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,131 rows where "date" is on date 2020-05-12
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1198820 | 1198820 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2020-05-12 | El Dorado | 17 | 0 | 35294 | |
1198821 | 1198821 | South County | South County | 2020-05-12 | El Dorado | 17 | 4 | 10345 | |
1198822 | 1198822 | Tahoe Region | Tahoe Region | 2020-05-12 | El Dorado | 17 | 20 | 30275 | |
1198823 | 1198823 | Auberry | Auberry | 2020-05-12 | Fresno | 19 | 0 | 3994 | |
1198824 | 1198824 | Biola | Biola | 2020-05-12 | Fresno | 19 | 0 | 949 | |
1198825 | 1198825 | Cantua Creek | Cantua Creek | 2020-05-12 | Fresno | 19 | 0 | 1125 | |
1198826 | 1198826 | Caruthers | Caruthers | 2020-05-12 | Fresno | 19 | 0 | 5887 | |
1198827 | 1198827 | Clovis | Clovis | 2020-05-12 | Fresno | 19 | 53 | 122949 | |
1198828 | 1198828 | Coalinga | Coalinga | 2020-05-12 | Fresno | 19 | 6 | 19345 | |
1198829 | 1198829 | Del Rey | Del Rey | 2020-05-12 | Fresno | 19 | 6 | 2759 | |
1198830 | 1198830 | Dinuba | Dinuba | 2020-05-12 | Fresno | 19 | 0 | 0 | |
1198831 | 1198831 | Dos Palos | Dos Palos | 2020-05-12 | Fresno | 19 | 0 | ||
1198832 | 1198832 | Dunlap | Dunlap | 2020-05-12 | Fresno | 19 | 0 | ||
1198833 | 1198833 | Firebaugh | Firebaugh | 2020-05-12 | Fresno | 19 | 22 | 9965 | |
1198834 | 1198834 | Five Points | Five Points | 2020-05-12 | Fresno | 19 | 0 | 0 | |
1198835 | 1198835 | Fowler | Fowler | 2020-05-12 | Fresno | 19 | 4 | 4 or fewer | 7917 |
1198836 | 1198836 | Fresno | Fresno | 2020-05-12 | Fresno | 19 | 437 | 608579 | |
1198837 | 1198837 | Friant | Friant | 2020-05-12 | Fresno | 19 | 0 | 1930 | |
1198838 | 1198838 | Huron | Huron | 2020-05-12 | Fresno | 19 | 23 | 7579 | |
1198839 | 1198839 | Kerman | Kerman | 2020-05-12 | Fresno | 19 | 10 | 21009 | |
1198840 | 1198840 | Kingsburg | Kingsburg | 2020-05-12 | Fresno | 19 | 23 | 17086 | |
1198841 | 1198841 | Laton | Laton | 2020-05-12 | Fresno | 19 | 7 | 3513 | |
1198842 | 1198842 | Mendota | Mendota | 2020-05-12 | Fresno | 19 | 32 | 13576 | |
1198843 | 1198843 | Orange Cove | Orange Cove | 2020-05-12 | Fresno | 19 | 43 | 11320 | |
1198844 | 1198844 | Parlier | Parlier | 2020-05-12 | Fresno | 19 | 45 | 17097 | |
1198845 | 1198845 | Prather | Prather | 2020-05-12 | Fresno | 19 | 0 | 0 | |
1198846 | 1198846 | Raisin | Raisin | 2020-05-12 | Fresno | 19 | 0 | 380 | |
1198847 | 1198847 | Reedley | Reedley | 2020-05-12 | Fresno | 19 | 61 | 31129 | |
1198848 | 1198848 | Riverdale | Riverdale | 2020-05-12 | Fresno | 19 | 0 | 6459 | |
1198849 | 1198849 | San Joaquin | San Joaquin | 2020-05-12 | Fresno | 19 | 4 | 4 or fewer | 4633 |
1198850 | 1198850 | Sanger | Sanger | 2020-05-12 | Fresno | 19 | 82 | 38252 | |
1198851 | 1198851 | Selma | Selma | 2020-05-12 | Fresno | 19 | 106 | 31726 | |
1198852 | 1198852 | Squaw Valley | Squaw Valley | 2020-05-12 | Fresno | 19 | 0 | 3908 | |
1198853 | 1198853 | Tollhouse | Tollhouse | 2020-05-12 | Fresno | 19 | 0 | 2712 | |
1198854 | 1198854 | Tranquillity | Tranquillity | 2020-05-12 | Fresno | 19 | 0 | 1132 | |
1198855 | 1198855 | 92222 | 92222: Bard | 2020-05-12 | Imperial | 25 | 0 | 0 | |
1198856 | 1198856 | 92227 | 92227: Brawley | 2020-05-12 | Imperial | 25 | 120 | 27255 | |
1198857 | 1198857 | 92231 | 92231: Calexico | 2020-05-12 | Imperial | 25 | 184 | 40019 | |
1198858 | 1198858 | 92233 | 92233: Calipatria | 2020-05-12 | Imperial | 25 | 12 | 7618 | |
1198859 | 1198859 | 92243 | 92243: El Centro | 2020-05-12 | Imperial | 25 | 0 | 50484 | |
1198860 | 1198860 | 92244 | 92244: El Centro | 2020-05-12 | Imperial | 25 | 0 | 0 | |
1198861 | 1198861 | 92249 | 92249: Heber | 2020-05-12 | Imperial | 25 | 23 | 7898 | |
1198862 | 1198862 | 92250 | 92250: Holtville | 2020-05-12 | Imperial | 25 | 24 | 8979 | |
1198863 | 1198863 | 92251 | 92251: Imperial | 2020-05-12 | Imperial | 25 | 56 | 23388 | |
1198864 | 1198864 | 92257 | 92257: Niland | 2020-05-12 | Imperial | 25 | 1 | 1332 | |
1198865 | 1198865 | 92259 | 92259: Ocotillo | 2020-05-12 | Imperial | 25 | 0 | 94 | |
1198866 | 1198866 | 92266 | 92266: Palo Verde | 2020-05-12 | Imperial | 25 | 0 | 108 | |
1198867 | 1198867 | 92273 | 92273: Seeley | 2020-05-12 | Imperial | 25 | 2 | 1704 | |
1198868 | 1198868 | 92274 | 92274: Thermal | 2020-05-12 | Imperial | 25 | 8 | 15118 | |
1198869 | 1198869 | 92275 | 92275: Salton City | 2020-05-12 | Imperial | 25 | 5 | 2456 | |
1198870 | 1198870 | 92281 | 92281: Westmorland | 2020-05-12 | Imperial | 25 | 6 | 2859 | |
1198871 | 1198871 | 92283 | 92283: Winterhaven | 2020-05-12 | Imperial | 25 | 2 | 1694 | |
1198872 | 1198872 | 93238 | 93238: Kernville | 2020-05-12 | Kern | 29 | 0 | 1408 | |
1198873 | 1198873 | 93240 | 93240: Lake Isabella | 2020-05-12 | Kern | 29 | 1 | 6960 | |
1198874 | 1198874 | 93241 | 93241: Lamont | 2020-05-12 | Kern | 29 | 83 | 16969 | |
1198875 | 1198875 | 93243 | 93243: Lebec | 2020-05-12 | Kern | 29 | 2 | 1709 | |
1198876 | 1198876 | 93249 | 93249: Lost Hills | 2020-05-12 | Kern | 29 | 11 | 2264 | |
1198877 | 1198877 | 93250 | 93250: Mc Farland | 2020-05-12 | Kern | 29 | 6 | 15523 | |
1198878 | 1198878 | 93251 | 93251: Mc Kittrick | 2020-05-12 | Kern | 29 | 0 | 243 | |
1198879 | 1198879 | 93252 | 93252: Maricopa | 2020-05-12 | Kern | 29 | 1 | 3188 | |
1198880 | 1198880 | 93255 | 93255: Onyx | 2020-05-12 | Kern | 29 | 0 | 707 | |
1198881 | 1198881 | 93263 | 93263: Shafter | 2020-05-12 | Kern | 29 | 30 | 20710 | |
1198882 | 1198882 | 93268 | 93268: Taft | 2020-05-12 | Kern | 29 | 18 | 17620 | |
1198883 | 1198883 | 93276 | 93276: Tupman | 2020-05-12 | Kern | 29 | 0 | 159 | |
1198884 | 1198884 | 93280 | 93280: Wasco | 2020-05-12 | Kern | 29 | 30 | 27552 | |
1198885 | 1198885 | 93283 | 93283: Weldon | 2020-05-12 | Kern | 29 | 0 | 2086 | |
1198886 | 1198886 | 93285 | 93285: Wofford Heights | 2020-05-12 | Kern | 29 | 0 | 1723 | |
1198887 | 1198887 | 93287 | 93287: Woody | 2020-05-12 | Kern | 29 | 0 | 74 | |
1198888 | 1198888 | 93301 | 93301: Bakersfield | 2020-05-12 | Kern | 29 | 25 | 12345 | |
1198889 | 1198889 | 93304 | 93304: Bakersfield | 2020-05-12 | Kern | 29 | 115 | 50787 | |
1198890 | 1198890 | 93305 | 93305: Bakersfield | 2020-05-12 | Kern | 29 | 60 | 39114 | |
1198891 | 1198891 | 93306 | 93306: Bakersfield | 2020-05-12 | Kern | 29 | 120 | 70208 | |
1198892 | 1198892 | 93307 | 93307: Bakersfield | 2020-05-12 | Kern | 29 | 248 | 84948 | |
1198893 | 1198893 | 93308 | 93308: Bakersfield | 2020-05-12 | Kern | 29 | 52 | 54042 | |
1198894 | 1198894 | 93309 | 93309: Bakersfield | 2020-05-12 | Kern | 29 | 123 | 60893 | |
1198895 | 1198895 | 93311 | 93311: Bakersfield | 2020-05-12 | Kern | 29 | 62 | 44862 | |
1198896 | 1198896 | 93312 | 93312: Bakersfield | 2020-05-12 | Kern | 29 | 61 | 59359 | |
1198897 | 1198897 | 93313 | 93313: Bakersfield | 2020-05-12 | Kern | 29 | 100 | 51245 | |
1198898 | 1198898 | 93314 | 93314: Bakersfield | 2020-05-12 | Kern | 29 | 28 | 26992 | |
1198899 | 1198899 | 93501 | 93501: Mojave | 2020-05-12 | Kern | 29 | 1 | 5063 | |
1198900 | 1198900 | 93505 | 93505: California City | 2020-05-12 | Kern | 29 | 4 | 13445 | |
1198901 | 1198901 | 93516 | 93516: Boron | 2020-05-12 | Kern | 29 | 0 | 2425 | |
1198902 | 1198902 | 93518 | 93518: Caliente | 2020-05-12 | Kern | 29 | 0 | 995 | |
1198903 | 1198903 | 93519 | 93519: Cantil | 2020-05-12 | Kern | 29 | 0 | 28 | |
1198904 | 1198904 | 93523 | 93523: Edwards | 2020-05-12 | Kern | 29 | 0 | 3312 | |
1198905 | 1198905 | 93524 | 93524: Edwards | 2020-05-12 | Kern | 29 | 0 | 168 | |
1198906 | 1198906 | 93527 | 93527: Inyokern | 2020-05-12 | Kern | 29 | 1 | 1852 | |
1198907 | 1198907 | 93203 | 93203: Arvin | 2020-05-12 | Kern | 29 | 49 | 22471 | |
1198908 | 1198908 | 93205 | 93205: Bodfish | 2020-05-12 | Kern | 29 | 0 | 1593 | |
1198909 | 1198909 | 93206 | 93206: Buttonwillow | 2020-05-12 | Kern | 29 | 0 | 2044 | |
1198910 | 1198910 | 93215 | 93215: Delano | 2020-05-12 | Kern | 29 | 35 | 55845 | |
1198911 | 1198911 | 93220 | 93220: Edison | 2020-05-12 | Kern | 29 | 0 | 313 | |
1198912 | 1198912 | 93222 | 93222: Pine Mountain Club | 2020-05-12 | Kern | 29 | 3 | 1420 | |
1198913 | 1198913 | 93224 | 93224: Fellows | 2020-05-12 | Kern | 29 | 0 | 402 | |
1198914 | 1198914 | 93225 | 93225: Frazier Park | 2020-05-12 | Kern | 29 | 5 | 5319 | |
1198915 | 1198915 | 93226 | 93226: Glennville | 2020-05-12 | Kern | 29 | 0 | 195 | |
1198916 | 1198916 | 93528 | 93528: Johannesburg | 2020-05-12 | Kern | 29 | 0 | 124 | |
1198917 | 1198917 | 93531 | 93531: Keene | 2020-05-12 | Kern | 29 | 0 | 422 | |
1198918 | 1198918 | 93554 | 93554: Randsburg | 2020-05-12 | Kern | 29 | 0 | 143 | |
1198919 | 1198919 | 93555 | 93555: Ridgecrest | 2020-05-12 | Kern | 29 | 3 | 34075 |
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 );