ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
520 rows where cases = 814 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 43
- Texas 42
- Georgia 38
- Pennsylvania 28
- Kentucky 25
- Virginia 24
- Iowa 22
- Nebraska 22
- Puerto Rico 18
- Wisconsin 18
- North Dakota 17
- Arkansas 16
- Michigan 16
- Oklahoma 16
- Missouri 15
- Kansas 14
- Illinois 11
- Indiana 11
- Louisiana 10
- Minnesota 9
- Ohio 9
- Vermont 9
- Alaska 8
- Tennessee 8
- Mississippi 7
- Montana 7
- New Jersey 7
- South Carolina 7
- Idaho 6
- Alabama 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479594 | 2479594 | 2022-05-06 | Real | Texas | 48385 | 814 | 25 |
2476336 | 2476336 | 2022-05-05 | Real | Texas | 48385 | 814 | 25 |
2473079 | 2473079 | 2022-05-04 | Real | Texas | 48385 | 814 | 25 |
2469823 | 2469823 | 2022-05-03 | Real | Texas | 48385 | 814 | 25 |
2466567 | 2466567 | 2022-05-02 | Real | Texas | 48385 | 814 | 25 |
2439432 | 2439432 | 2022-04-24 | Nance | Nebraska | 31125 | 814 | 12 |
2436176 | 2436176 | 2022-04-23 | Nance | Nebraska | 31125 | 814 | 12 |
2432920 | 2432920 | 2022-04-22 | Nance | Nebraska | 31125 | 814 | 12 |
2394398 | 2394398 | 2022-04-10 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2391142 | 2391142 | 2022-04-09 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2387886 | 2387886 | 2022-04-08 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2384631 | 2384631 | 2022-04-07 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2381376 | 2381376 | 2022-04-06 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2378121 | 2378121 | 2022-04-05 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2374867 | 2374867 | 2022-04-04 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2371615 | 2371615 | 2022-04-03 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2368362 | 2368362 | 2022-04-02 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2365109 | 2365109 | 2022-04-01 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2361856 | 2361856 | 2022-03-31 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2358602 | 2358602 | 2022-03-30 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2355348 | 2355348 | 2022-03-29 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2352095 | 2352095 | 2022-03-28 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2348843 | 2348843 | 2022-03-27 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2345590 | 2345590 | 2022-03-26 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2342337 | 2342337 | 2022-03-25 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2339084 | 2339084 | 2022-03-24 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2335830 | 2335830 | 2022-03-23 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2332576 | 2332576 | 2022-03-22 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2329323 | 2329323 | 2022-03-21 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2323862 | 2323862 | 2022-03-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 814 | 1 |
2326071 | 2326071 | 2022-03-20 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2320608 | 2320608 | 2022-03-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 814 | 1 |
2322818 | 2322818 | 2022-03-19 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2317354 | 2317354 | 2022-03-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 814 | 1 |
2319564 | 2319564 | 2022-03-18 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2316310 | 2316310 | 2022-03-17 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2313057 | 2313057 | 2022-03-16 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2296533 | 2296533 | 2022-03-11 | Cavalier | North Dakota | 38019 | 814 | 7 |
2293281 | 2293281 | 2022-03-10 | Cavalier | North Dakota | 38019 | 814 | 7 |
2290029 | 2290029 | 2022-03-09 | Cavalier | North Dakota | 38019 | 814 | 7 |
2244515 | 2244515 | 2022-02-23 | Hettinger | North Dakota | 38041 | 814 | 7 |
2241264 | 2241264 | 2022-02-22 | Hettinger | North Dakota | 38041 | 814 | 7 |
2238013 | 2238013 | 2022-02-21 | Hettinger | North Dakota | 38041 | 814 | 7 |
2234762 | 2234762 | 2022-02-20 | Hettinger | North Dakota | 38041 | 814 | 7 |
2231511 | 2231511 | 2022-02-19 | Hettinger | North Dakota | 38041 | 814 | 7 |
2228260 | 2228260 | 2022-02-18 | Hettinger | North Dakota | 38041 | 814 | 7 |
2219325 | 2219325 | 2022-02-15 | Sutton | Texas | 48435 | 814 | 12 |
2198977 | 2198977 | 2022-02-09 | Bowman | North Dakota | 38011 | 814 | 9 |
2178354 | 2178354 | 2022-02-03 | Chautauqua | Kansas | 20019 | 814 | 16 |
2175101 | 2175101 | 2022-02-02 | Chautauqua | Kansas | 20019 | 814 | 16 |
2111840 | 2111840 | 2022-01-13 | Garza | Texas | 48169 | 814 | 25 |
2088630 | 2088630 | 2022-01-06 | Wallowa | Oregon | 41063 | 814 | 13 |
2086292 | 2086292 | 2022-01-05 | Florence | Wisconsin | 55037 | 814 | 15 |
2077154 | 2077154 | 2022-01-03 | Warren | Georgia | 13301 | 814 | 26 |
2073903 | 2073903 | 2022-01-02 | Warren | Georgia | 13301 | 814 | 26 |
2070652 | 2070652 | 2022-01-01 | Warren | Georgia | 13301 | 814 | 26 |
2067401 | 2067401 | 2021-12-31 | Warren | Georgia | 13301 | 814 | 26 |
2058866 | 2058866 | 2021-12-28 | Thayer | Nebraska | 31169 | 814 | 8 |
2053571 | 2053571 | 2021-12-26 | Cumberland | Virginia | 51049 | 814 | 19 |
2050321 | 2050321 | 2021-12-25 | Cumberland | Virginia | 51049 | 814 | 19 |
2047071 | 2047071 | 2021-12-24 | Cumberland | Virginia | 51049 | 814 | 19 |
2029565 | 2029565 | 2021-12-19 | Furnas | Nebraska | 31065 | 814 | 6 |
2026314 | 2026314 | 2021-12-18 | Furnas | Nebraska | 31065 | 814 | 6 |
2023063 | 2023063 | 2021-12-17 | Furnas | Nebraska | 31065 | 814 | 6 |
1997744 | 1997744 | 2021-12-09 | Penuelas | Puerto Rico | 72111 | 814 | |
1974278 | 1974278 | 2021-12-02 | Boone | Nebraska | 31011 | 814 | 4 |
1971858 | 1971858 | 2021-12-01 | Lyman | South Dakota | 46085 | 814 | 11 |
1968121 | 1968121 | 2021-11-30 | Dunn | North Dakota | 38025 | 814 | 7 |
1943910 | 1943910 | 2021-11-23 | Boise | Idaho | 16015 | 814 | 11 |
1944313 | 1944313 | 2021-11-23 | Ottawa | Kansas | 20143 | 814 | 14 |
1941063 | 1941063 | 2021-11-22 | Ottawa | Kansas | 20143 | 814 | 14 |
1929751 | 1929751 | 2021-11-18 | Carson | Texas | 48065 | 814 | 24 |
1926501 | 1926501 | 2021-11-17 | Carson | Texas | 48065 | 814 | 24 |
1922336 | 1922336 | 2021-11-16 | Polk | Nebraska | 31143 | 814 | 18 |
1919086 | 1919086 | 2021-11-15 | Polk | Nebraska | 31143 | 814 | 18 |
1915072 | 1915072 | 2021-11-14 | Rooks | Kansas | 20163 | 814 | 13 |
1911822 | 1911822 | 2021-11-13 | Rooks | Kansas | 20163 | 814 | 13 |
1908573 | 1908573 | 2021-11-12 | Rooks | Kansas | 20163 | 814 | 13 |
1898789 | 1898789 | 2021-11-09 | Kearny | Kansas | 20093 | 814 | 14 |
1895539 | 1895539 | 2021-11-08 | Kearny | Kansas | 20093 | 814 | 14 |
1896336 | 1896336 | 2021-11-08 | Pierce | Nebraska | 31139 | 814 | 21 |
1897686 | 1897686 | 2021-11-08 | Skamania | Washington | 53059 | 814 | 7 |
1876467 | 1876467 | 2021-11-02 | Lincoln | Minnesota | 27081 | 814 | 5 |
1869598 | 1869598 | 2021-10-31 | Washington | Kansas | 20201 | 814 | 17 |
1866349 | 1866349 | 2021-10-30 | Washington | Kansas | 20201 | 814 | 17 |
1863100 | 1863100 | 2021-10-29 | Washington | Kansas | 20201 | 814 | 17 |
1859841 | 1859841 | 2021-10-28 | Sherman | Kansas | 20181 | 814 | 13 |
1856592 | 1856592 | 2021-10-27 | Sherman | Kansas | 20181 | 814 | 13 |
1844979 | 1844979 | 2021-10-23 | Lajas | Puerto Rico | 72079 | 814 | |
1841729 | 1841729 | 2021-10-22 | Lajas | Puerto Rico | 72079 | 814 | |
1830299 | 1830299 | 2021-10-19 | Stark | Illinois | 17175 | 814 | 28 |
1811837 | 1811837 | 2021-10-13 | Kearney | Nebraska | 31099 | 814 | 6 |
1801738 | 1801738 | 2021-10-10 | Mahnomen | Minnesota | 27087 | 814 | 11 |
1798489 | 1798489 | 2021-10-09 | Mahnomen | Minnesota | 27087 | 814 | 11 |
1795240 | 1795240 | 2021-10-08 | Mahnomen | Minnesota | 27087 | 814 | 11 |
1768023 | 1768023 | 2021-09-30 | Lafayette | Arkansas | 5073 | 814 | 12 |
1769162 | 1769162 | 2021-09-30 | Lake | Michigan | 26085 | 814 | 18 |
1765389 | 1765389 | 2021-09-29 | Ohio | Indiana | 18115 | 814 | 11 |
1765913 | 1765913 | 2021-09-29 | Lake | Michigan | 26085 | 814 | 18 |
1757672 | 1757672 | 2021-09-26 | Mills | Texas | 48333 | 814 | 26 |
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);