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 = "Long Beach" and fips = 37 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 |
---|---|---|---|---|---|---|---|---|
2094 | 2094 | Long Beach | Los Angeles | 37 | 2021-07-30 | 55739 | 953 | |
2155 | 2155 | Long Beach | Los Angeles | 37 | 2021-07-29 | 55739 | 953 | |
2216 | 2216 | Long Beach | Los Angeles | 37 | 2021-07-28 | 55643 | 951 | |
2277 | 2277 | Long Beach | Los Angeles | 37 | 2021-07-27 | 55503 | 951 | |
2338 | 2338 | Long Beach | Los Angeles | 37 | 2021-07-26 | 55244 | 951 | |
2399 | 2399 | Long Beach | Los Angeles | 37 | 2021-07-25 | 55133 | 951 | TRUE |
2460 | 2460 | Long Beach | Los Angeles | 37 | 2021-07-24 | 55133 | 951 | TRUE |
2521 | 2521 | Long Beach | Los Angeles | 37 | 2021-07-23 | 55133 | 951 | |
2582 | 2582 | Long Beach | Los Angeles | 37 | 2021-07-22 | 55028 | 950 | |
2643 | 2643 | Long Beach | Los Angeles | 37 | 2021-07-21 | 54890 | 949 | |
2704 | 2704 | Long Beach | Los Angeles | 37 | 2021-07-20 | 54750 | 949 | |
2765 | 2765 | Long Beach | Los Angeles | 37 | 2021-07-19 | 54471 | 948 | |
2826 | 2826 | Long Beach | Los Angeles | 37 | 2021-07-18 | 54395 | 948 | TRUE |
2887 | 2887 | Long Beach | Los Angeles | 37 | 2021-07-17 | 54395 | 948 | TRUE |
2948 | 2948 | Long Beach | Los Angeles | 37 | 2021-07-16 | 54395 | 948 | |
3009 | 3009 | Long Beach | Los Angeles | 37 | 2021-07-15 | 54294 | 948 | |
3070 | 3070 | Long Beach | Los Angeles | 37 | 2021-07-14 | 54201 | 947 | |
3131 | 3131 | Long Beach | Los Angeles | 37 | 2021-07-13 | 54105 | 947 | |
3192 | 3192 | Long Beach | Los Angeles | 37 | 2021-07-12 | 53885 | 947 | TRUE |
3253 | 3253 | Long Beach | Los Angeles | 37 | 2021-07-11 | 53885 | 947 | |
3314 | 3314 | Long Beach | Los Angeles | 37 | 2021-07-10 | 53843 | 947 | TRUE |
3375 | 3375 | Long Beach | Los Angeles | 37 | 2021-07-09 | 53843 | 947 | |
3436 | 3436 | Long Beach | Los Angeles | 37 | 2021-07-08 | 53843 | 947 | |
3497 | 3497 | Long Beach | Los Angeles | 37 | 2021-07-07 | 53811 | 945 | |
3558 | 3558 | Long Beach | Los Angeles | 37 | 2021-07-06 | 53734 | 945 | |
3619 | 3619 | Long Beach | Los Angeles | 37 | 2021-07-05 | 53709 | 945 | TRUE |
3680 | 3680 | Long Beach | Los Angeles | 37 | 2021-07-04 | 53709 | 945 | TRUE |
3741 | 3741 | Long Beach | Los Angeles | 37 | 2021-07-03 | 53709 | 945 | TRUE |
3802 | 3802 | Long Beach | Los Angeles | 37 | 2021-07-02 | 53709 | 945 | |
3863 | 3863 | Long Beach | Los Angeles | 37 | 2021-07-01 | 53692 | 945 | |
3924 | 3924 | Long Beach | Los Angeles | 37 | 2021-06-30 | 53650 | 945 | TRUE |
3985 | 3985 | Long Beach | Los Angeles | 37 | 2021-06-29 | 53650 | 945 | |
4046 | 4046 | Long Beach | Los Angeles | 37 | 2021-06-28 | 53612 | 945 | |
4107 | 4107 | Long Beach | Los Angeles | 37 | 2021-06-27 | 53607 | 945 | TRUE |
4168 | 4168 | Long Beach | Los Angeles | 37 | 2021-06-26 | 53607 | 945 | TRUE |
4229 | 4229 | Long Beach | Los Angeles | 37 | 2021-06-25 | 53607 | 945 | |
4290 | 4290 | Long Beach | Los Angeles | 37 | 2021-06-24 | 53564 | 947 | TRUE |
4351 | 4351 | Long Beach | Los Angeles | 37 | 2021-06-23 | 53564 | 947 | |
4412 | 4412 | Long Beach | Los Angeles | 37 | 2021-06-22 | 53533 | 945 | |
4473 | 4473 | Long Beach | Los Angeles | 37 | 2021-06-21 | 53525 | 945 | TRUE |
4534 | 4534 | Long Beach | Los Angeles | 37 | 2021-06-20 | 53525 | 945 | TRUE |
4595 | 4595 | Long Beach | Los Angeles | 37 | 2021-06-19 | 53525 | 945 | |
4656 | 4656 | Long Beach | Los Angeles | 37 | 2021-06-18 | 53515 | 945 | TRUE |
4717 | 4717 | Long Beach | Los Angeles | 37 | 2021-06-17 | 53515 | 945 | TRUE |
4778 | 4778 | Long Beach | Los Angeles | 37 | 2021-06-16 | 53515 | 945 | |
4839 | 4839 | Long Beach | Los Angeles | 37 | 2021-06-15 | 53505 | 944 | |
4900 | 4900 | Long Beach | Los Angeles | 37 | 2021-06-14 | 53476 | 942 | |
4961 | 4961 | Long Beach | Los Angeles | 37 | 2021-06-13 | 53476 | 942 | TRUE |
5022 | 5022 | Long Beach | Los Angeles | 37 | 2021-06-12 | 53476 | 942 | |
5083 | 5083 | Long Beach | Los Angeles | 37 | 2021-06-11 | 53476 | 942 | |
5144 | 5144 | Long Beach | Los Angeles | 37 | 2021-06-10 | 53482 | 942 | |
5205 | 5205 | Long Beach | Los Angeles | 37 | 2021-06-09 | 53468 | 942 | |
5266 | 5266 | Long Beach | Los Angeles | 37 | 2021-06-08 | 53465 | 941 | |
5327 | 5327 | Long Beach | Los Angeles | 37 | 2021-06-07 | 53450 | 941 | |
5388 | 5388 | Long Beach | Los Angeles | 37 | 2021-06-06 | 53437 | 941 | TRUE |
5449 | 5449 | Long Beach | Los Angeles | 37 | 2021-06-05 | 53437 | 941 | TRUE |
5510 | 5510 | Long Beach | Los Angeles | 37 | 2021-06-04 | 53437 | 941 | |
5571 | 5571 | Long Beach | Los Angeles | 37 | 2021-06-03 | 53416 | 940 | |
5632 | 5632 | Long Beach | Los Angeles | 37 | 2021-06-02 | 53403 | 939 | |
5693 | 5693 | Long Beach | Los Angeles | 37 | 2021-06-01 | 53383 | 939 | |
5754 | 5754 | Long Beach | Los Angeles | 37 | 2021-05-31 | 53378 | 939 | TRUE |
5815 | 5815 | Long Beach | Los Angeles | 37 | 2021-05-30 | 53378 | 939 | |
5876 | 5876 | Long Beach | Los Angeles | 37 | 2021-05-29 | 53378 | 939 | TRUE |
5937 | 5937 | Long Beach | Los Angeles | 37 | 2021-05-28 | 53378 | 939 | |
5998 | 5998 | Long Beach | Los Angeles | 37 | 2021-05-27 | 53369 | 939 | |
6059 | 6059 | Long Beach | Los Angeles | 37 | 2021-05-26 | 53353 | 938 | |
6120 | 6120 | Long Beach | Los Angeles | 37 | 2021-05-25 | 53328 | 937 | |
6181 | 6181 | Long Beach | Los Angeles | 37 | 2021-05-24 | 53295 | 935 | |
6242 | 6242 | Long Beach | Los Angeles | 37 | 2021-05-23 | 53287 | 935 | TRUE |
6303 | 6303 | Long Beach | Los Angeles | 37 | 2021-05-22 | 53287 | 935 | TRUE |
6364 | 6364 | Long Beach | Los Angeles | 37 | 2021-05-21 | 53287 | 935 | |
6425 | 6425 | Long Beach | Los Angeles | 37 | 2021-05-20 | 53274 | 935 | |
6486 | 6486 | Long Beach | Los Angeles | 37 | 2021-05-19 | 53250 | 934 | |
6547 | 6547 | Long Beach | Los Angeles | 37 | 2021-05-18 | 53240 | 934 | |
6608 | 6608 | Long Beach | Los Angeles | 37 | 2021-05-17 | 53223 | 934 | |
6669 | 6669 | Long Beach | Los Angeles | 37 | 2021-05-16 | 53223 | 934 | TRUE |
6730 | 6730 | Long Beach | Los Angeles | 37 | 2021-05-15 | 53223 | 934 | TRUE |
6791 | 6791 | Long Beach | Los Angeles | 37 | 2021-05-14 | 53185 | 933 | |
6852 | 6852 | Long Beach | Los Angeles | 37 | 2021-05-13 | 53154 | 933 | |
6913 | 6913 | Long Beach | Los Angeles | 37 | 2021-05-12 | 53145 | 933 | |
6974 | 6974 | Long Beach | Los Angeles | 37 | 2021-05-11 | 53133 | 933 | |
7035 | 7035 | Long Beach | Los Angeles | 37 | 2021-05-10 | 53107 | 932 | |
7096 | 7096 | Long Beach | Los Angeles | 37 | 2021-05-09 | 53082 | 932 | TRUE |
7157 | 7157 | Long Beach | Los Angeles | 37 | 2021-05-08 | 53082 | 932 | TRUE |
7218 | 7218 | Long Beach | Los Angeles | 37 | 2021-05-07 | 53082 | 932 | |
7279 | 7279 | Long Beach | Los Angeles | 37 | 2021-05-06 | 53057 | 931 | |
7340 | 7340 | Long Beach | Los Angeles | 37 | 2021-05-05 | 53025 | 931 | |
7401 | 7401 | Long Beach | Los Angeles | 37 | 2021-05-04 | 52992 | 931 | |
7462 | 7462 | Long Beach | Los Angeles | 37 | 2021-05-03 | 52954 | 931 | |
7523 | 7523 | Long Beach | Los Angeles | 37 | 2021-05-02 | 52956 | 931 | |
7584 | 7584 | Long Beach | Los Angeles | 37 | 2021-05-01 | 52956 | 931 | TRUE |
7645 | 7645 | Long Beach | Los Angeles | 37 | 2021-04-30 | 52938 | 931 | |
7706 | 7706 | Long Beach | Los Angeles | 37 | 2021-04-29 | 52909 | 931 | |
7767 | 7767 | Long Beach | Los Angeles | 37 | 2021-04-28 | 52887 | 931 | |
7828 | 7828 | Long Beach | Los Angeles | 37 | 2021-04-27 | 52873 | 929 | |
7889 | 7889 | Long Beach | Los Angeles | 37 | 2021-04-26 | 52827 | 929 | |
7950 | 7950 | Long Beach | Los Angeles | 37 | 2021-04-25 | 52800 | 929 | TRUE |
8011 | 8011 | Long Beach | Los Angeles | 37 | 2021-04-24 | 52800 | 929 | TRUE |
8072 | 8072 | Long Beach | Los Angeles | 37 | 2021-04-23 | 52777 | 928 | |
8133 | 8133 | Long Beach | Los Angeles | 37 | 2021-04-22 | 52749 | 928 |
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 );