ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18043 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729681 | 729681 | 2020-11-14 | Floyd | Indiana | 18043 | 2607 | 77 |
726438 | 726438 | 2020-11-13 | Floyd | Indiana | 18043 | 2540 | 77 |
723195 | 723195 | 2020-11-12 | Floyd | Indiana | 18043 | 2476 | 77 |
719952 | 719952 | 2020-11-11 | Floyd | Indiana | 18043 | 2374 | 77 |
716709 | 716709 | 2020-11-10 | Floyd | Indiana | 18043 | 2330 | 77 |
713465 | 713465 | 2020-11-09 | Floyd | Indiana | 18043 | 2301 | 75 |
710221 | 710221 | 2020-11-08 | Floyd | Indiana | 18043 | 2276 | 75 |
706977 | 706977 | 2020-11-07 | Floyd | Indiana | 18043 | 2238 | 75 |
703734 | 703734 | 2020-11-06 | Floyd | Indiana | 18043 | 2192 | 74 |
700492 | 700492 | 2020-11-05 | Floyd | Indiana | 18043 | 2164 | 74 |
697248 | 697248 | 2020-11-04 | Floyd | Indiana | 18043 | 2123 | 73 |
694006 | 694006 | 2020-11-03 | Floyd | Indiana | 18043 | 2082 | 72 |
690763 | 690763 | 2020-11-02 | Floyd | Indiana | 18043 | 2058 | 72 |
687518 | 687518 | 2020-11-01 | Floyd | Indiana | 18043 | 2038 | 72 |
684274 | 684274 | 2020-10-31 | Floyd | Indiana | 18043 | 2016 | 72 |
681031 | 681031 | 2020-10-30 | Floyd | Indiana | 18043 | 1968 | 72 |
677788 | 677788 | 2020-10-29 | Floyd | Indiana | 18043 | 1939 | 72 |
674545 | 674545 | 2020-10-28 | Floyd | Indiana | 18043 | 1911 | 72 |
671303 | 671303 | 2020-10-27 | Floyd | Indiana | 18043 | 1890 | 71 |
668060 | 668060 | 2020-10-26 | Floyd | Indiana | 18043 | 1880 | 71 |
664816 | 664816 | 2020-10-25 | Floyd | Indiana | 18043 | 1864 | 71 |
661571 | 661571 | 2020-10-24 | Floyd | Indiana | 18043 | 1845 | 71 |
658327 | 658327 | 2020-10-23 | Floyd | Indiana | 18043 | 1807 | 70 |
655082 | 655082 | 2020-10-22 | Floyd | Indiana | 18043 | 1797 | 70 |
651837 | 651837 | 2020-10-21 | Floyd | Indiana | 18043 | 1779 | 70 |
648593 | 648593 | 2020-10-20 | Floyd | Indiana | 18043 | 1754 | 70 |
645348 | 645348 | 2020-10-19 | Floyd | Indiana | 18043 | 1733 | 69 |
642101 | 642101 | 2020-10-18 | Floyd | Indiana | 18043 | 1714 | 68 |
638854 | 638854 | 2020-10-17 | Floyd | Indiana | 18043 | 1702 | 68 |
635608 | 635608 | 2020-10-16 | Floyd | Indiana | 18043 | 1673 | 68 |
632362 | 632362 | 2020-10-15 | Floyd | Indiana | 18043 | 1650 | 68 |
629118 | 629118 | 2020-10-14 | Floyd | Indiana | 18043 | 1637 | 68 |
625875 | 625875 | 2020-10-13 | Floyd | Indiana | 18043 | 1613 | 68 |
622633 | 622633 | 2020-10-12 | Floyd | Indiana | 18043 | 1608 | 68 |
619389 | 619389 | 2020-10-11 | Floyd | Indiana | 18043 | 1597 | 68 |
616147 | 616147 | 2020-10-10 | Floyd | Indiana | 18043 | 1583 | 68 |
612906 | 612906 | 2020-10-09 | Floyd | Indiana | 18043 | 1551 | 67 |
609664 | 609664 | 2020-10-08 | Floyd | Indiana | 18043 | 1536 | 67 |
606421 | 606421 | 2020-10-07 | Floyd | Indiana | 18043 | 1516 | 67 |
603179 | 603179 | 2020-10-06 | Floyd | Indiana | 18043 | 1503 | 67 |
599936 | 599936 | 2020-10-05 | Floyd | Indiana | 18043 | 1496 | 67 |
596694 | 596694 | 2020-10-04 | Floyd | Indiana | 18043 | 1491 | 67 |
593452 | 593452 | 2020-10-03 | Floyd | Indiana | 18043 | 1479 | 67 |
590211 | 590211 | 2020-10-02 | Floyd | Indiana | 18043 | 1459 | 67 |
586970 | 586970 | 2020-10-01 | Floyd | Indiana | 18043 | 1439 | 67 |
583730 | 583730 | 2020-09-30 | Floyd | Indiana | 18043 | 1426 | 67 |
580491 | 580491 | 2020-09-29 | Floyd | Indiana | 18043 | 1410 | 67 |
577250 | 577250 | 2020-09-28 | Floyd | Indiana | 18043 | 1402 | 67 |
574008 | 574008 | 2020-09-27 | Floyd | Indiana | 18043 | 1395 | 66 |
570765 | 570765 | 2020-09-26 | Floyd | Indiana | 18043 | 1376 | 66 |
567523 | 567523 | 2020-09-25 | Floyd | Indiana | 18043 | 1364 | 65 |
564283 | 564283 | 2020-09-24 | Floyd | Indiana | 18043 | 1357 | 64 |
561043 | 561043 | 2020-09-23 | Floyd | Indiana | 18043 | 1327 | 64 |
557807 | 557807 | 2020-09-22 | Floyd | Indiana | 18043 | 1320 | 64 |
554570 | 554570 | 2020-09-21 | Floyd | Indiana | 18043 | 1315 | 64 |
551331 | 551331 | 2020-09-20 | Floyd | Indiana | 18043 | 1309 | 64 |
548092 | 548092 | 2020-09-19 | Floyd | Indiana | 18043 | 1306 | 64 |
544854 | 544854 | 2020-09-18 | Floyd | Indiana | 18043 | 1292 | 64 |
541618 | 541618 | 2020-09-17 | Floyd | Indiana | 18043 | 1285 | 64 |
538381 | 538381 | 2020-09-16 | Floyd | Indiana | 18043 | 1276 | 63 |
535145 | 535145 | 2020-09-15 | Floyd | Indiana | 18043 | 1258 | 63 |
531910 | 531910 | 2020-09-14 | Floyd | Indiana | 18043 | 1247 | 63 |
528673 | 528673 | 2020-09-13 | Floyd | Indiana | 18043 | 1226 | 63 |
525437 | 525437 | 2020-09-12 | Floyd | Indiana | 18043 | 1220 | 63 |
522201 | 522201 | 2020-09-11 | Floyd | Indiana | 18043 | 1190 | 62 |
518964 | 518964 | 2020-09-10 | Floyd | Indiana | 18043 | 1175 | 62 |
515729 | 515729 | 2020-09-09 | Floyd | Indiana | 18043 | 1166 | 61 |
512496 | 512496 | 2020-09-08 | Floyd | Indiana | 18043 | 1162 | 61 |
509263 | 509263 | 2020-09-07 | Floyd | Indiana | 18043 | 1156 | 60 |
506031 | 506031 | 2020-09-06 | Floyd | Indiana | 18043 | 1149 | 60 |
502797 | 502797 | 2020-09-05 | Floyd | Indiana | 18043 | 1138 | 60 |
499563 | 499563 | 2020-09-04 | Floyd | Indiana | 18043 | 1115 | 60 |
496330 | 496330 | 2020-09-03 | Floyd | Indiana | 18043 | 1103 | 60 |
493096 | 493096 | 2020-09-02 | Floyd | Indiana | 18043 | 1091 | 60 |
489863 | 489863 | 2020-09-01 | Floyd | Indiana | 18043 | 1087 | 60 |
486630 | 486630 | 2020-08-31 | Floyd | Indiana | 18043 | 1082 | 57 |
483395 | 483395 | 2020-08-30 | Floyd | Indiana | 18043 | 1075 | 57 |
480161 | 480161 | 2020-08-29 | Floyd | Indiana | 18043 | 1069 | 57 |
476928 | 476928 | 2020-08-28 | Floyd | Indiana | 18043 | 1047 | 57 |
473695 | 473695 | 2020-08-27 | Floyd | Indiana | 18043 | 1031 | 57 |
470463 | 470463 | 2020-08-26 | Floyd | Indiana | 18043 | 1026 | 57 |
467234 | 467234 | 2020-08-25 | Floyd | Indiana | 18043 | 1014 | 57 |
464005 | 464005 | 2020-08-24 | Floyd | Indiana | 18043 | 1001 | 57 |
460776 | 460776 | 2020-08-23 | Floyd | Indiana | 18043 | 983 | 57 |
457549 | 457549 | 2020-08-22 | Floyd | Indiana | 18043 | 971 | 57 |
454321 | 454321 | 2020-08-21 | Floyd | Indiana | 18043 | 964 | 57 |
451093 | 451093 | 2020-08-20 | Floyd | Indiana | 18043 | 941 | 57 |
447865 | 447865 | 2020-08-19 | Floyd | Indiana | 18043 | 929 | 57 |
444638 | 444638 | 2020-08-18 | Floyd | Indiana | 18043 | 924 | 57 |
441412 | 441412 | 2020-08-17 | Floyd | Indiana | 18043 | 906 | 53 |
438186 | 438186 | 2020-08-16 | Floyd | Indiana | 18043 | 894 | 53 |
434960 | 434960 | 2020-08-15 | Floyd | Indiana | 18043 | 881 | 53 |
431735 | 431735 | 2020-08-14 | Floyd | Indiana | 18043 | 865 | 53 |
428507 | 428507 | 2020-08-13 | Floyd | Indiana | 18043 | 841 | 53 |
425283 | 425283 | 2020-08-12 | Floyd | Indiana | 18043 | 826 | 52 |
422062 | 422062 | 2020-08-11 | Floyd | Indiana | 18043 | 813 | 51 |
418839 | 418839 | 2020-08-10 | Floyd | Indiana | 18043 | 795 | 49 |
415618 | 415618 | 2020-08-09 | Floyd | Indiana | 18043 | 783 | 49 |
412398 | 412398 | 2020-08-08 | Floyd | Indiana | 18043 | 776 | 49 |
409179 | 409179 | 2020-08-07 | Floyd | Indiana | 18043 | 764 | 48 |
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);