CREATE TABLE CBSA
(
    CBSA      INTEGER
            primary key,
    CBSA_name TEXT,
    CBSA_type TEXT
);
CBSA
CREATE TABLE state
(
    abbreviation TEXT
            primary key,
    name         TEXT
);
state
CREATE TABLE congress
(
    cognress_rep_id TEXT
            primary key,
    first_name      TEXT,
    last_name       TEXT,
    CID             TEXT,
    party           TEXT,
    state           TEXT,
    abbreviation    TEXT,
    House           TEXT,
    District        INTEGER,
    land_area       REAL,
    foreign key (abbreviation) references state(abbreviation)
);
congress
CREATE TABLE zip_data
(
    zip_code                         INTEGER
            primary key,
    city                             TEXT,
    state                            TEXT,
    multi_county                     TEXT,
    type                             TEXT,
    organization                     TEXT,
    time_zone                        TEXT,
    daylight_savings                 TEXT,
    latitude                         REAL,
    longitude                        REAL,
    elevation                        INTEGER,
    state_fips                       INTEGER,
    county_fips                      INTEGER,
    region                           TEXT,
    division                         TEXT,
    population_2020                  INTEGER,
    population_2010                  INTEGER,
    households                       INTEGER,
    avg_house_value                  INTEGER,
    avg_income_per_household         INTEGER,
    persons_per_household            REAL,
    white_population                 INTEGER,
    black_population                 INTEGER,
    hispanic_population              INTEGER,
    asian_population                 INTEGER,
    american_indian_population       INTEGER,
    hawaiian_population              INTEGER,
    other_population                 INTEGER,
    male_population                  INTEGER,
    female_population                INTEGER,
    median_age                       REAL,
    male_median_age                  REAL,
    female_median_age                REAL,
    residential_mailboxes            INTEGER,
    business_mailboxes               INTEGER,
    total_delivery_receptacles       INTEGER,
    businesses                       INTEGER,
    "1st_quarter_payroll"            INTEGER,
    annual_payroll                   INTEGER,
    employees                        INTEGER,
    water_area                       REAL,
    land_area                        REAL,
    single_family_delivery_units     INTEGER,
    multi_family_delivery_units      INTEGER,
    total_beneficiaries              INTEGER,
    retired_workers                  INTEGER,
    disabled_workers                 INTEGER,
    parents_and_widowed              INTEGER,
    spouses                          INTEGER,
    children                         INTEGER,
    over_65                          INTEGER,
    monthly_benefits_all             INTEGER,
    monthly_benefits_retired_workers INTEGER,
    monthly_benefits_widowed         INTEGER,
    CBSA                             INTEGER,
    foreign key (state) references state(abbreviation),
    foreign key (CBSA) references CBSA(CBSA)
);
zip_data
CREATE TABLE alias
(
    zip_code INTEGER
            primary key,
    alias    TEXT,
    foreign key (zip_code) references zip_data(zip_code)
);
alias
CREATE TABLE area_code
(
    zip_code  INTEGER,
    area_code INTEGER,
    primary key (zip_code, area_code),
    foreign key (zip_code) references zip_data(zip_code)
);
area_code
CREATE TABLE avoid
(
    zip_code  INTEGER,
    bad_alias TEXT,
    primary key (zip_code, bad_alias),
    foreign key (zip_code) references zip_data(zip_code)
);
avoid
CREATE TABLE country
(
    zip_code INTEGER,
    county   TEXT,
    state    TEXT,
    primary key (zip_code, county),
    foreign key (zip_code) references zip_data(zip_code),
    foreign key (state) references state(abbreviation)
);
country
CREATE TABLE zip_congress
(
    zip_code INTEGER,
    district TEXT,
    primary key (zip_code, district),
    foreign key (district) references congress(cognress_rep_id),
    foreign key (zip_code) references zip_data(zip_code)
);
zip_congress
original_column_name,column_name,column_description,data_format,value_description
zip_code,zip code,the zip code of the district,integer,
district,,the district,text,
zip_congress
original_column_name,column_name,column_description,data_format,value_description
zip_code,zip code,the zip code of the bad alias,integer,
bad_alias,bad alias,the bad alias,text,
avoid
original_column_name,column_name,column_description,data_format,value_description
zip_code,zip code,the zip code of the area,integer,
area_code,area code,the code of the area,integer,
area_code
original_column_name,column_name,column_description,data_format,value_description
cognress_rep_id,congress representative id,the representative id of congress representatives,text,
first_name ,first name,the first name of the congress representative,text,
last_name,last name,the last name of the congress representative,text,
CID,,the unique identifier for the congress representative,text,
party,,the party of the representative,text,
state,,the state that the representative is from,text,
abbreviation,,the abbreviation of the state,text,
House,,the house that the representative is from,text,
District,,the id of the district that the representative represents ,integer,"commonsense evidence: The state is divided into different districts. The districts under the same state will be numbered uniformly. 
'NA' means that the state is not divided into districts. "
land_area,land area,the land area of the district,real,
congress
original_column_name,column_name,column_description,data_format,value_description
zip_code,zip code,the zip code of the alias,integer,
alias,,the alias of the city,text,
alias
original_column_name,column_name,column_description,data_format,value_description
zip_code,zip code,the zip code of the postal point,integer,
city,,the city where the postal point locates,text,
state,,the state of the city,text,
multi_county,multi country,whether the country that the city belongs to is multi_country,text,commonsense evidence: The meaning of multi_country is consisting of or involving multiple countries.
type,,the type of the postal point,text,
organization ,,the organization to which the postal point belongs,text,commonsense evidence: 'No data' means the postal point is not affiliated with any organization
time_zone,time zone,the time zone of the postal point location,text,
daylight_savings,daylight savings,whether the location implements daylight savings,text,"commonsense evidence: Daylight saving is the practice of advancing clocks (typically by one hour) during warmer months so that darkness falls at a later clock time. As a result, there is one 23-hour day in late winter or early spring and one 25-hour day in autumn."
latitude,,the latitude of the postal point location,real,
longitude,,the longitude of the postal point location,real,
elevation,,the elevation of the postal point location,integer,
state_fips,state fips,state-level FIPS code,integer,
county_fips,country fips,country-level FIPS code,integer,commonsense evidence: FIPS codes are numbers that uniquely identify geographic areas. The number of digits in FIPS codes varies depending on the level of geography.
region,,the region where the postal point locates ,text,
division,,the division of the organization ,text,
population_2020,population 2020,the population of the residential area in 2020,integer,commonsense evidence: 'No data' means that the postal point is not affiliated with any organization. Or the organization has no division. 
population_2010,population 2010,the population of the residential area in 2010,integer,
households,,the number of the households in the residential area,integer,
avg_house_value,average house value,the average house value in the residential area,integer,
avg_income_per_household,average income per household,the average income per household in the residential area,integer,
persons_per_household,persons per household,the number of persons per household residential area,real,
white_population,white population,the population of white people in the residential area,integer,
black_population,black population,the population of black people in the residential area,integer,
hispanic_population,Hispanic population,the population of Hispanic people in the residential area,integer,
asian_population,Asian population,the population of Asian people in the residential area,integer,
american_indian_population,American Indian population,the population of American Indian people in the residential area,integer,
hawaiian_population,Hawaiian population,the population of Hawaiian people in the residential area,integer,
other_population,other population,the population of other races in the residential area,integer,
male_population,male population,the population of males in the residential area,integer,
female_population,female population,the population of females in the residential area,integer,
median_age,median age,the median age of the residential area,real,commonsense evidence: gender ratio in the residential area = male_population / female_population if female_population != 0
male_median_age,male median age,the male median age in the residential area,real,
female_median_age,female median age,the female median age in the residential area,real,
residential_mailboxes,residential mailboxes,the number of residential mailboxes in the residential area,integer,
business_mailboxes,business mailboxes,the number of business mailboxes in the residential area,integer,
total_delivery_receptacles,total delivery receptacles,the total number of delivery receptacles,integer,
businesses,,the number of businesses in the residential area,integer,
1st_quarter_payroll,1st quarter payroll,the total wages reported in the 1st quarter payroll report of the residential area,integer,
annual_payroll,annual payroll,the total wages reported in the annual payroll report of the residential area,integer,
employees,,the number of employees in the residential area,integer,commonsense evidence: Employers must submit periodic payroll reports to the Internal Revenue Service and state taxing authority. The report is used by employers to report wage information.
water_area,water area,the water area of the residential area,real,
land_area,land area,the land area of the residential area,real,
single_family_delivery_units,single-family delivery units,the number of single-family delivery units in the residential area,integer,
multi_family_delivery_units,multi-family delivery units,the number of single-family delivery units in the residential area,integer,"commonsense evidence: A single-family unit can be described as a single unit that accommodates only one family or tenant at a time on rent.
"
total_beneficiaries,total beneficiaries,the total number of beneficiaries of the postal service,integer,commonsense evidence: multi-family units are usually under a greater surface area with the capacity to accommodate more than one tenant or multiple families on rent at the same time
retired_workers,retired workers,the number of retired workers in the residential area,integer,
disabled_workers,disable workers,the number of disabled workers in the residential area,integer,
parents_and_widowed,parents and widowed,the number of parents and widowed in the residential area,integer,
spouses,,the number of spouses in the residential area,integer,
children,,the number of children in the residential area,integer,
over_65,over 65,the number of people whose age is over 65 in the residential area,integer,
monthly_benefits_all,monthly benefits all,all benefit payments by month ,integer,"commonsense evidence: no. of over_65 can refer to elders. Higher means more elders
if the ratio: over_65 / children is higher: the aging is more serious."
monthly_benefits_retired_workers,monthly benefits retired workers,monthly benefit payments for retired workers,integer,usd
monthly_benefits_widowed,monthly benefits widowed,monthly benefit payments for retired workers,integer,
CBSA,,the code of the cbsa officer,integer,
zip_data
original_column_name,column_name,column_description,data_format,value_description
zip_code,zip code,the zip code of the state in the country,integer,
county,country,the country ,text,
state,,the state of the country,text,
country
original_column_name,column_name,column_description,data_format,value_description
CBSA,,the code of the cbsa officer,integer,
CBSA_name,cbsa name,the name and the position of the cbsa officer ,text,
CBSA_type,cbsa type,the office type of the officer,text,
CBSA
original_column_name,column_name,column_description,data_format,value_description
abbreviation,,the abbreviation of the state name,text,
name,,the state name,text,
state