ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 18463 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- New York 4
- Kentucky 3
- North Carolina 2
- Oklahoma 2
- Florida 1
- New Jersey 1
- Ohio 1
- Pennsylvania 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501792 | 2501792 | 2022-05-13 | Payne | Oklahoma | 40119 | 18463 | 166 |
2498534 | 2498534 | 2022-05-12 | Payne | Oklahoma | 40119 | 18463 | 166 |
2354968 | 2354968 | 2022-03-29 | Tompkins | New York | 36109 | 18463 | 83 |
2192761 | 2192761 | 2022-02-07 | Lawrence | Pennsylvania | 42073 | 18463 | 381 |
2169559 | 2169559 | 2022-01-31 | Jefferson | New York | 36045 | 18463 | 125 |
1935493 | 1935493 | 2021-11-20 | Ulster | New York | 36111 | 18463 | 287 |
1733147 | 1733147 | 2021-09-19 | Boone | Kentucky | 21015 | 18463 | 183 |
1729897 | 1729897 | 2021-09-18 | Boone | Kentucky | 21015 | 18463 | 183 |
1726647 | 1726647 | 2021-09-17 | Boone | Kentucky | 21015 | 18463 | 183 |
1349348 | 1349348 | 2021-05-24 | Santa Rosa | Florida | 12113 | 18463 | 291 |
1344325 | 1344325 | 2021-05-22 | Broome | New York | 36007 | 18463 | 360 |
1329421 | 1329421 | 2021-05-17 | Kenosha | Wisconsin | 55059 | 18463 | 324 |
1286117 | 1286117 | 2021-05-04 | Delaware | Ohio | 39041 | 18463 | 131 |
1074895 | 1074895 | 2021-02-28 | Cabarrus | North Carolina | 37025 | 18463 | 235 |
1071649 | 1071649 | 2021-02-27 | Cabarrus | North Carolina | 37025 | 18463 | 235 |
985081 | 985081 | 2021-01-31 | Henrico | Virginia | 51087 | 18463 | 344 |
210849 | 210849 | 2020-06-05 | Bergen | New Jersey | 34003 | 18463 | 1611 |
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);