BIGTOP-1986. Extract location dataset from BigPetStore data generator
Project: http://git-wip-us.apache.org/repos/asf/bigtop/repo Commit: http://git-wip-us.apache.org/repos/asf/bigtop/commit/74a66b1e Tree: http://git-wip-us.apache.org/repos/asf/bigtop/tree/74a66b1e Diff: http://git-wip-us.apache.org/repos/asf/bigtop/diff/74a66b1e Branch: refs/heads/master Commit: 74a66b1e8e0a3721f834bd9c36b826a68b494d34 Parents: caae595 Author: RJ Nowling <[email protected]> Authored: Wed Aug 26 08:53:19 2015 -0500 Committer: RJ Nowling <[email protected]> Committed: Wed Aug 26 08:53:19 2015 -0500 ---------------------------------------------------------------------- .../datamodels/inputs/ZipcodeRecord.java | 90 - .../bigpetstore/datareaders/ZipcodeReader.java | 193 - .../ACS_12_5YR_S1903/ACS_12_5YR_S1903.txt | 33 - .../ACS_12_5YR_S1903_metadata.csv | 123 - .../ACS_12_5YR_S1903_with_ann.csv | 33122 ---------------- .../resources/input_data/population_data.csv | 33090 ---------------- .../src/main/resources/input_data/zips.csv | 33179 ----------------- .../bigtop-location-data/README.md | 50 + .../bigtop-location-data/build.gradle | 63 + .../bigtop-location-data/settings.gradle | 16 + .../datagenerators/locations/Location.java | 90 + .../locations/LocationConstants.java | 25 + .../locations/LocationReader.java | 182 + .../ACS_12_5YR_S1903/ACS_12_5YR_S1903.txt | 33 + .../ACS_12_5YR_S1903_metadata.csv | 123 + .../ACS_12_5YR_S1903_with_ann.csv | 33122 ++++++++++++++++ .../resources/input_data/population_data.csv | 33090 ++++++++++++++++ .../src/main/resources/input_data/zips.csv | 33179 +++++++++++++++++ 18 files changed, 99973 insertions(+), 99830 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/bigtop/blob/74a66b1e/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datamodels/inputs/ZipcodeRecord.java ---------------------------------------------------------------------- diff --git a/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datamodels/inputs/ZipcodeRecord.java b/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datamodels/inputs/ZipcodeRecord.java deleted file mode 100644 index e5eeb60..0000000 --- a/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datamodels/inputs/ZipcodeRecord.java +++ /dev/null @@ -1,90 +0,0 @@ -/** - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed with - * this work for additional information regarding copyright ownership. - * The ASF licenses this file to You under the Apache License, Version 2.0 - * (the "License"); you may not use this file except in compliance with - * the License. You may obtain a copy of the License at - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, software - * distributed under the License is distributed on an "AS IS" BASIS, - * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - * See the License for the specific language governing permissions and - * limitations under the License. - */ -package org.apache.bigtop.datagenerators.bigpetstore.datamodels.inputs; - -import java.io.Serializable; - -import org.apache.commons.lang3.tuple.Pair; - -public class ZipcodeRecord implements Serializable -{ - private static final long serialVersionUID = 1769986686070108470L; - - final String zipcode; - final Pair<Double, Double> coordinates; - final String city; - final String state; - final double medianHouseholdIncome; - final long population; - - public ZipcodeRecord(String zipcode, Pair<Double, Double> coordinates, - String city, String state, double medianHouseholdIncome, long population) - { - this.city = city; - this.state = state; - this.zipcode = zipcode; - this.coordinates = coordinates; - this.medianHouseholdIncome = medianHouseholdIncome; - this.population = population; - } - - public String getZipcode() - { - return zipcode; - } - - public Pair<Double, Double> getCoordinates() - { - return coordinates; - } - - public double getMedianHouseholdIncome() - { - return medianHouseholdIncome; - } - - public long getPopulation() - { - return population; - } - - public double distance(ZipcodeRecord other) - { - if(other.getZipcode().equals(zipcode)) - return 0.0; - - Pair<Double, Double> otherCoords = other.getCoordinates(); - - double dist = Math.sin(Math.toRadians(coordinates.getLeft())) * - Math.sin(Math.toRadians(otherCoords.getLeft())) + - Math.cos(Math.toRadians(coordinates.getLeft())) * - Math.cos(Math.toRadians(otherCoords.getLeft())) * - Math.cos(Math.toRadians(coordinates.getRight() - otherCoords.getRight())); - dist = Math.toDegrees(Math.acos(dist)) * 69.09; - - return dist; - } - - public String getCity() - { - return city; - } - - public String getState() - { - return state; - } -} http://git-wip-us.apache.org/repos/asf/bigtop/blob/74a66b1e/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datareaders/ZipcodeReader.java ---------------------------------------------------------------------- diff --git a/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datareaders/ZipcodeReader.java b/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datareaders/ZipcodeReader.java deleted file mode 100644 index 2478c8e..0000000 --- a/bigtop-data-generators/bigpetstore-data-generator/src/main/java/org/apache/bigtop/datagenerators/bigpetstore/datareaders/ZipcodeReader.java +++ /dev/null @@ -1,193 +0,0 @@ -/** - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed with - * this work for additional information regarding copyright ownership. - * The ASF licenses this file to You under the Apache License, Version 2.0 - * (the "License"); you may not use this file except in compliance with - * the License. You may obtain a copy of the License at - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, software - * distributed under the License is distributed on an "AS IS" BASIS, - * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - * See the License for the specific language governing permissions and - * limitations under the License. - */ -package org.apache.bigtop.datagenerators.bigpetstore.datareaders; - -import java.io.FileNotFoundException; -import java.io.InputStream; -import java.util.HashSet; -import java.util.List; -import java.util.Map; -import java.util.Scanner; -import java.util.Set; -import java.util.Vector; - -import org.apache.bigtop.datagenerators.bigpetstore.datamodels.inputs.ZipcodeRecord; -import org.apache.commons.lang3.tuple.Pair; - -import com.google.common.collect.ImmutableList; -import com.google.common.collect.ImmutableMap; -import com.google.common.collect.Maps; - -public class ZipcodeReader -{ - private static class ZipcodeLocationRecord - { - public final Pair<Double, Double> coordinates; - public final String state; - public final String city; - - public ZipcodeLocationRecord(Pair<Double, Double> coordinates, - String city, String state) - { - this.coordinates = coordinates; - this.city = city; - this.state = state; - } - } - - InputStream zipcodeIncomesFile = null; - InputStream zipcodePopulationFile = null; - InputStream zipcodeCoordinatesFile = null; - - public void setIncomesFile(InputStream path) - { - this.zipcodeIncomesFile = path; - } - - public void setPopulationFile(InputStream path) - { - this.zipcodePopulationFile = path; - } - - public void setCoordinatesFile(InputStream path) - { - this.zipcodeCoordinatesFile = path; - } - - private ImmutableMap<String, Double> readIncomeData(InputStream path) throws FileNotFoundException - { - Scanner scanner = new Scanner(path); - - // skip headers - scanner.nextLine(); - scanner.nextLine(); - - Map<String, Double> entries = Maps.newHashMap(); - while(scanner.hasNextLine()) - { - String line = scanner.nextLine().trim(); - String[] cols = line.split(","); - // zipcodes are in the form "ZCTA5 XXXXX" - String zipcode = cols[2].split(" ")[1].trim(); - try - { - double medianHouseholdIncome = Integer.parseInt(cols[5].trim()); - entries.put(zipcode, medianHouseholdIncome); - } - catch(NumberFormatException e) - { - - } - } - - scanner.close(); - - return ImmutableMap.copyOf(entries); - } - - private ImmutableMap<String, Long> readPopulationData(InputStream path) throws FileNotFoundException - { - Scanner scanner = new Scanner(path); - - // skip header - scanner.nextLine(); - - Map<String, Long> entries = Maps.newHashMap(); - while(scanner.hasNextLine()) - { - String line = scanner.nextLine().trim(); - - if(line.length() == 0) - continue; - - String[] cols = line.split(","); - - String zipcode = cols[0].trim(); - Long population = Long.parseLong(cols[1].trim()); - - if(entries.containsKey(zipcode)) - { - entries.put(zipcode, Math.max(entries.get(zipcode), population)); - } - else - { - entries.put(zipcode, population); - } - } - - scanner.close(); - - return ImmutableMap.copyOf(entries); - } - - private ImmutableMap<String, ZipcodeLocationRecord> readCoordinates(InputStream path) throws FileNotFoundException - { - Scanner scanner = new Scanner(path); - - // skip header - scanner.nextLine(); - - Map<String, ZipcodeLocationRecord> entries = Maps.newHashMap(); - while(scanner.hasNextLine()) - { - String line = scanner.nextLine().trim(); - - String[] cols = line.split(", "); - - // remove quote marks - String zipcode = cols[0].substring(1, cols[0].length() - 1); - String state = cols[1].substring(1, cols[1].length() - 1); - Double latitude = Double.parseDouble(cols[2].substring(1, cols[2].length() - 1)); - Double longitude = Double.parseDouble(cols[3].substring(1, cols[3].length() - 1)); - String city = cols[4].substring(1, cols[4].length() - 1); - - Pair<Double, Double> coords = Pair.of(latitude, longitude); - - ZipcodeLocationRecord record = new ZipcodeLocationRecord(coords, city, state); - - entries.put(zipcode, record); - } - - scanner.close(); - - return ImmutableMap.copyOf(entries); - } - - public ImmutableList<ZipcodeRecord> readData() throws FileNotFoundException - { - ImmutableMap<String, Double> incomes = readIncomeData(this.zipcodeIncomesFile); - ImmutableMap<String, Long> populations = readPopulationData(this.zipcodePopulationFile); - ImmutableMap<String, ZipcodeLocationRecord> coordinates = readCoordinates(this.zipcodeCoordinatesFile); - - Set<String> zipcodeSubset = new HashSet<String>(incomes.keySet()); - zipcodeSubset.retainAll(populations.keySet()); - zipcodeSubset.retainAll(coordinates.keySet()); - - List<ZipcodeRecord> table = new Vector<ZipcodeRecord>(); - for(String zipcode : zipcodeSubset) - { - ZipcodeRecord record = new ZipcodeRecord(zipcode, - coordinates.get(zipcode).coordinates, - coordinates.get(zipcode).city, - coordinates.get(zipcode).state, - incomes.get(zipcode), - populations.get(zipcode)); - table.add(record); - } - - return ImmutableList.copyOf(table); - } -} http://git-wip-us.apache.org/repos/asf/bigtop/blob/74a66b1e/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903.txt ---------------------------------------------------------------------- diff --git a/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903.txt b/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903.txt deleted file mode 100755 index 7127f90..0000000 --- a/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903.txt +++ /dev/null @@ -1,33 +0,0 @@ -S1903 -MEDIAN INCOME IN THE PAST 12 MONTHS (IN 2012 INFLATION-ADJUSTED DOLLARS) - -Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns and estimates of housing units for states and counties. - - -Supporting documentation on code lists, subject definitions, data accuracy, and statistical testing can be found on the American Community Survey website in the Data and Documentation section. - -Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section. - - -Source: U.S. Census Bureau, 2008-2012 American Community Survey - - -Explanation of Symbols:An '**' entry in the margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate. -An '-' entry in the estimate column indicates that either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution. -An '-' following a median estimate means the median falls in the lowest interval of an open-ended distribution. -An '+' following a median estimate means the median falls in the upper interval of an open-ended distribution. -An '***' entry in the margin of error column indicates that the median falls in the lowest interval or upper interval of an open-ended distribution. A statistical test is not appropriate. -An '*****' entry in the margin of error column indicates that the estimate is controlled. A statistical test for sampling variability is not appropriate. -An 'N' entry in the estimate and margin of error columns indicates that data for this geographic area cannot be displayed because the number of sample cases is too small. -An '(X)' means that the estimate is not applicable or not available. - - -Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see Accuracy of the Data). The effect of nonsampling error is not represented in these tables. - - -While the 2008-2012 American Community Survey (ACS) data generally reflect the December 2009 Office of Management and Budget (OMB) definitions of metropolitan and micropolitan statistical areas; in certain instances the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB definitions due to differences in the effective dates of the geographic entities. - - -Estimates of urban and rural population, housing units, and characteristics reflect boundaries of urban areas defined based on Census 2000 data. Boundaries for urban areas have not been updated since Census 2000. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization. - - http://git-wip-us.apache.org/repos/asf/bigtop/blob/74a66b1e/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903_metadata.csv ---------------------------------------------------------------------- diff --git a/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903_metadata.csv b/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903_metadata.csv deleted file mode 100755 index 9f703a3..0000000 --- a/bigtop-data-generators/bigpetstore-data-generator/src/main/resources/input_data/ACS_12_5YR_S1903/ACS_12_5YR_S1903_metadata.csv +++ /dev/null @@ -1,123 +0,0 @@ -GEO.id,Id -GEO.id2,Id2 -GEO.display-label,Geography -HC01_EST_VC02,Total; Estimate; Households -HC01_MOE_VC02,Total; Margin of Error; Households -HC02_EST_VC02,Median income (dollars); Estimate; Households -HC02_MOE_VC02,Median income (dollars); Margin of Error; Households -HC01_EST_VC04,Total; Estimate; One race-- - White -HC01_MOE_VC04,Total; Margin of Error; One race-- - White -HC02_EST_VC04,Median income (dollars); Estimate; One race-- - White -HC02_MOE_VC04,Median income (dollars); Margin of Error; One race-- - White -HC01_EST_VC05,Total; Estimate; One race-- - Black or African American -HC01_MOE_VC05,Total; Margin of Error; One race-- - Black or African American -HC02_EST_VC05,Median income (dollars); Estimate; One race-- - Black or African American -HC02_MOE_VC05,Median income (dollars); Margin of Error; One race-- - Black or African American -HC01_EST_VC06,Total; Estimate; One race-- - American Indian and Alaska Native -HC01_MOE_VC06,Total; Margin of Error; One race-- - American Indian and Alaska Native -HC02_EST_VC06,Median income (dollars); Estimate; One race-- - American Indian and Alaska Native -HC02_MOE_VC06,Median income (dollars); Margin of Error; One race-- - American Indian and Alaska Native -HC01_EST_VC07,Total; Estimate; One race-- - Asian -HC01_MOE_VC07,Total; Margin of Error; One race-- - Asian -HC02_EST_VC07,Median income (dollars); Estimate; One race-- - Asian -HC02_MOE_VC07,Median income (dollars); Margin of Error; One race-- - Asian -HC01_EST_VC08,Total; Estimate; One race-- - Native Hawaiian and Other Pacific Islander -HC01_MOE_VC08,Total; Margin of Error; One race-- - Native Hawaiian and Other Pacific Islander -HC02_EST_VC08,Median income (dollars); Estimate; One race-- - Native Hawaiian and Other Pacific Islander -HC02_MOE_VC08,Median income (dollars); Margin of Error; One race-- - Native Hawaiian and Other Pacific Islander -HC01_EST_VC09,Total; Estimate; One race-- - Some other race -HC01_MOE_VC09,Total; Margin of Error; One race-- - Some other race -HC02_EST_VC09,Median income (dollars); Estimate; One race-- - Some other race -HC02_MOE_VC09,Median income (dollars); Margin of Error; One race-- - Some other race -HC01_EST_VC10,Total; Estimate; Two or more races -HC01_MOE_VC10,Total; Margin of Error; Two or more races -HC02_EST_VC10,Median income (dollars); Estimate; Two or more races -HC02_MOE_VC10,Median income (dollars); Margin of Error; Two or more races -HC01_EST_VC12,Total; Estimate; Hispanic or Latino origin (of any race) -HC01_MOE_VC12,Total; Margin of Error; Hispanic or Latino origin (of any race) -HC02_EST_VC12,Median income (dollars); Estimate; Hispanic or Latino origin (of any race) -HC02_MOE_VC12,Median income (dollars); Margin of Error; Hispanic or Latino origin (of any race) -HC01_EST_VC13,"Total; Estimate; White alone, not Hispanic or Latino" -HC01_MOE_VC13,"Total; Margin of Error; White alone, not Hispanic or Latino" -HC02_EST_VC13,"Median income (dollars); Estimate; White alone, not Hispanic or Latino" -HC02_MOE_VC13,"Median income (dollars); Margin of Error; White alone, not Hispanic or Latino" -HC01_EST_VC16,Total; Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 15 to 24 years -HC01_MOE_VC16,Total; Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 15 to 24 years -HC02_EST_VC16,Median income (dollars); Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 15 to 24 years -HC02_MOE_VC16,Median income (dollars); Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 15 to 24 years -HC01_EST_VC17,Total; Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 25 to 44 years -HC01_MOE_VC17,Total; Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 25 to 44 years -HC02_EST_VC17,Median income (dollars); Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 25 to 44 years -HC02_MOE_VC17,Median income (dollars); Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 25 to 44 years -HC01_EST_VC18,Total; Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 45 to 64 years -HC01_MOE_VC18,Total; Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 45 to 64 years -HC02_EST_VC18,Median income (dollars); Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 45 to 64 years -HC02_MOE_VC18,Median income (dollars); Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 45 to 64 years -HC01_EST_VC19,Total; Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 65 years and over -HC01_MOE_VC19,Total; Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 65 years and over -HC02_EST_VC19,Median income (dollars); Estimate; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 65 years and over -HC02_MOE_VC19,Median income (dollars); Margin of Error; HOUSEHOLD INCOME BY AGE OF HOUSEHOLDER - 65 years and over -HC01_EST_VC23,Total; Estimate; FAMILIES - Families -HC01_MOE_VC23,Total; Margin of Error; FAMILIES - Families -HC02_EST_VC23,Median income (dollars); Estimate; FAMILIES - Families -HC02_MOE_VC23,Median income (dollars); Margin of Error; FAMILIES - Families -HC01_EST_VC24,Total; Estimate; FAMILIES - Families - With own children under 18 years -HC01_MOE_VC24,Total; Margin of Error; FAMILIES - Families - With own children under 18 years -HC02_EST_VC24,Median income (dollars); Estimate; FAMILIES - Families - With own children under 18 years -HC02_MOE_VC24,Median income (dollars); Margin of Error; FAMILIES - Families - With own children under 18 years -HC01_EST_VC25,Total; Estimate; FAMILIES - Families - With no own children under 18 years -HC01_MOE_VC25,Total; Margin of Error; FAMILIES - Families - With no own children under 18 years -HC02_EST_VC25,Median income (dollars); Estimate; FAMILIES - Families - With no own children under 18 years -HC02_MOE_VC25,Median income (dollars); Margin of Error; FAMILIES - Families - With no own children under 18 years -HC01_EST_VC26,Total; Estimate; FAMILIES - Married-couple families -HC01_MOE_VC26,Total; Margin of Error; FAMILIES - Married-couple families -HC02_EST_VC26,Median income (dollars); Estimate; FAMILIES - Married-couple families -HC02_MOE_VC26,Median income (dollars); Margin of Error; FAMILIES - Married-couple families -HC01_EST_VC27,"Total; Estimate; FAMILIES - Female householder, no husband present" -HC01_MOE_VC27,"Total; Margin of Error; FAMILIES - Female householder, no husband present" -HC02_EST_VC27,"Median income (dollars); Estimate; FAMILIES - Female householder, no husband present" -HC02_MOE_VC27,"Median income (dollars); Margin of Error; FAMILIES - Female householder, no husband present" -HC01_EST_VC28,"Total; Estimate; FAMILIES - Male householder, no wife present" -HC01_MOE_VC28,"Total; Margin of Error; FAMILIES - Male householder, no wife present" -HC02_EST_VC28,"Median income (dollars); Estimate; FAMILIES - Male householder, no wife present" -HC02_MOE_VC28,"Median income (dollars); Margin of Error; FAMILIES - Male householder, no wife present" -HC01_EST_VC32,Total; Estimate; NONFAMILY HOUSEHOLDS - Nonfamily households -HC01_MOE_VC32,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Nonfamily households -HC02_EST_VC32,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Nonfamily households -HC02_MOE_VC32,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Nonfamily households -HC01_EST_VC33,Total; Estimate; NONFAMILY HOUSEHOLDS - Female householder -HC01_MOE_VC33,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Female householder -HC02_EST_VC33,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Female householder -HC02_MOE_VC33,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Female householder -HC01_EST_VC34,Total; Estimate; NONFAMILY HOUSEHOLDS - Female householder - Living alone -HC01_MOE_VC34,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Female householder - Living alone -HC02_EST_VC34,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Female householder - Living alone -HC02_MOE_VC34,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Female householder - Living alone -HC01_EST_VC35,Total; Estimate; NONFAMILY HOUSEHOLDS - Female householder - Not living alone -HC01_MOE_VC35,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Female householder - Not living alone -HC02_EST_VC35,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Female householder - Not living alone -HC02_MOE_VC35,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Female householder - Not living alone -HC01_EST_VC36,Total; Estimate; NONFAMILY HOUSEHOLDS - Male householder -HC01_MOE_VC36,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Male householder -HC02_EST_VC36,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Male householder -HC02_MOE_VC36,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Male householder -HC01_EST_VC37,Total; Estimate; NONFAMILY HOUSEHOLDS - Male householder - Living alone -HC01_MOE_VC37,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Male householder - Living alone -HC02_EST_VC37,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Male householder - Living alone -HC02_MOE_VC37,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Male householder - Living alone -HC01_EST_VC38,Total; Estimate; NONFAMILY HOUSEHOLDS - Male householder - Not living alone -HC01_MOE_VC38,Total; Margin of Error; NONFAMILY HOUSEHOLDS - Male householder - Not living alone -HC02_EST_VC38,Median income (dollars); Estimate; NONFAMILY HOUSEHOLDS - Male householder - Not living alone -HC02_MOE_VC38,Median income (dollars); Margin of Error; NONFAMILY HOUSEHOLDS - Male householder - Not living alone -HC01_EST_VC41,Total; Estimate; PERCENT IMPUTED - Household income in the past 12 months -HC01_MOE_VC41,Total; Margin of Error; PERCENT IMPUTED - Household income in the past 12 months -HC02_EST_VC41,Median income (dollars); Estimate; PERCENT IMPUTED - Household income in the past 12 months -HC02_MOE_VC41,Median income (dollars); Margin of Error; PERCENT IMPUTED - Household income in the past 12 months -HC01_EST_VC42,Total; Estimate; PERCENT IMPUTED - Family income in the past 12 months -HC01_MOE_VC42,Total; Margin of Error; PERCENT IMPUTED - Family income in the past 12 months -HC02_EST_VC42,Median income (dollars); Estimate; PERCENT IMPUTED - Family income in the past 12 months -HC02_MOE_VC42,Median income (dollars); Margin of Error; PERCENT IMPUTED - Family income in the past 12 months -HC01_EST_VC43,Total; Estimate; PERCENT IMPUTED - Nonfamily income in the past 12 months -HC01_MOE_VC43,Total; Margin of Error; PERCENT IMPUTED - Nonfamily income in the past 12 months -HC02_EST_VC43,Median income (dollars); Estimate; PERCENT IMPUTED - Nonfamily income in the past 12 months -HC02_MOE_VC43,Median income (dollars); Margin of Error; PERCENT IMPUTED - Nonfamily income in the past 12 months
