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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23670 | 23670 | 2020-03-31 | Buckingham | Virginia | 51029 | 2 | 0 |
25886 | 25886 | 2020-04-01 | Buckingham | Virginia | 51029 | 2 | 0 |
28175 | 28175 | 2020-04-02 | Buckingham | Virginia | 51029 | 2 | 0 |
30518 | 30518 | 2020-04-03 | Buckingham | Virginia | 51029 | 3 | 0 |
32916 | 32916 | 2020-04-04 | Buckingham | Virginia | 51029 | 4 | 0 |
35354 | 35354 | 2020-04-05 | Buckingham | Virginia | 51029 | 4 | 0 |
37836 | 37836 | 2020-04-06 | Buckingham | Virginia | 51029 | 4 | 0 |
40367 | 40367 | 2020-04-07 | Buckingham | Virginia | 51029 | 6 | 0 |
42936 | 42936 | 2020-04-08 | Buckingham | Virginia | 51029 | 9 | 0 |
45530 | 45530 | 2020-04-09 | Buckingham | Virginia | 51029 | 9 | 0 |
48154 | 48154 | 2020-04-10 | Buckingham | Virginia | 51029 | 10 | 0 |
50812 | 50812 | 2020-04-11 | Buckingham | Virginia | 51029 | 14 | 0 |
53487 | 53487 | 2020-04-12 | Buckingham | Virginia | 51029 | 14 | 0 |
56176 | 56176 | 2020-04-13 | Buckingham | Virginia | 51029 | 16 | 0 |
58882 | 58882 | 2020-04-14 | Buckingham | Virginia | 51029 | 18 | 0 |
61601 | 61601 | 2020-04-15 | Buckingham | Virginia | 51029 | 22 | 0 |
64333 | 64333 | 2020-04-16 | Buckingham | Virginia | 51029 | 23 | 0 |
67081 | 67081 | 2020-04-17 | Buckingham | Virginia | 51029 | 24 | 0 |
69843 | 69843 | 2020-04-18 | Buckingham | Virginia | 51029 | 25 | 0 |
72613 | 72613 | 2020-04-19 | Buckingham | Virginia | 51029 | 26 | 0 |
75389 | 75389 | 2020-04-20 | Buckingham | Virginia | 51029 | 26 | 0 |
78171 | 78171 | 2020-04-21 | Buckingham | Virginia | 51029 | 27 | 0 |
80963 | 80963 | 2020-04-22 | Buckingham | Virginia | 51029 | 27 | 0 |
83764 | 83764 | 2020-04-23 | Buckingham | Virginia | 51029 | 31 | 0 |
86571 | 86571 | 2020-04-24 | Buckingham | Virginia | 51029 | 31 | 0 |
89386 | 89386 | 2020-04-25 | Buckingham | Virginia | 51029 | 34 | 0 |
92203 | 92203 | 2020-04-26 | Buckingham | Virginia | 51029 | 35 | 0 |
95032 | 95032 | 2020-04-27 | Buckingham | Virginia | 51029 | 45 | 0 |
97874 | 97874 | 2020-04-28 | Buckingham | Virginia | 51029 | 55 | 0 |
100724 | 100724 | 2020-04-29 | Buckingham | Virginia | 51029 | 55 | 0 |
103579 | 103579 | 2020-04-30 | Buckingham | Virginia | 51029 | 58 | 0 |
106443 | 106443 | 2020-05-01 | Buckingham | Virginia | 51029 | 94 | 0 |
109312 | 109312 | 2020-05-02 | Buckingham | Virginia | 51029 | 137 | 0 |
112186 | 112186 | 2020-05-03 | Buckingham | Virginia | 51029 | 137 | 0 |
115069 | 115069 | 2020-05-04 | Buckingham | Virginia | 51029 | 137 | 0 |
118028 | 118028 | 2020-05-05 | Buckingham | Virginia | 51029 | 171 | 0 |
120992 | 120992 | 2020-05-06 | Buckingham | Virginia | 51029 | 171 | 0 |
123973 | 123973 | 2020-05-07 | Buckingham | Virginia | 51029 | 225 | 0 |
126958 | 126958 | 2020-05-08 | Buckingham | Virginia | 51029 | 225 | 1 |
129947 | 129947 | 2020-05-09 | Buckingham | Virginia | 51029 | 246 | 1 |
132937 | 132937 | 2020-05-10 | Buckingham | Virginia | 51029 | 246 | 1 |
135927 | 135927 | 2020-05-11 | Buckingham | Virginia | 51029 | 246 | 1 |
138918 | 138918 | 2020-05-12 | Buckingham | Virginia | 51029 | 301 | 2 |
141914 | 141914 | 2020-05-13 | Buckingham | Virginia | 51029 | 347 | 2 |
144911 | 144911 | 2020-05-14 | Buckingham | Virginia | 51029 | 348 | 2 |
147914 | 147914 | 2020-05-15 | Buckingham | Virginia | 51029 | 366 | 2 |
150923 | 150923 | 2020-05-16 | Buckingham | Virginia | 51029 | 411 | 2 |
153934 | 153934 | 2020-05-17 | Buckingham | Virginia | 51029 | 411 | 2 |
156951 | 156951 | 2020-05-18 | Buckingham | Virginia | 51029 | 417 | 2 |
159975 | 159975 | 2020-05-19 | Buckingham | Virginia | 51029 | 419 | 2 |
163003 | 163003 | 2020-05-20 | Buckingham | Virginia | 51029 | 419 | 2 |
166032 | 166032 | 2020-05-21 | Buckingham | Virginia | 51029 | 438 | 2 |
169068 | 169068 | 2020-05-22 | Buckingham | Virginia | 51029 | 439 | 2 |
172109 | 172109 | 2020-05-23 | Buckingham | Virginia | 51029 | 443 | 2 |
175152 | 175152 | 2020-05-24 | Buckingham | Virginia | 51029 | 442 | 2 |
178197 | 178197 | 2020-05-25 | Buckingham | Virginia | 51029 | 443 | 3 |
181241 | 181241 | 2020-05-26 | Buckingham | Virginia | 51029 | 445 | 3 |
184292 | 184292 | 2020-05-27 | Buckingham | Virginia | 51029 | 445 | 3 |
187349 | 187349 | 2020-05-28 | Buckingham | Virginia | 51029 | 453 | 3 |
190413 | 190413 | 2020-05-29 | Buckingham | Virginia | 51029 | 453 | 3 |
193479 | 193479 | 2020-05-30 | Buckingham | Virginia | 51029 | 456 | 3 |
196549 | 196549 | 2020-05-31 | Buckingham | Virginia | 51029 | 459 | 3 |
199622 | 199622 | 2020-06-01 | Buckingham | Virginia | 51029 | 461 | 3 |
202698 | 202698 | 2020-06-02 | Buckingham | Virginia | 51029 | 465 | 3 |
205777 | 205777 | 2020-06-03 | Buckingham | Virginia | 51029 | 467 | 3 |
208859 | 208859 | 2020-06-04 | Buckingham | Virginia | 51029 | 469 | 3 |
211944 | 211944 | 2020-06-05 | Buckingham | Virginia | 51029 | 475 | 3 |
215031 | 215031 | 2020-06-06 | Buckingham | Virginia | 51029 | 477 | 3 |
218121 | 218121 | 2020-06-07 | Buckingham | Virginia | 51029 | 481 | 3 |
221213 | 221213 | 2020-06-08 | Buckingham | Virginia | 51029 | 481 | 3 |
224309 | 224309 | 2020-06-09 | Buckingham | Virginia | 51029 | 484 | 3 |
227409 | 227409 | 2020-06-10 | Buckingham | Virginia | 51029 | 497 | 3 |
230513 | 230513 | 2020-06-11 | Buckingham | Virginia | 51029 | 517 | 3 |
233618 | 233618 | 2020-06-12 | Buckingham | Virginia | 51029 | 518 | 3 |
236725 | 236725 | 2020-06-13 | Buckingham | Virginia | 51029 | 519 | 3 |
239833 | 239833 | 2020-06-14 | Buckingham | Virginia | 51029 | 519 | 3 |
242944 | 242944 | 2020-06-15 | Buckingham | Virginia | 51029 | 521 | 3 |
246056 | 246056 | 2020-06-16 | Buckingham | Virginia | 51029 | 534 | 3 |
249168 | 249168 | 2020-06-17 | Buckingham | Virginia | 51029 | 542 | 3 |
252283 | 252283 | 2020-06-18 | Buckingham | Virginia | 51029 | 552 | 3 |
255402 | 255402 | 2020-06-19 | Buckingham | Virginia | 51029 | 552 | 3 |
258529 | 258529 | 2020-06-20 | Buckingham | Virginia | 51029 | 552 | 3 |
261656 | 261656 | 2020-06-21 | Buckingham | Virginia | 51029 | 552 | 3 |
264785 | 264785 | 2020-06-22 | Buckingham | Virginia | 51029 | 553 | 3 |
267914 | 267914 | 2020-06-23 | Buckingham | Virginia | 51029 | 553 | 4 |
271048 | 271048 | 2020-06-24 | Buckingham | Virginia | 51029 | 553 | 4 |
274188 | 274188 | 2020-06-25 | Buckingham | Virginia | 51029 | 555 | 4 |
277336 | 277336 | 2020-06-26 | Buckingham | Virginia | 51029 | 555 | 4 |
280484 | 280484 | 2020-06-27 | Buckingham | Virginia | 51029 | 556 | 4 |
283630 | 283630 | 2020-06-28 | Buckingham | Virginia | 51029 | 556 | 4 |
286776 | 286776 | 2020-06-29 | Buckingham | Virginia | 51029 | 556 | 4 |
289926 | 289926 | 2020-06-30 | Buckingham | Virginia | 51029 | 556 | 4 |
293079 | 293079 | 2020-07-01 | Buckingham | Virginia | 51029 | 559 | 4 |
296234 | 296234 | 2020-07-02 | Buckingham | Virginia | 51029 | 560 | 4 |
299396 | 299396 | 2020-07-03 | Buckingham | Virginia | 51029 | 566 | 4 |
302560 | 302560 | 2020-07-04 | Buckingham | Virginia | 51029 | 566 | 4 |
305724 | 305724 | 2020-07-05 | Buckingham | Virginia | 51029 | 566 | 4 |
308892 | 308892 | 2020-07-06 | Buckingham | Virginia | 51029 | 571 | 4 |
312061 | 312061 | 2020-07-07 | Buckingham | Virginia | 51029 | 570 | 5 |
315236 | 315236 | 2020-07-08 | Buckingham | Virginia | 51029 | 571 | 5 |
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);