ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,543 rows where county = "Crawford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199522 | 1199522 | 2021-04-07 | Crawford | Wisconsin | 55023 | 1737 | 17 |
1193235 | 1193235 | 2021-04-06 | Crawford | Arkansas | 5033 | 6996 | 115 |
1193537 | 1193537 | 2021-04-06 | Crawford | Georgia | 13079 | 653 | 19 |
1193725 | 1193725 | 2021-04-06 | Crawford | Illinois | 17033 | 2074 | 40 |
1193824 | 1193824 | 2021-04-06 | Crawford | Indiana | 18025 | 966 | 14 |
1193927 | 1193927 | 2021-04-06 | Crawford | Iowa | 19047 | 2605 | 39 |
1194022 | 1194022 | 2021-04-06 | Crawford | Kansas | 20037 | 4651 | 82 |
1194370 | 1194370 | 2021-04-06 | Crawford | Michigan | 26039 | 791 | 6 |
1194632 | 1194632 | 2021-04-06 | Crawford | Missouri | 29055 | 2521 | 35 |
1195185 | 1195185 | 2021-04-06 | Crawford | Ohio | 39033 | 3784 | 100 |
1195391 | 1195391 | 2021-04-06 | Crawford | Pennsylvania | 42039 | 6720 | 144 |
1196273 | 1196273 | 2021-04-06 | Crawford | Wisconsin | 55023 | 1734 | 17 |
1189985 | 1189985 | 2021-04-05 | Crawford | Arkansas | 5033 | 6995 | 115 |
1190287 | 1190287 | 2021-04-05 | Crawford | Georgia | 13079 | 654 | 19 |
1190475 | 1190475 | 2021-04-05 | Crawford | Illinois | 17033 | 2071 | 40 |
1190574 | 1190574 | 2021-04-05 | Crawford | Indiana | 18025 | 966 | 14 |
1190677 | 1190677 | 2021-04-05 | Crawford | Iowa | 19047 | 2603 | 38 |
1190772 | 1190772 | 2021-04-05 | Crawford | Kansas | 20037 | 4651 | 82 |
1191121 | 1191121 | 2021-04-05 | Crawford | Michigan | 26039 | 779 | 6 |
1191383 | 1191383 | 2021-04-05 | Crawford | Missouri | 29055 | 2521 | 35 |
1191937 | 1191937 | 2021-04-05 | Crawford | Ohio | 39033 | 3779 | 100 |
1192143 | 1192143 | 2021-04-05 | Crawford | Pennsylvania | 42039 | 6708 | 144 |
1193025 | 1193025 | 2021-04-05 | Crawford | Wisconsin | 55023 | 1734 | 17 |
1186738 | 1186738 | 2021-04-04 | Crawford | Arkansas | 5033 | 6989 | 115 |
1187040 | 1187040 | 2021-04-04 | Crawford | Georgia | 13079 | 654 | 19 |
1187228 | 1187228 | 2021-04-04 | Crawford | Illinois | 17033 | 2070 | 40 |
1187327 | 1187327 | 2021-04-04 | Crawford | Indiana | 18025 | 966 | 14 |
1187430 | 1187430 | 2021-04-04 | Crawford | Iowa | 19047 | 2603 | 38 |
1187525 | 1187525 | 2021-04-04 | Crawford | Kansas | 20037 | 4648 | 82 |
1187873 | 1187873 | 2021-04-04 | Crawford | Michigan | 26039 | 761 | 6 |
1188135 | 1188135 | 2021-04-04 | Crawford | Missouri | 29055 | 2517 | 35 |
1188688 | 1188688 | 2021-04-04 | Crawford | Ohio | 39033 | 3768 | 100 |
1188894 | 1188894 | 2021-04-04 | Crawford | Pennsylvania | 42039 | 6703 | 144 |
1189775 | 1189775 | 2021-04-04 | Crawford | Wisconsin | 55023 | 1734 | 17 |
1183491 | 1183491 | 2021-04-03 | Crawford | Arkansas | 5033 | 6989 | 115 |
1183793 | 1183793 | 2021-04-03 | Crawford | Georgia | 13079 | 654 | 19 |
1183981 | 1183981 | 2021-04-03 | Crawford | Illinois | 17033 | 2069 | 40 |
1184080 | 1184080 | 2021-04-03 | Crawford | Indiana | 18025 | 966 | 14 |
1184183 | 1184183 | 2021-04-03 | Crawford | Iowa | 19047 | 2604 | 38 |
1184278 | 1184278 | 2021-04-03 | Crawford | Kansas | 20037 | 4648 | 82 |
1184626 | 1184626 | 2021-04-03 | Crawford | Michigan | 26039 | 761 | 6 |
1184888 | 1184888 | 2021-04-03 | Crawford | Missouri | 29055 | 2510 | 35 |
1185441 | 1185441 | 2021-04-03 | Crawford | Ohio | 39033 | 3768 | 100 |
1185647 | 1185647 | 2021-04-03 | Crawford | Pennsylvania | 42039 | 6700 | 143 |
1186528 | 1186528 | 2021-04-03 | Crawford | Wisconsin | 55023 | 1734 | 17 |
1180244 | 1180244 | 2021-04-02 | Crawford | Arkansas | 5033 | 6985 | 115 |
1180546 | 1180546 | 2021-04-02 | Crawford | Georgia | 13079 | 654 | 19 |
1180734 | 1180734 | 2021-04-02 | Crawford | Illinois | 17033 | 2067 | 40 |
1180833 | 1180833 | 2021-04-02 | Crawford | Indiana | 18025 | 966 | 14 |
1180936 | 1180936 | 2021-04-02 | Crawford | Iowa | 19047 | 2599 | 37 |
1181031 | 1181031 | 2021-04-02 | Crawford | Kansas | 20037 | 4648 | 82 |
1181380 | 1181380 | 2021-04-02 | Crawford | Michigan | 26039 | 749 | 6 |
1181642 | 1181642 | 2021-04-02 | Crawford | Missouri | 29055 | 2509 | 35 |
1182194 | 1182194 | 2021-04-02 | Crawford | Ohio | 39033 | 3766 | 100 |
1182400 | 1182400 | 2021-04-02 | Crawford | Pennsylvania | 42039 | 6692 | 143 |
1183281 | 1183281 | 2021-04-02 | Crawford | Wisconsin | 55023 | 1734 | 17 |
1176997 | 1176997 | 2021-04-01 | Crawford | Arkansas | 5033 | 6981 | 115 |
1177299 | 1177299 | 2021-04-01 | Crawford | Georgia | 13079 | 653 | 18 |
1177487 | 1177487 | 2021-04-01 | Crawford | Illinois | 17033 | 2064 | 40 |
1177586 | 1177586 | 2021-04-01 | Crawford | Indiana | 18025 | 963 | 14 |
1177689 | 1177689 | 2021-04-01 | Crawford | Iowa | 19047 | 2600 | 37 |
1177784 | 1177784 | 2021-04-01 | Crawford | Kansas | 20037 | 4638 | 82 |
1178133 | 1178133 | 2021-04-01 | Crawford | Michigan | 26039 | 740 | 6 |
1178395 | 1178395 | 2021-04-01 | Crawford | Missouri | 29055 | 2503 | 35 |
1178947 | 1178947 | 2021-04-01 | Crawford | Ohio | 39033 | 3764 | 100 |
1179153 | 1179153 | 2021-04-01 | Crawford | Pennsylvania | 42039 | 6683 | 143 |
1180034 | 1180034 | 2021-04-01 | Crawford | Wisconsin | 55023 | 1732 | 17 |
1173750 | 1173750 | 2021-03-31 | Crawford | Arkansas | 5033 | 6978 | 115 |
1174052 | 1174052 | 2021-03-31 | Crawford | Georgia | 13079 | 652 | 17 |
1174240 | 1174240 | 2021-03-31 | Crawford | Illinois | 17033 | 2063 | 40 |
1174339 | 1174339 | 2021-03-31 | Crawford | Indiana | 18025 | 960 | 14 |
1174442 | 1174442 | 2021-03-31 | Crawford | Iowa | 19047 | 2592 | 37 |
1174537 | 1174537 | 2021-03-31 | Crawford | Kansas | 20037 | 4638 | 84 |
1174886 | 1174886 | 2021-03-31 | Crawford | Michigan | 26039 | 729 | 6 |
1175148 | 1175148 | 2021-03-31 | Crawford | Missouri | 29055 | 2494 | 35 |
1175700 | 1175700 | 2021-03-31 | Crawford | Ohio | 39033 | 3757 | 100 |
1175906 | 1175906 | 2021-03-31 | Crawford | Pennsylvania | 42039 | 6675 | 143 |
1176787 | 1176787 | 2021-03-31 | Crawford | Wisconsin | 55023 | 1731 | 17 |
1170503 | 1170503 | 2021-03-30 | Crawford | Arkansas | 5033 | 6976 | 115 |
1170805 | 1170805 | 2021-03-30 | Crawford | Georgia | 13079 | 652 | 17 |
1170993 | 1170993 | 2021-03-30 | Crawford | Illinois | 17033 | 2056 | 40 |
1171092 | 1171092 | 2021-03-30 | Crawford | Indiana | 18025 | 959 | 14 |
1171195 | 1171195 | 2021-03-30 | Crawford | Iowa | 19047 | 2592 | 36 |
1171290 | 1171290 | 2021-03-30 | Crawford | Kansas | 20037 | 4627 | 83 |
1171639 | 1171639 | 2021-03-30 | Crawford | Michigan | 26039 | 717 | 5 |
1171901 | 1171901 | 2021-03-30 | Crawford | Missouri | 29055 | 2476 | 35 |
1172453 | 1172453 | 2021-03-30 | Crawford | Ohio | 39033 | 3751 | 100 |
1172659 | 1172659 | 2021-03-30 | Crawford | Pennsylvania | 42039 | 6673 | 143 |
1173540 | 1173540 | 2021-03-30 | Crawford | Wisconsin | 55023 | 1731 | 17 |
1167255 | 1167255 | 2021-03-29 | Crawford | Arkansas | 5033 | 6971 | 115 |
1167557 | 1167557 | 2021-03-29 | Crawford | Georgia | 13079 | 649 | 17 |
1167745 | 1167745 | 2021-03-29 | Crawford | Illinois | 17033 | 2053 | 40 |
1167844 | 1167844 | 2021-03-29 | Crawford | Indiana | 18025 | 959 | 14 |
1167947 | 1167947 | 2021-03-29 | Crawford | Iowa | 19047 | 2588 | 36 |
1168042 | 1168042 | 2021-03-29 | Crawford | Kansas | 20037 | 4627 | 83 |
1168391 | 1168391 | 2021-03-29 | Crawford | Michigan | 26039 | 705 | 5 |
1168653 | 1168653 | 2021-03-29 | Crawford | Missouri | 29055 | 2466 | 35 |
1169206 | 1169206 | 2021-03-29 | Crawford | Ohio | 39033 | 3744 | 100 |
1169412 | 1169412 | 2021-03-29 | Crawford | Pennsylvania | 42039 | 6661 | 143 |
1170293 | 1170293 | 2021-03-29 | Crawford | Wisconsin | 55023 | 1731 | 17 |
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);