ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920672 | 920672 | 2021-01-12 | Sonoma | California | 6097 | 22191 | 219 |
917427 | 917427 | 2021-01-11 | Sonoma | California | 6097 | 21925 | 218 |
914182 | 914182 | 2021-01-10 | Sonoma | California | 6097 | 21393 | 218 |
910937 | 910937 | 2021-01-09 | Sonoma | California | 6097 | 21264 | 218 |
907692 | 907692 | 2021-01-08 | Sonoma | California | 6097 | 21067 | 218 |
904446 | 904446 | 2021-01-07 | Sonoma | California | 6097 | 20752 | 214 |
901201 | 901201 | 2021-01-06 | Sonoma | California | 6097 | 20501 | 213 |
897956 | 897956 | 2021-01-05 | Sonoma | California | 6097 | 20210 | 204 |
894711 | 894711 | 2021-01-04 | Sonoma | California | 6097 | 20015 | 196 |
891464 | 891464 | 2021-01-03 | Sonoma | California | 6097 | 19761 | 196 |
888217 | 888217 | 2021-01-02 | Sonoma | California | 6097 | 19513 | 196 |
884972 | 884972 | 2021-01-01 | Sonoma | California | 6097 | 19129 | 192 |
881727 | 881727 | 2020-12-31 | Sonoma | California | 6097 | 19055 | 192 |
878482 | 878482 | 2020-12-30 | Sonoma | California | 6097 | 18872 | 184 |
875237 | 875237 | 2020-12-29 | Sonoma | California | 6097 | 18872 | 184 |
871992 | 871992 | 2020-12-28 | Sonoma | California | 6097 | 18649 | 182 |
868747 | 868747 | 2020-12-27 | Sonoma | California | 6097 | 18539 | 182 |
865502 | 865502 | 2020-12-26 | Sonoma | California | 6097 | 18147 | 182 |
862257 | 862257 | 2020-12-25 | Sonoma | California | 6097 | 17903 | 181 |
859012 | 859012 | 2020-12-24 | Sonoma | California | 6097 | 17444 | 180 |
855767 | 855767 | 2020-12-23 | Sonoma | California | 6097 | 17444 | 180 |
852522 | 852522 | 2020-12-22 | Sonoma | California | 6097 | 17075 | 177 |
849277 | 849277 | 2020-12-21 | Sonoma | California | 6097 | 16802 | 174 |
846032 | 846032 | 2020-12-20 | Sonoma | California | 6097 | 16706 | 174 |
842786 | 842786 | 2020-12-19 | Sonoma | California | 6097 | 16495 | 174 |
839541 | 839541 | 2020-12-18 | Sonoma | California | 6097 | 16024 | 171 |
836296 | 836296 | 2020-12-17 | Sonoma | California | 6097 | 16024 | 171 |
833050 | 833050 | 2020-12-16 | Sonoma | California | 6097 | 15702 | 166 |
829803 | 829803 | 2020-12-15 | Sonoma | California | 6097 | 15096 | 166 |
826557 | 826557 | 2020-12-14 | Sonoma | California | 6097 | 14859 | 164 |
823310 | 823310 | 2020-12-13 | Sonoma | California | 6097 | 14705 | 162 |
820064 | 820064 | 2020-12-12 | Sonoma | California | 6097 | 14475 | 162 |
816818 | 816818 | 2020-12-11 | Sonoma | California | 6097 | 14282 | 162 |
813572 | 813572 | 2020-12-10 | Sonoma | California | 6097 | 14168 | 162 |
810328 | 810328 | 2020-12-09 | Sonoma | California | 6097 | 13912 | 162 |
807083 | 807083 | 2020-12-08 | Sonoma | California | 6097 | 13719 | 160 |
803838 | 803838 | 2020-12-07 | Sonoma | California | 6097 | 13439 | 160 |
800593 | 800593 | 2020-12-06 | Sonoma | California | 6097 | 13369 | 160 |
797348 | 797348 | 2020-12-05 | Sonoma | California | 6097 | 13098 | 160 |
794103 | 794103 | 2020-12-04 | Sonoma | California | 6097 | 13098 | 160 |
790858 | 790858 | 2020-12-03 | Sonoma | California | 6097 | 12923 | 160 |
787613 | 787613 | 2020-12-02 | Sonoma | California | 6097 | 12795 | 160 |
784369 | 784369 | 2020-12-01 | Sonoma | California | 6097 | 12662 | 160 |
781124 | 781124 | 2020-11-30 | Sonoma | California | 6097 | 12319 | 157 |
777878 | 777878 | 2020-11-29 | Sonoma | California | 6097 | 12198 | 157 |
774633 | 774633 | 2020-11-28 | Sonoma | California | 6097 | 12049 | 157 |
771388 | 771388 | 2020-11-27 | Sonoma | California | 6097 | 12049 | 157 |
768143 | 768143 | 2020-11-26 | Sonoma | California | 6097 | 11846 | 157 |
764897 | 764897 | 2020-11-25 | Sonoma | California | 6097 | 11846 | 157 |
761652 | 761652 | 2020-11-24 | Sonoma | California | 6097 | 11608 | 155 |
758407 | 758407 | 2020-11-23 | Sonoma | California | 6097 | 11608 | 155 |
755160 | 755160 | 2020-11-22 | Sonoma | California | 6097 | 11486 | 155 |
751914 | 751914 | 2020-11-21 | Sonoma | California | 6097 | 11428 | 155 |
748668 | 748668 | 2020-11-20 | Sonoma | California | 6097 | 11363 | 155 |
745422 | 745422 | 2020-11-19 | Sonoma | California | 6097 | 11316 | 150 |
742175 | 742175 | 2020-11-18 | Sonoma | California | 6097 | 11169 | 150 |
738928 | 738928 | 2020-11-17 | Sonoma | California | 6097 | 11133 | 150 |
735684 | 735684 | 2020-11-16 | Sonoma | California | 6097 | 11055 | 150 |
732438 | 732438 | 2020-11-15 | Sonoma | California | 6097 | 10970 | 149 |
729193 | 729193 | 2020-11-14 | Sonoma | California | 6097 | 10845 | 149 |
725950 | 725950 | 2020-11-13 | Sonoma | California | 6097 | 10679 | 149 |
722707 | 722707 | 2020-11-12 | Sonoma | California | 6097 | 10679 | 149 |
719464 | 719464 | 2020-11-11 | Sonoma | California | 6097 | 10606 | 149 |
716221 | 716221 | 2020-11-10 | Sonoma | California | 6097 | 10505 | 149 |
712977 | 712977 | 2020-11-09 | Sonoma | California | 6097 | 10424 | 146 |
709733 | 709733 | 2020-11-08 | Sonoma | California | 6097 | 10248 | 146 |
706489 | 706489 | 2020-11-07 | Sonoma | California | 6097 | 10248 | 146 |
703246 | 703246 | 2020-11-06 | Sonoma | California | 6097 | 10170 | 146 |
700003 | 700003 | 2020-11-05 | Sonoma | California | 6097 | 10116 | 146 |
696759 | 696759 | 2020-11-04 | Sonoma | California | 6097 | 10041 | 142 |
693517 | 693517 | 2020-11-03 | Sonoma | California | 6097 | 9953 | 142 |
690274 | 690274 | 2020-11-02 | Sonoma | California | 6097 | 9866 | 142 |
687029 | 687029 | 2020-11-01 | Sonoma | California | 6097 | 9686 | 136 |
683785 | 683785 | 2020-10-31 | Sonoma | California | 6097 | 9686 | 136 |
680542 | 680542 | 2020-10-30 | Sonoma | California | 6097 | 9646 | 136 |
677299 | 677299 | 2020-10-29 | Sonoma | California | 6097 | 9601 | 136 |
674056 | 674056 | 2020-10-28 | Sonoma | California | 6097 | 9569 | 136 |
670814 | 670814 | 2020-10-27 | Sonoma | California | 6097 | 9494 | 136 |
667571 | 667571 | 2020-10-26 | Sonoma | California | 6097 | 9402 | 136 |
664326 | 664326 | 2020-10-25 | Sonoma | California | 6097 | 9312 | 136 |
661082 | 661082 | 2020-10-24 | Sonoma | California | 6097 | 9245 | 134 |
657838 | 657838 | 2020-10-23 | Sonoma | California | 6097 | 9163 | 134 |
654593 | 654593 | 2020-10-22 | Sonoma | California | 6097 | 9099 | 134 |
651348 | 651348 | 2020-10-21 | Sonoma | California | 6097 | 9073 | 134 |
648104 | 648104 | 2020-10-20 | Sonoma | California | 6097 | 9016 | 134 |
644859 | 644859 | 2020-10-19 | Sonoma | California | 6097 | 8934 | 129 |
641611 | 641611 | 2020-10-18 | Sonoma | California | 6097 | 8858 | 129 |
638364 | 638364 | 2020-10-17 | Sonoma | California | 6097 | 8810 | 129 |
635119 | 635119 | 2020-10-16 | Sonoma | California | 6097 | 8717 | 129 |
631873 | 631873 | 2020-10-15 | Sonoma | California | 6097 | 8684 | 128 |
628629 | 628629 | 2020-10-14 | Sonoma | California | 6097 | 8615 | 128 |
625386 | 625386 | 2020-10-13 | Sonoma | California | 6097 | 8558 | 128 |
622143 | 622143 | 2020-10-12 | Sonoma | California | 6097 | 8500 | 128 |
618900 | 618900 | 2020-10-11 | Sonoma | California | 6097 | 8422 | 128 |
615658 | 615658 | 2020-10-10 | Sonoma | California | 6097 | 8352 | 126 |
612417 | 612417 | 2020-10-09 | Sonoma | California | 6097 | 8270 | 126 |
609175 | 609175 | 2020-10-08 | Sonoma | California | 6097 | 8155 | 126 |
605932 | 605932 | 2020-10-07 | Sonoma | California | 6097 | 8083 | 126 |
602690 | 602690 | 2020-10-06 | Sonoma | California | 6097 | 8037 | 122 |
599447 | 599447 | 2020-10-05 | Sonoma | California | 6097 | 7940 | 122 |
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);