From a 500-row sample across 22 columns.
inspectionidcsnumber| inspectionid | csnumber | mw | ovcond | isclosed | isofficially | handdryersam | changingtablesam | mirrorsam | urinalsam | urinalscomm | toiletsam |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 32524 | 1 | M1 | A | 0 | 0 | 0 | 0 | 0 | 1 | Stainless Steel | 1 |
| 32524 | 1 | W1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
inspectionid | integer | Unique inspection identification number | 0% | 19223398993150054 |
csnumber | categorical | Restroom Number | 0% | 123of 3 |
mw | categorical | Gender of Restroom | 0% | W1M1W2of 6 |
ovcond | categorical | Overall condition rating for restroom individual room | 0% | ANUof 4 |
isclosed |
GET /api/datasets/yp6n-7jdy GET /api/datasets/yp6n-7jdy/quality GET /api/datasets/yp6n-7jdy/related GET /api/columns?dataset=yp6n-7jdy
| A |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 |
| — |
| — |
| 1 |
| 32556 | 1 | M1 | U | 1 | 1 | 0 | 0 | 0 | — | — | — |
| 32556 | 1 | W1 | U | 1 | 1 | 0 | 0 | 0 | — | — | — |
| 32585 | 1 | M1 | N | 1 | 1 | 0 | 0 | 0 | — | — | — |
| 32585 | 1 | W1 | N | 1 | 1 | 0 | 0 | 0 | — | — | — |
| 32610 | 1 | M1 | N | 1 | 1 | 0 | 0 | 0 | — | — | — |
| 32610 | 1 | W1 | U | 0 | 0 | 0 | 0 | 0 | — | — | 1 |
| 32624 | 1 | M1 | A | 0 | 0 | 1 | 0 | 0 | 1 | Porcelain | 1 |
| 32624 | 1 | W1 | A | 0 | 0 | 1 | 0 | 0 | — | — | 2 |
Showing 12 of 22 columns. All of them are listed below.
| categorical |
| Indicates if restroom individual room was closed at time of inspection |
| 0% |
01of 2 |
isofficially | categorical | Indicates if restroom individual room was officially listed as closed at time of inspection | 0% | 01of 2 |
handdryersam | categorical | Number of hand dryers present at time of inspection | 4% | 102of 9 |
changingtablesam | categorical | Number of changing tables present at time of inspection | 5% | 012of 3 |
mirrorsam | categorical | Number of mirrors present at time of inspection | 5% | 012of 15 |
urinalsam | categorical | Number of urinals present at time of inspection | 56% | 123of 19 |
urinalscomm | categorical | Comments related to urinal amenities | 59% | PorcelainStainless SteelOtherof 9 |
toiletsam | text | Number of toilets present at time of inspection | 13% | 123 |
toiletscomm | categorical | Comments related to toilet amenities | 13% | PorcelainStainless SteelStainless Steel & Porcel…of 12 |
sinksam | categorical | Number of sinks present at time of inspection | 13% | 123of 16 |
sinkscomm | categorical | Comments related to sink amenities | 13% | PorcelainStainless SteelOtherof 11 |
toiletpaperdispam | text | Toilet paper dispenser present at time of inspection | 13% | 123 |
toiletpaperdispcomm | text | Comments related to toilet paper dispenser amenities | 13% | Tamper Proof Stainless S…2-ply or moreMulti Roll - Enclosed St… |
soapdispam | categorical | Number of soap dispensers present at time of inspection | 13% | 123of 18 |
soapdispcomm | text | Comments related to soap dispenser amenities | 14% | Stainless SteelSoap GlobeOther |
papertoweldispam | categorical | Number of paper towel dispensers present at time of inspection | 18% | 012of 7 |
papertoweldispcomm | categorical | Comments related to paper towel dispenser amenities | 80% | Stainless SteelMetal-Painted WhiteOtherof 15 |
comm | text | Comments | 86% | Not rated due to patron …Mens CS not rated due to…closed |