ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where county = "Crawford" and deaths = 40 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Crawford · 77 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1346543 | 1346543 | 2021-05-23 | Crawford | Iowa | 19047 | 2670 | 40 |
1343295 | 1343295 | 2021-05-22 | Crawford | Iowa | 19047 | 2671 | 40 |
1340047 | 1340047 | 2021-05-21 | Crawford | Iowa | 19047 | 2670 | 40 |
1336800 | 1336800 | 2021-05-20 | Crawford | Iowa | 19047 | 2669 | 40 |
1333553 | 1333553 | 2021-05-19 | Crawford | Iowa | 19047 | 2670 | 40 |
1330306 | 1330306 | 2021-05-18 | Crawford | Iowa | 19047 | 2665 | 40 |
1327059 | 1327059 | 2021-05-17 | Crawford | Iowa | 19047 | 2665 | 40 |
1323813 | 1323813 | 2021-05-16 | Crawford | Iowa | 19047 | 2664 | 40 |
1320567 | 1320567 | 2021-05-15 | Crawford | Iowa | 19047 | 2664 | 40 |
1317320 | 1317320 | 2021-05-14 | Crawford | Iowa | 19047 | 2664 | 40 |
1314073 | 1314073 | 2021-05-13 | Crawford | Iowa | 19047 | 2663 | 40 |
1310826 | 1310826 | 2021-05-12 | Crawford | Iowa | 19047 | 2663 | 40 |
1307580 | 1307580 | 2021-05-11 | Crawford | Iowa | 19047 | 2663 | 40 |
1304334 | 1304334 | 2021-05-10 | Crawford | Iowa | 19047 | 2661 | 40 |
1301087 | 1301087 | 2021-05-09 | Crawford | Iowa | 19047 | 2660 | 40 |
1297840 | 1297840 | 2021-05-08 | Crawford | Iowa | 19047 | 2659 | 40 |
1294594 | 1294594 | 2021-05-07 | Crawford | Iowa | 19047 | 2660 | 40 |
1291348 | 1291348 | 2021-05-06 | Crawford | Iowa | 19047 | 2648 | 40 |
1288102 | 1288102 | 2021-05-05 | Crawford | Iowa | 19047 | 2643 | 40 |
1284856 | 1284856 | 2021-05-04 | Crawford | Iowa | 19047 | 2640 | 40 |
1281609 | 1281609 | 2021-05-03 | Crawford | Iowa | 19047 | 2641 | 40 |
1278362 | 1278362 | 2021-05-02 | Crawford | Iowa | 19047 | 2638 | 40 |
1275115 | 1275115 | 2021-05-01 | Crawford | Iowa | 19047 | 2640 | 40 |
1271868 | 1271868 | 2021-04-30 | Crawford | Iowa | 19047 | 2635 | 40 |
1268621 | 1268621 | 2021-04-29 | Crawford | Iowa | 19047 | 2637 | 40 |
1265374 | 1265374 | 2021-04-28 | Crawford | Iowa | 19047 | 2631 | 40 |
1262127 | 1262127 | 2021-04-27 | Crawford | Iowa | 19047 | 2631 | 40 |
1258880 | 1258880 | 2021-04-26 | Crawford | Iowa | 19047 | 2631 | 40 |
1255633 | 1255633 | 2021-04-25 | Crawford | Iowa | 19047 | 2628 | 40 |
1252386 | 1252386 | 2021-04-24 | Crawford | Iowa | 19047 | 2629 | 40 |
1249139 | 1249139 | 2021-04-23 | Crawford | Iowa | 19047 | 2627 | 40 |
1245892 | 1245892 | 2021-04-22 | Crawford | Iowa | 19047 | 2629 | 40 |
1242645 | 1242645 | 2021-04-21 | Crawford | Iowa | 19047 | 2627 | 40 |
1239398 | 1239398 | 2021-04-20 | Crawford | Iowa | 19047 | 2625 | 40 |
1236151 | 1236151 | 2021-04-19 | Crawford | Iowa | 19047 | 2621 | 40 |
1232904 | 1232904 | 2021-04-18 | Crawford | Iowa | 19047 | 2621 | 40 |
1229655 | 1229655 | 2021-04-17 | Crawford | Iowa | 19047 | 2621 | 40 |
1226407 | 1226407 | 2021-04-16 | Crawford | Iowa | 19047 | 2622 | 40 |
1200222 | 1200222 | 2021-04-08 | Crawford | Illinois | 17033 | 2076 | 40 |
1196973 | 1196973 | 2021-04-07 | Crawford | Illinois | 17033 | 2075 | 40 |
1193725 | 1193725 | 2021-04-06 | Crawford | Illinois | 17033 | 2074 | 40 |
1190475 | 1190475 | 2021-04-05 | Crawford | Illinois | 17033 | 2071 | 40 |
1187228 | 1187228 | 2021-04-04 | Crawford | Illinois | 17033 | 2070 | 40 |
1183981 | 1183981 | 2021-04-03 | Crawford | Illinois | 17033 | 2069 | 40 |
1180734 | 1180734 | 2021-04-02 | Crawford | Illinois | 17033 | 2067 | 40 |
1177487 | 1177487 | 2021-04-01 | Crawford | Illinois | 17033 | 2064 | 40 |
1174240 | 1174240 | 2021-03-31 | Crawford | Illinois | 17033 | 2063 | 40 |
1170993 | 1170993 | 2021-03-30 | Crawford | Illinois | 17033 | 2056 | 40 |
1167745 | 1167745 | 2021-03-29 | Crawford | Illinois | 17033 | 2053 | 40 |
1164497 | 1164497 | 2021-03-28 | Crawford | Illinois | 17033 | 2052 | 40 |
1161249 | 1161249 | 2021-03-27 | Crawford | Illinois | 17033 | 2051 | 40 |
1158001 | 1158001 | 2021-03-26 | Crawford | Illinois | 17033 | 2047 | 40 |
1154754 | 1154754 | 2021-03-25 | Crawford | Illinois | 17033 | 2043 | 40 |
1151507 | 1151507 | 2021-03-24 | Crawford | Illinois | 17033 | 2037 | 40 |
1148260 | 1148260 | 2021-03-23 | Crawford | Illinois | 17033 | 2033 | 40 |
1145013 | 1145013 | 2021-03-22 | Crawford | Illinois | 17033 | 2029 | 40 |
1141766 | 1141766 | 2021-03-21 | Crawford | Illinois | 17033 | 2029 | 40 |
1138520 | 1138520 | 2021-03-20 | Crawford | Illinois | 17033 | 2028 | 40 |
1135274 | 1135274 | 2021-03-19 | Crawford | Illinois | 17033 | 2026 | 40 |
1132027 | 1132027 | 2021-03-18 | Crawford | Illinois | 17033 | 2026 | 40 |
1128779 | 1128779 | 2021-03-17 | Crawford | Illinois | 17033 | 2021 | 40 |
1125533 | 1125533 | 2021-03-16 | Crawford | Illinois | 17033 | 2019 | 40 |
1122287 | 1122287 | 2021-03-15 | Crawford | Illinois | 17033 | 2019 | 40 |
1119040 | 1119040 | 2021-03-14 | Crawford | Illinois | 17033 | 2018 | 40 |
1115793 | 1115793 | 2021-03-13 | Crawford | Illinois | 17033 | 2017 | 40 |
1112547 | 1112547 | 2021-03-12 | Crawford | Illinois | 17033 | 2017 | 40 |
1109301 | 1109301 | 2021-03-11 | Crawford | Illinois | 17033 | 2016 | 40 |
1106055 | 1106055 | 2021-03-10 | Crawford | Illinois | 17033 | 2016 | 40 |
1102809 | 1102809 | 2021-03-09 | Crawford | Illinois | 17033 | 2015 | 40 |
1099563 | 1099563 | 2021-03-08 | Crawford | Illinois | 17033 | 2014 | 40 |
1096315 | 1096315 | 2021-03-07 | Crawford | Illinois | 17033 | 2013 | 40 |
1093069 | 1093069 | 2021-03-06 | Crawford | Illinois | 17033 | 2013 | 40 |
1089823 | 1089823 | 2021-03-05 | Crawford | Illinois | 17033 | 2013 | 40 |
1086578 | 1086578 | 2021-03-04 | Crawford | Illinois | 17033 | 2013 | 40 |
1083332 | 1083332 | 2021-03-03 | Crawford | Illinois | 17033 | 2014 | 40 |
797240 | 797240 | 2020-12-05 | Crawford | Arkansas | 5033 | 3331 | 40 |
793995 | 793995 | 2020-12-04 | Crawford | Arkansas | 5033 | 3267 | 40 |
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);