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, date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 1895 | 1895 | 2020-10-29 | San Mateo | 81 | Atherton | 42 | -122.202983 | 37.45118 | |
| 1896 | 1896 | 2020-10-29 | San Mateo | 81 | Belmont | 163 | -122.290029 | 37.517802 | |
| 1897 | 1897 | 2020-10-29 | San Mateo | 81 | Brisbane | 38 | -122.407083 | 37.694842 | |
| 1898 | 1898 | 2020-10-29 | San Mateo | 81 | Broadmoor | 59 | -122.478889 | 37.6925 | |
| 1899 | 1899 | 2020-10-29 | San Mateo | 81 | Burlingame | 251 | -122.367428 | 37.568525 | |
| 1900 | 1900 | 2020-10-29 | San Mateo | 81 | Colma | 60 | -122.452386 | 37.690456 | |
| 1901 | 1901 | 2020-10-29 | San Mateo | 81 | Daly City | 1713 | -122.486349 | 37.68 | |
| 1902 | 1902 | 2020-10-29 | San Mateo | 81 | East Palo Alto | 1403 | -122.117826 | 37.453055 | |
| 1903 | 1903 | 2020-10-29 | San Mateo | 81 | El Granada | 42 | -122.47323 | 37.503766 | |
| 1904 | 1904 | 2020-10-29 | San Mateo | 81 | Emerald Hills | 32 | -122.268 | 37.4647 | |
| 1905 | 1905 | 2020-10-29 | San Mateo | 81 | Foster City | 145 | -122.27106 | 37.554948 | |
| 1906 | 1906 | 2020-10-29 | San Mateo | 81 | Half Moon Bay | 311 | -122.4354 | 37.490308 | |
| 1907 | 1907 | 2020-10-29 | San Mateo | 81 | Hillsborough | 68 | -122.3794 | 37.5741 | |
| 1908 | 1908 | 2020-10-29 | San Mateo | 81 | La Honda | 1 | 9 or fewer | -122.208658 | 37.291115 |
| 1909 | 1909 | 2020-10-29 | San Mateo | 81 | Ladera | 12 | -122.197222 | 37.399444 | |
| 1910 | 1910 | 2020-10-29 | San Mateo | 81 | Loma Mar | 1 | 9 or fewer | -122.276731 | 37.27042 |
| 1911 | 1911 | 2020-10-29 | San Mateo | 81 | Menlo Park | 394 | -122.180281 | 37.448491 | |
| 1912 | 1912 | 2020-10-29 | San Mateo | 81 | Millbrae | 214 | -122.418411 | 37.595895 | |
| 1913 | 1913 | 2020-10-29 | San Mateo | 81 | Montara | 14 | -122.511815 | 37.540905 | |
| 1914 | 1914 | 2020-10-29 | San Mateo | 81 | Moss Beach | 14 | -122.486349 | 37.546354 | |
| 1915 | 1915 | 2020-10-29 | San Mateo | 81 | North Fair Oaks | 551 | -122.1966 | 37.4744 | |
| 1916 | 1916 | 2020-10-29 | San Mateo | 81 | Pacifica | 237 | 122.480689 | 37.610177 | |
| 1917 | 1917 | 2020-10-29 | San Mateo | 81 | Pescadero | 20 | -122.333426 | 37.205116 | |
| 1918 | 1918 | 2020-10-29 | San Mateo | 81 | Portola Valley | 24 | -122.208658 | 37.387118 | |
| 1919 | 1919 | 2020-10-29 | San Mateo | 81 | Princeton | 1 | 9 or fewer | -122.01 | 39.4032 |
| 1920 | 1920 | 2020-10-29 | San Mateo | 81 | Redwood City | 1614 | -122.2364 | 37.4852 | |
| 1921 | 1921 | 2020-10-29 | San Mateo | 81 | San Bruno | 513 | -122.429737 | 37.62107 | |
| 1922 | 1922 | 2020-10-29 | San Mateo | 81 | San Carlos | 143 | -122.27106 | 37.497516 | |
| 1923 | 1923 | 2020-10-29 | San Mateo | 81 | San Mateo | 1665 | -122.3255 | 37.563 | |
| 1924 | 1924 | 2020-10-29 | San Mateo | 81 | South San Francisco | 1204 | -122.418411 | 37.65319 | |
| 1925 | 1925 | 2020-10-29 | San Mateo | 81 | West Menlo Park | 13 | -122.203 | 37.4335 | |
| 1926 | 1926 | 2020-10-29 | San Mateo | 81 | Woodside | 39 | -122.2539 | 37.4299 | |
| 7098 | 7098 | 2020-10-23 | San Mateo | 81 | Atherton | 44 | -122.202983 | 37.45118 | |
| 7099 | 7099 | 2020-10-23 | San Mateo | 81 | Belmont | 160 | -122.290029 | 37.517802 | |
| 7100 | 7100 | 2020-10-23 | San Mateo | 81 | Brisbane | 36 | -122.407083 | 37.694842 | |
| 7101 | 7101 | 2020-10-23 | San Mateo | 81 | Broadmoor | 1 | 9 or fewer | -122.478889 | 37.6925 |
| 7102 | 7102 | 2020-10-23 | San Mateo | 81 | Burlingame | 247 | -122.367428 | 37.568525 | |
| 7103 | 7103 | 2020-10-23 | San Mateo | 81 | Colma | 31 | -122.452386 | 37.690456 | |
| 7104 | 7104 | 2020-10-23 | San Mateo | 81 | Daly City | 1747 | -122.486349 | 37.68 | |
| 7105 | 7105 | 2020-10-23 | San Mateo | 81 | East Palo Alto | 1370 | -122.117826 | 37.453055 | |
| 7106 | 7106 | 2020-10-23 | San Mateo | 81 | El Granada | 29 | -122.47323 | 37.503766 | |
| 7107 | 7107 | 2020-10-23 | San Mateo | 81 | Emerald Hills | 25 | -122.268 | 37.4647 | |
| 7108 | 7108 | 2020-10-23 | San Mateo | 81 | Foster City | 139 | -122.27106 | 37.554948 | |
| 7109 | 7109 | 2020-10-23 | San Mateo | 81 | Half Moon Bay | 375 | -122.4354 | 37.490308 | |
| 7110 | 7110 | 2020-10-23 | San Mateo | 81 | Hillsborough | 63 | -122.3794 | 37.5741 | |
| 7111 | 7111 | 2020-10-23 | San Mateo | 81 | La Honda | 1 | 9 or fewer | -122.208658 | 37.291115 |
| 7112 | 7112 | 2020-10-23 | San Mateo | 81 | Ladera | 1 | 9 or fewer | -122.197222 | 37.399444 |
| 7113 | 7113 | 2020-10-23 | San Mateo | 81 | Loma Mar | 1 | 9 or fewer | -122.276731 | 37.27042 |
| 7114 | 7114 | 2020-10-23 | San Mateo | 81 | Menlo Park | 451 | -122.180281 | 37.448491 | |
| 7115 | 7115 | 2020-10-23 | San Mateo | 81 | Millbrae | 211 | -122.418411 | 37.595895 | |
| 7116 | 7116 | 2020-10-23 | San Mateo | 81 | Montara | 13 | -122.511815 | 37.540905 | |
| 7117 | 7117 | 2020-10-23 | San Mateo | 81 | Moss Beach | 48 | -122.486349 | 37.546354 | |
| 7118 | 7118 | 2020-10-23 | San Mateo | 81 | North Fair Oaks | 1 | 9 or fewer | -122.1966 | 37.4744 |
| 7119 | 7119 | 2020-10-23 | San Mateo | 81 | Pacifica | 228 | 122.480689 | 37.610177 | |
| 7120 | 7120 | 2020-10-23 | San Mateo | 81 | Pescadero | 25 | -122.333426 | 37.205116 | |
| 7121 | 7121 | 2020-10-23 | San Mateo | 81 | Portola Valley | 38 | -122.208658 | 37.387118 | |
| 7122 | 7122 | 2020-10-23 | San Mateo | 81 | Princeton | 1 | 9 or fewer | -122.01 | 39.4032 |
| 7123 | 7123 | 2020-10-23 | San Mateo | 81 | Redwood City | 2163 | -122.2364 | 37.4852 | |
| 7124 | 7124 | 2020-10-23 | San Mateo | 81 | San Bruno | 495 | -122.429737 | 37.62107 | |
| 7125 | 7125 | 2020-10-23 | San Mateo | 81 | San Carlos | 147 | -122.27106 | 37.497516 | |
| 7126 | 7126 | 2020-10-23 | San Mateo | 81 | San Mateo | 1643 | -122.3255 | 37.563 | |
| 7127 | 7127 | 2020-10-23 | San Mateo | 81 | South San Francisco | 1173 | -122.418411 | 37.65319 | |
| 7128 | 7128 | 2020-10-23 | San Mateo | 81 | West Menlo Park | 1 | 9 or fewer | -122.203 | 37.4335 |
| 7129 | 7129 | 2020-10-23 | San Mateo | 81 | Woodside | 43 | -122.2539 | 37.4299 | |
| 13235 | 13235 | 2020-10-16 | San Mateo | 81 | Atherton | 45 | -122.202983 | 37.45118 | |
| 13236 | 13236 | 2020-10-16 | San Mateo | 81 | Belmont | 149 | -122.290029 | 37.517802 | |
| 13237 | 13237 | 2020-10-16 | San Mateo | 81 | Brisbane | 36 | -122.407083 | 37.694842 | |
| 13238 | 13238 | 2020-10-16 | San Mateo | 81 | Broadmoor | 1 | 9 or fewer | -122.478889 | 37.6925 |
| 13239 | 13239 | 2020-10-16 | San Mateo | 81 | Burlingame | 237 | -122.367428 | 37.568525 | |
| 13240 | 13240 | 2020-10-16 | San Mateo | 81 | Colma | 26 | -122.452386 | 37.690456 | |
| 13241 | 13241 | 2020-10-16 | San Mateo | 81 | Daly City | 1694 | -122.486349 | 37.68 | |
| 13242 | 13242 | 2020-10-16 | San Mateo | 81 | East Palo Alto | 1334 | -122.117826 | 37.453055 | |
| 13243 | 13243 | 2020-10-16 | San Mateo | 81 | El Granada | 29 | -122.47323 | 37.503766 | |
| 13244 | 13244 | 2020-10-16 | San Mateo | 81 | Emerald Hills | 25 | -122.268 | 37.4647 | |
| 13245 | 13245 | 2020-10-16 | San Mateo | 81 | Foster City | 134 | -122.27106 | 37.554948 | |
| 13246 | 13246 | 2020-10-16 | San Mateo | 81 | Half Moon Bay | 368 | -122.4354 | 37.490308 | |
| 13247 | 13247 | 2020-10-16 | San Mateo | 81 | Hillsborough | 58 | -122.3794 | 37.5741 | |
| 13248 | 13248 | 2020-10-16 | San Mateo | 81 | La Honda | 1 | 9 or fewer | -122.208658 | 37.291115 |
| 13249 | 13249 | 2020-10-16 | San Mateo | 81 | Ladera | 1 | 9 or fewer | -122.197222 | 37.399444 |
| 13250 | 13250 | 2020-10-16 | San Mateo | 81 | Loma Mar | 1 | 9 or fewer | -122.276731 | 37.27042 |
| 13251 | 13251 | 2020-10-16 | San Mateo | 81 | Menlo Park | 433 | -122.180281 | 37.448491 | |
| 13252 | 13252 | 2020-10-16 | San Mateo | 81 | Millbrae | 207 | -122.418411 | 37.595895 | |
| 13253 | 13253 | 2020-10-16 | San Mateo | 81 | Montara | 13 | -122.511815 | 37.540905 | |
| 13254 | 13254 | 2020-10-16 | San Mateo | 81 | Moss Beach | 46 | -122.486349 | 37.546354 | |
| 13255 | 13255 | 2020-10-16 | San Mateo | 81 | North Fair Oaks | 1 | 9 or fewer | -122.1966 | 37.4744 |
| 13256 | 13256 | 2020-10-16 | San Mateo | 81 | Pacifica | 223 | 122.480689 | 37.610177 | |
| 13257 | 13257 | 2020-10-16 | San Mateo | 81 | Pescadero | 24 | -122.333426 | 37.205116 | |
| 13258 | 13258 | 2020-10-16 | San Mateo | 81 | Portola Valley | 38 | -122.208658 | 37.387118 | |
| 13259 | 13259 | 2020-10-16 | San Mateo | 81 | Princeton | 1 | 9 or fewer | -122.01 | 39.4032 |
| 13260 | 13260 | 2020-10-16 | San Mateo | 81 | Redwood City | 2122 | -122.2364 | 37.4852 | |
| 13261 | 13261 | 2020-10-16 | San Mateo | 81 | San Bruno | 482 | -122.429737 | 37.62107 | |
| 13262 | 13262 | 2020-10-16 | San Mateo | 81 | San Carlos | 143 | -122.27106 | 37.497516 | |
| 13263 | 13263 | 2020-10-16 | San Mateo | 81 | San Mateo | 1591 | -122.3255 | 37.563 | |
| 13264 | 13264 | 2020-10-16 | San Mateo | 81 | South San Francisco | 1135 | -122.418411 | 37.65319 | |
| 13265 | 13265 | 2020-10-16 | San Mateo | 81 | West Menlo Park | 1 | 9 or fewer | -122.203 | 37.4335 |
| 13266 | 13266 | 2020-10-16 | San Mateo | 81 | Woodside | 40 | -122.2539 | 37.4299 | |
| 19278 | 19278 | 2020-10-09 | San Mateo | 81 | Atherton | 45 | -122.202983 | 37.45118 | |
| 19279 | 19279 | 2020-10-09 | San Mateo | 81 | Belmont | 145 | -122.290029 | 37.517802 | |
| 19280 | 19280 | 2020-10-09 | San Mateo | 81 | Brisbane | 36 | -122.407083 | 37.694842 | |
| 19281 | 19281 | 2020-10-09 | San Mateo | 81 | Broadmoor | 1 | 9 or fewer | -122.478889 | 37.6925 |
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 );