latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
1,686 rows where fips = 37 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▼ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
33003 | 33003 | Long Beach | Los Angeles | 37 | 2020-01-26 | 0 | 0 | |
33004 | 33004 | Los Angeles | Los Angeles | 37 | 2020-01-26 | 1 | 0 | |
32995 | 32995 | Los Angeles | Los Angeles | 37 | 2020-01-27 | 1 | 0 | |
32992 | 32992 | Los Angeles | Los Angeles | 37 | 2020-01-28 | 1 | 0 | |
32989 | 32989 | Los Angeles | Los Angeles | 37 | 2020-01-29 | 1 | 0 | |
32986 | 32986 | Los Angeles | Los Angeles | 37 | 2020-01-30 | 1 | 0 | |
32967 | 32967 | Long Beach | Los Angeles | 37 | 2020-01-31 | 0 | 0 | |
32968 | 32968 | Los Angeles | Los Angeles | 37 | 2020-01-31 | 1 | 0 | |
32959 | 32959 | Los Angeles | Los Angeles | 37 | 2020-02-01 | 1 | 0 | |
32940 | 32940 | Long Beach | Los Angeles | 37 | 2020-02-02 | 0 | 0 | |
32941 | 32941 | Los Angeles | Los Angeles | 37 | 2020-02-02 | 1 | 0 | |
32931 | 32931 | Los Angeles | Los Angeles | 37 | 2020-02-03 | 1 | 0 | |
32927 | 32927 | Los Angeles | Los Angeles | 37 | 2020-02-04 | 1 | 0 | |
32923 | 32923 | Los Angeles | Los Angeles | 37 | 2020-02-05 | 1 | 0 | |
32919 | 32919 | Los Angeles | Los Angeles | 37 | 2020-02-06 | 1 | 0 | |
32915 | 32915 | Los Angeles | Los Angeles | 37 | 2020-02-07 | 1 | 0 | |
32911 | 32911 | Los Angeles | Los Angeles | 37 | 2020-02-08 | 1 | 0 | |
32907 | 32907 | Los Angeles | Los Angeles | 37 | 2020-02-09 | 1 | 0 | |
32903 | 32903 | Los Angeles | Los Angeles | 37 | 2020-02-10 | 1 | 0 | |
32899 | 32899 | Los Angeles | Los Angeles | 37 | 2020-02-11 | 1 | 0 | |
32895 | 32895 | Los Angeles | Los Angeles | 37 | 2020-02-12 | 1 | 0 | |
32891 | 32891 | Los Angeles | Los Angeles | 37 | 2020-02-13 | 1 | 0 | |
32887 | 32887 | Los Angeles | Los Angeles | 37 | 2020-02-14 | 1 | 0 | |
32883 | 32883 | Los Angeles | Los Angeles | 37 | 2020-02-15 | 1 | 0 | |
32879 | 32879 | Los Angeles | Los Angeles | 37 | 2020-02-16 | 1 | 0 | |
32875 | 32875 | Los Angeles | Los Angeles | 37 | 2020-02-17 | 1 | 0 | |
32871 | 32871 | Los Angeles | Los Angeles | 37 | 2020-02-18 | 1 | 0 | |
32867 | 32867 | Los Angeles | Los Angeles | 37 | 2020-02-19 | 1 | 0 | |
32848 | 32848 | Long Beach | Los Angeles | 37 | 2020-02-20 | 0 | 0 | |
32849 | 32849 | Los Angeles | Los Angeles | 37 | 2020-02-20 | 1 | 0 | |
32824 | 32824 | Long Beach | Los Angeles | 37 | 2020-02-21 | 0 | 0 | |
32825 | 32825 | Los Angeles | Los Angeles | 37 | 2020-02-21 | 1 | 0 | |
32814 | 32814 | Los Angeles | Los Angeles | 37 | 2020-02-22 | 1 | 0 | |
32808 | 32808 | Los Angeles | Los Angeles | 37 | 2020-02-23 | 1 | 0 | |
32802 | 32802 | Los Angeles | Los Angeles | 37 | 2020-02-24 | 1 | 0 | |
32796 | 32796 | Los Angeles | Los Angeles | 37 | 2020-02-25 | 1 | 0 | |
32776 | 32776 | Long Beach | Los Angeles | 37 | 2020-02-26 | 0 | 0 | |
32777 | 32777 | Los Angeles | Los Angeles | 37 | 2020-02-26 | 1 | 0 | |
32764 | 32764 | Los Angeles | Los Angeles | 37 | 2020-02-27 | 1 | 0 | |
32743 | 32743 | Long Beach | Los Angeles | 37 | 2020-02-28 | 0 | 0 | |
32744 | 32744 | Los Angeles | Los Angeles | 37 | 2020-02-28 | 1 | 0 | |
32718 | 32718 | Long Beach | Los Angeles | 37 | 2020-02-29 | 0 | 0 | |
32719 | 32719 | Los Angeles | Los Angeles | 37 | 2020-02-29 | 1 | 0 | |
32692 | 32692 | Long Beach | Los Angeles | 37 | 2020-03-01 | 0 | 0 | |
32693 | 32693 | Los Angeles | Los Angeles | 37 | 2020-03-01 | 1 | 0 | |
32666 | 32666 | Long Beach | Los Angeles | 37 | 2020-03-02 | 0 | 0 | |
32667 | 32667 | Los Angeles | Los Angeles | 37 | 2020-03-02 | 1 | 0 | |
32640 | 32640 | Long Beach | Los Angeles | 37 | 2020-03-03 | 0 | 0 | |
32641 | 32641 | Los Angeles | Los Angeles | 37 | 2020-03-03 | 1 | 0 | |
32614 | 32614 | Long Beach | Los Angeles | 37 | 2020-03-04 | 0 | 0 | |
32615 | 32615 | Los Angeles | Los Angeles | 37 | 2020-03-04 | 7 | 0 | |
32588 | 32588 | Long Beach | Los Angeles | 37 | 2020-03-05 | 0 | 0 | |
32589 | 32589 | Los Angeles | Los Angeles | 37 | 2020-03-05 | 11 | 0 | |
32562 | 32562 | Long Beach | Los Angeles | 37 | 2020-03-06 | 0 | 0 | |
32563 | 32563 | Los Angeles | Los Angeles | 37 | 2020-03-06 | 13 | 0 | |
32535 | 32535 | Long Beach | Los Angeles | 37 | 2020-03-07 | 0 | 0 | |
32536 | 32536 | Los Angeles | Los Angeles | 37 | 2020-03-07 | 14 | 0 | |
32508 | 32508 | Long Beach | Los Angeles | 37 | 2020-03-08 | 0 | 0 | |
32509 | 32509 | Los Angeles | Los Angeles | 37 | 2020-03-08 | 14 | 0 | |
32481 | 32481 | Long Beach | Los Angeles | 37 | 2020-03-09 | 3 | 0 | |
32482 | 32482 | Los Angeles | Los Angeles | 37 | 2020-03-09 | 16 | 0 | |
32454 | 32454 | Long Beach | Los Angeles | 37 | 2020-03-10 | 3 | 0 | |
32455 | 32455 | Los Angeles | Los Angeles | 37 | 2020-03-10 | 17 | 0 | |
32425 | 32425 | Long Beach | Los Angeles | 37 | 2020-03-11 | 4 | 0 | |
32426 | 32426 | Los Angeles | Los Angeles | 37 | 2020-03-11 | 24 | 1 | |
32427 | 32427 | Pasadena | Los Angeles | 37 | 2020-03-11 | 1 | 0 | |
32395 | 32395 | Long Beach | Los Angeles | 37 | 2020-03-12 | 4 | 0 | |
32396 | 32396 | Los Angeles | Los Angeles | 37 | 2020-03-12 | 27 | 1 | |
32397 | 32397 | Pasadena | Los Angeles | 37 | 2020-03-12 | 1 | 0 | |
32365 | 32365 | Long Beach | Los Angeles | 37 | 2020-03-13 | 4 | 0 | |
32366 | 32366 | Los Angeles | Los Angeles | 37 | 2020-03-13 | 35 | 1 | |
32367 | 32367 | Pasadena | Los Angeles | 37 | 2020-03-13 | 1 | 0 | |
32333 | 32333 | Long Beach | Los Angeles | 37 | 2020-03-14 | 5 | 0 | |
32334 | 32334 | Los Angeles | Los Angeles | 37 | 2020-03-14 | 48 | 1 | |
32335 | 32335 | Pasadena | Los Angeles | 37 | 2020-03-14 | 1 | 0 | |
32299 | 32299 | Long Beach | Los Angeles | 37 | 2020-03-15 | 5 | 0 | |
32300 | 32300 | Los Angeles | Los Angeles | 37 | 2020-03-15 | 63 | 1 | |
32301 | 32301 | Pasadena | Los Angeles | 37 | 2020-03-15 | 1 | 0 | |
32264 | 32264 | Long Beach | Los Angeles | 37 | 2020-03-16 | 5 | 0 | |
32265 | 32265 | Los Angeles | Los Angeles | 37 | 2020-03-16 | 87 | 1 | |
32266 | 32266 | Pasadena | Los Angeles | 37 | 2020-03-16 | 2 | 0 | |
32228 | 32228 | Long Beach | Los Angeles | 37 | 2020-03-17 | 8 | 0 | |
32229 | 32229 | Los Angeles | Los Angeles | 37 | 2020-03-17 | 137 | 1 | |
32230 | 32230 | Pasadena | Los Angeles | 37 | 2020-03-17 | 2 | 0 | |
32190 | 32190 | Long Beach | Los Angeles | 37 | 2020-03-18 | 10 | 0 | |
32191 | 32191 | Los Angeles | Los Angeles | 37 | 2020-03-18 | 180 | 1 | |
32192 | 32192 | Pasadena | Los Angeles | 37 | 2020-03-18 | 2 | 0 | TRUE |
32152 | 32152 | Long Beach | Los Angeles | 37 | 2020-03-19 | 12 | 0 | |
32153 | 32153 | Los Angeles | Los Angeles | 37 | 2020-03-19 | 217 | 2 | |
32154 | 32154 | Pasadena | Los Angeles | 37 | 2020-03-19 | 2 | 0 | |
32114 | 32114 | Long Beach | Los Angeles | 37 | 2020-03-20 | 14 | 0 | |
32115 | 32115 | Los Angeles | Los Angeles | 37 | 2020-03-20 | 278 | 2 | |
32116 | 32116 | Pasadena | Los Angeles | 37 | 2020-03-20 | 3 | 0 | |
32072 | 32072 | Long Beach | Los Angeles | 37 | 2020-03-21 | 15 | 0 | |
32073 | 32073 | Los Angeles | Los Angeles | 37 | 2020-03-21 | 335 | 4 | |
32074 | 32074 | Pasadena | Los Angeles | 37 | 2020-03-21 | 3 | 0 | |
32027 | 32027 | Long Beach | Los Angeles | 37 | 2020-03-22 | 17 | 0 | |
32028 | 32028 | Los Angeles | Los Angeles | 37 | 2020-03-22 | 391 | 5 | |
32029 | 32029 | Pasadena | Los Angeles | 37 | 2020-03-22 | 3 | 0 | |
31982 | 31982 | Long Beach | Los Angeles | 37 | 2020-03-23 | 21 | 1 |
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 );