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,692 rows where county = "Adams" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Adams · 6,692 ✖
Link rowid date ▲ county state fips cases deaths
1816859 1816859 2021-10-15 Adams Colorado 8001 74724 867
1817173 1817173 2021-10-15 Adams Idaho 16003 492 9
1817216 1817216 2021-10-15 Adams Illinois 17001 13072 181
1817319 1817319 2021-10-15 Adams Indiana 18001 4798 74
1817412 1817412 2021-10-15 Adams Iowa 19003 498 4
1818030 1818030 2021-10-15 Adams Mississippi 28001 4570 119
1818285 1818285 2021-10-15 Adams Nebraska 31001 3837 54
1818620 1818620 2021-10-15 Adams North Dakota 38001 361 4
1818676 1818676 2021-10-15 Adams Ohio 39001 4092 87
1818879 1818879 2021-10-15 Adams Pennsylvania 42001 12709 211
1819674 1819674 2021-10-15 Adams Washington 53001 3156 29
1819768 1819768 2021-10-15 Adams Wisconsin 55001 2684 33
1813611 1813611 2021-10-14 Adams Colorado 8001 74013 861
1813925 1813925 2021-10-14 Adams Idaho 16003 490 9
1813968 1813968 2021-10-14 Adams Illinois 17001 13055 181
1814071 1814071 2021-10-14 Adams Indiana 18001 4784 74
1814164 1814164 2021-10-14 Adams Iowa 19003 498 4
1814781 1814781 2021-10-14 Adams Mississippi 28001 4570 119
1815036 1815036 2021-10-14 Adams Nebraska 31001 3829 54
1815371 1815371 2021-10-14 Adams North Dakota 38001 359 4
1815427 1815427 2021-10-14 Adams Ohio 39001 4077 83
1815630 1815630 2021-10-14 Adams Pennsylvania 42001 12652 210
1816425 1816425 2021-10-14 Adams Washington 53001 3150 29
1816519 1816519 2021-10-14 Adams Wisconsin 55001 2684 33
1810362 1810362 2021-10-13 Adams Colorado 8001 74013 861
1810676 1810676 2021-10-13 Adams Idaho 16003 485 9
1810719 1810719 2021-10-13 Adams Illinois 17001 13041 181
1810822 1810822 2021-10-13 Adams Indiana 18001 4772 74
1810915 1810915 2021-10-13 Adams Iowa 19003 498 4
1811533 1811533 2021-10-13 Adams Mississippi 28001 4567 119
1811788 1811788 2021-10-13 Adams Nebraska 31001 3825 54
1812123 1812123 2021-10-13 Adams North Dakota 38001 359 4
1812179 1812179 2021-10-13 Adams Ohio 39001 4050 83
1812382 1812382 2021-10-13 Adams Pennsylvania 42001 12601 210
1813177 1813177 2021-10-13 Adams Washington 53001 3131 29
1813271 1813271 2021-10-13 Adams Wisconsin 55001 2672 33
1807113 1807113 2021-10-12 Adams Colorado 8001 73788 859
1807427 1807427 2021-10-12 Adams Idaho 16003 483 8
1807470 1807470 2021-10-12 Adams Illinois 17001 13028 181
1807573 1807573 2021-10-12 Adams Indiana 18001 4735 74
1807666 1807666 2021-10-12 Adams Iowa 19003 482 4
1808284 1808284 2021-10-12 Adams Mississippi 28001 4563 119
1808539 1808539 2021-10-12 Adams Nebraska 31001 3820 54
1808874 1808874 2021-10-12 Adams North Dakota 38001 354 4
1808930 1808930 2021-10-12 Adams Ohio 39001 4028 83
1809133 1809133 2021-10-12 Adams Pennsylvania 42001 12544 206
1809928 1809928 2021-10-12 Adams Washington 53001 3126 28
1810022 1810022 2021-10-12 Adams Wisconsin 55001 2661 33
1803862 1803862 2021-10-11 Adams Colorado 8001 73788 859
1804176 1804176 2021-10-11 Adams Idaho 16003 472 7
1804219 1804219 2021-10-11 Adams Illinois 17001 12983 180
1804322 1804322 2021-10-11 Adams Indiana 18001 4731 73
1804415 1804415 2021-10-11 Adams Iowa 19003 482 4
1805033 1805033 2021-10-11 Adams Mississippi 28001 4537 119
1805288 1805288 2021-10-11 Adams Nebraska 31001 3799 54
1805623 1805623 2021-10-11 Adams North Dakota 38001 352 4
1805680 1805680 2021-10-11 Adams Ohio 39001 4012 82
1805883 1805883 2021-10-11 Adams Pennsylvania 42001 12505 206
1806679 1806679 2021-10-11 Adams Washington 53001 3119 28
1806773 1806773 2021-10-11 Adams Wisconsin 55001 2653 33
1800613 1800613 2021-10-10 Adams Colorado 8001 73451 857
1800927 1800927 2021-10-10 Adams Idaho 16003 472 7
1800970 1800970 2021-10-10 Adams Illinois 17001 12983 180
1801073 1801073 2021-10-10 Adams Indiana 18001 4706 72
1801166 1801166 2021-10-10 Adams Iowa 19003 482 4
1801784 1801784 2021-10-10 Adams Mississippi 28001 4528 119
1802039 1802039 2021-10-10 Adams Nebraska 31001 3799 54
1802374 1802374 2021-10-10 Adams North Dakota 38001 352 4
1802430 1802430 2021-10-10 Adams Ohio 39001 4001 82
1802633 1802633 2021-10-10 Adams Pennsylvania 42001 12469 206
1803428 1803428 2021-10-10 Adams Washington 53001 3107 28
1803522 1803522 2021-10-10 Adams Wisconsin 55001 2617 33
1797364 1797364 2021-10-09 Adams Colorado 8001 73256 856
1797678 1797678 2021-10-09 Adams Idaho 16003 473 8
1797721 1797721 2021-10-09 Adams Illinois 17001 12983 180
1797824 1797824 2021-10-09 Adams Indiana 18001 4706 72
1797917 1797917 2021-10-09 Adams Iowa 19003 482 4
1798535 1798535 2021-10-09 Adams Mississippi 28001 4528 119
1798790 1798790 2021-10-09 Adams Nebraska 31001 3799 54
1799125 1799125 2021-10-09 Adams North Dakota 38001 350 4
1799181 1799181 2021-10-09 Adams Ohio 39001 3989 82
1799384 1799384 2021-10-09 Adams Pennsylvania 42001 12449 206
1800179 1800179 2021-10-09 Adams Washington 53001 3107 28
1800273 1800273 2021-10-09 Adams Wisconsin 55001 2617 33
1794115 1794115 2021-10-08 Adams Colorado 8001 73256 856
1794429 1794429 2021-10-08 Adams Idaho 16003 471 8
1794472 1794472 2021-10-08 Adams Illinois 17001 12983 180
1794575 1794575 2021-10-08 Adams Indiana 18001 4706 72
1794668 1794668 2021-10-08 Adams Iowa 19003 482 4
1795286 1795286 2021-10-08 Adams Mississippi 28001 4528 119
1795541 1795541 2021-10-08 Adams Nebraska 31001 3799 54
1795876 1795876 2021-10-08 Adams North Dakota 38001 350 4
1795932 1795932 2021-10-08 Adams Ohio 39001 3984 82
1796135 1796135 2021-10-08 Adams Pennsylvania 42001 12398 206
1796930 1796930 2021-10-08 Adams Washington 53001 3107 28
1797024 1797024 2021-10-08 Adams Wisconsin 55001 2617 33
1790867 1790867 2021-10-07 Adams Colorado 8001 73068 856
1791181 1791181 2021-10-07 Adams Idaho 16003 468 8
1791224 1791224 2021-10-07 Adams Illinois 17001 12968 180
1791327 1791327 2021-10-07 Adams Indiana 18001 4688 71

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