Column medicare.ps.fips2
Overview of column fips2 in table medicare.ps
Table |
|
Qualified name |
medicare.ps.fips2 |
Datatype |
string |
Column type |
computed |
Reference |
https://www.census.gov/library/reference/code-lists/ansi.html#states |
2 digit state FIPS, see https://en.wikipedia.org/wiki/Federal_Information_Processing_Standard_state_code
Expressions
(SELECT fips2 FROM public.us_states as s WHERE s.ssa2 = "state")