ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 9855 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Indiana 7
- New York 5
- South Carolina 4
- Washington 4
- Minnesota 3
- Wisconsin 3
- Alabama 2
- Louisiana 2
- Ohio 2
- California 1
- Illinois 1
- Iowa 1
- Maryland 1
- Mississippi 1
- Missouri 1
- New Hampshire 1
- New Jersey 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462356 | 2462356 | 2022-05-01 | Franklin | New York | 36033 | 9855 | 45 |
2382378 | 2382378 | 2022-04-07 | Franklin | Alabama | 1059 | 9855 | 137 |
2379123 | 2379123 | 2022-04-06 | Franklin | Alabama | 1059 | 9855 | 137 |
2248529 | 2248529 | 2022-02-24 | Medina | Texas | 48325 | 9855 | 190 |
2242190 | 2242190 | 2022-02-22 | Charlottesville city | Virginia | 51540 | 9855 | 67 |
2176054 | 2176054 | 2022-02-02 | Cortland | New York | 36023 | 9855 | 108 |
2074083 | 2074083 | 2022-01-02 | Dearborn | Indiana | 18029 | 9855 | 115 |
2070832 | 2070832 | 2022-01-01 | Dearborn | Indiana | 18029 | 9855 | 115 |
2067581 | 2067581 | 2021-12-31 | Dearborn | Indiana | 18029 | 9855 | 115 |
2064330 | 2064330 | 2021-12-30 | Dearborn | Indiana | 18029 | 9855 | 115 |
2049227 | 2049227 | 2021-12-25 | Genesee | New York | 36037 | 9855 | 153 |
2045977 | 2045977 | 2021-12-24 | Genesee | New York | 36037 | 9855 | 153 |
1994207 | 1994207 | 2021-12-08 | Jefferson | Ohio | 39081 | 9855 | 230 |
1952286 | 1952286 | 2021-11-25 | Georgetown | South Carolina | 45043 | 9855 | 183 |
1949035 | 1949035 | 2021-11-24 | Georgetown | South Carolina | 45043 | 9855 | 183 |
1860959 | 1860959 | 2021-10-28 | Lawrence | Ohio | 39087 | 9855 | 154 |
1824505 | 1824505 | 2021-10-17 | Rice | Minnesota | 27131 | 9855 | 131 |
1821256 | 1821256 | 2021-10-16 | Rice | Minnesota | 27131 | 9855 | 131 |
1818007 | 1818007 | 2021-10-15 | Rice | Minnesota | 27131 | 9855 | 131 |
1789937 | 1789937 | 2021-10-06 | Hawkins | Tennessee | 47073 | 9855 | 158 |
1785978 | 1785978 | 2021-10-05 | Chemung | New York | 36015 | 9855 | 150 |
1778356 | 1778356 | 2021-10-03 | Grant | Indiana | 18053 | 9855 | 219 |
1775106 | 1775106 | 2021-10-02 | Grant | Indiana | 18053 | 9855 | 219 |
1771856 | 1771856 | 2021-10-01 | Grant | Indiana | 18053 | 9855 | 219 |
1715833 | 1715833 | 2021-09-13 | Manitowoc | Wisconsin | 55071 | 9855 | 99 |
1581245 | 1581245 | 2021-08-03 | Merrimack | New Hampshire | 33013 | 9855 | 117 |
1517991 | 1517991 | 2021-07-15 | Sutter | California | 6101 | 9855 | 114 |
1498241 | 1498241 | 2021-07-08 | St. Croix | Wisconsin | 55109 | 9855 | 71 |
1354669 | 1354669 | 2021-05-25 | Orangeburg | South Carolina | 45075 | 9855 | 252 |
1351423 | 1351423 | 2021-05-24 | Orangeburg | South Carolina | 45075 | 9855 | 251 |
1348816 | 1348816 | 2021-05-23 | Thurston | Washington | 53067 | 9855 | 105 |
1345568 | 1345568 | 2021-05-22 | Thurston | Washington | 53067 | 9855 | 105 |
1342320 | 1342320 | 2021-05-21 | Thurston | Washington | 53067 | 9855 | 105 |
1188070 | 1188070 | 2021-04-04 | Madison | Mississippi | 28089 | 9855 | 209 |
1174799 | 1174799 | 2021-03-31 | Terrebonne | Louisiana | 22109 | 9855 | 218 |
943800 | 943800 | 2021-01-19 | Kendall | Illinois | 17093 | 9855 | 78 |
921662 | 921662 | 2021-01-12 | Washington | Maryland | 24043 | 9855 | 176 |
912991 | 912991 | 2021-01-09 | Franklin | Pennsylvania | 42055 | 9855 | 259 |
813262 | 813262 | 2020-12-09 | Fond du Lac | Wisconsin | 55039 | 9855 | 63 |
795665 | 795665 | 2020-12-04 | Gloucester | New Jersey | 34015 | 9855 | 298 |
791468 | 791468 | 2020-12-03 | Johnson | Iowa | 19103 | 9855 | 39 |
665636 | 665636 | 2020-10-25 | Jackson | Missouri | 29095 | 9855 | 123 |
655487 | 655487 | 2020-10-22 | Caddo | Louisiana | 22017 | 9855 | 391 |
363295 | 363295 | 2020-07-23 | Yakima | Washington | 53077 | 9855 | 207 |
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);