latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
50 rows where agency = "Pasadena" and did_not_update = "TRUE" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
266 | 266 | Pasadena | Los Angeles | 37 | 2021-08-29 | 12671 | 354 | TRUE |
327 | 327 | Pasadena | Los Angeles | 37 | 2021-08-28 | 12671 | 354 | TRUE |
693 | 693 | Pasadena | Los Angeles | 37 | 2021-08-22 | 12488 | 354 | TRUE |
754 | 754 | Pasadena | Los Angeles | 37 | 2021-08-21 | 12488 | 354 | TRUE |
1120 | 1120 | Pasadena | Los Angeles | 37 | 2021-08-15 | 12272 | 354 | TRUE |
1181 | 1181 | Pasadena | Los Angeles | 37 | 2021-08-14 | 12272 | 354 | TRUE |
1547 | 1547 | Pasadena | Los Angeles | 37 | 2021-08-08 | 12077 | 353 | TRUE |
1608 | 1608 | Pasadena | Los Angeles | 37 | 2021-08-07 | 12077 | 353 | TRUE |
1974 | 1974 | Pasadena | Los Angeles | 37 | 2021-08-01 | 11877 | 352 | TRUE |
2035 | 2035 | Pasadena | Los Angeles | 37 | 2021-07-31 | 11877 | 352 | TRUE |
2401 | 2401 | Pasadena | Los Angeles | 37 | 2021-07-25 | 11650 | 351 | TRUE |
2462 | 2462 | Pasadena | Los Angeles | 37 | 2021-07-24 | 11650 | 351 | TRUE |
2828 | 2828 | Pasadena | Los Angeles | 37 | 2021-07-18 | 11507 | 351 | TRUE |
2889 | 2889 | Pasadena | Los Angeles | 37 | 2021-07-17 | 11507 | 351 | TRUE |
3255 | 3255 | Pasadena | Los Angeles | 37 | 2021-07-11 | 11425 | 350 | TRUE |
3316 | 3316 | Pasadena | Los Angeles | 37 | 2021-07-10 | 11425 | 350 | TRUE |
4109 | 4109 | Pasadena | Los Angeles | 37 | 2021-06-27 | 11328 | 349 | TRUE |
4170 | 4170 | Pasadena | Los Angeles | 37 | 2021-06-26 | 11328 | 349 | TRUE |
4597 | 4597 | Pasadena | Los Angeles | 37 | 2021-06-19 | 11317 | 349 | TRUE |
4963 | 4963 | Pasadena | Los Angeles | 37 | 2021-06-13 | 11307 | 349 | TRUE |
5024 | 5024 | Pasadena | Los Angeles | 37 | 2021-06-12 | 11307 | 349 | TRUE |
5390 | 5390 | Pasadena | Los Angeles | 37 | 2021-06-06 | 11297 | 349 | TRUE |
5451 | 5451 | Pasadena | Los Angeles | 37 | 2021-06-05 | 11297 | 349 | TRUE |
5756 | 5756 | Pasadena | Los Angeles | 37 | 2021-05-31 | 11290 | 347 | TRUE |
5878 | 5878 | Pasadena | Los Angeles | 37 | 2021-05-29 | 11290 | 347 | TRUE |
6244 | 6244 | Pasadena | Los Angeles | 37 | 2021-05-23 | 11280 | 346 | TRUE |
6305 | 6305 | Pasadena | Los Angeles | 37 | 2021-05-22 | 11280 | 346 | TRUE |
6671 | 6671 | Pasadena | Los Angeles | 37 | 2021-05-16 | 11268 | 346 | TRUE |
6732 | 6732 | Pasadena | Los Angeles | 37 | 2021-05-15 | 11268 | 346 | TRUE |
7159 | 7159 | Pasadena | Los Angeles | 37 | 2021-05-08 | 11252 | 346 | TRUE |
7342 | 7342 | Pasadena | Los Angeles | 37 | 2021-05-05 | 11241 | 346 | TRUE |
7586 | 7586 | Pasadena | Los Angeles | 37 | 2021-05-01 | 11224 | 346 | TRUE |
7952 | 7952 | Pasadena | Los Angeles | 37 | 2021-04-25 | 11205 | 340 | TRUE |
8013 | 8013 | Pasadena | Los Angeles | 37 | 2021-04-24 | 11205 | 340 | TRUE |
8379 | 8379 | Pasadena | Los Angeles | 37 | 2021-04-18 | 11190 | 340 | TRUE |
8806 | 8806 | Pasadena | Los Angeles | 37 | 2021-04-11 | 11169 | 339 | TRUE |
8867 | 8867 | Pasadena | Los Angeles | 37 | 2021-04-10 | 11169 | 339 | TRUE |
9233 | 9233 | Pasadena | Los Angeles | 37 | 2021-04-04 | 11151 | 335 | TRUE |
9294 | 9294 | Pasadena | Los Angeles | 37 | 2021-04-03 | 11151 | 335 | TRUE |
9721 | 9721 | Pasadena | Los Angeles | 37 | 2021-03-27 | 11128 | 335 | TRUE |
10087 | 10087 | Pasadena | Los Angeles | 37 | 2021-03-21 | 11080 | 330 | TRUE |
10941 | 10941 | Pasadena | Los Angeles | 37 | 2021-03-07 | 10983 | 320 | TRUE |
14906 | 14906 | Pasadena | Los Angeles | 37 | 2021-01-01 | 6879 | 167 | TRUE |
15333 | 15333 | Pasadena | Los Angeles | 37 | 2020-12-25 | 5892 | 150 | TRUE |
15394 | 15394 | Pasadena | Los Angeles | 37 | 2020-12-24 | 5892 | 150 | TRUE |
17041 | 17041 | Pasadena | Los Angeles | 37 | 2020-11-27 | 3492 | 132 | TRUE |
17102 | 17102 | Pasadena | Los Angeles | 37 | 2020-11-26 | 3492 | 132 | TRUE |
19908 | 19908 | Pasadena | Los Angeles | 37 | 2020-10-11 | 2652 | 129 | TRUE |
21616 | 21616 | Pasadena | Los Angeles | 37 | 2020-09-13 | 2476 | 120 | TRUE |
32192 | 32192 | Pasadena | Los Angeles | 37 | 2020-03-18 | 2 | 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 );