From a 500-row sample across 10 columns.
citystateselection_date+1citystate| waiting_list_application | application_order_number | priority_number | applicant_name | city | state | postcode | waiting_list_status | selection_date | license_application_id |
|---|---|---|---|---|---|---|---|---|---|
| 14302-2016-AGVW | 1 | 11188 | SAMBA SANAHO | BRONX | NY | 10453 | Awaiting Waitlist Selection | — | — |
| 14303-2016-AGVW | 2 | 6798 | KEITH RICKARD |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
waiting_list_application | text | An identification number assigned by DCA to track applications for the General Vendor Waiting List | 0% | 20501-2016-AGVW25352-2016-AGVW24684-2016-AGVW |
application_order_number | integer | The sequential order number that the application for the General Vendor Waiting List was received by DCA | 0% | 47731005110454 |
priority_number | integer | Random number assigned to valid applications indicating the applicant's position on the waiting list | 2% | 47731005110454 |
applicant_name | text | The name of the General Vendor Waiting List applicant | 0% |
GET /api/datasets/6y5g-5hkj GET /api/datasets/6y5g-5hkj/quality GET /api/datasets/6y5g-5hkj/related GET /api/columns?dataset=6y5g-5hkj
citystatepostcode| NEW YORK |
| NY |
| 10038 |
| Awaiting Waitlist Selection |
| — |
| — |
| 14304-2016-AGVW | 3 | 7711 | HAMDI YUKSEL | BROOKLYN | NY | 11229 | Awaiting Waitlist Selection | — | — |
| 14305-2016-AGVW | 4 | 4662 | MUSTAFA KARGACI | BROOKLYN | NY | 11235 | Awaiting Waitlist Selection | — | — |
| 14306-2016-AGVW | 5 | 7058 | AWA NGAM | BROOKLYN | NY | 11221 | Awaiting Waitlist Selection | — | — |
| 14307-2016-AGVW | 6 | 3617 | FRANCISCO COTTO | SOUTH OZONE PARK | NY | 11420 | Awaiting Waitlist Selection | — | — |
| 14308-2016-AGVW | 7 | 1474 | NIANGUIRY DIARRA | BRONX | NY | 10460 | Awaiting Waitlist Selection | — | — |
| 14309-2016-AGVW | 8 | 899 | MARTA JULIA CAMPOS | EAST ELMHURST | NY | 11369 | Selected from Waitlist | 2023-07-12T00:00:00.000 | — |
| 14310-2016-AGVW | 9 | 289 | NDEYE DIENE | BRONX | NY | 10459 | Applied for License | 2019-01-28T00:00:00.000 | 2241-2019-AGEV |
| 14311-2016-AGVW | 10 | 3302 | VIVIEN GRULLON | ELMHURST | NY | 11373 | Awaiting Waitlist Selection | — | — |
MAMADOU DIALLOIBRAHIMA DIALLOMAMADOU BARRY |
city | text | The City of the applicant's mailing address | 0% | BROOKLYNBRONXNEW YORK |
state | categorical | The State of the applicant's mailing address | 0% | NYNJRIof 10 |
postcode | text | ZIP or Postal Code of the applicant's mailing address | 0% | 104561122011355 |
waiting_list_status | categorical | Indicates the current status of the applicant on the waiting List | 0% | Awaiting Waitlist Select…Did Not AppearApplied for Licenseof 7 |
selection_date | datetime | Date the applicant was selected from the Waiting List. | 92% | 2022-05-23T00:00:00.0002023-04-13T00:00:00.0002023-07-12T00:00:00.000 |
license_application_id | text | The Record ID number assigned to the application for a general vendor license. | 98% | 10102-2019-AGEV10107-2017-AGEV10132-2019-AGEV |