ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
168 rows where cases = 3513 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 25
- Georgia 14
- Indiana 11
- North Carolina 9
- Texas 9
- Virginia 9
- Alabama 8
- Kentucky 7
- Minnesota 7
- Missouri 7
- Puerto Rico 6
- Florida 5
- Illinois 5
- Arkansas 4
- Mississippi 4
- New York 4
- Ohio 4
- Pennsylvania 4
- South Carolina 3
- West Virginia 3
- Wisconsin 3
- Idaho 2
- Michigan 2
- Tennessee 2
- California 1
- Colorado 1
- Maryland 1
- Montana 1
- Nebraska 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500423 | 2500423 | 2022-05-13 | Jefferson | Iowa | 19101 | 3513 | 51 |
2497165 | 2497165 | 2022-05-12 | Jefferson | Iowa | 19101 | 3513 | 51 |
2493907 | 2493907 | 2022-05-11 | Jefferson | Iowa | 19101 | 3513 | 51 |
2490649 | 2490649 | 2022-05-10 | Jefferson | Iowa | 19101 | 3513 | 51 |
2487392 | 2487392 | 2022-05-09 | Jefferson | Iowa | 19101 | 3513 | 51 |
2484134 | 2484134 | 2022-05-08 | Jefferson | Iowa | 19101 | 3513 | 51 |
2480876 | 2480876 | 2022-05-07 | Jefferson | Iowa | 19101 | 3513 | 51 |
2477618 | 2477618 | 2022-05-06 | Jefferson | Iowa | 19101 | 3513 | 51 |
2474360 | 2474360 | 2022-05-05 | Jefferson | Iowa | 19101 | 3513 | 51 |
2471103 | 2471103 | 2022-05-04 | Jefferson | Iowa | 19101 | 3513 | 51 |
2429290 | 2429290 | 2022-04-21 | Kanabec | Minnesota | 27065 | 3513 | 56 |
2396770 | 2396770 | 2022-04-11 | Sibley | Minnesota | 27143 | 3513 | 24 |
2378182 | 2378182 | 2022-04-05 | Anasco | Puerto Rico | 72011 | 3513 | |
2374928 | 2374928 | 2022-04-04 | Anasco | Puerto Rico | 72011 | 3513 | |
2365169 | 2365169 | 2022-04-01 | Aibonito | Puerto Rico | 72009 | 3513 | |
2301805 | 2301805 | 2022-03-13 | Tipton | Indiana | 18159 | 3513 | 87 |
2298553 | 2298553 | 2022-03-12 | Tipton | Indiana | 18159 | 3513 | 87 |
2295301 | 2295301 | 2022-03-11 | Tipton | Indiana | 18159 | 3513 | 87 |
2247028 | 2247028 | 2022-02-24 | Leelanau | Michigan | 26089 | 3513 | 50 |
2243777 | 2243777 | 2022-02-23 | Leelanau | Michigan | 26089 | 3513 | 50 |
2202612 | 2202612 | 2022-02-10 | Quebradillas | Puerto Rico | 72115 | 3513 | |
2194607 | 2194607 | 2022-02-08 | Wright | Iowa | 19197 | 3513 | 58 |
2191353 | 2191353 | 2022-02-07 | Wright | Iowa | 19197 | 3513 | 58 |
2188100 | 2188100 | 2022-02-06 | Wright | Iowa | 19197 | 3513 | 58 |
2184847 | 2184847 | 2022-02-05 | Wright | Iowa | 19197 | 3513 | 58 |
2181595 | 2181595 | 2022-02-04 | Wright | Iowa | 19197 | 3513 | 58 |
2178344 | 2178344 | 2022-02-03 | Wright | Iowa | 19197 | 3513 | 58 |
2175091 | 2175091 | 2022-02-02 | Wright | Iowa | 19197 | 3513 | 58 |
2159428 | 2159428 | 2022-01-28 | Bates | Missouri | 29013 | 3513 | 70 |
2142747 | 2142747 | 2022-01-23 | Morgan | Kentucky | 21175 | 3513 | 17 |
2139492 | 2139492 | 2022-01-22 | Morgan | Kentucky | 21175 | 3513 | 17 |
2136236 | 2136236 | 2022-01-21 | Morgan | Kentucky | 21175 | 3513 | 17 |
2133303 | 2133303 | 2022-01-20 | Wadena | Minnesota | 27159 | 3513 | 47 |
2131707 | 2131707 | 2022-01-19 | Asotin | Washington | 53003 | 3513 | 54 |
2126815 | 2126815 | 2022-01-18 | Clarke | Mississippi | 28023 | 3513 | 96 |
2128158 | 2128158 | 2022-01-18 | Lee | Texas | 48287 | 3513 | 55 |
2110764 | 2110764 | 2022-01-13 | Hill | Montana | 30041 | 3513 | 71 |
2107840 | 2107840 | 2022-01-12 | Madison | North Carolina | 37115 | 3513 | 68 |
2104022 | 2104022 | 2022-01-11 | Roseau | Minnesota | 27135 | 3513 | 37 |
2099408 | 2099408 | 2022-01-10 | Henry | Alabama | 1067 | 3513 | 67 |
2095641 | 2095641 | 2022-01-08 | Lavaca | Texas | 48285 | 3513 | 100 |
2076574 | 2076574 | 2022-01-02 | Sawyer | Wisconsin | 55113 | 3513 | 49 |
2073323 | 2073323 | 2022-01-01 | Sawyer | Wisconsin | 55113 | 3513 | 49 |
2070072 | 2070072 | 2021-12-31 | Sawyer | Wisconsin | 55113 | 3513 | 49 |
2018584 | 2018584 | 2021-12-16 | Lamar | Georgia | 13171 | 3513 | 99 |
2008069 | 2008069 | 2021-12-12 | Dinwiddie | Virginia | 51053 | 3513 | 60 |
2004818 | 2004818 | 2021-12-11 | Dinwiddie | Virginia | 51053 | 3513 | 60 |
2001567 | 2001567 | 2021-12-10 | Dinwiddie | Virginia | 51053 | 3513 | 60 |
1973003 | 1973003 | 2021-12-02 | Berrien | Georgia | 13019 | 3513 | 71 |
1973255 | 1973255 | 2021-12-02 | Lawrence | Illinois | 17101 | 3513 | 46 |
1969753 | 1969753 | 2021-12-01 | Berrien | Georgia | 13019 | 3513 | 71 |
1966503 | 1966503 | 2021-11-30 | Berrien | Georgia | 13019 | 3513 | 71 |
1965685 | 1965685 | 2021-11-29 | Scurry | Texas | 48415 | 3513 | 85 |
1925250 | 1925250 | 2021-11-17 | Wabasha | Minnesota | 27157 | 3513 | 9 |
1901207 | 1901207 | 2021-11-10 | Arkansas | Arkansas | 5001 | 3513 | 60 |
1875490 | 1875490 | 2021-11-02 | Appling | Georgia | 13001 | 3513 | 103 |
1856092 | 1856092 | 2021-10-27 | McDuffie | Georgia | 13189 | 3513 | 75 |
1853160 | 1853160 | 2021-10-26 | Boone | Iowa | 19015 | 3513 | 37 |
1849794 | 1849794 | 2021-10-25 | Shelby | Illinois | 17173 | 3513 | 52 |
1849911 | 1849911 | 2021-10-25 | Boone | Iowa | 19015 | 3513 | 37 |
1846661 | 1846661 | 2021-10-24 | Boone | Iowa | 19015 | 3513 | 37 |
1848623 | 1848623 | 2021-10-24 | Lampasas | Texas | 48281 | 3513 | 62 |
1843411 | 1843411 | 2021-10-23 | Boone | Iowa | 19015 | 3513 | 37 |
1845373 | 1845373 | 2021-10-23 | Lampasas | Texas | 48281 | 3513 | 62 |
1840161 | 1840161 | 2021-10-22 | Boone | Iowa | 19015 | 3513 | 37 |
1842176 | 1842176 | 2021-10-22 | Reeves | Texas | 48389 | 3513 | 53 |
1836912 | 1836912 | 2021-10-21 | Boone | Iowa | 19015 | 3513 | 37 |
1833663 | 1833663 | 2021-10-20 | Boone | Iowa | 19015 | 3513 | 37 |
1828683 | 1828683 | 2021-10-18 | Susquehanna | Pennsylvania | 42115 | 3513 | 66 |
1790774 | 1790774 | 2021-10-07 | Logan | Arkansas | 5083 | 3513 | 37 |
1792107 | 1792107 | 2021-10-07 | Tishomingo | Mississippi | 28141 | 3513 | 89 |
1783991 | 1783991 | 2021-10-04 | Jackson | West Virginia | 54035 | 3513 | 72 |
1767608 | 1767608 | 2021-09-29 | Halifax | Virginia | 51083 | 3513 | 96 |
1764325 | 1764325 | 2021-09-28 | Carroll | Virginia | 51035 | 3513 | 85 |
1758703 | 1758703 | 2021-09-27 | Cassia | Idaho | 16031 | 3513 | 31 |
1759610 | 1759610 | 2021-09-27 | Stone | Mississippi | 28131 | 3513 | 60 |
1749606 | 1749606 | 2021-09-24 | Queen Anne's | Maryland | 24035 | 3513 | 64 |
1744832 | 1744832 | 2021-09-22 | Caroline | Virginia | 51033 | 3513 | 44 |
1723052 | 1723052 | 2021-09-16 | McDonough | Illinois | 17109 | 3513 | 67 |
1705184 | 1705184 | 2021-09-10 | Clarion | Pennsylvania | 42031 | 3513 | 100 |
1672016 | 1672016 | 2021-08-31 | Stoddard | Missouri | 29207 | 3513 | 55 |
1645017 | 1645017 | 2021-08-23 | Latah | Idaho | 16057 | 3513 | 16 |
1641614 | 1641614 | 2021-08-22 | Dawson | Georgia | 13085 | 3513 | 50 |
1638364 | 1638364 | 2021-08-21 | Dawson | Georgia | 13085 | 3513 | 50 |
1635114 | 1635114 | 2021-08-20 | Dawson | Georgia | 13085 | 3513 | 50 |
1581341 | 1581341 | 2021-08-03 | Otsego | New York | 36077 | 3513 | 47 |
1578281 | 1578281 | 2021-08-02 | Champaign | Ohio | 39021 | 3513 | 60 |
1554247 | 1554247 | 2021-07-26 | Ripley | Indiana | 18137 | 3513 | 72 |
1542916 | 1542916 | 2021-07-22 | Clarendon | South Carolina | 45027 | 3513 | 114 |
1505779 | 1505779 | 2021-07-11 | Boyle | Kentucky | 21021 | 3513 | 78 |
1502533 | 1502533 | 2021-07-10 | Boyle | Kentucky | 21021 | 3513 | 78 |
1499287 | 1499287 | 2021-07-09 | Boyle | Kentucky | 21021 | 3513 | 78 |
1487264 | 1487264 | 2021-07-05 | Person | North Carolina | 37145 | 3513 | 71 |
1484018 | 1484018 | 2021-07-04 | Person | North Carolina | 37145 | 3513 | 71 |
1480772 | 1480772 | 2021-07-03 | Person | North Carolina | 37145 | 3513 | 71 |
1477525 | 1477525 | 2021-07-02 | Person | North Carolina | 37145 | 3513 | 71 |
1474215 | 1474215 | 2021-07-01 | Bladen | North Carolina | 37017 | 3513 | 47 |
1467665 | 1467665 | 2021-06-29 | Chenango | New York | 36017 | 3513 | 77 |
1421078 | 1421078 | 2021-06-15 | Adams | Indiana | 18001 | 3513 | 56 |
1417833 | 1417833 | 2021-06-14 | Adams | Indiana | 18001 | 3513 | 56 |
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);