ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
443 rows where cases = 1377 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 45
- Texas 41
- South Dakota 34
- Iowa 32
- Oklahoma 24
- Georgia 21
- West Virginia 17
- Virginia 16
- Kansas 14
- Michigan 14
- Puerto Rico 14
- Minnesota 13
- Illinois 12
- Mississippi 12
- Indiana 11
- Kentucky 11
- Maine 11
- Missouri 11
- Arkansas 10
- Montana 9
- Utah 9
- Wisconsin 9
- California 8
- North Carolina 8
- Tennessee 8
- Alabama 7
- Pennsylvania 7
- Colorado 5
- Idaho 5
- Nebraska 5
- Ohio 5
- Oregon 5
- Connecticut 4
- New Mexico 4
- South Carolina 4
- Washington 4
- Florida 3
- North Dakota 3
- Vermont 3
- Louisiana 2
- Maryland 2
- New York 2
- Alaska 1
- Delaware 1
- Massachusetts 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500554 | 2500554 | 2022-05-13 | Rooks | Kansas | 20163 | 1377 | 20 |
2404237 | 2404237 | 2022-04-13 | Ceiba | Puerto Rico | 72037 | 1377 | |
2394502 | 2394502 | 2022-04-10 | Maunabo | Puerto Rico | 72095 | 1377 | |
2355595 | 2355595 | 2022-03-29 | Tripp | South Dakota | 46123 | 1377 | 24 |
2352342 | 2352342 | 2022-03-28 | Tripp | South Dakota | 46123 | 1377 | 24 |
2349090 | 2349090 | 2022-03-27 | Tripp | South Dakota | 46123 | 1377 | 24 |
2345837 | 2345837 | 2022-03-26 | Tripp | South Dakota | 46123 | 1377 | 24 |
2342584 | 2342584 | 2022-03-25 | Tripp | South Dakota | 46123 | 1377 | 24 |
2339331 | 2339331 | 2022-03-24 | Tripp | South Dakota | 46123 | 1377 | 24 |
2336077 | 2336077 | 2022-03-23 | Tripp | South Dakota | 46123 | 1377 | 24 |
2331629 | 2331629 | 2022-03-22 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2332823 | 2332823 | 2022-03-22 | Tripp | South Dakota | 46123 | 1377 | 24 |
2328377 | 2328377 | 2022-03-21 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2329570 | 2329570 | 2022-03-21 | Tripp | South Dakota | 46123 | 1377 | 24 |
2325124 | 2325124 | 2022-03-20 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2326318 | 2326318 | 2022-03-20 | Tripp | South Dakota | 46123 | 1377 | 24 |
2321870 | 2321870 | 2022-03-19 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2323065 | 2323065 | 2022-03-19 | Tripp | South Dakota | 46123 | 1377 | 24 |
2318616 | 2318616 | 2022-03-18 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2319811 | 2319811 | 2022-03-18 | Tripp | South Dakota | 46123 | 1377 | 24 |
2315363 | 2315363 | 2022-03-17 | Big Stone | Minnesota | 27011 | 1377 | 8 |
2316557 | 2316557 | 2022-03-17 | Tripp | South Dakota | 46123 | 1377 | 24 |
2313304 | 2313304 | 2022-03-16 | Tripp | South Dakota | 46123 | 1377 | 24 |
2308410 | 2308410 | 2022-03-15 | Van Buren | Iowa | 19177 | 1377 | 26 |
2310051 | 2310051 | 2022-03-15 | Tripp | South Dakota | 46123 | 1377 | 24 |
2305159 | 2305159 | 2022-03-14 | Van Buren | Iowa | 19177 | 1377 | 26 |
2306798 | 2306798 | 2022-03-14 | Tripp | South Dakota | 46123 | 1377 | 24 |
2301907 | 2301907 | 2022-03-13 | Van Buren | Iowa | 19177 | 1377 | 26 |
2303547 | 2303547 | 2022-03-13 | Tripp | South Dakota | 46123 | 1377 | 24 |
2298655 | 2298655 | 2022-03-12 | Van Buren | Iowa | 19177 | 1377 | 26 |
2300295 | 2300295 | 2022-03-12 | Tripp | South Dakota | 46123 | 1377 | 24 |
2295403 | 2295403 | 2022-03-11 | Van Buren | Iowa | 19177 | 1377 | 26 |
2297043 | 2297043 | 2022-03-11 | Tripp | South Dakota | 46123 | 1377 | 24 |
2292151 | 2292151 | 2022-03-10 | Van Buren | Iowa | 19177 | 1377 | 26 |
2293791 | 2293791 | 2022-03-10 | Tripp | South Dakota | 46123 | 1377 | 24 |
2288899 | 2288899 | 2022-03-09 | Van Buren | Iowa | 19177 | 1377 | 26 |
2290539 | 2290539 | 2022-03-09 | Tripp | South Dakota | 46123 | 1377 | 24 |
2266746 | 2266746 | 2022-03-02 | Atchison | Missouri | 29005 | 1377 | 19 |
2263495 | 2263495 | 2022-03-01 | Atchison | Missouri | 29005 | 1377 | 19 |
2264629 | 2264629 | 2022-03-01 | Bailey | Texas | 48017 | 1377 | 38 |
2236618 | 2236618 | 2022-02-21 | Gallatin | Illinois | 17059 | 1377 | 16 |
2233367 | 2233367 | 2022-02-20 | Gallatin | Illinois | 17059 | 1377 | 16 |
2230116 | 2230116 | 2022-02-19 | Gallatin | Illinois | 17059 | 1377 | 16 |
2226865 | 2226865 | 2022-02-18 | Gallatin | Illinois | 17059 | 1377 | 16 |
2217478 | 2217478 | 2022-02-15 | Washington | Kansas | 20201 | 1377 | 20 |
2214227 | 2214227 | 2022-02-14 | Washington | Kansas | 20201 | 1377 | 20 |
2212500 | 2212500 | 2022-02-13 | Spink | South Dakota | 46115 | 1377 | 33 |
2209247 | 2209247 | 2022-02-12 | Spink | South Dakota | 46115 | 1377 | 33 |
2205994 | 2205994 | 2022-02-11 | Spink | South Dakota | 46115 | 1377 | 33 |
2198491 | 2198491 | 2022-02-09 | Dade | Missouri | 29057 | 1377 | 38 |
2193465 | 2193465 | 2022-02-07 | Mathews | Virginia | 51115 | 1377 | 25 |
2166096 | 2166096 | 2022-01-30 | Stillwater | Montana | 30095 | 1377 | 29 |
2162841 | 2162841 | 2022-01-29 | Stillwater | Montana | 30095 | 1377 | 29 |
2159586 | 2159586 | 2022-01-28 | Stillwater | Montana | 30095 | 1377 | 29 |
2155242 | 2155242 | 2022-01-27 | Caribou | Idaho | 16029 | 1377 | 25 |
2122321 | 2122321 | 2022-01-17 | Woodruff | Arkansas | 5147 | 1377 | 24 |
2091954 | 2091954 | 2022-01-07 | Adjuntas | Puerto Rico | 72001 | 1377 | |
2086531 | 2086531 | 2022-01-06 | Newton | Arkansas | 5101 | 1377 | 44 |
2089505 | 2089505 | 2022-01-06 | Pendleton | West Virginia | 54071 | 1377 | 16 |
2083803 | 2083803 | 2022-01-05 | Schuyler | Illinois | 17169 | 1377 | 26 |
2056424 | 2056424 | 2021-12-27 | Hancock | Tennessee | 47067 | 1377 | 24 |
2056491 | 2056491 | 2021-12-27 | Archer | Texas | 48009 | 1377 | 24 |
2053488 | 2053488 | 2021-12-26 | Yoakum | Texas | 48501 | 1377 | 35 |
2050238 | 2050238 | 2021-12-25 | Yoakum | Texas | 48501 | 1377 | 35 |
2046988 | 2046988 | 2021-12-24 | Yoakum | Texas | 48501 | 1377 | 35 |
2043738 | 2043738 | 2021-12-23 | Yoakum | Texas | 48501 | 1377 | 35 |
2033794 | 2033794 | 2021-12-20 | Dallam | Texas | 48111 | 1377 | 31 |
2030544 | 2030544 | 2021-12-19 | Dallam | Texas | 48111 | 1377 | 31 |
2027293 | 2027293 | 2021-12-18 | Dallam | Texas | 48111 | 1377 | 31 |
2006050 | 2006050 | 2021-12-12 | Kingman | Kansas | 20095 | 1377 | 24 |
2007527 | 2007527 | 2021-12-12 | Allendale | South Carolina | 45005 | 1377 | 21 |
2002799 | 2002799 | 2021-12-11 | Kingman | Kansas | 20095 | 1377 | 24 |
2004276 | 2004276 | 2021-12-11 | Allendale | South Carolina | 45005 | 1377 | 21 |
1999549 | 1999549 | 2021-12-10 | Kingman | Kansas | 20095 | 1377 | 24 |
2001025 | 2001025 | 2021-12-10 | Allendale | South Carolina | 45005 | 1377 | 21 |
1984019 | 1984019 | 2021-12-05 | Valley | Montana | 30105 | 1377 | 29 |
1980769 | 1980769 | 2021-12-04 | Valley | Montana | 30105 | 1377 | 29 |
1977519 | 1977519 | 2021-12-03 | Valley | Montana | 30105 | 1377 | 29 |
1972911 | 1972911 | 2021-12-02 | Yuma | Colorado | 8125 | 1377 | 18 |
1972117 | 1972117 | 2021-12-01 | La Salle | Texas | 48283 | 1377 | 40 |
1943404 | 1943404 | 2021-11-23 | Sumter | Alabama | 1119 | 1377 | 41 |
1938559 | 1938559 | 2021-11-21 | Holt | Nebraska | 31089 | 1377 | 16 |
1938801 | 1938801 | 2021-11-21 | Jones | North Carolina | 37103 | 1377 | 35 |
1938852 | 1938852 | 2021-11-21 | Benson | North Dakota | 38005 | 1377 | 20 |
1935309 | 1935309 | 2021-11-20 | Holt | Nebraska | 31089 | 1377 | 16 |
1935551 | 1935551 | 2021-11-20 | Jones | North Carolina | 37103 | 1377 | 35 |
1935602 | 1935602 | 2021-11-20 | Benson | North Dakota | 38005 | 1377 | 20 |
1932059 | 1932059 | 2021-11-19 | Holt | Nebraska | 31089 | 1377 | 16 |
1932301 | 1932301 | 2021-11-19 | Jones | North Carolina | 37103 | 1377 | 35 |
1919869 | 1919869 | 2021-11-15 | Turner | South Dakota | 46125 | 1377 | 61 |
1912418 | 1912418 | 2021-11-13 | Oregon | Missouri | 29149 | 1377 | 11 |
1894454 | 1894454 | 2021-11-07 | Doddridge | West Virginia | 54017 | 1377 | 10 |
1891204 | 1891204 | 2021-11-06 | Doddridge | West Virginia | 54017 | 1377 | 10 |
1887954 | 1887954 | 2021-11-05 | Doddridge | West Virginia | 54017 | 1377 | 10 |
1873503 | 1873503 | 2021-11-01 | Powell | Montana | 30077 | 1377 | 18 |
1874859 | 1874859 | 2021-11-01 | Nelson | Virginia | 51125 | 1377 | 18 |
1869864 | 1869864 | 2021-10-31 | Crawford | Michigan | 26039 | 1377 | 17 |
1866615 | 1866615 | 2021-10-30 | Crawford | Michigan | 26039 | 1377 | 17 |
1868461 | 1868461 | 2021-10-30 | Gilmer | West Virginia | 54021 | 1377 | 12 |
1863366 | 1863366 | 2021-10-29 | Crawford | Michigan | 26039 | 1377 | 17 |
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);