ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 7078 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Alabama 8
- Florida 8
- Indiana 5
- Kansas 5
- Pennsylvania 4
- Texas 4
- Virgin Islands 4
- Arkansas 3
- Georgia 3
- Kentucky 3
- Minnesota 3
- North Carolina 3
- Michigan 2
- Mississippi 2
- Missouri 2
- Colorado 1
- Louisiana 1
- Maryland 1
- Montana 1
- Nevada 1
- North Dakota 1
- South Dakota 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484626 | 2484626 | 2022-05-08 | Cass | Minnesota | 27021 | 7078 | 81 |
2481368 | 2481368 | 2022-05-07 | Cass | Minnesota | 27021 | 7078 | 81 |
2478110 | 2478110 | 2022-05-06 | Cass | Minnesota | 27021 | 7078 | 81 |
2323803 | 2323803 | 2022-03-20 | Clarke | Alabama | 1025 | 7078 | 98 |
2320549 | 2320549 | 2022-03-19 | Clarke | Alabama | 1025 | 7078 | 98 |
2317295 | 2317295 | 2022-03-18 | Clarke | Alabama | 1025 | 7078 | 98 |
2314042 | 2314042 | 2022-03-17 | Clarke | Alabama | 1025 | 7078 | 98 |
2310789 | 2310789 | 2022-03-16 | Clarke | Alabama | 1025 | 7078 | 98 |
2307702 | 2307702 | 2022-03-15 | St. Francis | Arkansas | 5123 | 7078 | 91 |
2304801 | 2304801 | 2022-03-14 | Toombs | Georgia | 13279 | 7078 | 194 |
2284438 | 2284438 | 2022-03-07 | St. Thomas | Virgin Islands | 78030 | 7078 | 59 |
2281186 | 2281186 | 2022-03-06 | St. Thomas | Virgin Islands | 78030 | 7078 | 59 |
2277933 | 2277933 | 2022-03-05 | St. Thomas | Virgin Islands | 78030 | 7078 | 59 |
2274042 | 2274042 | 2022-03-04 | Elk | Pennsylvania | 42047 | 7078 | 96 |
2274680 | 2274680 | 2022-03-04 | St. Thomas | Virgin Islands | 78030 | 7078 | 59 |
2233658 | 2233658 | 2022-02-20 | Ellis | Kansas | 20051 | 7078 | 79 |
2230407 | 2230407 | 2022-02-19 | Ellis | Kansas | 20051 | 7078 | 79 |
2227156 | 2227156 | 2022-02-18 | Ellis | Kansas | 20051 | 7078 | 79 |
2224418 | 2224418 | 2022-02-17 | George | Mississippi | 28039 | 7078 | 82 |
2211946 | 2211946 | 2022-02-13 | Montgomery | North Carolina | 37123 | 7078 | 122 |
2208693 | 2208693 | 2022-02-12 | Montgomery | North Carolina | 37123 | 7078 | 122 |
2205440 | 2205440 | 2022-02-11 | Montgomery | North Carolina | 37123 | 7078 | 122 |
2152971 | 2152971 | 2022-01-26 | Lawrence | Missouri | 29109 | 7078 | 143 |
2153185 | 2153185 | 2022-01-26 | Douglas | Nevada | 32005 | 7078 | 78 |
2133457 | 2133457 | 2022-01-20 | Marion | Missouri | 29127 | 7078 | 110 |
2004965 | 2004965 | 2021-12-11 | Fayette | West Virginia | 54019 | 7078 | 141 |
1991811 | 1991811 | 2021-12-07 | Culpeper | Virginia | 51047 | 7078 | 92 |
1975862 | 1975862 | 2021-12-03 | Chilton | Alabama | 1021 | 7078 | 170 |
1959656 | 1959656 | 2021-11-28 | Russell | Alabama | 1113 | 7078 | 65 |
1910424 | 1910424 | 2021-11-12 | San Patricio | Texas | 48409 | 7078 | 294 |
1907175 | 1907175 | 2021-11-11 | San Patricio | Texas | 48409 | 7078 | 294 |
1903926 | 1903926 | 2021-11-10 | San Patricio | Texas | 48409 | 7078 | 294 |
1900676 | 1900676 | 2021-11-09 | San Patricio | Texas | 48409 | 7078 | 294 |
1873002 | 1873002 | 2021-11-01 | Lincoln | Louisiana | 22061 | 7078 | 115 |
1814428 | 1814428 | 2021-10-14 | Knox | Kentucky | 21121 | 7078 | 52 |
1814620 | 1814620 | 2021-10-14 | Branch | Michigan | 26023 | 7078 | 134 |
1811372 | 1811372 | 2021-10-13 | Branch | Michigan | 26023 | 7078 | 134 |
1792089 | 1792089 | 2021-10-07 | Oktibbeha | Mississippi | 28105 | 7078 | 126 |
1786396 | 1786396 | 2021-10-05 | Bradford | Pennsylvania | 42015 | 7078 | 108 |
1778549 | 1778549 | 2021-10-03 | Finney | Kansas | 20055 | 7078 | 79 |
1775299 | 1775299 | 2021-10-02 | Finney | Kansas | 20055 | 7078 | 79 |
1745504 | 1745504 | 2021-09-23 | Okeechobee | Florida | 12093 | 7078 | 98 |
1742255 | 1742255 | 2021-09-22 | Okeechobee | Florida | 12093 | 7078 | 98 |
1739006 | 1739006 | 2021-09-21 | Okeechobee | Florida | 12093 | 7078 | 98 |
1735757 | 1735757 | 2021-09-20 | Okeechobee | Florida | 12093 | 7078 | 98 |
1736494 | 1736494 | 2021-09-20 | Scott | Kentucky | 21209 | 7078 | 40 |
1732507 | 1732507 | 2021-09-19 | Okeechobee | Florida | 12093 | 7078 | 98 |
1729257 | 1729257 | 2021-09-18 | Okeechobee | Florida | 12093 | 7078 | 98 |
1726007 | 1726007 | 2021-09-17 | Okeechobee | Florida | 12093 | 7078 | 97 |
1608716 | 1608716 | 2021-08-12 | Coffee | Alabama | 1031 | 7078 | 135 |
1528699 | 1528699 | 2021-07-18 | Allegany | Maryland | 24001 | 7078 | 212 |
1516144 | 1516144 | 2021-07-14 | Lewis and Clark | Montana | 30049 | 7078 | 92 |
1505477 | 1505477 | 2021-07-11 | Boone | Indiana | 18011 | 7078 | 109 |
1502231 | 1502231 | 2021-07-10 | Boone | Indiana | 18011 | 7078 | 109 |
1498985 | 1498985 | 2021-07-09 | Boone | Indiana | 18011 | 7078 | 109 |
1450611 | 1450611 | 2021-06-24 | Christian | Kentucky | 21047 | 7078 | 107 |
1306888 | 1306888 | 2021-05-11 | Crawford | Arkansas | 5033 | 7078 | 119 |
1240879 | 1240879 | 2021-04-20 | Lawrence | Pennsylvania | 42073 | 7078 | 200 |
1184094 | 1184094 | 2021-04-03 | Grant | Indiana | 18053 | 7078 | 173 |
1038001 | 1038001 | 2021-02-17 | Floyd | Indiana | 18043 | 7078 | 166 |
916447 | 916447 | 2021-01-10 | Lincoln | South Dakota | 46083 | 7078 | 68 |
880534 | 880534 | 2020-12-30 | Fayette | Pennsylvania | 42051 | 7078 | 104 |
865400 | 865400 | 2020-12-26 | Faulkner | Arkansas | 5045 | 7078 | 84 |
756980 | 756980 | 2020-11-22 | Ward | North Dakota | 38101 | 7078 | 114 |
690504 | 690504 | 2020-11-02 | Henry | Georgia | 13151 | 7078 | 114 |
573704 | 573704 | 2020-09-27 | Clayton | Georgia | 13063 | 7078 | 162 |
453843 | 453843 | 2020-08-21 | Adams | Colorado | 8001 | 7078 | 189 |
357392 | 357392 | 2020-07-22 | Manatee | Florida | 12081 | 7078 | 149 |
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);