ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where cases = 1424 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 32
- Iowa 26
- Kansas 19
- Virginia 15
- Missouri 13
- Alabama 10
- Georgia 10
- Illinois 10
- Kentucky 10
- Louisiana 10
- Texas 10
- North Carolina 9
- Oklahoma 9
- Alaska 8
- Minnesota 8
- North Dakota 8
- Tennessee 8
- California 7
- Colorado 7
- Florida 6
- New York 6
- South Carolina 6
- West Virginia 6
- Pennsylvania 5
- South Dakota 5
- Maine 4
- Michigan 4
- Montana 4
- Nebraska 4
- New Mexico 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451679 | 2451679 | 2022-04-28 | Mitchell | Kansas | 20123 | 1424 | 22 |
2448423 | 2448423 | 2022-04-27 | Mitchell | Kansas | 20123 | 1424 | 22 |
2444294 | 2444294 | 2022-04-26 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2445167 | 2445167 | 2022-04-26 | Mitchell | Kansas | 20123 | 1424 | 22 |
2441038 | 2441038 | 2022-04-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2441911 | 2441911 | 2022-04-25 | Mitchell | Kansas | 20123 | 1424 | 22 |
2437782 | 2437782 | 2022-04-24 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2438655 | 2438655 | 2022-04-24 | Mitchell | Kansas | 20123 | 1424 | 22 |
2434526 | 2434526 | 2022-04-23 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2435399 | 2435399 | 2022-04-23 | Mitchell | Kansas | 20123 | 1424 | 22 |
2431270 | 2431270 | 2022-04-22 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2432143 | 2432143 | 2022-04-22 | Mitchell | Kansas | 20123 | 1424 | 22 |
2428014 | 2428014 | 2022-04-21 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2428887 | 2428887 | 2022-04-21 | Mitchell | Kansas | 20123 | 1424 | 22 |
2424758 | 2424758 | 2022-04-20 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1424 | 8 |
2425631 | 2425631 | 2022-04-20 | Mitchell | Kansas | 20123 | 1424 | 22 |
2422375 | 2422375 | 2022-04-19 | Mitchell | Kansas | 20123 | 1424 | 22 |
2419119 | 2419119 | 2022-04-18 | Mitchell | Kansas | 20123 | 1424 | 22 |
2415863 | 2415863 | 2022-04-17 | Mitchell | Kansas | 20123 | 1424 | 22 |
2412607 | 2412607 | 2022-04-16 | Mitchell | Kansas | 20123 | 1424 | 22 |
2409351 | 2409351 | 2022-04-15 | Mitchell | Kansas | 20123 | 1424 | 22 |
2319921 | 2319921 | 2022-03-18 | Bailey | Texas | 48017 | 1424 | 39 |
2305799 | 2305799 | 2022-03-14 | Dade | Missouri | 29057 | 1424 | 40 |
2293628 | 2293628 | 2022-03-10 | Guanica | Puerto Rico | 72055 | 1424 | |
2290376 | 2290376 | 2022-03-09 | Guanica | Puerto Rico | 72055 | 1424 | |
2287124 | 2287124 | 2022-03-08 | Guanica | Puerto Rico | 72055 | 1424 | |
2283872 | 2283872 | 2022-03-07 | Guanica | Puerto Rico | 72055 | 1424 | |
2268400 | 2268400 | 2022-03-02 | Wirt | West Virginia | 54105 | 1424 | 23 |
2176212 | 2176212 | 2022-02-02 | Dickey | North Dakota | 38021 | 1424 | 38 |
2169204 | 2169204 | 2022-01-31 | Carter | Missouri | 29035 | 1424 | 19 |
2169285 | 2169285 | 2022-01-31 | Shelby | Missouri | 29205 | 1424 | 13 |
2165949 | 2165949 | 2022-01-30 | Carter | Missouri | 29035 | 1424 | 19 |
2156680 | 2156680 | 2022-01-27 | Bottineau | North Dakota | 38009 | 1424 | 24 |
2157162 | 2157162 | 2022-01-27 | Hamlin | South Dakota | 46057 | 1424 | 40 |
2148462 | 2148462 | 2022-01-25 | Rio Blanco | Colorado | 8103 | 1424 | 13 |
2147563 | 2147563 | 2022-01-24 | Brooks | Texas | 48047 | 1424 | 48 |
2128919 | 2128919 | 2022-01-19 | Kit Carson | Colorado | 8063 | 1424 | 28 |
2128169 | 2128169 | 2022-01-18 | Marion | Texas | 48315 | 1424 | 55 |
2123867 | 2123867 | 2022-01-17 | Merrick | Nebraska | 31121 | 1424 | 15 |
2107708 | 2107708 | 2022-01-12 | Los Alamos | New Mexico | 35028 | 1424 | 11 |
2108580 | 2108580 | 2022-01-12 | Floyd | Texas | 48153 | 1424 | 41 |
2108934 | 2108934 | 2022-01-12 | Williamsburg city | Virginia | 51830 | 1424 | 13 |
2100468 | 2100468 | 2022-01-10 | Nicholas | Kentucky | 21181 | 1424 | 29 |
2078375 | 2078375 | 2022-01-03 | Wayne | Nebraska | 31179 | 1424 | 10 |
2072464 | 2072464 | 2022-01-01 | Ciales | Puerto Rico | 72039 | 1424 | |
2069213 | 2069213 | 2021-12-31 | Ciales | Puerto Rico | 72039 | 1424 | |
2046517 | 2046517 | 2021-12-24 | Utuado | Puerto Rico | 72141 | 1424 | |
2041145 | 2041145 | 2021-12-23 | Lincoln | Colorado | 8073 | 1424 | 8 |
2043267 | 2043267 | 2021-12-23 | Utuado | Puerto Rico | 72141 | 1424 | |
2034415 | 2034415 | 2021-12-21 | Perry | Alabama | 1105 | 1424 | 41 |
2031165 | 2031165 | 2021-12-20 | Perry | Alabama | 1105 | 1424 | 41 |
2032651 | 2032651 | 2021-12-20 | Harrison | Missouri | 29081 | 1424 | 21 |
2027914 | 2027914 | 2021-12-19 | Perry | Alabama | 1105 | 1424 | 41 |
2029400 | 2029400 | 2021-12-19 | Harrison | Missouri | 29081 | 1424 | 21 |
2030254 | 2030254 | 2021-12-19 | Quebradillas | Puerto Rico | 72115 | 1424 | |
2024663 | 2024663 | 2021-12-18 | Perry | Alabama | 1105 | 1424 | 41 |
2021412 | 2021412 | 2021-12-17 | Perry | Alabama | 1105 | 1424 | 41 |
2018161 | 2018161 | 2021-12-16 | Perry | Alabama | 1105 | 1424 | 41 |
2017882 | 2017882 | 2021-12-15 | Poquoson city | Virginia | 51735 | 1424 | 23 |
2011709 | 2011709 | 2021-12-14 | Greenlee | Arizona | 4011 | 1424 | 23 |
2012721 | 2012721 | 2021-12-14 | Trimble | Kentucky | 21223 | 1424 | 28 |
2004230 | 2004230 | 2021-12-11 | Lares | Puerto Rico | 72081 | 1424 | |
2000979 | 2000979 | 2021-12-10 | Lares | Puerto Rico | 72081 | 1424 | |
1995514 | 1995514 | 2021-12-09 | Nevada | Arkansas | 5099 | 1424 | 41 |
1996387 | 1996387 | 2021-12-09 | Elliott | Kentucky | 21063 | 1424 | 13 |
1997729 | 1997729 | 2021-12-09 | Lares | Puerto Rico | 72081 | 1424 | |
1994466 | 1994466 | 2021-12-08 | Guayama | Puerto Rico | 72057 | 1424 | |
1991215 | 1991215 | 2021-12-07 | Guayama | Puerto Rico | 72057 | 1424 | |
1991305 | 1991305 | 2021-12-07 | McCormick | South Carolina | 45065 | 1424 | 30 |
1987964 | 1987964 | 2021-12-06 | Guayama | Puerto Rico | 72057 | 1424 | |
1941805 | 1941805 | 2021-11-22 | Hamilton | Nebraska | 31081 | 1424 | 19 |
1904232 | 1904232 | 2021-11-10 | Pleasants | West Virginia | 54073 | 1424 | 30 |
1882352 | 1882352 | 2021-11-04 | Martin | Indiana | 18101 | 1424 | 20 |
1877436 | 1877436 | 2021-11-02 | Anasco | Puerto Rico | 72011 | 1424 | |
1874187 | 1874187 | 2021-11-01 | Anasco | Puerto Rico | 72011 | 1424 | |
1870938 | 1870938 | 2021-10-31 | Anasco | Puerto Rico | 72011 | 1424 | |
1867689 | 1867689 | 2021-10-30 | Anasco | Puerto Rico | 72011 | 1424 | |
1864440 | 1864440 | 2021-10-29 | Anasco | Puerto Rico | 72011 | 1424 | |
1861191 | 1861191 | 2021-10-28 | Anasco | Puerto Rico | 72011 | 1424 | |
1861785 | 1861785 | 2021-10-28 | Amelia | Virginia | 51007 | 1424 | 40 |
1852438 | 1852438 | 2021-10-26 | Nome Census Area | Alaska | 2180 | 1424 | 1 |
1825704 | 1825704 | 2021-10-17 | Moore | Tennessee | 47127 | 1424 | 21 |
1826021 | 1826021 | 2021-10-17 | Addison | Vermont | 50001 | 1424 | 8 |
1822455 | 1822455 | 2021-10-16 | Moore | Tennessee | 47127 | 1424 | 21 |
1823004 | 1823004 | 2021-10-16 | Ritchie | West Virginia | 54085 | 1424 | 17 |
1819206 | 1819206 | 2021-10-15 | Moore | Tennessee | 47127 | 1424 | 21 |
1813614 | 1813614 | 2021-10-14 | Archuleta | Colorado | 8007 | 1424 | 4 |
1758606 | 1758606 | 2021-09-27 | Lanier | Georgia | 13173 | 1424 | 14 |
1759757 | 1759757 | 2021-09-27 | Fergus | Montana | 30027 | 1424 | 36 |
1760671 | 1760671 | 2021-09-27 | Clay | Tennessee | 47027 | 1424 | 35 |
1756786 | 1756786 | 2021-09-26 | Yates | New York | 36123 | 1424 | 26 |
1754027 | 1754027 | 2021-09-25 | Salinas | Puerto Rico | 72123 | 1424 | |
1750779 | 1750779 | 2021-09-24 | Salinas | Puerto Rico | 72123 | 1424 | |
1746529 | 1746529 | 2021-09-23 | Rock | Minnesota | 27133 | 1424 | 19 |
1747530 | 1747530 | 2021-09-23 | Salinas | Puerto Rico | 72123 | 1424 | |
1737387 | 1737387 | 2021-09-20 | Washington | North Carolina | 37187 | 1424 | 34 |
1721524 | 1721524 | 2021-09-15 | Naguabo | Puerto Rico | 72103 | 1424 | |
1716734 | 1716734 | 2021-09-14 | Humboldt | Iowa | 19091 | 1424 | 26 |
1713488 | 1713488 | 2021-09-13 | Humboldt | Iowa | 19091 | 1424 | 26 |
1714230 | 1714230 | 2021-09-13 | Ralls | Missouri | 29173 | 1424 | 14 |
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);