ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 18001 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417833 | 1417833 | 2021-06-14 | Adams | Indiana | 18001 | 3513 | 56 |
1414587 | 1414587 | 2021-06-13 | Adams | Indiana | 18001 | 3513 | 56 |
1411342 | 1411342 | 2021-06-12 | Adams | Indiana | 18001 | 3513 | 56 |
1408097 | 1408097 | 2021-06-11 | Adams | Indiana | 18001 | 3512 | 56 |
1404851 | 1404851 | 2021-06-10 | Adams | Indiana | 18001 | 3511 | 56 |
1401606 | 1401606 | 2021-06-09 | Adams | Indiana | 18001 | 3511 | 56 |
1398361 | 1398361 | 2021-06-08 | Adams | Indiana | 18001 | 3511 | 56 |
1395114 | 1395114 | 2021-06-07 | Adams | Indiana | 18001 | 3511 | 56 |
1391869 | 1391869 | 2021-06-06 | Adams | Indiana | 18001 | 3511 | 56 |
1388624 | 1388624 | 2021-06-05 | Adams | Indiana | 18001 | 3511 | 56 |
1385379 | 1385379 | 2021-06-04 | Adams | Indiana | 18001 | 3511 | 56 |
1382133 | 1382133 | 2021-06-03 | Adams | Indiana | 18001 | 3511 | 56 |
1378888 | 1378888 | 2021-06-02 | Adams | Indiana | 18001 | 3510 | 56 |
1375642 | 1375642 | 2021-06-01 | Adams | Indiana | 18001 | 3509 | 56 |
1372397 | 1372397 | 2021-05-31 | Adams | Indiana | 18001 | 3507 | 56 |
1369152 | 1369152 | 2021-05-30 | Adams | Indiana | 18001 | 3507 | 56 |
1365906 | 1365906 | 2021-05-29 | Adams | Indiana | 18001 | 3504 | 56 |
1362660 | 1362660 | 2021-05-28 | Adams | Indiana | 18001 | 3503 | 56 |
1359413 | 1359413 | 2021-05-27 | Adams | Indiana | 18001 | 3503 | 56 |
1356167 | 1356167 | 2021-05-26 | Adams | Indiana | 18001 | 3502 | 56 |
1352921 | 1352921 | 2021-05-25 | Adams | Indiana | 18001 | 3502 | 56 |
1349675 | 1349675 | 2021-05-24 | Adams | Indiana | 18001 | 3501 | 56 |
1346428 | 1346428 | 2021-05-23 | Adams | Indiana | 18001 | 3501 | 56 |
1343180 | 1343180 | 2021-05-22 | Adams | Indiana | 18001 | 3501 | 56 |
1339932 | 1339932 | 2021-05-21 | Adams | Indiana | 18001 | 3499 | 56 |
1336685 | 1336685 | 2021-05-20 | Adams | Indiana | 18001 | 3497 | 56 |
1333438 | 1333438 | 2021-05-19 | Adams | Indiana | 18001 | 3495 | 56 |
1330191 | 1330191 | 2021-05-18 | Adams | Indiana | 18001 | 3494 | 56 |
1326944 | 1326944 | 2021-05-17 | Adams | Indiana | 18001 | 3492 | 56 |
1323698 | 1323698 | 2021-05-16 | Adams | Indiana | 18001 | 3491 | 56 |
1320452 | 1320452 | 2021-05-15 | Adams | Indiana | 18001 | 3490 | 56 |
1317205 | 1317205 | 2021-05-14 | Adams | Indiana | 18001 | 3484 | 56 |
1313958 | 1313958 | 2021-05-13 | Adams | Indiana | 18001 | 3484 | 55 |
1310711 | 1310711 | 2021-05-12 | Adams | Indiana | 18001 | 3482 | 55 |
1307465 | 1307465 | 2021-05-11 | Adams | Indiana | 18001 | 3478 | 55 |
1304219 | 1304219 | 2021-05-10 | Adams | Indiana | 18001 | 3476 | 55 |
1300972 | 1300972 | 2021-05-09 | Adams | Indiana | 18001 | 3477 | 55 |
1297725 | 1297725 | 2021-05-08 | Adams | Indiana | 18001 | 3475 | 55 |
1294479 | 1294479 | 2021-05-07 | Adams | Indiana | 18001 | 3471 | 55 |
1291233 | 1291233 | 2021-05-06 | Adams | Indiana | 18001 | 3471 | 55 |
1287987 | 1287987 | 2021-05-05 | Adams | Indiana | 18001 | 3471 | 55 |
1284741 | 1284741 | 2021-05-04 | Adams | Indiana | 18001 | 3469 | 55 |
1281494 | 1281494 | 2021-05-03 | Adams | Indiana | 18001 | 3465 | 55 |
1278247 | 1278247 | 2021-05-02 | Adams | Indiana | 18001 | 3464 | 55 |
1275000 | 1275000 | 2021-05-01 | Adams | Indiana | 18001 | 3463 | 55 |
1271753 | 1271753 | 2021-04-30 | Adams | Indiana | 18001 | 3457 | 55 |
1268506 | 1268506 | 2021-04-29 | Adams | Indiana | 18001 | 3450 | 55 |
1265259 | 1265259 | 2021-04-28 | Adams | Indiana | 18001 | 3448 | 55 |
1262012 | 1262012 | 2021-04-27 | Adams | Indiana | 18001 | 3448 | 55 |
1258765 | 1258765 | 2021-04-26 | Adams | Indiana | 18001 | 3446 | 54 |
1255518 | 1255518 | 2021-04-25 | Adams | Indiana | 18001 | 3446 | 54 |
1252271 | 1252271 | 2021-04-24 | Adams | Indiana | 18001 | 3446 | 54 |
1249024 | 1249024 | 2021-04-23 | Adams | Indiana | 18001 | 3445 | 54 |
1245777 | 1245777 | 2021-04-22 | Adams | Indiana | 18001 | 3445 | 54 |
1242530 | 1242530 | 2021-04-21 | Adams | Indiana | 18001 | 3443 | 54 |
1239283 | 1239283 | 2021-04-20 | Adams | Indiana | 18001 | 3442 | 54 |
1236036 | 1236036 | 2021-04-19 | Adams | Indiana | 18001 | 3441 | 53 |
1232789 | 1232789 | 2021-04-18 | Adams | Indiana | 18001 | 3440 | 53 |
1229540 | 1229540 | 2021-04-17 | Adams | Indiana | 18001 | 3440 | 53 |
1226292 | 1226292 | 2021-04-16 | Adams | Indiana | 18001 | 3439 | 53 |
1223045 | 1223045 | 2021-04-15 | Adams | Indiana | 18001 | 3438 | 53 |
1219797 | 1219797 | 2021-04-14 | Adams | Indiana | 18001 | 3438 | 53 |
1216549 | 1216549 | 2021-04-13 | Adams | Indiana | 18001 | 3436 | 53 |
1213302 | 1213302 | 2021-04-12 | Adams | Indiana | 18001 | 3432 | 53 |
1210054 | 1210054 | 2021-04-11 | Adams | Indiana | 18001 | 3430 | 53 |
1206805 | 1206805 | 2021-04-10 | Adams | Indiana | 18001 | 3428 | 53 |
1203557 | 1203557 | 2021-04-09 | Adams | Indiana | 18001 | 3426 | 53 |
1200309 | 1200309 | 2021-04-08 | Adams | Indiana | 18001 | 3424 | 53 |
1197060 | 1197060 | 2021-04-07 | Adams | Indiana | 18001 | 3421 | 53 |
1193812 | 1193812 | 2021-04-06 | Adams | Indiana | 18001 | 3418 | 53 |
1190562 | 1190562 | 2021-04-05 | Adams | Indiana | 18001 | 3418 | 53 |
1187315 | 1187315 | 2021-04-04 | Adams | Indiana | 18001 | 3418 | 53 |
1184068 | 1184068 | 2021-04-03 | Adams | Indiana | 18001 | 3417 | 53 |
1180821 | 1180821 | 2021-04-02 | Adams | Indiana | 18001 | 3413 | 53 |
1177574 | 1177574 | 2021-04-01 | Adams | Indiana | 18001 | 3400 | 52 |
1174327 | 1174327 | 2021-03-31 | Adams | Indiana | 18001 | 3399 | 52 |
1171080 | 1171080 | 2021-03-30 | Adams | Indiana | 18001 | 3394 | 52 |
1167832 | 1167832 | 2021-03-29 | Adams | Indiana | 18001 | 3386 | 52 |
1164584 | 1164584 | 2021-03-28 | Adams | Indiana | 18001 | 3384 | 52 |
1161336 | 1161336 | 2021-03-27 | Adams | Indiana | 18001 | 3382 | 52 |
1158088 | 1158088 | 2021-03-26 | Adams | Indiana | 18001 | 3379 | 52 |
1154841 | 1154841 | 2021-03-25 | Adams | Indiana | 18001 | 3376 | 52 |
1151594 | 1151594 | 2021-03-24 | Adams | Indiana | 18001 | 3374 | 52 |
1148347 | 1148347 | 2021-03-23 | Adams | Indiana | 18001 | 3374 | 52 |
1145100 | 1145100 | 2021-03-22 | Adams | Indiana | 18001 | 3371 | 52 |
1141853 | 1141853 | 2021-03-21 | Adams | Indiana | 18001 | 3367 | 52 |
1138607 | 1138607 | 2021-03-20 | Adams | Indiana | 18001 | 3364 | 52 |
1135361 | 1135361 | 2021-03-19 | Adams | Indiana | 18001 | 3363 | 52 |
1132114 | 1132114 | 2021-03-18 | Adams | Indiana | 18001 | 3361 | 51 |
1128866 | 1128866 | 2021-03-17 | Adams | Indiana | 18001 | 3360 | 51 |
1125620 | 1125620 | 2021-03-16 | Adams | Indiana | 18001 | 3356 | 51 |
1122374 | 1122374 | 2021-03-15 | Adams | Indiana | 18001 | 3355 | 51 |
1119127 | 1119127 | 2021-03-14 | Adams | Indiana | 18001 | 3354 | 51 |
1115880 | 1115880 | 2021-03-13 | Adams | Indiana | 18001 | 3351 | 51 |
1112634 | 1112634 | 2021-03-12 | Adams | Indiana | 18001 | 3349 | 51 |
1109388 | 1109388 | 2021-03-11 | Adams | Indiana | 18001 | 3349 | 51 |
1106142 | 1106142 | 2021-03-10 | Adams | Indiana | 18001 | 3346 | 51 |
1102896 | 1102896 | 2021-03-09 | Adams | Indiana | 18001 | 3327 | 51 |
1099650 | 1099650 | 2021-03-08 | Adams | Indiana | 18001 | 3305 | 50 |
1096402 | 1096402 | 2021-03-07 | Adams | Indiana | 18001 | 3298 | 50 |
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);