From a 500-row sample across 11 columns.
statezip_codecity+7statecityborough+1statecityapplicant_namestatecityborough+1Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| record_id | record_category | industry | application_submission_date | applicant_name | city | state | zip_code | borough | community_district | council_district |
|---|---|---|---|---|---|---|---|---|---|---|
| 1452798-PDCL | Lottery Application | Pedicab Business | 2012-12-26T00:00:00.000 | BEDFORD, ANDREA | VALLEY STREAM | NY | 11580 | Outside NYC | — | — |
| 1453852-PDCL | Lottery Application |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
record_id | text | A system generated number used to track the record through DCWP systems | 0% | 1454063-PDCL1453852-PDCL1457039-PDCL |
record_category | text | The type of record created in the system | 0% | Lottery Applicationof 1 |
industry | text | The type of business requesting the application | 0% | Pedicab Businessof 1 |
application_submission_date | datetime | The date the lottery application was submitted | 0% | 2013-02-13T00:00:00.0002013-02-20T00:00:00.000 |
GET /api/datasets/ayx3-dixq GET /api/datasets/ayx3-dixq/quality GET /api/datasets/ayx3-dixq/related GET /api/columns?dataset=ayx3-dixq
statecitycommunity_districtindustrystatecityindustry+2| Pedicab Business |
| 2013-01-15T00:00:00.000 |
| SONGURALP, ABDULKADIR |
| BROOKLYN |
| NY |
| 11204 |
| Brooklyn |
| 311 |
| 43 |
| 1453853-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | BAGIRGAN, FATIH | BROOKLYN | NY | 11209 | Brooklyn | 310 | 43 |
| 1453854-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | KAPLAN, EMRAH | BROOKLYN | NY | 11209 | Brooklyn | 310 | 43 |
| 1453857-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | KLAEBOE, GREGORY J. | NEW YORK | NY | 10032 | Manhattan | 112 | 10 |
| 1453861-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | GILL, SEAN | BROOKLYN | NY | 11201 | Brooklyn | 302 | 35 |
| 1453863-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | MIKHAYLOV, ALEXANDER | BROOKLYN | NY | 11204 | Brooklyn | 311 | 44 |
| 1453866-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | STIKHINA, NATALYA | BROOKLYN | NY | 11235 | Brooklyn | 315 | 48 |
| 1453868-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | DAVID & CO | NEW YORK | NY | 10044 | Manhattan | 108 | 5 |
| 1453888-PDCL | Lottery Application | Pedicab Business | 2013-01-15T00:00:00.000 | LEBZABRE, EMMANUEL | BRONX | NY | 10451 | Bronx | 204 | 17 |
2013-02-14T00:00:00.000applicant_name | text | The name of the individual or business applying for the lottery | 0% | BURTON, GARTHOCHILOV, SIYOVUSHKAYMAZ, OKAN |
does_the_organization | categorical | Yes/No field asking applicants if they already have an active Pedicab Business license | 63% | NoYesof 2 |
license_number | text | The license number if the applicant has an active license | 96% | 1385264-DCA1336845-DCA2082095-DCA |
total_number_of_registered | categorical | The current number of pedicabs registered to the applicant's license | 63% | 012of 19 |
desired_number_of_pedicab | text | The number of pedicabs the applicant is seeking through the lottery | 63% | 1of 1 |
pedicab_lottery_application | text | The sequential order in which the application was received. | 63% | 1239 |
pedicab_lottery_priority | text | The randomly assigned number that determines the applicant's selection order. | 71% | 541 |
lottery_selection_date | datetime | The date the applicant's selection or non-selection was determined | 64% | 2023-03-15T00:00:00.0002015-05-12T00:00:00.0002022-01-05T00:00:00.000of 9 |
selected_from_lottery | categorical | Yes/No field showing whether the applicant was selected from the lottery | 64% | YesNoof 2 |
city | text | The city of the applicant's primary address | 0% | BROOKLYNNEW YORKBRONX |
state | categorical | The state of the applicant's primary address | 0% | NYNJMAof 18 |
zip_code | text | The ZIP or postal code of the applicant's primary address | 0% | 112351122911377 |
borough | categorical | The Borough of the applicant's primary address | 3% | BrooklynQueensManhattanof 6 |
community_district | integer | The Community District of the applicant's primary address | 19% | 315311401 |
council_district | integer | The NYC Council District of the applicant's primary address | 19% | 482622 |