ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Berkeley" 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 |
---|---|---|---|---|---|---|---|
637980 | 637980 | 2020-10-16 | Berkeley | West Virginia | 54003 | 1349 | 17 |
634735 | 634735 | 2020-10-15 | Berkeley | West Virginia | 54003 | 1315 | 17 |
631490 | 631490 | 2020-10-14 | Berkeley | West Virginia | 54003 | 1301 | 17 |
628246 | 628246 | 2020-10-13 | Berkeley | West Virginia | 54003 | 1268 | 16 |
625003 | 625003 | 2020-10-12 | Berkeley | West Virginia | 54003 | 1246 | 16 |
621760 | 621760 | 2020-10-11 | Berkeley | West Virginia | 54003 | 1222 | 16 |
618517 | 618517 | 2020-10-10 | Berkeley | West Virginia | 54003 | 1202 | 16 |
615275 | 615275 | 2020-10-09 | Berkeley | West Virginia | 54003 | 1187 | 16 |
612034 | 612034 | 2020-10-08 | Berkeley | West Virginia | 54003 | 1161 | 16 |
608792 | 608792 | 2020-10-07 | Berkeley | West Virginia | 54003 | 1148 | 16 |
605549 | 605549 | 2020-10-06 | Berkeley | West Virginia | 54003 | 1118 | 16 |
602307 | 602307 | 2020-10-05 | Berkeley | West Virginia | 54003 | 1103 | 16 |
599064 | 599064 | 2020-10-04 | Berkeley | West Virginia | 54003 | 1093 | 16 |
595821 | 595821 | 2020-10-03 | Berkeley | West Virginia | 54003 | 1085 | 16 |
592579 | 592579 | 2020-10-02 | Berkeley | West Virginia | 54003 | 1064 | 16 |
589339 | 589339 | 2020-10-01 | Berkeley | West Virginia | 54003 | 1049 | 16 |
586098 | 586098 | 2020-09-30 | Berkeley | West Virginia | 54003 | 1025 | 15 |
582858 | 582858 | 2020-09-29 | Berkeley | West Virginia | 54003 | 1009 | 15 |
579619 | 579619 | 2020-09-28 | Berkeley | West Virginia | 54003 | 1002 | 14 |
576378 | 576378 | 2020-09-27 | Berkeley | West Virginia | 54003 | 995 | 13 |
573134 | 573134 | 2020-09-26 | Berkeley | West Virginia | 54003 | 987 | 13 |
569892 | 569892 | 2020-09-25 | Berkeley | West Virginia | 54003 | 976 | 13 |
566651 | 566651 | 2020-09-24 | Berkeley | West Virginia | 54003 | 968 | 13 |
563410 | 563410 | 2020-09-23 | Berkeley | West Virginia | 54003 | 952 | 13 |
560171 | 560171 | 2020-09-22 | Berkeley | West Virginia | 54003 | 948 | 13 |
556935 | 556935 | 2020-09-21 | Berkeley | West Virginia | 54003 | 947 | 13 |
553698 | 553698 | 2020-09-20 | Berkeley | West Virginia | 54003 | 944 | 12 |
550459 | 550459 | 2020-09-19 | Berkeley | West Virginia | 54003 | 938 | 13 |
547220 | 547220 | 2020-09-18 | Berkeley | West Virginia | 54003 | 929 | 13 |
543983 | 543983 | 2020-09-17 | Berkeley | West Virginia | 54003 | 922 | 13 |
540747 | 540747 | 2020-09-16 | Berkeley | West Virginia | 54003 | 911 | 11 |
537510 | 537510 | 2020-09-15 | Berkeley | West Virginia | 54003 | 890 | 11 |
534274 | 534274 | 2020-09-14 | Berkeley | West Virginia | 54003 | 884 | 11 |
531039 | 531039 | 2020-09-13 | Berkeley | West Virginia | 54003 | 872 | 11 |
527802 | 527802 | 2020-09-12 | Berkeley | West Virginia | 54003 | 866 | 11 |
524566 | 524566 | 2020-09-11 | Berkeley | West Virginia | 54003 | 856 | 11 |
521330 | 521330 | 2020-09-10 | Berkeley | West Virginia | 54003 | 851 | 11 |
518093 | 518093 | 2020-09-09 | Berkeley | West Virginia | 54003 | 840 | 11 |
514858 | 514858 | 2020-09-08 | Berkeley | West Virginia | 54003 | 837 | 11 |
511625 | 511625 | 2020-09-07 | Berkeley | West Virginia | 54003 | 831 | 11 |
508392 | 508392 | 2020-09-06 | Berkeley | West Virginia | 54003 | 825 | 11 |
505160 | 505160 | 2020-09-05 | Berkeley | West Virginia | 54003 | 822 | 11 |
501926 | 501926 | 2020-09-04 | Berkeley | West Virginia | 54003 | 819 | 11 |
498692 | 498692 | 2020-09-03 | Berkeley | West Virginia | 54003 | 812 | 11 |
495459 | 495459 | 2020-09-02 | Berkeley | West Virginia | 54003 | 808 | 11 |
492225 | 492225 | 2020-09-01 | Berkeley | West Virginia | 54003 | 804 | 11 |
488992 | 488992 | 2020-08-31 | Berkeley | West Virginia | 54003 | 801 | 11 |
485759 | 485759 | 2020-08-30 | Berkeley | West Virginia | 54003 | 798 | 11 |
482524 | 482524 | 2020-08-29 | Berkeley | West Virginia | 54003 | 794 | 11 |
479290 | 479290 | 2020-08-28 | Berkeley | West Virginia | 54003 | 788 | 11 |
476057 | 476057 | 2020-08-27 | Berkeley | West Virginia | 54003 | 780 | 11 |
472824 | 472824 | 2020-08-26 | Berkeley | West Virginia | 54003 | 777 | 11 |
469592 | 469592 | 2020-08-25 | Berkeley | West Virginia | 54003 | 769 | 11 |
466363 | 466363 | 2020-08-24 | Berkeley | West Virginia | 54003 | 767 | 11 |
463134 | 463134 | 2020-08-23 | Berkeley | West Virginia | 54003 | 766 | 11 |
459905 | 459905 | 2020-08-22 | Berkeley | West Virginia | 54003 | 764 | 11 |
456678 | 456678 | 2020-08-21 | Berkeley | West Virginia | 54003 | 757 | 11 |
453450 | 453450 | 2020-08-20 | Berkeley | West Virginia | 54003 | 753 | 11 |
450222 | 450222 | 2020-08-19 | Berkeley | West Virginia | 54003 | 748 | 11 |
446994 | 446994 | 2020-08-18 | Berkeley | West Virginia | 54003 | 745 | 11 |
443767 | 443767 | 2020-08-17 | Berkeley | West Virginia | 54003 | 738 | 11 |
440541 | 440541 | 2020-08-16 | Berkeley | West Virginia | 54003 | 734 | 11 |
437315 | 437315 | 2020-08-15 | Berkeley | West Virginia | 54003 | 733 | 11 |
434089 | 434089 | 2020-08-14 | Berkeley | West Virginia | 54003 | 727 | 11 |
430864 | 430864 | 2020-08-13 | Berkeley | West Virginia | 54003 | 720 | 11 |
427636 | 427636 | 2020-08-12 | Berkeley | West Virginia | 54003 | 713 | 11 |
424412 | 424412 | 2020-08-11 | Berkeley | West Virginia | 54003 | 699 | 11 |
421191 | 421191 | 2020-08-10 | Berkeley | West Virginia | 54003 | 698 | 11 |
417970 | 417970 | 2020-08-09 | Berkeley | West Virginia | 54003 | 696 | 11 |
414749 | 414749 | 2020-08-08 | Berkeley | West Virginia | 54003 | 693 | 11 |
411529 | 411529 | 2020-08-07 | Berkeley | West Virginia | 54003 | 686 | 11 |
408310 | 408310 | 2020-08-06 | Berkeley | West Virginia | 54003 | 675 | 11 |
405090 | 405090 | 2020-08-05 | Berkeley | West Virginia | 54003 | 670 | 11 |
401872 | 401872 | 2020-08-04 | Berkeley | West Virginia | 54003 | 661 | 11 |
398656 | 398656 | 2020-08-03 | Berkeley | West Virginia | 54003 | 657 | 11 |
395440 | 395440 | 2020-08-02 | Berkeley | West Virginia | 54003 | 655 | 11 |
392224 | 392224 | 2020-08-01 | Berkeley | West Virginia | 54003 | 651 | 11 |
389007 | 389007 | 2020-07-31 | Berkeley | West Virginia | 54003 | 645 | 11 |
385790 | 385790 | 2020-07-30 | Berkeley | West Virginia | 54003 | 637 | 11 |
382572 | 382572 | 2020-07-29 | Berkeley | West Virginia | 54003 | 631 | 11 |
379355 | 379355 | 2020-07-28 | Berkeley | West Virginia | 54003 | 627 | 11 |
376139 | 376139 | 2020-07-27 | Berkeley | West Virginia | 54003 | 620 | 10 |
372925 | 372925 | 2020-07-26 | Berkeley | West Virginia | 54003 | 612 | 10 |
369713 | 369713 | 2020-07-25 | Berkeley | West Virginia | 54003 | 608 | 10 |
366504 | 366504 | 2020-07-24 | Berkeley | West Virginia | 54003 | 604 | 10 |
363297 | 363297 | 2020-07-23 | Berkeley | West Virginia | 54003 | 596 | 10 |
360091 | 360091 | 2020-07-22 | Berkeley | West Virginia | 54003 | 587 | 10 |
356886 | 356886 | 2020-07-21 | Berkeley | West Virginia | 54003 | 569 | 10 |
353683 | 353683 | 2020-07-20 | Berkeley | West Virginia | 54003 | 568 | 10 |
350481 | 350481 | 2020-07-19 | Berkeley | West Virginia | 54003 | 567 | 10 |
347280 | 347280 | 2020-07-18 | Berkeley | West Virginia | 54003 | 564 | 10 |
344080 | 344080 | 2020-07-17 | Berkeley | West Virginia | 54003 | 558 | 10 |
340881 | 340881 | 2020-07-16 | Berkeley | West Virginia | 54003 | 555 | 10 |
337685 | 337685 | 2020-07-15 | Berkeley | West Virginia | 54003 | 550 | 10 |
334490 | 334490 | 2020-07-14 | Berkeley | West Virginia | 54003 | 543 | 10 |
331297 | 331297 | 2020-07-13 | Berkeley | West Virginia | 54003 | 537 | 10 |
328111 | 328111 | 2020-07-12 | Berkeley | West Virginia | 54003 | 533 | 10 |
324925 | 324925 | 2020-07-11 | Berkeley | West Virginia | 54003 | 531 | 10 |
321744 | 321744 | 2020-07-10 | Berkeley | West Virginia | 54003 | 523 | 10 |
318565 | 318565 | 2020-07-09 | Berkeley | West Virginia | 54003 | 517 | 10 |
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);