ZIP Code Data

Database Diagram for ZIP Code Data

ZIP_Data ZIP_Data.zip_code ZIP_Data.city ZIP_Data.state ZIP_Data.multi_county ZIP_Data.type ZIP_Data.organization ZIP_Data.time_zone ZIP_Data.daylight_savings ZIP_Data.latitude ZIP_Data.longitude ZIP_Data.elevation ZIP_Data.state_fips ZIP_Data.county_fips ZIP_Data.region ZIP_Data.division ZIP_Data.population_2020 ZIP_Data.population_2010 ZIP_Data.households ZIP_Data.avg_house_value ZIP_Data.avg_income_per_household ZIP_Data.persons_per_household ZIP_Data.white_population ZIP_Data.black_population ZIP_Data.hispanic_population ZIP_Data.asian_population ZIP_Data.american_indian_population ZIP_Data.hawaiian_population ZIP_Data.other_population ZIP_Data.male_population ZIP_Data.female_population ZIP_Data.median_age ZIP_Data.male_median_age ZIP_Data.female_median_age ZIP_Data.residential_mailboxes ZIP_Data.business_mailboxes ZIP_Data.total_delivery_receptacles ZIP_Data.businesses ZIP_Data.1st_quarter_payroll ZIP_Data.annual_payroll ZIP_Data.employees ZIP_Data.water_area ZIP_Data.land_area ZIP_Data.single_family_delivery_units ZIP_Data.multi_family_delivery_units ZIP_Data.total_beneficiaries ZIP_Data.retired_workers ZIP_Data.disabled_workers ZIP_Data.parents_and_widowed ZIP_Data.spouses ZIP_Data.children ZIP_Data.over_65 ZIP_Data.monthly_benefits_all ZIP_Data.monthly_benefits_retired_workers ZIP_Data.monthly_benefits_widowed ZIP_Data.CBSA County County.zip_code County.county County.state Alias Alias.zip_code Alias.alias Avoid Avoid.zip_code Avoid.bad_alias Area_Code Area_Code.zip_code Area_Code.area_code CBSA CBSA.CBSA CBSA.CBSA_name CBSA.CBSA_type State State.abbreviation State.name ZIP_Congress ZIP_Congress.zip_code ZIP_Congress.district ZIP_Data JOIN County ON ZIP_Data.zip_code = County.zip_code ZIP_Data JOIN Alias ON ZIP_Data.zip_code = Alias.zip_code ZIP_Data JOIN Avoid ON ZIP_Data.zip_code = Avoid.zip_code ZIP_Data JOIN Area_Code ON ZIP_Data.zip_code = Area_Code.zip_code ZIP_Data JOIN ZIP_Congress ON ZIP_Data.zip_code = ZIP_Congress.zip_code ZIP_Data JOIN State ON ZIP_Data.state = State.abbreviation ZIP_Congress JOIN Congress_113 ON ZIP_Congress.district = Congress_113.cognress_rep_id CBSA JOIN ZIP_Data ON CBSA.CBSA = ZIP_Data.CBSA