ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18177 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417921 | 1417921 | 2021-06-14 | Wayne | Indiana | 18177 | 7538 | 205 |
1414675 | 1414675 | 2021-06-13 | Wayne | Indiana | 18177 | 7537 | 205 |
1411430 | 1411430 | 2021-06-12 | Wayne | Indiana | 18177 | 7537 | 205 |
1408185 | 1408185 | 2021-06-11 | Wayne | Indiana | 18177 | 7536 | 205 |
1404939 | 1404939 | 2021-06-10 | Wayne | Indiana | 18177 | 7533 | 205 |
1401694 | 1401694 | 2021-06-09 | Wayne | Indiana | 18177 | 7531 | 205 |
1398449 | 1398449 | 2021-06-08 | Wayne | Indiana | 18177 | 7528 | 205 |
1395202 | 1395202 | 2021-06-07 | Wayne | Indiana | 18177 | 7525 | 205 |
1391957 | 1391957 | 2021-06-06 | Wayne | Indiana | 18177 | 7524 | 205 |
1388712 | 1388712 | 2021-06-05 | Wayne | Indiana | 18177 | 7524 | 205 |
1385467 | 1385467 | 2021-06-04 | Wayne | Indiana | 18177 | 7519 | 205 |
1382221 | 1382221 | 2021-06-03 | Wayne | Indiana | 18177 | 7517 | 205 |
1378976 | 1378976 | 2021-06-02 | Wayne | Indiana | 18177 | 7514 | 205 |
1375730 | 1375730 | 2021-06-01 | Wayne | Indiana | 18177 | 7506 | 205 |
1372485 | 1372485 | 2021-05-31 | Wayne | Indiana | 18177 | 7505 | 205 |
1369240 | 1369240 | 2021-05-30 | Wayne | Indiana | 18177 | 7505 | 205 |
1365994 | 1365994 | 2021-05-29 | Wayne | Indiana | 18177 | 7504 | 205 |
1362748 | 1362748 | 2021-05-28 | Wayne | Indiana | 18177 | 7502 | 204 |
1359501 | 1359501 | 2021-05-27 | Wayne | Indiana | 18177 | 7498 | 203 |
1356255 | 1356255 | 2021-05-26 | Wayne | Indiana | 18177 | 7492 | 203 |
1353009 | 1353009 | 2021-05-25 | Wayne | Indiana | 18177 | 7490 | 203 |
1349763 | 1349763 | 2021-05-24 | Wayne | Indiana | 18177 | 7487 | 203 |
1346516 | 1346516 | 2021-05-23 | Wayne | Indiana | 18177 | 7483 | 203 |
1343268 | 1343268 | 2021-05-22 | Wayne | Indiana | 18177 | 7479 | 203 |
1340020 | 1340020 | 2021-05-21 | Wayne | Indiana | 18177 | 7477 | 203 |
1336773 | 1336773 | 2021-05-20 | Wayne | Indiana | 18177 | 7471 | 203 |
1333526 | 1333526 | 2021-05-19 | Wayne | Indiana | 18177 | 7466 | 203 |
1330279 | 1330279 | 2021-05-18 | Wayne | Indiana | 18177 | 7459 | 203 |
1327032 | 1327032 | 2021-05-17 | Wayne | Indiana | 18177 | 7455 | 203 |
1323786 | 1323786 | 2021-05-16 | Wayne | Indiana | 18177 | 7452 | 203 |
1320540 | 1320540 | 2021-05-15 | Wayne | Indiana | 18177 | 7450 | 203 |
1317293 | 1317293 | 2021-05-14 | Wayne | Indiana | 18177 | 7447 | 203 |
1314046 | 1314046 | 2021-05-13 | Wayne | Indiana | 18177 | 7444 | 203 |
1310799 | 1310799 | 2021-05-12 | Wayne | Indiana | 18177 | 7439 | 203 |
1307553 | 1307553 | 2021-05-11 | Wayne | Indiana | 18177 | 7434 | 203 |
1304307 | 1304307 | 2021-05-10 | Wayne | Indiana | 18177 | 7427 | 203 |
1301060 | 1301060 | 2021-05-09 | Wayne | Indiana | 18177 | 7425 | 203 |
1297813 | 1297813 | 2021-05-08 | Wayne | Indiana | 18177 | 7418 | 203 |
1294567 | 1294567 | 2021-05-07 | Wayne | Indiana | 18177 | 7409 | 203 |
1291321 | 1291321 | 2021-05-06 | Wayne | Indiana | 18177 | 7401 | 203 |
1288075 | 1288075 | 2021-05-05 | Wayne | Indiana | 18177 | 7390 | 203 |
1284829 | 1284829 | 2021-05-04 | Wayne | Indiana | 18177 | 7385 | 202 |
1281582 | 1281582 | 2021-05-03 | Wayne | Indiana | 18177 | 7376 | 202 |
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 |
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);