ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 20, fips = 51036 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1900795 | 1900795 | 2021-11-09 | Charles City | Virginia | 51036 | 695 | 20 |
1897545 | 1897545 | 2021-11-08 | Charles City | Virginia | 51036 | 695 | 20 |
1894295 | 1894295 | 2021-11-07 | Charles City | Virginia | 51036 | 694 | 20 |
1891045 | 1891045 | 2021-11-06 | Charles City | Virginia | 51036 | 694 | 20 |
1887795 | 1887795 | 2021-11-05 | Charles City | Virginia | 51036 | 694 | 20 |
1884545 | 1884545 | 2021-11-04 | Charles City | Virginia | 51036 | 694 | 20 |
1881296 | 1881296 | 2021-11-03 | Charles City | Virginia | 51036 | 693 | 20 |
1878047 | 1878047 | 2021-11-02 | Charles City | Virginia | 51036 | 690 | 20 |
1874798 | 1874798 | 2021-11-01 | Charles City | Virginia | 51036 | 690 | 20 |
1871549 | 1871549 | 2021-10-31 | Charles City | Virginia | 51036 | 688 | 20 |
1868300 | 1868300 | 2021-10-30 | Charles City | Virginia | 51036 | 688 | 20 |
1865051 | 1865051 | 2021-10-29 | Charles City | Virginia | 51036 | 688 | 20 |
1861802 | 1861802 | 2021-10-28 | Charles City | Virginia | 51036 | 686 | 20 |
1858553 | 1858553 | 2021-10-27 | Charles City | Virginia | 51036 | 685 | 20 |
1855304 | 1855304 | 2021-10-26 | Charles City | Virginia | 51036 | 683 | 20 |
1852055 | 1852055 | 2021-10-25 | Charles City | Virginia | 51036 | 681 | 20 |
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);