ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 6079 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277769 | 1277769 | 2021-05-02 | San Luis Obispo | California | 6079 | 21193 | 260 |
1274522 | 1274522 | 2021-05-01 | San Luis Obispo | California | 6079 | 21193 | 260 |
1271275 | 1271275 | 2021-04-30 | San Luis Obispo | California | 6079 | 21193 | 260 |
1268028 | 1268028 | 2021-04-29 | San Luis Obispo | California | 6079 | 21180 | 260 |
1264781 | 1264781 | 2021-04-28 | San Luis Obispo | California | 6079 | 21164 | 260 |
1261534 | 1261534 | 2021-04-27 | San Luis Obispo | California | 6079 | 21138 | 260 |
1258287 | 1258287 | 2021-04-26 | San Luis Obispo | California | 6079 | 21130 | 260 |
1255040 | 1255040 | 2021-04-25 | San Luis Obispo | California | 6079 | 21071 | 260 |
1251793 | 1251793 | 2021-04-24 | San Luis Obispo | California | 6079 | 21071 | 260 |
1248546 | 1248546 | 2021-04-23 | San Luis Obispo | California | 6079 | 21071 | 260 |
1245299 | 1245299 | 2021-04-22 | San Luis Obispo | California | 6079 | 21038 | 260 |
1242052 | 1242052 | 2021-04-21 | San Luis Obispo | California | 6079 | 21010 | 258 |
1238805 | 1238805 | 2021-04-20 | San Luis Obispo | California | 6079 | 20991 | 257 |
1235558 | 1235558 | 2021-04-19 | San Luis Obispo | California | 6079 | 20972 | 257 |
1232311 | 1232311 | 2021-04-18 | San Luis Obispo | California | 6079 | 20917 | 256 |
1229062 | 1229062 | 2021-04-17 | San Luis Obispo | California | 6079 | 20917 | 256 |
1225814 | 1225814 | 2021-04-16 | San Luis Obispo | California | 6079 | 20917 | 256 |
1222567 | 1222567 | 2021-04-15 | San Luis Obispo | California | 6079 | 20878 | 256 |
1219319 | 1219319 | 2021-04-14 | San Luis Obispo | California | 6079 | 20857 | 256 |
1216071 | 1216071 | 2021-04-13 | San Luis Obispo | California | 6079 | 20827 | 256 |
1212824 | 1212824 | 2021-04-12 | San Luis Obispo | California | 6079 | 20754 | 256 |
1209576 | 1209576 | 2021-04-11 | San Luis Obispo | California | 6079 | 20723 | 256 |
1206327 | 1206327 | 2021-04-10 | San Luis Obispo | California | 6079 | 20723 | 256 |
1203079 | 1203079 | 2021-04-09 | San Luis Obispo | California | 6079 | 20723 | 256 |
1199831 | 1199831 | 2021-04-08 | San Luis Obispo | California | 6079 | 20704 | 256 |
1196582 | 1196582 | 2021-04-07 | San Luis Obispo | California | 6079 | 20671 | 256 |
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 |
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);