ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
229 rows where cases = 2277 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 23
- Georgia 22
- Iowa 17
- Missouri 15
- Kansas 12
- Wisconsin 10
- Florida 9
- Michigan 9
- Texas 9
- Arkansas 8
- Illinois 7
- Kentucky 7
- Colorado 6
- Indiana 6
- Ohio 6
- Louisiana 5
- Tennessee 5
- Utah 5
- Pennsylvania 4
- Wyoming 4
- Connecticut 3
- Mississippi 3
- Montana 3
- North Carolina 3
- Puerto Rico 3
- West Virginia 3
- Alabama 2
- Maine 2
- Minnesota 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500051 | 2500051 | 2022-05-13 | Lanier | Georgia | 13173 | 2277 | 25 |
2496793 | 2496793 | 2022-05-12 | Lanier | Georgia | 13173 | 2277 | 25 |
2493535 | 2493535 | 2022-05-11 | Lanier | Georgia | 13173 | 2277 | 25 |
2492772 | 2492772 | 2022-05-10 | Essex | Virginia | 51057 | 2277 | 33 |
2486257 | 2486257 | 2022-05-08 | Essex | Virginia | 51057 | 2277 | 33 |
2482999 | 2482999 | 2022-05-07 | Essex | Virginia | 51057 | 2277 | 33 |
2479741 | 2479741 | 2022-05-06 | Essex | Virginia | 51057 | 2277 | 33 |
2460804 | 2460804 | 2022-05-01 | Unknown | Connecticut | 2277 | 2 | |
2457548 | 2457548 | 2022-04-30 | Unknown | Connecticut | 2277 | 2 | |
2454292 | 2454292 | 2022-04-29 | Unknown | Connecticut | 2277 | 2 | |
2405438 | 2405438 | 2022-04-14 | San Miguel | Colorado | 8113 | 2277 | 8 |
2375479 | 2375479 | 2022-04-04 | Grand | Utah | 49019 | 2277 | 6 |
2375592 | 2375592 | 2022-04-04 | Madison | Virginia | 51113 | 2277 | 38 |
2372340 | 2372340 | 2022-04-03 | Madison | Virginia | 51113 | 2277 | 38 |
2369087 | 2369087 | 2022-04-02 | Madison | Virginia | 51113 | 2277 | 38 |
2365834 | 2365834 | 2022-04-01 | Madison | Virginia | 51113 | 2277 | 38 |
2362581 | 2362581 | 2022-03-31 | Madison | Virginia | 51113 | 2277 | 38 |
2304446 | 2304446 | 2022-03-14 | Scott | Arkansas | 5127 | 2277 | 38 |
2301194 | 2301194 | 2022-03-13 | Scott | Arkansas | 5127 | 2277 | 38 |
2302312 | 2302312 | 2022-03-13 | Luce | Michigan | 26095 | 2277 | 11 |
2299060 | 2299060 | 2022-03-12 | Luce | Michigan | 26095 | 2277 | 11 |
2295808 | 2295808 | 2022-03-11 | Luce | Michigan | 26095 | 2277 | 11 |
2297344 | 2297344 | 2022-03-11 | Runnels | Texas | 48399 | 2277 | 64 |
2294092 | 2294092 | 2022-03-10 | Runnels | Texas | 48399 | 2277 | 64 |
2286053 | 2286053 | 2022-03-08 | Luce | Michigan | 26095 | 2277 | 10 |
2287573 | 2287573 | 2022-03-08 | Parmer | Texas | 48369 | 2277 | 52 |
2282801 | 2282801 | 2022-03-07 | Luce | Michigan | 26095 | 2277 | 10 |
2217263 | 2217263 | 2022-02-15 | Switzerland | Indiana | 18155 | 2277 | 16 |
2215698 | 2215698 | 2022-02-14 | Bon Homme | South Dakota | 46009 | 2277 | 37 |
2175806 | 2175806 | 2022-02-02 | Wayne | Missouri | 29223 | 2277 | 43 |
2146400 | 2146400 | 2022-01-24 | Tunica | Mississippi | 28143 | 2277 | 41 |
2144616 | 2144616 | 2022-01-23 | Clarke | Virginia | 51043 | 2277 | 35 |
2141361 | 2141361 | 2022-01-22 | Clarke | Virginia | 51043 | 2277 | 35 |
2138105 | 2138105 | 2022-01-21 | Clarke | Virginia | 51043 | 2277 | 35 |
2092017 | 2092017 | 2022-01-07 | San German | Puerto Rico | 72125 | 2277 | |
2087670 | 2087670 | 2022-01-06 | Missaukee | Michigan | 26113 | 2277 | 52 |
2084418 | 2084418 | 2022-01-05 | Missaukee | Michigan | 26113 | 2277 | 52 |
2080819 | 2080819 | 2022-01-04 | Marion | Kansas | 20115 | 2277 | 35 |
2077567 | 2077567 | 2022-01-03 | Marion | Kansas | 20115 | 2277 | 35 |
2036268 | 2036268 | 2021-12-21 | Yates | New York | 36123 | 2277 | 35 |
2033723 | 2033723 | 2021-12-20 | Stewart | Tennessee | 47161 | 2277 | 39 |
2008788 | 2008788 | 2021-12-13 | Dade | Georgia | 13083 | 2277 | 22 |
1983318 | 1983318 | 2021-12-05 | Osage | Kansas | 20139 | 2277 | 39 |
1980068 | 1980068 | 2021-12-04 | Osage | Kansas | 20139 | 2277 | 39 |
1976818 | 1976818 | 2021-12-03 | Osage | Kansas | 20139 | 2277 | 39 |
1965170 | 1965170 | 2021-11-29 | Potter | Pennsylvania | 42105 | 2277 | 60 |
1965873 | 1965873 | 2021-11-29 | Patrick | Virginia | 51141 | 2277 | 59 |
1937507 | 1937507 | 2021-11-21 | Massac | Illinois | 17127 | 2277 | 57 |
1938419 | 1938419 | 2021-11-21 | Osage | Missouri | 29151 | 2277 | 35 |
1934257 | 1934257 | 2021-11-20 | Massac | Illinois | 17127 | 2277 | 57 |
1931006 | 1931006 | 2021-11-19 | Massac | Illinois | 17127 | 2277 | 57 |
1928225 | 1928225 | 2021-11-18 | Caldwell | Louisiana | 22021 | 2277 | 39 |
1924975 | 1924975 | 2021-11-17 | Caldwell | Louisiana | 22021 | 2277 | 39 |
1920237 | 1920237 | 2021-11-15 | Millard | Utah | 49027 | 2277 | 25 |
1915717 | 1915717 | 2021-11-14 | Custer | Montana | 30017 | 2277 | 37 |
1916987 | 1916987 | 2021-11-14 | Millard | Utah | 49027 | 2277 | 25 |
1917197 | 1917197 | 2021-11-14 | Braxton | West Virginia | 54007 | 2277 | 22 |
1912467 | 1912467 | 2021-11-13 | Custer | Montana | 30017 | 2277 | 37 |
1913737 | 1913737 | 2021-11-13 | Millard | Utah | 49027 | 2277 | 25 |
1909217 | 1909217 | 2021-11-12 | Custer | Montana | 30017 | 2277 | 37 |
1910487 | 1910487 | 2021-11-12 | Millard | Utah | 49027 | 2277 | 25 |
1882625 | 1882625 | 2021-11-04 | Clinton | Kentucky | 21053 | 2277 | 35 |
1853546 | 1853546 | 2021-10-26 | Franklin | Maine | 23007 | 2277 | 25 |
1839341 | 1839341 | 2021-10-21 | Goshen | Wyoming | 56015 | 2277 | 36 |
1833643 | 1833643 | 2021-10-20 | Tipton | Indiana | 18159 | 2277 | 61 |
1835234 | 1835234 | 2021-10-20 | Las Piedras | Puerto Rico | 72085 | 2277 | |
1831500 | 1831500 | 2021-10-19 | Schoharie | New York | 36095 | 2277 | 21 |
1821367 | 1821367 | 2021-10-16 | Bates | Missouri | 29013 | 2277 | 42 |
1807761 | 1807761 | 2021-10-12 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1804510 | 1804510 | 2021-10-11 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1801261 | 1801261 | 2021-10-10 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1797162 | 1797162 | 2021-10-09 | Macon | Alabama | 1087 | 2277 | 61 |
1798012 | 1798012 | 2021-10-09 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1794763 | 1794763 | 2021-10-08 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1791515 | 1791515 | 2021-10-07 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1788266 | 1788266 | 2021-10-06 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1789370 | 1789370 | 2021-10-06 | Warren | North Carolina | 37185 | 2277 | 27 |
1780836 | 1780836 | 2021-10-03 | Sawyer | Wisconsin | 55113 | 2277 | 31 |
1777586 | 1777586 | 2021-10-02 | Sawyer | Wisconsin | 55113 | 2277 | 31 |
1774336 | 1774336 | 2021-10-01 | Sawyer | Wisconsin | 55113 | 2277 | 31 |
1765236 | 1765236 | 2021-09-29 | Carroll | Illinois | 17015 | 2277 | 38 |
1761461 | 1761461 | 2021-09-28 | North Slope Borough | Alaska | 2185 | 2277 | 5 |
1758118 | 1758118 | 2021-09-26 | Lincoln | Wyoming | 56023 | 2277 | 15 |
1754870 | 1754870 | 2021-09-25 | Lincoln | Wyoming | 56023 | 2277 | 15 |
1751622 | 1751622 | 2021-09-24 | Lincoln | Wyoming | 56023 | 2277 | 15 |
1732014 | 1732014 | 2021-09-18 | McDowell | West Virginia | 54047 | 2277 | 28 |
1722655 | 1722655 | 2021-09-16 | Elbert | Colorado | 8039 | 2277 | 18 |
1710339 | 1710339 | 2021-09-12 | Jefferson | Kansas | 20087 | 2277 | 44 |
1707092 | 1707092 | 2021-09-11 | Jefferson | Kansas | 20087 | 2277 | 44 |
1703844 | 1703844 | 2021-09-10 | Jefferson | Kansas | 20087 | 2277 | 44 |
1693981 | 1693981 | 2021-09-07 | Delaware | Iowa | 19055 | 2277 | 43 |
1695736 | 1695736 | 2021-09-07 | Lewis | Tennessee | 47101 | 2277 | 29 |
1690732 | 1690732 | 2021-09-06 | Delaware | Iowa | 19055 | 2277 | 43 |
1687482 | 1687482 | 2021-09-05 | Delaware | Iowa | 19055 | 2277 | 43 |
1684232 | 1684232 | 2021-09-04 | Delaware | Iowa | 19055 | 2277 | 43 |
1680981 | 1680981 | 2021-09-03 | Delaware | Iowa | 19055 | 2277 | 43 |
1677733 | 1677733 | 2021-09-02 | Delaware | Iowa | 19055 | 2277 | 43 |
1678018 | 1678018 | 2021-09-02 | Spencer | Kentucky | 21215 | 2277 | 26 |
1674486 | 1674486 | 2021-09-01 | Delaware | Iowa | 19055 | 2277 | 43 |
1676838 | 1676838 | 2021-09-01 | Green Lake | Wisconsin | 55047 | 2277 | 27 |
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);