⚠️ 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

316 rows where place = "94605: Oakland" sorted by date descending

View and edit SQL

place

  • 94605: Oakland · 316

fips

  • 1 316

county

Link rowid date ▲ county fips place confirmed_cases note x y population
29 2021-01-24 Alameda 1 94605: Oakland 2117   -122.148748 37.760229 42375
1351 2021-01-23 Alameda 1 94605: Oakland 2117   -122.148748 37.760229 42375
2673 2021-01-22 Alameda 1 94605: Oakland 2119   -122.148748 37.760229 42375
4016 2021-01-21 Alameda 1 94605: Oakland 2104   -122.148748 37.760229 42375
5363 2021-01-20 Alameda 1 94605: Oakland 2062   -122.148748 37.760229 42375
6706 2021-01-19 Alameda 1 94605: Oakland 2062   -122.148748 37.760229 42375
8040 2021-01-18 Alameda 1 94605: Oakland 2062   -122.148748 37.760229 42375
9365 2021-01-17 Alameda 1 94605: Oakland 2018   -122.148748 37.760229 42375
10690 2021-01-16 Alameda 1 94605: Oakland 2018   -122.148748 37.760229 42375
12015 2021-01-15 Alameda 1 94605: Oakland 1970   -122.148748 37.760229 42375
13361 2021-01-14 Alameda 1 94605: Oakland 1970   -122.148748 37.760229 42375
14696 2021-01-13 Alameda 1 94605: Oakland 1942   -122.148748 37.760229 42375
16031 2021-01-12 Alameda 1 94605: Oakland 1911   -122.148748 37.760229 42375
17372 2021-01-11 Alameda 1 94605: Oakland 1850   -122.148748 37.760229 42375
18708 2021-01-10 Alameda 1 94605: Oakland 1806   -122.148748 37.760229 42375
19962 2021-01-09 Alameda 1 94605: Oakland 1806   -122.148748 37.760229 42375
21281 2021-01-08 Alameda 1 94605: Oakland 1747   -122.148748 37.760229 42375
22621 2021-01-07 Alameda 1 94605: Oakland 1729   -122.148748 37.760229 42375
23956 2021-01-06 Alameda 1 94605: Oakland 1729   -122.148748 37.760229 42375
25286 2021-01-05 Alameda 1 94605: Oakland 1663   -122.148748 37.760229 42375
26627 2021-01-04 Alameda 1 94605: Oakland 1663   -122.148748 37.760229 42375
27957 2021-01-03 Alameda 1 94605: Oakland 1645   -122.148748 37.760229 42375
29254 2021-01-02 Alameda 1 94605: Oakland 1625   -122.148748 37.760229 42375
30551 2021-01-01 Alameda 1 94605: Oakland 1625   -122.148748 37.760229 42375
31841 2020-12-31 Alameda 1 94605: Oakland 1597   -122.148748 37.760229 42375
33151 2020-12-30 Alameda 1 94605: Oakland 1562   -122.148748 37.760229 42375
34461 2020-12-29 Alameda 1 94605: Oakland 1562   -122.148748 37.760229 42375
35766 2020-12-28 Alameda 1 94605: Oakland 1557   -122.148748 37.760229 42375
37017 2020-12-27 Alameda 1 94605: Oakland 1540   -122.148748 37.760229 42375
38235 2020-12-26 Alameda 1 94605: Oakland 1524   -122.148748 37.760229 42375
39457 2020-12-25 Alameda 1 94605: Oakland 1463   -122.148748 37.760229 42375
40266 2020-12-24 Alameda 1 94605: Oakland 1463   -122.148748 37.760229 42375
41487 2020-12-23 Alameda 1 94605: Oakland 1442   -122.148748 37.760229 42375
42788 2020-12-22 Alameda 1 94605: Oakland 1396   -122.148748 37.760229 42375
44011 2020-12-21 Alameda 1 94605: Oakland 1396   -122.148748 37.760229 42375
45328 2020-12-20 Alameda 1 94605: Oakland 1378   -122.148748 37.760229 42375
46504 2020-12-19 Alameda 1 94605: Oakland 1313   -122.148748 37.760229 42375
47683 2020-12-18 Alameda 1 94605: Oakland 1313   -122.148748 37.760229 42375
48988 2020-12-17 Alameda 1 94605: Oakland 1313   -122.148748 37.760229 42375
50271 2020-12-16 Alameda 1 94605: Oakland 1293   -122.148748 37.760229 42375
51552 2020-12-15 Alameda 1 94605: Oakland 1270   -122.148748 37.760229 42375
52843 2020-12-14 Alameda 1 94605: Oakland 1249   -122.148748 37.760229 42375
54138 2020-12-13 Alameda 1 94605: Oakland 1187   -122.148748 37.760229 42375
55300 2020-12-12 Alameda 1 94605: Oakland 1187   -122.148748 37.760229 42375
56495 2020-12-11 Alameda 1 94605: Oakland 1176   -122.148748 37.760229 42375
57796 2020-12-10 Alameda 1 94605: Oakland 1147   -122.148748 37.760229 42375
59055 2020-12-09 Alameda 1 94605: Oakland 1139   -122.148748 37.760229 42375
60276 2020-12-08 Alameda 1 94605: Oakland 1113   -122.148748 37.760229 42375
61516 2020-12-07 Alameda 1 94605: Oakland 1079   -122.148748 37.760229 42375
62813 2020-12-06 Alameda 1 94605: Oakland 1056   -122.148748 37.760229 42375
63919 2020-12-05 Alameda 1 94605: Oakland 1056   -122.148748 37.760229 42375
65008 2020-12-04 Alameda 1 94605: Oakland 1035   -122.148748 37.760229 42375
66210 2020-12-03 Alameda 1 94605: Oakland 1020   -122.148748 37.760229 42375
67384 2020-12-02 Alameda 1 94605: Oakland 1003   -122.148748 37.760229 42375
68527 2020-12-01 Alameda 1 94605: Oakland 998   -122.148748 37.760229 42375
69741 2020-11-30 Alameda 1 94605: Oakland 998   -122.148748 37.760229 42375
70923 2020-11-29 Alameda 1 94605: Oakland 988   -122.148748 37.760229 42375
71888 2020-11-28 Alameda 1 94605: Oakland 976   -122.148748 37.760229 42375
72894 2020-11-27 Alameda 1 94605: Oakland 945   -122.148748 37.760229 42375
73765 2020-11-26 Alameda 1 94605: Oakland 945   -122.148748 37.760229 42375
74483 2020-11-25 Alameda 1 94605: Oakland 935   -122.148748 37.760229 42375
75600 2020-11-24 Alameda 1 94605: Oakland 935   -122.148748 37.760229 42375
76786 2020-11-23 Alameda 1 94605: Oakland 925   -122.148748 37.760229 42375
77804 2020-11-22 Alameda 1 94605: Oakland 913   -122.148748 37.760229 42375
78678 2020-11-21 Alameda 1 94605: Oakland 912   -122.148748 37.760229 42375
79487 2020-11-20 Alameda 1 94605: Oakland 912   -122.148748 37.760229 42375
80695 2020-11-19 Alameda 1 94605: Oakland 906   -122.148748 37.760229 42375
81837 2020-11-18 Alameda 1 94605: Oakland 896   -122.148748 37.760229 42375
83026 2020-11-17 Alameda 1 94605: Oakland 896   -122.148748 37.760229 42375
84206 2020-11-16 Alameda 1 94605: Oakland 878   -122.148748 37.760229 42375
85385 2020-11-15 Alameda 1 94605: Oakland 877   -122.148748 37.760229 42375
86083 2020-11-14 Alameda 1 94605: Oakland 874   -122.148748 37.760229 42375
86980 2020-11-13 Alameda 1 94605: Oakland 866   -122.148748 37.760229 42375
88102 2020-11-12 Alameda 1 94605: Oakland 870   -122.148748 37.760229 42375
89265 2020-11-11 Alameda 1 94605: Oakland 862   -122.148748 37.760229 42375
90184 2020-11-10 Alameda 1 94605: Oakland 856   -122.148748 37.760229 42375
91365 2020-11-09 Alameda 1 94605: Oakland 854   -122.148748 37.760229 42375
92507 2020-11-08 Alameda 1 94605: Oakland 847   -122.148748 37.760229 42375
93372 2020-11-07 Alameda 1 94605: Oakland 843   -122.148748 37.760229 42375
94230 2020-11-06 Alameda 1 94605: Oakland 836   -122.148748 37.760229 42375
95426 2020-11-05 Alameda 1 94605: Oakland 830   -122.148748 37.760229 42375
96566 2020-11-04 Alameda 1 94605: Oakland 828   -122.148748 37.760229 42375
97744 2020-11-03 Alameda 1 94605: Oakland 824   -122.148748 37.760229 42375
98905 2020-11-02 Alameda 1 94605: Oakland 822   -122.148748 37.760229 42375
100024 2020-11-01 Alameda 1 94605: Oakland 821   -122.148748 37.760229 42375
100871 2020-10-31 Alameda 1 94605: Oakland 816   -122.148748 37.760229 42375
101742 2020-10-30 Alameda 1 94605: Oakland 806   -122.148748 37.760229 42375
102918 2020-10-29 Alameda 1 94605: Oakland 797   -122.148748 37.760229 42375
104097 2020-10-28 Alameda 1 94605: Oakland 795   -122.148748 37.760229 42375
105229 2020-10-27 Alameda 1 94605: Oakland 789   -122.148748 37.760229 42375
106322 2020-10-26 Alameda 1 94605: Oakland 789   -122.148748 37.760229 42375
107462 2020-10-25 Alameda 1 94605: Oakland 788   -122.148748 37.760229 42375
108341 2020-10-24 Alameda 1 94605: Oakland 787   -122.148748 37.760229 42375
109179 2020-10-23 Alameda 1 94605: Oakland 782   -122.148748 37.760229 42375
110351 2020-10-22 Alameda 1 94605: Oakland 782   -122.148748 37.760229 42375
111494 2020-10-21 Alameda 1 94605: Oakland 780   -122.148748 37.760229 42375
112631 2020-10-20 Alameda 1 94605: Oakland 776   -122.148748 37.760229 42375
113799 2020-10-19 Alameda 1 94605: Oakland 772   -122.148748 37.760229 42375
114949 2020-10-18 Alameda 1 94605: Oakland 770   -122.148748 37.760229 42375
115817 2020-10-17 Alameda 1 94605: Oakland 770   -122.148748 37.760229 42375

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
);