ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 5, fips = 51179 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315337 | 315337 | 2020-07-08 | Stafford | Virginia | 51179 | 1029 | 5 |
312162 | 312162 | 2020-07-07 | Stafford | Virginia | 51179 | 1022 | 5 |
308993 | 308993 | 2020-07-06 | Stafford | Virginia | 51179 | 1012 | 5 |
305825 | 305825 | 2020-07-05 | Stafford | Virginia | 51179 | 1011 | 5 |
302661 | 302661 | 2020-07-04 | Stafford | Virginia | 51179 | 1008 | 5 |
299497 | 299497 | 2020-07-03 | Stafford | Virginia | 51179 | 998 | 5 |
296335 | 296335 | 2020-07-02 | Stafford | Virginia | 51179 | 1000 | 5 |
293180 | 293180 | 2020-07-01 | Stafford | Virginia | 51179 | 990 | 5 |
290027 | 290027 | 2020-06-30 | Stafford | Virginia | 51179 | 988 | 5 |
286877 | 286877 | 2020-06-29 | Stafford | Virginia | 51179 | 985 | 5 |
283731 | 283731 | 2020-06-28 | Stafford | Virginia | 51179 | 983 | 5 |
280585 | 280585 | 2020-06-27 | Stafford | Virginia | 51179 | 974 | 5 |
277437 | 277437 | 2020-06-26 | Stafford | Virginia | 51179 | 965 | 5 |
274289 | 274289 | 2020-06-25 | Stafford | Virginia | 51179 | 954 | 5 |
271149 | 271149 | 2020-06-24 | Stafford | Virginia | 51179 | 949 | 5 |
268015 | 268015 | 2020-06-23 | Stafford | Virginia | 51179 | 936 | 5 |
264886 | 264886 | 2020-06-22 | Stafford | Virginia | 51179 | 930 | 5 |
261757 | 261757 | 2020-06-21 | Stafford | Virginia | 51179 | 924 | 5 |
258630 | 258630 | 2020-06-20 | Stafford | Virginia | 51179 | 920 | 5 |
255503 | 255503 | 2020-06-19 | Stafford | Virginia | 51179 | 921 | 5 |
252384 | 252384 | 2020-06-18 | Stafford | Virginia | 51179 | 917 | 5 |
249269 | 249269 | 2020-06-17 | Stafford | Virginia | 51179 | 906 | 5 |
246157 | 246157 | 2020-06-16 | Stafford | Virginia | 51179 | 900 | 5 |
243044 | 243044 | 2020-06-15 | Stafford | Virginia | 51179 | 893 | 5 |
239933 | 239933 | 2020-06-14 | Stafford | Virginia | 51179 | 887 | 5 |
236825 | 236825 | 2020-06-13 | Stafford | Virginia | 51179 | 877 | 5 |
233718 | 233718 | 2020-06-12 | Stafford | Virginia | 51179 | 862 | 5 |
230613 | 230613 | 2020-06-11 | Stafford | Virginia | 51179 | 841 | 5 |
227509 | 227509 | 2020-06-10 | Stafford | Virginia | 51179 | 831 | 5 |
224409 | 224409 | 2020-06-09 | Stafford | Virginia | 51179 | 824 | 5 |
221313 | 221313 | 2020-06-08 | Stafford | Virginia | 51179 | 815 | 5 |
218221 | 218221 | 2020-06-07 | Stafford | Virginia | 51179 | 803 | 5 |
215131 | 215131 | 2020-06-06 | Stafford | Virginia | 51179 | 765 | 5 |
212044 | 212044 | 2020-06-05 | Stafford | Virginia | 51179 | 750 | 5 |
208959 | 208959 | 2020-06-04 | Stafford | Virginia | 51179 | 742 | 5 |
205877 | 205877 | 2020-06-03 | Stafford | Virginia | 51179 | 738 | 5 |
202798 | 202798 | 2020-06-02 | Stafford | Virginia | 51179 | 733 | 5 |
199722 | 199722 | 2020-06-01 | Stafford | Virginia | 51179 | 722 | 5 |
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);