ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 17720 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- California 7
- Oklahoma 7
- Kansas 3
- Michigan 3
- Colorado 1
- Florida 1
- Georgia 1
- Kentucky 1
- Montana 1
- New Hampshire 1
- New Jersey 1
- New York 1
- Pennsylvania 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421660 | 2421660 | 2022-04-19 | Yuba | California | 6115 | 17720 | 121 |
2418404 | 2418404 | 2022-04-18 | Yuba | California | 6115 | 17720 | 121 |
2415148 | 2415148 | 2022-04-17 | Yuba | California | 6115 | 17720 | 121 |
2411892 | 2411892 | 2022-04-16 | Yuba | California | 6115 | 17720 | 121 |
2408636 | 2408636 | 2022-04-15 | Yuba | California | 6115 | 17720 | 121 |
2405380 | 2405380 | 2022-04-14 | Yuba | California | 6115 | 17720 | 121 |
2402125 | 2402125 | 2022-04-13 | Yuba | California | 6115 | 17720 | 121 |
2325110 | 2325110 | 2022-03-20 | Shiawassee | Michigan | 26155 | 17720 | 228 |
2321856 | 2321856 | 2022-03-19 | Shiawassee | Michigan | 26155 | 17720 | 228 |
2318602 | 2318602 | 2022-03-18 | Shiawassee | Michigan | 26155 | 17720 | 228 |
2239192 | 2239192 | 2022-02-21 | Portage | Wisconsin | 55097 | 17720 | 150 |
2218652 | 2218652 | 2022-02-15 | Creek | Oklahoma | 40037 | 17720 | 296 |
2215401 | 2215401 | 2022-02-14 | Creek | Oklahoma | 40037 | 17720 | 296 |
2212150 | 2212150 | 2022-02-13 | Creek | Oklahoma | 40037 | 17720 | 296 |
2208897 | 2208897 | 2022-02-12 | Creek | Oklahoma | 40037 | 17720 | 296 |
2205644 | 2205644 | 2022-02-11 | Creek | Oklahoma | 40037 | 17720 | 296 |
2202391 | 2202391 | 2022-02-10 | Creek | Oklahoma | 40037 | 17720 | 296 |
2199137 | 2199137 | 2022-02-09 | Creek | Oklahoma | 40037 | 17720 | 296 |
2032759 | 2032759 | 2021-12-20 | Missoula | Montana | 30063 | 17720 | 191 |
2016649 | 2016649 | 2021-12-15 | Strafford | New Hampshire | 33017 | 17720 | 151 |
1896407 | 1896407 | 2021-11-08 | Sussex | New Jersey | 34037 | 17720 | 339 |
1857895 | 1857895 | 2021-10-27 | Fayette | Pennsylvania | 42051 | 17720 | 401 |
1606565 | 1606565 | 2021-08-11 | Warren | Kentucky | 21227 | 17720 | 194 |
1531244 | 1531244 | 2021-07-19 | Paulding | Georgia | 13223 | 17720 | 235 |
1460307 | 1460307 | 2021-06-27 | Shawnee | Kansas | 20177 | 17720 | 371 |
1457062 | 1457062 | 2021-06-26 | Shawnee | Kansas | 20177 | 17720 | 371 |
1453817 | 1453817 | 2021-06-25 | Shawnee | Kansas | 20177 | 17720 | 371 |
1332497 | 1332497 | 2021-05-18 | Norfolk city | Virginia | 51710 | 17720 | 259 |
1253416 | 1253416 | 2021-04-24 | Broome | New York | 36007 | 17720 | 351 |
923945 | 923945 | 2021-01-13 | Douglas | Colorado | 8035 | 17720 | 215 |
807235 | 807235 | 2020-12-08 | Volusia | Florida | 12127 | 17720 | 386 |
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);