ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Caledonia" and state = "Vermont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537320 | 537320 | 2020-09-15 | Caledonia | Vermont | 50005 | 34 | 0 |
534084 | 534084 | 2020-09-14 | Caledonia | Vermont | 50005 | 34 | 0 |
530849 | 530849 | 2020-09-13 | Caledonia | Vermont | 50005 | 34 | 0 |
527612 | 527612 | 2020-09-12 | Caledonia | Vermont | 50005 | 34 | 0 |
524376 | 524376 | 2020-09-11 | Caledonia | Vermont | 50005 | 33 | 0 |
521140 | 521140 | 2020-09-10 | Caledonia | Vermont | 50005 | 33 | 0 |
517903 | 517903 | 2020-09-09 | Caledonia | Vermont | 50005 | 33 | 0 |
514668 | 514668 | 2020-09-08 | Caledonia | Vermont | 50005 | 33 | 0 |
511435 | 511435 | 2020-09-07 | Caledonia | Vermont | 50005 | 33 | 0 |
508202 | 508202 | 2020-09-06 | Caledonia | Vermont | 50005 | 33 | 0 |
504970 | 504970 | 2020-09-05 | Caledonia | Vermont | 50005 | 33 | 0 |
501736 | 501736 | 2020-09-04 | Caledonia | Vermont | 50005 | 33 | 0 |
498502 | 498502 | 2020-09-03 | Caledonia | Vermont | 50005 | 33 | 0 |
495269 | 495269 | 2020-09-02 | Caledonia | Vermont | 50005 | 33 | 0 |
492035 | 492035 | 2020-09-01 | Caledonia | Vermont | 50005 | 33 | 0 |
488802 | 488802 | 2020-08-31 | Caledonia | Vermont | 50005 | 33 | 0 |
485569 | 485569 | 2020-08-30 | Caledonia | Vermont | 50005 | 34 | 0 |
482334 | 482334 | 2020-08-29 | Caledonia | Vermont | 50005 | 33 | 0 |
479100 | 479100 | 2020-08-28 | Caledonia | Vermont | 50005 | 32 | 0 |
475867 | 475867 | 2020-08-27 | Caledonia | Vermont | 50005 | 32 | 0 |
472634 | 472634 | 2020-08-26 | Caledonia | Vermont | 50005 | 30 | 0 |
469402 | 469402 | 2020-08-25 | Caledonia | Vermont | 50005 | 30 | 0 |
466173 | 466173 | 2020-08-24 | Caledonia | Vermont | 50005 | 30 | 0 |
462944 | 462944 | 2020-08-23 | Caledonia | Vermont | 50005 | 30 | 0 |
459715 | 459715 | 2020-08-22 | Caledonia | Vermont | 50005 | 30 | 0 |
456488 | 456488 | 2020-08-21 | Caledonia | Vermont | 50005 | 30 | 0 |
453260 | 453260 | 2020-08-20 | Caledonia | Vermont | 50005 | 30 | 0 |
450032 | 450032 | 2020-08-19 | Caledonia | Vermont | 50005 | 29 | 0 |
446804 | 446804 | 2020-08-18 | Caledonia | Vermont | 50005 | 29 | 0 |
443577 | 443577 | 2020-08-17 | Caledonia | Vermont | 50005 | 29 | 0 |
440351 | 440351 | 2020-08-16 | Caledonia | Vermont | 50005 | 29 | 0 |
437125 | 437125 | 2020-08-15 | Caledonia | Vermont | 50005 | 29 | 0 |
433899 | 433899 | 2020-08-14 | Caledonia | Vermont | 50005 | 28 | 0 |
430674 | 430674 | 2020-08-13 | Caledonia | Vermont | 50005 | 28 | 0 |
427446 | 427446 | 2020-08-12 | Caledonia | Vermont | 50005 | 28 | 0 |
424222 | 424222 | 2020-08-11 | Caledonia | Vermont | 50005 | 28 | 0 |
421001 | 421001 | 2020-08-10 | Caledonia | Vermont | 50005 | 28 | 0 |
417780 | 417780 | 2020-08-09 | Caledonia | Vermont | 50005 | 28 | 0 |
414559 | 414559 | 2020-08-08 | Caledonia | Vermont | 50005 | 26 | 0 |
411339 | 411339 | 2020-08-07 | Caledonia | Vermont | 50005 | 26 | 0 |
408120 | 408120 | 2020-08-06 | Caledonia | Vermont | 50005 | 26 | 0 |
404900 | 404900 | 2020-08-05 | Caledonia | Vermont | 50005 | 26 | 0 |
401682 | 401682 | 2020-08-04 | Caledonia | Vermont | 50005 | 26 | 0 |
398466 | 398466 | 2020-08-03 | Caledonia | Vermont | 50005 | 26 | 0 |
395250 | 395250 | 2020-08-02 | Caledonia | Vermont | 50005 | 26 | 0 |
392034 | 392034 | 2020-08-01 | Caledonia | Vermont | 50005 | 26 | 0 |
388817 | 388817 | 2020-07-31 | Caledonia | Vermont | 50005 | 26 | 0 |
385600 | 385600 | 2020-07-30 | Caledonia | Vermont | 50005 | 26 | 0 |
382382 | 382382 | 2020-07-29 | Caledonia | Vermont | 50005 | 26 | 0 |
379165 | 379165 | 2020-07-28 | Caledonia | Vermont | 50005 | 26 | 0 |
375949 | 375949 | 2020-07-27 | Caledonia | Vermont | 50005 | 25 | 0 |
372735 | 372735 | 2020-07-26 | Caledonia | Vermont | 50005 | 25 | 0 |
369523 | 369523 | 2020-07-25 | Caledonia | Vermont | 50005 | 25 | 0 |
366314 | 366314 | 2020-07-24 | Caledonia | Vermont | 50005 | 25 | 0 |
363108 | 363108 | 2020-07-23 | Caledonia | Vermont | 50005 | 25 | 0 |
359901 | 359901 | 2020-07-22 | Caledonia | Vermont | 50005 | 25 | 0 |
356696 | 356696 | 2020-07-21 | Caledonia | Vermont | 50005 | 25 | 0 |
353493 | 353493 | 2020-07-20 | Caledonia | Vermont | 50005 | 25 | 0 |
350291 | 350291 | 2020-07-19 | Caledonia | Vermont | 50005 | 24 | 0 |
347090 | 347090 | 2020-07-18 | Caledonia | Vermont | 50005 | 24 | 0 |
343890 | 343890 | 2020-07-17 | Caledonia | Vermont | 50005 | 24 | 0 |
340691 | 340691 | 2020-07-16 | Caledonia | Vermont | 50005 | 24 | 0 |
337495 | 337495 | 2020-07-15 | Caledonia | Vermont | 50005 | 23 | 0 |
334300 | 334300 | 2020-07-14 | Caledonia | Vermont | 50005 | 22 | 0 |
331107 | 331107 | 2020-07-13 | Caledonia | Vermont | 50005 | 22 | 0 |
327921 | 327921 | 2020-07-12 | Caledonia | Vermont | 50005 | 21 | 0 |
324736 | 324736 | 2020-07-11 | Caledonia | Vermont | 50005 | 21 | 0 |
321555 | 321555 | 2020-07-10 | Caledonia | Vermont | 50005 | 21 | 0 |
318376 | 318376 | 2020-07-09 | Caledonia | Vermont | 50005 | 21 | 0 |
315203 | 315203 | 2020-07-08 | Caledonia | Vermont | 50005 | 21 | 0 |
312029 | 312029 | 2020-07-07 | Caledonia | Vermont | 50005 | 21 | 0 |
308860 | 308860 | 2020-07-06 | Caledonia | Vermont | 50005 | 21 | 0 |
305692 | 305692 | 2020-07-05 | Caledonia | Vermont | 50005 | 21 | 0 |
302528 | 302528 | 2020-07-04 | Caledonia | Vermont | 50005 | 20 | 0 |
299364 | 299364 | 2020-07-03 | Caledonia | Vermont | 50005 | 20 | 0 |
296202 | 296202 | 2020-07-02 | Caledonia | Vermont | 50005 | 20 | 0 |
293047 | 293047 | 2020-07-01 | Caledonia | Vermont | 50005 | 19 | 0 |
289894 | 289894 | 2020-06-30 | Caledonia | Vermont | 50005 | 19 | 0 |
286744 | 286744 | 2020-06-29 | Caledonia | Vermont | 50005 | 19 | 0 |
283598 | 283598 | 2020-06-28 | Caledonia | Vermont | 50005 | 19 | 0 |
280452 | 280452 | 2020-06-27 | Caledonia | Vermont | 50005 | 19 | 0 |
277304 | 277304 | 2020-06-26 | Caledonia | Vermont | 50005 | 19 | 0 |
274156 | 274156 | 2020-06-25 | Caledonia | Vermont | 50005 | 19 | 0 |
271016 | 271016 | 2020-06-24 | Caledonia | Vermont | 50005 | 18 | 0 |
267882 | 267882 | 2020-06-23 | Caledonia | Vermont | 50005 | 18 | 0 |
264753 | 264753 | 2020-06-22 | Caledonia | Vermont | 50005 | 18 | 0 |
261624 | 261624 | 2020-06-21 | Caledonia | Vermont | 50005 | 18 | 0 |
258497 | 258497 | 2020-06-20 | Caledonia | Vermont | 50005 | 17 | 0 |
255370 | 255370 | 2020-06-19 | Caledonia | Vermont | 50005 | 16 | 0 |
252252 | 252252 | 2020-06-18 | Caledonia | Vermont | 50005 | 16 | 0 |
249137 | 249137 | 2020-06-17 | Caledonia | Vermont | 50005 | 16 | 0 |
246025 | 246025 | 2020-06-16 | Caledonia | Vermont | 50005 | 16 | 0 |
242913 | 242913 | 2020-06-15 | Caledonia | Vermont | 50005 | 16 | 0 |
239802 | 239802 | 2020-06-14 | Caledonia | Vermont | 50005 | 16 | 0 |
236694 | 236694 | 2020-06-13 | Caledonia | Vermont | 50005 | 16 | 0 |
233587 | 233587 | 2020-06-12 | Caledonia | Vermont | 50005 | 16 | 0 |
230482 | 230482 | 2020-06-11 | Caledonia | Vermont | 50005 | 16 | 0 |
227378 | 227378 | 2020-06-10 | Caledonia | Vermont | 50005 | 16 | 0 |
224278 | 224278 | 2020-06-09 | Caledonia | Vermont | 50005 | 16 | 0 |
221182 | 221182 | 2020-06-08 | Caledonia | Vermont | 50005 | 16 | 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);