ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
269 rows where cases = 2240 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 37
- Virginia 22
- Kentucky 17
- Georgia 15
- North Carolina 15
- Texas 14
- Florida 12
- Mississippi 11
- Missouri 10
- Arkansas 9
- Iowa 9
- Illinois 8
- Colorado 7
- Oregon 7
- Puerto Rico 7
- Alabama 6
- Montana 6
- South Dakota 6
- West Virginia 6
- Indiana 5
- Minnesota 5
- Wisconsin 5
- Louisiana 4
- Ohio 3
- Tennessee 3
- Washington 3
- Wyoming 3
- Alaska 2
- California 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492099 | 2492099 | 2022-05-10 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2488841 | 2488841 | 2022-05-09 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2485584 | 2485584 | 2022-05-08 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2482326 | 2482326 | 2022-05-07 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2479068 | 2479068 | 2022-05-06 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2475810 | 2475810 | 2022-05-05 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2472553 | 2472553 | 2022-05-04 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2469297 | 2469297 | 2022-05-03 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2466041 | 2466041 | 2022-05-02 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2462786 | 2462786 | 2022-05-01 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2459530 | 2459530 | 2022-04-30 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2456274 | 2456274 | 2022-04-29 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2453018 | 2453018 | 2022-04-28 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2449762 | 2449762 | 2022-04-27 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2446505 | 2446505 | 2022-04-26 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2443250 | 2443250 | 2022-04-25 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2439994 | 2439994 | 2022-04-24 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2440065 | 2440065 | 2022-04-24 | Guayanilla | Puerto Rico | 72059 | 2240 | |
2436738 | 2436738 | 2022-04-23 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2433482 | 2433482 | 2022-04-22 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2430226 | 2430226 | 2022-04-21 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2426970 | 2426970 | 2022-04-20 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2423714 | 2423714 | 2022-04-19 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2420458 | 2420458 | 2022-04-18 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2417202 | 2417202 | 2022-04-17 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2413946 | 2413946 | 2022-04-16 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2410690 | 2410690 | 2022-04-15 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2407434 | 2407434 | 2022-04-14 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2404178 | 2404178 | 2022-04-13 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2400923 | 2400923 | 2022-04-12 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2397668 | 2397668 | 2022-04-11 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2394413 | 2394413 | 2022-04-10 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2391157 | 2391157 | 2022-04-09 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2387901 | 2387901 | 2022-04-08 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2384646 | 2384646 | 2022-04-07 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2361973 | 2361973 | 2022-03-31 | Sabana Grande | Puerto Rico | 72121 | 2240 | |
2358719 | 2358719 | 2022-03-30 | Sabana Grande | Puerto Rico | 72121 | 2240 | |
2324820 | 2324820 | 2022-03-20 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2321566 | 2321566 | 2022-03-19 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2318312 | 2318312 | 2022-03-18 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2315059 | 2315059 | 2022-03-17 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2311806 | 2311806 | 2022-03-16 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2308553 | 2308553 | 2022-03-15 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2305302 | 2305302 | 2022-03-14 | Crittenden | Kentucky | 21055 | 2240 | 46 |
2269532 | 2269532 | 2022-03-03 | Elliott | Kentucky | 21063 | 2240 | 16 |
2271464 | 2271464 | 2022-03-03 | Essex | Virginia | 51057 | 2240 | 31 |
2261564 | 2261564 | 2022-02-28 | Red River | Texas | 48387 | 2240 | 64 |
2255616 | 2255616 | 2022-02-27 | Cleveland | Arkansas | 5025 | 2240 | 35 |
2258313 | 2258313 | 2022-02-27 | Red River | Texas | 48387 | 2240 | 64 |
2252365 | 2252365 | 2022-02-26 | Cleveland | Arkansas | 5025 | 2240 | 35 |
2244432 | 2244432 | 2022-02-23 | Graham | North Carolina | 37075 | 2240 | 30 |
2245300 | 2245300 | 2022-02-23 | Parmer | Texas | 48369 | 2240 | 51 |
2241181 | 2241181 | 2022-02-22 | Graham | North Carolina | 37075 | 2240 | 30 |
2233209 | 2233209 | 2022-02-20 | Johnson | Georgia | 13167 | 2240 | 70 |
2229958 | 2229958 | 2022-02-19 | Johnson | Georgia | 13167 | 2240 | 70 |
2226707 | 2226707 | 2022-02-18 | Johnson | Georgia | 13167 | 2240 | 70 |
2229060 | 2229060 | 2022-02-18 | Runnels | Texas | 48399 | 2240 | 62 |
2221152 | 2221152 | 2022-02-16 | Benton | Mississippi | 28009 | 2240 | 48 |
2222393 | 2222393 | 2022-02-16 | Castro | Texas | 48069 | 2240 | 46 |
2217901 | 2217901 | 2022-02-15 | Benton | Mississippi | 28009 | 2240 | 46 |
2211603 | 2211603 | 2022-02-13 | Dawson | Montana | 30021 | 2240 | 53 |
2213088 | 2213088 | 2022-02-13 | Clay | West Virginia | 54015 | 2240 | 32 |
2208350 | 2208350 | 2022-02-12 | Dawson | Montana | 30021 | 2240 | 53 |
2205097 | 2205097 | 2022-02-11 | Dawson | Montana | 30021 | 2240 | 53 |
2198623 | 2198623 | 2022-02-09 | Rosebud | Montana | 30087 | 2240 | 58 |
2196856 | 2196856 | 2022-02-08 | Ritchie | West Virginia | 54085 | 2240 | 27 |
2166904 | 2166904 | 2022-01-30 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2163649 | 2163649 | 2022-01-29 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2160287 | 2160287 | 2022-01-28 | Florida | Puerto Rico | 72054 | 2240 | |
2160394 | 2160394 | 2022-01-28 | Bon Homme | South Dakota | 46009 | 2240 | 36 |
2144711 | 2144711 | 2022-01-23 | Sussex | Virginia | 51183 | 2240 | 31 |
2141456 | 2141456 | 2022-01-22 | Sussex | Virginia | 51183 | 2240 | 31 |
2138200 | 2138200 | 2022-01-21 | Sussex | Virginia | 51183 | 2240 | 31 |
2108350 | 2108350 | 2022-01-12 | Butte | South Dakota | 46019 | 2240 | 40 |
2099106 | 2099106 | 2022-01-09 | Greensville | Virginia | 51081 | 2240 | 30 |
2095855 | 2095855 | 2022-01-08 | Greensville | Virginia | 51081 | 2240 | 30 |
2092603 | 2092603 | 2022-01-07 | Greensville | Virginia | 51081 | 2240 | 30 |
2079576 | 2079576 | 2022-01-03 | Dickenson | Virginia | 51051 | 2240 | 38 |
2055854 | 2055854 | 2021-12-27 | Swain | North Carolina | 37173 | 2240 | 28 |
2056232 | 2056232 | 2021-12-27 | Juana Diaz | Puerto Rico | 72075 | 2240 | |
2052604 | 2052604 | 2021-12-26 | Swain | North Carolina | 37173 | 2240 | 28 |
2049354 | 2049354 | 2021-12-25 | Swain | North Carolina | 37173 | 2240 | 28 |
2046104 | 2046104 | 2021-12-24 | Swain | North Carolina | 37173 | 2240 | 28 |
2041203 | 2041203 | 2021-12-23 | Franklin | Florida | 12037 | 2240 | 45 |
2042854 | 2042854 | 2021-12-23 | Swain | North Carolina | 37173 | 2240 | 28 |
2037953 | 2037953 | 2021-12-22 | Franklin | Florida | 12037 | 2240 | 45 |
2039605 | 2039605 | 2021-12-22 | Swain | North Carolina | 37173 | 2240 | 28 |
2039856 | 2039856 | 2021-12-22 | Hood River | Oregon | 41027 | 2240 | 38 |
2034703 | 2034703 | 2021-12-21 | Franklin | Florida | 12037 | 2240 | 45 |
2036399 | 2036399 | 2021-12-21 | Mountrail | North Dakota | 38061 | 2240 | 32 |
2031453 | 2031453 | 2021-12-20 | Franklin | Florida | 12037 | 2240 | 45 |
2028202 | 2028202 | 2021-12-19 | Franklin | Florida | 12037 | 2240 | 45 |
2028481 | 2028481 | 2021-12-19 | Cumberland | Illinois | 17035 | 2240 | 41 |
2024951 | 2024951 | 2021-12-18 | Franklin | Florida | 12037 | 2240 | 45 |
2025230 | 2025230 | 2021-12-18 | Cumberland | Illinois | 17035 | 2240 | 41 |
2021700 | 2021700 | 2021-12-17 | Franklin | Florida | 12037 | 2240 | 45 |
2021979 | 2021979 | 2021-12-17 | Cumberland | Illinois | 17035 | 2240 | 41 |
2023720 | 2023720 | 2021-12-17 | Fajardo | Puerto Rico | 72053 | 2240 | |
2018187 | 2018187 | 2021-12-16 | Ketchikan Gateway Borough | Alaska | 2130 | 2240 | 12 |
2019131 | 2019131 | 2021-12-16 | Carroll | Kentucky | 21041 | 2240 | 32 |
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);