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)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
14548 | 14548 | 2020-12-26 | Solano | 95 | 17330 | 95 | 0 | 0 |
14606 | 14606 | 2020-12-25 | Solano | 95 | 17330 | 95 | 0 | 0 |
14896 | 14896 | 2020-12-20 | Solano | 95 | 15008 | 93 | 0 | 0 |
14954 | 14954 | 2020-12-19 | Solano | 95 | 15008 | 93 | 0 | 0 |
15302 | 15302 | 2020-12-13 | Solano | 95 | 12733 | 91 | 0 | 0 |
15360 | 15360 | 2020-12-12 | Solano | 95 | 12733 | 91 | 0 | 0 |
15708 | 15708 | 2020-12-06 | Solano | 95 | 11413 | 85 | 0 | 0 |
15766 | 15766 | 2020-12-05 | Solano | 95 | 11413 | 85 | 0 | 0 |
16114 | 16114 | 2020-11-29 | Solano | 95 | 10036 | 81 | 0 | 0 |
16172 | 16172 | 2020-11-28 | Solano | 95 | 10036 | 81 | 0 | 0 |
16230 | 16230 | 2020-11-27 | Solano | 95 | 10036 | 81 | 0 | 0 |
16288 | 16288 | 2020-11-26 | Solano | 95 | 10036 | 81 | 0 | 0 |
16520 | 16520 | 2020-11-22 | Solano | 95 | 9349 | 80 | 0 | 0 |
16578 | 16578 | 2020-11-21 | Solano | 95 | 9349 | 80 | 0 | 0 |
16926 | 16926 | 2020-11-15 | Solano | 95 | 8729 | 79 | 0 | 0 |
16984 | 16984 | 2020-11-14 | Solano | 95 | 8729 | 79 | 0 | 0 |
17158 | 17158 | 2020-11-11 | Solano | 95 | 8430 | 79 | 0 | 0 |
17332 | 17332 | 2020-11-08 | Solano | 95 | 8132 | 79 | 0 | 0 |
17390 | 17390 | 2020-11-07 | Solano | 95 | 8132 | 79 | 0 | 0 |
17738 | 17738 | 2020-11-01 | Solano | 95 | 7634 | 76 | 0 | 0 |
17796 | 17796 | 2020-10-31 | Solano | 95 | 7634 | 76 | 0 | 0 |
18144 | 18144 | 2020-10-25 | Solano | 95 | 7286 | 74 | 0 | 0 |
18202 | 18202 | 2020-10-24 | Solano | 95 | 7286 | 74 | 0 | 0 |
18550 | 18550 | 2020-10-18 | Solano | 95 | 7009 | 74 | 0 | 0 |
18608 | 18608 | 2020-10-17 | Solano | 95 | 7009 | 74 | 0 | 0 |
18898 | 18898 | 2020-10-12 | Solano | 95 | 6750 | 74 | 0 | 0 |
18956 | 18956 | 2020-10-11 | Solano | 95 | 6750 | 74 | 0 | 0 |
19014 | 19014 | 2020-10-10 | Solano | 95 | 6750 | 74 | 0 | 0 |
19362 | 19362 | 2020-10-04 | Solano | 95 | 6520 | 71 | 0 | 0 |
19420 | 19420 | 2020-10-03 | Solano | 95 | 6520 | 71 | 0 | 0 |
19768 | 19768 | 2020-09-27 | Solano | 95 | 6309 | 63 | 0 | 0 |
19826 | 19826 | 2020-09-26 | Solano | 95 | 6309 | 63 | 0 | 0 |
20174 | 20174 | 2020-09-20 | Solano | 95 | 6085 | 55 | 0 | 0 |
20232 | 20232 | 2020-09-19 | Solano | 95 | 6085 | 55 | 0 | 0 |
20580 | 20580 | 2020-09-13 | Solano | 95 | 5820 | 48 | 0 | 0 |
20638 | 20638 | 2020-09-12 | Solano | 95 | 5820 | 48 | 0 | 0 |
20928 | 20928 | 2020-09-07 | Solano | 95 | 5671 | 48 | 0 | 0 |
20986 | 20986 | 2020-09-06 | Solano | 95 | 5671 | 48 | 0 | 0 |
21044 | 21044 | 2020-09-05 | Solano | 95 | 5671 | 48 | 0 | 0 |
21392 | 21392 | 2020-08-30 | Solano | 95 | 5388 | 46 | 0 | 0 |
21450 | 21450 | 2020-08-29 | Solano | 95 | 5388 | 46 | 0 | 0 |
21798 | 21798 | 2020-08-23 | Solano | 95 | 5048 | 44 | 0 | 0 |
21856 | 21856 | 2020-08-22 | Solano | 95 | 5048 | 44 | 0 | 0 |
22204 | 22204 | 2020-08-16 | Solano | 95 | 4596 | 41 | 0 | 0 |
22262 | 22262 | 2020-08-15 | Solano | 95 | 4596 | 41 | 0 | 0 |
22610 | 22610 | 2020-08-09 | Solano | 95 | 4029 | 40 | 0 | 0 |
22668 | 22668 | 2020-08-08 | Solano | 95 | 4029 | 40 | 0 | 0 |
23016 | 23016 | 2020-08-02 | Solano | 95 | 3611 | 37 | 0 | 0 |
23074 | 23074 | 2020-08-01 | Solano | 95 | 3611 | 37 | 0 | 0 |
23422 | 23422 | 2020-07-26 | Solano | 95 | 3129 | 35 | 0 | 0 |
23480 | 23480 | 2020-07-25 | Solano | 95 | 3129 | 35 | 0 | 0 |
23828 | 23828 | 2020-07-19 | Solano | 95 | 2554 | 31 | 0 | 0 |
23886 | 23886 | 2020-07-18 | Solano | 95 | 2554 | 31 | 0 | 0 |
24234 | 24234 | 2020-07-12 | Solano | 95 | 2075 | 28 | 0 | 0 |
24292 | 24292 | 2020-07-11 | Solano | 95 | 2075 | 28 | 0 | 0 |
24640 | 24640 | 2020-07-05 | Solano | 95 | 1476 | 25 | 0 | 0 |
24698 | 24698 | 2020-07-04 | Solano | 95 | 1476 | 25 | 0 | 0 |
24756 | 24756 | 2020-07-03 | Solano | 95 | 1476 | 25 | 0 | 0 |
25046 | 25046 | 2020-06-28 | Solano | 95 | 1118 | 23 | 0 | 0 |
25104 | 25104 | 2020-06-27 | Solano | 95 | 1118 | 23 | 0 | 0 |
25452 | 25452 | 2020-06-21 | Solano | 95 | 860 | 23 | 0 | 0 |
25510 | 25510 | 2020-06-20 | Solano | 95 | 860 | 23 | 0 | 0 |
25858 | 25858 | 2020-06-14 | Solano | 95 | 657 | 23 | 0 | 0 |
25916 | 25916 | 2020-06-13 | Solano | 95 | 657 | 23 | 0 | 0 |
26264 | 26264 | 2020-06-07 | Solano | 95 | 566 | 23 | 0 | 0 |
26322 | 26322 | 2020-06-06 | Solano | 95 | 566 | 23 | 0 | 0 |
26670 | 26670 | 2020-05-31 | Solano | 95 | 517 | 22 | 0 | 0 |
26728 | 26728 | 2020-05-30 | Solano | 95 | 517 | 22 | 0 | 0 |
27018 | 27018 | 2020-05-25 | Solano | 95 | 455 | 20 | 0 | 0 |
27076 | 27076 | 2020-05-24 | Solano | 95 | 455 | 20 | 0 | 0 |
27134 | 27134 | 2020-05-23 | Solano | 95 | 455 | 20 | 0 | 0 |
27482 | 27482 | 2020-05-17 | Solano | 95 | 410 | 16 | 0 | 0 |
27540 | 27540 | 2020-05-16 | Solano | 95 | 410 | 16 | 0 | 0 |
27888 | 27888 | 2020-05-10 | Solano | 95 | 351 | 7 | 0 | 0 |
27946 | 27946 | 2020-05-09 | Solano | 95 | 351 | 7 | 0 | 0 |
28294 | 28294 | 2020-05-03 | Solano | 95 | 266 | 5 | 0 | 0 |
28352 | 28352 | 2020-05-02 | Solano | 95 | 266 | 5 | 0 | 0 |
28687 | 28687 | 2020-04-26 | Solano | 95 | 199 | 4 | 0 | 0 |
28740 | 28740 | 2020-04-25 | Solano | 95 | 199 | 4 | 0 | 0 |
29058 | 29058 | 2020-04-19 | Solano | 95 | 169 | 2 | 0 | 0 |
29111 | 29111 | 2020-04-18 | Solano | 95 | 169 | 2 | 0 | 0 |
29429 | 29429 | 2020-04-12 | Solano | 95 | 121 | 2 | 0 | 0 |
29482 | 29482 | 2020-04-11 | Solano | 95 | 121 | 2 | 0 | 0 |
29800 | 29800 | 2020-04-05 | Solano | 95 | 73 | 1 | 0 | 0 |
29852 | 29852 | 2020-04-04 | Solano | 95 | 73 | 1 | 0 | 0 |
30155 | 30155 | 2020-03-29 | Solano | 95 | 34 | 0 | 0 | 0 |
30202 | 30202 | 2020-03-28 | Solano | 95 | 34 | 0 | 0 | 0 |
30249 | 30249 | 2020-03-27 | Solano | 95 | 34 | 0 | 0 | 0 |
30464 | 30464 | 2020-03-22 | Solano | 95 | 14 | 0 | 0 | 0 |
30611 | 30611 | 2020-03-18 | Solano | 95 | 8 | 0 | 0 | 0 |
30645 | 30645 | 2020-03-17 | Solano | 95 | 8 | 0 | 0 | 0 |
30708 | 30708 | 2020-03-15 | Solano | 95 | 6 | 0 | 0 | 0 |
30737 | 30737 | 2020-03-14 | Solano | 95 | 6 | 0 | 0 | 0 |
30765 | 30765 | 2020-03-13 | Solano | 95 | 6 | 0 | 0 | 0 |
30792 | 30792 | 2020-03-12 | Solano | 95 | 6 | 0 | 0 | 0 |
30819 | 30819 | 2020-03-11 | Solano | 95 | 6 | 0 | 0 | 0 |
30845 | 30845 | 2020-03-10 | Solano | 95 | 6 | 0 | 0 | 0 |
30895 | 30895 | 2020-03-08 | Solano | 95 | 3 | 0 | 0 | 0 |
30920 | 30920 | 2020-03-07 | Solano | 95 | 3 | 0 | 0 | 0 |
30944 | 30944 | 2020-03-06 | Solano | 95 | 3 | 0 | 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 );