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", deaths = 0 and fips = 91 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
46 | 46 | 2021-09-02 | Sierra | 91 | 198 | 0 | 7 | 0 |
104 | 104 | 2021-09-01 | Sierra | 91 | 191 | 0 | 3 | 0 |
162 | 162 | 2021-08-31 | Sierra | 91 | 188 | 0 | 0 | 0 |
220 | 220 | 2021-08-30 | Sierra | 91 | 188 | 0 | 0 | 0 |
278 | 278 | 2021-08-29 | Sierra | 91 | 188 | 0 | 0 | 0 |
336 | 336 | 2021-08-28 | Sierra | 91 | 188 | 0 | 0 | 0 |
394 | 394 | 2021-08-27 | Sierra | 91 | 188 | 0 | 0 | 0 |
452 | 452 | 2021-08-26 | Sierra | 91 | 188 | 0 | 13 | 0 |
510 | 510 | 2021-08-25 | Sierra | 91 | 175 | 0 | 1 | 0 |
568 | 568 | 2021-08-24 | Sierra | 91 | 174 | 0 | 0 | 0 |
626 | 626 | 2021-08-23 | Sierra | 91 | 174 | 0 | 14 | 0 |
684 | 684 | 2021-08-22 | Sierra | 91 | 160 | 0 | 0 | 0 |
742 | 742 | 2021-08-21 | Sierra | 91 | 160 | 0 | 0 | 0 |
800 | 800 | 2021-08-20 | Sierra | 91 | 160 | 0 | 2 | 0 |
858 | 858 | 2021-08-19 | Sierra | 91 | 158 | 0 | 4 | 0 |
916 | 916 | 2021-08-18 | Sierra | 91 | 154 | 0 | 0 | 0 |
974 | 974 | 2021-08-17 | Sierra | 91 | 154 | 0 | 2 | 0 |
1032 | 1032 | 2021-08-16 | Sierra | 91 | 152 | 0 | 2 | 0 |
1090 | 1090 | 2021-08-15 | Sierra | 91 | 150 | 0 | 0 | 0 |
1148 | 1148 | 2021-08-14 | Sierra | 91 | 150 | 0 | 0 | 0 |
1206 | 1206 | 2021-08-13 | Sierra | 91 | 150 | 0 | 0 | 0 |
1264 | 1264 | 2021-08-12 | Sierra | 91 | 150 | 0 | 4 | 0 |
1322 | 1322 | 2021-08-11 | Sierra | 91 | 146 | 0 | 3 | 0 |
1380 | 1380 | 2021-08-10 | Sierra | 91 | 143 | 0 | 3 | 0 |
1438 | 1438 | 2021-08-09 | Sierra | 91 | 140 | 0 | 2 | 0 |
1496 | 1496 | 2021-08-08 | Sierra | 91 | 138 | 0 | 0 | 0 |
1554 | 1554 | 2021-08-07 | Sierra | 91 | 138 | 0 | 0 | 0 |
1612 | 1612 | 2021-08-06 | Sierra | 91 | 138 | 0 | 0 | 0 |
1670 | 1670 | 2021-08-05 | Sierra | 91 | 138 | 0 | 1 | 0 |
1728 | 1728 | 2021-08-04 | Sierra | 91 | 137 | 0 | 0 | 0 |
1786 | 1786 | 2021-08-03 | Sierra | 91 | 137 | 0 | 4 | 0 |
1844 | 1844 | 2021-08-02 | Sierra | 91 | 133 | 0 | 2 | 0 |
1902 | 1902 | 2021-08-01 | Sierra | 91 | 131 | 0 | 0 | 0 |
1960 | 1960 | 2021-07-31 | Sierra | 91 | 131 | 0 | 0 | 0 |
2018 | 2018 | 2021-07-30 | Sierra | 91 | 131 | 0 | 2 | 0 |
2076 | 2076 | 2021-07-29 | Sierra | 91 | 129 | 0 | 3 | 0 |
2134 | 2134 | 2021-07-28 | Sierra | 91 | 126 | 0 | 0 | 0 |
2192 | 2192 | 2021-07-27 | Sierra | 91 | 126 | 0 | 0 | 0 |
2250 | 2250 | 2021-07-26 | Sierra | 91 | 126 | 0 | 1 | 0 |
2308 | 2308 | 2021-07-25 | Sierra | 91 | 125 | 0 | 0 | 0 |
2366 | 2366 | 2021-07-24 | Sierra | 91 | 125 | 0 | 0 | 0 |
2424 | 2424 | 2021-07-23 | Sierra | 91 | 125 | 0 | 1 | 0 |
2482 | 2482 | 2021-07-22 | Sierra | 91 | 124 | 0 | 0 | 0 |
2540 | 2540 | 2021-07-21 | Sierra | 91 | 124 | 0 | 0 | 0 |
2598 | 2598 | 2021-07-20 | Sierra | 91 | 124 | 0 | 0 | 0 |
2656 | 2656 | 2021-07-19 | Sierra | 91 | 124 | 0 | 0 | 0 |
2714 | 2714 | 2021-07-18 | Sierra | 91 | 124 | 0 | 0 | 0 |
2772 | 2772 | 2021-07-17 | Sierra | 91 | 124 | 0 | 0 | 0 |
2830 | 2830 | 2021-07-16 | Sierra | 91 | 124 | 0 | 0 | 0 |
2888 | 2888 | 2021-07-15 | Sierra | 91 | 124 | 0 | 1 | 0 |
2946 | 2946 | 2021-07-14 | Sierra | 91 | 123 | 0 | 0 | 0 |
3004 | 3004 | 2021-07-13 | Sierra | 91 | 123 | 0 | 1 | 0 |
3062 | 3062 | 2021-07-12 | Sierra | 91 | 122 | 0 | 0 | 0 |
3120 | 3120 | 2021-07-11 | Sierra | 91 | 122 | 0 | 0 | 0 |
3178 | 3178 | 2021-07-10 | Sierra | 91 | 122 | 0 | 0 | 0 |
3236 | 3236 | 2021-07-09 | Sierra | 91 | 122 | 0 | 0 | 0 |
3294 | 3294 | 2021-07-08 | Sierra | 91 | 122 | 0 | 0 | 0 |
3352 | 3352 | 2021-07-07 | Sierra | 91 | 122 | 0 | 0 | 0 |
3410 | 3410 | 2021-07-06 | Sierra | 91 | 122 | 0 | 0 | 0 |
3468 | 3468 | 2021-07-05 | Sierra | 91 | 122 | 0 | 0 | 0 |
3526 | 3526 | 2021-07-04 | Sierra | 91 | 122 | 0 | 0 | 0 |
3584 | 3584 | 2021-07-03 | Sierra | 91 | 122 | 0 | 0 | 0 |
3642 | 3642 | 2021-07-02 | Sierra | 91 | 122 | 0 | 0 | 0 |
3700 | 3700 | 2021-07-01 | Sierra | 91 | 122 | 0 | 0 | 0 |
3758 | 3758 | 2021-06-30 | Sierra | 91 | 122 | 0 | 0 | 0 |
3816 | 3816 | 2021-06-29 | Sierra | 91 | 122 | 0 | 0 | 0 |
3874 | 3874 | 2021-06-28 | Sierra | 91 | 122 | 0 | 4 | 0 |
3932 | 3932 | 2021-06-27 | Sierra | 91 | 118 | 0 | 0 | 0 |
3990 | 3990 | 2021-06-26 | Sierra | 91 | 118 | 0 | 0 | 0 |
4048 | 4048 | 2021-06-25 | Sierra | 91 | 118 | 0 | 0 | 0 |
4106 | 4106 | 2021-06-24 | Sierra | 91 | 118 | 0 | 1 | 0 |
4164 | 4164 | 2021-06-23 | Sierra | 91 | 117 | 0 | 0 | 0 |
4222 | 4222 | 2021-06-22 | Sierra | 91 | 117 | 0 | 1 | 0 |
4280 | 4280 | 2021-06-21 | Sierra | 91 | 116 | 0 | 1 | 0 |
4338 | 4338 | 2021-06-20 | Sierra | 91 | 115 | 0 | 0 | 0 |
4396 | 4396 | 2021-06-19 | Sierra | 91 | 115 | 0 | 0 | 0 |
4454 | 4454 | 2021-06-18 | Sierra | 91 | 115 | 0 | 2 | 0 |
4512 | 4512 | 2021-06-17 | Sierra | 91 | 113 | 0 | 0 | 0 |
4570 | 4570 | 2021-06-16 | Sierra | 91 | 113 | 0 | 0 | 0 |
4628 | 4628 | 2021-06-15 | Sierra | 91 | 113 | 0 | 0 | 0 |
4686 | 4686 | 2021-06-14 | Sierra | 91 | 113 | 0 | 0 | 0 |
4744 | 4744 | 2021-06-13 | Sierra | 91 | 113 | 0 | 0 | 0 |
4802 | 4802 | 2021-06-12 | Sierra | 91 | 113 | 0 | 0 | 0 |
4860 | 4860 | 2021-06-11 | Sierra | 91 | 113 | 0 | 0 | 0 |
4918 | 4918 | 2021-06-10 | Sierra | 91 | 113 | 0 | 0 | 0 |
4976 | 4976 | 2021-06-09 | Sierra | 91 | 113 | 0 | 0 | 0 |
5034 | 5034 | 2021-06-08 | Sierra | 91 | 113 | 0 | 0 | 0 |
5092 | 5092 | 2021-06-07 | Sierra | 91 | 113 | 0 | 0 | 0 |
5150 | 5150 | 2021-06-06 | Sierra | 91 | 113 | 0 | 0 | 0 |
5208 | 5208 | 2021-06-05 | Sierra | 91 | 113 | 0 | 0 | 0 |
5266 | 5266 | 2021-06-04 | Sierra | 91 | 113 | 0 | 0 | 0 |
5324 | 5324 | 2021-06-03 | Sierra | 91 | 113 | 0 | 0 | 0 |
5382 | 5382 | 2021-06-02 | Sierra | 91 | 113 | 0 | 0 | 0 |
5440 | 5440 | 2021-06-01 | Sierra | 91 | 113 | 0 | 0 | 0 |
5498 | 5498 | 2021-05-31 | Sierra | 91 | 113 | 0 | 0 | 0 |
5556 | 5556 | 2021-05-30 | Sierra | 91 | 113 | 0 | 0 | 0 |
5614 | 5614 | 2021-05-29 | Sierra | 91 | 113 | 0 | 0 | 0 |
5672 | 5672 | 2021-05-28 | Sierra | 91 | 113 | 0 | 1 | 0 |
5730 | 5730 | 2021-05-27 | Sierra | 91 | 112 | 0 | 0 | 0 |
5788 | 5788 | 2021-05-26 | Sierra | 91 | 112 | 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 );