ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
220 rows where county = "Crawford" and deaths = 19 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Crawford · 220 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
786413 | 786413 | 2020-12-01 | Crawford | Pennsylvania | 42039 | 2007 | 19 |
811005 | 811005 | 2020-12-09 | Crawford | Kansas | 20037 | 2756 | 19 |
814250 | 814250 | 2020-12-10 | Crawford | Kansas | 20037 | 2756 | 19 |
857056 | 857056 | 2020-12-23 | Crawford | Missouri | 29055 | 1561 | 19 |
860301 | 860301 | 2020-12-24 | Crawford | Missouri | 29055 | 1588 | 19 |
863546 | 863546 | 2020-12-25 | Crawford | Missouri | 29055 | 1608 | 19 |
866791 | 866791 | 2020-12-26 | Crawford | Missouri | 29055 | 1629 | 19 |
870036 | 870036 | 2020-12-27 | Crawford | Missouri | 29055 | 1637 | 19 |
873281 | 873281 | 2020-12-28 | Crawford | Missouri | 29055 | 1648 | 19 |
876526 | 876526 | 2020-12-29 | Crawford | Missouri | 29055 | 1666 | 19 |
879771 | 879771 | 2020-12-30 | Crawford | Missouri | 29055 | 1680 | 19 |
883016 | 883016 | 2020-12-31 | Crawford | Missouri | 29055 | 1706 | 19 |
886261 | 886261 | 2021-01-01 | Crawford | Missouri | 29055 | 1731 | 19 |
889507 | 889507 | 2021-01-02 | Crawford | Missouri | 29055 | 1741 | 19 |
892753 | 892753 | 2021-01-03 | Crawford | Missouri | 29055 | 1765 | 19 |
896000 | 896000 | 2021-01-04 | Crawford | Missouri | 29055 | 1765 | 19 |
1180546 | 1180546 | 2021-04-02 | Crawford | Georgia | 13079 | 654 | 19 |
1183793 | 1183793 | 2021-04-03 | Crawford | Georgia | 13079 | 654 | 19 |
1187040 | 1187040 | 2021-04-04 | Crawford | Georgia | 13079 | 654 | 19 |
1190287 | 1190287 | 2021-04-05 | Crawford | Georgia | 13079 | 654 | 19 |
1193537 | 1193537 | 2021-04-06 | Crawford | Georgia | 13079 | 653 | 19 |
1196785 | 1196785 | 2021-04-07 | Crawford | Georgia | 13079 | 653 | 19 |
1200034 | 1200034 | 2021-04-08 | Crawford | Georgia | 13079 | 654 | 19 |
1203282 | 1203282 | 2021-04-09 | Crawford | Georgia | 13079 | 655 | 19 |
1206530 | 1206530 | 2021-04-10 | Crawford | Georgia | 13079 | 655 | 19 |
1209779 | 1209779 | 2021-04-11 | Crawford | Georgia | 13079 | 655 | 19 |
1213027 | 1213027 | 2021-04-12 | Crawford | Georgia | 13079 | 655 | 19 |
1216274 | 1216274 | 2021-04-13 | Crawford | Georgia | 13079 | 655 | 19 |
1219522 | 1219522 | 2021-04-14 | Crawford | Georgia | 13079 | 655 | 19 |
1222770 | 1222770 | 2021-04-15 | Crawford | Georgia | 13079 | 655 | 19 |
1226017 | 1226017 | 2021-04-16 | Crawford | Georgia | 13079 | 654 | 19 |
1229265 | 1229265 | 2021-04-17 | Crawford | Georgia | 13079 | 654 | 19 |
1232514 | 1232514 | 2021-04-18 | Crawford | Georgia | 13079 | 654 | 19 |
1235761 | 1235761 | 2021-04-19 | Crawford | Georgia | 13079 | 655 | 19 |
1239008 | 1239008 | 2021-04-20 | Crawford | Georgia | 13079 | 655 | 19 |
1242255 | 1242255 | 2021-04-21 | Crawford | Georgia | 13079 | 655 | 19 |
1245502 | 1245502 | 2021-04-22 | Crawford | Georgia | 13079 | 657 | 19 |
1248749 | 1248749 | 2021-04-23 | Crawford | Georgia | 13079 | 657 | 19 |
1251996 | 1251996 | 2021-04-24 | Crawford | Georgia | 13079 | 658 | 19 |
1255243 | 1255243 | 2021-04-25 | Crawford | Georgia | 13079 | 658 | 19 |
1258490 | 1258490 | 2021-04-26 | Crawford | Georgia | 13079 | 659 | 19 |
1261737 | 1261737 | 2021-04-27 | Crawford | Georgia | 13079 | 659 | 19 |
1264984 | 1264984 | 2021-04-28 | Crawford | Georgia | 13079 | 658 | 19 |
1268231 | 1268231 | 2021-04-29 | Crawford | Georgia | 13079 | 658 | 19 |
1271478 | 1271478 | 2021-04-30 | Crawford | Georgia | 13079 | 661 | 19 |
1274725 | 1274725 | 2021-05-01 | Crawford | Georgia | 13079 | 662 | 19 |
1277972 | 1277972 | 2021-05-02 | Crawford | Georgia | 13079 | 662 | 19 |
1281219 | 1281219 | 2021-05-03 | Crawford | Georgia | 13079 | 663 | 19 |
1284466 | 1284466 | 2021-05-04 | Crawford | Georgia | 13079 | 663 | 19 |
1287712 | 1287712 | 2021-05-05 | Crawford | Georgia | 13079 | 662 | 19 |
1290958 | 1290958 | 2021-05-06 | Crawford | Georgia | 13079 | 663 | 19 |
1294204 | 1294204 | 2021-05-07 | Crawford | Georgia | 13079 | 663 | 19 |
1297450 | 1297450 | 2021-05-08 | Crawford | Georgia | 13079 | 663 | 19 |
1300697 | 1300697 | 2021-05-09 | Crawford | Georgia | 13079 | 663 | 19 |
1303944 | 1303944 | 2021-05-10 | Crawford | Georgia | 13079 | 663 | 19 |
1307190 | 1307190 | 2021-05-11 | Crawford | Georgia | 13079 | 661 | 19 |
1310436 | 1310436 | 2021-05-12 | Crawford | Georgia | 13079 | 660 | 19 |
1313683 | 1313683 | 2021-05-13 | Crawford | Georgia | 13079 | 659 | 19 |
1316930 | 1316930 | 2021-05-14 | Crawford | Georgia | 13079 | 659 | 19 |
1320177 | 1320177 | 2021-05-15 | Crawford | Georgia | 13079 | 658 | 19 |
1323423 | 1323423 | 2021-05-16 | Crawford | Georgia | 13079 | 658 | 19 |
1326669 | 1326669 | 2021-05-17 | Crawford | Georgia | 13079 | 658 | 19 |
1329916 | 1329916 | 2021-05-18 | Crawford | Georgia | 13079 | 656 | 19 |
1333163 | 1333163 | 2021-05-19 | Crawford | Georgia | 13079 | 655 | 19 |
1335897 | 1335897 | 2021-05-19 | Crawford | Wisconsin | 55023 | 1787 | 19 |
1336410 | 1336410 | 2021-05-20 | Crawford | Georgia | 13079 | 654 | 19 |
1339144 | 1339144 | 2021-05-20 | Crawford | Wisconsin | 55023 | 1787 | 19 |
1339657 | 1339657 | 2021-05-21 | Crawford | Georgia | 13079 | 656 | 19 |
1342392 | 1342392 | 2021-05-21 | Crawford | Wisconsin | 55023 | 1789 | 19 |
1342905 | 1342905 | 2021-05-22 | Crawford | Georgia | 13079 | 655 | 19 |
1345640 | 1345640 | 2021-05-22 | Crawford | Wisconsin | 55023 | 1792 | 19 |
1346153 | 1346153 | 2021-05-23 | Crawford | Georgia | 13079 | 655 | 19 |
1348888 | 1348888 | 2021-05-23 | Crawford | Wisconsin | 55023 | 1792 | 19 |
1349400 | 1349400 | 2021-05-24 | Crawford | Georgia | 13079 | 655 | 19 |
1352134 | 1352134 | 2021-05-24 | Crawford | Wisconsin | 55023 | 1792 | 19 |
1352646 | 1352646 | 2021-05-25 | Crawford | Georgia | 13079 | 655 | 19 |
1355380 | 1355380 | 2021-05-25 | Crawford | Wisconsin | 55023 | 1793 | 19 |
1358626 | 1358626 | 2021-05-26 | Crawford | Wisconsin | 55023 | 1793 | 19 |
1361872 | 1361872 | 2021-05-27 | Crawford | Wisconsin | 55023 | 1793 | 19 |
1365118 | 1365118 | 2021-05-28 | Crawford | Wisconsin | 55023 | 1794 | 19 |
1368364 | 1368364 | 2021-05-29 | Crawford | Wisconsin | 55023 | 1794 | 19 |
1371610 | 1371610 | 2021-05-30 | Crawford | Wisconsin | 55023 | 1794 | 19 |
1374855 | 1374855 | 2021-05-31 | Crawford | Wisconsin | 55023 | 1795 | 19 |
1378101 | 1378101 | 2021-06-01 | Crawford | Wisconsin | 55023 | 1794 | 19 |
1381346 | 1381346 | 2021-06-02 | Crawford | Wisconsin | 55023 | 1795 | 19 |
1384592 | 1384592 | 2021-06-03 | Crawford | Wisconsin | 55023 | 1795 | 19 |
1387837 | 1387837 | 2021-06-04 | Crawford | Wisconsin | 55023 | 1796 | 19 |
1391082 | 1391082 | 2021-06-05 | Crawford | Wisconsin | 55023 | 1796 | 19 |
1394327 | 1394327 | 2021-06-06 | Crawford | Wisconsin | 55023 | 1796 | 19 |
1397574 | 1397574 | 2021-06-07 | Crawford | Wisconsin | 55023 | 1796 | 19 |
1400819 | 1400819 | 2021-06-08 | Crawford | Wisconsin | 55023 | 1797 | 19 |
1404064 | 1404064 | 2021-06-09 | Crawford | Wisconsin | 55023 | 1797 | 19 |
1407310 | 1407310 | 2021-06-10 | Crawford | Wisconsin | 55023 | 1798 | 19 |
1410555 | 1410555 | 2021-06-11 | Crawford | Wisconsin | 55023 | 1798 | 19 |
1413800 | 1413800 | 2021-06-12 | Crawford | Wisconsin | 55023 | 1798 | 19 |
1417046 | 1417046 | 2021-06-13 | Crawford | Wisconsin | 55023 | 1798 | 19 |
1420291 | 1420291 | 2021-06-14 | Crawford | Wisconsin | 55023 | 1800 | 19 |
1423538 | 1423538 | 2021-06-15 | Crawford | Wisconsin | 55023 | 1800 | 19 |
1426784 | 1426784 | 2021-06-16 | Crawford | Wisconsin | 55023 | 1800 | 19 |
1430029 | 1430029 | 2021-06-17 | Crawford | Wisconsin | 55023 | 1800 | 19 |
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);