ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535493 | 535493 | 2020-09-15 | Madison | Kentucky | 21151 | 1438 | 4 |
532258 | 532258 | 2020-09-14 | Madison | Kentucky | 21151 | 1406 | 4 |
529021 | 529021 | 2020-09-13 | Madison | Kentucky | 21151 | 1398 | 4 |
525785 | 525785 | 2020-09-12 | Madison | Kentucky | 21151 | 1388 | 4 |
522549 | 522549 | 2020-09-11 | Madison | Kentucky | 21151 | 1363 | 4 |
519312 | 519312 | 2020-09-10 | Madison | Kentucky | 21151 | 1316 | 4 |
516077 | 516077 | 2020-09-09 | Madison | Kentucky | 21151 | 1268 | 4 |
512844 | 512844 | 2020-09-08 | Madison | Kentucky | 21151 | 1245 | 4 |
509612 | 509612 | 2020-09-07 | Madison | Kentucky | 21151 | 1234 | 4 |
506379 | 506379 | 2020-09-06 | Madison | Kentucky | 21151 | 1232 | 4 |
503145 | 503145 | 2020-09-05 | Madison | Kentucky | 21151 | 1228 | 4 |
499912 | 499912 | 2020-09-04 | Madison | Kentucky | 21151 | 1196 | 3 |
496678 | 496678 | 2020-09-03 | Madison | Kentucky | 21151 | 1174 | 3 |
493445 | 493445 | 2020-09-02 | Madison | Kentucky | 21151 | 1107 | 3 |
490211 | 490211 | 2020-09-01 | Madison | Kentucky | 21151 | 1085 | 3 |
486978 | 486978 | 2020-08-31 | Madison | Kentucky | 21151 | 1020 | 3 |
483743 | 483743 | 2020-08-30 | Madison | Kentucky | 21151 | 1001 | 3 |
480509 | 480509 | 2020-08-29 | Madison | Kentucky | 21151 | 964 | 3 |
477276 | 477276 | 2020-08-28 | Madison | Kentucky | 21151 | 937 | 3 |
474043 | 474043 | 2020-08-27 | Madison | Kentucky | 21151 | 881 | 3 |
470811 | 470811 | 2020-08-26 | Madison | Kentucky | 21151 | 859 | 2 |
467582 | 467582 | 2020-08-25 | Madison | Kentucky | 21151 | 828 | 2 |
464353 | 464353 | 2020-08-24 | Madison | Kentucky | 21151 | 805 | 2 |
461122 | 461122 | 2020-08-23 | Madison | Kentucky | 21151 | 757 | 2 |
457895 | 457895 | 2020-08-22 | Madison | Kentucky | 21151 | 757 | 2 |
454667 | 454667 | 2020-08-21 | Madison | Kentucky | 21151 | 716 | 2 |
451439 | 451439 | 2020-08-20 | Madison | Kentucky | 21151 | 709 | 1 |
448211 | 448211 | 2020-08-19 | Madison | Kentucky | 21151 | 696 | 1 |
444984 | 444984 | 2020-08-18 | Madison | Kentucky | 21151 | 686 | 1 |
441758 | 441758 | 2020-08-17 | Madison | Kentucky | 21151 | 676 | 1 |
438531 | 438531 | 2020-08-16 | Madison | Kentucky | 21151 | 630 | 1 |
435306 | 435306 | 2020-08-15 | Madison | Kentucky | 21151 | 630 | 1 |
432081 | 432081 | 2020-08-14 | Madison | Kentucky | 21151 | 623 | 1 |
428853 | 428853 | 2020-08-13 | Madison | Kentucky | 21151 | 603 | 1 |
425629 | 425629 | 2020-08-12 | Madison | Kentucky | 21151 | 583 | 1 |
422408 | 422408 | 2020-08-11 | Madison | Kentucky | 21151 | 549 | 1 |
419186 | 419186 | 2020-08-10 | Madison | Kentucky | 21151 | 516 | 1 |
415965 | 415965 | 2020-08-09 | Madison | Kentucky | 21151 | 505 | 1 |
412745 | 412745 | 2020-08-08 | Madison | Kentucky | 21151 | 492 | 1 |
409525 | 409525 | 2020-08-07 | Madison | Kentucky | 21151 | 456 | 1 |
406305 | 406305 | 2020-08-06 | Madison | Kentucky | 21151 | 444 | 1 |
403087 | 403087 | 2020-08-05 | Madison | Kentucky | 21151 | 426 | 1 |
399870 | 399870 | 2020-08-04 | Madison | Kentucky | 21151 | 411 | 1 |
396655 | 396655 | 2020-08-03 | Madison | Kentucky | 21151 | 396 | 1 |
393439 | 393439 | 2020-08-02 | Madison | Kentucky | 21151 | 383 | 1 |
390222 | 390222 | 2020-08-01 | Madison | Kentucky | 21151 | 380 | 1 |
387005 | 387005 | 2020-07-31 | Madison | Kentucky | 21151 | 370 | 1 |
383787 | 383787 | 2020-07-30 | Madison | Kentucky | 21151 | 344 | 1 |
380570 | 380570 | 2020-07-29 | Madison | Kentucky | 21151 | 338 | 1 |
377353 | 377353 | 2020-07-28 | Madison | Kentucky | 21151 | 331 | 1 |
374138 | 374138 | 2020-07-27 | Madison | Kentucky | 21151 | 312 | 1 |
370926 | 370926 | 2020-07-26 | Madison | Kentucky | 21151 | 308 | 1 |
367716 | 367716 | 2020-07-25 | Madison | Kentucky | 21151 | 305 | 1 |
364509 | 364509 | 2020-07-24 | Madison | Kentucky | 21151 | 299 | 1 |
361302 | 361302 | 2020-07-23 | Madison | Kentucky | 21151 | 295 | 1 |
358097 | 358097 | 2020-07-22 | Madison | Kentucky | 21151 | 287 | 1 |
354894 | 354894 | 2020-07-21 | Madison | Kentucky | 21151 | 280 | 1 |
351692 | 351692 | 2020-07-20 | Madison | Kentucky | 21151 | 258 | 1 |
348492 | 348492 | 2020-07-19 | Madison | Kentucky | 21151 | 258 | 1 |
345291 | 345291 | 2020-07-18 | Madison | Kentucky | 21151 | 254 | 1 |
342091 | 342091 | 2020-07-17 | Madison | Kentucky | 21151 | 250 | 1 |
338895 | 338895 | 2020-07-16 | Madison | Kentucky | 21151 | 232 | 1 |
335699 | 335699 | 2020-07-15 | Madison | Kentucky | 21151 | 221 | 1 |
332506 | 332506 | 2020-07-14 | Madison | Kentucky | 21151 | 210 | 1 |
329319 | 329319 | 2020-07-13 | Madison | Kentucky | 21151 | 193 | 1 |
326133 | 326133 | 2020-07-12 | Madison | Kentucky | 21151 | 187 | 1 |
322950 | 322950 | 2020-07-11 | Madison | Kentucky | 21151 | 183 | 1 |
319771 | 319771 | 2020-07-10 | Madison | Kentucky | 21151 | 178 | 1 |
316596 | 316596 | 2020-07-09 | Madison | Kentucky | 21151 | 169 | 1 |
313422 | 313422 | 2020-07-08 | Madison | Kentucky | 21151 | 160 | 1 |
310252 | 310252 | 2020-07-07 | Madison | Kentucky | 21151 | 152 | 1 |
307084 | 307084 | 2020-07-06 | Madison | Kentucky | 21151 | 143 | 1 |
303917 | 303917 | 2020-07-05 | Madison | Kentucky | 21151 | 130 | 1 |
300753 | 300753 | 2020-07-04 | Madison | Kentucky | 21151 | 130 | 1 |
297591 | 297591 | 2020-07-03 | Madison | Kentucky | 21151 | 130 | 1 |
294433 | 294433 | 2020-07-02 | Madison | Kentucky | 21151 | 126 | 1 |
291279 | 291279 | 2020-07-01 | Madison | Kentucky | 21151 | 125 | 1 |
288129 | 288129 | 2020-06-30 | Madison | Kentucky | 21151 | 125 | 1 |
284980 | 284980 | 2020-06-29 | Madison | Kentucky | 21151 | 125 | 1 |
281834 | 281834 | 2020-06-28 | Madison | Kentucky | 21151 | 125 | 1 |
278686 | 278686 | 2020-06-27 | Madison | Kentucky | 21151 | 112 | 1 |
275538 | 275538 | 2020-06-26 | Madison | Kentucky | 21151 | 107 | 1 |
272395 | 272395 | 2020-06-25 | Madison | Kentucky | 21151 | 106 | 1 |
269259 | 269259 | 2020-06-24 | Madison | Kentucky | 21151 | 103 | 1 |
266126 | 266126 | 2020-06-23 | Madison | Kentucky | 21151 | 100 | 1 |
262999 | 262999 | 2020-06-22 | Madison | Kentucky | 21151 | 95 | 1 |
259870 | 259870 | 2020-06-21 | Madison | Kentucky | 21151 | 94 | 1 |
256744 | 256744 | 2020-06-20 | Madison | Kentucky | 21151 | 94 | 1 |
253624 | 253624 | 2020-06-19 | Madison | Kentucky | 21151 | 91 | 1 |
250509 | 250509 | 2020-06-18 | Madison | Kentucky | 21151 | 88 | 1 |
247397 | 247397 | 2020-06-17 | Madison | Kentucky | 21151 | 88 | 1 |
244284 | 244284 | 2020-06-16 | Madison | Kentucky | 21151 | 88 | 1 |
241173 | 241173 | 2020-06-15 | Madison | Kentucky | 21151 | 88 | 1 |
238064 | 238064 | 2020-06-14 | Madison | Kentucky | 21151 | 88 | 1 |
234957 | 234957 | 2020-06-13 | Madison | Kentucky | 21151 | 76 | 1 |
231852 | 231852 | 2020-06-12 | Madison | Kentucky | 21151 | 73 | 1 |
228748 | 228748 | 2020-06-11 | Madison | Kentucky | 21151 | 73 | 1 |
225646 | 225646 | 2020-06-10 | Madison | Kentucky | 21151 | 73 | 1 |
222550 | 222550 | 2020-06-09 | Madison | Kentucky | 21151 | 73 | 1 |
219455 | 219455 | 2020-06-08 | Madison | Kentucky | 21151 | 73 | 1 |
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);