ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 10062 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Alabama 7
- Mississippi 5
- Arkansas 4
- Minnesota 3
- North Carolina 3
- Iowa 2
- Ohio 2
- Tennessee 2
- Connecticut 1
- Illinois 1
- Missouri 1
- New Mexico 1
- North Dakota 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418216 | 2418216 | 2022-04-18 | Russell | Alabama | 1113 | 10062 | 91 |
2414960 | 2414960 | 2022-04-17 | Russell | Alabama | 1113 | 10062 | 91 |
2411704 | 2411704 | 2022-04-16 | Russell | Alabama | 1113 | 10062 | 91 |
2408448 | 2408448 | 2022-04-15 | Russell | Alabama | 1113 | 10062 | 91 |
2331653 | 2331653 | 2022-03-22 | Isanti | Minnesota | 27059 | 10062 | 117 |
2205556 | 2205556 | 2022-02-11 | Defiance | Ohio | 39039 | 10062 | 152 |
2179506 | 2179506 | 2022-02-03 | Williams | North Dakota | 38105 | 10062 | 67 |
2160677 | 2160677 | 2022-01-28 | Jim Wells | Texas | 48249 | 10062 | 185 |
2143096 | 2143096 | 2022-01-23 | Hancock | Mississippi | 28045 | 10062 | 141 |
2139841 | 2139841 | 2022-01-22 | Hancock | Mississippi | 28045 | 10062 | 141 |
2136585 | 2136585 | 2022-01-21 | Hancock | Mississippi | 28045 | 10062 | 141 |
2130722 | 2130722 | 2022-01-19 | Crawford | Ohio | 39033 | 10062 | 175 |
1997946 | 1997946 | 2021-12-09 | Monroe | Tennessee | 47123 | 10062 | 140 |
1994695 | 1994695 | 2021-12-08 | Monroe | Tennessee | 47123 | 10062 | 140 |
1916030 | 1916030 | 2021-11-14 | Duplin | North Carolina | 37061 | 10062 | 193 |
1912780 | 1912780 | 2021-11-13 | Duplin | North Carolina | 37061 | 10062 | 193 |
1909530 | 1909530 | 2021-11-12 | Duplin | North Carolina | 37061 | 10062 | 193 |
1853749 | 1853749 | 2021-10-26 | Rice | Minnesota | 27131 | 10062 | 131 |
1714103 | 1714103 | 2021-09-13 | Lowndes | Mississippi | 28087 | 10062 | 169 |
1622007 | 1622007 | 2021-08-16 | Tolland | Connecticut | 9013 | 10062 | 188 |
1614213 | 1614213 | 2021-08-13 | Adams | Pennsylvania | 42001 | 10062 | 190 |
1536444 | 1536444 | 2021-07-20 | Oconee | South Carolina | 45073 | 10062 | 141 |
1511283 | 1511283 | 2021-07-13 | Cullman | Alabama | 1043 | 10062 | 203 |
1508036 | 1508036 | 2021-07-12 | Cullman | Alabama | 1043 | 10062 | 203 |
1492476 | 1492476 | 2021-07-07 | Vermilion | Illinois | 17183 | 10062 | 163 |
1321267 | 1321267 | 2021-05-15 | Clay | Missouri | 29047 | 10062 | 165 |
1310033 | 1310033 | 2021-05-12 | Elmore | Alabama | 1051 | 10062 | 205 |
1291987 | 1291987 | 2021-05-06 | Madison | Mississippi | 28089 | 10062 | 217 |
1252903 | 1252903 | 2021-04-24 | Carver | Minnesota | 27019 | 10062 | 45 |
1219229 | 1219229 | 2021-04-14 | Garland | Arkansas | 5051 | 10062 | 256 |
1212734 | 1212734 | 2021-04-12 | Garland | Arkansas | 5051 | 10062 | 255 |
1209486 | 1209486 | 2021-04-11 | Garland | Arkansas | 5051 | 10062 | 255 |
1206237 | 1206237 | 2021-04-10 | Garland | Arkansas | 5051 | 10062 | 255 |
1172216 | 1172216 | 2021-03-30 | Santa Fe | New Mexico | 35049 | 10062 | 142 |
828833 | 828833 | 2020-12-14 | Pennington | South Dakota | 46103 | 10062 | 115 |
804448 | 804448 | 2020-12-07 | Johnson | Iowa | 19103 | 10062 | 41 |
765553 | 765553 | 2020-11-25 | Woodbury | Iowa | 19193 | 10062 | 120 |
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);