ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
545 rows where cases = 685 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 46
- Texas 41
- Kansas 31
- Kentucky 30
- Georgia 28
- Virginia 25
- Illinois 20
- Iowa 18
- Nebraska 17
- North Carolina 17
- Puerto Rico 17
- Idaho 16
- Michigan 16
- Alaska 14
- Minnesota 14
- Washington 13
- Missouri 12
- Arkansas 11
- Montana 11
- South Dakota 11
- Mississippi 10
- Indiana 9
- West Virginia 9
- Colorado 8
- Louisiana 8
- Oklahoma 8
- Oregon 8
- Tennessee 8
- Wisconsin 8
- Ohio 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469839 | 2469839 | 2022-05-03 | Shackelford | Texas | 48417 | 685 | 12 |
2466583 | 2466583 | 2022-05-02 | Shackelford | Texas | 48417 | 685 | 12 |
2463328 | 2463328 | 2022-05-01 | Shackelford | Texas | 48417 | 685 | 12 |
2460072 | 2460072 | 2022-04-30 | Shackelford | Texas | 48417 | 685 | 12 |
2407172 | 2407172 | 2022-04-14 | McIntosh | North Dakota | 38051 | 685 | 9 |
2403916 | 2403916 | 2022-04-13 | McIntosh | North Dakota | 38051 | 685 | 9 |
2400661 | 2400661 | 2022-04-12 | McIntosh | North Dakota | 38051 | 685 | 9 |
2397406 | 2397406 | 2022-04-11 | McIntosh | North Dakota | 38051 | 685 | 9 |
2394151 | 2394151 | 2022-04-10 | McIntosh | North Dakota | 38051 | 685 | 9 |
2390895 | 2390895 | 2022-04-09 | McIntosh | North Dakota | 38051 | 685 | 9 |
2387639 | 2387639 | 2022-04-08 | McIntosh | North Dakota | 38051 | 685 | 9 |
2384384 | 2384384 | 2022-04-07 | McIntosh | North Dakota | 38051 | 685 | 9 |
2381129 | 2381129 | 2022-04-06 | McIntosh | North Dakota | 38051 | 685 | 9 |
2377874 | 2377874 | 2022-04-05 | McIntosh | North Dakota | 38051 | 685 | 9 |
2374621 | 2374621 | 2022-04-04 | McIntosh | North Dakota | 38051 | 685 | 9 |
2371369 | 2371369 | 2022-04-03 | McIntosh | North Dakota | 38051 | 685 | 9 |
2368116 | 2368116 | 2022-04-02 | McIntosh | North Dakota | 38051 | 685 | 9 |
2364863 | 2364863 | 2022-04-01 | McIntosh | North Dakota | 38051 | 685 | 9 |
2361609 | 2361609 | 2022-03-31 | McIntosh | North Dakota | 38051 | 685 | 9 |
2358355 | 2358355 | 2022-03-30 | McIntosh | North Dakota | 38051 | 685 | 9 |
2355101 | 2355101 | 2022-03-29 | McIntosh | North Dakota | 38051 | 685 | 9 |
2351848 | 2351848 | 2022-03-28 | McIntosh | North Dakota | 38051 | 685 | 9 |
2348596 | 2348596 | 2022-03-27 | McIntosh | North Dakota | 38051 | 685 | 9 |
2345343 | 2345343 | 2022-03-26 | McIntosh | North Dakota | 38051 | 685 | 9 |
2342090 | 2342090 | 2022-03-25 | McIntosh | North Dakota | 38051 | 685 | 9 |
2338837 | 2338837 | 2022-03-24 | McIntosh | North Dakota | 38051 | 685 | 9 |
2335583 | 2335583 | 2022-03-23 | McIntosh | North Dakota | 38051 | 685 | 9 |
2332329 | 2332329 | 2022-03-22 | McIntosh | North Dakota | 38051 | 685 | 9 |
2329076 | 2329076 | 2022-03-21 | McIntosh | North Dakota | 38051 | 685 | 9 |
2325824 | 2325824 | 2022-03-20 | McIntosh | North Dakota | 38051 | 685 | 9 |
2322571 | 2322571 | 2022-03-19 | McIntosh | North Dakota | 38051 | 685 | 9 |
2319317 | 2319317 | 2022-03-18 | McIntosh | North Dakota | 38051 | 685 | 9 |
2314115 | 2314115 | 2022-03-17 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2316063 | 2316063 | 2022-03-17 | McIntosh | North Dakota | 38051 | 685 | 9 |
2310862 | 2310862 | 2022-03-16 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2312810 | 2312810 | 2022-03-16 | McIntosh | North Dakota | 38051 | 685 | 9 |
2307609 | 2307609 | 2022-03-15 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2309557 | 2309557 | 2022-03-15 | McIntosh | North Dakota | 38051 | 685 | 9 |
2304358 | 2304358 | 2022-03-14 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2306304 | 2306304 | 2022-03-14 | McIntosh | North Dakota | 38051 | 685 | 9 |
2301106 | 2301106 | 2022-03-13 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2303053 | 2303053 | 2022-03-13 | McIntosh | North Dakota | 38051 | 685 | 9 |
2297854 | 2297854 | 2022-03-12 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2299801 | 2299801 | 2022-03-12 | McIntosh | North Dakota | 38051 | 685 | 9 |
2294602 | 2294602 | 2022-03-11 | Petersburg Borough | Alaska | 2195 | 685 | 2 |
2266906 | 2266906 | 2022-03-02 | Sheridan | Montana | 30091 | 685 | 11 |
2251661 | 2251661 | 2022-02-25 | Collingsworth | Texas | 48087 | 685 | 16 |
2248410 | 2248410 | 2022-02-24 | Collingsworth | Texas | 48087 | 685 | 16 |
2215748 | 2215748 | 2022-02-14 | Potter | South Dakota | 46107 | 685 | 7 |
2188966 | 2188966 | 2022-02-06 | Webster | Nebraska | 31181 | 685 | 9 |
2185713 | 2185713 | 2022-02-05 | Webster | Nebraska | 31181 | 685 | 9 |
2182461 | 2182461 | 2022-02-04 | Webster | Nebraska | 31181 | 685 | 9 |
2183108 | 2183108 | 2022-02-04 | Vieques | Puerto Rico | 72147 | 685 | |
2179201 | 2179201 | 2022-02-03 | Stanton | Nebraska | 31167 | 685 | 11 |
2169055 | 2169055 | 2022-01-31 | Lake of the Woods | Minnesota | 27077 | 685 | 5 |
2169522 | 2169522 | 2022-01-31 | Mora | New Mexico | 35033 | 685 | 16 |
2146932 | 2146932 | 2022-01-24 | Eddy | North Dakota | 38027 | 685 | 6 |
2147380 | 2147380 | 2022-01-24 | Bennett | South Dakota | 46007 | 685 | 9 |
2143321 | 2143321 | 2022-01-23 | Sweet Grass | Montana | 30097 | 685 | 8 |
2143678 | 2143678 | 2022-01-23 | Eddy | North Dakota | 38027 | 685 | 6 |
2140066 | 2140066 | 2022-01-22 | Sweet Grass | Montana | 30097 | 685 | 8 |
2140423 | 2140423 | 2022-01-22 | Eddy | North Dakota | 38027 | 685 | 6 |
2140441 | 2140441 | 2022-01-22 | Nelson | North Dakota | 38063 | 685 | 17 |
2136810 | 2136810 | 2022-01-21 | Sweet Grass | Montana | 30097 | 685 | 8 |
2132862 | 2132862 | 2022-01-20 | Osborne | Kansas | 20141 | 685 | 15 |
2132895 | 2132895 | 2022-01-20 | Woodson | Kansas | 20207 | 685 | 11 |
2129609 | 2129609 | 2022-01-19 | Osborne | Kansas | 20141 | 685 | 15 |
2129642 | 2129642 | 2022-01-19 | Woodson | Kansas | 20207 | 685 | 11 |
2110304 | 2110304 | 2022-01-13 | Tensas | Louisiana | 22107 | 685 | 10 |
2111407 | 2111407 | 2022-01-13 | Cameron | Pennsylvania | 42023 | 685 | 15 |
2107053 | 2107053 | 2022-01-12 | Tensas | Louisiana | 22107 | 685 | 10 |
2103802 | 2103802 | 2022-01-11 | Tensas | Louisiana | 22107 | 685 | 10 |
2102193 | 2102193 | 2022-01-10 | Reagan | Texas | 48383 | 685 | 11 |
2085129 | 2085129 | 2022-01-05 | Bowman | North Dakota | 38011 | 685 | 9 |
2063089 | 2063089 | 2021-12-29 | Haskell | Texas | 48207 | 685 | 37 |
2059839 | 2059839 | 2021-12-28 | Haskell | Texas | 48207 | 685 | 37 |
2054539 | 2054539 | 2021-12-27 | Pope | Illinois | 17151 | 685 | 7 |
2009763 | 2009763 | 2021-12-13 | Unknown | Minnesota | 685 | 124 | |
1995098 | 1995098 | 2021-12-08 | King and Queen | Virginia | 51097 | 685 | 9 |
1987008 | 1987008 | 2021-12-06 | Unknown | Minnesota | 685 | 124 | |
1973624 | 1973624 | 2021-12-02 | Carlisle | Kentucky | 21039 | 685 | 12 |
1968769 | 1968769 | 2021-11-30 | Coke | Texas | 48081 | 685 | 18 |
1960909 | 1960909 | 2021-11-28 | Ontonagon | Michigan | 26131 | 685 | 23 |
1957658 | 1957658 | 2021-11-27 | Ontonagon | Michigan | 26131 | 685 | 23 |
1954407 | 1954407 | 2021-11-26 | Ontonagon | Michigan | 26131 | 685 | 23 |
1951156 | 1951156 | 2021-11-25 | Ontonagon | Michigan | 26131 | 685 | 23 |
1947905 | 1947905 | 2021-11-24 | Ontonagon | Michigan | 26131 | 685 | 23 |
1932402 | 1932402 | 2021-11-19 | Wells | North Dakota | 38103 | 685 | 9 |
1933258 | 1933258 | 2021-11-19 | Essex | Vermont | 50009 | 685 | 2 |
1905751 | 1905751 | 2021-11-11 | Unknown | Minnesota | 685 | 124 | |
1907233 | 1907233 | 2021-11-11 | Garfield | Utah | 49017 | 685 | 12 |
1886346 | 1886346 | 2021-11-05 | Atchison | Missouri | 29005 | 685 | 7 |
1886874 | 1886874 | 2021-11-05 | LaMoure | North Dakota | 38045 | 685 | 17 |
1872123 | 1872123 | 2021-11-01 | Huerfano | Colorado | 8055 | 685 | 19 |
1858553 | 1858553 | 2021-10-27 | Charles City | Virginia | 51036 | 685 | 20 |
1853978 | 1853978 | 2021-10-26 | Chouteau | Montana | 30015 | 685 | 8 |
1846813 | 1846813 | 2021-10-24 | Meade | Kansas | 20119 | 685 | 14 |
1843563 | 1843563 | 2021-10-23 | Meade | Kansas | 20119 | 685 | 14 |
1840313 | 1840313 | 2021-10-22 | Meade | Kansas | 20119 | 685 | 14 |
1815041 | 1815041 | 2021-10-14 | Boone | Nebraska | 31011 | 685 | 4 |
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);