ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 6113 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917435 | 917435 | 2021-01-11 | Yolo | California | 6113 | 9610 | 127 |
914190 | 914190 | 2021-01-10 | Yolo | California | 6113 | 9524 | 127 |
910945 | 910945 | 2021-01-09 | Yolo | California | 6113 | 9391 | 127 |
907700 | 907700 | 2021-01-08 | Yolo | California | 6113 | 9207 | 127 |
904454 | 904454 | 2021-01-07 | Yolo | California | 6113 | 9083 | 126 |
901209 | 901209 | 2021-01-06 | Yolo | California | 6113 | 8980 | 125 |
897964 | 897964 | 2021-01-05 | Yolo | California | 6113 | 8834 | 123 |
894719 | 894719 | 2021-01-04 | Yolo | California | 6113 | 8673 | 117 |
891472 | 891472 | 2021-01-03 | Yolo | California | 6113 | 8571 | 117 |
888225 | 888225 | 2021-01-02 | Yolo | California | 6113 | 8461 | 117 |
884980 | 884980 | 2021-01-01 | Yolo | California | 6113 | 8295 | 111 |
881735 | 881735 | 2020-12-31 | Yolo | California | 6113 | 8238 | 111 |
878490 | 878490 | 2020-12-30 | Yolo | California | 6113 | 8124 | 109 |
875245 | 875245 | 2020-12-29 | Yolo | California | 6113 | 8031 | 109 |
872000 | 872000 | 2020-12-28 | Yolo | California | 6113 | 7919 | 109 |
868755 | 868755 | 2020-12-27 | Yolo | California | 6113 | 7793 | 109 |
865510 | 865510 | 2020-12-26 | Yolo | California | 6113 | 7700 | 109 |
862265 | 862265 | 2020-12-25 | Yolo | California | 6113 | 7566 | 110 |
859020 | 859020 | 2020-12-24 | Yolo | California | 6113 | 7508 | 110 |
855775 | 855775 | 2020-12-23 | Yolo | California | 6113 | 7388 | 108 |
852530 | 852530 | 2020-12-22 | Yolo | California | 6113 | 7266 | 108 |
849285 | 849285 | 2020-12-21 | Yolo | California | 6113 | 7121 | 104 |
846040 | 846040 | 2020-12-20 | Yolo | California | 6113 | 7025 | 104 |
842794 | 842794 | 2020-12-19 | Yolo | California | 6113 | 6901 | 104 |
839549 | 839549 | 2020-12-18 | Yolo | California | 6113 | 6800 | 104 |
836304 | 836304 | 2020-12-17 | Yolo | California | 6113 | 6649 | 99 |
833058 | 833058 | 2020-12-16 | Yolo | California | 6113 | 6531 | 98 |
829811 | 829811 | 2020-12-15 | Yolo | California | 6113 | 6389 | 98 |
826565 | 826565 | 2020-12-14 | Yolo | California | 6113 | 6267 | 89 |
823318 | 823318 | 2020-12-13 | Yolo | California | 6113 | 6117 | 89 |
820072 | 820072 | 2020-12-12 | Yolo | California | 6113 | 6049 | 89 |
816826 | 816826 | 2020-12-11 | Yolo | California | 6113 | 5979 | 89 |
813580 | 813580 | 2020-12-10 | Yolo | California | 6113 | 5774 | 89 |
810336 | 810336 | 2020-12-09 | Yolo | California | 6113 | 5639 | 89 |
807091 | 807091 | 2020-12-08 | Yolo | California | 6113 | 5549 | 84 |
803846 | 803846 | 2020-12-07 | Yolo | California | 6113 | 5492 | 84 |
800601 | 800601 | 2020-12-06 | Yolo | California | 6113 | 5372 | 84 |
797356 | 797356 | 2020-12-05 | Yolo | California | 6113 | 5310 | 84 |
794111 | 794111 | 2020-12-04 | Yolo | California | 6113 | 5167 | 81 |
790866 | 790866 | 2020-12-03 | Yolo | California | 6113 | 5068 | 81 |
787621 | 787621 | 2020-12-02 | Yolo | California | 6113 | 5020 | 81 |
784377 | 784377 | 2020-12-01 | Yolo | California | 6113 | 4930 | 77 |
781132 | 781132 | 2020-11-30 | Yolo | California | 6113 | 4893 | 77 |
777886 | 777886 | 2020-11-29 | Yolo | California | 6113 | 4827 | 76 |
774641 | 774641 | 2020-11-28 | Yolo | California | 6113 | 4737 | 75 |
771396 | 771396 | 2020-11-27 | Yolo | California | 6113 | 4626 | 75 |
768151 | 768151 | 2020-11-26 | Yolo | California | 6113 | 4561 | 74 |
764905 | 764905 | 2020-11-25 | Yolo | California | 6113 | 4476 | 74 |
761660 | 761660 | 2020-11-24 | Yolo | California | 6113 | 4363 | 74 |
758415 | 758415 | 2020-11-23 | Yolo | California | 6113 | 4257 | 75 |
755168 | 755168 | 2020-11-22 | Yolo | California | 6113 | 4199 | 75 |
751922 | 751922 | 2020-11-21 | Yolo | California | 6113 | 4139 | 75 |
748676 | 748676 | 2020-11-20 | Yolo | California | 6113 | 4050 | 74 |
745430 | 745430 | 2020-11-19 | Yolo | California | 6113 | 3981 | 72 |
742183 | 742183 | 2020-11-18 | Yolo | California | 6113 | 3933 | 71 |
738936 | 738936 | 2020-11-17 | Yolo | California | 6113 | 3892 | 70 |
735692 | 735692 | 2020-11-16 | Yolo | California | 6113 | 3863 | 70 |
732446 | 732446 | 2020-11-15 | Yolo | California | 6113 | 3814 | 68 |
729201 | 729201 | 2020-11-14 | Yolo | California | 6113 | 3761 | 66 |
725958 | 725958 | 2020-11-13 | Yolo | California | 6113 | 3720 | 66 |
722715 | 722715 | 2020-11-12 | Yolo | California | 6113 | 3649 | 64 |
719472 | 719472 | 2020-11-11 | Yolo | California | 6113 | 3612 | 64 |
716229 | 716229 | 2020-11-10 | Yolo | California | 6113 | 3577 | 64 |
712985 | 712985 | 2020-11-09 | Yolo | California | 6113 | 3527 | 63 |
709741 | 709741 | 2020-11-08 | Yolo | California | 6113 | 3494 | 63 |
706497 | 706497 | 2020-11-07 | Yolo | California | 6113 | 3463 | 63 |
703254 | 703254 | 2020-11-06 | Yolo | California | 6113 | 3423 | 63 |
700011 | 700011 | 2020-11-05 | Yolo | California | 6113 | 3395 | 62 |
696767 | 696767 | 2020-11-04 | Yolo | California | 6113 | 3363 | 62 |
693525 | 693525 | 2020-11-03 | Yolo | California | 6113 | 3344 | 61 |
690282 | 690282 | 2020-11-02 | Yolo | California | 6113 | 3320 | 61 |
687037 | 687037 | 2020-11-01 | Yolo | California | 6113 | 3303 | 60 |
683793 | 683793 | 2020-10-31 | Yolo | California | 6113 | 3292 | 60 |
680550 | 680550 | 2020-10-30 | Yolo | California | 6113 | 3266 | 60 |
677307 | 677307 | 2020-10-29 | Yolo | California | 6113 | 3250 | 60 |
674064 | 674064 | 2020-10-28 | Yolo | California | 6113 | 3234 | 60 |
670822 | 670822 | 2020-10-27 | Yolo | California | 6113 | 3219 | 59 |
667579 | 667579 | 2020-10-26 | Yolo | California | 6113 | 3207 | 59 |
664334 | 664334 | 2020-10-25 | Yolo | California | 6113 | 3191 | 59 |
661090 | 661090 | 2020-10-24 | Yolo | California | 6113 | 3166 | 58 |
657846 | 657846 | 2020-10-23 | Yolo | California | 6113 | 3144 | 58 |
654601 | 654601 | 2020-10-22 | Yolo | California | 6113 | 3119 | 58 |
651356 | 651356 | 2020-10-21 | Yolo | California | 6113 | 3099 | 58 |
648112 | 648112 | 2020-10-20 | Yolo | California | 6113 | 3086 | 56 |
644867 | 644867 | 2020-10-19 | Yolo | California | 6113 | 3073 | 56 |
641619 | 641619 | 2020-10-18 | Yolo | California | 6113 | 3063 | 56 |
638372 | 638372 | 2020-10-17 | Yolo | California | 6113 | 3046 | 56 |
635127 | 635127 | 2020-10-16 | Yolo | California | 6113 | 3034 | 56 |
631881 | 631881 | 2020-10-15 | Yolo | California | 6113 | 3015 | 56 |
628637 | 628637 | 2020-10-14 | Yolo | California | 6113 | 3010 | 56 |
625394 | 625394 | 2020-10-13 | Yolo | California | 6113 | 2986 | 56 |
622151 | 622151 | 2020-10-12 | Yolo | California | 6113 | 2966 | 56 |
618908 | 618908 | 2020-10-11 | Yolo | California | 6113 | 2954 | 56 |
615666 | 615666 | 2020-10-10 | Yolo | California | 6113 | 2942 | 56 |
612425 | 612425 | 2020-10-09 | Yolo | California | 6113 | 2929 | 56 |
609183 | 609183 | 2020-10-08 | Yolo | California | 6113 | 2918 | 56 |
605940 | 605940 | 2020-10-07 | Yolo | California | 6113 | 2909 | 56 |
602698 | 602698 | 2020-10-06 | Yolo | California | 6113 | 2903 | 56 |
599455 | 599455 | 2020-10-05 | Yolo | California | 6113 | 2893 | 56 |
596212 | 596212 | 2020-10-04 | Yolo | California | 6113 | 2879 | 56 |
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);