search

codeforkansascity / Property-Violations-Settlement

Analyzing Kansas City's open data on property violations
5 stars 7 forks source link

Data from Census/ACS Wishlist #41

Open EricRoche opened 8 years ago

EricRoche commented 8 years ago

This is the place to list out which datasets/variables you would like to pull from the ACS/Census. Please visit this list of variables for the complete list of available data.

Another great, easy to use resource is the American FactFinder.

Please include the table name and brief description!

buzwells commented 8 years ago

Here are some variables that look like they might be useful. The variable description below is from the CitySDK alias list (where that is available). The commented portion includes the formal variable name.

                "income", //B19013_001E - median income
                "population", //B01003_001E
                "employment_labor_force", //B23025_002E
                "employment_not_labor_force", //B23025_007E
                "employment_employed", //B23025_004E
                "employment_unemployed", //B23025_005E
                "poverty", //B17001_002E - # of folks living below the poverty level
                "age", //B01002_001E - median age, age groupings are also available
                "median_house_construction_year", //B25035_001E - older bldgs may have more issues
                "median_contract_rent", //B25058_001E
                "median_gross_rent", //B25064_001E
                "median_home_value", //B25077_001E
                "education_ged", //B15003_018E
                "education_none", //B15003_002E
                "education_high_school", //B15003_017E
                "education_associates", //B15003_021E
                "education_bachelors", //B15003_022E
                "education_masters", //B15003_023E
                "education_professional", //B15003_024E
                "education_doctorate" //B15003_025E
                ,"B25105_001E" // MEDIAN MONTHLY HOUSING COSTS (for owner occupied)
                ,"B25071_001E" // Median Gross Rent As A Percentage of Household Income (Dollars)

Should we always retrieve the related margin for error variable for each of these as well?

Still looking for the monthly housing cost as a percentage of income variable. When I try retrieving B25101_001E through the CitySDK, it's not a percentage, though for the subgroups within that variable family it seems to be a percentage.

jo-elliott commented 8 years ago

api.census.gov

Speak English less than 'very well' B06007_008E

Speak other languages B06007_006E

means of transportation to work retail B08126_006E

means of transportation to work arts, entertainment, and recreation, and accomodation and food services B08126_012E

B08130. MEANS OF TRANSPORTATION TO WORK BY PLACE OF WORK--STATE AND COUNTY LEVEL

B08201_026E 4 or more person household no vehicle available

means of transportation to work B08301_002E

public transportation means of transportation to work B08301_010E

B09010. Receipt of SSI, Public Assistance Income, or Food Stamps/SNAP in the Past 12 Mnths by Hhld Type for Children < 18 in Hhl

B09008. Presence of Unmarried Partner by Household Type for Children Under 18 Years in Households

B09008. Presence of Unmarried Partner by Household Type for Children Under 18 Years in Households

B27010. Types of Health Insurance Coverage by Age, under 18 with medicare only

B27010. Types of Health Insurance Coverage by Age with employer based health insurance only. 

B27010. Types of Health Insurance Coverage by Age under 18 with no health insurance coverage

OpenData KC consumer lending permits liquour license permits https://data.kcmo.org/Business/Business-License-Holders/pnm4-68wg

Also, Houses built before 1980 Number of parks death rate

zmon commented 8 years ago

There are some more Liquor sources on https://github.com/codeforkansascity/kc-open-data-library/wiki

EricRoche commented 8 years ago
dwancura commented 8 years ago

Good elements. I'm wondering if we can access any utility information, like average electric bill or average water bill.

buzwells commented 8 years ago

Following up on a conversation with Ron, I've consolidated the list above into a Google Sheet @: https://docs.google.com/spreadsheets/d/1ww_KmOxR5V_w3pmfnfuREJaWGm_cAYshFZgaDEsIKNU/edit?usp=sharing

I removed the dups, where I recognized them. There were only a few. In some cases, specific fields are identified, while in other cases only the census "concept" identifier (i.e., the prefix for the group of fields) is listed. For the concept cases, the idea we discussed is that all the fields within a concept would be retrieved.

rlh-aagis commented 8 years ago

Google Sheet, eh? Ok, then I could modify the Alteryx module to read from the sheet directly. This way as new variables are added, we can just run the module to add the additional variables to the dataset. Instant data! On Apr 5, 2016 7:25 AM, "Joel Wells" notifications@github.com wrote:

Following up on a conversation with Ron, I've consolidated the list above into a Google Sheet @: https://docs.google.com/spreadsheets/d/1ww_KmOxR5V_w3pmfnfuREJaWGm_cAYshFZgaDEsIKNU/edit?usp=sharing

I removed the dups, where I recognized them. There were only a few. In some cases, specific fields are identified, while in other cases only the census "concept" identifier (i.e., the prefix for the group of fields) is listed. For the concept cases, the idea we discussed is that all the fields within a concept would be retrieved.

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub https://github.com/codeforkansascity/Property-Violations-Settlement/issues/41#issuecomment-205778362

rlh-aagis commented 8 years ago

Good work Joel, yet we'll need a bit more work done on this. He will need assistance to identify exactly which variable is needed to ensure I'm getting you what you want. For example, let's look B08130 - Means of Transportation to work... If I pull the data for B08130_001E (I believe we touched based on this - gotta have the last 4 characters), this gives the total number of Workers 16 years and over given all the ways to get to work. Did you want this, or did you want the number that utilized public transport to get to work? Probably best we specifically identify which variables we want using the Social Explorer: http://www.socialexplorer.com/data/ACS2014_5yr/metadata/?ds=ACS14_5yr&table=B08130

Just trying to avoid the "Dog chasing his tail" scenario! =(;-))) Let's discuss this more tonight.

On Tue, Apr 5, 2016 at 7:25 AM, Joel Wells notifications@github.com wrote:

Following up on a conversation with Ron, I've consolidated the list above into a Google Sheet @: https://docs.google.com/spreadsheets/d/1ww_KmOxR5V_w3pmfnfuREJaWGm_cAYshFZgaDEsIKNU/edit?usp=sharing

I removed the dups, where I recognized them. There were only a few. In some cases, specific fields are identified, while in other cases only the census "concept" identifier (i.e., the prefix for the group of fields) is listed. For the concept cases, the idea we discussed is that all the fields within a concept would be retrieved.

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub https://github.com/codeforkansascity/Property-Violations-Settlement/issues/41#issuecomment-205778362

dwancura commented 8 years ago

Updated spreadsheet, added in a couple of new "1" entries. I looked for land area, not there. From the Social Explorers site, it's T003_001, not sure how to find this value in the B tables. I'd like to compute population density (i.e. population/land-area).

buzwells commented 8 years ago

Ron, looks like we're ready to go. The Google spreadsheet is now filtered based on Dan's input: https://docs.google.com/spreadsheets/d/1ww_KmOxR5V_w3pmfnfuREJaWGm_cAYshFZgaDEsIKNU/edit?usp=sharing .