latimes_place_totals

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

32,224 rows where county = "Alameda" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

  • 1 32,224

county

  • Alameda · 32,224 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1 1 94501 94501: Alameda 2021-10-27 Alameda 1 3148   62826
2 2 94502 94502: Alameda 2021-10-27 Alameda 1 385   14117
3 3 94505 94505: Discovery Bay 2021-10-27 Alameda 1 2   16382
4 4 94514 94514: Byron 2021-10-27 Alameda 1 1   1461
5 5 94536 94536: Fremont 2021-10-27 Alameda 1 3692   72976
6 6 94538 94538: Fremont 2021-10-27 Alameda 1 3912   63911
7 7 94539 94539: Fremont 2021-10-27 Alameda 1 1568   52960
8 8 94541 94541: Hayward 2021-10-27 Alameda 1 7765   65132
9 9 94542 94542: Hayward 2021-10-27 Alameda 1 975   13973
10 10 94544 94544: Hayward 2021-10-27 Alameda 1 9329   77121
11 11 94545 94545: Hayward 2021-10-27 Alameda 1 2998   31657
12 12 94546 94546: Castro Valley 2021-10-27 Alameda 1 2723   45536
13 13 94550 94550: Livermore 2021-10-27 Alameda 1 3348   50138
14 14 94551 94551: Livermore 2021-10-27 Alameda 1 3251   38986
15 15 94552 94552: Castro Valley 2021-10-27 Alameda 1 580   15204
16 16 94555 94555: Fremont 2021-10-27 Alameda 1 1330   36037
17 17 94560 94560: Newark 2021-10-27 Alameda 1 3500   44245
18 18 94566 94566: Pleasanton 2021-10-27 Alameda 1 2024   45046
19 19 94568 94568: Dublin 2021-10-27 Alameda 1 3454   58399
20 20 94577 94577: San Leandro 2021-10-27 Alameda 1 3903   48666
21 21 94578 94578: San Leandro 2021-10-27 Alameda 1 4031   40150
22 22 94579 94579: San Leandro 2021-10-27 Alameda 1 1596   20237
23 23 94580 94580: San Lorenzo 2021-10-27 Alameda 1 2646   28970
24 24 94586 94586: Sunol 2021-10-27 Alameda 1 46   797
25 25 94587 94587: Union City 2021-10-27 Alameda 1 5053   72446
26 26 94588 94588: Pleasanton 2021-10-27 Alameda 1 1390   31895
27 27 94601 94601: Oakland 2021-10-27 Alameda 1 7249   53261
28 28 94602 94602: Oakland 2021-10-27 Alameda 1 1718   29770
29 29 94603 94603: Oakland 2021-10-27 Alameda 1 5500   33241
30 30 94605 94605: Oakland 2021-10-27 Alameda 1 4077   42375
31 31 94606 94606: Oakland 2021-10-27 Alameda 1 2984   37076
32 32 94607 94607: Oakland 2021-10-27 Alameda 1 2231   26646
33 33 94608 94608: Emeryville 2021-10-27 Alameda 1 1863   31000
34 34 94609 94609: Oakland 2021-10-27 Alameda 1 1492   22293
35 35 94610 94610: Oakland 2021-10-27 Alameda 1 1214   30862
36 36 94611 94611: Oakland 2021-10-27 Alameda 1 1346   37826
37 37 94612 94612: Oakland 2021-10-27 Alameda 1 1114   17279
38 38 94613 94613: Oakland 2021-10-27 Alameda 1 4   212
39 39 94618 94618: Oakland 2021-10-27 Alameda 1 422   15545
40 40 94619 94619: Oakland 2021-10-27 Alameda 1 1680   24080
41 41 94621 94621: Oakland 2021-10-27 Alameda 1 5310   32915
42 42 94702 94702: Berkeley 2021-10-27 Alameda 1 821   16520
43 43 94703 94703: Berkeley 2021-10-27 Alameda 1 896   19805
44 44 94704 94704: Berkeley 2021-10-27 Alameda 1 1211   29129
45 45 94705 94705: Berkeley 2021-10-27 Alameda 1 435   13152
46 46 94706 94706: Albany 2021-10-27 Alameda 1 528   19921
47 47 94707 94707: Berkeley 2021-10-27 Alameda 1 209   12862
48 48 94708 94708: Berkeley 2021-10-27 Alameda 1 170   11725
49 49 94709 94709: Berkeley 2021-10-27 Alameda 1 256   11796
50 50 94710 94710: Berkeley 2021-10-27 Alameda 1 738   8059
51 51 94720 94720: Berkeley 2021-10-27 Alameda 1 242   1336
52 52 95377 95377: Tracy 2021-10-27 Alameda 1 1   32091
53 53 95391 95391: Mountain House 2021-10-27 Alameda 1 1   20131
1366 1366 94501 94501: Alameda 2021-10-26 Alameda 1 3148   62826
1367 1367 94502 94502: Alameda 2021-10-26 Alameda 1 385   14117
1368 1368 94505 94505: Discovery Bay 2021-10-26 Alameda 1 2   16382
1369 1369 94514 94514: Byron 2021-10-26 Alameda 1 1   1461
1370 1370 94536 94536: Fremont 2021-10-26 Alameda 1 3692   72976
1371 1371 94538 94538: Fremont 2021-10-26 Alameda 1 3912   63911
1372 1372 94539 94539: Fremont 2021-10-26 Alameda 1 1568   52960
1373 1373 94541 94541: Hayward 2021-10-26 Alameda 1 7765   65132
1374 1374 94542 94542: Hayward 2021-10-26 Alameda 1 975   13973
1375 1375 94544 94544: Hayward 2021-10-26 Alameda 1 9329   77121
1376 1376 94545 94545: Hayward 2021-10-26 Alameda 1 2998   31657
1377 1377 94546 94546: Castro Valley 2021-10-26 Alameda 1 2723   45536
1378 1378 94550 94550: Livermore 2021-10-26 Alameda 1 3348   50138
1379 1379 94551 94551: Livermore 2021-10-26 Alameda 1 3251   38986
1380 1380 94552 94552: Castro Valley 2021-10-26 Alameda 1 580   15204
1381 1381 94555 94555: Fremont 2021-10-26 Alameda 1 1330   36037
1382 1382 94560 94560: Newark 2021-10-26 Alameda 1 3500   44245
1383 1383 94566 94566: Pleasanton 2021-10-26 Alameda 1 2024   45046
1384 1384 94568 94568: Dublin 2021-10-26 Alameda 1 3454   58399
1385 1385 94577 94577: San Leandro 2021-10-26 Alameda 1 3903   48666
1386 1386 94578 94578: San Leandro 2021-10-26 Alameda 1 4031   40150
1387 1387 94579 94579: San Leandro 2021-10-26 Alameda 1 1596   20237
1388 1388 94580 94580: San Lorenzo 2021-10-26 Alameda 1 2646   28970
1389 1389 94586 94586: Sunol 2021-10-26 Alameda 1 46   797
1390 1390 94587 94587: Union City 2021-10-26 Alameda 1 5053   72446
1391 1391 94588 94588: Pleasanton 2021-10-26 Alameda 1 1390   31895
1392 1392 94601 94601: Oakland 2021-10-26 Alameda 1 7249   53261
1393 1393 94602 94602: Oakland 2021-10-26 Alameda 1 1718   29770
1394 1394 94603 94603: Oakland 2021-10-26 Alameda 1 5500   33241
1395 1395 94605 94605: Oakland 2021-10-26 Alameda 1 4077   42375
1396 1396 94606 94606: Oakland 2021-10-26 Alameda 1 2984   37076
1397 1397 94607 94607: Oakland 2021-10-26 Alameda 1 2231   26646
1398 1398 94608 94608: Emeryville 2021-10-26 Alameda 1 1863   31000
1399 1399 94609 94609: Oakland 2021-10-26 Alameda 1 1492   22293
1400 1400 94610 94610: Oakland 2021-10-26 Alameda 1 1214   30862
1401 1401 94611 94611: Oakland 2021-10-26 Alameda 1 1346   37826
1402 1402 94612 94612: Oakland 2021-10-26 Alameda 1 1114   17279
1403 1403 94613 94613: Oakland 2021-10-26 Alameda 1 4   212
1404 1404 94618 94618: Oakland 2021-10-26 Alameda 1 422   15545
1405 1405 94619 94619: Oakland 2021-10-26 Alameda 1 1680   24080
1406 1406 94621 94621: Oakland 2021-10-26 Alameda 1 5310   32915
1407 1407 94702 94702: Berkeley 2021-10-26 Alameda 1 821   16520
1408 1408 94703 94703: Berkeley 2021-10-26 Alameda 1 896   19805
1409 1409 94704 94704: Berkeley 2021-10-26 Alameda 1 1211   29129
1410 1410 94705 94705: Berkeley 2021-10-26 Alameda 1 435   13152
1411 1411 94706 94706: Albany 2021-10-26 Alameda 1 528   19921
1412 1412 94707 94707: Berkeley 2021-10-26 Alameda 1 209   12862

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