ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Perry" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054270 | 1054270 | 2021-02-22 | Perry | Indiana | 18123 | 1731 | 36 |
1051023 | 1051023 | 2021-02-21 | Perry | Indiana | 18123 | 1730 | 36 |
1047776 | 1047776 | 2021-02-20 | Perry | Indiana | 18123 | 1728 | 36 |
1044531 | 1044531 | 2021-02-19 | Perry | Indiana | 18123 | 1723 | 36 |
1041286 | 1041286 | 2021-02-18 | Perry | Indiana | 18123 | 1722 | 36 |
1038041 | 1038041 | 2021-02-17 | Perry | Indiana | 18123 | 1721 | 36 |
1034796 | 1034796 | 2021-02-16 | Perry | Indiana | 18123 | 1720 | 36 |
1031550 | 1031550 | 2021-02-15 | Perry | Indiana | 18123 | 1714 | 36 |
1028303 | 1028303 | 2021-02-14 | Perry | Indiana | 18123 | 1712 | 36 |
1025058 | 1025058 | 2021-02-13 | Perry | Indiana | 18123 | 1707 | 36 |
1021813 | 1021813 | 2021-02-12 | Perry | Indiana | 18123 | 1703 | 36 |
1018568 | 1018568 | 2021-02-11 | Perry | Indiana | 18123 | 1700 | 36 |
1015323 | 1015323 | 2021-02-10 | Perry | Indiana | 18123 | 1698 | 36 |
1012078 | 1012078 | 2021-02-09 | Perry | Indiana | 18123 | 1697 | 36 |
1008832 | 1008832 | 2021-02-08 | Perry | Indiana | 18123 | 1691 | 36 |
1005586 | 1005586 | 2021-02-07 | Perry | Indiana | 18123 | 1688 | 36 |
1002340 | 1002340 | 2021-02-06 | Perry | Indiana | 18123 | 1684 | 36 |
999094 | 999094 | 2021-02-05 | Perry | Indiana | 18123 | 1676 | 35 |
995848 | 995848 | 2021-02-04 | Perry | Indiana | 18123 | 1674 | 35 |
992602 | 992602 | 2021-02-03 | Perry | Indiana | 18123 | 1661 | 34 |
989356 | 989356 | 2021-02-02 | Perry | Indiana | 18123 | 1659 | 34 |
986109 | 986109 | 2021-02-01 | Perry | Indiana | 18123 | 1656 | 34 |
982862 | 982862 | 2021-01-31 | Perry | Indiana | 18123 | 1649 | 34 |
979616 | 979616 | 2021-01-30 | Perry | Indiana | 18123 | 1641 | 34 |
976370 | 976370 | 2021-01-29 | Perry | Indiana | 18123 | 1607 | 34 |
973125 | 973125 | 2021-01-28 | Perry | Indiana | 18123 | 1588 | 31 |
969880 | 969880 | 2021-01-27 | Perry | Indiana | 18123 | 1579 | 31 |
966636 | 966636 | 2021-01-26 | Perry | Indiana | 18123 | 1571 | 30 |
963391 | 963391 | 2021-01-25 | Perry | Indiana | 18123 | 1569 | 30 |
960146 | 960146 | 2021-01-24 | Perry | Indiana | 18123 | 1562 | 30 |
956900 | 956900 | 2021-01-23 | Perry | Indiana | 18123 | 1552 | 30 |
953655 | 953655 | 2021-01-22 | Perry | Indiana | 18123 | 1537 | 28 |
950410 | 950410 | 2021-01-21 | Perry | Indiana | 18123 | 1522 | 28 |
947164 | 947164 | 2021-01-20 | Perry | Indiana | 18123 | 1507 | 28 |
943917 | 943917 | 2021-01-19 | Perry | Indiana | 18123 | 1503 | 28 |
940672 | 940672 | 2021-01-18 | Perry | Indiana | 18123 | 1497 | 28 |
937427 | 937427 | 2021-01-17 | Perry | Indiana | 18123 | 1482 | 28 |
934182 | 934182 | 2021-01-16 | Perry | Indiana | 18123 | 1463 | 28 |
930937 | 930937 | 2021-01-15 | Perry | Indiana | 18123 | 1446 | 28 |
927692 | 927692 | 2021-01-14 | Perry | Indiana | 18123 | 1423 | 28 |
924446 | 924446 | 2021-01-13 | Perry | Indiana | 18123 | 1407 | 28 |
921201 | 921201 | 2021-01-12 | Perry | Indiana | 18123 | 1400 | 27 |
917956 | 917956 | 2021-01-11 | Perry | Indiana | 18123 | 1392 | 27 |
914711 | 914711 | 2021-01-10 | Perry | Indiana | 18123 | 1374 | 27 |
911466 | 911466 | 2021-01-09 | Perry | Indiana | 18123 | 1349 | 27 |
908221 | 908221 | 2021-01-08 | Perry | Indiana | 18123 | 1323 | 26 |
904975 | 904975 | 2021-01-07 | Perry | Indiana | 18123 | 1307 | 26 |
901730 | 901730 | 2021-01-06 | Perry | Indiana | 18123 | 1279 | 26 |
898485 | 898485 | 2021-01-05 | Perry | Indiana | 18123 | 1272 | 26 |
895240 | 895240 | 2021-01-04 | Perry | Indiana | 18123 | 1258 | 24 |
891993 | 891993 | 2021-01-03 | Perry | Indiana | 18123 | 1250 | 24 |
888747 | 888747 | 2021-01-02 | Perry | Indiana | 18123 | 1240 | 24 |
885501 | 885501 | 2021-01-01 | Perry | Indiana | 18123 | 1223 | 24 |
882256 | 882256 | 2020-12-31 | Perry | Indiana | 18123 | 1205 | 23 |
879011 | 879011 | 2020-12-30 | Perry | Indiana | 18123 | 1179 | 23 |
875766 | 875766 | 2020-12-29 | Perry | Indiana | 18123 | 1173 | 23 |
872521 | 872521 | 2020-12-28 | Perry | Indiana | 18123 | 1167 | 23 |
869276 | 869276 | 2020-12-27 | Perry | Indiana | 18123 | 1164 | 23 |
866031 | 866031 | 2020-12-26 | Perry | Indiana | 18123 | 1154 | 23 |
862786 | 862786 | 2020-12-25 | Perry | Indiana | 18123 | 1146 | 23 |
859541 | 859541 | 2020-12-24 | Perry | Indiana | 18123 | 1135 | 23 |
856296 | 856296 | 2020-12-23 | Perry | Indiana | 18123 | 1119 | 23 |
853051 | 853051 | 2020-12-22 | Perry | Indiana | 18123 | 1110 | 23 |
849806 | 849806 | 2020-12-21 | Perry | Indiana | 18123 | 1103 | 23 |
846561 | 846561 | 2020-12-20 | Perry | Indiana | 18123 | 1093 | 23 |
843315 | 843315 | 2020-12-19 | Perry | Indiana | 18123 | 1081 | 23 |
840070 | 840070 | 2020-12-18 | Perry | Indiana | 18123 | 1072 | 23 |
836825 | 836825 | 2020-12-17 | Perry | Indiana | 18123 | 1054 | 23 |
833579 | 833579 | 2020-12-16 | Perry | Indiana | 18123 | 1036 | 23 |
830332 | 830332 | 2020-12-15 | Perry | Indiana | 18123 | 1031 | 23 |
827086 | 827086 | 2020-12-14 | Perry | Indiana | 18123 | 1029 | 23 |
823839 | 823839 | 2020-12-13 | Perry | Indiana | 18123 | 1018 | 23 |
820593 | 820593 | 2020-12-12 | Perry | Indiana | 18123 | 1006 | 23 |
817347 | 817347 | 2020-12-11 | Perry | Indiana | 18123 | 998 | 23 |
814101 | 814101 | 2020-12-10 | Perry | Indiana | 18123 | 987 | 23 |
810856 | 810856 | 2020-12-09 | Perry | Indiana | 18123 | 969 | 23 |
807611 | 807611 | 2020-12-08 | Perry | Indiana | 18123 | 963 | 23 |
804366 | 804366 | 2020-12-07 | Perry | Indiana | 18123 | 955 | 23 |
801121 | 801121 | 2020-12-06 | Perry | Indiana | 18123 | 947 | 23 |
797876 | 797876 | 2020-12-05 | Perry | Indiana | 18123 | 934 | 23 |
794631 | 794631 | 2020-12-04 | Perry | Indiana | 18123 | 914 | 23 |
791386 | 791386 | 2020-12-03 | Perry | Indiana | 18123 | 903 | 23 |
788141 | 788141 | 2020-12-02 | Perry | Indiana | 18123 | 891 | 23 |
784897 | 784897 | 2020-12-01 | Perry | Indiana | 18123 | 887 | 22 |
781652 | 781652 | 2020-11-30 | Perry | Indiana | 18123 | 883 | 22 |
778406 | 778406 | 2020-11-29 | Perry | Indiana | 18123 | 874 | 22 |
775161 | 775161 | 2020-11-28 | Perry | Indiana | 18123 | 871 | 22 |
771916 | 771916 | 2020-11-27 | Perry | Indiana | 18123 | 861 | 22 |
768671 | 768671 | 2020-11-26 | Perry | Indiana | 18123 | 847 | 22 |
765425 | 765425 | 2020-11-25 | Perry | Indiana | 18123 | 835 | 22 |
762180 | 762180 | 2020-11-24 | Perry | Indiana | 18123 | 825 | 22 |
758935 | 758935 | 2020-11-23 | Perry | Indiana | 18123 | 819 | 22 |
755688 | 755688 | 2020-11-22 | Perry | Indiana | 18123 | 815 | 22 |
752442 | 752442 | 2020-11-21 | Perry | Indiana | 18123 | 808 | 22 |
749196 | 749196 | 2020-11-20 | Perry | Indiana | 18123 | 796 | 22 |
745950 | 745950 | 2020-11-19 | Perry | Indiana | 18123 | 785 | 22 |
742703 | 742703 | 2020-11-18 | Perry | Indiana | 18123 | 772 | 22 |
739456 | 739456 | 2020-11-17 | Perry | Indiana | 18123 | 762 | 21 |
736212 | 736212 | 2020-11-16 | Perry | Indiana | 18123 | 752 | 21 |
732966 | 732966 | 2020-11-15 | Perry | Indiana | 18123 | 738 | 21 |
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);