ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 51071 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
37859 | 37859 | 2020-04-06 | Giles | Virginia | 51071 | 1 | 0 |
40392 | 40392 | 2020-04-07 | Giles | Virginia | 51071 | 2 | 0 |
42961 | 42961 | 2020-04-08 | Giles | Virginia | 51071 | 2 | 0 |
45556 | 45556 | 2020-04-09 | Giles | Virginia | 51071 | 2 | 0 |
48182 | 48182 | 2020-04-10 | Giles | Virginia | 51071 | 2 | 0 |
50840 | 50840 | 2020-04-11 | Giles | Virginia | 51071 | 2 | 0 |
53515 | 53515 | 2020-04-12 | Giles | Virginia | 51071 | 3 | 0 |
56205 | 56205 | 2020-04-13 | Giles | Virginia | 51071 | 4 | 0 |
58911 | 58911 | 2020-04-14 | Giles | Virginia | 51071 | 4 | 0 |
61630 | 61630 | 2020-04-15 | Giles | Virginia | 51071 | 4 | 0 |
64363 | 64363 | 2020-04-16 | Giles | Virginia | 51071 | 4 | 0 |
67111 | 67111 | 2020-04-17 | Giles | Virginia | 51071 | 4 | 0 |
69873 | 69873 | 2020-04-18 | Giles | Virginia | 51071 | 4 | 0 |
72643 | 72643 | 2020-04-19 | Giles | Virginia | 51071 | 4 | 0 |
75419 | 75419 | 2020-04-20 | Giles | Virginia | 51071 | 4 | 0 |
78201 | 78201 | 2020-04-21 | Giles | Virginia | 51071 | 4 | 0 |
80993 | 80993 | 2020-04-22 | Giles | Virginia | 51071 | 4 | 0 |
83794 | 83794 | 2020-04-23 | Giles | Virginia | 51071 | 4 | 0 |
86601 | 86601 | 2020-04-24 | Giles | Virginia | 51071 | 4 | 0 |
89416 | 89416 | 2020-04-25 | Giles | Virginia | 51071 | 4 | 0 |
92233 | 92233 | 2020-04-26 | Giles | Virginia | 51071 | 4 | 0 |
95062 | 95062 | 2020-04-27 | Giles | Virginia | 51071 | 4 | 0 |
97904 | 97904 | 2020-04-28 | Giles | Virginia | 51071 | 4 | 0 |
100754 | 100754 | 2020-04-29 | Giles | Virginia | 51071 | 4 | 0 |
103609 | 103609 | 2020-04-30 | Giles | Virginia | 51071 | 4 | 0 |
106473 | 106473 | 2020-05-01 | Giles | Virginia | 51071 | 4 | 0 |
109342 | 109342 | 2020-05-02 | Giles | Virginia | 51071 | 4 | 0 |
112216 | 112216 | 2020-05-03 | Giles | Virginia | 51071 | 4 | 0 |
115099 | 115099 | 2020-05-04 | Giles | Virginia | 51071 | 4 | 0 |
118058 | 118058 | 2020-05-05 | Giles | Virginia | 51071 | 4 | 0 |
121022 | 121022 | 2020-05-06 | Giles | Virginia | 51071 | 4 | 0 |
124003 | 124003 | 2020-05-07 | Giles | Virginia | 51071 | 4 | 0 |
126988 | 126988 | 2020-05-08 | Giles | Virginia | 51071 | 4 | 0 |
129978 | 129978 | 2020-05-09 | Giles | Virginia | 51071 | 8 | 0 |
132968 | 132968 | 2020-05-10 | Giles | Virginia | 51071 | 8 | 0 |
135958 | 135958 | 2020-05-11 | Giles | Virginia | 51071 | 8 | 0 |
138949 | 138949 | 2020-05-12 | Giles | Virginia | 51071 | 8 | 0 |
141945 | 141945 | 2020-05-13 | Giles | Virginia | 51071 | 5 | 0 |
144942 | 144942 | 2020-05-14 | Giles | Virginia | 51071 | 5 | 0 |
147945 | 147945 | 2020-05-15 | Giles | Virginia | 51071 | 5 | 0 |
150954 | 150954 | 2020-05-16 | Giles | Virginia | 51071 | 5 | 0 |
153965 | 153965 | 2020-05-17 | Giles | Virginia | 51071 | 5 | 0 |
156982 | 156982 | 2020-05-18 | Giles | Virginia | 51071 | 5 | 0 |
160006 | 160006 | 2020-05-19 | Giles | Virginia | 51071 | 5 | 0 |
163034 | 163034 | 2020-05-20 | Giles | Virginia | 51071 | 5 | 0 |
166063 | 166063 | 2020-05-21 | Giles | Virginia | 51071 | 5 | 0 |
169099 | 169099 | 2020-05-22 | Giles | Virginia | 51071 | 5 | 0 |
172140 | 172140 | 2020-05-23 | Giles | Virginia | 51071 | 5 | 0 |
175183 | 175183 | 2020-05-24 | Giles | Virginia | 51071 | 5 | 0 |
178228 | 178228 | 2020-05-25 | Giles | Virginia | 51071 | 5 | 0 |
181272 | 181272 | 2020-05-26 | Giles | Virginia | 51071 | 5 | 0 |
184323 | 184323 | 2020-05-27 | Giles | Virginia | 51071 | 5 | 0 |
187380 | 187380 | 2020-05-28 | Giles | Virginia | 51071 | 5 | 0 |
190444 | 190444 | 2020-05-29 | Giles | Virginia | 51071 | 5 | 0 |
193510 | 193510 | 2020-05-30 | Giles | Virginia | 51071 | 5 | 0 |
196580 | 196580 | 2020-05-31 | Giles | Virginia | 51071 | 5 | 0 |
199653 | 199653 | 2020-06-01 | Giles | Virginia | 51071 | 5 | 0 |
202729 | 202729 | 2020-06-02 | Giles | Virginia | 51071 | 5 | 0 |
205808 | 205808 | 2020-06-03 | Giles | Virginia | 51071 | 5 | 0 |
208890 | 208890 | 2020-06-04 | Giles | Virginia | 51071 | 5 | 0 |
211975 | 211975 | 2020-06-05 | Giles | Virginia | 51071 | 5 | 0 |
215062 | 215062 | 2020-06-06 | Giles | Virginia | 51071 | 5 | 0 |
218152 | 218152 | 2020-06-07 | Giles | Virginia | 51071 | 5 | 0 |
221244 | 221244 | 2020-06-08 | Giles | Virginia | 51071 | 5 | 0 |
224340 | 224340 | 2020-06-09 | Giles | Virginia | 51071 | 5 | 0 |
227440 | 227440 | 2020-06-10 | Giles | Virginia | 51071 | 5 | 0 |
230544 | 230544 | 2020-06-11 | Giles | Virginia | 51071 | 5 | 0 |
233649 | 233649 | 2020-06-12 | Giles | Virginia | 51071 | 5 | 0 |
236756 | 236756 | 2020-06-13 | Giles | Virginia | 51071 | 5 | 0 |
239864 | 239864 | 2020-06-14 | Giles | Virginia | 51071 | 6 | 0 |
242975 | 242975 | 2020-06-15 | Giles | Virginia | 51071 | 6 | 0 |
246088 | 246088 | 2020-06-16 | Giles | Virginia | 51071 | 6 | 0 |
249200 | 249200 | 2020-06-17 | Giles | Virginia | 51071 | 6 | 0 |
252315 | 252315 | 2020-06-18 | Giles | Virginia | 51071 | 6 | 0 |
255434 | 255434 | 2020-06-19 | Giles | Virginia | 51071 | 6 | 0 |
258561 | 258561 | 2020-06-20 | Giles | Virginia | 51071 | 7 | 0 |
261688 | 261688 | 2020-06-21 | Giles | Virginia | 51071 | 7 | 0 |
264817 | 264817 | 2020-06-22 | Giles | Virginia | 51071 | 7 | 0 |
267946 | 267946 | 2020-06-23 | Giles | Virginia | 51071 | 7 | 0 |
271080 | 271080 | 2020-06-24 | Giles | Virginia | 51071 | 7 | 0 |
274220 | 274220 | 2020-06-25 | Giles | Virginia | 51071 | 8 | 0 |
277368 | 277368 | 2020-06-26 | Giles | Virginia | 51071 | 8 | 0 |
280516 | 280516 | 2020-06-27 | Giles | Virginia | 51071 | 8 | 0 |
283662 | 283662 | 2020-06-28 | Giles | Virginia | 51071 | 13 | 0 |
286808 | 286808 | 2020-06-29 | Giles | Virginia | 51071 | 14 | 0 |
289958 | 289958 | 2020-06-30 | Giles | Virginia | 51071 | 15 | 0 |
293111 | 293111 | 2020-07-01 | Giles | Virginia | 51071 | 15 | 0 |
296266 | 296266 | 2020-07-02 | Giles | Virginia | 51071 | 17 | 0 |
299428 | 299428 | 2020-07-03 | Giles | Virginia | 51071 | 17 | 0 |
302592 | 302592 | 2020-07-04 | Giles | Virginia | 51071 | 18 | 0 |
305756 | 305756 | 2020-07-05 | Giles | Virginia | 51071 | 18 | 0 |
308924 | 308924 | 2020-07-06 | Giles | Virginia | 51071 | 18 | 0 |
312093 | 312093 | 2020-07-07 | Giles | Virginia | 51071 | 18 | 0 |
315268 | 315268 | 2020-07-08 | Giles | Virginia | 51071 | 18 | 0 |
318441 | 318441 | 2020-07-09 | Giles | Virginia | 51071 | 18 | 0 |
321620 | 321620 | 2020-07-10 | Giles | Virginia | 51071 | 18 | 0 |
324801 | 324801 | 2020-07-11 | Giles | Virginia | 51071 | 18 | 0 |
327986 | 327986 | 2020-07-12 | Giles | Virginia | 51071 | 18 | 0 |
331172 | 331172 | 2020-07-13 | Giles | Virginia | 51071 | 18 | 0 |
334365 | 334365 | 2020-07-14 | Giles | Virginia | 51071 | 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);