ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Muhlenberg" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387021 | 387021 | 2020-07-31 | Muhlenberg | Kentucky | 21177 | 627 | 9 |
383803 | 383803 | 2020-07-30 | Muhlenberg | Kentucky | 21177 | 625 | 9 |
380586 | 380586 | 2020-07-29 | Muhlenberg | Kentucky | 21177 | 623 | 9 |
377369 | 377369 | 2020-07-28 | Muhlenberg | Kentucky | 21177 | 620 | 9 |
374154 | 374154 | 2020-07-27 | Muhlenberg | Kentucky | 21177 | 620 | 9 |
370942 | 370942 | 2020-07-26 | Muhlenberg | Kentucky | 21177 | 616 | 9 |
367732 | 367732 | 2020-07-25 | Muhlenberg | Kentucky | 21177 | 614 | 9 |
364525 | 364525 | 2020-07-24 | Muhlenberg | Kentucky | 21177 | 612 | 9 |
361318 | 361318 | 2020-07-23 | Muhlenberg | Kentucky | 21177 | 608 | 9 |
358113 | 358113 | 2020-07-22 | Muhlenberg | Kentucky | 21177 | 602 | 9 |
354910 | 354910 | 2020-07-21 | Muhlenberg | Kentucky | 21177 | 601 | 9 |
351708 | 351708 | 2020-07-20 | Muhlenberg | Kentucky | 21177 | 598 | 9 |
348508 | 348508 | 2020-07-19 | Muhlenberg | Kentucky | 21177 | 595 | 9 |
345307 | 345307 | 2020-07-18 | Muhlenberg | Kentucky | 21177 | 591 | 9 |
342107 | 342107 | 2020-07-17 | Muhlenberg | Kentucky | 21177 | 585 | 9 |
338911 | 338911 | 2020-07-16 | Muhlenberg | Kentucky | 21177 | 584 | 9 |
335715 | 335715 | 2020-07-15 | Muhlenberg | Kentucky | 21177 | 584 | 8 |
332522 | 332522 | 2020-07-14 | Muhlenberg | Kentucky | 21177 | 575 | 8 |
329335 | 329335 | 2020-07-13 | Muhlenberg | Kentucky | 21177 | 566 | 8 |
326149 | 326149 | 2020-07-12 | Muhlenberg | Kentucky | 21177 | 565 | 8 |
322966 | 322966 | 2020-07-11 | Muhlenberg | Kentucky | 21177 | 564 | 8 |
319787 | 319787 | 2020-07-10 | Muhlenberg | Kentucky | 21177 | 558 | 8 |
316612 | 316612 | 2020-07-09 | Muhlenberg | Kentucky | 21177 | 549 | 8 |
313438 | 313438 | 2020-07-08 | Muhlenberg | Kentucky | 21177 | 549 | 8 |
310268 | 310268 | 2020-07-07 | Muhlenberg | Kentucky | 21177 | 545 | 8 |
307100 | 307100 | 2020-07-06 | Muhlenberg | Kentucky | 21177 | 538 | 8 |
303933 | 303933 | 2020-07-05 | Muhlenberg | Kentucky | 21177 | 538 | 8 |
300769 | 300769 | 2020-07-04 | Muhlenberg | Kentucky | 21177 | 538 | 8 |
297607 | 297607 | 2020-07-03 | Muhlenberg | Kentucky | 21177 | 527 | 8 |
294449 | 294449 | 2020-07-02 | Muhlenberg | Kentucky | 21177 | 527 | 8 |
291295 | 291295 | 2020-07-01 | Muhlenberg | Kentucky | 21177 | 523 | 8 |
288145 | 288145 | 2020-06-30 | Muhlenberg | Kentucky | 21177 | 523 | 8 |
284996 | 284996 | 2020-06-29 | Muhlenberg | Kentucky | 21177 | 520 | 8 |
281850 | 281850 | 2020-06-28 | Muhlenberg | Kentucky | 21177 | 514 | 8 |
278702 | 278702 | 2020-06-27 | Muhlenberg | Kentucky | 21177 | 512 | 8 |
275554 | 275554 | 2020-06-26 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
272411 | 272411 | 2020-06-25 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
269275 | 269275 | 2020-06-24 | Muhlenberg | Kentucky | 21177 | 511 | 8 |
266142 | 266142 | 2020-06-23 | Muhlenberg | Kentucky | 21177 | 510 | 8 |
263015 | 263015 | 2020-06-22 | Muhlenberg | Kentucky | 21177 | 509 | 8 |
259886 | 259886 | 2020-06-21 | Muhlenberg | Kentucky | 21177 | 509 | 8 |
256760 | 256760 | 2020-06-20 | Muhlenberg | Kentucky | 21177 | 509 | 8 |
253640 | 253640 | 2020-06-19 | Muhlenberg | Kentucky | 21177 | 507 | 8 |
250525 | 250525 | 2020-06-18 | Muhlenberg | Kentucky | 21177 | 506 | 8 |
247413 | 247413 | 2020-06-17 | Muhlenberg | Kentucky | 21177 | 505 | 8 |
244300 | 244300 | 2020-06-16 | Muhlenberg | Kentucky | 21177 | 504 | 8 |
241189 | 241189 | 2020-06-15 | Muhlenberg | Kentucky | 21177 | 503 | 8 |
238080 | 238080 | 2020-06-14 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
234973 | 234973 | 2020-06-13 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
231868 | 231868 | 2020-06-12 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
228764 | 228764 | 2020-06-11 | Muhlenberg | Kentucky | 21177 | 502 | 8 |
225662 | 225662 | 2020-06-10 | Muhlenberg | Kentucky | 21177 | 499 | 8 |
222566 | 222566 | 2020-06-09 | Muhlenberg | Kentucky | 21177 | 499 | 8 |
219471 | 219471 | 2020-06-08 | Muhlenberg | Kentucky | 21177 | 499 | 8 |
216379 | 216379 | 2020-06-07 | Muhlenberg | Kentucky | 21177 | 498 | 8 |
213292 | 213292 | 2020-06-06 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
210207 | 210207 | 2020-06-05 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
207126 | 207126 | 2020-06-04 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
204045 | 204045 | 2020-06-03 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
200968 | 200968 | 2020-06-02 | Muhlenberg | Kentucky | 21177 | 497 | 8 |
197896 | 197896 | 2020-06-01 | Muhlenberg | Kentucky | 21177 | 497 | 7 |
194825 | 194825 | 2020-05-31 | Muhlenberg | Kentucky | 21177 | 497 | 7 |
191757 | 191757 | 2020-05-30 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
188693 | 188693 | 2020-05-29 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
185635 | 185635 | 2020-05-28 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
182580 | 182580 | 2020-05-27 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
179535 | 179535 | 2020-05-26 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
176491 | 176491 | 2020-05-25 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
173447 | 173447 | 2020-05-24 | Muhlenberg | Kentucky | 21177 | 485 | 7 |
170406 | 170406 | 2020-05-23 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
167368 | 167368 | 2020-05-22 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
164332 | 164332 | 2020-05-21 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
161303 | 161303 | 2020-05-20 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
158277 | 158277 | 2020-05-19 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
155260 | 155260 | 2020-05-18 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
152246 | 152246 | 2020-05-17 | Muhlenberg | Kentucky | 21177 | 476 | 7 |
149235 | 149235 | 2020-05-16 | Muhlenberg | Kentucky | 21177 | 474 | 7 |
146230 | 146230 | 2020-05-15 | Muhlenberg | Kentucky | 21177 | 464 | 6 |
143230 | 143230 | 2020-05-14 | Muhlenberg | Kentucky | 21177 | 459 | 6 |
140234 | 140234 | 2020-05-13 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
137241 | 137241 | 2020-05-12 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
134251 | 134251 | 2020-05-11 | Muhlenberg | Kentucky | 21177 | 457 | 6 |
131260 | 131260 | 2020-05-10 | Muhlenberg | Kentucky | 21177 | 453 | 6 |
128270 | 128270 | 2020-05-09 | Muhlenberg | Kentucky | 21177 | 453 | 6 |
125282 | 125282 | 2020-05-08 | Muhlenberg | Kentucky | 21177 | 452 | 6 |
122300 | 122300 | 2020-05-07 | Muhlenberg | Kentucky | 21177 | 458 | 6 |
119329 | 119329 | 2020-05-06 | Muhlenberg | Kentucky | 21177 | 446 | 6 |
116368 | 116368 | 2020-05-05 | Muhlenberg | Kentucky | 21177 | 442 | 4 |
113486 | 113486 | 2020-05-04 | Muhlenberg | Kentucky | 21177 | 241 | 4 |
110609 | 110609 | 2020-05-03 | Muhlenberg | Kentucky | 21177 | 241 | 4 |
107738 | 107738 | 2020-05-02 | Muhlenberg | Kentucky | 21177 | 125 | 4 |
104873 | 104873 | 2020-05-01 | Muhlenberg | Kentucky | 21177 | 125 | 4 |
102012 | 102012 | 2020-04-30 | Muhlenberg | Kentucky | 21177 | 123 | 4 |
99160 | 99160 | 2020-04-29 | Muhlenberg | Kentucky | 21177 | 116 | 4 |
96314 | 96314 | 2020-04-28 | Muhlenberg | Kentucky | 21177 | 114 | 4 |
93480 | 93480 | 2020-04-27 | Muhlenberg | Kentucky | 21177 | 111 | 4 |
90659 | 90659 | 2020-04-26 | Muhlenberg | Kentucky | 21177 | 111 | 4 |
87843 | 87843 | 2020-04-25 | Muhlenberg | Kentucky | 21177 | 96 | 4 |
85034 | 85034 | 2020-04-24 | Muhlenberg | Kentucky | 21177 | 92 | 4 |
82231 | 82231 | 2020-04-23 | Muhlenberg | Kentucky | 21177 | 92 | 3 |
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);