ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 9030 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Tennessee 7
- Kentucky 4
- Minnesota 4
- Montana 3
- North Carolina 3
- Pennsylvania 3
- Alabama 2
- New York 2
- Ohio 2
- Florida 1
- Guam 1
- Maryland 1
- New Mexico 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468337 | 2468337 | 2022-05-03 | Carlton | Minnesota | 27017 | 9030 | 96 |
2436744 | 2436744 | 2022-04-23 | Jefferson | Pennsylvania | 42065 | 9030 | 233 |
2378127 | 2378127 | 2022-04-05 | Clinton | Pennsylvania | 42035 | 9030 | 124 |
2378449 | 2378449 | 2022-04-05 | Scott | Tennessee | 47151 | 9030 | 115 |
2375195 | 2375195 | 2022-04-04 | Scott | Tennessee | 47151 | 9030 | 115 |
2371943 | 2371943 | 2022-04-03 | Scott | Tennessee | 47151 | 9030 | 115 |
2368690 | 2368690 | 2022-04-02 | Scott | Tennessee | 47151 | 9030 | 115 |
2365437 | 2365437 | 2022-04-01 | Scott | Tennessee | 47151 | 9030 | 115 |
2362184 | 2362184 | 2022-03-31 | Scott | Tennessee | 47151 | 9030 | 115 |
2358930 | 2358930 | 2022-03-30 | Scott | Tennessee | 47151 | 9030 | 115 |
2312128 | 2312128 | 2022-03-16 | Freeborn | Minnesota | 27047 | 9030 | 72 |
2254105 | 2254105 | 2022-02-26 | Franklin | New York | 36033 | 9030 | 44 |
2032119 | 2032119 | 2021-12-20 | Barren | Kentucky | 21009 | 9030 | 175 |
1969375 | 1969375 | 2021-12-01 | Dale | Alabama | 1045 | 9030 | 192 |
1775579 | 1775579 | 2021-10-02 | Allegany | Maryland | 24001 | 9030 | 234 |
1767891 | 1767891 | 2021-09-30 | Coffee | Alabama | 1031 | 9030 | 181 |
1630311 | 1630311 | 2021-08-18 | Pickaway | Ohio | 39129 | 9030 | 123 |
1551247 | 1551247 | 2021-07-25 | Campbell | Kentucky | 21037 | 9030 | 84 |
1548000 | 1548000 | 2021-07-24 | Campbell | Kentucky | 21037 | 9030 | 84 |
1544753 | 1544753 | 2021-07-23 | Campbell | Kentucky | 21037 | 9030 | 84 |
1432186 | 1432186 | 2021-06-18 | Columbiana | Ohio | 39029 | 9030 | 230 |
1310558 | 1310558 | 2021-05-12 | Unknown | Guam | 9030 | 140 | |
1271037 | 1271037 | 2021-04-29 | Laramie | Wyoming | 56021 | 9030 | 113 |
1266382 | 1266382 | 2021-04-28 | Lea | New Mexico | 35025 | 9030 | 164 |
1175625 | 1175625 | 2021-03-31 | Wilson | North Carolina | 37195 | 9030 | 158 |
1120382 | 1120382 | 2021-03-14 | Lincoln | North Carolina | 37109 | 9030 | 75 |
1117135 | 1117135 | 2021-03-13 | Lincoln | North Carolina | 37109 | 9030 | 75 |
1020109 | 1020109 | 2021-02-11 | Monroe | Pennsylvania | 42089 | 9030 | 253 |
873138 | 873138 | 2020-12-28 | Olmsted | Minnesota | 27109 | 9030 | 57 |
866896 | 866896 | 2020-12-26 | Gallatin | Montana | 30031 | 9030 | 37 |
863651 | 863651 | 2020-12-25 | Gallatin | Montana | 30031 | 9030 | 37 |
860406 | 860406 | 2020-12-24 | Gallatin | Montana | 30031 | 9030 | 37 |
639475 | 639475 | 2020-10-17 | Dakota | Minnesota | 27037 | 9030 | 133 |
344599 | 344599 | 2020-07-18 | Polk | Florida | 12105 | 9030 | 174 |
114187 | 114187 | 2020-05-04 | Orange | New York | 36071 | 9030 | 254 |
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);