latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
110,660 rows where county = "San Diego" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases ▼ | note | population |
---|---|---|---|---|---|---|---|---|---|
1047309 | 1047309 | 92155 | 92155: Coronado | 2020-09-19 | San Diego | 73 | 0 | 0 | |
1047313 | 1047313 | 92672 | 92672: San Clemente | 2020-09-19 | San Diego | 73 | 0 | 0 | |
1048407 | 1048407 | 91931 | 91931: Guatay | 2020-09-18 | San Diego | 73 | 0 | 0 | |
1048501 | 1048501 | 92155 | 92155: Coronado | 2020-09-18 | San Diego | 73 | 0 | 0 | |
1048505 | 1048505 | 92672 | 92672: San Clemente | 2020-09-18 | San Diego | 73 | 0 | 0 | |
1049599 | 1049599 | 91931 | 91931: Guatay | 2020-09-17 | San Diego | 73 | 0 | 0 | |
1049693 | 1049693 | 92155 | 92155: Coronado | 2020-09-17 | San Diego | 73 | 0 | 0 | |
1049697 | 1049697 | 92672 | 92672: San Clemente | 2020-09-17 | San Diego | 73 | 0 | 0 | |
1050791 | 1050791 | 91931 | 91931: Guatay | 2020-09-16 | San Diego | 73 | 0 | 0 | |
1050885 | 1050885 | 92155 | 92155: Coronado | 2020-09-16 | San Diego | 73 | 0 | 0 | |
1050889 | 1050889 | 92672 | 92672: San Clemente | 2020-09-16 | San Diego | 73 | 0 | 0 | |
1051983 | 1051983 | 91931 | 91931: Guatay | 2020-09-15 | San Diego | 73 | 0 | 0 | |
1052077 | 1052077 | 92155 | 92155: Coronado | 2020-09-15 | San Diego | 73 | 0 | 0 | |
1052081 | 1052081 | 92672 | 92672: San Clemente | 2020-09-15 | San Diego | 73 | 0 | 0 | |
1053175 | 1053175 | 91931 | 91931: Guatay | 2020-09-14 | San Diego | 73 | 0 | 0 | |
1053269 | 1053269 | 92155 | 92155: Coronado | 2020-09-14 | San Diego | 73 | 0 | 0 | |
1053273 | 1053273 | 92672 | 92672: San Clemente | 2020-09-14 | San Diego | 73 | 0 | 0 | |
1054367 | 1054367 | 91931 | 91931: Guatay | 2020-09-13 | San Diego | 73 | 0 | 0 | |
1054461 | 1054461 | 92155 | 92155: Coronado | 2020-09-13 | San Diego | 73 | 0 | 0 | |
1054465 | 1054465 | 92672 | 92672: San Clemente | 2020-09-13 | San Diego | 73 | 0 | 0 | |
1055559 | 1055559 | 91931 | 91931: Guatay | 2020-09-12 | San Diego | 73 | 0 | 0 | |
1055653 | 1055653 | 92155 | 92155: Coronado | 2020-09-12 | San Diego | 73 | 0 | 0 | |
1055657 | 1055657 | 92672 | 92672: San Clemente | 2020-09-12 | San Diego | 73 | 0 | 0 | |
1056751 | 1056751 | 91931 | 91931: Guatay | 2020-09-11 | San Diego | 73 | 0 | 0 | |
1056845 | 1056845 | 92155 | 92155: Coronado | 2020-09-11 | San Diego | 73 | 0 | 0 | |
1056849 | 1056849 | 92672 | 92672: San Clemente | 2020-09-11 | San Diego | 73 | 0 | 0 | |
1057943 | 1057943 | 91931 | 91931: Guatay | 2020-09-10 | San Diego | 73 | 0 | 0 | |
1058037 | 1058037 | 92155 | 92155: Coronado | 2020-09-10 | San Diego | 73 | 0 | 0 | |
1058041 | 1058041 | 92672 | 92672: San Clemente | 2020-09-10 | San Diego | 73 | 0 | 0 | |
1059135 | 1059135 | 91931 | 91931: Guatay | 2020-09-09 | San Diego | 73 | 0 | 0 | |
1059229 | 1059229 | 92155 | 92155: Coronado | 2020-09-09 | San Diego | 73 | 0 | 0 | |
1059233 | 1059233 | 92672 | 92672: San Clemente | 2020-09-09 | San Diego | 73 | 0 | 0 | |
1060327 | 1060327 | 91931 | 91931: Guatay | 2020-09-08 | San Diego | 73 | 0 | 0 | |
1060384 | 1060384 | 92096 | 92096: San Marcos | 2020-09-08 | San Diego | 73 | 0 | 0 | |
1060421 | 1060421 | 92155 | 92155: Coronado | 2020-09-08 | San Diego | 73 | 0 | 0 | |
1060425 | 1060425 | 92672 | 92672: San Clemente | 2020-09-08 | San Diego | 73 | 0 | 0 | |
1061519 | 1061519 | 91931 | 91931: Guatay | 2020-09-07 | San Diego | 73 | 0 | 0 | |
1061576 | 1061576 | 92096 | 92096: San Marcos | 2020-09-07 | San Diego | 73 | 0 | 0 | |
1061613 | 1061613 | 92155 | 92155: Coronado | 2020-09-07 | San Diego | 73 | 0 | 0 | |
1061617 | 1061617 | 92672 | 92672: San Clemente | 2020-09-07 | San Diego | 73 | 0 | 0 | |
1062711 | 1062711 | 91931 | 91931: Guatay | 2020-09-06 | San Diego | 73 | 0 | 0 | |
1062768 | 1062768 | 92096 | 92096: San Marcos | 2020-09-06 | San Diego | 73 | 0 | 0 | |
1062805 | 1062805 | 92155 | 92155: Coronado | 2020-09-06 | San Diego | 73 | 0 | 0 | |
1062809 | 1062809 | 92672 | 92672: San Clemente | 2020-09-06 | San Diego | 73 | 0 | 0 | |
1063903 | 1063903 | 91931 | 91931: Guatay | 2020-09-05 | San Diego | 73 | 0 | 0 | |
1063960 | 1063960 | 92096 | 92096: San Marcos | 2020-09-05 | San Diego | 73 | 0 | 0 | |
1063997 | 1063997 | 92155 | 92155: Coronado | 2020-09-05 | San Diego | 73 | 0 | 0 | |
1064001 | 1064001 | 92672 | 92672: San Clemente | 2020-09-05 | San Diego | 73 | 0 | 0 | |
1065095 | 1065095 | 91931 | 91931: Guatay | 2020-09-04 | San Diego | 73 | 0 | 0 | |
1065152 | 1065152 | 92096 | 92096: San Marcos | 2020-09-04 | San Diego | 73 | 0 | 0 | |
1065189 | 1065189 | 92155 | 92155: Coronado | 2020-09-04 | San Diego | 73 | 0 | 0 | |
1065193 | 1065193 | 92672 | 92672: San Clemente | 2020-09-04 | San Diego | 73 | 0 | 0 | |
1066287 | 1066287 | 91931 | 91931: Guatay | 2020-09-03 | San Diego | 73 | 0 | 0 | |
1066344 | 1066344 | 92096 | 92096: San Marcos | 2020-09-03 | San Diego | 73 | 0 | 0 | |
1066381 | 1066381 | 92155 | 92155: Coronado | 2020-09-03 | San Diego | 73 | 0 | 0 | |
1066385 | 1066385 | 92672 | 92672: San Clemente | 2020-09-03 | San Diego | 73 | 0 | 0 | |
1067475 | 1067475 | 91931 | 91931: Guatay | 2020-09-02 | San Diego | 73 | 0 | 0 | |
1067532 | 1067532 | 92096 | 92096: San Marcos | 2020-09-02 | San Diego | 73 | 0 | 0 | |
1067569 | 1067569 | 92155 | 92155: Coronado | 2020-09-02 | San Diego | 73 | 0 | 0 | |
1067571 | 1067571 | 92182 | 92182: San Diego | 2020-09-02 | San Diego | 73 | 0 | 0 | |
1067573 | 1067573 | 92672 | 92672: San Clemente | 2020-09-02 | San Diego | 73 | 0 | 0 | |
1068663 | 1068663 | 91931 | 91931: Guatay | 2020-09-01 | San Diego | 73 | 0 | 0 | |
1068720 | 1068720 | 92096 | 92096: San Marcos | 2020-09-01 | San Diego | 73 | 0 | 0 | |
1068757 | 1068757 | 92155 | 92155: Coronado | 2020-09-01 | San Diego | 73 | 0 | 0 | |
1068759 | 1068759 | 92182 | 92182: San Diego | 2020-09-01 | San Diego | 73 | 0 | 0 | |
1068761 | 1068761 | 92672 | 92672: San Clemente | 2020-09-01 | San Diego | 73 | 0 | 0 | |
1069851 | 1069851 | 91931 | 91931: Guatay | 2020-08-31 | San Diego | 73 | 0 | 0 | |
1069908 | 1069908 | 92096 | 92096: San Marcos | 2020-08-31 | San Diego | 73 | 0 | 0 | |
1069945 | 1069945 | 92155 | 92155: Coronado | 2020-08-31 | San Diego | 73 | 0 | 0 | |
1069947 | 1069947 | 92182 | 92182: San Diego | 2020-08-31 | San Diego | 73 | 0 | 0 | |
1069949 | 1069949 | 92672 | 92672: San Clemente | 2020-08-31 | San Diego | 73 | 0 | 0 | |
1071039 | 1071039 | 91931 | 91931: Guatay | 2020-08-30 | San Diego | 73 | 0 | 0 | |
1071096 | 1071096 | 92096 | 92096: San Marcos | 2020-08-30 | San Diego | 73 | 0 | 0 | |
1071133 | 1071133 | 92155 | 92155: Coronado | 2020-08-30 | San Diego | 73 | 0 | 0 | |
1071135 | 1071135 | 92182 | 92182: San Diego | 2020-08-30 | San Diego | 73 | 0 | 0 | |
1071137 | 1071137 | 92672 | 92672: San Clemente | 2020-08-30 | San Diego | 73 | 0 | 0 | |
1072227 | 1072227 | 91931 | 91931: Guatay | 2020-08-29 | San Diego | 73 | 0 | 0 | |
1072284 | 1072284 | 92096 | 92096: San Marcos | 2020-08-29 | San Diego | 73 | 0 | 0 | |
1072321 | 1072321 | 92155 | 92155: Coronado | 2020-08-29 | San Diego | 73 | 0 | 0 | |
1072323 | 1072323 | 92182 | 92182: San Diego | 2020-08-29 | San Diego | 73 | 0 | 0 | |
1072325 | 1072325 | 92672 | 92672: San Clemente | 2020-08-29 | San Diego | 73 | 0 | 0 | |
1073415 | 1073415 | 91931 | 91931: Guatay | 2020-08-28 | San Diego | 73 | 0 | 0 | |
1073472 | 1073472 | 92096 | 92096: San Marcos | 2020-08-28 | San Diego | 73 | 0 | 0 | |
1073509 | 1073509 | 92155 | 92155: Coronado | 2020-08-28 | San Diego | 73 | 0 | 0 | |
1073511 | 1073511 | 92182 | 92182: San Diego | 2020-08-28 | San Diego | 73 | 0 | 0 | |
1073513 | 1073513 | 92672 | 92672: San Clemente | 2020-08-28 | San Diego | 73 | 0 | 0 | |
1074603 | 1074603 | 91931 | 91931: Guatay | 2020-08-27 | San Diego | 73 | 0 | 0 | |
1074660 | 1074660 | 92096 | 92096: San Marcos | 2020-08-27 | San Diego | 73 | 0 | 0 | |
1074697 | 1074697 | 92155 | 92155: Coronado | 2020-08-27 | San Diego | 73 | 0 | 0 | |
1074699 | 1074699 | 92182 | 92182: San Diego | 2020-08-27 | San Diego | 73 | 0 | 0 | |
1074701 | 1074701 | 92672 | 92672: San Clemente | 2020-08-27 | San Diego | 73 | 0 | 0 | |
1075791 | 1075791 | 91931 | 91931: Guatay | 2020-08-26 | San Diego | 73 | 0 | 0 | |
1075848 | 1075848 | 92096 | 92096: San Marcos | 2020-08-26 | San Diego | 73 | 0 | 0 | |
1075885 | 1075885 | 92155 | 92155: Coronado | 2020-08-26 | San Diego | 73 | 0 | 0 | |
1075887 | 1075887 | 92182 | 92182: San Diego | 2020-08-26 | San Diego | 73 | 0 | 0 | |
1075889 | 1075889 | 92672 | 92672: San Clemente | 2020-08-26 | San Diego | 73 | 0 | 0 | |
1076979 | 1076979 | 91931 | 91931: Guatay | 2020-08-25 | San Diego | 73 | 0 | 0 | |
1077036 | 1077036 | 92096 | 92096: San Marcos | 2020-08-25 | San Diego | 73 | 0 | 0 | |
1077073 | 1077073 | 92155 | 92155: Coronado | 2020-08-25 | San Diego | 73 | 0 | 0 | |
1077075 | 1077075 | 92182 | 92182: San Diego | 2020-08-25 | San Diego | 73 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );