ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
452 rows where cases = 966 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 42
- Indiana 26
- Mississippi 26
- Kansas 25
- Iowa 24
- Kentucky 24
- Michigan 23
- Georgia 22
- Arkansas 15
- Puerto Rico 14
- Louisiana 13
- Missouri 13
- Virginia 13
- Colorado 11
- Minnesota 11
- North Carolina 11
- Illinois 10
- Oklahoma 10
- North Dakota 9
- West Virginia 9
- Nebraska 8
- Alabama 6
- Idaho 6
- Pennsylvania 6
- South Dakota 6
- Utah 6
- Wyoming 6
- Alaska 5
- Tennessee 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483555 | 2483555 | 2022-05-08 | Gilpin | Colorado | 8047 | 966 | 4 |
2480297 | 2480297 | 2022-05-07 | Gilpin | Colorado | 8047 | 966 | 4 |
2477039 | 2477039 | 2022-05-06 | Gilpin | Colorado | 8047 | 966 | 4 |
2404041 | 2404041 | 2022-04-13 | Beaver | Oklahoma | 40007 | 966 | 11 |
2400786 | 2400786 | 2022-04-12 | Beaver | Oklahoma | 40007 | 966 | 11 |
2397531 | 2397531 | 2022-04-11 | Beaver | Oklahoma | 40007 | 966 | 11 |
2394276 | 2394276 | 2022-04-10 | Beaver | Oklahoma | 40007 | 966 | 11 |
2391020 | 2391020 | 2022-04-09 | Beaver | Oklahoma | 40007 | 966 | 11 |
2387764 | 2387764 | 2022-04-08 | Beaver | Oklahoma | 40007 | 966 | 11 |
2384509 | 2384509 | 2022-04-07 | Beaver | Oklahoma | 40007 | 966 | 11 |
2331848 | 2331848 | 2022-03-22 | Knox | Missouri | 29103 | 966 | 13 |
2310448 | 2310448 | 2022-03-15 | Unknown | Vermont | 966 | 2 | |
2283245 | 2283245 | 2022-03-07 | Nuckolls | Nebraska | 31129 | 966 | 13 |
2266267 | 2266267 | 2022-03-02 | Carlisle | Kentucky | 21039 | 966 | 19 |
2256802 | 2256802 | 2022-02-27 | Ontonagon | Michigan | 26131 | 966 | 36 |
2257487 | 2257487 | 2022-02-27 | Tyrrell | North Carolina | 37177 | 966 | 8 |
2253551 | 2253551 | 2022-02-26 | Ontonagon | Michigan | 26131 | 966 | 36 |
2254236 | 2254236 | 2022-02-26 | Tyrrell | North Carolina | 37177 | 966 | 8 |
2250300 | 2250300 | 2022-02-25 | Ontonagon | Michigan | 26131 | 966 | 36 |
2250985 | 2250985 | 2022-02-25 | Tyrrell | North Carolina | 37177 | 966 | 8 |
2247049 | 2247049 | 2022-02-24 | Ontonagon | Michigan | 26131 | 966 | 36 |
2243798 | 2243798 | 2022-02-23 | Ontonagon | Michigan | 26131 | 966 | 36 |
2233914 | 2233914 | 2022-02-20 | Unknown | Louisiana | 966 | 0 | |
2230663 | 2230663 | 2022-02-19 | Unknown | Louisiana | 966 | 0 | |
2227412 | 2227412 | 2022-02-18 | Unknown | Louisiana | 966 | 0 | |
2224161 | 2224161 | 2022-02-17 | Unknown | Louisiana | 966 | 0 | |
2220910 | 2220910 | 2022-02-16 | Unknown | Louisiana | 966 | 0 | |
2217659 | 2217659 | 2022-02-15 | Unknown | Louisiana | 966 | 0 | |
2214408 | 2214408 | 2022-02-14 | Unknown | Louisiana | 966 | 0 | |
2215251 | 2215251 | 2022-02-14 | Foster | North Dakota | 38031 | 966 | 21 |
2212000 | 2212000 | 2022-02-13 | Foster | North Dakota | 38031 | 966 | 21 |
2208747 | 2208747 | 2022-02-12 | Foster | North Dakota | 38031 | 966 | 21 |
2172989 | 2172989 | 2022-02-01 | Sargent | North Dakota | 38081 | 966 | 9 |
2164999 | 2164999 | 2022-01-30 | Boise | Idaho | 16015 | 966 | 13 |
2166493 | 2166493 | 2022-01-30 | Wells | North Dakota | 38103 | 966 | 11 |
2161744 | 2161744 | 2022-01-29 | Boise | Idaho | 16015 | 966 | 13 |
2163238 | 2163238 | 2022-01-29 | Wells | North Dakota | 38103 | 966 | 11 |
2156211 | 2156211 | 2022-01-27 | Holt | Missouri | 29087 | 966 | 25 |
2149816 | 2149816 | 2022-01-25 | Pondera | Montana | 30073 | 966 | 6 |
2147587 | 2147587 | 2022-01-24 | Concho | Texas | 48095 | 966 | 10 |
2143334 | 2143334 | 2022-01-23 | Boone | Nebraska | 31011 | 966 | 4 |
2140079 | 2140079 | 2022-01-22 | Boone | Nebraska | 31011 | 966 | 4 |
2141083 | 2141083 | 2022-01-22 | Crockett | Texas | 48105 | 966 | 17 |
2136823 | 2136823 | 2022-01-21 | Boone | Nebraska | 31011 | 966 | 4 |
2132195 | 2132195 | 2022-01-20 | Saguache | Colorado | 8109 | 966 | 10 |
2125132 | 2125132 | 2022-01-17 | King and Queen | Virginia | 51097 | 966 | 9 |
2118280 | 2118280 | 2022-01-15 | Brewster | Texas | 48043 | 966 | 24 |
2100509 | 2100509 | 2022-01-10 | Cameron | Louisiana | 22023 | 966 | 8 |
2082347 | 2082347 | 2022-01-04 | Day | South Dakota | 46037 | 966 | 30 |
2079392 | 2079392 | 2022-01-03 | Lynn | Texas | 48305 | 966 | 29 |
2058042 | 2058042 | 2021-12-28 | Gray | Kansas | 20069 | 966 | 23 |
2054793 | 2054793 | 2021-12-27 | Gray | Kansas | 20069 | 966 | 23 |
2012551 | 2012551 | 2021-12-14 | Kearny | Kansas | 20093 | 966 | 17 |
2012583 | 2012583 | 2021-12-14 | Republic | Kansas | 20157 | 966 | 14 |
2009300 | 2009300 | 2021-12-13 | Kearny | Kansas | 20093 | 966 | 17 |
2009332 | 2009332 | 2021-12-13 | Republic | Kansas | 20157 | 966 | 14 |
2010097 | 2010097 | 2021-12-13 | Pierce | Nebraska | 31139 | 966 | 21 |
2011086 | 2011086 | 2021-12-13 | Hartley | Texas | 48205 | 966 | 2 |
2011159 | 2011159 | 2021-12-13 | Newton | Texas | 48351 | 966 | 54 |
2007835 | 2007835 | 2021-12-12 | Hartley | Texas | 48205 | 966 | 2 |
2007892 | 2007892 | 2021-12-12 | McCulloch | Texas | 48307 | 966 | 39 |
2007908 | 2007908 | 2021-12-12 | Newton | Texas | 48351 | 966 | 54 |
2008259 | 2008259 | 2021-12-12 | Wirt | West Virginia | 54105 | 966 | 17 |
2004641 | 2004641 | 2021-12-11 | McCulloch | Texas | 48307 | 966 | 39 |
2005008 | 2005008 | 2021-12-11 | Wirt | West Virginia | 54105 | 966 | 17 |
1991680 | 1991680 | 2021-12-07 | Sabine | Texas | 48403 | 966 | 77 |
1987650 | 1987650 | 2021-12-06 | Sioux | North Dakota | 38085 | 966 | 18 |
1988072 | 1988072 | 2021-12-06 | Brule | South Dakota | 46015 | 966 | 13 |
1988429 | 1988429 | 2021-12-06 | Sabine | Texas | 48403 | 966 | 77 |
1985179 | 1985179 | 2021-12-05 | Sabine | Texas | 48403 | 966 | 77 |
1971854 | 1971854 | 2021-12-01 | Kingsbury | South Dakota | 46077 | 966 | 18 |
1969283 | 1969283 | 2021-11-30 | Iron | Wisconsin | 55051 | 966 | 43 |
1928540 | 1928540 | 2021-11-18 | Jefferson | Mississippi | 28063 | 966 | 34 |
1925290 | 1925290 | 2021-11-17 | Jefferson | Mississippi | 28063 | 966 | 34 |
1922041 | 1922041 | 2021-11-16 | Jefferson | Mississippi | 28063 | 966 | 34 |
1903889 | 1903889 | 2021-11-10 | Mitchell | Texas | 48335 | 966 | 40 |
1900639 | 1900639 | 2021-11-09 | Mitchell | Texas | 48335 | 966 | 40 |
1901040 | 1901040 | 2021-11-09 | Menominee | Wisconsin | 55078 | 966 | 11 |
1872394 | 1872394 | 2021-11-01 | Wheeler | Georgia | 13309 | 966 | 34 |
1860140 | 1860140 | 2021-10-28 | Lake | Michigan | 26085 | 966 | 22 |
1860519 | 1860519 | 2021-10-28 | Toole | Montana | 30101 | 966 | 15 |
1856891 | 1856891 | 2021-10-27 | Lake | Michigan | 26085 | 966 | 22 |
1857270 | 1857270 | 2021-10-27 | Toole | Montana | 30101 | 966 | 15 |
1810116 | 1810116 | 2021-10-12 | Weston | Wyoming | 56045 | 966 | 8 |
1805212 | 1805212 | 2021-10-11 | Shannon | Missouri | 29203 | 966 | 17 |
1801780 | 1801780 | 2021-10-10 | Wilkin | Minnesota | 27167 | 966 | 14 |
1801963 | 1801963 | 2021-10-10 | Shannon | Missouri | 29203 | 966 | 17 |
1798531 | 1798531 | 2021-10-09 | Wilkin | Minnesota | 27167 | 966 | 14 |
1795282 | 1795282 | 2021-10-08 | Wilkin | Minnesota | 27167 | 966 | 14 |
1792456 | 1792456 | 2021-10-07 | Quay | New Mexico | 35037 | 966 | 17 |
1787652 | 1787652 | 2021-10-06 | Lake | Colorado | 8065 | 966 | 1 |
1788933 | 1788933 | 2021-10-06 | Maries | Missouri | 29125 | 966 | 18 |
1784020 | 1784020 | 2021-10-04 | Tucker | West Virginia | 54093 | 966 | 17 |
1769396 | 1769396 | 2021-09-30 | Clark | Missouri | 29045 | 966 | 12 |
1770366 | 1770366 | 2021-09-30 | Hamlin | South Dakota | 46057 | 966 | 40 |
1770395 | 1770395 | 2021-09-30 | Spink | South Dakota | 46115 | 966 | 27 |
1761888 | 1761888 | 2021-09-28 | Randolph | Georgia | 13243 | 966 | 38 |
1755974 | 1755974 | 2021-09-26 | Nicholas | Kentucky | 21181 | 966 | 14 |
1752726 | 1752726 | 2021-09-25 | Nicholas | Kentucky | 21181 | 966 | 14 |
1749477 | 1749477 | 2021-09-24 | Nicholas | Kentucky | 21181 | 966 | 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);