ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 8180 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Illinois 5
- Kentucky 4
- Guam 3
- Indiana 3
- Ohio 3
- Arizona 2
- Arkansas 2
- Michigan 2
- New York 2
- North Carolina 2
- Alabama 1
- Minnesota 1
- New Mexico 1
- North Dakota 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
- Vermont 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378151 | 2378151 | 2022-04-05 | McKean | Pennsylvania | 42083 | 8180 | 138 |
2224887 | 2224887 | 2022-02-17 | Wyoming | New York | 36121 | 8180 | 81 |
2213837 | 2213837 | 2022-02-14 | Bureau | Illinois | 17011 | 8180 | 137 |
2214307 | 2214307 | 2022-02-14 | Marshall | Kentucky | 21157 | 8180 | 92 |
2216146 | 2216146 | 2022-02-14 | Franklin | Vermont | 50011 | 8180 | 60 |
2092756 | 2092756 | 2022-01-07 | Ohio | West Virginia | 54069 | 8180 | 131 |
2028491 | 2028491 | 2021-12-19 | Franklin | Illinois | 17055 | 8180 | 140 |
2025240 | 2025240 | 2021-12-18 | Franklin | Illinois | 17055 | 8180 | 140 |
2021989 | 2021989 | 2021-12-17 | Franklin | Illinois | 17055 | 8180 | 140 |
1974540 | 1974540 | 2021-12-02 | Edgecombe | North Carolina | 37065 | 8180 | 127 |
1958217 | 1958217 | 2021-11-27 | Herkimer | New York | 36043 | 8180 | 143 |
1896646 | 1896646 | 2021-11-08 | Stark | North Dakota | 38089 | 8180 | 70 |
1827081 | 1827081 | 2021-10-18 | Dearborn | Indiana | 18029 | 8180 | 97 |
1810274 | 1810274 | 2021-10-13 | Mississippi | Arkansas | 5093 | 8180 | 137 |
1747203 | 1747203 | 2021-09-23 | Belmont | Ohio | 39013 | 8180 | 187 |
1730953 | 1730953 | 2021-09-18 | Ashtabula | Ohio | 39007 | 8180 | 185 |
1682291 | 1682291 | 2021-09-03 | Ross | Ohio | 39141 | 8180 | 169 |
1619538 | 1619538 | 2021-08-15 | Oldham | Kentucky | 21185 | 8180 | 85 |
1616290 | 1616290 | 2021-08-14 | Oldham | Kentucky | 21185 | 8180 | 85 |
1613041 | 1613041 | 2021-08-13 | Oldham | Kentucky | 21185 | 8180 | 85 |
1556830 | 1556830 | 2021-07-27 | Santa Cruz | Arizona | 4023 | 8180 | 181 |
1553583 | 1553583 | 2021-07-26 | Santa Cruz | Arizona | 4023 | 8180 | 181 |
1414589 | 1414589 | 2021-06-13 | Bartholomew | Indiana | 18005 | 8180 | 162 |
1411344 | 1411344 | 2021-06-12 | Bartholomew | Indiana | 18005 | 8180 | 162 |
1401086 | 1401086 | 2021-06-09 | White | Arkansas | 5145 | 8180 | 121 |
1398957 | 1398957 | 2021-06-08 | Montcalm | Michigan | 26117 | 8180 | 118 |
1330826 | 1330826 | 2021-05-18 | Clay | Minnesota | 27027 | 8180 | 92 |
1124228 | 1124228 | 2021-03-15 | Hamblen | Tennessee | 47063 | 8180 | 169 |
987171 | 987171 | 2021-02-01 | Lea | New Mexico | 35025 | 8180 | 121 |
982136 | 982136 | 2021-01-31 | Lauderdale | Alabama | 1077 | 8180 | 156 |
902288 | 902288 | 2021-01-06 | Unknown | Michigan | 8180 | 43 | |
856083 | 856083 | 2020-12-23 | Unknown | Guam | 8180 | 121 | |
852838 | 852838 | 2020-12-22 | Unknown | Guam | 8180 | 121 | |
855037 | 855037 | 2020-12-22 | Kaufman | Texas | 48257 | 8180 | 108 |
849593 | 849593 | 2020-12-21 | Unknown | Guam | 8180 | 121 | |
716595 | 716595 | 2020-11-10 | Champaign | Illinois | 17019 | 8180 | 37 |
614115 | 614115 | 2020-10-09 | Durham | North Carolina | 37063 | 8180 | 98 |
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);