latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
492 rows where county = "Sierra" 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 |
---|---|---|---|---|---|---|---|---|
18084 | 18084 | 2020-10-26 | Sierra | 91 | 6 | 0 | 0 | 0 |
18142 | 18142 | 2020-10-25 | Sierra | 91 | 6 | 0 | 0 | 0 |
18200 | 18200 | 2020-10-24 | Sierra | 91 | 6 | 0 | 0 | 0 |
18258 | 18258 | 2020-10-23 | Sierra | 91 | 6 | 0 | 0 | 0 |
18316 | 18316 | 2020-10-22 | Sierra | 91 | 6 | 0 | 0 | 0 |
18374 | 18374 | 2020-10-21 | Sierra | 91 | 6 | 0 | 0 | 0 |
18432 | 18432 | 2020-10-20 | Sierra | 91 | 6 | 0 | 0 | 0 |
18490 | 18490 | 2020-10-19 | Sierra | 91 | 6 | 0 | 0 | 0 |
18548 | 18548 | 2020-10-18 | Sierra | 91 | 6 | 0 | 0 | 0 |
18606 | 18606 | 2020-10-17 | Sierra | 91 | 6 | 0 | 0 | 0 |
18664 | 18664 | 2020-10-16 | Sierra | 91 | 6 | 0 | 0 | 0 |
18722 | 18722 | 2020-10-15 | Sierra | 91 | 6 | 0 | 0 | 0 |
18780 | 18780 | 2020-10-14 | Sierra | 91 | 6 | 0 | 0 | 0 |
18838 | 18838 | 2020-10-13 | Sierra | 91 | 6 | 0 | 0 | 0 |
18896 | 18896 | 2020-10-12 | Sierra | 91 | 6 | 0 | 0 | 0 |
18954 | 18954 | 2020-10-11 | Sierra | 91 | 6 | 0 | 0 | 0 |
19012 | 19012 | 2020-10-10 | Sierra | 91 | 6 | 0 | 0 | 0 |
19070 | 19070 | 2020-10-09 | Sierra | 91 | 6 | 0 | 0 | 0 |
19128 | 19128 | 2020-10-08 | Sierra | 91 | 6 | 0 | 0 | 0 |
19186 | 19186 | 2020-10-07 | Sierra | 91 | 6 | 0 | 0 | 0 |
19244 | 19244 | 2020-10-06 | Sierra | 91 | 6 | 0 | 0 | 0 |
19302 | 19302 | 2020-10-05 | Sierra | 91 | 6 | 0 | 0 | 0 |
19360 | 19360 | 2020-10-04 | Sierra | 91 | 6 | 0 | 0 | 0 |
19418 | 19418 | 2020-10-03 | Sierra | 91 | 6 | 0 | 0 | 0 |
19476 | 19476 | 2020-10-02 | Sierra | 91 | 6 | 0 | 0 | 0 |
19534 | 19534 | 2020-10-01 | Sierra | 91 | 6 | 0 | 0 | 0 |
19592 | 19592 | 2020-09-30 | Sierra | 91 | 6 | 0 | 0 | 0 |
19650 | 19650 | 2020-09-29 | Sierra | 91 | 6 | 0 | 0 | 0 |
19708 | 19708 | 2020-09-28 | Sierra | 91 | 6 | 0 | 0 | 0 |
19766 | 19766 | 2020-09-27 | Sierra | 91 | 6 | 0 | 0 | 0 |
19824 | 19824 | 2020-09-26 | Sierra | 91 | 6 | 0 | 0 | 0 |
19882 | 19882 | 2020-09-25 | Sierra | 91 | 6 | 0 | 0 | 0 |
19940 | 19940 | 2020-09-24 | Sierra | 91 | 6 | 0 | 0 | 0 |
19998 | 19998 | 2020-09-23 | Sierra | 91 | 6 | 0 | 0 | 0 |
20056 | 20056 | 2020-09-22 | Sierra | 91 | 6 | 0 | 0 | 0 |
20114 | 20114 | 2020-09-21 | Sierra | 91 | 6 | 0 | 0 | 0 |
20172 | 20172 | 2020-09-20 | Sierra | 91 | 6 | 0 | 0 | 0 |
20230 | 20230 | 2020-09-19 | Sierra | 91 | 6 | 0 | 0 | 0 |
20288 | 20288 | 2020-09-18 | Sierra | 91 | 6 | 0 | 0 | 0 |
20346 | 20346 | 2020-09-17 | Sierra | 91 | 6 | 0 | 0 | 0 |
20404 | 20404 | 2020-09-16 | Sierra | 91 | 6 | 0 | 0 | 0 |
20462 | 20462 | 2020-09-15 | Sierra | 91 | 6 | 0 | 0 | 0 |
20520 | 20520 | 2020-09-14 | Sierra | 91 | 6 | 0 | 0 | 0 |
20578 | 20578 | 2020-09-13 | Sierra | 91 | 6 | 0 | 0 | 0 |
20636 | 20636 | 2020-09-12 | Sierra | 91 | 6 | 0 | 0 | 0 |
20694 | 20694 | 2020-09-11 | Sierra | 91 | 6 | 0 | 0 | 0 |
20752 | 20752 | 2020-09-10 | Sierra | 91 | 6 | 0 | 0 | 0 |
20810 | 20810 | 2020-09-09 | Sierra | 91 | 6 | 0 | 0 | 0 |
20868 | 20868 | 2020-09-08 | Sierra | 91 | 6 | 0 | 0 | 0 |
20926 | 20926 | 2020-09-07 | Sierra | 91 | 6 | 0 | 0 | 0 |
20984 | 20984 | 2020-09-06 | Sierra | 91 | 6 | 0 | 0 | 0 |
21042 | 21042 | 2020-09-05 | Sierra | 91 | 6 | 0 | 0 | 0 |
21100 | 21100 | 2020-09-04 | Sierra | 91 | 6 | 0 | 0 | 0 |
21158 | 21158 | 2020-09-03 | Sierra | 91 | 6 | 0 | 0 | 0 |
21216 | 21216 | 2020-09-02 | Sierra | 91 | 6 | 0 | 0 | 0 |
21274 | 21274 | 2020-09-01 | Sierra | 91 | 6 | 0 | 0 | 0 |
21332 | 21332 | 2020-08-31 | Sierra | 91 | 6 | 0 | 0 | 0 |
21390 | 21390 | 2020-08-30 | Sierra | 91 | 6 | 0 | 0 | 0 |
21448 | 21448 | 2020-08-29 | Sierra | 91 | 6 | 0 | 0 | 0 |
21506 | 21506 | 2020-08-28 | Sierra | 91 | 6 | 0 | 0 | 0 |
21564 | 21564 | 2020-08-27 | Sierra | 91 | 6 | 0 | 0 | 0 |
21622 | 21622 | 2020-08-26 | Sierra | 91 | 6 | 0 | 0 | 0 |
21680 | 21680 | 2020-08-25 | Sierra | 91 | 6 | 0 | 0 | 0 |
21738 | 21738 | 2020-08-24 | Sierra | 91 | 6 | 0 | 0 | 0 |
21796 | 21796 | 2020-08-23 | Sierra | 91 | 6 | 0 | 0 | 0 |
21854 | 21854 | 2020-08-22 | Sierra | 91 | 6 | 0 | 0 | 0 |
21912 | 21912 | 2020-08-21 | Sierra | 91 | 6 | 0 | 0 | 0 |
21970 | 21970 | 2020-08-20 | Sierra | 91 | 6 | 0 | 0 | 0 |
22028 | 22028 | 2020-08-19 | Sierra | 91 | 6 | 0 | 0 | 0 |
22086 | 22086 | 2020-08-18 | Sierra | 91 | 6 | 0 | 0 | 0 |
22144 | 22144 | 2020-08-17 | Sierra | 91 | 6 | 0 | 0 | 0 |
22202 | 22202 | 2020-08-16 | Sierra | 91 | 6 | 0 | 0 | 0 |
22260 | 22260 | 2020-08-15 | Sierra | 91 | 6 | 0 | 0 | 0 |
22318 | 22318 | 2020-08-14 | Sierra | 91 | 6 | 0 | 1 | 0 |
22376 | 22376 | 2020-08-13 | Sierra | 91 | 5 | 0 | 0 | 0 |
22434 | 22434 | 2020-08-12 | Sierra | 91 | 5 | 0 | 0 | 0 |
22492 | 22492 | 2020-08-11 | Sierra | 91 | 5 | 0 | 1 | 0 |
22550 | 22550 | 2020-08-10 | Sierra | 91 | 4 | 0 | 1 | 0 |
22608 | 22608 | 2020-08-09 | Sierra | 91 | 3 | 0 | 0 | 0 |
22666 | 22666 | 2020-08-08 | Sierra | 91 | 3 | 0 | 0 | 0 |
22724 | 22724 | 2020-08-07 | Sierra | 91 | 3 | 0 | 0 | 0 |
22782 | 22782 | 2020-08-06 | Sierra | 91 | 3 | 0 | 0 | 0 |
22840 | 22840 | 2020-08-05 | Sierra | 91 | 3 | 0 | 0 | 0 |
22898 | 22898 | 2020-08-04 | Sierra | 91 | 3 | 0 | 1 | 0 |
22956 | 22956 | 2020-08-03 | Sierra | 91 | 2 | 0 | 0 | 0 |
23014 | 23014 | 2020-08-02 | Sierra | 91 | 2 | 0 | 0 | 0 |
23072 | 23072 | 2020-08-01 | Sierra | 91 | 2 | 0 | 0 | 0 |
23130 | 23130 | 2020-07-31 | Sierra | 91 | 2 | 0 | 0 | 0 |
23188 | 23188 | 2020-07-30 | Sierra | 91 | 2 | 0 | 0 | 0 |
23246 | 23246 | 2020-07-29 | Sierra | 91 | 2 | 0 | 0 | 0 |
23304 | 23304 | 2020-07-28 | Sierra | 91 | 2 | 0 | 0 | 0 |
23362 | 23362 | 2020-07-27 | Sierra | 91 | 2 | 0 | 1 | 0 |
23420 | 23420 | 2020-07-26 | Sierra | 91 | 1 | 0 | 0 | 0 |
23478 | 23478 | 2020-07-25 | Sierra | 91 | 1 | 0 | 0 | 0 |
23536 | 23536 | 2020-07-24 | Sierra | 91 | 1 | 0 | 0 | 0 |
23594 | 23594 | 2020-07-23 | Sierra | 91 | 1 | 0 | 0 | 0 |
23652 | 23652 | 2020-07-22 | Sierra | 91 | 1 | 0 | 0 | 0 |
23710 | 23710 | 2020-07-21 | Sierra | 91 | 1 | 0 | 0 | 0 |
23768 | 23768 | 2020-07-20 | Sierra | 91 | 1 | 0 | 0 | 0 |
23826 | 23826 | 2020-07-19 | Sierra | 91 | 1 | 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 );