latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,251,796 rows sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: date
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
103 | 103 | Dinuba | Dinuba | 2022-12-30 | Fresno | 19 | 131 | 0 | |
107 | 107 | Five Points | Five Points | 2022-12-30 | Fresno | 19 | 157 | 0 | |
118 | 118 | Prather | Prather | 2022-12-30 | Fresno | 19 | 205 | 0 | |
132 | 132 | 92222 | 92222: Bard | 2022-12-30 | Imperial | 25 | 13 | 0 | |
137 | 137 | 92244 | 92244: El Centro | 2022-12-30 | Imperial | 25 | 269 | 0 | |
160 | 160 | 95424 | 95424 | 2022-12-30 | Lake | 33 | 49 | 0 | |
255 | 255 | 93912 | 93912: Boronda | 2022-12-30 | Monterey | 53 | 294 | 0 | |
258 | 258 | 93922 | 93922: Carmel | 2022-12-30 | Monterey | 53 | 110 | 0 | |
267 | 267 | 93942 | 93942: Monterey | 2022-12-30 | Monterey | 53 | 94 | 0 | |
294 | 294 | 95602 | 95602: Auburn | 2022-12-30 | Nevada | 57 | 747 | 0 | |
295 | 295 | 95712 | 95712: Chicago Park | 2022-12-30 | Nevada | 57 | 60 | 0 | |
298 | 298 | 95924 | 95924: Cedar Ridge | 2022-12-30 | Nevada | 57 | 113 | 0 | |
305 | 305 | 95977 | 95977: Smartville | 2022-12-30 | Nevada | 57 | 128 | 0 | |
308 | 308 | 96160 | 96160: Truckee | 2022-12-30 | Nevada | 57 | 348 | 0 | |
310 | 310 | 96162 | 96162: Truckee | 2022-12-30 | Nevada | 57 | 227 | 0 | |
338 | 338 | Rancho Mission Viejo | Rancho Mission Viejo | 2022-12-30 | Orange | 59 | 1531 | 0 | |
345 | 345 | Silverado | Silverado | 2022-12-30 | Orange | 59 | 297 | 0 | |
347 | 347 | Trabuco Canyon | Trabuco Canyon | 2022-12-30 | Orange | 59 | 3540 | 0 | |
447 | 447 | Havasu Lake | Havasu Lake | 2022-12-30 | San Bernardino | 71 | 106 | 0 | |
493 | 493 | 91916 | 91916: Descanso | 2022-12-30 | San Diego | 73 | 369 | 0 | |
494 | 494 | 91917 | 91917: Dulzura | 2022-12-30 | San Diego | 73 | 333 | 0 | |
495 | 495 | 91931 | 91931: Guatay | 2022-12-30 | San Diego | 73 | 48 | 0 | |
497 | 497 | 91934 | 91934: Jacumba | 2022-12-30 | San Diego | 73 | 117 | 0 | |
498 | 498 | 91935 | 91935: Jamul | 2022-12-30 | San Diego | 73 | 2130 | 0 | |
503 | 503 | 91962 | 91962: Pine Valley | 2022-12-30 | San Diego | 73 | 368 | 0 | |
504 | 504 | 91963 | 91963: Potrero | 2022-12-30 | San Diego | 73 | 393 | 0 | |
506 | 506 | 91978 | 91978: Spring Valley | 2022-12-30 | San Diego | 73 | 2787 | 0 | |
507 | 507 | 91980 | 91980: Tecate | 2022-12-30 | San Diego | 73 | 287 | 0 | |
508 | 508 | 92003 | 92003: Bonsall | 2022-12-30 | San Diego | 73 | 1061 | 0 | |
509 | 509 | 92004 | 92004: Borrego Springs | 2022-12-30 | San Diego | 73 | 377 | 0 | |
525 | 525 | 92036 | 92036: Julian | 2022-12-30 | San Diego | 73 | 496 | 0 | |
533 | 533 | 92059 | 92059: Pala | 2022-12-30 | San Diego | 73 | 623 | 0 | |
534 | 534 | 92060 | 92060: Palomar Mountain | 2022-12-30 | San Diego | 73 | 103 | 0 | |
535 | 535 | 92061 | 92061: Pauma Valley | 2022-12-30 | San Diego | 73 | 731 | 0 | |
538 | 538 | 92066 | 92066: Ranchita | 2022-12-30 | San Diego | 73 | 48 | 0 | |
539 | 539 | 92067 | 92067: Rancho Santa Fe | 2022-12-30 | San Diego | 73 | 1880 | 0 | |
541 | 541 | 92070 | 92070: Santa Ysabel | 2022-12-30 | San Diego | 73 | 365 | 0 | |
549 | 549 | 92086 | 92086: Warner Springs | 2022-12-30 | San Diego | 73 | 170 | 0 | |
550 | 550 | 92091 | 92091: Rancho Santa Fe | 2022-12-30 | San Diego | 73 | 182 | 0 | |
552 | 552 | 92096 | 92096: San Marcos | 2022-12-30 | San Diego | 73 | 37 | 0 | |
572 | 572 | 92121 | 92121: San Diego | 2022-12-30 | San Diego | 73 | 1096 | 0 | |
582 | 582 | 92134 | 92134: San Diego | 2022-12-30 | San Diego | 73 | 137 | 0 | |
583 | 583 | 92135 | 92135: Coronado | 2022-12-30 | San Diego | 73 | 175 | 0 | |
586 | 586 | 92140 | 92140: San Diego | 2022-12-30 | San Diego | 73 | 213 | 0 | |
587 | 587 | 92145 | 92145: San Diego | 2022-12-30 | San Diego | 73 | 37 | 0 | |
589 | 589 | 92155 | 92155: Coronado | 2022-12-30 | San Diego | 73 | 95 | 0 | |
591 | 591 | 92182 | 92182: San Diego | 2022-12-30 | San Diego | 73 | 188 | 0 | |
592 | 592 | 92536 | 92536: Aguanga | 2022-12-30 | San Diego | 73 | 26 | 0 | |
593 | 593 | 92672 | 92672: San Clemente | 2022-12-30 | San Diego | 73 | 13 | 0 | |
596 | 596 | 91905 | 91905: Boulevard | 2022-12-30 | San Diego | 73 | 291 | 0 | |
597 | 597 | 91906 | 91906: Campo | 2022-12-30 | San Diego | 73 | 1022 | 0 | |
624 | 624 | ASH (patients) | ASH (patients) | 2022-12-30 | San Luis Obispo | 79 | 503 | 0 | |
628 | 628 | CMC (Inmates) | CMC (Inmates) | 2022-12-30 | San Luis Obispo | 79 | 3430 | 0 | |
629 | 629 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2022-12-30 | San Luis Obispo | 79 | 1007 | 0 | |
680 | 680 | Lompoc Federal Prison | Lompoc Federal Prison | 2022-12-30 | Santa Barbara | 83 | 1161 | 0 | |
767 | 767 | 93212 | Corcoran, Angiola: 93212 | 2022-12-30 | Tulare | 107 | 24 | 0 | |
791 | 791 | 93646 | Traver: 93646 | 2022-12-30 | Tulare | 107 | 61 | 0 | |
793 | 793 | 93654 | Orosi: 93654 | 2022-12-30 | Tulare | 107 | 216 | 0 | |
931 | 931 | Dinuba | Dinuba | 2022-12-29 | Fresno | 19 | 131 | 0 | |
935 | 935 | Five Points | Five Points | 2022-12-29 | Fresno | 19 | 157 | 0 | |
946 | 946 | Prather | Prather | 2022-12-29 | Fresno | 19 | 205 | 0 | |
960 | 960 | 92222 | 92222: Bard | 2022-12-29 | Imperial | 25 | 13 | 0 | |
965 | 965 | 92244 | 92244: El Centro | 2022-12-29 | Imperial | 25 | 269 | 0 | |
988 | 988 | 95424 | 95424 | 2022-12-29 | Lake | 33 | 49 | 0 | |
1083 | 1083 | 93912 | 93912: Boronda | 2022-12-29 | Monterey | 53 | 294 | 0 | |
1086 | 1086 | 93922 | 93922: Carmel | 2022-12-29 | Monterey | 53 | 110 | 0 | |
1095 | 1095 | 93942 | 93942: Monterey | 2022-12-29 | Monterey | 53 | 94 | 0 | |
1122 | 1122 | 95602 | 95602: Auburn | 2022-12-29 | Nevada | 57 | 747 | 0 | |
1123 | 1123 | 95712 | 95712: Chicago Park | 2022-12-29 | Nevada | 57 | 60 | 0 | |
1126 | 1126 | 95924 | 95924: Cedar Ridge | 2022-12-29 | Nevada | 57 | 113 | 0 | |
1133 | 1133 | 95977 | 95977: Smartville | 2022-12-29 | Nevada | 57 | 128 | 0 | |
1136 | 1136 | 96160 | 96160: Truckee | 2022-12-29 | Nevada | 57 | 348 | 0 | |
1138 | 1138 | 96162 | 96162: Truckee | 2022-12-29 | Nevada | 57 | 227 | 0 | |
1166 | 1166 | Rancho Mission Viejo | Rancho Mission Viejo | 2022-12-29 | Orange | 59 | 1531 | 0 | |
1173 | 1173 | Silverado | Silverado | 2022-12-29 | Orange | 59 | 297 | 0 | |
1175 | 1175 | Trabuco Canyon | Trabuco Canyon | 2022-12-29 | Orange | 59 | 3540 | 0 | |
1275 | 1275 | Havasu Lake | Havasu Lake | 2022-12-29 | San Bernardino | 71 | 106 | 0 | |
1321 | 1321 | 91916 | 91916: Descanso | 2022-12-29 | San Diego | 73 | 369 | 0 | |
1322 | 1322 | 91917 | 91917: Dulzura | 2022-12-29 | San Diego | 73 | 333 | 0 | |
1323 | 1323 | 91931 | 91931: Guatay | 2022-12-29 | San Diego | 73 | 48 | 0 | |
1325 | 1325 | 91934 | 91934: Jacumba | 2022-12-29 | San Diego | 73 | 117 | 0 | |
1326 | 1326 | 91935 | 91935: Jamul | 2022-12-29 | San Diego | 73 | 2130 | 0 | |
1331 | 1331 | 91962 | 91962: Pine Valley | 2022-12-29 | San Diego | 73 | 368 | 0 | |
1332 | 1332 | 91963 | 91963: Potrero | 2022-12-29 | San Diego | 73 | 393 | 0 | |
1334 | 1334 | 91978 | 91978: Spring Valley | 2022-12-29 | San Diego | 73 | 2787 | 0 | |
1335 | 1335 | 91980 | 91980: Tecate | 2022-12-29 | San Diego | 73 | 287 | 0 | |
1336 | 1336 | 92003 | 92003: Bonsall | 2022-12-29 | San Diego | 73 | 1061 | 0 | |
1337 | 1337 | 92004 | 92004: Borrego Springs | 2022-12-29 | San Diego | 73 | 377 | 0 | |
1353 | 1353 | 92036 | 92036: Julian | 2022-12-29 | San Diego | 73 | 496 | 0 | |
1361 | 1361 | 92059 | 92059: Pala | 2022-12-29 | San Diego | 73 | 623 | 0 | |
1362 | 1362 | 92060 | 92060: Palomar Mountain | 2022-12-29 | San Diego | 73 | 103 | 0 | |
1363 | 1363 | 92061 | 92061: Pauma Valley | 2022-12-29 | San Diego | 73 | 731 | 0 | |
1366 | 1366 | 92066 | 92066: Ranchita | 2022-12-29 | San Diego | 73 | 48 | 0 | |
1367 | 1367 | 92067 | 92067: Rancho Santa Fe | 2022-12-29 | San Diego | 73 | 1880 | 0 | |
1369 | 1369 | 92070 | 92070: Santa Ysabel | 2022-12-29 | San Diego | 73 | 365 | 0 | |
1377 | 1377 | 92086 | 92086: Warner Springs | 2022-12-29 | San Diego | 73 | 170 | 0 | |
1378 | 1378 | 92091 | 92091: Rancho Santa Fe | 2022-12-29 | San Diego | 73 | 182 | 0 | |
1380 | 1380 | 92096 | 92096: San Marcos | 2022-12-29 | San Diego | 73 | 37 | 0 | |
1400 | 1400 | 92121 | 92121: San Diego | 2022-12-29 | San Diego | 73 | 1096 | 0 | |
1410 | 1410 | 92134 | 92134: San Diego | 2022-12-29 | San Diego | 73 | 137 | 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] INTEGER );