ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 18 and fips = 51021 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 |
---|---|---|---|---|---|---|---|
2144601 | 2144601 | 2022-01-23 | Bland | Virginia | 51021 | 1412 | 18 |
2141346 | 2141346 | 2022-01-22 | Bland | Virginia | 51021 | 1412 | 18 |
2138090 | 2138090 | 2022-01-21 | Bland | Virginia | 51021 | 1412 | 18 |
2134836 | 2134836 | 2022-01-20 | Bland | Virginia | 51021 | 1373 | 18 |
2131584 | 2131584 | 2022-01-19 | Bland | Virginia | 51021 | 1360 | 18 |
2128330 | 2128330 | 2022-01-18 | Bland | Virginia | 51021 | 1346 | 18 |
2125077 | 2125077 | 2022-01-17 | Bland | Virginia | 51021 | 1348 | 18 |
2121825 | 2121825 | 2022-01-16 | Bland | Virginia | 51021 | 1299 | 18 |
2118573 | 2118573 | 2022-01-15 | Bland | Virginia | 51021 | 1299 | 18 |
2115321 | 2115321 | 2022-01-14 | Bland | Virginia | 51021 | 1299 | 18 |
2112069 | 2112069 | 2022-01-13 | Bland | Virginia | 51021 | 1287 | 18 |
2108817 | 2108817 | 2022-01-12 | Bland | Virginia | 51021 | 1264 | 18 |
2105566 | 2105566 | 2022-01-11 | Bland | Virginia | 51021 | 1258 | 18 |
2102315 | 2102315 | 2022-01-10 | Bland | Virginia | 51021 | 1256 | 18 |
2099064 | 2099064 | 2022-01-09 | Bland | Virginia | 51021 | 1227 | 18 |
2095813 | 2095813 | 2022-01-08 | Bland | Virginia | 51021 | 1227 | 18 |
2092561 | 2092561 | 2022-01-07 | Bland | Virginia | 51021 | 1227 | 18 |
2089309 | 2089309 | 2022-01-06 | Bland | Virginia | 51021 | 1212 | 18 |
2086058 | 2086058 | 2022-01-05 | Bland | Virginia | 51021 | 1206 | 18 |
2082806 | 2082806 | 2022-01-04 | Bland | Virginia | 51021 | 1204 | 18 |
2079554 | 2079554 | 2022-01-03 | Bland | Virginia | 51021 | 1202 | 18 |
2076302 | 2076302 | 2022-01-02 | Bland | Virginia | 51021 | 1185 | 18 |
2073051 | 2073051 | 2022-01-01 | Bland | Virginia | 51021 | 1185 | 18 |
2069800 | 2069800 | 2021-12-31 | Bland | Virginia | 51021 | 1185 | 18 |
2066549 | 2066549 | 2021-12-30 | Bland | Virginia | 51021 | 1180 | 18 |
2063299 | 2063299 | 2021-12-29 | Bland | Virginia | 51021 | 1174 | 18 |
2060049 | 2060049 | 2021-12-28 | Bland | Virginia | 51021 | 1170 | 18 |
2056800 | 2056800 | 2021-12-27 | Bland | Virginia | 51021 | 1168 | 18 |
2053551 | 2053551 | 2021-12-26 | Bland | Virginia | 51021 | 1166 | 18 |
2050301 | 2050301 | 2021-12-25 | Bland | Virginia | 51021 | 1166 | 18 |
2047051 | 2047051 | 2021-12-24 | Bland | Virginia | 51021 | 1166 | 18 |
2043801 | 2043801 | 2021-12-23 | Bland | Virginia | 51021 | 1165 | 18 |
2040552 | 2040552 | 2021-12-22 | Bland | Virginia | 51021 | 1164 | 18 |
2037302 | 2037302 | 2021-12-21 | Bland | Virginia | 51021 | 1160 | 18 |
2034052 | 2034052 | 2021-12-20 | Bland | Virginia | 51021 | 1159 | 18 |
2030802 | 2030802 | 2021-12-19 | Bland | Virginia | 51021 | 1151 | 18 |
2027551 | 2027551 | 2021-12-18 | Bland | Virginia | 51021 | 1151 | 18 |
2024300 | 2024300 | 2021-12-17 | Bland | Virginia | 51021 | 1151 | 18 |
2021049 | 2021049 | 2021-12-16 | Bland | Virginia | 51021 | 1150 | 18 |
2017798 | 2017798 | 2021-12-15 | Bland | Virginia | 51021 | 1147 | 18 |
2014548 | 2014548 | 2021-12-14 | Bland | Virginia | 51021 | 1149 | 18 |
2011297 | 2011297 | 2021-12-13 | Bland | Virginia | 51021 | 1149 | 18 |
2008046 | 2008046 | 2021-12-12 | Bland | Virginia | 51021 | 1148 | 18 |
2004795 | 2004795 | 2021-12-11 | Bland | Virginia | 51021 | 1148 | 18 |
2001544 | 2001544 | 2021-12-10 | Bland | Virginia | 51021 | 1148 | 18 |
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);