ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 21177 and state = "Kentucky" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
9961 | 9961 | 2020-03-24 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
11364 | 11364 | 2020-03-25 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
12937 | 12937 | 2020-03-26 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
14643 | 14643 | 2020-03-27 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
16458 | 16458 | 2020-03-28 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
18369 | 18369 | 2020-03-29 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
20385 | 20385 | 2020-03-30 | Muhlenberg | Kentucky | 21177 | 2 | 0 |
22490 | 22490 | 2020-03-31 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
24666 | 24666 | 2020-04-01 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
26915 | 26915 | 2020-04-02 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
29231 | 29231 | 2020-04-03 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
31607 | 31607 | 2020-04-04 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
34031 | 34031 | 2020-04-05 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
36489 | 36489 | 2020-04-06 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
38996 | 38996 | 2020-04-07 | Muhlenberg | Kentucky | 21177 | 8 | 0 |
41546 | 41546 | 2020-04-08 | Muhlenberg | Kentucky | 21177 | 26 | 0 |
44122 | 44122 | 2020-04-09 | Muhlenberg | Kentucky | 21177 | 26 | 0 |
49370 | 49370 | 2020-04-11 | Muhlenberg | Kentucky | 21177 | 28 | 0 |
46730 | 46730 | 2020-04-10 | Muhlenberg | Kentucky | 21177 | 36 | 0 |
52037 | 52037 | 2020-04-12 | Muhlenberg | Kentucky | 21177 | 43 | 1 |
54718 | 54718 | 2020-04-13 | Muhlenberg | Kentucky | 21177 | 45 | 2 |
57416 | 57416 | 2020-04-14 | Muhlenberg | Kentucky | 21177 | 51 | 2 |
60125 | 60125 | 2020-04-15 | Muhlenberg | Kentucky | 21177 | 52 | 2 |
62845 | 62845 | 2020-04-16 | Muhlenberg | Kentucky | 21177 | 55 | 2 |
65584 | 65584 | 2020-04-17 | Muhlenberg | Kentucky | 21177 | 60 | 2 |
68333 | 68333 | 2020-04-18 | Muhlenberg | Kentucky | 21177 | 70 | 2 |
71096 | 71096 | 2020-04-19 | Muhlenberg | Kentucky | 21177 | 75 | 2 |
76649 | 76649 | 2020-04-21 | Muhlenberg | Kentucky | 21177 | 75 | 2 |
79434 | 79434 | 2020-04-22 | Muhlenberg | Kentucky | 21177 | 75 | 2 |
73868 | 73868 | 2020-04-20 | Muhlenberg | Kentucky | 21177 | 76 | 2 |
82231 | 82231 | 2020-04-23 | Muhlenberg | Kentucky | 21177 | 92 | 3 |
85034 | 85034 | 2020-04-24 | Muhlenberg | Kentucky | 21177 | 92 | 4 |
87843 | 87843 | 2020-04-25 | Muhlenberg | Kentucky | 21177 | 96 | 4 |
90659 | 90659 | 2020-04-26 | Muhlenberg | Kentucky | 21177 | 111 | 4 |
93480 | 93480 | 2020-04-27 | Muhlenberg | Kentucky | 21177 | 111 | 4 |
96314 | 96314 | 2020-04-28 | Muhlenberg | Kentucky | 21177 | 114 | 4 |
99160 | 99160 | 2020-04-29 | Muhlenberg | Kentucky | 21177 | 116 | 4 |
102012 | 102012 | 2020-04-30 | Muhlenberg | Kentucky | 21177 | 123 | 4 |
104873 | 104873 | 2020-05-01 | Muhlenberg | Kentucky | 21177 | 125 | 4 |
107738 | 107738 | 2020-05-02 | Muhlenberg | Kentucky | 21177 | 125 | 4 |
110609 | 110609 | 2020-05-03 | Muhlenberg | Kentucky | 21177 | 241 | 4 |
113486 | 113486 | 2020-05-04 | Muhlenberg | Kentucky | 21177 | 241 | 4 |
116368 | 116368 | 2020-05-05 | Muhlenberg | Kentucky | 21177 | 442 | 4 |
119329 | 119329 | 2020-05-06 | Muhlenberg | Kentucky | 21177 | 446 | 6 |
125282 | 125282 | 2020-05-08 | Muhlenberg | Kentucky | 21177 | 452 | 6 |
128270 | 128270 | 2020-05-09 | Muhlenberg | Kentucky | 21177 | 453 | 6 |
131260 | 131260 | 2020-05-10 | Muhlenberg | Kentucky | 21177 | 453 | 6 |
134251 | 134251 | 2020-05-11 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
137241 | 137241 | 2020-05-12 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
140234 | 140234 | 2020-05-13 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
122300 | 122300 | 2020-05-07 | Muhlenberg | Kentucky | 21177 | 458 | 6 |
143230 | 143230 | 2020-05-14 | Muhlenberg | Kentucky | 21177 | 459 | 6 |
146230 | 146230 | 2020-05-15 | Muhlenberg | Kentucky | 21177 | 464 | 6 |
149235 | 149235 | 2020-05-16 | Muhlenberg | Kentucky | 21177 | 474 | 7 |
152246 | 152246 | 2020-05-17 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
155260 | 155260 | 2020-05-18 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
158277 | 158277 | 2020-05-19 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
161303 | 161303 | 2020-05-20 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
164332 | 164332 | 2020-05-21 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
167368 | 167368 | 2020-05-22 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
170406 | 170406 | 2020-05-23 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
173447 | 173447 | 2020-05-24 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
176491 | 176491 | 2020-05-25 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
179535 | 179535 | 2020-05-26 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
182580 | 182580 | 2020-05-27 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
185635 | 185635 | 2020-05-28 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
188693 | 188693 | 2020-05-29 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
191757 | 191757 | 2020-05-30 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
194825 | 194825 | 2020-05-31 | Muhlenberg | Kentucky | 21177 | 497 | 7 |
197896 | 197896 | 2020-06-01 | Muhlenberg | Kentucky | 21177 | 497 | 7 |
200968 | 200968 | 2020-06-02 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
204045 | 204045 | 2020-06-03 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
207126 | 207126 | 2020-06-04 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
210207 | 210207 | 2020-06-05 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
213292 | 213292 | 2020-06-06 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
216379 | 216379 | 2020-06-07 | Muhlenberg | Kentucky | 21177 | 498 | 8 |
219471 | 219471 | 2020-06-08 | Muhlenberg | Kentucky | 21177 | 499 | 8 |
222566 | 222566 | 2020-06-09 | Muhlenberg | Kentucky | 21177 | 499 | 8 |
225662 | 225662 | 2020-06-10 | Muhlenberg | Kentucky | 21177 | 499 | 8 |
228764 | 228764 | 2020-06-11 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
231868 | 231868 | 2020-06-12 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
234973 | 234973 | 2020-06-13 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
238080 | 238080 | 2020-06-14 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
241189 | 241189 | 2020-06-15 | Muhlenberg | Kentucky | 21177 | 503 | 8 |
244300 | 244300 | 2020-06-16 | Muhlenberg | Kentucky | 21177 | 504 | 8 |
247413 | 247413 | 2020-06-17 | Muhlenberg | Kentucky | 21177 | 505 | 8 |
250525 | 250525 | 2020-06-18 | Muhlenberg | Kentucky | 21177 | 506 | 8 |
253640 | 253640 | 2020-06-19 | Muhlenberg | Kentucky | 21177 | 507 | 8 |
256760 | 256760 | 2020-06-20 | Muhlenberg | Kentucky | 21177 | 509 | 8 |
259886 | 259886 | 2020-06-21 | Muhlenberg | Kentucky | 21177 | 509 | 8 |
263015 | 263015 | 2020-06-22 | Muhlenberg | Kentucky | 21177 | 509 | 8 |
266142 | 266142 | 2020-06-23 | Muhlenberg | Kentucky | 21177 | 510 | 8 |
269275 | 269275 | 2020-06-24 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
272411 | 272411 | 2020-06-25 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
275554 | 275554 | 2020-06-26 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
278702 | 278702 | 2020-06-27 | Muhlenberg | Kentucky | 21177 | 512 | 8 |
281850 | 281850 | 2020-06-28 | Muhlenberg | Kentucky | 21177 | 514 | 8 |
284996 | 284996 | 2020-06-29 | Muhlenberg | Kentucky | 21177 | 520 | 8 |
288145 | 288145 | 2020-06-30 | Muhlenberg | Kentucky | 21177 | 523 | 8 |
291295 | 291295 | 2020-07-01 | Muhlenberg | Kentucky | 21177 | 523 | 8 |
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);