ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Santa Barbara" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193336 | 1193336 | 2021-04-06 | Santa Barbara | California | 6083 | 33381 | 443 |
1190086 | 1190086 | 2021-04-05 | Santa Barbara | California | 6083 | 33358 | 443 |
1186839 | 1186839 | 2021-04-04 | Santa Barbara | California | 6083 | 33297 | 443 |
1183592 | 1183592 | 2021-04-03 | Santa Barbara | California | 6083 | 33297 | 443 |
1180345 | 1180345 | 2021-04-02 | Santa Barbara | California | 6083 | 33270 | 443 |
1177098 | 1177098 | 2021-04-01 | Santa Barbara | California | 6083 | 33217 | 443 |
1173851 | 1173851 | 2021-03-31 | Santa Barbara | California | 6083 | 33174 | 441 |
1170604 | 1170604 | 2021-03-30 | Santa Barbara | California | 6083 | 33134 | 439 |
1167356 | 1167356 | 2021-03-29 | Santa Barbara | California | 6083 | 33105 | 439 |
1164108 | 1164108 | 2021-03-28 | Santa Barbara | California | 6083 | 33077 | 439 |
1160860 | 1160860 | 2021-03-27 | Santa Barbara | California | 6083 | 33045 | 439 |
1157612 | 1157612 | 2021-03-26 | Santa Barbara | California | 6083 | 33020 | 439 |
1154365 | 1154365 | 2021-03-25 | Santa Barbara | California | 6083 | 32982 | 438 |
1151118 | 1151118 | 2021-03-24 | Santa Barbara | California | 6083 | 32933 | 438 |
1147871 | 1147871 | 2021-03-23 | Santa Barbara | California | 6083 | 32895 | 437 |
1144624 | 1144624 | 2021-03-22 | Santa Barbara | California | 6083 | 32873 | 437 |
1141377 | 1141377 | 2021-03-21 | Santa Barbara | California | 6083 | 32859 | 435 |
1138131 | 1138131 | 2021-03-20 | Santa Barbara | California | 6083 | 32836 | 435 |
1134885 | 1134885 | 2021-03-19 | Santa Barbara | California | 6083 | 32798 | 435 |
1131638 | 1131638 | 2021-03-18 | Santa Barbara | California | 6083 | 32755 | 434 |
1128390 | 1128390 | 2021-03-17 | Santa Barbara | California | 6083 | 32703 | 433 |
1125144 | 1125144 | 2021-03-16 | Santa Barbara | California | 6083 | 32669 | 431 |
1121898 | 1121898 | 2021-03-15 | Santa Barbara | California | 6083 | 32634 | 431 |
1118651 | 1118651 | 2021-03-14 | Santa Barbara | California | 6083 | 32621 | 431 |
1115404 | 1115404 | 2021-03-13 | Santa Barbara | California | 6083 | 32595 | 429 |
1112158 | 1112158 | 2021-03-12 | Santa Barbara | California | 6083 | 32573 | 428 |
1108912 | 1108912 | 2021-03-11 | Santa Barbara | California | 6083 | 32519 | 426 |
1105666 | 1105666 | 2021-03-10 | Santa Barbara | California | 6083 | 32474 | 425 |
1102420 | 1102420 | 2021-03-09 | Santa Barbara | California | 6083 | 32436 | 424 |
1099174 | 1099174 | 2021-03-08 | Santa Barbara | California | 6083 | 32414 | 424 |
1095926 | 1095926 | 2021-03-07 | Santa Barbara | California | 6083 | 32347 | 423 |
1092680 | 1092680 | 2021-03-06 | Santa Barbara | California | 6083 | 32301 | 423 |
1089434 | 1089434 | 2021-03-05 | Santa Barbara | California | 6083 | 32267 | 422 |
1086189 | 1086189 | 2021-03-04 | Santa Barbara | California | 6083 | 32219 | 421 |
1082943 | 1082943 | 2021-03-03 | Santa Barbara | California | 6083 | 32147 | 420 |
1079697 | 1079697 | 2021-03-02 | Santa Barbara | California | 6083 | 32087 | 416 |
1076452 | 1076452 | 2021-03-01 | Santa Barbara | California | 6083 | 32050 | 413 |
1073206 | 1073206 | 2021-02-28 | Santa Barbara | California | 6083 | 32017 | 411 |
1069960 | 1069960 | 2021-02-27 | Santa Barbara | California | 6083 | 31951 | 411 |
1066715 | 1066715 | 2021-02-26 | Santa Barbara | California | 6083 | 31867 | 409 |
1063470 | 1063470 | 2021-02-25 | Santa Barbara | California | 6083 | 31763 | 407 |
1060225 | 1060225 | 2021-02-24 | Santa Barbara | California | 6083 | 31567 | 398 |
1056979 | 1056979 | 2021-02-23 | Santa Barbara | California | 6083 | 31567 | 396 |
1053733 | 1053733 | 2021-02-22 | Santa Barbara | California | 6083 | 31567 | 396 |
1050486 | 1050486 | 2021-02-21 | Santa Barbara | California | 6083 | 31518 | 394 |
1047239 | 1047239 | 2021-02-20 | Santa Barbara | California | 6083 | 31432 | 394 |
1043994 | 1043994 | 2021-02-19 | Santa Barbara | California | 6083 | 31334 | 392 |
1040749 | 1040749 | 2021-02-18 | Santa Barbara | California | 6083 | 31185 | 388 |
1037504 | 1037504 | 2021-02-17 | Santa Barbara | California | 6083 | 31067 | 381 |
1034259 | 1034259 | 2021-02-16 | Santa Barbara | California | 6083 | 30991 | 376 |
1031013 | 1031013 | 2021-02-15 | Santa Barbara | California | 6083 | 30862 | 372 |
1027766 | 1027766 | 2021-02-14 | Santa Barbara | California | 6083 | 30862 | 372 |
1024521 | 1024521 | 2021-02-13 | Santa Barbara | California | 6083 | 30728 | 372 |
1021276 | 1021276 | 2021-02-12 | Santa Barbara | California | 6083 | 30586 | 367 |
1018031 | 1018031 | 2021-02-11 | Santa Barbara | California | 6083 | 30502 | 366 |
1014786 | 1014786 | 2021-02-10 | Santa Barbara | California | 6083 | 30352 | 358 |
1011541 | 1011541 | 2021-02-09 | Santa Barbara | California | 6083 | 30206 | 348 |
1008295 | 1008295 | 2021-02-08 | Santa Barbara | California | 6083 | 30087 | 337 |
1005049 | 1005049 | 2021-02-07 | Santa Barbara | California | 6083 | 29941 | 336 |
1001803 | 1001803 | 2021-02-06 | Santa Barbara | California | 6083 | 29755 | 336 |
998557 | 998557 | 2021-02-05 | Santa Barbara | California | 6083 | 29564 | 334 |
995311 | 995311 | 2021-02-04 | Santa Barbara | California | 6083 | 29431 | 330 |
992065 | 992065 | 2021-02-03 | Santa Barbara | California | 6083 | 29191 | 316 |
988819 | 988819 | 2021-02-02 | Santa Barbara | California | 6083 | 29009 | 303 |
985572 | 985572 | 2021-02-01 | Santa Barbara | California | 6083 | 28830 | 298 |
982325 | 982325 | 2021-01-31 | Santa Barbara | California | 6083 | 28567 | 291 |
979079 | 979079 | 2021-01-30 | Santa Barbara | California | 6083 | 28338 | 291 |
975834 | 975834 | 2021-01-29 | Santa Barbara | California | 6083 | 28150 | 289 |
972589 | 972589 | 2021-01-28 | Santa Barbara | California | 6083 | 27754 | 285 |
969344 | 969344 | 2021-01-27 | Santa Barbara | California | 6083 | 27532 | 279 |
966100 | 966100 | 2021-01-26 | Santa Barbara | California | 6083 | 27149 | 267 |
962855 | 962855 | 2021-01-25 | Santa Barbara | California | 6083 | 27149 | 267 |
959610 | 959610 | 2021-01-24 | Santa Barbara | California | 6083 | 26820 | 265 |
956364 | 956364 | 2021-01-23 | Santa Barbara | California | 6083 | 26514 | 264 |
953119 | 953119 | 2021-01-22 | Santa Barbara | California | 6083 | 25986 | 260 |
949874 | 949874 | 2021-01-21 | Santa Barbara | California | 6083 | 25751 | 249 |
946628 | 946628 | 2021-01-20 | Santa Barbara | California | 6083 | 25083 | 236 |
943381 | 943381 | 2021-01-19 | Santa Barbara | California | 6083 | 25083 | 236 |
940136 | 940136 | 2021-01-18 | Santa Barbara | California | 6083 | 24481 | 231 |
936891 | 936891 | 2021-01-17 | Santa Barbara | California | 6083 | 24481 | 231 |
933646 | 933646 | 2021-01-16 | Santa Barbara | California | 6083 | 24149 | 231 |
930401 | 930401 | 2021-01-15 | Santa Barbara | California | 6083 | 23538 | 228 |
927156 | 927156 | 2021-01-14 | Santa Barbara | California | 6083 | 23184 | 223 |
923910 | 923910 | 2021-01-13 | Santa Barbara | California | 6083 | 22769 | 214 |
920665 | 920665 | 2021-01-12 | Santa Barbara | California | 6083 | 22237 | 207 |
917420 | 917420 | 2021-01-11 | Santa Barbara | California | 6083 | 21767 | 199 |
914175 | 914175 | 2021-01-10 | Santa Barbara | California | 6083 | 21323 | 197 |
910930 | 910930 | 2021-01-09 | Santa Barbara | California | 6083 | 20550 | 197 |
907685 | 907685 | 2021-01-08 | Santa Barbara | California | 6083 | 19953 | 185 |
904439 | 904439 | 2021-01-07 | Santa Barbara | California | 6083 | 19953 | 185 |
901194 | 901194 | 2021-01-06 | Santa Barbara | California | 6083 | 19448 | 181 |
897949 | 897949 | 2021-01-05 | Santa Barbara | California | 6083 | 19019 | 173 |
894704 | 894704 | 2021-01-04 | Santa Barbara | California | 6083 | 18680 | 166 |
891457 | 891457 | 2021-01-03 | Santa Barbara | California | 6083 | 18135 | 160 |
888210 | 888210 | 2021-01-02 | Santa Barbara | California | 6083 | 17759 | 160 |
884965 | 884965 | 2021-01-01 | Santa Barbara | California | 6083 | 17434 | 160 |
881720 | 881720 | 2020-12-31 | Santa Barbara | California | 6083 | 17391 | 160 |
878475 | 878475 | 2020-12-30 | Santa Barbara | California | 6083 | 17008 | 157 |
875230 | 875230 | 2020-12-29 | Santa Barbara | California | 6083 | 16732 | 156 |
871985 | 871985 | 2020-12-28 | Santa Barbara | California | 6083 | 16476 | 153 |
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);