From a 500-row sample across 16 columns.
_4_option2_4_option4_3_option1+15location| siteid | inspectionid | inpectiondate | location | question1 | question2 | question3 | question4 | question6 | question8 | _2_option5 | _2_multipleinstances |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7432.04 | 101536 | 2020-01-08T11:27:16.000Z | West 90th Street and Amsterdam Avenue | Yes | Yes | Yes | Yes | 0 | No | — | — |
| 5489.03 | 86743 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
siteid | coordinate | — | 0% | 6948.115365.025755.01 |
inspectionid | integer | — | 0% | 720383950081605 |
inpectiondate | datetime | — | 0% | 2016-01-06T09:22:10.000Z2019-10-30T14:47:47.000Z2016-08-03T11:33:44.000Z |
location | text | — | 0% | Columbia Street and Rivi…Broadway and West 60th S…University Place and Eas… |
GET /api/datasets/5uei-swth GET /api/datasets/5uei-swth/quality GET /api/datasets/5uei-swth/related GET /api/columns?dataset=5uei-swth
| 2019-07-30T11:56:21.000Z |
| Kent Avenue and North 9th Street |
| Yes |
| Yes |
| Yes |
| Yes |
| 0 |
| No |
| — |
| — |
| 6575.06 | 74497 | 2018-09-11T12:08:30.000Z | East 52nd Street and Second Avenue | Yes | Yes | Yes | Yes | 0 | No | — | — |
| 6865.03 | 78254 | 2018-12-13T12:42:50.000Z | 21st Street and 31st Drive | Yes | Yes | Yes | Yes | 0 | No | — | — |
| 6551.03 | 86388 | 2019-07-18T13:45:34.000Z | East 43rd Street and Fifth Avenue | No | Yes | Yes | Yes | — | No | — | — |
| 3776.05 | 84860 | 2019-06-03T13:52:14.000Z | Montgomery Street and Franklin Avenue | No | Yes | Yes | Yes | — | No | — | — |
| 4637.06 | 83529 | 2019-05-01T13:40:30.000Z | Fulton Street and Adams Street | Yes | Yes | Yes | Yes | 0 | No | — | — |
| 5098.10 | 101796 | 2020-01-15T12:12:42.000Z | Peck Slip and Front Street | Yes | Yes | Yes | Yes | 0 | No | — | — |
| 5616.01 | 72820 | 2018-07-31T11:41:36.000Z | East 9th Street and Avenue C | No | No | Yes | Yes | — | No | Yes | No |
| 6115.09 | 81731 | 2019-03-14T13:22:49.000Z | West 15th Street and Tenth Avenue | No | Yes | Yes | Yes | — | No | — | — |
Showing 12 of 13 columns. All of them are listed below.
question1 | categorical | — | 0% | YesNoof 2 |
question2 | categorical | — | 0% | YesNoof 2 |
_2_option1 | text | — | 95% | Yesof 1 |
_2_option2 | text | — | 99% | Yesof 1 |
_2_option3 | text | — | 99% | Yesof 1 |
_2_option4 | text | — | 96% | Yesof 1 |
_2_option5 | text | — | 96% | Yesof 1 |
_2_option6 | text | — | 96% | Yesof 1 |
_2_ticketnumber | text | — | 100% | — |
_2_bikeidnumber | text | — | 100% | — |
_2_multipleinstances | categorical | — | 85% | NoYesof 2 |
_2_ticketcomments | text | — | 85% | Station needs a power wa…Last plate misalignedSeparation of last plate… |
question3 | categorical | — | 1% | YesNoof 2 |
_3_option1 | text | — | 100% | Yesof 1 |
_3_option2 | text | — | 100% | Yesof 1 |
_3_option3 | text | — | 99% | Yesof 1 |
_3_option4 | text | — | 100% | — |
_3_ticketnumber | text | — | 99% | 1-4846.01-02232015-42711…1-4846.01-03232015-41746…1-4846.01-07112013-42807… |
_3_ticketcomments | text | — | 99% | Slightly damaged but sti…Kiosk not responding aft…Screen is cracked |
question4 | categorical | — | 3% | YesNoof 2 |
_4_option1 | text | — | 99% | Yesof 1 |
_4_option2 | text | — | 100% | Yesof 1 |
_4_option3 | text | — | 100% | Yesof 1 |
_4_option4 | text | — | 99% | Yesof 1 |
_4_ticketnumber | text | — | 98% | 1-6039.06-08012014-48666…1-5238.04-09242014-34496…3-4637.02-06062014-56396… |
_4_ticketcomments | text | — | 99% | Did not dispense receipt…Not printing receiptsDid not read key fob |
question5 | categorical | — | 98% | NoYesof 2 |
question6 | integer | — | 26% | 012 |
question7 | categorical | — | 100% | NoYesof 2 |
question8 | categorical | — | 1% | NoYesof 2 |
_8_option1 | text | — | 97% | Yesof 1 |
_8_option2 | text | — | 100% | Yesof 1 |
_8_option3 | text | — | 82% | Yesof 1 |
_8_ticketnumber | text | — | 81% | 1-5922.08-07112013-55810…1-6055.08-12022013-60657…1-6441.02-12302014-43685… |
_8_bikeidnumber | text | — | 81% | 073590559604948 |
_8_ticketcomments | text | — | 81% | Bike damage is unknownUnknown - locked down.Unknown |
question9 | integer | — | 78% | 99901 |
question10 | integer | — | 78% | 9992322 |