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,181 rows where "date" is on date 2022-12-18 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
14647 | 14647 | Wheatland | Wheatland | 2022-12-18 | Yuba | 115 | 1069 | 3747 | |
14646 | 14646 | Plumas Lake | Plumas Lake | 2022-12-18 | Yuba | 115 | 2436 | 7367 | |
14645 | 14645 | Other | Other | 2022-12-18 | Yuba | 115 | 1884 | ||
14644 | 14644 | Olivehurst Linda | Olivehurst Linda | 2022-12-18 | Yuba | 115 | 5234 | 32623 | |
14643 | 14643 | Marysville | Marysville | 2022-12-18 | Yuba | 115 | 8670 | 12282 | |
14642 | 14642 | Woodland | Woodland | 2022-12-18 | Yolo | 113 | 12042 | 59044 | |
14641 | 14641 | Winters | Winters | 2022-12-18 | Yolo | 113 | 1222 | 7132 | |
14640 | 14640 | West Sacramento | West Sacramento | 2022-12-18 | Yolo | 113 | 10325 | 52826 | |
14639 | 14639 | Unincorporated | Other | 2022-12-18 | Yolo | 113 | 4575 | ||
14638 | 14638 | Davis | Davis | 2022-12-18 | Yolo | 113 | 8121 | 67988 | |
14637 | 14637 | 93066 | 93066: Somis | 2022-12-18 | Ventura | 111 | 635 | 3481 | |
14636 | 14636 | 93065 | 93065: Simi Valley | 2022-12-18 | Ventura | 111 | 17939 | 74780 | |
14635 | 14635 | 93063 | 93063: Simi Valley (Santa Susana) | 2022-12-18 | Ventura | 111 | 13122 | 56563 | |
14634 | 14634 | 93060 | 93060: Santa Paula | 2022-12-18 | Ventura | 111 | 12036 | 34229 | |
14633 | 14633 | 93041 | 93041: Port Hueneme | 2022-12-18 | Ventura | 111 | 6252 | 24129 | |
14632 | 14632 | 93040 | 93040: Piru | 2022-12-18 | Ventura | 111 | 840 | 1831 | |
14631 | 14631 | 93036 | 93036: Oxnard | 2022-12-18 | Ventura | 111 | 14626 | 48022 | |
14630 | 14630 | 93035 | 93035: Oxnard | 2022-12-18 | Ventura | 111 | 6931 | 28321 | |
14629 | 14629 | 93033 | 93033: Oxnard | 2022-12-18 | Ventura | 111 | 27430 | 83319 | |
14628 | 14628 | 93030 | 93030: Oxnard | 2022-12-18 | Ventura | 111 | 20258 | 62016 | |
14627 | 14627 | 93023 | 93023: Ojai | 2022-12-18 | Ventura | 111 | 3563 | 20656 | |
14626 | 14626 | 93022 | 93022: Oak View | 2022-12-18 | Ventura | 111 | 1283 | 5550 | |
14625 | 14625 | 93021 | 93021: Moorpark | 2022-12-18 | Ventura | 111 | 8362 | 38325 | |
14624 | 14624 | 93015 | 93015: Fillmore | 2022-12-18 | Ventura | 111 | 6819 | 18832 | |
14623 | 14623 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2022-12-18 | Ventura | 111 | 6554 | 37622 | |
14622 | 14622 | 93010 | 93010: Camarillo | 2022-12-18 | Ventura | 111 | 10126 | 44240 | |
14621 | 14621 | 93004 | 93004: Ventura | 2022-12-18 | Ventura | 111 | 6945 | 30473 | |
14620 | 14620 | 93003 | 93003: Ventura | 2022-12-18 | Ventura | 111 | 12352 | 51304 | |
14619 | 14619 | 93001 | 93001: Ventura | 2022-12-18 | Ventura | 111 | 7942 | 33139 | |
14618 | 14618 | 91377 | 91377: Oak Park | 2022-12-18 | Ventura | 111 | 2385 | 14226 | |
14617 | 14617 | 91362 | 91362: Thousand Oaks/Westlake | 2022-12-18 | Ventura | 111 | 6654 | 36980 | |
14616 | 14616 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2022-12-18 | Ventura | 111 | 2304 | 20487 | |
14615 | 14615 | 91360 | 91360: Thousand Oaks | 2022-12-18 | Ventura | 111 | 9058 | 42104 | |
14614 | 14614 | 91320 | 91320: Thousand Oaks/Newbury Park | 2022-12-18 | Ventura | 111 | 9118 | 46191 | |
14613 | 14613 | 91307 | 91307: Bell Canyon | 2022-12-18 | Ventura | 111 | 37 | 2391 | |
14612 | 14612 | 93654 | Orosi: 93654 | 2022-12-18 | Tulare | 107 | 216 | 0 | |
14611 | 14611 | 93647 | Orosi: 93647 | 2022-12-18 | Tulare | 107 | 2781 | 10896 | |
14610 | 14610 | 93646 | Traver: 93646 | 2022-12-18 | Tulare | 107 | 61 | 0 | |
14609 | 14609 | 93631 | Traver: 93631 | 2022-12-18 | Tulare | 107 | 530 | 16349 | |
14608 | 14608 | 93618 | Dinuba: 93618 | 2022-12-18 | Tulare | 107 | 8169 | 31230 | |
14607 | 14607 | 93615 | Cutler: 93615 | 2022-12-18 | Tulare | 107 | 1407 | 6513 | |
14606 | 14606 | 93292 | Visalia: 93292 | 2022-12-18 | Tulare | 107 | 7737 | 41031 | |
14605 | 14605 | 93291 | Visalia: 93291 | 2022-12-18 | Tulare | 107 | 12169 | 57968 | |
14604 | 14604 | 93286 | Woodlake: 93286 | 2022-12-18 | Tulare | 107 | 1935 | 9755 | |
14603 | 14603 | 93277 | Visalia: 93277 | 2022-12-18 | Tulare | 107 | 9559 | 53015 | |
14602 | 14602 | 93274 | Tulare: 93274 | 2022-12-18 | Tulare | 107 | 17342 | 73778 | |
14601 | 14601 | 93272 | Tipton: 93272 | 2022-12-18 | Tulare | 107 | 852 | 4454 | |
14600 | 14600 | 93271 | Three Rivers: 93271 | 2022-12-18 | Tulare | 107 | 163 | 2432 | |
14599 | 14599 | 93270 | Terra Bella: 93270 | 2022-12-18 | Tulare | 107 | 1491 | 5542 | |
14598 | 14598 | 93267 | Strathmore: 93267 | 2022-12-18 | Tulare | 107 | 1417 | 5542 | |
14597 | 14597 | 93265 | Springville: 93265 | 2022-12-18 | Tulare | 107 | 515 | 6347 | |
14596 | 14596 | 93262 | Mountain: 93262 | 2022-12-18 | Tulare | 107 | 101 | 3271 | |
14595 | 14595 | 93257 | Porterville: 93257 | 2022-12-18 | Tulare | 107 | 21173 | 76923 | |
14594 | 14594 | 93256 | Pixley: 93256 | 2022-12-18 | Tulare | 107 | 1637 | 5939 | |
14593 | 14593 | 93247 | Lindsay: 93247 | 2022-12-18 | Tulare | 107 | 3939 | 18522 | |
14592 | 14592 | 93235 | Ivanhoe: 93235 | 2022-12-18 | Tulare | 107 | 1077 | 4198 | |
14591 | 14591 | 93227 | Goshen: 93227 | 2022-12-18 | Tulare | 107 | 169 | 3425 | |
14590 | 14590 | 93223 | Farmersville: 93223 | 2022-12-18 | Tulare | 107 | 2364 | 10742 | |
14589 | 14589 | 93221 | Exeter: 93221 | 2022-12-18 | Tulare | 107 | 2243 | 14328 | |
14588 | 14588 | 93219 | Earlimart: 93219 | 2022-12-18 | Tulare | 107 | 2568 | 10167 | |
14587 | 14587 | 93215 | Richgrove: 93215 | 2022-12-18 | Tulare | 107 | 696 | 55269 | |
14586 | 14586 | 93212 | Corcoran, Angiola: 93212 | 2022-12-18 | Tulare | 107 | 24 | 0 | |
14585 | 14585 | 93201 | Alpaugh: 93201 | 2022-12-18 | Tulare | 107 | 252 | 1431 | |
14584 | 14584 | West County | West County | 2022-12-18 | Trinity | 105 | 139 | 2254 | |
14583 | 14583 | South County | South County | 2022-12-18 | Trinity | 105 | 278 | 4010 | |
14582 | 14582 | North County | North County | 2022-12-18 | Trinity | 105 | 49 | 699 | |
14581 | 14581 | East County | East County | 2022-12-18 | Trinity | 105 | 853 | 6738 | |
14580 | 14580 | 95497 | 95497: The Sea Ranch | 2022-12-18 | Sonoma | 97 | 39 | 1161 | |
14579 | 14579 | 95492 | 95492: Windsor | 2022-12-18 | Sonoma | 97 | 6694 | 29920 | |
14578 | 14578 | 95476 | 95476: Sonoma | 2022-12-18 | Sonoma | 97 | 7638 | 36792 | |
14577 | 14577 | 95472 | 95472: Sebastopol | 2022-12-18 | Sonoma | 97 | 4042 | 30762 | |
14576 | 14576 | 95465 | 95465: Occidental | 2022-12-18 | Sonoma | 97 | 207 | 2104 | |
14575 | 14575 | 95462 | 95462: Monte Rio | 2022-12-18 | Sonoma | 97 | 155 | 1265 | |
14574 | 14574 | 95452 | 95452: Kenwood | 2022-12-18 | Sonoma | 97 | 145 | 970 | |
14573 | 14573 | 95450 | 95450: Jenner | 2022-12-18 | Sonoma | 97 | 29 | 298 | |
14572 | 14572 | 95448 | 95448: Healdsburg | 2022-12-18 | Sonoma | 97 | 3354 | 17482 | |
14571 | 14571 | 95446 | 95446: Guerneville | 2022-12-18 | Sonoma | 97 | 701 | 5100 | |
14570 | 14570 | 95444 | 95444: Graton | 2022-12-18 | Sonoma | 97 | 164 | 715 | |
14569 | 14569 | 95442 | 95442: Glen Ellen | 2022-12-18 | Sonoma | 97 | 538 | 3136 | |
14568 | 14568 | 95441 | 95441: Geyserville | 2022-12-18 | Sonoma | 97 | 374 | 2053 | |
14567 | 14567 | 95439 | 95439: Fulton | 2022-12-18 | Sonoma | 97 | 175 | 774 | |
14566 | 14566 | 95436 | 95436: Forestville | 2022-12-18 | Sonoma | 97 | 812 | 6352 | |
14565 | 14565 | 95425 | 95425: Cloverdale | 2022-12-18 | Sonoma | 97 | 2285 | 10586 | |
14564 | 14564 | 95421 | 95421: Cazadero | 2022-12-18 | Sonoma | 97 | 139 | 1681 | |
14563 | 14563 | 95412 | 95412: Annapolis | 2022-12-18 | Sonoma | 97 | 20 | 402 | |
14562 | 14562 | 95409 | 95409: Santa Rosa | 2022-12-18 | Sonoma | 97 | 4527 | 27312 | |
14561 | 14561 | 95407 | 95407: Santa Rosa | 2022-12-18 | Sonoma | 97 | 13605 | 42483 | |
14560 | 14560 | 95405 | 95405: Santa Rosa | 2022-12-18 | Sonoma | 97 | 4414 | 21448 | |
14559 | 14559 | 95404 | 95404: Santa Rosa | 2022-12-18 | Sonoma | 97 | 8375 | 40474 | |
14558 | 14558 | 95403 | 95403: Santa Rosa | 2022-12-18 | Sonoma | 97 | 11947 | 45355 | |
14557 | 14557 | 95401 | 95401: Santa Rosa | 2022-12-18 | Sonoma | 97 | 9813 | 38986 | |
14556 | 14556 | 94954 | 94954: Petaluma | 2022-12-18 | Sonoma | 97 | 7948 | 38414 | |
14555 | 14555 | 94952 | 94952: Petaluma | 2022-12-18 | Sonoma | 97 | 5766 | 36184 | |
14554 | 14554 | 94951 | 94951: Penngrove | 2022-12-18 | Sonoma | 97 | 756 | 4571 | |
14553 | 14553 | 94931 | 94931: Cotati | 2022-12-18 | Sonoma | 97 | 1896 | 8601 | |
14552 | 14552 | 94928 | 94928: Rohnert Park | 2022-12-18 | Sonoma | 97 | 11544 | 44103 | |
14551 | 14551 | 94923 | 94923: Bodega Bay | 2022-12-18 | Sonoma | 97 | 144 | 846 | |
14550 | 14550 | 94922 | 94922: Bodega | 2022-12-18 | Sonoma | 97 | 72 | 603 | |
14549 | 14549 | 94515 | 94515: Calistoga | 2022-12-18 | Sonoma | 97 | 74 | 7436 | |
14548 | 14548 | Vallejo | Vallejo | 2022-12-18 | Solano | 95 | 34801 | 119544 |
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 );