ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
382 rows where cases = 2155 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 81
- Kentucky 22
- Missouri 19
- Idaho 18
- Texas 18
- Georgia 17
- Iowa 17
- Minnesota 16
- North Carolina 12
- Virginia 12
- California 11
- Mississippi 11
- Arkansas 10
- Florida 10
- Indiana 10
- Illinois 9
- Wisconsin 9
- Colorado 7
- Ohio 7
- Puerto Rico 7
- Alabama 6
- South Carolina 6
- Wyoming 6
- Tennessee 5
- West Virginia 5
- Utah 4
- Louisiana 3
- Michigan 3
- New York 3
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502262 | 2502262 | 2022-05-13 | Dallam | Texas | 48111 | 2155 | 40 |
2499004 | 2499004 | 2022-05-12 | Dallam | Texas | 48111 | 2155 | 40 |
2495746 | 2495746 | 2022-05-11 | Dallam | Texas | 48111 | 2155 | 40 |
2492488 | 2492488 | 2022-05-10 | Dallam | Texas | 48111 | 2155 | 40 |
2489230 | 2489230 | 2022-05-09 | Dallam | Texas | 48111 | 2155 | 40 |
2485973 | 2485973 | 2022-05-08 | Dallam | Texas | 48111 | 2155 | 40 |
2482715 | 2482715 | 2022-05-07 | Dallam | Texas | 48111 | 2155 | 41 |
2479457 | 2479457 | 2022-05-06 | Dallam | Texas | 48111 | 2155 | 41 |
2476199 | 2476199 | 2022-05-05 | Dallam | Texas | 48111 | 2155 | 41 |
2472942 | 2472942 | 2022-05-04 | Dallam | Texas | 48111 | 2155 | 41 |
2470113 | 2470113 | 2022-05-03 | Doddridge | West Virginia | 54017 | 2155 | 18 |
2466857 | 2466857 | 2022-05-02 | Doddridge | West Virginia | 54017 | 2155 | 18 |
2445569 | 2445569 | 2022-04-26 | Jackson | Minnesota | 27063 | 2155 | 17 |
2442313 | 2442313 | 2022-04-25 | Jackson | Minnesota | 27063 | 2155 | 17 |
2430948 | 2430948 | 2022-04-21 | Northampton | Virginia | 51131 | 2155 | 63 |
2427048 | 2427048 | 2022-04-20 | Jayuya | Puerto Rico | 72073 | 2155 | |
2422760 | 2422760 | 2022-04-19 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2419504 | 2419504 | 2022-04-18 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2419877 | 2419877 | 2022-04-18 | Holt | Nebraska | 31089 | 2155 | 20 |
2416248 | 2416248 | 2022-04-17 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2416622 | 2416622 | 2022-04-17 | Holt | Nebraska | 31089 | 2155 | 20 |
2412992 | 2412992 | 2022-04-16 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2413366 | 2413366 | 2022-04-16 | Holt | Nebraska | 31089 | 2155 | 20 |
2409736 | 2409736 | 2022-04-15 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2410110 | 2410110 | 2022-04-15 | Holt | Nebraska | 31089 | 2155 | 20 |
2406854 | 2406854 | 2022-04-14 | Holt | Nebraska | 31089 | 2155 | 20 |
2403598 | 2403598 | 2022-04-13 | Holt | Nebraska | 31089 | 2155 | 20 |
2379673 | 2379673 | 2022-04-06 | Fremont | Idaho | 16043 | 2155 | 28 |
2381491 | 2381491 | 2022-04-06 | Rincon | Puerto Rico | 72117 | 2155 | |
2376419 | 2376419 | 2022-04-05 | Fremont | Idaho | 16043 | 2155 | 27 |
2378236 | 2378236 | 2022-04-05 | Rincon | Puerto Rico | 72117 | 2155 | |
2373167 | 2373167 | 2022-04-04 | Fremont | Idaho | 16043 | 2155 | 27 |
2374982 | 2374982 | 2022-04-04 | Rincon | Puerto Rico | 72117 | 2155 | |
2369914 | 2369914 | 2022-04-03 | Fremont | Idaho | 16043 | 2155 | 27 |
2366661 | 2366661 | 2022-04-02 | Fremont | Idaho | 16043 | 2155 | 27 |
2363408 | 2363408 | 2022-04-01 | Fremont | Idaho | 16043 | 2155 | 27 |
2360154 | 2360154 | 2022-03-31 | Fremont | Idaho | 16043 | 2155 | 27 |
2356900 | 2356900 | 2022-03-30 | Fremont | Idaho | 16043 | 2155 | 27 |
2353647 | 2353647 | 2022-03-29 | Fremont | Idaho | 16043 | 2155 | 27 |
2350395 | 2350395 | 2022-03-28 | Fremont | Idaho | 16043 | 2155 | 27 |
2347142 | 2347142 | 2022-03-27 | Fremont | Idaho | 16043 | 2155 | 27 |
2348099 | 2348099 | 2022-03-27 | Gentry | Missouri | 29075 | 2155 | 31 |
2343889 | 2343889 | 2022-03-26 | Fremont | Idaho | 16043 | 2155 | 27 |
2344846 | 2344846 | 2022-03-26 | Gentry | Missouri | 29075 | 2155 | 31 |
2340636 | 2340636 | 2022-03-25 | Fremont | Idaho | 16043 | 2155 | 27 |
2341593 | 2341593 | 2022-03-25 | Gentry | Missouri | 29075 | 2155 | 31 |
2338340 | 2338340 | 2022-03-24 | Gentry | Missouri | 29075 | 2155 | 31 |
2335086 | 2335086 | 2022-03-23 | Gentry | Missouri | 29075 | 2155 | 31 |
2331832 | 2331832 | 2022-03-22 | Gentry | Missouri | 29075 | 2155 | 31 |
2292808 | 2292808 | 2022-03-10 | Howard | Missouri | 29089 | 2155 | 25 |
2289556 | 2289556 | 2022-03-09 | Howard | Missouri | 29089 | 2155 | 25 |
2284922 | 2284922 | 2022-03-08 | Nevada | Arkansas | 5099 | 2155 | 44 |
2286304 | 2286304 | 2022-03-08 | Howard | Missouri | 29089 | 2155 | 25 |
2279012 | 2279012 | 2022-03-06 | Martin | Indiana | 18101 | 2155 | 25 |
2275759 | 2275759 | 2022-03-05 | Martin | Indiana | 18101 | 2155 | 25 |
2272506 | 2272506 | 2022-03-04 | Martin | Indiana | 18101 | 2155 | 25 |
2274086 | 2274086 | 2022-03-04 | Adjuntas | Puerto Rico | 72001 | 2155 | |
2269014 | 2269014 | 2022-03-03 | Seminole | Georgia | 13253 | 2155 | 28 |
2269254 | 2269254 | 2022-03-03 | Martin | Indiana | 18101 | 2155 | 25 |
2262750 | 2262750 | 2022-03-01 | Martin | Indiana | 18101 | 2155 | 25 |
2256533 | 2256533 | 2022-02-27 | Gallatin | Kentucky | 21077 | 2155 | 45 |
2253282 | 2253282 | 2022-02-26 | Gallatin | Kentucky | 21077 | 2155 | 45 |
2250031 | 2250031 | 2022-02-25 | Gallatin | Kentucky | 21077 | 2155 | 45 |
2243939 | 2243939 | 2022-02-23 | Kemper | Mississippi | 28069 | 2155 | 46 |
2240278 | 2240278 | 2022-02-22 | Gallatin | Kentucky | 21077 | 2155 | 45 |
2236493 | 2236493 | 2022-02-21 | Pulaski | Georgia | 13235 | 2155 | 70 |
2220196 | 2220196 | 2022-02-16 | Heard | Georgia | 13149 | 2155 | 44 |
2210280 | 2210280 | 2022-02-13 | San Miguel | Colorado | 8113 | 2155 | 7 |
2207027 | 2207027 | 2022-02-12 | San Miguel | Colorado | 8113 | 2155 | 7 |
2203774 | 2203774 | 2022-02-11 | San Miguel | Colorado | 8113 | 2155 | 7 |
2202610 | 2202610 | 2022-02-10 | Penuelas | Puerto Rico | 72111 | 2155 | |
2199419 | 2199419 | 2022-02-09 | McCormick | South Carolina | 45065 | 2155 | 36 |
2147432 | 2147432 | 2022-01-24 | Roberts | South Dakota | 46109 | 2155 | 45 |
2118430 | 2118430 | 2022-01-15 | Morris | Texas | 48343 | 2155 | 58 |
2102762 | 2102762 | 2022-01-11 | Fulton | Arkansas | 5049 | 2155 | 79 |
2102845 | 2102845 | 2022-01-11 | Plumas | California | 6063 | 2155 | 12 |
2103066 | 2103066 | 2022-01-11 | Early | Georgia | 13099 | 2155 | 58 |
2096142 | 2096142 | 2022-01-09 | Coosa | Alabama | 1037 | 2155 | 48 |
2092765 | 2092765 | 2022-01-07 | Roane | West Virginia | 54087 | 2155 | 29 |
2055280 | 2055280 | 2021-12-27 | Amite | Mississippi | 28005 | 2155 | 58 |
2056916 | 2056916 | 2021-12-27 | Westmoreland | Virginia | 51193 | 2155 | 39 |
2037764 | 2037764 | 2021-12-22 | Little River | Arkansas | 5081 | 2155 | 84 |
2032199 | 2032199 | 2021-12-20 | Metcalfe | Kentucky | 21169 | 2155 | 48 |
2032690 | 2032690 | 2021-12-20 | Pemiscot | Missouri | 29155 | 2155 | 59 |
2033770 | 2033770 | 2021-12-20 | Camp | Texas | 48063 | 2155 | 67 |
2029439 | 2029439 | 2021-12-19 | Pemiscot | Missouri | 29155 | 2155 | 59 |
2030436 | 2030436 | 2021-12-19 | Jackson | Tennessee | 47087 | 2155 | 43 |
2026188 | 2026188 | 2021-12-18 | Pemiscot | Missouri | 29155 | 2155 | 59 |
2027185 | 2027185 | 2021-12-18 | Jackson | Tennessee | 47087 | 2155 | 43 |
2023934 | 2023934 | 2021-12-17 | Jackson | Tennessee | 47087 | 2155 | 43 |
2013079 | 2013079 | 2021-12-14 | Perry | Mississippi | 28111 | 2155 | 56 |
2014500 | 2014500 | 2021-12-14 | Juab | Utah | 49023 | 2155 | 19 |
1988930 | 1988930 | 2021-12-07 | Ketchikan Gateway Borough | Alaska | 2130 | 2155 | 11 |
1989449 | 1989449 | 2021-12-07 | Shoshone | Idaho | 16079 | 2155 | 66 |
1985680 | 1985680 | 2021-12-06 | Ketchikan Gateway Borough | Alaska | 2130 | 2155 | 11 |
1956635 | 1956635 | 2021-11-27 | Moffat | Colorado | 8081 | 2155 | 47 |
1953384 | 1953384 | 2021-11-26 | Moffat | Colorado | 8081 | 2155 | 47 |
1950133 | 1950133 | 2021-11-25 | Moffat | Colorado | 8081 | 2155 | 47 |
1921938 | 1921938 | 2021-11-16 | Cottonwood | Minnesota | 27033 | 2155 | 31 |
1904495 | 1904495 | 2021-11-11 | Lee | Arkansas | 5077 | 2155 | 52 |
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);