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 |
---|---|---|---|---|---|---|---|
1053748 | 1053748 | 2021-02-22 | Yolo | California | 6113 | 12670 | 181 |
1050501 | 1050501 | 2021-02-21 | Yolo | California | 6113 | 12639 | 181 |
1047254 | 1047254 | 2021-02-20 | Yolo | California | 6113 | 12606 | 181 |
1044009 | 1044009 | 2021-02-19 | Yolo | California | 6113 | 12549 | 181 |
1040764 | 1040764 | 2021-02-18 | Yolo | California | 6113 | 12506 | 181 |
1037519 | 1037519 | 2021-02-17 | Yolo | California | 6113 | 12457 | 181 |
1034274 | 1034274 | 2021-02-16 | Yolo | California | 6113 | 12412 | 172 |
1031028 | 1031028 | 2021-02-15 | Yolo | California | 6113 | 12399 | 172 |
1027781 | 1027781 | 2021-02-14 | Yolo | California | 6113 | 12374 | 172 |
1024536 | 1024536 | 2021-02-13 | Yolo | California | 6113 | 12340 | 172 |
1021291 | 1021291 | 2021-02-12 | Yolo | California | 6113 | 12303 | 172 |
1018046 | 1018046 | 2021-02-11 | Yolo | California | 6113 | 12276 | 172 |
1014801 | 1014801 | 2021-02-10 | Yolo | California | 6113 | 12220 | 172 |
1011556 | 1011556 | 2021-02-09 | Yolo | California | 6113 | 12169 | 170 |
1008310 | 1008310 | 2021-02-08 | Yolo | California | 6113 | 12135 | 158 |
1005064 | 1005064 | 2021-02-07 | Yolo | California | 6113 | 12061 | 158 |
1001818 | 1001818 | 2021-02-06 | Yolo | California | 6113 | 12025 | 158 |
998572 | 998572 | 2021-02-05 | Yolo | California | 6113 | 11982 | 158 |
995326 | 995326 | 2021-02-04 | Yolo | California | 6113 | 11933 | 158 |
992080 | 992080 | 2021-02-03 | Yolo | California | 6113 | 11886 | 158 |
988834 | 988834 | 2021-02-02 | Yolo | California | 6113 | 11824 | 156 |
985587 | 985587 | 2021-02-01 | Yolo | California | 6113 | 11771 | 149 |
982340 | 982340 | 2021-01-31 | Yolo | California | 6113 | 11698 | 149 |
979094 | 979094 | 2021-01-30 | Yolo | California | 6113 | 11612 | 149 |
975849 | 975849 | 2021-01-29 | Yolo | California | 6113 | 11500 | 149 |
972604 | 972604 | 2021-01-28 | Yolo | California | 6113 | 11427 | 149 |
969359 | 969359 | 2021-01-27 | Yolo | California | 6113 | 11361 | 147 |
966115 | 966115 | 2021-01-26 | Yolo | California | 6113 | 11276 | 146 |
962870 | 962870 | 2021-01-25 | Yolo | California | 6113 | 11210 | 138 |
959625 | 959625 | 2021-01-24 | Yolo | California | 6113 | 11087 | 138 |
956379 | 956379 | 2021-01-23 | Yolo | California | 6113 | 11014 | 138 |
953134 | 953134 | 2021-01-22 | Yolo | California | 6113 | 10940 | 138 |
949889 | 949889 | 2021-01-21 | Yolo | California | 6113 | 10852 | 138 |
946643 | 946643 | 2021-01-20 | Yolo | California | 6113 | 10789 | 138 |
943396 | 943396 | 2021-01-19 | Yolo | California | 6113 | 10620 | 131 |
940151 | 940151 | 2021-01-18 | Yolo | California | 6113 | 10519 | 131 |
936906 | 936906 | 2021-01-17 | Yolo | California | 6113 | 10406 | 131 |
933661 | 933661 | 2021-01-16 | Yolo | California | 6113 | 10240 | 131 |
930416 | 930416 | 2021-01-15 | Yolo | California | 6113 | 10097 | 131 |
927171 | 927171 | 2021-01-14 | Yolo | California | 6113 | 9933 | 131 |
923925 | 923925 | 2021-01-13 | Yolo | California | 6113 | 9857 | 131 |
920680 | 920680 | 2021-01-12 | Yolo | California | 6113 | 9699 | 130 |
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 |
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);