ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Buckingham" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388849 | 388849 | 2020-07-31 | Buckingham | Virginia | 51029 | 593 | 6 |
385632 | 385632 | 2020-07-30 | Buckingham | Virginia | 51029 | 592 | 6 |
382414 | 382414 | 2020-07-29 | Buckingham | Virginia | 51029 | 592 | 6 |
379197 | 379197 | 2020-07-28 | Buckingham | Virginia | 51029 | 592 | 6 |
375981 | 375981 | 2020-07-27 | Buckingham | Virginia | 51029 | 592 | 6 |
372767 | 372767 | 2020-07-26 | Buckingham | Virginia | 51029 | 592 | 6 |
369555 | 369555 | 2020-07-25 | Buckingham | Virginia | 51029 | 591 | 6 |
366346 | 366346 | 2020-07-24 | Buckingham | Virginia | 51029 | 590 | 6 |
363140 | 363140 | 2020-07-23 | Buckingham | Virginia | 51029 | 590 | 6 |
359934 | 359934 | 2020-07-22 | Buckingham | Virginia | 51029 | 587 | 6 |
356729 | 356729 | 2020-07-21 | Buckingham | Virginia | 51029 | 587 | 6 |
353526 | 353526 | 2020-07-20 | Buckingham | Virginia | 51029 | 584 | 6 |
350324 | 350324 | 2020-07-19 | Buckingham | Virginia | 51029 | 582 | 6 |
347123 | 347123 | 2020-07-18 | Buckingham | Virginia | 51029 | 579 | 6 |
343923 | 343923 | 2020-07-17 | Buckingham | Virginia | 51029 | 579 | 6 |
340724 | 340724 | 2020-07-16 | Buckingham | Virginia | 51029 | 578 | 6 |
337528 | 337528 | 2020-07-15 | Buckingham | Virginia | 51029 | 577 | 6 |
334333 | 334333 | 2020-07-14 | Buckingham | Virginia | 51029 | 577 | 6 |
331140 | 331140 | 2020-07-13 | Buckingham | Virginia | 51029 | 577 | 6 |
327954 | 327954 | 2020-07-12 | Buckingham | Virginia | 51029 | 577 | 6 |
324769 | 324769 | 2020-07-11 | Buckingham | Virginia | 51029 | 576 | 6 |
321588 | 321588 | 2020-07-10 | Buckingham | Virginia | 51029 | 574 | 6 |
318409 | 318409 | 2020-07-09 | Buckingham | Virginia | 51029 | 572 | 6 |
315236 | 315236 | 2020-07-08 | Buckingham | Virginia | 51029 | 571 | 5 |
312061 | 312061 | 2020-07-07 | Buckingham | Virginia | 51029 | 570 | 5 |
308892 | 308892 | 2020-07-06 | Buckingham | Virginia | 51029 | 571 | 4 |
305724 | 305724 | 2020-07-05 | Buckingham | Virginia | 51029 | 566 | 4 |
302560 | 302560 | 2020-07-04 | Buckingham | Virginia | 51029 | 566 | 4 |
299396 | 299396 | 2020-07-03 | Buckingham | Virginia | 51029 | 566 | 4 |
296234 | 296234 | 2020-07-02 | Buckingham | Virginia | 51029 | 560 | 4 |
293079 | 293079 | 2020-07-01 | Buckingham | Virginia | 51029 | 559 | 4 |
289926 | 289926 | 2020-06-30 | Buckingham | Virginia | 51029 | 556 | 4 |
286776 | 286776 | 2020-06-29 | Buckingham | Virginia | 51029 | 556 | 4 |
283630 | 283630 | 2020-06-28 | Buckingham | Virginia | 51029 | 556 | 4 |
280484 | 280484 | 2020-06-27 | Buckingham | Virginia | 51029 | 556 | 4 |
277336 | 277336 | 2020-06-26 | Buckingham | Virginia | 51029 | 555 | 4 |
274188 | 274188 | 2020-06-25 | Buckingham | Virginia | 51029 | 555 | 4 |
271048 | 271048 | 2020-06-24 | Buckingham | Virginia | 51029 | 553 | 4 |
267914 | 267914 | 2020-06-23 | Buckingham | Virginia | 51029 | 553 | 4 |
264785 | 264785 | 2020-06-22 | Buckingham | Virginia | 51029 | 553 | 3 |
261656 | 261656 | 2020-06-21 | Buckingham | Virginia | 51029 | 552 | 3 |
258529 | 258529 | 2020-06-20 | Buckingham | Virginia | 51029 | 552 | 3 |
255402 | 255402 | 2020-06-19 | Buckingham | Virginia | 51029 | 552 | 3 |
252283 | 252283 | 2020-06-18 | Buckingham | Virginia | 51029 | 552 | 3 |
249168 | 249168 | 2020-06-17 | Buckingham | Virginia | 51029 | 542 | 3 |
246056 | 246056 | 2020-06-16 | Buckingham | Virginia | 51029 | 534 | 3 |
242944 | 242944 | 2020-06-15 | Buckingham | Virginia | 51029 | 521 | 3 |
239833 | 239833 | 2020-06-14 | Buckingham | Virginia | 51029 | 519 | 3 |
236725 | 236725 | 2020-06-13 | Buckingham | Virginia | 51029 | 519 | 3 |
233618 | 233618 | 2020-06-12 | Buckingham | Virginia | 51029 | 518 | 3 |
230513 | 230513 | 2020-06-11 | Buckingham | Virginia | 51029 | 517 | 3 |
227409 | 227409 | 2020-06-10 | Buckingham | Virginia | 51029 | 497 | 3 |
224309 | 224309 | 2020-06-09 | Buckingham | Virginia | 51029 | 484 | 3 |
221213 | 221213 | 2020-06-08 | Buckingham | Virginia | 51029 | 481 | 3 |
218121 | 218121 | 2020-06-07 | Buckingham | Virginia | 51029 | 481 | 3 |
215031 | 215031 | 2020-06-06 | Buckingham | Virginia | 51029 | 477 | 3 |
211944 | 211944 | 2020-06-05 | Buckingham | Virginia | 51029 | 475 | 3 |
208859 | 208859 | 2020-06-04 | Buckingham | Virginia | 51029 | 469 | 3 |
205777 | 205777 | 2020-06-03 | Buckingham | Virginia | 51029 | 467 | 3 |
202698 | 202698 | 2020-06-02 | Buckingham | Virginia | 51029 | 465 | 3 |
199622 | 199622 | 2020-06-01 | Buckingham | Virginia | 51029 | 461 | 3 |
196549 | 196549 | 2020-05-31 | Buckingham | Virginia | 51029 | 459 | 3 |
193479 | 193479 | 2020-05-30 | Buckingham | Virginia | 51029 | 456 | 3 |
190413 | 190413 | 2020-05-29 | Buckingham | Virginia | 51029 | 453 | 3 |
187349 | 187349 | 2020-05-28 | Buckingham | Virginia | 51029 | 453 | 3 |
184292 | 184292 | 2020-05-27 | Buckingham | Virginia | 51029 | 445 | 3 |
181241 | 181241 | 2020-05-26 | Buckingham | Virginia | 51029 | 445 | 3 |
178197 | 178197 | 2020-05-25 | Buckingham | Virginia | 51029 | 443 | 3 |
175152 | 175152 | 2020-05-24 | Buckingham | Virginia | 51029 | 442 | 2 |
172109 | 172109 | 2020-05-23 | Buckingham | Virginia | 51029 | 443 | 2 |
169068 | 169068 | 2020-05-22 | Buckingham | Virginia | 51029 | 439 | 2 |
166032 | 166032 | 2020-05-21 | Buckingham | Virginia | 51029 | 438 | 2 |
163003 | 163003 | 2020-05-20 | Buckingham | Virginia | 51029 | 419 | 2 |
159975 | 159975 | 2020-05-19 | Buckingham | Virginia | 51029 | 419 | 2 |
156951 | 156951 | 2020-05-18 | Buckingham | Virginia | 51029 | 417 | 2 |
153934 | 153934 | 2020-05-17 | Buckingham | Virginia | 51029 | 411 | 2 |
150923 | 150923 | 2020-05-16 | Buckingham | Virginia | 51029 | 411 | 2 |
147914 | 147914 | 2020-05-15 | Buckingham | Virginia | 51029 | 366 | 2 |
144911 | 144911 | 2020-05-14 | Buckingham | Virginia | 51029 | 348 | 2 |
141914 | 141914 | 2020-05-13 | Buckingham | Virginia | 51029 | 347 | 2 |
138918 | 138918 | 2020-05-12 | Buckingham | Virginia | 51029 | 301 | 2 |
135927 | 135927 | 2020-05-11 | Buckingham | Virginia | 51029 | 246 | 1 |
132937 | 132937 | 2020-05-10 | Buckingham | Virginia | 51029 | 246 | 1 |
129947 | 129947 | 2020-05-09 | Buckingham | Virginia | 51029 | 246 | 1 |
126958 | 126958 | 2020-05-08 | Buckingham | Virginia | 51029 | 225 | 1 |
123973 | 123973 | 2020-05-07 | Buckingham | Virginia | 51029 | 225 | 0 |
120992 | 120992 | 2020-05-06 | Buckingham | Virginia | 51029 | 171 | 0 |
118028 | 118028 | 2020-05-05 | Buckingham | Virginia | 51029 | 171 | 0 |
115069 | 115069 | 2020-05-04 | Buckingham | Virginia | 51029 | 137 | 0 |
112186 | 112186 | 2020-05-03 | Buckingham | Virginia | 51029 | 137 | 0 |
109312 | 109312 | 2020-05-02 | Buckingham | Virginia | 51029 | 137 | 0 |
106443 | 106443 | 2020-05-01 | Buckingham | Virginia | 51029 | 94 | 0 |
103579 | 103579 | 2020-04-30 | Buckingham | Virginia | 51029 | 58 | 0 |
100724 | 100724 | 2020-04-29 | Buckingham | Virginia | 51029 | 55 | 0 |
97874 | 97874 | 2020-04-28 | Buckingham | Virginia | 51029 | 55 | 0 |
95032 | 95032 | 2020-04-27 | Buckingham | Virginia | 51029 | 45 | 0 |
92203 | 92203 | 2020-04-26 | Buckingham | Virginia | 51029 | 35 | 0 |
89386 | 89386 | 2020-04-25 | Buckingham | Virginia | 51029 | 34 | 0 |
86571 | 86571 | 2020-04-24 | Buckingham | Virginia | 51029 | 31 | 0 |
83764 | 83764 | 2020-04-23 | Buckingham | Virginia | 51029 | 31 | 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);