ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 10015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Alabama 4
- California 3
- Arkansas 2
- Kansas 2
- Michigan 2
- New Jersey 2
- New York 2
- North Carolina 2
- Oklahoma 2
- Oregon 2
- Vermont 2
- Illinois 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- New Hampshire 1
- Pennsylvania 1
- South Carolina 1
- Tennessee 1
- Texas 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491669 | 2491669 | 2022-05-10 | Franklin | New York | 36033 | 10015 | 46 |
2489461 | 2489461 | 2022-05-09 | Bennington | Vermont | 50003 | 10015 | 70 |
2440978 | 2440978 | 2022-04-25 | Escambia | Alabama | 1053 | 10015 | 170 |
2424698 | 2424698 | 2022-04-20 | Escambia | Alabama | 1053 | 10015 | 170 |
2421442 | 2421442 | 2022-04-19 | Escambia | Alabama | 1053 | 10015 | 170 |
2398298 | 2398298 | 2022-04-11 | Washington | Vermont | 50023 | 10015 | 47 |
2291321 | 2291321 | 2022-03-10 | Russell | Alabama | 1113 | 10015 | 84 |
2287813 | 2287813 | 2022-03-08 | Tazewell | Virginia | 51185 | 10015 | 157 |
2283090 | 2283090 | 2022-03-07 | Phelps | Missouri | 29161 | 10015 | 231 |
2240152 | 2240152 | 2022-02-22 | Cowley | Kansas | 20035 | 10015 | 147 |
2236901 | 2236901 | 2022-02-21 | Cowley | Kansas | 20035 | 10015 | 147 |
2087489 | 2087489 | 2022-01-06 | Whitley | Kentucky | 21235 | 10015 | 142 |
1984204 | 1984204 | 2021-12-05 | Cayuga | New York | 36011 | 10015 | 114 |
1896536 | 1896536 | 2021-11-08 | Franklin | North Carolina | 37069 | 10015 | 60 |
1842745 | 1842745 | 2021-10-23 | Greene | Arkansas | 5055 | 10015 | 122 |
1721390 | 1721390 | 2021-09-15 | Linn | Oregon | 41043 | 10015 | 86 |
1539873 | 1539873 | 2021-07-21 | Bastrop | Texas | 48021 | 10015 | 105 |
1448153 | 1448153 | 2021-06-23 | Warren | New Jersey | 34041 | 10015 | 237 |
1438841 | 1438841 | 2021-06-20 | Deschutes | Oregon | 41017 | 10015 | 82 |
1430326 | 1430326 | 2021-06-18 | Napa | California | 6055 | 10015 | 80 |
1428654 | 1428654 | 2021-06-17 | Strafford | New Hampshire | 33017 | 10015 | 97 |
1256059 | 1256059 | 2021-04-25 | Allegan | Michigan | 26005 | 10015 | 126 |
1252812 | 1252812 | 2021-04-24 | Allegan | Michigan | 26005 | 10015 | 126 |
1159828 | 1159828 | 2021-03-26 | Lancaster | South Carolina | 45057 | 10015 | 157 |
1154273 | 1154273 | 2021-03-25 | Garland | Arkansas | 5051 | 10015 | 251 |
1132131 | 1132131 | 2021-03-18 | Delaware | Indiana | 18035 | 10015 | 187 |
1056086 | 1056086 | 2021-02-22 | Madison | Tennessee | 47113 | 10015 | 225 |
1039275 | 1039275 | 2021-02-17 | Wayne | North Carolina | 37191 | 10015 | 203 |
953538 | 953538 | 2021-01-22 | Kendall | Illinois | 17093 | 10015 | 81 |
918573 | 918573 | 2021-01-11 | Olmsted | Minnesota | 27109 | 10015 | 68 |
871963 | 871963 | 2020-12-28 | Madera | California | 6039 | 10015 | 116 |
864178 | 864178 | 2020-12-25 | Canadian | Oklahoma | 40017 | 10015 | 49 |
860933 | 860933 | 2020-12-24 | Canadian | Oklahoma | 40017 | 10015 | 49 |
693258 | 693258 | 2020-11-02 | Winnebago | Wisconsin | 55139 | 10015 | 69 |
584798 | 584798 | 2020-09-30 | Camden | New Jersey | 34007 | 10015 | 612 |
548605 | 548605 | 2020-09-19 | Norfolk | Massachusetts | 25021 | 10015 | 1046 |
410744 | 410744 | 2020-08-07 | Montgomery | Pennsylvania | 42091 | 10015 | 855 |
389375 | 389375 | 2020-08-01 | Sacramento | California | 6067 | 10015 | 142 |
364642 | 364642 | 2020-07-24 | Baltimore city | Maryland | 24510 | 10015 | 395 |
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);