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

21,216 rows where county = "Alameda" sorted by date descending

View and edit SQL

fips

  • 1 21,216

county

  • Alameda · 21,216
Link rowid id name date ▲ county fips confirmed_cases note population
1 94501 94501: Alameda 2021-04-10 Alameda 1 2054   62826
2 94502 94502: Alameda 2021-04-10 Alameda 1 235   14117
3 94505 94505: Discovery Bay 2021-04-10 Alameda 1 1   16382
4 94536 94536: Fremont 2021-04-10 Alameda 1 2716   72976
5 94538 94538: Fremont 2021-04-10 Alameda 1 2778   63911
6 94539 94539: Fremont 2021-04-10 Alameda 1 1069   52960
7 94541 94541: Hayward 2021-04-10 Alameda 1 5917   65132
8 94542 94542: Hayward 2021-04-10 Alameda 1 692   13973
9 94544 94544: Hayward 2021-04-10 Alameda 1 7269   77121
10 94545 94545: Hayward 2021-04-10 Alameda 1 2274   31657
11 94546 94546: Castro Valley 2021-04-10 Alameda 1 1775   45536
12 94550 94550: Livermore 2021-04-10 Alameda 1 2082   50138
13 94551 94551: Livermore 2021-04-10 Alameda 1 2134   38986
14 94552 94552: Castro Valley 2021-04-10 Alameda 1 390   15204
15 94555 94555: Fremont 2021-04-10 Alameda 1 936   36037
16 94560 94560: Newark 2021-04-10 Alameda 1 2662   44245
17 94566 94566: Pleasanton 2021-04-10 Alameda 1 1318   45046
18 94568 94568: Dublin 2021-04-10 Alameda 1 2299   58399
19 94577 94577: San Leandro 2021-04-10 Alameda 1 2846   48666
20 94578 94578: San Leandro 2021-04-10 Alameda 1 2913   40150
21 94579 94579: San Leandro 2021-04-10 Alameda 1 1087   20237
22 94580 94580: San Lorenzo 2021-04-10 Alameda 1 1952   28970
23 94586 94586: Sunol 2021-04-10 Alameda 1 33   797
24 94587 94587: Union City 2021-04-10 Alameda 1 3851   72446
25 94588 94588: Pleasanton 2021-04-10 Alameda 1 884   31895
26 94601 94601: Oakland 2021-04-10 Alameda 1 5641   53261
27 94602 94602: Oakland 2021-04-10 Alameda 1 1194   29770
28 94603 94603: Oakland 2021-04-10 Alameda 1 4232   33241
29 94605 94605: Oakland 2021-04-10 Alameda 1 2560   42375
30 94606 94606: Oakland 2021-04-10 Alameda 1 2112   37076
31 94607 94607: Oakland 2021-04-10 Alameda 1 1284   26646
32 94608 94608: Emeryville 2021-04-10 Alameda 1 1081   31000
33 94609 94609: Oakland 2021-04-10 Alameda 1 952   22293
34 94610 94610: Oakland 2021-04-10 Alameda 1 710   30862
35 94611 94611: Oakland 2021-04-10 Alameda 1 860   37826
36 94612 94612: Oakland 2021-04-10 Alameda 1 609   17279
37 94613 94613: Oakland 2021-04-10 Alameda 1 2   212
38 94618 94618: Oakland 2021-04-10 Alameda 1 249   15545
39 94619 94619: Oakland 2021-04-10 Alameda 1 1086   24080
40 94621 94621: Oakland 2021-04-10 Alameda 1 4015   32915
41 94702 94702: Berkeley 2021-04-10 Alameda 1 520   16520
42 94703 94703: Berkeley 2021-04-10 Alameda 1 566   19805
43 94704 94704: Berkeley 2021-04-10 Alameda 1 917   29129
44 94705 94705: Berkeley 2021-04-10 Alameda 1 306   13152
45 94706 94706: Albany 2021-04-10 Alameda 1 345   19921
46 94707 94707: Berkeley 2021-04-10 Alameda 1 137   12862
47 94708 94708: Berkeley 2021-04-10 Alameda 1 90   11725
48 94709 94709: Berkeley 2021-04-10 Alameda 1 155   11796
49 94710 94710: Berkeley 2021-04-10 Alameda 1 553   8059
50 94720 94720: Berkeley 2021-04-10 Alameda 1 194   1336
51 95377 95377: Tracy 2021-04-10 Alameda 1 1   32091
52 95391 95391: Mountain House 2021-04-10 Alameda 1 1   20131
1368 94501 94501: Alameda 2021-04-09 Alameda 1 2054   62826
1369 94502 94502: Alameda 2021-04-09 Alameda 1 235   14117
1370 94505 94505: Discovery Bay 2021-04-09 Alameda 1 1   16382
1371 94536 94536: Fremont 2021-04-09 Alameda 1 2716   72976
1372 94538 94538: Fremont 2021-04-09 Alameda 1 2778   63911
1373 94539 94539: Fremont 2021-04-09 Alameda 1 1069   52960
1374 94541 94541: Hayward 2021-04-09 Alameda 1 5917   65132
1375 94542 94542: Hayward 2021-04-09 Alameda 1 692   13973
1376 94544 94544: Hayward 2021-04-09 Alameda 1 7269   77121
1377 94545 94545: Hayward 2021-04-09 Alameda 1 2274   31657
1378 94546 94546: Castro Valley 2021-04-09 Alameda 1 1775   45536
1379 94550 94550: Livermore 2021-04-09 Alameda 1 2082   50138
1380 94551 94551: Livermore 2021-04-09 Alameda 1 2134   38986
1381 94552 94552: Castro Valley 2021-04-09 Alameda 1 390   15204
1382 94555 94555: Fremont 2021-04-09 Alameda 1 936   36037
1383 94560 94560: Newark 2021-04-09 Alameda 1 2662   44245
1384 94566 94566: Pleasanton 2021-04-09 Alameda 1 1318   45046
1385 94568 94568: Dublin 2021-04-09 Alameda 1 2299   58399
1386 94577 94577: San Leandro 2021-04-09 Alameda 1 2846   48666
1387 94578 94578: San Leandro 2021-04-09 Alameda 1 2913   40150
1388 94579 94579: San Leandro 2021-04-09 Alameda 1 1087   20237
1389 94580 94580: San Lorenzo 2021-04-09 Alameda 1 1952   28970
1390 94586 94586: Sunol 2021-04-09 Alameda 1 33   797
1391 94587 94587: Union City 2021-04-09 Alameda 1 3851   72446
1392 94588 94588: Pleasanton 2021-04-09 Alameda 1 884   31895
1393 94601 94601: Oakland 2021-04-09 Alameda 1 5641   53261
1394 94602 94602: Oakland 2021-04-09 Alameda 1 1194   29770
1395 94603 94603: Oakland 2021-04-09 Alameda 1 4232   33241
1396 94605 94605: Oakland 2021-04-09 Alameda 1 2560   42375
1397 94606 94606: Oakland 2021-04-09 Alameda 1 2112   37076
1398 94607 94607: Oakland 2021-04-09 Alameda 1 1284   26646
1399 94608 94608: Emeryville 2021-04-09 Alameda 1 1081   31000
1400 94609 94609: Oakland 2021-04-09 Alameda 1 952   22293
1401 94610 94610: Oakland 2021-04-09 Alameda 1 710   30862
1402 94611 94611: Oakland 2021-04-09 Alameda 1 860   37826
1403 94612 94612: Oakland 2021-04-09 Alameda 1 609   17279
1404 94613 94613: Oakland 2021-04-09 Alameda 1 2   212
1405 94618 94618: Oakland 2021-04-09 Alameda 1 249   15545
1406 94619 94619: Oakland 2021-04-09 Alameda 1 1086   24080
1407 94621 94621: Oakland 2021-04-09 Alameda 1 4015   32915
1408 94702 94702: Berkeley 2021-04-09 Alameda 1 520   16520
1409 94703 94703: Berkeley 2021-04-09 Alameda 1 566   19805
1410 94704 94704: Berkeley 2021-04-09 Alameda 1 917   29129
1411 94705 94705: Berkeley 2021-04-09 Alameda 1 306   13152
1412 94706 94706: Albany 2021-04-09 Alameda 1 345   19921
1413 94707 94707: Berkeley 2021-04-09 Alameda 1 137   12862
1414 94708 94708: Berkeley 2021-04-09 Alameda 1 90   11725
1415 94709 94709: Berkeley 2021-04-09 Alameda 1 155   11796

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);