ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
281 rows where cases = 1833 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 29
- Georgia 28
- Florida 21
- Virginia 17
- Indiana 15
- Kansas 11
- Oklahoma 11
- Illinois 10
- Michigan 10
- Puerto Rico 9
- Kentucky 8
- Minnesota 8
- Montana 8
- Alabama 7
- Idaho 7
- Iowa 7
- Arkansas 6
- Louisiana 6
- Ohio 5
- West Virginia 5
- Wisconsin 5
- Colorado 4
- Mississippi 4
- Missouri 4
- North Carolina 4
- Maine 3
- Maryland 3
- New Mexico 3
- Oregon 3
- Pennsylvania 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2408248 | 2408248 | 2022-04-14 | Calhoun | West Virginia | 54013 | 1833 | 13 |
2404992 | 2404992 | 2022-04-13 | Calhoun | West Virginia | 54013 | 1833 | 13 |
2388449 | 2388449 | 2022-04-08 | Stephens | Texas | 48429 | 1833 | 45 |
2385169 | 2385169 | 2022-04-07 | Rains | Texas | 48379 | 1833 | 59 |
2385194 | 2385194 | 2022-04-07 | Stephens | Texas | 48429 | 1833 | 45 |
2381914 | 2381914 | 2022-04-06 | Rains | Texas | 48379 | 1833 | 59 |
2381939 | 2381939 | 2022-04-06 | Stephens | Texas | 48429 | 1833 | 45 |
2378659 | 2378659 | 2022-04-05 | Rains | Texas | 48379 | 1833 | 59 |
2378684 | 2378684 | 2022-04-05 | Stephens | Texas | 48429 | 1833 | 45 |
2375405 | 2375405 | 2022-04-04 | Rains | Texas | 48379 | 1833 | 59 |
2372153 | 2372153 | 2022-04-03 | Rains | Texas | 48379 | 1833 | 59 |
2325077 | 2325077 | 2022-03-20 | Lake | Michigan | 26085 | 1833 | 37 |
2321823 | 2321823 | 2022-03-19 | Lake | Michigan | 26085 | 1833 | 37 |
2318569 | 2318569 | 2022-03-18 | Lake | Michigan | 26085 | 1833 | 37 |
2315316 | 2315316 | 2022-03-17 | Lake | Michigan | 26085 | 1833 | 37 |
2312063 | 2312063 | 2022-03-16 | Lake | Michigan | 26085 | 1833 | 37 |
2267189 | 2267189 | 2022-03-02 | Gates | North Carolina | 37073 | 1833 | 19 |
2268121 | 2268121 | 2022-03-02 | Winkler | Texas | 48495 | 1833 | 34 |
2264868 | 2264868 | 2022-03-01 | Winkler | Texas | 48495 | 1833 | 34 |
2261618 | 2261618 | 2022-02-28 | Winkler | Texas | 48495 | 1833 | 34 |
2258367 | 2258367 | 2022-02-27 | Winkler | Texas | 48495 | 1833 | 34 |
2255116 | 2255116 | 2022-02-26 | Winkler | Texas | 48495 | 1833 | 34 |
2251865 | 2251865 | 2022-02-25 | Winkler | Texas | 48495 | 1833 | 34 |
2248614 | 2248614 | 2022-02-24 | Winkler | Texas | 48495 | 1833 | 34 |
2194691 | 2194691 | 2022-02-08 | Russell | Kansas | 20167 | 1833 | 36 |
2191437 | 2191437 | 2022-02-07 | Russell | Kansas | 20167 | 1833 | 36 |
2187671 | 2187671 | 2022-02-06 | Irwin | Georgia | 13155 | 1833 | 42 |
2184418 | 2184418 | 2022-02-05 | Irwin | Georgia | 13155 | 1833 | 42 |
2181166 | 2181166 | 2022-02-04 | Irwin | Georgia | 13155 | 1833 | 42 |
2166276 | 2166276 | 2022-01-30 | Sierra | New Mexico | 35051 | 1833 | 69 |
2163021 | 2163021 | 2022-01-29 | Sierra | New Mexico | 35051 | 1833 | 69 |
2159766 | 2159766 | 2022-01-28 | Sierra | New Mexico | 35051 | 1833 | 69 |
2155580 | 2155580 | 2022-01-27 | Clay | Kansas | 20027 | 1833 | 32 |
2157874 | 2157874 | 2022-01-27 | Pepin | Wisconsin | 55091 | 1833 | 16 |
2152327 | 2152327 | 2022-01-26 | Clay | Kansas | 20027 | 1833 | 32 |
2149763 | 2149763 | 2022-01-25 | St. Clair | Missouri | 29185 | 1833 | 29 |
2147636 | 2147636 | 2022-01-24 | Hamilton | Texas | 48193 | 1833 | 29 |
2148025 | 2148025 | 2022-01-24 | Gilmer | West Virginia | 54021 | 1833 | 17 |
2137779 | 2137779 | 2022-01-21 | Archer | Texas | 48009 | 1833 | 24 |
2125894 | 2125894 | 2022-01-18 | Pulaski | Georgia | 13235 | 1833 | 68 |
2081189 | 2081189 | 2022-01-04 | Unknown | Michigan | 1833 | 10 | |
2073941 | 2073941 | 2022-01-02 | Franklin | Idaho | 16041 | 1833 | 27 |
2076395 | 2076395 | 2022-01-02 | Richmond | Virginia | 51159 | 1833 | 17 |
2070690 | 2070690 | 2022-01-01 | Franklin | Idaho | 16041 | 1833 | 27 |
2073144 | 2073144 | 2022-01-01 | Richmond | Virginia | 51159 | 1833 | 17 |
2067439 | 2067439 | 2021-12-31 | Franklin | Idaho | 16041 | 1833 | 27 |
2069893 | 2069893 | 2021-12-31 | Richmond | Virginia | 51159 | 1833 | 17 |
2064188 | 2064188 | 2021-12-30 | Franklin | Idaho | 16041 | 1833 | 27 |
2056215 | 2056215 | 2021-12-27 | Coamo | Puerto Rico | 72043 | 1833 | |
2038127 | 2038127 | 2021-12-22 | Screven | Georgia | 13251 | 1833 | 62 |
2030155 | 2030155 | 2021-12-19 | Forest | Pennsylvania | 42053 | 1833 | 31 |
2015388 | 2015388 | 2021-12-15 | Towns | Georgia | 13281 | 1833 | 84 |
2012137 | 2012137 | 2021-12-14 | Towns | Georgia | 13281 | 1833 | 84 |
2012674 | 2012674 | 2021-12-14 | Lee | Kentucky | 21129 | 1833 | 39 |
2009982 | 2009982 | 2021-12-13 | Dawson | Montana | 30021 | 1833 | 50 |
2006731 | 2006731 | 2021-12-12 | Dawson | Montana | 30021 | 1833 | 50 |
2003480 | 2003480 | 2021-12-11 | Dawson | Montana | 30021 | 1833 | 50 |
2000230 | 2000230 | 2021-12-10 | Dawson | Montana | 30021 | 1833 | 50 |
1995868 | 1995868 | 2021-12-09 | Screven | Georgia | 13251 | 1833 | 62 |
1996617 | 1996617 | 2021-12-09 | Crawford | Michigan | 26039 | 1833 | 20 |
1992617 | 1992617 | 2021-12-08 | Screven | Georgia | 13251 | 1833 | 62 |
1993366 | 1993366 | 2021-12-08 | Crawford | Michigan | 26039 | 1833 | 20 |
1989366 | 1989366 | 2021-12-07 | Screven | Georgia | 13251 | 1833 | 62 |
1990215 | 1990215 | 2021-12-07 | Koochiching | Minnesota | 27071 | 1833 | 25 |
1963211 | 1963211 | 2021-11-29 | Liberty | Florida | 12077 | 1833 | 23 |
1959960 | 1959960 | 2021-11-28 | Liberty | Florida | 12077 | 1833 | 23 |
1956709 | 1956709 | 2021-11-27 | Liberty | Florida | 12077 | 1833 | 23 |
1953458 | 1953458 | 2021-11-26 | Liberty | Florida | 12077 | 1833 | 23 |
1950207 | 1950207 | 2021-11-25 | Liberty | Florida | 12077 | 1833 | 23 |
1946956 | 1946956 | 2021-11-24 | Liberty | Florida | 12077 | 1833 | 23 |
1943705 | 1943705 | 2021-11-23 | Liberty | Florida | 12077 | 1833 | 23 |
1940455 | 1940455 | 2021-11-22 | Liberty | Florida | 12077 | 1833 | 23 |
1937205 | 1937205 | 2021-11-21 | Liberty | Florida | 12077 | 1833 | 23 |
1933955 | 1933955 | 2021-11-20 | Liberty | Florida | 12077 | 1833 | 23 |
1930361 | 1930361 | 2021-11-19 | Coosa | Alabama | 1037 | 1833 | 44 |
1930703 | 1930703 | 2021-11-19 | Liberty | Florida | 12077 | 1833 | 23 |
1927343 | 1927343 | 2021-11-18 | Bent | Colorado | 8011 | 1833 | 31 |
1927453 | 1927453 | 2021-11-18 | Liberty | Florida | 12077 | 1833 | 23 |
1924203 | 1924203 | 2021-11-17 | Liberty | Florida | 12077 | 1833 | 23 |
1920954 | 1920954 | 2021-11-16 | Liberty | Florida | 12077 | 1833 | 23 |
1921260 | 1921260 | 2021-11-16 | Menard | Illinois | 17129 | 1833 | 18 |
1917704 | 1917704 | 2021-11-15 | Liberty | Florida | 12077 | 1833 | 23 |
1914454 | 1914454 | 2021-11-14 | Liberty | Florida | 12077 | 1833 | 23 |
1917036 | 1917036 | 2021-11-14 | Brunswick | Virginia | 51025 | 1833 | 33 |
1911204 | 1911204 | 2021-11-13 | Liberty | Florida | 12077 | 1833 | 23 |
1913786 | 1913786 | 2021-11-13 | Brunswick | Virginia | 51025 | 1833 | 33 |
1907955 | 1907955 | 2021-11-12 | Liberty | Florida | 12077 | 1833 | 23 |
1910536 | 1910536 | 2021-11-12 | Brunswick | Virginia | 51025 | 1833 | 33 |
1861090 | 1861090 | 2021-10-28 | Curry | Oregon | 41015 | 1833 | 25 |
1833629 | 1833629 | 2021-10-20 | Pulaski | Indiana | 18131 | 1833 | 57 |
1827554 | 1827554 | 2021-10-18 | Knox | Maine | 23013 | 1833 | 12 |
1824305 | 1824305 | 2021-10-17 | Knox | Maine | 23013 | 1833 | 12 |
1825148 | 1825148 | 2021-10-17 | Mountrail | North Dakota | 38061 | 1833 | 25 |
1821056 | 1821056 | 2021-10-16 | Knox | Maine | 23013 | 1833 | 12 |
1813805 | 1813805 | 2021-10-14 | Early | Georgia | 13099 | 1833 | 57 |
1793601 | 1793601 | 2021-10-07 | Greensville | Virginia | 51081 | 1833 | 25 |
1785654 | 1785654 | 2021-10-05 | Dent | Missouri | 29065 | 1833 | 36 |
1779282 | 1779282 | 2021-10-03 | Roosevelt | Montana | 30085 | 1833 | 57 |
1776032 | 1776032 | 2021-10-02 | Roosevelt | Montana | 30085 | 1833 | 57 |
1772782 | 1772782 | 2021-10-01 | Roosevelt | Montana | 30085 | 1833 | 57 |
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);