ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Rockbridge" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388941 | 388941 | 2020-07-31 | Rockbridge | Virginia | 51163 | 66 | 0 |
385724 | 385724 | 2020-07-30 | Rockbridge | Virginia | 51163 | 65 | 0 |
382506 | 382506 | 2020-07-29 | Rockbridge | Virginia | 51163 | 63 | 0 |
379289 | 379289 | 2020-07-28 | Rockbridge | Virginia | 51163 | 62 | 0 |
376073 | 376073 | 2020-07-27 | Rockbridge | Virginia | 51163 | 62 | 0 |
372859 | 372859 | 2020-07-26 | Rockbridge | Virginia | 51163 | 62 | 0 |
369647 | 369647 | 2020-07-25 | Rockbridge | Virginia | 51163 | 57 | 0 |
366438 | 366438 | 2020-07-24 | Rockbridge | Virginia | 51163 | 54 | 0 |
363232 | 363232 | 2020-07-23 | Rockbridge | Virginia | 51163 | 51 | 0 |
360026 | 360026 | 2020-07-22 | Rockbridge | Virginia | 51163 | 51 | 0 |
356821 | 356821 | 2020-07-21 | Rockbridge | Virginia | 51163 | 47 | 0 |
353618 | 353618 | 2020-07-20 | Rockbridge | Virginia | 51163 | 47 | 0 |
350416 | 350416 | 2020-07-19 | Rockbridge | Virginia | 51163 | 46 | 0 |
347215 | 347215 | 2020-07-18 | Rockbridge | Virginia | 51163 | 46 | 0 |
344015 | 344015 | 2020-07-17 | Rockbridge | Virginia | 51163 | 42 | 0 |
340816 | 340816 | 2020-07-16 | Rockbridge | Virginia | 51163 | 41 | 0 |
337620 | 337620 | 2020-07-15 | Rockbridge | Virginia | 51163 | 41 | 0 |
334425 | 334425 | 2020-07-14 | Rockbridge | Virginia | 51163 | 36 | 0 |
331232 | 331232 | 2020-07-13 | Rockbridge | Virginia | 51163 | 35 | 0 |
328046 | 328046 | 2020-07-12 | Rockbridge | Virginia | 51163 | 35 | 0 |
324861 | 324861 | 2020-07-11 | Rockbridge | Virginia | 51163 | 34 | 0 |
321680 | 321680 | 2020-07-10 | Rockbridge | Virginia | 51163 | 32 | 0 |
318501 | 318501 | 2020-07-09 | Rockbridge | Virginia | 51163 | 33 | 0 |
315328 | 315328 | 2020-07-08 | Rockbridge | Virginia | 51163 | 33 | 0 |
312153 | 312153 | 2020-07-07 | Rockbridge | Virginia | 51163 | 33 | 0 |
308984 | 308984 | 2020-07-06 | Rockbridge | Virginia | 51163 | 33 | 0 |
305816 | 305816 | 2020-07-05 | Rockbridge | Virginia | 51163 | 33 | 0 |
302652 | 302652 | 2020-07-04 | Rockbridge | Virginia | 51163 | 33 | 0 |
299488 | 299488 | 2020-07-03 | Rockbridge | Virginia | 51163 | 32 | 0 |
296326 | 296326 | 2020-07-02 | Rockbridge | Virginia | 51163 | 32 | 0 |
293171 | 293171 | 2020-07-01 | Rockbridge | Virginia | 51163 | 31 | 0 |
290018 | 290018 | 2020-06-30 | Rockbridge | Virginia | 51163 | 30 | 0 |
286868 | 286868 | 2020-06-29 | Rockbridge | Virginia | 51163 | 30 | 0 |
283722 | 283722 | 2020-06-28 | Rockbridge | Virginia | 51163 | 30 | 0 |
280576 | 280576 | 2020-06-27 | Rockbridge | Virginia | 51163 | 29 | 0 |
277428 | 277428 | 2020-06-26 | Rockbridge | Virginia | 51163 | 28 | 0 |
274280 | 274280 | 2020-06-25 | Rockbridge | Virginia | 51163 | 27 | 0 |
271140 | 271140 | 2020-06-24 | Rockbridge | Virginia | 51163 | 24 | 0 |
268006 | 268006 | 2020-06-23 | Rockbridge | Virginia | 51163 | 23 | 0 |
264877 | 264877 | 2020-06-22 | Rockbridge | Virginia | 51163 | 21 | 0 |
261748 | 261748 | 2020-06-21 | Rockbridge | Virginia | 51163 | 18 | 0 |
258621 | 258621 | 2020-06-20 | Rockbridge | Virginia | 51163 | 18 | 0 |
255494 | 255494 | 2020-06-19 | Rockbridge | Virginia | 51163 | 18 | 0 |
252375 | 252375 | 2020-06-18 | Rockbridge | Virginia | 51163 | 18 | 0 |
249260 | 249260 | 2020-06-17 | Rockbridge | Virginia | 51163 | 18 | 0 |
246148 | 246148 | 2020-06-16 | Rockbridge | Virginia | 51163 | 18 | 0 |
243035 | 243035 | 2020-06-15 | Rockbridge | Virginia | 51163 | 19 | 0 |
239924 | 239924 | 2020-06-14 | Rockbridge | Virginia | 51163 | 19 | 0 |
236816 | 236816 | 2020-06-13 | Rockbridge | Virginia | 51163 | 19 | 0 |
233709 | 233709 | 2020-06-12 | Rockbridge | Virginia | 51163 | 19 | 0 |
230604 | 230604 | 2020-06-11 | Rockbridge | Virginia | 51163 | 19 | 0 |
227500 | 227500 | 2020-06-10 | Rockbridge | Virginia | 51163 | 19 | 0 |
224400 | 224400 | 2020-06-09 | Rockbridge | Virginia | 51163 | 19 | 0 |
221304 | 221304 | 2020-06-08 | Rockbridge | Virginia | 51163 | 20 | 0 |
218212 | 218212 | 2020-06-07 | Rockbridge | Virginia | 51163 | 19 | 0 |
215122 | 215122 | 2020-06-06 | Rockbridge | Virginia | 51163 | 18 | 0 |
212035 | 212035 | 2020-06-05 | Rockbridge | Virginia | 51163 | 18 | 0 |
208950 | 208950 | 2020-06-04 | Rockbridge | Virginia | 51163 | 18 | 0 |
205868 | 205868 | 2020-06-03 | Rockbridge | Virginia | 51163 | 19 | 0 |
202789 | 202789 | 2020-06-02 | Rockbridge | Virginia | 51163 | 19 | 0 |
199713 | 199713 | 2020-06-01 | Rockbridge | Virginia | 51163 | 18 | 0 |
196640 | 196640 | 2020-05-31 | Rockbridge | Virginia | 51163 | 18 | 0 |
193570 | 193570 | 2020-05-30 | Rockbridge | Virginia | 51163 | 18 | 0 |
190504 | 190504 | 2020-05-29 | Rockbridge | Virginia | 51163 | 16 | 0 |
187440 | 187440 | 2020-05-28 | Rockbridge | Virginia | 51163 | 16 | 0 |
184383 | 184383 | 2020-05-27 | Rockbridge | Virginia | 51163 | 17 | 0 |
181332 | 181332 | 2020-05-26 | Rockbridge | Virginia | 51163 | 17 | 0 |
178288 | 178288 | 2020-05-25 | Rockbridge | Virginia | 51163 | 16 | 0 |
175243 | 175243 | 2020-05-24 | Rockbridge | Virginia | 51163 | 14 | 0 |
172200 | 172200 | 2020-05-23 | Rockbridge | Virginia | 51163 | 14 | 0 |
169159 | 169159 | 2020-05-22 | Rockbridge | Virginia | 51163 | 13 | 0 |
166123 | 166123 | 2020-05-21 | Rockbridge | Virginia | 51163 | 12 | 0 |
163094 | 163094 | 2020-05-20 | Rockbridge | Virginia | 51163 | 13 | 0 |
160066 | 160066 | 2020-05-19 | Rockbridge | Virginia | 51163 | 13 | 0 |
157042 | 157042 | 2020-05-18 | Rockbridge | Virginia | 51163 | 11 | 0 |
154025 | 154025 | 2020-05-17 | Rockbridge | Virginia | 51163 | 11 | 0 |
151014 | 151014 | 2020-05-16 | Rockbridge | Virginia | 51163 | 11 | 0 |
148005 | 148005 | 2020-05-15 | Rockbridge | Virginia | 51163 | 10 | 0 |
145002 | 145002 | 2020-05-14 | Rockbridge | Virginia | 51163 | 11 | 0 |
142005 | 142005 | 2020-05-13 | Rockbridge | Virginia | 51163 | 11 | 0 |
139009 | 139009 | 2020-05-12 | Rockbridge | Virginia | 51163 | 9 | 0 |
136018 | 136018 | 2020-05-11 | Rockbridge | Virginia | 51163 | 9 | 0 |
133028 | 133028 | 2020-05-10 | Rockbridge | Virginia | 51163 | 9 | 0 |
130038 | 130038 | 2020-05-09 | Rockbridge | Virginia | 51163 | 9 | 0 |
127048 | 127048 | 2020-05-08 | Rockbridge | Virginia | 51163 | 8 | 0 |
124063 | 124063 | 2020-05-07 | Rockbridge | Virginia | 51163 | 8 | 0 |
121082 | 121082 | 2020-05-06 | Rockbridge | Virginia | 51163 | 8 | 0 |
118118 | 118118 | 2020-05-05 | Rockbridge | Virginia | 51163 | 8 | 0 |
115159 | 115159 | 2020-05-04 | Rockbridge | Virginia | 51163 | 7 | 0 |
112276 | 112276 | 2020-05-03 | Rockbridge | Virginia | 51163 | 7 | 0 |
109402 | 109402 | 2020-05-02 | Rockbridge | Virginia | 51163 | 7 | 0 |
106533 | 106533 | 2020-05-01 | Rockbridge | Virginia | 51163 | 7 | 0 |
103669 | 103669 | 2020-04-30 | Rockbridge | Virginia | 51163 | 6 | 0 |
100814 | 100814 | 2020-04-29 | Rockbridge | Virginia | 51163 | 5 | 0 |
97964 | 97964 | 2020-04-28 | Rockbridge | Virginia | 51163 | 5 | 0 |
95120 | 95120 | 2020-04-27 | Rockbridge | Virginia | 51163 | 5 | 0 |
92291 | 92291 | 2020-04-26 | Rockbridge | Virginia | 51163 | 5 | 0 |
89474 | 89474 | 2020-04-25 | Rockbridge | Virginia | 51163 | 5 | 0 |
86659 | 86659 | 2020-04-24 | Rockbridge | Virginia | 51163 | 5 | 0 |
83852 | 83852 | 2020-04-23 | Rockbridge | Virginia | 51163 | 5 | 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);