From a 439-row sample across 12 columns.
statecityapplicant_name+1record_categorystatecity+2statecityHas zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.
| waitlist_application_id | record_category | applicant_name | waitlist_status | general_vendor_license_number | general_vendor_license_status | general_vendor_license_type | city | state | zip_code | blue_waitlist_number | selection_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10053-2018-SMGV | Blue Waitlist | DAVID H MARTINEZ | Closed | 2064005-DCA | Inactive | Citywide Specialized Vendor (Yellow) | QUEENS VILLAGE | NY | 114291437 | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
waitlist_application_id | text | An identification number assigned by DCWP for internal tracking purposes | 0% | 13745-2018-SMGV53-2013-SMGV138-2012-SMGV |
record_category | text | The type of record created in the system. | 0% | Blue Waitlistof 1 |
applicant_name | text | The name of the Blue General Vendor Waiting List applicant | 0% | DENISE R THOMASRICHARD JR. WEBBDAVID H MARTINEZ |
blue_waitlist_number | integer | Indicates the applicant's position on the waiting list | 1% |
GET /api/datasets/r9ax-4va4 GET /api/datasets/r9ax-4va4/quality GET /api/datasets/r9ax-4va4/related GET /api/columns?dataset=r9ax-4va4
citystatecity| — |
| 10-2012-SMGV | Blue Waitlist | LEON PEARSON JR | Selected from Waitlist | 1163299-DCA | Inactive | Midtown Specialized Vendor (Blue) | BRONX | NY | 104610209 | 143 | 2017-02-02T00:00:00.000 |
| 10-2013-SMGV | Blue Waitlist | RUFUS G KING | Closed | 1001227-DCA | Inactive | Citywide Specialized Vendor (Yellow) | BROOKLYN | NY | 11213 | 580 | — |
| 1021-2019-SMGV | Blue Waitlist | GAVIN ATKINSON | Closed | 2081841-DCA | Inactive | Citywide Specialized Vendor (Yellow) | BRONX | NY | 104682141 | 1230 | — |
| 102-2012-SMGV | Blue Waitlist | THOMAS J. LIQUORI | Selected from Waitlist | 1216706-DCA | Active | Midtown Specialized Vendor (Blue) | FLUSHING | NY | 113651807 | 240 | 2022-10-08T00:00:00.000 |
| 104-2012-SMGV | Blue Waitlist | ARDES V ARMSTRONG | Pending - Blue Waitlist | 1402308-DCA | Active | Citywide Specialized Vendor (Yellow) | BROOKLYN | NY | 112078850 | 541 | — |
| 105-2012-SMGV | Blue Waitlist | CLARENCE E NELSON | Closed | 1125168-DCA | Inactive | Citywide Specialized Vendor (Yellow) | JAMAICA | NY | 114354934 | 146 | — |
| 106-2012-SMGV | Blue Waitlist | JEFFERY A ANTOINE | Selected from Waitlist | 1147601-DCA | Active | Midtown Specialized Vendor (Blue) | BROOKLYN | NY | 112360474 | 97 | 2016-07-01T00:00:00.000 |
| 10700-2019-SMGV | Blue Waitlist | Rudolph Murray | Closed | 2090387-DCA | Inactive | Citywide Specialized Vendor (Yellow) | YONKERS | NY | 107103623 | 1318 | — |
| 10703-2018-SMGV | Blue Waitlist | SUMEDH KAURA | Closed | 2071858-DCA | Inactive | Citywide Specialized Vendor (Yellow) | FLORAL PARK | NY | 110011006 | 1128 | — |
1111139476waitlist_status | categorical | Indicates the current status of the applicant on the waiting List | 0% | ClosedPending - Blue WaitlistSelected from Waitlistof 3 |
selection_date | datetime | The date a licensed general vendor was selected from the waitlist. | 90% | 2016-07-01T00:00:00.0002022-08-12T00:00:00.0002022-08-16T00:00:00.000of 19 |
general_vendor_license_number | text | General Vendor license number that the applicant had prior to applying for the Blue Waiting List | 0% | 2064005-DCA2075947-DCA1350009-DCA |
general_vendor_license_status | categorical | Current status of the General Vendor License | 0% | InactiveActiveof 2 |
general_vendor_license_type | categorical | Type of general vendor license the applicant was issued in order to apply for the Blue Waiting List | 0% | Citywide Specialized Ven…Midtown Specialized Vend…General Vendor (White)of 3 |
city | text | The City of the applicant's mailing address | 10% | BROOKLYNBRONXNEW YORK |
state | categorical | The State of the applicant's mailing address | 10% | NYNJof 2 |
zip_code | text | ZIP or Postal Code of the applicant's mailing address | 10% | 11101451810467116912015 |