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 |
---|---|---|---|---|---|---|---|
1792859 | 1792859 | 2021-10-07 | Douglas | Oregon | 41019 | 11523 | 231 |
1793104 | 1793104 | 2021-10-07 | Douglas | South Dakota | 46043 | 503 | 9 |
1793689 | 1793689 | 2021-10-07 | Douglas | Washington | 53017 | 5778 | 34 |
1793790 | 1793790 | 2021-10-07 | Douglas | Wisconsin | 55031 | 5664 | 66 |
1787636 | 1787636 | 2021-10-06 | Douglas | Colorado | 8035 | 38521 | 301 |
1787811 | 1787811 | 2021-10-06 | Douglas | Georgia | 13097 | 21693 | 269 |
1787995 | 1787995 | 2021-10-06 | Douglas | Illinois | 17041 | 3166 | 43 |
1788292 | 1788292 | 2021-10-06 | Douglas | Kansas | 20045 | 12037 | 99 |
1788720 | 1788720 | 2021-10-06 | Douglas | Minnesota | 27041 | 5859 | 86 |
1788903 | 1788903 | 2021-10-06 | Douglas | Missouri | 29067 | 1576 | 42 |
1789070 | 1789070 | 2021-10-06 | Douglas | Nebraska | 31055 | 84226 | 798 |
1789140 | 1789140 | 2021-10-06 | Douglas | Nevada | 32005 | 4502 | 51 |
1789610 | 1789610 | 2021-10-06 | Douglas | Oregon | 41019 | 11463 | 229 |
1789855 | 1789855 | 2021-10-06 | Douglas | South Dakota | 46043 | 503 | 9 |
1790440 | 1790440 | 2021-10-06 | Douglas | Washington | 53017 | 5755 | 33 |
1790541 | 1790541 | 2021-10-06 | Douglas | Wisconsin | 55031 | 5649 | 66 |
1784387 | 1784387 | 2021-10-05 | Douglas | Colorado | 8035 | 38387 | 299 |
1784562 | 1784562 | 2021-10-05 | Douglas | Georgia | 13097 | 21687 | 269 |
1784746 | 1784746 | 2021-10-05 | Douglas | Illinois | 17041 | 3160 | 43 |
1785043 | 1785043 | 2021-10-05 | Douglas | Kansas | 20045 | 11959 | 99 |
1785472 | 1785472 | 2021-10-05 | Douglas | Minnesota | 27041 | 5827 | 85 |
1785655 | 1785655 | 2021-10-05 | Douglas | Missouri | 29067 | 1571 | 42 |
1785822 | 1785822 | 2021-10-05 | Douglas | Nebraska | 31055 | 84041 | 797 |
1785892 | 1785892 | 2021-10-05 | Douglas | Nevada | 32005 | 4424 | 50 |
1786362 | 1786362 | 2021-10-05 | Douglas | Oregon | 41019 | 11414 | 226 |
1786607 | 1786607 | 2021-10-05 | Douglas | South Dakota | 46043 | 502 | 9 |
1787192 | 1787192 | 2021-10-05 | Douglas | Washington | 53017 | 5739 | 33 |
1787293 | 1787293 | 2021-10-05 | Douglas | Wisconsin | 55031 | 5623 | 66 |
1781138 | 1781138 | 2021-10-04 | Douglas | Colorado | 8035 | 38299 | 296 |
1781313 | 1781313 | 2021-10-04 | Douglas | Georgia | 13097 | 21656 | 265 |
1781497 | 1781497 | 2021-10-04 | Douglas | Illinois | 17041 | 3151 | 43 |
1781794 | 1781794 | 2021-10-04 | Douglas | Kansas | 20045 | 11959 | 99 |
1782223 | 1782223 | 2021-10-04 | Douglas | Minnesota | 27041 | 5732 | 84 |
1782406 | 1782406 | 2021-10-04 | Douglas | Missouri | 29067 | 1570 | 42 |
1782573 | 1782573 | 2021-10-04 | Douglas | Nebraska | 31055 | 83834 | 796 |
1782643 | 1782643 | 2021-10-04 | Douglas | Nevada | 32005 | 4403 | 50 |
1783113 | 1783113 | 2021-10-04 | Douglas | Oregon | 41019 | 11347 | 220 |
1783358 | 1783358 | 2021-10-04 | Douglas | South Dakota | 46043 | 500 | 9 |
1783943 | 1783943 | 2021-10-04 | Douglas | Washington | 53017 | 5695 | 33 |
1784044 | 1784044 | 2021-10-04 | Douglas | Wisconsin | 55031 | 5605 | 66 |
1777888 | 1777888 | 2021-10-03 | Douglas | Colorado | 8035 | 38299 | 296 |
1778063 | 1778063 | 2021-10-03 | Douglas | Georgia | 13097 | 21560 | 265 |
1778247 | 1778247 | 2021-10-03 | Douglas | Illinois | 17041 | 3131 | 43 |
1778544 | 1778544 | 2021-10-03 | Douglas | Kansas | 20045 | 11904 | 99 |
1778973 | 1778973 | 2021-10-03 | Douglas | Minnesota | 27041 | 5686 | 84 |
1779156 | 1779156 | 2021-10-03 | Douglas | Missouri | 29067 | 1570 | 42 |
1779323 | 1779323 | 2021-10-03 | Douglas | Nebraska | 31055 | 83487 | 795 |
1779393 | 1779393 | 2021-10-03 | Douglas | Nevada | 32005 | 4396 | 50 |
1779864 | 1779864 | 2021-10-03 | Douglas | Oregon | 41019 | 11288 | 220 |
1780109 | 1780109 | 2021-10-03 | Douglas | South Dakota | 46043 | 500 | 9 |
1780694 | 1780694 | 2021-10-03 | Douglas | Washington | 53017 | 5669 | 33 |
1780795 | 1780795 | 2021-10-03 | Douglas | Wisconsin | 55031 | 5546 | 66 |
1774638 | 1774638 | 2021-10-02 | Douglas | Colorado | 8035 | 38167 | 294 |
1774813 | 1774813 | 2021-10-02 | Douglas | Georgia | 13097 | 21560 | 265 |
1774997 | 1774997 | 2021-10-02 | Douglas | Illinois | 17041 | 3131 | 43 |
1775294 | 1775294 | 2021-10-02 | Douglas | Kansas | 20045 | 11904 | 99 |
1775723 | 1775723 | 2021-10-02 | Douglas | Minnesota | 27041 | 5686 | 84 |
1775906 | 1775906 | 2021-10-02 | Douglas | Missouri | 29067 | 1570 | 42 |
1776073 | 1776073 | 2021-10-02 | Douglas | Nebraska | 31055 | 83487 | 795 |
1776143 | 1776143 | 2021-10-02 | Douglas | Nevada | 32005 | 4396 | 50 |
1776614 | 1776614 | 2021-10-02 | Douglas | Oregon | 41019 | 11288 | 220 |
1776859 | 1776859 | 2021-10-02 | Douglas | South Dakota | 46043 | 500 | 9 |
1777444 | 1777444 | 2021-10-02 | Douglas | Washington | 53017 | 5669 | 33 |
1777545 | 1777545 | 2021-10-02 | Douglas | Wisconsin | 55031 | 5546 | 66 |
1771388 | 1771388 | 2021-10-01 | Douglas | Colorado | 8035 | 38062 | 292 |
1771563 | 1771563 | 2021-10-01 | Douglas | Georgia | 13097 | 21560 | 265 |
1771747 | 1771747 | 2021-10-01 | Douglas | Illinois | 17041 | 3131 | 43 |
1772044 | 1772044 | 2021-10-01 | Douglas | Kansas | 20045 | 11904 | 99 |
1772473 | 1772473 | 2021-10-01 | Douglas | Minnesota | 27041 | 5686 | 84 |
1772656 | 1772656 | 2021-10-01 | Douglas | Missouri | 29067 | 1564 | 42 |
1772823 | 1772823 | 2021-10-01 | Douglas | Nebraska | 31055 | 83487 | 795 |
1772893 | 1772893 | 2021-10-01 | Douglas | Nevada | 32005 | 4396 | 50 |
1773364 | 1773364 | 2021-10-01 | Douglas | Oregon | 41019 | 11288 | 220 |
1773609 | 1773609 | 2021-10-01 | Douglas | South Dakota | 46043 | 500 | 9 |
1774194 | 1774194 | 2021-10-01 | Douglas | Washington | 53017 | 5669 | 33 |
1774295 | 1774295 | 2021-10-01 | Douglas | Wisconsin | 55031 | 5546 | 66 |
1768139 | 1768139 | 2021-09-30 | Douglas | Colorado | 8035 | 37908 | 289 |
1768314 | 1768314 | 2021-09-30 | Douglas | Georgia | 13097 | 21526 | 264 |
1768498 | 1768498 | 2021-09-30 | Douglas | Illinois | 17041 | 3124 | 42 |
1768795 | 1768795 | 2021-09-30 | Douglas | Kansas | 20045 | 11841 | 99 |
1769224 | 1769224 | 2021-09-30 | Douglas | Minnesota | 27041 | 5651 | 84 |
1769407 | 1769407 | 2021-09-30 | Douglas | Missouri | 29067 | 1562 | 42 |
1769574 | 1769574 | 2021-09-30 | Douglas | Nebraska | 31055 | 83356 | 793 |
1769644 | 1769644 | 2021-09-30 | Douglas | Nevada | 32005 | 4385 | 49 |
1770114 | 1770114 | 2021-09-30 | Douglas | Oregon | 41019 | 11252 | 215 |
1770359 | 1770359 | 2021-09-30 | Douglas | South Dakota | 46043 | 499 | 9 |
1770944 | 1770944 | 2021-09-30 | Douglas | Washington | 53017 | 5635 | 33 |
1771045 | 1771045 | 2021-09-30 | Douglas | Wisconsin | 55031 | 5516 | 66 |
1764890 | 1764890 | 2021-09-29 | Douglas | Colorado | 8035 | 37769 | 287 |
1765065 | 1765065 | 2021-09-29 | Douglas | Georgia | 13097 | 21456 | 266 |
1765249 | 1765249 | 2021-09-29 | Douglas | Illinois | 17041 | 3112 | 42 |
1765546 | 1765546 | 2021-09-29 | Douglas | Kansas | 20045 | 11841 | 99 |
1765975 | 1765975 | 2021-09-29 | Douglas | Minnesota | 27041 | 5605 | 84 |
1766158 | 1766158 | 2021-09-29 | Douglas | Missouri | 29067 | 1560 | 42 |
1766325 | 1766325 | 2021-09-29 | Douglas | Nebraska | 31055 | 83089 | 788 |
1766395 | 1766395 | 2021-09-29 | Douglas | Nevada | 32005 | 4372 | 49 |
1766865 | 1766865 | 2021-09-29 | Douglas | Oregon | 41019 | 11176 | 215 |
1767110 | 1767110 | 2021-09-29 | Douglas | South Dakota | 46043 | 498 | 9 |
1767695 | 1767695 | 2021-09-29 | Douglas | Washington | 53017 | 5596 | 33 |
1767796 | 1767796 | 2021-09-29 | Douglas | Wisconsin | 55031 | 5508 | 66 |
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);