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,276 rows where "date" is on date 2021-01-27 sorted by id
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id ▼ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
888598 | 888598 | 92109 | 92109: San Diego | 2021-01-27 | San Diego | 73 | 2401 | 54115 | |
888599 | 888599 | 92110 | 92110: San Diego | 2021-01-27 | San Diego | 73 | 1359 | 29878 | |
888600 | 888600 | 92111 | 92111: San Diego | 2021-01-27 | San Diego | 73 | 2469 | 47943 | |
888601 | 888601 | 92113 | 92113: San Diego | 2021-01-27 | San Diego | 73 | 6081 | 48550 | |
888602 | 888602 | 92114 | 92114: San Diego | 2021-01-27 | San Diego | 73 | 5863 | 58032 | |
888603 | 888603 | 92115 | 92115: San Diego | 2021-01-27 | San Diego | 73 | 4802 | 61463 | |
888604 | 888604 | 92116 | 92116: San Diego | 2021-01-27 | San Diego | 73 | 1356 | 36946 | |
888605 | 888605 | 92117 | 92117: San Diego | 2021-01-27 | San Diego | 73 | 2367 | 52122 | |
888606 | 888606 | 92118 | 92118: Coronado | 2021-01-27 | San Diego | 73 | 564 | 17956 | |
888607 | 888607 | 92119 | 92119: San Diego | 2021-01-27 | San Diego | 73 | 994 | 23730 | |
888608 | 888608 | 92120 | 92120: San Diego | 2021-01-27 | San Diego | 73 | 1377 | 29448 | |
888609 | 888609 | 92121 | 92121: San Diego | 2021-01-27 | San Diego | 73 | 146 | 0 | |
888610 | 888610 | 92122 | 92122: San Diego | 2021-01-27 | San Diego | 73 | 1075 | 48952 | |
888611 | 888611 | 92123 | 92123: San Diego | 2021-01-27 | San Diego | 73 | 1772 | 33643 | |
888612 | 888612 | 92124 | 92124: San Diego | 2021-01-27 | San Diego | 73 | 964 | 31705 | |
888613 | 888613 | 92126 | 92126: San Diego | 2021-01-27 | San Diego | 73 | 3306 | 76748 | |
888614 | 888614 | 92127 | 92127: San Diego | 2021-01-27 | San Diego | 73 | 1359 | 49508 | |
888615 | 888615 | 92128 | 92128: San Diego | 2021-01-27 | San Diego | 73 | 1678 | 51732 | |
888616 | 888616 | 92129 | 92129: San Diego | 2021-01-27 | San Diego | 73 | 1593 | 52624 | |
888617 | 888617 | 92130 | 92130: San Diego | 2021-01-27 | San Diego | 73 | 1393 | 59593 | |
888618 | 888618 | 92131 | 92131: San Diego | 2021-01-27 | San Diego | 73 | 1020 | 36090 | |
888619 | 888619 | 92134 | 92134: San Diego | 2021-01-27 | San Diego | 73 | 35 | 0 | |
888620 | 888620 | 92135 | 92135: Coronado | 2021-01-27 | San Diego | 73 | 74 | 0 | |
888621 | 888621 | 92136 | 92136: San Diego | 2021-01-27 | San Diego | 73 | 168 | 12492 | |
888622 | 888622 | 92139 | 92139: San Diego | 2021-01-27 | San Diego | 73 | 2891 | 33271 | |
888623 | 888623 | 92140 | 92140: San Diego | 2021-01-27 | San Diego | 73 | 105 | 0 | |
888624 | 888624 | 92145 | 92145: San Diego | 2021-01-27 | San Diego | 73 | 12 | 0 | |
888625 | 888625 | 92154 | 92154: San Diego | 2021-01-27 | San Diego | 73 | 11923 | 79997 | |
888626 | 888626 | 92155 | 92155: Coronado | 2021-01-27 | San Diego | 73 | 15 | 0 | |
888627 | 888627 | 92173 | 92173: San Ysidro | 2021-01-27 | San Diego | 73 | 5606 | 27097 | |
888628 | 888628 | 92182 | 92182: San Diego | 2021-01-27 | San Diego | 73 | 21 | 0 | |
887735 | 887735 | 92222 | 92222: Bard | 2021-01-27 | Imperial | 25 | 5 | 0 | |
887736 | 887736 | 92227 | 92227: Brawley | 2021-01-27 | Imperial | 25 | 3940 | 27255 | |
887737 | 887737 | 92231 | 92231: Calexico | 2021-01-27 | Imperial | 25 | 6958 | 40019 | |
887738 | 887738 | 92233 | 92233: Calipatria | 2021-01-27 | Imperial | 25 | 1409 | 7618 | |
887739 | 887739 | 92243 | 92243: El Centro | 2021-01-27 | Imperial | 25 | 6686 | 50484 | |
887740 | 887740 | 92244 | 92244: El Centro | 2021-01-27 | Imperial | 25 | 87 | 0 | |
887741 | 887741 | 92249 | 92249: Heber | 2021-01-27 | Imperial | 25 | 1075 | 7898 | |
887742 | 887742 | 92250 | 92250: Holtville | 2021-01-27 | Imperial | 25 | 992 | 8979 | |
887743 | 887743 | 92251 | 92251: Imperial | 2021-01-27 | Imperial | 25 | 3416 | 23388 | |
887744 | 887744 | 92257 | 92257: Niland | 2021-01-27 | Imperial | 25 | 90 | 1332 | |
887745 | 887745 | 92259 | 92259: Ocotillo | 2021-01-27 | Imperial | 25 | 7 | 94 | |
887746 | 887746 | 92266 | 92266: Palo Verde | 2021-01-27 | Imperial | 25 | 8 | 108 | |
887747 | 887747 | 92273 | 92273: Seeley | 2021-01-27 | Imperial | 25 | 187 | 1704 | |
887748 | 887748 | 92274 | 92274: Thermal | 2021-01-27 | Imperial | 25 | 453 | 15118 | |
887749 | 887749 | 92275 | 92275: Salton City | 2021-01-27 | Imperial | 25 | 44 | 2456 | |
887750 | 887750 | 92281 | 92281: Westmorland | 2021-01-27 | Imperial | 25 | 239 | 2859 | |
887751 | 887751 | 92283 | 92283: Winterhaven | 2021-01-27 | Imperial | 25 | 264 | 1694 | |
888629 | 888629 | 92536 | 92536: Aguanga | 2021-01-27 | San Diego | 73 | 5 | 0 | |
888630 | 888630 | 92672 | 92672: San Clemente | 2021-01-27 | San Diego | 73 | 45 | 0 | |
888835 | 888835 | 93001 | 93001: Ventura | 2021-01-27 | Ventura | 111 | 2371 | 33139 | |
888836 | 888836 | 93003 | 93003: Ventura | 2021-01-27 | Ventura | 111 | 3416 | 51304 | |
888837 | 888837 | 93004 | 93004: Ventura | 2021-01-27 | Ventura | 111 | 1947 | 30473 | |
888838 | 888838 | 93010 | 93010: Camarillo | 2021-01-27 | Ventura | 111 | 2638 | 44240 | |
888839 | 888839 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-01-27 | Ventura | 111 | 1430 | 37622 | |
888840 | 888840 | 93015 | 93015: Fillmore | 2021-01-27 | Ventura | 111 | 2236 | 18832 | |
888841 | 888841 | 93021 | 93021: Moorpark | 2021-01-27 | Ventura | 111 | 2343 | 38325 | |
888842 | 888842 | 93022 | 93022: Oak View | 2021-01-27 | Ventura | 111 | 298 | 5550 | |
888843 | 888843 | 93023 | 93023: Ojai | 2021-01-27 | Ventura | 111 | 850 | 20656 | |
888844 | 888844 | 93030 | 93030: Oxnard | 2021-01-27 | Ventura | 111 | 8283 | 62016 | |
888845 | 888845 | 93033 | 93033: Oxnard | 2021-01-27 | Ventura | 111 | 11703 | 83319 | |
888846 | 888846 | 93035 | 93035: Oxnard | 2021-01-27 | Ventura | 111 | 1978 | 28321 | |
888847 | 888847 | 93036 | 93036: Oxnard | 2021-01-27 | Ventura | 111 | 5236 | 48022 | |
888848 | 888848 | 93040 | 93040: Piru | 2021-01-27 | Ventura | 111 | 304 | 1831 | |
888849 | 888849 | 93041 | 93041: Port Hueneme | 2021-01-27 | Ventura | 111 | 2005 | 24129 | |
888850 | 888850 | 93060 | 93060: Santa Paula | 2021-01-27 | Ventura | 111 | 4567 | 34229 | |
888851 | 888851 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-01-27 | Ventura | 111 | 3730 | 56563 | |
888852 | 888852 | 93065 | 93065: Simi Valley | 2021-01-27 | Ventura | 111 | 5352 | 74780 | |
888853 | 888853 | 93066 | 93066: Somis | 2021-01-27 | Ventura | 111 | 201 | 3481 | |
888801 | 888801 | 93201 | Alpaugh: 93201 | 2021-01-27 | Tulare | 107 | 71 | 1431 | |
887787 | 887787 | 93203 | 93203: Arvin | 2021-01-27 | Kern | 29 | 2747 | 22471 | |
887788 | 887788 | 93205 | 93205: Bodfish | 2021-01-27 | Kern | 29 | 62 | 1593 | |
887789 | 887789 | 93206 | 93206: Buttonwillow | 2021-01-27 | Kern | 29 | 242 | 2044 | |
888802 | 888802 | 93212 | Corcoran, Angiola: 93212 | 2021-01-27 | Tulare | 107 | 10 | 0 | |
887790 | 887790 | 93215 | 93215: Delano | 2021-01-27 | Kern | 29 | 7679 | 55845 | |
888803 | 888803 | 93215 | Richgrove: 93215 | 2021-01-27 | Tulare | 107 | 299 | 55269 | |
888804 | 888804 | 93219 | Earlimart: 93219 | 2021-01-27 | Tulare | 107 | 1306 | 10167 | |
887791 | 887791 | 93220 | 93220: Edison | 2021-01-27 | Kern | 29 | 18 | 313 | |
888805 | 888805 | 93221 | Exeter: 93221 | 2021-01-27 | Tulare | 107 | 936 | 14328 | |
887792 | 887792 | 93222 | 93222: Pine Mountain Club | 2021-01-27 | Kern | 29 | 42 | 1420 | |
888806 | 888806 | 93223 | Farmersville: 93223 | 2021-01-27 | Tulare | 107 | 1084 | 10742 | |
887793 | 887793 | 93224 | 93224: Fellows | 2021-01-27 | Kern | 29 | 32 | 402 | |
887794 | 887794 | 93225 | 93225: Frazier Park | 2021-01-27 | Kern | 29 | 205 | 5319 | |
887752 | 887752 | 93226 | 93226: Glennville | 2021-01-27 | Kern | 29 | 15 | 195 | |
888807 | 888807 | 93227 | Goshen: 93227 | 2021-01-27 | Tulare | 107 | 85 | 3425 | |
888808 | 888808 | 93235 | Ivanhoe: 93235 | 2021-01-27 | Tulare | 107 | 459 | 4198 | |
887753 | 887753 | 93238 | 93238: Kernville | 2021-01-27 | Kern | 29 | 53 | 1408 | |
887754 | 887754 | 93240 | 93240: Lake Isabella | 2021-01-27 | Kern | 29 | 230 | 6960 | |
887755 | 887755 | 93241 | 93241: Lamont | 2021-01-27 | Kern | 29 | 2028 | 16969 | |
887756 | 887756 | 93243 | 93243: Lebec | 2021-01-27 | Kern | 29 | 84 | 1709 | |
888809 | 888809 | 93247 | Lindsay: 93247 | 2021-01-27 | Tulare | 107 | 1664 | 18522 | |
887757 | 887757 | 93249 | 93249: Lost Hills | 2021-01-27 | Kern | 29 | 254 | 2264 | |
887758 | 887758 | 93250 | 93250: Mc Farland | 2021-01-27 | Kern | 29 | 2084 | 15523 | |
887759 | 887759 | 93251 | 93251: Mc Kittrick | 2021-01-27 | Kern | 29 | 18 | 243 | |
887760 | 887760 | 93252 | 93252: Maricopa | 2021-01-27 | Kern | 29 | 83 | 3188 | |
887761 | 887761 | 93255 | 93255: Onyx | 2021-01-27 | Kern | 29 | 8 | 707 | |
888810 | 888810 | 93256 | Pixley: 93256 | 2021-01-27 | Tulare | 107 | 714 | 5939 | |
888811 | 888811 | 93257 | Porterville: 93257 | 2021-01-27 | Tulare | 107 | 8763 | 76923 | |
888812 | 888812 | 93262 | Mountain: 93262 | 2021-01-27 | Tulare | 107 | 38 | 3271 | |
887762 | 887762 | 93263 | 93263: Shafter | 2021-01-27 | Kern | 29 | 3044 | 20710 |
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 );