Broadband Data By Town - 2024
State of Connecticut
@usgov.state_of_connecticut_broadband_data_by_town_2024
State of Connecticut
@usgov.state_of_connecticut_broadband_data_by_town_2024
CREATE TABLE table_1 (
"objectid_1" BIGINT,
"municipality" VARCHAR,
"councilsofgovernments" VARCHAR,
"county" VARCHAR,
"planningregion" VARCHAR,
"statefips" BIGINT,
"councilsofgovernmentsfips" BIGINT,
"municipalityfips" BIGINT,
"municipalityfips_geoid" BIGINT,
"total_bsls" BIGINT,
"unserved_count" BIGINT,
"underserved_count" BIGINT,
"served_count" BIGINT,
"state_goal_count" BIGINT,
"providers" VARCHAR,
"p_100_20_provs" VARCHAR,
"p_1gb_100_provs" VARCHAR,
"gigabit_count" BIGINT,
"technology_summary" VARCHAR,
"technologies" VARCHAR,
"max_download" BIGINT,
"max_upload" BIGINT,
"avg_download" DOUBLE,
"avg_upload" DOUBLE,
"total_connections" BIGINT,
"consumer_connections" BIGINT,
"max_advertised_download_speed" BIGINT,
"max_advertised_upload_speed" BIGINT,
"min_advertised_download_speed" DOUBLE,
"min_advertised_upload_speed" DOUBLE,
"avg_down" DOUBLE,
"avg_up" DOUBLE,
"unserved_sub" BIGINT,
"underserved_sub" BIGINT,
"served_sub" BIGINT,
"gigc_sub" BIGINT,
"providers_summary" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.