ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 13986 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Michigan 4
- Mississippi 3
- Georgia 2
- Illinois 2
- New Mexico 2
- Alabama 1
- Colorado 1
- Florida 1
- Minnesota 1
- Missouri 1
- North Carolina 1
- Oregon 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2357653 | 2357653 | 2022-03-30 | Benton | Minnesota | 27009 | 13986 | 174 |
2293187 | 2293187 | 2022-03-10 | Carteret | North Carolina | 37031 | 13986 | 85 |
2211229 | 2211229 | 2022-02-13 | Barry | Michigan | 26015 | 13986 | 155 |
2207976 | 2207976 | 2022-02-12 | Barry | Michigan | 26015 | 13986 | 155 |
2204723 | 2204723 | 2022-02-11 | Barry | Michigan | 26015 | 13986 | 155 |
2172412 | 2172412 | 2022-02-01 | Pearl River | Mississippi | 28109 | 13986 | 250 |
1983871 | 1983871 | 2021-12-05 | Christian | Missouri | 29043 | 13986 | 202 |
1905794 | 1905794 | 2021-11-11 | Jones | Mississippi | 28067 | 13986 | 244 |
1906186 | 1906186 | 2021-11-11 | Santa Fe | New Mexico | 35049 | 13986 | 175 |
1902545 | 1902545 | 2021-11-10 | Jones | Mississippi | 28067 | 13986 | 244 |
1902937 | 1902937 | 2021-11-10 | Santa Fe | New Mexico | 35049 | 13986 | 175 |
1722430 | 1722430 | 2021-09-16 | Limestone | Alabama | 1083 | 13986 | 179 |
1697055 | 1697055 | 2021-09-08 | LaSalle | Illinois | 17099 | 13986 | 322 |
1696324 | 1696324 | 2021-09-07 | Dodge | Wisconsin | 55027 | 13986 | 204 |
1235616 | 1235616 | 2021-04-19 | Mesa | Colorado | 8077 | 13986 | 209 |
1153120 | 1153120 | 2021-03-24 | Clackamas | Oregon | 41005 | 13986 | 200 |
1135347 | 1135347 | 2021-03-19 | Tazewell | Illinois | 17179 | 13986 | 276 |
1021449 | 1021449 | 2021-02-12 | Bibb | Georgia | 13021 | 13986 | 352 |
967152 | 967152 | 2021-01-26 | Kalamazoo | Michigan | 26077 | 13986 | 304 |
807307 | 807307 | 2020-12-08 | Hall | Georgia | 13139 | 13986 | 208 |
722859 | 722859 | 2020-11-12 | Volusia | Florida | 12127 | 13986 | 333 |
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);