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 |
---|---|---|---|---|---|---|---|
1813795 | 1813795 | 2021-10-14 | Crawford | Georgia | 13079 | 1121 | 40 |
1813984 | 1813984 | 2021-10-14 | Crawford | Illinois | 17033 | 3292 | 46 |
1814083 | 1814083 | 2021-10-14 | Crawford | Indiana | 18025 | 1577 | 23 |
1814186 | 1814186 | 2021-10-14 | Crawford | Iowa | 19047 | 3374 | 45 |
1814281 | 1814281 | 2021-10-14 | Crawford | Kansas | 20037 | 6637 | 113 |
1814628 | 1814628 | 2021-10-14 | Crawford | Michigan | 26039 | 1230 | 16 |
1814890 | 1814890 | 2021-10-14 | Crawford | Missouri | 29055 | 3561 | 56 |
1815443 | 1815443 | 2021-10-14 | Crawford | Ohio | 39033 | 6128 | 127 |
1815649 | 1815649 | 2021-10-14 | Crawford | Pennsylvania | 42039 | 10266 | 180 |
1816530 | 1816530 | 2021-10-14 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1810244 | 1810244 | 2021-10-13 | Crawford | Arkansas | 5033 | 10554 | 170 |
1810546 | 1810546 | 2021-10-13 | Crawford | Georgia | 13079 | 1117 | 40 |
1810735 | 1810735 | 2021-10-13 | Crawford | Illinois | 17033 | 3282 | 46 |
1810834 | 1810834 | 2021-10-13 | Crawford | Indiana | 18025 | 1572 | 23 |
1810937 | 1810937 | 2021-10-13 | Crawford | Iowa | 19047 | 3374 | 45 |
1811032 | 1811032 | 2021-10-13 | Crawford | Kansas | 20037 | 6637 | 113 |
1811380 | 1811380 | 2021-10-13 | Crawford | Michigan | 26039 | 1230 | 16 |
1811642 | 1811642 | 2021-10-13 | Crawford | Missouri | 29055 | 3553 | 56 |
1812195 | 1812195 | 2021-10-13 | Crawford | Ohio | 39033 | 6099 | 127 |
1812401 | 1812401 | 2021-10-13 | Crawford | Pennsylvania | 42039 | 10224 | 178 |
1813282 | 1813282 | 2021-10-13 | Crawford | Wisconsin | 55023 | 2218 | 22 |
1806995 | 1806995 | 2021-10-12 | Crawford | Arkansas | 5033 | 10539 | 169 |
1807297 | 1807297 | 2021-10-12 | Crawford | Georgia | 13079 | 1115 | 40 |
1807486 | 1807486 | 2021-10-12 | Crawford | Illinois | 17033 | 3270 | 46 |
1807585 | 1807585 | 2021-10-12 | Crawford | Indiana | 18025 | 1568 | 23 |
1807688 | 1807688 | 2021-10-12 | Crawford | Iowa | 19047 | 3346 | 45 |
1807783 | 1807783 | 2021-10-12 | Crawford | Kansas | 20037 | 6632 | 113 |
1808131 | 1808131 | 2021-10-12 | Crawford | Michigan | 26039 | 1202 | 16 |
1808393 | 1808393 | 2021-10-12 | Crawford | Missouri | 29055 | 3543 | 56 |
1808946 | 1808946 | 2021-10-12 | Crawford | Ohio | 39033 | 6067 | 127 |
1809152 | 1809152 | 2021-10-12 | Crawford | Pennsylvania | 42039 | 10173 | 176 |
1810033 | 1810033 | 2021-10-12 | Crawford | Wisconsin | 55023 | 2201 | 22 |
1803744 | 1803744 | 2021-10-11 | Crawford | Arkansas | 5033 | 10521 | 168 |
1804046 | 1804046 | 2021-10-11 | Crawford | Georgia | 13079 | 1108 | 38 |
1804235 | 1804235 | 2021-10-11 | Crawford | Illinois | 17033 | 3252 | 46 |
1804334 | 1804334 | 2021-10-11 | Crawford | Indiana | 18025 | 1565 | 22 |
1804437 | 1804437 | 2021-10-11 | Crawford | Iowa | 19047 | 3346 | 45 |
1804532 | 1804532 | 2021-10-11 | Crawford | Kansas | 20037 | 6632 | 113 |
1804880 | 1804880 | 2021-10-11 | Crawford | Michigan | 26039 | 1202 | 16 |
1805142 | 1805142 | 2021-10-11 | Crawford | Missouri | 29055 | 3542 | 56 |
1805696 | 1805696 | 2021-10-11 | Crawford | Ohio | 39033 | 6045 | 127 |
1805902 | 1805902 | 2021-10-11 | Crawford | Pennsylvania | 42039 | 10106 | 175 |
1806784 | 1806784 | 2021-10-11 | Crawford | Wisconsin | 55023 | 2191 | 22 |
1800495 | 1800495 | 2021-10-10 | Crawford | Arkansas | 5033 | 10510 | 168 |
1800797 | 1800797 | 2021-10-10 | Crawford | Georgia | 13079 | 1108 | 38 |
1800986 | 1800986 | 2021-10-10 | Crawford | Illinois | 17033 | 3252 | 46 |
1801085 | 1801085 | 2021-10-10 | Crawford | Indiana | 18025 | 1553 | 22 |
1801188 | 1801188 | 2021-10-10 | Crawford | Iowa | 19047 | 3346 | 45 |
1801283 | 1801283 | 2021-10-10 | Crawford | Kansas | 20037 | 6626 | 113 |
1801631 | 1801631 | 2021-10-10 | Crawford | Michigan | 26039 | 1194 | 16 |
1801893 | 1801893 | 2021-10-10 | Crawford | Missouri | 29055 | 3539 | 56 |
1802446 | 1802446 | 2021-10-10 | Crawford | Ohio | 39033 | 6035 | 127 |
1802652 | 1802652 | 2021-10-10 | Crawford | Pennsylvania | 42039 | 10076 | 175 |
1803533 | 1803533 | 2021-10-10 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1797246 | 1797246 | 2021-10-09 | Crawford | Arkansas | 5033 | 10506 | 168 |
1797548 | 1797548 | 2021-10-09 | Crawford | Georgia | 13079 | 1108 | 38 |
1797737 | 1797737 | 2021-10-09 | Crawford | Illinois | 17033 | 3252 | 46 |
1797836 | 1797836 | 2021-10-09 | Crawford | Indiana | 18025 | 1553 | 22 |
1797939 | 1797939 | 2021-10-09 | Crawford | Iowa | 19047 | 3346 | 45 |
1798034 | 1798034 | 2021-10-09 | Crawford | Kansas | 20037 | 6626 | 113 |
1798382 | 1798382 | 2021-10-09 | Crawford | Michigan | 26039 | 1194 | 16 |
1798644 | 1798644 | 2021-10-09 | Crawford | Missouri | 29055 | 3538 | 56 |
1799197 | 1799197 | 2021-10-09 | Crawford | Ohio | 39033 | 6010 | 127 |
1799403 | 1799403 | 2021-10-09 | Crawford | Pennsylvania | 42039 | 10055 | 175 |
1800284 | 1800284 | 2021-10-09 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1793997 | 1793997 | 2021-10-08 | Crawford | Arkansas | 5033 | 10483 | 168 |
1794299 | 1794299 | 2021-10-08 | Crawford | Georgia | 13079 | 1108 | 38 |
1794488 | 1794488 | 2021-10-08 | Crawford | Illinois | 17033 | 3252 | 46 |
1794587 | 1794587 | 2021-10-08 | Crawford | Indiana | 18025 | 1553 | 22 |
1794690 | 1794690 | 2021-10-08 | Crawford | Iowa | 19047 | 3346 | 45 |
1794785 | 1794785 | 2021-10-08 | Crawford | Kansas | 20037 | 6626 | 113 |
1795133 | 1795133 | 2021-10-08 | Crawford | Michigan | 26039 | 1194 | 16 |
1795395 | 1795395 | 2021-10-08 | Crawford | Missouri | 29055 | 3532 | 56 |
1795948 | 1795948 | 2021-10-08 | Crawford | Ohio | 39033 | 5992 | 127 |
1796154 | 1796154 | 2021-10-08 | Crawford | Pennsylvania | 42039 | 9998 | 175 |
1797035 | 1797035 | 2021-10-08 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1790749 | 1790749 | 2021-10-07 | Crawford | Arkansas | 5033 | 10456 | 168 |
1791051 | 1791051 | 2021-10-07 | Crawford | Georgia | 13079 | 1107 | 38 |
1791240 | 1791240 | 2021-10-07 | Crawford | Illinois | 17033 | 3241 | 46 |
1791339 | 1791339 | 2021-10-07 | Crawford | Indiana | 18025 | 1540 | 22 |
1791442 | 1791442 | 2021-10-07 | Crawford | Iowa | 19047 | 3346 | 45 |
1791537 | 1791537 | 2021-10-07 | Crawford | Kansas | 20037 | 6608 | 113 |
1791884 | 1791884 | 2021-10-07 | Crawford | Michigan | 26039 | 1180 | 16 |
1792146 | 1792146 | 2021-10-07 | Crawford | Missouri | 29055 | 3520 | 56 |
1792699 | 1792699 | 2021-10-07 | Crawford | Ohio | 39033 | 5957 | 125 |
1792905 | 1792905 | 2021-10-07 | Crawford | Pennsylvania | 42039 | 9952 | 172 |
1793786 | 1793786 | 2021-10-07 | Crawford | Wisconsin | 55023 | 2164 | 22 |
1787500 | 1787500 | 2021-10-06 | Crawford | Arkansas | 5033 | 10442 | 166 |
1787802 | 1787802 | 2021-10-06 | Crawford | Georgia | 13079 | 1103 | 38 |
1787991 | 1787991 | 2021-10-06 | Crawford | Illinois | 17033 | 3225 | 46 |
1788090 | 1788090 | 2021-10-06 | Crawford | Indiana | 18025 | 1533 | 22 |
1788193 | 1788193 | 2021-10-06 | Crawford | Iowa | 19047 | 3346 | 45 |
1788288 | 1788288 | 2021-10-06 | Crawford | Kansas | 20037 | 6608 | 113 |
1788635 | 1788635 | 2021-10-06 | Crawford | Michigan | 26039 | 1180 | 16 |
1788897 | 1788897 | 2021-10-06 | Crawford | Missouri | 29055 | 3514 | 56 |
1789450 | 1789450 | 2021-10-06 | Crawford | Ohio | 39033 | 5914 | 125 |
1789656 | 1789656 | 2021-10-06 | Crawford | Pennsylvania | 42039 | 9882 | 172 |
1790537 | 1790537 | 2021-10-06 | Crawford | Wisconsin | 55023 | 2144 | 22 |
1784251 | 1784251 | 2021-10-05 | Crawford | Arkansas | 5033 | 10413 | 166 |
1784553 | 1784553 | 2021-10-05 | Crawford | Georgia | 13079 | 1100 | 38 |
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);