ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
382 rows where cases = 1587 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 23
- Texas 22
- West Virginia 21
- Georgia 20
- Virginia 19
- Wyoming 17
- Missouri 15
- Arkansas 14
- Illinois 14
- Kansas 14
- Louisiana 13
- Minnesota 13
- Colorado 12
- Mississippi 12
- North Carolina 12
- Puerto Rico 12
- Tennessee 12
- Montana 11
- Alabama 8
- Kentucky 8
- North Dakota 8
- Indiana 7
- Michigan 7
- Nebraska 7
- Washington 7
- Wisconsin 7
- Idaho 6
- Pennsylvania 6
- South Carolina 5
- Maine 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500035 | 2500035 | 2022-05-13 | Hancock | Georgia | 13141 | 1587 | 90 |
2496777 | 2496777 | 2022-05-12 | Hancock | Georgia | 13141 | 1587 | 90 |
2493519 | 2493519 | 2022-05-11 | Hancock | Georgia | 13141 | 1587 | 90 |
2490056 | 2490056 | 2022-05-10 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2486799 | 2486799 | 2022-05-09 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2467797 | 2467797 | 2022-05-03 | Adair | Iowa | 19001 | 1587 | 50 |
2464542 | 2464542 | 2022-05-02 | Adair | Iowa | 19001 | 1587 | 50 |
2461286 | 2461286 | 2022-05-01 | Adair | Iowa | 19001 | 1587 | 50 |
2458030 | 2458030 | 2022-04-30 | Adair | Iowa | 19001 | 1587 | 50 |
2454774 | 2454774 | 2022-04-29 | Adair | Iowa | 19001 | 1587 | 50 |
2451518 | 2451518 | 2022-04-28 | Adair | Iowa | 19001 | 1587 | 50 |
2448262 | 2448262 | 2022-04-27 | Adair | Iowa | 19001 | 1587 | 50 |
2444207 | 2444207 | 2022-04-25 | Weston | Wyoming | 56045 | 1587 | 18 |
2440951 | 2440951 | 2022-04-24 | Weston | Wyoming | 56045 | 1587 | 18 |
2437695 | 2437695 | 2022-04-23 | Weston | Wyoming | 56045 | 1587 | 18 |
2434439 | 2434439 | 2022-04-22 | Weston | Wyoming | 56045 | 1587 | 18 |
2429943 | 2429943 | 2022-04-21 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2431183 | 2431183 | 2022-04-21 | Weston | Wyoming | 56045 | 1587 | 18 |
2426687 | 2426687 | 2022-04-20 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2427927 | 2427927 | 2022-04-20 | Weston | Wyoming | 56045 | 1587 | 18 |
2423431 | 2423431 | 2022-04-19 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2424671 | 2424671 | 2022-04-19 | Weston | Wyoming | 56045 | 1587 | 18 |
2420174 | 2420174 | 2022-04-18 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2421415 | 2421415 | 2022-04-18 | Weston | Wyoming | 56045 | 1587 | 18 |
2416919 | 2416919 | 2022-04-17 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2418159 | 2418159 | 2022-04-17 | Weston | Wyoming | 56045 | 1587 | 18 |
2413663 | 2413663 | 2022-04-16 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2414903 | 2414903 | 2022-04-16 | Weston | Wyoming | 56045 | 1587 | 18 |
2410407 | 2410407 | 2022-04-15 | Bottineau | North Dakota | 38009 | 1587 | 26 |
2411647 | 2411647 | 2022-04-15 | Weston | Wyoming | 56045 | 1587 | 18 |
2408391 | 2408391 | 2022-04-14 | Weston | Wyoming | 56045 | 1587 | 18 |
2405135 | 2405135 | 2022-04-13 | Weston | Wyoming | 56045 | 1587 | 18 |
2401880 | 2401880 | 2022-04-12 | Weston | Wyoming | 56045 | 1587 | 18 |
2362828 | 2362828 | 2022-03-31 | Weston | Wyoming | 56045 | 1587 | 18 |
2359574 | 2359574 | 2022-03-30 | Weston | Wyoming | 56045 | 1587 | 18 |
2356320 | 2356320 | 2022-03-29 | Weston | Wyoming | 56045 | 1587 | 18 |
2324068 | 2324068 | 2022-03-20 | Kit Carson | Colorado | 8063 | 1587 | 31 |
2320814 | 2320814 | 2022-03-19 | Kit Carson | Colorado | 8063 | 1587 | 31 |
2317560 | 2317560 | 2022-03-18 | Kit Carson | Colorado | 8063 | 1587 | 31 |
2314307 | 2314307 | 2022-03-17 | Kit Carson | Colorado | 8063 | 1587 | 31 |
2311054 | 2311054 | 2022-03-16 | Kit Carson | Colorado | 8063 | 1587 | 31 |
2279818 | 2279818 | 2022-03-06 | Maries | Missouri | 29125 | 1587 | 33 |
2276565 | 2276565 | 2022-03-05 | Maries | Missouri | 29125 | 1587 | 33 |
2273312 | 2273312 | 2022-03-04 | Maries | Missouri | 29125 | 1587 | 33 |
2270060 | 2270060 | 2022-03-03 | Maries | Missouri | 29125 | 1587 | 33 |
2248390 | 2248390 | 2022-02-24 | Brooks | Texas | 48047 | 1587 | 50 |
2233216 | 2233216 | 2022-02-20 | Lincoln | Georgia | 13181 | 1587 | 35 |
2229965 | 2229965 | 2022-02-19 | Lincoln | Georgia | 13181 | 1587 | 35 |
2226714 | 2226714 | 2022-02-18 | Lincoln | Georgia | 13181 | 1587 | 35 |
2188871 | 2188871 | 2022-02-06 | Valley | Montana | 30105 | 1587 | 34 |
2185618 | 2185618 | 2022-02-05 | Valley | Montana | 30105 | 1587 | 34 |
2182366 | 2182366 | 2022-02-04 | Valley | Montana | 30105 | 1587 | 34 |
2169053 | 2169053 | 2022-01-31 | Lac qui Parle | Minnesota | 27073 | 1587 | 28 |
2164619 | 2164619 | 2022-01-30 | Woodruff | Arkansas | 5147 | 1587 | 24 |
2161364 | 2161364 | 2022-01-29 | Woodruff | Arkansas | 5147 | 1587 | 24 |
2158108 | 2158108 | 2022-01-28 | Woodruff | Arkansas | 5147 | 1587 | 24 |
2153161 | 2153161 | 2022-01-26 | Richardson | Nebraska | 31147 | 1587 | 24 |
2146530 | 2146530 | 2022-01-24 | Blaine | Montana | 30005 | 1587 | 28 |
2143601 | 2143601 | 2022-01-23 | Gates | North Carolina | 37073 | 1587 | 19 |
2140346 | 2140346 | 2022-01-22 | Gates | North Carolina | 37073 | 1587 | 19 |
2137090 | 2137090 | 2022-01-21 | Gates | North Carolina | 37073 | 1587 | 19 |
2114770 | 2114770 | 2022-01-14 | Patillas | Puerto Rico | 72109 | 1587 | |
2109914 | 2109914 | 2022-01-13 | Union | Indiana | 18161 | 1587 | 20 |
2108600 | 2108600 | 2022-01-12 | Hamilton | Texas | 48193 | 1587 | 29 |
2100818 | 2100818 | 2022-01-10 | Humphreys | Mississippi | 28053 | 1587 | 39 |
2102526 | 2102526 | 2022-01-10 | Webster | West Virginia | 54101 | 1587 | 27 |
2095717 | 2095717 | 2022-01-08 | Swisher | Texas | 48437 | 1587 | 27 |
2092730 | 2092730 | 2022-01-07 | Doddridge | West Virginia | 54017 | 1587 | 15 |
2079565 | 2079565 | 2022-01-03 | Charlotte | Virginia | 51037 | 1587 | 31 |
2062071 | 2062071 | 2021-12-29 | Hamilton | Nebraska | 31081 | 1587 | 19 |
2058826 | 2058826 | 2021-12-28 | Holt | Nebraska | 31089 | 1587 | 16 |
2051085 | 2051085 | 2021-12-26 | Johnson | Georgia | 13167 | 1587 | 64 |
2053719 | 2053719 | 2021-12-26 | Clay | West Virginia | 54015 | 1587 | 25 |
2047835 | 2047835 | 2021-12-25 | Johnson | Georgia | 13167 | 1587 | 64 |
2050469 | 2050469 | 2021-12-25 | Clay | West Virginia | 54015 | 1587 | 25 |
2044585 | 2044585 | 2021-12-24 | Johnson | Georgia | 13167 | 1587 | 64 |
2047219 | 2047219 | 2021-12-24 | Clay | West Virginia | 54015 | 1587 | 25 |
2043969 | 2043969 | 2021-12-23 | Clay | West Virginia | 54015 | 1587 | 25 |
2031868 | 2031868 | 2021-12-20 | Martin | Indiana | 18101 | 1587 | 20 |
2032772 | 2032772 | 2021-12-20 | Sanders | Montana | 30089 | 1587 | 40 |
2029521 | 2029521 | 2021-12-19 | Sanders | Montana | 30089 | 1587 | 40 |
2026270 | 2026270 | 2021-12-18 | Sanders | Montana | 30089 | 1587 | 40 |
2023019 | 2023019 | 2021-12-17 | Sanders | Montana | 30089 | 1587 | 40 |
2009728 | 2009728 | 2021-12-13 | Marshall | Minnesota | 27089 | 1587 | 23 |
1996646 | 1996646 | 2021-12-09 | Mackinac | Michigan | 26097 | 1587 | 17 |
1992665 | 1992665 | 2021-12-08 | Benewah | Idaho | 16009 | 1587 | 29 |
1993395 | 1993395 | 2021-12-08 | Mackinac | Michigan | 26097 | 1587 | 17 |
1988571 | 1988571 | 2021-12-06 | Floyd | Virginia | 51063 | 1587 | 32 |
1973568 | 1973568 | 2021-12-02 | Norton | Kansas | 20137 | 1587 | 32 |
1973944 | 1973944 | 2021-12-02 | Clearwater | Minnesota | 27029 | 1587 | 21 |
1970318 | 1970318 | 2021-12-01 | Norton | Kansas | 20137 | 1587 | 32 |
1944704 | 1944704 | 2021-11-23 | Jackson | Minnesota | 27063 | 1587 | 16 |
1920262 | 1920262 | 2021-11-15 | Orange | Vermont | 50017 | 1587 | 6 |
1905345 | 1905345 | 2021-11-11 | Wilson | Kansas | 20205 | 1587 | 34 |
1902095 | 1902095 | 2021-11-10 | Wilson | Kansas | 20205 | 1587 | 34 |
1881344 | 1881344 | 2021-11-03 | Lexington city | Virginia | 51678 | 1587 | 36 |
1860853 | 1860853 | 2021-10-28 | Washington | North Carolina | 37187 | 1587 | 37 |
1856999 | 1856999 | 2021-10-27 | Rock | Minnesota | 27133 | 1587 | 19 |
1857216 | 1857216 | 2021-10-27 | Wayne | Missouri | 29223 | 1587 | 18 |
1830749 | 1830749 | 2021-10-19 | East Carroll | Louisiana | 22035 | 1587 | 30 |
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);