latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
492 rows where agency = "Sierra" and fips = 91 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
49 | 49 | Sierra | Sierra | 91 | 2021-09-02 | 198 | 0 | |
110 | 110 | Sierra | Sierra | 91 | 2021-09-01 | 191 | 0 | |
171 | 171 | Sierra | Sierra | 91 | 2021-08-31 | 188 | 0 | TRUE |
232 | 232 | Sierra | Sierra | 91 | 2021-08-30 | 188 | 0 | TRUE |
293 | 293 | Sierra | Sierra | 91 | 2021-08-29 | 188 | 0 | TRUE |
354 | 354 | Sierra | Sierra | 91 | 2021-08-28 | 188 | 0 | TRUE |
415 | 415 | Sierra | Sierra | 91 | 2021-08-27 | 188 | 0 | |
476 | 476 | Sierra | Sierra | 91 | 2021-08-26 | 188 | 0 | |
537 | 537 | Sierra | Sierra | 91 | 2021-08-25 | 175 | 0 | |
598 | 598 | Sierra | Sierra | 91 | 2021-08-24 | 174 | 0 | TRUE |
659 | 659 | Sierra | Sierra | 91 | 2021-08-23 | 174 | 0 | |
720 | 720 | Sierra | Sierra | 91 | 2021-08-22 | 160 | 0 | TRUE |
781 | 781 | Sierra | Sierra | 91 | 2021-08-21 | 160 | 0 | TRUE |
842 | 842 | Sierra | Sierra | 91 | 2021-08-20 | 160 | 0 | |
903 | 903 | Sierra | Sierra | 91 | 2021-08-19 | 158 | 0 | |
964 | 964 | Sierra | Sierra | 91 | 2021-08-18 | 154 | 0 | |
1025 | 1025 | Sierra | Sierra | 91 | 2021-08-17 | 154 | 0 | |
1086 | 1086 | Sierra | Sierra | 91 | 2021-08-16 | 152 | 0 | |
1147 | 1147 | Sierra | Sierra | 91 | 2021-08-15 | 150 | 0 | TRUE |
1208 | 1208 | Sierra | Sierra | 91 | 2021-08-14 | 150 | 0 | TRUE |
1269 | 1269 | Sierra | Sierra | 91 | 2021-08-13 | 150 | 0 | |
1330 | 1330 | Sierra | Sierra | 91 | 2021-08-12 | 150 | 0 | |
1391 | 1391 | Sierra | Sierra | 91 | 2021-08-11 | 146 | 0 | |
1452 | 1452 | Sierra | Sierra | 91 | 2021-08-10 | 143 | 0 | |
1513 | 1513 | Sierra | Sierra | 91 | 2021-08-09 | 140 | 0 | |
1574 | 1574 | Sierra | Sierra | 91 | 2021-08-08 | 138 | 0 | TRUE |
1635 | 1635 | Sierra | Sierra | 91 | 2021-08-07 | 138 | 0 | TRUE |
1696 | 1696 | Sierra | Sierra | 91 | 2021-08-06 | 138 | 0 | TRUE |
1757 | 1757 | Sierra | Sierra | 91 | 2021-08-05 | 138 | 0 | |
1818 | 1818 | Sierra | Sierra | 91 | 2021-08-04 | 137 | 0 | TRUE |
1879 | 1879 | Sierra | Sierra | 91 | 2021-08-03 | 137 | 0 | |
1940 | 1940 | Sierra | Sierra | 91 | 2021-08-02 | 133 | 0 | |
2001 | 2001 | Sierra | Sierra | 91 | 2021-08-01 | 131 | 0 | TRUE |
2062 | 2062 | Sierra | Sierra | 91 | 2021-07-31 | 131 | 0 | TRUE |
2123 | 2123 | Sierra | Sierra | 91 | 2021-07-30 | 131 | 0 | |
2184 | 2184 | Sierra | Sierra | 91 | 2021-07-29 | 129 | 0 | |
2245 | 2245 | Sierra | Sierra | 91 | 2021-07-28 | 126 | 0 | TRUE |
2306 | 2306 | Sierra | Sierra | 91 | 2021-07-27 | 126 | 0 | TRUE |
2367 | 2367 | Sierra | Sierra | 91 | 2021-07-26 | 126 | 0 | |
2428 | 2428 | Sierra | Sierra | 91 | 2021-07-25 | 125 | 0 | TRUE |
2489 | 2489 | Sierra | Sierra | 91 | 2021-07-24 | 125 | 0 | TRUE |
2550 | 2550 | Sierra | Sierra | 91 | 2021-07-23 | 125 | 0 | |
2611 | 2611 | Sierra | Sierra | 91 | 2021-07-22 | 124 | 0 | TRUE |
2672 | 2672 | Sierra | Sierra | 91 | 2021-07-21 | 124 | 0 | TRUE |
2733 | 2733 | Sierra | Sierra | 91 | 2021-07-20 | 124 | 0 | TRUE |
2794 | 2794 | Sierra | Sierra | 91 | 2021-07-19 | 124 | 0 | TRUE |
2855 | 2855 | Sierra | Sierra | 91 | 2021-07-18 | 124 | 0 | TRUE |
2916 | 2916 | Sierra | Sierra | 91 | 2021-07-17 | 124 | 0 | TRUE |
2977 | 2977 | Sierra | Sierra | 91 | 2021-07-16 | 124 | 0 | TRUE |
3038 | 3038 | Sierra | Sierra | 91 | 2021-07-15 | 124 | 0 | |
3099 | 3099 | Sierra | Sierra | 91 | 2021-07-14 | 123 | 0 | TRUE |
3160 | 3160 | Sierra | Sierra | 91 | 2021-07-13 | 123 | 0 | |
3221 | 3221 | Sierra | Sierra | 91 | 2021-07-12 | 122 | 0 | TRUE |
3282 | 3282 | Sierra | Sierra | 91 | 2021-07-11 | 122 | 0 | TRUE |
3343 | 3343 | Sierra | Sierra | 91 | 2021-07-10 | 122 | 0 | TRUE |
3404 | 3404 | Sierra | Sierra | 91 | 2021-07-09 | 122 | 0 | |
3465 | 3465 | Sierra | Sierra | 91 | 2021-07-08 | 122 | 0 | |
3526 | 3526 | Sierra | Sierra | 91 | 2021-07-07 | 122 | 0 | TRUE |
3587 | 3587 | Sierra | Sierra | 91 | 2021-07-06 | 122 | 0 | TRUE |
3648 | 3648 | Sierra | Sierra | 91 | 2021-07-05 | 122 | 0 | TRUE |
3709 | 3709 | Sierra | Sierra | 91 | 2021-07-04 | 122 | 0 | TRUE |
3770 | 3770 | Sierra | Sierra | 91 | 2021-07-03 | 122 | 0 | TRUE |
3831 | 3831 | Sierra | Sierra | 91 | 2021-07-02 | 122 | 0 | TRUE |
3892 | 3892 | Sierra | Sierra | 91 | 2021-07-01 | 122 | 0 | |
3953 | 3953 | Sierra | Sierra | 91 | 2021-06-30 | 122 | 0 | |
4014 | 4014 | Sierra | Sierra | 91 | 2021-06-29 | 122 | 0 | |
4075 | 4075 | Sierra | Sierra | 91 | 2021-06-28 | 122 | 0 | |
4136 | 4136 | Sierra | Sierra | 91 | 2021-06-27 | 118 | 0 | TRUE |
4197 | 4197 | Sierra | Sierra | 91 | 2021-06-26 | 118 | 0 | TRUE |
4258 | 4258 | Sierra | Sierra | 91 | 2021-06-25 | 118 | 0 | TRUE |
4319 | 4319 | Sierra | Sierra | 91 | 2021-06-24 | 118 | 0 | |
4380 | 4380 | Sierra | Sierra | 91 | 2021-06-23 | 117 | 0 | TRUE |
4441 | 4441 | Sierra | Sierra | 91 | 2021-06-22 | 117 | 0 | |
4502 | 4502 | Sierra | Sierra | 91 | 2021-06-21 | 116 | 0 | |
4563 | 4563 | Sierra | Sierra | 91 | 2021-06-20 | 115 | 0 | TRUE |
4624 | 4624 | Sierra | Sierra | 91 | 2021-06-19 | 115 | 0 | TRUE |
4685 | 4685 | Sierra | Sierra | 91 | 2021-06-18 | 115 | 0 | |
4746 | 4746 | Sierra | Sierra | 91 | 2021-06-17 | 113 | 0 | TRUE |
4807 | 4807 | Sierra | Sierra | 91 | 2021-06-16 | 113 | 0 | |
4868 | 4868 | Sierra | Sierra | 91 | 2021-06-15 | 113 | 0 | |
4929 | 4929 | Sierra | Sierra | 91 | 2021-06-14 | 113 | 0 | |
4990 | 4990 | Sierra | Sierra | 91 | 2021-06-13 | 113 | 0 | TRUE |
5051 | 5051 | Sierra | Sierra | 91 | 2021-06-12 | 113 | 0 | TRUE |
5112 | 5112 | Sierra | Sierra | 91 | 2021-06-11 | 113 | 0 | TRUE |
5173 | 5173 | Sierra | Sierra | 91 | 2021-06-10 | 113 | 0 | |
5234 | 5234 | Sierra | Sierra | 91 | 2021-06-09 | 113 | 0 | |
5295 | 5295 | Sierra | Sierra | 91 | 2021-06-08 | 113 | 0 | |
5356 | 5356 | Sierra | Sierra | 91 | 2021-06-07 | 113 | 0 | |
5417 | 5417 | Sierra | Sierra | 91 | 2021-06-06 | 113 | 0 | TRUE |
5478 | 5478 | Sierra | Sierra | 91 | 2021-06-05 | 113 | 0 | TRUE |
5539 | 5539 | Sierra | Sierra | 91 | 2021-06-04 | 113 | 0 | |
5600 | 5600 | Sierra | Sierra | 91 | 2021-06-03 | 113 | 0 | |
5661 | 5661 | Sierra | Sierra | 91 | 2021-06-02 | 113 | 0 | TRUE |
5722 | 5722 | Sierra | Sierra | 91 | 2021-06-01 | 113 | 0 | |
5783 | 5783 | Sierra | Sierra | 91 | 2021-05-31 | 113 | 0 | TRUE |
5844 | 5844 | Sierra | Sierra | 91 | 2021-05-30 | 113 | 0 | |
5905 | 5905 | Sierra | Sierra | 91 | 2021-05-29 | 113 | 0 | TRUE |
5966 | 5966 | Sierra | Sierra | 91 | 2021-05-28 | 113 | 0 | |
6027 | 6027 | Sierra | Sierra | 91 | 2021-05-27 | 112 | 0 | |
6088 | 6088 | Sierra | Sierra | 91 | 2021-05-26 | 112 | 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 );