Census.gov

Data from the census.gov QuickFacts site.

@kaggle.willianoliveiragibin_census_gov

Table List

1 table(63.5 KB)

Census State Quickfacts New

@kaggle.willianoliveiragibin_census_gov.census_state_quickfacts_new

63.5 KB
89 rows
52 columns

people People	alaska Alaska	georgia Georgia	hawaii Hawaii	idaho Idaho	illinois Illinois	indiana Indiana	iowa Iowa	kansas Kansas	kentucky Kentucky	louisiana Louisiana	maine Maine	arizona Arizona	maryland Maryland	massachusetts Massachusetts	michigan Michigan	minnesota Minnesota	missouri Missouri	mississippi Mississippi	montana Montana	nebraska Nebraska	nevada Nevada	new_hampshire New Hampshire	arkansas Arkansas	new_jersey New Jersey	new_mexico New Mexico	new_york New York	north_carolina North Carolina	north_dakota North Dakota	ohio Ohio	oklahoma Oklahoma	oregon Oregon	pennsylvania Pennsylvania	rhode_island Rhode Island	california California	south_carolina South Carolina	south_dakota South Dakota	tennessee Tennessee	texas Texas	utah Utah	vermont Vermont	virginia Virginia	washington Washington	west_virginia West Virginia	wisconsin Wisconsin	colorado Colorado	wyoming Wyoming	connecticut Connecticut	delaware Delaware	district_of_columbia District Of Columbia	florida Florida	alabama Alabama
Population	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Population estimates; July 1; 2016; (V2016)	741894	10310371	1428557	1683140	12801539	6633053	3134693	2907289	4436974	4681666	1331479	6931071	6016447	6811779	9928300	5519952	6093000	2988726	1042520	1907116	2940058	1334795	2988248	8944469	2081015	19745289	10146788	757952	11614373	3923561	4093465	12784227	1056426	39250017	4961119	865454	6651194	27862596	3051217	624594	8411808	7288000	1831102	5778708	5540545	585501	3576452	952065	681170	20612439	4863300
Population estimates; July 1; 2015; (V2015)	738432	10214860	1431603	1654930	12859995	6619680	3123899	2911641	4425092	4670724	1329328	6828065	6006401	6794422	9922576	5489594	6083672	2992333	1032949	1896190	2890845	1330608	2978204	8958013	2085109	19795791	10042802	756927	11613423	3911338	4028977	12802503	1056298	39144818	4896146	858469	6600299	27469114	2995919	626042	8382993	7170351	1844128	5771337	5456574	586107	3590886	945934	672228	20271272	4858979
Population estimates base; April 1; 2010; (V2016)	710249	9688680	1360301	1567650	12831574	6484136	3046869	2853129	4339344	4533479	1328364	6392301	5773786	6547813	9884129	5303924	5988928	2968103	989414	1826334	2700691	1316461	2916025	8791953	2059198	19378110	9535688	672591	11536727	3751615	3831072	12702857	1052940	37254522	4625410	814195	6346298	25146100	2763888	625741	8001041	6724545	1853011	5687289	5029324	563767	3574114	897936	601766	18804592	4780131
Population estimates base; April 1; 2010; (V2015)	710249	9688681	1360301	1567652	12831549	6484229	3046869	2853132	4339349	4533479	1328361	6392307	5773785	6547817	9884129	5303925	5988927	2968103	989417	1826341	2700691	1316466	2915958	8791936	2059192	19378087	9535692	672591	11536725	3751616	3831073	12702887	1052931	37254503	4625401	814191	6346275	25146105	2763888	625745	8001045	6724543	1853011	5687289	5029324	563767	3574118	897936	601767	18804623	4780127
Population; percent change - April 1; 2010 (estimates base) to July 1; 2016; (V2016)	4.5	6.4	5	7.4	-0.2	2.3	2.9	1.9	2.2	3.3	0.2	8.4	4.2	4	0.4	4.1	1.7	0.7	5.4	4.4	8.9	1.4	2.5	1.7	1.1	1.9	6.4	12.7	0.7	4.6	6.8	0.6	0.3	5.4	7.3	6.3	4.8	10.8	10.4	-0.2	5.1	8.4	-1.2	1.6	10.2	3.9	0.1	6	13.2	9.6	1.7
Population; percent change - April 1; 2010 (estimates base) to July 1; 2015; (V2015)	4	5.4	5.2	5.6	0.2	2.1	2.5	2.1	2	3	0.1	6.8	4	3.8	0.4	3.5	1.6	0.8	4.4	3.8	7	1.1	2.1	1.9	1.3	2.2	5.3	12.5	0.7	4.3	5.2	0.8	0.3	5.1	5.9	5.4	4	9.2	8.4	Z	4.8	6.6	-0.5	1.5	8.5	4	0.5	5.3	11.7	7.8	1.6
Population; Census; April 1; 2010	710231	9687653	1360301	1567582	12830632	6483802	3046355	2853118	4339367	4533372	1328361	6392017	5773552	6547629	9883640	5303925	5988927	2967297	989415	1826341	2700551	1316470	2915918	8791894	2059179	19378102	9535483	672591	11536504	3751351	3831074	12702379	1052567	37253956	4625364	814180	6346105	25145561	2763885	625741	8001024	6724540	1852994	5686986	5029196	563626	3574097	897934	601723	18801310	4779736
Age and Sex	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Persons under 5 years; percent; July 1; 2015; (V2015)	7.5	6.5	6.5	6.8	6.1	6.3	6.3	6.8	6.3	6.7	4.9	6.3	6.1	5.4	5.8	6.4	6.2	6.4	6	6.9	6.1	4.9	6.4	5.9	6.5	6	6	7	6	6.9	5.7	5.6	5.2	6.4	5.9	7.1	6.1	7.2	8.4	4.9	6.1	6.2	5.6	5.9	6.2	6.6	5.2	5.9	6.4	5.4	6


CREATE TABLE census_state_quickfacts_new (
  "people" VARCHAR,
  "alaska" VARCHAR,
  "georgia" VARCHAR,
  "hawaii" VARCHAR,
  "idaho" VARCHAR,
  "illinois" VARCHAR,
  "indiana" VARCHAR,
  "iowa" VARCHAR,
  "kansas" VARCHAR,
  "kentucky" VARCHAR,
  "louisiana" VARCHAR,
  "maine" VARCHAR,
  "arizona" VARCHAR,
  "maryland" VARCHAR,
  "massachusetts" VARCHAR,
  "michigan" VARCHAR,
  "minnesota" VARCHAR,
  "missouri" VARCHAR,
  "mississippi" VARCHAR,
  "montana" VARCHAR,
  "nebraska" VARCHAR,
  "nevada" VARCHAR,
  "new_hampshire" VARCHAR,
  "arkansas" VARCHAR,
  "new_jersey" VARCHAR,
  "new_mexico" VARCHAR,
  "new_york" VARCHAR,
  "north_carolina" VARCHAR,
  "north_dakota" VARCHAR,
  "ohio" VARCHAR,
  "oklahoma" VARCHAR,
  "oregon" VARCHAR,
  "pennsylvania" VARCHAR,
  "rhode_island" VARCHAR,
  "california" VARCHAR,
  "south_carolina" VARCHAR,
  "south_dakota" VARCHAR,
  "tennessee" VARCHAR,
  "texas" VARCHAR,
  "utah" VARCHAR,
  "vermont" VARCHAR,
  "virginia" VARCHAR,
  "washington" VARCHAR,
  "west_virginia" VARCHAR,
  "wisconsin" VARCHAR,
  "colorado" VARCHAR,
  "wyoming" VARCHAR,
  "connecticut" VARCHAR,
  "delaware" VARCHAR,
  "district_of_columbia" VARCHAR,
  "florida" VARCHAR,
  "alabama" VARCHAR
);