Database Tables

These are the classes that define all the tables in the database. Under each table, all the columns (which are the class attributes) are listed.

There are four tables that represent the Self-Sufficiency Standard data: sss.SSS contains the columns that are present in all files, while sss.Miscellaneous, sss.HealthCare and sss.ARPA are helper tables with extra information for some rows in sss.SSS. The sss.Report table contains information about when the Self-Sufficiency Standard report was prepared.

Supplementary information useful for various analyses are contained the sss.GeoID, sss.PUMA, and sss.City tables.

Self-Sufficiency Data Tables

class sss.SSS(**kwargs)

Defines the self_sufficiency_standard table.

family_type

One of our primary keys, the family type as seen in the standard SSS.

Type:: String Column

state

One of our primary keys, which what state this data is taken from.

Type:: String Column

place

One of our primary keys, either the town or county.

Type:: String Column

year

One of our primary keys, the year the data is from.

Type:: String Column

analysis_type

One of our primary keys, whether the file is either a town or county.

Type:: String Column

adult

Number of adults in the household.

Type:: Integer Column

infant

Number of infants in the household.

Type:: Integer Column

preschooler

Number of preschoolers in the household.

Type:: Integer Column

schoolager

Number of schoolagers in the household.

Type:: Integer Column

teenager

Number of teenagers in the househould.

Type:: Integer Column

weighted_child_count

Number of total children in the household. A value is only present when the family type is a*c*.

Type:: Integer Column

housing

Cost of housing.

Type:: Float Column

child_care

Cost of child care.

Type:: Float Column

food

Cost of food.

Type:: Float Column

transportation

Cost of transportation.

Type:: Float Column

health_care

Cost of health care.

Type:: Float Column

miscellaneous

Cost of miscellaneous costs.

Type:: Float Column

taxes

Cost of taxes paid.

Type:: Float Column

earned_income_tax_credit

Amount of tax credit earned through work.

Type:: Float Column

child_care_tax_credit

Amount of tax credit earned through child care cost.

Type:: Float Column

child_tax_credit

Amount of tax credit earned through number of children.

Type:: Float Column

hourly_self_sufficiency_wage

The hourly wage needed to reach self-sufficiency.

Type:: Float Column

monthly_self_sufficiency_wage

The monthly wage needed to reach self-sufficiency.

Type:: Float Column

annual_self_sufficiency_wage

The annual wage needed reach self-sufficiency.

Type:: Float Column

emergency_savings

The amount needed to cover random expenses.

Type:: Float Column

miscellaneous_is_secondary

Value represents whether there is a table breakdown of miscellaneous.

Type:: Boolean Column

health_care_is_secondary

Value represents whether there is a table breakdown of health care.

Type:: Boolean Column

analysis_is_secondary

Value represents whether there is a table breakdown of ARPA.

Type:: Boolean Column

class sss.Miscellaneous(**kwargs)

Define the miscellaneous table.

state

One of our primary keys, which what state this data is taken from.

Type:: String Column

place

One of our primary keys, which either the town or county.

Type:: String Column

year

One of our primary keys, the year the data is from.

Type:: Integer Column

analysis_type

One of our primary keys, whether the file is either a town or county.

Type:: String Column

broadband_and_cell_phone

Cost families spend on broadband and cell phone per month.

Type:: Float Column

class sss.HealthCare(**kwargs)

Define the health_care table.

state

One of our primary keys, which what state this data is taken from.

Type:: String Column

place

One of our primary keys, which either the town or county.

Type:: String Column

year

One of our primary keys, the year the data is from.

Type:: Integer Column

analysis_type

One of our primary keys, whether the file is either a town or county.

Type:: String Column

premium

Price that job covers heatlh_care

Type:: Float Column

out_of_pocket

Price that family pays for health care

Type:: Float Column

class sss.ARPA(**kwargs)

Define the arpa table.

state

One of our primary keys, which what state this data is taken from.

Type:: String Column

place

One of our primary keys, the town or county.

Type:: String Column

year

One of our primary keys, the year the data is from.

Type:: Integer Column

analysis_type

One of our primary keys, whether the file is either a town or county.

Type:: String Column

federal_state_eitc

Amount of the “refundable” tax credit based on loss of income.

Type:: Float Column

federal_cdctc

Amount of Child and Dependent Care Tax Credit.

Type:: Float Column

federal_income_taxes

Amount of federal income taxes paid.

Type:: Float Column

payroll_taxes

Amount of payroll taxes paid.

Type:: Float Column

state_sales_taxes

Amount of state sales taxes paid.

Type:: Float Column

total_annual_resources

An adjusted annual wage to reach self-sufficiency.

Type:: Float Column

Report table

class sss.Report(**kwargs)

Define the report table.

year

year of report

Type:: Integer Column

state

name of state

Type:: String Column

analysis_type

analysis type of sss, e.g. full, partial

Type:: String Column

cpi_month

cpi month of the report

Type:: String Column

cpi_year

cpi year of the report

Type:: Integer Column

update_date

update date

Type:: Date Column

update_person

person who updated the report

Type:: String Column

Geographical Identifier table

class sss.GeoID(**kwargs)

Defines the geo_identifier table.

The data for this table comes from the Census.

state

name of the state, e.g. WA

Type:: String Column

place

SSS place name

Type:: String Column

state_fips

fips code of state

Type:: String Column

county_fips

fips code of county

Type:: String Column

place_fips

fips code of place

Type:: String Column

cpi_region

name of cpi region

Type:: String Column

PUMA table

class sss.PUMA(**kwargs)

Define the puma table.

PUMA stands for Public Use Microdata Area from the Census.

summary_level

Summary Level Code

Type:: String Column

state_fips

State FIPS Code

Type:: String Column

state

state name, e.g. WA

Type:: String Column

puma_code

PUMA Code

Type:: String Column

county_fips

County FIPS Code

Type:: String Column

county_sub_fips

County Subdivision FIPS Code

Type:: String Column

county_sub

name of the county sub

Type:: String Column

county

name of the county

Type:: String Column

puma_area

name of the puma area

Type:: String Column

place

name of the sss place

Type:: String Column

population

population of the puma

Type:: Integer Column

weight

weight of population based on puma

Type:: Float Column

year

the year of population

Type:: Integer Column

City table

class sss.City(**kwargs)

Define the city table.

This table links the SSS places to cities and provides population to allow for choosing similar sized cities to compare.

state

name of the state, e.g. WA

Type:: String Column

place

SSS place name

Type:: String Column

city

sss_city, some cities of sss place

Type:: String Column

census_name

the census name of the city

Type:: String Column

population

number of the population of the city

Type:: Integer Column

public_transit

whether the city is public transit or not

Type:: Boolean Column