{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Getting started with R" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**By [Christine Zhang](https://twitter.com/christinezhang) (Knight-Mozilla / Los Angeles Times) & [Ryan Menezes](https://twitter.com/ryanvmenezes) (Los Angeles Times)**\n", "\n", "*IRE Conference -- New Orleans, LA*\n", " \n", "June 18, 2016 \n", "\n", "This workshop is a basic introduction to R, a free, open-source software for data analysis and statistics. \n", "\n", "R is a powerful tool that can help you quickly and effectively answer questions using data.\n", "\n", "Take our host city, New Orleans, for example. Hurricane Katrina was a devastating natural disaster that substantially affected the population of New Orleans. The hurricane took place in August 2005, which coincidentally falls between the U.S. Census full population counts in 2000 and 2010.\n", "\n", "In this session, we will use the \"Demographic Profile” -- a large summary file with many different demographic variables downloaded from the [U.S. Census Bureau website](http://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml) -- from 2000 and 2010, for all census tracts in the state of Louisiana.\n", "\n", "**In this session, we will:**\n", "\n", "* Load the 2000 data in R\n", "* Select a few variables pertaining to population counts and housing occupancy\n", "* Clean the data\n", "* Focus on the Orleans Parish in particular, which represents the city of New Orleans, and tally the population\n", "* Perform the same steps on the 2010 data\n", "* Merge the two sets\n", "* Write the merged data out to a CSV file for our next class, [More with R](More%20with%20R.ipynb), where we'll do some more in depth analysis\n", "\n", "Basic analysis techniques like the ones you will learn in this class can help you write data-driven stories, like [this one written by The Times-Picayune](http://www.nola.com/politics/index.ssf/2011/02/new_orleans_officials_2010_pop.html) shortly after the census released its 2010 tally.\n", "\n", "The story begins:\n", "\n", "> Five years after Hurricane Katrina emptied New Orleans and prompted the largest mass migration in modern American history, **the 2010 Census counted 343,829 people living in the still-recovering city, a 29 percent drop since the last head count a decade ago**, according to data released today.\n", "\n", "Using the data we have, we will attempt to replicate the calculations in that lede.\n", "\n", "The following code and annotations were written in a Jupyter notebook. The code is best run in RStudio version 0.99.902 using R version 3.3.0" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Loading data\n", "\n", "We'll start by loading in the 2000 data, which is stored in a CSV (comma-separated values) file. CSVs are plain-text files of data where commas separate the columns within a line. It is sometimes preferable to work with CSVs as opposed to files of a proprietary format, such as Microsoft Excel files, but the Census Bureau readily makes data available in both formats.\n", "\n", "Let's run R's `read.csv` command and save the data to an object called `census2000`. Here, we are using assignment with `<-`, which tells R to run the right side and assign the result to the object named on the left. " ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "census2000 <- read.csv('2000_census_demographic_profile.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now that this ran without incident, let's inspect the first few rows using `head`, which by default prints out the first six rows of a data frame (R's internal term for a spreadsheet):" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
GEO.idGEO.id2GEO.display.labelHC01_VC01HC02_VC01HC01_VC03HC02_VC03HC01_VC04HC02_VC04HC01_VC05HC02_VC05HC01_VC06HC02_VC06HC01_VC07HC02_VC07HC01_VC08HC02_VC08HC01_VC09HC02_VC09HC01_VC10HC02_VC10HC01_VC11HC02_VC11HC01_VC12HC02_VC12HC01_VC13HC02_VC13HC01_VC14HC02_VC14HC01_VC15HC02_VC15HC01_VC16HC02_VC16HC01_VC17HC02_VC17HC01_VC18HC02_VC18HC01_VC19HC02_VC19HC01_VC20HC02_VC20HC01_VC21HC02_VC21HC01_VC22HC02_VC22HC01_VC23HC02_VC23HC01_VC24HC02_VC24HC01_VC25HC02_VC25HC01_VC26HC02_VC26HC01_VC28HC02_VC28HC01_VC29HC02_VC29HC01_VC30HC02_VC30HC01_VC31HC02_VC31HC01_VC32HC02_VC32HC01_VC33HC02_VC33HC01_VC34HC02_VC34HC01_VC35HC02_VC35HC01_VC36HC02_VC36HC01_VC37HC02_VC37HC01_VC38HC02_VC38HC01_VC39HC02_VC39HC01_VC40HC02_VC40HC01_VC41HC02_VC41HC01_VC42HC02_VC42HC01_VC43HC02_VC43HC01_VC44HC02_VC44HC01_VC45HC02_VC45HC01_VC46HC02_VC46HC01_VC48HC02_VC48HC01_VC49HC02_VC49HC01_VC50HC02_VC50HC01_VC51HC02_VC51HC01_VC52HC02_VC52HC01_VC53HC02_VC53HC01_VC55HC02_VC55HC01_VC56HC02_VC56HC01_VC57HC02_VC57HC01_VC58HC02_VC58HC01_VC59HC02_VC59HC01_VC60HC02_VC60HC01_VC61HC02_VC61HC01_VC62HC02_VC62HC01_VC64HC02_VC64HC01_VC65HC02_VC65HC01_VC66HC02_VC66HC01_VC67HC02_VC67HC01_VC68HC02_VC68HC01_VC69HC02_VC69HC01_VC70HC02_VC70HC01_VC71HC02_VC71HC01_VC72HC02_VC72HC01_VC73HC02_VC73HC01_VC74HC02_VC74HC01_VC75HC02_VC75HC01_VC76HC02_VC76HC01_VC78HC02_VC78HC01_VC79HC02_VC79HC01_VC80HC02_VC80HC01_VC81HC02_VC81HC01_VC82HC02_VC82HC01_VC83HC02_VC83HC01_VC84HC02_VC84HC01_VC85HC02_VC85HC01_VC86HC02_VC86HC01_VC87HC02_VC87HC01_VC88HC02_VC88HC01_VC89HC02_VC89HC01_VC90HC02_VC90HC01_VC91HC02_VC91HC01_VC93HC02_VC93HC01_VC94HC02_VC94HC01_VC95HC02_VC95HC01_VC96HC02_VC96HC01_VC97HC02_VC97HC01_VC98HC02_VC98HC01_VC100HC02_VC100HC01_VC101HC02_VC101HC01_VC102HC02_VC102HC01_VC103HC02_VC103HC01_VC104HC02_VC104
1IdId2GeographyNumber; Total populationPercent; Total populationNumber; Total population - SEX AND AGE - MalePercent; Total population - SEX AND AGE - MaleNumber; Total population - SEX AND AGE - FemalePercent; Total population - SEX AND AGE - FemaleNumber; Total population - SEX AND AGE - Under 5 yearsPercent; Total population - SEX AND AGE - Under 5 yearsNumber; Total population - SEX AND AGE - 5 to 9 yearsPercent; Total population - SEX AND AGE - 5 to 9 yearsNumber; Total population - SEX AND AGE - 10 to 14 yearsPercent; Total population - SEX AND AGE - 10 to 14 yearsNumber; Total population - SEX AND AGE - 15 to 19 yearsPercent; Total population - SEX AND AGE - 15 to 19 yearsNumber; Total population - SEX AND AGE - 20 to 24 yearsPercent; Total population - SEX AND AGE - 20 to 24 yearsNumber; Total population - SEX AND AGE - 25 to 34 yearsPercent; Total population - SEX AND AGE - 25 to 34 yearsNumber; Total population - SEX AND AGE - 35 to 44 yearsPercent; Total population - SEX AND AGE - 35 to 44 yearsNumber; Total population - SEX AND AGE - 45 to 54 yearsPercent; Total population - SEX AND AGE - 45 to 54 yearsNumber; Total population - SEX AND AGE - 55 to 59 yearsPercent; Total population - SEX AND AGE - 55 to 59 yearsNumber; Total population - SEX AND AGE - 60 to 64 yearsPercent; Total population - SEX AND AGE - 60 to 64 yearsNumber; Total population - SEX AND AGE - 65 to 74 yearsPercent; Total population - SEX AND AGE - 65 to 74 yearsNumber; Total population - SEX AND AGE - 75 to 84 yearsPercent; Total population - SEX AND AGE - 75 to 84 yearsNumber; Total population - SEX AND AGE - 85 years and overPercent; Total population - SEX AND AGE - 85 years and overNumber; Total population - SEX AND AGE - Median age (years)Percent; Total population - SEX AND AGE - Median age (years)Number; Total population - SEX AND AGE - 18 years and overPercent; Total population - SEX AND AGE - 18 years and overNumber; Total population - SEX AND AGE - 18 years and over - MalePercent; Total population - SEX AND AGE - 18 years and over - MaleNumber; Total population - SEX AND AGE - 18 years and over - FemalePercent; Total population - SEX AND AGE - 18 years and over - FemaleNumber; Total population - SEX AND AGE - 21 years and overPercent; Total population - SEX AND AGE - 21 years and overNumber; Total population - SEX AND AGE - 62 years and overPercent; Total population - SEX AND AGE - 62 years and overNumber; Total population - SEX AND AGE - 65 years and overPercent; Total population - SEX AND AGE - 65 years and overNumber; Total population - SEX AND AGE - 65 years and over - MalePercent; Total population - SEX AND AGE - 65 years and over - MaleNumber; Total population - SEX AND AGE - 65 years and over - FemalePercent; Total population - SEX AND AGE - 65 years and over - FemaleNumber; Total population - RACE - One racePercent; Total population - RACE - One raceNumber; Total population - RACE - One race - WhitePercent; Total population - RACE - One race - WhiteNumber; Total population - RACE - One race - Black or African AmericanPercent; Total population - RACE - One race - Black or African AmericanNumber; Total population - RACE - One race - American Indian and Alaska NativePercent; Total population - RACE - One race - American Indian and Alaska NativeNumber; Total population - RACE - One race - AsianPercent; Total population - RACE - One race - AsianNumber; Total population - RACE - One race - Asian - Asian IndianPercent; Total population - RACE - One race - Asian - Asian IndianNumber; Total population - RACE - One race - Asian - ChinesePercent; Total population - RACE - One race - Asian - ChineseNumber; Total population - RACE - One race - Asian - FilipinoPercent; Total population - RACE - One race - Asian - FilipinoNumber; Total population - RACE - One race - Asian - JapanesePercent; Total population - RACE - One race - Asian - JapaneseNumber; Total population - RACE - One race - Asian - KoreanPercent; Total population - RACE - One race - Asian - KoreanNumber; Total population - RACE - One race - Asian - VietnamesePercent; Total population - RACE - One race - Asian - VietnameseNumber; Total population - RACE - One race - Asian - Other Asian [1]Percent; Total population - RACE - One race - Asian - Other Asian [1]Number; Total population - RACE - One race - Native Hawaiian and Other Pacific IslanderPercent; Total population - RACE - One race - Native Hawaiian and Other Pacific IslanderNumber; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Native HawaiianPercent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Native HawaiianNumber; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Guamanian or ChamorroPercent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Guamanian or ChamorroNumber; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - SamoanPercent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - SamoanNumber; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Other Pacific Islander [2]Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Other Pacific Islander [2]Number; Total population - RACE - One race - Some other racePercent; Total population - RACE - One race - Some other raceNumber; Total population - RACE - Two or more racesPercent; Total population - RACE - Two or more racesNumber; Total population - RACE - Race alone or in combination with one or more other races [3] - WhitePercent; Total population - RACE - Race alone or in combination with one or more other races [3] - WhiteNumber; Total population - RACE - Race alone or in combination with one or more other races [3] - Black or African AmericanPercent; Total population - RACE - Race alone or in combination with one or more other races [3] - Black or African AmericanNumber; Total population - RACE - Race alone or in combination with one or more other races [3] - American Indian and Alaska NativePercent; Total population - RACE - Race alone or in combination with one or more other races [3] - American Indian and Alaska NativeNumber; Total population - RACE - Race alone or in combination with one or more other races [3] - AsianPercent; Total population - RACE - Race alone or in combination with one or more other races [3] - AsianNumber; Total population - RACE - Race alone or in combination with one or more other races [3] - Native Hawaiian and Other Pacific IslanderPercent; Total population - RACE - Race alone or in combination with one or more other races [3] - Native Hawaiian and Other Pacific IslanderNumber; Total population - RACE - Race alone or in combination with one or more other races [3] - Some other racePercent; Total population - RACE - Race alone or in combination with one or more other races [3] - Some other raceNumber; HISPANIC OR LATINO AND RACE - Total populationPercent; HISPANIC OR LATINO AND RACE - Total populationNumber; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race)Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race)Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - MexicanPercent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - MexicanNumber; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Puerto RicanPercent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Puerto RicanNumber; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - CubanPercent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - CubanNumber; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Other Hispanic or LatinoPercent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Other Hispanic or LatinoNumber; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or LatinoPercent; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or LatinoNumber; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino - White alonePercent; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino - White aloneNumber; RELATIONSHIP - Total populationPercent; RELATIONSHIP - Total populationNumber; RELATIONSHIP - Total population - In householdsPercent; RELATIONSHIP - Total population - In householdsNumber; RELATIONSHIP - Total population - In households - HouseholderPercent; RELATIONSHIP - Total population - In households - HouseholderNumber; RELATIONSHIP - Total population - In households - SpousePercent; RELATIONSHIP - Total population - In households - SpouseNumber; RELATIONSHIP - Total population - In households - ChildPercent; RELATIONSHIP - Total population - In households - ChildNumber; RELATIONSHIP - Total population - In households - Child - Own child under 18 yearsPercent; RELATIONSHIP - Total population - In households - Child - Own child under 18 yearsNumber; RELATIONSHIP - Total population - In households - Other relativesPercent; RELATIONSHIP - Total population - In households - Other relativesNumber; RELATIONSHIP - Total population - In households - Other relatives - Under 18 yearsPercent; RELATIONSHIP - Total population - In households - Other relatives - Under 18 yearsNumber; RELATIONSHIP - Total population - In households - NonrelativesPercent; RELATIONSHIP - Total population - In households - NonrelativesNumber; RELATIONSHIP - Total population - In households - Nonrelatives - Unmarried partnerPercent; RELATIONSHIP - Total population - In households - Nonrelatives - Unmarried partnerNumber; RELATIONSHIP - Total population - In group quartersPercent; RELATIONSHIP - Total population - In group quartersNumber; RELATIONSHIP - Total population - In group quarters - Institutionalized populationPercent; RELATIONSHIP - Total population - In group quarters - Institutionalized populationNumber; RELATIONSHIP - Total population - In group quarters - Noninstitutionalized populationPercent; RELATIONSHIP - Total population - In group quarters - Noninstitutionalized populationNumber; HOUSEHOLDS BY TYPE - Total householdsPercent; HOUSEHOLDS BY TYPE - Total householdsNumber; HOUSEHOLDS BY TYPE - Total households - Family households (families)Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families)Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - With own children under 18 yearsPercent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - With own children under 18 yearsNumber; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple familyPercent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple familyNumber; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family - With own children under 18 yearsPercent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family - With own children under 18 yearsNumber; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband presentPercent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband presentNumber; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present - With own children under 18 yearsPercent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present - With own children under 18 yearsNumber; HOUSEHOLDS BY TYPE - Total households - Nonfamily householdsPercent; HOUSEHOLDS BY TYPE - Total households - Nonfamily householdsNumber; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alonePercent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living aloneNumber; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone - Householder 65 years and overPercent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone - Householder 65 years and overNumber; HOUSEHOLDS BY TYPE - Total households - Households with individuals under 18 yearsPercent; HOUSEHOLDS BY TYPE - Total households - Households with individuals under 18 yearsNumber; HOUSEHOLDS BY TYPE - Total households - Households with individuals 65 years and overPercent; HOUSEHOLDS BY TYPE - Total households - Households with individuals 65 years and overNumber; HOUSEHOLDS BY TYPE - Total households - Average household sizePercent; HOUSEHOLDS BY TYPE - Total households - Average household sizeNumber; HOUSEHOLDS BY TYPE - Total households - Average family sizePercent; HOUSEHOLDS BY TYPE - Total households - Average family sizeNumber; HOUSING OCCUPANCY - Total housing unitsPercent; HOUSING OCCUPANCY - Total housing unitsNumber; HOUSING OCCUPANCY - Total housing units - Occupied housing unitsPercent; HOUSING OCCUPANCY - Total housing units - Occupied housing unitsNumber; HOUSING OCCUPANCY - Total housing units - Vacant housing unitsPercent; HOUSING OCCUPANCY - Total housing units - Vacant housing unitsNumber; HOUSING OCCUPANCY - Total housing units - Vacant housing units - For seasonal, recreational, or occasional usePercent; HOUSING OCCUPANCY - Total housing units - Vacant housing units - For seasonal, recreational, or occasional useNumber; HOUSING OCCUPANCY - Total housing units - Homeowner vacancy rate (percent)Percent; HOUSING OCCUPANCY - Total housing units - Homeowner vacancy rate (percent)Number; HOUSING OCCUPANCY - Total housing units - Rental vacancy rate (percent)Percent; HOUSING OCCUPANCY - Total housing units - Rental vacancy rate (percent)Number; HOUSING TENURE - Occupied housing unitsPercent; HOUSING TENURE - Occupied housing unitsNumber; HOUSING TENURE - Occupied housing units - Owner-occupied housing unitsPercent; HOUSING TENURE - Occupied housing units - Owner-occupied housing unitsNumber; HOUSING TENURE - Occupied housing units - Renter-occupied housing unitsPercent; HOUSING TENURE - Occupied housing units - Renter-occupied housing unitsNumber; HOUSING TENURE - Occupied housing units - Average household size of owner-occupied unitPercent; HOUSING TENURE - Occupied housing units - Average household size of owner-occupied unitNumber; HOUSING TENURE - Occupied housing units - Average household size of renter-occupied unitPercent; HOUSING TENURE - Occupied housing units - Average household size of renter-occupied unit
21400000US2200196010022001960100Census Tract 9601, Acadia Parish, Louisiana6,1881002,920473,26853462850285419572937567281291315699113015252443372875123234(X)4,304701,957322,347384,031659961684314295554896,1741004,455721,67527120700000200010004000000000002501404,468721,6772719080003016,18810087151110003516,101994,398716,1881006,030972,236361,119182,199361,70028274414322023109215831512702,2361001,59571868391,1195057326363162371164129585263031496243569253(X)3(X)2,4101002,2369317471511(X)8(X)2,2361001,52668710323(X)3(X)
31400000US2200196020022001960200Census Tract 9602, Acadia Parish, Louisiana5,0561002,562512,4944934674168476946392986579128611770914250520342635150342134(X)3,527701,758351,769353,28965570114559217423855,0351004,79995216460100000000000001000000000001302104,81695226513060401605,05610035118000001705,021994,775945,0561005,0561001,764351,216241,791351,41328173386211226110000001,7641001,40880722411,216696173513488153562031018128778144339193(X)3(X)1,9091001,7649214583121(X)7(X)1,7641001,46183303173(X)3(X)
41400000US2200196030022001960300Census Tract 9603, Acadia Parish, Louisiana3,1491001,593511,55649209725183051026082047368125201740913148513042097104332135(X)2,233711,103351,130362,081664351434511150519563,1401003,05897672802000100000000010101000000040903,066976921302010703,1491001514000001103,1341003,049973,1491003,1481001,14536750241,09135854277323818934821000101,14510088377445397506636932938525262232282091847542247223(X)3(X)1,2461001,1459210181921(X)7(X)1,1451001,0419110493(X)3(X)
51400000US2200196040022001960400Census Tract 9604, Acadia Parish, Louisiana5,6171002,754492,8635142984067520947693536691129141668412254522244107193365134(X)3,944701,911342,033363,716668001466812302536675,583995,34795207418060101040000000000000000000503415,3819621144318000905,61710043124000001905,574995,307955,6171005,5921001,991351,291231,994361,554281964101212027012501001501,9911001,55578804401,2916564132168899543622388201891086143482243(X)3(X)2,1761001,9919218592311(X)6(X)1,9911001,63082361183(X)3(X)
61400000US2200196050022001960500Census Tract 9605, Acadia Parish, Louisiana4,9271002,461502,4665040084389439941893197704147771664413227515432345134339132(X)3,405691,675341,730353,16264499104078167324054,9011004,49891378815040000010000030001000001000502614,5249238583514010904,92710061137110002314,866994,448904,9271004,9211001,692341,068221,809371,418291744711178410026000601,6921001,32678762451,06863611361821110363662230018136880848316193(X)3(X)1,7961001,6929410462211(X)5(X)1,6921001,41984273163(X)3(X)
\n" ], "text/latex": [ "\\begin{tabular}{r|lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll}\n", " & GEO.id & GEO.id2 & GEO.display.label & HC01_VC01 & HC02_VC01 & HC01_VC03 & HC02_VC03 & HC01_VC04 & HC02_VC04 & HC01_VC05 & HC02_VC05 & HC01_VC06 & HC02_VC06 & HC01_VC07 & HC02_VC07 & HC01_VC08 & HC02_VC08 & HC01_VC09 & HC02_VC09 & HC01_VC10 & HC02_VC10 & HC01_VC11 & HC02_VC11 & HC01_VC12 & HC02_VC12 & HC01_VC13 & HC02_VC13 & HC01_VC14 & HC02_VC14 & HC01_VC15 & HC02_VC15 & HC01_VC16 & HC02_VC16 & HC01_VC17 & HC02_VC17 & HC01_VC18 & HC02_VC18 & HC01_VC19 & HC02_VC19 & HC01_VC20 & HC02_VC20 & HC01_VC21 & HC02_VC21 & HC01_VC22 & HC02_VC22 & HC01_VC23 & HC02_VC23 & HC01_VC24 & HC02_VC24 & HC01_VC25 & HC02_VC25 & HC01_VC26 & HC02_VC26 & HC01_VC28 & HC02_VC28 & HC01_VC29 & HC02_VC29 & HC01_VC30 & HC02_VC30 & HC01_VC31 & HC02_VC31 & HC01_VC32 & HC02_VC32 & HC01_VC33 & HC02_VC33 & HC01_VC34 & HC02_VC34 & HC01_VC35 & HC02_VC35 & HC01_VC36 & HC02_VC36 & HC01_VC37 & HC02_VC37 & HC01_VC38 & HC02_VC38 & HC01_VC39 & HC02_VC39 & HC01_VC40 & HC02_VC40 & HC01_VC41 & HC02_VC41 & HC01_VC42 & HC02_VC42 & HC01_VC43 & HC02_VC43 & HC01_VC44 & HC02_VC44 & HC01_VC45 & HC02_VC45 & HC01_VC46 & HC02_VC46 & HC01_VC48 & HC02_VC48 & HC01_VC49 & HC02_VC49 & HC01_VC50 & HC02_VC50 & HC01_VC51 & HC02_VC51 & HC01_VC52 & HC02_VC52 & HC01_VC53 & HC02_VC53 & HC01_VC55 & HC02_VC55 & HC01_VC56 & HC02_VC56 & HC01_VC57 & HC02_VC57 & HC01_VC58 & HC02_VC58 & HC01_VC59 & HC02_VC59 & HC01_VC60 & HC02_VC60 & HC01_VC61 & HC02_VC61 & HC01_VC62 & HC02_VC62 & HC01_VC64 & HC02_VC64 & HC01_VC65 & HC02_VC65 & HC01_VC66 & HC02_VC66 & HC01_VC67 & HC02_VC67 & HC01_VC68 & HC02_VC68 & HC01_VC69 & HC02_VC69 & HC01_VC70 & HC02_VC70 & HC01_VC71 & HC02_VC71 & HC01_VC72 & HC02_VC72 & HC01_VC73 & HC02_VC73 & HC01_VC74 & HC02_VC74 & HC01_VC75 & HC02_VC75 & HC01_VC76 & HC02_VC76 & HC01_VC78 & HC02_VC78 & HC01_VC79 & HC02_VC79 & HC01_VC80 & HC02_VC80 & HC01_VC81 & HC02_VC81 & HC01_VC82 & HC02_VC82 & HC01_VC83 & HC02_VC83 & HC01_VC84 & HC02_VC84 & HC01_VC85 & HC02_VC85 & HC01_VC86 & HC02_VC86 & HC01_VC87 & HC02_VC87 & HC01_VC88 & HC02_VC88 & HC01_VC89 & HC02_VC89 & HC01_VC90 & HC02_VC90 & HC01_VC91 & HC02_VC91 & HC01_VC93 & HC02_VC93 & HC01_VC94 & HC02_VC94 & HC01_VC95 & HC02_VC95 & HC01_VC96 & HC02_VC96 & HC01_VC97 & HC02_VC97 & HC01_VC98 & HC02_VC98 & HC01_VC100 & HC02_VC100 & HC01_VC101 & HC02_VC101 & HC01_VC102 & HC02_VC102 & HC01_VC103 & HC02_VC103 & HC01_VC104 & HC02_VC104\\\\\n", "\\hline\n", "\t1 & Id & Id2 & Geography & Number; Total population & Percent; Total population & Number; Total population - SEX AND AGE - Male & Percent; Total population - SEX AND AGE - Male & Number; Total population - SEX AND AGE - Female & Percent; Total population - SEX AND AGE - Female & Number; Total population - SEX AND AGE - Under 5 years & Percent; Total population - SEX AND AGE - Under 5 years & Number; Total population - SEX AND AGE - 5 to 9 years & Percent; Total population - SEX AND AGE - 5 to 9 years & Number; Total population - SEX AND AGE - 10 to 14 years & Percent; Total population - SEX AND AGE - 10 to 14 years & Number; Total population - SEX AND AGE - 15 to 19 years & Percent; Total population - SEX AND AGE - 15 to 19 years & Number; Total population - SEX AND AGE - 20 to 24 years & Percent; Total population - SEX AND AGE - 20 to 24 years & Number; Total population - SEX AND AGE - 25 to 34 years & Percent; Total population - SEX AND AGE - 25 to 34 years & Number; Total population - SEX AND AGE - 35 to 44 years & Percent; Total population - SEX AND AGE - 35 to 44 years & Number; Total population - SEX AND AGE - 45 to 54 years & Percent; Total population - SEX AND AGE - 45 to 54 years & Number; Total population - SEX AND AGE - 55 to 59 years & Percent; Total population - SEX AND AGE - 55 to 59 years & Number; Total population - SEX AND AGE - 60 to 64 years & Percent; Total population - SEX AND AGE - 60 to 64 years & Number; Total population - SEX AND AGE - 65 to 74 years & Percent; Total population - SEX AND AGE - 65 to 74 years & Number; Total population - SEX AND AGE - 75 to 84 years & Percent; Total population - SEX AND AGE - 75 to 84 years & Number; Total population - SEX AND AGE - 85 years and over & Percent; Total population - SEX AND AGE - 85 years and over & Number; Total population - SEX AND AGE - Median age (years) & Percent; Total population - SEX AND AGE - Median age (years) & Number; Total population - SEX AND AGE - 18 years and over & Percent; Total population - SEX AND AGE - 18 years and over & Number; Total population - SEX AND AGE - 18 years and over - Male & Percent; Total population - SEX AND AGE - 18 years and over - Male & Number; Total population - SEX AND AGE - 18 years and over - Female & Percent; Total population - SEX AND AGE - 18 years and over - Female & Number; Total population - SEX AND AGE - 21 years and over & Percent; Total population - SEX AND AGE - 21 years and over & Number; Total population - SEX AND AGE - 62 years and over & Percent; Total population - SEX AND AGE - 62 years and over & Number; Total population - SEX AND AGE - 65 years and over & Percent; Total population - SEX AND AGE - 65 years and over & Number; Total population - SEX AND AGE - 65 years and over - Male & Percent; Total population - SEX AND AGE - 65 years and over - Male & Number; Total population - SEX AND AGE - 65 years and over - Female & Percent; Total population - SEX AND AGE - 65 years and over - Female & Number; Total population - RACE - One race & Percent; Total population - RACE - One race & Number; Total population - RACE - One race - White & Percent; Total population - RACE - One race - White & Number; Total population - RACE - One race - Black or African American & Percent; Total population - RACE - One race - Black or African American & Number; Total population - RACE - One race - American Indian and Alaska Native & Percent; Total population - RACE - One race - American Indian and Alaska Native & Number; Total population - RACE - One race - Asian & Percent; Total population - RACE - One race - Asian & Number; Total population - RACE - One race - Asian - Asian Indian & Percent; Total population - RACE - One race - Asian - Asian Indian & Number; Total population - RACE - One race - Asian - Chinese & Percent; Total population - RACE - One race - Asian - Chinese & Number; Total population - RACE - One race - Asian - Filipino & Percent; Total population - RACE - One race - Asian - Filipino & Number; Total population - RACE - One race - Asian - Japanese & Percent; Total population - RACE - One race - Asian - Japanese & Number; Total population - RACE - One race - Asian - Korean & Percent; Total population - RACE - One race - Asian - Korean & Number; Total population - RACE - One race - Asian - Vietnamese & Percent; Total population - RACE - One race - Asian - Vietnamese & Number; Total population - RACE - One race - Asian - Other Asian [1] & Percent; Total population - RACE - One race - Asian - Other Asian [1] & Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander & Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander & Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Native Hawaiian & Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Native Hawaiian & Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Guamanian or Chamorro & Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Guamanian or Chamorro & Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Samoan & Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Samoan & Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Other Pacific Islander [2] & Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Other Pacific Islander [2] & Number; Total population - RACE - One race - Some other race & Percent; Total population - RACE - One race - Some other race & Number; Total population - RACE - Two or more races & Percent; Total population - RACE - Two or more races & Number; Total population - RACE - Race alone or in combination with one or more other races [3] - White & Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - White & Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Black or African American & Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Black or African American & Number; Total population - RACE - Race alone or in combination with one or more other races [3] - American Indian and Alaska Native & Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - American Indian and Alaska Native & Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Asian & Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Asian & Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Native Hawaiian and Other Pacific Islander & Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Native Hawaiian and Other Pacific Islander & Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Some other race & Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Some other race & Number; HISPANIC OR LATINO AND RACE - Total population & Percent; HISPANIC OR LATINO AND RACE - Total population & Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) & Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) & Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Mexican & Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Mexican & Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Puerto Rican & Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Puerto Rican & Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Cuban & Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Cuban & Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Other Hispanic or Latino & Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Other Hispanic or Latino & Number; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino & Percent; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino & Number; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino - White alone & Percent; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino - White alone & Number; RELATIONSHIP - Total population & Percent; RELATIONSHIP - Total population & Number; RELATIONSHIP - Total population - In households & Percent; RELATIONSHIP - Total population - In households & Number; RELATIONSHIP - Total population - In households - Householder & Percent; RELATIONSHIP - Total population - In households - Householder & Number; RELATIONSHIP - Total population - In households - Spouse & Percent; RELATIONSHIP - Total population - In households - Spouse & Number; RELATIONSHIP - Total population - In households - Child & Percent; RELATIONSHIP - Total population - In households - Child & Number; RELATIONSHIP - Total population - In households - Child - Own child under 18 years & Percent; RELATIONSHIP - Total population - In households - Child - Own child under 18 years & Number; RELATIONSHIP - Total population - In households - Other relatives & Percent; RELATIONSHIP - Total population - In households - Other relatives & Number; RELATIONSHIP - Total population - In households - Other relatives - Under 18 years & Percent; RELATIONSHIP - Total population - In households - Other relatives - Under 18 years & Number; RELATIONSHIP - Total population - In households - Nonrelatives & Percent; RELATIONSHIP - Total population - In households - Nonrelatives & Number; RELATIONSHIP - Total population - In households - Nonrelatives - Unmarried partner & Percent; RELATIONSHIP - Total population - In households - Nonrelatives - Unmarried partner & Number; RELATIONSHIP - Total population - In group quarters & Percent; RELATIONSHIP - Total population - In group quarters & Number; RELATIONSHIP - Total population - In group quarters - Institutionalized population & Percent; RELATIONSHIP - Total population - In group quarters - Institutionalized population & Number; RELATIONSHIP - Total population - In group quarters - Noninstitutionalized population & Percent; RELATIONSHIP - Total population - In group quarters - Noninstitutionalized population & Number; HOUSEHOLDS BY TYPE - Total households & Percent; HOUSEHOLDS BY TYPE - Total households & Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) & Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) & Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - With own children under 18 years & Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - With own children under 18 years & Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family & Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family & Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family - With own children under 18 years & Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family - With own children under 18 years & Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present & Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present & Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present - With own children under 18 years & Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present - With own children under 18 years & Number; HOUSEHOLDS BY TYPE - Total households - Nonfamily households & Percent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households & Number; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone & Percent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone & Number; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone - Householder 65 years and over & Percent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone - Householder 65 years and over & Number; HOUSEHOLDS BY TYPE - Total households - Households with individuals under 18 years & Percent; HOUSEHOLDS BY TYPE - Total households - Households with individuals under 18 years & Number; HOUSEHOLDS BY TYPE - Total households - Households with individuals 65 years and over & Percent; HOUSEHOLDS BY TYPE - Total households - Households with individuals 65 years and over & Number; HOUSEHOLDS BY TYPE - Total households - Average household size & Percent; HOUSEHOLDS BY TYPE - Total households - Average household size & Number; HOUSEHOLDS BY TYPE - Total households - Average family size & Percent; HOUSEHOLDS BY TYPE - Total households - Average family size & Number; HOUSING OCCUPANCY - Total housing units & Percent; HOUSING OCCUPANCY - Total housing units & Number; HOUSING OCCUPANCY - Total housing units - Occupied housing units & Percent; HOUSING OCCUPANCY - Total housing units - Occupied housing units & Number; HOUSING OCCUPANCY - Total housing units - Vacant housing units & Percent; HOUSING OCCUPANCY - Total housing units - Vacant housing units & Number; HOUSING OCCUPANCY - Total housing units - Vacant housing units - For seasonal, recreational, or occasional use & Percent; HOUSING OCCUPANCY - Total housing units - Vacant housing units - For seasonal, recreational, or occasional use & Number; HOUSING OCCUPANCY - Total housing units - Homeowner vacancy rate (percent) & Percent; HOUSING OCCUPANCY - Total housing units - Homeowner vacancy rate (percent) & Number; HOUSING OCCUPANCY - Total housing units - Rental vacancy rate (percent) & Percent; HOUSING OCCUPANCY - Total housing units - Rental vacancy rate (percent) & Number; HOUSING TENURE - Occupied housing units & Percent; HOUSING TENURE - Occupied housing units & Number; HOUSING TENURE - Occupied housing units - Owner-occupied housing units & Percent; HOUSING TENURE - Occupied housing units - Owner-occupied housing units & Number; HOUSING TENURE - Occupied housing units - Renter-occupied housing units & Percent; HOUSING TENURE - Occupied housing units - Renter-occupied housing units & Number; HOUSING TENURE - Occupied housing units - Average household size of owner-occupied unit & Percent; HOUSING TENURE - Occupied housing units - Average household size of owner-occupied unit & Number; HOUSING TENURE - Occupied housing units - Average household size of renter-occupied unit & Percent; HOUSING TENURE - Occupied housing units - Average household size of renter-occupied unit\\\\\n", "\t2 & 1400000US22001960100 & 22001960100 & Census Tract 9601, Acadia Parish, Louisiana & 6,188 & 100 & 2,920 & 47 & 3,268 & 53 & 462 & 8 & 502 & 8 & 541 & 9 & 572 & 9 & 375 & 6 & 728 & 12 & 913 & 15 & 699 & 11 & 301 & 5 & 252 & 4 & 433 & 7 & 287 & 5 & 123 & 2 & 34 & (X) & 4,304 & 70 & 1,957 & 32 & 2,347 & 38 & 4,031 & 65 & 996 & 16 & 843 & 14 & 295 & 5 & 548 & 9 & 6,174 & 100 & 4,455 & 72 & 1,675 & 27 & 12 & 0 & 7 & 0 & 0 & 0 & 0 & 0 & 2 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 4 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 25 & 0 & 14 & 0 & 4,468 & 72 & 1,677 & 27 & 19 & 0 & 8 & 0 & 0 & 0 & 30 & 1 & 6,188 & 100 & 87 & 1 & 51 & 1 & 1 & 0 & 0 & 0 & 35 & 1 & 6,101 & 99 & 4,398 & 71 & 6,188 & 100 & 6,030 & 97 & 2,236 & 36 & 1,119 & 18 & 2,199 & 36 & 1,700 & 28 & 274 & 4 & 143 & 2 & 202 & 3 & 109 & 2 & 158 & 3 & 151 & 2 & 7 & 0 & 2,236 & 100 & 1,595 & 71 & 868 & 39 & 1,119 & 50 & 573 & 26 & 363 & 16 & 237 & 11 & 641 & 29 & 585 & 26 & 303 & 14 & 962 & 43 & 569 & 25 & 3 & (X) & 3 & (X) & 2,410 & 100 & 2,236 & 93 & 174 & 7 & 15 & 1 & 1 & (X) & 8 & (X) & 2,236 & 100 & 1,526 & 68 & 710 & 32 & 3 & (X) & 3 & (X)\\\\\n", "\t3 & 1400000US22001960200 & 22001960200 & Census Tract 9602, Acadia Parish, Louisiana & 5,056 & 100 & 2,562 & 51 & 2,494 & 49 & 346 & 7 & 416 & 8 & 476 & 9 & 463 & 9 & 298 & 6 & 579 & 12 & 861 & 17 & 709 & 14 & 250 & 5 & 203 & 4 & 263 & 5 & 150 & 3 & 42 & 1 & 34 & (X) & 3,527 & 70 & 1,758 & 35 & 1,769 & 35 & 3,289 & 65 & 570 & 11 & 455 & 9 & 217 & 4 & 238 & 5 & 5,035 & 100 & 4,799 & 95 & 216 & 4 & 6 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 13 & 0 & 21 & 0 & 4,816 & 95 & 226 & 5 & 13 & 0 & 6 & 0 & 4 & 0 & 16 & 0 & 5,056 & 100 & 35 & 1 & 18 & 0 & 0 & 0 & 0 & 0 & 17 & 0 & 5,021 & 99 & 4,775 & 94 & 5,056 & 100 & 5,056 & 100 & 1,764 & 35 & 1,216 & 24 & 1,791 & 35 & 1,413 & 28 & 173 & 3 & 86 & 2 & 112 & 2 & 61 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 1,764 & 100 & 1,408 & 80 & 722 & 41 & 1,216 & 69 & 617 & 35 & 134 & 8 & 81 & 5 & 356 & 20 & 310 & 18 & 128 & 7 & 781 & 44 & 339 & 19 & 3 & (X) & 3 & (X) & 1,909 & 100 & 1,764 & 92 & 145 & 8 & 31 & 2 & 1 & (X) & 7 & (X) & 1,764 & 100 & 1,461 & 83 & 303 & 17 & 3 & (X) & 3 & (X)\\\\\n", "\t4 & 1400000US22001960300 & 22001960300 & Census Tract 9603, Acadia Parish, Louisiana & 3,149 & 100 & 1,593 & 51 & 1,556 & 49 & 209 & 7 & 251 & 8 & 305 & 10 & 260 & 8 & 204 & 7 & 368 & 12 & 520 & 17 & 409 & 13 & 148 & 5 & 130 & 4 & 209 & 7 & 104 & 3 & 32 & 1 & 35 & (X) & 2,233 & 71 & 1,103 & 35 & 1,130 & 36 & 2,081 & 66 & 435 & 14 & 345 & 11 & 150 & 5 & 195 & 6 & 3,140 & 100 & 3,058 & 97 & 67 & 2 & 8 & 0 & 2 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 1 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 4 & 0 & 9 & 0 & 3,066 & 97 & 69 & 2 & 13 & 0 & 2 & 0 & 1 & 0 & 7 & 0 & 3,149 & 100 & 15 & 1 & 4 & 0 & 0 & 0 & 0 & 0 & 11 & 0 & 3,134 & 100 & 3,049 & 97 & 3,149 & 100 & 3,148 & 100 & 1,145 & 36 & 750 & 24 & 1,091 & 35 & 854 & 27 & 73 & 2 & 38 & 1 & 89 & 3 & 48 & 2 & 1 & 0 & 0 & 0 & 1 & 0 & 1,145 & 100 & 883 & 77 & 445 & 39 & 750 & 66 & 369 & 32 & 93 & 8 & 52 & 5 & 262 & 23 & 228 & 20 & 91 & 8 & 475 & 42 & 247 & 22 & 3 & (X) & 3 & (X) & 1,246 & 100 & 1,145 & 92 & 101 & 8 & 19 & 2 & 1 & (X) & 7 & (X) & 1,145 & 100 & 1,041 & 91 & 104 & 9 & 3 & (X) & 3 & (X)\\\\\n", "\t5 & 1400000US22001960400 & 22001960400 & Census Tract 9604, Acadia Parish, Louisiana & 5,617 & 100 & 2,754 & 49 & 2,863 & 51 & 429 & 8 & 406 & 7 & 520 & 9 & 476 & 9 & 353 & 6 & 691 & 12 & 914 & 16 & 684 & 12 & 254 & 5 & 222 & 4 & 410 & 7 & 193 & 3 & 65 & 1 & 34 & (X) & 3,944 & 70 & 1,911 & 34 & 2,033 & 36 & 3,716 & 66 & 800 & 14 & 668 & 12 & 302 & 5 & 366 & 7 & 5,583 & 99 & 5,347 & 95 & 207 & 4 & 18 & 0 & 6 & 0 & 1 & 0 & 1 & 0 & 4 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 5 & 0 & 34 & 1 & 5,381 & 96 & 211 & 4 & 43 & 1 & 8 & 0 & 0 & 0 & 9 & 0 & 5,617 & 100 & 43 & 1 & 24 & 0 & 0 & 0 & 0 & 0 & 19 & 0 & 5,574 & 99 & 5,307 & 95 & 5,617 & 100 & 5,592 & 100 & 1,991 & 35 & 1,291 & 23 & 1,994 & 36 & 1,554 & 28 & 196 & 4 & 101 & 2 & 120 & 2 & 70 & 1 & 25 & 0 & 10 & 0 & 15 & 0 & 1,991 & 100 & 1,555 & 78 & 804 & 40 & 1,291 & 65 & 641 & 32 & 168 & 8 & 99 & 5 & 436 & 22 & 388 & 20 & 189 & 10 & 861 & 43 & 482 & 24 & 3 & (X) & 3 & (X) & 2,176 & 100 & 1,991 & 92 & 185 & 9 & 23 & 1 & 1 & (X) & 6 & (X) & 1,991 & 100 & 1,630 & 82 & 361 & 18 & 3 & (X) & 3 & (X)\\\\\n", "\t6 & 1400000US22001960500 & 22001960500 & Census Tract 9605, Acadia Parish, Louisiana & 4,927 & 100 & 2,461 & 50 & 2,466 & 50 & 400 & 8 & 438 & 9 & 439 & 9 & 418 & 9 & 319 & 7 & 704 & 14 & 777 & 16 & 644 & 13 & 227 & 5 & 154 & 3 & 234 & 5 & 134 & 3 & 39 & 1 & 32 & (X) & 3,405 & 69 & 1,675 & 34 & 1,730 & 35 & 3,162 & 64 & 499 & 10 & 407 & 8 & 167 & 3 & 240 & 5 & 4,901 & 100 & 4,498 & 91 & 378 & 8 & 15 & 0 & 4 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 3 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 5 & 0 & 26 & 1 & 4,524 & 92 & 385 & 8 & 35 & 1 & 4 & 0 & 1 & 0 & 9 & 0 & 4,927 & 100 & 61 & 1 & 37 & 1 & 1 & 0 & 0 & 0 & 23 & 1 & 4,866 & 99 & 4,448 & 90 & 4,927 & 100 & 4,921 & 100 & 1,692 & 34 & 1,068 & 22 & 1,809 & 37 & 1,418 & 29 & 174 & 4 & 71 & 1 & 178 & 4 & 100 & 2 & 6 & 0 & 0 & 0 & 6 & 0 & 1,692 & 100 & 1,326 & 78 & 762 & 45 & 1,068 & 63 & 611 & 36 & 182 & 11 & 103 & 6 & 366 & 22 & 300 & 18 & 136 & 8 & 808 & 48 & 316 & 19 & 3 & (X) & 3 & (X) & 1,796 & 100 & 1,692 & 94 & 104 & 6 & 22 & 1 & 1 & (X) & 5 & (X) & 1,692 & 100 & 1,419 & 84 & 273 & 16 & 3 & (X) & 3 & (X)\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " GEO.id GEO.id2 GEO.display.label\n", "1 Id Id2 Geography\n", "2 1400000US22001960100 22001960100 Census Tract 9601, Acadia Parish, Louisiana\n", "3 1400000US22001960200 22001960200 Census Tract 9602, Acadia Parish, Louisiana\n", "4 1400000US22001960300 22001960300 Census Tract 9603, Acadia Parish, Louisiana\n", "5 1400000US22001960400 22001960400 Census Tract 9604, Acadia Parish, Louisiana\n", "6 1400000US22001960500 22001960500 Census Tract 9605, Acadia Parish, Louisiana\n", " HC01_VC01 HC02_VC01\n", "1 Number; Total population Percent; Total population\n", "2 6,188 100\n", "3 5,056 100\n", "4 3,149 100\n", "5 5,617 100\n", "6 4,927 100\n", " HC01_VC03\n", "1 Number; Total population - SEX AND AGE - Male\n", "2 2,920\n", "3 2,562\n", "4 1,593\n", "5 2,754\n", "6 2,461\n", " HC02_VC03\n", "1 Percent; Total population - SEX AND AGE - Male\n", "2 47\n", "3 51\n", "4 51\n", "5 49\n", "6 50\n", " HC01_VC04\n", "1 Number; Total population - SEX AND AGE - Female\n", "2 3,268\n", "3 2,494\n", "4 1,556\n", "5 2,863\n", "6 2,466\n", " HC02_VC04\n", "1 Percent; Total population - SEX AND AGE - Female\n", "2 53\n", "3 49\n", "4 49\n", "5 51\n", "6 50\n", " HC01_VC05\n", "1 Number; Total population - SEX AND AGE - Under 5 years\n", "2 462\n", "3 346\n", "4 209\n", "5 429\n", "6 400\n", " HC02_VC05\n", "1 Percent; Total population - SEX AND AGE - Under 5 years\n", "2 8\n", "3 7\n", "4 7\n", "5 8\n", "6 8\n", " HC01_VC06\n", "1 Number; Total population - SEX AND AGE - 5 to 9 years\n", "2 502\n", "3 416\n", "4 251\n", "5 406\n", "6 438\n", " HC02_VC06\n", "1 Percent; Total population - SEX AND AGE - 5 to 9 years\n", "2 8\n", "3 8\n", "4 8\n", "5 7\n", "6 9\n", " HC01_VC07\n", "1 Number; Total population - SEX AND AGE - 10 to 14 years\n", "2 541\n", "3 476\n", "4 305\n", "5 520\n", "6 439\n", " HC02_VC07\n", "1 Percent; Total population - SEX AND AGE - 10 to 14 years\n", "2 9\n", "3 9\n", "4 10\n", "5 9\n", "6 9\n", " HC01_VC08\n", "1 Number; Total population - SEX AND AGE - 15 to 19 years\n", "2 572\n", "3 463\n", "4 260\n", "5 476\n", "6 418\n", " HC02_VC08\n", "1 Percent; Total population - SEX AND AGE - 15 to 19 years\n", "2 9\n", "3 9\n", "4 8\n", "5 9\n", "6 9\n", " HC01_VC09\n", "1 Number; Total population - SEX AND AGE - 20 to 24 years\n", "2 375\n", "3 298\n", "4 204\n", "5 353\n", "6 319\n", " HC02_VC09\n", "1 Percent; Total population - SEX AND AGE - 20 to 24 years\n", "2 6\n", "3 6\n", "4 7\n", "5 6\n", "6 7\n", " HC01_VC10\n", "1 Number; Total population - SEX AND AGE - 25 to 34 years\n", "2 728\n", "3 579\n", "4 368\n", "5 691\n", "6 704\n", " HC02_VC10\n", "1 Percent; Total population - SEX AND AGE - 25 to 34 years\n", "2 12\n", "3 12\n", "4 12\n", "5 12\n", "6 14\n", " HC01_VC11\n", "1 Number; Total population - SEX AND AGE - 35 to 44 years\n", "2 913\n", "3 861\n", "4 520\n", "5 914\n", "6 777\n", " HC02_VC11\n", "1 Percent; Total population - SEX AND AGE - 35 to 44 years\n", "2 15\n", "3 17\n", "4 17\n", "5 16\n", "6 16\n", " HC01_VC12\n", "1 Number; Total population - SEX AND AGE - 45 to 54 years\n", "2 699\n", "3 709\n", "4 409\n", "5 684\n", "6 644\n", " HC02_VC12\n", "1 Percent; Total population - SEX AND AGE - 45 to 54 years\n", "2 11\n", "3 14\n", "4 13\n", "5 12\n", "6 13\n", " HC01_VC13\n", "1 Number; Total population - SEX AND AGE - 55 to 59 years\n", "2 301\n", "3 250\n", "4 148\n", "5 254\n", "6 227\n", " HC02_VC13\n", "1 Percent; Total population - SEX AND AGE - 55 to 59 years\n", "2 5\n", "3 5\n", "4 5\n", "5 5\n", "6 5\n", " HC01_VC14\n", "1 Number; Total population - SEX AND AGE - 60 to 64 years\n", "2 252\n", "3 203\n", "4 130\n", "5 222\n", "6 154\n", " HC02_VC14\n", "1 Percent; Total population - SEX AND AGE - 60 to 64 years\n", "2 4\n", "3 4\n", "4 4\n", "5 4\n", "6 3\n", " HC01_VC15\n", "1 Number; Total population - SEX AND AGE - 65 to 74 years\n", "2 433\n", "3 263\n", "4 209\n", "5 410\n", "6 234\n", " HC02_VC15\n", "1 Percent; Total population - SEX AND AGE - 65 to 74 years\n", "2 7\n", "3 5\n", "4 7\n", "5 7\n", "6 5\n", " HC01_VC16\n", "1 Number; Total population - SEX AND AGE - 75 to 84 years\n", "2 287\n", "3 150\n", "4 104\n", "5 193\n", "6 134\n", " HC02_VC16\n", "1 Percent; Total population - SEX AND AGE - 75 to 84 years\n", "2 5\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " HC01_VC17\n", "1 Number; Total population - SEX AND AGE - 85 years and over\n", "2 123\n", "3 42\n", "4 32\n", "5 65\n", "6 39\n", " HC02_VC17\n", "1 Percent; Total population - SEX AND AGE - 85 years and over\n", "2 2\n", "3 1\n", "4 1\n", "5 1\n", "6 1\n", " HC01_VC18\n", "1 Number; Total population - SEX AND AGE - Median age (years)\n", "2 34\n", "3 34\n", "4 35\n", "5 34\n", "6 32\n", " HC02_VC18\n", "1 Percent; Total population - SEX AND AGE - Median age (years)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " HC01_VC19\n", "1 Number; Total population - SEX AND AGE - 18 years and over\n", "2 4,304\n", "3 3,527\n", "4 2,233\n", "5 3,944\n", "6 3,405\n", " HC02_VC19\n", "1 Percent; Total population - SEX AND AGE - 18 years and over\n", "2 70\n", "3 70\n", "4 71\n", "5 70\n", "6 69\n", " HC01_VC20\n", "1 Number; Total population - SEX AND AGE - 18 years and over - Male\n", "2 1,957\n", "3 1,758\n", "4 1,103\n", "5 1,911\n", "6 1,675\n", " HC02_VC20\n", "1 Percent; Total population - SEX AND AGE - 18 years and over - Male\n", "2 32\n", "3 35\n", "4 35\n", "5 34\n", "6 34\n", " HC01_VC21\n", "1 Number; Total population - SEX AND AGE - 18 years and over - Female\n", "2 2,347\n", "3 1,769\n", "4 1,130\n", "5 2,033\n", "6 1,730\n", " HC02_VC21\n", "1 Percent; Total population - SEX AND AGE - 18 years and over - Female\n", "2 38\n", "3 35\n", "4 36\n", "5 36\n", "6 35\n", " HC01_VC22\n", "1 Number; Total population - SEX AND AGE - 21 years and over\n", "2 4,031\n", "3 3,289\n", "4 2,081\n", "5 3,716\n", "6 3,162\n", " HC02_VC22\n", "1 Percent; Total population - SEX AND AGE - 21 years and over\n", "2 65\n", "3 65\n", "4 66\n", "5 66\n", "6 64\n", " HC01_VC23\n", "1 Number; Total population - SEX AND AGE - 62 years and over\n", "2 996\n", "3 570\n", "4 435\n", "5 800\n", "6 499\n", " HC02_VC23\n", "1 Percent; Total population - SEX AND AGE - 62 years and over\n", "2 16\n", "3 11\n", "4 14\n", "5 14\n", "6 10\n", " HC01_VC24\n", "1 Number; Total population - SEX AND AGE - 65 years and over\n", "2 843\n", "3 455\n", "4 345\n", "5 668\n", "6 407\n", " HC02_VC24\n", "1 Percent; Total population - SEX AND AGE - 65 years and over\n", "2 14\n", "3 9\n", "4 11\n", "5 12\n", "6 8\n", " HC01_VC25\n", "1 Number; Total population - SEX AND AGE - 65 years and over - Male\n", "2 295\n", "3 217\n", "4 150\n", "5 302\n", "6 167\n", " HC02_VC25\n", "1 Percent; Total population - SEX AND AGE - 65 years and over - Male\n", "2 5\n", "3 4\n", "4 5\n", "5 5\n", "6 3\n", " HC01_VC26\n", "1 Number; Total population - SEX AND AGE - 65 years and over - Female\n", "2 548\n", "3 238\n", "4 195\n", "5 366\n", "6 240\n", " HC02_VC26\n", "1 Percent; Total population - SEX AND AGE - 65 years and over - Female\n", "2 9\n", "3 5\n", "4 6\n", "5 7\n", "6 5\n", " HC01_VC28\n", "1 Number; Total population - RACE - One race\n", "2 6,174\n", "3 5,035\n", "4 3,140\n", "5 5,583\n", "6 4,901\n", " HC02_VC28\n", "1 Percent; Total population - RACE - One race\n", "2 100\n", "3 100\n", "4 100\n", "5 99\n", "6 100\n", " HC01_VC29\n", "1 Number; Total population - RACE - One race - White\n", "2 4,455\n", "3 4,799\n", "4 3,058\n", "5 5,347\n", "6 4,498\n", " HC02_VC29\n", "1 Percent; Total population - RACE - One race - White\n", "2 72\n", "3 95\n", "4 97\n", "5 95\n", "6 91\n", " HC01_VC30\n", "1 Number; Total population - RACE - One race - Black or African American\n", "2 1,675\n", "3 216\n", "4 67\n", "5 207\n", "6 378\n", " HC02_VC30\n", "1 Percent; Total population - RACE - One race - Black or African American\n", "2 27\n", "3 4\n", "4 2\n", "5 4\n", "6 8\n", " HC01_VC31\n", "1 Number; Total population - RACE - One race - American Indian and Alaska Native\n", "2 12\n", "3 6\n", "4 8\n", "5 18\n", "6 15\n", " HC02_VC31\n", "1 Percent; Total population - RACE - One race - American Indian and Alaska Native\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC32\n", "1 Number; Total population - RACE - One race - Asian\n", "2 7\n", "3 1\n", "4 2\n", "5 6\n", "6 4\n", " HC02_VC32\n", "1 Percent; Total population - RACE - One race - Asian\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC33\n", "1 Number; Total population - RACE - One race - Asian - Asian Indian\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 0\n", " HC02_VC33\n", "1 Percent; Total population - RACE - One race - Asian - Asian Indian\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC34\n", "1 Number; Total population - RACE - One race - Asian - Chinese\n", "2 0\n", "3 0\n", "4 1\n", "5 1\n", "6 0\n", " HC02_VC34\n", "1 Percent; Total population - RACE - One race - Asian - Chinese\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC35\n", "1 Number; Total population - RACE - One race - Asian - Filipino\n", "2 2\n", "3 0\n", "4 0\n", "5 4\n", "6 1\n", " HC02_VC35\n", "1 Percent; Total population - RACE - One race - Asian - Filipino\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC36\n", "1 Number; Total population - RACE - One race - Asian - Japanese\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC02_VC36\n", "1 Percent; Total population - RACE - One race - Asian - Japanese\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC37\n", "1 Number; Total population - RACE - One race - Asian - Korean\n", "2 1\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC02_VC37\n", "1 Percent; Total population - RACE - One race - Asian - Korean\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC38\n", "1 Number; Total population - RACE - One race - Asian - Vietnamese\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 3\n", " HC02_VC38\n", "1 Percent; Total population - RACE - One race - Asian - Vietnamese\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC39\n", "1 Number; Total population - RACE - One race - Asian - Other Asian [1]\n", "2 4\n", "3 1\n", "4 1\n", "5 0\n", "6 0\n", " HC02_VC39\n", "1 Percent; Total population - RACE - One race - Asian - Other Asian [1]\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC40\n", "1 Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander\n", "2 0\n", "3 0\n", "4 1\n", "5 0\n", "6 1\n", " HC02_VC40\n", "1 Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC41\n", "1 Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Native Hawaiian\n", "2 0\n", "3 0\n", "4 1\n", "5 0\n", "6 0\n", " HC02_VC41\n", "1 Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Native Hawaiian\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC42\n", "1 Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Guamanian or Chamorro\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC02_VC42\n", "1 Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Guamanian or Chamorro\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC43\n", "1 Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Samoan\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 1\n", " HC02_VC43\n", "1 Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Samoan\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC44\n", "1 Number; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Other Pacific Islander [2]\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC02_VC44\n", "1 Percent; Total population - RACE - One race - Native Hawaiian and Other Pacific Islander - Other Pacific Islander [2]\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC45\n", "1 Number; Total population - RACE - One race - Some other race\n", "2 25\n", "3 13\n", "4 4\n", "5 5\n", "6 5\n", " HC02_VC45\n", "1 Percent; Total population - RACE - One race - Some other race\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC46\n", "1 Number; Total population - RACE - Two or more races\n", "2 14\n", "3 21\n", "4 9\n", "5 34\n", "6 26\n", " HC02_VC46\n", "1 Percent; Total population - RACE - Two or more races\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 1\n", " HC01_VC48\n", "1 Number; Total population - RACE - Race alone or in combination with one or more other races [3] - White\n", "2 4,468\n", "3 4,816\n", "4 3,066\n", "5 5,381\n", "6 4,524\n", " HC02_VC48\n", "1 Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - White\n", "2 72\n", "3 95\n", "4 97\n", "5 96\n", "6 92\n", " HC01_VC49\n", "1 Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Black or African American\n", "2 1,677\n", "3 226\n", "4 69\n", "5 211\n", "6 385\n", " HC02_VC49\n", "1 Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Black or African American\n", "2 27\n", "3 5\n", "4 2\n", "5 4\n", "6 8\n", " HC01_VC50\n", "1 Number; Total population - RACE - Race alone or in combination with one or more other races [3] - American Indian and Alaska Native\n", "2 19\n", "3 13\n", "4 13\n", "5 43\n", "6 35\n", " HC02_VC50\n", "1 Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - American Indian and Alaska Native\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 1\n", " HC01_VC51\n", "1 Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Asian\n", "2 8\n", "3 6\n", "4 2\n", "5 8\n", "6 4\n", " HC02_VC51\n", "1 Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Asian\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC52\n", "1 Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Native Hawaiian and Other Pacific Islander\n", "2 0\n", "3 4\n", "4 1\n", "5 0\n", "6 1\n", " HC02_VC52\n", "1 Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Native Hawaiian and Other Pacific Islander\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC53\n", "1 Number; Total population - RACE - Race alone or in combination with one or more other races [3] - Some other race\n", "2 30\n", "3 16\n", "4 7\n", "5 9\n", "6 9\n", " HC02_VC53\n", "1 Percent; Total population - RACE - Race alone or in combination with one or more other races [3] - Some other race\n", "2 1\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC55\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population\n", "2 6,188\n", "3 5,056\n", "4 3,149\n", "5 5,617\n", "6 4,927\n", " HC02_VC55\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " HC01_VC56\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race)\n", "2 87\n", "3 35\n", "4 15\n", "5 43\n", "6 61\n", " HC02_VC56\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race)\n", "2 1\n", "3 1\n", "4 1\n", "5 1\n", "6 1\n", " HC01_VC57\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Mexican\n", "2 51\n", "3 18\n", "4 4\n", "5 24\n", "6 37\n", " HC02_VC57\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Mexican\n", "2 1\n", "3 0\n", "4 0\n", "5 0\n", "6 1\n", " HC01_VC58\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Puerto Rican\n", "2 1\n", "3 0\n", "4 0\n", "5 0\n", "6 1\n", " HC02_VC58\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Puerto Rican\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC59\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Cuban\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC02_VC59\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Cuban\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC60\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Other Hispanic or Latino\n", "2 35\n", "3 17\n", "4 11\n", "5 19\n", "6 23\n", " HC02_VC60\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Hispanic or Latino (of any race) - Other Hispanic or Latino\n", "2 1\n", "3 0\n", "4 0\n", "5 0\n", "6 1\n", " HC01_VC61\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino\n", "2 6,101\n", "3 5,021\n", "4 3,134\n", "5 5,574\n", "6 4,866\n", " HC02_VC61\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino\n", "2 99\n", "3 99\n", "4 100\n", "5 99\n", "6 99\n", " HC01_VC62\n", "1 Number; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino - White alone\n", "2 4,398\n", "3 4,775\n", "4 3,049\n", "5 5,307\n", "6 4,448\n", " HC02_VC62\n", "1 Percent; HISPANIC OR LATINO AND RACE - Total population - Not Hispanic or Latino - White alone\n", "2 71\n", "3 94\n", "4 97\n", "5 95\n", "6 90\n", " HC01_VC64\n", "1 Number; RELATIONSHIP - Total population\n", "2 6,188\n", "3 5,056\n", "4 3,149\n", "5 5,617\n", "6 4,927\n", " HC02_VC64\n", "1 Percent; RELATIONSHIP - Total population\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " HC01_VC65\n", "1 Number; RELATIONSHIP - Total population - In households\n", "2 6,030\n", "3 5,056\n", "4 3,148\n", "5 5,592\n", "6 4,921\n", " HC02_VC65\n", "1 Percent; RELATIONSHIP - Total population - In households\n", "2 97\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " HC01_VC66\n", "1 Number; RELATIONSHIP - Total population - In households - Householder\n", "2 2,236\n", "3 1,764\n", "4 1,145\n", "5 1,991\n", "6 1,692\n", " HC02_VC66\n", "1 Percent; RELATIONSHIP - Total population - In households - Householder\n", "2 36\n", "3 35\n", "4 36\n", "5 35\n", "6 34\n", " HC01_VC67\n", "1 Number; RELATIONSHIP - Total population - In households - Spouse\n", "2 1,119\n", "3 1,216\n", "4 750\n", "5 1,291\n", "6 1,068\n", " HC02_VC67\n", "1 Percent; RELATIONSHIP - Total population - In households - Spouse\n", "2 18\n", "3 24\n", "4 24\n", "5 23\n", "6 22\n", " HC01_VC68\n", "1 Number; RELATIONSHIP - Total population - In households - Child\n", "2 2,199\n", "3 1,791\n", "4 1,091\n", "5 1,994\n", "6 1,809\n", " HC02_VC68\n", "1 Percent; RELATIONSHIP - Total population - In households - Child\n", "2 36\n", "3 35\n", "4 35\n", "5 36\n", "6 37\n", " HC01_VC69\n", "1 Number; RELATIONSHIP - Total population - In households - Child - Own child under 18 years\n", "2 1,700\n", "3 1,413\n", "4 854\n", "5 1,554\n", "6 1,418\n", " HC02_VC69\n", "1 Percent; RELATIONSHIP - Total population - In households - Child - Own child under 18 years\n", "2 28\n", "3 28\n", "4 27\n", "5 28\n", "6 29\n", " HC01_VC70\n", "1 Number; RELATIONSHIP - Total population - In households - Other relatives\n", "2 274\n", "3 173\n", "4 73\n", "5 196\n", "6 174\n", " HC02_VC70\n", "1 Percent; RELATIONSHIP - Total population - In households - Other relatives\n", "2 4\n", "3 3\n", "4 2\n", "5 4\n", "6 4\n", " HC01_VC71\n", "1 Number; RELATIONSHIP - Total population - In households - Other relatives - Under 18 years\n", "2 143\n", "3 86\n", "4 38\n", "5 101\n", "6 71\n", " HC02_VC71\n", "1 Percent; RELATIONSHIP - Total population - In households - Other relatives - Under 18 years\n", "2 2\n", "3 2\n", "4 1\n", "5 2\n", "6 1\n", " HC01_VC72\n", "1 Number; RELATIONSHIP - Total population - In households - Nonrelatives\n", "2 202\n", "3 112\n", "4 89\n", "5 120\n", "6 178\n", " HC02_VC72\n", "1 Percent; RELATIONSHIP - Total population - In households - Nonrelatives\n", "2 3\n", "3 2\n", "4 3\n", "5 2\n", "6 4\n", " HC01_VC73\n", "1 Number; RELATIONSHIP - Total population - In households - Nonrelatives - Unmarried partner\n", "2 109\n", "3 61\n", "4 48\n", "5 70\n", "6 100\n", " HC02_VC73\n", "1 Percent; RELATIONSHIP - Total population - In households - Nonrelatives - Unmarried partner\n", "2 2\n", "3 1\n", "4 2\n", "5 1\n", "6 2\n", " HC01_VC74\n", "1 Number; RELATIONSHIP - Total population - In group quarters\n", "2 158\n", "3 0\n", "4 1\n", "5 25\n", "6 6\n", " HC02_VC74\n", "1 Percent; RELATIONSHIP - Total population - In group quarters\n", "2 3\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC75\n", "1 Number; RELATIONSHIP - Total population - In group quarters - Institutionalized population\n", "2 151\n", "3 0\n", "4 0\n", "5 10\n", "6 0\n", " HC02_VC75\n", "1 Percent; RELATIONSHIP - Total population - In group quarters - Institutionalized population\n", "2 2\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC76\n", "1 Number; RELATIONSHIP - Total population - In group quarters - Noninstitutionalized population\n", "2 7\n", "3 0\n", "4 1\n", "5 15\n", "6 6\n", " HC02_VC76\n", "1 Percent; RELATIONSHIP - Total population - In group quarters - Noninstitutionalized population\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " HC01_VC78\n", "1 Number; HOUSEHOLDS BY TYPE - Total households\n", "2 2,236\n", "3 1,764\n", "4 1,145\n", "5 1,991\n", "6 1,692\n", " HC02_VC78\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " HC01_VC79\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Family households (families)\n", "2 1,595\n", "3 1,408\n", "4 883\n", "5 1,555\n", "6 1,326\n", " HC02_VC79\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families)\n", "2 71\n", "3 80\n", "4 77\n", "5 78\n", "6 78\n", " HC01_VC80\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - With own children under 18 years\n", "2 868\n", "3 722\n", "4 445\n", "5 804\n", "6 762\n", " HC02_VC80\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - With own children under 18 years\n", "2 39\n", "3 41\n", "4 39\n", "5 40\n", "6 45\n", " HC01_VC81\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family\n", "2 1,119\n", "3 1,216\n", "4 750\n", "5 1,291\n", "6 1,068\n", " HC02_VC81\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family\n", "2 50\n", "3 69\n", "4 66\n", "5 65\n", "6 63\n", " HC01_VC82\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family - With own children under 18 years\n", "2 573\n", "3 617\n", "4 369\n", "5 641\n", "6 611\n", " HC02_VC82\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Married-couple family - With own children under 18 years\n", "2 26\n", "3 35\n", "4 32\n", "5 32\n", "6 36\n", " HC01_VC83\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present\n", "2 363\n", "3 134\n", "4 93\n", "5 168\n", "6 182\n", " HC02_VC83\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present\n", "2 16\n", "3 8\n", "4 8\n", "5 8\n", "6 11\n", " HC01_VC84\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present - With own children under 18 years\n", "2 237\n", "3 81\n", "4 52\n", "5 99\n", "6 103\n", " HC02_VC84\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Family households (families) - Female householder, no husband present - With own children under 18 years\n", "2 11\n", "3 5\n", "4 5\n", "5 5\n", "6 6\n", " HC01_VC85\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Nonfamily households\n", "2 641\n", "3 356\n", "4 262\n", "5 436\n", "6 366\n", " HC02_VC85\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households\n", "2 29\n", "3 20\n", "4 23\n", "5 22\n", "6 22\n", " HC01_VC86\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone\n", "2 585\n", "3 310\n", "4 228\n", "5 388\n", "6 300\n", " HC02_VC86\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone\n", "2 26\n", "3 18\n", "4 20\n", "5 20\n", "6 18\n", " HC01_VC87\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone - Householder 65 years and over\n", "2 303\n", "3 128\n", "4 91\n", "5 189\n", "6 136\n", " HC02_VC87\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Nonfamily households - Householder living alone - Householder 65 years and over\n", "2 14\n", "3 7\n", "4 8\n", "5 10\n", "6 8\n", " HC01_VC88\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Households with individuals under 18 years\n", "2 962\n", "3 781\n", "4 475\n", "5 861\n", "6 808\n", " HC02_VC88\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Households with individuals under 18 years\n", "2 43\n", "3 44\n", "4 42\n", "5 43\n", "6 48\n", " HC01_VC89\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Households with individuals 65 years and over\n", "2 569\n", "3 339\n", "4 247\n", "5 482\n", "6 316\n", " HC02_VC89\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Households with individuals 65 years and over\n", "2 25\n", "3 19\n", "4 22\n", "5 24\n", "6 19\n", " HC01_VC90\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Average household size\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " HC02_VC90\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Average household size\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " HC01_VC91\n", "1 Number; HOUSEHOLDS BY TYPE - Total households - Average family size\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " HC02_VC91\n", "1 Percent; HOUSEHOLDS BY TYPE - Total households - Average family size\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " HC01_VC93\n", "1 Number; HOUSING OCCUPANCY - Total housing units\n", "2 2,410\n", "3 1,909\n", "4 1,246\n", "5 2,176\n", "6 1,796\n", " HC02_VC93\n", "1 Percent; HOUSING OCCUPANCY - Total housing units\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " HC01_VC94\n", "1 Number; HOUSING OCCUPANCY - Total housing units - Occupied housing units\n", "2 2,236\n", "3 1,764\n", "4 1,145\n", "5 1,991\n", "6 1,692\n", " HC02_VC94\n", "1 Percent; HOUSING OCCUPANCY - Total housing units - Occupied housing units\n", "2 93\n", "3 92\n", "4 92\n", "5 92\n", "6 94\n", " HC01_VC95\n", "1 Number; HOUSING OCCUPANCY - Total housing units - Vacant housing units\n", "2 174\n", "3 145\n", "4 101\n", "5 185\n", "6 104\n", " HC02_VC95\n", "1 Percent; HOUSING OCCUPANCY - Total housing units - Vacant housing units\n", "2 7\n", "3 8\n", "4 8\n", "5 9\n", "6 6\n", " HC01_VC96\n", "1 Number; HOUSING OCCUPANCY - Total housing units - Vacant housing units - For seasonal, recreational, or occasional use\n", "2 15\n", "3 31\n", "4 19\n", "5 23\n", "6 22\n", " HC02_VC96\n", "1 Percent; HOUSING OCCUPANCY - Total housing units - Vacant housing units - For seasonal, recreational, or occasional use\n", "2 1\n", "3 2\n", "4 2\n", "5 1\n", "6 1\n", " HC01_VC97\n", "1 Number; HOUSING OCCUPANCY - Total housing units - Homeowner vacancy rate (percent)\n", "2 1\n", "3 1\n", "4 1\n", "5 1\n", "6 1\n", " HC02_VC97\n", "1 Percent; HOUSING OCCUPANCY - Total housing units - Homeowner vacancy rate (percent)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " HC01_VC98\n", "1 Number; HOUSING OCCUPANCY - Total housing units - Rental vacancy rate (percent)\n", "2 8\n", "3 7\n", "4 7\n", "5 6\n", "6 5\n", " HC02_VC98\n", "1 Percent; HOUSING OCCUPANCY - Total housing units - Rental vacancy rate (percent)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " HC01_VC100\n", "1 Number; HOUSING TENURE - Occupied housing units\n", "2 2,236\n", "3 1,764\n", "4 1,145\n", "5 1,991\n", "6 1,692\n", " HC02_VC100\n", "1 Percent; HOUSING TENURE - Occupied housing units\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " HC01_VC101\n", "1 Number; HOUSING TENURE - Occupied housing units - Owner-occupied housing units\n", "2 1,526\n", "3 1,461\n", "4 1,041\n", "5 1,630\n", "6 1,419\n", " HC02_VC101\n", "1 Percent; HOUSING TENURE - Occupied housing units - Owner-occupied housing units\n", "2 68\n", "3 83\n", "4 91\n", "5 82\n", "6 84\n", " HC01_VC102\n", "1 Number; HOUSING TENURE - Occupied housing units - Renter-occupied housing units\n", "2 710\n", "3 303\n", "4 104\n", "5 361\n", "6 273\n", " HC02_VC102\n", "1 Percent; HOUSING TENURE - Occupied housing units - Renter-occupied housing units\n", "2 32\n", "3 17\n", "4 9\n", "5 18\n", "6 16\n", " HC01_VC103\n", "1 Number; HOUSING TENURE - Occupied housing units - Average household size of owner-occupied unit\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " HC02_VC103\n", "1 Percent; HOUSING TENURE - Occupied housing units - Average household size of owner-occupied unit\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " HC01_VC104\n", "1 Number; HOUSING TENURE - Occupied housing units - Average household size of renter-occupied unit\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " HC02_VC104\n", "1 Percent; HOUSING TENURE - Occupied housing units - Average household size of renter-occupied unit\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "head(census2000)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Upon inspection, we can see that the file came with two header rows. R, by default, takes the first row of a CSV to be the header. We clearly do not need the first one so we can rerun the `read.csv` command and tell it so:" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "census2000 <- read.csv('2000_census_demographic_profile.csv', skip = 1)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
IdId2GeographyNumber..Total.populationPercent..Total.populationNumber..Total.population...SEX.AND.AGE...MalePercent..Total.population...SEX.AND.AGE...MaleNumber..Total.population...SEX.AND.AGE...FemalePercent..Total.population...SEX.AND.AGE...FemaleNumber..Total.population...SEX.AND.AGE...Under.5.yearsPercent..Total.population...SEX.AND.AGE...Under.5.yearsNumber..Total.population...SEX.AND.AGE...5.to.9.yearsPercent..Total.population...SEX.AND.AGE...5.to.9.yearsNumber..Total.population...SEX.AND.AGE...10.to.14.yearsPercent..Total.population...SEX.AND.AGE...10.to.14.yearsNumber..Total.population...SEX.AND.AGE...15.to.19.yearsPercent..Total.population...SEX.AND.AGE...15.to.19.yearsNumber..Total.population...SEX.AND.AGE...20.to.24.yearsPercent..Total.population...SEX.AND.AGE...20.to.24.yearsNumber..Total.population...SEX.AND.AGE...25.to.34.yearsPercent..Total.population...SEX.AND.AGE...25.to.34.yearsNumber..Total.population...SEX.AND.AGE...35.to.44.yearsPercent..Total.population...SEX.AND.AGE...35.to.44.yearsNumber..Total.population...SEX.AND.AGE...45.to.54.yearsPercent..Total.population...SEX.AND.AGE...45.to.54.yearsNumber..Total.population...SEX.AND.AGE...55.to.59.yearsPercent..Total.population...SEX.AND.AGE...55.to.59.yearsNumber..Total.population...SEX.AND.AGE...60.to.64.yearsPercent..Total.population...SEX.AND.AGE...60.to.64.yearsNumber..Total.population...SEX.AND.AGE...65.to.74.yearsPercent..Total.population...SEX.AND.AGE...65.to.74.yearsNumber..Total.population...SEX.AND.AGE...75.to.84.yearsPercent..Total.population...SEX.AND.AGE...75.to.84.yearsNumber..Total.population...SEX.AND.AGE...85.years.and.overPercent..Total.population...SEX.AND.AGE...85.years.and.overNumber..Total.population...SEX.AND.AGE...Median.age..years.Percent..Total.population...SEX.AND.AGE...Median.age..years.Number..Total.population...SEX.AND.AGE...18.years.and.overPercent..Total.population...SEX.AND.AGE...18.years.and.overNumber..Total.population...SEX.AND.AGE...18.years.and.over...MalePercent..Total.population...SEX.AND.AGE...18.years.and.over...MaleNumber..Total.population...SEX.AND.AGE...18.years.and.over...FemalePercent..Total.population...SEX.AND.AGE...18.years.and.over...FemaleNumber..Total.population...SEX.AND.AGE...21.years.and.overPercent..Total.population...SEX.AND.AGE...21.years.and.overNumber..Total.population...SEX.AND.AGE...62.years.and.overPercent..Total.population...SEX.AND.AGE...62.years.and.overNumber..Total.population...SEX.AND.AGE...65.years.and.overPercent..Total.population...SEX.AND.AGE...65.years.and.overNumber..Total.population...SEX.AND.AGE...65.years.and.over...MalePercent..Total.population...SEX.AND.AGE...65.years.and.over...MaleNumber..Total.population...SEX.AND.AGE...65.years.and.over...FemalePercent..Total.population...SEX.AND.AGE...65.years.and.over...FemaleNumber..Total.population...RACE...One.racePercent..Total.population...RACE...One.raceNumber..Total.population...RACE...One.race...WhitePercent..Total.population...RACE...One.race...WhiteNumber..Total.population...RACE...One.race...Black.or.African.AmericanPercent..Total.population...RACE...One.race...Black.or.African.AmericanNumber..Total.population...RACE...One.race...American.Indian.and.Alaska.NativePercent..Total.population...RACE...One.race...American.Indian.and.Alaska.NativeNumber..Total.population...RACE...One.race...AsianPercent..Total.population...RACE...One.race...AsianNumber..Total.population...RACE...One.race...Asian...Asian.IndianPercent..Total.population...RACE...One.race...Asian...Asian.IndianNumber..Total.population...RACE...One.race...Asian...ChinesePercent..Total.population...RACE...One.race...Asian...ChineseNumber..Total.population...RACE...One.race...Asian...FilipinoPercent..Total.population...RACE...One.race...Asian...FilipinoNumber..Total.population...RACE...One.race...Asian...JapanesePercent..Total.population...RACE...One.race...Asian...JapaneseNumber..Total.population...RACE...One.race...Asian...KoreanPercent..Total.population...RACE...One.race...Asian...KoreanNumber..Total.population...RACE...One.race...Asian...VietnamesePercent..Total.population...RACE...One.race...Asian...VietnameseNumber..Total.population...RACE...One.race...Asian...Other.Asian..1.Percent..Total.population...RACE...One.race...Asian...Other.Asian..1.Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.IslanderPercent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.IslanderNumber..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Native.HawaiianPercent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Native.HawaiianNumber..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Guamanian.or.ChamorroPercent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Guamanian.or.ChamorroNumber..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...SamoanPercent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...SamoanNumber..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Other.Pacific.Islander..2.Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Other.Pacific.Islander..2.Number..Total.population...RACE...One.race...Some.other.racePercent..Total.population...RACE...One.race...Some.other.raceNumber..Total.population...RACE...Two.or.more.racesPercent..Total.population...RACE...Two.or.more.racesNumber..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....WhitePercent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....WhiteNumber..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Black.or.African.AmericanPercent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Black.or.African.AmericanNumber..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....American.Indian.and.Alaska.NativePercent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....American.Indian.and.Alaska.NativeNumber..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....AsianPercent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....AsianNumber..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Native.Hawaiian.and.Other.Pacific.IslanderPercent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Native.Hawaiian.and.Other.Pacific.IslanderNumber..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Some.other.racePercent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Some.other.raceNumber..HISPANIC.OR.LATINO.AND.RACE...Total.populationPercent..HISPANIC.OR.LATINO.AND.RACE...Total.populationNumber..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race.Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race.Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....MexicanPercent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....MexicanNumber..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Puerto.RicanPercent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Puerto.RicanNumber..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....CubanPercent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....CubanNumber..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Other.Hispanic.or.LatinoPercent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Other.Hispanic.or.LatinoNumber..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.LatinoPercent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.LatinoNumber..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino...White.alonePercent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino...White.aloneNumber..RELATIONSHIP...Total.populationPercent..RELATIONSHIP...Total.populationNumber..RELATIONSHIP...Total.population...In.householdsPercent..RELATIONSHIP...Total.population...In.householdsNumber..RELATIONSHIP...Total.population...In.households...HouseholderPercent..RELATIONSHIP...Total.population...In.households...HouseholderNumber..RELATIONSHIP...Total.population...In.households...SpousePercent..RELATIONSHIP...Total.population...In.households...SpouseNumber..RELATIONSHIP...Total.population...In.households...ChildPercent..RELATIONSHIP...Total.population...In.households...ChildNumber..RELATIONSHIP...Total.population...In.households...Child...Own.child.under.18.yearsPercent..RELATIONSHIP...Total.population...In.households...Child...Own.child.under.18.yearsNumber..RELATIONSHIP...Total.population...In.households...Other.relativesPercent..RELATIONSHIP...Total.population...In.households...Other.relativesNumber..RELATIONSHIP...Total.population...In.households...Other.relatives...Under.18.yearsPercent..RELATIONSHIP...Total.population...In.households...Other.relatives...Under.18.yearsNumber..RELATIONSHIP...Total.population...In.households...NonrelativesPercent..RELATIONSHIP...Total.population...In.households...NonrelativesNumber..RELATIONSHIP...Total.population...In.households...Nonrelatives...Unmarried.partnerPercent..RELATIONSHIP...Total.population...In.households...Nonrelatives...Unmarried.partnerNumber..RELATIONSHIP...Total.population...In.group.quartersPercent..RELATIONSHIP...Total.population...In.group.quartersNumber..RELATIONSHIP...Total.population...In.group.quarters...Institutionalized.populationPercent..RELATIONSHIP...Total.population...In.group.quarters...Institutionalized.populationNumber..RELATIONSHIP...Total.population...In.group.quarters...Noninstitutionalized.populationPercent..RELATIONSHIP...Total.population...In.group.quarters...Noninstitutionalized.populationNumber..HOUSEHOLDS.BY.TYPE...Total.householdsPercent..HOUSEHOLDS.BY.TYPE...Total.householdsNumber..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families.Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families.Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....With.own.children.under.18.yearsPercent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....With.own.children.under.18.yearsNumber..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.familyPercent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.familyNumber..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family...With.own.children.under.18.yearsPercent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family...With.own.children.under.18.yearsNumber..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.presentPercent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.presentNumber..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present...With.own.children.under.18.yearsPercent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present...With.own.children.under.18.yearsNumber..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.householdsPercent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.householdsNumber..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alonePercent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.aloneNumber..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone...Householder.65.years.and.overPercent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone...Householder.65.years.and.overNumber..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.under.18.yearsPercent..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.under.18.yearsNumber..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.65.years.and.overPercent..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.65.years.and.overNumber..HOUSEHOLDS.BY.TYPE...Total.households...Average.household.sizePercent..HOUSEHOLDS.BY.TYPE...Total.households...Average.household.sizeNumber..HOUSEHOLDS.BY.TYPE...Total.households...Average.family.sizePercent..HOUSEHOLDS.BY.TYPE...Total.households...Average.family.sizeNumber..HOUSING.OCCUPANCY...Total.housing.unitsPercent..HOUSING.OCCUPANCY...Total.housing.unitsNumber..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.unitsPercent..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.unitsNumber..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.unitsPercent..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.unitsNumber..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units...For.seasonal..recreational..or.occasional.usePercent..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units...For.seasonal..recreational..or.occasional.useNumber..HOUSING.OCCUPANCY...Total.housing.units...Homeowner.vacancy.rate..percent.Percent..HOUSING.OCCUPANCY...Total.housing.units...Homeowner.vacancy.rate..percent.Number..HOUSING.OCCUPANCY...Total.housing.units...Rental.vacancy.rate..percent.Percent..HOUSING.OCCUPANCY...Total.housing.units...Rental.vacancy.rate..percent.Number..HOUSING.TENURE...Occupied.housing.unitsPercent..HOUSING.TENURE...Occupied.housing.unitsNumber..HOUSING.TENURE...Occupied.housing.units...Owner.occupied.housing.unitsPercent..HOUSING.TENURE...Occupied.housing.units...Owner.occupied.housing.unitsNumber..HOUSING.TENURE...Occupied.housing.units...Renter.occupied.housing.unitsPercent..HOUSING.TENURE...Occupied.housing.units...Renter.occupied.housing.unitsNumber..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.owner.occupied.unitPercent..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.owner.occupied.unitNumber..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.renter.occupied.unitPercent..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.renter.occupied.unit
11400000US2200196010022001960100Census Tract 9601, Acadia Parish, Louisiana6,1881002,920473,26853462850285419572937567281291315699113015252443372875123234(X)4,304701,957322,347384,031659961684314295554896,1741004,455721,67527120700000200010004000000000002501404,468721,6772719080003016,18810087151110003516,101994,398716,1881006,030972,236361,119182,199361,70028274414322023109215831512702,2361001,59571868391,1195057326363162371164129585263031496243569253(X)3(X)2,4101002,2369317471511(X)8(X)2,2361001,52668710323(X)3(X)
21400000US2200196020022001960200Census Tract 9602, Acadia Parish, Louisiana5,0561002,562512,4944934674168476946392986579128611770914250520342635150342134(X)3,527701,758351,769353,28965570114559217423855,0351004,79995216460100000000000001000000000001302104,81695226513060401605,05610035118000001705,021994,775945,0561005,0561001,764351,216241,791351,41328173386211226110000001,7641001,40880722411,216696173513488153562031018128778144339193(X)3(X)1,9091001,7649214583121(X)7(X)1,7641001,46183303173(X)3(X)
31400000US2200196030022001960300Census Tract 9603, Acadia Parish, Louisiana3,1491001,593511,55649209725183051026082047368125201740913148513042097104332135(X)2,233711,103351,130362,081664351434511150519563,1401003,05897672802000100000000010101000000040903,066976921302010703,1491001514000001103,1341003,049973,1491003,1481001,14536750241,09135854277323818934821000101,14510088377445397506636932938525262232282091847542247223(X)3(X)1,2461001,1459210181921(X)7(X)1,1451001,0419110493(X)3(X)
41400000US2200196040022001960400Census Tract 9604, Acadia Parish, Louisiana5,6171002,754492,8635142984067520947693536691129141668412254522244107193365134(X)3,944701,911342,033363,716668001466812302536675,583995,34795207418060101040000000000000000000503415,3819621144318000905,61710043124000001905,574995,307955,6171005,5921001,991351,291231,994361,554281964101212027012501001501,9911001,55578804401,2916564132168899543622388201891086143482243(X)3(X)2,1761001,9919218592311(X)6(X)1,9911001,63082361183(X)3(X)
51400000US2200196050022001960500Census Tract 9605, Acadia Parish, Louisiana4,9271002,461502,4665040084389439941893197704147771664413227515432345134339132(X)3,405691,675341,730353,16264499104078167324054,9011004,49891378815040000010000030001000001000502614,5249238583514010904,92710061137110002314,866994,448904,9271004,9211001,692341,068221,809371,418291744711178410026000601,6921001,32678762451,06863611361821110363662230018136880848316193(X)3(X)1,7961001,6929410462211(X)5(X)1,6921001,41984273163(X)3(X)
61400000US2200196060022001960600Census Tract 9606, Acadia Parish, Louisiana5,6541002,647473,00753464847184428460835867601387115615112434209441572414105233(X)3,999711,791322,208393,736668691576114271549095,620994,8098578214701200030200010600000000000001003414,8428679214180150002105,65410049128100002105,605994,774845,6541005,526982,073371,076191,891331,47826289516031974110212821282002,0731001,47771796381,076525412631015189959629521252431288243510253(X)3(X)2,2921002,07390219101111(X)14(X)2,0731001,47471599293(X)3(X)
\n" ], "text/latex": [ "\\begin{tabular}{r|lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll}\n", " & Id & Id2 & Geography & Number..Total.population & Percent..Total.population & Number..Total.population...SEX.AND.AGE...Male & Percent..Total.population...SEX.AND.AGE...Male & Number..Total.population...SEX.AND.AGE...Female & Percent..Total.population...SEX.AND.AGE...Female & Number..Total.population...SEX.AND.AGE...Under.5.years & Percent..Total.population...SEX.AND.AGE...Under.5.years & Number..Total.population...SEX.AND.AGE...5.to.9.years & Percent..Total.population...SEX.AND.AGE...5.to.9.years & Number..Total.population...SEX.AND.AGE...10.to.14.years & Percent..Total.population...SEX.AND.AGE...10.to.14.years & Number..Total.population...SEX.AND.AGE...15.to.19.years & Percent..Total.population...SEX.AND.AGE...15.to.19.years & Number..Total.population...SEX.AND.AGE...20.to.24.years & Percent..Total.population...SEX.AND.AGE...20.to.24.years & Number..Total.population...SEX.AND.AGE...25.to.34.years & Percent..Total.population...SEX.AND.AGE...25.to.34.years & Number..Total.population...SEX.AND.AGE...35.to.44.years & Percent..Total.population...SEX.AND.AGE...35.to.44.years & Number..Total.population...SEX.AND.AGE...45.to.54.years & Percent..Total.population...SEX.AND.AGE...45.to.54.years & Number..Total.population...SEX.AND.AGE...55.to.59.years & Percent..Total.population...SEX.AND.AGE...55.to.59.years & Number..Total.population...SEX.AND.AGE...60.to.64.years & Percent..Total.population...SEX.AND.AGE...60.to.64.years & Number..Total.population...SEX.AND.AGE...65.to.74.years & Percent..Total.population...SEX.AND.AGE...65.to.74.years & Number..Total.population...SEX.AND.AGE...75.to.84.years & Percent..Total.population...SEX.AND.AGE...75.to.84.years & Number..Total.population...SEX.AND.AGE...85.years.and.over & Percent..Total.population...SEX.AND.AGE...85.years.and.over & Number..Total.population...SEX.AND.AGE...Median.age..years. & Percent..Total.population...SEX.AND.AGE...Median.age..years. & Number..Total.population...SEX.AND.AGE...18.years.and.over & Percent..Total.population...SEX.AND.AGE...18.years.and.over & Number..Total.population...SEX.AND.AGE...18.years.and.over...Male & Percent..Total.population...SEX.AND.AGE...18.years.and.over...Male & Number..Total.population...SEX.AND.AGE...18.years.and.over...Female & Percent..Total.population...SEX.AND.AGE...18.years.and.over...Female & Number..Total.population...SEX.AND.AGE...21.years.and.over & Percent..Total.population...SEX.AND.AGE...21.years.and.over & Number..Total.population...SEX.AND.AGE...62.years.and.over & Percent..Total.population...SEX.AND.AGE...62.years.and.over & Number..Total.population...SEX.AND.AGE...65.years.and.over & Percent..Total.population...SEX.AND.AGE...65.years.and.over & Number..Total.population...SEX.AND.AGE...65.years.and.over...Male & Percent..Total.population...SEX.AND.AGE...65.years.and.over...Male & Number..Total.population...SEX.AND.AGE...65.years.and.over...Female & Percent..Total.population...SEX.AND.AGE...65.years.and.over...Female & Number..Total.population...RACE...One.race & Percent..Total.population...RACE...One.race & Number..Total.population...RACE...One.race...White & Percent..Total.population...RACE...One.race...White & Number..Total.population...RACE...One.race...Black.or.African.American & Percent..Total.population...RACE...One.race...Black.or.African.American & Number..Total.population...RACE...One.race...American.Indian.and.Alaska.Native & Percent..Total.population...RACE...One.race...American.Indian.and.Alaska.Native & Number..Total.population...RACE...One.race...Asian & Percent..Total.population...RACE...One.race...Asian & Number..Total.population...RACE...One.race...Asian...Asian.Indian & Percent..Total.population...RACE...One.race...Asian...Asian.Indian & Number..Total.population...RACE...One.race...Asian...Chinese & Percent..Total.population...RACE...One.race...Asian...Chinese & Number..Total.population...RACE...One.race...Asian...Filipino & Percent..Total.population...RACE...One.race...Asian...Filipino & Number..Total.population...RACE...One.race...Asian...Japanese & Percent..Total.population...RACE...One.race...Asian...Japanese & Number..Total.population...RACE...One.race...Asian...Korean & Percent..Total.population...RACE...One.race...Asian...Korean & Number..Total.population...RACE...One.race...Asian...Vietnamese & Percent..Total.population...RACE...One.race...Asian...Vietnamese & Number..Total.population...RACE...One.race...Asian...Other.Asian..1. & Percent..Total.population...RACE...One.race...Asian...Other.Asian..1. & Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander & Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander & Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Native.Hawaiian & Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Native.Hawaiian & Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Guamanian.or.Chamorro & Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Guamanian.or.Chamorro & Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Samoan & Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Samoan & Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Other.Pacific.Islander..2. & Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Other.Pacific.Islander..2. & Number..Total.population...RACE...One.race...Some.other.race & Percent..Total.population...RACE...One.race...Some.other.race & Number..Total.population...RACE...Two.or.more.races & Percent..Total.population...RACE...Two.or.more.races & Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....White & Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....White & Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Black.or.African.American & Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Black.or.African.American & Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....American.Indian.and.Alaska.Native & Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....American.Indian.and.Alaska.Native & Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Asian & Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Asian & Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Native.Hawaiian.and.Other.Pacific.Islander & Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Native.Hawaiian.and.Other.Pacific.Islander & Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Some.other.race & Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Some.other.race & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race. & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race. & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Mexican & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Mexican & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Puerto.Rican & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Puerto.Rican & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Cuban & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Cuban & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Other.Hispanic.or.Latino & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Other.Hispanic.or.Latino & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino & Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino...White.alone & Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino...White.alone & Number..RELATIONSHIP...Total.population & Percent..RELATIONSHIP...Total.population & Number..RELATIONSHIP...Total.population...In.households & Percent..RELATIONSHIP...Total.population...In.households & Number..RELATIONSHIP...Total.population...In.households...Householder & Percent..RELATIONSHIP...Total.population...In.households...Householder & Number..RELATIONSHIP...Total.population...In.households...Spouse & Percent..RELATIONSHIP...Total.population...In.households...Spouse & Number..RELATIONSHIP...Total.population...In.households...Child & Percent..RELATIONSHIP...Total.population...In.households...Child & Number..RELATIONSHIP...Total.population...In.households...Child...Own.child.under.18.years & Percent..RELATIONSHIP...Total.population...In.households...Child...Own.child.under.18.years & Number..RELATIONSHIP...Total.population...In.households...Other.relatives & Percent..RELATIONSHIP...Total.population...In.households...Other.relatives & Number..RELATIONSHIP...Total.population...In.households...Other.relatives...Under.18.years & Percent..RELATIONSHIP...Total.population...In.households...Other.relatives...Under.18.years & Number..RELATIONSHIP...Total.population...In.households...Nonrelatives & Percent..RELATIONSHIP...Total.population...In.households...Nonrelatives & Number..RELATIONSHIP...Total.population...In.households...Nonrelatives...Unmarried.partner & Percent..RELATIONSHIP...Total.population...In.households...Nonrelatives...Unmarried.partner & Number..RELATIONSHIP...Total.population...In.group.quarters & Percent..RELATIONSHIP...Total.population...In.group.quarters & Number..RELATIONSHIP...Total.population...In.group.quarters...Institutionalized.population & Percent..RELATIONSHIP...Total.population...In.group.quarters...Institutionalized.population & Number..RELATIONSHIP...Total.population...In.group.quarters...Noninstitutionalized.population & Percent..RELATIONSHIP...Total.population...In.group.quarters...Noninstitutionalized.population & Number..HOUSEHOLDS.BY.TYPE...Total.households & Percent..HOUSEHOLDS.BY.TYPE...Total.households & Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families. & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families. & Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....With.own.children.under.18.years & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....With.own.children.under.18.years & Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family & Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family...With.own.children.under.18.years & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family...With.own.children.under.18.years & Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present & Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present...With.own.children.under.18.years & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present...With.own.children.under.18.years & Number..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households & Number..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone & Number..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone...Householder.65.years.and.over & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone...Householder.65.years.and.over & Number..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.under.18.years & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.under.18.years & Number..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.65.years.and.over & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.65.years.and.over & Number..HOUSEHOLDS.BY.TYPE...Total.households...Average.household.size & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Average.household.size & Number..HOUSEHOLDS.BY.TYPE...Total.households...Average.family.size & Percent..HOUSEHOLDS.BY.TYPE...Total.households...Average.family.size & Number..HOUSING.OCCUPANCY...Total.housing.units & Percent..HOUSING.OCCUPANCY...Total.housing.units & Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units & Percent..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units & Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units & Percent..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units & Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units...For.seasonal..recreational..or.occasional.use & Percent..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units...For.seasonal..recreational..or.occasional.use & Number..HOUSING.OCCUPANCY...Total.housing.units...Homeowner.vacancy.rate..percent. & Percent..HOUSING.OCCUPANCY...Total.housing.units...Homeowner.vacancy.rate..percent. & Number..HOUSING.OCCUPANCY...Total.housing.units...Rental.vacancy.rate..percent. & Percent..HOUSING.OCCUPANCY...Total.housing.units...Rental.vacancy.rate..percent. & Number..HOUSING.TENURE...Occupied.housing.units & Percent..HOUSING.TENURE...Occupied.housing.units & Number..HOUSING.TENURE...Occupied.housing.units...Owner.occupied.housing.units & Percent..HOUSING.TENURE...Occupied.housing.units...Owner.occupied.housing.units & Number..HOUSING.TENURE...Occupied.housing.units...Renter.occupied.housing.units & Percent..HOUSING.TENURE...Occupied.housing.units...Renter.occupied.housing.units & Number..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.owner.occupied.unit & Percent..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.owner.occupied.unit & Number..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.renter.occupied.unit & Percent..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.renter.occupied.unit\\\\\n", "\\hline\n", "\t1 & 1400000US22001960100 & 22001960100 & Census Tract 9601, Acadia Parish, Louisiana & 6,188 & 100 & 2,920 & 47 & 3,268 & 53 & 462 & 8 & 502 & 8 & 541 & 9 & 572 & 9 & 375 & 6 & 728 & 12 & 913 & 15 & 699 & 11 & 301 & 5 & 252 & 4 & 433 & 7 & 287 & 5 & 123 & 2 & 34 & (X) & 4,304 & 70 & 1,957 & 32 & 2,347 & 38 & 4,031 & 65 & 996 & 16 & 843 & 14 & 295 & 5 & 548 & 9 & 6,174 & 100 & 4,455 & 72 & 1,675 & 27 & 12 & 0 & 7 & 0 & 0 & 0 & 0 & 0 & 2 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 4 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 25 & 0 & 14 & 0 & 4,468 & 72 & 1,677 & 27 & 19 & 0 & 8 & 0 & 0 & 0 & 30 & 1 & 6,188 & 100 & 87 & 1 & 51 & 1 & 1 & 0 & 0 & 0 & 35 & 1 & 6,101 & 99 & 4,398 & 71 & 6,188 & 100 & 6,030 & 97 & 2,236 & 36 & 1,119 & 18 & 2,199 & 36 & 1,700 & 28 & 274 & 4 & 143 & 2 & 202 & 3 & 109 & 2 & 158 & 3 & 151 & 2 & 7 & 0 & 2,236 & 100 & 1,595 & 71 & 868 & 39 & 1,119 & 50 & 573 & 26 & 363 & 16 & 237 & 11 & 641 & 29 & 585 & 26 & 303 & 14 & 962 & 43 & 569 & 25 & 3 & (X) & 3 & (X) & 2,410 & 100 & 2,236 & 93 & 174 & 7 & 15 & 1 & 1 & (X) & 8 & (X) & 2,236 & 100 & 1,526 & 68 & 710 & 32 & 3 & (X) & 3 & (X)\\\\\n", "\t2 & 1400000US22001960200 & 22001960200 & Census Tract 9602, Acadia Parish, Louisiana & 5,056 & 100 & 2,562 & 51 & 2,494 & 49 & 346 & 7 & 416 & 8 & 476 & 9 & 463 & 9 & 298 & 6 & 579 & 12 & 861 & 17 & 709 & 14 & 250 & 5 & 203 & 4 & 263 & 5 & 150 & 3 & 42 & 1 & 34 & (X) & 3,527 & 70 & 1,758 & 35 & 1,769 & 35 & 3,289 & 65 & 570 & 11 & 455 & 9 & 217 & 4 & 238 & 5 & 5,035 & 100 & 4,799 & 95 & 216 & 4 & 6 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 13 & 0 & 21 & 0 & 4,816 & 95 & 226 & 5 & 13 & 0 & 6 & 0 & 4 & 0 & 16 & 0 & 5,056 & 100 & 35 & 1 & 18 & 0 & 0 & 0 & 0 & 0 & 17 & 0 & 5,021 & 99 & 4,775 & 94 & 5,056 & 100 & 5,056 & 100 & 1,764 & 35 & 1,216 & 24 & 1,791 & 35 & 1,413 & 28 & 173 & 3 & 86 & 2 & 112 & 2 & 61 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 1,764 & 100 & 1,408 & 80 & 722 & 41 & 1,216 & 69 & 617 & 35 & 134 & 8 & 81 & 5 & 356 & 20 & 310 & 18 & 128 & 7 & 781 & 44 & 339 & 19 & 3 & (X) & 3 & (X) & 1,909 & 100 & 1,764 & 92 & 145 & 8 & 31 & 2 & 1 & (X) & 7 & (X) & 1,764 & 100 & 1,461 & 83 & 303 & 17 & 3 & (X) & 3 & (X)\\\\\n", "\t3 & 1400000US22001960300 & 22001960300 & Census Tract 9603, Acadia Parish, Louisiana & 3,149 & 100 & 1,593 & 51 & 1,556 & 49 & 209 & 7 & 251 & 8 & 305 & 10 & 260 & 8 & 204 & 7 & 368 & 12 & 520 & 17 & 409 & 13 & 148 & 5 & 130 & 4 & 209 & 7 & 104 & 3 & 32 & 1 & 35 & (X) & 2,233 & 71 & 1,103 & 35 & 1,130 & 36 & 2,081 & 66 & 435 & 14 & 345 & 11 & 150 & 5 & 195 & 6 & 3,140 & 100 & 3,058 & 97 & 67 & 2 & 8 & 0 & 2 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 1 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 4 & 0 & 9 & 0 & 3,066 & 97 & 69 & 2 & 13 & 0 & 2 & 0 & 1 & 0 & 7 & 0 & 3,149 & 100 & 15 & 1 & 4 & 0 & 0 & 0 & 0 & 0 & 11 & 0 & 3,134 & 100 & 3,049 & 97 & 3,149 & 100 & 3,148 & 100 & 1,145 & 36 & 750 & 24 & 1,091 & 35 & 854 & 27 & 73 & 2 & 38 & 1 & 89 & 3 & 48 & 2 & 1 & 0 & 0 & 0 & 1 & 0 & 1,145 & 100 & 883 & 77 & 445 & 39 & 750 & 66 & 369 & 32 & 93 & 8 & 52 & 5 & 262 & 23 & 228 & 20 & 91 & 8 & 475 & 42 & 247 & 22 & 3 & (X) & 3 & (X) & 1,246 & 100 & 1,145 & 92 & 101 & 8 & 19 & 2 & 1 & (X) & 7 & (X) & 1,145 & 100 & 1,041 & 91 & 104 & 9 & 3 & (X) & 3 & (X)\\\\\n", "\t4 & 1400000US22001960400 & 22001960400 & Census Tract 9604, Acadia Parish, Louisiana & 5,617 & 100 & 2,754 & 49 & 2,863 & 51 & 429 & 8 & 406 & 7 & 520 & 9 & 476 & 9 & 353 & 6 & 691 & 12 & 914 & 16 & 684 & 12 & 254 & 5 & 222 & 4 & 410 & 7 & 193 & 3 & 65 & 1 & 34 & (X) & 3,944 & 70 & 1,911 & 34 & 2,033 & 36 & 3,716 & 66 & 800 & 14 & 668 & 12 & 302 & 5 & 366 & 7 & 5,583 & 99 & 5,347 & 95 & 207 & 4 & 18 & 0 & 6 & 0 & 1 & 0 & 1 & 0 & 4 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 5 & 0 & 34 & 1 & 5,381 & 96 & 211 & 4 & 43 & 1 & 8 & 0 & 0 & 0 & 9 & 0 & 5,617 & 100 & 43 & 1 & 24 & 0 & 0 & 0 & 0 & 0 & 19 & 0 & 5,574 & 99 & 5,307 & 95 & 5,617 & 100 & 5,592 & 100 & 1,991 & 35 & 1,291 & 23 & 1,994 & 36 & 1,554 & 28 & 196 & 4 & 101 & 2 & 120 & 2 & 70 & 1 & 25 & 0 & 10 & 0 & 15 & 0 & 1,991 & 100 & 1,555 & 78 & 804 & 40 & 1,291 & 65 & 641 & 32 & 168 & 8 & 99 & 5 & 436 & 22 & 388 & 20 & 189 & 10 & 861 & 43 & 482 & 24 & 3 & (X) & 3 & (X) & 2,176 & 100 & 1,991 & 92 & 185 & 9 & 23 & 1 & 1 & (X) & 6 & (X) & 1,991 & 100 & 1,630 & 82 & 361 & 18 & 3 & (X) & 3 & (X)\\\\\n", "\t5 & 1400000US22001960500 & 22001960500 & Census Tract 9605, Acadia Parish, Louisiana & 4,927 & 100 & 2,461 & 50 & 2,466 & 50 & 400 & 8 & 438 & 9 & 439 & 9 & 418 & 9 & 319 & 7 & 704 & 14 & 777 & 16 & 644 & 13 & 227 & 5 & 154 & 3 & 234 & 5 & 134 & 3 & 39 & 1 & 32 & (X) & 3,405 & 69 & 1,675 & 34 & 1,730 & 35 & 3,162 & 64 & 499 & 10 & 407 & 8 & 167 & 3 & 240 & 5 & 4,901 & 100 & 4,498 & 91 & 378 & 8 & 15 & 0 & 4 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 3 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 0 & 0 & 1 & 0 & 0 & 0 & 5 & 0 & 26 & 1 & 4,524 & 92 & 385 & 8 & 35 & 1 & 4 & 0 & 1 & 0 & 9 & 0 & 4,927 & 100 & 61 & 1 & 37 & 1 & 1 & 0 & 0 & 0 & 23 & 1 & 4,866 & 99 & 4,448 & 90 & 4,927 & 100 & 4,921 & 100 & 1,692 & 34 & 1,068 & 22 & 1,809 & 37 & 1,418 & 29 & 174 & 4 & 71 & 1 & 178 & 4 & 100 & 2 & 6 & 0 & 0 & 0 & 6 & 0 & 1,692 & 100 & 1,326 & 78 & 762 & 45 & 1,068 & 63 & 611 & 36 & 182 & 11 & 103 & 6 & 366 & 22 & 300 & 18 & 136 & 8 & 808 & 48 & 316 & 19 & 3 & (X) & 3 & (X) & 1,796 & 100 & 1,692 & 94 & 104 & 6 & 22 & 1 & 1 & (X) & 5 & (X) & 1,692 & 100 & 1,419 & 84 & 273 & 16 & 3 & (X) & 3 & (X)\\\\\n", "\t6 & 1400000US22001960600 & 22001960600 & Census Tract 9606, Acadia Parish, Louisiana & 5,654 & 100 & 2,647 & 47 & 3,007 & 53 & 464 & 8 & 471 & 8 & 442 & 8 & 460 & 8 & 358 & 6 & 760 & 13 & 871 & 15 & 615 & 11 & 243 & 4 & 209 & 4 & 415 & 7 & 241 & 4 & 105 & 2 & 33 & (X) & 3,999 & 71 & 1,791 & 32 & 2,208 & 39 & 3,736 & 66 & 869 & 15 & 761 & 14 & 271 & 5 & 490 & 9 & 5,620 & 99 & 4,809 & 85 & 782 & 14 & 7 & 0 & 12 & 0 & 0 & 0 & 3 & 0 & 2 & 0 & 0 & 0 & 1 & 0 & 6 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 10 & 0 & 34 & 1 & 4,842 & 86 & 792 & 14 & 18 & 0 & 15 & 0 & 0 & 0 & 21 & 0 & 5,654 & 100 & 49 & 1 & 28 & 1 & 0 & 0 & 0 & 0 & 21 & 0 & 5,605 & 99 & 4,774 & 84 & 5,654 & 100 & 5,526 & 98 & 2,073 & 37 & 1,076 & 19 & 1,891 & 33 & 1,478 & 26 & 289 & 5 & 160 & 3 & 197 & 4 & 110 & 2 & 128 & 2 & 128 & 2 & 0 & 0 & 2,073 & 100 & 1,477 & 71 & 796 & 38 & 1,076 & 52 & 541 & 26 & 310 & 15 & 189 & 9 & 596 & 29 & 521 & 25 & 243 & 12 & 882 & 43 & 510 & 25 & 3 & (X) & 3 & (X) & 2,292 & 100 & 2,073 & 90 & 219 & 10 & 11 & 1 & 1 & (X) & 14 & (X) & 2,073 & 100 & 1,474 & 71 & 599 & 29 & 3 & (X) & 3 & (X)\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " Id Id2 Geography\n", "1 1400000US22001960100 22001960100 Census Tract 9601, Acadia Parish, Louisiana\n", "2 1400000US22001960200 22001960200 Census Tract 9602, Acadia Parish, Louisiana\n", "3 1400000US22001960300 22001960300 Census Tract 9603, Acadia Parish, Louisiana\n", "4 1400000US22001960400 22001960400 Census Tract 9604, Acadia Parish, Louisiana\n", "5 1400000US22001960500 22001960500 Census Tract 9605, Acadia Parish, Louisiana\n", "6 1400000US22001960600 22001960600 Census Tract 9606, Acadia Parish, Louisiana\n", " Number..Total.population Percent..Total.population\n", "1 6,188 100\n", "2 5,056 100\n", "3 3,149 100\n", "4 5,617 100\n", "5 4,927 100\n", "6 5,654 100\n", " Number..Total.population...SEX.AND.AGE...Male\n", "1 2,920\n", "2 2,562\n", "3 1,593\n", "4 2,754\n", "5 2,461\n", "6 2,647\n", " Percent..Total.population...SEX.AND.AGE...Male\n", "1 47\n", "2 51\n", "3 51\n", "4 49\n", "5 50\n", "6 47\n", " Number..Total.population...SEX.AND.AGE...Female\n", "1 3,268\n", "2 2,494\n", "3 1,556\n", "4 2,863\n", "5 2,466\n", "6 3,007\n", " Percent..Total.population...SEX.AND.AGE...Female\n", "1 53\n", "2 49\n", "3 49\n", "4 51\n", "5 50\n", "6 53\n", " Number..Total.population...SEX.AND.AGE...Under.5.years\n", "1 462\n", "2 346\n", "3 209\n", "4 429\n", "5 400\n", "6 464\n", " Percent..Total.population...SEX.AND.AGE...Under.5.years\n", "1 8\n", "2 7\n", "3 7\n", "4 8\n", "5 8\n", "6 8\n", " Number..Total.population...SEX.AND.AGE...5.to.9.years\n", "1 502\n", "2 416\n", "3 251\n", "4 406\n", "5 438\n", "6 471\n", " Percent..Total.population...SEX.AND.AGE...5.to.9.years\n", "1 8\n", "2 8\n", "3 8\n", "4 7\n", "5 9\n", "6 8\n", " Number..Total.population...SEX.AND.AGE...10.to.14.years\n", "1 541\n", "2 476\n", "3 305\n", "4 520\n", "5 439\n", "6 442\n", " Percent..Total.population...SEX.AND.AGE...10.to.14.years\n", "1 9\n", "2 9\n", "3 10\n", "4 9\n", "5 9\n", "6 8\n", " Number..Total.population...SEX.AND.AGE...15.to.19.years\n", "1 572\n", "2 463\n", "3 260\n", "4 476\n", "5 418\n", "6 460\n", " Percent..Total.population...SEX.AND.AGE...15.to.19.years\n", "1 9\n", "2 9\n", "3 8\n", "4 9\n", "5 9\n", "6 8\n", " Number..Total.population...SEX.AND.AGE...20.to.24.years\n", "1 375\n", "2 298\n", "3 204\n", "4 353\n", "5 319\n", "6 358\n", " Percent..Total.population...SEX.AND.AGE...20.to.24.years\n", "1 6\n", "2 6\n", "3 7\n", "4 6\n", "5 7\n", "6 6\n", " Number..Total.population...SEX.AND.AGE...25.to.34.years\n", "1 728\n", "2 579\n", "3 368\n", "4 691\n", "5 704\n", "6 760\n", " Percent..Total.population...SEX.AND.AGE...25.to.34.years\n", "1 12\n", "2 12\n", "3 12\n", "4 12\n", "5 14\n", "6 13\n", " Number..Total.population...SEX.AND.AGE...35.to.44.years\n", "1 913\n", "2 861\n", "3 520\n", "4 914\n", "5 777\n", "6 871\n", " Percent..Total.population...SEX.AND.AGE...35.to.44.years\n", "1 15\n", "2 17\n", "3 17\n", "4 16\n", "5 16\n", "6 15\n", " Number..Total.population...SEX.AND.AGE...45.to.54.years\n", "1 699\n", "2 709\n", "3 409\n", "4 684\n", "5 644\n", "6 615\n", " Percent..Total.population...SEX.AND.AGE...45.to.54.years\n", "1 11\n", "2 14\n", "3 13\n", "4 12\n", "5 13\n", "6 11\n", " Number..Total.population...SEX.AND.AGE...55.to.59.years\n", "1 301\n", "2 250\n", "3 148\n", "4 254\n", "5 227\n", "6 243\n", " Percent..Total.population...SEX.AND.AGE...55.to.59.years\n", "1 5\n", "2 5\n", "3 5\n", "4 5\n", "5 5\n", "6 4\n", " Number..Total.population...SEX.AND.AGE...60.to.64.years\n", "1 252\n", "2 203\n", "3 130\n", "4 222\n", "5 154\n", "6 209\n", " Percent..Total.population...SEX.AND.AGE...60.to.64.years\n", "1 4\n", "2 4\n", "3 4\n", "4 4\n", "5 3\n", "6 4\n", " Number..Total.population...SEX.AND.AGE...65.to.74.years\n", "1 433\n", "2 263\n", "3 209\n", "4 410\n", "5 234\n", "6 415\n", " Percent..Total.population...SEX.AND.AGE...65.to.74.years\n", "1 7\n", "2 5\n", "3 7\n", "4 7\n", "5 5\n", "6 7\n", " Number..Total.population...SEX.AND.AGE...75.to.84.years\n", "1 287\n", "2 150\n", "3 104\n", "4 193\n", "5 134\n", "6 241\n", " Percent..Total.population...SEX.AND.AGE...75.to.84.years\n", "1 5\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 4\n", " Number..Total.population...SEX.AND.AGE...85.years.and.over\n", "1 123\n", "2 42\n", "3 32\n", "4 65\n", "5 39\n", "6 105\n", " Percent..Total.population...SEX.AND.AGE...85.years.and.over\n", "1 2\n", "2 1\n", "3 1\n", "4 1\n", "5 1\n", "6 2\n", " Number..Total.population...SEX.AND.AGE...Median.age..years.\n", "1 34\n", "2 34\n", "3 35\n", "4 34\n", "5 32\n", "6 33\n", " Percent..Total.population...SEX.AND.AGE...Median.age..years.\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " Number..Total.population...SEX.AND.AGE...18.years.and.over\n", "1 4,304\n", "2 3,527\n", "3 2,233\n", "4 3,944\n", "5 3,405\n", "6 3,999\n", " Percent..Total.population...SEX.AND.AGE...18.years.and.over\n", "1 70\n", "2 70\n", "3 71\n", "4 70\n", "5 69\n", "6 71\n", " Number..Total.population...SEX.AND.AGE...18.years.and.over...Male\n", "1 1,957\n", "2 1,758\n", "3 1,103\n", "4 1,911\n", "5 1,675\n", "6 1,791\n", " Percent..Total.population...SEX.AND.AGE...18.years.and.over...Male\n", "1 32\n", "2 35\n", "3 35\n", "4 34\n", "5 34\n", "6 32\n", " Number..Total.population...SEX.AND.AGE...18.years.and.over...Female\n", "1 2,347\n", "2 1,769\n", "3 1,130\n", "4 2,033\n", "5 1,730\n", "6 2,208\n", " Percent..Total.population...SEX.AND.AGE...18.years.and.over...Female\n", "1 38\n", "2 35\n", "3 36\n", "4 36\n", "5 35\n", "6 39\n", " Number..Total.population...SEX.AND.AGE...21.years.and.over\n", "1 4,031\n", "2 3,289\n", "3 2,081\n", "4 3,716\n", "5 3,162\n", "6 3,736\n", " Percent..Total.population...SEX.AND.AGE...21.years.and.over\n", "1 65\n", "2 65\n", "3 66\n", "4 66\n", "5 64\n", "6 66\n", " Number..Total.population...SEX.AND.AGE...62.years.and.over\n", "1 996\n", "2 570\n", "3 435\n", "4 800\n", "5 499\n", "6 869\n", " Percent..Total.population...SEX.AND.AGE...62.years.and.over\n", "1 16\n", "2 11\n", "3 14\n", "4 14\n", "5 10\n", "6 15\n", " Number..Total.population...SEX.AND.AGE...65.years.and.over\n", "1 843\n", "2 455\n", "3 345\n", "4 668\n", "5 407\n", "6 761\n", " Percent..Total.population...SEX.AND.AGE...65.years.and.over\n", "1 14\n", "2 9\n", "3 11\n", "4 12\n", "5 8\n", "6 14\n", " Number..Total.population...SEX.AND.AGE...65.years.and.over...Male\n", "1 295\n", "2 217\n", "3 150\n", "4 302\n", "5 167\n", "6 271\n", " Percent..Total.population...SEX.AND.AGE...65.years.and.over...Male\n", "1 5\n", "2 4\n", "3 5\n", "4 5\n", "5 3\n", "6 5\n", " Number..Total.population...SEX.AND.AGE...65.years.and.over...Female\n", "1 548\n", "2 238\n", "3 195\n", "4 366\n", "5 240\n", "6 490\n", " Percent..Total.population...SEX.AND.AGE...65.years.and.over...Female\n", "1 9\n", "2 5\n", "3 6\n", "4 7\n", "5 5\n", "6 9\n", " Number..Total.population...RACE...One.race\n", "1 6,174\n", "2 5,035\n", "3 3,140\n", "4 5,583\n", "5 4,901\n", "6 5,620\n", " Percent..Total.population...RACE...One.race\n", "1 100\n", "2 100\n", "3 100\n", "4 99\n", "5 100\n", "6 99\n", " Number..Total.population...RACE...One.race...White\n", "1 4,455\n", "2 4,799\n", "3 3,058\n", "4 5,347\n", "5 4,498\n", "6 4,809\n", " Percent..Total.population...RACE...One.race...White\n", "1 72\n", "2 95\n", "3 97\n", "4 95\n", "5 91\n", "6 85\n", " Number..Total.population...RACE...One.race...Black.or.African.American\n", "1 1,675\n", "2 216\n", "3 67\n", "4 207\n", "5 378\n", "6 782\n", " Percent..Total.population...RACE...One.race...Black.or.African.American\n", "1 27\n", "2 4\n", "3 2\n", "4 4\n", "5 8\n", "6 14\n", " Number..Total.population...RACE...One.race...American.Indian.and.Alaska.Native\n", "1 12\n", "2 6\n", "3 8\n", "4 18\n", "5 15\n", "6 7\n", " Percent..Total.population...RACE...One.race...American.Indian.and.Alaska.Native\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian\n", "1 7\n", "2 1\n", "3 2\n", "4 6\n", "5 4\n", "6 12\n", " Percent..Total.population...RACE...One.race...Asian\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Asian.Indian\n", "1 0\n", "2 0\n", "3 0\n", "4 1\n", "5 0\n", "6 0\n", " Percent..Total.population...RACE...One.race...Asian...Asian.Indian\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Chinese\n", "1 0\n", "2 0\n", "3 1\n", "4 1\n", "5 0\n", "6 3\n", " Percent..Total.population...RACE...One.race...Asian...Chinese\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Filipino\n", "1 2\n", "2 0\n", "3 0\n", "4 4\n", "5 1\n", "6 2\n", " Percent..Total.population...RACE...One.race...Asian...Filipino\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Japanese\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Percent..Total.population...RACE...One.race...Asian...Japanese\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Korean\n", "1 1\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 1\n", " Percent..Total.population...RACE...One.race...Asian...Korean\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Vietnamese\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 3\n", "6 6\n", " Percent..Total.population...RACE...One.race...Asian...Vietnamese\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Asian...Other.Asian..1.\n", "1 4\n", "2 1\n", "3 1\n", "4 0\n", "5 0\n", "6 0\n", " Percent..Total.population...RACE...One.race...Asian...Other.Asian..1.\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander\n", "1 0\n", "2 0\n", "3 1\n", "4 0\n", "5 1\n", "6 0\n", " Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Native.Hawaiian\n", "1 0\n", "2 0\n", "3 1\n", "4 0\n", "5 0\n", "6 0\n", " Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Native.Hawaiian\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Guamanian.or.Chamorro\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Guamanian.or.Chamorro\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Samoan\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 0\n", " Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Samoan\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Other.Pacific.Islander..2.\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Percent..Total.population...RACE...One.race...Native.Hawaiian.and.Other.Pacific.Islander...Other.Pacific.Islander..2.\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...One.race...Some.other.race\n", "1 25\n", "2 13\n", "3 4\n", "4 5\n", "5 5\n", "6 10\n", " Percent..Total.population...RACE...One.race...Some.other.race\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...Two.or.more.races\n", "1 14\n", "2 21\n", "3 9\n", "4 34\n", "5 26\n", "6 34\n", " Percent..Total.population...RACE...Two.or.more.races\n", "1 0\n", "2 0\n", "3 0\n", "4 1\n", "5 1\n", "6 1\n", " Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....White\n", "1 4,468\n", "2 4,816\n", "3 3,066\n", "4 5,381\n", "5 4,524\n", "6 4,842\n", " Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....White\n", "1 72\n", "2 95\n", "3 97\n", "4 96\n", "5 92\n", "6 86\n", " Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Black.or.African.American\n", "1 1,677\n", "2 226\n", "3 69\n", "4 211\n", "5 385\n", "6 792\n", " Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Black.or.African.American\n", "1 27\n", "2 5\n", "3 2\n", "4 4\n", "5 8\n", "6 14\n", " Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....American.Indian.and.Alaska.Native\n", "1 19\n", "2 13\n", "3 13\n", "4 43\n", "5 35\n", "6 18\n", " Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....American.Indian.and.Alaska.Native\n", "1 0\n", "2 0\n", "3 0\n", "4 1\n", "5 1\n", "6 0\n", " Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Asian\n", "1 8\n", "2 6\n", "3 2\n", "4 8\n", "5 4\n", "6 15\n", " Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Asian\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Native.Hawaiian.and.Other.Pacific.Islander\n", "1 0\n", "2 4\n", "3 1\n", "4 0\n", "5 1\n", "6 0\n", " Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Native.Hawaiian.and.Other.Pacific.Islander\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Some.other.race\n", "1 30\n", "2 16\n", "3 7\n", "4 9\n", "5 9\n", "6 21\n", " Percent..Total.population...RACE...Race.alone.or.in.combination.with.one.or.more.other.races..3....Some.other.race\n", "1 1\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population\n", "1 6,188\n", "2 5,056\n", "3 3,149\n", "4 5,617\n", "5 4,927\n", "6 5,654\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population\n", "1 100\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race.\n", "1 87\n", "2 35\n", "3 15\n", "4 43\n", "5 61\n", "6 49\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race.\n", "1 1\n", "2 1\n", "3 1\n", "4 1\n", "5 1\n", "6 1\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Mexican\n", "1 51\n", "2 18\n", "3 4\n", "4 24\n", "5 37\n", "6 28\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Mexican\n", "1 1\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 1\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Puerto.Rican\n", "1 1\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 0\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Puerto.Rican\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Cuban\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Cuban\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Other.Hispanic.or.Latino\n", "1 35\n", "2 17\n", "3 11\n", "4 19\n", "5 23\n", "6 21\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Hispanic.or.Latino..of.any.race....Other.Hispanic.or.Latino\n", "1 1\n", "2 0\n", "3 0\n", "4 0\n", "5 1\n", "6 0\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino\n", "1 6,101\n", "2 5,021\n", "3 3,134\n", "4 5,574\n", "5 4,866\n", "6 5,605\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino\n", "1 99\n", "2 99\n", "3 100\n", "4 99\n", "5 99\n", "6 99\n", " Number..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino...White.alone\n", "1 4,398\n", "2 4,775\n", "3 3,049\n", "4 5,307\n", "5 4,448\n", "6 4,774\n", " Percent..HISPANIC.OR.LATINO.AND.RACE...Total.population...Not.Hispanic.or.Latino...White.alone\n", "1 71\n", "2 94\n", "3 97\n", "4 95\n", "5 90\n", "6 84\n", " Number..RELATIONSHIP...Total.population\n", "1 6,188\n", "2 5,056\n", "3 3,149\n", "4 5,617\n", "5 4,927\n", "6 5,654\n", " Percent..RELATIONSHIP...Total.population\n", "1 100\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " Number..RELATIONSHIP...Total.population...In.households\n", "1 6,030\n", "2 5,056\n", "3 3,148\n", "4 5,592\n", "5 4,921\n", "6 5,526\n", " Percent..RELATIONSHIP...Total.population...In.households\n", "1 97\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 98\n", " Number..RELATIONSHIP...Total.population...In.households...Householder\n", "1 2,236\n", "2 1,764\n", "3 1,145\n", "4 1,991\n", "5 1,692\n", "6 2,073\n", " Percent..RELATIONSHIP...Total.population...In.households...Householder\n", "1 36\n", "2 35\n", "3 36\n", "4 35\n", "5 34\n", "6 37\n", " Number..RELATIONSHIP...Total.population...In.households...Spouse\n", "1 1,119\n", "2 1,216\n", "3 750\n", "4 1,291\n", "5 1,068\n", "6 1,076\n", " Percent..RELATIONSHIP...Total.population...In.households...Spouse\n", "1 18\n", "2 24\n", "3 24\n", "4 23\n", "5 22\n", "6 19\n", " Number..RELATIONSHIP...Total.population...In.households...Child\n", "1 2,199\n", "2 1,791\n", "3 1,091\n", "4 1,994\n", "5 1,809\n", "6 1,891\n", " Percent..RELATIONSHIP...Total.population...In.households...Child\n", "1 36\n", "2 35\n", "3 35\n", "4 36\n", "5 37\n", "6 33\n", " Number..RELATIONSHIP...Total.population...In.households...Child...Own.child.under.18.years\n", "1 1,700\n", "2 1,413\n", "3 854\n", "4 1,554\n", "5 1,418\n", "6 1,478\n", " Percent..RELATIONSHIP...Total.population...In.households...Child...Own.child.under.18.years\n", "1 28\n", "2 28\n", "3 27\n", "4 28\n", "5 29\n", "6 26\n", " Number..RELATIONSHIP...Total.population...In.households...Other.relatives\n", "1 274\n", "2 173\n", "3 73\n", "4 196\n", "5 174\n", "6 289\n", " Percent..RELATIONSHIP...Total.population...In.households...Other.relatives\n", "1 4\n", "2 3\n", "3 2\n", "4 4\n", "5 4\n", "6 5\n", " Number..RELATIONSHIP...Total.population...In.households...Other.relatives...Under.18.years\n", "1 143\n", "2 86\n", "3 38\n", "4 101\n", "5 71\n", "6 160\n", " Percent..RELATIONSHIP...Total.population...In.households...Other.relatives...Under.18.years\n", "1 2\n", "2 2\n", "3 1\n", "4 2\n", "5 1\n", "6 3\n", " Number..RELATIONSHIP...Total.population...In.households...Nonrelatives\n", "1 202\n", "2 112\n", "3 89\n", "4 120\n", "5 178\n", "6 197\n", " Percent..RELATIONSHIP...Total.population...In.households...Nonrelatives\n", "1 3\n", "2 2\n", "3 3\n", "4 2\n", "5 4\n", "6 4\n", " Number..RELATIONSHIP...Total.population...In.households...Nonrelatives...Unmarried.partner\n", "1 109\n", "2 61\n", "3 48\n", "4 70\n", "5 100\n", "6 110\n", " Percent..RELATIONSHIP...Total.population...In.households...Nonrelatives...Unmarried.partner\n", "1 2\n", "2 1\n", "3 2\n", "4 1\n", "5 2\n", "6 2\n", " Number..RELATIONSHIP...Total.population...In.group.quarters\n", "1 158\n", "2 0\n", "3 1\n", "4 25\n", "5 6\n", "6 128\n", " Percent..RELATIONSHIP...Total.population...In.group.quarters\n", "1 3\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 2\n", " Number..RELATIONSHIP...Total.population...In.group.quarters...Institutionalized.population\n", "1 151\n", "2 0\n", "3 0\n", "4 10\n", "5 0\n", "6 128\n", " Percent..RELATIONSHIP...Total.population...In.group.quarters...Institutionalized.population\n", "1 2\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 2\n", " Number..RELATIONSHIP...Total.population...In.group.quarters...Noninstitutionalized.population\n", "1 7\n", "2 0\n", "3 1\n", "4 15\n", "5 6\n", "6 0\n", " Percent..RELATIONSHIP...Total.population...In.group.quarters...Noninstitutionalized.population\n", "1 0\n", "2 0\n", "3 0\n", "4 0\n", "5 0\n", "6 0\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households\n", "1 2,236\n", "2 1,764\n", "3 1,145\n", "4 1,991\n", "5 1,692\n", "6 2,073\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households\n", "1 100\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families.\n", "1 1,595\n", "2 1,408\n", "3 883\n", "4 1,555\n", "5 1,326\n", "6 1,477\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families.\n", "1 71\n", "2 80\n", "3 77\n", "4 78\n", "5 78\n", "6 71\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....With.own.children.under.18.years\n", "1 868\n", "2 722\n", "3 445\n", "4 804\n", "5 762\n", "6 796\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....With.own.children.under.18.years\n", "1 39\n", "2 41\n", "3 39\n", "4 40\n", "5 45\n", "6 38\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family\n", "1 1,119\n", "2 1,216\n", "3 750\n", "4 1,291\n", "5 1,068\n", "6 1,076\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family\n", "1 50\n", "2 69\n", "3 66\n", "4 65\n", "5 63\n", "6 52\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family...With.own.children.under.18.years\n", "1 573\n", "2 617\n", "3 369\n", "4 641\n", "5 611\n", "6 541\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Married.couple.family...With.own.children.under.18.years\n", "1 26\n", "2 35\n", "3 32\n", "4 32\n", "5 36\n", "6 26\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present\n", "1 363\n", "2 134\n", "3 93\n", "4 168\n", "5 182\n", "6 310\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present\n", "1 16\n", "2 8\n", "3 8\n", "4 8\n", "5 11\n", "6 15\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present...With.own.children.under.18.years\n", "1 237\n", "2 81\n", "3 52\n", "4 99\n", "5 103\n", "6 189\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Family.households..families....Female.householder..no.husband.present...With.own.children.under.18.years\n", "1 11\n", "2 5\n", "3 5\n", "4 5\n", "5 6\n", "6 9\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households\n", "1 641\n", "2 356\n", "3 262\n", "4 436\n", "5 366\n", "6 596\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households\n", "1 29\n", "2 20\n", "3 23\n", "4 22\n", "5 22\n", "6 29\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone\n", "1 585\n", "2 310\n", "3 228\n", "4 388\n", "5 300\n", "6 521\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone\n", "1 26\n", "2 18\n", "3 20\n", "4 20\n", "5 18\n", "6 25\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone...Householder.65.years.and.over\n", "1 303\n", "2 128\n", "3 91\n", "4 189\n", "5 136\n", "6 243\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Nonfamily.households...Householder.living.alone...Householder.65.years.and.over\n", "1 14\n", "2 7\n", "3 8\n", "4 10\n", "5 8\n", "6 12\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.under.18.years\n", "1 962\n", "2 781\n", "3 475\n", "4 861\n", "5 808\n", "6 882\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.under.18.years\n", "1 43\n", "2 44\n", "3 42\n", "4 43\n", "5 48\n", "6 43\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.65.years.and.over\n", "1 569\n", "2 339\n", "3 247\n", "4 482\n", "5 316\n", "6 510\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Households.with.individuals.65.years.and.over\n", "1 25\n", "2 19\n", "3 22\n", "4 24\n", "5 19\n", "6 25\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Average.household.size\n", "1 3\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Average.household.size\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " Number..HOUSEHOLDS.BY.TYPE...Total.households...Average.family.size\n", "1 3\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " Percent..HOUSEHOLDS.BY.TYPE...Total.households...Average.family.size\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " Number..HOUSING.OCCUPANCY...Total.housing.units\n", "1 2,410\n", "2 1,909\n", "3 1,246\n", "4 2,176\n", "5 1,796\n", "6 2,292\n", " Percent..HOUSING.OCCUPANCY...Total.housing.units\n", "1 100\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units\n", "1 2,236\n", "2 1,764\n", "3 1,145\n", "4 1,991\n", "5 1,692\n", "6 2,073\n", " Percent..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units\n", "1 93\n", "2 92\n", "3 92\n", "4 92\n", "5 94\n", "6 90\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units\n", "1 174\n", "2 145\n", "3 101\n", "4 185\n", "5 104\n", "6 219\n", " Percent..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units\n", "1 7\n", "2 8\n", "3 8\n", "4 9\n", "5 6\n", "6 10\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units...For.seasonal..recreational..or.occasional.use\n", "1 15\n", "2 31\n", "3 19\n", "4 23\n", "5 22\n", "6 11\n", " Percent..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units...For.seasonal..recreational..or.occasional.use\n", "1 1\n", "2 2\n", "3 2\n", "4 1\n", "5 1\n", "6 1\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Homeowner.vacancy.rate..percent.\n", "1 1\n", "2 1\n", "3 1\n", "4 1\n", "5 1\n", "6 1\n", " Percent..HOUSING.OCCUPANCY...Total.housing.units...Homeowner.vacancy.rate..percent.\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Rental.vacancy.rate..percent.\n", "1 8\n", "2 7\n", "3 7\n", "4 6\n", "5 5\n", "6 14\n", " Percent..HOUSING.OCCUPANCY...Total.housing.units...Rental.vacancy.rate..percent.\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " Number..HOUSING.TENURE...Occupied.housing.units\n", "1 2,236\n", "2 1,764\n", "3 1,145\n", "4 1,991\n", "5 1,692\n", "6 2,073\n", " Percent..HOUSING.TENURE...Occupied.housing.units\n", "1 100\n", "2 100\n", "3 100\n", "4 100\n", "5 100\n", "6 100\n", " Number..HOUSING.TENURE...Occupied.housing.units...Owner.occupied.housing.units\n", "1 1,526\n", "2 1,461\n", "3 1,041\n", "4 1,630\n", "5 1,419\n", "6 1,474\n", " Percent..HOUSING.TENURE...Occupied.housing.units...Owner.occupied.housing.units\n", "1 68\n", "2 83\n", "3 91\n", "4 82\n", "5 84\n", "6 71\n", " Number..HOUSING.TENURE...Occupied.housing.units...Renter.occupied.housing.units\n", "1 710\n", "2 303\n", "3 104\n", "4 361\n", "5 273\n", "6 599\n", " Percent..HOUSING.TENURE...Occupied.housing.units...Renter.occupied.housing.units\n", "1 32\n", "2 17\n", "3 9\n", "4 18\n", "5 16\n", "6 29\n", " Number..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.owner.occupied.unit\n", "1 3\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " Percent..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.owner.occupied.unit\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)\n", " Number..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.renter.occupied.unit\n", "1 3\n", "2 3\n", "3 3\n", "4 3\n", "5 3\n", "6 3\n", " Percent..HOUSING.TENURE...Occupied.housing.units...Average.household.size.of.renter.occupied.unit\n", "1 (X)\n", "2 (X)\n", "3 (X)\n", "4 (X)\n", "5 (X)\n", "6 (X)" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "head(census2000)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Cleaning the data\n", "\n", "Visually, we can see that this data set is very wide. In fact, there are 195 columns.\n", "\n", "Spaces are not allowed in R column names. That's why they've been automatically converted to periods, as in `Number..Total.population`.\n", "\n", "Let's keep a handful of these:\n", "\n", "* `Id2`: This is what the census bureau calls a FIPS code. It is a unique numerical identifier for all census tracts. This will be important when we join our two datasets together. \n", " \n", " \n", "* `Geography`: This is a text description of the tract, with the parish name. \n", " \n", " \n", "* `Number..Total.population`: The total population of the tract. \n", " \n", " \n", "* `Number..HOUSING.OCCUPANCY...Total.housing.units`, `Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units`, and `Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units`: The total, occupied and vacant housing units.\n", "\n", "To help us trim the data set to just these six columns, we are going to import a package. There are thousands of packages for R created by the open-source community, which help improve on what is included in R by default.\n", "\n", "The one we will use here is called dplyr." ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "Warning message:\n", ": package ‘dplyr’ was built under R version 3.2.4\n", "Attaching package: ‘dplyr’\n", "\n", "The following objects are masked from ‘package:stats’:\n", "\n", " filter, lag\n", "\n", "The following objects are masked from ‘package:base’:\n", "\n", " intersect, setdiff, setequal, union\n", "\n" ] } ], "source": [ "## if dplyr was not installed we would have to run this\n", "# install.packages('dplyr')\n", "\n", "## to import the package and all of its functions \n", "library('dplyr')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "From dplyr, we will use the `select` function to trim the data set and save it to a new variable called census2000.trimmed:" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
Id2GeographyNumber..Total.populationNumber..HOUSING.OCCUPANCY...Total.housing.unitsNumber..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.unitsNumber..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units
122001960100Census Tract 9601, Acadia Parish, Louisiana6,1882,4102,236174
222001960200Census Tract 9602, Acadia Parish, Louisiana5,0561,9091,764145
322001960300Census Tract 9603, Acadia Parish, Louisiana3,1491,2461,145101
422001960400Census Tract 9604, Acadia Parish, Louisiana5,6172,1761,991185
522001960500Census Tract 9605, Acadia Parish, Louisiana4,9271,7961,692104
622001960600Census Tract 9606, Acadia Parish, Louisiana5,6542,2922,073219
\n" ], "text/latex": [ "\\begin{tabular}{r|llllll}\n", " & Id2 & Geography & Number..Total.population & Number..HOUSING.OCCUPANCY...Total.housing.units & Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units & Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units\\\\\n", "\\hline\n", "\t1 & 22001960100 & Census Tract 9601, Acadia Parish, Louisiana & 6,188 & 2,410 & 2,236 & 174\\\\\n", "\t2 & 22001960200 & Census Tract 9602, Acadia Parish, Louisiana & 5,056 & 1,909 & 1,764 & 145\\\\\n", "\t3 & 22001960300 & Census Tract 9603, Acadia Parish, Louisiana & 3,149 & 1,246 & 1,145 & 101\\\\\n", "\t4 & 22001960400 & Census Tract 9604, Acadia Parish, Louisiana & 5,617 & 2,176 & 1,991 & 185\\\\\n", "\t5 & 22001960500 & Census Tract 9605, Acadia Parish, Louisiana & 4,927 & 1,796 & 1,692 & 104\\\\\n", "\t6 & 22001960600 & Census Tract 9606, Acadia Parish, Louisiana & 5,654 & 2,292 & 2,073 & 219\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " Id2 Geography\n", "1 22001960100 Census Tract 9601, Acadia Parish, Louisiana\n", "2 22001960200 Census Tract 9602, Acadia Parish, Louisiana\n", "3 22001960300 Census Tract 9603, Acadia Parish, Louisiana\n", "4 22001960400 Census Tract 9604, Acadia Parish, Louisiana\n", "5 22001960500 Census Tract 9605, Acadia Parish, Louisiana\n", "6 22001960600 Census Tract 9606, Acadia Parish, Louisiana\n", " Number..Total.population Number..HOUSING.OCCUPANCY...Total.housing.units\n", "1 6,188 2,410\n", "2 5,056 1,909\n", "3 3,149 1,246\n", "4 5,617 2,176\n", "5 4,927 1,796\n", "6 5,654 2,292\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units\n", "1 2,236\n", "2 1,764\n", "3 1,145\n", "4 1,991\n", "5 1,692\n", "6 2,073\n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units\n", "1 174\n", "2 145\n", "3 101\n", "4 185\n", "5 104\n", "6 219" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "census2000.trimmed <- select(\n", " census2000, # name of the data frame\n", " # list of all the six column names we want to keep\n", " Id2, \n", " Geography, \n", " Number..Total.population, \n", " Number..HOUSING.OCCUPANCY...Total.housing.units, \n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units, \n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units\n", ")\n", "\n", "head(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This shows us that we were able to select the columns correctly. But one lingering issue is that these column names are long and unwieldy. Since we are going to be typing them often, let's rename them to shorter, more convenient versions:" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
fips.codegeographypopulationtotal.housing.unitsoccupied.housing.unitsvacant.housing.units
122001960100Census Tract 9601, Acadia Parish, Louisiana6,1882,4102,236174
222001960200Census Tract 9602, Acadia Parish, Louisiana5,0561,9091,764145
322001960300Census Tract 9603, Acadia Parish, Louisiana3,1491,2461,145101
422001960400Census Tract 9604, Acadia Parish, Louisiana5,6172,1761,991185
522001960500Census Tract 9605, Acadia Parish, Louisiana4,9271,7961,692104
622001960600Census Tract 9606, Acadia Parish, Louisiana5,6542,2922,073219
\n" ], "text/latex": [ "\\begin{tabular}{r|llllll}\n", " & fips.code & geography & population & total.housing.units & occupied.housing.units & vacant.housing.units\\\\\n", "\\hline\n", "\t1 & 22001960100 & Census Tract 9601, Acadia Parish, Louisiana & 6,188 & 2,410 & 2,236 & 174\\\\\n", "\t2 & 22001960200 & Census Tract 9602, Acadia Parish, Louisiana & 5,056 & 1,909 & 1,764 & 145\\\\\n", "\t3 & 22001960300 & Census Tract 9603, Acadia Parish, Louisiana & 3,149 & 1,246 & 1,145 & 101\\\\\n", "\t4 & 22001960400 & Census Tract 9604, Acadia Parish, Louisiana & 5,617 & 2,176 & 1,991 & 185\\\\\n", "\t5 & 22001960500 & Census Tract 9605, Acadia Parish, Louisiana & 4,927 & 1,796 & 1,692 & 104\\\\\n", "\t6 & 22001960600 & Census Tract 9606, Acadia Parish, Louisiana & 5,654 & 2,292 & 2,073 & 219\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " fips.code geography population\n", "1 22001960100 Census Tract 9601, Acadia Parish, Louisiana 6,188\n", "2 22001960200 Census Tract 9602, Acadia Parish, Louisiana 5,056\n", "3 22001960300 Census Tract 9603, Acadia Parish, Louisiana 3,149\n", "4 22001960400 Census Tract 9604, Acadia Parish, Louisiana 5,617\n", "5 22001960500 Census Tract 9605, Acadia Parish, Louisiana 4,927\n", "6 22001960600 Census Tract 9606, Acadia Parish, Louisiana 5,654\n", " total.housing.units occupied.housing.units vacant.housing.units\n", "1 2,410 2,236 174\n", "2 1,909 1,764 145\n", "3 1,246 1,145 101\n", "4 2,176 1,991 185\n", "5 1,796 1,692 104\n", "6 2,292 2,073 219" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "colnames(census2000.trimmed) <- c(\n", " 'fips.code', 'geography', 'population',\n", " 'total.housing.units', 'occupied.housing.units', 'vacant.housing.units'\n", ")\n", "head(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Another helpful command to run on any data set is `str`, which gives you the structure of the variable as defined by R:" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "'data.frame':\t1106 obs. of 6 variables:\n", " $ fips.code : num 2.2e+10 2.2e+10 2.2e+10 2.2e+10 2.2e+10 ...\n", " $ geography : Factor w/ 1106 levels \"Census Tract 10.01, Lafayette Parish, Louisiana\",..: 970 978 985 993 1000 1006 1011 1015 1018 1021 ...\n", " $ population : Factor w/ 1019 levels \"0\",\"1\",\"10,248\",..: 859 710 350 801 692 806 647 804 711 842 ...\n", " $ total.housing.units : Factor w/ 905 levels \"1\",\"10\",\"1,002\",..: 565 404 104 499 357 531 397 522 426 594 ...\n", " $ occupied.housing.units: Factor w/ 876 levels \"0\",\"1\",\"1,001\",..: 512 363 74 446 338 468 347 470 374 514 ...\n", " $ vacant.housing.units : Factor w/ 374 levels \"0\",\"1\",\"10\",\"100\",..: 86 54 5 98 9 134 83 86 110 196 ...\n" ] } ], "source": [ "str(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The structure tells us that this is a data frame with 1106 rows and six columns. It further tells us the type of each column. \n", "\n", "Notice how the FIPS code read in as a number but the other numeric columns read in as “factors”? That's R-speak for a categorical variable, and any character variables are by default set to this type. This happened because the numbers and those columns have commas. The presence of a single character within a number makes R treat the entire column as strings. This will be an issue later when we try to add two numbers together, as R doesn't know how to add two characters.\n", "\n", "The solution: we need to remove the comma from all the strings, then recast the variable as a number.\n", "\n", "To help with this we are going to use another package called `stringr`, and a function from within it called `str_replace`:" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "Warning message:\n", ": package ‘stringr’ was built under R version 3.2.5" ] } ], "source": [ "# install.packages('stringr')\n", "\n", "library('stringr')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's start with the population variable. First, let's remove the comma and write the result to the original column. (The format for calling a column from a data frame in R is `df.name$column.name`)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [], "source": [ "census2000.trimmed$population <- str_replace(\n", " census2000.trimmed$population, \n", " pattern = ',', \n", " replacement = ''\n", ")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Then we'll visually inspect the head:" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
fips.codegeographypopulationtotal.housing.unitsoccupied.housing.unitsvacant.housing.units
122001960100Census Tract 9601, Acadia Parish, Louisiana61882,4102,236174
222001960200Census Tract 9602, Acadia Parish, Louisiana50561,9091,764145
322001960300Census Tract 9603, Acadia Parish, Louisiana31491,2461,145101
422001960400Census Tract 9604, Acadia Parish, Louisiana56172,1761,991185
522001960500Census Tract 9605, Acadia Parish, Louisiana49271,7961,692104
622001960600Census Tract 9606, Acadia Parish, Louisiana56542,2922,073219
\n" ], "text/latex": [ "\\begin{tabular}{r|llllll}\n", " & fips.code & geography & population & total.housing.units & occupied.housing.units & vacant.housing.units\\\\\n", "\\hline\n", "\t1 & 22001960100 & Census Tract 9601, Acadia Parish, Louisiana & 6188 & 2,410 & 2,236 & 174\\\\\n", "\t2 & 22001960200 & Census Tract 9602, Acadia Parish, Louisiana & 5056 & 1,909 & 1,764 & 145\\\\\n", "\t3 & 22001960300 & Census Tract 9603, Acadia Parish, Louisiana & 3149 & 1,246 & 1,145 & 101\\\\\n", "\t4 & 22001960400 & Census Tract 9604, Acadia Parish, Louisiana & 5617 & 2,176 & 1,991 & 185\\\\\n", "\t5 & 22001960500 & Census Tract 9605, Acadia Parish, Louisiana & 4927 & 1,796 & 1,692 & 104\\\\\n", "\t6 & 22001960600 & Census Tract 9606, Acadia Parish, Louisiana & 5654 & 2,292 & 2,073 & 219\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " fips.code geography population\n", "1 22001960100 Census Tract 9601, Acadia Parish, Louisiana 6188\n", "2 22001960200 Census Tract 9602, Acadia Parish, Louisiana 5056\n", "3 22001960300 Census Tract 9603, Acadia Parish, Louisiana 3149\n", "4 22001960400 Census Tract 9604, Acadia Parish, Louisiana 5617\n", "5 22001960500 Census Tract 9605, Acadia Parish, Louisiana 4927\n", "6 22001960600 Census Tract 9606, Acadia Parish, Louisiana 5654\n", " total.housing.units occupied.housing.units vacant.housing.units\n", "1 2,410 2,236 174\n", "2 1,909 1,764 145\n", "3 1,246 1,145 101\n", "4 2,176 1,991 185\n", "5 1,796 1,692 104\n", "6 2,292 2,073 219" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "head(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This appeared to work. But R will still think this is a character variable unless we explicitly tell it otherwise:" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [], "source": [ "census2000.trimmed$population <- as.numeric(census2000.trimmed$population)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Running `str` will help us ensure this worked:" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "'data.frame':\t1106 obs. of 6 variables:\n", " $ fips.code : num 2.2e+10 2.2e+10 2.2e+10 2.2e+10 2.2e+10 ...\n", " $ geography : Factor w/ 1106 levels \"Census Tract 10.01, Lafayette Parish, Louisiana\",..: 970 978 985 993 1000 1006 1011 1015 1018 1021 ...\n", " $ population : num 6188 5056 3149 5617 4927 ...\n", " $ total.housing.units : Factor w/ 905 levels \"1\",\"10\",\"1,002\",..: 565 404 104 499 357 531 397 522 426 594 ...\n", " $ occupied.housing.units: Factor w/ 876 levels \"0\",\"1\",\"1,001\",..: 512 363 74 446 338 468 347 470 374 514 ...\n", " $ vacant.housing.units : Factor w/ 374 levels \"0\",\"1\",\"10\",\"100\",..: 86 54 5 98 9 134 83 86 110 196 ...\n" ] } ], "source": [ "str(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "For the rest of the columns we can nest the first function within the second to speed things up:" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [], "source": [ "census2000.trimmed$total.housing.units <- as.numeric(str_replace(census2000.trimmed$total.housing.units, pattern = ',', replacement = ''))\n", "census2000.trimmed$occupied.housing.units <- as.numeric(str_replace(census2000.trimmed$occupied.housing.units, pattern = ',', replacement = ''))\n", "census2000.trimmed$vacant.housing.units <- as.numeric(str_replace(census2000.trimmed$vacant.housing.units, pattern = ',', replacement = ''))" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "'data.frame':\t1106 obs. of 6 variables:\n", " $ fips.code : num 2.2e+10 2.2e+10 2.2e+10 2.2e+10 2.2e+10 ...\n", " $ geography : Factor w/ 1106 levels \"Census Tract 10.01, Lafayette Parish, Louisiana\",..: 970 978 985 993 1000 1006 1011 1015 1018 1021 ...\n", " $ population : num 6188 5056 3149 5617 4927 ...\n", " $ total.housing.units : num 2410 1909 1246 2176 1796 ...\n", " $ occupied.housing.units: num 2236 1764 1145 1991 1692 ...\n", " $ vacant.housing.units : num 174 145 101 185 104 219 171 174 196 284 ...\n" ] } ], "source": [ "str(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "By default, `head` will print the first six lines. But we can override the default to show as many as we want (we'll show 10 here):" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
fips.codegeographypopulationtotal.housing.unitsoccupied.housing.unitsvacant.housing.units
122001960100Census Tract 9601, Acadia Parish, Louisiana618824102236174
222001960200Census Tract 9602, Acadia Parish, Louisiana505619091764145
322001960300Census Tract 9603, Acadia Parish, Louisiana314912461145101
422001960400Census Tract 9604, Acadia Parish, Louisiana561721761991185
522001960500Census Tract 9605, Acadia Parish, Louisiana492717961692104
622001960600Census Tract 9606, Acadia Parish, Louisiana565422922073219
722001960700Census Tract 9607, Acadia Parish, Louisiana461418941723171
822001960800Census Tract 9608, Acadia Parish, Louisiana564022542080174
922001960900Census Tract 9609, Acadia Parish, Louisiana505919781782196
1022001961000Census Tract 9610, Acadia Parish, Louisiana596525262242284
\n" ], "text/latex": [ "\\begin{tabular}{r|llllll}\n", " & fips.code & geography & population & total.housing.units & occupied.housing.units & vacant.housing.units\\\\\n", "\\hline\n", "\t1 & 22001960100 & Census Tract 9601, Acadia Parish, Louisiana & 6188 & 2410 & 2236 & 174\\\\\n", "\t2 & 22001960200 & Census Tract 9602, Acadia Parish, Louisiana & 5056 & 1909 & 1764 & 145\\\\\n", "\t3 & 22001960300 & Census Tract 9603, Acadia Parish, Louisiana & 3149 & 1246 & 1145 & 101\\\\\n", "\t4 & 22001960400 & Census Tract 9604, Acadia Parish, Louisiana & 5617 & 2176 & 1991 & 185\\\\\n", "\t5 & 22001960500 & Census Tract 9605, Acadia Parish, Louisiana & 4927 & 1796 & 1692 & 104\\\\\n", "\t6 & 22001960600 & Census Tract 9606, Acadia Parish, Louisiana & 5654 & 2292 & 2073 & 219\\\\\n", "\t7 & 22001960700 & Census Tract 9607, Acadia Parish, Louisiana & 4614 & 1894 & 1723 & 171\\\\\n", "\t8 & 22001960800 & Census Tract 9608, Acadia Parish, Louisiana & 5640 & 2254 & 2080 & 174\\\\\n", "\t9 & 22001960900 & Census Tract 9609, Acadia Parish, Louisiana & 5059 & 1978 & 1782 & 196\\\\\n", "\t10 & 22001961000 & Census Tract 9610, Acadia Parish, Louisiana & 5965 & 2526 & 2242 & 284\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " fips.code geography population\n", "1 22001960100 Census Tract 9601, Acadia Parish, Louisiana 6188\n", "2 22001960200 Census Tract 9602, Acadia Parish, Louisiana 5056\n", "3 22001960300 Census Tract 9603, Acadia Parish, Louisiana 3149\n", "4 22001960400 Census Tract 9604, Acadia Parish, Louisiana 5617\n", "5 22001960500 Census Tract 9605, Acadia Parish, Louisiana 4927\n", "6 22001960600 Census Tract 9606, Acadia Parish, Louisiana 5654\n", "7 22001960700 Census Tract 9607, Acadia Parish, Louisiana 4614\n", "8 22001960800 Census Tract 9608, Acadia Parish, Louisiana 5640\n", "9 22001960900 Census Tract 9609, Acadia Parish, Louisiana 5059\n", "10 22001961000 Census Tract 9610, Acadia Parish, Louisiana 5965\n", " total.housing.units occupied.housing.units vacant.housing.units\n", "1 2410 2236 174\n", "2 1909 1764 145\n", "3 1246 1145 101\n", "4 2176 1991 185\n", "5 1796 1692 104\n", "6 2292 2073 219\n", "7 1894 1723 171\n", "8 2254 2080 174\n", "9 1978 1782 196\n", "10 2526 2242 284" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "head(census2000.trimmed, n = 10)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "That worked!\n", "\n", "But in the interest of full disclosure, you should know that we added those commas to the original CSVs from the Census Bureau to facilitate this exercise. “Commafied” numbers are one of the most frequent stumbling blocks to creating a cleaned data set.\n", "\n", "For our last cleaning exercise, we'll work with the geography column. It has a lot of information in there, but it would be more useful if the census tract, parish name and state were separated, to help us aggregate some of these numbers.\n", "\n", "The package tidyr has a function that helps us do just that:" ] }, { "cell_type": "code", "execution_count": 17, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# install.packages('tidyr')\n", "\n", "library('tidyr')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Should you run into a function and not know what arguments it takes, running the function name, a pair of of empty parentheses afterwards, preceded by a question mark will allow you to access the documentation on that function:" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# ?separate()" ] }, { "cell_type": "code", "execution_count": 19, "metadata": { "collapsed": false }, "outputs": [], "source": [ "census2000.trimmed <- separate(\n", " census2000.trimmed, # name of the data frame\n", " geography, # column to split\n", " c('tract', 'parish', 'state'), # new column names\n", " ', ' # delimiter to split on (note the space after the comma)\n", ")" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
fips.codetractparishstatepopulationtotal.housing.unitsoccupied.housing.unitsvacant.housing.units
122001960100Census Tract 9601Acadia ParishLouisiana618824102236174
222001960200Census Tract 9602Acadia ParishLouisiana505619091764145
322001960300Census Tract 9603Acadia ParishLouisiana314912461145101
422001960400Census Tract 9604Acadia ParishLouisiana561721761991185
522001960500Census Tract 9605Acadia ParishLouisiana492717961692104
622001960600Census Tract 9606Acadia ParishLouisiana565422922073219
\n" ], "text/latex": [ "\\begin{tabular}{r|llllllll}\n", " & fips.code & tract & parish & state & population & total.housing.units & occupied.housing.units & vacant.housing.units\\\\\n", "\\hline\n", "\t1 & 22001960100 & Census Tract 9601 & Acadia Parish & Louisiana & 6188 & 2410 & 2236 & 174\\\\\n", "\t2 & 22001960200 & Census Tract 9602 & Acadia Parish & Louisiana & 5056 & 1909 & 1764 & 145\\\\\n", "\t3 & 22001960300 & Census Tract 9603 & Acadia Parish & Louisiana & 3149 & 1246 & 1145 & 101\\\\\n", "\t4 & 22001960400 & Census Tract 9604 & Acadia Parish & Louisiana & 5617 & 2176 & 1991 & 185\\\\\n", "\t5 & 22001960500 & Census Tract 9605 & Acadia Parish & Louisiana & 4927 & 1796 & 1692 & 104\\\\\n", "\t6 & 22001960600 & Census Tract 9606 & Acadia Parish & Louisiana & 5654 & 2292 & 2073 & 219\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " fips.code tract parish state population\n", "1 22001960100 Census Tract 9601 Acadia Parish Louisiana 6188\n", "2 22001960200 Census Tract 9602 Acadia Parish Louisiana 5056\n", "3 22001960300 Census Tract 9603 Acadia Parish Louisiana 3149\n", "4 22001960400 Census Tract 9604 Acadia Parish Louisiana 5617\n", "5 22001960500 Census Tract 9605 Acadia Parish Louisiana 4927\n", "6 22001960600 Census Tract 9606 Acadia Parish Louisiana 5654\n", " total.housing.units occupied.housing.units vacant.housing.units\n", "1 2410 2236 174\n", "2 1909 1764 145\n", "3 1246 1145 101\n", "4 2176 1991 185\n", "5 1796 1692 104\n", "6 2292 2073 219" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "head(census2000.trimmed)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Our data set is as cleaned up as we need it to be now.\n", "\n", "Let's summarize it with a frequency table of the county names:" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "\n", " Acadia Parish Allen Parish \n", " 12 5 \n", " Ascension Parish Assumption Parish \n", " 14 6 \n", " Avoyelles Parish Beauregard Parish \n", " 9 7 \n", " Bienville Parish Bossier Parish \n", " 5 19 \n", " Caddo Parish Calcasieu Parish \n", " 64 41 \n", " Caldwell Parish Cameron Parish \n", " 3 2 \n", " Catahoula Parish Claiborne Parish \n", " 3 5 \n", " Concordia Parish De Soto Parish \n", " 5 7 \n", " East Baton Rouge Parish East Carroll Parish \n", " 89 3 \n", " East Feliciana Parish Evangeline Parish \n", " 4 8 \n", " Franklin Parish Grant Parish \n", " 6 5 \n", " Iberia Parish Iberville Parish \n", " 15 8 \n", " Jackson Parish Jefferson Davis Parish \n", " 5 7 \n", " Jefferson Parish Lafayette Parish \n", " 123 41 \n", " Lafourche Parish La Salle Parish \n", " 22 3 \n", " Lincoln Parish Livingston Parish \n", " 10 13 \n", " Madison Parish Morehouse Parish \n", " 5 8 \n", " Natchitoches Parish Orleans Parish \n", " 9 181 \n", " Ouachita Parish Plaquemines Parish \n", " 41 8 \n", " Pointe Coupee Parish Rapides Parish \n", " 6 34 \n", " Red River Parish Richland Parish \n", " 2 6 \n", " Sabine Parish St. Bernard Parish \n", " 7 17 \n", " St. Charles Parish St. Helena Parish \n", " 13 2 \n", " St. James Parish St. John the Baptist Parish \n", " 7 11 \n", " St. Landry Parish St. Martin Parish \n", " 19 9 \n", " St. Mary Parish St. Tammany Parish \n", " 16 35 \n", " Tangipahoa Parish Tensas Parish \n", " 18 3 \n", " Terrebonne Parish Union Parish \n", " 20 6 \n", " Vermilion Parish Vernon Parish \n", " 10 9 \n", " Washington Parish Webster Parish \n", " 10 11 \n", " West Baton Rouge Parish West Carroll Parish \n", " 4 3 \n", " West Feliciana Parish Winn Parish \n", " 3 4 " ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "table(census2000.trimmed$parish)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now we need to run all of the above cleaning steps on the 2010 data:" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "collapsed": true }, "outputs": [], "source": [ "census2010 <- read.csv('2010_census_demographic_profile.csv', skip = 1)\n", "\n", "census2010.trimmed <- select(\n", " census2010, # name of the data frame\n", " # list of all the column names we want to keep\n", " Id2, Geography, Number..SEX.AND.AGE...Total.population, \n", " Number..HOUSING.OCCUPANCY...Total.housing.units, \n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Occupied.housing.units, \n", " Number..HOUSING.OCCUPANCY...Total.housing.units...Vacant.housing.units\n", ")\n", "\n", "colnames(census2010.trimmed) <- c('fips.code', 'census.tract', 'population', \n", " 'total.housing.units', 'occupied.housing.units', 'vacant.housing.units')\n", "\n", "census2010.trimmed$population <- as.numeric(str_replace(census2010.trimmed$population, pattern = ',', replacement = ''))\n", "census2010.trimmed$total.housing.units <- as.numeric(str_replace(census2010.trimmed$total.housing.units, pattern = ',', replacement = ''))\n", "census2010.trimmed$occupied.housing.units <- as.numeric(str_replace(census2010.trimmed$occupied.housing.units, pattern = ',', replacement = ''))\n", "census2010.trimmed$vacant.housing.units <- as.numeric(str_replace(census2010.trimmed$vacant.housing.units, pattern = ',', replacement = ''))\n", "\n", "census2010.trimmed <- separate(census2010.trimmed, census.tract, c('tract', 'parish', 'state'), ', ')\n", "\n", "orleans2010 <- filter(census2010.trimmed, parish == 'Orleans Parish')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Merging\n", "\n", "Now that we've cleaned both of our data files, let's merge the 2000 and 2010 data. Merging allows you to link two data sets on values common to both. It is a powerful operation that cannot be easily done in a program like Excel with such versatility.\n", "\n", "In this case, we know that the FIPS code and the character names for most of the tracts should be consistent across the 10-year period.\n", "\n", "However, census tracts are added, deleted, split and joined over the course of 10 years. We will make sure to keep all entries in both years. This is what is referred to as a \"full outer join.” If we were to only keep all rows that were common to both data frames (R’s default behavior) we would lose some data." ] }, { "cell_type": "code", "execution_count": 23, "metadata": { "collapsed": false }, "outputs": [], "source": [ "census.comparison <- merge(\n", " census2000.trimmed, # first data frame\n", " census2010.trimmed, # second data frame\n", " by = c('fips.code', 'tract', 'parish', 'state'), # keys to use for join\n", " suffixes = c('.00', '.10'), # suffixes to append to new columns\n", " all = TRUE # specifying to keep all data from both data frames\n", ")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's inspect a portion of the data frame where there are full matches and partial matches:" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
fips.codetractparishstatepopulation.00total.housing.units.00occupied.housing.units.00vacant.housing.units.00population.10total.housing.units.10occupied.housing.units.10vacant.housing.units.10
6522015010801Census Tract 108.01Bossier ParishLouisiana315915271351176335914151284131
6622015010803Census Tract 108.03Bossier ParishLouisiana536222502120130NANANANA
6722015010804Census Tract 108.04Bossier ParishLouisiana610123832282101727829432815128
6822015010805Census Tract 108.05Bossier ParishLouisianaNANANANA323815851425160
6922015010806Census Tract 108.06Bossier ParishLouisianaNANANANA40861671161061
\n" ], "text/latex": [ "\\begin{tabular}{r|llllllllllll}\n", " & fips.code & tract & parish & state & population.00 & total.housing.units.00 & occupied.housing.units.00 & vacant.housing.units.00 & population.10 & total.housing.units.10 & occupied.housing.units.10 & vacant.housing.units.10\\\\\n", "\\hline\n", "\t65 & 22015010801 & Census Tract 108.01 & Bossier Parish & Louisiana & 3159 & 1527 & 1351 & 176 & 3359 & 1415 & 1284 & 131\\\\\n", "\t66 & 22015010803 & Census Tract 108.03 & Bossier Parish & Louisiana & 5362 & 2250 & 2120 & 130 & NA & NA & NA & NA\\\\\n", "\t67 & 22015010804 & Census Tract 108.04 & Bossier Parish & Louisiana & 6101 & 2383 & 2282 & 101 & 7278 & 2943 & 2815 & 128\\\\\n", "\t68 & 22015010805 & Census Tract 108.05 & Bossier Parish & Louisiana & NA & NA & NA & NA & 3238 & 1585 & 1425 & 160\\\\\n", "\t69 & 22015010806 & Census Tract 108.06 & Bossier Parish & Louisiana & NA & NA & NA & NA & 4086 & 1671 & 1610 & 61\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " fips.code tract parish state population.00\n", "65 22015010801 Census Tract 108.01 Bossier Parish Louisiana 3159\n", "66 22015010803 Census Tract 108.03 Bossier Parish Louisiana 5362\n", "67 22015010804 Census Tract 108.04 Bossier Parish Louisiana 6101\n", "68 22015010805 Census Tract 108.05 Bossier Parish Louisiana NA\n", "69 22015010806 Census Tract 108.06 Bossier Parish Louisiana NA\n", " total.housing.units.00 occupied.housing.units.00 vacant.housing.units.00\n", "65 1527 1351 176\n", "66 2250 2120 130\n", "67 2383 2282 101\n", "68 NA NA NA\n", "69 NA NA NA\n", " population.10 total.housing.units.10 occupied.housing.units.10\n", "65 3359 1415 1284\n", "66 NA NA NA\n", "67 7278 2943 2815\n", "68 3238 1585 1425\n", "69 4086 1671 1610\n", " vacant.housing.units.10\n", "65 131\n", "66 NA\n", "67 128\n", "68 160\n", "69 61" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "census.comparison[65:69, ]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Saving your work\n", "\n", "Saving your intermediate work to a file is often good practice, so we will write the results of our merge to a CSV (you can do this with any data frame you create in R)." ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "collapsed": false }, "outputs": [], "source": [ "write.csv(census.comparison, 'census_comparison_result.csv', row.names = FALSE)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Calculating population changes in New Orleans\n", "\n", "Let's filter our merged data frame down to just Orleans Parish. The Orleans Parish and the city of New Orleans are “coterminous” (that is, they share the same boundaries), so this will isolate only the census tracts of the city." ] }, { "cell_type": "code", "execution_count": 26, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\t\n", "\n", "
fips.codetractparishstatepopulation.00total.housing.units.00occupied.housing.units.00vacant.housing.units.00population.10total.housing.units.10occupied.housing.units.10vacant.housing.units.10
12.2071e+10Census Tract 1Orleans ParishLouisiana238114081145263245515131229284
22.2071e+10Census Tract 2Orleans ParishLouisiana13476914961951197738496242
32.2071e+10Census Tract 3Orleans ParishLouisiana14687195591601231641467174
42.2071e+10Census Tract 4Orleans ParishLouisiana2564103487316123281137911226
52.2071e+10Census Tract 6.01Orleans ParishLouisiana203470450619884932826959
62.2071e+10Census Tract 6.02Orleans ParishLouisiana2957110610119525341108923185
\n" ], "text/latex": [ "\\begin{tabular}{r|llllllllllll}\n", " & fips.code & tract & parish & state & population.00 & total.housing.units.00 & occupied.housing.units.00 & vacant.housing.units.00 & population.10 & total.housing.units.10 & occupied.housing.units.10 & vacant.housing.units.10\\\\\n", "\\hline\n", "\t1 & 2.2071e+10 & Census Tract 1 & Orleans Parish & Louisiana & 2381 & 1408 & 1145 & 263 & 2455 & 1513 & 1229 & 284\\\\\n", "\t2 & 2.2071e+10 & Census Tract 2 & Orleans Parish & Louisiana & 1347 & 691 & 496 & 195 & 1197 & 738 & 496 & 242\\\\\n", "\t3 & 2.2071e+10 & Census Tract 3 & Orleans Parish & Louisiana & 1468 & 719 & 559 & 160 & 1231 & 641 & 467 & 174\\\\\n", "\t4 & 2.2071e+10 & Census Tract 4 & Orleans Parish & Louisiana & 2564 & 1034 & 873 & 161 & 2328 & 1137 & 911 & 226\\\\\n", "\t5 & 2.2071e+10 & Census Tract 6.01 & Orleans Parish & Louisiana & 2034 & 704 & 506 & 198 & 849 & 328 & 269 & 59\\\\\n", "\t6 & 2.2071e+10 & Census Tract 6.02 & Orleans Parish & Louisiana & 2957 & 1106 & 1011 & 95 & 2534 & 1108 & 923 & 185\\\\\n", "\\end{tabular}\n" ], "text/plain": [ " fips.code tract parish state population.00\n", "1 2.2071e+10 Census Tract 1 Orleans Parish Louisiana 2381\n", "2 2.2071e+10 Census Tract 2 Orleans Parish Louisiana 1347\n", "3 2.2071e+10 Census Tract 3 Orleans Parish Louisiana 1468\n", "4 2.2071e+10 Census Tract 4 Orleans Parish Louisiana 2564\n", "5 2.2071e+10 Census Tract 6.01 Orleans Parish Louisiana 2034\n", "6 2.2071e+10 Census Tract 6.02 Orleans Parish Louisiana 2957\n", " total.housing.units.00 occupied.housing.units.00 vacant.housing.units.00\n", "1 1408 1145 263\n", "2 691 496 195\n", "3 719 559 160\n", "4 1034 873 161\n", "5 704 506 198\n", "6 1106 1011 95\n", " population.10 total.housing.units.10 occupied.housing.units.10\n", "1 2455 1513 1229\n", "2 1197 738 496\n", "3 1231 641 467\n", "4 2328 1137 911\n", "5 849 328 269\n", "6 2534 1108 923\n", " vacant.housing.units.10\n", "1 284\n", "2 242\n", "3 174\n", "4 226\n", "5 59\n", "6 185" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# note the use of \"==\" since we are expressing a criterion\n", "orleans <- filter(census.comparison, parish == 'Orleans Parish') \n", "head(orleans)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now we can do some quick calculations with our new merged data frame for New Orleans.\n", "\n", "First question: **What was the population of New Orleans in 2000?**\n", "\n", "That requires summing up the 2000 population column like so:" ] }, { "cell_type": "code", "execution_count": 27, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "[1] NA" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sum(orleans$population.00)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Why didn't this work? Let's inspect the population.00 variable using `summary`:" ] }, { "cell_type": "code", "execution_count": 28, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ " Min. 1st Qu. Median Mean 3rd Qu. Max. NA's \n", " 52 1711 2274 2678 3141 9931 30 " ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "summary(orleans$population.00)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This reveals that there are 30 census tracts that have NA, or missing, values for population.00. By default, R does not compute a sum of a column if there are missing values. We'll have to tell it to ignore these missing values by specifying `na.rm = TRUE`:" ] }, { "cell_type": "code", "execution_count": 29, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "484674" ], "text/latex": [ "484674" ], "text/markdown": [ "484674" ], "text/plain": [ "[1] 484674" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sum(orleans$population.00, na.rm = TRUE)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Second question: **What was the population of New Orleans in 2010?**" ] }, { "cell_type": "code", "execution_count": 30, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "343829" ], "text/latex": [ "343829" ], "text/markdown": [ "343829" ], "text/plain": [ "[1] 343829" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sum(orleans$population.10, na.rm = TRUE)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This matches the story exactly.\n", "\n", "Last question: **What was the percent change in New Orleans population between 2000 and 2010?**\n", "\n", "To do this, we'll first save each population calculation to new objects. Then we'll create another object to store the percent change." ] }, { "cell_type": "code", "execution_count": 31, "metadata": { "collapsed": false }, "outputs": [], "source": [ "nola2000pop <- sum(orleans$population.00, na.rm = TRUE)\n", "nola2010pop <- sum(orleans$population.10, na.rm = TRUE)\n", "\n", "perc.change.nola <- (nola2010pop - nola2000pop)/nola2000pop * 100" ] }, { "cell_type": "code", "execution_count": 32, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[1] \"The percent change in New Orleans population since 2000 is -29%\"\n" ] } ], "source": [ "print(paste('The percent change in New Orleans population since 2000 is ', round(perc.change.nola), '%', sep =''))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Again, we see that this matches the 29% drop cited by [The Times-Picayune article]( http://www.nola.com/politics/index.ssf/2011/02/new_orleans_officials_2010_pop.html). Yay!" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This concludes our workshop, Getting started with R. \n", "\n", "We'll use the merged data CSV we saved above to do further analysis in our next workshop, [More with R](http://www.ire.org/events-and-training/event/2199/2638/). Take a sneak peak at the notebook [here](More%20with%20R.ipynb).\n", "\n", "Any questions?\n", "\n", "* christine.zhang@latimes.com or [@christinezhang](https://twitter.com/christinezhang) on Twitter\n", "* ryan.menezes@latimes.com or [@ryanvmenezes](https://twitter.com/ryanvmenezes) on Twitter" ] } ], "metadata": { "kernelspec": { "display_name": "R", "language": "R", "name": "ir" }, "language_info": { "codemirror_mode": "r", "file_extension": ".r", "mimetype": "text/x-r-source", "name": "R", "pygments_lexer": "r", "version": "3.2.2" } }, "nbformat": 4, "nbformat_minor": 0 }