From a 500-row sample across 19 columns.
namelicense_numbervehicle_vin_number+4namelicense_numbervehicle_vin_number+2namelicense_numberbase_namenamebase_telephone_number+9| active | license_number | name | license_type | license_status | dmv_license_plate_number | vehicle_vin_number | certification_date | hack_up_date | vehicle_year | base_number | base_name |
|---|---|---|---|---|---|---|---|---|---|---|---|
| YES | AA139 | MIAH,MUJTABA | 2028-06-28T00:00:00.000 | 6131567 | T147458C | JTMDJREV5HD100798 | 01/30/2026 | 01/30/2020 | 2017 | B03036 | ZYNC INC |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
active | categorical | Permit active or not | 0% | YESNOof 2 |
license_number | text | Permit License Number | 0% | AE070AB942AE022 |
name | text | Owner Name | 0% | SINGH,SATNAMRAHMAN,MOHAMMED,MSINGH,JASBIR |
license_type | datetime | Expiration Date | 0% | 2028-10-24T00:00:00.0002028-10-15T00:00:00.0002028-10-16T00:00:00.000 |
GET /api/datasets/yhuu-4pt3 GET /api/datasets/yhuu-4pt3/quality GET /api/datasets/yhuu-4pt3/related GET /api/columns?dataset=yhuu-4pt3
namelicense_numbernamelicense_numberbase_namenamelicense_number+2namelicense_number| YES |
| AA460 |
| SINGH,SATNAM |
| 2028-07-17T00:00:00.000 |
| 5111375 |
| T133167C |
| 5J6RS6H58TL011152 |
| 01/22/2026 |
| 01/30/2026 |
| 2026 |
| B02219 |
| ALL QUEENS CAR & LIMOUSINE INC. |
| YES | AF503 | SIDDIQUE,MOHAMMED | 2028-10-31T00:00:00.000 | 5481041 | T624997C | 2T3LWRFV8RW224001 | 06/04/2024 | 06/05/2024 | 2024 | B02772 | TAP & RIDE,INC. |
| YES | BB505 | MOUSSA,ELSAYED,MOHAMED | 2027-01-16T00:00:00.000 | 6035540 | T114761C | 5TDYK3DC8FS604954 | 07/10/2023 | 06/06/2023 | 2015 | B03152 | EXIT LUXURY INC. |
| NO | AB902 | HUSSAIN,IMRAN | 2028-08-20T00:00:00.000 | 5943879 | T108034C | 1FMCU4K32CKA52055 | 06/05/2019 | 06/18/2019 | 2012 | B01614 | — |
| NO | BC124 | GUL,AGHA,N | 2028-04-25T00:00:00.000 | 5963114 | T791514C | 4T1BB46K49U076552 | 03/19/2020 | 03/20/2020 | 2009 | B03036 | ZYNC INC |
| YES | AA056 | ROMERO,RAUL | 2028-06-21T00:00:00.000 | 5254432 | T133002C | 4T1T11BK3PU101370 | 02/13/2025 | 01/21/2015 | 2023 | B00647 | KISS CAR SERVICE INC |
| YES | AE254 | AKRAM,IMRAN | 2028-10-17T00:00:00.000 | 5991344 | T102963C | JTMZFREV2FJ058306 | 03/04/2022 | 03/04/2022 | 2015 | B01601 | YOURS CAR SERVICE INC |
| YES | BB550 | SANOGO,MAMADOU | 2027-01-21T00:00:00.000 | 5610172 | T671056C | KNDJ23AU5N7172380 | 03/28/2025 | 04/28/2015 | 2022 | B03407 | ZOOM TRANSIT INC |
| YES | AD850 | SINGH,DALVINDER | 2028-10-11T00:00:00.000 | 5325376 | T517535C | JTMRJREV7JD259589 | 08/17/2026 | 08/18/2026 | 2018 | B02772 | TAP & RIDE,INC. |
Showing 12 of 17 columns. All of them are listed below.
license_status |
| text |
| Vehicle License Number |
| 10% |
546578157872325945757 |
dmv_license_plate_number | text | DMV License Plate Number | 10% | T151932CT114898CT499727C |
vehicle_vin_number | text | Vehicle VIN Number | 10% | 2LNBL8CV0BX7639794T3MWRFV5MU0371174T3ZA3BB8BU054147 |
vehicle_type | text | Wheelchair Access Vehicle indicator | 97% | WAVof 1 |
certification_date | date | Certification Date | 10% | 07/09/202602/13/202504/04/2023 |
hack_up_date | date | Hack Up Date | 10% | 12/23/201301/08/201412/29/2023 |
vehicle_year | text | Vehicle Year | 10% | 201520182014 |
base_number | text | Base Number | 1% | B02932B03036B02902 |
base_name | text | Base Name | 2% | GRAND TRANSPORTATION SER…ZYNC INCNY CAR & LIMO SERVICES I… |
base_telephone_number | phone | Base Telephone Number | 2% | (718) 433-4255(718) 482-1818(718) 255-1798 |
base_website | categorical | Base Website | 63% | WWW.GRANDLIMONY.COMWWW.NYINSURANCEB.COMWWW.RIVERSIDECARLIMO.COMof 6 |
base_address | text | Base Address | 2% | 36-13 32 STREET LIC NY …12-04 44 AVENUE LIC NY …71-16 35 AVENUE JACKSON… |
suspension_reason | categorical | Reason Code A,B,C (inactive) or G (active) | 0% | GA-CAof 8 |
suspension_date | text | Suspension Date | 100% | — |
date_updated | datetime | Last Date Updated | 0% | 2026-10-12T00:00:00.000of 1 |
time_updated | text | Last Time Updated | 0% | 14:00of 1 |