About this Dataset

Broadband Adoption Basic Indicators

Key indicators of broadband adoption, service and infrastructure in New York City by NTA.
Organization: City of New York
Last updated: 2020-11-10T17:01:05.023619
Tags: access, broadband, broadband-adoption, cable, city-assets, city-buildings, connectivity, digital-divide, digital-equity, digital-inclusion, infrastructure, internet, internet-master-plan, internet-service-provider, internet-speed, mobile, mobile-broadband, mobile-broadband-adoption, mobile-telecommunications, neighborhood-tabulation-area, network, nta, planning, pole, pole-attachments, poles, poletop, public-wi-fi, street-furniture, telecommunications, wi-fi

Tables

Table 1

@usgov.city_of_new_york_broadband_adoption_basic_indicators.table_1

38.8 kB
195 rows
25 columns

CREATE TABLE table_1 (
  "neighborhood_tabulation_area_code_nta_code" VARCHAR  -- Neighborhood Tabulation Area Code (NTA Code),
  "neighborhood_tabulation_area_name_nta_name" VARCHAR  -- Neighborhood Tabulation Area Name (NTA NAME),
  "borough_name" VARCHAR,
  "total_population" BIGINT,
  "total_number_of_households" BIGINT,
  "home_broadband_adoption_percentage_of_households" DOUBLE  -- Home Broadband Adoption (Percentage Of Households),
  "home_broadband_adoption_by_quartiles_high_connected_me_8a8ba80d" VARCHAR  -- Home Broadband Adoption By Quartiles (High Connected, Medium High Connected, Medium Low Connected, Low Connected),
  "mobile_broadband_adoption_percentage_of_households" DOUBLE  -- Mobile Broadband Adoption (Percentage Of Households),
  "mobile_broadband_adoption_by_quartiles_high_connected__09bba638" VARCHAR  -- Mobile Broadband Adoption By Quartiles (High Connected, Medium High Connected, Medium Low Connected, Low Connected),
  "no_broadband_percentage_of_households" DOUBLE  -- No Broadband (Percentage Of Households),
  "no_broadand_by_quartiles_high_medium_high_medium_low_low" VARCHAR  -- No Broadand By Quartiles (High, Medium High, Medium Low, Low),
  "commercial_fiber_max_isp_choice_by_nta" BIGINT,
  "percentage_of_blocks_without_a_commercial_fiber_provider" DOUBLE,
  "percentage_of_blocks_without_a_commercial_fiber_provid_b397c7fb" VARCHAR  -- Percentage Of Blocks Without A Commercial Fiber Provider By Quartiles,
  "residential_broadband_isp_choice_average_by_nta" DOUBLE,
  "residential_broadband_isp_choice_average_by_quartiles" VARCHAR,
  "total_poles" BIGINT,
  "reserved_poles" BIGINT,
  "density_of_poles_reserved_and_with_equipment_installed_cac719a9" DOUBLE  -- Density Of Poles Reserved And With Equipment Installed For Mobile Telecom Franchise,
  "public_wi_fi_in_nyc_count" BIGINT,
  "number_of_free_public_wi_fi_access_points_in_a_pedestr_3c46f68e" BIGINT  -- Number Of Free Public Wi-Fi Access Points In A Pedestrian Corridor,
  "available_free_public_wi_fi_in_a_pedestrian_corridor_y_n" BOOLEAN  -- Available Free Public Wi-Fi In A Pedestrian Corridor (Y/N),
  "number_of_public_computer_centers_with_free_public_wi_fi" BIGINT,
  "number_of_public_computer_center_workstations" BIGINT,
  "number_of_public_computer_center_open_lab_hours" VARCHAR
);