⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

319 rows where place = "94502: Alameda" sorted by date descending

View and edit SQL

place

  • 94502: Alameda · 319

fips

  • 1 319

county

Link rowid date ▲ county fips place confirmed_cases note x y population
2 2021-01-23 Alameda 1 94502: Alameda 196   -122.241149 37.736988 14117
1324 2021-01-22 Alameda 1 94502: Alameda 196   -122.241149 37.736988 14117
2667 2021-01-21 Alameda 1 94502: Alameda 194   -122.241149 37.736988 14117
4014 2021-01-20 Alameda 1 94502: Alameda 191   -122.241149 37.736988 14117
5357 2021-01-19 Alameda 1 94502: Alameda 191   -122.241149 37.736988 14117
6691 2021-01-18 Alameda 1 94502: Alameda 191   -122.241149 37.736988 14117
8016 2021-01-17 Alameda 1 94502: Alameda 187   -122.241149 37.736988 14117
9341 2021-01-16 Alameda 1 94502: Alameda 187   -122.241149 37.736988 14117
10666 2021-01-15 Alameda 1 94502: Alameda 183   -122.241149 37.736988 14117
12012 2021-01-14 Alameda 1 94502: Alameda 183   -122.241149 37.736988 14117
13347 2021-01-13 Alameda 1 94502: Alameda 181   -122.241149 37.736988 14117
14682 2021-01-12 Alameda 1 94502: Alameda 181   -122.241149 37.736988 14117
16023 2021-01-11 Alameda 1 94502: Alameda 174   -122.241149 37.736988 14117
17359 2021-01-10 Alameda 1 94502: Alameda 172   -122.241149 37.736988 14117
18613 2021-01-09 Alameda 1 94502: Alameda 172   -122.241149 37.736988 14117
19933 2021-01-08 Alameda 1 94502: Alameda 162   -122.241149 37.736988 14117
21273 2021-01-07 Alameda 1 94502: Alameda 158   -122.241149 37.736988 14117
22608 2021-01-06 Alameda 1 94502: Alameda 158   -122.241149 37.736988 14117
23938 2021-01-05 Alameda 1 94502: Alameda 150   -122.241149 37.736988 14117
25279 2021-01-04 Alameda 1 94502: Alameda 150   -122.241149 37.736988 14117
26609 2021-01-03 Alameda 1 94502: Alameda 147   -122.241149 37.736988 14117
27906 2021-01-02 Alameda 1 94502: Alameda 146   -122.241149 37.736988 14117
29203 2021-01-01 Alameda 1 94502: Alameda 146   -122.241149 37.736988 14117
30493 2020-12-31 Alameda 1 94502: Alameda 145   -122.241149 37.736988 14117
31803 2020-12-30 Alameda 1 94502: Alameda 134   -122.241149 37.736988 14117
33113 2020-12-29 Alameda 1 94502: Alameda 134   -122.241149 37.736988 14117
34418 2020-12-28 Alameda 1 94502: Alameda 134   -122.241149 37.736988 14117
35669 2020-12-27 Alameda 1 94502: Alameda 130   -122.241149 37.736988 14117
36887 2020-12-26 Alameda 1 94502: Alameda 130   -122.241149 37.736988 14117
38109 2020-12-25 Alameda 1 94502: Alameda 126   -122.241149 37.736988 14117
38918 2020-12-24 Alameda 1 94502: Alameda 126   -122.241149 37.736988 14117
40139 2020-12-23 Alameda 1 94502: Alameda 123   -122.241149 37.736988 14117
41440 2020-12-22 Alameda 1 94502: Alameda 119   -122.241149 37.736988 14117
42663 2020-12-21 Alameda 1 94502: Alameda 119   -122.241149 37.736988 14117
43980 2020-12-20 Alameda 1 94502: Alameda 114   -122.241149 37.736988 14117
45156 2020-12-19 Alameda 1 94502: Alameda 109   -122.241149 37.736988 14117
46335 2020-12-18 Alameda 1 94502: Alameda 109   -122.241149 37.736988 14117
47640 2020-12-17 Alameda 1 94502: Alameda 109   -122.241149 37.736988 14117
48923 2020-12-16 Alameda 1 94502: Alameda 109   -122.241149 37.736988 14117
50204 2020-12-15 Alameda 1 94502: Alameda 109   -122.241149 37.736988 14117
51495 2020-12-14 Alameda 1 94502: Alameda 107   -122.241149 37.736988 14117
52790 2020-12-13 Alameda 1 94502: Alameda 104   -122.241149 37.736988 14117
53952 2020-12-12 Alameda 1 94502: Alameda 104   -122.241149 37.736988 14117
55147 2020-12-11 Alameda 1 94502: Alameda 103   -122.241149 37.736988 14117
56448 2020-12-10 Alameda 1 94502: Alameda 102   -122.241149 37.736988 14117
57707 2020-12-09 Alameda 1 94502: Alameda 101   -122.241149 37.736988 14117
58928 2020-12-08 Alameda 1 94502: Alameda 100   -122.241149 37.736988 14117
60168 2020-12-07 Alameda 1 94502: Alameda 95   -122.241149 37.736988 14117
61465 2020-12-06 Alameda 1 94502: Alameda 89   -122.241149 37.736988 14117
62571 2020-12-05 Alameda 1 94502: Alameda 89   -122.241149 37.736988 14117
63660 2020-12-04 Alameda 1 94502: Alameda 89   -122.241149 37.736988 14117
64862 2020-12-03 Alameda 1 94502: Alameda 88   -122.241149 37.736988 14117
66036 2020-12-02 Alameda 1 94502: Alameda 86   -122.241149 37.736988 14117
67179 2020-12-01 Alameda 1 94502: Alameda 84   -122.241149 37.736988 14117
68393 2020-11-30 Alameda 1 94502: Alameda 84   -122.241149 37.736988 14117
69575 2020-11-29 Alameda 1 94502: Alameda 82   -122.241149 37.736988 14117
70540 2020-11-28 Alameda 1 94502: Alameda 82   -122.241149 37.736988 14117
71546 2020-11-27 Alameda 1 94502: Alameda 79   -122.241149 37.736988 14117
72417 2020-11-26 Alameda 1 94502: Alameda 79   -122.241149 37.736988 14117
73135 2020-11-25 Alameda 1 94502: Alameda 78   -122.241149 37.736988 14117
74252 2020-11-24 Alameda 1 94502: Alameda 78   -122.241149 37.736988 14117
75438 2020-11-23 Alameda 1 94502: Alameda 77   -122.241149 37.736988 14117
76456 2020-11-22 Alameda 1 94502: Alameda 77   -122.241149 37.736988 14117
77330 2020-11-21 Alameda 1 94502: Alameda 76   -122.241149 37.736988 14117
78139 2020-11-20 Alameda 1 94502: Alameda 76   -122.241149 37.736988 14117
79347 2020-11-19 Alameda 1 94502: Alameda 76   -122.241149 37.736988 14117
80489 2020-11-18 Alameda 1 94502: Alameda 73   -122.241149 37.736988 14117
81678 2020-11-17 Alameda 1 94502: Alameda 73   -122.241149 37.736988 14117
82858 2020-11-16 Alameda 1 94502: Alameda 71   -122.241149 37.736988 14117
84037 2020-11-15 Alameda 1 94502: Alameda 70   -122.241149 37.736988 14117
84735 2020-11-14 Alameda 1 94502: Alameda 69   -122.241149 37.736988 14117
85632 2020-11-13 Alameda 1 94502: Alameda 69   -122.241149 37.736988 14117
86755 2020-11-12 Alameda 1 94502: Alameda 69   -122.241149 37.736988 14117
87917 2020-11-11 Alameda 1 94502: Alameda 69   -122.241149 37.736988 14117
88836 2020-11-10 Alameda 1 94502: Alameda 66   -122.241149 37.736988 14117
90017 2020-11-09 Alameda 1 94502: Alameda 66   -122.241149 37.736988 14117
91159 2020-11-08 Alameda 1 94502: Alameda 66   -122.241149 37.736988 14117
92024 2020-11-07 Alameda 1 94502: Alameda 65   -122.241149 37.736988 14117
92882 2020-11-06 Alameda 1 94502: Alameda 65   -122.241149 37.736988 14117
94078 2020-11-05 Alameda 1 94502: Alameda 64   -122.241149 37.736988 14117
95218 2020-11-04 Alameda 1 94502: Alameda 64   -122.241149 37.736988 14117
96396 2020-11-03 Alameda 1 94502: Alameda 63   -122.241149 37.736988 14117
97557 2020-11-02 Alameda 1 94502: Alameda 63   -122.241149 37.736988 14117
98676 2020-11-01 Alameda 1 94502: Alameda 63   -122.241149 37.736988 14117
99523 2020-10-31 Alameda 1 94502: Alameda 62   -122.241149 37.736988 14117
100394 2020-10-30 Alameda 1 94502: Alameda 61   -122.241149 37.736988 14117
101570 2020-10-29 Alameda 1 94502: Alameda 61   -122.241149 37.736988 14117
102749 2020-10-28 Alameda 1 94502: Alameda 61   -122.241149 37.736988 14117
103881 2020-10-27 Alameda 1 94502: Alameda 60   -122.241149 37.736988 14117
104974 2020-10-26 Alameda 1 94502: Alameda 60   -122.241149 37.736988 14117
106114 2020-10-25 Alameda 1 94502: Alameda 60   -122.241149 37.736988 14117
106993 2020-10-24 Alameda 1 94502: Alameda 60   -122.241149 37.736988 14117
107831 2020-10-23 Alameda 1 94502: Alameda 60   -122.241149 37.736988 14117
109003 2020-10-22 Alameda 1 94502: Alameda 60   -122.241149 37.736988 14117
110146 2020-10-21 Alameda 1 94502: Alameda 59   -122.241149 37.736988 14117
111283 2020-10-20 Alameda 1 94502: Alameda 59   -122.241149 37.736988 14117
112451 2020-10-19 Alameda 1 94502: Alameda 59   -122.241149 37.736988 14117
113601 2020-10-18 Alameda 1 94502: Alameda 58   -122.241149 37.736988 14117
114469 2020-10-17 Alameda 1 94502: Alameda 58   -122.241149 37.736988 14117
115386 2020-10-16 Alameda 1 94502: Alameda 58   -122.241149 37.736988 14117

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT,
   [population] TEXT
);