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

263 rows where place = "94501: Alameda" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 94501: Alameda · 263

fips

  • 1 263

county

Link rowid date ▲ county fips place confirmed_cases note x y population
1 2020-11-30 Alameda 1 94501: Alameda 568   -122.274583 37.774606 62826
1202 2020-11-29 Alameda 1 94501: Alameda 562   -122.274583 37.774606 62826
2143 2020-11-28 Alameda 1 94501: Alameda 556   -122.274583 37.774606 62826
3160 2020-11-27 Alameda 1 94501: Alameda 536   -122.274583 37.774606 62826
4050 2020-11-26 Alameda 1 94501: Alameda 536   -122.274583 37.774606 62826
4808 2020-11-25 Alameda 1 94501: Alameda 529   -122.274583 37.774606 62826
5945 2020-11-24 Alameda 1 94501: Alameda 529   -122.274583 37.774606 62826
7150 2020-11-23 Alameda 1 94501: Alameda 524   -122.274583 37.774606 62826
8134 2020-11-22 Alameda 1 94501: Alameda 517   -122.274583 37.774606 62826
8984 2020-11-21 Alameda 1 94501: Alameda 509   -122.274583 37.774606 62826
9793 2020-11-20 Alameda 1 94501: Alameda 509   -122.274583 37.774606 62826
10988 2020-11-19 Alameda 1 94501: Alameda 503   -122.274583 37.774606 62826
12145 2020-11-18 Alameda 1 94501: Alameda 492   -122.274583 37.774606 62826
13289 2020-11-17 Alameda 1 94501: Alameda 492   -122.274583 37.774606 62826
14487 2020-11-16 Alameda 1 94501: Alameda 476   -122.274583 37.774606 62826
15649 2020-11-15 Alameda 1 94501: Alameda 470   -122.274583 37.774606 62826
16351 2020-11-14 Alameda 1 94501: Alameda 468   -122.274583 37.774606 62826
17224 2020-11-13 Alameda 1 94501: Alameda 463   -122.274583 37.774606 62826
18335 2020-11-12 Alameda 1 94501: Alameda 465   -122.274583 37.774606 62826
19504 2020-11-11 Alameda 1 94501: Alameda 462   -122.274583 37.774606 62826
20391 2020-11-10 Alameda 1 94501: Alameda 454   -122.274583 37.774606 62826
21578 2020-11-09 Alameda 1 94501: Alameda 451   -122.274583 37.774606 62826
22693 2020-11-08 Alameda 1 94501: Alameda 446   -122.274583 37.774606 62826
23525 2020-11-07 Alameda 1 94501: Alameda 446   -122.274583 37.774606 62826
24350 2020-11-06 Alameda 1 94501: Alameda 439   -122.274583 37.774606 62826
25555 2020-11-05 Alameda 1 94501: Alameda 436   -122.274583 37.774606 62826
26675 2020-11-04 Alameda 1 94501: Alameda 433   -122.274583 37.774606 62826
27860 2020-11-03 Alameda 1 94501: Alameda 431   -122.274583 37.774606 62826
29035 2020-11-02 Alameda 1 94501: Alameda 430   -122.274583 37.774606 62826
30129 2020-11-01 Alameda 1 94501: Alameda 425   -122.274583 37.774606 62826
30918 2020-10-31 Alameda 1 94501: Alameda 424   -122.274583 37.774606 62826
31727 2020-10-30 Alameda 1 94501: Alameda 418   -122.274583 37.774606 62826
32911 2020-10-29 Alameda 1 94501: Alameda 415   -122.274583 37.774606 62826
34067 2020-10-28 Alameda 1 94501: Alameda 413   -122.274583 37.774606 62826
35176 2020-10-27 Alameda 1 94501: Alameda 407   -122.274583 37.774606 62826
36303 2020-10-26 Alameda 1 94501: Alameda 403   -122.274583 37.774606 62826
37394 2020-10-25 Alameda 1 94501: Alameda 401   -122.274583 37.774606 62826
38242 2020-10-24 Alameda 1 94501: Alameda 399   -122.274583 37.774606 62826
39046 2020-10-23 Alameda 1 94501: Alameda 398   -122.274583 37.774606 62826
40230 2020-10-22 Alameda 1 94501: Alameda 397   -122.274583 37.774606 62826
41349 2020-10-21 Alameda 1 94501: Alameda 396   -122.274583 37.774606 62826
42459 2020-10-20 Alameda 1 94501: Alameda 396   -122.274583 37.774606 62826
43633 2020-10-19 Alameda 1 94501: Alameda 396   -122.274583 37.774606 62826
44733 2020-10-18 Alameda 1 94501: Alameda 395   -122.274583 37.774606 62826
45569 2020-10-17 Alameda 1 94501: Alameda 395   -122.274583 37.774606 62826
46453 2020-10-16 Alameda 1 94501: Alameda 390   -122.274583 37.774606 62826
47625 2020-10-15 Alameda 1 94501: Alameda 389   -122.274583 37.774606 62826
48750 2020-10-14 Alameda 1 94501: Alameda 388   -122.274583 37.774606 62826
49879 2020-10-13 Alameda 1 94501: Alameda 387   -122.274583 37.774606 62826
50953 2020-10-12 Alameda 1 94501: Alameda 387   -122.274583 37.774606 62826
51978 2020-10-11 Alameda 1 94501: Alameda 387   -122.274583 37.774606 62826
52807 2020-10-10 Alameda 1 94501: Alameda 385   -122.274583 37.774606 62826
53682 2020-10-09 Alameda 1 94501: Alameda 383   -122.274583 37.774606 62826
54855 2020-10-08 Alameda 1 94501: Alameda 383   -122.274583 37.774606 62826
55969 2020-10-07 Alameda 1 94501: Alameda 379   -122.274583 37.774606 62826
57090 2020-10-06 Alameda 1 94501: Alameda 378   -122.274583 37.774606 62826
58180 2020-10-05 Alameda 1 94501: Alameda 378   -122.274583 37.774606 62826
59243 2020-10-04 Alameda 1 94501: Alameda 377   -122.274583 37.774606 62826
60086 2020-10-03 Alameda 1 94501: Alameda 374   -122.274583 37.774606 62826
60934 2020-10-02 Alameda 1 94501: Alameda 374   -122.274583 37.774606 62826
62127 2020-10-01 Alameda 1 94501: Alameda 370   -122.274583 37.774606 62826
63200 2020-09-30 Alameda 1 94501: Alameda 369   -122.274583 37.774606 62826
64316 2020-09-29 Alameda 1 94501: Alameda 368   -122.274583 37.774606 62826
65440 2020-09-28 Alameda 1 94501: Alameda 368   -122.274583 37.774606 62826
66549 2020-09-27 Alameda 1 94501: Alameda 360   -122.274583 37.774606 62826
67356 2020-09-26 Alameda 1 94501: Alameda 360   -122.274583 37.774606 62826
68219 2020-09-25 Alameda 1 94501: Alameda 357   -122.274583 37.774606 62826
69403 2020-09-24 Alameda 1 94501: Alameda 354   -122.274583 37.774606 62826
70525 2020-09-23 Alameda 1 94501: Alameda 353   -122.274583 37.774606 62826
71631 2020-09-22 Alameda 1 94501: Alameda 352   -122.274583 37.774606 62826
72682 2020-09-21 Alameda 1 94501: Alameda 350   -122.274583 37.774606 62826
73712 2020-09-20 Alameda 1 94501: Alameda 350   -122.274583 37.774606 62826
74549 2020-09-19 Alameda 1 94501: Alameda 349   -122.274583 37.774606 62826
75413 2020-09-18 Alameda 1 94501: Alameda 345   -122.274583 37.774606 62826
76585 2020-09-17 Alameda 1 94501: Alameda 341   -122.274583 37.774606 62826
77695 2020-09-16 Alameda 1 94501: Alameda 339   -122.274583 37.774606 62826
78742 2020-09-15 Alameda 1 94501: Alameda 338   -122.274583 37.774606 62826
79899 2020-09-14 Alameda 1 94501: Alameda 333   -122.274583 37.774606 62826
81020 2020-09-13 Alameda 1 94501: Alameda 333   -122.274583 37.774606 62826
81859 2020-09-12 Alameda 1 94501: Alameda 331   -122.274583 37.774606 62826
82732 2020-09-11 Alameda 1 94501: Alameda 330   -122.274583 37.774606 62826
83919 2020-09-10 Alameda 1 94501: Alameda 327   -122.274583 37.774606 62826
84976 2020-09-09 Alameda 1 94501: Alameda 325   -122.274583 37.774606 62826
86115 2020-09-08 Alameda 1 94501: Alameda 321   -122.274583 37.774606 62826
87210 2020-09-07 Alameda 1 94501: Alameda 319   -122.274583 37.774606 62826
88028 2020-09-06 Alameda 1 94501: Alameda 315   -122.274583 37.774606 62826
88841 2020-09-05 Alameda 1 94501: Alameda 313   -122.274583 37.774606 62826
89699 2020-09-04 Alameda 1 94501: Alameda 307   -122.274583 37.774606 62826
90885 2020-09-03 Alameda 1 94501: Alameda 305   -122.274583 37.774606 62826
91948 2020-09-02 Alameda 1 94501: Alameda 303   -122.274583 37.774606 62826
93040 2020-09-01 Alameda 1 94501: Alameda 300   -122.274583 37.774606 62826
94194 2020-08-31 Alameda 1 94501: Alameda 296   -122.274583 37.774606 62826
95279 2020-08-30 Alameda 1 94501: Alameda 295   -122.274583 37.774606 62826
96090 2020-08-29 Alameda 1 94501: Alameda 292   -122.274583 37.774606 62826
97222 2020-08-28 Alameda 1 94501: Alameda 290   -122.274583 37.774606 62826
97902 2020-08-27 Alameda 1 94501: Alameda 286   -122.274583 37.774606 62826
98965 2020-08-26 Alameda 1 94501: Alameda 282   -122.274583 37.774606 62826
100041 2020-08-25 Alameda 1 94501: Alameda 279   -122.274583 37.774606 62826
101110 2020-08-24 Alameda 1 94501: Alameda 274   -122.274583 37.774606 62826
102198 2020-08-23 Alameda 1 94501: Alameda 274   -122.274583 37.774606 62826

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