ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 21167 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12935 | 12935 | 2020-03-26 | Mercer | Kentucky | 21167 | 1 | 0 |
14641 | 14641 | 2020-03-27 | Mercer | Kentucky | 21167 | 1 | 0 |
16456 | 16456 | 2020-03-28 | Mercer | Kentucky | 21167 | 2 | 0 |
18367 | 18367 | 2020-03-29 | Mercer | Kentucky | 21167 | 2 | 0 |
20383 | 20383 | 2020-03-30 | Mercer | Kentucky | 21167 | 2 | 0 |
22488 | 22488 | 2020-03-31 | Mercer | Kentucky | 21167 | 2 | 0 |
24664 | 24664 | 2020-04-01 | Mercer | Kentucky | 21167 | 2 | 0 |
26913 | 26913 | 2020-04-02 | Mercer | Kentucky | 21167 | 2 | 0 |
29229 | 29229 | 2020-04-03 | Mercer | Kentucky | 21167 | 2 | 0 |
31605 | 31605 | 2020-04-04 | Mercer | Kentucky | 21167 | 3 | 0 |
34028 | 34028 | 2020-04-05 | Mercer | Kentucky | 21167 | 3 | 0 |
36486 | 36486 | 2020-04-06 | Mercer | Kentucky | 21167 | 3 | 0 |
38993 | 38993 | 2020-04-07 | Mercer | Kentucky | 21167 | 4 | 0 |
41543 | 41543 | 2020-04-08 | Mercer | Kentucky | 21167 | 4 | 0 |
44119 | 44119 | 2020-04-09 | Mercer | Kentucky | 21167 | 4 | 0 |
46727 | 46727 | 2020-04-10 | Mercer | Kentucky | 21167 | 7 | 0 |
49367 | 49367 | 2020-04-11 | Mercer | Kentucky | 21167 | 9 | 0 |
52033 | 52033 | 2020-04-12 | Mercer | Kentucky | 21167 | 9 | 0 |
54714 | 54714 | 2020-04-13 | Mercer | Kentucky | 21167 | 9 | 0 |
57412 | 57412 | 2020-04-14 | Mercer | Kentucky | 21167 | 9 | 0 |
60121 | 60121 | 2020-04-15 | Mercer | Kentucky | 21167 | 9 | 0 |
62841 | 62841 | 2020-04-16 | Mercer | Kentucky | 21167 | 9 | 0 |
65580 | 65580 | 2020-04-17 | Mercer | Kentucky | 21167 | 9 | 0 |
68329 | 68329 | 2020-04-18 | Mercer | Kentucky | 21167 | 9 | 0 |
71092 | 71092 | 2020-04-19 | Mercer | Kentucky | 21167 | 9 | 0 |
73864 | 73864 | 2020-04-20 | Mercer | Kentucky | 21167 | 9 | 0 |
76645 | 76645 | 2020-04-21 | Mercer | Kentucky | 21167 | 10 | 0 |
79430 | 79430 | 2020-04-22 | Mercer | Kentucky | 21167 | 11 | 0 |
82227 | 82227 | 2020-04-23 | Mercer | Kentucky | 21167 | 11 | 0 |
85030 | 85030 | 2020-04-24 | Mercer | Kentucky | 21167 | 11 | 0 |
87839 | 87839 | 2020-04-25 | Mercer | Kentucky | 21167 | 11 | 0 |
90655 | 90655 | 2020-04-26 | Mercer | Kentucky | 21167 | 11 | 0 |
93476 | 93476 | 2020-04-27 | Mercer | Kentucky | 21167 | 11 | 0 |
96309 | 96309 | 2020-04-28 | Mercer | Kentucky | 21167 | 11 | 0 |
99155 | 99155 | 2020-04-29 | Mercer | Kentucky | 21167 | 11 | 0 |
102007 | 102007 | 2020-04-30 | Mercer | Kentucky | 21167 | 11 | 0 |
104868 | 104868 | 2020-05-01 | Mercer | Kentucky | 21167 | 11 | 0 |
107733 | 107733 | 2020-05-02 | Mercer | Kentucky | 21167 | 11 | 0 |
110604 | 110604 | 2020-05-03 | Mercer | Kentucky | 21167 | 11 | 0 |
113481 | 113481 | 2020-05-04 | Mercer | Kentucky | 21167 | 11 | 0 |
116363 | 116363 | 2020-05-05 | Mercer | Kentucky | 21167 | 11 | 0 |
119324 | 119324 | 2020-05-06 | Mercer | Kentucky | 21167 | 11 | 0 |
122295 | 122295 | 2020-05-07 | Mercer | Kentucky | 21167 | 11 | 0 |
125277 | 125277 | 2020-05-08 | Mercer | Kentucky | 21167 | 11 | 0 |
128265 | 128265 | 2020-05-09 | Mercer | Kentucky | 21167 | 11 | 0 |
131255 | 131255 | 2020-05-10 | Mercer | Kentucky | 21167 | 11 | 0 |
134246 | 134246 | 2020-05-11 | Mercer | Kentucky | 21167 | 11 | 0 |
137236 | 137236 | 2020-05-12 | Mercer | Kentucky | 21167 | 12 | 0 |
140229 | 140229 | 2020-05-13 | Mercer | Kentucky | 21167 | 12 | 0 |
143225 | 143225 | 2020-05-14 | Mercer | Kentucky | 21167 | 12 | 0 |
146225 | 146225 | 2020-05-15 | Mercer | Kentucky | 21167 | 12 | 0 |
149230 | 149230 | 2020-05-16 | Mercer | Kentucky | 21167 | 12 | 0 |
152241 | 152241 | 2020-05-17 | Mercer | Kentucky | 21167 | 12 | 0 |
155255 | 155255 | 2020-05-18 | Mercer | Kentucky | 21167 | 12 | 0 |
158272 | 158272 | 2020-05-19 | Mercer | Kentucky | 21167 | 12 | 0 |
161298 | 161298 | 2020-05-20 | Mercer | Kentucky | 21167 | 12 | 0 |
164327 | 164327 | 2020-05-21 | Mercer | Kentucky | 21167 | 12 | 0 |
167363 | 167363 | 2020-05-22 | Mercer | Kentucky | 21167 | 12 | 0 |
170401 | 170401 | 2020-05-23 | Mercer | Kentucky | 21167 | 12 | 0 |
173442 | 173442 | 2020-05-24 | Mercer | Kentucky | 21167 | 12 | 0 |
176486 | 176486 | 2020-05-25 | Mercer | Kentucky | 21167 | 12 | 0 |
179530 | 179530 | 2020-05-26 | Mercer | Kentucky | 21167 | 13 | 0 |
182575 | 182575 | 2020-05-27 | Mercer | Kentucky | 21167 | 13 | 0 |
185630 | 185630 | 2020-05-28 | Mercer | Kentucky | 21167 | 13 | 0 |
188688 | 188688 | 2020-05-29 | Mercer | Kentucky | 21167 | 13 | 0 |
191752 | 191752 | 2020-05-30 | Mercer | Kentucky | 21167 | 13 | 0 |
194820 | 194820 | 2020-05-31 | Mercer | Kentucky | 21167 | 13 | 0 |
197891 | 197891 | 2020-06-01 | Mercer | Kentucky | 21167 | 13 | 0 |
200963 | 200963 | 2020-06-02 | Mercer | Kentucky | 21167 | 14 | 0 |
204040 | 204040 | 2020-06-03 | Mercer | Kentucky | 21167 | 14 | 0 |
207121 | 207121 | 2020-06-04 | Mercer | Kentucky | 21167 | 14 | 0 |
210202 | 210202 | 2020-06-05 | Mercer | Kentucky | 21167 | 15 | 0 |
213287 | 213287 | 2020-06-06 | Mercer | Kentucky | 21167 | 15 | 0 |
216374 | 216374 | 2020-06-07 | Mercer | Kentucky | 21167 | 15 | 0 |
219466 | 219466 | 2020-06-08 | Mercer | Kentucky | 21167 | 15 | 0 |
222561 | 222561 | 2020-06-09 | Mercer | Kentucky | 21167 | 15 | 0 |
225657 | 225657 | 2020-06-10 | Mercer | Kentucky | 21167 | 15 | 0 |
228759 | 228759 | 2020-06-11 | Mercer | Kentucky | 21167 | 16 | 0 |
231863 | 231863 | 2020-06-12 | Mercer | Kentucky | 21167 | 16 | 0 |
234968 | 234968 | 2020-06-13 | Mercer | Kentucky | 21167 | 16 | 0 |
238075 | 238075 | 2020-06-14 | Mercer | Kentucky | 21167 | 16 | 0 |
241184 | 241184 | 2020-06-15 | Mercer | Kentucky | 21167 | 16 | 0 |
244295 | 244295 | 2020-06-16 | Mercer | Kentucky | 21167 | 16 | 0 |
247408 | 247408 | 2020-06-17 | Mercer | Kentucky | 21167 | 16 | 0 |
250520 | 250520 | 2020-06-18 | Mercer | Kentucky | 21167 | 17 | 0 |
253635 | 253635 | 2020-06-19 | Mercer | Kentucky | 21167 | 17 | 0 |
256755 | 256755 | 2020-06-20 | Mercer | Kentucky | 21167 | 17 | 0 |
259881 | 259881 | 2020-06-21 | Mercer | Kentucky | 21167 | 17 | 0 |
263010 | 263010 | 2020-06-22 | Mercer | Kentucky | 21167 | 17 | 0 |
266137 | 266137 | 2020-06-23 | Mercer | Kentucky | 21167 | 17 | 0 |
269270 | 269270 | 2020-06-24 | Mercer | Kentucky | 21167 | 17 | 0 |
272406 | 272406 | 2020-06-25 | Mercer | Kentucky | 21167 | 17 | 0 |
275549 | 275549 | 2020-06-26 | Mercer | Kentucky | 21167 | 23 | 0 |
278697 | 278697 | 2020-06-27 | Mercer | Kentucky | 21167 | 23 | 0 |
281845 | 281845 | 2020-06-28 | Mercer | Kentucky | 21167 | 23 | 0 |
284991 | 284991 | 2020-06-29 | Mercer | Kentucky | 21167 | 23 | 0 |
288140 | 288140 | 2020-06-30 | Mercer | Kentucky | 21167 | 23 | 0 |
291290 | 291290 | 2020-07-01 | Mercer | Kentucky | 21167 | 23 | 0 |
294444 | 294444 | 2020-07-02 | Mercer | Kentucky | 21167 | 24 | 0 |
297602 | 297602 | 2020-07-03 | Mercer | Kentucky | 21167 | 24 | 0 |
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);