latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
27 rows where county = "Monterey", "date" is on date 2021-07-20 and fips = 53 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
666231 | 666231 | 93426 | 93426: Bradley | 2021-07-20 | Monterey | 53 | 30 | 1604 | |
666232 | 666232 | 93901 | 93901: Salinas | 2021-07-20 | Monterey | 53 | 2663 | 27805 | |
666233 | 666233 | 93905 | 93905: Salinas | 2021-07-20 | Monterey | 53 | 9192 | 60408 | |
666234 | 666234 | 93906 | 93906: Salinas | 2021-07-20 | Monterey | 53 | 7740 | 65256 | |
666235 | 666235 | 93907 | 93907: Salinas | 2021-07-20 | Monterey | 53 | 1763 | 22766 | |
666236 | 666236 | 93908 | 93908: Salinas | 2021-07-20 | Monterey | 53 | 536 | 12093 | |
666237 | 666237 | 93912 | 93912: Boronda | 2021-07-20 | Monterey | 53 | 125 | 0 | |
666238 | 666238 | 93920 | 93920: Big Sur | 2021-07-20 | Monterey | 53 | 52 | 1403 | |
666239 | 666239 | 93921 | 93921: Carmel | 2021-07-20 | Monterey | 53 | 36 | 3379 | |
666240 | 666240 | 93922 | 93922: Carmel | 2021-07-20 | Monterey | 53 | 23 | 0 | |
666241 | 666241 | 93923 | 93923: Carmel | 2021-07-20 | Monterey | 53 | 223 | 12833 | |
666242 | 666242 | 93924 | 93924: Carmel Valley | 2021-07-20 | Monterey | 53 | 140 | 6568 | |
666243 | 666243 | 93925 | 93925: Chualar | 2021-07-20 | Monterey | 53 | 202 | 2155 | |
666244 | 666244 | 93926 | 93926: Gonzales | 2021-07-20 | Monterey | 53 | 1376 | 9262 | |
666245 | 666245 | 93927 | 93927: Greenfield | 2021-07-20 | Monterey | 53 | 2764 | 18778 | |
666246 | 666246 | 93930 | 93930: King City | 2021-07-20 | Monterey | 53 | 2208 | 17142 | |
666247 | 666247 | 93933 | 93933: Marina | 2021-07-20 | Monterey | 53 | 1354 | 25015 | |
666248 | 666248 | 93940 | 93940: Monterey | 2021-07-20 | Monterey | 53 | 1033 | 32411 | |
666249 | 666249 | 93942 | 93942: Monterey | 2021-07-20 | Monterey | 53 | 29 | 0 | |
666250 | 666250 | 93950 | 93950: Pacific Grove | 2021-07-20 | Monterey | 53 | 368 | 15595 | |
666251 | 666251 | 93953 | 93953: Pebble Beach | 2021-07-20 | Monterey | 53 | 57 | 4117 | |
666252 | 666252 | 93955 | 93955: Seaside | 2021-07-20 | Monterey | 53 | 2647 | 34395 | |
666253 | 666253 | 93960 | 93960: Soledad | 2021-07-20 | Monterey | 53 | 6142 | 26610 | |
666254 | 666254 | 95004 | 95004: Aromas | 2021-07-20 | Monterey | 53 | 122 | 3956 | |
666255 | 666255 | 95012 | 95012: Castroville | 2021-07-20 | Monterey | 53 | 1416 | 10792 | |
666256 | 666256 | 95039 | 95039: Moss Landing | 2021-07-20 | Monterey | 53 | 138 | 1195 | |
666257 | 666257 | 95076 | 95076: Watsonville | 2021-07-20 | Monterey | 53 | 1325 | 86703 |
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 );