ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,168 rows where county = "Scott" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Scott · 6,168 ✖
Link rowid date ▲ county state fips cases deaths
1816787 1816787 2021-10-15 Scott Arkansas 5127 1704 29
1817300 1817300 2021-10-15 Scott Illinois 17171 711 6
1817389 1817389 2021-10-15 Scott Indiana 18143 4346 70
1817492 1817492 2021-10-15 Scott Iowa 19163 24459 271
1817596 1817596 2021-10-15 Scott Kansas 20171 737 27
1817720 1817720 2021-10-15 Scott Kentucky 21209 8126 46
1818010 1818010 2021-10-15 Scott Minnesota 27139 21316 159
1818091 1818091 2021-10-15 Scott Mississippi 28123 4709 98
1818208 1818208 2021-10-15 Scott Missouri 29201 7082 111
1819218 1819218 2021-10-15 Scott Tennessee 47151 5066 58
1819653 1819653 2021-10-15 Scott Virginia 51169 2991 75
1813539 1813539 2021-10-14 Scott Arkansas 5127 1698 29
1814052 1814052 2021-10-14 Scott Illinois 17171 710 6
1814141 1814141 2021-10-14 Scott Indiana 18143 4336 70
1814244 1814244 2021-10-14 Scott Iowa 19163 24459 271
1814348 1814348 2021-10-14 Scott Kansas 20171 722 27
1814472 1814472 2021-10-14 Scott Kentucky 21209 8098 44
1814761 1814761 2021-10-14 Scott Minnesota 27139 21262 159
1814842 1814842 2021-10-14 Scott Mississippi 28123 4706 98
1814959 1814959 2021-10-14 Scott Missouri 29201 7068 111
1815969 1815969 2021-10-14 Scott Tennessee 47151 5043 58
1816404 1816404 2021-10-14 Scott Virginia 51169 2974 74
1810290 1810290 2021-10-13 Scott Arkansas 5127 1696 29
1810803 1810803 2021-10-13 Scott Illinois 17171 710 6
1810892 1810892 2021-10-13 Scott Indiana 18143 4328 70
1810995 1810995 2021-10-13 Scott Iowa 19163 24459 271
1811099 1811099 2021-10-13 Scott Kansas 20171 722 27
1811223 1811223 2021-10-13 Scott Kentucky 21209 8059 44
1811513 1811513 2021-10-13 Scott Minnesota 27139 21193 159
1811594 1811594 2021-10-13 Scott Mississippi 28123 4703 98
1811711 1811711 2021-10-13 Scott Missouri 29201 7051 111
1812721 1812721 2021-10-13 Scott Tennessee 47151 5030 57
1813156 1813156 2021-10-13 Scott Virginia 51169 2949 72
1807041 1807041 2021-10-12 Scott Arkansas 5127 1692 29
1807554 1807554 2021-10-12 Scott Illinois 17171 707 6
1807643 1807643 2021-10-12 Scott Indiana 18143 4319 70
1807746 1807746 2021-10-12 Scott Iowa 19163 24172 270
1807850 1807850 2021-10-12 Scott Kansas 20171 706 27
1807974 1807974 2021-10-12 Scott Kentucky 21209 7990 43
1808264 1808264 2021-10-12 Scott Minnesota 27139 21137 157
1808345 1808345 2021-10-12 Scott Mississippi 28123 4699 97
1808462 1808462 2021-10-12 Scott Missouri 29201 7032 111
1809472 1809472 2021-10-12 Scott Tennessee 47151 4981 54
1809907 1809907 2021-10-12 Scott Virginia 51169 2910 72
1803790 1803790 2021-10-11 Scott Arkansas 5127 1688 29
1804303 1804303 2021-10-11 Scott Illinois 17171 706 6
1804392 1804392 2021-10-11 Scott Indiana 18143 4314 70
1804495 1804495 2021-10-11 Scott Iowa 19163 24172 270
1804599 1804599 2021-10-11 Scott Kansas 20171 706 27
1804723 1804723 2021-10-11 Scott Kentucky 21209 7918 43
1805013 1805013 2021-10-11 Scott Minnesota 27139 20934 157
1805094 1805094 2021-10-11 Scott Mississippi 28123 4692 96
1805211 1805211 2021-10-11 Scott Missouri 29201 7031 111
1806222 1806222 2021-10-11 Scott Tennessee 47151 4955 54
1806657 1806657 2021-10-11 Scott Virginia 51169 2874 72
1800541 1800541 2021-10-10 Scott Arkansas 5127 1686 29
1801054 1801054 2021-10-10 Scott Illinois 17171 706 6
1801143 1801143 2021-10-10 Scott Indiana 18143 4292 70
1801246 1801246 2021-10-10 Scott Iowa 19163 24172 270
1801350 1801350 2021-10-10 Scott Kansas 20171 705 27
1801474 1801474 2021-10-10 Scott Kentucky 21209 7864 43
1801764 1801764 2021-10-10 Scott Minnesota 27139 20877 157
1801845 1801845 2021-10-10 Scott Mississippi 28123 4688 96
1801962 1801962 2021-10-10 Scott Missouri 29201 7027 111
1802972 1802972 2021-10-10 Scott Tennessee 47151 4931 54
1803407 1803407 2021-10-10 Scott Virginia 51169 2874 72
1797292 1797292 2021-10-09 Scott Arkansas 5127 1685 27
1797805 1797805 2021-10-09 Scott Illinois 17171 706 6
1797894 1797894 2021-10-09 Scott Indiana 18143 4292 70
1797997 1797997 2021-10-09 Scott Iowa 19163 24172 270
1798101 1798101 2021-10-09 Scott Kansas 20171 705 27
1798225 1798225 2021-10-09 Scott Kentucky 21209 7864 43
1798515 1798515 2021-10-09 Scott Minnesota 27139 20877 157
1798596 1798596 2021-10-09 Scott Mississippi 28123 4688 96
1798713 1798713 2021-10-09 Scott Missouri 29201 7023 111
1799723 1799723 2021-10-09 Scott Tennessee 47151 4931 54
1800158 1800158 2021-10-09 Scott Virginia 51169 2874 72
1794043 1794043 2021-10-08 Scott Arkansas 5127 1680 26
1794556 1794556 2021-10-08 Scott Illinois 17171 706 6
1794645 1794645 2021-10-08 Scott Indiana 18143 4292 70
1794748 1794748 2021-10-08 Scott Iowa 19163 24172 270
1794852 1794852 2021-10-08 Scott Kansas 20171 705 27
1794976 1794976 2021-10-08 Scott Kentucky 21209 7864 43
1795266 1795266 2021-10-08 Scott Minnesota 27139 20877 157
1795347 1795347 2021-10-08 Scott Mississippi 28123 4688 96
1795464 1795464 2021-10-08 Scott Missouri 29201 7014 111
1796474 1796474 2021-10-08 Scott Tennessee 47151 4931 54
1796909 1796909 2021-10-08 Scott Virginia 51169 2874 72
1790795 1790795 2021-10-07 Scott Arkansas 5127 1676 26
1791308 1791308 2021-10-07 Scott Illinois 17171 705 5
1791397 1791397 2021-10-07 Scott Indiana 18143 4269 70
1791500 1791500 2021-10-07 Scott Iowa 19163 24172 270
1791604 1791604 2021-10-07 Scott Kansas 20171 696 27
1791728 1791728 2021-10-07 Scott Kentucky 21209 7836 42
1792017 1792017 2021-10-07 Scott Minnesota 27139 20801 157
1792098 1792098 2021-10-07 Scott Mississippi 28123 4685 96
1792215 1792215 2021-10-07 Scott Missouri 29201 6992 111
1793225 1793225 2021-10-07 Scott Tennessee 47151 4917 54
1793660 1793660 2021-10-07 Scott Virginia 51169 2863 72
1787546 1787546 2021-10-06 Scott Arkansas 5127 1673 26

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);