ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 9828 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Michigan 5
- Tennessee 4
- Illinois 3
- New York 3
- New Jersey 2
- Utah 2
- Virginia 2
- Arkansas 1
- Idaho 1
- Indiana 1
- Iowa 1
- Maryland 1
- Massachusetts 1
- Nebraska 1
- New Hampshire 1
- North Carolina 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487107 | 2487107 | 2022-05-09 | Bingham | Idaho | 16011 | 9828 | 154 |
2461157 | 2461157 | 2022-05-01 | Montgomery | Illinois | 17135 | 9828 | 111 |
2457901 | 2457901 | 2022-04-30 | Montgomery | Illinois | 17135 | 9828 | 111 |
2454645 | 2454645 | 2022-04-29 | Montgomery | Illinois | 17135 | 9828 | 111 |
2218230 | 2218230 | 2022-02-15 | Scotts Bluff | Nebraska | 31157 | 9828 | 102 |
2191691 | 2191691 | 2022-02-07 | Franklin | Massachusetts | 25011 | 9828 | 153 |
2169597 | 2169597 | 2022-01-31 | Alexander | North Carolina | 37003 | 9828 | 121 |
2125096 | 2125096 | 2022-01-17 | Culpeper | Virginia | 51047 | 9828 | 97 |
2111031 | 2111031 | 2022-01-13 | Washington | New York | 36115 | 9828 | 96 |
1952737 | 1952737 | 2021-11-25 | Iron | Utah | 49021 | 9828 | 60 |
1949486 | 1949486 | 2021-11-24 | Iron | Utah | 49021 | 9828 | 60 |
1921874 | 1921874 | 2021-11-16 | Isabella | Michigan | 26073 | 9828 | 137 |
1921913 | 1921913 | 2021-11-16 | Shiawassee | Michigan | 26155 | 9828 | 137 |
1918624 | 1918624 | 2021-11-15 | Isabella | Michigan | 26073 | 9828 | 137 |
1918663 | 1918663 | 2021-11-15 | Shiawassee | Michigan | 26155 | 9828 | 137 |
1825713 | 1825713 | 2021-10-17 | Roane | Tennessee | 47145 | 9828 | 147 |
1822464 | 1822464 | 2021-10-16 | Roane | Tennessee | 47145 | 9828 | 147 |
1819215 | 1819215 | 2021-10-15 | Roane | Tennessee | 47145 | 9828 | 147 |
1799012 | 1799012 | 2021-10-09 | St. Lawrence | New York | 36089 | 9828 | 122 |
1452798 | 1452798 | 2021-06-24 | St. Croix | Wisconsin | 55109 | 9828 | 67 |
1415683 | 1415683 | 2021-06-13 | Hunterdon | New Jersey | 34019 | 9828 | 176 |
1412437 | 1412437 | 2021-06-12 | Hunterdon | New Jersey | 34019 | 9828 | 176 |
1347513 | 1347513 | 2021-05-23 | Strafford | New Hampshire | 33017 | 9828 | 90 |
1243071 | 1243071 | 2021-04-21 | Allegan | Michigan | 26005 | 9828 | 126 |
1184575 | 1184575 | 2021-04-03 | Charles | Maryland | 24017 | 9828 | 176 |
1121466 | 1121466 | 2021-03-14 | Stafford | Virginia | 51179 | 9828 | 70 |
1099082 | 1099082 | 2021-03-08 | Garland | Arkansas | 5051 | 9828 | 234 |
1063963 | 1063963 | 2021-02-25 | Delaware | Indiana | 18035 | 9828 | 183 |
906743 | 906743 | 2021-01-07 | Bradley | Tennessee | 47011 | 9828 | 81 |
814162 | 814162 | 2020-12-10 | Dubuque | Iowa | 19061 | 9828 | 123 |
533949 | 533949 | 2020-09-14 | Lubbock | Texas | 48303 | 9828 | 109 |
82918 | 82918 | 2020-04-23 | Rockland | New York | 36087 | 9828 | 322 |
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);