ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Putnam" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638018 | 638018 | 2020-10-16 | Putnam | West Virginia | 54079 | 767 | 10 |
634773 | 634773 | 2020-10-15 | Putnam | West Virginia | 54079 | 739 | 10 |
631528 | 631528 | 2020-10-14 | Putnam | West Virginia | 54079 | 732 | 10 |
628284 | 628284 | 2020-10-13 | Putnam | West Virginia | 54079 | 719 | 10 |
625041 | 625041 | 2020-10-12 | Putnam | West Virginia | 54079 | 710 | 10 |
621798 | 621798 | 2020-10-11 | Putnam | West Virginia | 54079 | 707 | 10 |
618555 | 618555 | 2020-10-10 | Putnam | West Virginia | 54079 | 694 | 10 |
615313 | 615313 | 2020-10-09 | Putnam | West Virginia | 54079 | 675 | 10 |
612072 | 612072 | 2020-10-08 | Putnam | West Virginia | 54079 | 658 | 10 |
608830 | 608830 | 2020-10-07 | Putnam | West Virginia | 54079 | 647 | 10 |
605587 | 605587 | 2020-10-06 | Putnam | West Virginia | 54079 | 641 | 10 |
602345 | 602345 | 2020-10-05 | Putnam | West Virginia | 54079 | 630 | 10 |
599102 | 599102 | 2020-10-04 | Putnam | West Virginia | 54079 | 627 | 9 |
595859 | 595859 | 2020-10-03 | Putnam | West Virginia | 54079 | 620 | 9 |
592617 | 592617 | 2020-10-02 | Putnam | West Virginia | 54079 | 612 | 9 |
589377 | 589377 | 2020-10-01 | Putnam | West Virginia | 54079 | 590 | 9 |
586136 | 586136 | 2020-09-30 | Putnam | West Virginia | 54079 | 583 | 9 |
582896 | 582896 | 2020-09-29 | Putnam | West Virginia | 54079 | 576 | 8 |
579657 | 579657 | 2020-09-28 | Putnam | West Virginia | 54079 | 566 | 5 |
576416 | 576416 | 2020-09-27 | Putnam | West Virginia | 54079 | 559 | 5 |
573172 | 573172 | 2020-09-26 | Putnam | West Virginia | 54079 | 550 | 5 |
569930 | 569930 | 2020-09-25 | Putnam | West Virginia | 54079 | 538 | 5 |
566689 | 566689 | 2020-09-24 | Putnam | West Virginia | 54079 | 529 | 5 |
563448 | 563448 | 2020-09-23 | Putnam | West Virginia | 54079 | 522 | 5 |
560209 | 560209 | 2020-09-22 | Putnam | West Virginia | 54079 | 521 | 5 |
556973 | 556973 | 2020-09-21 | Putnam | West Virginia | 54079 | 509 | 5 |
553736 | 553736 | 2020-09-20 | Putnam | West Virginia | 54079 | 496 | 5 |
550497 | 550497 | 2020-09-19 | Putnam | West Virginia | 54079 | 484 | 4 |
547258 | 547258 | 2020-09-18 | Putnam | West Virginia | 54079 | 471 | 2 |
544021 | 544021 | 2020-09-17 | Putnam | West Virginia | 54079 | 460 | 2 |
540785 | 540785 | 2020-09-16 | Putnam | West Virginia | 54079 | 441 | 2 |
537548 | 537548 | 2020-09-15 | Putnam | West Virginia | 54079 | 416 | 2 |
534312 | 534312 | 2020-09-14 | Putnam | West Virginia | 54079 | 403 | 2 |
531077 | 531077 | 2020-09-13 | Putnam | West Virginia | 54079 | 399 | 2 |
527840 | 527840 | 2020-09-12 | Putnam | West Virginia | 54079 | 393 | 2 |
524604 | 524604 | 2020-09-11 | Putnam | West Virginia | 54079 | 371 | 2 |
521368 | 521368 | 2020-09-10 | Putnam | West Virginia | 54079 | 362 | 1 |
518131 | 518131 | 2020-09-09 | Putnam | West Virginia | 54079 | 353 | 1 |
514896 | 514896 | 2020-09-08 | Putnam | West Virginia | 54079 | 352 | 1 |
511663 | 511663 | 2020-09-07 | Putnam | West Virginia | 54079 | 350 | 0 |
508430 | 508430 | 2020-09-06 | Putnam | West Virginia | 54079 | 340 | 0 |
505198 | 505198 | 2020-09-05 | Putnam | West Virginia | 54079 | 338 | 0 |
501964 | 501964 | 2020-09-04 | Putnam | West Virginia | 54079 | 323 | 0 |
498730 | 498730 | 2020-09-03 | Putnam | West Virginia | 54079 | 307 | 0 |
495497 | 495497 | 2020-09-02 | Putnam | West Virginia | 54079 | 294 | 0 |
492263 | 492263 | 2020-09-01 | Putnam | West Virginia | 54079 | 286 | 0 |
489030 | 489030 | 2020-08-31 | Putnam | West Virginia | 54079 | 283 | 0 |
485797 | 485797 | 2020-08-30 | Putnam | West Virginia | 54079 | 278 | 0 |
482562 | 482562 | 2020-08-29 | Putnam | West Virginia | 54079 | 274 | 0 |
479328 | 479328 | 2020-08-28 | Putnam | West Virginia | 54079 | 265 | 0 |
476095 | 476095 | 2020-08-27 | Putnam | West Virginia | 54079 | 257 | 0 |
472862 | 472862 | 2020-08-26 | Putnam | West Virginia | 54079 | 254 | 0 |
469630 | 469630 | 2020-08-25 | Putnam | West Virginia | 54079 | 252 | 0 |
466401 | 466401 | 2020-08-24 | Putnam | West Virginia | 54079 | 247 | 0 |
463172 | 463172 | 2020-08-23 | Putnam | West Virginia | 54079 | 245 | 0 |
459943 | 459943 | 2020-08-22 | Putnam | West Virginia | 54079 | 244 | 0 |
456716 | 456716 | 2020-08-21 | Putnam | West Virginia | 54079 | 237 | 0 |
453488 | 453488 | 2020-08-20 | Putnam | West Virginia | 54079 | 236 | 0 |
450260 | 450260 | 2020-08-19 | Putnam | West Virginia | 54079 | 228 | 0 |
447032 | 447032 | 2020-08-18 | Putnam | West Virginia | 54079 | 227 | 0 |
443805 | 443805 | 2020-08-17 | Putnam | West Virginia | 54079 | 225 | 0 |
440579 | 440579 | 2020-08-16 | Putnam | West Virginia | 54079 | 218 | 0 |
437353 | 437353 | 2020-08-15 | Putnam | West Virginia | 54079 | 216 | 0 |
434127 | 434127 | 2020-08-14 | Putnam | West Virginia | 54079 | 207 | 0 |
430902 | 430902 | 2020-08-13 | Putnam | West Virginia | 54079 | 204 | 0 |
427674 | 427674 | 2020-08-12 | Putnam | West Virginia | 54079 | 203 | 0 |
424450 | 424450 | 2020-08-11 | Putnam | West Virginia | 54079 | 200 | 0 |
421229 | 421229 | 2020-08-10 | Putnam | West Virginia | 54079 | 195 | 0 |
418008 | 418008 | 2020-08-09 | Putnam | West Virginia | 54079 | 195 | 0 |
414787 | 414787 | 2020-08-08 | Putnam | West Virginia | 54079 | 193 | 0 |
411567 | 411567 | 2020-08-07 | Putnam | West Virginia | 54079 | 186 | 0 |
408348 | 408348 | 2020-08-06 | Putnam | West Virginia | 54079 | 178 | 0 |
405128 | 405128 | 2020-08-05 | Putnam | West Virginia | 54079 | 174 | 0 |
401910 | 401910 | 2020-08-04 | Putnam | West Virginia | 54079 | 174 | 0 |
398694 | 398694 | 2020-08-03 | Putnam | West Virginia | 54079 | 172 | 0 |
395478 | 395478 | 2020-08-02 | Putnam | West Virginia | 54079 | 167 | 0 |
392262 | 392262 | 2020-08-01 | Putnam | West Virginia | 54079 | 163 | 0 |
389045 | 389045 | 2020-07-31 | Putnam | West Virginia | 54079 | 159 | 0 |
385828 | 385828 | 2020-07-30 | Putnam | West Virginia | 54079 | 152 | 0 |
382610 | 382610 | 2020-07-29 | Putnam | West Virginia | 54079 | 147 | 0 |
379393 | 379393 | 2020-07-28 | Putnam | West Virginia | 54079 | 153 | 0 |
376177 | 376177 | 2020-07-27 | Putnam | West Virginia | 54079 | 150 | 0 |
372963 | 372963 | 2020-07-26 | Putnam | West Virginia | 54079 | 147 | 0 |
369751 | 369751 | 2020-07-25 | Putnam | West Virginia | 54079 | 136 | 0 |
366541 | 366541 | 2020-07-24 | Putnam | West Virginia | 54079 | 133 | 0 |
363334 | 363334 | 2020-07-23 | Putnam | West Virginia | 54079 | 127 | 0 |
360128 | 360128 | 2020-07-22 | Putnam | West Virginia | 54079 | 127 | 0 |
356923 | 356923 | 2020-07-21 | Putnam | West Virginia | 54079 | 117 | 0 |
353720 | 353720 | 2020-07-20 | Putnam | West Virginia | 54079 | 116 | 0 |
350518 | 350518 | 2020-07-19 | Putnam | West Virginia | 54079 | 112 | 0 |
347317 | 347317 | 2020-07-18 | Putnam | West Virginia | 54079 | 109 | 0 |
344117 | 344117 | 2020-07-17 | Putnam | West Virginia | 54079 | 100 | 0 |
340918 | 340918 | 2020-07-16 | Putnam | West Virginia | 54079 | 97 | 0 |
337722 | 337722 | 2020-07-15 | Putnam | West Virginia | 54079 | 94 | 0 |
334527 | 334527 | 2020-07-14 | Putnam | West Virginia | 54079 | 91 | 0 |
331334 | 331334 | 2020-07-13 | Putnam | West Virginia | 54079 | 91 | 0 |
328148 | 328148 | 2020-07-12 | Putnam | West Virginia | 54079 | 89 | 0 |
324962 | 324962 | 2020-07-11 | Putnam | West Virginia | 54079 | 86 | 0 |
321781 | 321781 | 2020-07-10 | Putnam | West Virginia | 54079 | 79 | 0 |
318602 | 318602 | 2020-07-09 | Putnam | West Virginia | 54079 | 78 | 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);