ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054232 | 1054232 | 2021-02-22 | Franklin | Indiana | 18047 | 1601 | 36 |
1050985 | 1050985 | 2021-02-21 | Franklin | Indiana | 18047 | 1601 | 36 |
1047738 | 1047738 | 2021-02-20 | Franklin | Indiana | 18047 | 1601 | 36 |
1044493 | 1044493 | 2021-02-19 | Franklin | Indiana | 18047 | 1600 | 36 |
1041248 | 1041248 | 2021-02-18 | Franklin | Indiana | 18047 | 1598 | 36 |
1038003 | 1038003 | 2021-02-17 | Franklin | Indiana | 18047 | 1597 | 36 |
1034758 | 1034758 | 2021-02-16 | Franklin | Indiana | 18047 | 1596 | 36 |
1031512 | 1031512 | 2021-02-15 | Franklin | Indiana | 18047 | 1593 | 36 |
1028265 | 1028265 | 2021-02-14 | Franklin | Indiana | 18047 | 1592 | 36 |
1025020 | 1025020 | 2021-02-13 | Franklin | Indiana | 18047 | 1588 | 36 |
1021775 | 1021775 | 2021-02-12 | Franklin | Indiana | 18047 | 1587 | 36 |
1018530 | 1018530 | 2021-02-11 | Franklin | Indiana | 18047 | 1586 | 36 |
1015285 | 1015285 | 2021-02-10 | Franklin | Indiana | 18047 | 1584 | 36 |
1012040 | 1012040 | 2021-02-09 | Franklin | Indiana | 18047 | 1582 | 36 |
1008794 | 1008794 | 2021-02-08 | Franklin | Indiana | 18047 | 1580 | 36 |
1005548 | 1005548 | 2021-02-07 | Franklin | Indiana | 18047 | 1578 | 36 |
1002302 | 1002302 | 2021-02-06 | Franklin | Indiana | 18047 | 1574 | 36 |
999056 | 999056 | 2021-02-05 | Franklin | Indiana | 18047 | 1566 | 36 |
995810 | 995810 | 2021-02-04 | Franklin | Indiana | 18047 | 1562 | 35 |
992564 | 992564 | 2021-02-03 | Franklin | Indiana | 18047 | 1560 | 34 |
989318 | 989318 | 2021-02-02 | Franklin | Indiana | 18047 | 1559 | 34 |
986071 | 986071 | 2021-02-01 | Franklin | Indiana | 18047 | 1555 | 34 |
982824 | 982824 | 2021-01-31 | Franklin | Indiana | 18047 | 1551 | 34 |
979578 | 979578 | 2021-01-30 | Franklin | Indiana | 18047 | 1549 | 33 |
976332 | 976332 | 2021-01-29 | Franklin | Indiana | 18047 | 1543 | 33 |
973087 | 973087 | 2021-01-28 | Franklin | Indiana | 18047 | 1535 | 34 |
969842 | 969842 | 2021-01-27 | Franklin | Indiana | 18047 | 1533 | 34 |
966598 | 966598 | 2021-01-26 | Franklin | Indiana | 18047 | 1516 | 34 |
963353 | 963353 | 2021-01-25 | Franklin | Indiana | 18047 | 1510 | 34 |
960108 | 960108 | 2021-01-24 | Franklin | Indiana | 18047 | 1507 | 34 |
956862 | 956862 | 2021-01-23 | Franklin | Indiana | 18047 | 1500 | 34 |
953617 | 953617 | 2021-01-22 | Franklin | Indiana | 18047 | 1495 | 34 |
950372 | 950372 | 2021-01-21 | Franklin | Indiana | 18047 | 1486 | 34 |
947126 | 947126 | 2021-01-20 | Franklin | Indiana | 18047 | 1472 | 34 |
943879 | 943879 | 2021-01-19 | Franklin | Indiana | 18047 | 1461 | 34 |
940634 | 940634 | 2021-01-18 | Franklin | Indiana | 18047 | 1455 | 34 |
937389 | 937389 | 2021-01-17 | Franklin | Indiana | 18047 | 1451 | 34 |
934144 | 934144 | 2021-01-16 | Franklin | Indiana | 18047 | 1442 | 34 |
930899 | 930899 | 2021-01-15 | Franklin | Indiana | 18047 | 1434 | 34 |
927654 | 927654 | 2021-01-14 | Franklin | Indiana | 18047 | 1410 | 34 |
924408 | 924408 | 2021-01-13 | Franklin | Indiana | 18047 | 1403 | 34 |
921163 | 921163 | 2021-01-12 | Franklin | Indiana | 18047 | 1391 | 33 |
917918 | 917918 | 2021-01-11 | Franklin | Indiana | 18047 | 1384 | 31 |
914673 | 914673 | 2021-01-10 | Franklin | Indiana | 18047 | 1376 | 31 |
911428 | 911428 | 2021-01-09 | Franklin | Indiana | 18047 | 1363 | 31 |
908183 | 908183 | 2021-01-08 | Franklin | Indiana | 18047 | 1356 | 31 |
904937 | 904937 | 2021-01-07 | Franklin | Indiana | 18047 | 1334 | 31 |
901692 | 901692 | 2021-01-06 | Franklin | Indiana | 18047 | 1316 | 31 |
898447 | 898447 | 2021-01-05 | Franklin | Indiana | 18047 | 1296 | 30 |
895202 | 895202 | 2021-01-04 | Franklin | Indiana | 18047 | 1285 | 30 |
891955 | 891955 | 2021-01-03 | Franklin | Indiana | 18047 | 1276 | 30 |
888709 | 888709 | 2021-01-02 | Franklin | Indiana | 18047 | 1265 | 30 |
885463 | 885463 | 2021-01-01 | Franklin | Indiana | 18047 | 1261 | 30 |
882218 | 882218 | 2020-12-31 | Franklin | Indiana | 18047 | 1229 | 29 |
878973 | 878973 | 2020-12-30 | Franklin | Indiana | 18047 | 1215 | 29 |
875728 | 875728 | 2020-12-29 | Franklin | Indiana | 18047 | 1197 | 29 |
872483 | 872483 | 2020-12-28 | Franklin | Indiana | 18047 | 1173 | 29 |
869238 | 869238 | 2020-12-27 | Franklin | Indiana | 18047 | 1165 | 29 |
865993 | 865993 | 2020-12-26 | Franklin | Indiana | 18047 | 1162 | 29 |
862748 | 862748 | 2020-12-25 | Franklin | Indiana | 18047 | 1154 | 29 |
859503 | 859503 | 2020-12-24 | Franklin | Indiana | 18047 | 1134 | 29 |
856258 | 856258 | 2020-12-23 | Franklin | Indiana | 18047 | 1121 | 29 |
853013 | 853013 | 2020-12-22 | Franklin | Indiana | 18047 | 1102 | 29 |
849768 | 849768 | 2020-12-21 | Franklin | Indiana | 18047 | 1098 | 29 |
846523 | 846523 | 2020-12-20 | Franklin | Indiana | 18047 | 1091 | 29 |
843277 | 843277 | 2020-12-19 | Franklin | Indiana | 18047 | 1081 | 29 |
840032 | 840032 | 2020-12-18 | Franklin | Indiana | 18047 | 1073 | 29 |
836787 | 836787 | 2020-12-17 | Franklin | Indiana | 18047 | 1051 | 29 |
833541 | 833541 | 2020-12-16 | Franklin | Indiana | 18047 | 1030 | 29 |
830294 | 830294 | 2020-12-15 | Franklin | Indiana | 18047 | 1013 | 29 |
827048 | 827048 | 2020-12-14 | Franklin | Indiana | 18047 | 999 | 29 |
823801 | 823801 | 2020-12-13 | Franklin | Indiana | 18047 | 992 | 29 |
820555 | 820555 | 2020-12-12 | Franklin | Indiana | 18047 | 963 | 29 |
817309 | 817309 | 2020-12-11 | Franklin | Indiana | 18047 | 954 | 29 |
814063 | 814063 | 2020-12-10 | Franklin | Indiana | 18047 | 938 | 29 |
810818 | 810818 | 2020-12-09 | Franklin | Indiana | 18047 | 926 | 29 |
807573 | 807573 | 2020-12-08 | Franklin | Indiana | 18047 | 904 | 29 |
804328 | 804328 | 2020-12-07 | Franklin | Indiana | 18047 | 887 | 29 |
801083 | 801083 | 2020-12-06 | Franklin | Indiana | 18047 | 872 | 29 |
797838 | 797838 | 2020-12-05 | Franklin | Indiana | 18047 | 857 | 29 |
794593 | 794593 | 2020-12-04 | Franklin | Indiana | 18047 | 832 | 29 |
791348 | 791348 | 2020-12-03 | Franklin | Indiana | 18047 | 818 | 29 |
788103 | 788103 | 2020-12-02 | Franklin | Indiana | 18047 | 811 | 29 |
784859 | 784859 | 2020-12-01 | Franklin | Indiana | 18047 | 800 | 28 |
781614 | 781614 | 2020-11-30 | Franklin | Indiana | 18047 | 786 | 28 |
778368 | 778368 | 2020-11-29 | Franklin | Indiana | 18047 | 773 | 28 |
775123 | 775123 | 2020-11-28 | Franklin | Indiana | 18047 | 756 | 28 |
771878 | 771878 | 2020-11-27 | Franklin | Indiana | 18047 | 748 | 28 |
768633 | 768633 | 2020-11-26 | Franklin | Indiana | 18047 | 727 | 28 |
765387 | 765387 | 2020-11-25 | Franklin | Indiana | 18047 | 712 | 28 |
762142 | 762142 | 2020-11-24 | Franklin | Indiana | 18047 | 698 | 27 |
758897 | 758897 | 2020-11-23 | Franklin | Indiana | 18047 | 671 | 26 |
755650 | 755650 | 2020-11-22 | Franklin | Indiana | 18047 | 647 | 26 |
752404 | 752404 | 2020-11-21 | Franklin | Indiana | 18047 | 629 | 26 |
749158 | 749158 | 2020-11-20 | Franklin | Indiana | 18047 | 613 | 26 |
745912 | 745912 | 2020-11-19 | Franklin | Indiana | 18047 | 603 | 26 |
742665 | 742665 | 2020-11-18 | Franklin | Indiana | 18047 | 583 | 26 |
739418 | 739418 | 2020-11-17 | Franklin | Indiana | 18047 | 571 | 26 |
736174 | 736174 | 2020-11-16 | Franklin | Indiana | 18047 | 559 | 26 |
732928 | 732928 | 2020-11-15 | Franklin | Indiana | 18047 | 544 | 26 |
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);