ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Franklin" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921065 | 921065 | 2021-01-12 | Franklin | Illinois | 17055 | 3693 | 65 |
917820 | 917820 | 2021-01-11 | Franklin | Illinois | 17055 | 3685 | 64 |
914575 | 914575 | 2021-01-10 | Franklin | Illinois | 17055 | 3665 | 64 |
911330 | 911330 | 2021-01-09 | Franklin | Illinois | 17055 | 3645 | 63 |
908085 | 908085 | 2021-01-08 | Franklin | Illinois | 17055 | 3609 | 64 |
904839 | 904839 | 2021-01-07 | Franklin | Illinois | 17055 | 3589 | 63 |
901594 | 901594 | 2021-01-06 | Franklin | Illinois | 17055 | 3559 | 62 |
898349 | 898349 | 2021-01-05 | Franklin | Illinois | 17055 | 3517 | 60 |
895104 | 895104 | 2021-01-04 | Franklin | Illinois | 17055 | 3488 | 59 |
891857 | 891857 | 2021-01-03 | Franklin | Illinois | 17055 | 3473 | 59 |
888610 | 888610 | 2021-01-02 | Franklin | Illinois | 17055 | 3426 | 59 |
885365 | 885365 | 2021-01-01 | Franklin | Illinois | 17055 | 3362 | 56 |
882120 | 882120 | 2020-12-31 | Franklin | Illinois | 17055 | 3362 | 56 |
878875 | 878875 | 2020-12-30 | Franklin | Illinois | 17055 | 3307 | 55 |
875630 | 875630 | 2020-12-29 | Franklin | Illinois | 17055 | 3261 | 52 |
872385 | 872385 | 2020-12-28 | Franklin | Illinois | 17055 | 3234 | 51 |
869140 | 869140 | 2020-12-27 | Franklin | Illinois | 17055 | 3203 | 51 |
865895 | 865895 | 2020-12-26 | Franklin | Illinois | 17055 | 3185 | 49 |
862650 | 862650 | 2020-12-25 | Franklin | Illinois | 17055 | 3175 | 49 |
859405 | 859405 | 2020-12-24 | Franklin | Illinois | 17055 | 3129 | 49 |
856160 | 856160 | 2020-12-23 | Franklin | Illinois | 17055 | 3077 | 48 |
852915 | 852915 | 2020-12-22 | Franklin | Illinois | 17055 | 3028 | 45 |
849670 | 849670 | 2020-12-21 | Franklin | Illinois | 17055 | 2979 | 43 |
846425 | 846425 | 2020-12-20 | Franklin | Illinois | 17055 | 2938 | 43 |
843179 | 843179 | 2020-12-19 | Franklin | Illinois | 17055 | 2903 | 43 |
839934 | 839934 | 2020-12-18 | Franklin | Illinois | 17055 | 2847 | 42 |
836689 | 836689 | 2020-12-17 | Franklin | Illinois | 17055 | 2806 | 42 |
833443 | 833443 | 2020-12-16 | Franklin | Illinois | 17055 | 2746 | 40 |
830196 | 830196 | 2020-12-15 | Franklin | Illinois | 17055 | 2701 | 40 |
826950 | 826950 | 2020-12-14 | Franklin | Illinois | 17055 | 2668 | 38 |
823703 | 823703 | 2020-12-13 | Franklin | Illinois | 17055 | 2627 | 38 |
820457 | 820457 | 2020-12-12 | Franklin | Illinois | 17055 | 2572 | 38 |
817211 | 817211 | 2020-12-11 | Franklin | Illinois | 17055 | 2527 | 37 |
813965 | 813965 | 2020-12-10 | Franklin | Illinois | 17055 | 2485 | 37 |
810720 | 810720 | 2020-12-09 | Franklin | Illinois | 17055 | 2429 | 36 |
807475 | 807475 | 2020-12-08 | Franklin | Illinois | 17055 | 2373 | 36 |
804230 | 804230 | 2020-12-07 | Franklin | Illinois | 17055 | 2344 | 32 |
800985 | 800985 | 2020-12-06 | Franklin | Illinois | 17055 | 2309 | 32 |
797740 | 797740 | 2020-12-05 | Franklin | Illinois | 17055 | 2281 | 32 |
794495 | 794495 | 2020-12-04 | Franklin | Illinois | 17055 | 2243 | 30 |
791250 | 791250 | 2020-12-03 | Franklin | Illinois | 17055 | 2204 | 27 |
788005 | 788005 | 2020-12-02 | Franklin | Illinois | 17055 | 2145 | 27 |
784761 | 784761 | 2020-12-01 | Franklin | Illinois | 17055 | 2109 | 26 |
781516 | 781516 | 2020-11-30 | Franklin | Illinois | 17055 | 2077 | 25 |
778270 | 778270 | 2020-11-29 | Franklin | Illinois | 17055 | 2048 | 25 |
775025 | 775025 | 2020-11-28 | Franklin | Illinois | 17055 | 2021 | 25 |
771780 | 771780 | 2020-11-27 | Franklin | Illinois | 17055 | 1995 | 25 |
768535 | 768535 | 2020-11-26 | Franklin | Illinois | 17055 | 1987 | 25 |
765289 | 765289 | 2020-11-25 | Franklin | Illinois | 17055 | 1936 | 22 |
762044 | 762044 | 2020-11-24 | Franklin | Illinois | 17055 | 1874 | 22 |
758799 | 758799 | 2020-11-23 | Franklin | Illinois | 17055 | 1865 | 22 |
755552 | 755552 | 2020-11-22 | Franklin | Illinois | 17055 | 1856 | 22 |
752306 | 752306 | 2020-11-21 | Franklin | Illinois | 17055 | 1816 | 22 |
749060 | 749060 | 2020-11-20 | Franklin | Illinois | 17055 | 1798 | 19 |
745814 | 745814 | 2020-11-19 | Franklin | Illinois | 17055 | 1757 | 18 |
742567 | 742567 | 2020-11-18 | Franklin | Illinois | 17055 | 1717 | 18 |
739320 | 739320 | 2020-11-17 | Franklin | Illinois | 17055 | 1673 | 17 |
736076 | 736076 | 2020-11-16 | Franklin | Illinois | 17055 | 1642 | 16 |
732830 | 732830 | 2020-11-15 | Franklin | Illinois | 17055 | 1601 | 16 |
729585 | 729585 | 2020-11-14 | Franklin | Illinois | 17055 | 1577 | 16 |
726342 | 726342 | 2020-11-13 | Franklin | Illinois | 17055 | 1512 | 15 |
723099 | 723099 | 2020-11-12 | Franklin | Illinois | 17055 | 1452 | 15 |
719856 | 719856 | 2020-11-11 | Franklin | Illinois | 17055 | 1414 | 15 |
716613 | 716613 | 2020-11-10 | Franklin | Illinois | 17055 | 1363 | 14 |
713369 | 713369 | 2020-11-09 | Franklin | Illinois | 17055 | 1324 | 13 |
710125 | 710125 | 2020-11-08 | Franklin | Illinois | 17055 | 1293 | 13 |
706881 | 706881 | 2020-11-07 | Franklin | Illinois | 17055 | 1265 | 12 |
703638 | 703638 | 2020-11-06 | Franklin | Illinois | 17055 | 1231 | 12 |
700395 | 700395 | 2020-11-05 | Franklin | Illinois | 17055 | 1193 | 12 |
697151 | 697151 | 2020-11-04 | Franklin | Illinois | 17055 | 1151 | 11 |
693909 | 693909 | 2020-11-03 | Franklin | Illinois | 17055 | 1141 | 11 |
690666 | 690666 | 2020-11-02 | Franklin | Illinois | 17055 | 1122 | 10 |
687421 | 687421 | 2020-11-01 | Franklin | Illinois | 17055 | 1110 | 10 |
684177 | 684177 | 2020-10-31 | Franklin | Illinois | 17055 | 1081 | 10 |
680934 | 680934 | 2020-10-30 | Franklin | Illinois | 17055 | 1081 | 10 |
677691 | 677691 | 2020-10-29 | Franklin | Illinois | 17055 | 1059 | 10 |
674448 | 674448 | 2020-10-28 | Franklin | Illinois | 17055 | 1033 | 10 |
671206 | 671206 | 2020-10-27 | Franklin | Illinois | 17055 | 1005 | 9 |
667963 | 667963 | 2020-10-26 | Franklin | Illinois | 17055 | 986 | 9 |
664719 | 664719 | 2020-10-25 | Franklin | Illinois | 17055 | 982 | 9 |
661474 | 661474 | 2020-10-24 | Franklin | Illinois | 17055 | 952 | 9 |
658230 | 658230 | 2020-10-23 | Franklin | Illinois | 17055 | 930 | 8 |
654985 | 654985 | 2020-10-22 | Franklin | Illinois | 17055 | 913 | 8 |
651740 | 651740 | 2020-10-21 | Franklin | Illinois | 17055 | 888 | 8 |
648496 | 648496 | 2020-10-20 | Franklin | Illinois | 17055 | 866 | 6 |
645251 | 645251 | 2020-10-19 | Franklin | Illinois | 17055 | 840 | 6 |
642004 | 642004 | 2020-10-18 | Franklin | Illinois | 17055 | 834 | 6 |
638757 | 638757 | 2020-10-17 | Franklin | Illinois | 17055 | 813 | 6 |
635511 | 635511 | 2020-10-16 | Franklin | Illinois | 17055 | 801 | 6 |
632265 | 632265 | 2020-10-15 | Franklin | Illinois | 17055 | 779 | 6 |
629021 | 629021 | 2020-10-14 | Franklin | Illinois | 17055 | 711 | 6 |
625778 | 625778 | 2020-10-13 | Franklin | Illinois | 17055 | 698 | 5 |
622536 | 622536 | 2020-10-12 | Franklin | Illinois | 17055 | 678 | 5 |
619292 | 619292 | 2020-10-11 | Franklin | Illinois | 17055 | 658 | 5 |
616050 | 616050 | 2020-10-10 | Franklin | Illinois | 17055 | 638 | 5 |
612809 | 612809 | 2020-10-09 | Franklin | Illinois | 17055 | 627 | 5 |
609567 | 609567 | 2020-10-08 | Franklin | Illinois | 17055 | 620 | 5 |
606324 | 606324 | 2020-10-07 | Franklin | Illinois | 17055 | 608 | 5 |
603082 | 603082 | 2020-10-06 | Franklin | Illinois | 17055 | 591 | 4 |
599839 | 599839 | 2020-10-05 | Franklin | Illinois | 17055 | 580 | 4 |
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);