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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
2034 | 2034 | Los Angeles | Los Angeles | 37 | 2021-07-31 | 1232551 | 23377 | |
2035 | 2035 | Pasadena | Los Angeles | 37 | 2021-07-31 | 11877 | 352 | TRUE |
2094 | 2094 | Long Beach | Los Angeles | 37 | 2021-07-30 | 55739 | 953 | |
2095 | 2095 | Los Angeles | Los Angeles | 37 | 2021-07-30 | 1229471 | 23371 | |
2096 | 2096 | Pasadena | Los Angeles | 37 | 2021-07-30 | 11877 | 352 | |
2155 | 2155 | Long Beach | Los Angeles | 37 | 2021-07-29 | 55739 | 953 | |
2156 | 2156 | Los Angeles | Los Angeles | 37 | 2021-07-29 | 1226022 | 23371 | |
2157 | 2157 | Pasadena | Los Angeles | 37 | 2021-07-29 | 11822 | 352 | |
2216 | 2216 | Long Beach | Los Angeles | 37 | 2021-07-28 | 55643 | 951 | |
2217 | 2217 | Los Angeles | Los Angeles | 37 | 2021-07-28 | 1222967 | 23355 | |
2218 | 2218 | Pasadena | Los Angeles | 37 | 2021-07-28 | 11785 | 352 | |
2277 | 2277 | Long Beach | Los Angeles | 37 | 2021-07-27 | 55503 | 951 | |
2278 | 2278 | Los Angeles | Los Angeles | 37 | 2021-07-27 | 1220856 | 23340 | |
2279 | 2279 | Pasadena | Los Angeles | 37 | 2021-07-27 | 11731 | 352 | |
2338 | 2338 | Long Beach | Los Angeles | 37 | 2021-07-26 | 55244 | 951 | |
2339 | 2339 | Los Angeles | Los Angeles | 37 | 2021-07-26 | 1218988 | 23329 | |
2340 | 2340 | Pasadena | Los Angeles | 37 | 2021-07-26 | 11731 | 352 | |
2399 | 2399 | Long Beach | Los Angeles | 37 | 2021-07-25 | 55133 | 951 | TRUE |
2400 | 2400 | Los Angeles | Los Angeles | 37 | 2021-07-25 | 1217061 | 23326 | |
2401 | 2401 | Pasadena | Los Angeles | 37 | 2021-07-25 | 11650 | 351 | TRUE |
2460 | 2460 | Long Beach | Los Angeles | 37 | 2021-07-24 | 55133 | 951 | TRUE |
2461 | 2461 | Los Angeles | Los Angeles | 37 | 2021-07-24 | 1214977 | 23322 | |
2462 | 2462 | Pasadena | Los Angeles | 37 | 2021-07-24 | 11650 | 351 | TRUE |
2521 | 2521 | Long Beach | Los Angeles | 37 | 2021-07-23 | 55133 | 951 | |
2522 | 2522 | Los Angeles | Los Angeles | 37 | 2021-07-23 | 1212516 | 23313 | |
2523 | 2523 | Pasadena | Los Angeles | 37 | 2021-07-23 | 11650 | 351 | |
2582 | 2582 | Long Beach | Los Angeles | 37 | 2021-07-22 | 55028 | 950 | |
2583 | 2583 | Los Angeles | Los Angeles | 37 | 2021-07-22 | 1209654 | 23307 | |
2584 | 2584 | Pasadena | Los Angeles | 37 | 2021-07-22 | 11572 | 351 | |
2643 | 2643 | Long Beach | Los Angeles | 37 | 2021-07-21 | 54890 | 949 | |
2644 | 2644 | Los Angeles | Los Angeles | 37 | 2021-07-21 | 1207068 | 23294 | |
2645 | 2645 | Pasadena | Los Angeles | 37 | 2021-07-21 | 11593 | 351 | |
2704 | 2704 | Long Beach | Los Angeles | 37 | 2021-07-20 | 54750 | 949 | |
2705 | 2705 | Los Angeles | Los Angeles | 37 | 2021-07-20 | 1204857 | 23288 | |
2706 | 2706 | Pasadena | Los Angeles | 37 | 2021-07-20 | 11572 | 351 | |
2765 | 2765 | Long Beach | Los Angeles | 37 | 2021-07-19 | 54471 | 948 | |
2766 | 2766 | Los Angeles | Los Angeles | 37 | 2021-07-19 | 1203188 | 23286 | |
2767 | 2767 | Pasadena | Los Angeles | 37 | 2021-07-19 | 11558 | 351 | |
2826 | 2826 | Long Beach | Los Angeles | 37 | 2021-07-18 | 54395 | 948 | TRUE |
2827 | 2827 | Los Angeles | Los Angeles | 37 | 2021-07-18 | 1201958 | 23284 | |
2828 | 2828 | Pasadena | Los Angeles | 37 | 2021-07-18 | 11507 | 351 | TRUE |
2887 | 2887 | Long Beach | Los Angeles | 37 | 2021-07-17 | 54395 | 948 | TRUE |
2888 | 2888 | Los Angeles | Los Angeles | 37 | 2021-07-17 | 1200325 | 23280 | |
2889 | 2889 | Pasadena | Los Angeles | 37 | 2021-07-17 | 11507 | 351 | TRUE |
2948 | 2948 | Long Beach | Los Angeles | 37 | 2021-07-16 | 54395 | 948 | |
2949 | 2949 | Los Angeles | Los Angeles | 37 | 2021-07-16 | 1198656 | 23269 | |
2950 | 2950 | Pasadena | Los Angeles | 37 | 2021-07-16 | 11507 | 351 | |
3009 | 3009 | Long Beach | Los Angeles | 37 | 2021-07-15 | 54294 | 948 | |
3010 | 3010 | Los Angeles | Los Angeles | 37 | 2021-07-15 | 1196893 | 23268 | |
3011 | 3011 | Pasadena | Los Angeles | 37 | 2021-07-15 | 11484 | 351 | |
3070 | 3070 | Long Beach | Los Angeles | 37 | 2021-07-14 | 54201 | 947 | |
3071 | 3071 | Los Angeles | Los Angeles | 37 | 2021-07-14 | 1195492 | 23265 | |
3072 | 3072 | Pasadena | Los Angeles | 37 | 2021-07-14 | 11471 | 351 | |
3131 | 3131 | Long Beach | Los Angeles | 37 | 2021-07-13 | 54105 | 947 | |
3132 | 3132 | Los Angeles | Los Angeles | 37 | 2021-07-13 | 1194430 | 23256 | |
3133 | 3133 | Pasadena | Los Angeles | 37 | 2021-07-13 | 11457 | 351 | |
3192 | 3192 | Long Beach | Los Angeles | 37 | 2021-07-12 | 53885 | 947 | TRUE |
3193 | 3193 | Los Angeles | Los Angeles | 37 | 2021-07-12 | 1193375 | 23246 | |
3194 | 3194 | Pasadena | Los Angeles | 37 | 2021-07-12 | 11425 | 350 | |
3253 | 3253 | Long Beach | Los Angeles | 37 | 2021-07-11 | 53885 | 947 | |
3254 | 3254 | Los Angeles | Los Angeles | 37 | 2021-07-11 | 1192318 | 23245 | |
3255 | 3255 | Pasadena | Los Angeles | 37 | 2021-07-11 | 11425 | 350 | TRUE |
3314 | 3314 | Long Beach | Los Angeles | 37 | 2021-07-10 | 53843 | 947 | TRUE |
3315 | 3315 | Los Angeles | Los Angeles | 37 | 2021-07-10 | 1191247 | 23241 | |
3316 | 3316 | Pasadena | Los Angeles | 37 | 2021-07-10 | 11425 | 350 | TRUE |
3375 | 3375 | Long Beach | Los Angeles | 37 | 2021-07-09 | 53843 | 947 | |
3376 | 3376 | Los Angeles | Los Angeles | 37 | 2021-07-09 | 1190178 | 23233 | |
3377 | 3377 | Pasadena | Los Angeles | 37 | 2021-07-09 | 11425 | 350 | |
3436 | 3436 | Long Beach | Los Angeles | 37 | 2021-07-08 | 53843 | 947 | |
3437 | 3437 | Los Angeles | Los Angeles | 37 | 2021-07-08 | 1189146 | 23230 | |
3438 | 3438 | Pasadena | Los Angeles | 37 | 2021-07-08 | 11413 | 350 | |
3497 | 3497 | Long Beach | Los Angeles | 37 | 2021-07-07 | 53811 | 945 | |
3498 | 3498 | Los Angeles | Los Angeles | 37 | 2021-07-07 | 1188414 | 23219 | |
3499 | 3499 | Pasadena | Los Angeles | 37 | 2021-07-07 | 11397 | 350 | |
3558 | 3558 | Long Beach | Los Angeles | 37 | 2021-07-06 | 53734 | 945 | |
3559 | 3559 | Los Angeles | Los Angeles | 37 | 2021-07-06 | 1187984 | 23213 | |
3560 | 3560 | Pasadena | Los Angeles | 37 | 2021-07-06 | 11388 | 350 | |
3619 | 3619 | Long Beach | Los Angeles | 37 | 2021-07-05 | 53709 | 945 | TRUE |
3620 | 3620 | Los Angeles | Los Angeles | 37 | 2021-07-05 | 1187222 | 23208 | |
3621 | 3621 | Pasadena | Los Angeles | 37 | 2021-07-05 | 11385 | 349 | |
3680 | 3680 | Long Beach | Los Angeles | 37 | 2021-07-04 | 53709 | 945 | TRUE |
3681 | 3681 | Los Angeles | Los Angeles | 37 | 2021-07-04 | 1186767 | 23204 | |
3682 | 3682 | Pasadena | Los Angeles | 37 | 2021-07-04 | 11380 | 349 | |
3741 | 3741 | Long Beach | Los Angeles | 37 | 2021-07-03 | 53709 | 945 | TRUE |
3742 | 3742 | Los Angeles | Los Angeles | 37 | 2021-07-03 | 1186178 | 23198 | |
3743 | 3743 | Pasadena | Los Angeles | 37 | 2021-07-03 | 11376 | 349 | |
3802 | 3802 | Long Beach | Los Angeles | 37 | 2021-07-02 | 53709 | 945 | |
3803 | 3803 | Los Angeles | Los Angeles | 37 | 2021-07-02 | 1186178 | 23198 | |
3804 | 3804 | Pasadena | Los Angeles | 37 | 2021-07-02 | 11372 | 349 | |
3863 | 3863 | Long Beach | Los Angeles | 37 | 2021-07-01 | 53692 | 945 | |
3864 | 3864 | Los Angeles | Los Angeles | 37 | 2021-07-01 | 1185701 | 23195 | |
3865 | 3865 | Pasadena | Los Angeles | 37 | 2021-07-01 | 11354 | 349 | |
3924 | 3924 | Long Beach | Los Angeles | 37 | 2021-06-30 | 53650 | 945 | TRUE |
3925 | 3925 | Los Angeles | Los Angeles | 37 | 2021-06-30 | 1185253 | 23189 | |
3926 | 3926 | Pasadena | Los Angeles | 37 | 2021-06-30 | 11347 | 349 | |
3985 | 3985 | Long Beach | Los Angeles | 37 | 2021-06-29 | 53650 | 945 | |
3986 | 3986 | Los Angeles | Los Angeles | 37 | 2021-06-29 | 1184888 | 23188 | |
3987 | 3987 | Pasadena | Los Angeles | 37 | 2021-06-29 | 11337 | 349 | |
4046 | 4046 | Long Beach | Los Angeles | 37 | 2021-06-28 | 53612 | 945 | |
4047 | 4047 | Los Angeles | Los Angeles | 37 | 2021-06-28 | 1184625 | 23186 |
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 );