latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
522 rows where deaths = 0 and fips = 3 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 |
---|---|---|---|---|---|---|---|---|
2 | 2 | 2021-09-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
60 | 60 | 2021-09-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
118 | 118 | 2021-08-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
176 | 176 | 2021-08-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
234 | 234 | 2021-08-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
292 | 292 | 2021-08-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
350 | 350 | 2021-08-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
408 | 408 | 2021-08-26 | Alpine | 3 | 89 | 0 | 0 | 0 |
466 | 466 | 2021-08-25 | Alpine | 3 | 89 | 0 | 0 | 0 |
524 | 524 | 2021-08-24 | Alpine | 3 | 89 | 0 | 0 | 0 |
582 | 582 | 2021-08-23 | Alpine | 3 | 89 | 0 | 0 | 0 |
640 | 640 | 2021-08-22 | Alpine | 3 | 89 | 0 | 0 | 0 |
698 | 698 | 2021-08-21 | Alpine | 3 | 89 | 0 | 0 | 0 |
756 | 756 | 2021-08-20 | Alpine | 3 | 89 | 0 | 0 | 0 |
814 | 814 | 2021-08-19 | Alpine | 3 | 89 | 0 | 0 | 0 |
872 | 872 | 2021-08-18 | Alpine | 3 | 89 | 0 | 0 | 0 |
930 | 930 | 2021-08-17 | Alpine | 3 | 89 | 0 | 0 | 0 |
988 | 988 | 2021-08-16 | Alpine | 3 | 89 | 0 | 0 | 0 |
1046 | 1046 | 2021-08-15 | Alpine | 3 | 89 | 0 | 0 | 0 |
1104 | 1104 | 2021-08-14 | Alpine | 3 | 89 | 0 | 0 | 0 |
1162 | 1162 | 2021-08-13 | Alpine | 3 | 89 | 0 | 0 | 0 |
1220 | 1220 | 2021-08-12 | Alpine | 3 | 89 | 0 | 0 | 0 |
1278 | 1278 | 2021-08-11 | Alpine | 3 | 89 | 0 | 0 | 0 |
1336 | 1336 | 2021-08-10 | Alpine | 3 | 89 | 0 | 0 | 0 |
1394 | 1394 | 2021-08-09 | Alpine | 3 | 89 | 0 | 0 | 0 |
1452 | 1452 | 2021-08-08 | Alpine | 3 | 89 | 0 | 0 | 0 |
1510 | 1510 | 2021-08-07 | Alpine | 3 | 89 | 0 | 0 | 0 |
1568 | 1568 | 2021-08-06 | Alpine | 3 | 89 | 0 | 0 | 0 |
1626 | 1626 | 2021-08-05 | Alpine | 3 | 89 | 0 | 0 | 0 |
1684 | 1684 | 2021-08-04 | Alpine | 3 | 89 | 0 | 0 | 0 |
1742 | 1742 | 2021-08-03 | Alpine | 3 | 89 | 0 | 0 | 0 |
1800 | 1800 | 2021-08-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
1858 | 1858 | 2021-08-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
1916 | 1916 | 2021-07-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
1974 | 1974 | 2021-07-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
2032 | 2032 | 2021-07-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
2090 | 2090 | 2021-07-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
2148 | 2148 | 2021-07-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
2206 | 2206 | 2021-07-26 | Alpine | 3 | 89 | 0 | 0 | 0 |
2264 | 2264 | 2021-07-25 | Alpine | 3 | 89 | 0 | 0 | 0 |
2322 | 2322 | 2021-07-24 | Alpine | 3 | 89 | 0 | 0 | 0 |
2380 | 2380 | 2021-07-23 | Alpine | 3 | 89 | 0 | 0 | 0 |
2438 | 2438 | 2021-07-22 | Alpine | 3 | 89 | 0 | 0 | 0 |
2496 | 2496 | 2021-07-21 | Alpine | 3 | 89 | 0 | 0 | 0 |
2554 | 2554 | 2021-07-20 | Alpine | 3 | 89 | 0 | 0 | 0 |
2612 | 2612 | 2021-07-19 | Alpine | 3 | 89 | 0 | 0 | 0 |
2670 | 2670 | 2021-07-18 | Alpine | 3 | 89 | 0 | 0 | 0 |
2728 | 2728 | 2021-07-17 | Alpine | 3 | 89 | 0 | 0 | 0 |
2786 | 2786 | 2021-07-16 | Alpine | 3 | 89 | 0 | 0 | 0 |
2844 | 2844 | 2021-07-15 | Alpine | 3 | 89 | 0 | 0 | 0 |
2902 | 2902 | 2021-07-14 | Alpine | 3 | 89 | 0 | 0 | 0 |
2960 | 2960 | 2021-07-13 | Alpine | 3 | 89 | 0 | 0 | 0 |
3018 | 3018 | 2021-07-12 | Alpine | 3 | 89 | 0 | 0 | 0 |
3076 | 3076 | 2021-07-11 | Alpine | 3 | 89 | 0 | 0 | 0 |
3134 | 3134 | 2021-07-10 | Alpine | 3 | 89 | 0 | 0 | 0 |
3192 | 3192 | 2021-07-09 | Alpine | 3 | 89 | 0 | 0 | 0 |
3250 | 3250 | 2021-07-08 | Alpine | 3 | 89 | 0 | 0 | 0 |
3308 | 3308 | 2021-07-07 | Alpine | 3 | 89 | 0 | 0 | 0 |
3366 | 3366 | 2021-07-06 | Alpine | 3 | 89 | 0 | 0 | 0 |
3424 | 3424 | 2021-07-05 | Alpine | 3 | 89 | 0 | 0 | 0 |
3482 | 3482 | 2021-07-04 | Alpine | 3 | 89 | 0 | 0 | 0 |
3540 | 3540 | 2021-07-03 | Alpine | 3 | 89 | 0 | 0 | 0 |
3598 | 3598 | 2021-07-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
3656 | 3656 | 2021-07-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
3714 | 3714 | 2021-06-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
3772 | 3772 | 2021-06-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
3830 | 3830 | 2021-06-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
3888 | 3888 | 2021-06-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
3946 | 3946 | 2021-06-26 | Alpine | 3 | 89 | 0 | 0 | 0 |
4004 | 4004 | 2021-06-25 | Alpine | 3 | 89 | 0 | 0 | 0 |
4062 | 4062 | 2021-06-24 | Alpine | 3 | 89 | 0 | 0 | 0 |
4120 | 4120 | 2021-06-23 | Alpine | 3 | 89 | 0 | 0 | 0 |
4178 | 4178 | 2021-06-22 | Alpine | 3 | 89 | 0 | 0 | 0 |
4236 | 4236 | 2021-06-21 | Alpine | 3 | 89 | 0 | 0 | 0 |
4294 | 4294 | 2021-06-20 | Alpine | 3 | 89 | 0 | 0 | 0 |
4352 | 4352 | 2021-06-19 | Alpine | 3 | 89 | 0 | 0 | 0 |
4410 | 4410 | 2021-06-18 | Alpine | 3 | 89 | 0 | 0 | 0 |
4468 | 4468 | 2021-06-17 | Alpine | 3 | 89 | 0 | 0 | 0 |
4526 | 4526 | 2021-06-16 | Alpine | 3 | 89 | 0 | 0 | 0 |
4584 | 4584 | 2021-06-15 | Alpine | 3 | 89 | 0 | 0 | 0 |
4642 | 4642 | 2021-06-14 | Alpine | 3 | 89 | 0 | 0 | 0 |
4700 | 4700 | 2021-06-13 | Alpine | 3 | 89 | 0 | 0 | 0 |
4758 | 4758 | 2021-06-12 | Alpine | 3 | 89 | 0 | 0 | 0 |
4816 | 4816 | 2021-06-11 | Alpine | 3 | 89 | 0 | 0 | 0 |
4874 | 4874 | 2021-06-10 | Alpine | 3 | 89 | 0 | 0 | 0 |
4932 | 4932 | 2021-06-09 | Alpine | 3 | 89 | 0 | 0 | 0 |
4990 | 4990 | 2021-06-08 | Alpine | 3 | 89 | 0 | 0 | 0 |
5048 | 5048 | 2021-06-07 | Alpine | 3 | 89 | 0 | 0 | 0 |
5106 | 5106 | 2021-06-06 | Alpine | 3 | 89 | 0 | 0 | 0 |
5164 | 5164 | 2021-06-05 | Alpine | 3 | 89 | 0 | 0 | 0 |
5222 | 5222 | 2021-06-04 | Alpine | 3 | 89 | 0 | 0 | 0 |
5280 | 5280 | 2021-06-03 | Alpine | 3 | 89 | 0 | 0 | 0 |
5338 | 5338 | 2021-06-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
5396 | 5396 | 2021-06-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
5454 | 5454 | 2021-05-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
5512 | 5512 | 2021-05-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
5570 | 5570 | 2021-05-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
5628 | 5628 | 2021-05-28 | Alpine | 3 | 89 | 0 | 0 | 0 |
5686 | 5686 | 2021-05-27 | Alpine | 3 | 89 | 0 | 0 | 0 |
5744 | 5744 | 2021-05-26 | Alpine | 3 | 89 | 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 );