ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where fips = 18125 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054271 | 1054271 | 2021-02-22 | Pike | Indiana | 18125 | 1271 | 32 |
1051024 | 1051024 | 2021-02-21 | Pike | Indiana | 18125 | 1271 | 32 |
1047777 | 1047777 | 2021-02-20 | Pike | Indiana | 18125 | 1268 | 32 |
1044532 | 1044532 | 2021-02-19 | Pike | Indiana | 18125 | 1266 | 32 |
1041287 | 1041287 | 2021-02-18 | Pike | Indiana | 18125 | 1264 | 32 |
1038042 | 1038042 | 2021-02-17 | Pike | Indiana | 18125 | 1264 | 32 |
1034797 | 1034797 | 2021-02-16 | Pike | Indiana | 18125 | 1264 | 32 |
1031551 | 1031551 | 2021-02-15 | Pike | Indiana | 18125 | 1264 | 32 |
1028304 | 1028304 | 2021-02-14 | Pike | Indiana | 18125 | 1263 | 32 |
1025059 | 1025059 | 2021-02-13 | Pike | Indiana | 18125 | 1262 | 32 |
1021814 | 1021814 | 2021-02-12 | Pike | Indiana | 18125 | 1261 | 32 |
1018569 | 1018569 | 2021-02-11 | Pike | Indiana | 18125 | 1260 | 32 |
1015324 | 1015324 | 2021-02-10 | Pike | Indiana | 18125 | 1261 | 32 |
1012079 | 1012079 | 2021-02-09 | Pike | Indiana | 18125 | 1260 | 31 |
1008833 | 1008833 | 2021-02-08 | Pike | Indiana | 18125 | 1260 | 31 |
1005587 | 1005587 | 2021-02-07 | Pike | Indiana | 18125 | 1257 | 31 |
1002341 | 1002341 | 2021-02-06 | Pike | Indiana | 18125 | 1251 | 31 |
999095 | 999095 | 2021-02-05 | Pike | Indiana | 18125 | 1245 | 31 |
995849 | 995849 | 2021-02-04 | Pike | Indiana | 18125 | 1244 | 31 |
992603 | 992603 | 2021-02-03 | Pike | Indiana | 18125 | 1236 | 28 |
989357 | 989357 | 2021-02-02 | Pike | Indiana | 18125 | 1234 | 28 |
986110 | 986110 | 2021-02-01 | Pike | Indiana | 18125 | 1234 | 28 |
982863 | 982863 | 2021-01-31 | Pike | Indiana | 18125 | 1228 | 28 |
979617 | 979617 | 2021-01-30 | Pike | Indiana | 18125 | 1224 | 28 |
976371 | 976371 | 2021-01-29 | Pike | Indiana | 18125 | 1218 | 28 |
973126 | 973126 | 2021-01-28 | Pike | Indiana | 18125 | 1211 | 28 |
969881 | 969881 | 2021-01-27 | Pike | Indiana | 18125 | 1197 | 28 |
966637 | 966637 | 2021-01-26 | Pike | Indiana | 18125 | 1190 | 28 |
963392 | 963392 | 2021-01-25 | Pike | Indiana | 18125 | 1187 | 28 |
960147 | 960147 | 2021-01-24 | Pike | Indiana | 18125 | 1184 | 28 |
956901 | 956901 | 2021-01-23 | Pike | Indiana | 18125 | 1171 | 28 |
953656 | 953656 | 2021-01-22 | Pike | Indiana | 18125 | 1164 | 28 |
950411 | 950411 | 2021-01-21 | Pike | Indiana | 18125 | 1158 | 28 |
947165 | 947165 | 2021-01-20 | Pike | Indiana | 18125 | 1148 | 28 |
943918 | 943918 | 2021-01-19 | Pike | Indiana | 18125 | 1145 | 28 |
940673 | 940673 | 2021-01-18 | Pike | Indiana | 18125 | 1143 | 27 |
937428 | 937428 | 2021-01-17 | Pike | Indiana | 18125 | 1138 | 27 |
934183 | 934183 | 2021-01-16 | Pike | Indiana | 18125 | 1133 | 27 |
930938 | 930938 | 2021-01-15 | Pike | Indiana | 18125 | 1126 | 27 |
927693 | 927693 | 2021-01-14 | Pike | Indiana | 18125 | 1115 | 27 |
924447 | 924447 | 2021-01-13 | Pike | Indiana | 18125 | 1088 | 27 |
921202 | 921202 | 2021-01-12 | Pike | Indiana | 18125 | 1073 | 27 |
917957 | 917957 | 2021-01-11 | Pike | Indiana | 18125 | 1063 | 27 |
914712 | 914712 | 2021-01-10 | Pike | Indiana | 18125 | 1053 | 27 |
911467 | 911467 | 2021-01-09 | Pike | Indiana | 18125 | 1042 | 27 |
908222 | 908222 | 2021-01-08 | Pike | Indiana | 18125 | 1038 | 27 |
904976 | 904976 | 2021-01-07 | Pike | Indiana | 18125 | 1023 | 27 |
901731 | 901731 | 2021-01-06 | Pike | Indiana | 18125 | 1007 | 27 |
898486 | 898486 | 2021-01-05 | Pike | Indiana | 18125 | 992 | 27 |
895241 | 895241 | 2021-01-04 | Pike | Indiana | 18125 | 977 | 27 |
891994 | 891994 | 2021-01-03 | Pike | Indiana | 18125 | 964 | 27 |
888748 | 888748 | 2021-01-02 | Pike | Indiana | 18125 | 955 | 27 |
885502 | 885502 | 2021-01-01 | Pike | Indiana | 18125 | 949 | 27 |
882257 | 882257 | 2020-12-31 | Pike | Indiana | 18125 | 934 | 27 |
879012 | 879012 | 2020-12-30 | Pike | Indiana | 18125 | 912 | 27 |
875767 | 875767 | 2020-12-29 | Pike | Indiana | 18125 | 897 | 26 |
872522 | 872522 | 2020-12-28 | Pike | Indiana | 18125 | 894 | 26 |
869277 | 869277 | 2020-12-27 | Pike | Indiana | 18125 | 885 | 26 |
866032 | 866032 | 2020-12-26 | Pike | Indiana | 18125 | 879 | 26 |
862787 | 862787 | 2020-12-25 | Pike | Indiana | 18125 | 870 | 26 |
859542 | 859542 | 2020-12-24 | Pike | Indiana | 18125 | 854 | 25 |
856297 | 856297 | 2020-12-23 | Pike | Indiana | 18125 | 837 | 25 |
853052 | 853052 | 2020-12-22 | Pike | Indiana | 18125 | 823 | 25 |
849807 | 849807 | 2020-12-21 | Pike | Indiana | 18125 | 818 | 25 |
846562 | 846562 | 2020-12-20 | Pike | Indiana | 18125 | 811 | 25 |
843316 | 843316 | 2020-12-19 | Pike | Indiana | 18125 | 787 | 24 |
840071 | 840071 | 2020-12-18 | Pike | Indiana | 18125 | 773 | 24 |
836826 | 836826 | 2020-12-17 | Pike | Indiana | 18125 | 761 | 24 |
833580 | 833580 | 2020-12-16 | Pike | Indiana | 18125 | 743 | 24 |
830333 | 830333 | 2020-12-15 | Pike | Indiana | 18125 | 722 | 24 |
827087 | 827087 | 2020-12-14 | Pike | Indiana | 18125 | 717 | 23 |
823840 | 823840 | 2020-12-13 | Pike | Indiana | 18125 | 708 | 23 |
820594 | 820594 | 2020-12-12 | Pike | Indiana | 18125 | 695 | 21 |
817348 | 817348 | 2020-12-11 | Pike | Indiana | 18125 | 681 | 21 |
814102 | 814102 | 2020-12-10 | Pike | Indiana | 18125 | 665 | 21 |
810857 | 810857 | 2020-12-09 | Pike | Indiana | 18125 | 661 | 21 |
807612 | 807612 | 2020-12-08 | Pike | Indiana | 18125 | 652 | 21 |
804367 | 804367 | 2020-12-07 | Pike | Indiana | 18125 | 650 | 21 |
801122 | 801122 | 2020-12-06 | Pike | Indiana | 18125 | 639 | 21 |
797877 | 797877 | 2020-12-05 | Pike | Indiana | 18125 | 624 | 21 |
794632 | 794632 | 2020-12-04 | Pike | Indiana | 18125 | 610 | 21 |
791387 | 791387 | 2020-12-03 | Pike | Indiana | 18125 | 593 | 21 |
788142 | 788142 | 2020-12-02 | Pike | Indiana | 18125 | 574 | 21 |
784898 | 784898 | 2020-12-01 | Pike | Indiana | 18125 | 552 | 20 |
781653 | 781653 | 2020-11-30 | Pike | Indiana | 18125 | 549 | 20 |
778407 | 778407 | 2020-11-29 | Pike | Indiana | 18125 | 540 | 20 |
775162 | 775162 | 2020-11-28 | Pike | Indiana | 18125 | 537 | 20 |
771917 | 771917 | 2020-11-27 | Pike | Indiana | 18125 | 527 | 19 |
768672 | 768672 | 2020-11-26 | Pike | Indiana | 18125 | 516 | 19 |
765426 | 765426 | 2020-11-25 | Pike | Indiana | 18125 | 509 | 19 |
762181 | 762181 | 2020-11-24 | Pike | Indiana | 18125 | 503 | 18 |
758936 | 758936 | 2020-11-23 | Pike | Indiana | 18125 | 502 | 18 |
755689 | 755689 | 2020-11-22 | Pike | Indiana | 18125 | 496 | 18 |
752443 | 752443 | 2020-11-21 | Pike | Indiana | 18125 | 489 | 18 |
749197 | 749197 | 2020-11-20 | Pike | Indiana | 18125 | 482 | 18 |
745951 | 745951 | 2020-11-19 | Pike | Indiana | 18125 | 480 | 18 |
742704 | 742704 | 2020-11-18 | Pike | Indiana | 18125 | 471 | 18 |
739457 | 739457 | 2020-11-17 | Pike | Indiana | 18125 | 464 | 18 |
736213 | 736213 | 2020-11-16 | Pike | Indiana | 18125 | 457 | 18 |
732967 | 732967 | 2020-11-15 | Pike | Indiana | 18125 | 452 | 18 |
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);