latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
199 rows where deaths = 38 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips 24
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1580 | 1580 | 2021-08-06 | Inyo | 27 | 1482 | 38 | 0 | 0 |
1638 | 1638 | 2021-08-05 | Inyo | 27 | 1482 | 38 | 0 | 0 |
1696 | 1696 | 2021-08-04 | Inyo | 27 | 1482 | 38 | 0 | 0 |
1754 | 1754 | 2021-08-03 | Inyo | 27 | 1482 | 38 | 9 | 0 |
1812 | 1812 | 2021-08-02 | Inyo | 27 | 1473 | 38 | 0 | 0 |
1870 | 1870 | 2021-08-01 | Inyo | 27 | 1473 | 38 | 0 | 0 |
1928 | 1928 | 2021-07-31 | Inyo | 27 | 1473 | 38 | 0 | 0 |
1986 | 1986 | 2021-07-30 | Inyo | 27 | 1473 | 38 | 3 | 0 |
2044 | 2044 | 2021-07-29 | Inyo | 27 | 1470 | 38 | 17 | 0 |
2102 | 2102 | 2021-07-28 | Inyo | 27 | 1453 | 38 | 0 | 0 |
2160 | 2160 | 2021-07-27 | Inyo | 27 | 1453 | 38 | 0 | 0 |
2218 | 2218 | 2021-07-26 | Inyo | 27 | 1453 | 38 | 0 | 0 |
2276 | 2276 | 2021-07-25 | Inyo | 27 | 1453 | 38 | 0 | 0 |
2334 | 2334 | 2021-07-24 | Inyo | 27 | 1453 | 38 | 0 | 0 |
2392 | 2392 | 2021-07-23 | Inyo | 27 | 1453 | 38 | 0 | 0 |
2450 | 2450 | 2021-07-22 | Inyo | 27 | 1453 | 38 | 7 | 0 |
2508 | 2508 | 2021-07-21 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2566 | 2566 | 2021-07-20 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2624 | 2624 | 2021-07-19 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2682 | 2682 | 2021-07-18 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2740 | 2740 | 2021-07-17 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2798 | 2798 | 2021-07-16 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2856 | 2856 | 2021-07-15 | Inyo | 27 | 1446 | 38 | 0 | 0 |
2914 | 2914 | 2021-07-14 | Inyo | 27 | 1446 | 38 | 2 | 0 |
2972 | 2972 | 2021-07-13 | Inyo | 27 | 1444 | 38 | 0 | 0 |
3030 | 3030 | 2021-07-12 | Inyo | 27 | 1444 | 38 | 0 | 0 |
3088 | 3088 | 2021-07-11 | Inyo | 27 | 1444 | 38 | 0 | 0 |
3146 | 3146 | 2021-07-10 | Inyo | 27 | 1444 | 38 | 0 | 0 |
3204 | 3204 | 2021-07-09 | Inyo | 27 | 1444 | 38 | 3 | 0 |
3262 | 3262 | 2021-07-08 | Inyo | 27 | 1441 | 38 | 0 | 0 |
3320 | 3320 | 2021-07-07 | Inyo | 27 | 1441 | 38 | 0 | 0 |
3378 | 3378 | 2021-07-06 | Inyo | 27 | 1441 | 38 | 0 | 0 |
3436 | 3436 | 2021-07-05 | Inyo | 27 | 1441 | 38 | 0 | 0 |
3494 | 3494 | 2021-07-04 | Inyo | 27 | 1441 | 38 | 0 | 0 |
3552 | 3552 | 2021-07-03 | Inyo | 27 | 1441 | 38 | 7 | 0 |
3610 | 3610 | 2021-07-02 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3668 | 3668 | 2021-07-01 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3726 | 3726 | 2021-06-30 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3759 | 3759 | 2021-06-30 | Siskiyou | 93 | 2404 | 38 | 0 | 0 |
3784 | 3784 | 2021-06-29 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3817 | 3817 | 2021-06-29 | Siskiyou | 93 | 2404 | 38 | 2 | 0 |
3842 | 3842 | 2021-06-28 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3875 | 3875 | 2021-06-28 | Siskiyou | 93 | 2402 | 38 | 0 | 0 |
3900 | 3900 | 2021-06-27 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3933 | 3933 | 2021-06-27 | Siskiyou | 93 | 2402 | 38 | 0 | 0 |
3958 | 3958 | 2021-06-26 | Inyo | 27 | 1434 | 38 | 0 | 0 |
3991 | 3991 | 2021-06-26 | Siskiyou | 93 | 2402 | 38 | 0 | 0 |
4016 | 4016 | 2021-06-25 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4049 | 4049 | 2021-06-25 | Siskiyou | 93 | 2402 | 38 | 3 | 0 |
4074 | 4074 | 2021-06-24 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4107 | 4107 | 2021-06-24 | Siskiyou | 93 | 2399 | 38 | 1 | 1 |
4132 | 4132 | 2021-06-23 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4190 | 4190 | 2021-06-22 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4248 | 4248 | 2021-06-21 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4306 | 4306 | 2021-06-20 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4364 | 4364 | 2021-06-19 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4422 | 4422 | 2021-06-18 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4480 | 4480 | 2021-06-17 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4538 | 4538 | 2021-06-16 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4596 | 4596 | 2021-06-15 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4654 | 4654 | 2021-06-14 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4712 | 4712 | 2021-06-13 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4770 | 4770 | 2021-06-12 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4828 | 4828 | 2021-06-11 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4886 | 4886 | 2021-06-10 | Inyo | 27 | 1434 | 38 | 0 | 0 |
4944 | 4944 | 2021-06-09 | Inyo | 27 | 1434 | 38 | 1 | 0 |
5002 | 5002 | 2021-06-08 | Inyo | 27 | 1433 | 38 | 1 | 0 |
5060 | 5060 | 2021-06-07 | Inyo | 27 | 1432 | 38 | 0 | 0 |
5118 | 5118 | 2021-06-06 | Inyo | 27 | 1432 | 38 | 0 | 0 |
5176 | 5176 | 2021-06-05 | Inyo | 27 | 1432 | 38 | 0 | 0 |
5234 | 5234 | 2021-06-04 | Inyo | 27 | 1432 | 38 | 0 | 0 |
5292 | 5292 | 2021-06-03 | Inyo | 27 | 1432 | 38 | 0 | 0 |
5350 | 5350 | 2021-06-02 | Inyo | 27 | 1432 | 38 | 1 | 0 |
5408 | 5408 | 2021-06-01 | Inyo | 27 | 1431 | 38 | 0 | 0 |
5466 | 5466 | 2021-05-31 | Inyo | 27 | 1431 | 38 | 0 | 0 |
5524 | 5524 | 2021-05-30 | Inyo | 27 | 1431 | 38 | 0 | 0 |
5582 | 5582 | 2021-05-29 | Inyo | 27 | 1431 | 38 | 0 | 0 |
5640 | 5640 | 2021-05-28 | Inyo | 27 | 1431 | 38 | 1 | 0 |
5698 | 5698 | 2021-05-27 | Inyo | 27 | 1430 | 38 | 0 | 0 |
5756 | 5756 | 2021-05-26 | Inyo | 27 | 1430 | 38 | 1 | 0 |
5814 | 5814 | 2021-05-25 | Inyo | 27 | 1429 | 38 | 0 | 0 |
5872 | 5872 | 2021-05-24 | Inyo | 27 | 1429 | 38 | 0 | 0 |
5930 | 5930 | 2021-05-23 | Inyo | 27 | 1429 | 38 | 0 | 0 |
5988 | 5988 | 2021-05-22 | Inyo | 27 | 1429 | 38 | 0 | 0 |
6046 | 6046 | 2021-05-21 | Inyo | 27 | 1429 | 38 | 0 | 0 |
6104 | 6104 | 2021-05-20 | Inyo | 27 | 1429 | 38 | 0 | 0 |
6162 | 6162 | 2021-05-19 | Inyo | 27 | 1429 | 38 | 1 | 0 |
6220 | 6220 | 2021-05-18 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6278 | 6278 | 2021-05-17 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6336 | 6336 | 2021-05-16 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6394 | 6394 | 2021-05-15 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6452 | 6452 | 2021-05-14 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6510 | 6510 | 2021-05-13 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6568 | 6568 | 2021-05-12 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6626 | 6626 | 2021-05-11 | Inyo | 27 | 1428 | 38 | 0 | 0 |
6684 | 6684 | 2021-05-10 | Inyo | 27 | 1428 | 38 | 2 | 0 |
6742 | 6742 | 2021-05-09 | Inyo | 27 | 1426 | 38 | 0 | 0 |
6800 | 6800 | 2021-05-08 | Inyo | 27 | 1426 | 38 | 0 | 0 |
6858 | 6858 | 2021-05-07 | Inyo | 27 | 1426 | 38 | 1 | 0 |
6916 | 6916 | 2021-05-06 | Inyo | 27 | 1425 | 38 | 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 );