From a 500-row sample across 10 columns.
dbatotal_dispatched_tripsbase_name| base_number | wave_number | base_name | dba | years | week_number | pickup_start_date | pickup_end_date | total_dispatched_trips | unique_dispatched_vehicle |
|---|---|---|---|---|---|---|---|---|---|
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2015 | 40 | 2015-09-27T00:00:00.000 | 2015-10-03T00:00:00.000 | 19 | 6 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
base_number | text | The TLC license number of the dispatching base | 0% | B02765B02764B00381 |
wave_number | categorical | "The wave assigned to each base, determining when first submission of trip records began. The date after which trips must be submitted is as follows for each wave: Wave 1: Required for all trips beginning 1/1/15 Wave 2: Required for all trips beginning 3/1/15 Wave 3: Required for all trips beginning 4/1/15 Wave 4: Required for all trips beginning 4/1/15, or all trips after the base begins dispatching, whichever is latest." | 0% | 321of 4 |
base_name | text | The official name of the base entity | 0% | SEAGULL RIDE CORPTREMONT DISPATCHING CORPGREAT EXPRESS CAR & LIMO… |
dba | text |
GET /api/datasets/2bmr-jdsv GET /api/datasets/2bmr-jdsv/quality GET /api/datasets/2bmr-jdsv/related GET /api/columns?dataset=2bmr-jdsv
| 2015 |
| 41 |
| 2015-10-04T00:00:00.000 |
| 2015-10-10T00:00:00.000 |
| 58 |
| 8 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2015 | 42 | 2015-10-11T00:00:00.000 | 2015-10-17T00:00:00.000 | 88 | 8 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2015 | 43 | 2015-10-18T00:00:00.000 | 2015-10-24T00:00:00.000 | 105 | 7 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2015 | 44 | 2015-10-25T00:00:00.000 | 2015-10-31T00:00:00.000 | 170 | 10 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2016 | 20 | 2016-05-08T00:00:00.000 | 2016-05-14T00:00:00.000 | 43 | 3 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2016 | 21 | 2016-05-15T00:00:00.000 | 2016-05-21T00:00:00.000 | 53 | 3 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2016 | 22 | 2016-05-22T00:00:00.000 | 2016-05-28T00:00:00.000 | 58 | 3 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2016 | 23 | 2016-05-29T00:00:00.000 | 2016-06-04T00:00:00.000 | 70 | 3 |
| B02756 | 3 | ALLY CAR SERVICE LLC | ACTIVE EXPRESS CAR & LIMO 2 | 2016 | 24 | 2016-06-05T00:00:00.000 | 2016-06-11T00:00:00.000 | 43 | 3 |
| The official name of the base entity The “doing business as” name of the base |
| 76% |
FOUR ONES CAR SERVICEELEGANTEJUNO |
years | categorical | The number of the year | 0% | 201720162018of 4 |
week_number | integer | The number of the week in a given year | 0% | 232218 |
pickup_start_date | datetime | The start date of the reporting week | 0% | 2017-11-26T00:00:00.0002018-01-28T00:00:00.0002018-02-25T00:00:00.000 |
pickup_end_date | datetime | The end date of the reporting week | 0% | 2017-12-02T00:00:00.0002018-02-03T00:00:00.0002018-03-03T00:00:00.000 |
total_dispatched_trips | integer | The total number of dispatched trips performed in the week, to both affiliated and non‐affiliated vehicles* | 0% | 756 |
unique_dispatched_vehicle | integer | "The unique number of vehicles the base dispatches to in the week, including both affiliated and non‐affiliated vehicles*" | 0% | 657 |