ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Wise" and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
30611 | 30611 | 2020-04-03 | Wise | Virginia | 51195 | 1 | 0 |
33011 | 33011 | 2020-04-04 | Wise | Virginia | 51195 | 1 | 0 |
35449 | 35449 | 2020-04-05 | Wise | Virginia | 51195 | 1 | 0 |
37933 | 37933 | 2020-04-06 | Wise | Virginia | 51195 | 1 | 0 |
40468 | 40468 | 2020-04-07 | Wise | Virginia | 51195 | 3 | 0 |
43037 | 43037 | 2020-04-08 | Wise | Virginia | 51195 | 4 | 0 |
45633 | 45633 | 2020-04-09 | Wise | Virginia | 51195 | 5 | 0 |
48260 | 48260 | 2020-04-10 | Wise | Virginia | 51195 | 8 | 0 |
50918 | 50918 | 2020-04-11 | Wise | Virginia | 51195 | 8 | 1 |
53593 | 53593 | 2020-04-12 | Wise | Virginia | 51195 | 8 | 1 |
56283 | 56283 | 2020-04-13 | Wise | Virginia | 51195 | 13 | 1 |
58989 | 58989 | 2020-04-14 | Wise | Virginia | 51195 | 14 | 1 |
61708 | 61708 | 2020-04-15 | Wise | Virginia | 51195 | 15 | 1 |
64441 | 64441 | 2020-04-16 | Wise | Virginia | 51195 | 18 | 1 |
67189 | 67189 | 2020-04-17 | Wise | Virginia | 51195 | 17 | 1 |
69951 | 69951 | 2020-04-18 | Wise | Virginia | 51195 | 18 | 1 |
72721 | 72721 | 2020-04-19 | Wise | Virginia | 51195 | 18 | 1 |
75497 | 75497 | 2020-04-20 | Wise | Virginia | 51195 | 18 | 1 |
78280 | 78280 | 2020-04-21 | Wise | Virginia | 51195 | 18 | 1 |
81073 | 81073 | 2020-04-22 | Wise | Virginia | 51195 | 18 | 1 |
83874 | 83874 | 2020-04-23 | Wise | Virginia | 51195 | 20 | 1 |
86681 | 86681 | 2020-04-24 | Wise | Virginia | 51195 | 20 | 1 |
89496 | 89496 | 2020-04-25 | Wise | Virginia | 51195 | 20 | 1 |
92313 | 92313 | 2020-04-26 | Wise | Virginia | 51195 | 20 | 1 |
95142 | 95142 | 2020-04-27 | Wise | Virginia | 51195 | 21 | 1 |
97987 | 97987 | 2020-04-28 | Wise | Virginia | 51195 | 22 | 1 |
100837 | 100837 | 2020-04-29 | Wise | Virginia | 51195 | 22 | 1 |
103692 | 103692 | 2020-04-30 | Wise | Virginia | 51195 | 22 | 1 |
106556 | 106556 | 2020-05-01 | Wise | Virginia | 51195 | 22 | 1 |
109425 | 109425 | 2020-05-02 | Wise | Virginia | 51195 | 22 | 1 |
112299 | 112299 | 2020-05-03 | Wise | Virginia | 51195 | 22 | 1 |
115182 | 115182 | 2020-05-04 | Wise | Virginia | 51195 | 22 | 1 |
118141 | 118141 | 2020-05-05 | Wise | Virginia | 51195 | 22 | 1 |
121105 | 121105 | 2020-05-06 | Wise | Virginia | 51195 | 22 | 1 |
124085 | 124085 | 2020-05-07 | Wise | Virginia | 51195 | 22 | 1 |
127070 | 127070 | 2020-05-08 | Wise | Virginia | 51195 | 22 | 1 |
130060 | 130060 | 2020-05-09 | Wise | Virginia | 51195 | 22 | 1 |
133050 | 133050 | 2020-05-10 | Wise | Virginia | 51195 | 22 | 1 |
136040 | 136040 | 2020-05-11 | Wise | Virginia | 51195 | 22 | 1 |
139031 | 139031 | 2020-05-12 | Wise | Virginia | 51195 | 22 | 1 |
142027 | 142027 | 2020-05-13 | Wise | Virginia | 51195 | 23 | 2 |
145024 | 145024 | 2020-05-14 | Wise | Virginia | 51195 | 23 | 2 |
148027 | 148027 | 2020-05-15 | Wise | Virginia | 51195 | 23 | 2 |
151036 | 151036 | 2020-05-16 | Wise | Virginia | 51195 | 23 | 2 |
154047 | 154047 | 2020-05-17 | Wise | Virginia | 51195 | 23 | 2 |
157064 | 157064 | 2020-05-18 | Wise | Virginia | 51195 | 23 | 2 |
160088 | 160088 | 2020-05-19 | Wise | Virginia | 51195 | 23 | 2 |
163116 | 163116 | 2020-05-20 | Wise | Virginia | 51195 | 23 | 2 |
166145 | 166145 | 2020-05-21 | Wise | Virginia | 51195 | 24 | 2 |
169181 | 169181 | 2020-05-22 | Wise | Virginia | 51195 | 24 | 2 |
172222 | 172222 | 2020-05-23 | Wise | Virginia | 51195 | 24 | 2 |
175265 | 175265 | 2020-05-24 | Wise | Virginia | 51195 | 24 | 2 |
178310 | 178310 | 2020-05-25 | Wise | Virginia | 51195 | 24 | 2 |
181354 | 181354 | 2020-05-26 | Wise | Virginia | 51195 | 24 | 2 |
184405 | 184405 | 2020-05-27 | Wise | Virginia | 51195 | 24 | 2 |
187462 | 187462 | 2020-05-28 | Wise | Virginia | 51195 | 24 | 2 |
190526 | 190526 | 2020-05-29 | Wise | Virginia | 51195 | 24 | 2 |
193592 | 193592 | 2020-05-30 | Wise | Virginia | 51195 | 24 | 2 |
196662 | 196662 | 2020-05-31 | Wise | Virginia | 51195 | 25 | 2 |
199735 | 199735 | 2020-06-01 | Wise | Virginia | 51195 | 25 | 2 |
202811 | 202811 | 2020-06-02 | Wise | Virginia | 51195 | 25 | 2 |
205890 | 205890 | 2020-06-03 | Wise | Virginia | 51195 | 25 | 2 |
208972 | 208972 | 2020-06-04 | Wise | Virginia | 51195 | 27 | 2 |
212057 | 212057 | 2020-06-05 | Wise | Virginia | 51195 | 27 | 2 |
215144 | 215144 | 2020-06-06 | Wise | Virginia | 51195 | 27 | 2 |
218234 | 218234 | 2020-06-07 | Wise | Virginia | 51195 | 27 | 2 |
221326 | 221326 | 2020-06-08 | Wise | Virginia | 51195 | 27 | 2 |
224422 | 224422 | 2020-06-09 | Wise | Virginia | 51195 | 27 | 2 |
227522 | 227522 | 2020-06-10 | Wise | Virginia | 51195 | 27 | 2 |
230626 | 230626 | 2020-06-11 | Wise | Virginia | 51195 | 27 | 2 |
233731 | 233731 | 2020-06-12 | Wise | Virginia | 51195 | 27 | 2 |
236838 | 236838 | 2020-06-13 | Wise | Virginia | 51195 | 27 | 2 |
239946 | 239946 | 2020-06-14 | Wise | Virginia | 51195 | 27 | 2 |
243057 | 243057 | 2020-06-15 | Wise | Virginia | 51195 | 27 | 2 |
246170 | 246170 | 2020-06-16 | Wise | Virginia | 51195 | 27 | 2 |
249282 | 249282 | 2020-06-17 | Wise | Virginia | 51195 | 27 | 2 |
252397 | 252397 | 2020-06-18 | Wise | Virginia | 51195 | 27 | 2 |
255516 | 255516 | 2020-06-19 | Wise | Virginia | 51195 | 27 | 2 |
258643 | 258643 | 2020-06-20 | Wise | Virginia | 51195 | 27 | 2 |
261770 | 261770 | 2020-06-21 | Wise | Virginia | 51195 | 27 | 2 |
264899 | 264899 | 2020-06-22 | Wise | Virginia | 51195 | 27 | 2 |
268028 | 268028 | 2020-06-23 | Wise | Virginia | 51195 | 27 | 2 |
271162 | 271162 | 2020-06-24 | Wise | Virginia | 51195 | 27 | 2 |
274302 | 274302 | 2020-06-25 | Wise | Virginia | 51195 | 27 | 2 |
277450 | 277450 | 2020-06-26 | Wise | Virginia | 51195 | 27 | 2 |
280598 | 280598 | 2020-06-27 | Wise | Virginia | 51195 | 27 | 2 |
283744 | 283744 | 2020-06-28 | Wise | Virginia | 51195 | 27 | 2 |
286890 | 286890 | 2020-06-29 | Wise | Virginia | 51195 | 27 | 2 |
290040 | 290040 | 2020-06-30 | Wise | Virginia | 51195 | 28 | 2 |
293193 | 293193 | 2020-07-01 | Wise | Virginia | 51195 | 28 | 2 |
296348 | 296348 | 2020-07-02 | Wise | Virginia | 51195 | 28 | 2 |
299510 | 299510 | 2020-07-03 | Wise | Virginia | 51195 | 29 | 2 |
302674 | 302674 | 2020-07-04 | Wise | Virginia | 51195 | 30 | 2 |
305838 | 305838 | 2020-07-05 | Wise | Virginia | 51195 | 30 | 2 |
309006 | 309006 | 2020-07-06 | Wise | Virginia | 51195 | 32 | 2 |
312175 | 312175 | 2020-07-07 | Wise | Virginia | 51195 | 32 | 2 |
315350 | 315350 | 2020-07-08 | Wise | Virginia | 51195 | 33 | 2 |
318523 | 318523 | 2020-07-09 | Wise | Virginia | 51195 | 34 | 2 |
321702 | 321702 | 2020-07-10 | Wise | Virginia | 51195 | 36 | 2 |
324883 | 324883 | 2020-07-11 | Wise | Virginia | 51195 | 38 | 2 |
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);