ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
396 rows where cases = 1425 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 32
- Oklahoma 25
- Puerto Rico 24
- Texas 22
- Illinois 21
- Kentucky 19
- Kansas 18
- Louisiana 17
- North Dakota 17
- Georgia 16
- Missouri 14
- Indiana 13
- Michigan 12
- Arkansas 11
- Mississippi 11
- Tennessee 11
- Minnesota 10
- Montana 10
- Utah 10
- Alabama 7
- Wisconsin 7
- North Carolina 6
- Oregon 6
- West Virginia 6
- California 4
- Colorado 4
- Connecticut 4
- Iowa 4
- Nebraska 4
- South Dakota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500910 | 2500910 | 2022-05-13 | Big Stone | Minnesota | 27011 | 1425 | 9 |
2492055 | 2492055 | 2022-05-10 | Lake | Oregon | 41037 | 1425 | 29 |
2470075 | 2470075 | 2022-05-03 | Ferry | Washington | 53019 | 1425 | 29 |
2466819 | 2466819 | 2022-05-02 | Ferry | Washington | 53019 | 1425 | 29 |
2349572 | 2349572 | 2022-03-27 | Mathews | Virginia | 51115 | 1425 | 28 |
2346319 | 2346319 | 2022-03-26 | Mathews | Virginia | 51115 | 1425 | 28 |
2343066 | 2343066 | 2022-03-25 | Mathews | Virginia | 51115 | 1425 | 28 |
2339813 | 2339813 | 2022-03-24 | Mathews | Virginia | 51115 | 1425 | 28 |
2336559 | 2336559 | 2022-03-23 | Mathews | Virginia | 51115 | 1425 | 28 |
2332933 | 2332933 | 2022-03-22 | Bailey | Texas | 48017 | 1425 | 39 |
2333305 | 2333305 | 2022-03-22 | Mathews | Virginia | 51115 | 1425 | 28 |
2329680 | 2329680 | 2022-03-21 | Bailey | Texas | 48017 | 1425 | 39 |
2330052 | 2330052 | 2022-03-21 | Mathews | Virginia | 51115 | 1425 | 28 |
2325318 | 2325318 | 2022-03-20 | Dade | Missouri | 29057 | 1425 | 41 |
2326428 | 2326428 | 2022-03-20 | Bailey | Texas | 48017 | 1425 | 39 |
2326800 | 2326800 | 2022-03-20 | Mathews | Virginia | 51115 | 1425 | 28 |
2322064 | 2322064 | 2022-03-19 | Dade | Missouri | 29057 | 1425 | 41 |
2323175 | 2323175 | 2022-03-19 | Bailey | Texas | 48017 | 1425 | 39 |
2323547 | 2323547 | 2022-03-19 | Mathews | Virginia | 51115 | 1425 | 28 |
2318810 | 2318810 | 2022-03-18 | Dade | Missouri | 29057 | 1425 | 41 |
2320293 | 2320293 | 2022-03-18 | Mathews | Virginia | 51115 | 1425 | 28 |
2315557 | 2315557 | 2022-03-17 | Dade | Missouri | 29057 | 1425 | 41 |
2317039 | 2317039 | 2022-03-17 | Mathews | Virginia | 51115 | 1425 | 28 |
2312304 | 2312304 | 2022-03-16 | Dade | Missouri | 29057 | 1425 | 41 |
2312948 | 2312948 | 2022-03-16 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2313786 | 2313786 | 2022-03-16 | Mathews | Virginia | 51115 | 1425 | 28 |
2309051 | 2309051 | 2022-03-15 | Dade | Missouri | 29057 | 1425 | 41 |
2309695 | 2309695 | 2022-03-15 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2306442 | 2306442 | 2022-03-14 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2303191 | 2303191 | 2022-03-13 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2299939 | 2299939 | 2022-03-12 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2296687 | 2296687 | 2022-03-11 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2296880 | 2296880 | 2022-03-11 | Guanica | Puerto Rico | 72055 | 1425 | |
2293435 | 2293435 | 2022-03-10 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2290793 | 2290793 | 2022-03-09 | Lynn | Texas | 48305 | 1425 | 37 |
2286073 | 2286073 | 2022-03-08 | Oscoda | Michigan | 26135 | 1425 | 54 |
2282821 | 2282821 | 2022-03-07 | Oscoda | Michigan | 26135 | 1425 | 54 |
2279568 | 2279568 | 2022-03-06 | Oscoda | Michigan | 26135 | 1425 | 54 |
2276315 | 2276315 | 2022-03-05 | Oscoda | Michigan | 26135 | 1425 | 54 |
2273062 | 2273062 | 2022-03-04 | Oscoda | Michigan | 26135 | 1425 | 54 |
2265147 | 2265147 | 2022-03-01 | Wirt | West Virginia | 54105 | 1425 | 23 |
2261897 | 2261897 | 2022-02-28 | Wirt | West Virginia | 54105 | 1425 | 23 |
2211074 | 2211074 | 2022-02-13 | Owsley | Kentucky | 21189 | 1425 | 23 |
2207821 | 2207821 | 2022-02-12 | Owsley | Kentucky | 21189 | 1425 | 23 |
2204568 | 2204568 | 2022-02-11 | Owsley | Kentucky | 21189 | 1425 | 23 |
2198649 | 2198649 | 2022-02-09 | Cedar | Nebraska | 31027 | 1425 | 11 |
2174767 | 2174767 | 2022-02-02 | Caribou | Idaho | 16029 | 1425 | 25 |
2175916 | 2175916 | 2022-02-02 | Keith | Nebraska | 31101 | 1425 | 14 |
2172457 | 2172457 | 2022-02-01 | Carter | Missouri | 29035 | 1425 | 19 |
2086121 | 2086121 | 2022-01-05 | Madison | Virginia | 51113 | 1425 | 25 |
2082019 | 2082019 | 2022-01-04 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2078767 | 2078767 | 2022-01-03 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2075516 | 2075516 | 2022-01-02 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2076044 | 2076044 | 2022-01-02 | Dallam | Texas | 48111 | 1425 | 32 |
2072265 | 2072265 | 2022-01-01 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2072793 | 2072793 | 2022-01-01 | Dallam | Texas | 48111 | 1425 | 32 |
2069014 | 2069014 | 2021-12-31 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2069542 | 2069542 | 2021-12-31 | Dallam | Texas | 48111 | 1425 | 32 |
2065763 | 2065763 | 2021-12-30 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2066291 | 2066291 | 2021-12-30 | Dallam | Texas | 48111 | 1425 | 32 |
2062513 | 2062513 | 2021-12-29 | Alfalfa | Oklahoma | 40003 | 1425 | 10 |
2037665 | 2037665 | 2021-12-22 | Perry | Alabama | 1105 | 1425 | 41 |
2037895 | 2037895 | 2021-12-22 | Lincoln | Colorado | 8073 | 1425 | 8 |
2039255 | 2039255 | 2021-12-22 | Madison | Montana | 30057 | 1425 | 20 |
2035343 | 2035343 | 2021-12-21 | Russell | Kansas | 20167 | 1425 | 34 |
2032093 | 2032093 | 2021-12-20 | Russell | Kansas | 20167 | 1425 | 34 |
2032803 | 2032803 | 2021-12-20 | Cuming | Nebraska | 31039 | 1425 | 15 |
2021133 | 2021133 | 2021-12-16 | Poquoson city | Virginia | 51735 | 1425 | 23 |
2014960 | 2014960 | 2021-12-15 | Greenlee | Arizona | 4011 | 1425 | 23 |
2017233 | 2017233 | 2021-12-15 | Lares | Puerto Rico | 72081 | 1425 | |
2013983 | 2013983 | 2021-12-14 | Lares | Puerto Rico | 72081 | 1425 | |
2010732 | 2010732 | 2021-12-13 | Lares | Puerto Rico | 72081 | 1425 | |
2006268 | 2006268 | 2021-12-12 | Red River | Louisiana | 22081 | 1425 | 49 |
2007481 | 2007481 | 2021-12-12 | Lares | Puerto Rico | 72081 | 1425 | |
2003017 | 2003017 | 2021-12-11 | Red River | Louisiana | 22081 | 1425 | 49 |
1998765 | 1998765 | 2021-12-10 | Nevada | Arkansas | 5099 | 1425 | 41 |
1999767 | 1999767 | 2021-12-10 | Red River | Louisiana | 22081 | 1425 | 49 |
1996516 | 1996516 | 2021-12-09 | Red River | Louisiana | 22081 | 1425 | 49 |
1991048 | 1991048 | 2021-12-07 | Major | Oklahoma | 40093 | 1425 | 33 |
1987797 | 1987797 | 2021-12-06 | Major | Oklahoma | 40093 | 1425 | 33 |
1984547 | 1984547 | 2021-12-05 | Major | Oklahoma | 40093 | 1425 | 33 |
1981297 | 1981297 | 2021-12-04 | Major | Oklahoma | 40093 | 1425 | 33 |
1978047 | 1978047 | 2021-12-03 | Major | Oklahoma | 40093 | 1425 | 33 |
1974797 | 1974797 | 2021-12-02 | Major | Oklahoma | 40093 | 1425 | 32 |
1971548 | 1971548 | 2021-12-01 | Major | Oklahoma | 40093 | 1425 | 32 |
1968922 | 1968922 | 2021-11-30 | Red River | Texas | 48387 | 1425 | 55 |
1963167 | 1963167 | 2021-11-29 | Unknown | Connecticut | 1425 | 3 | |
1944919 | 1944919 | 2021-11-23 | Oregon | Missouri | 29149 | 1425 | 24 |
1939855 | 1939855 | 2021-11-21 | Nelson | Virginia | 51125 | 1425 | 19 |
1936605 | 1936605 | 2021-11-20 | Nelson | Virginia | 51125 | 1425 | 19 |
1933355 | 1933355 | 2021-11-19 | Nelson | Virginia | 51125 | 1425 | 19 |
1929581 | 1929581 | 2021-11-18 | Grant | South Dakota | 46051 | 1425 | 46 |
1918439 | 1918439 | 2021-11-15 | Owen | Kentucky | 21187 | 1425 | 26 |
1918888 | 1918888 | 2021-11-15 | Iron | Missouri | 29093 | 1425 | 15 |
1903150 | 1903150 | 2021-11-10 | Traill | North Dakota | 38097 | 1425 | 21 |
1900200 | 1900200 | 2021-11-09 | Coamo | Puerto Rico | 72043 | 1425 | |
1896950 | 1896950 | 2021-11-08 | Coamo | Puerto Rico | 72043 | 1425 | |
1893700 | 1893700 | 2021-11-07 | Coamo | Puerto Rico | 72043 | 1425 | |
1887184 | 1887184 | 2021-11-05 | Anasco | Puerto Rico | 72011 | 1425 | |
1883934 | 1883934 | 2021-11-04 | Anasco | Puerto Rico | 72011 | 1425 |
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);