ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18163 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1486074 | 1486074 | 2021-07-05 | Vanderburgh | Indiana | 18163 | 22681 | 408 |
1482828 | 1482828 | 2021-07-04 | Vanderburgh | Indiana | 18163 | 22681 | 408 |
1479581 | 1479581 | 2021-07-03 | Vanderburgh | Indiana | 18163 | 22681 | 408 |
1476335 | 1476335 | 2021-07-02 | Vanderburgh | Indiana | 18163 | 22681 | 408 |
1473089 | 1473089 | 2021-07-01 | Vanderburgh | Indiana | 18163 | 22672 | 407 |
1469843 | 1469843 | 2021-06-30 | Vanderburgh | Indiana | 18163 | 22654 | 407 |
1466598 | 1466598 | 2021-06-29 | Vanderburgh | Indiana | 18163 | 22632 | 407 |
1463353 | 1463353 | 2021-06-28 | Vanderburgh | Indiana | 18163 | 22625 | 406 |
1460108 | 1460108 | 2021-06-27 | Vanderburgh | Indiana | 18163 | 22594 | 406 |
1456863 | 1456863 | 2021-06-26 | Vanderburgh | Indiana | 18163 | 22594 | 406 |
1453618 | 1453618 | 2021-06-25 | Vanderburgh | Indiana | 18163 | 22594 | 406 |
1450372 | 1450372 | 2021-06-24 | Vanderburgh | Indiana | 18163 | 22585 | 406 |
1447127 | 1447127 | 2021-06-23 | Vanderburgh | Indiana | 18163 | 22575 | 406 |
1443882 | 1443882 | 2021-06-22 | Vanderburgh | Indiana | 18163 | 22569 | 406 |
1440637 | 1440637 | 2021-06-21 | Vanderburgh | Indiana | 18163 | 22568 | 405 |
1437390 | 1437390 | 2021-06-20 | Vanderburgh | Indiana | 18163 | 22565 | 405 |
1434143 | 1434143 | 2021-06-19 | Vanderburgh | Indiana | 18163 | 22565 | 405 |
1430897 | 1430897 | 2021-06-18 | Vanderburgh | Indiana | 18163 | 22564 | 405 |
1427652 | 1427652 | 2021-06-17 | Vanderburgh | Indiana | 18163 | 22558 | 405 |
1424407 | 1424407 | 2021-06-16 | Vanderburgh | Indiana | 18163 | 22555 | 405 |
1421159 | 1421159 | 2021-06-15 | Vanderburgh | Indiana | 18163 | 22553 | 405 |
1417914 | 1417914 | 2021-06-14 | Vanderburgh | Indiana | 18163 | 22551 | 405 |
1414668 | 1414668 | 2021-06-13 | Vanderburgh | Indiana | 18163 | 22549 | 405 |
1411423 | 1411423 | 2021-06-12 | Vanderburgh | Indiana | 18163 | 22549 | 405 |
1408178 | 1408178 | 2021-06-11 | Vanderburgh | Indiana | 18163 | 22544 | 403 |
1404932 | 1404932 | 2021-06-10 | Vanderburgh | Indiana | 18163 | 22539 | 403 |
1401687 | 1401687 | 2021-06-09 | Vanderburgh | Indiana | 18163 | 22536 | 403 |
1398442 | 1398442 | 2021-06-08 | Vanderburgh | Indiana | 18163 | 22532 | 403 |
1395195 | 1395195 | 2021-06-07 | Vanderburgh | Indiana | 18163 | 22524 | 403 |
1391950 | 1391950 | 2021-06-06 | Vanderburgh | Indiana | 18163 | 22517 | 403 |
1388705 | 1388705 | 2021-06-05 | Vanderburgh | Indiana | 18163 | 22517 | 403 |
1385460 | 1385460 | 2021-06-04 | Vanderburgh | Indiana | 18163 | 22508 | 403 |
1382214 | 1382214 | 2021-06-03 | Vanderburgh | Indiana | 18163 | 22500 | 403 |
1378969 | 1378969 | 2021-06-02 | Vanderburgh | Indiana | 18163 | 22494 | 403 |
1375723 | 1375723 | 2021-06-01 | Vanderburgh | Indiana | 18163 | 22491 | 403 |
1372478 | 1372478 | 2021-05-31 | Vanderburgh | Indiana | 18163 | 22485 | 403 |
1369233 | 1369233 | 2021-05-30 | Vanderburgh | Indiana | 18163 | 22485 | 403 |
1365987 | 1365987 | 2021-05-29 | Vanderburgh | Indiana | 18163 | 22481 | 403 |
1362741 | 1362741 | 2021-05-28 | Vanderburgh | Indiana | 18163 | 22473 | 403 |
1359494 | 1359494 | 2021-05-27 | Vanderburgh | Indiana | 18163 | 22467 | 403 |
1356248 | 1356248 | 2021-05-26 | Vanderburgh | Indiana | 18163 | 22459 | 402 |
1353002 | 1353002 | 2021-05-25 | Vanderburgh | Indiana | 18163 | 22453 | 402 |
1349756 | 1349756 | 2021-05-24 | Vanderburgh | Indiana | 18163 | 22468 | 402 |
1346509 | 1346509 | 2021-05-23 | Vanderburgh | Indiana | 18163 | 22466 | 402 |
1343261 | 1343261 | 2021-05-22 | Vanderburgh | Indiana | 18163 | 22460 | 402 |
1340013 | 1340013 | 2021-05-21 | Vanderburgh | Indiana | 18163 | 22449 | 402 |
1336766 | 1336766 | 2021-05-20 | Vanderburgh | Indiana | 18163 | 22412 | 402 |
1333519 | 1333519 | 2021-05-19 | Vanderburgh | Indiana | 18163 | 22396 | 402 |
1330272 | 1330272 | 2021-05-18 | Vanderburgh | Indiana | 18163 | 22385 | 402 |
1327025 | 1327025 | 2021-05-17 | Vanderburgh | Indiana | 18163 | 22376 | 402 |
1323779 | 1323779 | 2021-05-16 | Vanderburgh | Indiana | 18163 | 22376 | 402 |
1320533 | 1320533 | 2021-05-15 | Vanderburgh | Indiana | 18163 | 22368 | 402 |
1317286 | 1317286 | 2021-05-14 | Vanderburgh | Indiana | 18163 | 22351 | 402 |
1314039 | 1314039 | 2021-05-13 | Vanderburgh | Indiana | 18163 | 22341 | 402 |
1310792 | 1310792 | 2021-05-12 | Vanderburgh | Indiana | 18163 | 22327 | 402 |
1307546 | 1307546 | 2021-05-11 | Vanderburgh | Indiana | 18163 | 22319 | 402 |
1304300 | 1304300 | 2021-05-10 | Vanderburgh | Indiana | 18163 | 22312 | 402 |
1301053 | 1301053 | 2021-05-09 | Vanderburgh | Indiana | 18163 | 22309 | 402 |
1297806 | 1297806 | 2021-05-08 | Vanderburgh | Indiana | 18163 | 22302 | 401 |
1294560 | 1294560 | 2021-05-07 | Vanderburgh | Indiana | 18163 | 22293 | 401 |
1291314 | 1291314 | 2021-05-06 | Vanderburgh | Indiana | 18163 | 22280 | 401 |
1288068 | 1288068 | 2021-05-05 | Vanderburgh | Indiana | 18163 | 22261 | 401 |
1284822 | 1284822 | 2021-05-04 | Vanderburgh | Indiana | 18163 | 22240 | 401 |
1281575 | 1281575 | 2021-05-03 | Vanderburgh | Indiana | 18163 | 22234 | 400 |
1278328 | 1278328 | 2021-05-02 | Vanderburgh | Indiana | 18163 | 22230 | 400 |
1275081 | 1275081 | 2021-05-01 | Vanderburgh | Indiana | 18163 | 22220 | 400 |
1271834 | 1271834 | 2021-04-30 | Vanderburgh | Indiana | 18163 | 22203 | 400 |
1268587 | 1268587 | 2021-04-29 | Vanderburgh | Indiana | 18163 | 22187 | 400 |
1265340 | 1265340 | 2021-04-28 | Vanderburgh | Indiana | 18163 | 22179 | 400 |
1262093 | 1262093 | 2021-04-27 | Vanderburgh | Indiana | 18163 | 22169 | 399 |
1258846 | 1258846 | 2021-04-26 | Vanderburgh | Indiana | 18163 | 22164 | 399 |
1255599 | 1255599 | 2021-04-25 | Vanderburgh | Indiana | 18163 | 22155 | 399 |
1252352 | 1252352 | 2021-04-24 | Vanderburgh | Indiana | 18163 | 22149 | 399 |
1249105 | 1249105 | 2021-04-23 | Vanderburgh | Indiana | 18163 | 22134 | 399 |
1245858 | 1245858 | 2021-04-22 | Vanderburgh | Indiana | 18163 | 22118 | 399 |
1242611 | 1242611 | 2021-04-21 | Vanderburgh | Indiana | 18163 | 22108 | 399 |
1239364 | 1239364 | 2021-04-20 | Vanderburgh | Indiana | 18163 | 22100 | 399 |
1236117 | 1236117 | 2021-04-19 | Vanderburgh | Indiana | 18163 | 22090 | 399 |
1232870 | 1232870 | 2021-04-18 | Vanderburgh | Indiana | 18163 | 22086 | 399 |
1229621 | 1229621 | 2021-04-17 | Vanderburgh | Indiana | 18163 | 22069 | 399 |
1226373 | 1226373 | 2021-04-16 | Vanderburgh | Indiana | 18163 | 22059 | 399 |
1223126 | 1223126 | 2021-04-15 | Vanderburgh | Indiana | 18163 | 22043 | 398 |
1219878 | 1219878 | 2021-04-14 | Vanderburgh | Indiana | 18163 | 22025 | 398 |
1216630 | 1216630 | 2021-04-13 | Vanderburgh | Indiana | 18163 | 21996 | 398 |
1213383 | 1213383 | 2021-04-12 | Vanderburgh | Indiana | 18163 | 21969 | 398 |
1210135 | 1210135 | 2021-04-11 | Vanderburgh | Indiana | 18163 | 21957 | 398 |
1206886 | 1206886 | 2021-04-10 | Vanderburgh | Indiana | 18163 | 21940 | 398 |
1203638 | 1203638 | 2021-04-09 | Vanderburgh | Indiana | 18163 | 21929 | 398 |
1200390 | 1200390 | 2021-04-08 | Vanderburgh | Indiana | 18163 | 21908 | 398 |
1197141 | 1197141 | 2021-04-07 | Vanderburgh | Indiana | 18163 | 21886 | 398 |
1193893 | 1193893 | 2021-04-06 | Vanderburgh | Indiana | 18163 | 21856 | 397 |
1190643 | 1190643 | 2021-04-05 | Vanderburgh | Indiana | 18163 | 21845 | 396 |
1187396 | 1187396 | 2021-04-04 | Vanderburgh | Indiana | 18163 | 21841 | 396 |
1184149 | 1184149 | 2021-04-03 | Vanderburgh | Indiana | 18163 | 21823 | 396 |
1180902 | 1180902 | 2021-04-02 | Vanderburgh | Indiana | 18163 | 21805 | 396 |
1177655 | 1177655 | 2021-04-01 | Vanderburgh | Indiana | 18163 | 21785 | 395 |
1174408 | 1174408 | 2021-03-31 | Vanderburgh | Indiana | 18163 | 21762 | 395 |
1171161 | 1171161 | 2021-03-30 | Vanderburgh | Indiana | 18163 | 21738 | 395 |
1167913 | 1167913 | 2021-03-29 | Vanderburgh | Indiana | 18163 | 21719 | 394 |
1164665 | 1164665 | 2021-03-28 | Vanderburgh | Indiana | 18163 | 21709 | 394 |
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);