ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 18310 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337316 | 2337316 | 2022-03-24 | Rockdale | Georgia | 13247 | 18310 | 314 |
2334062 | 2334062 | 2022-03-23 | Rockdale | Georgia | 13247 | 18310 | 314 |
2217455 | 2217455 | 2022-02-15 | Reno | Kansas | 20155 | 18310 | 214 |
2214204 | 2214204 | 2022-02-14 | Reno | Kansas | 20155 | 18310 | 214 |
2210123 | 2210123 | 2022-02-13 | Jefferson | Arkansas | 5069 | 18310 | 253 |
2146904 | 2146904 | 2022-01-24 | Surry | North Carolina | 37171 | 18310 | 277 |
1680165 | 1680165 | 2021-09-03 | Calhoun | Alabama | 1015 | 18310 | 355 |
1557706 | 1557706 | 2021-07-27 | Shawnee | Kansas | 20177 | 18310 | 377 |
1554459 | 1554459 | 2021-07-26 | Shawnee | Kansas | 20177 | 18310 | 377 |
1370676 | 1370676 | 2021-05-30 | Clackamas | Oregon | 41005 | 18310 | 223 |
1296956 | 1296956 | 2021-05-07 | Kenosha | Wisconsin | 55059 | 18310 | 324 |
930231 | 930231 | 2021-01-15 | Shelby | Alabama | 1117 | 18310 | 113 |
694487 | 694487 | 2020-11-03 | Baltimore city | Maryland | 24510 | 18310 | 508 |
485622 | 485622 | 2020-08-30 | Fairfax | Virginia | 51059 | 18310 | 555 |
256889 | 256889 | 2020-06-20 | Prince George's | Maryland | 24033 | 18310 | 658 |
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);