ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
319 rows where cases = 1912 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 32
- Louisiana 32
- North Dakota 25
- Texas 24
- Illinois 14
- Virginia 14
- Missouri 13
- Florida 10
- Indiana 10
- Michigan 10
- Mississippi 10
- Puerto Rico 10
- Arkansas 9
- California 9
- Iowa 9
- Kansas 8
- Kentucky 8
- West Virginia 8
- Minnesota 5
- Alabama 4
- Colorado 4
- Idaho 4
- New York 4
- North Carolina 4
- Ohio 4
- South Carolina 4
- Washington 4
- Wisconsin 4
- Pennsylvania 3
- South Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490268 | 2490268 | 2022-05-10 | Irwin | Georgia | 13155 | 1912 | 51 |
2487011 | 2487011 | 2022-05-09 | Irwin | Georgia | 13155 | 1912 | 51 |
2483753 | 2483753 | 2022-05-08 | Irwin | Georgia | 13155 | 1912 | 51 |
2480495 | 2480495 | 2022-05-07 | Irwin | Georgia | 13155 | 1912 | 51 |
2477237 | 2477237 | 2022-05-06 | Irwin | Georgia | 13155 | 1912 | 51 |
2473979 | 2473979 | 2022-05-05 | Irwin | Georgia | 13155 | 1912 | 51 |
2470722 | 2470722 | 2022-05-04 | Irwin | Georgia | 13155 | 1912 | 51 |
2425841 | 2425841 | 2022-04-20 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2422585 | 2422585 | 2022-04-19 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2419329 | 2419329 | 2022-04-18 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2416073 | 2416073 | 2022-04-17 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2412817 | 2412817 | 2022-04-16 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2409561 | 2409561 | 2022-04-15 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2406305 | 2406305 | 2022-04-14 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2403049 | 2403049 | 2022-04-13 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2399795 | 2399795 | 2022-04-12 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2396539 | 2396539 | 2022-04-11 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2393284 | 2393284 | 2022-04-10 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2390028 | 2390028 | 2022-04-09 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2386772 | 2386772 | 2022-04-08 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2383517 | 2383517 | 2022-04-07 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2380262 | 2380262 | 2022-04-06 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2377007 | 2377007 | 2022-04-05 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2373755 | 2373755 | 2022-04-04 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2370502 | 2370502 | 2022-04-03 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2367249 | 2367249 | 2022-04-02 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2363996 | 2363996 | 2022-04-01 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2360742 | 2360742 | 2022-03-31 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2357488 | 2357488 | 2022-03-30 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2354235 | 2354235 | 2022-03-29 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2350983 | 2350983 | 2022-03-28 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2347730 | 2347730 | 2022-03-27 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2344477 | 2344477 | 2022-03-26 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2341224 | 2341224 | 2022-03-25 | St. Helena | Louisiana | 22091 | 1912 | 23 |
2258640 | 2258640 | 2022-02-27 | Tucker | West Virginia | 54093 | 1912 | 33 |
2252400 | 2252400 | 2022-02-26 | Monroe | Arkansas | 5095 | 1912 | 31 |
2255389 | 2255389 | 2022-02-26 | Tucker | West Virginia | 54093 | 1912 | 33 |
2249149 | 2249149 | 2022-02-25 | Monroe | Arkansas | 5095 | 1912 | 31 |
2252138 | 2252138 | 2022-02-25 | Tucker | West Virginia | 54093 | 1912 | 33 |
2245898 | 2245898 | 2022-02-24 | Monroe | Arkansas | 5095 | 1912 | 31 |
2237421 | 2237421 | 2022-02-21 | Franklin | Mississippi | 28037 | 1912 | 36 |
2233708 | 2233708 | 2022-02-20 | Pratt | Kansas | 20151 | 1912 | 30 |
2234170 | 2234170 | 2022-02-20 | Franklin | Mississippi | 28037 | 1912 | 36 |
2230457 | 2230457 | 2022-02-19 | Pratt | Kansas | 20151 | 1912 | 30 |
2230919 | 2230919 | 2022-02-19 | Franklin | Mississippi | 28037 | 1912 | 36 |
2227206 | 2227206 | 2022-02-18 | Pratt | Kansas | 20151 | 1912 | 30 |
2227668 | 2227668 | 2022-02-18 | Franklin | Mississippi | 28037 | 1912 | 36 |
2224670 | 2224670 | 2022-02-17 | Cheyenne | Nebraska | 31033 | 1912 | 23 |
2186340 | 2186340 | 2022-02-05 | Patillas | Puerto Rico | 72109 | 1912 | |
2183088 | 2183088 | 2022-02-04 | Patillas | Puerto Rico | 72109 | 1912 | |
2176919 | 2176919 | 2022-02-02 | Hamilton | Texas | 48193 | 1912 | 29 |
2168719 | 2168719 | 2022-01-31 | Cumberland | Kentucky | 21057 | 1912 | 23 |
2164845 | 2164845 | 2022-01-30 | Candler | Georgia | 13043 | 1912 | 91 |
2161590 | 2161590 | 2022-01-29 | Candler | Georgia | 13043 | 1912 | 91 |
2158334 | 2158334 | 2022-01-28 | Candler | Georgia | 13043 | 1912 | 91 |
2146870 | 2146870 | 2022-01-24 | Jones | North Carolina | 37103 | 1912 | 38 |
2131035 | 2131035 | 2022-01-19 | Rincon | Puerto Rico | 72117 | 1912 | |
2125967 | 2125967 | 2022-01-18 | Fremont | Idaho | 16043 | 1912 | 20 |
2119328 | 2119328 | 2022-01-16 | Evans | Georgia | 13109 | 1912 | 58 |
2116076 | 2116076 | 2022-01-15 | Evans | Georgia | 13109 | 1912 | 58 |
2112825 | 2112825 | 2022-01-14 | Evans | Georgia | 13109 | 1912 | 58 |
2087995 | 2087995 | 2022-01-06 | Dawson | Montana | 30021 | 1912 | 52 |
2084746 | 2084746 | 2022-01-05 | Fergus | Montana | 30027 | 1912 | 51 |
2085781 | 2085781 | 2022-01-05 | Childress | Texas | 48075 | 1912 | 23 |
2019063 | 2019063 | 2021-12-16 | Marshall | Kansas | 20117 | 1912 | 34 |
2015813 | 2015813 | 2021-12-15 | Marshall | Kansas | 20117 | 1912 | 34 |
1995445 | 1995445 | 2021-12-09 | Valdez-Cordova Census Area | Alaska | 2261 | 1912 | 9 |
1992194 | 1992194 | 2021-12-08 | Valdez-Cordova Census Area | Alaska | 2261 | 1912 | 9 |
1975512 | 1975512 | 2021-12-02 | Addison | Vermont | 50001 | 1912 | 10 |
1966769 | 1966769 | 2021-11-30 | Menard | Illinois | 17129 | 1912 | 18 |
1963146 | 1963146 | 2021-11-29 | Prowers | Colorado | 8099 | 1912 | 37 |
1963452 | 1963452 | 2021-11-29 | Washington | Idaho | 16087 | 1912 | 47 |
1959818 | 1959818 | 2021-11-28 | Plumas | California | 6063 | 1912 | 7 |
1956567 | 1956567 | 2021-11-27 | Plumas | California | 6063 | 1912 | 7 |
1953316 | 1953316 | 2021-11-26 | Plumas | California | 6063 | 1912 | 7 |
1950065 | 1950065 | 2021-11-25 | Plumas | California | 6063 | 1912 | 7 |
1946814 | 1946814 | 2021-11-24 | Plumas | California | 6063 | 1912 | 7 |
1940696 | 1940696 | 2021-11-22 | Washington | Idaho | 16087 | 1912 | 47 |
1928346 | 1928346 | 2021-11-18 | Benzie | Michigan | 26019 | 1912 | 42 |
1925096 | 1925096 | 2021-11-17 | Benzie | Michigan | 26019 | 1912 | 42 |
1922959 | 1922959 | 2021-11-16 | Hatillo | Puerto Rico | 72065 | 1912 | |
1914111 | 1914111 | 2021-11-14 | Conecuh | Alabama | 1035 | 1912 | 60 |
1910861 | 1910861 | 2021-11-13 | Conecuh | Alabama | 1035 | 1912 | 60 |
1906828 | 1906828 | 2021-11-11 | Dewey | South Dakota | 46041 | 1912 | 32 |
1903579 | 1903579 | 2021-11-10 | Dewey | South Dakota | 46041 | 1912 | 32 |
1899879 | 1899879 | 2021-11-09 | McLean | North Dakota | 38055 | 1912 | 40 |
1884577 | 1884577 | 2021-11-04 | Greensville | Virginia | 51081 | 1912 | 27 |
1878629 | 1878629 | 2021-11-03 | Las Animas | Colorado | 8071 | 1912 | 23 |
1859932 | 1859932 | 2021-10-28 | Martin | Kentucky | 21159 | 1912 | 35 |
1859940 | 1859940 | 2021-10-28 | Metcalfe | Kentucky | 21169 | 1912 | 42 |
1856683 | 1856683 | 2021-10-27 | Martin | Kentucky | 21159 | 1912 | 35 |
1857957 | 1857957 | 2021-10-27 | Cidra | Puerto Rico | 72041 | 1912 | |
1848200 | 1848200 | 2021-10-24 | Cabo Rojo | Puerto Rico | 72023 | 1912 | |
1826647 | 1826647 | 2021-10-18 | Moffat | Colorado | 8081 | 1912 | 40 |
1755549 | 1755549 | 2021-09-26 | Mercer | Illinois | 17131 | 1912 | 34 |
1752301 | 1752301 | 2021-09-25 | Mercer | Illinois | 17131 | 1912 | 34 |
1749052 | 1749052 | 2021-09-24 | Mercer | Illinois | 17131 | 1912 | 34 |
1745802 | 1745802 | 2021-09-23 | Mercer | Illinois | 17131 | 1912 | 34 |
1739671 | 1739671 | 2021-09-21 | Estill | Kentucky | 21065 | 1912 | 12 |
1728294 | 1728294 | 2021-09-17 | Camp | Texas | 48063 | 1912 | 58 |
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);