ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
248 rows where cases = 2310 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 30
- Georgia 22
- Colorado 17
- Virginia 16
- Missouri 15
- North Carolina 12
- Michigan 11
- Iowa 10
- Indiana 8
- Mississippi 8
- Ohio 8
- Alabama 6
- Idaho 6
- Kentucky 6
- Puerto Rico 6
- Illinois 5
- Nebraska 5
- Oklahoma 5
- Arkansas 4
- Minnesota 4
- Oregon 4
- Utah 4
- West Virginia 4
- California 3
- South Carolina 3
- Tennessee 3
- Washington 3
- Louisiana 2
- Montana 2
- New Jersey 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501317 | 2501317 | 2022-05-13 | Phelps | Nebraska | 31137 | 2310 | 14 |
2501523 | 2501523 | 2022-05-13 | Graham | North Carolina | 37075 | 2310 | 31 |
2498059 | 2498059 | 2022-05-12 | Phelps | Nebraska | 31137 | 2310 | 14 |
2498265 | 2498265 | 2022-05-12 | Graham | North Carolina | 37075 | 2310 | 31 |
2494801 | 2494801 | 2022-05-11 | Phelps | Nebraska | 31137 | 2310 | 14 |
2495007 | 2495007 | 2022-05-11 | Graham | North Carolina | 37075 | 2310 | 31 |
2495289 | 2495289 | 2022-05-11 | Unknown | Oklahoma | 2310 | 0 | |
2492031 | 2492031 | 2022-05-10 | Unknown | Oklahoma | 2310 | 0 | |
2483588 | 2483588 | 2022-05-08 | San Miguel | Colorado | 8113 | 2310 | 8 |
2480330 | 2480330 | 2022-05-07 | San Miguel | Colorado | 8113 | 2310 | 8 |
2477072 | 2477072 | 2022-05-06 | San Miguel | Colorado | 8113 | 2310 | 8 |
2473814 | 2473814 | 2022-05-05 | San Miguel | Colorado | 8113 | 2310 | 8 |
2473828 | 2473828 | 2022-05-05 | Unknown | Connecticut | 2310 | 1 | |
2444783 | 2444783 | 2022-04-26 | Clearwater | Idaho | 16035 | 2310 | 33 |
2441527 | 2441527 | 2022-04-25 | Clearwater | Idaho | 16035 | 2310 | 33 |
2424677 | 2424677 | 2022-04-20 | Bullock | Alabama | 1011 | 2310 | 54 |
2417735 | 2417735 | 2022-04-17 | Runnels | Texas | 48399 | 2310 | 66 |
2414479 | 2414479 | 2022-04-16 | Runnels | Texas | 48399 | 2310 | 66 |
2411223 | 2411223 | 2022-04-15 | Runnels | Texas | 48399 | 2310 | 66 |
2407967 | 2407967 | 2022-04-14 | Runnels | Texas | 48399 | 2310 | 66 |
2353850 | 2353850 | 2022-03-29 | Switzerland | Indiana | 18155 | 2310 | 20 |
2304023 | 2304023 | 2022-03-13 | Lunenburg | Virginia | 51111 | 2310 | 31 |
2300771 | 2300771 | 2022-03-12 | Lunenburg | Virginia | 51111 | 2310 | 31 |
2297519 | 2297519 | 2022-03-11 | Lunenburg | Virginia | 51111 | 2310 | 31 |
2266640 | 2266640 | 2022-03-02 | Rock | Minnesota | 27133 | 2310 | 33 |
2266871 | 2266871 | 2022-03-02 | Dawson | Montana | 30021 | 2310 | 54 |
2263672 | 2263672 | 2022-03-01 | Box Butte | Nebraska | 31013 | 2310 | 17 |
2260421 | 2260421 | 2022-02-28 | Box Butte | Nebraska | 31013 | 2310 | 17 |
2246341 | 2246341 | 2022-02-24 | Washington | Idaho | 16087 | 2310 | 56 |
2244992 | 2244992 | 2022-02-23 | Lake | South Dakota | 46079 | 2310 | 27 |
2220261 | 2220261 | 2022-02-16 | Towns | Georgia | 13281 | 2310 | 97 |
2195268 | 2195268 | 2022-02-08 | Linn | Missouri | 29115 | 2310 | 61 |
2179808 | 2179808 | 2022-02-03 | Florida | Puerto Rico | 72054 | 2310 | |
2177172 | 2177172 | 2022-02-02 | Galax city | Virginia | 51640 | 2310 | 72 |
2159430 | 2159430 | 2022-01-28 | Bollinger | Missouri | 29017 | 2310 | 35 |
2157049 | 2157049 | 2022-01-27 | Luquillo | Puerto Rico | 72089 | 2310 | |
2157524 | 2157524 | 2022-01-27 | Trinity | Texas | 48455 | 2310 | 67 |
2152904 | 2152904 | 2022-01-26 | Tunica | Mississippi | 28143 | 2310 | 41 |
2150199 | 2150199 | 2022-01-25 | Mercer | North Dakota | 38057 | 2310 | 22 |
2075593 | 2075593 | 2022-01-02 | Baker | Oregon | 41001 | 2310 | 36 |
2072342 | 2072342 | 2022-01-01 | Baker | Oregon | 41001 | 2310 | 36 |
2069091 | 2069091 | 2021-12-31 | Baker | Oregon | 41001 | 2310 | 36 |
2065840 | 2065840 | 2021-12-30 | Baker | Oregon | 41001 | 2310 | 36 |
2061514 | 2061514 | 2021-12-29 | Madison | Louisiana | 22065 | 2310 | 55 |
2053304 | 2053304 | 2021-12-26 | Eastland | Texas | 48133 | 2310 | 88 |
2050054 | 2050054 | 2021-12-25 | Eastland | Texas | 48133 | 2310 | 88 |
2046804 | 2046804 | 2021-12-24 | Eastland | Texas | 48133 | 2310 | 88 |
2041362 | 2041362 | 2021-12-23 | Oglethorpe | Georgia | 13221 | 2310 | 43 |
2043554 | 2043554 | 2021-12-23 | Eastland | Texas | 48133 | 2310 | 88 |
2015140 | 2015140 | 2021-12-15 | Las Animas | Colorado | 8071 | 2310 | 29 |
1971729 | 1971729 | 2021-12-01 | Las Piedras | Puerto Rico | 72085 | 2310 | |
1965328 | 1965328 | 2021-11-29 | Clay | South Dakota | 46027 | 2310 | 17 |
1938327 | 1938327 | 2021-11-21 | Tallahatchie | Mississippi | 28135 | 2310 | 52 |
1939737 | 1939737 | 2021-11-21 | Millard | Utah | 49027 | 2310 | 27 |
1935077 | 1935077 | 2021-11-20 | Tallahatchie | Mississippi | 28135 | 2310 | 52 |
1936487 | 1936487 | 2021-11-20 | Millard | Utah | 49027 | 2310 | 27 |
1931827 | 1931827 | 2021-11-19 | Tallahatchie | Mississippi | 28135 | 2310 | 52 |
1933237 | 1933237 | 2021-11-19 | Millard | Utah | 49027 | 2310 | 27 |
1930280 | 1930280 | 2021-11-18 | Lafayette | Wisconsin | 55065 | 2310 | 12 |
1922121 | 1922121 | 2021-11-16 | Dallas | Missouri | 29059 | 2310 | 43 |
1913955 | 1913955 | 2021-11-13 | Grant | West Virginia | 54023 | 2310 | 34 |
1898260 | 1898260 | 2021-11-09 | Charlton | Georgia | 13049 | 2310 | 55 |
1899772 | 1899772 | 2021-11-09 | Chowan | North Carolina | 37041 | 2310 | 42 |
1896522 | 1896522 | 2021-11-08 | Chowan | North Carolina | 37041 | 2310 | 42 |
1894322 | 1894322 | 2021-11-07 | Giles | Virginia | 51071 | 2310 | 31 |
1891072 | 1891072 | 2021-11-06 | Giles | Virginia | 51071 | 2310 | 31 |
1887822 | 1887822 | 2021-11-05 | Giles | Virginia | 51071 | 2310 | 31 |
1858891 | 1858891 | 2021-10-28 | Lamar | Alabama | 1075 | 2310 | 48 |
1857109 | 1857109 | 2021-10-27 | Bates | Missouri | 29013 | 2310 | 43 |
1852272 | 1852272 | 2021-10-25 | Crawford | Wisconsin | 55023 | 2310 | 22 |
1837463 | 1837463 | 2021-10-21 | Houston | Minnesota | 27055 | 2310 | 17 |
1830503 | 1830503 | 2021-10-19 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1827254 | 1827254 | 2021-10-18 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1823514 | 1823514 | 2021-10-17 | Bleckley | Georgia | 13023 | 2310 | 68 |
1824005 | 1824005 | 2021-10-17 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1826122 | 1826122 | 2021-10-17 | New Kent | Virginia | 51127 | 2310 | 22 |
1820265 | 1820265 | 2021-10-16 | Bleckley | Georgia | 13023 | 2310 | 68 |
1820756 | 1820756 | 2021-10-16 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1822873 | 1822873 | 2021-10-16 | New Kent | Virginia | 51127 | 2310 | 22 |
1817016 | 1817016 | 2021-10-15 | Bleckley | Georgia | 13023 | 2310 | 68 |
1817507 | 1817507 | 2021-10-15 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1819624 | 1819624 | 2021-10-15 | New Kent | Virginia | 51127 | 2310 | 22 |
1814259 | 1814259 | 2021-10-14 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1811010 | 1811010 | 2021-10-13 | Winneshiek | Iowa | 19191 | 2310 | 37 |
1805615 | 1805615 | 2021-10-11 | Warren | North Carolina | 37185 | 2310 | 27 |
1777883 | 1777883 | 2021-10-03 | Crowley | Colorado | 8025 | 2310 | 20 |
1778919 | 1778919 | 2021-10-03 | Manistee | Michigan | 26101 | 2310 | 33 |
1774633 | 1774633 | 2021-10-02 | Crowley | Colorado | 8025 | 2310 | 20 |
1775669 | 1775669 | 2021-10-02 | Manistee | Michigan | 26101 | 2310 | 33 |
1777299 | 1777299 | 2021-10-02 | Windsor | Vermont | 50027 | 2310 | 25 |
1771383 | 1771383 | 2021-10-01 | Crowley | Colorado | 8025 | 2310 | 20 |
1772419 | 1772419 | 2021-10-01 | Manistee | Michigan | 26101 | 2310 | 33 |
1772727 | 1772727 | 2021-10-01 | Ste. Genevieve | Missouri | 29186 | 2310 | 29 |
1765323 | 1765323 | 2021-09-29 | Warren | Illinois | 17187 | 2310 | 66 |
1763756 | 1763756 | 2021-09-28 | Manati | Puerto Rico | 72091 | 2310 | |
1755172 | 1755172 | 2021-09-26 | Otero | Colorado | 8089 | 2310 | 72 |
1751924 | 1751924 | 2021-09-25 | Otero | Colorado | 8089 | 2310 | 72 |
1748675 | 1748675 | 2021-09-24 | Otero | Colorado | 8089 | 2310 | 72 |
1744985 | 1744985 | 2021-09-22 | Barbour | West Virginia | 54001 | 2310 | 40 |
1739716 | 1739716 | 2021-09-21 | Mason | Kentucky | 21161 | 2310 | 47 |
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);