common.fipsmap

Field Type Null Default Key Extra Comment
fips_code varchar(5) YES MUL A FIPS code (county code)
fips_zip_code varchar(5) YES MUL A zip code associated with the FIPS code
fips_desc varchar(100) YES County Name
fips_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
fips_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
fips_code
TableColumn
_1.patientspat_fips_code
_1188.patientspat_fips_code
_1218.patientspat_fips_code
_1548.patientspat_fips_code
_435.patientspat_fips_code
_436.patientspat_fips_code
_436_archive_testing.patientspat_fips_code
_437.patientspat_fips_code
_8.patientspat_fips_code
_81.patientspat_fips_code
_999.patientspat_fips_code