ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
287 rows where cases = 2172 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 51
- Virginia 32
- Kentucky 20
- Tennessee 18
- Iowa 15
- Missouri 14
- Texas 13
- Illinois 12
- Mississippi 8
- North Carolina 8
- Washington 8
- West Virginia 8
- Oklahoma 7
- Colorado 6
- Indiana 6
- Minnesota 6
- Ohio 6
- Wisconsin 6
- Vermont 5
- Nebraska 4
- South Carolina 4
- Louisiana 3
- Michigan 3
- Puerto Rico 3
- South Dakota 3
- Alaska 2
- Arkansas 2
- Idaho 2
- Wyoming 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501113 | 2501113 | 2022-05-13 | Gentry | Missouri | 29075 | 2172 | 31 |
2497072 | 2497072 | 2022-05-12 | Martin | Indiana | 18101 | 2172 | 25 |
2493814 | 2493814 | 2022-05-11 | Martin | Indiana | 18101 | 2172 | 25 |
2483801 | 2483801 | 2022-05-08 | Seminole | Georgia | 13253 | 2172 | 30 |
2486307 | 2486307 | 2022-05-08 | Northampton | Virginia | 51131 | 2172 | 64 |
2480543 | 2480543 | 2022-05-07 | Seminole | Georgia | 13253 | 2172 | 30 |
2483049 | 2483049 | 2022-05-07 | Northampton | Virginia | 51131 | 2172 | 64 |
2477285 | 2477285 | 2022-05-06 | Seminole | Georgia | 13253 | 2172 | 30 |
2479791 | 2479791 | 2022-05-06 | Northampton | Virginia | 51131 | 2172 | 64 |
2474027 | 2474027 | 2022-05-05 | Seminole | Georgia | 13253 | 2172 | 30 |
2476533 | 2476533 | 2022-05-05 | Northampton | Virginia | 51131 | 2172 | 64 |
2470770 | 2470770 | 2022-05-04 | Seminole | Georgia | 13253 | 2172 | 30 |
2467514 | 2467514 | 2022-05-03 | Seminole | Georgia | 13253 | 2172 | 30 |
2464259 | 2464259 | 2022-05-02 | Seminole | Georgia | 13253 | 2172 | 30 |
2461003 | 2461003 | 2022-05-01 | Seminole | Georgia | 13253 | 2172 | 30 |
2457747 | 2457747 | 2022-04-30 | Seminole | Georgia | 13253 | 2172 | 30 |
2454491 | 2454491 | 2022-04-29 | Seminole | Georgia | 13253 | 2172 | 30 |
2451235 | 2451235 | 2022-04-28 | Seminole | Georgia | 13253 | 2172 | 30 |
2447979 | 2447979 | 2022-04-27 | Seminole | Georgia | 13253 | 2172 | 30 |
2444672 | 2444672 | 2022-04-26 | Heard | Georgia | 13149 | 2172 | 52 |
2444723 | 2444723 | 2022-04-26 | Seminole | Georgia | 13253 | 2172 | 30 |
2447228 | 2447228 | 2022-04-26 | Northumberland | Virginia | 51133 | 2172 | 46 |
2441416 | 2441416 | 2022-04-25 | Heard | Georgia | 13149 | 2172 | 52 |
2441467 | 2441467 | 2022-04-25 | Seminole | Georgia | 13253 | 2172 | 30 |
2443588 | 2443588 | 2022-04-25 | Archer | Texas | 48009 | 2172 | 28 |
2438160 | 2438160 | 2022-04-24 | Heard | Georgia | 13149 | 2172 | 52 |
2438211 | 2438211 | 2022-04-24 | Seminole | Georgia | 13253 | 2172 | 30 |
2438711 | 2438711 | 2022-04-24 | Bracken | Kentucky | 21023 | 2172 | 26 |
2440332 | 2440332 | 2022-04-24 | Archer | Texas | 48009 | 2172 | 28 |
2440717 | 2440717 | 2022-04-24 | Northumberland | Virginia | 51133 | 2172 | 46 |
2434904 | 2434904 | 2022-04-23 | Heard | Georgia | 13149 | 2172 | 52 |
2434955 | 2434955 | 2022-04-23 | Seminole | Georgia | 13253 | 2172 | 30 |
2435455 | 2435455 | 2022-04-23 | Bracken | Kentucky | 21023 | 2172 | 26 |
2437076 | 2437076 | 2022-04-23 | Archer | Texas | 48009 | 2172 | 28 |
2437461 | 2437461 | 2022-04-23 | Northumberland | Virginia | 51133 | 2172 | 46 |
2431648 | 2431648 | 2022-04-22 | Heard | Georgia | 13149 | 2172 | 52 |
2431699 | 2431699 | 2022-04-22 | Seminole | Georgia | 13253 | 2172 | 30 |
2432199 | 2432199 | 2022-04-22 | Bracken | Kentucky | 21023 | 2172 | 26 |
2434205 | 2434205 | 2022-04-22 | Northumberland | Virginia | 51133 | 2172 | 46 |
2428392 | 2428392 | 2022-04-21 | Heard | Georgia | 13149 | 2172 | 52 |
2428443 | 2428443 | 2022-04-21 | Seminole | Georgia | 13253 | 2172 | 30 |
2428943 | 2428943 | 2022-04-21 | Bracken | Kentucky | 21023 | 2172 | 26 |
2430949 | 2430949 | 2022-04-21 | Northumberland | Virginia | 51133 | 2172 | 46 |
2425136 | 2425136 | 2022-04-20 | Heard | Georgia | 13149 | 2172 | 52 |
2425187 | 2425187 | 2022-04-20 | Seminole | Georgia | 13253 | 2172 | 30 |
2425687 | 2425687 | 2022-04-20 | Bracken | Kentucky | 21023 | 2172 | 26 |
2421931 | 2421931 | 2022-04-19 | Seminole | Georgia | 13253 | 2172 | 29 |
2422431 | 2422431 | 2022-04-19 | Bracken | Kentucky | 21023 | 2172 | 26 |
2418675 | 2418675 | 2022-04-18 | Seminole | Georgia | 13253 | 2172 | 29 |
2419175 | 2419175 | 2022-04-18 | Bracken | Kentucky | 21023 | 2172 | 26 |
2415419 | 2415419 | 2022-04-17 | Seminole | Georgia | 13253 | 2172 | 29 |
2412163 | 2412163 | 2022-04-16 | Seminole | Georgia | 13253 | 2172 | 29 |
2408907 | 2408907 | 2022-04-15 | Seminole | Georgia | 13253 | 2172 | 29 |
2405642 | 2405642 | 2022-04-14 | Pulaski | Georgia | 13235 | 2172 | 77 |
2405651 | 2405651 | 2022-04-14 | Seminole | Georgia | 13253 | 2172 | 29 |
2402396 | 2402396 | 2022-04-13 | Seminole | Georgia | 13253 | 2172 | 29 |
2399141 | 2399141 | 2022-04-12 | Seminole | Georgia | 13253 | 2172 | 29 |
2395886 | 2395886 | 2022-04-11 | Seminole | Georgia | 13253 | 2172 | 29 |
2392621 | 2392621 | 2022-04-10 | Pulaski | Georgia | 13235 | 2172 | 77 |
2389365 | 2389365 | 2022-04-09 | Pulaski | Georgia | 13235 | 2172 | 77 |
2386110 | 2386110 | 2022-04-08 | Pulaski | Georgia | 13235 | 2172 | 77 |
2381804 | 2381804 | 2022-04-06 | Franklin | Texas | 48159 | 2172 | 42 |
2353702 | 2353702 | 2022-03-29 | Hamilton | Illinois | 17065 | 2172 | 34 |
2350450 | 2350450 | 2022-03-28 | Hamilton | Illinois | 17065 | 2172 | 34 |
2347197 | 2347197 | 2022-03-27 | Hamilton | Illinois | 17065 | 2172 | 34 |
2343944 | 2343944 | 2022-03-26 | Hamilton | Illinois | 17065 | 2172 | 34 |
2340691 | 2340691 | 2022-03-25 | Hamilton | Illinois | 17065 | 2172 | 34 |
2317443 | 2317443 | 2022-03-18 | Nevada | Arkansas | 5099 | 2172 | 44 |
2289558 | 2289558 | 2022-03-09 | Iron | Missouri | 29093 | 2172 | 40 |
2265077 | 2265077 | 2022-03-01 | Lincoln | Washington | 53043 | 2172 | 27 |
2261827 | 2261827 | 2022-02-28 | Lincoln | Washington | 53043 | 2172 | 27 |
2251045 | 2251045 | 2022-02-25 | Traill | North Dakota | 38097 | 2172 | 24 |
2224726 | 2224726 | 2022-02-17 | Red Willow | Nebraska | 31145 | 2172 | 19 |
2219564 | 2219564 | 2022-02-15 | Lincoln | Washington | 53043 | 2172 | 27 |
2214907 | 2214907 | 2022-02-14 | Box Butte | Nebraska | 31013 | 2172 | 16 |
2216314 | 2216314 | 2022-02-14 | Lincoln | Washington | 53043 | 2172 | 27 |
2168267 | 2168267 | 2022-01-31 | Franklin | Idaho | 16041 | 2172 | 27 |
2170516 | 2170516 | 2022-01-31 | Runnels | Texas | 48399 | 2172 | 60 |
2136678 | 2136678 | 2022-01-21 | Douglas | Missouri | 29067 | 2172 | 68 |
2131986 | 2131986 | 2022-01-20 | Valdez-Cordova Census Area | Alaska | 2261 | 2172 | 14 |
2128732 | 2128732 | 2022-01-19 | Valdez-Cordova Census Area | Alaska | 2261 | 2172 | 14 |
2106951 | 2106951 | 2022-01-12 | Lyon | Kentucky | 21143 | 2172 | 31 |
2092484 | 2092484 | 2022-01-07 | Ward | Texas | 48475 | 2172 | 37 |
2085590 | 2085590 | 2022-01-05 | Butte | South Dakota | 46019 | 2172 | 40 |
2078204 | 2078204 | 2022-01-03 | Ripley | Missouri | 29181 | 2172 | 52 |
2036936 | 2036936 | 2021-12-21 | Jackson | Tennessee | 47087 | 2172 | 44 |
2037591 | 2037591 | 2021-12-21 | Big Horn | Wyoming | 56003 | 2172 | 58 |
2034341 | 2034341 | 2021-12-20 | Big Horn | Wyoming | 56003 | 2172 | 58 |
1991846 | 1991846 | 2021-12-07 | King William | Virginia | 51101 | 2172 | 26 |
1987845 | 1987845 | 2021-12-06 | Hood River | Oregon | 41027 | 2172 | 37 |
1966735 | 1966735 | 2021-11-30 | Greene | Illinois | 17061 | 2172 | 53 |
1965831 | 1965831 | 2021-11-29 | Goochland | Virginia | 51075 | 2172 | 31 |
1943814 | 1943814 | 2021-11-23 | Jasper | Georgia | 13159 | 2172 | 60 |
1917174 | 1917174 | 2021-11-14 | Klickitat | Washington | 53039 | 2172 | 25 |
1913924 | 1913924 | 2021-11-13 | Klickitat | Washington | 53039 | 2172 | 25 |
1913975 | 1913975 | 2021-11-13 | Monroe | West Virginia | 54063 | 2172 | 26 |
1910674 | 1910674 | 2021-11-12 | Klickitat | Washington | 53039 | 2172 | 25 |
1900978 | 1900978 | 2021-11-09 | Morgan | West Virginia | 54065 | 2172 | 47 |
1897728 | 1897728 | 2021-11-08 | Morgan | West Virginia | 54065 | 2172 | 46 |
1867710 | 1867710 | 2021-10-30 | Fajardo | Puerto Rico | 72053 | 2172 |
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);