Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: note, x, y, date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2020-10-30 | Alameda | 1 | Alameda | 472 | -122.274444 | 37.756111 | |
| 2 | 2 | 2020-10-30 | Alameda | 1 | Albany | 63 | -122.297778 | 37.886944 | |
| 3 | 3 | 2020-10-30 | Alameda | 1 | Berkeley | 775 | -122.272778 | 37.871667 | |
| 4 | 4 | 2020-10-30 | Alameda | 1 | Dublin | 329 | -121.935833 | 37.702222 | |
| 5 | 5 | 2020-10-30 | Alameda | 1 | Emeryville | 105 | -122.285278 | 37.831389 | |
| 6 | 6 | 2020-10-30 | Alameda | 1 | Fremont | 1660 | -121.988611 | 37.548333 | |
| 7 | 7 | 2020-10-30 | Alameda | 1 | Hayward | 3511 | -122.080796 | 37.66882 | |
| 8 | 8 | 2020-10-30 | Alameda | 1 | Homeless | 155 | |||
| 9 | 9 | 2020-10-30 | Alameda | 1 | Livermore | 1013 | -121.768056 | 37.681944 | |
| 10 | 10 | 2020-10-30 | Alameda | 1 | Newark | 635 | -122.033333 | 37.533333 | |
| 11 | 11 | 2020-10-30 | Alameda | 1 | Oakland | 9155 | -122.270833 | 37.804444 | |
| 12 | 12 | 2020-10-30 | Alameda | 1 | Other | 38 | |||
| 13 | 13 | 2020-10-30 | Alameda | 1 | Piedmont | 46 | -122.233333 | 37.816667 | |
| 14 | 14 | 2020-10-30 | Alameda | 1 | Pleasanton | 522 | -121.874722 | 37.6625 | |
| 15 | 15 | 2020-10-30 | Alameda | 1 | San Leandro | 1326 | -122.156111 | 37.725 | |
| 16 | 16 | 2020-10-30 | Alameda | 1 | Sunol | 13 | -121.888611 | 37.594444 | |
| 17 | 17 | 2020-10-30 | Alameda | 1 | Union City | 916 | -122.048333 | 37.596389 | |
| 1032 | 1032 | 2020-10-29 | Alameda | 1 | Alameda | 468 | -122.274444 | 37.756111 | |
| 1033 | 1033 | 2020-10-29 | Alameda | 1 | Albany | 63 | -122.297778 | 37.886944 | |
| 1034 | 1034 | 2020-10-29 | Alameda | 1 | Berkeley | 772 | -122.272778 | 37.871667 | |
| 1035 | 1035 | 2020-10-29 | Alameda | 1 | Dublin | 328 | -121.935833 | 37.702222 | |
| 1036 | 1036 | 2020-10-29 | Alameda | 1 | Emeryville | 105 | -122.285278 | 37.831389 | |
| 1037 | 1037 | 2020-10-29 | Alameda | 1 | Fremont | 1643 | -121.988611 | 37.548333 | |
| 1038 | 1038 | 2020-10-29 | Alameda | 1 | Hayward | 3493 | -122.080796 | 37.66882 | |
| 1039 | 1039 | 2020-10-29 | Alameda | 1 | Homeless | 155 | |||
| 1040 | 1040 | 2020-10-29 | Alameda | 1 | Livermore | 1009 | -121.768056 | 37.681944 | |
| 1041 | 1041 | 2020-10-29 | Alameda | 1 | Newark | 632 | -122.033333 | 37.533333 | |
| 1042 | 1042 | 2020-10-29 | Alameda | 1 | Oakland | 9117 | -122.270833 | 37.804444 | |
| 1043 | 1043 | 2020-10-29 | Alameda | 1 | Other | 38 | |||
| 1044 | 1044 | 2020-10-29 | Alameda | 1 | Piedmont | 44 | -122.233333 | 37.816667 | |
| 1045 | 1045 | 2020-10-29 | Alameda | 1 | Pleasanton | 517 | -121.874722 | 37.6625 | |
| 1046 | 1046 | 2020-10-29 | Alameda | 1 | San Leandro | 1310 | -122.156111 | 37.725 | |
| 1047 | 1047 | 2020-10-29 | Alameda | 1 | Sunol | 12 | -121.888611 | 37.594444 | |
| 1048 | 1048 | 2020-10-29 | Alameda | 1 | Union City | 910 | -122.048333 | 37.596389 | |
| 2032 | 2032 | 2020-10-28 | Alameda | 1 | Alameda | 465 | -122.274444 | 37.756111 | |
| 2033 | 2033 | 2020-10-28 | Alameda | 1 | Albany | 63 | -122.297778 | 37.886944 | |
| 2034 | 2034 | 2020-10-28 | Alameda | 1 | Berkeley | 764 | -122.272778 | 37.871667 | |
| 2035 | 2035 | 2020-10-28 | Alameda | 1 | Dublin | 328 | -121.935833 | 37.702222 | |
| 2036 | 2036 | 2020-10-28 | Alameda | 1 | Emeryville | 105 | -122.285278 | 37.831389 | |
| 2037 | 2037 | 2020-10-28 | Alameda | 1 | Fremont | 1639 | -121.988611 | 37.548333 | |
| 2038 | 2038 | 2020-10-28 | Alameda | 1 | Hayward | 3488 | -122.080796 | 37.66882 | |
| 2039 | 2039 | 2020-10-28 | Alameda | 1 | Homeless | 152 | |||
| 2040 | 2040 | 2020-10-28 | Alameda | 1 | Livermore | 1008 | -121.768056 | 37.681944 | |
| 2041 | 2041 | 2020-10-28 | Alameda | 1 | Newark | 632 | -122.033333 | 37.533333 | |
| 2042 | 2042 | 2020-10-28 | Alameda | 1 | Oakland | 9096 | -122.270833 | 37.804444 | |
| 2043 | 2043 | 2020-10-28 | Alameda | 1 | Other | 38 | |||
| 2044 | 2044 | 2020-10-28 | Alameda | 1 | Piedmont | 43 | -122.233333 | 37.816667 | |
| 2045 | 2045 | 2020-10-28 | Alameda | 1 | Pleasanton | 515 | -121.874722 | 37.6625 | |
| 2046 | 2046 | 2020-10-28 | Alameda | 1 | San Leandro | 1306 | -122.156111 | 37.725 | |
| 2047 | 2047 | 2020-10-28 | Alameda | 1 | Sunol | 12 | -121.888611 | 37.594444 | |
| 2048 | 2048 | 2020-10-28 | Alameda | 1 | Union City | 906 | -122.048333 | 37.596389 | |
| 2984 | 2984 | 2020-10-27 | Alameda | 1 | Alameda | 459 | -122.274444 | 37.756111 | |
| 2985 | 2985 | 2020-10-27 | Alameda | 1 | Albany | 63 | -122.297778 | 37.886944 | |
| 2986 | 2986 | 2020-10-27 | Alameda | 1 | Berkeley | 757 | -122.272778 | 37.871667 | |
| 2987 | 2987 | 2020-10-27 | Alameda | 1 | Dublin | 326 | -121.935833 | 37.702222 | |
| 2988 | 2988 | 2020-10-27 | Alameda | 1 | Emeryville | 104 | -122.285278 | 37.831389 | |
| 2989 | 2989 | 2020-10-27 | Alameda | 1 | Fremont | 1633 | -121.988611 | 37.548333 | |
| 2990 | 2990 | 2020-10-27 | Alameda | 1 | Hayward | 3475 | -122.080796 | 37.66882 | |
| 2991 | 2991 | 2020-10-27 | Alameda | 1 | Homeless | 152 | |||
| 2992 | 2992 | 2020-10-27 | Alameda | 1 | Livermore | 1004 | -121.768056 | 37.681944 | |
| 2993 | 2993 | 2020-10-27 | Alameda | 1 | Newark | 630 | -122.033333 | 37.533333 | |
| 2994 | 2994 | 2020-10-27 | Alameda | 1 | Oakland | 9064 | -122.270833 | 37.804444 | |
| 2995 | 2995 | 2020-10-27 | Alameda | 1 | Other | 38 | |||
| 2996 | 2996 | 2020-10-27 | Alameda | 1 | Piedmont | 43 | -122.233333 | 37.816667 | |
| 2997 | 2997 | 2020-10-27 | Alameda | 1 | Pleasanton | 513 | -121.874722 | 37.6625 | |
| 2998 | 2998 | 2020-10-27 | Alameda | 1 | San Leandro | 1291 | -122.156111 | 37.725 | |
| 2999 | 2999 | 2020-10-27 | Alameda | 1 | Sunol | 12 | -121.888611 | 37.594444 | |
| 3000 | 3000 | 2020-10-27 | Alameda | 1 | Union City | 905 | -122.048333 | 37.596389 | |
| 3960 | 3960 | 2020-10-26 | Alameda | 1 | Alameda | 458 | -122.274444 | 37.756111 | |
| 3961 | 3961 | 2020-10-26 | Alameda | 1 | Albany | 63 | -122.297778 | 37.886944 | |
| 3962 | 3962 | 2020-10-26 | Alameda | 1 | Berkeley | 756 | -122.272778 | 37.871667 | |
| 3963 | 3963 | 2020-10-26 | Alameda | 1 | Dublin | 324 | -121.935833 | 37.702222 | |
| 3964 | 3964 | 2020-10-26 | Alameda | 1 | Emeryville | 104 | -122.285278 | 37.831389 | |
| 3965 | 3965 | 2020-10-26 | Alameda | 1 | Fremont | 1619 | -121.988611 | 37.548333 | |
| 3966 | 3966 | 2020-10-26 | Alameda | 1 | Hayward | 3465 | -122.080796 | 37.66882 | |
| 3967 | 3967 | 2020-10-26 | Alameda | 1 | Homeless | 152 | |||
| 3968 | 3968 | 2020-10-26 | Alameda | 1 | Livermore | 1005 | -121.768056 | 37.681944 | |
| 3969 | 3969 | 2020-10-26 | Alameda | 1 | Newark | 623 | -122.033333 | 37.533333 | |
| 3970 | 3970 | 2020-10-26 | Alameda | 1 | Oakland | 9038 | -122.270833 | 37.804444 | |
| 3971 | 3971 | 2020-10-26 | Alameda | 1 | Other | 38 | |||
| 3972 | 3972 | 2020-10-26 | Alameda | 1 | Piedmont | 42 | -122.233333 | 37.816667 | |
| 3973 | 3973 | 2020-10-26 | Alameda | 1 | Pleasanton | 512 | -121.874722 | 37.6625 | |
| 3974 | 3974 | 2020-10-26 | Alameda | 1 | San Leandro | 1286 | -122.156111 | 37.725 | |
| 3975 | 3975 | 2020-10-26 | Alameda | 1 | Sunol | 12 | -121.888611 | 37.594444 | |
| 3976 | 3976 | 2020-10-26 | Alameda | 1 | Union City | 900 | -122.048333 | 37.596389 | |
| 4921 | 4921 | 2020-10-25 | Alameda | 1 | Alameda | 456 | -122.274444 | 37.756111 | |
| 4922 | 4922 | 2020-10-25 | Alameda | 1 | Albany | 63 | -122.297778 | 37.886944 | |
| 4923 | 4923 | 2020-10-25 | Alameda | 1 | Berkeley | 749 | -122.272778 | 37.871667 | |
| 4924 | 4924 | 2020-10-25 | Alameda | 1 | Dublin | 320 | -121.935833 | 37.702222 | |
| 4925 | 4925 | 2020-10-25 | Alameda | 1 | Emeryville | 102 | -122.285278 | 37.831389 | |
| 4926 | 4926 | 2020-10-25 | Alameda | 1 | Fremont | 1615 | -121.988611 | 37.548333 | |
| 4927 | 4927 | 2020-10-25 | Alameda | 1 | Hayward | 3454 | -122.080796 | 37.66882 | |
| 4928 | 4928 | 2020-10-25 | Alameda | 1 | Homeless | 152 | |||
| 4929 | 4929 | 2020-10-25 | Alameda | 1 | Livermore | 1002 | -121.768056 | 37.681944 | |
| 4930 | 4930 | 2020-10-25 | Alameda | 1 | Newark | 618 | -122.033333 | 37.533333 | |
| 4931 | 4931 | 2020-10-25 | Alameda | 1 | Oakland | 9021 | -122.270833 | 37.804444 | |
| 4932 | 4932 | 2020-10-25 | Alameda | 1 | Other | 38 | |||
| 4933 | 4933 | 2020-10-25 | Alameda | 1 | Piedmont | 42 | -122.233333 | 37.816667 | |
| 4934 | 4934 | 2020-10-25 | Alameda | 1 | Pleasanton | 506 | -121.874722 | 37.6625 | |
| 4935 | 4935 | 2020-10-25 | Alameda | 1 | San Leandro | 1285 | -122.156111 | 37.725 |
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT );