latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
560 rows where fips = 95 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 |
---|---|---|---|---|---|---|---|---|
6151 | 6151 | Solano | Solano | 95 | 2021-05-25 | 33202 | 234 | |
6212 | 6212 | Solano | Solano | 95 | 2021-05-24 | 33183 | 234 | |
6273 | 6273 | Solano | Solano | 95 | 2021-05-23 | 33122 | 234 | TRUE |
6334 | 6334 | Solano | Solano | 95 | 2021-05-22 | 33122 | 234 | TRUE |
6395 | 6395 | Solano | Solano | 95 | 2021-05-21 | 33122 | 234 | |
6456 | 6456 | Solano | Solano | 95 | 2021-05-20 | 33111 | 234 | |
6517 | 6517 | Solano | Solano | 95 | 2021-05-19 | 33086 | 230 | |
6578 | 6578 | Solano | Solano | 95 | 2021-05-18 | 33026 | 230 | |
6639 | 6639 | Solano | Solano | 95 | 2021-05-17 | 33011 | 224 | |
6700 | 6700 | Solano | Solano | 95 | 2021-05-16 | 32974 | 217 | TRUE |
6761 | 6761 | Solano | Solano | 95 | 2021-05-15 | 32974 | 217 | TRUE |
6822 | 6822 | Solano | Solano | 95 | 2021-05-14 | 32974 | 217 | |
6883 | 6883 | Solano | Solano | 95 | 2021-05-13 | 32953 | 217 | |
6944 | 6944 | Solano | Solano | 95 | 2021-05-12 | 32912 | 216 | |
7005 | 7005 | Solano | Solano | 95 | 2021-05-11 | 32880 | 216 | |
7066 | 7066 | Solano | Solano | 95 | 2021-05-10 | 32864 | 216 | |
7127 | 7127 | Solano | Solano | 95 | 2021-05-09 | 32752 | 216 | |
7188 | 7188 | Solano | Solano | 95 | 2021-05-08 | 32752 | 216 | TRUE |
7249 | 7249 | Solano | Solano | 95 | 2021-05-07 | 32752 | 216 | |
7310 | 7310 | Solano | Solano | 95 | 2021-05-06 | 32698 | 216 | |
7371 | 7371 | Solano | Solano | 95 | 2021-05-05 | 32642 | 216 | |
7432 | 7432 | Solano | Solano | 95 | 2021-05-04 | 32613 | 216 | |
7493 | 7493 | Solano | Solano | 95 | 2021-05-03 | 32588 | 216 | |
7554 | 7554 | Solano | Solano | 95 | 2021-05-02 | 32477 | 215 | |
7615 | 7615 | Solano | Solano | 95 | 2021-05-01 | 32477 | 215 | |
7676 | 7676 | Solano | Solano | 95 | 2021-04-30 | 32477 | 215 | |
7737 | 7737 | Solano | Solano | 95 | 2021-04-29 | 32412 | 215 | |
7798 | 7798 | Solano | Solano | 95 | 2021-04-28 | 32366 | 215 | |
7859 | 7859 | Solano | Solano | 95 | 2021-04-27 | 32345 | 215 | |
7920 | 7920 | Solano | Solano | 95 | 2021-04-26 | 32313 | 215 | |
7981 | 7981 | Solano | Solano | 95 | 2021-04-25 | 32126 | 212 | TRUE |
8042 | 8042 | Solano | Solano | 95 | 2021-04-24 | 32126 | 212 | |
8103 | 8103 | Solano | Solano | 95 | 2021-04-23 | 32126 | 212 | |
8164 | 8164 | Solano | Solano | 95 | 2021-04-22 | 32126 | 212 | |
8225 | 8225 | Solano | Solano | 95 | 2021-04-21 | 32086 | 212 | |
8286 | 8286 | Solano | Solano | 95 | 2021-04-20 | 32047 | 212 | |
8347 | 8347 | Solano | Solano | 95 | 2021-04-19 | 32027 | 212 | |
8408 | 8408 | Solano | Solano | 95 | 2021-04-18 | 31875 | 211 | TRUE |
8469 | 8469 | Solano | Solano | 95 | 2021-04-17 | 31875 | 211 | TRUE |
8530 | 8530 | Solano | Solano | 95 | 2021-04-16 | 31875 | 211 | |
8591 | 8591 | Solano | Solano | 95 | 2021-04-15 | 31804 | 209 | |
8652 | 8652 | Solano | Solano | 95 | 2021-04-14 | 31734 | 209 | |
8713 | 8713 | Solano | Solano | 95 | 2021-04-13 | 31702 | 209 | |
8774 | 8774 | Solano | Solano | 95 | 2021-04-12 | 31673 | 209 | |
8835 | 8835 | Solano | Solano | 95 | 2021-04-11 | 31527 | 203 | TRUE |
8896 | 8896 | Solano | Solano | 95 | 2021-04-10 | 31527 | 203 | TRUE |
8957 | 8957 | Solano | Solano | 95 | 2021-04-09 | 31527 | 203 | |
9018 | 9018 | Solano | Solano | 95 | 2021-04-08 | 31489 | 203 | |
9079 | 9079 | Solano | Solano | 95 | 2021-04-07 | 31462 | 203 | |
9140 | 9140 | Solano | Solano | 95 | 2021-04-06 | 31432 | 203 | |
9201 | 9201 | Solano | Solano | 95 | 2021-04-05 | 31401 | 203 | |
9262 | 9262 | Solano | Solano | 95 | 2021-04-04 | 31301 | 197 | TRUE |
9323 | 9323 | Solano | Solano | 95 | 2021-04-03 | 31301 | 197 | TRUE |
9384 | 9384 | Solano | Solano | 95 | 2021-04-02 | 31301 | 197 | |
9445 | 9445 | Solano | Solano | 95 | 2021-04-01 | 31240 | 197 | |
9506 | 9506 | Solano | Solano | 95 | 2021-03-31 | 31189 | 197 | |
9567 | 9567 | Solano | Solano | 95 | 2021-03-30 | 31165 | 197 | |
9628 | 9628 | Solano | Solano | 95 | 2021-03-29 | 31121 | 197 | |
9689 | 9689 | Solano | Solano | 95 | 2021-03-28 | 31009 | 191 | TRUE |
9750 | 9750 | Solano | Solano | 95 | 2021-03-27 | 31009 | 191 | TRUE |
9811 | 9811 | Solano | Solano | 95 | 2021-03-26 | 31009 | 191 | |
9872 | 9872 | Solano | Solano | 95 | 2021-03-25 | 30951 | 191 | |
9933 | 9933 | Solano | Solano | 95 | 2021-03-24 | 30907 | 187 | |
9994 | 9994 | Solano | Solano | 95 | 2021-03-23 | 30865 | 187 | |
10055 | 10055 | Solano | Solano | 95 | 2021-03-22 | 30834 | 187 | |
10116 | 10116 | Solano | Solano | 95 | 2021-03-21 | 30745 | 181 | TRUE |
10177 | 10177 | Solano | Solano | 95 | 2021-03-20 | 30745 | 181 | TRUE |
10238 | 10238 | Solano | Solano | 95 | 2021-03-19 | 30745 | 181 | |
10299 | 10299 | Solano | Solano | 95 | 2021-03-18 | 30710 | 181 | |
10360 | 10360 | Solano | Solano | 95 | 2021-03-17 | 30670 | 178 | |
10421 | 10421 | Solano | Solano | 95 | 2021-03-16 | 30624 | 177 | |
10482 | 10482 | Solano | Solano | 95 | 2021-03-15 | 30581 | 177 | |
10543 | 10543 | Solano | Solano | 95 | 2021-03-14 | 30517 | 177 | TRUE |
10604 | 10604 | Solano | Solano | 95 | 2021-03-13 | 30517 | 177 | TRUE |
10665 | 10665 | Solano | Solano | 95 | 2021-03-12 | 30517 | 177 | |
10726 | 10726 | Solano | Solano | 95 | 2021-03-11 | 30488 | 177 | |
10787 | 10787 | Solano | Solano | 95 | 2021-03-10 | 30453 | 177 | |
10848 | 10848 | Solano | Solano | 95 | 2021-03-09 | 30425 | 171 | |
10909 | 10909 | Solano | Solano | 95 | 2021-03-08 | 30404 | 167 | |
10970 | 10970 | Solano | Solano | 95 | 2021-03-07 | 30305 | 167 | TRUE |
11031 | 11031 | Solano | Solano | 95 | 2021-03-06 | 30305 | 167 | TRUE |
11092 | 11092 | Solano | Solano | 95 | 2021-03-05 | 30305 | 167 | |
11153 | 11153 | Solano | Solano | 95 | 2021-03-04 | 30262 | 165 | |
11214 | 11214 | Solano | Solano | 95 | 2021-03-03 | 30216 | 165 | |
11275 | 11275 | Solano | Solano | 95 | 2021-03-02 | 30163 | 164 | |
11336 | 11336 | Solano | Solano | 95 | 2021-03-01 | 30115 | 164 | |
11397 | 11397 | Solano | Solano | 95 | 2021-02-28 | 30024 | 164 | TRUE |
11458 | 11458 | Solano | Solano | 95 | 2021-02-27 | 30024 | 164 | TRUE |
11519 | 11519 | Solano | Solano | 95 | 2021-02-26 | 30024 | 164 | |
11580 | 11580 | Solano | Solano | 95 | 2021-02-25 | 29968 | 164 | |
11641 | 11641 | Solano | Solano | 95 | 2021-02-24 | 29925 | 164 | |
11702 | 11702 | Solano | Solano | 95 | 2021-02-23 | 29882 | 160 | |
11763 | 11763 | Solano | Solano | 95 | 2021-02-22 | 29859 | 160 | |
11824 | 11824 | Solano | Solano | 95 | 2021-02-21 | 29766 | 160 | TRUE |
11885 | 11885 | Solano | Solano | 95 | 2021-02-20 | 29766 | 160 | TRUE |
11946 | 11946 | Solano | Solano | 95 | 2021-02-19 | 29766 | 160 | |
12007 | 12007 | Solano | Solano | 95 | 2021-02-18 | 29690 | 156 | |
12068 | 12068 | Solano | Solano | 95 | 2021-02-17 | 29643 | 156 | |
12129 | 12129 | Solano | Solano | 95 | 2021-02-16 | 29580 | 149 | |
12190 | 12190 | Solano | Solano | 95 | 2021-02-15 | 29251 | 140 | TRUE |
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 );