ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18053 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193838 | 1193838 | 2021-04-06 | Grant | Indiana | 18053 | 7102 | 174 |
1190588 | 1190588 | 2021-04-05 | Grant | Indiana | 18053 | 7089 | 173 |
1187341 | 1187341 | 2021-04-04 | Grant | Indiana | 18053 | 7084 | 173 |
1184094 | 1184094 | 2021-04-03 | Grant | Indiana | 18053 | 7078 | 173 |
1180847 | 1180847 | 2021-04-02 | Grant | Indiana | 18053 | 7074 | 173 |
1177600 | 1177600 | 2021-04-01 | Grant | Indiana | 18053 | 7064 | 173 |
1174353 | 1174353 | 2021-03-31 | Grant | Indiana | 18053 | 7057 | 173 |
1171106 | 1171106 | 2021-03-30 | Grant | Indiana | 18053 | 7052 | 173 |
1167858 | 1167858 | 2021-03-29 | Grant | Indiana | 18053 | 7044 | 172 |
1164610 | 1164610 | 2021-03-28 | Grant | Indiana | 18053 | 7040 | 172 |
1161362 | 1161362 | 2021-03-27 | Grant | Indiana | 18053 | 7031 | 171 |
1158114 | 1158114 | 2021-03-26 | Grant | Indiana | 18053 | 7023 | 171 |
1154867 | 1154867 | 2021-03-25 | Grant | Indiana | 18053 | 7003 | 171 |
1151620 | 1151620 | 2021-03-24 | Grant | Indiana | 18053 | 6993 | 171 |
1148373 | 1148373 | 2021-03-23 | Grant | Indiana | 18053 | 6988 | 171 |
1145126 | 1145126 | 2021-03-22 | Grant | Indiana | 18053 | 6976 | 171 |
1141879 | 1141879 | 2021-03-21 | Grant | Indiana | 18053 | 6973 | 171 |
1138633 | 1138633 | 2021-03-20 | Grant | Indiana | 18053 | 6970 | 170 |
1135387 | 1135387 | 2021-03-19 | Grant | Indiana | 18053 | 6959 | 170 |
1132140 | 1132140 | 2021-03-18 | Grant | Indiana | 18053 | 6950 | 169 |
1128892 | 1128892 | 2021-03-17 | Grant | Indiana | 18053 | 6945 | 169 |
1125646 | 1125646 | 2021-03-16 | Grant | Indiana | 18053 | 6936 | 169 |
1122400 | 1122400 | 2021-03-15 | Grant | Indiana | 18053 | 6930 | 169 |
1119153 | 1119153 | 2021-03-14 | Grant | Indiana | 18053 | 6921 | 169 |
1115906 | 1115906 | 2021-03-13 | Grant | Indiana | 18053 | 6920 | 169 |
1112660 | 1112660 | 2021-03-12 | Grant | Indiana | 18053 | 6913 | 169 |
1109414 | 1109414 | 2021-03-11 | Grant | Indiana | 18053 | 6908 | 169 |
1106168 | 1106168 | 2021-03-10 | Grant | Indiana | 18053 | 6897 | 167 |
1102922 | 1102922 | 2021-03-09 | Grant | Indiana | 18053 | 6888 | 167 |
1099676 | 1099676 | 2021-03-08 | Grant | Indiana | 18053 | 6885 | 166 |
1096428 | 1096428 | 2021-03-07 | Grant | Indiana | 18053 | 6883 | 166 |
1093182 | 1093182 | 2021-03-06 | Grant | Indiana | 18053 | 6880 | 166 |
1089936 | 1089936 | 2021-03-05 | Grant | Indiana | 18053 | 6871 | 165 |
1086691 | 1086691 | 2021-03-04 | Grant | Indiana | 18053 | 6863 | 165 |
1083445 | 1083445 | 2021-03-03 | Grant | Indiana | 18053 | 6854 | 165 |
1080199 | 1080199 | 2021-03-02 | Grant | Indiana | 18053 | 6847 | 164 |
1076954 | 1076954 | 2021-03-01 | Grant | Indiana | 18053 | 6842 | 164 |
1073708 | 1073708 | 2021-02-28 | Grant | Indiana | 18053 | 6839 | 164 |
1070462 | 1070462 | 2021-02-27 | Grant | Indiana | 18053 | 6837 | 164 |
1067217 | 1067217 | 2021-02-26 | Grant | Indiana | 18053 | 6828 | 164 |
1063972 | 1063972 | 2021-02-25 | Grant | Indiana | 18053 | 6826 | 164 |
1060727 | 1060727 | 2021-02-24 | Grant | Indiana | 18053 | 6821 | 164 |
1057481 | 1057481 | 2021-02-23 | Grant | Indiana | 18053 | 6810 | 164 |
1054235 | 1054235 | 2021-02-22 | Grant | Indiana | 18053 | 6806 | 163 |
1050988 | 1050988 | 2021-02-21 | Grant | Indiana | 18053 | 6803 | 162 |
1047741 | 1047741 | 2021-02-20 | Grant | Indiana | 18053 | 6797 | 162 |
1044496 | 1044496 | 2021-02-19 | Grant | Indiana | 18053 | 6787 | 161 |
1041251 | 1041251 | 2021-02-18 | Grant | Indiana | 18053 | 6783 | 161 |
1038006 | 1038006 | 2021-02-17 | Grant | Indiana | 18053 | 6773 | 161 |
1034761 | 1034761 | 2021-02-16 | Grant | Indiana | 18053 | 6771 | 161 |
1031515 | 1031515 | 2021-02-15 | Grant | Indiana | 18053 | 6767 | 161 |
1028268 | 1028268 | 2021-02-14 | Grant | Indiana | 18053 | 6762 | 161 |
1025023 | 1025023 | 2021-02-13 | Grant | Indiana | 18053 | 6754 | 161 |
1021778 | 1021778 | 2021-02-12 | Grant | Indiana | 18053 | 6739 | 160 |
1018533 | 1018533 | 2021-02-11 | Grant | Indiana | 18053 | 6726 | 159 |
1015288 | 1015288 | 2021-02-10 | Grant | Indiana | 18053 | 6698 | 159 |
1012043 | 1012043 | 2021-02-09 | Grant | Indiana | 18053 | 6684 | 159 |
1008797 | 1008797 | 2021-02-08 | Grant | Indiana | 18053 | 6674 | 158 |
1005551 | 1005551 | 2021-02-07 | Grant | Indiana | 18053 | 6664 | 158 |
1002305 | 1002305 | 2021-02-06 | Grant | Indiana | 18053 | 6654 | 158 |
999059 | 999059 | 2021-02-05 | Grant | Indiana | 18053 | 6623 | 155 |
995813 | 995813 | 2021-02-04 | Grant | Indiana | 18053 | 6614 | 155 |
992567 | 992567 | 2021-02-03 | Grant | Indiana | 18053 | 6599 | 128 |
989321 | 989321 | 2021-02-02 | Grant | Indiana | 18053 | 6590 | 128 |
986074 | 986074 | 2021-02-01 | Grant | Indiana | 18053 | 6574 | 128 |
982827 | 982827 | 2021-01-31 | Grant | Indiana | 18053 | 6562 | 128 |
979581 | 979581 | 2021-01-30 | Grant | Indiana | 18053 | 6546 | 128 |
976335 | 976335 | 2021-01-29 | Grant | Indiana | 18053 | 6523 | 125 |
973090 | 973090 | 2021-01-28 | Grant | Indiana | 18053 | 6504 | 124 |
969845 | 969845 | 2021-01-27 | Grant | Indiana | 18053 | 6479 | 124 |
966601 | 966601 | 2021-01-26 | Grant | Indiana | 18053 | 6462 | 123 |
963356 | 963356 | 2021-01-25 | Grant | Indiana | 18053 | 6437 | 121 |
960111 | 960111 | 2021-01-24 | Grant | Indiana | 18053 | 6421 | 121 |
956865 | 956865 | 2021-01-23 | Grant | Indiana | 18053 | 6401 | 120 |
953620 | 953620 | 2021-01-22 | Grant | Indiana | 18053 | 6375 | 120 |
950375 | 950375 | 2021-01-21 | Grant | Indiana | 18053 | 6347 | 118 |
947129 | 947129 | 2021-01-20 | Grant | Indiana | 18053 | 6304 | 117 |
943882 | 943882 | 2021-01-19 | Grant | Indiana | 18053 | 6284 | 115 |
940637 | 940637 | 2021-01-18 | Grant | Indiana | 18053 | 6257 | 115 |
937392 | 937392 | 2021-01-17 | Grant | Indiana | 18053 | 6227 | 115 |
934147 | 934147 | 2021-01-16 | Grant | Indiana | 18053 | 6208 | 114 |
930902 | 930902 | 2021-01-15 | Grant | Indiana | 18053 | 6175 | 114 |
927657 | 927657 | 2021-01-14 | Grant | Indiana | 18053 | 6127 | 113 |
924411 | 924411 | 2021-01-13 | Grant | Indiana | 18053 | 6070 | 113 |
921166 | 921166 | 2021-01-12 | Grant | Indiana | 18053 | 6036 | 113 |
917921 | 917921 | 2021-01-11 | Grant | Indiana | 18053 | 6001 | 113 |
914676 | 914676 | 2021-01-10 | Grant | Indiana | 18053 | 5962 | 113 |
911431 | 911431 | 2021-01-09 | Grant | Indiana | 18053 | 5920 | 113 |
908186 | 908186 | 2021-01-08 | Grant | Indiana | 18053 | 5864 | 111 |
904940 | 904940 | 2021-01-07 | Grant | Indiana | 18053 | 5789 | 108 |
901695 | 901695 | 2021-01-06 | Grant | Indiana | 18053 | 5707 | 108 |
898450 | 898450 | 2021-01-05 | Grant | Indiana | 18053 | 5648 | 106 |
895205 | 895205 | 2021-01-04 | Grant | Indiana | 18053 | 5582 | 106 |
891958 | 891958 | 2021-01-03 | Grant | Indiana | 18053 | 5558 | 106 |
888712 | 888712 | 2021-01-02 | Grant | Indiana | 18053 | 5496 | 105 |
885466 | 885466 | 2021-01-01 | Grant | Indiana | 18053 | 5462 | 105 |
882221 | 882221 | 2020-12-31 | Grant | Indiana | 18053 | 5404 | 102 |
878976 | 878976 | 2020-12-30 | Grant | Indiana | 18053 | 5306 | 100 |
875731 | 875731 | 2020-12-29 | Grant | Indiana | 18053 | 5257 | 98 |
872486 | 872486 | 2020-12-28 | Grant | Indiana | 18053 | 5208 | 97 |
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);