ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where county = "Scott" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417814 | 1417814 | 2021-06-14 | Scott | Illinois | 17171 | 488 | 1 |
1414568 | 1414568 | 2021-06-13 | Scott | Illinois | 17171 | 488 | 1 |
1411323 | 1411323 | 2021-06-12 | Scott | Illinois | 17171 | 488 | 1 |
1408078 | 1408078 | 2021-06-11 | Scott | Illinois | 17171 | 488 | 1 |
1404832 | 1404832 | 2021-06-10 | Scott | Illinois | 17171 | 488 | 1 |
1401587 | 1401587 | 2021-06-09 | Scott | Illinois | 17171 | 488 | 1 |
1398342 | 1398342 | 2021-06-08 | Scott | Illinois | 17171 | 488 | 1 |
1395095 | 1395095 | 2021-06-07 | Scott | Illinois | 17171 | 488 | 1 |
1391850 | 1391850 | 2021-06-06 | Scott | Illinois | 17171 | 488 | 1 |
1388605 | 1388605 | 2021-06-05 | Scott | Illinois | 17171 | 488 | 1 |
1385360 | 1385360 | 2021-06-04 | Scott | Illinois | 17171 | 488 | 1 |
1382114 | 1382114 | 2021-06-03 | Scott | Illinois | 17171 | 487 | 1 |
1378869 | 1378869 | 2021-06-02 | Scott | Illinois | 17171 | 486 | 1 |
1375623 | 1375623 | 2021-06-01 | Scott | Illinois | 17171 | 486 | 1 |
1372378 | 1372378 | 2021-05-31 | Scott | Illinois | 17171 | 485 | 1 |
1369133 | 1369133 | 2021-05-30 | Scott | Illinois | 17171 | 485 | 1 |
1365887 | 1365887 | 2021-05-29 | Scott | Illinois | 17171 | 485 | 1 |
1362641 | 1362641 | 2021-05-28 | Scott | Illinois | 17171 | 484 | 1 |
1359394 | 1359394 | 2021-05-27 | Scott | Illinois | 17171 | 484 | 1 |
1356148 | 1356148 | 2021-05-26 | Scott | Illinois | 17171 | 483 | 1 |
1352902 | 1352902 | 2021-05-25 | Scott | Illinois | 17171 | 483 | 1 |
1349656 | 1349656 | 2021-05-24 | Scott | Illinois | 17171 | 480 | 1 |
1346409 | 1346409 | 2021-05-23 | Scott | Illinois | 17171 | 480 | 1 |
1343161 | 1343161 | 2021-05-22 | Scott | Illinois | 17171 | 480 | 1 |
1339913 | 1339913 | 2021-05-21 | Scott | Illinois | 17171 | 480 | 1 |
1336666 | 1336666 | 2021-05-20 | Scott | Illinois | 17171 | 479 | 1 |
1333419 | 1333419 | 2021-05-19 | Scott | Illinois | 17171 | 479 | 1 |
1330172 | 1330172 | 2021-05-18 | Scott | Illinois | 17171 | 479 | 1 |
1326925 | 1326925 | 2021-05-17 | Scott | Illinois | 17171 | 479 | 1 |
1323679 | 1323679 | 2021-05-16 | Scott | Illinois | 17171 | 479 | 1 |
1320433 | 1320433 | 2021-05-15 | Scott | Illinois | 17171 | 479 | 1 |
1317186 | 1317186 | 2021-05-14 | Scott | Illinois | 17171 | 479 | 1 |
1313939 | 1313939 | 2021-05-13 | Scott | Illinois | 17171 | 478 | 1 |
1310692 | 1310692 | 2021-05-12 | Scott | Illinois | 17171 | 478 | 1 |
1307446 | 1307446 | 2021-05-11 | Scott | Illinois | 17171 | 477 | 1 |
1304200 | 1304200 | 2021-05-10 | Scott | Illinois | 17171 | 478 | 1 |
1300953 | 1300953 | 2021-05-09 | Scott | Illinois | 17171 | 478 | 1 |
1297706 | 1297706 | 2021-05-08 | Scott | Illinois | 17171 | 478 | 1 |
1294460 | 1294460 | 2021-05-07 | Scott | Illinois | 17171 | 478 | 1 |
1291214 | 1291214 | 2021-05-06 | Scott | Illinois | 17171 | 478 | 1 |
1287968 | 1287968 | 2021-05-05 | Scott | Illinois | 17171 | 477 | 1 |
1284722 | 1284722 | 2021-05-04 | Scott | Illinois | 17171 | 476 | 1 |
1281475 | 1281475 | 2021-05-03 | Scott | Illinois | 17171 | 477 | 1 |
1278228 | 1278228 | 2021-05-02 | Scott | Illinois | 17171 | 476 | 1 |
1274981 | 1274981 | 2021-05-01 | Scott | Illinois | 17171 | 476 | 1 |
1271734 | 1271734 | 2021-04-30 | Scott | Illinois | 17171 | 476 | 1 |
1268487 | 1268487 | 2021-04-29 | Scott | Illinois | 17171 | 474 | 1 |
1265240 | 1265240 | 2021-04-28 | Scott | Illinois | 17171 | 475 | 1 |
1261993 | 1261993 | 2021-04-27 | Scott | Illinois | 17171 | 473 | 1 |
1258746 | 1258746 | 2021-04-26 | Scott | Illinois | 17171 | 472 | 1 |
1255499 | 1255499 | 2021-04-25 | Scott | Illinois | 17171 | 471 | 1 |
1252252 | 1252252 | 2021-04-24 | Scott | Illinois | 17171 | 471 | 1 |
1249005 | 1249005 | 2021-04-23 | Scott | Illinois | 17171 | 469 | 1 |
1245758 | 1245758 | 2021-04-22 | Scott | Illinois | 17171 | 469 | 1 |
1242511 | 1242511 | 2021-04-21 | Scott | Illinois | 17171 | 469 | 1 |
1239264 | 1239264 | 2021-04-20 | Scott | Illinois | 17171 | 469 | 1 |
1236017 | 1236017 | 2021-04-19 | Scott | Illinois | 17171 | 467 | 1 |
1232770 | 1232770 | 2021-04-18 | Scott | Illinois | 17171 | 467 | 1 |
1229521 | 1229521 | 2021-04-17 | Scott | Illinois | 17171 | 467 | 1 |
1226273 | 1226273 | 2021-04-16 | Scott | Illinois | 17171 | 467 | 1 |
1223026 | 1223026 | 2021-04-15 | Scott | Illinois | 17171 | 467 | 1 |
1219778 | 1219778 | 2021-04-14 | Scott | Illinois | 17171 | 467 | 1 |
1216530 | 1216530 | 2021-04-13 | Scott | Illinois | 17171 | 467 | 1 |
1213283 | 1213283 | 2021-04-12 | Scott | Illinois | 17171 | 466 | 1 |
1210035 | 1210035 | 2021-04-11 | Scott | Illinois | 17171 | 466 | 1 |
1206786 | 1206786 | 2021-04-10 | Scott | Illinois | 17171 | 466 | 1 |
1203538 | 1203538 | 2021-04-09 | Scott | Illinois | 17171 | 465 | 1 |
1200290 | 1200290 | 2021-04-08 | Scott | Illinois | 17171 | 465 | 1 |
1197041 | 1197041 | 2021-04-07 | Scott | Illinois | 17171 | 462 | 1 |
1193793 | 1193793 | 2021-04-06 | Scott | Illinois | 17171 | 461 | 1 |
1190543 | 1190543 | 2021-04-05 | Scott | Illinois | 17171 | 459 | 1 |
1187296 | 1187296 | 2021-04-04 | Scott | Illinois | 17171 | 459 | 1 |
1184049 | 1184049 | 2021-04-03 | Scott | Illinois | 17171 | 460 | 1 |
1180802 | 1180802 | 2021-04-02 | Scott | Illinois | 17171 | 459 | 1 |
1177555 | 1177555 | 2021-04-01 | Scott | Illinois | 17171 | 457 | 1 |
1174308 | 1174308 | 2021-03-31 | Scott | Illinois | 17171 | 456 | 1 |
1171061 | 1171061 | 2021-03-30 | Scott | Illinois | 17171 | 456 | 1 |
1167813 | 1167813 | 2021-03-29 | Scott | Illinois | 17171 | 456 | 1 |
1164565 | 1164565 | 2021-03-28 | Scott | Illinois | 17171 | 456 | 1 |
1161317 | 1161317 | 2021-03-27 | Scott | Illinois | 17171 | 456 | 1 |
1158069 | 1158069 | 2021-03-26 | Scott | Illinois | 17171 | 457 | 1 |
1154822 | 1154822 | 2021-03-25 | Scott | Illinois | 17171 | 456 | 1 |
1151575 | 1151575 | 2021-03-24 | Scott | Illinois | 17171 | 454 | 1 |
1148328 | 1148328 | 2021-03-23 | Scott | Illinois | 17171 | 453 | 1 |
1145081 | 1145081 | 2021-03-22 | Scott | Illinois | 17171 | 453 | 1 |
1141834 | 1141834 | 2021-03-21 | Scott | Illinois | 17171 | 452 | 1 |
1138588 | 1138588 | 2021-03-20 | Scott | Illinois | 17171 | 452 | 1 |
1135342 | 1135342 | 2021-03-19 | Scott | Illinois | 17171 | 452 | 1 |
1132095 | 1132095 | 2021-03-18 | Scott | Illinois | 17171 | 451 | 1 |
1128847 | 1128847 | 2021-03-17 | Scott | Illinois | 17171 | 451 | 1 |
1125601 | 1125601 | 2021-03-16 | Scott | Illinois | 17171 | 451 | 1 |
1122355 | 1122355 | 2021-03-15 | Scott | Illinois | 17171 | 451 | 1 |
1119108 | 1119108 | 2021-03-14 | Scott | Illinois | 17171 | 451 | 1 |
1115861 | 1115861 | 2021-03-13 | Scott | Illinois | 17171 | 451 | 1 |
1112615 | 1112615 | 2021-03-12 | Scott | Illinois | 17171 | 451 | 1 |
1109369 | 1109369 | 2021-03-11 | Scott | Illinois | 17171 | 451 | 1 |
1106123 | 1106123 | 2021-03-10 | Scott | Illinois | 17171 | 451 | 1 |
1102877 | 1102877 | 2021-03-09 | Scott | Illinois | 17171 | 451 | 1 |
1099631 | 1099631 | 2021-03-08 | Scott | Illinois | 17171 | 449 | 1 |
1096383 | 1096383 | 2021-03-07 | Scott | Illinois | 17171 | 449 | 1 |
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);