(delete This Block Layer) 2024 Availability By Block (Unserved And Underserved Locations) by US Government | Demographics and Population Studies

About this Dataset

(delete This Block Layer) 2024 Availability By Block (Unserved And Underserved Locations)

Link to block layer: Connecticut Broadband Availability Data by Block 2024
Organization: State of Connecticut
Last updated: 2025-05-24T17:22:03.944102

Tables

Table 1

@usgov.state_of_connecticut_delete_this_block_layer_2024_avai_28ad7a4f.table_1

4.42 MB
48358 rows
36 columns


CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "statefp20" BIGINT,
  "countyfp20" BIGINT,
  "tractce20" BIGINT,
  "blockce20" BIGINT,
  "geoid20" BIGINT,
  "name20" VARCHAR,
  "mtfcc20" VARCHAR,
  "ur20" VARCHAR,
  "uace20" VARCHAR,
  "uatype20" VARCHAR,
  "funcstat20" VARCHAR,
  "aland20" BIGINT,
  "awater20" BIGINT,
  "intptlat20" DOUBLE,
  "intptlon20" DOUBLE,
  "block_geoid" DOUBLE,
  "total_bsls" DOUBLE,
  "unserved_count" DOUBLE,
  "perc_unserved" DOUBLE,
  "underserved_count" DOUBLE,
  "served_count" DOUBLE,
  "state_goal_count" DOUBLE,
  "perc_state_goal" DOUBLE,
  "gigabit_count" DOUBLE,
  "providers" VARCHAR,
  "p_100_20_provs" VARCHAR,
  "p_1gb_100_provs" VARCHAR,
  "technology_summary" VARCHAR,
  "max_download" DOUBLE,
  "max_upload" DOUBLE,
  "avg_download" DOUBLE,
  "avg_upload" DOUBLE,
  "objectid" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);