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 |
---|---|---|---|---|---|---|---|
1193343 | 1193343 | 2021-04-06 | Sonoma | California | 6097 | 29423 | 311 |
1190093 | 1190093 | 2021-04-05 | Sonoma | California | 6097 | 29402 | 311 |
1186846 | 1186846 | 2021-04-04 | Sonoma | California | 6097 | 29372 | 311 |
1183599 | 1183599 | 2021-04-03 | Sonoma | California | 6097 | 29349 | 311 |
1180352 | 1180352 | 2021-04-02 | Sonoma | California | 6097 | 29310 | 311 |
1177105 | 1177105 | 2021-04-01 | Sonoma | California | 6097 | 29257 | 311 |
1173858 | 1173858 | 2021-03-31 | Sonoma | California | 6097 | 29255 | 311 |
1170611 | 1170611 | 2021-03-30 | Sonoma | California | 6097 | 29235 | 310 |
1167363 | 1167363 | 2021-03-29 | Sonoma | California | 6097 | 29219 | 310 |
1164115 | 1164115 | 2021-03-28 | Sonoma | California | 6097 | 29199 | 310 |
1160867 | 1160867 | 2021-03-27 | Sonoma | California | 6097 | 29122 | 310 |
1157619 | 1157619 | 2021-03-26 | Sonoma | California | 6097 | 29122 | 310 |
1154372 | 1154372 | 2021-03-25 | Sonoma | California | 6097 | 29090 | 310 |
1151125 | 1151125 | 2021-03-24 | Sonoma | California | 6097 | 29059 | 310 |
1147878 | 1147878 | 2021-03-23 | Sonoma | California | 6097 | 29045 | 310 |
1144631 | 1144631 | 2021-03-22 | Sonoma | California | 6097 | 29006 | 310 |
1141384 | 1141384 | 2021-03-21 | Sonoma | California | 6097 | 28981 | 309 |
1138138 | 1138138 | 2021-03-20 | Sonoma | California | 6097 | 28943 | 308 |
1134892 | 1134892 | 2021-03-19 | Sonoma | California | 6097 | 28915 | 308 |
1131645 | 1131645 | 2021-03-18 | Sonoma | California | 6097 | 28882 | 308 |
1128397 | 1128397 | 2021-03-17 | Sonoma | California | 6097 | 28850 | 308 |
1125151 | 1125151 | 2021-03-16 | Sonoma | California | 6097 | 28820 | 308 |
1121905 | 1121905 | 2021-03-15 | Sonoma | California | 6097 | 28798 | 308 |
1118658 | 1118658 | 2021-03-14 | Sonoma | California | 6097 | 28762 | 308 |
1115411 | 1115411 | 2021-03-13 | Sonoma | California | 6097 | 28714 | 306 |
1112165 | 1112165 | 2021-03-12 | Sonoma | California | 6097 | 28677 | 306 |
1108919 | 1108919 | 2021-03-11 | Sonoma | California | 6097 | 28638 | 306 |
1105673 | 1105673 | 2021-03-10 | Sonoma | California | 6097 | 28601 | 306 |
1102427 | 1102427 | 2021-03-09 | Sonoma | California | 6097 | 28571 | 306 |
1099181 | 1099181 | 2021-03-08 | Sonoma | California | 6097 | 28533 | 303 |
1095933 | 1095933 | 2021-03-07 | Sonoma | California | 6097 | 28484 | 303 |
1092687 | 1092687 | 2021-03-06 | Sonoma | California | 6097 | 28417 | 303 |
1089441 | 1089441 | 2021-03-05 | Sonoma | California | 6097 | 28379 | 301 |
1086196 | 1086196 | 2021-03-04 | Sonoma | California | 6097 | 28307 | 301 |
1082950 | 1082950 | 2021-03-03 | Sonoma | California | 6097 | 28261 | 301 |
1079704 | 1079704 | 2021-03-02 | Sonoma | California | 6097 | 28222 | 298 |
1076459 | 1076459 | 2021-03-01 | Sonoma | California | 6097 | 28193 | 298 |
1073213 | 1073213 | 2021-02-28 | Sonoma | California | 6097 | 28141 | 298 |
1069967 | 1069967 | 2021-02-27 | Sonoma | California | 6097 | 28063 | 298 |
1066722 | 1066722 | 2021-02-26 | Sonoma | California | 6097 | 28004 | 298 |
1063477 | 1063477 | 2021-02-25 | Sonoma | California | 6097 | 27954 | 298 |
1060232 | 1060232 | 2021-02-24 | Sonoma | California | 6097 | 27882 | 295 |
1056986 | 1056986 | 2021-02-23 | Sonoma | California | 6097 | 27845 | 295 |
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 |
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);