latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
560 rows where fips = 95 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5848 | 5848 | 2021-05-25 | Solano | 95 | 33202 | 234 | 19 | 0 |
5906 | 5906 | 2021-05-24 | Solano | 95 | 33183 | 234 | 61 | 0 |
5964 | 5964 | 2021-05-23 | Solano | 95 | 33122 | 234 | 0 | 0 |
6022 | 6022 | 2021-05-22 | Solano | 95 | 33122 | 234 | 0 | 0 |
6080 | 6080 | 2021-05-21 | Solano | 95 | 33122 | 234 | 11 | 0 |
6138 | 6138 | 2021-05-20 | Solano | 95 | 33111 | 234 | 25 | 4 |
6196 | 6196 | 2021-05-19 | Solano | 95 | 33086 | 230 | 60 | 0 |
6254 | 6254 | 2021-05-18 | Solano | 95 | 33026 | 230 | 15 | 6 |
6312 | 6312 | 2021-05-17 | Solano | 95 | 33011 | 224 | 37 | 7 |
6370 | 6370 | 2021-05-16 | Solano | 95 | 32974 | 217 | 0 | 0 |
6428 | 6428 | 2021-05-15 | Solano | 95 | 32974 | 217 | 0 | 0 |
6486 | 6486 | 2021-05-14 | Solano | 95 | 32974 | 217 | 21 | 0 |
6544 | 6544 | 2021-05-13 | Solano | 95 | 32953 | 217 | 41 | 1 |
6602 | 6602 | 2021-05-12 | Solano | 95 | 32912 | 216 | 32 | 0 |
6660 | 6660 | 2021-05-11 | Solano | 95 | 32880 | 216 | 16 | 0 |
6718 | 6718 | 2021-05-10 | Solano | 95 | 32864 | 216 | 112 | 0 |
6776 | 6776 | 2021-05-09 | Solano | 95 | 32752 | 216 | 0 | 0 |
6834 | 6834 | 2021-05-08 | Solano | 95 | 32752 | 216 | 0 | 0 |
6892 | 6892 | 2021-05-07 | Solano | 95 | 32752 | 216 | 54 | 0 |
6950 | 6950 | 2021-05-06 | Solano | 95 | 32698 | 216 | 56 | 0 |
7008 | 7008 | 2021-05-05 | Solano | 95 | 32642 | 216 | 29 | 0 |
7066 | 7066 | 2021-05-04 | Solano | 95 | 32613 | 216 | 25 | 0 |
7124 | 7124 | 2021-05-03 | Solano | 95 | 32588 | 216 | 111 | 1 |
7182 | 7182 | 2021-05-02 | Solano | 95 | 32477 | 215 | 0 | 0 |
7240 | 7240 | 2021-05-01 | Solano | 95 | 32477 | 215 | 0 | 0 |
7298 | 7298 | 2021-04-30 | Solano | 95 | 32477 | 215 | 65 | 0 |
7356 | 7356 | 2021-04-29 | Solano | 95 | 32412 | 215 | 46 | 0 |
7414 | 7414 | 2021-04-28 | Solano | 95 | 32366 | 215 | 21 | 0 |
7472 | 7472 | 2021-04-27 | Solano | 95 | 32345 | 215 | 32 | 0 |
7530 | 7530 | 2021-04-26 | Solano | 95 | 32313 | 215 | 187 | 3 |
7588 | 7588 | 2021-04-25 | Solano | 95 | 32126 | 212 | 0 | 0 |
7646 | 7646 | 2021-04-24 | Solano | 95 | 32126 | 212 | 0 | 0 |
7704 | 7704 | 2021-04-23 | Solano | 95 | 32126 | 212 | 0 | 0 |
7762 | 7762 | 2021-04-22 | Solano | 95 | 32126 | 212 | 40 | 0 |
7820 | 7820 | 2021-04-21 | Solano | 95 | 32086 | 212 | 39 | 0 |
7878 | 7878 | 2021-04-20 | Solano | 95 | 32047 | 212 | 20 | 0 |
7936 | 7936 | 2021-04-19 | Solano | 95 | 32027 | 212 | 152 | 1 |
7994 | 7994 | 2021-04-18 | Solano | 95 | 31875 | 211 | 0 | 0 |
8052 | 8052 | 2021-04-17 | Solano | 95 | 31875 | 211 | 0 | 0 |
8110 | 8110 | 2021-04-16 | Solano | 95 | 31875 | 211 | 71 | 2 |
8168 | 8168 | 2021-04-15 | Solano | 95 | 31804 | 209 | 70 | 0 |
8226 | 8226 | 2021-04-14 | Solano | 95 | 31734 | 209 | 32 | 0 |
8284 | 8284 | 2021-04-13 | Solano | 95 | 31702 | 209 | 29 | 0 |
8342 | 8342 | 2021-04-12 | Solano | 95 | 31673 | 209 | 146 | 6 |
8400 | 8400 | 2021-04-11 | Solano | 95 | 31527 | 203 | 0 | 0 |
8458 | 8458 | 2021-04-10 | Solano | 95 | 31527 | 203 | 0 | 0 |
8516 | 8516 | 2021-04-09 | Solano | 95 | 31527 | 203 | 38 | 0 |
8574 | 8574 | 2021-04-08 | Solano | 95 | 31489 | 203 | 27 | 0 |
8632 | 8632 | 2021-04-07 | Solano | 95 | 31462 | 203 | 30 | 0 |
8690 | 8690 | 2021-04-06 | Solano | 95 | 31432 | 203 | 31 | 0 |
8748 | 8748 | 2021-04-05 | Solano | 95 | 31401 | 203 | 100 | 6 |
8806 | 8806 | 2021-04-04 | Solano | 95 | 31301 | 197 | 0 | 0 |
8864 | 8864 | 2021-04-03 | Solano | 95 | 31301 | 197 | 0 | 0 |
8922 | 8922 | 2021-04-02 | Solano | 95 | 31301 | 197 | 61 | 0 |
8980 | 8980 | 2021-04-01 | Solano | 95 | 31240 | 197 | 51 | 0 |
9038 | 9038 | 2021-03-31 | Solano | 95 | 31189 | 197 | 24 | 0 |
9096 | 9096 | 2021-03-30 | Solano | 95 | 31165 | 197 | 44 | 0 |
9154 | 9154 | 2021-03-29 | Solano | 95 | 31121 | 197 | 112 | 6 |
9212 | 9212 | 2021-03-28 | Solano | 95 | 31009 | 191 | 0 | 0 |
9270 | 9270 | 2021-03-27 | Solano | 95 | 31009 | 191 | 0 | 0 |
9328 | 9328 | 2021-03-26 | Solano | 95 | 31009 | 191 | 58 | 0 |
9386 | 9386 | 2021-03-25 | Solano | 95 | 30951 | 191 | 44 | 4 |
9444 | 9444 | 2021-03-24 | Solano | 95 | 30907 | 187 | 42 | 0 |
9502 | 9502 | 2021-03-23 | Solano | 95 | 30865 | 187 | 31 | 0 |
9560 | 9560 | 2021-03-22 | Solano | 95 | 30834 | 187 | 89 | 6 |
9618 | 9618 | 2021-03-21 | Solano | 95 | 30745 | 181 | 0 | 0 |
9676 | 9676 | 2021-03-20 | Solano | 95 | 30745 | 181 | 0 | 0 |
9734 | 9734 | 2021-03-19 | Solano | 95 | 30745 | 181 | 35 | 0 |
9792 | 9792 | 2021-03-18 | Solano | 95 | 30710 | 181 | 40 | 3 |
9850 | 9850 | 2021-03-17 | Solano | 95 | 30670 | 178 | 46 | 1 |
9908 | 9908 | 2021-03-16 | Solano | 95 | 30624 | 177 | 43 | 0 |
9966 | 9966 | 2021-03-15 | Solano | 95 | 30581 | 177 | 64 | 0 |
10024 | 10024 | 2021-03-14 | Solano | 95 | 30517 | 177 | 0 | 0 |
10082 | 10082 | 2021-03-13 | Solano | 95 | 30517 | 177 | 0 | 0 |
10140 | 10140 | 2021-03-12 | Solano | 95 | 30517 | 177 | 29 | 0 |
10198 | 10198 | 2021-03-11 | Solano | 95 | 30488 | 177 | 35 | 0 |
10256 | 10256 | 2021-03-10 | Solano | 95 | 30453 | 177 | 28 | 6 |
10314 | 10314 | 2021-03-09 | Solano | 95 | 30425 | 171 | 21 | 4 |
10372 | 10372 | 2021-03-08 | Solano | 95 | 30404 | 167 | 99 | 0 |
10430 | 10430 | 2021-03-07 | Solano | 95 | 30305 | 167 | 0 | 0 |
10488 | 10488 | 2021-03-06 | Solano | 95 | 30305 | 167 | 0 | 0 |
10546 | 10546 | 2021-03-05 | Solano | 95 | 30305 | 167 | 43 | 2 |
10604 | 10604 | 2021-03-04 | Solano | 95 | 30262 | 165 | 46 | 0 |
10662 | 10662 | 2021-03-03 | Solano | 95 | 30216 | 165 | 53 | 1 |
10720 | 10720 | 2021-03-02 | Solano | 95 | 30163 | 164 | 48 | 0 |
10778 | 10778 | 2021-03-01 | Solano | 95 | 30115 | 164 | 91 | 0 |
10836 | 10836 | 2021-02-28 | Solano | 95 | 30024 | 164 | 0 | 0 |
10894 | 10894 | 2021-02-27 | Solano | 95 | 30024 | 164 | 0 | 0 |
10952 | 10952 | 2021-02-26 | Solano | 95 | 30024 | 164 | 56 | 0 |
11010 | 11010 | 2021-02-25 | Solano | 95 | 29968 | 164 | 43 | 0 |
11068 | 11068 | 2021-02-24 | Solano | 95 | 29925 | 164 | 43 | 4 |
11126 | 11126 | 2021-02-23 | Solano | 95 | 29882 | 160 | 23 | 0 |
11184 | 11184 | 2021-02-22 | Solano | 95 | 29859 | 160 | 93 | 0 |
11242 | 11242 | 2021-02-21 | Solano | 95 | 29766 | 160 | 0 | 0 |
11300 | 11300 | 2021-02-20 | Solano | 95 | 29766 | 160 | 0 | 0 |
11358 | 11358 | 2021-02-19 | Solano | 95 | 29766 | 160 | 76 | 4 |
11416 | 11416 | 2021-02-18 | Solano | 95 | 29690 | 156 | 47 | 0 |
11474 | 11474 | 2021-02-17 | Solano | 95 | 29643 | 156 | 63 | 7 |
11532 | 11532 | 2021-02-16 | Solano | 95 | 29580 | 149 | 329 | 9 |
11590 | 11590 | 2021-02-15 | Solano | 95 | 29251 | 140 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );