About this Dataset

Pedicab Registration Plate Lottery Applications

Pedicabs may not operate in New York City without a DCWP-issued pedicab registration plate. By law, the City can only issue new pedicab registration plates when the number of registered pedicabs falls below 840. Every year, DCWP solicits applications to enter a lottery for any pedicab registration plates available, up to the statutory limit of 850.

In each lottery cycle, applications are assigned an application order number based on when they are submitted. Applications that qualify for the lottery are randomly assigned a ""Pedicab Lottery Priority Number"". Qualified applications are selected from the lottery in priority number order until the number of available plates have been awarded.
Organization: City of New York
Last updated: 2023-08-19T02:23:45.242668
Tags: application, license, lottery, pedicab, pedicab-business, random, registration-plate, selection

Tables

Table 1

@usgov.city_of_new_york_pedicab_registration_plate_lottery_ap_b4184c9a.table_1

85.42 kB
2,375 rows
19 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "record_category" VARCHAR,
  "industry" VARCHAR,
  "application_submission_date" TIMESTAMP,
  "applicant_name" VARCHAR,
  "does_the_organization_currently_hold_an_active_pedicab_2d5fba2b" VARCHAR  -- Does The Organization Currently Hold An Active Pedicab Business License,
  "license_number" VARCHAR,
  "total_number_of_registered_pedicab_vehicles" DOUBLE,
  "desired_number_of_pedicab_units" DOUBLE,
  "pedicab_lottery_application_order_number" DOUBLE,
  "pedicab_lottery_priority_number" DOUBLE,
  "lottery_selection_date" TIMESTAMP,
  "selected_from_lottery" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "borough" VARCHAR,
  "community_district" DOUBLE,
  "council_district" DOUBLE
);