ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
384 rows where cases = 1491 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 44
- Iowa 27
- Kentucky 23
- Illinois 22
- Missouri 20
- Virginia 19
- North Dakota 17
- Puerto Rico 15
- Alabama 14
- Texas 14
- Minnesota 13
- Colorado 10
- North Carolina 10
- South Dakota 10
- Tennessee 10
- Arkansas 9
- Maine 9
- Oregon 8
- New York 7
- West Virginia 7
- Florida 6
- Ohio 6
- Washington 6
- Indiana 5
- Mississippi 5
- Virgin Islands 5
- Louisiana 4
- Utah 4
- Alaska 3
- Massachusetts 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2407183 | 2407183 | 2022-04-14 | Ransom | North Dakota | 38073 | 1491 | 28 |
2403263 | 2403263 | 2022-04-13 | Norman | Minnesota | 27107 | 1491 | 13 |
2403927 | 2403927 | 2022-04-13 | Ransom | North Dakota | 38073 | 1491 | 28 |
2400009 | 2400009 | 2022-04-12 | Norman | Minnesota | 27107 | 1491 | 13 |
2400672 | 2400672 | 2022-04-12 | Ransom | North Dakota | 38073 | 1491 | 28 |
2396753 | 2396753 | 2022-04-11 | Norman | Minnesota | 27107 | 1491 | 13 |
2397417 | 2397417 | 2022-04-11 | Ransom | North Dakota | 38073 | 1491 | 28 |
2393498 | 2393498 | 2022-04-10 | Norman | Minnesota | 27107 | 1491 | 13 |
2394162 | 2394162 | 2022-04-10 | Ransom | North Dakota | 38073 | 1491 | 28 |
2390242 | 2390242 | 2022-04-09 | Norman | Minnesota | 27107 | 1491 | 13 |
2390906 | 2390906 | 2022-04-09 | Ransom | North Dakota | 38073 | 1491 | 28 |
2386986 | 2386986 | 2022-04-08 | Norman | Minnesota | 27107 | 1491 | 13 |
2387650 | 2387650 | 2022-04-08 | Ransom | North Dakota | 38073 | 1491 | 28 |
2383731 | 2383731 | 2022-04-07 | Norman | Minnesota | 27107 | 1491 | 13 |
2384395 | 2384395 | 2022-04-07 | Ransom | North Dakota | 38073 | 1491 | 28 |
2381140 | 2381140 | 2022-04-06 | Ransom | North Dakota | 38073 | 1491 | 28 |
2377885 | 2377885 | 2022-04-05 | Ransom | North Dakota | 38073 | 1491 | 28 |
2374632 | 2374632 | 2022-04-04 | Ransom | North Dakota | 38073 | 1491 | 28 |
2371380 | 2371380 | 2022-04-03 | Ransom | North Dakota | 38073 | 1491 | 28 |
2368127 | 2368127 | 2022-04-02 | Ransom | North Dakota | 38073 | 1491 | 28 |
2364874 | 2364874 | 2022-04-01 | Ransom | North Dakota | 38073 | 1491 | 28 |
2339897 | 2339897 | 2022-03-24 | Skamania | Washington | 53059 | 1491 | 12 |
2336644 | 2336644 | 2022-03-23 | Skamania | Washington | 53059 | 1491 | 12 |
2302537 | 2302537 | 2022-03-13 | Carter | Missouri | 29035 | 1491 | 21 |
2299285 | 2299285 | 2022-03-12 | Carter | Missouri | 29035 | 1491 | 21 |
2296033 | 2296033 | 2022-03-11 | Carter | Missouri | 29035 | 1491 | 21 |
2292781 | 2292781 | 2022-03-10 | Carter | Missouri | 29035 | 1491 | 21 |
2289529 | 2289529 | 2022-03-09 | Carter | Missouri | 29035 | 1491 | 21 |
2286277 | 2286277 | 2022-03-08 | Carter | Missouri | 29035 | 1491 | 21 |
2283025 | 2283025 | 2022-03-07 | Carter | Missouri | 29035 | 1491 | 21 |
2278729 | 2278729 | 2022-03-06 | Jenkins | Georgia | 13165 | 1491 | 66 |
2275476 | 2275476 | 2022-03-05 | Jenkins | Georgia | 13165 | 1491 | 66 |
2272223 | 2272223 | 2022-03-04 | Jenkins | Georgia | 13165 | 1491 | 66 |
2274497 | 2274497 | 2022-03-04 | Jack | Texas | 48237 | 1491 | 27 |
2268971 | 2268971 | 2022-03-03 | Jenkins | Georgia | 13165 | 1491 | 66 |
2265718 | 2265718 | 2022-03-02 | Jenkins | Georgia | 13165 | 1491 | 66 |
2266330 | 2266330 | 2022-03-02 | Menifee | Kentucky | 21165 | 1491 | 30 |
2262467 | 2262467 | 2022-03-01 | Jenkins | Georgia | 13165 | 1491 | 66 |
2259216 | 2259216 | 2022-02-28 | Jenkins | Georgia | 13165 | 1491 | 66 |
2261236 | 2261236 | 2022-02-28 | Hamlin | South Dakota | 46057 | 1491 | 41 |
2255965 | 2255965 | 2022-02-27 | Jenkins | Georgia | 13165 | 1491 | 66 |
2252714 | 2252714 | 2022-02-26 | Jenkins | Georgia | 13165 | 1491 | 66 |
2249463 | 2249463 | 2022-02-25 | Jenkins | Georgia | 13165 | 1491 | 66 |
2245995 | 2245995 | 2022-02-24 | Clear Creek | Colorado | 8019 | 1491 | 11 |
2246212 | 2246212 | 2022-02-24 | Jenkins | Georgia | 13165 | 1491 | 66 |
2242744 | 2242744 | 2022-02-23 | Clear Creek | Colorado | 8019 | 1491 | 11 |
2242961 | 2242961 | 2022-02-23 | Jenkins | Georgia | 13165 | 1491 | 66 |
2239710 | 2239710 | 2022-02-22 | Jenkins | Georgia | 13165 | 1491 | 66 |
2236459 | 2236459 | 2022-02-21 | Jenkins | Georgia | 13165 | 1491 | 66 |
2233208 | 2233208 | 2022-02-20 | Jenkins | Georgia | 13165 | 1491 | 66 |
2229957 | 2229957 | 2022-02-19 | Jenkins | Georgia | 13165 | 1491 | 66 |
2226706 | 2226706 | 2022-02-18 | Jenkins | Georgia | 13165 | 1491 | 66 |
2190754 | 2190754 | 2022-02-07 | Rio Blanco | Colorado | 8103 | 1491 | 13 |
2189447 | 2189447 | 2022-02-06 | Harney | Oregon | 41025 | 1491 | 36 |
2186194 | 2186194 | 2022-02-05 | Harney | Oregon | 41025 | 1491 | 36 |
2182942 | 2182942 | 2022-02-04 | Harney | Oregon | 41025 | 1491 | 36 |
2179689 | 2179689 | 2022-02-03 | Grant | Oregon | 41023 | 1491 | 18 |
2180697 | 2180697 | 2022-02-03 | Weston | Wyoming | 56045 | 1491 | 17 |
2133471 | 2133471 | 2022-01-20 | Ozark | Missouri | 29153 | 1491 | 48 |
2127952 | 2127952 | 2022-01-18 | Hancock | Tennessee | 47067 | 1491 | 28 |
2124700 | 2124700 | 2022-01-17 | Hancock | Tennessee | 47067 | 1491 | 28 |
2121448 | 2121448 | 2022-01-16 | Hancock | Tennessee | 47067 | 1491 | 28 |
2118196 | 2118196 | 2022-01-15 | Hancock | Tennessee | 47067 | 1491 | 28 |
2114945 | 2114945 | 2022-01-14 | Hancock | Tennessee | 47067 | 1491 | 28 |
2111693 | 2111693 | 2022-01-13 | Hancock | Tennessee | 47067 | 1491 | 28 |
2108441 | 2108441 | 2022-01-12 | Hancock | Tennessee | 47067 | 1491 | 28 |
2103152 | 2103152 | 2022-01-11 | Terrell | Georgia | 13273 | 1491 | 58 |
2100061 | 2100061 | 2022-01-10 | Schuyler | Illinois | 17169 | 1491 | 27 |
2085126 | 2085126 | 2022-01-05 | Benson | North Dakota | 38005 | 1491 | 22 |
2078152 | 2078152 | 2022-01-03 | Harrison | Missouri | 29081 | 1491 | 23 |
2060055 | 2060055 | 2021-12-28 | Buena Vista city | Virginia | 51530 | 1491 | 33 |
2046151 | 2046151 | 2021-12-24 | Pembina | North Dakota | 38067 | 1491 | 15 |
2033592 | 2033592 | 2021-12-20 | Custer | South Dakota | 46033 | 1491 | 19 |
2024511 | 2024511 | 2021-12-17 | Webster | West Virginia | 54101 | 1491 | 26 |
2013443 | 2013443 | 2021-12-14 | Quay | New Mexico | 35037 | 1491 | 26 |
2006680 | 2006680 | 2021-12-12 | Oregon | Missouri | 29149 | 1491 | 26 |
1998465 | 1998465 | 2021-12-09 | Gilmer | West Virginia | 54021 | 1491 | 14 |
1987313 | 1987313 | 2021-12-06 | Hamilton | Nebraska | 31081 | 1491 | 19 |
1988612 | 1988612 | 2021-12-06 | Nelson | Virginia | 51125 | 1491 | 21 |
1983896 | 1983896 | 2021-12-05 | Iron | Missouri | 29093 | 1491 | 27 |
1978263 | 1978263 | 2021-12-03 | Yauco | Puerto Rico | 72153 | 1491 | |
1975013 | 1975013 | 2021-12-02 | Yauco | Puerto Rico | 72153 | 1491 | |
1972597 | 1972597 | 2021-12-01 | Sublette | Wyoming | 56035 | 1491 | 23 |
1949551 | 1949551 | 2021-11-24 | Clarke | Virginia | 51043 | 1491 | 29 |
1940559 | 1940559 | 2021-11-22 | Heard | Georgia | 13149 | 1491 | 41 |
1941465 | 1941465 | 2021-11-22 | Marshall | Minnesota | 27089 | 1491 | 21 |
1937309 | 1937309 | 2021-11-21 | Heard | Georgia | 13149 | 1491 | 41 |
1934059 | 1934059 | 2021-11-20 | Heard | Georgia | 13149 | 1491 | 41 |
1930807 | 1930807 | 2021-11-19 | Heard | Georgia | 13149 | 1491 | 41 |
1925185 | 1925185 | 2021-11-17 | Clearwater | Minnesota | 27029 | 1491 | 20 |
1923437 | 1923437 | 2021-11-16 | Swisher | Texas | 48437 | 1491 | 22 |
1920188 | 1920188 | 2021-11-15 | Swisher | Texas | 48437 | 1491 | 22 |
1920233 | 1920233 | 2021-11-15 | Grand | Utah | 49019 | 1491 | 5 |
1916938 | 1916938 | 2021-11-14 | Swisher | Texas | 48437 | 1491 | 22 |
1916983 | 1916983 | 2021-11-14 | Grand | Utah | 49019 | 1491 | 5 |
1913688 | 1913688 | 2021-11-13 | Swisher | Texas | 48437 | 1491 | 22 |
1913733 | 1913733 | 2021-11-13 | Grand | Utah | 49019 | 1491 | 5 |
1910438 | 1910438 | 2021-11-12 | Swisher | Texas | 48437 | 1491 | 22 |
1907189 | 1907189 | 2021-11-11 | Swisher | Texas | 48437 | 1491 | 22 |
1879963 | 1879963 | 2021-11-03 | Beaverhead | Montana | 30001 | 1491 | 17 |
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);