ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where county = "Crawford" and deaths = 15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Crawford · 116 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1778888 | 1778888 | 2021-10-03 | Crawford | Michigan | 26039 | 1154 | 15 |
1775638 | 1775638 | 2021-10-02 | Crawford | Michigan | 26039 | 1154 | 15 |
1772388 | 1772388 | 2021-10-01 | Crawford | Michigan | 26039 | 1154 | 15 |
1769139 | 1769139 | 2021-09-30 | Crawford | Michigan | 26039 | 1153 | 15 |
1765890 | 1765890 | 2021-09-29 | Crawford | Michigan | 26039 | 1153 | 15 |
1762641 | 1762641 | 2021-09-28 | Crawford | Michigan | 26039 | 1145 | 15 |
1759392 | 1759392 | 2021-09-27 | Crawford | Michigan | 26039 | 1145 | 15 |
1756144 | 1756144 | 2021-09-26 | Crawford | Michigan | 26039 | 1137 | 15 |
1752896 | 1752896 | 2021-09-25 | Crawford | Michigan | 26039 | 1137 | 15 |
1749648 | 1749648 | 2021-09-24 | Crawford | Michigan | 26039 | 1137 | 15 |
1746398 | 1746398 | 2021-09-23 | Crawford | Michigan | 26039 | 1122 | 15 |
1743149 | 1743149 | 2021-09-22 | Crawford | Michigan | 26039 | 1122 | 15 |
1739900 | 1739900 | 2021-09-21 | Crawford | Michigan | 26039 | 1108 | 15 |
1736651 | 1736651 | 2021-09-20 | Crawford | Michigan | 26039 | 1108 | 15 |
1733401 | 1733401 | 2021-09-19 | Crawford | Michigan | 26039 | 1098 | 15 |
1730151 | 1730151 | 2021-09-18 | Crawford | Michigan | 26039 | 1098 | 15 |
1726901 | 1726901 | 2021-09-17 | Crawford | Michigan | 26039 | 1098 | 15 |
1723652 | 1723652 | 2021-09-16 | Crawford | Michigan | 26039 | 1094 | 15 |
1720403 | 1720403 | 2021-09-15 | Crawford | Michigan | 26039 | 1094 | 15 |
1717155 | 1717155 | 2021-09-14 | Crawford | Michigan | 26039 | 1090 | 15 |
1713907 | 1713907 | 2021-09-13 | Crawford | Michigan | 26039 | 1090 | 15 |
1307477 | 1307477 | 2021-05-11 | Crawford | Indiana | 18025 | 999 | 15 |
1304231 | 1304231 | 2021-05-10 | Crawford | Indiana | 18025 | 998 | 15 |
1300984 | 1300984 | 2021-05-09 | Crawford | Indiana | 18025 | 998 | 15 |
1297737 | 1297737 | 2021-05-08 | Crawford | Indiana | 18025 | 996 | 15 |
1294491 | 1294491 | 2021-05-07 | Crawford | Indiana | 18025 | 994 | 15 |
1291245 | 1291245 | 2021-05-06 | Crawford | Indiana | 18025 | 992 | 15 |
1287999 | 1287999 | 2021-05-05 | Crawford | Indiana | 18025 | 992 | 15 |
1284753 | 1284753 | 2021-05-04 | Crawford | Indiana | 18025 | 991 | 15 |
1281506 | 1281506 | 2021-05-03 | Crawford | Indiana | 18025 | 990 | 15 |
1278259 | 1278259 | 2021-05-02 | Crawford | Indiana | 18025 | 989 | 15 |
1275012 | 1275012 | 2021-05-01 | Crawford | Indiana | 18025 | 987 | 15 |
1271765 | 1271765 | 2021-04-30 | Crawford | Indiana | 18025 | 986 | 15 |
1268518 | 1268518 | 2021-04-29 | Crawford | Indiana | 18025 | 984 | 15 |
1265271 | 1265271 | 2021-04-28 | Crawford | Indiana | 18025 | 984 | 15 |
1262024 | 1262024 | 2021-04-27 | Crawford | Indiana | 18025 | 983 | 15 |
1258777 | 1258777 | 2021-04-26 | Crawford | Indiana | 18025 | 983 | 15 |
1255530 | 1255530 | 2021-04-25 | Crawford | Indiana | 18025 | 983 | 15 |
1252283 | 1252283 | 2021-04-24 | Crawford | Indiana | 18025 | 983 | 15 |
1249036 | 1249036 | 2021-04-23 | Crawford | Indiana | 18025 | 982 | 15 |
1245789 | 1245789 | 2021-04-22 | Crawford | Indiana | 18025 | 982 | 15 |
1242542 | 1242542 | 2021-04-21 | Crawford | Indiana | 18025 | 980 | 15 |
1239295 | 1239295 | 2021-04-20 | Crawford | Indiana | 18025 | 980 | 15 |
1236048 | 1236048 | 2021-04-19 | Crawford | Indiana | 18025 | 977 | 15 |
1232801 | 1232801 | 2021-04-18 | Crawford | Indiana | 18025 | 977 | 15 |
1229552 | 1229552 | 2021-04-17 | Crawford | Indiana | 18025 | 977 | 15 |
1226304 | 1226304 | 2021-04-16 | Crawford | Indiana | 18025 | 976 | 15 |
1223057 | 1223057 | 2021-04-15 | Crawford | Indiana | 18025 | 971 | 15 |
1219809 | 1219809 | 2021-04-14 | Crawford | Indiana | 18025 | 970 | 15 |
1216561 | 1216561 | 2021-04-13 | Crawford | Indiana | 18025 | 970 | 15 |
1213314 | 1213314 | 2021-04-12 | Crawford | Indiana | 18025 | 970 | 15 |
1210066 | 1210066 | 2021-04-11 | Crawford | Indiana | 18025 | 969 | 15 |
1206817 | 1206817 | 2021-04-10 | Crawford | Indiana | 18025 | 969 | 15 |
1203569 | 1203569 | 2021-04-09 | Crawford | Indiana | 18025 | 968 | 15 |
1200321 | 1200321 | 2021-04-08 | Crawford | Indiana | 18025 | 968 | 15 |
1047440 | 1047440 | 2021-02-20 | Crawford | Georgia | 13079 | 614 | 15 |
1044195 | 1044195 | 2021-02-19 | Crawford | Georgia | 13079 | 613 | 15 |
1040950 | 1040950 | 2021-02-18 | Crawford | Georgia | 13079 | 602 | 15 |
975523 | 975523 | 2021-01-28 | Crawford | Wisconsin | 55023 | 1683 | 15 |
972278 | 972278 | 2021-01-27 | Crawford | Wisconsin | 55023 | 1679 | 15 |
969033 | 969033 | 2021-01-26 | Crawford | Wisconsin | 55023 | 1676 | 15 |
965789 | 965789 | 2021-01-25 | Crawford | Wisconsin | 55023 | 1675 | 15 |
962544 | 962544 | 2021-01-24 | Crawford | Wisconsin | 55023 | 1673 | 15 |
959299 | 959299 | 2021-01-23 | Crawford | Wisconsin | 55023 | 1673 | 15 |
850566 | 850566 | 2020-12-21 | Crawford | Missouri | 29055 | 1532 | 15 |
847321 | 847321 | 2020-12-20 | Crawford | Missouri | 29055 | 1494 | 15 |
844075 | 844075 | 2020-12-19 | Crawford | Missouri | 29055 | 1478 | 15 |
840830 | 840830 | 2020-12-18 | Crawford | Missouri | 29055 | 1470 | 15 |
837585 | 837585 | 2020-12-17 | Crawford | Missouri | 29055 | 1459 | 15 |
834339 | 834339 | 2020-12-16 | Crawford | Missouri | 29055 | 1433 | 15 |
831092 | 831092 | 2020-12-15 | Crawford | Missouri | 29055 | 1424 | 15 |
810910 | 810910 | 2020-12-09 | Crawford | Iowa | 19047 | 1885 | 15 |
807665 | 807665 | 2020-12-08 | Crawford | Iowa | 19047 | 1865 | 15 |
771970 | 771970 | 2020-11-27 | Crawford | Iowa | 19047 | 1741 | 15 |
768725 | 768725 | 2020-11-26 | Crawford | Iowa | 19047 | 1730 | 15 |
765479 | 765479 | 2020-11-25 | Crawford | Iowa | 19047 | 1720 | 15 |
762234 | 762234 | 2020-11-24 | Crawford | Iowa | 19047 | 1707 | 15 |
758989 | 758989 | 2020-11-23 | Crawford | Iowa | 19047 | 1706 | 15 |
755742 | 755742 | 2020-11-22 | Crawford | Iowa | 19047 | 1682 | 15 |
752496 | 752496 | 2020-11-21 | Crawford | Iowa | 19047 | 1670 | 15 |
749250 | 749250 | 2020-11-20 | Crawford | Iowa | 19047 | 1660 | 15 |
746004 | 746004 | 2020-11-19 | Crawford | Iowa | 19047 | 1655 | 15 |
747263 | 747263 | 2020-11-19 | Crawford | Ohio | 39033 | 1028 | 15 |
742757 | 742757 | 2020-11-18 | Crawford | Iowa | 19047 | 1641 | 15 |
744017 | 744017 | 2020-11-18 | Crawford | Ohio | 39033 | 1000 | 15 |
739510 | 739510 | 2020-11-17 | Crawford | Iowa | 19047 | 1626 | 15 |
736266 | 736266 | 2020-11-16 | Crawford | Iowa | 19047 | 1614 | 15 |
733020 | 733020 | 2020-11-15 | Crawford | Iowa | 19047 | 1601 | 15 |
729775 | 729775 | 2020-11-14 | Crawford | Iowa | 19047 | 1594 | 15 |
726532 | 726532 | 2020-11-13 | Crawford | Iowa | 19047 | 1587 | 15 |
723289 | 723289 | 2020-11-12 | Crawford | Iowa | 19047 | 1572 | 15 |
720046 | 720046 | 2020-11-11 | Crawford | Iowa | 19047 | 1555 | 15 |
716803 | 716803 | 2020-11-10 | Crawford | Iowa | 19047 | 1527 | 15 |
713559 | 713559 | 2020-11-09 | Crawford | Iowa | 19047 | 1516 | 15 |
710315 | 710315 | 2020-11-08 | Crawford | Iowa | 19047 | 1500 | 15 |
707071 | 707071 | 2020-11-07 | Crawford | Iowa | 19047 | 1493 | 15 |
703828 | 703828 | 2020-11-06 | Crawford | Iowa | 19047 | 1484 | 15 |
700586 | 700586 | 2020-11-05 | Crawford | Iowa | 19047 | 1477 | 15 |
697342 | 697342 | 2020-11-04 | Crawford | Iowa | 19047 | 1455 | 15 |
694100 | 694100 | 2020-11-03 | Crawford | Iowa | 19047 | 1437 | 15 |
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);