zip_to_cbsa_crosswalk

A crosswalk of ZIP to CBSA from https://www.huduser.gov/portal/datasets/usps_crosswalk.html.

Primary Key:

• zip_code
• cbsa
• release_date

Checks:

• zip_to_cbsa_crosswalk_total_percentage_check - ((total_percentage > (0)::double precision) AND (total_percentage <= (1)::double precision))

Indexes:

• zip_to_cbsa_crosswalk_cbsa_idx - cbsa
• zip_to_cbsa_crosswalk_zip_code_idx - zip_code

Column	Data Type	Nullable	Indexed	Description
zip_code	text	No	Yes	-
cbsa	text	No	Yes	-
total_percentage	double precision	No	No	The percentage the CBSA is for the ZIP. From the range of 0 (exclusive) to 1 (inclusive).
release_date	date	No	Yes	-