ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
320 rows where cases = 1530 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Georgia 19
- Illinois 16
- Kentucky 16
- Oklahoma 15
- Iowa 13
- Alabama 12
- Virginia 12
- Arkansas 11
- Kansas 11
- Missouri 11
- Tennessee 11
- Indiana 10
- Minnesota 10
- Montana 9
- Louisiana 8
- Puerto Rico 8
- Mississippi 7
- Nebraska 7
- Colorado 6
- North Carolina 6
- Vermont 6
- California 5
- South Dakota 5
- West Virginia 5
- Wisconsin 5
- Florida 4
- Michigan 4
- New York 4
- Ohio 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495287 | 2495287 | 2022-05-11 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2492029 | 2492029 | 2022-05-10 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2488771 | 2488771 | 2022-05-09 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2483894 | 2483894 | 2022-05-08 | Calhoun | Illinois | 17013 | 1530 | 8 |
2484669 | 2484669 | 2022-05-08 | Norman | Minnesota | 27107 | 1530 | 13 |
2485514 | 2485514 | 2022-05-08 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2480636 | 2480636 | 2022-05-07 | Calhoun | Illinois | 17013 | 1530 | 8 |
2481411 | 2481411 | 2022-05-07 | Norman | Minnesota | 27107 | 1530 | 13 |
2482256 | 2482256 | 2022-05-07 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2477378 | 2477378 | 2022-05-06 | Calhoun | Illinois | 17013 | 1530 | 8 |
2478153 | 2478153 | 2022-05-06 | Norman | Minnesota | 27107 | 1530 | 13 |
2478998 | 2478998 | 2022-05-06 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2475740 | 2475740 | 2022-05-05 | Tillman | Oklahoma | 40141 | 1530 | 35 |
2476176 | 2476176 | 2022-05-05 | Carson | Texas | 48065 | 1530 | 36 |
2472919 | 2472919 | 2022-05-04 | Carson | Texas | 48065 | 1530 | 36 |
2469663 | 2469663 | 2022-05-03 | Carson | Texas | 48065 | 1530 | 36 |
2466407 | 2466407 | 2022-05-02 | Carson | Texas | 48065 | 1530 | 36 |
2463152 | 2463152 | 2022-05-01 | Carson | Texas | 48065 | 1530 | 36 |
2459896 | 2459896 | 2022-04-30 | Carson | Texas | 48065 | 1530 | 36 |
2456640 | 2456640 | 2022-04-29 | Carson | Texas | 48065 | 1530 | 36 |
2453384 | 2453384 | 2022-04-28 | Carson | Texas | 48065 | 1530 | 36 |
2416569 | 2416569 | 2022-04-17 | Stillwater | Montana | 30095 | 1530 | 30 |
2413313 | 2413313 | 2022-04-16 | Stillwater | Montana | 30095 | 1530 | 30 |
2410057 | 2410057 | 2022-04-15 | Stillwater | Montana | 30095 | 1530 | 30 |
2406801 | 2406801 | 2022-04-14 | Stillwater | Montana | 30095 | 1530 | 30 |
2403545 | 2403545 | 2022-04-13 | Stillwater | Montana | 30095 | 1530 | 30 |
2373121 | 2373121 | 2022-04-04 | Twiggs | Georgia | 13289 | 1530 | 69 |
2353323 | 2353323 | 2022-03-29 | Clear Creek | Colorado | 8019 | 1530 | 12 |
2308057 | 2308057 | 2022-03-15 | Twiggs | Georgia | 13289 | 1530 | 68 |
2302743 | 2302743 | 2022-03-13 | Keith | Nebraska | 31101 | 1530 | 17 |
2299491 | 2299491 | 2022-03-12 | Keith | Nebraska | 31101 | 1530 | 17 |
2296239 | 2296239 | 2022-03-11 | Keith | Nebraska | 31101 | 1530 | 17 |
2292987 | 2292987 | 2022-03-10 | Keith | Nebraska | 31101 | 1530 | 17 |
2289735 | 2289735 | 2022-03-09 | Keith | Nebraska | 31101 | 1530 | 17 |
2283231 | 2283231 | 2022-03-07 | Keith | Nebraska | 31101 | 1530 | 17 |
2222982 | 2222982 | 2022-02-16 | Weston | Wyoming | 56045 | 1530 | 17 |
2195722 | 2195722 | 2022-02-08 | Bottineau | North Dakota | 38009 | 1530 | 24 |
2169217 | 2169217 | 2022-01-31 | Daviess | Missouri | 29061 | 1530 | 24 |
2160594 | 2160594 | 2022-01-28 | Coleman | Texas | 48083 | 1530 | 64 |
2149741 | 2149741 | 2022-01-25 | Ozark | Missouri | 29153 | 1530 | 48 |
2137970 | 2137970 | 2022-01-21 | Refugio | Texas | 48391 | 1530 | 31 |
2134618 | 2134618 | 2022-01-20 | Hansford | Texas | 48195 | 1530 | 27 |
2109676 | 2109676 | 2022-01-13 | Wilcox | Georgia | 13315 | 1530 | 61 |
2084960 | 2084960 | 2022-01-05 | Sierra | New Mexico | 35051 | 1530 | 65 |
2079560 | 2079560 | 2022-01-03 | Buena Vista city | Virginia | 51530 | 1530 | 34 |
2079859 | 2079859 | 2022-01-03 | Sublette | Wyoming | 56035 | 1530 | 23 |
2028411 | 2028411 | 2021-12-19 | Wilkinson | Georgia | 13319 | 1530 | 47 |
2025160 | 2025160 | 2021-12-18 | Wilkinson | Georgia | 13319 | 1530 | 47 |
2021909 | 2021909 | 2021-12-17 | Wilkinson | Georgia | 13319 | 1530 | 47 |
2024205 | 2024205 | 2021-12-17 | Swisher | Texas | 48437 | 1530 | 25 |
2024471 | 2024471 | 2021-12-17 | Gilmer | West Virginia | 54021 | 1530 | 14 |
2017697 | 2017697 | 2021-12-15 | Somervell | Texas | 48425 | 1530 | 25 |
1966095 | 1966095 | 2021-11-29 | Platte | Wyoming | 56031 | 1530 | 26 |
1949566 | 1949566 | 2021-11-24 | Floyd | Virginia | 51063 | 1530 | 31 |
1942983 | 1942983 | 2021-11-22 | Grand | Utah | 49019 | 1530 | 5 |
1927611 | 1927611 | 2021-11-18 | Stewart | Georgia | 13259 | 1530 | 28 |
1924361 | 1924361 | 2021-11-17 | Stewart | Georgia | 13259 | 1530 | 28 |
1894888 | 1894888 | 2021-11-08 | Park | Colorado | 8093 | 1530 | 10 |
1882305 | 1882305 | 2021-11-04 | Benton | Indiana | 18007 | 1530 | 17 |
1874392 | 1874392 | 2021-11-01 | Clay | Tennessee | 47027 | 1530 | 37 |
1871143 | 1871143 | 2021-10-31 | Clay | Tennessee | 47027 | 1530 | 37 |
1867894 | 1867894 | 2021-10-30 | Clay | Tennessee | 47027 | 1530 | 37 |
1864645 | 1864645 | 2021-10-29 | Clay | Tennessee | 47027 | 1530 | 37 |
1853355 | 1853355 | 2021-10-26 | Wilson | Kansas | 20205 | 1530 | 33 |
1850106 | 1850106 | 2021-10-25 | Wilson | Kansas | 20205 | 1530 | 33 |
1840943 | 1840943 | 2021-10-22 | Ralls | Missouri | 29173 | 1530 | 14 |
1833891 | 1833891 | 2021-10-20 | Edmonson | Kentucky | 21061 | 1530 | 29 |
1835376 | 1835376 | 2021-10-20 | Roberts | South Dakota | 46109 | 1530 | 43 |
1810695 | 1810695 | 2021-10-13 | Franklin | Idaho | 16041 | 1530 | 21 |
1809864 | 1809864 | 2021-10-12 | Lexington city | Virginia | 51678 | 1530 | 34 |
1806470 | 1806470 | 2021-10-11 | Trinity | Texas | 48455 | 1530 | 56 |
1801128 | 1801128 | 2021-10-10 | Newton | Indiana | 18111 | 1530 | 50 |
1803220 | 1803220 | 2021-10-10 | Trinity | Texas | 48455 | 1530 | 56 |
1797879 | 1797879 | 2021-10-09 | Newton | Indiana | 18111 | 1530 | 50 |
1799971 | 1799971 | 2021-10-09 | Trinity | Texas | 48455 | 1530 | 55 |
1794630 | 1794630 | 2021-10-08 | Newton | Indiana | 18111 | 1530 | 50 |
1793283 | 1793283 | 2021-10-07 | Childress | Texas | 48075 | 1530 | 20 |
1782412 | 1782412 | 2021-10-04 | Grundy | Missouri | 29079 | 1530 | 47 |
1763605 | 1763605 | 2021-09-28 | Woods | Oklahoma | 40151 | 1530 | 20 |
1760356 | 1760356 | 2021-09-27 | Woods | Oklahoma | 40151 | 1530 | 20 |
1757108 | 1757108 | 2021-09-26 | Woods | Oklahoma | 40151 | 1530 | 20 |
1753860 | 1753860 | 2021-09-25 | Woods | Oklahoma | 40151 | 1530 | 20 |
1750612 | 1750612 | 2021-09-24 | Woods | Oklahoma | 40151 | 1530 | 20 |
1747362 | 1747362 | 2021-09-23 | Woods | Oklahoma | 40151 | 1530 | 20 |
1744113 | 1744113 | 2021-09-22 | Woods | Oklahoma | 40151 | 1530 | 20 |
1733356 | 1733356 | 2021-09-19 | Kent | Maryland | 24029 | 1530 | 52 |
1719206 | 1719206 | 2021-09-15 | Wilcox | Alabama | 1131 | 1530 | 33 |
1715799 | 1715799 | 2021-09-13 | Ashland | Wisconsin | 55003 | 1530 | 16 |
1686328 | 1686328 | 2021-09-04 | Orleans | Vermont | 50019 | 1530 | 13 |
1678179 | 1678179 | 2021-09-02 | Gogebic | Michigan | 26053 | 1530 | 53 |
1674931 | 1674931 | 2021-09-01 | Gogebic | Michigan | 26053 | 1530 | 53 |
1667696 | 1667696 | 2021-08-30 | Towns | Georgia | 13281 | 1530 | 65 |
1648740 | 1648740 | 2021-08-24 | Knott | Kentucky | 21119 | 1530 | 25 |
1645790 | 1645790 | 2021-08-23 | Kanabec | Minnesota | 27065 | 1530 | 29 |
1634724 | 1634724 | 2021-08-20 | Lowndes | Alabama | 1085 | 1530 | 55 |
1635873 | 1635873 | 2021-08-20 | Hancock | Maine | 23009 | 1530 | 41 |
1631476 | 1631476 | 2021-08-19 | Lowndes | Alabama | 1085 | 1530 | 55 |
1631514 | 1631514 | 2021-08-19 | Kusilvak Census Area | Alaska | 2158 | 1530 | 4 |
1629655 | 1629655 | 2021-08-18 | Perry | Mississippi | 28111 | 1530 | 41 |
1607416 | 1607416 | 2021-08-11 | Mitchell | North Carolina | 37121 | 1530 | 16 |
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);