Census Block Groups In 2000
District of Columbia
@usgov.district_of_columbia_census_block_groups_in_2000
District of Columbia
@usgov.district_of_columbia_census_block_groups_in_2000
CREATE TABLE table_1 (
"objectid" BIGINT,
"cjrtractbg" VARCHAR,
"cnt_cjrtra" BIGINT,
"state_fips" BIGINT,
"cnty_fips" BIGINT,
"stcofips" BIGINT,
"tract" BIGINT,
"blkgrp" BIGINT,
"fips" BIGINT,
"pop2000" BIGINT,
"pop2004" BIGINT,
"pop00_sqmi" DOUBLE,
"pop04_sqmi" DOUBLE,
"white" BIGINT,
"black" BIGINT,
"ameri_es" BIGINT,
"asian" BIGINT,
"hawn_pi" BIGINT,
"other" BIGINT,
"mult_race" BIGINT,
"hispanic" BIGINT,
"males" BIGINT,
"females" BIGINT,
"age_under5" BIGINT,
"age_5_17" BIGINT,
"age_18_21" BIGINT,
"age_22_29" BIGINT,
"age_30_39" BIGINT,
"age_40_49" BIGINT,
"age_50_64" BIGINT,
"age_65_up" BIGINT,
"med_age" DOUBLE,
"med_age_m" DOUBLE,
"med_age_f" DOUBLE,
"households" BIGINT,
"ave_hh_sz" DOUBLE,
"hsehld_1_m" BIGINT,
"hsehld_1_f" BIGINT,
"marhh_chd" BIGINT,
"marhh_no_c" BIGINT,
"mhh_child" BIGINT,
"fhh_child" BIGINT,
"families" BIGINT,
"ave_fam_sz" DOUBLE,
"hse_units" BIGINT,
"vacant" BIGINT,
"owner_occ" BIGINT,
"renter_occ" BIGINT,
"sqmi" DOUBLE,
"gis_id" VARCHAR,
"shapearea" BIGINT,
"shapelen" BIGINT
);
Anyone who has the link will be able to view this.