block_group


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
bgid VARCHAR 50 √ null
state VARCHAR 50 √ null
state_abbr VARCHAR 50 √ null
county_fips INT 10 √ null
county_name VARCHAR 50 √ null
county_state VARCHAR 50 √ null
dma_id INT 10 √ null
dma_name VARCHAR 56 √ null
cbsa_id VARCHAR 50 √ null
t_dma.ID Implied Constraint R
cbsa_name VARCHAR 55 √ null
cbsa_id_contiguous INT 10 √ null
cbsa_name_contiguous VARCHAR 55 √ null
market_type_id INT 10 √ null
market_type VARCHAR 50 √ null
market_type_name VARCHAR 65 √ null
markettype_detailed VARCHAR 50 √ null
density_class VARCHAR 50 √ null
experience_org1 VARCHAR 50 √ null
experience_org2 VARCHAR 50 √ null
experience_org3 VARCHAR 54 √ null
neighborhood_org1 VARCHAR 50 √ null
neighborhood_org2 VARCHAR 56 √ null
neighborhood_smra_org1 VARCHAR 50 √ null
neighborhood_smra_org2 VARCHAR 56 √ null
neighborhood_smra_org3 VARCHAR 50 √ null
neighborhood_smra_org4 VARCHAR 56 √ null
store_in_store_org1 VARCHAR 50 √ null
store_in_store_org2 VARCHAR 54 √ null
store_in_store_org3 VARCHAR 60 √ null
express_org1 VARCHAR 50 √ null
express_org2 VARCHAR 50 √ null
express_org3 VARCHAR 52 √ null
experience_area VARCHAR 50 √ null
popcy INT 10 √ null
pop5y INT 10 √ null
hhcy INT 10 √ null
hh5y INT 10 √ null
latitude DECIMAL 28,10 √ null
longitude DECIMAL 28,10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation