ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
285 rows where cases = 1807 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 41
- Georgia 18
- Iowa 16
- Texas 16
- Kentucky 14
- Missouri 14
- North Carolina 11
- Illinois 10
- Kansas 10
- Puerto Rico 10
- Indiana 9
- Minnesota 9
- Virginia 9
- Arkansas 7
- Florida 7
- Montana 7
- Alabama 6
- Louisiana 6
- Mississippi 6
- Tennessee 6
- Wisconsin 6
- Pennsylvania 5
- South Carolina 5
- South Dakota 5
- Colorado 3
- Idaho 3
- Michigan 3
- North Dakota 3
- Washington 3
- West Virginia 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500509 | 2500509 | 2022-05-13 | Greenwood | Kansas | 20073 | 1807 | 23 |
2502067 | 2502067 | 2022-05-13 | Fall River | South Dakota | 46047 | 1807 | 39 |
2498809 | 2498809 | 2022-05-12 | Fall River | South Dakota | 46047 | 1807 | 39 |
2495551 | 2495551 | 2022-05-11 | Fall River | South Dakota | 46047 | 1807 | 39 |
2426317 | 2426317 | 2022-04-20 | Madison | Montana | 30057 | 1807 | 20 |
2426365 | 2426365 | 2022-04-20 | Cuming | Nebraska | 31039 | 1807 | 15 |
2423061 | 2423061 | 2022-04-19 | Madison | Montana | 30057 | 1807 | 20 |
2423109 | 2423109 | 2022-04-19 | Cuming | Nebraska | 31039 | 1807 | 15 |
2400318 | 2400318 | 2022-04-12 | Cuming | Nebraska | 31039 | 1807 | 15 |
2400372 | 2400372 | 2022-04-12 | Richardson | Nebraska | 31147 | 1807 | 24 |
2397015 | 2397015 | 2022-04-11 | Madison | Montana | 30057 | 1807 | 20 |
2397063 | 2397063 | 2022-04-11 | Cuming | Nebraska | 31039 | 1807 | 15 |
2397117 | 2397117 | 2022-04-11 | Richardson | Nebraska | 31147 | 1807 | 24 |
2393808 | 2393808 | 2022-04-10 | Cuming | Nebraska | 31039 | 1807 | 15 |
2393862 | 2393862 | 2022-04-10 | Richardson | Nebraska | 31147 | 1807 | 24 |
2390552 | 2390552 | 2022-04-09 | Cuming | Nebraska | 31039 | 1807 | 15 |
2390606 | 2390606 | 2022-04-09 | Richardson | Nebraska | 31147 | 1807 | 24 |
2387296 | 2387296 | 2022-04-08 | Cuming | Nebraska | 31039 | 1807 | 15 |
2387350 | 2387350 | 2022-04-08 | Richardson | Nebraska | 31147 | 1807 | 24 |
2384041 | 2384041 | 2022-04-07 | Cuming | Nebraska | 31039 | 1807 | 15 |
2384095 | 2384095 | 2022-04-07 | Richardson | Nebraska | 31147 | 1807 | 24 |
2380786 | 2380786 | 2022-04-06 | Cuming | Nebraska | 31039 | 1807 | 15 |
2380840 | 2380840 | 2022-04-06 | Richardson | Nebraska | 31147 | 1807 | 24 |
2377531 | 2377531 | 2022-04-05 | Cuming | Nebraska | 31039 | 1807 | 15 |
2377585 | 2377585 | 2022-04-05 | Richardson | Nebraska | 31147 | 1807 | 24 |
2374278 | 2374278 | 2022-04-04 | Cuming | Nebraska | 31039 | 1807 | 15 |
2374332 | 2374332 | 2022-04-04 | Richardson | Nebraska | 31147 | 1807 | 24 |
2371026 | 2371026 | 2022-04-03 | Cuming | Nebraska | 31039 | 1807 | 15 |
2371080 | 2371080 | 2022-04-03 | Richardson | Nebraska | 31147 | 1807 | 24 |
2367773 | 2367773 | 2022-04-02 | Cuming | Nebraska | 31039 | 1807 | 15 |
2367827 | 2367827 | 2022-04-02 | Richardson | Nebraska | 31147 | 1807 | 24 |
2364520 | 2364520 | 2022-04-01 | Cuming | Nebraska | 31039 | 1807 | 15 |
2364574 | 2364574 | 2022-04-01 | Richardson | Nebraska | 31147 | 1807 | 24 |
2361266 | 2361266 | 2022-03-31 | Cuming | Nebraska | 31039 | 1807 | 15 |
2361320 | 2361320 | 2022-03-31 | Richardson | Nebraska | 31147 | 1807 | 24 |
2358066 | 2358066 | 2022-03-30 | Richardson | Nebraska | 31147 | 1807 | 24 |
2354759 | 2354759 | 2022-03-29 | Cuming | Nebraska | 31039 | 1807 | 15 |
2354813 | 2354813 | 2022-03-29 | Richardson | Nebraska | 31147 | 1807 | 24 |
2348254 | 2348254 | 2022-03-27 | Cuming | Nebraska | 31039 | 1807 | 15 |
2345001 | 2345001 | 2022-03-26 | Cuming | Nebraska | 31039 | 1807 | 15 |
2341748 | 2341748 | 2022-03-25 | Cuming | Nebraska | 31039 | 1807 | 15 |
2338495 | 2338495 | 2022-03-24 | Cuming | Nebraska | 31039 | 1807 | 15 |
2335241 | 2335241 | 2022-03-23 | Cuming | Nebraska | 31039 | 1807 | 15 |
2331987 | 2331987 | 2022-03-22 | Cuming | Nebraska | 31039 | 1807 | 15 |
2332666 | 2332666 | 2022-03-22 | Hormigueros | Puerto Rico | 72067 | 1807 | |
2329413 | 2329413 | 2022-03-21 | Hormigueros | Puerto Rico | 72067 | 1807 | |
2325482 | 2325482 | 2022-03-20 | Cuming | Nebraska | 31039 | 1807 | 15 |
2322228 | 2322228 | 2022-03-19 | Cuming | Nebraska | 31039 | 1807 | 15 |
2290855 | 2290855 | 2022-03-09 | Stephens | Texas | 48429 | 1807 | 45 |
2284617 | 2284617 | 2022-03-07 | Calhoun | West Virginia | 54013 | 1807 | 13 |
2225799 | 2225799 | 2022-02-17 | Rains | Texas | 48379 | 1807 | 56 |
2222606 | 2222606 | 2022-02-16 | Winkler | Texas | 48495 | 1807 | 34 |
2151317 | 2151317 | 2022-01-25 | Webster | West Virginia | 54101 | 1807 | 27 |
2142602 | 2142602 | 2022-01-23 | Kingman | Kansas | 20095 | 1807 | 25 |
2144048 | 2144048 | 2022-01-23 | Patillas | Puerto Rico | 72109 | 1807 | |
2139347 | 2139347 | 2022-01-22 | Kingman | Kansas | 20095 | 1807 | 25 |
2136091 | 2136091 | 2022-01-21 | Kingman | Kansas | 20095 | 1807 | 25 |
2132818 | 2132818 | 2022-01-20 | Ellsworth | Kansas | 20053 | 1807 | 30 |
2133439 | 2133439 | 2022-01-20 | Iron | Missouri | 29093 | 1807 | 33 |
2133610 | 2133610 | 2022-01-20 | Holt | Nebraska | 31089 | 1807 | 17 |
2129565 | 2129565 | 2022-01-19 | Ellsworth | Kansas | 20053 | 1807 | 30 |
2126459 | 2126459 | 2022-01-18 | Livingston | Kentucky | 21139 | 1807 | 51 |
2103091 | 2103091 | 2022-01-11 | Heard | Georgia | 13149 | 1807 | 43 |
2105713 | 2105713 | 2022-01-11 | Pend Oreille | Washington | 53051 | 1807 | 26 |
2089222 | 2089222 | 2022-01-06 | Trinity | Texas | 48455 | 1807 | 64 |
2089256 | 2089256 | 2022-01-06 | Emery | Utah | 49015 | 1807 | 25 |
2082799 | 2082799 | 2022-01-04 | Amelia | Virginia | 51007 | 1807 | 44 |
2079439 | 2079439 | 2022-01-03 | Runnels | Texas | 48399 | 1807 | 56 |
2051093 | 2051093 | 2021-12-26 | Long | Georgia | 13183 | 1807 | 29 |
2052966 | 2052966 | 2021-12-26 | Coamo | Puerto Rico | 72043 | 1807 | |
2047843 | 2047843 | 2021-12-25 | Long | Georgia | 13183 | 1807 | 29 |
2044177 | 2044177 | 2021-12-24 | Wilcox | Alabama | 1131 | 1807 | 38 |
2044593 | 2044593 | 2021-12-24 | Long | Georgia | 13183 | 1807 | 29 |
2041028 | 2041028 | 2021-12-23 | Pike | Arkansas | 5109 | 1807 | 39 |
2041344 | 2041344 | 2021-12-23 | Long | Georgia | 13183 | 1807 | 29 |
2037778 | 2037778 | 2021-12-22 | Pike | Arkansas | 5109 | 1807 | 39 |
2038094 | 2038094 | 2021-12-22 | Long | Georgia | 13183 | 1807 | 29 |
2017522 | 2017522 | 2021-12-15 | Childress | Texas | 48075 | 1807 | 22 |
2008998 | 2008998 | 2021-12-13 | Jasper | Illinois | 17079 | 1807 | 23 |
1998530 | 1998530 | 2021-12-09 | Forest | Wisconsin | 55041 | 1807 | 34 |
1983977 | 1983977 | 2021-12-05 | Dawson | Montana | 30021 | 1807 | 49 |
1980727 | 1980727 | 2021-12-04 | Dawson | Montana | 30021 | 1807 | 49 |
1977477 | 1977477 | 2021-12-03 | Dawson | Montana | 30021 | 1807 | 49 |
1973132 | 1973132 | 2021-12-02 | Towns | Georgia | 13281 | 1807 | 84 |
1971699 | 1971699 | 2021-12-01 | Camuy | Puerto Rico | 72027 | 1807 | |
1968011 | 1968011 | 2021-11-30 | Alleghany | North Carolina | 37005 | 1807 | 6 |
1924357 | 1924357 | 2021-11-17 | Screven | Georgia | 13251 | 1807 | 62 |
1921108 | 1921108 | 2021-11-16 | Screven | Georgia | 13251 | 1807 | 62 |
1909097 | 1909097 | 2021-11-12 | Barton | Missouri | 29011 | 1807 | 29 |
1905848 | 1905848 | 2021-11-11 | Barton | Missouri | 29011 | 1807 | 29 |
1902599 | 1902599 | 2021-11-10 | Barton | Missouri | 29011 | 1807 | 29 |
1812153 | 1812153 | 2021-10-13 | Mountrail | North Dakota | 38061 | 1807 | 23 |
1809438 | 1809438 | 2021-10-12 | Houston | Tennessee | 47083 | 1807 | 43 |
1783765 | 1783765 | 2021-10-04 | Juab | Utah | 49023 | 1807 | 16 |
1769343 | 1769343 | 2021-09-30 | Noxubee | Mississippi | 28103 | 1807 | 40 |
1758261 | 1758261 | 2021-09-27 | Desha | Arkansas | 5041 | 1807 | 29 |
1733322 | 1733322 | 2021-09-19 | West Carroll | Louisiana | 22123 | 1807 | 46 |
1730072 | 1730072 | 2021-09-18 | West Carroll | Louisiana | 22123 | 1807 | 46 |
1726822 | 1726822 | 2021-09-17 | West Carroll | Louisiana | 22123 | 1807 | 46 |
1717858 | 1717858 | 2021-09-14 | Mitchell | North Carolina | 37121 | 1807 | 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);