ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
307 rows where cases = 1584 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 22
- Tennessee 21
- Missouri 20
- Iowa 19
- Texas 19
- Virginia 18
- Arkansas 10
- North Dakota 10
- Oklahoma 10
- Indiana 9
- Kansas 9
- Minnesota 9
- North Carolina 9
- Wyoming 9
- Alabama 8
- Louisiana 8
- Michigan 8
- Rhode Island 8
- West Virginia 8
- Florida 7
- Illinois 7
- Oregon 6
- Mississippi 5
- Puerto Rico 5
- New York 4
- California 3
- Colorado 3
- Idaho 3
- Kentucky 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2353067 | 2353067 | 2022-03-28 | Weston | Wyoming | 56045 | 1584 | 18 |
2349815 | 2349815 | 2022-03-27 | Weston | Wyoming | 56045 | 1584 | 18 |
2346562 | 2346562 | 2022-03-26 | Weston | Wyoming | 56045 | 1584 | 18 |
2343309 | 2343309 | 2022-03-25 | Weston | Wyoming | 56045 | 1584 | 18 |
2338816 | 2338816 | 2022-03-24 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2335562 | 2335562 | 2022-03-23 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2332308 | 2332308 | 2022-03-22 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2329055 | 2329055 | 2022-03-21 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2330295 | 2330295 | 2022-03-21 | Weston | Wyoming | 56045 | 1584 | 18 |
2325803 | 2325803 | 2022-03-20 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2327043 | 2327043 | 2022-03-20 | Weston | Wyoming | 56045 | 1584 | 18 |
2322550 | 2322550 | 2022-03-19 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2323790 | 2323790 | 2022-03-19 | Weston | Wyoming | 56045 | 1584 | 18 |
2319296 | 2319296 | 2022-03-18 | Bottineau | North Dakota | 38009 | 1584 | 26 |
2320536 | 2320536 | 2022-03-18 | Weston | Wyoming | 56045 | 1584 | 18 |
2262817 | 2262817 | 2022-03-01 | Davis | Iowa | 19051 | 1584 | 29 |
2263590 | 2263590 | 2022-03-01 | Shannon | Missouri | 29203 | 1584 | 35 |
2264237 | 2264237 | 2022-03-01 | Harney | Oregon | 41025 | 1584 | 37 |
2259566 | 2259566 | 2022-02-28 | Davis | Iowa | 19051 | 1584 | 29 |
2260339 | 2260339 | 2022-02-28 | Shannon | Missouri | 29203 | 1584 | 35 |
2256315 | 2256315 | 2022-02-27 | Davis | Iowa | 19051 | 1584 | 29 |
2253064 | 2253064 | 2022-02-26 | Davis | Iowa | 19051 | 1584 | 29 |
2249813 | 2249813 | 2022-02-25 | Davis | Iowa | 19051 | 1584 | 29 |
2246562 | 2246562 | 2022-02-24 | Davis | Iowa | 19051 | 1584 | 29 |
2243311 | 2243311 | 2022-02-23 | Davis | Iowa | 19051 | 1584 | 29 |
2150729 | 2150729 | 2022-01-25 | Hancock | Tennessee | 47067 | 1584 | 29 |
2147477 | 2147477 | 2022-01-24 | Hancock | Tennessee | 47067 | 1584 | 29 |
2144223 | 2144223 | 2022-01-23 | Hancock | Tennessee | 47067 | 1584 | 29 |
2140968 | 2140968 | 2022-01-22 | Hancock | Tennessee | 47067 | 1584 | 29 |
2137712 | 2137712 | 2022-01-21 | Hancock | Tennessee | 47067 | 1584 | 29 |
2134458 | 2134458 | 2022-01-20 | Hancock | Tennessee | 47067 | 1584 | 29 |
2135032 | 2135032 | 2022-01-20 | Pendleton | West Virginia | 54071 | 1584 | 16 |
2131206 | 2131206 | 2022-01-19 | Hancock | Tennessee | 47067 | 1584 | 29 |
2128358 | 2128358 | 2022-01-18 | Falls Church city | Virginia | 51610 | 1584 | 14 |
2113919 | 2113919 | 2022-01-14 | Harrison | Missouri | 29081 | 1584 | 26 |
2099272 | 2099272 | 2022-01-09 | Tyler | West Virginia | 54095 | 1584 | 26 |
2087410 | 2087410 | 2022-01-06 | Gallatin | Kentucky | 21077 | 1584 | 44 |
2058822 | 2058822 | 2021-12-28 | Hamilton | Nebraska | 31081 | 1584 | 19 |
2019623 | 2019623 | 2021-12-16 | Carroll | Missouri | 29033 | 1584 | 39 |
2006477 | 2006477 | 2021-12-12 | Marshall | Minnesota | 27089 | 1584 | 23 |
2003226 | 2003226 | 2021-12-11 | Marshall | Minnesota | 27089 | 1584 | 23 |
1999976 | 1999976 | 2021-12-10 | Marshall | Minnesota | 27089 | 1584 | 23 |
2001749 | 2001749 | 2021-12-10 | Summers | West Virginia | 54089 | 1584 | 35 |
1989821 | 1989821 | 2021-12-07 | Pawnee | Kansas | 20145 | 1584 | 20 |
1990102 | 1990102 | 2021-12-07 | Baraga | Michigan | 26013 | 1584 | 47 |
1991043 | 1991043 | 2021-12-07 | Latimer | Oklahoma | 40077 | 1584 | 26 |
1986571 | 1986571 | 2021-12-06 | Pawnee | Kansas | 20145 | 1584 | 20 |
1986852 | 1986852 | 2021-12-06 | Baraga | Michigan | 26013 | 1584 | 47 |
1987792 | 1987792 | 2021-12-06 | Latimer | Oklahoma | 40077 | 1584 | 26 |
1982900 | 1982900 | 2021-12-05 | Wilkes | Georgia | 13317 | 1584 | 38 |
1983270 | 1983270 | 2021-12-05 | Doniphan | Kansas | 20043 | 1584 | 29 |
1984542 | 1984542 | 2021-12-05 | Latimer | Oklahoma | 40077 | 1584 | 26 |
1979650 | 1979650 | 2021-12-04 | Wilkes | Georgia | 13317 | 1584 | 38 |
1980020 | 1980020 | 2021-12-04 | Doniphan | Kansas | 20043 | 1584 | 29 |
1981292 | 1981292 | 2021-12-04 | Latimer | Oklahoma | 40077 | 1584 | 26 |
1976400 | 1976400 | 2021-12-03 | Wilkes | Georgia | 13317 | 1584 | 38 |
1976770 | 1976770 | 2021-12-03 | Doniphan | Kansas | 20043 | 1584 | 29 |
1978042 | 1978042 | 2021-12-03 | Latimer | Oklahoma | 40077 | 1584 | 26 |
1973121 | 1973121 | 2021-12-02 | Stewart | Georgia | 13259 | 1584 | 29 |
1973151 | 1973151 | 2021-12-02 | Wilkes | Georgia | 13317 | 1584 | 38 |
1974792 | 1974792 | 2021-12-02 | Latimer | Oklahoma | 40077 | 1584 | 23 |
1969871 | 1969871 | 2021-12-01 | Stewart | Georgia | 13259 | 1584 | 29 |
1971543 | 1971543 | 2021-12-01 | Latimer | Oklahoma | 40077 | 1584 | 23 |
1972163 | 1972163 | 2021-12-01 | Parmer | Texas | 48369 | 1584 | 41 |
1962264 | 1962264 | 2021-11-28 | Clay | Texas | 48077 | 1584 | 25 |
1959013 | 1959013 | 2021-11-27 | Clay | Texas | 48077 | 1584 | 25 |
1955762 | 1955762 | 2021-11-26 | Clay | Texas | 48077 | 1584 | 25 |
1952511 | 1952511 | 2021-11-25 | Clay | Texas | 48077 | 1584 | 25 |
1949260 | 1949260 | 2021-11-24 | Clay | Texas | 48077 | 1584 | 25 |
1917012 | 1917012 | 2021-11-14 | Orange | Vermont | 50017 | 1584 | 6 |
1891738 | 1891738 | 2021-11-07 | Atkinson | Georgia | 13003 | 1584 | 37 |
1888488 | 1888488 | 2021-11-06 | Atkinson | Georgia | 13003 | 1584 | 37 |
1885238 | 1885238 | 2021-11-05 | Atkinson | Georgia | 13003 | 1584 | 37 |
1881989 | 1881989 | 2021-11-04 | Atkinson | Georgia | 13003 | 1584 | 37 |
1878740 | 1878740 | 2021-11-03 | Atkinson | Georgia | 13003 | 1584 | 37 |
1880849 | 1880849 | 2021-11-03 | Lake | South Dakota | 46079 | 1584 | 20 |
1875491 | 1875491 | 2021-11-02 | Atkinson | Georgia | 13003 | 1584 | 37 |
1857231 | 1857231 | 2021-10-27 | Deer Lodge | Montana | 30023 | 1584 | 24 |
1850522 | 1850522 | 2021-10-25 | Yellow Medicine | Minnesota | 27173 | 1584 | 20 |
1851629 | 1851629 | 2021-10-25 | Todd | South Dakota | 46121 | 1584 | 36 |
1813964 | 1813964 | 2021-10-14 | Teton | Idaho | 16081 | 1584 | 5 |
1811604 | 1811604 | 2021-10-13 | Tunica | Mississippi | 28143 | 1584 | 39 |
1812713 | 1812713 | 2021-10-13 | Perry | Tennessee | 47135 | 1584 | 34 |
1790834 | 1790834 | 2021-10-07 | Mono | California | 6051 | 1584 | 5 |
1783671 | 1783671 | 2021-10-04 | Morris | Texas | 48343 | 1584 | 47 |
1780422 | 1780422 | 2021-10-03 | Morris | Texas | 48343 | 1584 | 47 |
1777172 | 1777172 | 2021-10-02 | Morris | Texas | 48343 | 1584 | 47 |
1773922 | 1773922 | 2021-10-01 | Morris | Texas | 48343 | 1584 | 47 |
1762571 | 1762571 | 2021-09-28 | Knox | Maine | 23013 | 1584 | 10 |
1732388 | 1732388 | 2021-09-19 | Bent | Colorado | 8011 | 1584 | 23 |
1729138 | 1729138 | 2021-09-18 | Bent | Colorado | 8011 | 1584 | 23 |
1725888 | 1725888 | 2021-09-17 | Bent | Colorado | 8011 | 1584 | 23 |
1723159 | 1723159 | 2021-09-16 | Pulaski | Indiana | 18131 | 1584 | 50 |
1721606 | 1721606 | 2021-09-15 | Bon Homme | South Dakota | 46009 | 1584 | 29 |
1710915 | 1710915 | 2021-09-12 | Cedar | Missouri | 29039 | 1584 | 29 |
1702764 | 1702764 | 2021-09-09 | Grant | West Virginia | 54023 | 1584 | 30 |
1698641 | 1698641 | 2021-09-08 | Curry | Oregon | 41015 | 1584 | 16 |
1699564 | 1699564 | 2021-09-08 | Buffalo | Wisconsin | 55011 | 1584 | 7 |
1699636 | 1699636 | 2021-09-08 | Converse | Wyoming | 56009 | 1584 | 25 |
1685745 | 1685745 | 2021-09-04 | Aguas Buenas | Puerto Rico | 72007 | 1584 |
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);