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,277 rows where "date" is on date 2022-02-28
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
381772 | 381772 | Auberry | Auberry | 2022-02-28 | Fresno | 19 | 262 | 3994 | |
381773 | 381773 | Biola | Biola | 2022-02-28 | Fresno | 19 | 300 | 949 | |
381774 | 381774 | Cantua Creek | Cantua Creek | 2022-02-28 | Fresno | 19 | 202 | 1125 | |
381775 | 381775 | Caruthers | Caruthers | 2022-02-28 | Fresno | 19 | 1092 | 5887 | |
381776 | 381776 | Clovis | Clovis | 2022-02-28 | Fresno | 19 | 16159 | 122949 | |
381777 | 381777 | Coalinga | Coalinga | 2022-02-28 | Fresno | 19 | 5023 | 19345 | |
381778 | 381778 | Del Rey | Del Rey | 2022-02-28 | Fresno | 19 | 482 | 2759 | |
381779 | 381779 | Dinuba | Dinuba | 2022-02-28 | Fresno | 19 | 77 | 0 | |
381780 | 381780 | Dos Palos | Dos Palos | 2022-02-28 | Fresno | 19 | 0 | ||
381781 | 381781 | Dunlap | Dunlap | 2022-02-28 | Fresno | 19 | 6 | ||
381782 | 381782 | Firebaugh | Firebaugh | 2022-02-28 | Fresno | 19 | 1640 | 9965 | |
381783 | 381783 | Five Points | Five Points | 2022-02-28 | Fresno | 19 | 82 | 0 | |
381784 | 381784 | Fowler | Fowler | 2022-02-28 | Fresno | 19 | 1651 | 7917 | |
381785 | 381785 | Fresno | Fresno | 2022-02-28 | Fresno | 19 | 101523 | 608579 | |
381786 | 381786 | Friant | Friant | 2022-02-28 | Fresno | 19 | 170 | 1930 | |
381787 | 381787 | Huron | Huron | 2022-02-28 | Fresno | 19 | 1145 | 7579 | |
381788 | 381788 | Kerman | Kerman | 2022-02-28 | Fresno | 19 | 3818 | 21009 | |
381789 | 381789 | Kingsburg | Kingsburg | 2022-02-28 | Fresno | 19 | 2277 | 17086 | |
381790 | 381790 | Laton | Laton | 2022-02-28 | Fresno | 19 | 594 | 3513 | |
381791 | 381791 | Mendota | Mendota | 2022-02-28 | Fresno | 19 | 2355 | 13576 | |
381792 | 381792 | Orange Cove | Orange Cove | 2022-02-28 | Fresno | 19 | 2348 | 11320 | |
381793 | 381793 | Parlier | Parlier | 2022-02-28 | Fresno | 19 | 3781 | 17097 | |
381794 | 381794 | Prather | Prather | 2022-02-28 | Fresno | 19 | 128 | 0 | |
381795 | 381795 | Raisin | Raisin | 2022-02-28 | Fresno | 19 | 95 | 380 | |
381796 | 381796 | Reedley | Reedley | 2022-02-28 | Fresno | 19 | 5553 | 31129 | |
381797 | 381797 | Riverdale | Riverdale | 2022-02-28 | Fresno | 19 | 1186 | 6459 | |
381798 | 381798 | San Joaquin | San Joaquin | 2022-02-28 | Fresno | 19 | 780 | 4633 | |
381799 | 381799 | Sanger | Sanger | 2022-02-28 | Fresno | 19 | 7504 | 38252 | |
381800 | 381800 | Selma | Selma | 2022-02-28 | Fresno | 19 | 6741 | 31726 | |
381801 | 381801 | Squaw Valley | Squaw Valley | 2022-02-28 | Fresno | 19 | 250 | 3908 | |
381802 | 381802 | Tollhouse | Tollhouse | 2022-02-28 | Fresno | 19 | 173 | 2712 | |
381803 | 381803 | Tranquillity | Tranquillity | 2022-02-28 | Fresno | 19 | 175 | 1132 | |
381804 | 381804 | 92222 | 92222: Bard | 2022-02-28 | Imperial | 25 | 12 | 0 | |
381805 | 381805 | 92227 | 92227: Brawley | 2022-02-28 | Imperial | 25 | 8954 | 27255 | |
381806 | 381806 | 92231 | 92231: Calexico | 2022-02-28 | Imperial | 25 | 13503 | 40019 | |
381807 | 381807 | 92233 | 92233: Calipatria | 2022-02-28 | Imperial | 25 | 1044 | 7618 | |
381808 | 381808 | 92243 | 92243: El Centro | 2022-02-28 | Imperial | 25 | 13655 | 50484 | |
381809 | 381809 | 92244 | 92244: El Centro | 2022-02-28 | Imperial | 25 | 214 | 0 | |
381810 | 381810 | 92249 | 92249: Heber | 2022-02-28 | Imperial | 25 | 2073 | 7898 | |
381811 | 381811 | 92250 | 92250: Holtville | 2022-02-28 | Imperial | 25 | 1962 | 8979 | |
381812 | 381812 | 92251 | 92251: Imperial | 2022-02-28 | Imperial | 25 | 6248 | 23388 | |
381813 | 381813 | 92257 | 92257: Niland | 2022-02-28 | Imperial | 25 | 305 | 1332 | |
381814 | 381814 | 92259 | 92259: Ocotillo | 2022-02-28 | Imperial | 25 | 27 | 94 | |
381815 | 381815 | 92266 | 92266: Palo Verde | 2022-02-28 | Imperial | 25 | 15 | 108 | |
381816 | 381816 | 92273 | 92273: Seeley | 2022-02-28 | Imperial | 25 | 402 | 1704 | |
381817 | 381817 | 92274 | 92274: Thermal | 2022-02-28 | Imperial | 25 | 1040 | 15118 | |
381818 | 381818 | 92275 | 92275: Salton City | 2022-02-28 | Imperial | 25 | 62 | 2456 | |
381819 | 381819 | 92281 | 92281: Westmorland | 2022-02-28 | Imperial | 25 | 556 | 2859 | |
381820 | 381820 | 92283 | 92283: Winterhaven | 2022-02-28 | Imperial | 25 | 781 | 1694 | |
381821 | 381821 | 93226 | 93226: Glennville | 2022-02-28 | Kern | 29 | 35 | 195 | |
381822 | 381822 | 93238 | 93238: Kernville | 2022-02-28 | Kern | 29 | 206 | 1408 | |
381823 | 381823 | 93240 | 93240: Lake Isabella | 2022-02-28 | Kern | 29 | 1006 | 6960 | |
381824 | 381824 | 93241 | 93241: Lamont | 2022-02-28 | Kern | 29 | 4470 | 16969 | |
381825 | 381825 | 93243 | 93243: Lebec | 2022-02-28 | Kern | 29 | 227 | 1709 | |
381826 | 381826 | 93249 | 93249: Lost Hills | 2022-02-28 | Kern | 29 | 558 | 2264 | |
381827 | 381827 | 93250 | 93250: Mc Farland | 2022-02-28 | Kern | 29 | 4468 | 15523 | |
381828 | 381828 | 93251 | 93251: Mc Kittrick | 2022-02-28 | Kern | 29 | 52 | 243 | |
381829 | 381829 | 93252 | 93252: Maricopa | 2022-02-28 | Kern | 29 | 277 | 3188 | |
381830 | 381830 | 93255 | 93255: Onyx | 2022-02-28 | Kern | 29 | 45 | 707 | |
381831 | 381831 | 93263 | 93263: Shafter | 2022-02-28 | Kern | 29 | 6694 | 20710 | |
381832 | 381832 | 93268 | 93268: Taft | 2022-02-28 | Kern | 29 | 4148 | 17620 | |
381833 | 381833 | 93276 | 93276: Tupman | 2022-02-28 | Kern | 29 | 56 | 159 | |
381834 | 381834 | 93280 | 93280: Wasco | 2022-02-28 | Kern | 29 | 10748 | 27552 | |
381835 | 381835 | 93283 | 93283: Weldon | 2022-02-28 | Kern | 29 | 224 | 2086 | |
381836 | 381836 | 93285 | 93285: Wofford Heights | 2022-02-28 | Kern | 29 | 292 | 1723 | |
381837 | 381837 | 93287 | 93287: Woody | 2022-02-28 | Kern | 29 | 24 | 74 | |
381838 | 381838 | 93301 | 93301: Bakersfield | 2022-02-28 | Kern | 29 | 4090 | 12345 | |
381839 | 381839 | 93304 | 93304: Bakersfield | 2022-02-28 | Kern | 29 | 13875 | 50787 | |
381840 | 381840 | 93305 | 93305: Bakersfield | 2022-02-28 | Kern | 29 | 10058 | 39114 | |
381841 | 381841 | 93306 | 93306: Bakersfield | 2022-02-28 | Kern | 29 | 19989 | 70208 | |
381842 | 381842 | 93307 | 93307: Bakersfield | 2022-02-28 | Kern | 29 | 24310 | 84948 | |
381843 | 381843 | 93308 | 93308: Bakersfield | 2022-02-28 | Kern | 29 | 12242 | 54042 | |
381844 | 381844 | 93309 | 93309: Bakersfield | 2022-02-28 | Kern | 29 | 15350 | 60893 | |
381845 | 381845 | 93311 | 93311: Bakersfield | 2022-02-28 | Kern | 29 | 12062 | 44862 | |
381846 | 381846 | 93312 | 93312: Bakersfield | 2022-02-28 | Kern | 29 | 14354 | 59359 | |
381847 | 381847 | 93313 | 93313: Bakersfield | 2022-02-28 | Kern | 29 | 15970 | 51245 | |
381848 | 381848 | 93314 | 93314: Bakersfield | 2022-02-28 | Kern | 29 | 8131 | 26992 | |
381849 | 381849 | 93501 | 93501: Mojave | 2022-02-28 | Kern | 29 | 1034 | 5063 | |
381850 | 381850 | 93505 | 93505: California City | 2022-02-28 | Kern | 29 | 3137 | 13445 | |
381851 | 381851 | 93516 | 93516: Boron | 2022-02-28 | Kern | 29 | 440 | 2425 | |
381852 | 381852 | 93518 | 93518: Caliente | 2022-02-28 | Kern | 29 | 85 | 995 | |
381853 | 381853 | 93519 | 93519: Cantil | 2022-02-28 | Kern | 29 | 3 | 28 | |
381854 | 381854 | 93523 | 93523: Edwards | 2022-02-28 | Kern | 29 | 373 | 3312 | |
381855 | 381855 | 93524 | 93524: Edwards | 2022-02-28 | Kern | 29 | 49 | 168 | |
381856 | 381856 | 93203 | 93203: Arvin | 2022-02-28 | Kern | 29 | 5683 | 22471 | |
381857 | 381857 | 93205 | 93205: Bodfish | 2022-02-28 | Kern | 29 | 298 | 1593 | |
381858 | 381858 | 93206 | 93206: Buttonwillow | 2022-02-28 | Kern | 29 | 511 | 2044 | |
381859 | 381859 | 93215 | 93215: Delano | 2022-02-28 | Kern | 29 | 17343 | 55845 | |
381860 | 381860 | 93220 | 93220: Edison | 2022-02-28 | Kern | 29 | 31 | 313 | |
381861 | 381861 | 93222 | 93222: Pine Mountain Club | 2022-02-28 | Kern | 29 | 148 | 1420 | |
381862 | 381862 | 93224 | 93224: Fellows | 2022-02-28 | Kern | 29 | 95 | 402 | |
381863 | 381863 | 93225 | 93225: Frazier Park | 2022-02-28 | Kern | 29 | 715 | 5319 | |
381864 | 381864 | 93527 | 93527: Inyokern | 2022-02-28 | Kern | 29 | 295 | 1852 | |
381865 | 381865 | 93528 | 93528: Johannesburg | 2022-02-28 | Kern | 29 | 13 | 124 | |
381866 | 381866 | 93531 | 93531: Keene | 2022-02-28 | Kern | 29 | 70 | 422 | |
381867 | 381867 | 93554 | 93554: Randsburg | 2022-02-28 | Kern | 29 | 10 | 143 | |
381868 | 381868 | 93555 | 93555: Ridgecrest | 2022-02-28 | Kern | 29 | 5976 | 34075 | |
381869 | 381869 | 93560 | 93560: Rosamond | 2022-02-28 | Kern | 29 | 5061 | 20797 | |
381870 | 381870 | 93561 | 93561: Tehachapi | 2022-02-28 | Kern | 29 | 8731 | 34271 | |
381871 | 381871 | Armona | Armona | 2022-02-28 | Kings | 31 | 1468 | 3795 |
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 );