latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
1,118 rows where county = "Alameda" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
3051 | 3051 | Alameda | Alameda | 1 | 2021-07-14 | 88013 | 1220 | |
3052 | 3052 | Berkeley | Alameda | 1 | 2021-07-14 | 3730 | 50 | |
3112 | 3112 | Alameda | Alameda | 1 | 2021-07-13 | 87824 | 1220 | |
3113 | 3113 | Berkeley | Alameda | 1 | 2021-07-13 | 3722 | 50 | |
3173 | 3173 | Alameda | Alameda | 1 | 2021-07-12 | 87481 | 1220 | |
3174 | 3174 | Berkeley | Alameda | 1 | 2021-07-12 | 3716 | 50 | |
3234 | 3234 | Alameda | Alameda | 1 | 2021-07-11 | 87452 | 1220 | |
3235 | 3235 | Berkeley | Alameda | 1 | 2021-07-11 | 3708 | 50 | |
3295 | 3295 | Alameda | Alameda | 1 | 2021-07-10 | 87325 | 1218 | |
3296 | 3296 | Berkeley | Alameda | 1 | 2021-07-10 | 3691 | 50 | |
3356 | 3356 | Alameda | Alameda | 1 | 2021-07-09 | 87072 | 1218 | |
3357 | 3357 | Berkeley | Alameda | 1 | 2021-07-09 | 3689 | 50 | |
3417 | 3417 | Alameda | Alameda | 1 | 2021-07-08 | 87072 | 1217 | |
3418 | 3418 | Berkeley | Alameda | 1 | 2021-07-08 | 3689 | 50 | |
3478 | 3478 | Alameda | Alameda | 1 | 2021-07-07 | 86800 | 1217 | |
3479 | 3479 | Berkeley | Alameda | 1 | 2021-07-07 | 3683 | 50 | |
3539 | 3539 | Alameda | Alameda | 1 | 2021-07-06 | 86700 | 1217 | |
3540 | 3540 | Berkeley | Alameda | 1 | 2021-07-06 | 3683 | 50 | |
3600 | 3600 | Alameda | Alameda | 1 | 2021-07-05 | 86694 | 1217 | TRUE |
3601 | 3601 | Berkeley | Alameda | 1 | 2021-07-05 | 3681 | 50 | TRUE |
3661 | 3661 | Alameda | Alameda | 1 | 2021-07-04 | 86694 | 1217 | TRUE |
3662 | 3662 | Berkeley | Alameda | 1 | 2021-07-04 | 3681 | 50 | TRUE |
3722 | 3722 | Alameda | Alameda | 1 | 2021-07-03 | 86694 | 1217 | |
3723 | 3723 | Berkeley | Alameda | 1 | 2021-07-03 | 3681 | 50 | |
3783 | 3783 | Alameda | Alameda | 1 | 2021-07-02 | 86694 | 1217 | |
3784 | 3784 | Berkeley | Alameda | 1 | 2021-07-02 | 3676 | 50 | |
3844 | 3844 | Alameda | Alameda | 1 | 2021-07-01 | 86608 | 1217 | TRUE |
3845 | 3845 | Berkeley | Alameda | 1 | 2021-07-01 | 3673 | 50 | |
3905 | 3905 | Alameda | Alameda | 1 | 2021-06-30 | 86608 | 1217 | |
3906 | 3906 | Berkeley | Alameda | 1 | 2021-06-30 | 3668 | 50 | |
3966 | 3966 | Alameda | Alameda | 1 | 2021-06-29 | 86543 | 1217 | |
3967 | 3967 | Berkeley | Alameda | 1 | 2021-06-29 | 3668 | 50 | |
4027 | 4027 | Alameda | Alameda | 1 | 2021-06-28 | 86494 | 1217 | |
4028 | 4028 | Berkeley | Alameda | 1 | 2021-06-28 | 3671 | 50 | TRUE |
4088 | 4088 | Alameda | Alameda | 1 | 2021-06-27 | 86432 | 1217 | |
4089 | 4089 | Berkeley | Alameda | 1 | 2021-06-27 | 3671 | 50 | |
4149 | 4149 | Alameda | Alameda | 1 | 2021-06-26 | 86426 | 1217 | |
4150 | 4150 | Berkeley | Alameda | 1 | 2021-06-26 | 3664 | 50 | |
4210 | 4210 | Alameda | Alameda | 1 | 2021-06-25 | 86272 | 1217 | |
4211 | 4211 | Berkeley | Alameda | 1 | 2021-06-25 | 3664 | 50 | |
4271 | 4271 | Alameda | Alameda | 1 | 2021-06-24 | 86226 | 1217 | |
4272 | 4272 | Berkeley | Alameda | 1 | 2021-06-24 | 3664 | 50 | |
4332 | 4332 | Alameda | Alameda | 1 | 2021-06-23 | 86153 | 1217 | |
4333 | 4333 | Berkeley | Alameda | 1 | 2021-06-23 | 3664 | 50 | |
4393 | 4393 | Alameda | Alameda | 1 | 2021-06-22 | 86093 | 1217 | |
4394 | 4394 | Berkeley | Alameda | 1 | 2021-06-22 | 3663 | 50 | |
4454 | 4454 | Alameda | Alameda | 1 | 2021-06-21 | 85991 | 1217 | |
4455 | 4455 | Berkeley | Alameda | 1 | 2021-06-21 | 3658 | 50 | |
4515 | 4515 | Alameda | Alameda | 1 | 2021-06-20 | 85946 | 1217 | TRUE |
4516 | 4516 | Berkeley | Alameda | 1 | 2021-06-20 | 3646 | 46 | TRUE |
4576 | 4576 | Alameda | Alameda | 1 | 2021-06-19 | 85946 | 1217 | TRUE |
4577 | 4577 | Berkeley | Alameda | 1 | 2021-06-19 | 3646 | 46 | TRUE |
4637 | 4637 | Alameda | Alameda | 1 | 2021-06-18 | 85946 | 1217 | |
4638 | 4638 | Berkeley | Alameda | 1 | 2021-06-18 | 3646 | 46 | |
4698 | 4698 | Alameda | Alameda | 1 | 2021-06-17 | 85920 | 1217 | |
4699 | 4699 | Berkeley | Alameda | 1 | 2021-06-17 | 3642 | 46 | |
4759 | 4759 | Alameda | Alameda | 1 | 2021-06-16 | 85899 | 1217 | |
4760 | 4760 | Berkeley | Alameda | 1 | 2021-06-16 | 3636 | 46 | |
4820 | 4820 | Alameda | Alameda | 1 | 2021-06-15 | 85865 | 1217 | |
4821 | 4821 | Berkeley | Alameda | 1 | 2021-06-15 | 3634 | 46 | |
4881 | 4881 | Alameda | Alameda | 1 | 2021-06-14 | 85814 | 1217 | |
4882 | 4882 | Berkeley | Alameda | 1 | 2021-06-14 | 3634 | 46 | |
4942 | 4942 | Alameda | Alameda | 1 | 2021-06-13 | 85754 | 1217 | |
4943 | 4943 | Berkeley | Alameda | 1 | 2021-06-13 | 3633 | 46 | |
5003 | 5003 | Alameda | Alameda | 1 | 2021-06-12 | 85707 | 1217 | TRUE |
5004 | 5004 | Berkeley | Alameda | 1 | 2021-06-12 | 3632 | 46 | |
5064 | 5064 | Alameda | Alameda | 1 | 2021-06-11 | 85707 | 1217 | |
5065 | 5065 | Berkeley | Alameda | 1 | 2021-06-11 | 3631 | 46 | TRUE |
5125 | 5125 | Alameda | Alameda | 1 | 2021-06-10 | 85673 | 1217 | |
5126 | 5126 | Berkeley | Alameda | 1 | 2021-06-10 | 3631 | 46 | |
5186 | 5186 | Alameda | Alameda | 1 | 2021-06-09 | 85575 | 1217 | TRUE |
5187 | 5187 | Berkeley | Alameda | 1 | 2021-06-09 | 3628 | 46 | |
5247 | 5247 | Alameda | Alameda | 1 | 2021-06-08 | 85575 | 1217 | |
5248 | 5248 | Berkeley | Alameda | 1 | 2021-06-08 | 3626 | 46 | |
5308 | 5308 | Alameda | Alameda | 1 | 2021-06-07 | 85522 | 1217 | |
5309 | 5309 | Berkeley | Alameda | 1 | 2021-06-07 | 3625 | 46 | |
5369 | 5369 | Alameda | Alameda | 1 | 2021-06-06 | 85518 | 1217 | |
5370 | 5370 | Berkeley | Alameda | 1 | 2021-06-06 | 3623 | 46 | |
5430 | 5430 | Alameda | Alameda | 1 | 2021-06-05 | 85506 | 1217 | |
5431 | 5431 | Berkeley | Alameda | 1 | 2021-06-05 | 3623 | 46 | |
5491 | 5491 | Alameda | Alameda | 1 | 2021-06-04 | 85469 | 1217 | |
5492 | 5492 | Berkeley | Alameda | 1 | 2021-06-04 | 3622 | 46 | |
5552 | 5552 | Alameda | Alameda | 1 | 2021-06-03 | 85402 | 1217 | |
5553 | 5553 | Berkeley | Alameda | 1 | 2021-06-03 | 3623 | 46 | |
5613 | 5613 | Alameda | Alameda | 1 | 2021-06-02 | 85350 | 1217 | |
5614 | 5614 | Berkeley | Alameda | 1 | 2021-06-02 | 3620 | 46 | |
5674 | 5674 | Alameda | Alameda | 1 | 2021-06-01 | 85335 | 1217 | |
5675 | 5675 | Berkeley | Alameda | 1 | 2021-06-01 | 3620 | 46 | |
5735 | 5735 | Alameda | Alameda | 1 | 2021-05-31 | 85309 | 1217 | |
5736 | 5736 | Berkeley | Alameda | 1 | 2021-05-31 | 3620 | 46 | |
5796 | 5796 | Alameda | Alameda | 1 | 2021-05-30 | 85300 | 1217 | |
5797 | 5797 | Berkeley | Alameda | 1 | 2021-05-30 | 3620 | 46 | |
5857 | 5857 | Alameda | Alameda | 1 | 2021-05-29 | 85272 | 1217 | TRUE |
5858 | 5858 | Berkeley | Alameda | 1 | 2021-05-29 | 3620 | 46 | TRUE |
5918 | 5918 | Alameda | Alameda | 1 | 2021-05-28 | 85217 | 1217 | |
5919 | 5919 | Berkeley | Alameda | 1 | 2021-05-28 | 3620 | 46 | |
5979 | 5979 | Alameda | Alameda | 1 | 2021-05-27 | 85155 | 1217 | |
5980 | 5980 | Berkeley | Alameda | 1 | 2021-05-27 | 3618 | 46 | |
6040 | 6040 | Alameda | Alameda | 1 | 2021-05-26 | 85089 | 1217 | |
6041 | 6041 | Berkeley | Alameda | 1 | 2021-05-26 | 3618 | 46 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );