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

Acs2015 County Data

@kaggle.muonneutrino_us_census_demographic_data.acs2015_county_data

323.69 KB
3220 rows
37 columns

censusid CensusId	state State	county County	totalpop TotalPop	men Men	women Women	hispanic Hispanic	white White	black Black	native Native	asian Asian	citizen Citizen	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	transit Transit	walk Walk	othertransp OtherTransp	workathome WorkAtHome	meancommute MeanCommute	employed Employed	privatework PrivateWork	publicwork PublicWork	selfemployed SelfEmployed	familywork FamilyWork	unemployment Unemployment
1001	Alabama	Autauga	55221	26745	28476	2.6	75.8	18.5	0.4	1	40725	51281	2391	24974	1080	12.9	18.6	33.2	17	24.2	8.6	17.1	87.5	8.8	0.1	0.5	1.3	1.8	26.5	23986	73.6	20.9	5.5		7.6
1003	Alabama	Baldwin	195121	95314	99807	4.5	83.1	9.5	0.6	0.7	147695	50254	1263	27317	711	13.4	19.2	33.1	17.7	27.1	10.8	11.2	84.7	8.8	0.1	1	1.4	3.9	26.4	85953	81.5	12.3	5.8	0.4	7.5
1005	Alabama	Barbour	26932	14497	12435	4.6	46.2	46.7	0.2	0.4	20714	32964	2973	16824	798	26.7	45.3	26.8	16.1	23.1	10.8	23.1	83.8	10.9	0.4	1.8	1.5	1.6	24.1	8597	71.8	20.8	7.3	0.1	17.6
1007	Alabama	Bibb	22604	12073	10531	2.2	74.5	21.4	0.4	0.1	17495	38678	3995	18431	1618	16.8	27.9	21.5	17.9	17.8	19	23.7	83.2	13.5	0.5	0.6	1.5	0.7	28.8	8294	76.8	16.1	6.7	0.4	8.3
1009	Alabama	Blount	57710	28512	29198	8.6	87.9	1.5	0.3	0.1	42345	45813	3141	20532	708	16.7	27.2	28.5	14.1	23.9	13.5	19.9	84.9	11.2	0.4	0.9	0.4	2.3	34.9	22189	82	13.5	4.2	0.4	7.7
1011	Alabama	Bullock	10678	5660	5018	4.4	22.2	70.7	1.2	0.2	8057	31938	5884	17580	2055	24.6	38.4	18.8	15	19.7	20.1	26.4	74.9	14.9	0.7	5	1.7	2.8	27.5	3865	79.5	15.1	5.4		18
1013	Alabama	Butler	20354	9502	10852	1.2	53.3	43.8	0.1	0.4	15581	32229	1793	18390	714	25.4	39.2	27.5	16.6	21.9	10.3	23.7	84.5	12.4		0.8	0.6	1.7	24.6	7813	77.4	16.2	6.2	0.2	10.9
1015	Alabama	Calhoun	116648	56274	60374	3.5	73	20.3	0.2	0.9	88612	41703	925	21374	489	20.5	31.6	27.3	17.7	24.2	10.5	20.4	85.3	9.4	0.2	1.2	1.2	2.7	24.1	47401	74.1	20.8	5	0.1	12.3
1017	Alabama	Chambers	34079	16258	17821	0.4	57.3	40.3	0.2	0.8	26462	34177	2949	21071	1366	21.6	37.2	23.3	14.5	26.3	11.5	24.4	85.1	11.9	0.2	0.3	0.4	2.1	25.1	13689	85.1	12.1	2.8		8.9
1019	Alabama	Cherokee	26008	12975	13033	1.5	91.7	4.8	0.6	0.3	20600	36296	1710	21811	1556	19.2	30.1	29.3	16	19.5	13.7	21.5	83.9	12.1	0.2	0.6	0.7	2.5	27.4	10155	73.1	18.5	7.9	0.5	7.9


CREATE TABLE acs2015_county_data (
  "censusid" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "totalpop" BIGINT,
  "men" BIGINT,
  "women" BIGINT,
  "hispanic" DOUBLE,
  "white" DOUBLE,
  "black" DOUBLE,
  "native" DOUBLE,
  "asian" DOUBLE,
  "pacific" DOUBLE,
  "citizen" BIGINT,
  "income" DOUBLE,
  "incomeerr" DOUBLE,
  "incomepercap" BIGINT,
  "incomepercaperr" BIGINT,
  "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
);