ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
267 rows where cases = 2012 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Minnesota 22
- Arkansas 20
- Tennessee 15
- Kansas 14
- Kentucky 13
- Louisiana 11
- Pennsylvania 11
- Virginia 10
- Wisconsin 10
- Missouri 9
- West Virginia 9
- Georgia 8
- Illinois 8
- Indiana 8
- North Carolina 7
- South Dakota 7
- Colorado 6
- Michigan 6
- Ohio 6
- Alabama 4
- Idaho 4
- Puerto Rico 4
- South Carolina 4
- Mississippi 3
- Nebraska 3
- Oregon 3
- Maryland 2
- Montana 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497705 | 2497705 | 2022-05-12 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2494447 | 2494447 | 2022-05-11 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2491189 | 2491189 | 2022-05-10 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2476464 | 2476464 | 2022-05-05 | Buena Vista city | Virginia | 51530 | 2012 | 44 |
2467546 | 2467546 | 2022-05-03 | Wilcox | Georgia | 13315 | 2012 | 71 |
2469568 | 2469568 | 2022-05-03 | Hancock | Tennessee | 47067 | 2012 | 37 |
2469950 | 2469950 | 2022-05-03 | Buena Vista city | Virginia | 51530 | 2012 | 44 |
2464291 | 2464291 | 2022-05-02 | Wilcox | Georgia | 13315 | 2012 | 71 |
2466312 | 2466312 | 2022-05-02 | Hancock | Tennessee | 47067 | 2012 | 37 |
2466895 | 2466895 | 2022-05-02 | Tucker | West Virginia | 54093 | 2012 | 38 |
2463057 | 2463057 | 2022-05-01 | Hancock | Tennessee | 47067 | 2012 | 37 |
2459801 | 2459801 | 2022-04-30 | Hancock | Tennessee | 47067 | 2012 | 37 |
2456545 | 2456545 | 2022-04-29 | Hancock | Tennessee | 47067 | 2012 | 37 |
2453289 | 2453289 | 2022-04-28 | Hancock | Tennessee | 47067 | 2012 | 37 |
2450033 | 2450033 | 2022-04-27 | Hancock | Tennessee | 47067 | 2012 | 37 |
2301944 | 2301944 | 2022-03-13 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2298692 | 2298692 | 2022-03-12 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2295440 | 2295440 | 2022-03-11 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2292188 | 2292188 | 2022-03-10 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2288936 | 2288936 | 2022-03-09 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2285685 | 2285685 | 2022-03-08 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2282433 | 2282433 | 2022-03-07 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2282888 | 2282888 | 2022-03-07 | Murray | Minnesota | 27101 | 2012 | 15 |
2279180 | 2279180 | 2022-03-06 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2279635 | 2279635 | 2022-03-06 | Murray | Minnesota | 27101 | 2012 | 15 |
2275927 | 2275927 | 2022-03-05 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2276382 | 2276382 | 2022-03-05 | Murray | Minnesota | 27101 | 2012 | 15 |
2272674 | 2272674 | 2022-03-04 | Ellsworth | Kansas | 20053 | 2012 | 31 |
2273129 | 2273129 | 2022-03-04 | Murray | Minnesota | 27101 | 2012 | 15 |
2269877 | 2269877 | 2022-03-03 | Murray | Minnesota | 27101 | 2012 | 15 |
2270073 | 2270073 | 2022-03-03 | Oregon | Missouri | 29149 | 2012 | 32 |
2264474 | 2264474 | 2022-03-01 | Custer | South Dakota | 46033 | 2012 | 22 |
2246308 | 2246308 | 2022-02-24 | Boundary | Idaho | 16021 | 2012 | 57 |
2240609 | 2240609 | 2022-02-22 | Marshall | Minnesota | 27089 | 2012 | 23 |
2206777 | 2206777 | 2022-02-12 | Perry | Alabama | 1105 | 2012 | 41 |
2197755 | 2197755 | 2022-02-09 | Warren | Indiana | 18171 | 2012 | 24 |
2199455 | 2199455 | 2022-02-09 | Grant | South Dakota | 46051 | 2012 | 49 |
2199631 | 2199631 | 2022-02-09 | Clay | Texas | 48077 | 2012 | 27 |
2200076 | 2200076 | 2022-02-09 | Doddridge | West Virginia | 54017 | 2012 | 16 |
2194501 | 2194501 | 2022-02-08 | Warren | Indiana | 18171 | 2012 | 24 |
2173573 | 2173573 | 2022-02-01 | Archer | Texas | 48009 | 2012 | 24 |
2165596 | 2165596 | 2022-01-30 | Red River | Louisiana | 22081 | 2012 | 49 |
2162341 | 2162341 | 2022-01-29 | Red River | Louisiana | 22081 | 2012 | 49 |
2159086 | 2159086 | 2022-01-28 | Red River | Louisiana | 22081 | 2012 | 49 |
2131468 | 2131468 | 2022-01-19 | Runnels | Texas | 48399 | 2012 | 57 |
2124655 | 2124655 | 2022-01-17 | Roberts | South Dakota | 46109 | 2012 | 45 |
2125025 | 2125025 | 2022-01-17 | Emery | Utah | 49015 | 2012 | 25 |
2121403 | 2121403 | 2022-01-16 | Roberts | South Dakota | 46109 | 2012 | 45 |
2118151 | 2118151 | 2022-01-15 | Roberts | South Dakota | 46109 | 2012 | 45 |
2114900 | 2114900 | 2022-01-14 | Roberts | South Dakota | 46109 | 2012 | 45 |
2099067 | 2099067 | 2022-01-09 | Brunswick | Virginia | 51025 | 2012 | 36 |
2095816 | 2095816 | 2022-01-08 | Brunswick | Virginia | 51025 | 2012 | 36 |
2092564 | 2092564 | 2022-01-07 | Brunswick | Virginia | 51025 | 2012 | 36 |
2060491 | 2060491 | 2021-12-29 | Desha | Arkansas | 5041 | 2012 | 35 |
2037792 | 2037792 | 2021-12-22 | Stone | Arkansas | 5137 | 2012 | 47 |
2034611 | 2034611 | 2021-12-21 | Archuleta | Colorado | 8007 | 2012 | 9 |
2017550 | 2017550 | 2021-12-15 | Duval | Texas | 48131 | 2012 | 60 |
1967176 | 1967176 | 2021-11-30 | Lyon | Kentucky | 21143 | 2012 | 26 |
1951235 | 1951235 | 2021-11-25 | Pope | Minnesota | 27121 | 2012 | 10 |
1947984 | 1947984 | 2021-11-24 | Pope | Minnesota | 27121 | 2012 | 10 |
1938144 | 1938144 | 2021-11-21 | Missaukee | Michigan | 26113 | 2012 | 41 |
1934894 | 1934894 | 2021-11-20 | Missaukee | Michigan | 26113 | 2012 | 41 |
1931644 | 1931644 | 2021-11-19 | Missaukee | Michigan | 26113 | 2012 | 41 |
1905308 | 1905308 | 2021-11-11 | Nemaha | Kansas | 20131 | 2012 | 56 |
1902058 | 1902058 | 2021-11-10 | Nemaha | Kansas | 20131 | 2012 | 56 |
1904008 | 1904008 | 2021-11-10 | Caledonia | Vermont | 50005 | 2012 | 20 |
1892685 | 1892685 | 2021-11-07 | Chippewa | Minnesota | 27023 | 2012 | 40 |
1889435 | 1889435 | 2021-11-06 | Chippewa | Minnesota | 27023 | 2012 | 40 |
1886185 | 1886185 | 2021-11-05 | Chippewa | Minnesota | 27023 | 2012 | 40 |
1882936 | 1882936 | 2021-11-04 | Chippewa | Minnesota | 27023 | 2012 | 40 |
1853370 | 1853370 | 2021-10-26 | Breathitt | Kentucky | 21025 | 2012 | 29 |
1851229 | 1851229 | 2021-10-25 | Noble | Ohio | 39121 | 2012 | 47 |
1851763 | 1851763 | 2021-10-25 | Camp | Texas | 48063 | 2012 | 65 |
1848513 | 1848513 | 2021-10-24 | Camp | Texas | 48063 | 2012 | 65 |
1833956 | 1833956 | 2021-10-20 | Pendleton | Kentucky | 21191 | 2012 | 17 |
1835435 | 1835435 | 2021-10-20 | Lake | Tennessee | 47095 | 2012 | 31 |
1831959 | 1831959 | 2021-10-19 | Cayey | Puerto Rico | 72035 | 2012 | |
1790558 | 1790558 | 2021-10-06 | Lafayette | Wisconsin | 55065 | 2012 | 12 |
1786696 | 1786696 | 2021-10-05 | Jackson | Tennessee | 47087 | 2012 | 39 |
1779009 | 1779009 | 2021-10-03 | Pennington | Minnesota | 27113 | 2012 | 22 |
1775759 | 1775759 | 2021-10-02 | Pennington | Minnesota | 27113 | 2012 | 22 |
1772509 | 1772509 | 2021-10-01 | Pennington | Minnesota | 27113 | 2012 | 22 |
1768146 | 1768146 | 2021-09-30 | Grand | Colorado | 8049 | 2012 | 10 |
1738059 | 1738059 | 2021-09-20 | Comanche | Texas | 48093 | 2012 | 56 |
1734809 | 1734809 | 2021-09-19 | Comanche | Texas | 48093 | 2012 | 56 |
1731559 | 1731559 | 2021-09-18 | Comanche | Texas | 48093 | 2012 | 56 |
1719609 | 1719609 | 2021-09-15 | Jasper | Georgia | 13159 | 2012 | 47 |
1722254 | 1722254 | 2021-09-15 | Hardy | West Virginia | 54031 | 2012 | 25 |
1708961 | 1708961 | 2021-09-11 | Pecos | Texas | 48371 | 2012 | 40 |
1700178 | 1700178 | 2021-09-09 | Telfair | Georgia | 13271 | 2012 | 61 |
1694472 | 1694472 | 2021-09-07 | Roscommon | Michigan | 26143 | 2012 | 57 |
1695958 | 1695958 | 2021-09-07 | Nolan | Texas | 48353 | 2012 | 56 |
1696367 | 1696367 | 2021-09-07 | Sawyer | Wisconsin | 55113 | 2012 | 29 |
1692710 | 1692710 | 2021-09-06 | Nolan | Texas | 48353 | 2012 | 56 |
1693119 | 1693119 | 2021-09-06 | Sawyer | Wisconsin | 55113 | 2012 | 29 |
1689461 | 1689461 | 2021-09-05 | Nolan | Texas | 48353 | 2012 | 56 |
1686211 | 1686211 | 2021-09-04 | Nolan | Texas | 48353 | 2012 | 56 |
1677808 | 1677808 | 2021-09-02 | Atchison | Kansas | 20005 | 2012 | 22 |
1674561 | 1674561 | 2021-09-01 | Atchison | Kansas | 20005 | 2012 | 22 |
1665832 | 1665832 | 2021-08-29 | Bertie | North Carolina | 37015 | 2012 | 46 |
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);