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 |
---|---|---|---|---|---|---|---|
1193334 | 1193334 | 2021-04-06 | San Luis Obispo | California | 6079 | 20649 | 256 |
1190084 | 1190084 | 2021-04-05 | San Luis Obispo | California | 6079 | 20606 | 256 |
1186837 | 1186837 | 2021-04-04 | San Luis Obispo | California | 6079 | 20547 | 256 |
1183590 | 1183590 | 2021-04-03 | San Luis Obispo | California | 6079 | 20547 | 256 |
1180343 | 1180343 | 2021-04-02 | San Luis Obispo | California | 6079 | 20547 | 256 |
1177096 | 1177096 | 2021-04-01 | San Luis Obispo | California | 6079 | 20522 | 256 |
1173849 | 1173849 | 2021-03-31 | San Luis Obispo | California | 6079 | 20505 | 256 |
1170602 | 1170602 | 2021-03-30 | San Luis Obispo | California | 6079 | 20475 | 255 |
1167354 | 1167354 | 2021-03-29 | San Luis Obispo | California | 6079 | 20433 | 255 |
1164106 | 1164106 | 2021-03-28 | San Luis Obispo | California | 6079 | 20402 | 255 |
1160858 | 1160858 | 2021-03-27 | San Luis Obispo | California | 6079 | 20402 | 255 |
1157610 | 1157610 | 2021-03-26 | San Luis Obispo | California | 6079 | 20402 | 255 |
1154363 | 1154363 | 2021-03-25 | San Luis Obispo | California | 6079 | 20354 | 253 |
1151116 | 1151116 | 2021-03-24 | San Luis Obispo | California | 6079 | 20309 | 253 |
1147869 | 1147869 | 2021-03-23 | San Luis Obispo | California | 6079 | 20303 | 253 |
1144622 | 1144622 | 2021-03-22 | San Luis Obispo | California | 6079 | 20260 | 253 |
1141375 | 1141375 | 2021-03-21 | San Luis Obispo | California | 6079 | 20189 | 253 |
1138129 | 1138129 | 2021-03-20 | San Luis Obispo | California | 6079 | 20189 | 253 |
1134883 | 1134883 | 2021-03-19 | San Luis Obispo | California | 6079 | 20189 | 253 |
1131636 | 1131636 | 2021-03-18 | San Luis Obispo | California | 6079 | 20172 | 253 |
1128388 | 1128388 | 2021-03-17 | San Luis Obispo | California | 6079 | 20136 | 253 |
1125142 | 1125142 | 2021-03-16 | San Luis Obispo | California | 6079 | 20115 | 253 |
1121896 | 1121896 | 2021-03-15 | San Luis Obispo | California | 6079 | 20078 | 253 |
1118649 | 1118649 | 2021-03-14 | San Luis Obispo | California | 6079 | 20041 | 251 |
1115402 | 1115402 | 2021-03-13 | San Luis Obispo | California | 6079 | 20041 | 251 |
1112156 | 1112156 | 2021-03-12 | San Luis Obispo | California | 6079 | 20041 | 251 |
1108910 | 1108910 | 2021-03-11 | San Luis Obispo | California | 6079 | 20017 | 251 |
1105664 | 1105664 | 2021-03-10 | San Luis Obispo | California | 6079 | 19966 | 248 |
1102418 | 1102418 | 2021-03-09 | San Luis Obispo | California | 6079 | 19927 | 248 |
1099172 | 1099172 | 2021-03-08 | San Luis Obispo | California | 6079 | 19860 | 247 |
1095924 | 1095924 | 2021-03-07 | San Luis Obispo | California | 6079 | 19835 | 246 |
1092678 | 1092678 | 2021-03-06 | San Luis Obispo | California | 6079 | 19835 | 246 |
1089432 | 1089432 | 2021-03-05 | San Luis Obispo | California | 6079 | 19835 | 246 |
1086187 | 1086187 | 2021-03-04 | San Luis Obispo | California | 6079 | 19797 | 241 |
1082941 | 1082941 | 2021-03-03 | San Luis Obispo | California | 6079 | 19751 | 238 |
1079695 | 1079695 | 2021-03-02 | San Luis Obispo | California | 6079 | 19724 | 236 |
1076450 | 1076450 | 2021-03-01 | San Luis Obispo | California | 6079 | 19696 | 235 |
1073204 | 1073204 | 2021-02-28 | San Luis Obispo | California | 6079 | 19643 | 227 |
1069958 | 1069958 | 2021-02-27 | San Luis Obispo | California | 6079 | 19643 | 227 |
1066713 | 1066713 | 2021-02-26 | San Luis Obispo | California | 6079 | 19643 | 227 |
1063468 | 1063468 | 2021-02-25 | San Luis Obispo | California | 6079 | 19612 | 227 |
1060223 | 1060223 | 2021-02-24 | San Luis Obispo | California | 6079 | 19500 | 221 |
1056977 | 1056977 | 2021-02-23 | San Luis Obispo | California | 6079 | 19500 | 221 |
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 |
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);