ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 7034 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Virgin Islands 7
- Montana 5
- Georgia 4
- Tennessee 4
- Idaho 3
- Kentucky 3
- Mississippi 3
- Ohio 3
- West Virginia 3
- Louisiana 2
- Missouri 2
- Pennsylvania 2
- South Carolina 2
- Texas 2
- Virginia 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Florida 1
- New Hampshire 1
- New Mexico 1
- New York 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492963 | 2492963 | 2022-05-10 | Wyoming | West Virginia | 54109 | 7034 | 116 |
2489705 | 2489705 | 2022-05-09 | Wyoming | West Virginia | 54109 | 7034 | 116 |
2452509 | 2452509 | 2022-04-28 | Coos | New Hampshire | 33007 | 7034 | 113 |
2427867 | 2427867 | 2022-04-20 | Lincoln | Wisconsin | 55069 | 7034 | 148 |
2407392 | 2407392 | 2022-04-14 | Lincoln | Oregon | 41041 | 7034 | 84 |
2393773 | 2393773 | 2022-04-10 | Ravalli | Montana | 30081 | 7034 | 141 |
2390517 | 2390517 | 2022-04-09 | Ravalli | Montana | 30081 | 7034 | 141 |
2387261 | 2387261 | 2022-04-08 | Ravalli | Montana | 30081 | 7034 | 141 |
2384006 | 2384006 | 2022-04-07 | Ravalli | Montana | 30081 | 7034 | 141 |
2270865 | 2270865 | 2022-03-03 | Gurabo | Puerto Rico | 72063 | 7034 | |
2247272 | 2247272 | 2022-02-24 | Dunklin | Missouri | 29069 | 7034 | 108 |
2245417 | 2245417 | 2022-02-23 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2245519 | 2245519 | 2022-02-23 | Pulaski | Virginia | 51155 | 7034 | 120 |
2242166 | 2242166 | 2022-02-22 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2238915 | 2238915 | 2022-02-21 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2235664 | 2235664 | 2022-02-20 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2232413 | 2232413 | 2022-02-19 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2229162 | 2229162 | 2022-02-18 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2225911 | 2225911 | 2022-02-17 | St. Thomas | Virgin Islands | 78030 | 7034 | 58 |
2138448 | 2138448 | 2022-01-22 | Marion | Alabama | 1093 | 7034 | 134 |
2134326 | 2134326 | 2022-01-20 | Clarendon | South Carolina | 45027 | 7034 | 141 |
2106470 | 2106470 | 2022-01-12 | Nez Perce | Idaho | 16069 | 7034 | 119 |
1961679 | 1961679 | 2021-11-28 | Crawford | Ohio | 39033 | 7034 | 150 |
1916695 | 1916695 | 2021-11-14 | Rhea | Tennessee | 47143 | 7034 | 94 |
1913445 | 1913445 | 2021-11-13 | Rhea | Tennessee | 47143 | 7034 | 94 |
1910195 | 1910195 | 2021-11-12 | Rhea | Tennessee | 47143 | 7034 | 94 |
1904909 | 1904909 | 2021-11-11 | Bingham | Idaho | 16011 | 7034 | 124 |
1901659 | 1901659 | 2021-11-10 | Bingham | Idaho | 16011 | 7034 | 124 |
1886905 | 1886905 | 2021-11-05 | Williams | North Dakota | 38105 | 7034 | 52 |
1884136 | 1884136 | 2021-11-04 | Cheatham | Tennessee | 47021 | 7034 | 71 |
1814492 | 1814492 | 2021-10-14 | Avoyelles | Louisiana | 22009 | 7034 | 177 |
1806047 | 1806047 | 2021-10-11 | Chesterfield | South Carolina | 45025 | 7034 | 140 |
1779093 | 1779093 | 2021-10-03 | Oktibbeha | Mississippi | 28105 | 7034 | 124 |
1775843 | 1775843 | 2021-10-02 | Oktibbeha | Mississippi | 28105 | 7034 | 124 |
1772593 | 1772593 | 2021-10-01 | Oktibbeha | Mississippi | 28105 | 7034 | 124 |
1773409 | 1773409 | 2021-10-01 | Columbia | Pennsylvania | 42037 | 7034 | 143 |
1718772 | 1718772 | 2021-09-14 | Box Elder | Utah | 49003 | 7034 | 65 |
1709824 | 1709824 | 2021-09-12 | Colquitt | Georgia | 13071 | 7034 | 145 |
1706577 | 1706577 | 2021-09-11 | Colquitt | Georgia | 13071 | 7034 | 145 |
1703329 | 1703329 | 2021-09-10 | Colquitt | Georgia | 13071 | 7034 | 145 |
1701931 | 1701931 | 2021-09-09 | Carbon | Pennsylvania | 42025 | 7034 | 178 |
1660149 | 1660149 | 2021-08-27 | Harrison | Texas | 48203 | 7034 | 123 |
1621820 | 1621820 | 2021-08-16 | Crittenden | Arkansas | 5035 | 7034 | 104 |
1605140 | 1605140 | 2021-08-10 | Bedford | Virginia | 51019 | 7034 | 110 |
1536084 | 1536084 | 2021-07-20 | Hancock | Ohio | 39063 | 7034 | 134 |
1531823 | 1531823 | 2021-07-19 | McCracken | Kentucky | 21145 | 7034 | 135 |
1441489 | 1441489 | 2021-06-21 | Lewis and Clark | Montana | 30049 | 7034 | 89 |
1315099 | 1315099 | 2021-05-13 | Valencia | New Mexico | 35061 | 7034 | 109 |
1291672 | 1291672 | 2021-05-06 | Iberia | Louisiana | 22045 | 7034 | 153 |
1262323 | 1262323 | 2021-04-27 | Bullitt | Kentucky | 21029 | 7034 | 72 |
1243708 | 1243708 | 2021-04-21 | Oswego | New York | 36075 | 7034 | 90 |
1232424 | 1232424 | 2021-04-18 | Flagler | Florida | 12035 | 7034 | 106 |
1105393 | 1105393 | 2021-03-09 | Portage | Wisconsin | 55097 | 7034 | 67 |
1096792 | 1096792 | 2021-03-07 | Oldham | Kentucky | 21185 | 7034 | 69 |
1080000 | 1080000 | 2021-03-02 | Troup | Georgia | 13285 | 7034 | 199 |
1072882 | 1072882 | 2021-02-27 | Wood | West Virginia | 54107 | 7034 | 131 |
991263 | 991263 | 2021-02-02 | Coryell | Texas | 48099 | 7034 | 57 |
980397 | 980397 | 2021-01-30 | Jasper | Missouri | 29097 | 7034 | 101 |
958281 | 958281 | 2021-01-23 | Wayne | Ohio | 39169 | 7034 | 171 |
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);