ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053692 | 1053692 | 2021-02-22 | Alameda | California | 6001 | 79670 | 1200 |
1050445 | 1050445 | 2021-02-21 | Alameda | California | 6001 | 79560 | 1200 |
1047198 | 1047198 | 2021-02-20 | Alameda | California | 6001 | 79492 | 1175 |
1043953 | 1043953 | 2021-02-19 | Alameda | California | 6001 | 79318 | 1171 |
1040708 | 1040708 | 2021-02-18 | Alameda | California | 6001 | 79113 | 1126 |
1037463 | 1037463 | 2021-02-17 | Alameda | California | 6001 | 79037 | 1125 |
1034218 | 1034218 | 2021-02-16 | Alameda | California | 6001 | 78904 | 1122 |
1030972 | 1030972 | 2021-02-15 | Alameda | California | 6001 | 78735 | 1121 |
1027725 | 1027725 | 2021-02-14 | Alameda | California | 6001 | 78377 | 1120 |
1024480 | 1024480 | 2021-02-13 | Alameda | California | 6001 | 78306 | 1120 |
1021235 | 1021235 | 2021-02-12 | Alameda | California | 6001 | 77947 | 1088 |
1017990 | 1017990 | 2021-02-11 | Alameda | California | 6001 | 77653 | 1064 |
1014745 | 1014745 | 2021-02-10 | Alameda | California | 6001 | 77237 | 1063 |
1011500 | 1011500 | 2021-02-09 | Alameda | California | 6001 | 77130 | 1051 |
1008254 | 1008254 | 2021-02-08 | Alameda | California | 6001 | 76669 | 1041 |
1005008 | 1005008 | 2021-02-07 | Alameda | California | 6001 | 76191 | 1041 |
1001762 | 1001762 | 2021-02-06 | Alameda | California | 6001 | 75758 | 1037 |
998516 | 998516 | 2021-02-05 | Alameda | California | 6001 | 75443 | 1030 |
995270 | 995270 | 2021-02-04 | Alameda | California | 6001 | 75196 | 1021 |
992024 | 992024 | 2021-02-03 | Alameda | California | 6001 | 74980 | 999 |
988778 | 988778 | 2021-02-02 | Alameda | California | 6001 | 74682 | 991 |
985531 | 985531 | 2021-02-01 | Alameda | California | 6001 | 74108 | 982 |
982284 | 982284 | 2021-01-31 | Alameda | California | 6001 | 73792 | 980 |
979038 | 979038 | 2021-01-30 | Alameda | California | 6001 | 73563 | 974 |
975793 | 975793 | 2021-01-29 | Alameda | California | 6001 | 73136 | 959 |
972548 | 972548 | 2021-01-28 | Alameda | California | 6001 | 72618 | 937 |
969303 | 969303 | 2021-01-27 | Alameda | California | 6001 | 72045 | 929 |
966059 | 966059 | 2021-01-26 | Alameda | California | 6001 | 71319 | 906 |
962814 | 962814 | 2021-01-25 | Alameda | California | 6001 | 70844 | 896 |
959569 | 959569 | 2021-01-24 | Alameda | California | 6001 | 70355 | 894 |
956323 | 956323 | 2021-01-23 | Alameda | California | 6001 | 69714 | 886 |
953078 | 953078 | 2021-01-22 | Alameda | California | 6001 | 69575 | 856 |
949833 | 949833 | 2021-01-21 | Alameda | California | 6001 | 69128 | 842 |
946587 | 946587 | 2021-01-20 | Alameda | California | 6001 | 68670 | 788 |
943340 | 943340 | 2021-01-19 | Alameda | California | 6001 | 67973 | 765 |
940095 | 940095 | 2021-01-18 | Alameda | California | 6001 | 67396 | 764 |
936850 | 936850 | 2021-01-17 | Alameda | California | 6001 | 66604 | 757 |
933605 | 933605 | 2021-01-16 | Alameda | California | 6001 | 65700 | 757 |
930360 | 930360 | 2021-01-15 | Alameda | California | 6001 | 64781 | 768 |
927115 | 927115 | 2021-01-14 | Alameda | California | 6001 | 63887 | 776 |
923869 | 923869 | 2021-01-13 | Alameda | California | 6001 | 62964 | 776 |
920624 | 920624 | 2021-01-12 | Alameda | California | 6001 | 62067 | 763 |
917379 | 917379 | 2021-01-11 | Alameda | California | 6001 | 61132 | 736 |
914134 | 914134 | 2021-01-10 | Alameda | California | 6001 | 60146 | 732 |
910889 | 910889 | 2021-01-09 | Alameda | California | 6001 | 59193 | 732 |
907644 | 907644 | 2021-01-08 | Alameda | California | 6001 | 57942 | 729 |
904398 | 904398 | 2021-01-07 | Alameda | California | 6001 | 57102 | 713 |
901153 | 901153 | 2021-01-06 | Alameda | California | 6001 | 56453 | 697 |
897908 | 897908 | 2021-01-05 | Alameda | California | 6001 | 55920 | 681 |
894663 | 894663 | 2021-01-04 | Alameda | California | 6001 | 55094 | 656 |
891416 | 891416 | 2021-01-03 | Alameda | California | 6001 | 54539 | 656 |
888169 | 888169 | 2021-01-02 | Alameda | California | 6001 | 53539 | 656 |
884924 | 884924 | 2021-01-01 | Alameda | California | 6001 | 52496 | 657 |
881679 | 881679 | 2020-12-31 | Alameda | California | 6001 | 51611 | 657 |
878434 | 878434 | 2020-12-30 | Alameda | California | 6001 | 50967 | 625 |
875189 | 875189 | 2020-12-29 | Alameda | California | 6001 | 50426 | 625 |
871944 | 871944 | 2020-12-28 | Alameda | California | 6001 | 49817 | 625 |
868699 | 868699 | 2020-12-27 | Alameda | California | 6001 | 49105 | 625 |
865454 | 865454 | 2020-12-26 | Alameda | California | 6001 | 48386 | 625 |
862209 | 862209 | 2020-12-25 | Alameda | California | 6001 | 47548 | 619 |
858964 | 858964 | 2020-12-24 | Alameda | California | 6001 | 46774 | 619 |
855719 | 855719 | 2020-12-23 | Alameda | California | 6001 | 45772 | 616 |
852474 | 852474 | 2020-12-22 | Alameda | California | 6001 | 44777 | 609 |
849229 | 849229 | 2020-12-21 | Alameda | California | 6001 | 44025 | 588 |
845984 | 845984 | 2020-12-20 | Alameda | California | 6001 | 43130 | 587 |
842738 | 842738 | 2020-12-19 | Alameda | California | 6001 | 42217 | 585 |
839493 | 839493 | 2020-12-18 | Alameda | California | 6001 | 41569 | 574 |
836248 | 836248 | 2020-12-17 | Alameda | California | 6001 | 40772 | 563 |
833002 | 833002 | 2020-12-16 | Alameda | California | 6001 | 40047 | 563 |
829755 | 829755 | 2020-12-15 | Alameda | California | 6001 | 39273 | 558 |
826509 | 826509 | 2020-12-14 | Alameda | California | 6001 | 38239 | 546 |
823262 | 823262 | 2020-12-13 | Alameda | California | 6001 | 37048 | 542 |
820016 | 820016 | 2020-12-12 | Alameda | California | 6001 | 36302 | 542 |
816770 | 816770 | 2020-12-11 | Alameda | California | 6001 | 35707 | 538 |
813524 | 813524 | 2020-12-10 | Alameda | California | 6001 | 35068 | 533 |
810280 | 810280 | 2020-12-09 | Alameda | California | 6001 | 34394 | 526 |
807035 | 807035 | 2020-12-08 | Alameda | California | 6001 | 33908 | 525 |
803790 | 803790 | 2020-12-07 | Alameda | California | 6001 | 33498 | 522 |
800545 | 800545 | 2020-12-06 | Alameda | California | 6001 | 32802 | 522 |
797300 | 797300 | 2020-12-05 | Alameda | California | 6001 | 31892 | 522 |
794055 | 794055 | 2020-12-04 | Alameda | California | 6001 | 31225 | 522 |
790810 | 790810 | 2020-12-03 | Alameda | California | 6001 | 31001 | 522 |
787565 | 787565 | 2020-12-02 | Alameda | California | 6001 | 30351 | 520 |
784321 | 784321 | 2020-12-01 | Alameda | California | 6001 | 29993 | 514 |
781076 | 781076 | 2020-11-30 | Alameda | California | 6001 | 29939 | 512 |
777830 | 777830 | 2020-11-29 | Alameda | California | 6001 | 29497 | 512 |
774585 | 774585 | 2020-11-28 | Alameda | California | 6001 | 29137 | 511 |
771340 | 771340 | 2020-11-27 | Alameda | California | 6001 | 28878 | 505 |
768095 | 768095 | 2020-11-26 | Alameda | California | 6001 | 28399 | 502 |
764849 | 764849 | 2020-11-25 | Alameda | California | 6001 | 28246 | 502 |
761604 | 761604 | 2020-11-24 | Alameda | California | 6001 | 27878 | 499 |
758359 | 758359 | 2020-11-23 | Alameda | California | 6001 | 27643 | 499 |
755112 | 755112 | 2020-11-22 | Alameda | California | 6001 | 27506 | 499 |
751866 | 751866 | 2020-11-21 | Alameda | California | 6001 | 27456 | 499 |
748620 | 748620 | 2020-11-20 | Alameda | California | 6001 | 27244 | 499 |
745374 | 745374 | 2020-11-19 | Alameda | California | 6001 | 26948 | 495 |
742127 | 742127 | 2020-11-18 | Alameda | California | 6001 | 26676 | 494 |
738880 | 738880 | 2020-11-17 | Alameda | California | 6001 | 26481 | 493 |
735636 | 735636 | 2020-11-16 | Alameda | California | 6001 | 26068 | 490 |
732390 | 732390 | 2020-11-15 | Alameda | California | 6001 | 25893 | 490 |
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);