ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92,572 rows where state = "Kentucky" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 21067 799
- 21097 797
- 21111 797
- 21173 793
- 21017 791
- 21179 791
- 21049 790
- 21143 788
- 21073 787
- 21117 787
- 21227 787
- 21047 786
- 21059 786
- 21101 786
- 21199 786
- 21209 786
- 21035 785
- 21005 784
- 21151 784
- 21215 784
- 21003 783
- 21025 783
- 21093 783
- 21113 783
- 21185 783
- 21141 782
- 21145 781
- 21159 781
- 21165 781
- 21177 781
- …
county >30
- Fayette 799
- Harrison 797
- Jefferson 797
- Montgomery 793
- Bourbon 791
- Nelson 791
- Clark 790
- Lyon 788
- Franklin 787
- Kenton 787
- Warren 787
- Christian 786
- Daviess 786
- Henderson 786
- Pulaski 786
- Scott 786
- Calloway 785
- Anderson 784
- Madison 784
- Spencer 784
- Allen 783
- Breathitt 783
- Hardin 783
- Jessamine 783
- Oldham 783
- Logan 782
- Martin 781
- McCracken 781
- Menifee 781
- Muhlenberg 781
- …
state 1
- Kentucky · 92,572 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
33966 | 33966 | 2020-04-05 | Adair | Kentucky | 21001 | 3 | 0 |
36424 | 36424 | 2020-04-06 | Adair | Kentucky | 21001 | 3 | 0 |
38929 | 38929 | 2020-04-07 | Adair | Kentucky | 21001 | 4 | 1 |
41477 | 41477 | 2020-04-08 | Adair | Kentucky | 21001 | 4 | 1 |
44052 | 44052 | 2020-04-09 | Adair | Kentucky | 21001 | 9 | 1 |
46660 | 46660 | 2020-04-10 | Adair | Kentucky | 21001 | 10 | 1 |
49297 | 49297 | 2020-04-11 | Adair | Kentucky | 21001 | 11 | 1 |
51963 | 51963 | 2020-04-12 | Adair | Kentucky | 21001 | 43 | 1 |
54644 | 54644 | 2020-04-13 | Adair | Kentucky | 21001 | 43 | 1 |
57339 | 57339 | 2020-04-14 | Adair | Kentucky | 21001 | 44 | 2 |
60048 | 60048 | 2020-04-15 | Adair | Kentucky | 21001 | 45 | 2 |
62768 | 62768 | 2020-04-16 | Adair | Kentucky | 21001 | 46 | 3 |
65507 | 65507 | 2020-04-17 | Adair | Kentucky | 21001 | 46 | 3 |
68256 | 68256 | 2020-04-18 | Adair | Kentucky | 21001 | 47 | 3 |
71017 | 71017 | 2020-04-19 | Adair | Kentucky | 21001 | 53 | 3 |
73789 | 73789 | 2020-04-20 | Adair | Kentucky | 21001 | 54 | 4 |
76569 | 76569 | 2020-04-21 | Adair | Kentucky | 21001 | 53 | 4 |
79354 | 79354 | 2020-04-22 | Adair | Kentucky | 21001 | 60 | 4 |
82150 | 82150 | 2020-04-23 | Adair | Kentucky | 21001 | 64 | 5 |
84953 | 84953 | 2020-04-24 | Adair | Kentucky | 21001 | 80 | 6 |
87762 | 87762 | 2020-04-25 | Adair | Kentucky | 21001 | 83 | 7 |
90578 | 90578 | 2020-04-26 | Adair | Kentucky | 21001 | 83 | 9 |
93399 | 93399 | 2020-04-27 | Adair | Kentucky | 21001 | 83 | 9 |
96232 | 96232 | 2020-04-28 | Adair | Kentucky | 21001 | 79 | 10 |
99078 | 99078 | 2020-04-29 | Adair | Kentucky | 21001 | 79 | 10 |
101930 | 101930 | 2020-04-30 | Adair | Kentucky | 21001 | 81 | 10 |
104791 | 104791 | 2020-05-01 | Adair | Kentucky | 21001 | 81 | 11 |
107656 | 107656 | 2020-05-02 | Adair | Kentucky | 21001 | 81 | 11 |
110527 | 110527 | 2020-05-03 | Adair | Kentucky | 21001 | 81 | 13 |
113404 | 113404 | 2020-05-04 | Adair | Kentucky | 21001 | 81 | 13 |
116286 | 116286 | 2020-05-05 | Adair | Kentucky | 21001 | 81 | 13 |
119247 | 119247 | 2020-05-06 | Adair | Kentucky | 21001 | 82 | 13 |
122217 | 122217 | 2020-05-07 | Adair | Kentucky | 21001 | 84 | 13 |
125199 | 125199 | 2020-05-08 | Adair | Kentucky | 21001 | 84 | 13 |
128187 | 128187 | 2020-05-09 | Adair | Kentucky | 21001 | 86 | 13 |
131177 | 131177 | 2020-05-10 | Adair | Kentucky | 21001 | 86 | 13 |
134168 | 134168 | 2020-05-11 | Adair | Kentucky | 21001 | 88 | 13 |
137158 | 137158 | 2020-05-12 | Adair | Kentucky | 21001 | 88 | 13 |
140151 | 140151 | 2020-05-13 | Adair | Kentucky | 21001 | 88 | 13 |
143147 | 143147 | 2020-05-14 | Adair | Kentucky | 21001 | 91 | 14 |
146147 | 146147 | 2020-05-15 | Adair | Kentucky | 21001 | 92 | 14 |
149151 | 149151 | 2020-05-16 | Adair | Kentucky | 21001 | 92 | 14 |
152162 | 152162 | 2020-05-17 | Adair | Kentucky | 21001 | 92 | 14 |
155175 | 155175 | 2020-05-18 | Adair | Kentucky | 21001 | 95 | 14 |
158192 | 158192 | 2020-05-19 | Adair | Kentucky | 21001 | 94 | 17 |
161217 | 161217 | 2020-05-20 | Adair | Kentucky | 21001 | 94 | 17 |
164246 | 164246 | 2020-05-21 | Adair | Kentucky | 21001 | 95 | 18 |
167282 | 167282 | 2020-05-22 | Adair | Kentucky | 21001 | 96 | 18 |
170320 | 170320 | 2020-05-23 | Adair | Kentucky | 21001 | 96 | 18 |
173361 | 173361 | 2020-05-24 | Adair | Kentucky | 21001 | 96 | 18 |
176405 | 176405 | 2020-05-25 | Adair | Kentucky | 21001 | 96 | 18 |
179449 | 179449 | 2020-05-26 | Adair | Kentucky | 21001 | 96 | 19 |
182494 | 182494 | 2020-05-27 | Adair | Kentucky | 21001 | 96 | 19 |
185548 | 185548 | 2020-05-28 | Adair | Kentucky | 21001 | 96 | 19 |
188606 | 188606 | 2020-05-29 | Adair | Kentucky | 21001 | 97 | 19 |
191670 | 191670 | 2020-05-30 | Adair | Kentucky | 21001 | 97 | 19 |
194738 | 194738 | 2020-05-31 | Adair | Kentucky | 21001 | 97 | 19 |
197809 | 197809 | 2020-06-01 | Adair | Kentucky | 21001 | 97 | 19 |
200880 | 200880 | 2020-06-02 | Adair | Kentucky | 21001 | 97 | 19 |
203957 | 203957 | 2020-06-03 | Adair | Kentucky | 21001 | 97 | 19 |
207038 | 207038 | 2020-06-04 | Adair | Kentucky | 21001 | 97 | 19 |
210119 | 210119 | 2020-06-05 | Adair | Kentucky | 21001 | 98 | 19 |
213204 | 213204 | 2020-06-06 | Adair | Kentucky | 21001 | 99 | 19 |
216291 | 216291 | 2020-06-07 | Adair | Kentucky | 21001 | 99 | 19 |
219383 | 219383 | 2020-06-08 | Adair | Kentucky | 21001 | 100 | 19 |
222478 | 222478 | 2020-06-09 | Adair | Kentucky | 21001 | 101 | 19 |
225574 | 225574 | 2020-06-10 | Adair | Kentucky | 21001 | 101 | 19 |
228676 | 228676 | 2020-06-11 | Adair | Kentucky | 21001 | 101 | 19 |
231780 | 231780 | 2020-06-12 | Adair | Kentucky | 21001 | 101 | 19 |
234885 | 234885 | 2020-06-13 | Adair | Kentucky | 21001 | 101 | 19 |
237992 | 237992 | 2020-06-14 | Adair | Kentucky | 21001 | 101 | 19 |
241101 | 241101 | 2020-06-15 | Adair | Kentucky | 21001 | 102 | 19 |
244212 | 244212 | 2020-06-16 | Adair | Kentucky | 21001 | 102 | 19 |
247325 | 247325 | 2020-06-17 | Adair | Kentucky | 21001 | 104 | 19 |
250437 | 250437 | 2020-06-18 | Adair | Kentucky | 21001 | 106 | 19 |
253552 | 253552 | 2020-06-19 | Adair | Kentucky | 21001 | 107 | 19 |
256672 | 256672 | 2020-06-20 | Adair | Kentucky | 21001 | 107 | 19 |
259798 | 259798 | 2020-06-21 | Adair | Kentucky | 21001 | 107 | 19 |
262927 | 262927 | 2020-06-22 | Adair | Kentucky | 21001 | 108 | 19 |
266054 | 266054 | 2020-06-23 | Adair | Kentucky | 21001 | 108 | 19 |
269187 | 269187 | 2020-06-24 | Adair | Kentucky | 21001 | 109 | 19 |
272323 | 272323 | 2020-06-25 | Adair | Kentucky | 21001 | 110 | 19 |
275466 | 275466 | 2020-06-26 | Adair | Kentucky | 21001 | 111 | 19 |
278614 | 278614 | 2020-06-27 | Adair | Kentucky | 21001 | 115 | 19 |
281762 | 281762 | 2020-06-28 | Adair | Kentucky | 21001 | 116 | 19 |
284908 | 284908 | 2020-06-29 | Adair | Kentucky | 21001 | 118 | 19 |
288057 | 288057 | 2020-06-30 | Adair | Kentucky | 21001 | 120 | 19 |
291207 | 291207 | 2020-07-01 | Adair | Kentucky | 21001 | 126 | 19 |
294361 | 294361 | 2020-07-02 | Adair | Kentucky | 21001 | 127 | 19 |
297519 | 297519 | 2020-07-03 | Adair | Kentucky | 21001 | 127 | 19 |
300681 | 300681 | 2020-07-04 | Adair | Kentucky | 21001 | 130 | 19 |
303845 | 303845 | 2020-07-05 | Adair | Kentucky | 21001 | 131 | 19 |
307012 | 307012 | 2020-07-06 | Adair | Kentucky | 21001 | 136 | 19 |
310180 | 310180 | 2020-07-07 | Adair | Kentucky | 21001 | 139 | 19 |
313350 | 313350 | 2020-07-08 | Adair | Kentucky | 21001 | 139 | 19 |
316524 | 316524 | 2020-07-09 | Adair | Kentucky | 21001 | 145 | 19 |
319699 | 319699 | 2020-07-10 | Adair | Kentucky | 21001 | 149 | 19 |
322878 | 322878 | 2020-07-11 | Adair | Kentucky | 21001 | 151 | 19 |
326061 | 326061 | 2020-07-12 | Adair | Kentucky | 21001 | 153 | 19 |
329247 | 329247 | 2020-07-13 | Adair | Kentucky | 21001 | 160 | 19 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);