covid

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Custom SQL query returning 165 rows (hide)

with filtered as ( select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where state = 'Kentucky' ), rows as ( select null as facet, null as favet_name, null as facet_value, rowid, date, county, state, fips, cases, deaths from filtered order by date desc limit 101 ), count as ( select 'COUNT' as facet, null as facet_name, count(*) as facet_value, null, null, null, null, null, null, null from filtered ), facet_state as ( select 'state' as facet, state as facet_name, count(*) as facet_value, null, null, null, null, null, null, null from filtered group by facet_name order by facet_value desc limit 31 ), facet_county as ( select 'county' as facet, county as facet_name, count(*) as facet_value, null, null, null, null, null, null, null from filtered group by facet_name order by facet_value desc limit 31 ), facet_fips as ( select 'fips' as facet, fips as facet_name, count(*) as facet_value, null, null, null, null, null, null, null from filtered group by facet_name order by facet_value desc limit 31 ) select * from rows union all select * from count union all select * from facet_state union all select * from facet_county union all select * from facet_fips

This data as json, yaml, Notebook, copyable, CSV

facet	favet_name	facet_value	rowid	date	county	state	fips	cases	deaths
			2500579	2022-05-13	Adair	Kentucky	21001	5929	107
			2500580	2022-05-13	Allen	Kentucky	21003	6601	107
			2500581	2022-05-13	Anderson	Kentucky	21005	6620	70
			2500582	2022-05-13	Ballard	Kentucky	21007	1387	29
			2500583	2022-05-13	Barren	Kentucky	21009	13032	219
			2500584	2022-05-13	Bath	Kentucky	21011	3210	48
			2500585	2022-05-13	Bell	Kentucky	21013	8868	149
			2500586	2022-05-13	Boone	Kentucky	21015	40084	297
			2500587	2022-05-13	Bourbon	Kentucky	21017	6002	59
			2500588	2022-05-13	Boyd	Kentucky	21019	16369	177
			2500589	2022-05-13	Boyle	Kentucky	21021	8473	132
			2500590	2022-05-13	Bracken	Kentucky	21023	2186	26
			2500591	2022-05-13	Breathitt	Kentucky	21025	3801	54
			2500592	2022-05-13	Breckinridge	Kentucky	21027	5170	78
			2500593	2022-05-13	Bullitt	Kentucky	21029	21805	223
			2500594	2022-05-13	Butler	Kentucky	21031	3874	54
			2500595	2022-05-13	Caldwell	Kentucky	21033	4158	61
			2500596	2022-05-13	Calloway	Kentucky	21035	8414	94
			2500597	2022-05-13	Campbell	Kentucky	21037	25104	178
			2500598	2022-05-13	Carlisle	Kentucky	21039	1076	20
			2500599	2022-05-13	Carroll	Kentucky	21041	3504	45
			2500600	2022-05-13	Carter	Kentucky	21043	8675	107
			2500601	2022-05-13	Casey	Kentucky	21045	4216	74
			2500602	2022-05-13	Christian	Kentucky	21047	16376	210
			2500603	2022-05-13	Clark	Kentucky	21049	10749	68
			2500604	2022-05-13	Clay	Kentucky	21051	7867	92
			2500605	2022-05-13	Clinton	Kentucky	21053	3674	52
			2500606	2022-05-13	Crittenden	Kentucky	21055	2292	50
			2500607	2022-05-13	Cumberland	Kentucky	21057	2238	33
			2500608	2022-05-13	Daviess	Kentucky	21059	31176	391
			2500609	2022-05-13	Edmonson	Kentucky	21061	2563	47
			2500610	2022-05-13	Elliott	Kentucky	21063	2594	19
			2500611	2022-05-13	Estill	Kentucky	21065	4120	50
			2500612	2022-05-13	Fayette	Kentucky	21067	95993	609
			2500613	2022-05-13	Fleming	Kentucky	21069	3928	59
			2500614	2022-05-13	Floyd	Kentucky	21071	12571	206
			2500615	2022-05-13	Franklin	Kentucky	21073	13911	153
			2500616	2022-05-13	Fulton	Kentucky	21075	1218	31
			2500617	2022-05-13	Gallatin	Kentucky	21077	2221	51
			2500618	2022-05-13	Garrard	Kentucky	21079	4815	78
			2500619	2022-05-13	Grant	Kentucky	21081	7855	62
			2500620	2022-05-13	Graves	Kentucky	21083	11355	181
			2500621	2022-05-13	Grayson	Kentucky	21085	8014	134
			2500622	2022-05-13	Green	Kentucky	21087	3761	45
			2500623	2022-05-13	Greenup	Kentucky	21089	12124	145
			2500624	2022-05-13	Hancock	Kentucky	21091	2498	25
			2500625	2022-05-13	Hardin	Kentucky	21093	32778	434
			2500626	2022-05-13	Harlan	Kentucky	21095	9222	211
			2500627	2022-05-13	Harrison	Kentucky	21097	6417	76
			2500628	2022-05-13	Hart	Kentucky	21099	5428	101
			2500629	2022-05-13	Henderson	Kentucky	21101	13972	168
			2500630	2022-05-13	Henry	Kentucky	21103	4836	52
			2500631	2022-05-13	Hickman	Kentucky	21105	879	27
			2500632	2022-05-13	Hopkins	Kentucky	21107	14975	255
			2500633	2022-05-13	Jackson	Kentucky	21109	4286	80
			2500634	2022-05-13	Jefferson	Kentucky	21111	234899	2357
			2500635	2022-05-13	Jessamine	Kentucky	21113	15289	139
			2500636	2022-05-13	Johnson	Kentucky	21115	6173	118
			2500637	2022-05-13	Kenton	Kentucky	21117	46264	415
			2500638	2022-05-13	Knott	Kentucky	21119	4233	64
			2500639	2022-05-13	Knox	Kentucky	21121	11523	144
			2500640	2022-05-13	Larue	Kentucky	21123	3741	73
			2500641	2022-05-13	Laurel	Kentucky	21125	20315	242
			2500642	2022-05-13	Lawrence	Kentucky	21127	4503	69
			2500643	2022-05-13	Lee	Kentucky	21129	2951	52
			2500644	2022-05-13	Leslie	Kentucky	21131	3723	49
			2500645	2022-05-13	Letcher	Kentucky	21133	7140	114
			2500646	2022-05-13	Lewis	Kentucky	21135	4529	86
			2500647	2022-05-13	Lincoln	Kentucky	21137	6487	137
			2500648	2022-05-13	Livingston	Kentucky	21139	2482	61
			2500649	2022-05-13	Logan	Kentucky	21141	8369	126
			2500650	2022-05-13	Lyon	Kentucky	21143	2881	34
			2500651	2022-05-13	Madison	Kentucky	21151	27833	280
			2500652	2022-05-13	Magoffin	Kentucky	21153	3950	51
			2500653	2022-05-13	Marion	Kentucky	21155	6433	85
			2500654	2022-05-13	Marshall	Kentucky	21157	8421	112
			2500655	2022-05-13	Martin	Kentucky	21159	3308	49
			2500656	2022-05-13	Mason	Kentucky	21161	5017	105
			2500657	2022-05-13	McCracken	Kentucky	21145	18502	263
			2500658	2022-05-13	McCreary	Kentucky	21147	5727	82
			2500659	2022-05-13	McLean	Kentucky	21149	2621	53
			2500660	2022-05-13	Meade	Kentucky	21163	5821	66
			2500661	2022-05-13	Menifee	Kentucky	21165	1706	32
			2500662	2022-05-13	Mercer	Kentucky	21167	7401	106
			2500663	2022-05-13	Metcalfe	Kentucky	21169	2875	64
			2500664	2022-05-13	Monroe	Kentucky	21171	3624	77
			2500665	2022-05-13	Montgomery	Kentucky	21173	8200	108
			2500666	2022-05-13	Morgan	Kentucky	21175	5272	28
			2500667	2022-05-13	Muhlenberg	Kentucky	21177	10190	121
			2500668	2022-05-13	Nelson	Kentucky	21179	14507	153
			2500669	2022-05-13	Nicholas	Kentucky	21181	2105	31
			2500670	2022-05-13	Ohio	Kentucky	21183	7313	103
			2500671	2022-05-13	Oldham	Kentucky	21185	18515	145
			2500672	2022-05-13	Owen	Kentucky	21187	2370	34
			2500673	2022-05-13	Owsley	Kentucky	21189	1574	27
			2500674	2022-05-13	Pendleton	Kentucky	21191	3498	38
			2500675	2022-05-13	Perry	Kentucky	21193	11040	178
			2500676	2022-05-13	Pike	Kentucky	21195	19099	307
			2500677	2022-05-13	Powell	Kentucky	21197	4782	44
			2500678	2022-05-13	Pulaski	Kentucky	21199	18157	293
			2500679	2022-05-13	Robertson	Kentucky	21201	672	21
COUNT		92572
state	Kentucky	92572
county	Fayette	799
county	Jefferson	797
county	Harrison	797
county	Montgomery	793
county	Nelson	791
county	Bourbon	791
county	Clark	790
county	Lyon	788
county	Warren	787
county	Kenton	787
county	Franklin	787
county	Scott	786
county	Pulaski	786
county	Henderson	786
county	Daviess	786
county	Christian	786
county	Calloway	785
county	Spencer	784
county	Madison	784
county	Anderson	784
county	Oldham	783
county	Jessamine	783
county	Hardin	783
county	Breathitt	783
county	Allen	783
county	Logan	782
county	Simpson	781
county	Muhlenberg	781
county	Menifee	781
county	McCracken	781
county	Martin	781
fips	21067	799
fips	21111	797
fips	21097	797
fips	21173	793
fips	21179	791
fips	21017	791
fips	21049	790
fips	21143	788
fips	21227	787
fips	21117	787
fips	21073	787
fips	21209	786
fips	21199	786
fips	21101	786
fips	21059	786
fips	21047	786
fips	21035	785
fips	21215	784
fips	21151	784
fips	21005	784
fips	21185	783
fips	21113	783
fips	21093	783
fips	21025	783
fips	21003	783
fips	21141	782
fips	21213	781
fips	21177	781
fips	21165	781
fips	21159	781
fips	21145	781