ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
326 rows where fips = 6097 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933733 | 933733 | 2021-01-16 | Sonoma | California | 6097 | 23204 | 234 |
930488 | 930488 | 2021-01-15 | Sonoma | California | 6097 | 23089 | 234 |
927243 | 927243 | 2021-01-14 | Sonoma | California | 6097 | 22840 | 234 |
923997 | 923997 | 2021-01-13 | Sonoma | California | 6097 | 22531 | 227 |
920752 | 920752 | 2021-01-12 | Sonoma | California | 6097 | 22191 | 219 |
917507 | 917507 | 2021-01-11 | Sonoma | California | 6097 | 21925 | 218 |
914262 | 914262 | 2021-01-10 | Sonoma | California | 6097 | 21393 | 218 |
911017 | 911017 | 2021-01-09 | Sonoma | California | 6097 | 21264 | 218 |
907772 | 907772 | 2021-01-08 | Sonoma | California | 6097 | 21067 | 218 |
904526 | 904526 | 2021-01-07 | Sonoma | California | 6097 | 20752 | 214 |
901281 | 901281 | 2021-01-06 | Sonoma | California | 6097 | 20501 | 213 |
898036 | 898036 | 2021-01-05 | Sonoma | California | 6097 | 20210 | 204 |
894791 | 894791 | 2021-01-04 | Sonoma | California | 6097 | 20015 | 196 |
891544 | 891544 | 2021-01-03 | Sonoma | California | 6097 | 19761 | 196 |
888297 | 888297 | 2021-01-02 | Sonoma | California | 6097 | 19513 | 196 |
885052 | 885052 | 2021-01-01 | Sonoma | California | 6097 | 19129 | 192 |
881807 | 881807 | 2020-12-31 | Sonoma | California | 6097 | 19055 | 192 |
878562 | 878562 | 2020-12-30 | Sonoma | California | 6097 | 18872 | 184 |
875317 | 875317 | 2020-12-29 | Sonoma | California | 6097 | 18872 | 184 |
872072 | 872072 | 2020-12-28 | Sonoma | California | 6097 | 18649 | 182 |
868827 | 868827 | 2020-12-27 | Sonoma | California | 6097 | 18539 | 182 |
865582 | 865582 | 2020-12-26 | Sonoma | California | 6097 | 18147 | 182 |
862337 | 862337 | 2020-12-25 | Sonoma | California | 6097 | 17903 | 181 |
859092 | 859092 | 2020-12-24 | Sonoma | California | 6097 | 17444 | 180 |
855847 | 855847 | 2020-12-23 | Sonoma | California | 6097 | 17444 | 180 |
852602 | 852602 | 2020-12-22 | Sonoma | California | 6097 | 17075 | 177 |
849357 | 849357 | 2020-12-21 | Sonoma | California | 6097 | 16802 | 174 |
846112 | 846112 | 2020-12-20 | Sonoma | California | 6097 | 16706 | 174 |
842866 | 842866 | 2020-12-19 | Sonoma | California | 6097 | 16495 | 174 |
839621 | 839621 | 2020-12-18 | Sonoma | California | 6097 | 16024 | 171 |
836376 | 836376 | 2020-12-17 | Sonoma | California | 6097 | 16024 | 171 |
833130 | 833130 | 2020-12-16 | Sonoma | California | 6097 | 15702 | 166 |
829883 | 829883 | 2020-12-15 | Sonoma | California | 6097 | 15096 | 166 |
826637 | 826637 | 2020-12-14 | Sonoma | California | 6097 | 14859 | 164 |
823390 | 823390 | 2020-12-13 | Sonoma | California | 6097 | 14705 | 162 |
820144 | 820144 | 2020-12-12 | Sonoma | California | 6097 | 14475 | 162 |
816898 | 816898 | 2020-12-11 | Sonoma | California | 6097 | 14282 | 162 |
813652 | 813652 | 2020-12-10 | Sonoma | California | 6097 | 14168 | 162 |
810408 | 810408 | 2020-12-09 | Sonoma | California | 6097 | 13912 | 162 |
807163 | 807163 | 2020-12-08 | Sonoma | California | 6097 | 13719 | 160 |
803918 | 803918 | 2020-12-07 | Sonoma | California | 6097 | 13439 | 160 |
800672 | 800672 | 2020-12-06 | Sonoma | California | 6097 | 13369 | 160 |
797426 | 797426 | 2020-12-05 | Sonoma | California | 6097 | 13098 | 160 |
794181 | 794181 | 2020-12-04 | Sonoma | California | 6097 | 13098 | 160 |
790935 | 790935 | 2020-12-03 | Sonoma | California | 6097 | 12923 | 160 |
787689 | 787689 | 2020-12-02 | Sonoma | California | 6097 | 12795 | 160 |
784445 | 784445 | 2020-12-01 | Sonoma | California | 6097 | 12662 | 160 |
781200 | 781200 | 2020-11-30 | Sonoma | California | 6097 | 12319 | 157 |
777954 | 777954 | 2020-11-29 | Sonoma | California | 6097 | 12198 | 157 |
774708 | 774708 | 2020-11-28 | Sonoma | California | 6097 | 12049 | 157 |
771463 | 771463 | 2020-11-27 | Sonoma | California | 6097 | 12049 | 157 |
768217 | 768217 | 2020-11-26 | Sonoma | California | 6097 | 11846 | 157 |
764970 | 764970 | 2020-11-25 | Sonoma | California | 6097 | 11846 | 157 |
761724 | 761724 | 2020-11-24 | Sonoma | California | 6097 | 11608 | 155 |
758478 | 758478 | 2020-11-23 | Sonoma | California | 6097 | 11608 | 155 |
755231 | 755231 | 2020-11-22 | Sonoma | California | 6097 | 11486 | 155 |
751984 | 751984 | 2020-11-21 | Sonoma | California | 6097 | 11428 | 155 |
748737 | 748737 | 2020-11-20 | Sonoma | California | 6097 | 11363 | 155 |
745490 | 745490 | 2020-11-19 | Sonoma | California | 6097 | 11316 | 150 |
742243 | 742243 | 2020-11-18 | Sonoma | California | 6097 | 11169 | 150 |
738996 | 738996 | 2020-11-17 | Sonoma | California | 6097 | 11133 | 150 |
735751 | 735751 | 2020-11-16 | Sonoma | California | 6097 | 11055 | 150 |
732505 | 732505 | 2020-11-15 | Sonoma | California | 6097 | 10970 | 149 |
729260 | 729260 | 2020-11-14 | Sonoma | California | 6097 | 10845 | 149 |
726016 | 726016 | 2020-11-13 | Sonoma | California | 6097 | 10679 | 149 |
722772 | 722772 | 2020-11-12 | Sonoma | California | 6097 | 10679 | 149 |
719528 | 719528 | 2020-11-11 | Sonoma | California | 6097 | 10606 | 149 |
716284 | 716284 | 2020-11-10 | Sonoma | California | 6097 | 10505 | 149 |
713040 | 713040 | 2020-11-09 | Sonoma | California | 6097 | 10424 | 146 |
709796 | 709796 | 2020-11-08 | Sonoma | California | 6097 | 10248 | 146 |
706552 | 706552 | 2020-11-07 | Sonoma | California | 6097 | 10248 | 146 |
703309 | 703309 | 2020-11-06 | Sonoma | California | 6097 | 10170 | 146 |
700065 | 700065 | 2020-11-05 | Sonoma | California | 6097 | 10116 | 146 |
696820 | 696820 | 2020-11-04 | Sonoma | California | 6097 | 10041 | 142 |
693577 | 693577 | 2020-11-03 | Sonoma | California | 6097 | 9953 | 142 |
690334 | 690334 | 2020-11-02 | Sonoma | California | 6097 | 9866 | 142 |
687089 | 687089 | 2020-11-01 | Sonoma | California | 6097 | 9686 | 136 |
683844 | 683844 | 2020-10-31 | Sonoma | California | 6097 | 9686 | 136 |
680600 | 680600 | 2020-10-30 | Sonoma | California | 6097 | 9646 | 136 |
677357 | 677357 | 2020-10-29 | Sonoma | California | 6097 | 9601 | 136 |
674113 | 674113 | 2020-10-28 | Sonoma | California | 6097 | 9569 | 136 |
670871 | 670871 | 2020-10-27 | Sonoma | California | 6097 | 9494 | 136 |
667628 | 667628 | 2020-10-26 | Sonoma | California | 6097 | 9402 | 136 |
664382 | 664382 | 2020-10-25 | Sonoma | California | 6097 | 9312 | 136 |
661137 | 661137 | 2020-10-24 | Sonoma | California | 6097 | 9245 | 134 |
657893 | 657893 | 2020-10-23 | Sonoma | California | 6097 | 9163 | 134 |
654648 | 654648 | 2020-10-22 | Sonoma | California | 6097 | 9099 | 134 |
651403 | 651403 | 2020-10-21 | Sonoma | California | 6097 | 9073 | 134 |
648159 | 648159 | 2020-10-20 | Sonoma | California | 6097 | 9016 | 134 |
644914 | 644914 | 2020-10-19 | Sonoma | California | 6097 | 8934 | 129 |
641666 | 641666 | 2020-10-18 | Sonoma | California | 6097 | 8858 | 129 |
638419 | 638419 | 2020-10-17 | Sonoma | California | 6097 | 8810 | 129 |
635174 | 635174 | 2020-10-16 | Sonoma | California | 6097 | 8717 | 129 |
631928 | 631928 | 2020-10-15 | Sonoma | California | 6097 | 8684 | 128 |
628684 | 628684 | 2020-10-14 | Sonoma | California | 6097 | 8615 | 128 |
625441 | 625441 | 2020-10-13 | Sonoma | California | 6097 | 8558 | 128 |
622198 | 622198 | 2020-10-12 | Sonoma | California | 6097 | 8500 | 128 |
618955 | 618955 | 2020-10-11 | Sonoma | California | 6097 | 8422 | 128 |
615713 | 615713 | 2020-10-10 | Sonoma | California | 6097 | 8352 | 126 |
612472 | 612472 | 2020-10-09 | Sonoma | California | 6097 | 8270 | 126 |
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]);