US Census Demographic Data

Demographic and Economic Data for Tracts and Counties

@kaggle.muonneutrino_us_census_demographic_data

Table List

4 tables(9.28 MB)

Acs2015 Census Tract Data

Acs2015 County Data

Acs2017 Census Tract Data

Acs2017 County Data

Acs2017 Census Tract Data

@kaggle.muonneutrino_us_census_demographic_data.acs2017_census_tract_data

4.34 MB
74001 rows
37 columns

tractid TractId	state State	county County	totalpop TotalPop	men Men	women Women	hispanic Hispanic	white White	black Black	native Native	asian Asian	pacific Pacific	votingagecitizen VotingAgeCitizen	income Income	incomeerr IncomeErr	incomepercap IncomePerCap	incomepercaperr IncomePerCapErr	poverty Poverty	childpoverty ChildPoverty	professional Professional	service Service	office Office	construction Construction	production Production	drive Drive	carpool Carpool	walk Walk	othertransp OtherTransp	workathome WorkAtHome	meancommute MeanCommute	employed Employed	privatework PrivateWork	publicwork PublicWork	selfemployed SelfEmployed	familywork FamilyWork	unemployment Unemployment
1001020100	Alabama	Autauga County	1845	899	946	2.4	86.3	5.2		1.2		1407	67826	14560	33018	6294	10.7	20.8	38.5	15.6	22.8	10.8	12.4	94.2	3.3	0.5		2.1	24.5	881	74.2	21.2	4.5		4.6
1001020200	Alabama	Autauga County	2172	1167	1005	1.1	41.6	54.5		1		1652	41287	3819	18996	2453	22.4	35.8	30.5	24.9	22.9	6.3	15.4	90.5	9.1		0.5		22.2	852	75.9	15	9		3.4
1001020300	Alabama	Autauga County	3385	1533	1852	8	61.4	26.5	0.6	0.7	0.4	2480	46806	9496	21236	2562	14.7	21.1	27.9	19.4	33.3	9.9	9.6	88.3	8.4	1	0.8	1.5	23.1	1482	73.3	21.1	4.8	0.7	4.7
1001020400	Alabama	Autauga County	4267	2001	2266	9.6	80.3	7.1	0.5	0.2		3257	55895	4369	28068	3190	2.3	1.7	29	16.6	25.8	9.1	19.5	82.3	11.2	1.5	2.9	2.1	25.9	1849	75.8	19.7	4.5		6.1
1001020500	Alabama	Autauga County	9965	5054	4911	0.9	77.5	16.4		3.1		7229	68143	14424	36905	10706	12.2	17.9	48.8	13.8	20.5	3.5	13.4	86.9	11.2	0.8	0.3	0.7	21	4787	71.4	24.1	4.5		2.3
1001020600	Alabama	Autauga County	3620	1765	1855	3	70.7	25.1				2687	44549	16126	27038	4427	13.6	20.2	25.2	24.6	29	8.1	13.1	83	4.8	0.7	3.5	8	21.1	1364	84	14.1	1.9		6.1
1001020700	Alabama	Autauga County	3420	1459	1961	4	78	13.7	0.6			2538	41250	16811	19028	2587	27	27.7	25.4	35	21.6	5.6	12.4	89	11				16.4	1418	77.4	17.6	5		16.9
1001020801	Alabama	Autauga County	2913	1495	1418	4.2	86.3	7.1	1.5			2163	80089	13397	36631	5174	12	25.1	46	9.1	30.6	8.3	6	89.5	4.6		0.7	5.2	24.6	1369	72.7	17.5	8.8	1	7.2
1001020802	Alabama	Autauga County	11333	5488	5845	1.4	81.8	15.3		1		8248	64439	8677	26621	2187	14.7	21.8	36.8	20.2	19.6	9.3	14	89.1	8.7			2.2	27.4	4857	70.1	22.5	7.4		2.2
1001020900	Alabama	Autauga County	6167	3111	3056	1	86.2	9.7	0.8	0.3		4710	49469	15517	26726	3839	9.4	13.2	32.3	12.7	20.1	6.4	28.6	77.2	11.9		5	5.9	35.6	2781	80.4	14.5	5		6.8


CREATE TABLE acs2017_census_tract_data (
  "tractid" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "totalpop" BIGINT,
  "men" BIGINT,
  "women" BIGINT,
  "hispanic" DOUBLE,
  "white" DOUBLE,
  "black" DOUBLE,
  "native" DOUBLE,
  "asian" DOUBLE,
  "pacific" DOUBLE,
  "votingagecitizen" BIGINT,
  "income" DOUBLE,
  "incomeerr" DOUBLE,
  "incomepercap" DOUBLE,
  "incomepercaperr" DOUBLE,
  "poverty" DOUBLE,
  "childpoverty" DOUBLE,
  "professional" DOUBLE,
  "service" DOUBLE,
  "office" DOUBLE,
  "construction" DOUBLE,
  "production" DOUBLE,
  "drive" DOUBLE,
  "carpool" DOUBLE,
  "transit" DOUBLE,
  "walk" DOUBLE,
  "othertransp" DOUBLE,
  "workathome" DOUBLE,
  "meancommute" DOUBLE,
  "employed" BIGINT,
  "privatework" DOUBLE,
  "publicwork" DOUBLE,
  "selfemployed" DOUBLE,
  "familywork" DOUBLE,
  "unemployment" DOUBLE
);