latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "Calaveras" 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 |
---|---|---|---|---|---|---|---|---|
18977 | 18977 | Calaveras | Calaveras | 9 | 2020-10-26 | 342 | 18 | TRUE |
19038 | 19038 | Calaveras | Calaveras | 9 | 2020-10-25 | 342 | 18 | TRUE |
19099 | 19099 | Calaveras | Calaveras | 9 | 2020-10-24 | 342 | 18 | TRUE |
19160 | 19160 | Calaveras | Calaveras | 9 | 2020-10-23 | 342 | 18 | |
19221 | 19221 | Calaveras | Calaveras | 9 | 2020-10-22 | 339 | 17 | TRUE |
19282 | 19282 | Calaveras | Calaveras | 9 | 2020-10-21 | 339 | 17 | TRUE |
19343 | 19343 | Calaveras | Calaveras | 9 | 2020-10-20 | 339 | 17 | |
19404 | 19404 | Calaveras | Calaveras | 9 | 2020-10-19 | 333 | 17 | TRUE |
19465 | 19465 | Calaveras | Calaveras | 9 | 2020-10-18 | 333 | 17 | TRUE |
19526 | 19526 | Calaveras | Calaveras | 9 | 2020-10-17 | 333 | 17 | TRUE |
19587 | 19587 | Calaveras | Calaveras | 9 | 2020-10-16 | 333 | 17 | |
19648 | 19648 | Calaveras | Calaveras | 9 | 2020-10-15 | 331 | 16 | TRUE |
19709 | 19709 | Calaveras | Calaveras | 9 | 2020-10-14 | 331 | 16 | TRUE |
19770 | 19770 | Calaveras | Calaveras | 9 | 2020-10-13 | 331 | 16 | |
19831 | 19831 | Calaveras | Calaveras | 9 | 2020-10-12 | 330 | 16 | TRUE |
19892 | 19892 | Calaveras | Calaveras | 9 | 2020-10-11 | 330 | 16 | TRUE |
19953 | 19953 | Calaveras | Calaveras | 9 | 2020-10-10 | 330 | 16 | TRUE |
20014 | 20014 | Calaveras | Calaveras | 9 | 2020-10-09 | 330 | 16 | |
20075 | 20075 | Calaveras | Calaveras | 9 | 2020-10-08 | 329 | 14 | TRUE |
20136 | 20136 | Calaveras | Calaveras | 9 | 2020-10-07 | 329 | 14 | TRUE |
20197 | 20197 | Calaveras | Calaveras | 9 | 2020-10-06 | 329 | 14 | |
20258 | 20258 | Calaveras | Calaveras | 9 | 2020-10-05 | 324 | 14 | TRUE |
20319 | 20319 | Calaveras | Calaveras | 9 | 2020-10-04 | 324 | 14 | TRUE |
20380 | 20380 | Calaveras | Calaveras | 9 | 2020-10-03 | 324 | 14 | TRUE |
20441 | 20441 | Calaveras | Calaveras | 9 | 2020-10-02 | 324 | 14 | |
20502 | 20502 | Calaveras | Calaveras | 9 | 2020-10-01 | 322 | 14 | TRUE |
20563 | 20563 | Calaveras | Calaveras | 9 | 2020-09-30 | 322 | 14 | TRUE |
20624 | 20624 | Calaveras | Calaveras | 9 | 2020-09-29 | 322 | 14 | |
20685 | 20685 | Calaveras | Calaveras | 9 | 2020-09-28 | 317 | 14 | TRUE |
20746 | 20746 | Calaveras | Calaveras | 9 | 2020-09-27 | 317 | 14 | TRUE |
20807 | 20807 | Calaveras | Calaveras | 9 | 2020-09-26 | 317 | 14 | TRUE |
20868 | 20868 | Calaveras | Calaveras | 9 | 2020-09-25 | 317 | 14 | |
20929 | 20929 | Calaveras | Calaveras | 9 | 2020-09-24 | 314 | 14 | |
20990 | 20990 | Calaveras | Calaveras | 9 | 2020-09-23 | 314 | 14 | TRUE |
21051 | 21051 | Calaveras | Calaveras | 9 | 2020-09-22 | 314 | 14 | |
21112 | 21112 | Calaveras | Calaveras | 9 | 2020-09-21 | 311 | 14 | TRUE |
21173 | 21173 | Calaveras | Calaveras | 9 | 2020-09-20 | 311 | 14 | TRUE |
21234 | 21234 | Calaveras | Calaveras | 9 | 2020-09-19 | 311 | 14 | TRUE |
21295 | 21295 | Calaveras | Calaveras | 9 | 2020-09-18 | 311 | 14 | |
21356 | 21356 | Calaveras | Calaveras | 9 | 2020-09-17 | 305 | 13 | TRUE |
21417 | 21417 | Calaveras | Calaveras | 9 | 2020-09-16 | 305 | 13 | TRUE |
21478 | 21478 | Calaveras | Calaveras | 9 | 2020-09-15 | 305 | 13 | |
21539 | 21539 | Calaveras | Calaveras | 9 | 2020-09-14 | 298 | 10 | TRUE |
21600 | 21600 | Calaveras | Calaveras | 9 | 2020-09-13 | 298 | 10 | TRUE |
21661 | 21661 | Calaveras | Calaveras | 9 | 2020-09-12 | 298 | 10 | TRUE |
21722 | 21722 | Calaveras | Calaveras | 9 | 2020-09-11 | 298 | 10 | |
21783 | 21783 | Calaveras | Calaveras | 9 | 2020-09-10 | 286 | 2 | TRUE |
21844 | 21844 | Calaveras | Calaveras | 9 | 2020-09-09 | 286 | 2 | TRUE |
21905 | 21905 | Calaveras | Calaveras | 9 | 2020-09-08 | 286 | 2 | |
21966 | 21966 | Calaveras | Calaveras | 9 | 2020-09-07 | 273 | 2 | TRUE |
22027 | 22027 | Calaveras | Calaveras | 9 | 2020-09-06 | 273 | 2 | TRUE |
22088 | 22088 | Calaveras | Calaveras | 9 | 2020-09-05 | 273 | 2 | TRUE |
22149 | 22149 | Calaveras | Calaveras | 9 | 2020-09-04 | 273 | 2 | |
22210 | 22210 | Calaveras | Calaveras | 9 | 2020-09-03 | 257 | 2 | TRUE |
22271 | 22271 | Calaveras | Calaveras | 9 | 2020-09-02 | 257 | 2 | TRUE |
22332 | 22332 | Calaveras | Calaveras | 9 | 2020-09-01 | 257 | 2 | |
22393 | 22393 | Calaveras | Calaveras | 9 | 2020-08-31 | 236 | 2 | TRUE |
22454 | 22454 | Calaveras | Calaveras | 9 | 2020-08-30 | 236 | 2 | TRUE |
22515 | 22515 | Calaveras | Calaveras | 9 | 2020-08-29 | 236 | 2 | TRUE |
22576 | 22576 | Calaveras | Calaveras | 9 | 2020-08-28 | 236 | 2 | |
22637 | 22637 | Calaveras | Calaveras | 9 | 2020-08-27 | 223 | 2 | TRUE |
22698 | 22698 | Calaveras | Calaveras | 9 | 2020-08-26 | 223 | 2 | TRUE |
22759 | 22759 | Calaveras | Calaveras | 9 | 2020-08-25 | 223 | 2 | |
22820 | 22820 | Calaveras | Calaveras | 9 | 2020-08-24 | 197 | 2 | TRUE |
22881 | 22881 | Calaveras | Calaveras | 9 | 2020-08-23 | 197 | 2 | TRUE |
22942 | 22942 | Calaveras | Calaveras | 9 | 2020-08-22 | 197 | 2 | TRUE |
23003 | 23003 | Calaveras | Calaveras | 9 | 2020-08-21 | 197 | 2 | |
23064 | 23064 | Calaveras | Calaveras | 9 | 2020-08-20 | 181 | 1 | TRUE |
23125 | 23125 | Calaveras | Calaveras | 9 | 2020-08-19 | 181 | 1 | TRUE |
23186 | 23186 | Calaveras | Calaveras | 9 | 2020-08-18 | 181 | 1 | |
23247 | 23247 | Calaveras | Calaveras | 9 | 2020-08-17 | 174 | 1 | TRUE |
23308 | 23308 | Calaveras | Calaveras | 9 | 2020-08-16 | 174 | 1 | TRUE |
23369 | 23369 | Calaveras | Calaveras | 9 | 2020-08-15 | 174 | 1 | TRUE |
23430 | 23430 | Calaveras | Calaveras | 9 | 2020-08-14 | 174 | 1 | |
23491 | 23491 | Calaveras | Calaveras | 9 | 2020-08-13 | 161 | 1 | TRUE |
23552 | 23552 | Calaveras | Calaveras | 9 | 2020-08-12 | 161 | 1 | TRUE |
23613 | 23613 | Calaveras | Calaveras | 9 | 2020-08-11 | 161 | 1 | |
23674 | 23674 | Calaveras | Calaveras | 9 | 2020-08-10 | 147 | 1 | TRUE |
23735 | 23735 | Calaveras | Calaveras | 9 | 2020-08-09 | 147 | 1 | TRUE |
23796 | 23796 | Calaveras | Calaveras | 9 | 2020-08-08 | 147 | 1 | TRUE |
23857 | 23857 | Calaveras | Calaveras | 9 | 2020-08-07 | 147 | 1 | |
23918 | 23918 | Calaveras | Calaveras | 9 | 2020-08-06 | 136 | 1 | TRUE |
23979 | 23979 | Calaveras | Calaveras | 9 | 2020-08-05 | 136 | 1 | TRUE |
24040 | 24040 | Calaveras | Calaveras | 9 | 2020-08-04 | 136 | 1 | |
24101 | 24101 | Calaveras | Calaveras | 9 | 2020-08-03 | 125 | 1 | TRUE |
24162 | 24162 | Calaveras | Calaveras | 9 | 2020-08-02 | 125 | 1 | TRUE |
24223 | 24223 | Calaveras | Calaveras | 9 | 2020-08-01 | 125 | 1 | TRUE |
24284 | 24284 | Calaveras | Calaveras | 9 | 2020-07-31 | 125 | 1 | |
24345 | 24345 | Calaveras | Calaveras | 9 | 2020-07-30 | 108 | 1 | TRUE |
24406 | 24406 | Calaveras | Calaveras | 9 | 2020-07-29 | 108 | 1 | TRUE |
24467 | 24467 | Calaveras | Calaveras | 9 | 2020-07-28 | 108 | 1 | |
24528 | 24528 | Calaveras | Calaveras | 9 | 2020-07-27 | 99 | 1 | TRUE |
24589 | 24589 | Calaveras | Calaveras | 9 | 2020-07-26 | 99 | 1 | TRUE |
24650 | 24650 | Calaveras | Calaveras | 9 | 2020-07-25 | 99 | 1 | TRUE |
24711 | 24711 | Calaveras | Calaveras | 9 | 2020-07-24 | 99 | 1 | |
24772 | 24772 | Calaveras | Calaveras | 9 | 2020-07-23 | 94 | 1 | |
24833 | 24833 | Calaveras | Calaveras | 9 | 2020-07-22 | 94 | 1 | TRUE |
24894 | 24894 | Calaveras | Calaveras | 9 | 2020-07-21 | 94 | 1 | |
24955 | 24955 | Calaveras | Calaveras | 9 | 2020-07-20 | 87 | 0 | TRUE |
25016 | 25016 | Calaveras | Calaveras | 9 | 2020-07-19 | 87 | 0 | TRUE |
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 );