ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053725 | 1053725 | 2021-02-22 | Sacramento | California | 6067 | 92427 | 1438 |
1050478 | 1050478 | 2021-02-21 | Sacramento | California | 6067 | 92056 | 1431 |
1047231 | 1047231 | 2021-02-20 | Sacramento | California | 6067 | 91814 | 1431 |
1043986 | 1043986 | 2021-02-19 | Sacramento | California | 6067 | 91796 | 1431 |
1040741 | 1040741 | 2021-02-18 | Sacramento | California | 6067 | 91392 | 1412 |
1037496 | 1037496 | 2021-02-17 | Sacramento | California | 6067 | 91245 | 1402 |
1034251 | 1034251 | 2021-02-16 | Sacramento | California | 6067 | 91090 | 1382 |
1031005 | 1031005 | 2021-02-15 | Sacramento | California | 6067 | 90855 | 1372 |
1027758 | 1027758 | 2021-02-14 | Sacramento | California | 6067 | 90400 | 1372 |
1024513 | 1024513 | 2021-02-13 | Sacramento | California | 6067 | 90251 | 1372 |
1021268 | 1021268 | 2021-02-12 | Sacramento | California | 6067 | 89987 | 1372 |
1018023 | 1018023 | 2021-02-11 | Sacramento | California | 6067 | 89652 | 1360 |
1014778 | 1014778 | 2021-02-10 | Sacramento | California | 6067 | 89377 | 1352 |
1011533 | 1011533 | 2021-02-09 | Sacramento | California | 6067 | 89266 | 1335 |
1008287 | 1008287 | 2021-02-08 | Sacramento | California | 6067 | 88918 | 1318 |
1005041 | 1005041 | 2021-02-07 | Sacramento | California | 6067 | 88531 | 1302 |
1001795 | 1001795 | 2021-02-06 | Sacramento | California | 6067 | 87991 | 1302 |
998549 | 998549 | 2021-02-05 | Sacramento | California | 6067 | 87703 | 1302 |
995303 | 995303 | 2021-02-04 | Sacramento | California | 6067 | 87414 | 1288 |
992057 | 992057 | 2021-02-03 | Sacramento | California | 6067 | 87106 | 1281 |
988811 | 988811 | 2021-02-02 | Sacramento | California | 6067 | 86855 | 1271 |
985564 | 985564 | 2021-02-01 | Sacramento | California | 6067 | 86559 | 1262 |
982317 | 982317 | 2021-01-31 | Sacramento | California | 6067 | 86387 | 1239 |
979071 | 979071 | 2021-01-30 | Sacramento | California | 6067 | 86319 | 1239 |
975826 | 975826 | 2021-01-29 | Sacramento | California | 6067 | 85697 | 1239 |
972581 | 972581 | 2021-01-28 | Sacramento | California | 6067 | 85427 | 1216 |
969336 | 969336 | 2021-01-27 | Sacramento | California | 6067 | 85061 | 1208 |
966092 | 966092 | 2021-01-26 | Sacramento | California | 6067 | 84652 | 1194 |
962847 | 962847 | 2021-01-25 | Sacramento | California | 6067 | 84109 | 1185 |
959602 | 959602 | 2021-01-24 | Sacramento | California | 6067 | 83407 | 1157 |
956356 | 956356 | 2021-01-23 | Sacramento | California | 6067 | 82860 | 1157 |
953111 | 953111 | 2021-01-22 | Sacramento | California | 6067 | 82302 | 1157 |
949866 | 949866 | 2021-01-21 | Sacramento | California | 6067 | 81686 | 1145 |
946620 | 946620 | 2021-01-20 | Sacramento | California | 6067 | 81182 | 1128 |
943373 | 943373 | 2021-01-19 | Sacramento | California | 6067 | 80677 | 1111 |
940128 | 940128 | 2021-01-18 | Sacramento | California | 6067 | 80153 | 1080 |
936883 | 936883 | 2021-01-17 | Sacramento | California | 6067 | 79121 | 1080 |
933638 | 933638 | 2021-01-16 | Sacramento | California | 6067 | 80278 | 1080 |
930393 | 930393 | 2021-01-15 | Sacramento | California | 6067 | 79136 | 1080 |
927148 | 927148 | 2021-01-14 | Sacramento | California | 6067 | 78267 | 1062 |
923902 | 923902 | 2021-01-13 | Sacramento | California | 6067 | 77200 | 1044 |
920657 | 920657 | 2021-01-12 | Sacramento | California | 6067 | 76008 | 1031 |
917412 | 917412 | 2021-01-11 | Sacramento | California | 6067 | 75393 | 1015 |
914167 | 914167 | 2021-01-10 | Sacramento | California | 6067 | 74481 | 977 |
910922 | 910922 | 2021-01-09 | Sacramento | California | 6067 | 73244 | 977 |
907677 | 907677 | 2021-01-08 | Sacramento | California | 6067 | 72341 | 977 |
904431 | 904431 | 2021-01-07 | Sacramento | California | 6067 | 71571 | 955 |
901186 | 901186 | 2021-01-06 | Sacramento | California | 6067 | 70676 | 941 |
897941 | 897941 | 2021-01-05 | Sacramento | California | 6067 | 70163 | 917 |
894696 | 894696 | 2021-01-04 | Sacramento | California | 6067 | 69110 | 898 |
891449 | 891449 | 2021-01-03 | Sacramento | California | 6067 | 67809 | 857 |
888202 | 888202 | 2021-01-02 | Sacramento | California | 6067 | 66955 | 857 |
884957 | 884957 | 2021-01-01 | Sacramento | California | 6067 | 65816 | 857 |
881712 | 881712 | 2020-12-31 | Sacramento | California | 6067 | 65540 | 857 |
878467 | 878467 | 2020-12-30 | Sacramento | California | 6067 | 65077 | 844 |
875222 | 875222 | 2020-12-29 | Sacramento | California | 6067 | 64321 | 833 |
871977 | 871977 | 2020-12-28 | Sacramento | California | 6067 | 63415 | 827 |
868732 | 868732 | 2020-12-27 | Sacramento | California | 6067 | 62434 | 809 |
865487 | 865487 | 2020-12-26 | Sacramento | California | 6067 | 61629 | 809 |
862242 | 862242 | 2020-12-25 | Sacramento | California | 6067 | 60595 | 809 |
858997 | 858997 | 2020-12-24 | Sacramento | California | 6067 | 59769 | 809 |
855752 | 855752 | 2020-12-23 | Sacramento | California | 6067 | 58868 | 797 |
852507 | 852507 | 2020-12-22 | Sacramento | California | 6067 | 58000 | 786 |
849262 | 849262 | 2020-12-21 | Sacramento | California | 6067 | 57081 | 774 |
846017 | 846017 | 2020-12-20 | Sacramento | California | 6067 | 55168 | 741 |
842771 | 842771 | 2020-12-19 | Sacramento | California | 6067 | 54002 | 741 |
839526 | 839526 | 2020-12-18 | Sacramento | California | 6067 | 54002 | 741 |
836281 | 836281 | 2020-12-17 | Sacramento | California | 6067 | 53184 | 727 |
833035 | 833035 | 2020-12-16 | Sacramento | California | 6067 | 52181 | 711 |
829788 | 829788 | 2020-12-15 | Sacramento | California | 6067 | 51051 | 699 |
826542 | 826542 | 2020-12-14 | Sacramento | California | 6067 | 50222 | 689 |
823295 | 823295 | 2020-12-13 | Sacramento | California | 6067 | 48318 | 670 |
820049 | 820049 | 2020-12-12 | Sacramento | California | 6067 | 47472 | 670 |
816803 | 816803 | 2020-12-11 | Sacramento | California | 6067 | 47472 | 670 |
813557 | 813557 | 2020-12-10 | Sacramento | California | 6067 | 46478 | 659 |
810313 | 810313 | 2020-12-09 | Sacramento | California | 6067 | 45335 | 646 |
807068 | 807068 | 2020-12-08 | Sacramento | California | 6067 | 44687 | 635 |
803823 | 803823 | 2020-12-07 | Sacramento | California | 6067 | 43425 | 620 |
800578 | 800578 | 2020-12-06 | Sacramento | California | 6067 | 41877 | 614 |
797333 | 797333 | 2020-12-05 | Sacramento | California | 6067 | 41095 | 614 |
794088 | 794088 | 2020-12-04 | Sacramento | California | 6067 | 41095 | 614 |
790843 | 790843 | 2020-12-03 | Sacramento | California | 6067 | 40304 | 603 |
787598 | 787598 | 2020-12-02 | Sacramento | California | 6067 | 39366 | 591 |
784354 | 784354 | 2020-12-01 | Sacramento | California | 6067 | 38998 | 586 |
781109 | 781109 | 2020-11-30 | Sacramento | California | 6067 | 37883 | 581 |
777863 | 777863 | 2020-11-29 | Sacramento | California | 6067 | 36904 | 576 |
774618 | 774618 | 2020-11-28 | Sacramento | California | 6067 | 36629 | 576 |
771373 | 771373 | 2020-11-27 | Sacramento | California | 6067 | 36629 | 576 |
768128 | 768128 | 2020-11-26 | Sacramento | California | 6067 | 35738 | 566 |
764882 | 764882 | 2020-11-25 | Sacramento | California | 6067 | 35738 | 566 |
761637 | 761637 | 2020-11-24 | Sacramento | California | 6067 | 35142 | 557 |
758392 | 758392 | 2020-11-23 | Sacramento | California | 6067 | 34185 | 550 |
755145 | 755145 | 2020-11-22 | Sacramento | California | 6067 | 33132 | 546 |
751899 | 751899 | 2020-11-21 | Sacramento | California | 6067 | 32864 | 546 |
748653 | 748653 | 2020-11-20 | Sacramento | California | 6067 | 32864 | 546 |
745407 | 745407 | 2020-11-19 | Sacramento | California | 6067 | 32410 | 544 |
742160 | 742160 | 2020-11-18 | Sacramento | California | 6067 | 31851 | 536 |
738913 | 738913 | 2020-11-17 | Sacramento | California | 6067 | 31386 | 533 |
735669 | 735669 | 2020-11-16 | Sacramento | California | 6067 | 30998 | 527 |
732423 | 732423 | 2020-11-15 | Sacramento | California | 6067 | 30297 | 520 |
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);