latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
522 rows where fips = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
3 | 3 | Alpine | Alpine | 3 | 2021-09-02 | 89 | 0 | TRUE |
64 | 64 | Alpine | Alpine | 3 | 2021-09-01 | 89 | 0 | TRUE |
125 | 125 | Alpine | Alpine | 3 | 2021-08-31 | 89 | 0 | TRUE |
186 | 186 | Alpine | Alpine | 3 | 2021-08-30 | 89 | 0 | TRUE |
247 | 247 | Alpine | Alpine | 3 | 2021-08-29 | 89 | 0 | TRUE |
308 | 308 | Alpine | Alpine | 3 | 2021-08-28 | 89 | 0 | TRUE |
369 | 369 | Alpine | Alpine | 3 | 2021-08-27 | 89 | 0 | TRUE |
430 | 430 | Alpine | Alpine | 3 | 2021-08-26 | 89 | 0 | TRUE |
491 | 491 | Alpine | Alpine | 3 | 2021-08-25 | 89 | 0 | TRUE |
552 | 552 | Alpine | Alpine | 3 | 2021-08-24 | 89 | 0 | TRUE |
613 | 613 | Alpine | Alpine | 3 | 2021-08-23 | 89 | 0 | TRUE |
674 | 674 | Alpine | Alpine | 3 | 2021-08-22 | 89 | 0 | TRUE |
735 | 735 | Alpine | Alpine | 3 | 2021-08-21 | 89 | 0 | TRUE |
796 | 796 | Alpine | Alpine | 3 | 2021-08-20 | 89 | 0 | TRUE |
857 | 857 | Alpine | Alpine | 3 | 2021-08-19 | 89 | 0 | TRUE |
918 | 918 | Alpine | Alpine | 3 | 2021-08-18 | 89 | 0 | TRUE |
979 | 979 | Alpine | Alpine | 3 | 2021-08-17 | 89 | 0 | TRUE |
1040 | 1040 | Alpine | Alpine | 3 | 2021-08-16 | 89 | 0 | TRUE |
1101 | 1101 | Alpine | Alpine | 3 | 2021-08-15 | 89 | 0 | TRUE |
1162 | 1162 | Alpine | Alpine | 3 | 2021-08-14 | 89 | 0 | TRUE |
1223 | 1223 | Alpine | Alpine | 3 | 2021-08-13 | 89 | 0 | TRUE |
1284 | 1284 | Alpine | Alpine | 3 | 2021-08-12 | 89 | 0 | TRUE |
1345 | 1345 | Alpine | Alpine | 3 | 2021-08-11 | 89 | 0 | TRUE |
1406 | 1406 | Alpine | Alpine | 3 | 2021-08-10 | 89 | 0 | TRUE |
1467 | 1467 | Alpine | Alpine | 3 | 2021-08-09 | 89 | 0 | TRUE |
1528 | 1528 | Alpine | Alpine | 3 | 2021-08-08 | 89 | 0 | TRUE |
1589 | 1589 | Alpine | Alpine | 3 | 2021-08-07 | 89 | 0 | TRUE |
1650 | 1650 | Alpine | Alpine | 3 | 2021-08-06 | 89 | 0 | TRUE |
1711 | 1711 | Alpine | Alpine | 3 | 2021-08-05 | 89 | 0 | TRUE |
1772 | 1772 | Alpine | Alpine | 3 | 2021-08-04 | 89 | 0 | TRUE |
1833 | 1833 | Alpine | Alpine | 3 | 2021-08-03 | 89 | 0 | TRUE |
1894 | 1894 | Alpine | Alpine | 3 | 2021-08-02 | 89 | 0 | TRUE |
1955 | 1955 | Alpine | Alpine | 3 | 2021-08-01 | 89 | 0 | TRUE |
2016 | 2016 | Alpine | Alpine | 3 | 2021-07-31 | 89 | 0 | TRUE |
2077 | 2077 | Alpine | Alpine | 3 | 2021-07-30 | 89 | 0 | TRUE |
2138 | 2138 | Alpine | Alpine | 3 | 2021-07-29 | 89 | 0 | TRUE |
2199 | 2199 | Alpine | Alpine | 3 | 2021-07-28 | 89 | 0 | TRUE |
2260 | 2260 | Alpine | Alpine | 3 | 2021-07-27 | 89 | 0 | TRUE |
2321 | 2321 | Alpine | Alpine | 3 | 2021-07-26 | 89 | 0 | TRUE |
2382 | 2382 | Alpine | Alpine | 3 | 2021-07-25 | 89 | 0 | TRUE |
2443 | 2443 | Alpine | Alpine | 3 | 2021-07-24 | 89 | 0 | TRUE |
2504 | 2504 | Alpine | Alpine | 3 | 2021-07-23 | 89 | 0 | TRUE |
2565 | 2565 | Alpine | Alpine | 3 | 2021-07-22 | 89 | 0 | TRUE |
2626 | 2626 | Alpine | Alpine | 3 | 2021-07-21 | 89 | 0 | TRUE |
2687 | 2687 | Alpine | Alpine | 3 | 2021-07-20 | 89 | 0 | TRUE |
2748 | 2748 | Alpine | Alpine | 3 | 2021-07-19 | 89 | 0 | TRUE |
2809 | 2809 | Alpine | Alpine | 3 | 2021-07-18 | 89 | 0 | TRUE |
2870 | 2870 | Alpine | Alpine | 3 | 2021-07-17 | 89 | 0 | TRUE |
2931 | 2931 | Alpine | Alpine | 3 | 2021-07-16 | 89 | 0 | TRUE |
2992 | 2992 | Alpine | Alpine | 3 | 2021-07-15 | 89 | 0 | TRUE |
3053 | 3053 | Alpine | Alpine | 3 | 2021-07-14 | 89 | 0 | TRUE |
3114 | 3114 | Alpine | Alpine | 3 | 2021-07-13 | 89 | 0 | TRUE |
3175 | 3175 | Alpine | Alpine | 3 | 2021-07-12 | 89 | 0 | TRUE |
3236 | 3236 | Alpine | Alpine | 3 | 2021-07-11 | 89 | 0 | TRUE |
3297 | 3297 | Alpine | Alpine | 3 | 2021-07-10 | 89 | 0 | TRUE |
3358 | 3358 | Alpine | Alpine | 3 | 2021-07-09 | 89 | 0 | TRUE |
3419 | 3419 | Alpine | Alpine | 3 | 2021-07-08 | 89 | 0 | |
3480 | 3480 | Alpine | Alpine | 3 | 2021-07-07 | 89 | 0 | TRUE |
3541 | 3541 | Alpine | Alpine | 3 | 2021-07-06 | 89 | 0 | TRUE |
3602 | 3602 | Alpine | Alpine | 3 | 2021-07-05 | 89 | 0 | TRUE |
3663 | 3663 | Alpine | Alpine | 3 | 2021-07-04 | 89 | 0 | TRUE |
3724 | 3724 | Alpine | Alpine | 3 | 2021-07-03 | 89 | 0 | TRUE |
3785 | 3785 | Alpine | Alpine | 3 | 2021-07-02 | 89 | 0 | TRUE |
3846 | 3846 | Alpine | Alpine | 3 | 2021-07-01 | 89 | 0 | TRUE |
3907 | 3907 | Alpine | Alpine | 3 | 2021-06-30 | 89 | 0 | TRUE |
3968 | 3968 | Alpine | Alpine | 3 | 2021-06-29 | 89 | 0 | TRUE |
4029 | 4029 | Alpine | Alpine | 3 | 2021-06-28 | 89 | 0 | TRUE |
4090 | 4090 | Alpine | Alpine | 3 | 2021-06-27 | 89 | 0 | TRUE |
4151 | 4151 | Alpine | Alpine | 3 | 2021-06-26 | 89 | 0 | TRUE |
4212 | 4212 | Alpine | Alpine | 3 | 2021-06-25 | 89 | 0 | TRUE |
4273 | 4273 | Alpine | Alpine | 3 | 2021-06-24 | 89 | 0 | TRUE |
4334 | 4334 | Alpine | Alpine | 3 | 2021-06-23 | 89 | 0 | TRUE |
4395 | 4395 | Alpine | Alpine | 3 | 2021-06-22 | 89 | 0 | TRUE |
4456 | 4456 | Alpine | Alpine | 3 | 2021-06-21 | 89 | 0 | TRUE |
4517 | 4517 | Alpine | Alpine | 3 | 2021-06-20 | 89 | 0 | TRUE |
4578 | 4578 | Alpine | Alpine | 3 | 2021-06-19 | 89 | 0 | TRUE |
4639 | 4639 | Alpine | Alpine | 3 | 2021-06-18 | 89 | 0 | TRUE |
4700 | 4700 | Alpine | Alpine | 3 | 2021-06-17 | 89 | 0 | TRUE |
4761 | 4761 | Alpine | Alpine | 3 | 2021-06-16 | 89 | 0 | TRUE |
4822 | 4822 | Alpine | Alpine | 3 | 2021-06-15 | 89 | 0 | TRUE |
4883 | 4883 | Alpine | Alpine | 3 | 2021-06-14 | 89 | 0 | TRUE |
4944 | 4944 | Alpine | Alpine | 3 | 2021-06-13 | 89 | 0 | TRUE |
5005 | 5005 | Alpine | Alpine | 3 | 2021-06-12 | 89 | 0 | TRUE |
5066 | 5066 | Alpine | Alpine | 3 | 2021-06-11 | 89 | 0 | TRUE |
5127 | 5127 | Alpine | Alpine | 3 | 2021-06-10 | 89 | 0 | |
5188 | 5188 | Alpine | Alpine | 3 | 2021-06-09 | 89 | 0 | TRUE |
5249 | 5249 | Alpine | Alpine | 3 | 2021-06-08 | 89 | 0 | TRUE |
5310 | 5310 | Alpine | Alpine | 3 | 2021-06-07 | 89 | 0 | TRUE |
5371 | 5371 | Alpine | Alpine | 3 | 2021-06-06 | 89 | 0 | TRUE |
5432 | 5432 | Alpine | Alpine | 3 | 2021-06-05 | 89 | 0 | TRUE |
5493 | 5493 | Alpine | Alpine | 3 | 2021-06-04 | 89 | 0 | TRUE |
5554 | 5554 | Alpine | Alpine | 3 | 2021-06-03 | 89 | 0 | |
5615 | 5615 | Alpine | Alpine | 3 | 2021-06-02 | 89 | 0 | |
5676 | 5676 | Alpine | Alpine | 3 | 2021-06-01 | 89 | 0 | TRUE |
5737 | 5737 | Alpine | Alpine | 3 | 2021-05-31 | 89 | 0 | TRUE |
5798 | 5798 | Alpine | Alpine | 3 | 2021-05-30 | 89 | 0 | TRUE |
5859 | 5859 | Alpine | Alpine | 3 | 2021-05-29 | 89 | 0 | TRUE |
5920 | 5920 | Alpine | Alpine | 3 | 2021-05-28 | 89 | 0 | TRUE |
5981 | 5981 | Alpine | Alpine | 3 | 2021-05-27 | 89 | 0 | |
6042 | 6042 | Alpine | Alpine | 3 | 2021-05-26 | 89 | 0 |
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 );