Column medicare.ps.fips2

Overview of column fips2 in table medicare.ps

Table

medicare.ps

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")
Column medicare.ps.fips2 Lineage SVG

Data lineage for column medicare.ps.fips2