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

53 rows where county = "Alameda" and "date" is on date 2021-02-07 sorted by date descending

✎ View and edit SQL

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

fips 1

  • 1 53

county 1

  • Alameda · 53 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
873552 873552 94501 94501: Alameda 2021-02-07 Alameda 1 1866   62826
873553 873553 94502 94502: Alameda 2021-02-07 Alameda 1 216   14117
873554 873554 94505 94505: Discovery Bay 2021-02-07 Alameda 1 1   16382
873555 873555 94514 94514: Byron 2021-02-07 Alameda 1 0   1461
873556 873556 94536 94536: Fremont 2021-02-07 Alameda 1 2443   72976
873557 873557 94538 94538: Fremont 2021-02-07 Alameda 1 2490   63911
873558 873558 94539 94539: Fremont 2021-02-07 Alameda 1 874   52960
873559 873559 94541 94541: Hayward 2021-02-07 Alameda 1 5392   65132
873560 873560 94542 94542: Hayward 2021-02-07 Alameda 1 630   13973
873561 873561 94544 94544: Hayward 2021-02-07 Alameda 1 6625   77121
873562 873562 94545 94545: Hayward 2021-02-07 Alameda 1 2099   31657
873563 873563 94546 94546: Castro Valley 2021-02-07 Alameda 1 1591   45536
873564 873564 94550 94550: Livermore 2021-02-07 Alameda 1 1932   50138
873565 873565 94551 94551: Livermore 2021-02-07 Alameda 1 1981   38986
873566 873566 94552 94552: Castro Valley 2021-02-07 Alameda 1 327   15204
873567 873567 94555 94555: Fremont 2021-02-07 Alameda 1 848   36037
873568 873568 94560 94560: Newark 2021-02-07 Alameda 1 2480   44245
873569 873569 94566 94566: Pleasanton 2021-02-07 Alameda 1 1203   45046
873570 873570 94568 94568: Dublin 2021-02-07 Alameda 1 2102   58399
873571 873571 94577 94577: San Leandro 2021-02-07 Alameda 1 2505   48666
873572 873572 94578 94578: San Leandro 2021-02-07 Alameda 1 2655   40150
873573 873573 94579 94579: San Leandro 2021-02-07 Alameda 1 990   20237
873574 873574 94580 94580: San Lorenzo 2021-02-07 Alameda 1 1830   28970
873575 873575 94586 94586: Sunol 2021-02-07 Alameda 1 30   797
873576 873576 94587 94587: Union City 2021-02-07 Alameda 1 3536   72446
873577 873577 94588 94588: Pleasanton 2021-02-07 Alameda 1 778   31895
873578 873578 94601 94601: Oakland 2021-02-07 Alameda 1 5193   53261
873579 873579 94602 94602: Oakland 2021-02-07 Alameda 1 1072   29770
873580 873580 94603 94603: Oakland 2021-02-07 Alameda 1 3916   33241
873581 873581 94605 94605: Oakland 2021-02-07 Alameda 1 2314   42375
873582 873582 94606 94606: Oakland 2021-02-07 Alameda 1 1899   37076
873583 873583 94607 94607: Oakland 2021-02-07 Alameda 1 1110   26646
873584 873584 94608 94608: Emeryville 2021-02-07 Alameda 1 946   31000
873585 873585 94609 94609: Oakland 2021-02-07 Alameda 1 880   22293
873586 873586 94610 94610: Oakland 2021-02-07 Alameda 1 628   30862
873587 873587 94611 94611: Oakland 2021-02-07 Alameda 1 751   37826
873588 873588 94612 94612: Oakland 2021-02-07 Alameda 1 474   17279
873589 873589 94613 94613: Oakland 2021-02-07 Alameda 1 2   212
873590 873590 94618 94618: Oakland 2021-02-07 Alameda 1 209   15545
873591 873591 94619 94619: Oakland 2021-02-07 Alameda 1 991   24080
873592 873592 94621 94621: Oakland 2021-02-07 Alameda 1 3678   32915
873593 873593 94702 94702: Berkeley 2021-02-07 Alameda 1 456   16520
873594 873594 94703 94703: Berkeley 2021-02-07 Alameda 1 501   19805
873595 873595 94704 94704: Berkeley 2021-02-07 Alameda 1 691   29129
873596 873596 94705 94705: Berkeley 2021-02-07 Alameda 1 275   13152
873597 873597 94706 94706: Albany 2021-02-07 Alameda 1 303   19921
873598 873598 94707 94707: Berkeley 2021-02-07 Alameda 1 125   12862
873599 873599 94708 94708: Berkeley 2021-02-07 Alameda 1 78   11725
873600 873600 94709 94709: Berkeley 2021-02-07 Alameda 1 126   11796
873601 873601 94710 94710: Berkeley 2021-02-07 Alameda 1 524   8059
873602 873602 94720 94720: Berkeley 2021-02-07 Alameda 1 109   1336
873603 873603 95377 95377: Tracy 2021-02-07 Alameda 1 1   32091
873604 873604 95391 95391: Mountain House 2021-02-07 Alameda 1 1   20131

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