ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "San Luis Obispo" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053731 | 1053731 | 2021-02-22 | San Luis Obispo | California | 6079 | 19458 | 220 |
1050484 | 1050484 | 2021-02-21 | San Luis Obispo | California | 6079 | 19340 | 217 |
1047237 | 1047237 | 2021-02-20 | San Luis Obispo | California | 6079 | 19340 | 217 |
1043992 | 1043992 | 2021-02-19 | San Luis Obispo | California | 6079 | 19340 | 217 |
1040747 | 1040747 | 2021-02-18 | San Luis Obispo | California | 6079 | 19283 | 210 |
1037502 | 1037502 | 2021-02-17 | San Luis Obispo | California | 6079 | 19248 | 210 |
1034257 | 1034257 | 2021-02-16 | San Luis Obispo | California | 6079 | 19210 | 210 |
1031011 | 1031011 | 2021-02-15 | San Luis Obispo | California | 6079 | 18889 | 205 |
1027764 | 1027764 | 2021-02-14 | San Luis Obispo | California | 6079 | 18889 | 205 |
1024519 | 1024519 | 2021-02-13 | San Luis Obispo | California | 6079 | 18889 | 205 |
1021274 | 1021274 | 2021-02-12 | San Luis Obispo | California | 6079 | 18889 | 205 |
1018029 | 1018029 | 2021-02-11 | San Luis Obispo | California | 6079 | 18889 | 205 |
1014784 | 1014784 | 2021-02-10 | San Luis Obispo | California | 6079 | 18838 | 202 |
1011539 | 1011539 | 2021-02-09 | San Luis Obispo | California | 6079 | 18788 | 200 |
1008293 | 1008293 | 2021-02-08 | San Luis Obispo | California | 6079 | 18684 | 196 |
1005047 | 1005047 | 2021-02-07 | San Luis Obispo | California | 6079 | 18467 | 194 |
1001801 | 1001801 | 2021-02-06 | San Luis Obispo | California | 6079 | 18467 | 194 |
998555 | 998555 | 2021-02-05 | San Luis Obispo | California | 6079 | 18467 | 194 |
995309 | 995309 | 2021-02-04 | San Luis Obispo | California | 6079 | 18353 | 192 |
992063 | 992063 | 2021-02-03 | San Luis Obispo | California | 6079 | 18186 | 187 |
988817 | 988817 | 2021-02-02 | San Luis Obispo | California | 6079 | 18038 | 178 |
985570 | 985570 | 2021-02-01 | San Luis Obispo | California | 6079 | 17887 | 177 |
982323 | 982323 | 2021-01-31 | San Luis Obispo | California | 6079 | 17605 | 168 |
979077 | 979077 | 2021-01-30 | San Luis Obispo | California | 6079 | 17605 | 168 |
975832 | 975832 | 2021-01-29 | San Luis Obispo | California | 6079 | 17605 | 168 |
972587 | 972587 | 2021-01-28 | San Luis Obispo | California | 6079 | 17511 | 164 |
969342 | 969342 | 2021-01-27 | San Luis Obispo | California | 6079 | 17366 | 161 |
966098 | 966098 | 2021-01-26 | San Luis Obispo | California | 6079 | 17151 | 161 |
962853 | 962853 | 2021-01-25 | San Luis Obispo | California | 6079 | 16957 | 158 |
959608 | 959608 | 2021-01-24 | San Luis Obispo | California | 6079 | 16652 | 151 |
956362 | 956362 | 2021-01-23 | San Luis Obispo | California | 6079 | 16437 | 151 |
953117 | 953117 | 2021-01-22 | San Luis Obispo | California | 6079 | 16437 | 151 |
949872 | 949872 | 2021-01-21 | San Luis Obispo | California | 6079 | 16228 | 151 |
946626 | 946626 | 2021-01-20 | San Luis Obispo | California | 6079 | 16056 | 140 |
943379 | 943379 | 2021-01-19 | San Luis Obispo | California | 6079 | 15929 | 136 |
940134 | 940134 | 2021-01-18 | San Luis Obispo | California | 6079 | 15658 | 135 |
936889 | 936889 | 2021-01-17 | San Luis Obispo | California | 6079 | 15466 | 128 |
933644 | 933644 | 2021-01-16 | San Luis Obispo | California | 6079 | 15129 | 128 |
930399 | 930399 | 2021-01-15 | San Luis Obispo | California | 6079 | 15102 | 128 |
927154 | 927154 | 2021-01-14 | San Luis Obispo | California | 6079 | 14778 | 125 |
923908 | 923908 | 2021-01-13 | San Luis Obispo | California | 6079 | 14425 | 119 |
920663 | 920663 | 2021-01-12 | San Luis Obispo | California | 6079 | 14233 | 115 |
917418 | 917418 | 2021-01-11 | San Luis Obispo | California | 6079 | 13968 | 111 |
914173 | 914173 | 2021-01-10 | San Luis Obispo | California | 6079 | 13647 | 101 |
910928 | 910928 | 2021-01-09 | San Luis Obispo | California | 6079 | 13286 | 101 |
907683 | 907683 | 2021-01-08 | San Luis Obispo | California | 6079 | 12891 | 101 |
904437 | 904437 | 2021-01-07 | San Luis Obispo | California | 6079 | 12597 | 95 |
901192 | 901192 | 2021-01-06 | San Luis Obispo | California | 6079 | 12185 | 95 |
897947 | 897947 | 2021-01-05 | San Luis Obispo | California | 6079 | 11945 | 90 |
894702 | 894702 | 2021-01-04 | San Luis Obispo | California | 6079 | 11635 | 88 |
891455 | 891455 | 2021-01-03 | San Luis Obispo | California | 6079 | 11467 | 82 |
888208 | 888208 | 2021-01-02 | San Luis Obispo | California | 6079 | 11160 | 82 |
884963 | 884963 | 2021-01-01 | San Luis Obispo | California | 6079 | 10846 | 82 |
881718 | 881718 | 2020-12-31 | San Luis Obispo | California | 6079 | 10490 | 82 |
878473 | 878473 | 2020-12-30 | San Luis Obispo | California | 6079 | 10387 | 82 |
875228 | 875228 | 2020-12-29 | San Luis Obispo | California | 6079 | 10260 | 74 |
871983 | 871983 | 2020-12-28 | San Luis Obispo | California | 6079 | 10154 | 70 |
868738 | 868738 | 2020-12-27 | San Luis Obispo | California | 6079 | 9945 | 67 |
865493 | 865493 | 2020-12-26 | San Luis Obispo | California | 6079 | 9749 | 67 |
862248 | 862248 | 2020-12-25 | San Luis Obispo | California | 6079 | 9504 | 67 |
859003 | 859003 | 2020-12-24 | San Luis Obispo | California | 6079 | 9471 | 67 |
855758 | 855758 | 2020-12-23 | San Luis Obispo | California | 6079 | 9303 | 66 |
852513 | 852513 | 2020-12-22 | San Luis Obispo | California | 6079 | 9061 | 65 |
849268 | 849268 | 2020-12-21 | San Luis Obispo | California | 6079 | 8881 | 60 |
846023 | 846023 | 2020-12-20 | San Luis Obispo | California | 6079 | 8788 | 59 |
842777 | 842777 | 2020-12-19 | San Luis Obispo | California | 6079 | 8598 | 59 |
839532 | 839532 | 2020-12-18 | San Luis Obispo | California | 6079 | 8460 | 59 |
836287 | 836287 | 2020-12-17 | San Luis Obispo | California | 6079 | 8269 | 56 |
833041 | 833041 | 2020-12-16 | San Luis Obispo | California | 6079 | 8090 | 54 |
829794 | 829794 | 2020-12-15 | San Luis Obispo | California | 6079 | 7895 | 52 |
826548 | 826548 | 2020-12-14 | San Luis Obispo | California | 6079 | 7711 | 46 |
823301 | 823301 | 2020-12-13 | San Luis Obispo | California | 6079 | 7462 | 46 |
820055 | 820055 | 2020-12-12 | San Luis Obispo | California | 6079 | 7452 | 46 |
816809 | 816809 | 2020-12-11 | San Luis Obispo | California | 6079 | 7452 | 46 |
813563 | 813563 | 2020-12-10 | San Luis Obispo | California | 6079 | 7267 | 45 |
810319 | 810319 | 2020-12-09 | San Luis Obispo | California | 6079 | 7071 | 45 |
807074 | 807074 | 2020-12-08 | San Luis Obispo | California | 6079 | 6965 | 42 |
803829 | 803829 | 2020-12-07 | San Luis Obispo | California | 6079 | 6873 | 42 |
800584 | 800584 | 2020-12-06 | San Luis Obispo | California | 6079 | 6623 | 42 |
797339 | 797339 | 2020-12-05 | San Luis Obispo | California | 6079 | 6540 | 42 |
794094 | 794094 | 2020-12-04 | San Luis Obispo | California | 6079 | 6540 | 42 |
790849 | 790849 | 2020-12-03 | San Luis Obispo | California | 6079 | 6459 | 38 |
787604 | 787604 | 2020-12-02 | San Luis Obispo | California | 6079 | 6378 | 38 |
784360 | 784360 | 2020-12-01 | San Luis Obispo | California | 6079 | 6345 | 38 |
781115 | 781115 | 2020-11-30 | San Luis Obispo | California | 6079 | 6311 | 38 |
777869 | 777869 | 2020-11-29 | San Luis Obispo | California | 6079 | 6129 | 36 |
774624 | 774624 | 2020-11-28 | San Luis Obispo | California | 6079 | 6129 | 36 |
771379 | 771379 | 2020-11-27 | San Luis Obispo | California | 6079 | 6129 | 36 |
768134 | 768134 | 2020-11-26 | San Luis Obispo | California | 6079 | 5956 | 35 |
764888 | 764888 | 2020-11-25 | San Luis Obispo | California | 6079 | 5956 | 35 |
761643 | 761643 | 2020-11-24 | San Luis Obispo | California | 6079 | 5885 | 35 |
758398 | 758398 | 2020-11-23 | San Luis Obispo | California | 6079 | 5811 | 35 |
755151 | 755151 | 2020-11-22 | San Luis Obispo | California | 6079 | 5618 | 35 |
751905 | 751905 | 2020-11-21 | San Luis Obispo | California | 6079 | 5607 | 35 |
748659 | 748659 | 2020-11-20 | San Luis Obispo | California | 6079 | 5607 | 35 |
745413 | 745413 | 2020-11-19 | San Luis Obispo | California | 6079 | 5486 | 35 |
742166 | 742166 | 2020-11-18 | San Luis Obispo | California | 6079 | 5400 | 34 |
738919 | 738919 | 2020-11-17 | San Luis Obispo | California | 6079 | 5321 | 34 |
735675 | 735675 | 2020-11-16 | San Luis Obispo | California | 6079 | 5250 | 34 |
732429 | 732429 | 2020-11-15 | San Luis Obispo | California | 6079 | 5073 | 33 |
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);