ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
330 rows where fips = 6001 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
959649 | 959649 | 2021-01-24 | Alameda | California | 6001 | 70355 | 894 |
956403 | 956403 | 2021-01-23 | Alameda | California | 6001 | 69714 | 886 |
953158 | 953158 | 2021-01-22 | Alameda | California | 6001 | 69575 | 856 |
949913 | 949913 | 2021-01-21 | Alameda | California | 6001 | 69128 | 842 |
946667 | 946667 | 2021-01-20 | Alameda | California | 6001 | 68670 | 788 |
943420 | 943420 | 2021-01-19 | Alameda | California | 6001 | 67973 | 765 |
940175 | 940175 | 2021-01-18 | Alameda | California | 6001 | 67396 | 764 |
936930 | 936930 | 2021-01-17 | Alameda | California | 6001 | 66604 | 757 |
933685 | 933685 | 2021-01-16 | Alameda | California | 6001 | 65700 | 757 |
930440 | 930440 | 2021-01-15 | Alameda | California | 6001 | 64781 | 768 |
927195 | 927195 | 2021-01-14 | Alameda | California | 6001 | 63887 | 776 |
923949 | 923949 | 2021-01-13 | Alameda | California | 6001 | 62964 | 776 |
920704 | 920704 | 2021-01-12 | Alameda | California | 6001 | 62067 | 763 |
917459 | 917459 | 2021-01-11 | Alameda | California | 6001 | 61132 | 736 |
914214 | 914214 | 2021-01-10 | Alameda | California | 6001 | 60146 | 732 |
910969 | 910969 | 2021-01-09 | Alameda | California | 6001 | 59193 | 732 |
907724 | 907724 | 2021-01-08 | Alameda | California | 6001 | 57942 | 729 |
904478 | 904478 | 2021-01-07 | Alameda | California | 6001 | 57102 | 713 |
901233 | 901233 | 2021-01-06 | Alameda | California | 6001 | 56453 | 697 |
897988 | 897988 | 2021-01-05 | Alameda | California | 6001 | 55920 | 681 |
894743 | 894743 | 2021-01-04 | Alameda | California | 6001 | 55094 | 656 |
891496 | 891496 | 2021-01-03 | Alameda | California | 6001 | 54539 | 656 |
888249 | 888249 | 2021-01-02 | Alameda | California | 6001 | 53539 | 656 |
885004 | 885004 | 2021-01-01 | Alameda | California | 6001 | 52496 | 657 |
881759 | 881759 | 2020-12-31 | Alameda | California | 6001 | 51611 | 657 |
878514 | 878514 | 2020-12-30 | Alameda | California | 6001 | 50967 | 625 |
875269 | 875269 | 2020-12-29 | Alameda | California | 6001 | 50426 | 625 |
872024 | 872024 | 2020-12-28 | Alameda | California | 6001 | 49817 | 625 |
868779 | 868779 | 2020-12-27 | Alameda | California | 6001 | 49105 | 625 |
865534 | 865534 | 2020-12-26 | Alameda | California | 6001 | 48386 | 625 |
862289 | 862289 | 2020-12-25 | Alameda | California | 6001 | 47548 | 619 |
859044 | 859044 | 2020-12-24 | Alameda | California | 6001 | 46774 | 619 |
855799 | 855799 | 2020-12-23 | Alameda | California | 6001 | 45772 | 616 |
852554 | 852554 | 2020-12-22 | Alameda | California | 6001 | 44777 | 609 |
849309 | 849309 | 2020-12-21 | Alameda | California | 6001 | 44025 | 588 |
846064 | 846064 | 2020-12-20 | Alameda | California | 6001 | 43130 | 587 |
842818 | 842818 | 2020-12-19 | Alameda | California | 6001 | 42217 | 585 |
839573 | 839573 | 2020-12-18 | Alameda | California | 6001 | 41569 | 574 |
836328 | 836328 | 2020-12-17 | Alameda | California | 6001 | 40772 | 563 |
833082 | 833082 | 2020-12-16 | Alameda | California | 6001 | 40047 | 563 |
829835 | 829835 | 2020-12-15 | Alameda | California | 6001 | 39273 | 558 |
826589 | 826589 | 2020-12-14 | Alameda | California | 6001 | 38239 | 546 |
823342 | 823342 | 2020-12-13 | Alameda | California | 6001 | 37048 | 542 |
820096 | 820096 | 2020-12-12 | Alameda | California | 6001 | 36302 | 542 |
816850 | 816850 | 2020-12-11 | Alameda | California | 6001 | 35707 | 538 |
813604 | 813604 | 2020-12-10 | Alameda | California | 6001 | 35068 | 533 |
810360 | 810360 | 2020-12-09 | Alameda | California | 6001 | 34394 | 526 |
807115 | 807115 | 2020-12-08 | Alameda | California | 6001 | 33908 | 525 |
803870 | 803870 | 2020-12-07 | Alameda | California | 6001 | 33498 | 522 |
800624 | 800624 | 2020-12-06 | Alameda | California | 6001 | 32802 | 522 |
797378 | 797378 | 2020-12-05 | Alameda | California | 6001 | 31892 | 522 |
794133 | 794133 | 2020-12-04 | Alameda | California | 6001 | 31225 | 522 |
790887 | 790887 | 2020-12-03 | Alameda | California | 6001 | 31001 | 522 |
787641 | 787641 | 2020-12-02 | Alameda | California | 6001 | 30351 | 520 |
784397 | 784397 | 2020-12-01 | Alameda | California | 6001 | 29993 | 514 |
781152 | 781152 | 2020-11-30 | Alameda | California | 6001 | 29939 | 512 |
777906 | 777906 | 2020-11-29 | Alameda | California | 6001 | 29497 | 512 |
774660 | 774660 | 2020-11-28 | Alameda | California | 6001 | 29137 | 511 |
771415 | 771415 | 2020-11-27 | Alameda | California | 6001 | 28878 | 505 |
768169 | 768169 | 2020-11-26 | Alameda | California | 6001 | 28399 | 502 |
764922 | 764922 | 2020-11-25 | Alameda | California | 6001 | 28246 | 502 |
761676 | 761676 | 2020-11-24 | Alameda | California | 6001 | 27878 | 499 |
758430 | 758430 | 2020-11-23 | Alameda | California | 6001 | 27643 | 499 |
755183 | 755183 | 2020-11-22 | Alameda | California | 6001 | 27506 | 499 |
751936 | 751936 | 2020-11-21 | Alameda | California | 6001 | 27456 | 499 |
748689 | 748689 | 2020-11-20 | Alameda | California | 6001 | 27244 | 499 |
745442 | 745442 | 2020-11-19 | Alameda | California | 6001 | 26948 | 495 |
742195 | 742195 | 2020-11-18 | Alameda | California | 6001 | 26676 | 494 |
738948 | 738948 | 2020-11-17 | Alameda | California | 6001 | 26481 | 493 |
735703 | 735703 | 2020-11-16 | Alameda | California | 6001 | 26068 | 490 |
732457 | 732457 | 2020-11-15 | Alameda | California | 6001 | 25893 | 490 |
729212 | 729212 | 2020-11-14 | Alameda | California | 6001 | 25781 | 489 |
725968 | 725968 | 2020-11-13 | Alameda | California | 6001 | 25620 | 486 |
722724 | 722724 | 2020-11-12 | Alameda | California | 6001 | 25421 | 486 |
719480 | 719480 | 2020-11-11 | Alameda | California | 6001 | 25270 | 483 |
716236 | 716236 | 2020-11-10 | Alameda | California | 6001 | 25131 | 475 |
712992 | 712992 | 2020-11-09 | Alameda | California | 6001 | 25022 | 475 |
709748 | 709748 | 2020-11-08 | Alameda | California | 6001 | 24872 | 475 |
706504 | 706504 | 2020-11-07 | Alameda | California | 6001 | 24685 | 475 |
703261 | 703261 | 2020-11-06 | Alameda | California | 6001 | 24439 | 471 |
700017 | 700017 | 2020-11-05 | Alameda | California | 6001 | 24391 | 465 |
696772 | 696772 | 2020-11-04 | Alameda | California | 6001 | 24254 | 466 |
693529 | 693529 | 2020-11-03 | Alameda | California | 6001 | 24183 | 466 |
690286 | 690286 | 2020-11-02 | Alameda | California | 6001 | 24116 | 464 |
687041 | 687041 | 2020-11-01 | Alameda | California | 6001 | 24015 | 464 |
683796 | 683796 | 2020-10-31 | Alameda | California | 6001 | 23897 | 464 |
680552 | 680552 | 2020-10-30 | Alameda | California | 6001 | 23796 | 463 |
677309 | 677309 | 2020-10-29 | Alameda | California | 6001 | 23657 | 463 |
674065 | 674065 | 2020-10-28 | Alameda | California | 6001 | 23597 | 462 |
670823 | 670823 | 2020-10-27 | Alameda | California | 6001 | 23492 | 462 |
667580 | 667580 | 2020-10-26 | Alameda | California | 6001 | 23412 | 461 |
664334 | 664334 | 2020-10-25 | Alameda | California | 6001 | 23333 | 461 |
661089 | 661089 | 2020-10-24 | Alameda | California | 6001 | 23236 | 460 |
657845 | 657845 | 2020-10-23 | Alameda | California | 6001 | 23154 | 456 |
654600 | 654600 | 2020-10-22 | Alameda | California | 6001 | 23022 | 456 |
651355 | 651355 | 2020-10-21 | Alameda | California | 6001 | 22953 | 435 |
648111 | 648111 | 2020-10-20 | Alameda | California | 6001 | 22828 | 433 |
644866 | 644866 | 2020-10-19 | Alameda | California | 6001 | 22759 | 433 |
641618 | 641618 | 2020-10-18 | Alameda | California | 6001 | 22657 | 442 |
638371 | 638371 | 2020-10-17 | Alameda | California | 6001 | 22480 | 442 |
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]);