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 |
---|---|---|---|---|---|---|---|
768631 | 768631 | 2020-11-26 | Floyd | Indiana | 18043 | 3257 | 81 |
765385 | 765385 | 2020-11-25 | Floyd | Indiana | 18043 | 3170 | 80 |
762140 | 762140 | 2020-11-24 | Floyd | Indiana | 18043 | 3122 | 80 |
758895 | 758895 | 2020-11-23 | Floyd | Indiana | 18043 | 3068 | 80 |
755648 | 755648 | 2020-11-22 | Floyd | Indiana | 18043 | 3018 | 80 |
752402 | 752402 | 2020-11-21 | Floyd | Indiana | 18043 | 2955 | 80 |
749156 | 749156 | 2020-11-20 | Floyd | Indiana | 18043 | 2885 | 80 |
745910 | 745910 | 2020-11-19 | Floyd | Indiana | 18043 | 2831 | 80 |
742663 | 742663 | 2020-11-18 | Floyd | Indiana | 18043 | 2779 | 80 |
739416 | 739416 | 2020-11-17 | Floyd | Indiana | 18043 | 2722 | 80 |
736172 | 736172 | 2020-11-16 | Floyd | Indiana | 18043 | 2680 | 79 |
732926 | 732926 | 2020-11-15 | Floyd | Indiana | 18043 | 2644 | 78 |
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 |
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);