ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
267 rows where cases = 2287 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 31
- Georgia 21
- Texas 20
- Illinois 14
- Mississippi 14
- Tennessee 12
- Virginia 12
- Iowa 11
- North Carolina 10
- Indiana 9
- Arkansas 8
- Missouri 8
- South Dakota 8
- Idaho 7
- Michigan 7
- Ohio 7
- Rhode Island 7
- Colorado 6
- Louisiana 6
- Minnesota 5
- Puerto Rico 5
- Wisconsin 5
- Maine 4
- Vermont 4
- West Virginia 3
- Maryland 2
- Pennsylvania 2
- South Carolina 2
- Utah 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440094 | 2440094 | 2022-04-24 | Rincon | Puerto Rico | 72117 | 2287 | |
2423811 | 2423811 | 2022-04-19 | Penuelas | Puerto Rico | 72111 | 2287 | |
2415935 | 2415935 | 2022-04-17 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2412679 | 2412679 | 2022-04-16 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2409423 | 2409423 | 2022-04-15 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2406167 | 2406167 | 2022-04-14 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2402911 | 2402911 | 2022-04-13 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2403285 | 2403285 | 2022-04-13 | Swift | Minnesota | 27151 | 2287 | 33 |
2399657 | 2399657 | 2022-04-12 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2401174 | 2401174 | 2022-04-12 | Clay | Tennessee | 47027 | 2287 | 49 |
2396401 | 2396401 | 2022-04-11 | Crittenden | Kentucky | 21055 | 2287 | 49 |
2396797 | 2396797 | 2022-04-11 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2397919 | 2397919 | 2022-04-11 | Clay | Tennessee | 47027 | 2287 | 49 |
2393542 | 2393542 | 2022-04-10 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2394664 | 2394664 | 2022-04-10 | Clay | Tennessee | 47027 | 2287 | 49 |
2390286 | 2390286 | 2022-04-09 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2391408 | 2391408 | 2022-04-09 | Clay | Tennessee | 47027 | 2287 | 49 |
2387030 | 2387030 | 2022-04-08 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2388152 | 2388152 | 2022-04-08 | Clay | Tennessee | 47027 | 2287 | 49 |
2383775 | 2383775 | 2022-04-07 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2384897 | 2384897 | 2022-04-07 | Clay | Tennessee | 47027 | 2287 | 49 |
2380520 | 2380520 | 2022-04-06 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2381642 | 2381642 | 2022-04-06 | Clay | Tennessee | 47027 | 2287 | 49 |
2377265 | 2377265 | 2022-04-05 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2374013 | 2374013 | 2022-04-04 | Choctaw | Mississippi | 28019 | 2287 | 33 |
2347592 | 2347592 | 2022-03-27 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2344339 | 2344339 | 2022-03-26 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2341086 | 2341086 | 2022-03-25 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2336977 | 2336977 | 2022-03-24 | Scott | Arkansas | 5127 | 2287 | 41 |
2337833 | 2337833 | 2022-03-24 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2334579 | 2334579 | 2022-03-23 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2331325 | 2331325 | 2022-03-22 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2328073 | 2328073 | 2022-03-21 | Crittenden | Kentucky | 21055 | 2287 | 46 |
2329865 | 2329865 | 2022-03-21 | Red River | Texas | 48387 | 2287 | 64 |
2326613 | 2326613 | 2022-03-20 | Red River | Texas | 48387 | 2287 | 64 |
2323360 | 2323360 | 2022-03-19 | Red River | Texas | 48387 | 2287 | 64 |
2320106 | 2320106 | 2022-03-18 | Red River | Texas | 48387 | 2287 | 64 |
2314605 | 2314605 | 2022-03-17 | Clearwater | Idaho | 16035 | 2287 | 32 |
2316852 | 2316852 | 2022-03-17 | Red River | Texas | 48387 | 2287 | 64 |
2251756 | 2251756 | 2022-02-25 | La Salle | Texas | 48283 | 2287 | 45 |
2225451 | 2225451 | 2022-02-17 | Bon Homme | South Dakota | 46009 | 2287 | 37 |
2220514 | 2220514 | 2022-02-16 | Switzerland | Indiana | 18155 | 2287 | 16 |
2217316 | 2217316 | 2022-02-15 | Guthrie | Iowa | 19077 | 2287 | 42 |
2214065 | 2214065 | 2022-02-14 | Guthrie | Iowa | 19077 | 2287 | 42 |
2210813 | 2210813 | 2022-02-13 | Guthrie | Iowa | 19077 | 2287 | 42 |
2207560 | 2207560 | 2022-02-12 | Guthrie | Iowa | 19077 | 2287 | 42 |
2204307 | 2204307 | 2022-02-11 | Guthrie | Iowa | 19077 | 2287 | 42 |
2201054 | 2201054 | 2022-02-10 | Guthrie | Iowa | 19077 | 2287 | 42 |
2197800 | 2197800 | 2022-02-09 | Guthrie | Iowa | 19077 | 2287 | 42 |
2187692 | 2187692 | 2022-02-06 | McIntosh | Georgia | 13191 | 2287 | 35 |
2189707 | 2189707 | 2022-02-06 | Lake | South Dakota | 46079 | 2287 | 26 |
2184439 | 2184439 | 2022-02-05 | McIntosh | Georgia | 13191 | 2287 | 35 |
2186454 | 2186454 | 2022-02-05 | Lake | South Dakota | 46079 | 2287 | 26 |
2181187 | 2181187 | 2022-02-04 | McIntosh | Georgia | 13191 | 2287 | 35 |
2183202 | 2183202 | 2022-02-04 | Lake | South Dakota | 46079 | 2287 | 26 |
2134706 | 2134706 | 2022-01-20 | Pecos | Texas | 48371 | 2287 | 60 |
2129123 | 2129123 | 2022-01-19 | Long | Georgia | 13183 | 2287 | 29 |
2125567 | 2125567 | 2022-01-18 | Stone | Arkansas | 5137 | 2287 | 51 |
2122315 | 2122315 | 2022-01-17 | Stone | Arkansas | 5137 | 2287 | 51 |
2108361 | 2108361 | 2022-01-12 | Dewey | South Dakota | 46041 | 2287 | 35 |
2108963 | 2108963 | 2022-01-12 | Pacific | Washington | 53049 | 2287 | 43 |
2086641 | 2086641 | 2022-01-06 | Gunnison | Colorado | 8051 | 2287 | 13 |
2049704 | 2049704 | 2021-12-25 | Barranquitas | Puerto Rico | 72019 | 2287 | |
2035133 | 2035133 | 2021-12-21 | Pulaski | Indiana | 18131 | 2287 | 65 |
2014614 | 2014614 | 2021-12-14 | Martinsville city | Virginia | 51690 | 2287 | 94 |
1996049 | 1996049 | 2021-12-09 | Wabash | Illinois | 17185 | 2287 | 22 |
1998203 | 1998203 | 2021-12-09 | Terry | Texas | 48445 | 2287 | 68 |
1992812 | 1992812 | 2021-12-08 | Blackford | Indiana | 18009 | 2287 | 47 |
1994952 | 1994952 | 2021-12-08 | Terry | Texas | 48445 | 2287 | 68 |
1990006 | 1990006 | 2021-12-07 | Madison | Louisiana | 22065 | 2287 | 53 |
1986756 | 1986756 | 2021-12-06 | Madison | Louisiana | 22065 | 2287 | 53 |
1969082 | 1969082 | 2021-11-30 | Grayson | Virginia | 51077 | 2287 | 52 |
1960262 | 1960262 | 2021-11-28 | Massac | Illinois | 17127 | 2287 | 57 |
1960712 | 1960712 | 2021-11-28 | Trigg | Kentucky | 21221 | 2287 | 25 |
1957011 | 1957011 | 2021-11-27 | Massac | Illinois | 17127 | 2287 | 57 |
1957461 | 1957461 | 2021-11-27 | Trigg | Kentucky | 21221 | 2287 | 25 |
1953760 | 1953760 | 2021-11-26 | Massac | Illinois | 17127 | 2287 | 57 |
1954210 | 1954210 | 2021-11-26 | Trigg | Kentucky | 21221 | 2287 | 25 |
1950509 | 1950509 | 2021-11-25 | Massac | Illinois | 17127 | 2287 | 57 |
1950959 | 1950959 | 2021-11-25 | Trigg | Kentucky | 21221 | 2287 | 25 |
1947258 | 1947258 | 2021-11-24 | Massac | Illinois | 17127 | 2287 | 57 |
1947708 | 1947708 | 2021-11-24 | Trigg | Kentucky | 21221 | 2287 | 25 |
1944457 | 1944457 | 2021-11-23 | Trigg | Kentucky | 21221 | 2287 | 25 |
1944904 | 1944904 | 2021-11-23 | Macon | Missouri | 29121 | 2287 | 34 |
1945463 | 1945463 | 2021-11-23 | Monroe | Ohio | 39111 | 2287 | 59 |
1937427 | 1937427 | 2021-11-21 | Idaho | Idaho | 16049 | 2287 | 38 |
1934177 | 1934177 | 2021-11-20 | Idaho | Idaho | 16049 | 2287 | 38 |
1930925 | 1930925 | 2021-11-19 | Idaho | Idaho | 16049 | 2287 | 38 |
1917868 | 1917868 | 2021-11-15 | Telfair | Georgia | 13271 | 2287 | 73 |
1899887 | 1899887 | 2021-11-09 | Ramsey | North Dakota | 38071 | 2287 | 38 |
1890472 | 1890472 | 2021-11-06 | Las Piedras | Puerto Rico | 72085 | 2287 | |
1871761 | 1871761 | 2021-10-31 | Burnett | Wisconsin | 55013 | 2287 | 32 |
1868496 | 1868496 | 2021-10-30 | Taylor | West Virginia | 54091 | 2287 | 38 |
1868512 | 1868512 | 2021-10-30 | Burnett | Wisconsin | 55013 | 2287 | 32 |
1865263 | 1865263 | 2021-10-29 | Burnett | Wisconsin | 55013 | 2287 | 32 |
1853839 | 1853839 | 2021-10-26 | Tallahatchie | Mississippi | 28135 | 2287 | 52 |
1778234 | 1778234 | 2021-10-03 | Carroll | Illinois | 17015 | 2287 | 38 |
1774984 | 1774984 | 2021-10-02 | Carroll | Illinois | 17015 | 2287 | 38 |
1771734 | 1771734 | 2021-10-01 | Carroll | Illinois | 17015 | 2287 | 38 |
1746188 | 1746188 | 2021-09-23 | Henry | Kentucky | 21103 | 2287 | 23 |
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);