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

37.89 KB
195 rows
25 columns


CREATE TABLE table_1 (
  "neighborhood_tabulation_area_code_nta_code" VARCHAR,
  "neighborhood_tabulation_area_name_nta_name" VARCHAR,
  "borough_name" VARCHAR,
  "total_population" BIGINT,
  "total_number_of_households" BIGINT,
  "home_broadband_adoption_percentage_of_households" DOUBLE,
  "home_broadband_adoption_by_quartiles_high_connected_me_8a8ba80d" VARCHAR,
  "mobile_broadband_adoption_percentage_of_households" DOUBLE,
  "mobile_broadband_adoption_by_quartiles_high_connected__09bba638" VARCHAR,
  "no_broadband_percentage_of_households" DOUBLE,
  "no_broadand_by_quartiles_high_medium_high_medium_low_low" VARCHAR,
  "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,
  "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,
  "public_wi_fi_in_nyc_count" BIGINT,
  "number_of_free_public_wi_fi_access_points_in_a_pedestr_3c46f68e" BIGINT,
  "available_free_public_wi_fi_in_a_pedestrian_corridor_y_n" BOOLEAN,
  "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
);