ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
336 rows where cases = 1654 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 28
- Texas 28
- Kentucky 22
- Puerto Rico 22
- Missouri 21
- Georgia 19
- Illinois 18
- Minnesota 16
- Indiana 11
- Kansas 10
- Oklahoma 10
- Michigan 8
- North Carolina 8
- South Carolina 7
- Tennessee 7
- Virginia 7
- Wisconsin 7
- Alabama 6
- Florida 6
- Louisiana 6
- Montana 6
- West Virginia 6
- Iowa 5
- Mississippi 5
- New Mexico 5
- Ohio 5
- Colorado 4
- Pennsylvania 4
- Idaho 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500511 | 2500511 | 2022-05-13 | Harper | Kansas | 20077 | 1654 | 27 |
2426086 | 2426086 | 2022-04-20 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2422830 | 2422830 | 2022-04-19 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2419574 | 2419574 | 2022-04-18 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2416318 | 2416318 | 2022-04-17 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2413062 | 2413062 | 2022-04-16 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2409806 | 2409806 | 2022-04-15 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2406550 | 2406550 | 2022-04-14 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2403294 | 2403294 | 2022-04-13 | Wilkin | Minnesota | 27167 | 1654 | 22 |
2284291 | 2284291 | 2022-03-07 | Marion | Texas | 48315 | 1654 | 59 |
2281039 | 2281039 | 2022-03-06 | Marion | Texas | 48315 | 1654 | 59 |
2277786 | 2277786 | 2022-03-05 | Marion | Texas | 48315 | 1654 | 59 |
2247268 | 2247268 | 2022-02-24 | Daviess | Missouri | 29061 | 1654 | 26 |
2224501 | 2224501 | 2022-02-17 | Chariton | Missouri | 29041 | 1654 | 34 |
2194955 | 2194955 | 2022-02-08 | Alcona | Michigan | 26001 | 1654 | 67 |
2191701 | 2191701 | 2022-02-07 | Alcona | Michigan | 26001 | 1654 | 67 |
2192062 | 2192062 | 2022-02-07 | Sullivan | Missouri | 29211 | 1654 | 19 |
2180554 | 2180554 | 2022-02-03 | Calhoun | West Virginia | 54013 | 1654 | 10 |
2174685 | 2174685 | 2022-02-02 | Miller | Georgia | 13201 | 1654 | 26 |
2141937 | 2141937 | 2022-01-23 | Lake | Colorado | 8065 | 1654 | 2 |
2142903 | 2142903 | 2022-01-23 | Alger | Michigan | 26003 | 1654 | 11 |
2138682 | 2138682 | 2022-01-22 | Lake | Colorado | 8065 | 1654 | 2 |
2139648 | 2139648 | 2022-01-22 | Alger | Michigan | 26003 | 1654 | 11 |
2135426 | 2135426 | 2022-01-21 | Lake | Colorado | 8065 | 1654 | 2 |
2136392 | 2136392 | 2022-01-21 | Alger | Michigan | 26003 | 1654 | 11 |
2099536 | 2099536 | 2022-01-10 | Nevada | Arkansas | 5099 | 1654 | 43 |
2084833 | 2084833 | 2022-01-05 | Holt | Nebraska | 31089 | 1654 | 16 |
2074145 | 2074145 | 2022-01-02 | Switzerland | Indiana | 18155 | 1654 | 14 |
2070894 | 2070894 | 2022-01-01 | Switzerland | Indiana | 18155 | 1654 | 14 |
2067643 | 2067643 | 2021-12-31 | Switzerland | Indiana | 18155 | 1654 | 14 |
2064392 | 2064392 | 2021-12-30 | Switzerland | Indiana | 18155 | 1654 | 14 |
2052126 | 2052126 | 2021-12-26 | Carroll | Missouri | 29033 | 1654 | 39 |
2052666 | 2052666 | 2021-12-26 | Traill | North Dakota | 38097 | 1654 | 21 |
2048876 | 2048876 | 2021-12-25 | Carroll | Missouri | 29033 | 1654 | 39 |
2049416 | 2049416 | 2021-12-25 | Traill | North Dakota | 38097 | 1654 | 21 |
2045626 | 2045626 | 2021-12-24 | Carroll | Missouri | 29033 | 1654 | 39 |
2042376 | 2042376 | 2021-12-23 | Carroll | Missouri | 29033 | 1654 | 39 |
2019451 | 2019451 | 2021-12-16 | Clearwater | Minnesota | 27029 | 1654 | 24 |
2017748 | 2017748 | 2021-12-15 | Grand | Utah | 49019 | 1654 | 7 |
2013095 | 2013095 | 2021-12-14 | Tunica | Mississippi | 28143 | 1654 | 39 |
2011355 | 2011355 | 2021-12-13 | Lexington city | Virginia | 51678 | 1654 | 37 |
1992547 | 1992547 | 2021-12-08 | Evans | Georgia | 13109 | 1654 | 54 |
1994514 | 1994514 | 2021-12-08 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1989296 | 1989296 | 2021-12-07 | Evans | Georgia | 13109 | 1654 | 54 |
1991189 | 1991189 | 2021-12-07 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1991263 | 1991263 | 2021-12-07 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1986046 | 1986046 | 2021-12-06 | Evans | Georgia | 13109 | 1654 | 54 |
1987938 | 1987938 | 2021-12-06 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1988012 | 1988012 | 2021-12-06 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1982796 | 1982796 | 2021-12-05 | Evans | Georgia | 13109 | 1654 | 54 |
1984688 | 1984688 | 2021-12-05 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1984762 | 1984762 | 2021-12-05 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1979546 | 1979546 | 2021-12-04 | Evans | Georgia | 13109 | 1654 | 54 |
1981438 | 1981438 | 2021-12-04 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1981512 | 1981512 | 2021-12-04 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1976296 | 1976296 | 2021-12-03 | Evans | Georgia | 13109 | 1654 | 54 |
1978188 | 1978188 | 2021-12-03 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1978262 | 1978262 | 2021-12-03 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1974938 | 1974938 | 2021-12-02 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1975012 | 1975012 | 2021-12-02 | Yabucoa | Puerto Rico | 72151 | 1654 | |
1971689 | 1971689 | 2021-12-01 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1968439 | 1968439 | 2021-11-30 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1963295 | 1963295 | 2021-11-29 | Evans | Georgia | 13109 | 1654 | 54 |
1964253 | 1964253 | 2021-11-29 | Stevens | Minnesota | 27149 | 1654 | 11 |
1964528 | 1964528 | 2021-11-29 | Box Butte | Nebraska | 31013 | 1654 | 16 |
1965188 | 1965188 | 2021-11-29 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1961226 | 1961226 | 2021-11-28 | Deer Lodge | Montana | 30023 | 1654 | 27 |
1961936 | 1961936 | 2021-11-28 | Aguas Buenas | Puerto Rico | 72007 | 1654 | |
1957975 | 1957975 | 2021-11-27 | Deer Lodge | Montana | 30023 | 1654 | 27 |
1954724 | 1954724 | 2021-11-26 | Deer Lodge | Montana | 30023 | 1654 | 27 |
1944299 | 1944299 | 2021-11-23 | Marshall | Kansas | 20117 | 1654 | 32 |
1941049 | 1941049 | 2021-11-22 | Marshall | Kansas | 20117 | 1654 | 32 |
1924560 | 1924560 | 2021-11-17 | Crawford | Indiana | 18025 | 1654 | 30 |
1917919 | 1917919 | 2021-11-15 | Clearwater | Idaho | 16035 | 1654 | 26 |
1904239 | 1904239 | 2021-11-10 | Roane | West Virginia | 54087 | 1654 | 23 |
1897393 | 1897393 | 2021-11-08 | Morris | Texas | 48343 | 1654 | 55 |
1892249 | 1892249 | 2021-11-07 | Brown | Kansas | 20013 | 1654 | 40 |
1894143 | 1894143 | 2021-11-07 | Morris | Texas | 48343 | 1654 | 55 |
1888999 | 1888999 | 2021-11-06 | Brown | Kansas | 20013 | 1654 | 40 |
1890893 | 1890893 | 2021-11-06 | Morris | Texas | 48343 | 1654 | 55 |
1885749 | 1885749 | 2021-11-05 | Brown | Kansas | 20013 | 1654 | 40 |
1887643 | 1887643 | 2021-11-05 | Morris | Texas | 48343 | 1654 | 55 |
1884393 | 1884393 | 2021-11-04 | Morris | Texas | 48343 | 1654 | 55 |
1879879 | 1879879 | 2021-11-03 | Douglas | Missouri | 29067 | 1654 | 47 |
1881144 | 1881144 | 2021-11-03 | Morris | Texas | 48343 | 1654 | 55 |
1875535 | 1875535 | 2021-11-02 | Dooly | Georgia | 13093 | 1654 | 59 |
1872444 | 1872444 | 2021-11-01 | Owyhee | Idaho | 16073 | 1654 | 39 |
1872448 | 1872448 | 2021-11-01 | Teton | Idaho | 16081 | 1654 | 5 |
1860781 | 1860781 | 2021-10-28 | Clay | North Carolina | 37043 | 1654 | 36 |
1804728 | 1804728 | 2021-10-11 | Todd | Kentucky | 21219 | 1654 | 30 |
1794049 | 1794049 | 2021-10-08 | Stone | Arkansas | 5137 | 1654 | 40 |
1793445 | 1793445 | 2021-10-07 | Runnels | Texas | 48399 | 1654 | 52 |
1781010 | 1781010 | 2021-10-04 | Fulton | Arkansas | 5049 | 1654 | 55 |
1777760 | 1777760 | 2021-10-03 | Fulton | Arkansas | 5049 | 1654 | 55 |
1774510 | 1774510 | 2021-10-02 | Fulton | Arkansas | 5049 | 1654 | 55 |
1769069 | 1769069 | 2021-09-30 | Knox | Maine | 23013 | 1654 | 10 |
1763592 | 1763592 | 2021-09-28 | Pushmataha | Oklahoma | 40127 | 1654 | 32 |
1760343 | 1760343 | 2021-09-27 | Pushmataha | Oklahoma | 40127 | 1654 | 32 |
1757095 | 1757095 | 2021-09-26 | Pushmataha | Oklahoma | 40127 | 1654 | 32 |
1753847 | 1753847 | 2021-09-25 | Pushmataha | Oklahoma | 40127 | 1654 | 32 |
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);