ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Santa Barbara", fips = 6083 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
868740 | 868740 | 2020-12-27 | Santa Barbara | California | 6083 | 16265 | 153 |
865495 | 865495 | 2020-12-26 | Santa Barbara | California | 6083 | 16083 | 153 |
862250 | 862250 | 2020-12-25 | Santa Barbara | California | 6083 | 15657 | 151 |
859005 | 859005 | 2020-12-24 | Santa Barbara | California | 6083 | 15657 | 151 |
855760 | 855760 | 2020-12-23 | Santa Barbara | California | 6083 | 15417 | 151 |
852515 | 852515 | 2020-12-22 | Santa Barbara | California | 6083 | 15198 | 150 |
849270 | 849270 | 2020-12-21 | Santa Barbara | California | 6083 | 14935 | 148 |
846025 | 846025 | 2020-12-20 | Santa Barbara | California | 6083 | 14738 | 147 |
842779 | 842779 | 2020-12-19 | Santa Barbara | California | 6083 | 14391 | 147 |
839534 | 839534 | 2020-12-18 | Santa Barbara | California | 6083 | 14376 | 147 |
836289 | 836289 | 2020-12-17 | Santa Barbara | California | 6083 | 14190 | 145 |
833043 | 833043 | 2020-12-16 | Santa Barbara | California | 6083 | 13957 | 145 |
829796 | 829796 | 2020-12-15 | Santa Barbara | California | 6083 | 13763 | 142 |
826550 | 826550 | 2020-12-14 | Santa Barbara | California | 6083 | 13557 | 140 |
823303 | 823303 | 2020-12-13 | Santa Barbara | California | 6083 | 13198 | 140 |
820057 | 820057 | 2020-12-12 | Santa Barbara | California | 6083 | 13056 | 140 |
816811 | 816811 | 2020-12-11 | Santa Barbara | California | 6083 | 12866 | 140 |
813565 | 813565 | 2020-12-10 | Santa Barbara | California | 6083 | 12808 | 140 |
810321 | 810321 | 2020-12-09 | Santa Barbara | California | 6083 | 12636 | 139 |
807076 | 807076 | 2020-12-08 | Santa Barbara | California | 6083 | 12502 | 139 |
803831 | 803831 | 2020-12-07 | Santa Barbara | California | 6083 | 12379 | 138 |
800586 | 800586 | 2020-12-06 | Santa Barbara | California | 6083 | 12107 | 138 |
797341 | 797341 | 2020-12-05 | Santa Barbara | California | 6083 | 11947 | 138 |
794096 | 794096 | 2020-12-04 | Santa Barbara | California | 6083 | 11917 | 138 |
790851 | 790851 | 2020-12-03 | Santa Barbara | California | 6083 | 11845 | 138 |
787606 | 787606 | 2020-12-02 | Santa Barbara | California | 6083 | 11720 | 138 |
784362 | 784362 | 2020-12-01 | Santa Barbara | California | 6083 | 11631 | 137 |
781117 | 781117 | 2020-11-30 | Santa Barbara | California | 6083 | 11602 | 136 |
777871 | 777871 | 2020-11-29 | Santa Barbara | California | 6083 | 11481 | 135 |
774626 | 774626 | 2020-11-28 | Santa Barbara | California | 6083 | 11340 | 135 |
771381 | 771381 | 2020-11-27 | Santa Barbara | California | 6083 | 11277 | 135 |
768136 | 768136 | 2020-11-26 | Santa Barbara | California | 6083 | 11205 | 135 |
764890 | 764890 | 2020-11-25 | Santa Barbara | California | 6083 | 11205 | 135 |
761645 | 761645 | 2020-11-24 | Santa Barbara | California | 6083 | 11166 | 135 |
758400 | 758400 | 2020-11-23 | Santa Barbara | California | 6083 | 11067 | 133 |
755153 | 755153 | 2020-11-22 | Santa Barbara | California | 6083 | 10922 | 133 |
751907 | 751907 | 2020-11-21 | Santa Barbara | California | 6083 | 10839 | 133 |
748661 | 748661 | 2020-11-20 | Santa Barbara | California | 6083 | 10839 | 133 |
745415 | 745415 | 2020-11-19 | Santa Barbara | California | 6083 | 10768 | 133 |
742168 | 742168 | 2020-11-18 | Santa Barbara | California | 6083 | 10702 | 133 |
738921 | 738921 | 2020-11-17 | Santa Barbara | California | 6083 | 10612 | 133 |
735677 | 735677 | 2020-11-16 | Santa Barbara | California | 6083 | 10577 | 133 |
732431 | 732431 | 2020-11-15 | Santa Barbara | California | 6083 | 10482 | 131 |
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);