ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053740 | 1053740 | 2021-02-22 | Sonoma | California | 6097 | 27793 | 295 |
1050493 | 1050493 | 2021-02-21 | Sonoma | California | 6097 | 27703 | 291 |
1047246 | 1047246 | 2021-02-20 | Sonoma | California | 6097 | 27606 | 291 |
1044001 | 1044001 | 2021-02-19 | Sonoma | California | 6097 | 27542 | 291 |
1040756 | 1040756 | 2021-02-18 | Sonoma | California | 6097 | 27414 | 291 |
1037511 | 1037511 | 2021-02-17 | Sonoma | California | 6097 | 27414 | 291 |
1034266 | 1034266 | 2021-02-16 | Sonoma | California | 6097 | 27361 | 291 |
1031020 | 1031020 | 2021-02-15 | Sonoma | California | 6097 | 27361 | 287 |
1027773 | 1027773 | 2021-02-14 | Sonoma | California | 6097 | 27249 | 287 |
1024528 | 1024528 | 2021-02-13 | Sonoma | California | 6097 | 27143 | 287 |
1021283 | 1021283 | 2021-02-12 | Sonoma | California | 6097 | 27133 | 287 |
1018038 | 1018038 | 2021-02-11 | Sonoma | California | 6097 | 27056 | 283 |
1014793 | 1014793 | 2021-02-10 | Sonoma | California | 6097 | 26971 | 283 |
1011548 | 1011548 | 2021-02-09 | Sonoma | California | 6097 | 26939 | 280 |
1008302 | 1008302 | 2021-02-08 | Sonoma | California | 6097 | 26909 | 277 |
1005056 | 1005056 | 2021-02-07 | Sonoma | California | 6097 | 26836 | 277 |
1001810 | 1001810 | 2021-02-06 | Sonoma | California | 6097 | 26674 | 275 |
998564 | 998564 | 2021-02-05 | Sonoma | California | 6097 | 26595 | 275 |
995318 | 995318 | 2021-02-04 | Sonoma | California | 6097 | 26430 | 270 |
992072 | 992072 | 2021-02-03 | Sonoma | California | 6097 | 26306 | 267 |
988826 | 988826 | 2021-02-02 | Sonoma | California | 6097 | 26250 | 267 |
985579 | 985579 | 2021-02-01 | Sonoma | California | 6097 | 26189 | 265 |
982332 | 982332 | 2021-01-31 | Sonoma | California | 6097 | 26108 | 260 |
979086 | 979086 | 2021-01-30 | Sonoma | California | 6097 | 25992 | 260 |
975841 | 975841 | 2021-01-29 | Sonoma | California | 6097 | 25825 | 260 |
972596 | 972596 | 2021-01-28 | Sonoma | California | 6097 | 25678 | 260 |
969351 | 969351 | 2021-01-27 | Sonoma | California | 6097 | 25536 | 254 |
966107 | 966107 | 2021-01-26 | Sonoma | California | 6097 | 25160 | 251 |
962862 | 962862 | 2021-01-25 | Sonoma | California | 6097 | 25141 | 251 |
959617 | 959617 | 2021-01-24 | Sonoma | California | 6097 | 24935 | 247 |
956371 | 956371 | 2021-01-23 | Sonoma | California | 6097 | 24761 | 247 |
953126 | 953126 | 2021-01-22 | Sonoma | California | 6097 | 24571 | 245 |
949881 | 949881 | 2021-01-21 | Sonoma | California | 6097 | 24469 | 245 |
946635 | 946635 | 2021-01-20 | Sonoma | California | 6097 | 24184 | 242 |
943388 | 943388 | 2021-01-19 | Sonoma | California | 6097 | 24068 | 240 |
940143 | 940143 | 2021-01-18 | Sonoma | California | 6097 | 23871 | 240 |
936898 | 936898 | 2021-01-17 | Sonoma | California | 6097 | 23607 | 234 |
933653 | 933653 | 2021-01-16 | Sonoma | California | 6097 | 23204 | 234 |
930408 | 930408 | 2021-01-15 | Sonoma | California | 6097 | 23089 | 234 |
927163 | 927163 | 2021-01-14 | Sonoma | California | 6097 | 22840 | 234 |
923917 | 923917 | 2021-01-13 | Sonoma | California | 6097 | 22531 | 227 |
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 |
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);