ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
267 rows where cases = 1867 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 24
- Michigan 23
- Iowa 21
- Georgia 18
- Minnesota 12
- Kentucky 10
- Virginia 10
- Mississippi 9
- Missouri 9
- Ohio 9
- Oklahoma 8
- Puerto Rico 8
- Rhode Island 7
- Arkansas 6
- Illinois 6
- Indiana 6
- Montana 6
- North Carolina 6
- Alabama 5
- Idaho 5
- New Hampshire 5
- West Virginia 5
- Kansas 4
- Pennsylvania 4
- Washington 4
- Wisconsin 4
- Florida 3
- Louisiana 3
- Nebraska 3
- North Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468246 | 2468246 | 2022-05-03 | Alger | Michigan | 26003 | 1867 | 13 |
2464991 | 2464991 | 2022-05-02 | Alger | Michigan | 26003 | 1867 | 13 |
2461735 | 2461735 | 2022-05-01 | Alger | Michigan | 26003 | 1867 | 13 |
2458479 | 2458479 | 2022-04-30 | Alger | Michigan | 26003 | 1867 | 13 |
2455223 | 2455223 | 2022-04-29 | Alger | Michigan | 26003 | 1867 | 13 |
2451967 | 2451967 | 2022-04-28 | Alger | Michigan | 26003 | 1867 | 13 |
2453832 | 2453832 | 2022-04-28 | Calhoun | West Virginia | 54013 | 1867 | 14 |
2448711 | 2448711 | 2022-04-27 | Alger | Michigan | 26003 | 1867 | 13 |
2445455 | 2445455 | 2022-04-26 | Alger | Michigan | 26003 | 1867 | 13 |
2442199 | 2442199 | 2022-04-25 | Alger | Michigan | 26003 | 1867 | 13 |
2438943 | 2438943 | 2022-04-24 | Alger | Michigan | 26003 | 1867 | 13 |
2435687 | 2435687 | 2022-04-23 | Alger | Michigan | 26003 | 1867 | 13 |
2432431 | 2432431 | 2022-04-22 | Alger | Michigan | 26003 | 1867 | 13 |
2429175 | 2429175 | 2022-04-21 | Alger | Michigan | 26003 | 1867 | 13 |
2425919 | 2425919 | 2022-04-20 | Alger | Michigan | 26003 | 1867 | 13 |
2422663 | 2422663 | 2022-04-19 | Alger | Michigan | 26003 | 1867 | 13 |
2419407 | 2419407 | 2022-04-18 | Alger | Michigan | 26003 | 1867 | 13 |
2419815 | 2419815 | 2022-04-18 | Powell | Montana | 30077 | 1867 | 28 |
2416151 | 2416151 | 2022-04-17 | Alger | Michigan | 26003 | 1867 | 13 |
2416560 | 2416560 | 2022-04-17 | Powell | Montana | 30077 | 1867 | 28 |
2412895 | 2412895 | 2022-04-16 | Alger | Michigan | 26003 | 1867 | 13 |
2413304 | 2413304 | 2022-04-16 | Powell | Montana | 30077 | 1867 | 28 |
2409639 | 2409639 | 2022-04-15 | Alger | Michigan | 26003 | 1867 | 13 |
2410048 | 2410048 | 2022-04-15 | Powell | Montana | 30077 | 1867 | 28 |
2406383 | 2406383 | 2022-04-14 | Alger | Michigan | 26003 | 1867 | 13 |
2406792 | 2406792 | 2022-04-14 | Powell | Montana | 30077 | 1867 | 28 |
2403127 | 2403127 | 2022-04-13 | Alger | Michigan | 26003 | 1867 | 13 |
2262859 | 2262859 | 2022-03-01 | Monroe | Iowa | 19135 | 1867 | 48 |
2259608 | 2259608 | 2022-02-28 | Monroe | Iowa | 19135 | 1867 | 48 |
2256357 | 2256357 | 2022-02-27 | Monroe | Iowa | 19135 | 1867 | 48 |
2253106 | 2253106 | 2022-02-26 | Monroe | Iowa | 19135 | 1867 | 48 |
2249855 | 2249855 | 2022-02-25 | Monroe | Iowa | 19135 | 1867 | 48 |
2246604 | 2246604 | 2022-02-24 | Monroe | Iowa | 19135 | 1867 | 48 |
2243353 | 2243353 | 2022-02-23 | Monroe | Iowa | 19135 | 1867 | 48 |
2222456 | 2222456 | 2022-02-16 | Hansford | Texas | 48195 | 1867 | 28 |
2219205 | 2219205 | 2022-02-15 | Hansford | Texas | 48195 | 1867 | 28 |
2209863 | 2209863 | 2022-02-12 | Pendleton | West Virginia | 54071 | 1867 | 16 |
2206610 | 2206610 | 2022-02-11 | Pendleton | West Virginia | 54071 | 1867 | 16 |
2199669 | 2199669 | 2022-02-09 | Floyd | Texas | 48153 | 1867 | 46 |
2196557 | 2196557 | 2022-02-08 | Swisher | Texas | 48437 | 1867 | 31 |
2190467 | 2190467 | 2022-02-07 | Choctaw | Alabama | 1023 | 1867 | 33 |
2176235 | 2176235 | 2022-02-02 | Pembina | North Dakota | 38067 | 1867 | 16 |
2172982 | 2172982 | 2022-02-01 | Pembina | North Dakota | 38067 | 1867 | 16 |
2164957 | 2164957 | 2022-01-30 | Taylor | Georgia | 13269 | 1867 | 47 |
2161702 | 2161702 | 2022-01-29 | Taylor | Georgia | 13269 | 1867 | 47 |
2158446 | 2158446 | 2022-01-28 | Taylor | Georgia | 13269 | 1867 | 47 |
2152207 | 2152207 | 2022-01-26 | Warren | Indiana | 18171 | 1867 | 24 |
2149543 | 2149543 | 2022-01-25 | Murray | Minnesota | 27101 | 1867 | 15 |
2142729 | 2142729 | 2022-01-23 | Livingston | Kentucky | 21139 | 1867 | 51 |
2139474 | 2139474 | 2022-01-22 | Livingston | Kentucky | 21139 | 1867 | 51 |
2136218 | 2136218 | 2022-01-21 | Livingston | Kentucky | 21139 | 1867 | 51 |
2137987 | 2137987 | 2022-01-21 | Somervell | Texas | 48425 | 1867 | 30 |
2130001 | 2130001 | 2022-01-19 | Jackson | Minnesota | 27063 | 1867 | 16 |
2127781 | 2127781 | 2022-01-18 | Rincon | Puerto Rico | 72117 | 1867 | |
2127783 | 2127783 | 2022-01-18 | Sabana Grande | Puerto Rico | 72121 | 1867 | |
2124529 | 2124529 | 2022-01-17 | Rincon | Puerto Rico | 72117 | 1867 | |
2124818 | 2124818 | 2022-01-17 | Dallam | Texas | 48111 | 1867 | 34 |
2119433 | 2119433 | 2022-01-16 | Wilkinson | Georgia | 13319 | 1867 | 48 |
2116181 | 2116181 | 2022-01-15 | Wilkinson | Georgia | 13319 | 1867 | 48 |
2112930 | 2112930 | 2022-01-14 | Wilkinson | Georgia | 13319 | 1867 | 48 |
2103545 | 2103545 | 2022-01-11 | Doniphan | Kansas | 20043 | 1867 | 32 |
2100294 | 2100294 | 2022-01-10 | Doniphan | Kansas | 20043 | 1867 | 32 |
2089380 | 2089380 | 2022-01-06 | Nelson | Virginia | 51125 | 1867 | 24 |
2080444 | 2080444 | 2022-01-04 | Franklin | Idaho | 16041 | 1867 | 27 |
2080743 | 2080743 | 2022-01-04 | Sac | Iowa | 19161 | 1867 | 28 |
2077491 | 2077491 | 2022-01-03 | Sac | Iowa | 19161 | 1867 | 28 |
2073961 | 2073961 | 2022-01-02 | Teton | Idaho | 16081 | 1867 | 8 |
2074240 | 2074240 | 2022-01-02 | Sac | Iowa | 19161 | 1867 | 28 |
2070710 | 2070710 | 2022-01-01 | Teton | Idaho | 16081 | 1867 | 8 |
2070989 | 2070989 | 2022-01-01 | Sac | Iowa | 19161 | 1867 | 28 |
2067459 | 2067459 | 2021-12-31 | Teton | Idaho | 16081 | 1867 | 8 |
2067738 | 2067738 | 2021-12-31 | Sac | Iowa | 19161 | 1867 | 28 |
2064139 | 2064139 | 2021-12-30 | Towns | Georgia | 13281 | 1867 | 88 |
2064208 | 2064208 | 2021-12-30 | Teton | Idaho | 16081 | 1867 | 8 |
2064487 | 2064487 | 2021-12-30 | Sac | Iowa | 19161 | 1867 | 28 |
2061237 | 2061237 | 2021-12-29 | Sac | Iowa | 19161 | 1867 | 28 |
2035429 | 2035429 | 2021-12-21 | Lee | Kentucky | 21129 | 1867 | 40 |
2001522 | 2001522 | 2021-12-10 | Lamoille | Vermont | 50015 | 1867 | 9 |
1992121 | 1992121 | 2021-12-08 | Coosa | Alabama | 1037 | 1867 | 48 |
1990595 | 1990595 | 2021-12-07 | Red Willow | Nebraska | 31145 | 1867 | 16 |
1943595 | 1943595 | 2021-11-23 | Bent | Colorado | 8011 | 1867 | 31 |
1944563 | 1944563 | 2021-11-23 | Kent | Maryland | 24029 | 1867 | 56 |
1918901 | 1918901 | 2021-11-15 | Linn | Missouri | 29115 | 1867 | 27 |
1915651 | 1915651 | 2021-11-14 | Linn | Missouri | 29115 | 1867 | 27 |
1912401 | 1912401 | 2021-11-13 | Linn | Missouri | 29115 | 1867 | 27 |
1910249 | 1910249 | 2021-11-12 | Callahan | Texas | 48059 | 1867 | 57 |
1907000 | 1907000 | 2021-11-11 | Callahan | Texas | 48059 | 1867 | 57 |
1877194 | 1877194 | 2021-11-02 | Harrison | Ohio | 39067 | 1867 | 48 |
1861325 | 1861325 | 2021-10-28 | Butte | South Dakota | 46019 | 1867 | 31 |
1847324 | 1847324 | 2021-10-24 | Noxubee | Mississippi | 28103 | 1867 | 40 |
1844074 | 1844074 | 2021-10-23 | Noxubee | Mississippi | 28103 | 1867 | 40 |
1840824 | 1840824 | 2021-10-22 | Noxubee | Mississippi | 28103 | 1867 | 40 |
1841393 | 1841393 | 2021-10-22 | Mountrail | North Dakota | 38061 | 1867 | 25 |
1835200 | 1835200 | 2021-10-20 | Barranquitas | Puerto Rico | 72019 | 1867 | |
1762317 | 1762317 | 2021-09-28 | Jackson | Kansas | 20085 | 1867 | 19 |
1759069 | 1759069 | 2021-09-27 | Jackson | Kansas | 20085 | 1867 | 19 |
1757174 | 1757174 | 2021-09-26 | Fulton | Pennsylvania | 42057 | 1867 | 23 |
1740989 | 1740989 | 2021-09-21 | Cidra | Puerto Rico | 72041 | 1867 | |
1737505 | 1737505 | 2021-09-20 | Monroe | Ohio | 39111 | 1867 | 49 |
1737740 | 1737740 | 2021-09-20 | Cidra | Puerto Rico | 72041 | 1867 |
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);