ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1817962 | 1817962 | 2021-10-15 | Douglas | Minnesota | 27041 | 6161 | 89 |
1818145 | 1818145 | 2021-10-15 | Douglas | Missouri | 29067 | 1614 | 45 |
1818312 | 1818312 | 2021-10-15 | Douglas | Nebraska | 31055 | 85544 | 818 |
1818382 | 1818382 | 2021-10-15 | Douglas | Nevada | 32005 | 4589 | 53 |
1818852 | 1818852 | 2021-10-15 | Douglas | Oregon | 41019 | 11795 | 240 |
1819097 | 1819097 | 2021-10-15 | Douglas | South Dakota | 46043 | 508 | 9 |
1819682 | 1819682 | 2021-10-15 | Douglas | Washington | 53017 | 5939 | 38 |
1819783 | 1819783 | 2021-10-15 | Douglas | Wisconsin | 55031 | 5794 | 66 |
1813629 | 1813629 | 2021-10-14 | Douglas | Colorado | 8035 | 39405 | 308 |
1813804 | 1813804 | 2021-10-14 | Douglas | Georgia | 13097 | 22052 | 276 |
1813988 | 1813988 | 2021-10-14 | Douglas | Illinois | 17041 | 3240 | 43 |
1814285 | 1814285 | 2021-10-14 | Douglas | Kansas | 20045 | 12162 | 101 |
1814713 | 1814713 | 2021-10-14 | Douglas | Minnesota | 27041 | 6122 | 88 |
1814896 | 1814896 | 2021-10-14 | Douglas | Missouri | 29067 | 1610 | 45 |
1815063 | 1815063 | 2021-10-14 | Douglas | Nebraska | 31055 | 85401 | 816 |
1815133 | 1815133 | 2021-10-14 | Douglas | Nevada | 32005 | 4579 | 53 |
1815603 | 1815603 | 2021-10-14 | Douglas | Oregon | 41019 | 11751 | 240 |
1815848 | 1815848 | 2021-10-14 | Douglas | South Dakota | 46043 | 508 | 9 |
1816433 | 1816433 | 2021-10-14 | Douglas | Washington | 53017 | 5922 | 38 |
1816534 | 1816534 | 2021-10-14 | Douglas | Wisconsin | 55031 | 5794 | 66 |
1810380 | 1810380 | 2021-10-13 | Douglas | Colorado | 8035 | 39406 | 308 |
1810555 | 1810555 | 2021-10-13 | Douglas | Georgia | 13097 | 22034 | 276 |
1810739 | 1810739 | 2021-10-13 | Douglas | Illinois | 17041 | 3227 | 43 |
1811036 | 1811036 | 2021-10-13 | Douglas | Kansas | 20045 | 12162 | 101 |
1811465 | 1811465 | 2021-10-13 | Douglas | Minnesota | 27041 | 6087 | 88 |
1811648 | 1811648 | 2021-10-13 | Douglas | Missouri | 29067 | 1605 | 45 |
1811815 | 1811815 | 2021-10-13 | Douglas | Nebraska | 31055 | 85220 | 813 |
1811885 | 1811885 | 2021-10-13 | Douglas | Nevada | 32005 | 4571 | 53 |
1812355 | 1812355 | 2021-10-13 | Douglas | Oregon | 41019 | 11713 | 240 |
1812600 | 1812600 | 2021-10-13 | Douglas | South Dakota | 46043 | 507 | 9 |
1813185 | 1813185 | 2021-10-13 | Douglas | Washington | 53017 | 5896 | 36 |
1813286 | 1813286 | 2021-10-13 | Douglas | Wisconsin | 55031 | 5766 | 66 |
1807131 | 1807131 | 2021-10-12 | Douglas | Colorado | 8035 | 39223 | 308 |
1807306 | 1807306 | 2021-10-12 | Douglas | Georgia | 13097 | 22011 | 276 |
1807490 | 1807490 | 2021-10-12 | Douglas | Illinois | 17041 | 3208 | 43 |
1807787 | 1807787 | 2021-10-12 | Douglas | Kansas | 20045 | 12145 | 100 |
1808216 | 1808216 | 2021-10-12 | Douglas | Minnesota | 27041 | 6060 | 88 |
1808399 | 1808399 | 2021-10-12 | Douglas | Missouri | 29067 | 1601 | 42 |
1808566 | 1808566 | 2021-10-12 | Douglas | Nebraska | 31055 | 84988 | 804 |
1808636 | 1808636 | 2021-10-12 | Douglas | Nevada | 32005 | 4562 | 53 |
1809106 | 1809106 | 2021-10-12 | Douglas | Oregon | 41019 | 11664 | 238 |
1809351 | 1809351 | 2021-10-12 | Douglas | South Dakota | 46043 | 503 | 9 |
1809936 | 1809936 | 2021-10-12 | Douglas | Washington | 53017 | 5879 | 34 |
1810037 | 1810037 | 2021-10-12 | Douglas | Wisconsin | 55031 | 5737 | 66 |
1803880 | 1803880 | 2021-10-11 | Douglas | Colorado | 8035 | 39223 | 308 |
1804055 | 1804055 | 2021-10-11 | Douglas | Georgia | 13097 | 21892 | 274 |
1804239 | 1804239 | 2021-10-11 | Douglas | Illinois | 17041 | 3186 | 43 |
1804536 | 1804536 | 2021-10-11 | Douglas | Kansas | 20045 | 12145 | 100 |
1804965 | 1804965 | 2021-10-11 | Douglas | Minnesota | 27041 | 5963 | 88 |
1805148 | 1805148 | 2021-10-11 | Douglas | Missouri | 29067 | 1601 | 42 |
1805315 | 1805315 | 2021-10-11 | Douglas | Nebraska | 31055 | 84526 | 801 |
1805385 | 1805385 | 2021-10-11 | Douglas | Nevada | 32005 | 4527 | 52 |
1805856 | 1805856 | 2021-10-11 | Douglas | Oregon | 41019 | 11624 | 236 |
1806101 | 1806101 | 2021-10-11 | Douglas | South Dakota | 46043 | 503 | 9 |
1806687 | 1806687 | 2021-10-11 | Douglas | Washington | 53017 | 5826 | 34 |
1806788 | 1806788 | 2021-10-11 | Douglas | Wisconsin | 55031 | 5729 | 66 |
1800631 | 1800631 | 2021-10-10 | Douglas | Colorado | 8035 | 39018 | 306 |
1800806 | 1800806 | 2021-10-10 | Douglas | Georgia | 13097 | 21892 | 274 |
1800990 | 1800990 | 2021-10-10 | Douglas | Illinois | 17041 | 3186 | 43 |
1801287 | 1801287 | 2021-10-10 | Douglas | Kansas | 20045 | 12102 | 100 |
1801716 | 1801716 | 2021-10-10 | Douglas | Minnesota | 27041 | 5936 | 86 |
1801899 | 1801899 | 2021-10-10 | Douglas | Missouri | 29067 | 1599 | 42 |
1802066 | 1802066 | 2021-10-10 | Douglas | Nebraska | 31055 | 84526 | 801 |
1802136 | 1802136 | 2021-10-10 | Douglas | Nevada | 32005 | 4521 | 52 |
1802606 | 1802606 | 2021-10-10 | Douglas | Oregon | 41019 | 11562 | 233 |
1802851 | 1802851 | 2021-10-10 | Douglas | South Dakota | 46043 | 503 | 9 |
1803436 | 1803436 | 2021-10-10 | Douglas | Washington | 53017 | 5806 | 34 |
1803537 | 1803537 | 2021-10-10 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1797382 | 1797382 | 2021-10-09 | Douglas | Colorado | 8035 | 38911 | 305 |
1797557 | 1797557 | 2021-10-09 | Douglas | Georgia | 13097 | 21892 | 274 |
1797741 | 1797741 | 2021-10-09 | Douglas | Illinois | 17041 | 3186 | 43 |
1798038 | 1798038 | 2021-10-09 | Douglas | Kansas | 20045 | 12102 | 100 |
1798467 | 1798467 | 2021-10-09 | Douglas | Minnesota | 27041 | 5936 | 86 |
1798650 | 1798650 | 2021-10-09 | Douglas | Missouri | 29067 | 1598 | 42 |
1798817 | 1798817 | 2021-10-09 | Douglas | Nebraska | 31055 | 84526 | 801 |
1798887 | 1798887 | 2021-10-09 | Douglas | Nevada | 32005 | 4521 | 52 |
1799357 | 1799357 | 2021-10-09 | Douglas | Oregon | 41019 | 11562 | 233 |
1799602 | 1799602 | 2021-10-09 | Douglas | South Dakota | 46043 | 503 | 9 |
1800187 | 1800187 | 2021-10-09 | Douglas | Washington | 53017 | 5806 | 34 |
1800288 | 1800288 | 2021-10-09 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1794133 | 1794133 | 2021-10-08 | Douglas | Colorado | 8035 | 38911 | 305 |
1794308 | 1794308 | 2021-10-08 | Douglas | Georgia | 13097 | 21892 | 274 |
1794492 | 1794492 | 2021-10-08 | Douglas | Illinois | 17041 | 3186 | 43 |
1794789 | 1794789 | 2021-10-08 | Douglas | Kansas | 20045 | 12102 | 100 |
1795218 | 1795218 | 2021-10-08 | Douglas | Minnesota | 27041 | 5936 | 86 |
1795401 | 1795401 | 2021-10-08 | Douglas | Missouri | 29067 | 1591 | 42 |
1795568 | 1795568 | 2021-10-08 | Douglas | Nebraska | 31055 | 84526 | 801 |
1795638 | 1795638 | 2021-10-08 | Douglas | Nevada | 32005 | 4521 | 52 |
1796108 | 1796108 | 2021-10-08 | Douglas | Oregon | 41019 | 11562 | 233 |
1796353 | 1796353 | 2021-10-08 | Douglas | South Dakota | 46043 | 503 | 9 |
1796938 | 1796938 | 2021-10-08 | Douglas | Washington | 53017 | 5806 | 34 |
1797039 | 1797039 | 2021-10-08 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1790885 | 1790885 | 2021-10-07 | Douglas | Colorado | 8035 | 38740 | 302 |
1791060 | 1791060 | 2021-10-07 | Douglas | Georgia | 13097 | 21819 | 271 |
1791244 | 1791244 | 2021-10-07 | Douglas | Illinois | 17041 | 3180 | 43 |
1791541 | 1791541 | 2021-10-07 | Douglas | Kansas | 20045 | 12037 | 99 |
1791969 | 1791969 | 2021-10-07 | Douglas | Minnesota | 27041 | 5897 | 86 |
1792152 | 1792152 | 2021-10-07 | Douglas | Missouri | 29067 | 1583 | 42 |
1792319 | 1792319 | 2021-10-07 | Douglas | Nebraska | 31055 | 84345 | 801 |
1792389 | 1792389 | 2021-10-07 | Douglas | Nevada | 32005 | 4509 | 52 |
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);