ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
273 rows where cases = 1953 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 17
- Texas 17
- Georgia 14
- Wisconsin 14
- Alabama 12
- Kentucky 12
- Arkansas 11
- Indiana 11
- Iowa 11
- Virginia 11
- West Virginia 11
- Puerto Rico 10
- Montana 8
- New York 7
- North Carolina 7
- Tennessee 7
- Washington 7
- Michigan 6
- New Mexico 6
- North Dakota 6
- Ohio 6
- Oregon 6
- Kansas 5
- Pennsylvania 5
- South Dakota 5
- Illinois 4
- South Carolina 4
- Alaska 3
- Maryland 3
- Vermont 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486488 | 2486488 | 2022-05-08 | Menominee | Wisconsin | 55078 | 1953 | 14 |
2483230 | 2483230 | 2022-05-07 | Menominee | Wisconsin | 55078 | 1953 | 14 |
2479972 | 2479972 | 2022-05-06 | Menominee | Wisconsin | 55078 | 1953 | 14 |
2395256 | 2395256 | 2022-04-10 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2392000 | 2392000 | 2022-04-09 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2388744 | 2388744 | 2022-04-08 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2349532 | 2349532 | 2022-03-27 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2346279 | 2346279 | 2022-03-26 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2343026 | 2343026 | 2022-03-25 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2339773 | 2339773 | 2022-03-24 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2336755 | 2336755 | 2022-03-23 | Pepin | Wisconsin | 55091 | 1953 | 18 |
2333501 | 2333501 | 2022-03-22 | Pepin | Wisconsin | 55091 | 1953 | 18 |
2301965 | 2301965 | 2022-03-13 | Kingman | Kansas | 20095 | 1953 | 26 |
2297938 | 2297938 | 2022-03-12 | Prairie | Arkansas | 5117 | 1953 | 41 |
2298713 | 2298713 | 2022-03-12 | Kingman | Kansas | 20095 | 1953 | 26 |
2294686 | 2294686 | 2022-03-11 | Prairie | Arkansas | 5117 | 1953 | 41 |
2295461 | 2295461 | 2022-03-11 | Kingman | Kansas | 20095 | 1953 | 26 |
2294233 | 2294233 | 2022-03-10 | Fairfax city | Virginia | 51600 | 1953 | 43 |
2284477 | 2284477 | 2022-03-07 | Fairfax city | Virginia | 51600 | 1953 | 43 |
2264034 | 2264034 | 2022-03-01 | Pembina | North Dakota | 38067 | 1953 | 16 |
2261711 | 2261711 | 2022-02-28 | Fairfax city | Virginia | 51600 | 1953 | 43 |
2254250 | 2254250 | 2022-02-26 | Benson | North Dakota | 38005 | 1953 | 22 |
2254631 | 2254631 | 2022-02-26 | Patillas | Puerto Rico | 72109 | 1953 | |
2250999 | 2250999 | 2022-02-25 | Benson | North Dakota | 38005 | 1953 | 22 |
2248266 | 2248266 | 2022-02-24 | Turner | South Dakota | 46125 | 1953 | 62 |
2248463 | 2248463 | 2022-02-24 | Hamilton | Texas | 48193 | 1953 | 31 |
2244180 | 2244180 | 2022-02-23 | Custer | Nebraska | 31041 | 1953 | 28 |
2245015 | 2245015 | 2022-02-23 | Turner | South Dakota | 46125 | 1953 | 62 |
2245212 | 2245212 | 2022-02-23 | Hamilton | Texas | 48193 | 1953 | 30 |
2241961 | 2241961 | 2022-02-22 | Hamilton | Texas | 48193 | 1953 | 30 |
2238710 | 2238710 | 2022-02-21 | Hamilton | Texas | 48193 | 1953 | 30 |
2235459 | 2235459 | 2022-02-20 | Hamilton | Texas | 48193 | 1953 | 30 |
2232208 | 2232208 | 2022-02-19 | Hamilton | Texas | 48193 | 1953 | 30 |
2216493 | 2216493 | 2022-02-15 | Choctaw | Alabama | 1023 | 1953 | 33 |
2215065 | 2215065 | 2022-02-14 | Quay | New Mexico | 35037 | 1953 | 44 |
2205837 | 2205837 | 2022-02-11 | Guayanilla | Puerto Rico | 72059 | 1953 | |
2197533 | 2197533 | 2022-02-09 | Boundary | Idaho | 16021 | 1953 | 55 |
2198330 | 2198330 | 2022-02-09 | Lake | Minnesota | 27075 | 1953 | 27 |
2180129 | 2180129 | 2022-02-03 | Dallam | Texas | 48111 | 1953 | 35 |
2180252 | 2180252 | 2022-02-03 | Ochiltree | Texas | 48357 | 1953 | 43 |
2177001 | 2177001 | 2022-02-02 | Ochiltree | Texas | 48357 | 1953 | 43 |
2167741 | 2167741 | 2022-01-31 | Perry | Alabama | 1105 | 1953 | 40 |
2166049 | 2166049 | 2022-01-30 | Beaverhead | Montana | 30001 | 1953 | 24 |
2167521 | 2167521 | 2022-01-30 | Lincoln | Washington | 53043 | 1953 | 27 |
2162794 | 2162794 | 2022-01-29 | Beaverhead | Montana | 30001 | 1953 | 24 |
2164266 | 2164266 | 2022-01-29 | Lincoln | Washington | 53043 | 1953 | 27 |
2159539 | 2159539 | 2022-01-28 | Beaverhead | Montana | 30001 | 1953 | 24 |
2161011 | 2161011 | 2022-01-28 | Lincoln | Washington | 53043 | 1953 | 27 |
2143200 | 2143200 | 2022-01-23 | Howard | Missouri | 29089 | 1953 | 22 |
2139971 | 2139971 | 2022-01-22 | Monroe | Missouri | 29137 | 1953 | 38 |
2125561 | 2125561 | 2022-01-18 | Scott | Arkansas | 5127 | 1953 | 35 |
2110754 | 2110754 | 2022-01-13 | Dawson | Montana | 30021 | 1953 | 53 |
2112105 | 2112105 | 2022-01-13 | Galax city | Virginia | 51640 | 1953 | 70 |
2107415 | 2107415 | 2022-01-12 | Grundy | Missouri | 29079 | 1953 | 60 |
2098124 | 2098124 | 2022-01-09 | Washington | North Carolina | 37187 | 1953 | 39 |
2094872 | 2094872 | 2022-01-08 | Washington | North Carolina | 37187 | 1953 | 39 |
2091620 | 2091620 | 2022-01-07 | Washington | North Carolina | 37187 | 1953 | 39 |
2083208 | 2083208 | 2022-01-05 | Valdez-Cordova Census Area | Alaska | 2261 | 1953 | 12 |
2079956 | 2079956 | 2022-01-04 | Valdez-Cordova Census Area | Alaska | 2261 | 1953 | 12 |
2076704 | 2076704 | 2022-01-03 | Valdez-Cordova Census Area | Alaska | 2261 | 1953 | 12 |
2057409 | 2057409 | 2021-12-28 | Rio Grande | Colorado | 8105 | 1953 | 40 |
2050629 | 2050629 | 2021-12-26 | Conecuh | Alabama | 1035 | 1953 | 62 |
2052948 | 2052948 | 2021-12-26 | Aguas Buenas | Puerto Rico | 72007 | 1953 | |
2047379 | 2047379 | 2021-12-25 | Conecuh | Alabama | 1035 | 1953 | 62 |
2036397 | 2036397 | 2021-12-21 | Mercer | North Dakota | 38057 | 1953 | 22 |
2032616 | 2032616 | 2021-12-20 | Barton | Missouri | 29011 | 1953 | 40 |
2013754 | 2013754 | 2021-12-14 | Vinton | Ohio | 39163 | 1953 | 41 |
2009874 | 2009874 | 2021-12-13 | Cedar | Missouri | 29039 | 1953 | 42 |
2003361 | 2003361 | 2021-12-11 | Bollinger | Missouri | 29017 | 1953 | 33 |
1951752 | 1951752 | 2021-11-25 | Yates | New York | 36123 | 1953 | 33 |
1938689 | 1938689 | 2021-11-21 | Torrance | New Mexico | 35057 | 1953 | 21 |
1939197 | 1939197 | 2021-11-21 | Cidra | Puerto Rico | 72041 | 1953 | |
1935439 | 1935439 | 2021-11-20 | Torrance | New Mexico | 35057 | 1953 | 21 |
1932189 | 1932189 | 2021-11-19 | Torrance | New Mexico | 35057 | 1953 | 21 |
1928936 | 1928936 | 2021-11-18 | Socorro | New Mexico | 35053 | 1953 | 64 |
1895834 | 1895834 | 2021-11-08 | Nantucket | Massachusetts | 25019 | 1953 | 0 |
1890132 | 1890132 | 2021-11-06 | Mountrail | North Dakota | 38061 | 1953 | 27 |
1882925 | 1882925 | 2021-11-04 | Aitkin | Minnesota | 27001 | 1953 | 46 |
1859927 | 1859927 | 2021-10-28 | Lyon | Kentucky | 21143 | 1953 | 26 |
1855246 | 1855246 | 2021-10-26 | Juab | Utah | 49023 | 1953 | 18 |
1830576 | 1830576 | 2021-10-19 | Osage | Kansas | 20139 | 1953 | 34 |
1827327 | 1827327 | 2021-10-18 | Osage | Kansas | 20139 | 1953 | 34 |
1811131 | 1811131 | 2021-10-13 | Breathitt | Kentucky | 21025 | 1953 | 24 |
1787226 | 1787226 | 2021-10-05 | Braxton | West Virginia | 54007 | 1953 | 15 |
1783224 | 1783224 | 2021-10-04 | Cayey | Puerto Rico | 72035 | 1953 | |
1780756 | 1780756 | 2021-10-03 | Monroe | West Virginia | 54063 | 1953 | 25 |
1776669 | 1776669 | 2021-10-02 | Fulton | Pennsylvania | 42057 | 1953 | 26 |
1777486 | 1777486 | 2021-10-02 | Grant | West Virginia | 54023 | 1953 | 31 |
1746336 | 1746336 | 2021-09-23 | Waldo | Maine | 23027 | 1953 | 28 |
1742005 | 1742005 | 2021-09-22 | Chicot | Arkansas | 5017 | 1953 | 44 |
1733715 | 1733715 | 2021-09-19 | Pemiscot | Missouri | 29155 | 1953 | 41 |
1734521 | 1734521 | 2021-09-19 | Morovis | Puerto Rico | 72101 | 1953 | |
1731271 | 1731271 | 2021-09-18 | Morovis | Puerto Rico | 72101 | 1953 | |
1722305 | 1722305 | 2021-09-15 | Crawford | Wisconsin | 55023 | 1953 | 22 |
1693306 | 1693306 | 2021-09-07 | Lee | Arkansas | 5077 | 1953 | 40 |
1690432 | 1690432 | 2021-09-06 | Telfair | Georgia | 13271 | 1953 | 61 |
1691412 | 1691412 | 2021-09-06 | Bates | Missouri | 29013 | 1953 | 37 |
1693029 | 1693029 | 2021-09-06 | Lincoln | West Virginia | 54043 | 1953 | 29 |
1687182 | 1687182 | 2021-09-05 | Telfair | Georgia | 13271 | 1953 | 61 |
1683932 | 1683932 | 2021-09-04 | Telfair | Georgia | 13271 | 1953 | 61 |
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);