ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Clark" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193821 | 1193821 | 2021-04-06 | Clark | Indiana | 18019 | 12545 | 196 |
1190571 | 1190571 | 2021-04-05 | Clark | Indiana | 18019 | 12533 | 196 |
1187324 | 1187324 | 2021-04-04 | Clark | Indiana | 18019 | 12511 | 196 |
1184077 | 1184077 | 2021-04-03 | Clark | Indiana | 18019 | 12493 | 196 |
1180830 | 1180830 | 2021-04-02 | Clark | Indiana | 18019 | 12476 | 196 |
1177583 | 1177583 | 2021-04-01 | Clark | Indiana | 18019 | 12460 | 195 |
1174336 | 1174336 | 2021-03-31 | Clark | Indiana | 18019 | 12442 | 195 |
1171089 | 1171089 | 2021-03-30 | Clark | Indiana | 18019 | 12430 | 195 |
1167841 | 1167841 | 2021-03-29 | Clark | Indiana | 18019 | 12427 | 195 |
1164593 | 1164593 | 2021-03-28 | Clark | Indiana | 18019 | 12420 | 194 |
1161345 | 1161345 | 2021-03-27 | Clark | Indiana | 18019 | 12406 | 194 |
1158097 | 1158097 | 2021-03-26 | Clark | Indiana | 18019 | 12389 | 194 |
1154850 | 1154850 | 2021-03-25 | Clark | Indiana | 18019 | 12374 | 194 |
1151603 | 1151603 | 2021-03-24 | Clark | Indiana | 18019 | 12361 | 193 |
1148356 | 1148356 | 2021-03-23 | Clark | Indiana | 18019 | 12347 | 193 |
1145109 | 1145109 | 2021-03-22 | Clark | Indiana | 18019 | 12336 | 192 |
1141862 | 1141862 | 2021-03-21 | Clark | Indiana | 18019 | 12322 | 192 |
1138616 | 1138616 | 2021-03-20 | Clark | Indiana | 18019 | 12313 | 191 |
1135370 | 1135370 | 2021-03-19 | Clark | Indiana | 18019 | 12301 | 191 |
1132123 | 1132123 | 2021-03-18 | Clark | Indiana | 18019 | 12273 | 191 |
1128875 | 1128875 | 2021-03-17 | Clark | Indiana | 18019 | 12252 | 191 |
1125629 | 1125629 | 2021-03-16 | Clark | Indiana | 18019 | 12239 | 191 |
1122383 | 1122383 | 2021-03-15 | Clark | Indiana | 18019 | 12226 | 191 |
1119136 | 1119136 | 2021-03-14 | Clark | Indiana | 18019 | 12218 | 191 |
1115889 | 1115889 | 2021-03-13 | Clark | Indiana | 18019 | 12206 | 191 |
1112643 | 1112643 | 2021-03-12 | Clark | Indiana | 18019 | 12181 | 190 |
1109397 | 1109397 | 2021-03-11 | Clark | Indiana | 18019 | 12151 | 190 |
1106151 | 1106151 | 2021-03-10 | Clark | Indiana | 18019 | 12134 | 190 |
1102905 | 1102905 | 2021-03-09 | Clark | Indiana | 18019 | 12125 | 190 |
1099659 | 1099659 | 2021-03-08 | Clark | Indiana | 18019 | 12112 | 190 |
1096411 | 1096411 | 2021-03-07 | Clark | Indiana | 18019 | 12098 | 190 |
1093165 | 1093165 | 2021-03-06 | Clark | Indiana | 18019 | 12079 | 190 |
1089919 | 1089919 | 2021-03-05 | Clark | Indiana | 18019 | 12051 | 190 |
1086674 | 1086674 | 2021-03-04 | Clark | Indiana | 18019 | 12039 | 189 |
1083428 | 1083428 | 2021-03-03 | Clark | Indiana | 18019 | 12020 | 189 |
1080182 | 1080182 | 2021-03-02 | Clark | Indiana | 18019 | 11997 | 189 |
1076937 | 1076937 | 2021-03-01 | Clark | Indiana | 18019 | 11986 | 189 |
1073691 | 1073691 | 2021-02-28 | Clark | Indiana | 18019 | 11967 | 189 |
1070445 | 1070445 | 2021-02-27 | Clark | Indiana | 18019 | 11949 | 188 |
1067200 | 1067200 | 2021-02-26 | Clark | Indiana | 18019 | 11934 | 188 |
1063955 | 1063955 | 2021-02-25 | Clark | Indiana | 18019 | 11906 | 187 |
1060710 | 1060710 | 2021-02-24 | Clark | Indiana | 18019 | 11881 | 187 |
1057464 | 1057464 | 2021-02-23 | Clark | Indiana | 18019 | 11864 | 187 |
1054218 | 1054218 | 2021-02-22 | Clark | Indiana | 18019 | 11847 | 187 |
1050971 | 1050971 | 2021-02-21 | Clark | Indiana | 18019 | 11827 | 187 |
1047724 | 1047724 | 2021-02-20 | Clark | Indiana | 18019 | 11811 | 187 |
1044479 | 1044479 | 2021-02-19 | Clark | Indiana | 18019 | 11783 | 187 |
1041234 | 1041234 | 2021-02-18 | Clark | Indiana | 18019 | 11761 | 187 |
1037989 | 1037989 | 2021-02-17 | Clark | Indiana | 18019 | 11747 | 187 |
1034744 | 1034744 | 2021-02-16 | Clark | Indiana | 18019 | 11723 | 185 |
1031498 | 1031498 | 2021-02-15 | Clark | Indiana | 18019 | 11699 | 184 |
1028251 | 1028251 | 2021-02-14 | Clark | Indiana | 18019 | 11675 | 184 |
1025006 | 1025006 | 2021-02-13 | Clark | Indiana | 18019 | 11657 | 183 |
1021761 | 1021761 | 2021-02-12 | Clark | Indiana | 18019 | 11637 | 182 |
1018516 | 1018516 | 2021-02-11 | Clark | Indiana | 18019 | 11602 | 180 |
1015271 | 1015271 | 2021-02-10 | Clark | Indiana | 18019 | 11574 | 179 |
1012026 | 1012026 | 2021-02-09 | Clark | Indiana | 18019 | 11541 | 179 |
1008780 | 1008780 | 2021-02-08 | Clark | Indiana | 18019 | 11498 | 174 |
1005534 | 1005534 | 2021-02-07 | Clark | Indiana | 18019 | 11477 | 174 |
1002288 | 1002288 | 2021-02-06 | Clark | Indiana | 18019 | 11446 | 174 |
999042 | 999042 | 2021-02-05 | Clark | Indiana | 18019 | 11396 | 173 |
995796 | 995796 | 2021-02-04 | Clark | Indiana | 18019 | 11344 | 173 |
992550 | 992550 | 2021-02-03 | Clark | Indiana | 18019 | 11296 | 158 |
989304 | 989304 | 2021-02-02 | Clark | Indiana | 18019 | 11262 | 158 |
986057 | 986057 | 2021-02-01 | Clark | Indiana | 18019 | 11227 | 157 |
982810 | 982810 | 2021-01-31 | Clark | Indiana | 18019 | 11177 | 157 |
979564 | 979564 | 2021-01-30 | Clark | Indiana | 18019 | 11112 | 157 |
976318 | 976318 | 2021-01-29 | Clark | Indiana | 18019 | 11060 | 154 |
973073 | 973073 | 2021-01-28 | Clark | Indiana | 18019 | 10964 | 153 |
969828 | 969828 | 2021-01-27 | Clark | Indiana | 18019 | 10910 | 153 |
966584 | 966584 | 2021-01-26 | Clark | Indiana | 18019 | 10873 | 153 |
963339 | 963339 | 2021-01-25 | Clark | Indiana | 18019 | 10832 | 152 |
960094 | 960094 | 2021-01-24 | Clark | Indiana | 18019 | 10752 | 152 |
956848 | 956848 | 2021-01-23 | Clark | Indiana | 18019 | 10698 | 152 |
953603 | 953603 | 2021-01-22 | Clark | Indiana | 18019 | 10602 | 147 |
950358 | 950358 | 2021-01-21 | Clark | Indiana | 18019 | 10541 | 145 |
947112 | 947112 | 2021-01-20 | Clark | Indiana | 18019 | 10449 | 144 |
943865 | 943865 | 2021-01-19 | Clark | Indiana | 18019 | 10370 | 143 |
940620 | 940620 | 2021-01-18 | Clark | Indiana | 18019 | 10321 | 140 |
937375 | 937375 | 2021-01-17 | Clark | Indiana | 18019 | 10261 | 138 |
934130 | 934130 | 2021-01-16 | Clark | Indiana | 18019 | 10172 | 137 |
930885 | 930885 | 2021-01-15 | Clark | Indiana | 18019 | 10053 | 137 |
927640 | 927640 | 2021-01-14 | Clark | Indiana | 18019 | 9973 | 136 |
924394 | 924394 | 2021-01-13 | Clark | Indiana | 18019 | 9885 | 134 |
921149 | 921149 | 2021-01-12 | Clark | Indiana | 18019 | 9778 | 133 |
917904 | 917904 | 2021-01-11 | Clark | Indiana | 18019 | 9716 | 130 |
914659 | 914659 | 2021-01-10 | Clark | Indiana | 18019 | 9636 | 130 |
911414 | 911414 | 2021-01-09 | Clark | Indiana | 18019 | 9514 | 130 |
908169 | 908169 | 2021-01-08 | Clark | Indiana | 18019 | 9357 | 130 |
904923 | 904923 | 2021-01-07 | Clark | Indiana | 18019 | 9253 | 127 |
901678 | 901678 | 2021-01-06 | Clark | Indiana | 18019 | 9104 | 127 |
898433 | 898433 | 2021-01-05 | Clark | Indiana | 18019 | 9004 | 125 |
895188 | 895188 | 2021-01-04 | Clark | Indiana | 18019 | 8894 | 121 |
891941 | 891941 | 2021-01-03 | Clark | Indiana | 18019 | 8785 | 121 |
888695 | 888695 | 2021-01-02 | Clark | Indiana | 18019 | 8701 | 121 |
885449 | 885449 | 2021-01-01 | Clark | Indiana | 18019 | 8566 | 121 |
882204 | 882204 | 2020-12-31 | Clark | Indiana | 18019 | 8403 | 119 |
878959 | 878959 | 2020-12-30 | Clark | Indiana | 18019 | 8262 | 119 |
875714 | 875714 | 2020-12-29 | Clark | Indiana | 18019 | 8185 | 116 |
872469 | 872469 | 2020-12-28 | Clark | Indiana | 18019 | 8094 | 115 |
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);