ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
346 rows where cases = 1525 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 27
- Virginia 25
- Georgia 24
- Alabama 22
- Texas 20
- Missouri 18
- Illinois 17
- Kentucky 17
- Oklahoma 16
- Nebraska 14
- Tennessee 12
- Arkansas 10
- Minnesota 8
- Washington 8
- Kansas 7
- Mississippi 7
- Colorado 6
- North Carolina 6
- South Dakota 6
- Michigan 5
- Montana 5
- West Virginia 5
- Florida 4
- Indiana 4
- Louisiana 4
- Massachusetts 4
- Puerto Rico 4
- South Carolina 4
- Wyoming 4
- Arizona 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499734 | 2499734 | 2022-05-13 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2496476 | 2496476 | 2022-05-12 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2493218 | 2493218 | 2022-05-11 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2489960 | 2489960 | 2022-05-10 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2486703 | 2486703 | 2022-05-09 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2483445 | 2483445 | 2022-05-08 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2480187 | 2480187 | 2022-05-07 | Montgomery | Arkansas | 5097 | 1525 | 57 |
2472642 | 2472642 | 2022-05-04 | Maunabo | Puerto Rico | 72095 | 1525 | |
2468686 | 2468686 | 2022-05-03 | Cedar | Nebraska | 31027 | 1525 | 14 |
2441560 | 2441560 | 2022-04-25 | Calhoun | Illinois | 17013 | 1525 | 8 |
2426900 | 2426900 | 2022-04-20 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2423644 | 2423644 | 2022-04-19 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2420387 | 2420387 | 2022-04-18 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2417132 | 2417132 | 2022-04-17 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2413876 | 2413876 | 2022-04-16 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2410620 | 2410620 | 2022-04-15 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2407364 | 2407364 | 2022-04-14 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2404108 | 2404108 | 2022-04-13 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2400853 | 2400853 | 2022-04-12 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2397598 | 2397598 | 2022-04-11 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2394343 | 2394343 | 2022-04-10 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2391087 | 2391087 | 2022-04-09 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2387831 | 2387831 | 2022-04-08 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2384576 | 2384576 | 2022-04-07 | Tillman | Oklahoma | 40141 | 1525 | 34 |
2362237 | 2362237 | 2022-03-31 | Carson | Texas | 48065 | 1525 | 34 |
2351478 | 2351478 | 2022-03-28 | Stillwater | Montana | 30095 | 1525 | 29 |
2194508 | 2194508 | 2022-02-08 | Adair | Iowa | 19001 | 1525 | 47 |
2190734 | 2190734 | 2022-02-07 | Kit Carson | Colorado | 8063 | 1525 | 29 |
2191254 | 2191254 | 2022-02-07 | Adair | Iowa | 19001 | 1525 | 47 |
2188001 | 2188001 | 2022-02-06 | Adair | Iowa | 19001 | 1525 | 47 |
2184748 | 2184748 | 2022-02-05 | Adair | Iowa | 19001 | 1525 | 47 |
2181496 | 2181496 | 2022-02-04 | Adair | Iowa | 19001 | 1525 | 47 |
2178245 | 2178245 | 2022-02-03 | Adair | Iowa | 19001 | 1525 | 47 |
2174992 | 2174992 | 2022-02-02 | Adair | Iowa | 19001 | 1525 | 47 |
2157338 | 2157338 | 2022-01-27 | Coleman | Texas | 48083 | 1525 | 64 |
2103312 | 2103312 | 2022-01-11 | Schuyler | Illinois | 17169 | 1525 | 27 |
2075050 | 2075050 | 2022-01-02 | Cheyenne | Nebraska | 31033 | 1525 | 19 |
2071799 | 2071799 | 2022-01-01 | Cheyenne | Nebraska | 31033 | 1525 | 19 |
2068548 | 2068548 | 2021-12-31 | Cheyenne | Nebraska | 31033 | 1525 | 19 |
2065297 | 2065297 | 2021-12-30 | Cheyenne | Nebraska | 31033 | 1525 | 19 |
2063604 | 2063604 | 2021-12-29 | Sublette | Wyoming | 56035 | 1525 | 23 |
2057587 | 2057587 | 2021-12-28 | Lanier | Georgia | 13173 | 1525 | 17 |
2057975 | 2057975 | 2021-12-28 | Monroe | Iowa | 19135 | 1525 | 43 |
2060260 | 2060260 | 2021-12-28 | Webster | West Virginia | 54101 | 1525 | 27 |
2054726 | 2054726 | 2021-12-27 | Monroe | Iowa | 19135 | 1525 | 43 |
2056943 | 2056943 | 2021-12-27 | Lincoln | Washington | 53043 | 1525 | 26 |
2051476 | 2051476 | 2021-12-26 | Monroe | Iowa | 19135 | 1525 | 43 |
2048226 | 2048226 | 2021-12-25 | Monroe | Iowa | 19135 | 1525 | 43 |
2044976 | 2044976 | 2021-12-24 | Monroe | Iowa | 19135 | 1525 | 43 |
2041727 | 2041727 | 2021-12-23 | Monroe | Iowa | 19135 | 1525 | 43 |
2038477 | 2038477 | 2021-12-22 | Monroe | Iowa | 19135 | 1525 | 43 |
2028774 | 2028774 | 2021-12-19 | Coffey | Kansas | 20031 | 1525 | 31 |
2025523 | 2025523 | 2021-12-18 | Coffey | Kansas | 20031 | 1525 | 31 |
2022272 | 2022272 | 2021-12-17 | Coffey | Kansas | 20031 | 1525 | 31 |
2023746 | 2023746 | 2021-12-17 | Naguabo | Puerto Rico | 72103 | 1525 | |
2020495 | 2020495 | 2021-12-16 | Naguabo | Puerto Rico | 72103 | 1525 | |
2020954 | 2020954 | 2021-12-16 | Swisher | Texas | 48437 | 1525 | 25 |
2005655 | 2005655 | 2021-12-12 | Wilkinson | Georgia | 13319 | 1525 | 46 |
2008117 | 2008117 | 2021-12-12 | Nelson | Virginia | 51125 | 1525 | 23 |
2002404 | 2002404 | 2021-12-11 | Wilkinson | Georgia | 13319 | 1525 | 46 |
2004866 | 2004866 | 2021-12-11 | Nelson | Virginia | 51125 | 1525 | 23 |
1999154 | 1999154 | 2021-12-10 | Wilkinson | Georgia | 13319 | 1525 | 46 |
2001615 | 2001615 | 2021-12-10 | Nelson | Virginia | 51125 | 1525 | 23 |
1995903 | 1995903 | 2021-12-09 | Wilkinson | Georgia | 13319 | 1525 | 46 |
1986151 | 1986151 | 2021-12-06 | Wilkinson | Georgia | 13319 | 1525 | 47 |
1986988 | 1986988 | 2021-12-06 | Pipestone | Minnesota | 27117 | 1525 | 29 |
1972608 | 1972608 | 2021-12-02 | Bullock | Alabama | 1011 | 1525 | 45 |
1974293 | 1974293 | 2021-12-02 | Custer | Nebraska | 31041 | 1525 | 23 |
1969358 | 1969358 | 2021-12-01 | Bullock | Alabama | 1011 | 1525 | 45 |
1966108 | 1966108 | 2021-11-30 | Bullock | Alabama | 1011 | 1525 | 45 |
1953103 | 1953103 | 2021-11-26 | Bullock | Alabama | 1011 | 1525 | 45 |
1949852 | 1949852 | 2021-11-25 | Bullock | Alabama | 1011 | 1525 | 45 |
1946601 | 1946601 | 2021-11-24 | Bullock | Alabama | 1011 | 1525 | 45 |
1944765 | 1944765 | 2021-11-23 | Benton | Mississippi | 28009 | 1525 | 39 |
1944964 | 1944964 | 2021-11-23 | Carbon | Montana | 30009 | 1525 | 22 |
1936737 | 1936737 | 2021-11-20 | Ritchie | West Virginia | 54085 | 1525 | 21 |
1923848 | 1923848 | 2021-11-17 | Bullock | Alabama | 1011 | 1525 | 45 |
1921559 | 1921559 | 2021-11-16 | Norton | Kansas | 20137 | 1525 | 32 |
1917944 | 1917944 | 2021-11-15 | Valley | Idaho | 16085 | 1525 | 13 |
1918309 | 1918309 | 2021-11-15 | Norton | Kansas | 20137 | 1525 | 32 |
1914612 | 1914612 | 2021-11-14 | Stewart | Georgia | 13259 | 1525 | 28 |
1911362 | 1911362 | 2021-11-13 | Stewart | Georgia | 13259 | 1525 | 28 |
1908113 | 1908113 | 2021-11-12 | Stewart | Georgia | 13259 | 1525 | 28 |
1898352 | 1898352 | 2021-11-09 | Pulaski | Georgia | 13235 | 1525 | 61 |
1894601 | 1894601 | 2021-11-08 | Bullock | Alabama | 1011 | 1525 | 44 |
1891351 | 1891351 | 2021-11-07 | Bullock | Alabama | 1011 | 1525 | 44 |
1884851 | 1884851 | 2021-11-05 | Bullock | Alabama | 1011 | 1525 | 44 |
1879707 | 1879707 | 2021-11-03 | Jackson | Minnesota | 27063 | 1525 | 15 |
1868849 | 1868849 | 2021-10-31 | Archuleta | Colorado | 8007 | 1525 | 4 |
1869169 | 1869169 | 2021-10-31 | Boundary | Idaho | 16021 | 1525 | 31 |
1865600 | 1865600 | 2021-10-30 | Archuleta | Colorado | 8007 | 1525 | 4 |
1865920 | 1865920 | 2021-10-30 | Boundary | Idaho | 16021 | 1525 | 31 |
1862351 | 1862351 | 2021-10-29 | Archuleta | Colorado | 8007 | 1525 | 4 |
1846372 | 1846372 | 2021-10-24 | Seminole | Georgia | 13253 | 1525 | 24 |
1843122 | 1843122 | 2021-10-23 | Seminole | Georgia | 13253 | 1525 | 24 |
1839872 | 1839872 | 2021-10-22 | Seminole | Georgia | 13253 | 1525 | 24 |
1840926 | 1840926 | 2021-10-22 | Montgomery | Missouri | 29139 | 1525 | 19 |
1837677 | 1837677 | 2021-10-21 | Montgomery | Missouri | 29139 | 1525 | 19 |
1831196 | 1831196 | 2021-10-19 | Ralls | Missouri | 29173 | 1525 | 14 |
1832127 | 1832127 | 2021-10-19 | Roberts | South Dakota | 46109 | 1525 | 43 |
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);