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)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
1411 | 1411 | 92135 | 92135: Coronado | 2022-12-29 | San Diego | 73 | 175 | 0 | |
1414 | 1414 | 92140 | 92140: San Diego | 2022-12-29 | San Diego | 73 | 213 | 0 | |
1415 | 1415 | 92145 | 92145: San Diego | 2022-12-29 | San Diego | 73 | 37 | 0 | |
1417 | 1417 | 92155 | 92155: Coronado | 2022-12-29 | San Diego | 73 | 95 | 0 | |
1419 | 1419 | 92182 | 92182: San Diego | 2022-12-29 | San Diego | 73 | 188 | 0 | |
1420 | 1420 | 92536 | 92536: Aguanga | 2022-12-29 | San Diego | 73 | 26 | 0 | |
1421 | 1421 | 92672 | 92672: San Clemente | 2022-12-29 | San Diego | 73 | 13 | 0 | |
1424 | 1424 | 91905 | 91905: Boulevard | 2022-12-29 | San Diego | 73 | 291 | 0 | |
1425 | 1425 | 91906 | 91906: Campo | 2022-12-29 | San Diego | 73 | 1022 | 0 | |
1452 | 1452 | ASH (patients) | ASH (patients) | 2022-12-29 | San Luis Obispo | 79 | 503 | 0 | |
1456 | 1456 | CMC (Inmates) | CMC (Inmates) | 2022-12-29 | San Luis Obispo | 79 | 3430 | 0 | |
1457 | 1457 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2022-12-29 | San Luis Obispo | 79 | 1007 | 0 | |
1508 | 1508 | Lompoc Federal Prison | Lompoc Federal Prison | 2022-12-29 | Santa Barbara | 83 | 1161 | 0 | |
1595 | 1595 | 93212 | Corcoran, Angiola: 93212 | 2022-12-29 | Tulare | 107 | 24 | 0 | |
1619 | 1619 | 93646 | Traver: 93646 | 2022-12-29 | Tulare | 107 | 61 | 0 | |
1621 | 1621 | 93654 | Orosi: 93654 | 2022-12-29 | Tulare | 107 | 216 | 0 | |
1759 | 1759 | Dinuba | Dinuba | 2022-12-28 | Fresno | 19 | 131 | 0 | |
1763 | 1763 | Five Points | Five Points | 2022-12-28 | Fresno | 19 | 157 | 0 | |
1774 | 1774 | Prather | Prather | 2022-12-28 | Fresno | 19 | 205 | 0 | |
1788 | 1788 | 92222 | 92222: Bard | 2022-12-28 | Imperial | 25 | 13 | 0 | |
1793 | 1793 | 92244 | 92244: El Centro | 2022-12-28 | Imperial | 25 | 269 | 0 | |
1816 | 1816 | 95424 | 95424 | 2022-12-28 | Lake | 33 | 49 | 0 | |
2132 | 2132 | Unincorporated - Padua Hills | Padua Hills | 2022-12-28 | Los Angeles | 37 | 36 | 0 | |
2170 | 2170 | Unincorporated - West Chatsworth | West Chatsworth | 2022-12-28 | Los Angeles | 37 | 5 | 0 | |
2264 | 2264 | 93912 | 93912: Boronda | 2022-12-28 | Monterey | 53 | 294 | 0 | |
2267 | 2267 | 93922 | 93922: Carmel | 2022-12-28 | Monterey | 53 | 110 | 0 | |
2276 | 2276 | 93942 | 93942: Monterey | 2022-12-28 | Monterey | 53 | 94 | 0 | |
2303 | 2303 | 95602 | 95602: Auburn | 2022-12-28 | Nevada | 57 | 747 | 0 | |
2304 | 2304 | 95712 | 95712: Chicago Park | 2022-12-28 | Nevada | 57 | 60 | 0 | |
2307 | 2307 | 95924 | 95924: Cedar Ridge | 2022-12-28 | Nevada | 57 | 113 | 0 | |
2314 | 2314 | 95977 | 95977: Smartville | 2022-12-28 | Nevada | 57 | 128 | 0 | |
2317 | 2317 | 96160 | 96160: Truckee | 2022-12-28 | Nevada | 57 | 348 | 0 | |
2319 | 2319 | 96162 | 96162: Truckee | 2022-12-28 | Nevada | 57 | 227 | 0 | |
2347 | 2347 | Rancho Mission Viejo | Rancho Mission Viejo | 2022-12-28 | Orange | 59 | 1527 | 0 | |
2354 | 2354 | Silverado | Silverado | 2022-12-28 | Orange | 59 | 297 | 0 | |
2356 | 2356 | Trabuco Canyon | Trabuco Canyon | 2022-12-28 | Orange | 59 | 3525 | 0 | |
2456 | 2456 | Havasu Lake | Havasu Lake | 2022-12-28 | San Bernardino | 71 | 106 | 0 | |
2502 | 2502 | 91916 | 91916: Descanso | 2022-12-28 | San Diego | 73 | 369 | 0 | |
2503 | 2503 | 91917 | 91917: Dulzura | 2022-12-28 | San Diego | 73 | 332 | 0 | |
2504 | 2504 | 91931 | 91931: Guatay | 2022-12-28 | San Diego | 73 | 48 | 0 | |
2506 | 2506 | 91934 | 91934: Jacumba | 2022-12-28 | San Diego | 73 | 116 | 0 | |
2507 | 2507 | 91935 | 91935: Jamul | 2022-12-28 | San Diego | 73 | 2118 | 0 | |
2512 | 2512 | 91962 | 91962: Pine Valley | 2022-12-28 | San Diego | 73 | 366 | 0 | |
2513 | 2513 | 91963 | 91963: Potrero | 2022-12-28 | San Diego | 73 | 391 | 0 | |
2515 | 2515 | 91978 | 91978: Spring Valley | 2022-12-28 | San Diego | 73 | 2773 | 0 | |
2516 | 2516 | 91980 | 91980: Tecate | 2022-12-28 | San Diego | 73 | 287 | 0 | |
2517 | 2517 | 92003 | 92003: Bonsall | 2022-12-28 | San Diego | 73 | 1054 | 0 | |
2518 | 2518 | 92004 | 92004: Borrego Springs | 2022-12-28 | San Diego | 73 | 377 | 0 | |
2534 | 2534 | 92036 | 92036: Julian | 2022-12-28 | San Diego | 73 | 495 | 0 | |
2542 | 2542 | 92059 | 92059: Pala | 2022-12-28 | San Diego | 73 | 618 | 0 | |
2543 | 2543 | 92060 | 92060: Palomar Mountain | 2022-12-28 | San Diego | 73 | 102 | 0 | |
2544 | 2544 | 92061 | 92061: Pauma Valley | 2022-12-28 | San Diego | 73 | 727 | 0 | |
2547 | 2547 | 92066 | 92066: Ranchita | 2022-12-28 | San Diego | 73 | 48 | 0 | |
2548 | 2548 | 92067 | 92067: Rancho Santa Fe | 2022-12-28 | San Diego | 73 | 1868 | 0 | |
2550 | 2550 | 92070 | 92070: Santa Ysabel | 2022-12-28 | San Diego | 73 | 364 | 0 | |
2558 | 2558 | 92086 | 92086: Warner Springs | 2022-12-28 | San Diego | 73 | 170 | 0 | |
2559 | 2559 | 92091 | 92091: Rancho Santa Fe | 2022-12-28 | San Diego | 73 | 179 | 0 | |
2561 | 2561 | 92096 | 92096: San Marcos | 2022-12-28 | San Diego | 73 | 36 | 0 | |
2581 | 2581 | 92121 | 92121: San Diego | 2022-12-28 | San Diego | 73 | 1088 | 0 | |
2591 | 2591 | 92134 | 92134: San Diego | 2022-12-28 | San Diego | 73 | 136 | 0 | |
2592 | 2592 | 92135 | 92135: Coronado | 2022-12-28 | San Diego | 73 | 173 | 0 | |
2595 | 2595 | 92140 | 92140: San Diego | 2022-12-28 | San Diego | 73 | 213 | 0 | |
2596 | 2596 | 92145 | 92145: San Diego | 2022-12-28 | San Diego | 73 | 37 | 0 | |
2598 | 2598 | 92155 | 92155: Coronado | 2022-12-28 | San Diego | 73 | 94 | 0 | |
2600 | 2600 | 92182 | 92182: San Diego | 2022-12-28 | San Diego | 73 | 188 | 0 | |
2601 | 2601 | 92536 | 92536: Aguanga | 2022-12-28 | San Diego | 73 | 26 | 0 | |
2602 | 2602 | 92672 | 92672: San Clemente | 2022-12-28 | San Diego | 73 | 13 | 0 | |
2605 | 2605 | 91905 | 91905: Boulevard | 2022-12-28 | San Diego | 73 | 289 | 0 | |
2606 | 2606 | 91906 | 91906: Campo | 2022-12-28 | San Diego | 73 | 1015 | 0 | |
2633 | 2633 | ASH (patients) | ASH (patients) | 2022-12-28 | San Luis Obispo | 79 | 503 | 0 | |
2637 | 2637 | CMC (Inmates) | CMC (Inmates) | 2022-12-28 | San Luis Obispo | 79 | 3430 | 0 | |
2638 | 2638 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2022-12-28 | San Luis Obispo | 79 | 1007 | 0 | |
2689 | 2689 | Lompoc Federal Prison | Lompoc Federal Prison | 2022-12-28 | Santa Barbara | 83 | 1161 | 0 | |
2776 | 2776 | 93212 | Corcoran, Angiola: 93212 | 2022-12-28 | Tulare | 107 | 24 | 0 | |
2800 | 2800 | 93646 | Traver: 93646 | 2022-12-28 | Tulare | 107 | 61 | 0 | |
2802 | 2802 | 93654 | Orosi: 93654 | 2022-12-28 | Tulare | 107 | 216 | 0 | |
2940 | 2940 | Dinuba | Dinuba | 2022-12-27 | Fresno | 19 | 131 | 0 | |
2944 | 2944 | Five Points | Five Points | 2022-12-27 | Fresno | 19 | 157 | 0 | |
2955 | 2955 | Prather | Prather | 2022-12-27 | Fresno | 19 | 205 | 0 | |
2969 | 2969 | 92222 | 92222: Bard | 2022-12-27 | Imperial | 25 | 13 | 0 | |
2974 | 2974 | 92244 | 92244: El Centro | 2022-12-27 | Imperial | 25 | 269 | 0 | |
2997 | 2997 | 95424 | 95424 | 2022-12-27 | Lake | 33 | 49 | 0 | |
3313 | 3313 | Unincorporated - Padua Hills | Padua Hills | 2022-12-27 | Los Angeles | 37 | 36 | 0 | |
3351 | 3351 | Unincorporated - West Chatsworth | West Chatsworth | 2022-12-27 | Los Angeles | 37 | 5 | 0 | |
3445 | 3445 | 93912 | 93912: Boronda | 2022-12-27 | Monterey | 53 | 294 | 0 | |
3448 | 3448 | 93922 | 93922: Carmel | 2022-12-27 | Monterey | 53 | 110 | 0 | |
3457 | 3457 | 93942 | 93942: Monterey | 2022-12-27 | Monterey | 53 | 94 | 0 | |
3484 | 3484 | 95602 | 95602: Auburn | 2022-12-27 | Nevada | 57 | 747 | 0 | |
3485 | 3485 | 95712 | 95712: Chicago Park | 2022-12-27 | Nevada | 57 | 60 | 0 | |
3488 | 3488 | 95924 | 95924: Cedar Ridge | 2022-12-27 | Nevada | 57 | 113 | 0 | |
3495 | 3495 | 95977 | 95977: Smartville | 2022-12-27 | Nevada | 57 | 128 | 0 | |
3498 | 3498 | 96160 | 96160: Truckee | 2022-12-27 | Nevada | 57 | 348 | 0 | |
3500 | 3500 | 96162 | 96162: Truckee | 2022-12-27 | Nevada | 57 | 227 | 0 | |
3528 | 3528 | Rancho Mission Viejo | Rancho Mission Viejo | 2022-12-27 | Orange | 59 | 1527 | 0 | |
3535 | 3535 | Silverado | Silverado | 2022-12-27 | Orange | 59 | 297 | 0 | |
3537 | 3537 | Trabuco Canyon | Trabuco Canyon | 2022-12-27 | Orange | 59 | 3525 | 0 | |
3637 | 3637 | Havasu Lake | Havasu Lake | 2022-12-27 | San Bernardino | 71 | 106 | 0 | |
3683 | 3683 | 91916 | 91916: Descanso | 2022-12-27 | San Diego | 73 | 369 | 0 | |
3684 | 3684 | 91917 | 91917: Dulzura | 2022-12-27 | San Diego | 73 | 332 | 0 | |
3685 | 3685 | 91931 | 91931: Guatay | 2022-12-27 | San Diego | 73 | 48 | 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 );