ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 51530 and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
30519 | 30519 | 2020-04-03 | Buena Vista city | Virginia | 51530 | 1 | 0 |
32917 | 32917 | 2020-04-04 | Buena Vista city | Virginia | 51530 | 1 | 0 |
35355 | 35355 | 2020-04-05 | Buena Vista city | Virginia | 51530 | 4 | 0 |
37837 | 37837 | 2020-04-06 | Buena Vista city | Virginia | 51530 | 4 | 0 |
40368 | 40368 | 2020-04-07 | Buena Vista city | Virginia | 51530 | 4 | 0 |
42937 | 42937 | 2020-04-08 | Buena Vista city | Virginia | 51530 | 4 | 0 |
45531 | 45531 | 2020-04-09 | Buena Vista city | Virginia | 51530 | 4 | 0 |
48155 | 48155 | 2020-04-10 | Buena Vista city | Virginia | 51530 | 4 | 0 |
50813 | 50813 | 2020-04-11 | Buena Vista city | Virginia | 51530 | 4 | 0 |
53488 | 53488 | 2020-04-12 | Buena Vista city | Virginia | 51530 | 4 | 0 |
56177 | 56177 | 2020-04-13 | Buena Vista city | Virginia | 51530 | 4 | 0 |
58883 | 58883 | 2020-04-14 | Buena Vista city | Virginia | 51530 | 4 | 0 |
61602 | 61602 | 2020-04-15 | Buena Vista city | Virginia | 51530 | 4 | 0 |
64334 | 64334 | 2020-04-16 | Buena Vista city | Virginia | 51530 | 4 | 0 |
67082 | 67082 | 2020-04-17 | Buena Vista city | Virginia | 51530 | 5 | 0 |
69844 | 69844 | 2020-04-18 | Buena Vista city | Virginia | 51530 | 5 | 0 |
72614 | 72614 | 2020-04-19 | Buena Vista city | Virginia | 51530 | 5 | 0 |
75390 | 75390 | 2020-04-20 | Buena Vista city | Virginia | 51530 | 5 | 0 |
78172 | 78172 | 2020-04-21 | Buena Vista city | Virginia | 51530 | 5 | 0 |
80964 | 80964 | 2020-04-22 | Buena Vista city | Virginia | 51530 | 5 | 0 |
83765 | 83765 | 2020-04-23 | Buena Vista city | Virginia | 51530 | 5 | 0 |
86572 | 86572 | 2020-04-24 | Buena Vista city | Virginia | 51530 | 5 | 0 |
89387 | 89387 | 2020-04-25 | Buena Vista city | Virginia | 51530 | 5 | 0 |
92204 | 92204 | 2020-04-26 | Buena Vista city | Virginia | 51530 | 5 | 0 |
95033 | 95033 | 2020-04-27 | Buena Vista city | Virginia | 51530 | 5 | 0 |
97875 | 97875 | 2020-04-28 | Buena Vista city | Virginia | 51530 | 5 | 0 |
100725 | 100725 | 2020-04-29 | Buena Vista city | Virginia | 51530 | 5 | 0 |
103580 | 103580 | 2020-04-30 | Buena Vista city | Virginia | 51530 | 6 | 0 |
106444 | 106444 | 2020-05-01 | Buena Vista city | Virginia | 51530 | 6 | 0 |
109313 | 109313 | 2020-05-02 | Buena Vista city | Virginia | 51530 | 6 | 0 |
112187 | 112187 | 2020-05-03 | Buena Vista city | Virginia | 51530 | 6 | 0 |
115070 | 115070 | 2020-05-04 | Buena Vista city | Virginia | 51530 | 6 | 0 |
118029 | 118029 | 2020-05-05 | Buena Vista city | Virginia | 51530 | 6 | 0 |
120993 | 120993 | 2020-05-06 | Buena Vista city | Virginia | 51530 | 6 | 0 |
123974 | 123974 | 2020-05-07 | Buena Vista city | Virginia | 51530 | 8 | 0 |
126959 | 126959 | 2020-05-08 | Buena Vista city | Virginia | 51530 | 8 | 0 |
129948 | 129948 | 2020-05-09 | Buena Vista city | Virginia | 51530 | 8 | 0 |
132938 | 132938 | 2020-05-10 | Buena Vista city | Virginia | 51530 | 8 | 0 |
135928 | 135928 | 2020-05-11 | Buena Vista city | Virginia | 51530 | 8 | 0 |
138919 | 138919 | 2020-05-12 | Buena Vista city | Virginia | 51530 | 8 | 0 |
141915 | 141915 | 2020-05-13 | Buena Vista city | Virginia | 51530 | 8 | 0 |
144912 | 144912 | 2020-05-14 | Buena Vista city | Virginia | 51530 | 8 | 0 |
147915 | 147915 | 2020-05-15 | Buena Vista city | Virginia | 51530 | 8 | 0 |
150924 | 150924 | 2020-05-16 | Buena Vista city | Virginia | 51530 | 8 | 0 |
153935 | 153935 | 2020-05-17 | Buena Vista city | Virginia | 51530 | 8 | 0 |
156952 | 156952 | 2020-05-18 | Buena Vista city | Virginia | 51530 | 9 | 0 |
159976 | 159976 | 2020-05-19 | Buena Vista city | Virginia | 51530 | 11 | 0 |
163004 | 163004 | 2020-05-20 | Buena Vista city | Virginia | 51530 | 11 | 0 |
166033 | 166033 | 2020-05-21 | Buena Vista city | Virginia | 51530 | 12 | 0 |
169069 | 169069 | 2020-05-22 | Buena Vista city | Virginia | 51530 | 12 | 0 |
172110 | 172110 | 2020-05-23 | Buena Vista city | Virginia | 51530 | 12 | 0 |
175153 | 175153 | 2020-05-24 | Buena Vista city | Virginia | 51530 | 12 | 0 |
178198 | 178198 | 2020-05-25 | Buena Vista city | Virginia | 51530 | 12 | 0 |
181242 | 181242 | 2020-05-26 | Buena Vista city | Virginia | 51530 | 13 | 0 |
184293 | 184293 | 2020-05-27 | Buena Vista city | Virginia | 51530 | 13 | 0 |
187350 | 187350 | 2020-05-28 | Buena Vista city | Virginia | 51530 | 13 | 0 |
190414 | 190414 | 2020-05-29 | Buena Vista city | Virginia | 51530 | 13 | 0 |
193480 | 193480 | 2020-05-30 | Buena Vista city | Virginia | 51530 | 13 | 0 |
196550 | 196550 | 2020-05-31 | Buena Vista city | Virginia | 51530 | 13 | 0 |
199623 | 199623 | 2020-06-01 | Buena Vista city | Virginia | 51530 | 13 | 0 |
202699 | 202699 | 2020-06-02 | Buena Vista city | Virginia | 51530 | 13 | 0 |
205778 | 205778 | 2020-06-03 | Buena Vista city | Virginia | 51530 | 13 | 0 |
208860 | 208860 | 2020-06-04 | Buena Vista city | Virginia | 51530 | 13 | 0 |
211945 | 211945 | 2020-06-05 | Buena Vista city | Virginia | 51530 | 13 | 0 |
215032 | 215032 | 2020-06-06 | Buena Vista city | Virginia | 51530 | 13 | 0 |
218122 | 218122 | 2020-06-07 | Buena Vista city | Virginia | 51530 | 13 | 0 |
221214 | 221214 | 2020-06-08 | Buena Vista city | Virginia | 51530 | 13 | 0 |
224310 | 224310 | 2020-06-09 | Buena Vista city | Virginia | 51530 | 13 | 0 |
227410 | 227410 | 2020-06-10 | Buena Vista city | Virginia | 51530 | 13 | 0 |
230514 | 230514 | 2020-06-11 | Buena Vista city | Virginia | 51530 | 12 | 0 |
233619 | 233619 | 2020-06-12 | Buena Vista city | Virginia | 51530 | 12 | 0 |
236726 | 236726 | 2020-06-13 | Buena Vista city | Virginia | 51530 | 12 | 0 |
239834 | 239834 | 2020-06-14 | Buena Vista city | Virginia | 51530 | 12 | 0 |
242945 | 242945 | 2020-06-15 | Buena Vista city | Virginia | 51530 | 12 | 0 |
246057 | 246057 | 2020-06-16 | Buena Vista city | Virginia | 51530 | 12 | 0 |
249169 | 249169 | 2020-06-17 | Buena Vista city | Virginia | 51530 | 12 | 0 |
252284 | 252284 | 2020-06-18 | Buena Vista city | Virginia | 51530 | 12 | 0 |
255403 | 255403 | 2020-06-19 | Buena Vista city | Virginia | 51530 | 12 | 0 |
258530 | 258530 | 2020-06-20 | Buena Vista city | Virginia | 51530 | 12 | 0 |
261657 | 261657 | 2020-06-21 | Buena Vista city | Virginia | 51530 | 12 | 0 |
264786 | 264786 | 2020-06-22 | Buena Vista city | Virginia | 51530 | 12 | 0 |
267915 | 267915 | 2020-06-23 | Buena Vista city | Virginia | 51530 | 14 | 0 |
271049 | 271049 | 2020-06-24 | Buena Vista city | Virginia | 51530 | 14 | 0 |
274189 | 274189 | 2020-06-25 | Buena Vista city | Virginia | 51530 | 14 | 0 |
277337 | 277337 | 2020-06-26 | Buena Vista city | Virginia | 51530 | 14 | 0 |
280485 | 280485 | 2020-06-27 | Buena Vista city | Virginia | 51530 | 14 | 0 |
283631 | 283631 | 2020-06-28 | Buena Vista city | Virginia | 51530 | 14 | 0 |
286777 | 286777 | 2020-06-29 | Buena Vista city | Virginia | 51530 | 14 | 0 |
289927 | 289927 | 2020-06-30 | Buena Vista city | Virginia | 51530 | 15 | 0 |
293080 | 293080 | 2020-07-01 | Buena Vista city | Virginia | 51530 | 16 | 0 |
296235 | 296235 | 2020-07-02 | Buena Vista city | Virginia | 51530 | 16 | 0 |
299397 | 299397 | 2020-07-03 | Buena Vista city | Virginia | 51530 | 16 | 0 |
302561 | 302561 | 2020-07-04 | Buena Vista city | Virginia | 51530 | 15 | 0 |
305725 | 305725 | 2020-07-05 | Buena Vista city | Virginia | 51530 | 15 | 0 |
308893 | 308893 | 2020-07-06 | Buena Vista city | Virginia | 51530 | 15 | 0 |
312062 | 312062 | 2020-07-07 | Buena Vista city | Virginia | 51530 | 16 | 0 |
315237 | 315237 | 2020-07-08 | Buena Vista city | Virginia | 51530 | 16 | 0 |
318410 | 318410 | 2020-07-09 | Buena Vista city | Virginia | 51530 | 15 | 0 |
321589 | 321589 | 2020-07-10 | Buena Vista city | Virginia | 51530 | 18 | 0 |
324770 | 324770 | 2020-07-11 | Buena Vista city | Virginia | 51530 | 18 | 0 |
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);