ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 11049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Ohio 7
- Oklahoma 7
- Texas 6
- Illinois 3
- Michigan 2
- New York 2
- North Carolina 2
- Virginia 2
- Washington 2
- Arkansas 1
- California 1
- Florida 1
- Montana 1
- Oregon 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417740 | 2417740 | 2022-04-17 | San Patricio | Texas | 48409 | 11049 | 339 |
2414484 | 2414484 | 2022-04-16 | San Patricio | Texas | 48409 | 11049 | 339 |
2411228 | 2411228 | 2022-04-15 | San Patricio | Texas | 48409 | 11049 | 339 |
2407972 | 2407972 | 2022-04-14 | San Patricio | Texas | 48409 | 11049 | 339 |
2404716 | 2404716 | 2022-04-13 | San Patricio | Texas | 48409 | 11049 | 339 |
2405020 | 2405020 | 2022-04-13 | Ohio | West Virginia | 54069 | 11049 | 166 |
2381236 | 2381236 | 2022-04-06 | Shelby | Ohio | 39149 | 11049 | 186 |
2381271 | 2381271 | 2022-04-06 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2377981 | 2377981 | 2022-04-05 | Shelby | Ohio | 39149 | 11049 | 186 |
2378016 | 2378016 | 2022-04-05 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2378913 | 2378913 | 2022-04-05 | Douglas | Washington | 53017 | 11049 | 69 |
2374727 | 2374727 | 2022-04-04 | Shelby | Ohio | 39149 | 11049 | 186 |
2374762 | 2374762 | 2022-04-04 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2375659 | 2375659 | 2022-04-04 | Douglas | Washington | 53017 | 11049 | 69 |
2371475 | 2371475 | 2022-04-03 | Shelby | Ohio | 39149 | 11049 | 186 |
2371510 | 2371510 | 2022-04-03 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2368222 | 2368222 | 2022-04-02 | Shelby | Ohio | 39149 | 11049 | 186 |
2368257 | 2368257 | 2022-04-02 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2364969 | 2364969 | 2022-04-01 | Shelby | Ohio | 39149 | 11049 | 186 |
2365004 | 2365004 | 2022-04-01 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2361716 | 2361716 | 2022-03-31 | Shelby | Ohio | 39149 | 11049 | 186 |
2361751 | 2361751 | 2022-03-31 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2307234 | 2307234 | 2022-03-14 | Danville city | Virginia | 51590 | 11049 | 271 |
2286019 | 2286019 | 2022-03-08 | Cass | Michigan | 26027 | 11049 | 137 |
2282767 | 2282767 | 2022-03-07 | Cass | Michigan | 26027 | 11049 | 137 |
2160726 | 2160726 | 2022-01-28 | Nacogdoches | Texas | 48347 | 11049 | 243 |
2132116 | 2132116 | 2022-01-20 | San Benito | California | 6069 | 11049 | 88 |
1900893 | 1900893 | 2021-11-09 | Suffolk city | Virginia | 51800 | 11049 | 241 |
1860493 | 1860493 | 2021-10-28 | Lewis and Clark | Montana | 30049 | 11049 | 111 |
1505423 | 1505423 | 2021-07-11 | Macon | Illinois | 17115 | 11049 | 222 |
1502177 | 1502177 | 2021-07-10 | Macon | Illinois | 17115 | 11049 | 222 |
1498931 | 1498931 | 2021-07-09 | Macon | Illinois | 17115 | 11049 | 222 |
1338222 | 1338222 | 2021-05-20 | Jackson | Oregon | 41029 | 11049 | 141 |
1308645 | 1308645 | 2021-05-11 | Rensselaer | New York | 36083 | 11049 | 140 |
1221021 | 1221021 | 2021-04-14 | Cleveland | North Carolina | 37045 | 11049 | 222 |
1131774 | 1131774 | 2021-03-18 | Martin | Florida | 12085 | 11049 | 299 |
995216 | 995216 | 2021-02-04 | Faulkner | Arkansas | 5045 | 11049 | 139 |
899625 | 899625 | 2021-01-05 | Alamance | North Carolina | 37001 | 11049 | 124 |
381361 | 381361 | 2020-07-29 | Orange | New York | 36071 | 11049 | 404 |
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);