Broadband Adoption And Infrastructure By State Assembly District
City of New York
@usgov.city_of_new_york_broadband_adoption_and_infrastructure_9521831d
City of New York
@usgov.city_of_new_york_broadband_adoption_and_infrastructure_9521831d
Key indicators of broadband adoption, service and infrastructure in New York City by State Senate District
Data Limitations: Data accuracy is limited as of the date of publication and by the methodology and accuracy of the original sources. The City shall not be liable for any costs related to, or in reliance of, the data contained in these datasets.
Organization: City of New York
Last updated: 2020-11-10T17:04:35.795742
Tags: access, broadband, broadband-adoption, cable, city-assets, city-buildings, connectivity, digital-divide, digital-equity, digital-inclusion, district, infrastructure, internet, internet-master-plan, internet-service-provider, internet-speed, mobile, mobile-broadband, mobile-broadband-adoption, mobile-telecommunications, network, planning, pole, pole-attachments, pole-top, poles, public-computer-center, public-wi-fi, senate, state-senate, street-furniture, telecommunications, wi-fi
CREATE TABLE table_1 (
"oid" BIGINT,
"state_senate_district" BIGINT,
"home_broadband_adoption_percentage_of_households" DOUBLE -- Home Broadband Adoption (Percentage Of Households),
"mobile_broadband_adoption_percentage_of_households" DOUBLE -- Mobile Broadband Adoption (Percentage Of Households),
"no_internet_access_percentage_of_households" DOUBLE -- No Internet Access (Percentage Of Households),
"no_home_broadband_adoption_percentage_of_households" DOUBLE -- No Home Broadband Adoption (Percentage Of Households),
"no_mobile_broadband_adoption_percentage_of_households" DOUBLE -- No Mobile Broadband Adoption (Percentage Of Households),
"no_home_broadband_adoption_by_quartile" VARCHAR,
"no_mobile_broadband_adoption_by_quartile" VARCHAR,
"commercial_fiber_max_isp_choice" BIGINT,
"public_computer_center_count" BIGINT,
"workstations_in_pccs" BIGINT,
"avg_training_hrs_per_week_in_pccs" DOUBLE,
"public_wi_fi_count" BIGINT,
"poles_reserved_by_mobile_telecom_franchisee" BIGINT,
"pole_with_equipment_installed_by_mobile_telecom_franchise" BIGINT,
"density_of_poles_reserved_and_with_equipment_installed_cac719a9" DOUBLE -- Density Of Poles Reserved And With Equipment Installed For Mobile Telecom Franchise
);Anyone who has the link will be able to view this.