latimes_agency_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_agency_totals

559 rows where agency = "Berkeley" sorted by date descending

✎ View and edit SQL

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

Suggested facets: did_not_update, date (date)

fips 1

  • 1 559

county 1

agency 1

  • Berkeley · 559 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
2 2 Berkeley Alameda 1 2021-09-02 4592 53  
63 63 Berkeley Alameda 1 2021-09-01 4565 53  
124 124 Berkeley Alameda 1 2021-08-31 4517 53 TRUE
185 185 Berkeley Alameda 1 2021-08-30 4517 53  
246 246 Berkeley Alameda 1 2021-08-29 4501 53  
307 307 Berkeley Alameda 1 2021-08-28 4482 53  
368 368 Berkeley Alameda 1 2021-08-27 4450 53  
429 429 Berkeley Alameda 1 2021-08-26 4416 53  
490 490 Berkeley Alameda 1 2021-08-25 4378 53  
551 551 Berkeley Alameda 1 2021-08-24 4360 53  
612 612 Berkeley Alameda 1 2021-08-23 4348 52  
673 673 Berkeley Alameda 1 2021-08-22 4333 52  
734 734 Berkeley Alameda 1 2021-08-21 4318 52  
795 795 Berkeley Alameda 1 2021-08-20 4300 52  
856 856 Berkeley Alameda 1 2021-08-19 4275 52  
917 917 Berkeley Alameda 1 2021-08-18 4252 52  
978 978 Berkeley Alameda 1 2021-08-17 4238 52  
1039 1039 Berkeley Alameda 1 2021-08-16 4223 51  
1100 1100 Berkeley Alameda 1 2021-08-15 4202 51  
1161 1161 Berkeley Alameda 1 2021-08-14 4202 51  
1222 1222 Berkeley Alameda 1 2021-08-13 4185 51  
1283 1283 Berkeley Alameda 1 2021-08-12 4168 51  
1344 1344 Berkeley Alameda 1 2021-08-11 4156 51  
1405 1405 Berkeley Alameda 1 2021-08-10 4138 51  
1466 1466 Berkeley Alameda 1 2021-08-09 4123 50  
1527 1527 Berkeley Alameda 1 2021-08-08 4108 50  
1588 1588 Berkeley Alameda 1 2021-08-07 4098 50  
1649 1649 Berkeley Alameda 1 2021-08-06 4083 50  
1710 1710 Berkeley Alameda 1 2021-08-05 4061 50  
1771 1771 Berkeley Alameda 1 2021-08-04 4037 50  
1832 1832 Berkeley Alameda 1 2021-08-03 4009 50  
1893 1893 Berkeley Alameda 1 2021-08-02 4004 50  
1954 1954 Berkeley Alameda 1 2021-08-01 3963 50  
2015 2015 Berkeley Alameda 1 2021-07-31 3937 50 TRUE
2076 2076 Berkeley Alameda 1 2021-07-30 3937 50  
2137 2137 Berkeley Alameda 1 2021-07-29 3937 50  
2198 2198 Berkeley Alameda 1 2021-07-28 3923 50  
2259 2259 Berkeley Alameda 1 2021-07-27 3910 50  
2320 2320 Berkeley Alameda 1 2021-07-26 3896 50  
2381 2381 Berkeley Alameda 1 2021-07-25 3889 50  
2442 2442 Berkeley Alameda 1 2021-07-24 3872 50  
2503 2503 Berkeley Alameda 1 2021-07-23 3850 50  
2564 2564 Berkeley Alameda 1 2021-07-22 3824 50  
2625 2625 Berkeley Alameda 1 2021-07-21 3813 50  
2686 2686 Berkeley Alameda 1 2021-07-20 3793 50  
2747 2747 Berkeley Alameda 1 2021-07-19 3778 50  
2808 2808 Berkeley Alameda 1 2021-07-18 3775 50  
2869 2869 Berkeley Alameda 1 2021-07-17 3764 50  
2930 2930 Berkeley Alameda 1 2021-07-16 3752 50  
2991 2991 Berkeley Alameda 1 2021-07-15 3730 50  
3052 3052 Berkeley Alameda 1 2021-07-14 3730 50  
3113 3113 Berkeley Alameda 1 2021-07-13 3722 50  
3174 3174 Berkeley Alameda 1 2021-07-12 3716 50  
3235 3235 Berkeley Alameda 1 2021-07-11 3708 50  
3296 3296 Berkeley Alameda 1 2021-07-10 3691 50  
3357 3357 Berkeley Alameda 1 2021-07-09 3689 50  
3418 3418 Berkeley Alameda 1 2021-07-08 3689 50  
3479 3479 Berkeley Alameda 1 2021-07-07 3683 50  
3540 3540 Berkeley Alameda 1 2021-07-06 3683 50  
3601 3601 Berkeley Alameda 1 2021-07-05 3681 50 TRUE
3662 3662 Berkeley Alameda 1 2021-07-04 3681 50 TRUE
3723 3723 Berkeley Alameda 1 2021-07-03 3681 50  
3784 3784 Berkeley Alameda 1 2021-07-02 3676 50  
3845 3845 Berkeley Alameda 1 2021-07-01 3673 50  
3906 3906 Berkeley Alameda 1 2021-06-30 3668 50  
3967 3967 Berkeley Alameda 1 2021-06-29 3668 50  
4028 4028 Berkeley Alameda 1 2021-06-28 3671 50 TRUE
4089 4089 Berkeley Alameda 1 2021-06-27 3671 50  
4150 4150 Berkeley Alameda 1 2021-06-26 3664 50  
4211 4211 Berkeley Alameda 1 2021-06-25 3664 50  
4272 4272 Berkeley Alameda 1 2021-06-24 3664 50  
4333 4333 Berkeley Alameda 1 2021-06-23 3664 50  
4394 4394 Berkeley Alameda 1 2021-06-22 3663 50  
4455 4455 Berkeley Alameda 1 2021-06-21 3658 50  
4516 4516 Berkeley Alameda 1 2021-06-20 3646 46 TRUE
4577 4577 Berkeley Alameda 1 2021-06-19 3646 46 TRUE
4638 4638 Berkeley Alameda 1 2021-06-18 3646 46  
4699 4699 Berkeley Alameda 1 2021-06-17 3642 46  
4760 4760 Berkeley Alameda 1 2021-06-16 3636 46  
4821 4821 Berkeley Alameda 1 2021-06-15 3634 46  
4882 4882 Berkeley Alameda 1 2021-06-14 3634 46  
4943 4943 Berkeley Alameda 1 2021-06-13 3633 46  
5004 5004 Berkeley Alameda 1 2021-06-12 3632 46  
5065 5065 Berkeley Alameda 1 2021-06-11 3631 46 TRUE
5126 5126 Berkeley Alameda 1 2021-06-10 3631 46  
5187 5187 Berkeley Alameda 1 2021-06-09 3628 46  
5248 5248 Berkeley Alameda 1 2021-06-08 3626 46  
5309 5309 Berkeley Alameda 1 2021-06-07 3625 46  
5370 5370 Berkeley Alameda 1 2021-06-06 3623 46  
5431 5431 Berkeley Alameda 1 2021-06-05 3623 46  
5492 5492 Berkeley Alameda 1 2021-06-04 3622 46  
5553 5553 Berkeley Alameda 1 2021-06-03 3623 46  
5614 5614 Berkeley Alameda 1 2021-06-02 3620 46  
5675 5675 Berkeley Alameda 1 2021-06-01 3620 46  
5736 5736 Berkeley Alameda 1 2021-05-31 3620 46  
5797 5797 Berkeley Alameda 1 2021-05-30 3620 46  
5858 5858 Berkeley Alameda 1 2021-05-29 3620 46 TRUE
5919 5919 Berkeley Alameda 1 2021-05-28 3620 46  
5980 5980 Berkeley Alameda 1 2021-05-27 3618 46  
6041 6041 Berkeley Alameda 1 2021-05-26 3618 46  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);