ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Wayne" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278335 | 1278335 | 2021-05-02 | Wayne | Indiana | 18177 | 7374 | 202 |
1275088 | 1275088 | 2021-05-01 | Wayne | Indiana | 18177 | 7369 | 202 |
1271841 | 1271841 | 2021-04-30 | Wayne | Indiana | 18177 | 7360 | 202 |
1268594 | 1268594 | 2021-04-29 | Wayne | Indiana | 18177 | 7351 | 202 |
1265347 | 1265347 | 2021-04-28 | Wayne | Indiana | 18177 | 7342 | 202 |
1262100 | 1262100 | 2021-04-27 | Wayne | Indiana | 18177 | 7334 | 202 |
1258853 | 1258853 | 2021-04-26 | Wayne | Indiana | 18177 | 7331 | 202 |
1255606 | 1255606 | 2021-04-25 | Wayne | Indiana | 18177 | 7328 | 202 |
1252359 | 1252359 | 2021-04-24 | Wayne | Indiana | 18177 | 7319 | 202 |
1249112 | 1249112 | 2021-04-23 | Wayne | Indiana | 18177 | 7310 | 202 |
1245865 | 1245865 | 2021-04-22 | Wayne | Indiana | 18177 | 7305 | 202 |
1242618 | 1242618 | 2021-04-21 | Wayne | Indiana | 18177 | 7301 | 202 |
1239371 | 1239371 | 2021-04-20 | Wayne | Indiana | 18177 | 7294 | 202 |
1236124 | 1236124 | 2021-04-19 | Wayne | Indiana | 18177 | 7290 | 202 |
1232877 | 1232877 | 2021-04-18 | Wayne | Indiana | 18177 | 7283 | 202 |
1229628 | 1229628 | 2021-04-17 | Wayne | Indiana | 18177 | 7279 | 202 |
1226380 | 1226380 | 2021-04-16 | Wayne | Indiana | 18177 | 7271 | 202 |
1223133 | 1223133 | 2021-04-15 | Wayne | Indiana | 18177 | 7264 | 202 |
1219885 | 1219885 | 2021-04-14 | Wayne | Indiana | 18177 | 7255 | 202 |
1216637 | 1216637 | 2021-04-13 | Wayne | Indiana | 18177 | 7249 | 201 |
1213390 | 1213390 | 2021-04-12 | Wayne | Indiana | 18177 | 7238 | 200 |
1210142 | 1210142 | 2021-04-11 | Wayne | Indiana | 18177 | 7233 | 200 |
1206893 | 1206893 | 2021-04-10 | Wayne | Indiana | 18177 | 7230 | 200 |
1203645 | 1203645 | 2021-04-09 | Wayne | Indiana | 18177 | 7225 | 200 |
1200397 | 1200397 | 2021-04-08 | Wayne | Indiana | 18177 | 7214 | 200 |
1197148 | 1197148 | 2021-04-07 | Wayne | Indiana | 18177 | 7204 | 200 |
1193900 | 1193900 | 2021-04-06 | Wayne | Indiana | 18177 | 7203 | 200 |
1190650 | 1190650 | 2021-04-05 | Wayne | Indiana | 18177 | 7199 | 200 |
1187403 | 1187403 | 2021-04-04 | Wayne | Indiana | 18177 | 7195 | 200 |
1184156 | 1184156 | 2021-04-03 | Wayne | Indiana | 18177 | 7188 | 200 |
1180909 | 1180909 | 2021-04-02 | Wayne | Indiana | 18177 | 7185 | 200 |
1177662 | 1177662 | 2021-04-01 | Wayne | Indiana | 18177 | 7178 | 200 |
1174415 | 1174415 | 2021-03-31 | Wayne | Indiana | 18177 | 7173 | 200 |
1171168 | 1171168 | 2021-03-30 | Wayne | Indiana | 18177 | 7161 | 200 |
1167920 | 1167920 | 2021-03-29 | Wayne | Indiana | 18177 | 7159 | 200 |
1164672 | 1164672 | 2021-03-28 | Wayne | Indiana | 18177 | 7157 | 200 |
1161424 | 1161424 | 2021-03-27 | Wayne | Indiana | 18177 | 7152 | 200 |
1158176 | 1158176 | 2021-03-26 | Wayne | Indiana | 18177 | 7149 | 200 |
1154929 | 1154929 | 2021-03-25 | Wayne | Indiana | 18177 | 7140 | 200 |
1151682 | 1151682 | 2021-03-24 | Wayne | Indiana | 18177 | 7137 | 200 |
1148435 | 1148435 | 2021-03-23 | Wayne | Indiana | 18177 | 7132 | 200 |
1145188 | 1145188 | 2021-03-22 | Wayne | Indiana | 18177 | 7120 | 200 |
1141941 | 1141941 | 2021-03-21 | Wayne | Indiana | 18177 | 7119 | 200 |
1138695 | 1138695 | 2021-03-20 | Wayne | Indiana | 18177 | 7112 | 200 |
1135449 | 1135449 | 2021-03-19 | Wayne | Indiana | 18177 | 7108 | 200 |
1132202 | 1132202 | 2021-03-18 | Wayne | Indiana | 18177 | 7099 | 200 |
1128954 | 1128954 | 2021-03-17 | Wayne | Indiana | 18177 | 7095 | 199 |
1125708 | 1125708 | 2021-03-16 | Wayne | Indiana | 18177 | 7089 | 199 |
1122462 | 1122462 | 2021-03-15 | Wayne | Indiana | 18177 | 7084 | 198 |
1119215 | 1119215 | 2021-03-14 | Wayne | Indiana | 18177 | 7081 | 197 |
1115968 | 1115968 | 2021-03-13 | Wayne | Indiana | 18177 | 7077 | 197 |
1112722 | 1112722 | 2021-03-12 | Wayne | Indiana | 18177 | 7075 | 195 |
1109476 | 1109476 | 2021-03-11 | Wayne | Indiana | 18177 | 7070 | 195 |
1106230 | 1106230 | 2021-03-10 | Wayne | Indiana | 18177 | 7061 | 195 |
1102984 | 1102984 | 2021-03-09 | Wayne | Indiana | 18177 | 7055 | 195 |
1099738 | 1099738 | 2021-03-08 | Wayne | Indiana | 18177 | 7052 | 195 |
1096490 | 1096490 | 2021-03-07 | Wayne | Indiana | 18177 | 7047 | 195 |
1093244 | 1093244 | 2021-03-06 | Wayne | Indiana | 18177 | 7047 | 195 |
1089998 | 1089998 | 2021-03-05 | Wayne | Indiana | 18177 | 7040 | 195 |
1086753 | 1086753 | 2021-03-04 | Wayne | Indiana | 18177 | 7038 | 195 |
1083507 | 1083507 | 2021-03-03 | Wayne | Indiana | 18177 | 7035 | 195 |
1080261 | 1080261 | 2021-03-02 | Wayne | Indiana | 18177 | 7030 | 195 |
1077016 | 1077016 | 2021-03-01 | Wayne | Indiana | 18177 | 7023 | 194 |
1073770 | 1073770 | 2021-02-28 | Wayne | Indiana | 18177 | 7021 | 194 |
1070524 | 1070524 | 2021-02-27 | Wayne | Indiana | 18177 | 7020 | 194 |
1067279 | 1067279 | 2021-02-26 | Wayne | Indiana | 18177 | 7012 | 194 |
1064034 | 1064034 | 2021-02-25 | Wayne | Indiana | 18177 | 7007 | 193 |
1060789 | 1060789 | 2021-02-24 | Wayne | Indiana | 18177 | 6988 | 193 |
1057543 | 1057543 | 2021-02-23 | Wayne | Indiana | 18177 | 6977 | 192 |
1054297 | 1054297 | 2021-02-22 | Wayne | Indiana | 18177 | 6973 | 191 |
1051050 | 1051050 | 2021-02-21 | Wayne | Indiana | 18177 | 6970 | 191 |
1047803 | 1047803 | 2021-02-20 | Wayne | Indiana | 18177 | 6967 | 190 |
1044558 | 1044558 | 2021-02-19 | Wayne | Indiana | 18177 | 6952 | 190 |
1041313 | 1041313 | 2021-02-18 | Wayne | Indiana | 18177 | 6948 | 189 |
1038068 | 1038068 | 2021-02-17 | Wayne | Indiana | 18177 | 6943 | 189 |
1034823 | 1034823 | 2021-02-16 | Wayne | Indiana | 18177 | 6934 | 188 |
1031577 | 1031577 | 2021-02-15 | Wayne | Indiana | 18177 | 6923 | 187 |
1028330 | 1028330 | 2021-02-14 | Wayne | Indiana | 18177 | 6914 | 187 |
1025085 | 1025085 | 2021-02-13 | Wayne | Indiana | 18177 | 6906 | 187 |
1021840 | 1021840 | 2021-02-12 | Wayne | Indiana | 18177 | 6886 | 187 |
1018595 | 1018595 | 2021-02-11 | Wayne | Indiana | 18177 | 6869 | 185 |
1015350 | 1015350 | 2021-02-10 | Wayne | Indiana | 18177 | 6851 | 184 |
1012105 | 1012105 | 2021-02-09 | Wayne | Indiana | 18177 | 6837 | 183 |
1008859 | 1008859 | 2021-02-08 | Wayne | Indiana | 18177 | 6826 | 183 |
1005613 | 1005613 | 2021-02-07 | Wayne | Indiana | 18177 | 6813 | 183 |
1002367 | 1002367 | 2021-02-06 | Wayne | Indiana | 18177 | 6803 | 183 |
999121 | 999121 | 2021-02-05 | Wayne | Indiana | 18177 | 6793 | 182 |
995875 | 995875 | 2021-02-04 | Wayne | Indiana | 18177 | 6771 | 182 |
992629 | 992629 | 2021-02-03 | Wayne | Indiana | 18177 | 6752 | 173 |
989383 | 989383 | 2021-02-02 | Wayne | Indiana | 18177 | 6734 | 173 |
986136 | 986136 | 2021-02-01 | Wayne | Indiana | 18177 | 6717 | 170 |
982889 | 982889 | 2021-01-31 | Wayne | Indiana | 18177 | 6713 | 170 |
979643 | 979643 | 2021-01-30 | Wayne | Indiana | 18177 | 6692 | 170 |
976397 | 976397 | 2021-01-29 | Wayne | Indiana | 18177 | 6665 | 168 |
973152 | 973152 | 2021-01-28 | Wayne | Indiana | 18177 | 6644 | 167 |
969907 | 969907 | 2021-01-27 | Wayne | Indiana | 18177 | 6606 | 167 |
966663 | 966663 | 2021-01-26 | Wayne | Indiana | 18177 | 6587 | 167 |
963418 | 963418 | 2021-01-25 | Wayne | Indiana | 18177 | 6569 | 165 |
960173 | 960173 | 2021-01-24 | Wayne | Indiana | 18177 | 6549 | 165 |
956927 | 956927 | 2021-01-23 | Wayne | Indiana | 18177 | 6528 | 165 |
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);