ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 8365 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Oklahoma 7
- Minnesota 4
- Ohio 4
- North Carolina 3
- Pennsylvania 3
- Texas 3
- Indiana 2
- Louisiana 2
- Tennessee 2
- Georgia 1
- Massachusetts 1
- Missouri 1
- Montana 1
- New Mexico 1
- New York 1
- Oregon 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2312754 | 2312754 | 2022-03-16 | Pasquotank | North Carolina | 37139 | 8365 | 111 |
2283806 | 2283806 | 2022-03-07 | Greene | Pennsylvania | 42059 | 8365 | 100 |
2228953 | 2228953 | 2022-02-18 | Grimes | Texas | 48185 | 8365 | 116 |
2134130 | 2134130 | 2022-01-20 | Coos | Oregon | 41011 | 8365 | 128 |
2097502 | 2097502 | 2022-01-09 | Mower | Minnesota | 27099 | 8365 | 58 |
2094250 | 2094250 | 2022-01-08 | Mower | Minnesota | 27099 | 8365 | 58 |
2090998 | 2090998 | 2022-01-07 | Mower | Minnesota | 27099 | 8365 | 58 |
2063080 | 2063080 | 2021-12-29 | Hale | Texas | 48189 | 8365 | 203 |
1990183 | 1990183 | 2021-12-07 | Beltrami | Minnesota | 27007 | 8365 | 101 |
1974683 | 1974683 | 2021-12-02 | Darke | Ohio | 39037 | 8365 | 180 |
1917871 | 1917871 | 2021-11-15 | Tift | Georgia | 13277 | 8365 | 183 |
1879071 | 1879071 | 2021-11-03 | Dubois | Indiana | 18037 | 8365 | 135 |
1854581 | 1854581 | 2021-10-26 | Washington | Oklahoma | 40147 | 8365 | 193 |
1851332 | 1851332 | 2021-10-25 | Washington | Oklahoma | 40147 | 8365 | 193 |
1848082 | 1848082 | 2021-10-24 | Washington | Oklahoma | 40147 | 8365 | 193 |
1844832 | 1844832 | 2021-10-23 | Washington | Oklahoma | 40147 | 8365 | 193 |
1841582 | 1841582 | 2021-10-22 | Washington | Oklahoma | 40147 | 8365 | 193 |
1837279 | 1837279 | 2021-10-21 | St. Martin | Louisiana | 22099 | 8365 | 160 |
1838333 | 1838333 | 2021-10-21 | Washington | Oklahoma | 40147 | 8365 | 193 |
1835084 | 1835084 | 2021-10-20 | Washington | Oklahoma | 40147 | 8365 | 193 |
1805486 | 1805486 | 2021-10-11 | Jefferson | New York | 36045 | 8365 | 73 |
1769965 | 1769965 | 2021-09-30 | Geauga | Ohio | 39055 | 8365 | 157 |
1662972 | 1662972 | 2021-08-28 | Lawrence | Pennsylvania | 42073 | 8365 | 229 |
1585266 | 1585266 | 2021-08-04 | Greene | Tennessee | 47059 | 8365 | 160 |
1580164 | 1580164 | 2021-08-03 | Bartholomew | Indiana | 18005 | 8365 | 162 |
1264112 | 1264112 | 2021-04-27 | Orange | Texas | 48361 | 8365 | 146 |
1227700 | 1227700 | 2021-04-16 | Marion | Ohio | 39101 | 8365 | 135 |
1169096 | 1169096 | 2021-03-29 | Moore | North Carolina | 37125 | 8365 | 181 |
1149264 | 1149264 | 2021-03-23 | Cascade | Montana | 30013 | 8365 | 150 |
1133530 | 1133530 | 2021-03-18 | Muskingum | Ohio | 39119 | 8365 | 120 |
1130468 | 1130468 | 2021-03-17 | Mercer | Pennsylvania | 42085 | 8365 | 244 |
1049992 | 1049992 | 2021-02-20 | Hampton city | Virginia | 51650 | 8365 | 90 |
1026241 | 1026241 | 2021-02-13 | Henderson | North Carolina | 37089 | 8365 | 127 |
1019629 | 1019629 | 2021-02-11 | Lea | New Mexico | 35025 | 8365 | 132 |
864618 | 864618 | 2020-12-25 | Putnam | Tennessee | 47141 | 8365 | 114 |
607241 | 607241 | 2020-10-07 | Jackson | Missouri | 29095 | 8365 | 107 |
496754 | 496754 | 2020-09-03 | Lafayette | Louisiana | 22055 | 8365 | 112 |
313579 | 313579 | 2020-07-08 | Bristol | Massachusetts | 25005 | 8365 | 592 |
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);