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 |
---|---|---|---|---|---|---|---|
1277771 | 1277771 | 2021-05-02 | Santa Barbara | California | 6083 | 34180 | 453 |
1274524 | 1274524 | 2021-05-01 | Santa Barbara | California | 6083 | 34180 | 451 |
1271277 | 1271277 | 2021-04-30 | Santa Barbara | California | 6083 | 34180 | 448 |
1268030 | 1268030 | 2021-04-29 | Santa Barbara | California | 6083 | 34164 | 448 |
1264783 | 1264783 | 2021-04-28 | Santa Barbara | California | 6083 | 34128 | 448 |
1261536 | 1261536 | 2021-04-27 | Santa Barbara | California | 6083 | 34099 | 448 |
1258289 | 1258289 | 2021-04-26 | Santa Barbara | California | 6083 | 34073 | 448 |
1255042 | 1255042 | 2021-04-25 | Santa Barbara | California | 6083 | 34017 | 448 |
1251795 | 1251795 | 2021-04-24 | Santa Barbara | California | 6083 | 34017 | 447 |
1248548 | 1248548 | 2021-04-23 | Santa Barbara | California | 6083 | 34017 | 446 |
1245301 | 1245301 | 2021-04-22 | Santa Barbara | California | 6083 | 33994 | 445 |
1242054 | 1242054 | 2021-04-21 | Santa Barbara | California | 6083 | 33952 | 445 |
1238807 | 1238807 | 2021-04-20 | Santa Barbara | California | 6083 | 33926 | 446 |
1235560 | 1235560 | 2021-04-19 | Santa Barbara | California | 6083 | 33913 | 446 |
1232313 | 1232313 | 2021-04-18 | Santa Barbara | California | 6083 | 33896 | 446 |
1229064 | 1229064 | 2021-04-17 | Santa Barbara | California | 6083 | 33863 | 446 |
1225816 | 1225816 | 2021-04-16 | Santa Barbara | California | 6083 | 33830 | 446 |
1222569 | 1222569 | 2021-04-15 | Santa Barbara | California | 6083 | 33796 | 445 |
1219321 | 1219321 | 2021-04-14 | Santa Barbara | California | 6083 | 33774 | 444 |
1216073 | 1216073 | 2021-04-13 | Santa Barbara | California | 6083 | 33736 | 444 |
1212826 | 1212826 | 2021-04-12 | Santa Barbara | California | 6083 | 33727 | 444 |
1209578 | 1209578 | 2021-04-11 | Santa Barbara | California | 6083 | 33704 | 444 |
1206329 | 1206329 | 2021-04-10 | Santa Barbara | California | 6083 | 33655 | 444 |
1203081 | 1203081 | 2021-04-09 | Santa Barbara | California | 6083 | 33545 | 444 |
1199833 | 1199833 | 2021-04-08 | Santa Barbara | California | 6083 | 33427 | 444 |
1196584 | 1196584 | 2021-04-07 | Santa Barbara | California | 6083 | 33408 | 443 |
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 |
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);