ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
512 rows where cases = 986 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 42
- Georgia 30
- Kentucky 29
- Michigan 27
- Texas 27
- Kansas 24
- Oklahoma 22
- Arkansas 20
- Louisiana 19
- Missouri 18
- Virginia 17
- Iowa 12
- Tennessee 12
- Alaska 11
- Colorado 11
- Illinois 11
- Montana 11
- North Carolina 11
- Puerto Rico 11
- Idaho 10
- Mississippi 10
- South Dakota 10
- Washington 10
- Wyoming 10
- Alabama 8
- Minnesota 8
- West Virginia 8
- California 7
- Indiana 7
- Nebraska 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2429954 | 2429954 | 2022-04-21 | Foster | North Dakota | 38031 | 986 | 23 |
2425849 | 2425849 | 2022-04-20 | Tensas | Louisiana | 22107 | 986 | 11 |
2426698 | 2426698 | 2022-04-20 | Foster | North Dakota | 38031 | 986 | 23 |
2422593 | 2422593 | 2022-04-19 | Tensas | Louisiana | 22107 | 986 | 11 |
2422727 | 2422727 | 2022-04-19 | Ontonagon | Michigan | 26131 | 986 | 38 |
2423442 | 2423442 | 2022-04-19 | Foster | North Dakota | 38031 | 986 | 23 |
2419337 | 2419337 | 2022-04-18 | Tensas | Louisiana | 22107 | 986 | 11 |
2419471 | 2419471 | 2022-04-18 | Ontonagon | Michigan | 26131 | 986 | 38 |
2420185 | 2420185 | 2022-04-18 | Foster | North Dakota | 38031 | 986 | 23 |
2416081 | 2416081 | 2022-04-17 | Tensas | Louisiana | 22107 | 986 | 11 |
2416215 | 2416215 | 2022-04-17 | Ontonagon | Michigan | 26131 | 986 | 38 |
2416930 | 2416930 | 2022-04-17 | Foster | North Dakota | 38031 | 986 | 23 |
2412825 | 2412825 | 2022-04-16 | Tensas | Louisiana | 22107 | 986 | 11 |
2412959 | 2412959 | 2022-04-16 | Ontonagon | Michigan | 26131 | 986 | 38 |
2413674 | 2413674 | 2022-04-16 | Foster | North Dakota | 38031 | 986 | 23 |
2409569 | 2409569 | 2022-04-15 | Tensas | Louisiana | 22107 | 986 | 11 |
2409703 | 2409703 | 2022-04-15 | Ontonagon | Michigan | 26131 | 986 | 38 |
2410418 | 2410418 | 2022-04-15 | Foster | North Dakota | 38031 | 986 | 23 |
2406313 | 2406313 | 2022-04-14 | Tensas | Louisiana | 22107 | 986 | 11 |
2406447 | 2406447 | 2022-04-14 | Ontonagon | Michigan | 26131 | 986 | 38 |
2407162 | 2407162 | 2022-04-14 | Foster | North Dakota | 38031 | 986 | 23 |
2403057 | 2403057 | 2022-04-13 | Tensas | Louisiana | 22107 | 986 | 11 |
2403191 | 2403191 | 2022-04-13 | Ontonagon | Michigan | 26131 | 986 | 38 |
2403906 | 2403906 | 2022-04-13 | Foster | North Dakota | 38031 | 986 | 23 |
2399803 | 2399803 | 2022-04-12 | Tensas | Louisiana | 22107 | 986 | 11 |
2400651 | 2400651 | 2022-04-12 | Foster | North Dakota | 38031 | 986 | 23 |
2396547 | 2396547 | 2022-04-11 | Tensas | Louisiana | 22107 | 986 | 11 |
2397396 | 2397396 | 2022-04-11 | Foster | North Dakota | 38031 | 986 | 23 |
2393292 | 2393292 | 2022-04-10 | Tensas | Louisiana | 22107 | 986 | 11 |
2394141 | 2394141 | 2022-04-10 | Foster | North Dakota | 38031 | 986 | 23 |
2390036 | 2390036 | 2022-04-09 | Tensas | Louisiana | 22107 | 986 | 11 |
2390885 | 2390885 | 2022-04-09 | Foster | North Dakota | 38031 | 986 | 23 |
2386780 | 2386780 | 2022-04-08 | Tensas | Louisiana | 22107 | 986 | 11 |
2387629 | 2387629 | 2022-04-08 | Foster | North Dakota | 38031 | 986 | 23 |
2384374 | 2384374 | 2022-04-07 | Foster | North Dakota | 38031 | 986 | 23 |
2381119 | 2381119 | 2022-04-06 | Foster | North Dakota | 38031 | 986 | 23 |
2377864 | 2377864 | 2022-04-05 | Foster | North Dakota | 38031 | 986 | 23 |
2374611 | 2374611 | 2022-04-04 | Foster | North Dakota | 38031 | 986 | 23 |
2371359 | 2371359 | 2022-04-03 | Foster | North Dakota | 38031 | 986 | 23 |
2368106 | 2368106 | 2022-04-02 | Foster | North Dakota | 38031 | 986 | 23 |
2364853 | 2364853 | 2022-04-01 | Foster | North Dakota | 38031 | 986 | 23 |
2361599 | 2361599 | 2022-03-31 | Foster | North Dakota | 38031 | 986 | 23 |
2358345 | 2358345 | 2022-03-30 | Foster | North Dakota | 38031 | 986 | 23 |
2353279 | 2353279 | 2022-03-29 | Modoc | California | 6049 | 986 | 7 |
2355091 | 2355091 | 2022-03-29 | Foster | North Dakota | 38031 | 986 | 23 |
2350027 | 2350027 | 2022-03-28 | Modoc | California | 6049 | 986 | 7 |
2351838 | 2351838 | 2022-03-28 | Foster | North Dakota | 38031 | 986 | 23 |
2346774 | 2346774 | 2022-03-27 | Modoc | California | 6049 | 986 | 7 |
2348586 | 2348586 | 2022-03-27 | Foster | North Dakota | 38031 | 986 | 23 |
2343521 | 2343521 | 2022-03-26 | Modoc | California | 6049 | 986 | 7 |
2345333 | 2345333 | 2022-03-26 | Foster | North Dakota | 38031 | 986 | 23 |
2340268 | 2340268 | 2022-03-25 | Modoc | California | 6049 | 986 | 7 |
2342080 | 2342080 | 2022-03-25 | Foster | North Dakota | 38031 | 986 | 23 |
2337015 | 2337015 | 2022-03-24 | Modoc | California | 6049 | 986 | 7 |
2338827 | 2338827 | 2022-03-24 | Foster | North Dakota | 38031 | 986 | 23 |
2335573 | 2335573 | 2022-03-23 | Foster | North Dakota | 38031 | 986 | 23 |
2332319 | 2332319 | 2022-03-22 | Foster | North Dakota | 38031 | 986 | 23 |
2329066 | 2329066 | 2022-03-21 | Foster | North Dakota | 38031 | 986 | 23 |
2325814 | 2325814 | 2022-03-20 | Foster | North Dakota | 38031 | 986 | 23 |
2322561 | 2322561 | 2022-03-19 | Foster | North Dakota | 38031 | 986 | 23 |
2319307 | 2319307 | 2022-03-18 | Foster | North Dakota | 38031 | 986 | 23 |
2222423 | 2222423 | 2022-02-16 | Donley | Texas | 48129 | 986 | 23 |
2202278 | 2202278 | 2022-02-10 | Wells | North Dakota | 38103 | 986 | 11 |
2195891 | 2195891 | 2022-02-08 | Grant | Oklahoma | 40053 | 986 | 12 |
2192637 | 2192637 | 2022-02-07 | Grant | Oklahoma | 40053 | 986 | 12 |
2189222 | 2189222 | 2022-02-06 | Dunn | North Dakota | 38025 | 986 | 8 |
2189383 | 2189383 | 2022-02-06 | Grant | Oklahoma | 40053 | 986 | 12 |
2185969 | 2185969 | 2022-02-05 | Dunn | North Dakota | 38025 | 986 | 8 |
2186130 | 2186130 | 2022-02-05 | Grant | Oklahoma | 40053 | 986 | 12 |
2182878 | 2182878 | 2022-02-04 | Grant | Oklahoma | 40053 | 986 | 12 |
2179626 | 2179626 | 2022-02-03 | Grant | Oklahoma | 40053 | 986 | 12 |
2176375 | 2176375 | 2022-02-02 | Grant | Oklahoma | 40053 | 986 | 12 |
2157153 | 2157153 | 2022-01-27 | Deuel | South Dakota | 46039 | 986 | 12 |
2154096 | 2154096 | 2022-01-26 | Crockett | Texas | 48105 | 986 | 17 |
2141752 | 2141752 | 2022-01-23 | Yukon-Koyukuk Census Area | Alaska | 2290 | 986 | 8 |
2138496 | 2138496 | 2022-01-22 | Yukon-Koyukuk Census Area | Alaska | 2290 | 986 | 8 |
2135241 | 2135241 | 2022-01-21 | Yukon-Koyukuk Census Area | Alaska | 2290 | 986 | 8 |
2130338 | 2130338 | 2022-01-19 | Dixon | Nebraska | 31051 | 986 | 11 |
2123878 | 2123878 | 2022-01-17 | Polk | Nebraska | 31143 | 986 | 18 |
2108948 | 2108948 | 2022-01-12 | Ferry | Washington | 53019 | 986 | 18 |
2103258 | 2103258 | 2022-01-11 | Gallatin | Illinois | 17059 | 986 | 11 |
2103995 | 2103995 | 2022-01-11 | Lincoln | Minnesota | 27081 | 986 | 5 |
2085623 | 2085623 | 2022-01-05 | Lyman | South Dakota | 46085 | 986 | 12 |
2075887 | 2075887 | 2022-01-02 | Tripp | South Dakota | 46123 | 986 | 21 |
2076190 | 2076190 | 2022-01-02 | Sabine | Texas | 48403 | 986 | 77 |
2072636 | 2072636 | 2022-01-01 | Tripp | South Dakota | 46123 | 986 | 21 |
2072939 | 2072939 | 2022-01-01 | Sabine | Texas | 48403 | 986 | 77 |
2069385 | 2069385 | 2021-12-31 | Tripp | South Dakota | 46123 | 986 | 21 |
2069688 | 2069688 | 2021-12-31 | Sabine | Texas | 48403 | 986 | 77 |
2063865 | 2063865 | 2021-12-30 | Clear Creek | Colorado | 8019 | 986 | 7 |
2066134 | 2066134 | 2021-12-30 | Tripp | South Dakota | 46123 | 986 | 21 |
2066437 | 2066437 | 2021-12-30 | Sabine | Texas | 48403 | 986 | 77 |
2062408 | 2062408 | 2021-12-29 | Sioux | North Dakota | 38085 | 986 | 18 |
2058558 | 2058558 | 2021-12-28 | Jefferson | Mississippi | 28063 | 986 | 35 |
2056589 | 2056589 | 2021-12-27 | Hartley | Texas | 48205 | 986 | 2 |
2040765 | 2040765 | 2021-12-22 | Wirt | West Virginia | 54105 | 986 | 17 |
2016192 | 2016192 | 2021-12-15 | Big Stone | Minnesota | 27011 | 986 | 7 |
2008901 | 2008901 | 2021-12-13 | Wheeler | Georgia | 13309 | 986 | 36 |
2005650 | 2005650 | 2021-12-12 | Wheeler | Georgia | 13309 | 986 | 36 |
2002399 | 2002399 | 2021-12-11 | Wheeler | Georgia | 13309 | 986 | 36 |
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);