ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
752 rows where county = "Highland" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
81004 | 81004 | 2020-04-22 | Highland | Virginia | 51091 | 1 | 0 |
83805 | 83805 | 2020-04-23 | Highland | Virginia | 51091 | 1 | 0 |
86612 | 86612 | 2020-04-24 | Highland | Virginia | 51091 | 1 | 0 |
89427 | 89427 | 2020-04-25 | Highland | Virginia | 51091 | 1 | 0 |
92244 | 92244 | 2020-04-26 | Highland | Virginia | 51091 | 1 | 0 |
95073 | 95073 | 2020-04-27 | Highland | Virginia | 51091 | 1 | 0 |
97916 | 97916 | 2020-04-28 | Highland | Virginia | 51091 | 2 | 0 |
100766 | 100766 | 2020-04-29 | Highland | Virginia | 51091 | 2 | 0 |
103621 | 103621 | 2020-04-30 | Highland | Virginia | 51091 | 2 | 0 |
106485 | 106485 | 2020-05-01 | Highland | Virginia | 51091 | 2 | 0 |
109354 | 109354 | 2020-05-02 | Highland | Virginia | 51091 | 2 | 0 |
112228 | 112228 | 2020-05-03 | Highland | Virginia | 51091 | 2 | 0 |
115111 | 115111 | 2020-05-04 | Highland | Virginia | 51091 | 2 | 0 |
118070 | 118070 | 2020-05-05 | Highland | Virginia | 51091 | 2 | 0 |
121034 | 121034 | 2020-05-06 | Highland | Virginia | 51091 | 2 | 0 |
124015 | 124015 | 2020-05-07 | Highland | Virginia | 51091 | 2 | 0 |
127000 | 127000 | 2020-05-08 | Highland | Virginia | 51091 | 2 | 0 |
129990 | 129990 | 2020-05-09 | Highland | Virginia | 51091 | 2 | 0 |
132980 | 132980 | 2020-05-10 | Highland | Virginia | 51091 | 2 | 0 |
135970 | 135970 | 2020-05-11 | Highland | Virginia | 51091 | 2 | 0 |
138961 | 138961 | 2020-05-12 | Highland | Virginia | 51091 | 2 | 0 |
141957 | 141957 | 2020-05-13 | Highland | Virginia | 51091 | 2 | 0 |
144954 | 144954 | 2020-05-14 | Highland | Virginia | 51091 | 2 | 0 |
147957 | 147957 | 2020-05-15 | Highland | Virginia | 51091 | 2 | 0 |
150966 | 150966 | 2020-05-16 | Highland | Virginia | 51091 | 2 | 0 |
153977 | 153977 | 2020-05-17 | Highland | Virginia | 51091 | 2 | 0 |
156994 | 156994 | 2020-05-18 | Highland | Virginia | 51091 | 2 | 0 |
160018 | 160018 | 2020-05-19 | Highland | Virginia | 51091 | 2 | 0 |
163046 | 163046 | 2020-05-20 | Highland | Virginia | 51091 | 2 | 0 |
166075 | 166075 | 2020-05-21 | Highland | Virginia | 51091 | 3 | 0 |
169111 | 169111 | 2020-05-22 | Highland | Virginia | 51091 | 3 | 0 |
172152 | 172152 | 2020-05-23 | Highland | Virginia | 51091 | 3 | 0 |
175195 | 175195 | 2020-05-24 | Highland | Virginia | 51091 | 3 | 0 |
178240 | 178240 | 2020-05-25 | Highland | Virginia | 51091 | 3 | 0 |
181284 | 181284 | 2020-05-26 | Highland | Virginia | 51091 | 3 | 0 |
184335 | 184335 | 2020-05-27 | Highland | Virginia | 51091 | 3 | 0 |
187392 | 187392 | 2020-05-28 | Highland | Virginia | 51091 | 3 | 0 |
190456 | 190456 | 2020-05-29 | Highland | Virginia | 51091 | 3 | 0 |
193522 | 193522 | 2020-05-30 | Highland | Virginia | 51091 | 3 | 0 |
196592 | 196592 | 2020-05-31 | Highland | Virginia | 51091 | 3 | 0 |
199665 | 199665 | 2020-06-01 | Highland | Virginia | 51091 | 3 | 0 |
202741 | 202741 | 2020-06-02 | Highland | Virginia | 51091 | 3 | 0 |
205820 | 205820 | 2020-06-03 | Highland | Virginia | 51091 | 3 | 0 |
208902 | 208902 | 2020-06-04 | Highland | Virginia | 51091 | 3 | 0 |
211987 | 211987 | 2020-06-05 | Highland | Virginia | 51091 | 3 | 0 |
215074 | 215074 | 2020-06-06 | Highland | Virginia | 51091 | 3 | 0 |
218164 | 218164 | 2020-06-07 | Highland | Virginia | 51091 | 3 | 0 |
221256 | 221256 | 2020-06-08 | Highland | Virginia | 51091 | 3 | 0 |
224352 | 224352 | 2020-06-09 | Highland | Virginia | 51091 | 3 | 0 |
227452 | 227452 | 2020-06-10 | Highland | Virginia | 51091 | 2 | 0 |
230556 | 230556 | 2020-06-11 | Highland | Virginia | 51091 | 2 | 0 |
233661 | 233661 | 2020-06-12 | Highland | Virginia | 51091 | 2 | 0 |
236768 | 236768 | 2020-06-13 | Highland | Virginia | 51091 | 2 | 0 |
239876 | 239876 | 2020-06-14 | Highland | Virginia | 51091 | 3 | 0 |
242987 | 242987 | 2020-06-15 | Highland | Virginia | 51091 | 3 | 0 |
246100 | 246100 | 2020-06-16 | Highland | Virginia | 51091 | 3 | 0 |
249212 | 249212 | 2020-06-17 | Highland | Virginia | 51091 | 3 | 0 |
252327 | 252327 | 2020-06-18 | Highland | Virginia | 51091 | 3 | 0 |
255446 | 255446 | 2020-06-19 | Highland | Virginia | 51091 | 3 | 0 |
258573 | 258573 | 2020-06-20 | Highland | Virginia | 51091 | 3 | 0 |
261700 | 261700 | 2020-06-21 | Highland | Virginia | 51091 | 3 | 0 |
264829 | 264829 | 2020-06-22 | Highland | Virginia | 51091 | 3 | 0 |
267958 | 267958 | 2020-06-23 | Highland | Virginia | 51091 | 3 | 0 |
271092 | 271092 | 2020-06-24 | Highland | Virginia | 51091 | 3 | 0 |
274232 | 274232 | 2020-06-25 | Highland | Virginia | 51091 | 3 | 0 |
277380 | 277380 | 2020-06-26 | Highland | Virginia | 51091 | 3 | 0 |
280528 | 280528 | 2020-06-27 | Highland | Virginia | 51091 | 3 | 0 |
283674 | 283674 | 2020-06-28 | Highland | Virginia | 51091 | 3 | 0 |
286820 | 286820 | 2020-06-29 | Highland | Virginia | 51091 | 3 | 0 |
289970 | 289970 | 2020-06-30 | Highland | Virginia | 51091 | 3 | 0 |
293123 | 293123 | 2020-07-01 | Highland | Virginia | 51091 | 3 | 0 |
296278 | 296278 | 2020-07-02 | Highland | Virginia | 51091 | 3 | 0 |
299440 | 299440 | 2020-07-03 | Highland | Virginia | 51091 | 3 | 0 |
302604 | 302604 | 2020-07-04 | Highland | Virginia | 51091 | 3 | 0 |
305768 | 305768 | 2020-07-05 | Highland | Virginia | 51091 | 3 | 0 |
308936 | 308936 | 2020-07-06 | Highland | Virginia | 51091 | 3 | 0 |
312105 | 312105 | 2020-07-07 | Highland | Virginia | 51091 | 3 | 0 |
315280 | 315280 | 2020-07-08 | Highland | Virginia | 51091 | 3 | 0 |
318453 | 318453 | 2020-07-09 | Highland | Virginia | 51091 | 3 | 0 |
321632 | 321632 | 2020-07-10 | Highland | Virginia | 51091 | 3 | 0 |
324813 | 324813 | 2020-07-11 | Highland | Virginia | 51091 | 3 | 0 |
327998 | 327998 | 2020-07-12 | Highland | Virginia | 51091 | 3 | 0 |
331184 | 331184 | 2020-07-13 | Highland | Virginia | 51091 | 3 | 0 |
334377 | 334377 | 2020-07-14 | Highland | Virginia | 51091 | 3 | 0 |
337572 | 337572 | 2020-07-15 | Highland | Virginia | 51091 | 3 | 0 |
340768 | 340768 | 2020-07-16 | Highland | Virginia | 51091 | 3 | 0 |
343967 | 343967 | 2020-07-17 | Highland | Virginia | 51091 | 3 | 0 |
347167 | 347167 | 2020-07-18 | Highland | Virginia | 51091 | 3 | 0 |
350368 | 350368 | 2020-07-19 | Highland | Virginia | 51091 | 3 | 0 |
353570 | 353570 | 2020-07-20 | Highland | Virginia | 51091 | 3 | 0 |
356773 | 356773 | 2020-07-21 | Highland | Virginia | 51091 | 3 | 0 |
359978 | 359978 | 2020-07-22 | Highland | Virginia | 51091 | 3 | 0 |
363184 | 363184 | 2020-07-23 | Highland | Virginia | 51091 | 3 | 0 |
366390 | 366390 | 2020-07-24 | Highland | Virginia | 51091 | 3 | 0 |
369599 | 369599 | 2020-07-25 | Highland | Virginia | 51091 | 3 | 0 |
372811 | 372811 | 2020-07-26 | Highland | Virginia | 51091 | 3 | 0 |
376025 | 376025 | 2020-07-27 | Highland | Virginia | 51091 | 3 | 0 |
379241 | 379241 | 2020-07-28 | Highland | Virginia | 51091 | 3 | 0 |
382458 | 382458 | 2020-07-29 | Highland | Virginia | 51091 | 3 | 0 |
385676 | 385676 | 2020-07-30 | Highland | Virginia | 51091 | 3 | 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);