ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,200 rows where county = "Boone" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
county 1
- Boone · 4,504 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810232 | 1810232 | 2021-10-13 | Boone | Arkansas | 5009 | 6140 | 126 |
1810722 | 1810722 | 2021-10-13 | Boone | Illinois | 17007 | 7838 | 95 |
1810827 | 1810827 | 2021-10-13 | Boone | Indiana | 18011 | 8786 | 121 |
1810921 | 1810921 | 2021-10-13 | Boone | Iowa | 19015 | 3452 | 37 |
1811126 | 1811126 | 2021-10-13 | Boone | Kentucky | 21015 | 20356 | 197 |
1811624 | 1811624 | 2021-10-13 | Boone | Missouri | 29019 | 25080 | 166 |
1811793 | 1811793 | 2021-10-13 | Boone | Nebraska | 31011 | 685 | 4 |
1813218 | 1813218 | 2021-10-13 | Boone | West Virginia | 54005 | 3352 | 47 |
1806983 | 1806983 | 2021-10-12 | Boone | Arkansas | 5009 | 6132 | 126 |
1807473 | 1807473 | 2021-10-12 | Boone | Illinois | 17007 | 7828 | 95 |
1807578 | 1807578 | 2021-10-12 | Boone | Indiana | 18011 | 8771 | 121 |
1807672 | 1807672 | 2021-10-12 | Boone | Iowa | 19015 | 3387 | 36 |
1807877 | 1807877 | 2021-10-12 | Boone | Kentucky | 21015 | 20275 | 197 |
1808375 | 1808375 | 2021-10-12 | Boone | Missouri | 29019 | 24903 | 162 |
1808544 | 1808544 | 2021-10-12 | Boone | Nebraska | 31011 | 682 | 4 |
1809969 | 1809969 | 2021-10-12 | Boone | West Virginia | 54005 | 3348 | 47 |
1803732 | 1803732 | 2021-10-11 | Boone | Arkansas | 5009 | 6123 | 126 |
1804222 | 1804222 | 2021-10-11 | Boone | Illinois | 17007 | 7784 | 95 |
1804327 | 1804327 | 2021-10-11 | Boone | Indiana | 18011 | 8763 | 121 |
1804421 | 1804421 | 2021-10-11 | Boone | Iowa | 19015 | 3387 | 36 |
1804626 | 1804626 | 2021-10-11 | Boone | Kentucky | 21015 | 20215 | 197 |
1805124 | 1805124 | 2021-10-11 | Boone | Missouri | 29019 | 24903 | 162 |
1805293 | 1805293 | 2021-10-11 | Boone | Nebraska | 31011 | 679 | 4 |
1806720 | 1806720 | 2021-10-11 | Boone | West Virginia | 54005 | 3334 | 47 |
1800483 | 1800483 | 2021-10-10 | Boone | Arkansas | 5009 | 6121 | 126 |
1800973 | 1800973 | 2021-10-10 | Boone | Illinois | 17007 | 7784 | 95 |
1801078 | 1801078 | 2021-10-10 | Boone | Indiana | 18011 | 8733 | 121 |
1801172 | 1801172 | 2021-10-10 | Boone | Iowa | 19015 | 3387 | 36 |
1801377 | 1801377 | 2021-10-10 | Boone | Kentucky | 21015 | 20026 | 197 |
1801875 | 1801875 | 2021-10-10 | Boone | Missouri | 29019 | 24903 | 162 |
1802044 | 1802044 | 2021-10-10 | Boone | Nebraska | 31011 | 679 | 4 |
1803469 | 1803469 | 2021-10-10 | Boone | West Virginia | 54005 | 3324 | 44 |
1797234 | 1797234 | 2021-10-09 | Boone | Arkansas | 5009 | 6118 | 114 |
1797724 | 1797724 | 2021-10-09 | Boone | Illinois | 17007 | 7784 | 95 |
1797829 | 1797829 | 2021-10-09 | Boone | Indiana | 18011 | 8733 | 121 |
1797923 | 1797923 | 2021-10-09 | Boone | Iowa | 19015 | 3387 | 36 |
1798128 | 1798128 | 2021-10-09 | Boone | Kentucky | 21015 | 20026 | 197 |
1798626 | 1798626 | 2021-10-09 | Boone | Missouri | 29019 | 24903 | 162 |
1798795 | 1798795 | 2021-10-09 | Boone | Nebraska | 31011 | 679 | 4 |
1800220 | 1800220 | 2021-10-09 | Boone | West Virginia | 54005 | 3313 | 45 |
1793985 | 1793985 | 2021-10-08 | Boone | Arkansas | 5009 | 6106 | 114 |
1794475 | 1794475 | 2021-10-08 | Boone | Illinois | 17007 | 7784 | 95 |
1794580 | 1794580 | 2021-10-08 | Boone | Indiana | 18011 | 8733 | 121 |
1794674 | 1794674 | 2021-10-08 | Boone | Iowa | 19015 | 3387 | 36 |
1794879 | 1794879 | 2021-10-08 | Boone | Kentucky | 21015 | 20026 | 197 |
1795377 | 1795377 | 2021-10-08 | Boone | Missouri | 29019 | 24903 | 162 |
1795546 | 1795546 | 2021-10-08 | Boone | Nebraska | 31011 | 679 | 4 |
1796971 | 1796971 | 2021-10-08 | Boone | West Virginia | 54005 | 3295 | 45 |
1790737 | 1790737 | 2021-10-07 | Boone | Arkansas | 5009 | 6096 | 114 |
1791227 | 1791227 | 2021-10-07 | Boone | Illinois | 17007 | 7765 | 95 |
1791332 | 1791332 | 2021-10-07 | Boone | Indiana | 18011 | 8706 | 121 |
1791426 | 1791426 | 2021-10-07 | Boone | Iowa | 19015 | 3387 | 36 |
1791631 | 1791631 | 2021-10-07 | Boone | Kentucky | 21015 | 19987 | 197 |
1792128 | 1792128 | 2021-10-07 | Boone | Missouri | 29019 | 24854 | 162 |
1792297 | 1792297 | 2021-10-07 | Boone | Nebraska | 31011 | 675 | 4 |
1793722 | 1793722 | 2021-10-07 | Boone | West Virginia | 54005 | 3275 | 43 |
1787488 | 1787488 | 2021-10-06 | Boone | Arkansas | 5009 | 6086 | 114 |
1787978 | 1787978 | 2021-10-06 | Boone | Illinois | 17007 | 7757 | 95 |
1788083 | 1788083 | 2021-10-06 | Boone | Indiana | 18011 | 8690 | 121 |
1788177 | 1788177 | 2021-10-06 | Boone | Iowa | 19015 | 3387 | 36 |
1788382 | 1788382 | 2021-10-06 | Boone | Kentucky | 21015 | 19890 | 194 |
1788879 | 1788879 | 2021-10-06 | Boone | Missouri | 29019 | 24804 | 160 |
1789048 | 1789048 | 2021-10-06 | Boone | Nebraska | 31011 | 671 | 4 |
1790473 | 1790473 | 2021-10-06 | Boone | West Virginia | 54005 | 3253 | 43 |
1784239 | 1784239 | 2021-10-05 | Boone | Arkansas | 5009 | 6073 | 114 |
1784729 | 1784729 | 2021-10-05 | Boone | Illinois | 17007 | 7738 | 95 |
1784834 | 1784834 | 2021-10-05 | Boone | Indiana | 18011 | 8661 | 120 |
1784928 | 1784928 | 2021-10-05 | Boone | Iowa | 19015 | 3290 | 36 |
1785133 | 1785133 | 2021-10-05 | Boone | Kentucky | 21015 | 19829 | 194 |
1785631 | 1785631 | 2021-10-05 | Boone | Missouri | 29019 | 24762 | 160 |
1785800 | 1785800 | 2021-10-05 | Boone | Nebraska | 31011 | 671 | 4 |
1787225 | 1787225 | 2021-10-05 | Boone | West Virginia | 54005 | 3225 | 42 |
1780990 | 1780990 | 2021-10-04 | Boone | Arkansas | 5009 | 6057 | 114 |
1781480 | 1781480 | 2021-10-04 | Boone | Illinois | 17007 | 7728 | 95 |
1781585 | 1781585 | 2021-10-04 | Boone | Indiana | 18011 | 8653 | 120 |
1781679 | 1781679 | 2021-10-04 | Boone | Iowa | 19015 | 3290 | 36 |
1781884 | 1781884 | 2021-10-04 | Boone | Kentucky | 21015 | 19721 | 194 |
1782382 | 1782382 | 2021-10-04 | Boone | Missouri | 29019 | 24712 | 155 |
1782551 | 1782551 | 2021-10-04 | Boone | Nebraska | 31011 | 671 | 4 |
1783976 | 1783976 | 2021-10-04 | Boone | West Virginia | 54005 | 3218 | 42 |
1777740 | 1777740 | 2021-10-03 | Boone | Arkansas | 5009 | 6054 | 114 |
1778230 | 1778230 | 2021-10-03 | Boone | Illinois | 17007 | 7709 | 95 |
1778335 | 1778335 | 2021-10-03 | Boone | Indiana | 18011 | 8607 | 118 |
1778429 | 1778429 | 2021-10-03 | Boone | Iowa | 19015 | 3290 | 36 |
1778634 | 1778634 | 2021-10-03 | Boone | Kentucky | 21015 | 19625 | 193 |
1779132 | 1779132 | 2021-10-03 | Boone | Missouri | 29019 | 24620 | 154 |
1779301 | 1779301 | 2021-10-03 | Boone | Nebraska | 31011 | 666 | 4 |
1780727 | 1780727 | 2021-10-03 | Boone | West Virginia | 54005 | 3204 | 42 |
1774490 | 1774490 | 2021-10-02 | Boone | Arkansas | 5009 | 6050 | 114 |
1774980 | 1774980 | 2021-10-02 | Boone | Illinois | 17007 | 7709 | 95 |
1775085 | 1775085 | 2021-10-02 | Boone | Indiana | 18011 | 8607 | 118 |
1775179 | 1775179 | 2021-10-02 | Boone | Iowa | 19015 | 3290 | 36 |
1775384 | 1775384 | 2021-10-02 | Boone | Kentucky | 21015 | 19625 | 193 |
1775882 | 1775882 | 2021-10-02 | Boone | Missouri | 29019 | 24620 | 154 |
1776051 | 1776051 | 2021-10-02 | Boone | Nebraska | 31011 | 666 | 4 |
1777477 | 1777477 | 2021-10-02 | Boone | West Virginia | 54005 | 3193 | 42 |
1771240 | 1771240 | 2021-10-01 | Boone | Arkansas | 5009 | 6033 | 114 |
1771730 | 1771730 | 2021-10-01 | Boone | Illinois | 17007 | 7709 | 95 |
1771835 | 1771835 | 2021-10-01 | Boone | Indiana | 18011 | 8607 | 118 |
1771929 | 1771929 | 2021-10-01 | Boone | Iowa | 19015 | 3290 | 36 |
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);