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 new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
48 | 48 | 2021-09-02 | Solano | 95 | 41521 | 273 | 0 | 0 |
164 | 164 | 2021-08-31 | Solano | 95 | 40477 | 270 | 0 | 0 |
280 | 280 | 2021-08-29 | Solano | 95 | 39800 | 266 | 0 | 0 |
338 | 338 | 2021-08-28 | Solano | 95 | 39800 | 266 | 0 | 0 |
454 | 454 | 2021-08-26 | Solano | 95 | 39329 | 266 | 0 | 0 |
570 | 570 | 2021-08-24 | Solano | 95 | 39002 | 264 | 0 | 0 |
686 | 686 | 2021-08-22 | Solano | 95 | 38764 | 262 | 0 | 0 |
744 | 744 | 2021-08-21 | Solano | 95 | 38764 | 262 | 0 | 0 |
860 | 860 | 2021-08-19 | Solano | 95 | 38294 | 259 | 0 | 0 |
976 | 976 | 2021-08-17 | Solano | 95 | 37914 | 259 | 0 | 0 |
1092 | 1092 | 2021-08-15 | Solano | 95 | 37664 | 254 | 0 | 0 |
1150 | 1150 | 2021-08-14 | Solano | 95 | 37664 | 254 | 0 | 0 |
1266 | 1266 | 2021-08-12 | Solano | 95 | 37350 | 254 | 0 | 0 |
1382 | 1382 | 2021-08-10 | Solano | 95 | 37056 | 254 | 0 | 0 |
1498 | 1498 | 2021-08-08 | Solano | 95 | 36848 | 249 | 0 | 0 |
1556 | 1556 | 2021-08-07 | Solano | 95 | 36848 | 249 | 0 | 0 |
1672 | 1672 | 2021-08-05 | Solano | 95 | 36525 | 249 | 0 | 0 |
1788 | 1788 | 2021-08-03 | Solano | 95 | 36249 | 249 | 0 | 0 |
1904 | 1904 | 2021-08-01 | Solano | 95 | 36004 | 249 | 0 | 0 |
1962 | 1962 | 2021-07-31 | Solano | 95 | 36004 | 249 | 0 | 0 |
2078 | 2078 | 2021-07-29 | Solano | 95 | 35703 | 249 | 0 | 0 |
2194 | 2194 | 2021-07-27 | Solano | 95 | 35482 | 245 | 0 | 0 |
2310 | 2310 | 2021-07-25 | Solano | 95 | 35193 | 245 | 0 | 0 |
2368 | 2368 | 2021-07-24 | Solano | 95 | 35193 | 245 | 0 | 0 |
2484 | 2484 | 2021-07-22 | Solano | 95 | 34885 | 245 | 0 | 0 |
2600 | 2600 | 2021-07-20 | Solano | 95 | 34761 | 245 | 0 | 0 |
2716 | 2716 | 2021-07-18 | Solano | 95 | 34630 | 245 | 0 | 0 |
2774 | 2774 | 2021-07-17 | Solano | 95 | 34630 | 245 | 0 | 0 |
2890 | 2890 | 2021-07-15 | Solano | 95 | 34461 | 245 | 0 | 0 |
3006 | 3006 | 2021-07-13 | Solano | 95 | 34377 | 245 | 0 | 0 |
3122 | 3122 | 2021-07-11 | Solano | 95 | 34240 | 245 | 0 | 0 |
3238 | 3238 | 2021-07-09 | Solano | 95 | 34149 | 245 | 0 | 0 |
3296 | 3296 | 2021-07-08 | Solano | 95 | 34149 | 245 | 0 | 0 |
3412 | 3412 | 2021-07-06 | Solano | 95 | 34044 | 244 | 0 | 0 |
3470 | 3470 | 2021-07-05 | Solano | 95 | 34044 | 244 | 0 | 0 |
3528 | 3528 | 2021-07-04 | Solano | 95 | 34044 | 244 | 0 | 0 |
3586 | 3586 | 2021-07-03 | Solano | 95 | 34044 | 244 | 0 | 0 |
3702 | 3702 | 2021-07-01 | Solano | 95 | 33973 | 244 | 0 | 0 |
3818 | 3818 | 2021-06-29 | Solano | 95 | 33898 | 244 | 0 | 0 |
3934 | 3934 | 2021-06-27 | Solano | 95 | 33846 | 244 | 0 | 0 |
3992 | 3992 | 2021-06-26 | Solano | 95 | 33846 | 244 | 0 | 0 |
4108 | 4108 | 2021-06-24 | Solano | 95 | 33797 | 244 | 0 | 0 |
4224 | 4224 | 2021-06-22 | Solano | 95 | 33762 | 244 | 0 | 0 |
4340 | 4340 | 2021-06-20 | Solano | 95 | 33707 | 244 | 0 | 0 |
4398 | 4398 | 2021-06-19 | Solano | 95 | 33707 | 244 | 0 | 0 |
4746 | 4746 | 2021-06-13 | Solano | 95 | 33569 | 244 | 0 | 0 |
4804 | 4804 | 2021-06-12 | Solano | 95 | 33569 | 244 | 0 | 0 |
5152 | 5152 | 2021-06-06 | Solano | 95 | 33491 | 244 | 0 | 0 |
5210 | 5210 | 2021-06-05 | Solano | 95 | 33491 | 244 | 0 | 0 |
5500 | 5500 | 2021-05-31 | Solano | 95 | 33293 | 238 | 0 | 0 |
5558 | 5558 | 2021-05-30 | Solano | 95 | 33293 | 238 | 0 | 0 |
5616 | 5616 | 2021-05-29 | Solano | 95 | 33293 | 238 | 0 | 0 |
5964 | 5964 | 2021-05-23 | Solano | 95 | 33122 | 234 | 0 | 0 |
6022 | 6022 | 2021-05-22 | Solano | 95 | 33122 | 234 | 0 | 0 |
6370 | 6370 | 2021-05-16 | Solano | 95 | 32974 | 217 | 0 | 0 |
6428 | 6428 | 2021-05-15 | Solano | 95 | 32974 | 217 | 0 | 0 |
6776 | 6776 | 2021-05-09 | Solano | 95 | 32752 | 216 | 0 | 0 |
6834 | 6834 | 2021-05-08 | Solano | 95 | 32752 | 216 | 0 | 0 |
7182 | 7182 | 2021-05-02 | Solano | 95 | 32477 | 215 | 0 | 0 |
7240 | 7240 | 2021-05-01 | Solano | 95 | 32477 | 215 | 0 | 0 |
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 |
7994 | 7994 | 2021-04-18 | Solano | 95 | 31875 | 211 | 0 | 0 |
8052 | 8052 | 2021-04-17 | Solano | 95 | 31875 | 211 | 0 | 0 |
8400 | 8400 | 2021-04-11 | Solano | 95 | 31527 | 203 | 0 | 0 |
8458 | 8458 | 2021-04-10 | Solano | 95 | 31527 | 203 | 0 | 0 |
8806 | 8806 | 2021-04-04 | Solano | 95 | 31301 | 197 | 0 | 0 |
8864 | 8864 | 2021-04-03 | Solano | 95 | 31301 | 197 | 0 | 0 |
9212 | 9212 | 2021-03-28 | Solano | 95 | 31009 | 191 | 0 | 0 |
9270 | 9270 | 2021-03-27 | Solano | 95 | 31009 | 191 | 0 | 0 |
9618 | 9618 | 2021-03-21 | Solano | 95 | 30745 | 181 | 0 | 0 |
9676 | 9676 | 2021-03-20 | Solano | 95 | 30745 | 181 | 0 | 0 |
10024 | 10024 | 2021-03-14 | Solano | 95 | 30517 | 177 | 0 | 0 |
10082 | 10082 | 2021-03-13 | Solano | 95 | 30517 | 177 | 0 | 0 |
10430 | 10430 | 2021-03-07 | Solano | 95 | 30305 | 167 | 0 | 0 |
10488 | 10488 | 2021-03-06 | Solano | 95 | 30305 | 167 | 0 | 0 |
10836 | 10836 | 2021-02-28 | Solano | 95 | 30024 | 164 | 0 | 0 |
10894 | 10894 | 2021-02-27 | Solano | 95 | 30024 | 164 | 0 | 0 |
11242 | 11242 | 2021-02-21 | Solano | 95 | 29766 | 160 | 0 | 0 |
11300 | 11300 | 2021-02-20 | Solano | 95 | 29766 | 160 | 0 | 0 |
11590 | 11590 | 2021-02-15 | Solano | 95 | 29251 | 140 | 0 | 0 |
11648 | 11648 | 2021-02-14 | Solano | 95 | 29251 | 140 | 0 | 0 |
11706 | 11706 | 2021-02-13 | Solano | 95 | 29251 | 140 | 0 | 0 |
11764 | 11764 | 2021-02-12 | Solano | 95 | 29251 | 140 | 0 | 0 |
12054 | 12054 | 2021-02-07 | Solano | 95 | 28686 | 134 | 0 | 0 |
12112 | 12112 | 2021-02-06 | Solano | 95 | 28686 | 134 | 0 | 0 |
12460 | 12460 | 2021-01-31 | Solano | 95 | 27706 | 122 | 0 | 0 |
12518 | 12518 | 2021-01-30 | Solano | 95 | 27706 | 122 | 0 | 0 |
12866 | 12866 | 2021-01-24 | Solano | 95 | 26494 | 111 | 0 | 0 |
12924 | 12924 | 2021-01-23 | Solano | 95 | 26494 | 111 | 0 | 0 |
13214 | 13214 | 2021-01-18 | Solano | 95 | 24654 | 105 | 0 | 0 |
13272 | 13272 | 2021-01-17 | Solano | 95 | 24654 | 105 | 0 | 0 |
13330 | 13330 | 2021-01-16 | Solano | 95 | 24654 | 105 | 0 | 0 |
13678 | 13678 | 2021-01-10 | Solano | 95 | 22232 | 102 | 0 | 0 |
13736 | 13736 | 2021-01-09 | Solano | 95 | 22232 | 102 | 0 | 0 |
14084 | 14084 | 2021-01-03 | Solano | 95 | 19211 | 98 | 0 | 0 |
14142 | 14142 | 2021-01-02 | Solano | 95 | 19211 | 98 | 0 | 0 |
14200 | 14200 | 2021-01-01 | Solano | 95 | 19211 | 98 | 0 | 0 |
14490 | 14490 | 2020-12-27 | Solano | 95 | 17330 | 95 | 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 );