ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,478 rows where county = "Scott" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1788059 | 1788059 | 2021-10-06 | Scott | Illinois | 17171 | 704 | 5 |
1788148 | 1788148 | 2021-10-06 | Scott | Indiana | 18143 | 4258 | 70 |
1788251 | 1788251 | 2021-10-06 | Scott | Iowa | 19163 | 24172 | 270 |
1788355 | 1788355 | 2021-10-06 | Scott | Kansas | 20171 | 696 | 27 |
1788479 | 1788479 | 2021-10-06 | Scott | Kentucky | 21209 | 7795 | 42 |
1788768 | 1788768 | 2021-10-06 | Scott | Minnesota | 27139 | 20760 | 156 |
1788849 | 1788849 | 2021-10-06 | Scott | Mississippi | 28123 | 4669 | 96 |
1788966 | 1788966 | 2021-10-06 | Scott | Missouri | 29201 | 6971 | 111 |
1789976 | 1789976 | 2021-10-06 | Scott | Tennessee | 47151 | 4896 | 54 |
1790411 | 1790411 | 2021-10-06 | Scott | Virginia | 51169 | 2855 | 72 |
1784297 | 1784297 | 2021-10-05 | Scott | Arkansas | 5127 | 1670 | 26 |
1784810 | 1784810 | 2021-10-05 | Scott | Illinois | 17171 | 704 | 5 |
1784899 | 1784899 | 2021-10-05 | Scott | Indiana | 18143 | 4247 | 70 |
1785002 | 1785002 | 2021-10-05 | Scott | Iowa | 19163 | 23799 | 266 |
1785106 | 1785106 | 2021-10-05 | Scott | Kansas | 20171 | 688 | 27 |
1785230 | 1785230 | 2021-10-05 | Scott | Kentucky | 21209 | 7736 | 42 |
1785520 | 1785520 | 2021-10-05 | Scott | Minnesota | 27139 | 20634 | 153 |
1785601 | 1785601 | 2021-10-05 | Scott | Mississippi | 28123 | 4664 | 96 |
1785718 | 1785718 | 2021-10-05 | Scott | Missouri | 29201 | 6946 | 111 |
1786728 | 1786728 | 2021-10-05 | Scott | Tennessee | 47151 | 4878 | 54 |
1787163 | 1787163 | 2021-10-05 | Scott | Virginia | 51169 | 2836 | 72 |
1781048 | 1781048 | 2021-10-04 | Scott | Arkansas | 5127 | 1668 | 25 |
1781561 | 1781561 | 2021-10-04 | Scott | Illinois | 17171 | 703 | 5 |
1781650 | 1781650 | 2021-10-04 | Scott | Indiana | 18143 | 4234 | 69 |
1781753 | 1781753 | 2021-10-04 | Scott | Iowa | 19163 | 23799 | 266 |
1781857 | 1781857 | 2021-10-04 | Scott | Kansas | 20171 | 688 | 27 |
1781981 | 1781981 | 2021-10-04 | Scott | Kentucky | 21209 | 7713 | 42 |
1782271 | 1782271 | 2021-10-04 | Scott | Minnesota | 27139 | 20491 | 152 |
1782352 | 1782352 | 2021-10-04 | Scott | Mississippi | 28123 | 4662 | 96 |
1782469 | 1782469 | 2021-10-04 | Scott | Missouri | 29201 | 6938 | 110 |
1783479 | 1783479 | 2021-10-04 | Scott | Tennessee | 47151 | 4865 | 54 |
1783914 | 1783914 | 2021-10-04 | Scott | Virginia | 51169 | 2820 | 71 |
1777798 | 1777798 | 2021-10-03 | Scott | Arkansas | 5127 | 1667 | 25 |
1778311 | 1778311 | 2021-10-03 | Scott | Illinois | 17171 | 702 | 5 |
1778400 | 1778400 | 2021-10-03 | Scott | Indiana | 18143 | 4202 | 67 |
1778503 | 1778503 | 2021-10-03 | Scott | Iowa | 19163 | 23799 | 266 |
1778607 | 1778607 | 2021-10-03 | Scott | Kansas | 20171 | 688 | 27 |
1778731 | 1778731 | 2021-10-03 | Scott | Kentucky | 21209 | 7644 | 40 |
1779021 | 1779021 | 2021-10-03 | Scott | Minnesota | 27139 | 20438 | 152 |
1779102 | 1779102 | 2021-10-03 | Scott | Mississippi | 28123 | 4652 | 96 |
1779219 | 1779219 | 2021-10-03 | Scott | Missouri | 29201 | 6936 | 110 |
1780230 | 1780230 | 2021-10-03 | Scott | Tennessee | 47151 | 4827 | 54 |
1780665 | 1780665 | 2021-10-03 | Scott | Virginia | 51169 | 2755 | 71 |
1774548 | 1774548 | 2021-10-02 | Scott | Arkansas | 5127 | 1665 | 25 |
1775061 | 1775061 | 2021-10-02 | Scott | Illinois | 17171 | 702 | 5 |
1775150 | 1775150 | 2021-10-02 | Scott | Indiana | 18143 | 4202 | 67 |
1775253 | 1775253 | 2021-10-02 | Scott | Iowa | 19163 | 23799 | 266 |
1775357 | 1775357 | 2021-10-02 | Scott | Kansas | 20171 | 688 | 27 |
1775481 | 1775481 | 2021-10-02 | Scott | Kentucky | 21209 | 7644 | 40 |
1775771 | 1775771 | 2021-10-02 | Scott | Minnesota | 27139 | 20438 | 152 |
1775852 | 1775852 | 2021-10-02 | Scott | Mississippi | 28123 | 4652 | 96 |
1775969 | 1775969 | 2021-10-02 | Scott | Missouri | 29201 | 6933 | 110 |
1776980 | 1776980 | 2021-10-02 | Scott | Tennessee | 47151 | 4827 | 54 |
1777415 | 1777415 | 2021-10-02 | Scott | Virginia | 51169 | 2755 | 71 |
1771298 | 1771298 | 2021-10-01 | Scott | Arkansas | 5127 | 1664 | 25 |
1771811 | 1771811 | 2021-10-01 | Scott | Illinois | 17171 | 702 | 5 |
1771900 | 1771900 | 2021-10-01 | Scott | Indiana | 18143 | 4202 | 67 |
1772003 | 1772003 | 2021-10-01 | Scott | Iowa | 19163 | 23799 | 266 |
1772107 | 1772107 | 2021-10-01 | Scott | Kansas | 20171 | 688 | 27 |
1772231 | 1772231 | 2021-10-01 | Scott | Kentucky | 21209 | 7644 | 40 |
1772521 | 1772521 | 2021-10-01 | Scott | Minnesota | 27139 | 20438 | 152 |
1772602 | 1772602 | 2021-10-01 | Scott | Mississippi | 28123 | 4652 | 96 |
1772719 | 1772719 | 2021-10-01 | Scott | Missouri | 29201 | 6921 | 110 |
1773730 | 1773730 | 2021-10-01 | Scott | Tennessee | 47151 | 4827 | 54 |
1774165 | 1774165 | 2021-10-01 | Scott | Virginia | 51169 | 2755 | 71 |
1768049 | 1768049 | 2021-09-30 | Scott | Arkansas | 5127 | 1655 | 25 |
1768562 | 1768562 | 2021-09-30 | Scott | Illinois | 17171 | 701 | 5 |
1768651 | 1768651 | 2021-09-30 | Scott | Indiana | 18143 | 4186 | 67 |
1768754 | 1768754 | 2021-09-30 | Scott | Iowa | 19163 | 23799 | 266 |
1768858 | 1768858 | 2021-09-30 | Scott | Kansas | 20171 | 684 | 27 |
1768982 | 1768982 | 2021-09-30 | Scott | Kentucky | 21209 | 7571 | 40 |
1769272 | 1769272 | 2021-09-30 | Scott | Minnesota | 27139 | 20371 | 151 |
1769353 | 1769353 | 2021-09-30 | Scott | Mississippi | 28123 | 4644 | 96 |
1769470 | 1769470 | 2021-09-30 | Scott | Missouri | 29201 | 6902 | 110 |
1770480 | 1770480 | 2021-09-30 | Scott | Tennessee | 47151 | 4807 | 54 |
1770915 | 1770915 | 2021-09-30 | Scott | Virginia | 51169 | 2740 | 70 |
1764800 | 1764800 | 2021-09-29 | Scott | Arkansas | 5127 | 1655 | 25 |
1765313 | 1765313 | 2021-09-29 | Scott | Illinois | 17171 | 701 | 5 |
1765402 | 1765402 | 2021-09-29 | Scott | Indiana | 18143 | 4173 | 67 |
1765505 | 1765505 | 2021-09-29 | Scott | Iowa | 19163 | 23799 | 266 |
1765609 | 1765609 | 2021-09-29 | Scott | Kansas | 20171 | 684 | 27 |
1765733 | 1765733 | 2021-09-29 | Scott | Kentucky | 21209 | 7510 | 40 |
1766023 | 1766023 | 2021-09-29 | Scott | Minnesota | 27139 | 20316 | 151 |
1766104 | 1766104 | 2021-09-29 | Scott | Mississippi | 28123 | 4630 | 96 |
1766221 | 1766221 | 2021-09-29 | Scott | Missouri | 29201 | 6871 | 110 |
1767231 | 1767231 | 2021-09-29 | Scott | Tennessee | 47151 | 4783 | 54 |
1767666 | 1767666 | 2021-09-29 | Scott | Virginia | 51169 | 2713 | 70 |
1761551 | 1761551 | 2021-09-28 | Scott | Arkansas | 5127 | 1651 | 25 |
1762064 | 1762064 | 2021-09-28 | Scott | Illinois | 17171 | 700 | 5 |
1762153 | 1762153 | 2021-09-28 | Scott | Indiana | 18143 | 4156 | 67 |
1762256 | 1762256 | 2021-09-28 | Scott | Iowa | 19163 | 23329 | 265 |
1762360 | 1762360 | 2021-09-28 | Scott | Kansas | 20171 | 682 | 27 |
1762484 | 1762484 | 2021-09-28 | Scott | Kentucky | 21209 | 7424 | 40 |
1762774 | 1762774 | 2021-09-28 | Scott | Minnesota | 27139 | 20259 | 146 |
1762855 | 1762855 | 2021-09-28 | Scott | Mississippi | 28123 | 4621 | 96 |
1762972 | 1762972 | 2021-09-28 | Scott | Missouri | 29201 | 6845 | 110 |
1763982 | 1763982 | 2021-09-28 | Scott | Tennessee | 47151 | 4754 | 54 |
1764417 | 1764417 | 2021-09-28 | Scott | Virginia | 51169 | 2689 | 68 |
1758303 | 1758303 | 2021-09-27 | Scott | Arkansas | 5127 | 1644 | 24 |
1758816 | 1758816 | 2021-09-27 | Scott | Illinois | 17171 | 698 | 5 |
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);