latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
38 rows where fips = 59 and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
958 | 958 | 2021-08-17 | Orange | 59 | 276632 | 5161 | 668 | 3 |
1654 | 1654 | 2021-08-05 | Orange | 59 | 267908 | 5146 | 777 | 3 |
4844 | 4844 | 2021-06-11 | Orange | 59 | 255588 | 5095 | 18 | 3 |
5250 | 5250 | 2021-06-04 | Orange | 59 | 255371 | 5073 | 24 | 3 |
5366 | 5366 | 2021-06-02 | Orange | 59 | 255322 | 5068 | 31 | 3 |
5656 | 5656 | 2021-05-28 | Orange | 59 | 255164 | 5059 | 55 | 3 |
5888 | 5888 | 2021-05-24 | Orange | 59 | 255048 | 5052 | 26 | 3 |
6178 | 6178 | 2021-05-19 | Orange | 59 | 254882 | 5034 | 51 | 3 |
6526 | 6526 | 2021-05-13 | Orange | 59 | 254492 | 5026 | 35 | 3 |
6758 | 6758 | 2021-05-09 | Orange | 59 | 254311 | 5008 | 33 | 3 |
10934 | 10934 | 2021-02-26 | Orange | 59 | 245983 | 3892 | 349 | 3 |
14994 | 14994 | 2020-12-18 | Orange | 59 | 116377 | 1734 | 2594 | 3 |
16328 | 16328 | 2020-11-25 | Orange | 59 | 73152 | 1559 | 1199 | 3 |
16502 | 16502 | 2020-11-22 | Orange | 59 | 69694 | 1554 | 552 | 3 |
16618 | 16618 | 2020-11-20 | Orange | 59 | 68336 | 1540 | 1169 | 3 |
17198 | 17198 | 2020-11-10 | Orange | 59 | 62830 | 1512 | 267 | 3 |
17314 | 17314 | 2020-11-08 | Orange | 59 | 62255 | 1509 | 512 | 3 |
17372 | 17372 | 2020-11-07 | Orange | 59 | 61743 | 1506 | 322 | 3 |
17488 | 17488 | 2020-11-05 | Orange | 59 | 61112 | 1494 | 271 | 3 |
18126 | 18126 | 2020-10-25 | Orange | 59 | 58573 | 1447 | 247 | 3 |
19170 | 19170 | 2020-10-07 | Orange | 59 | 55042 | 1292 | 144 | 3 |
20852 | 20852 | 2020-09-08 | Orange | 59 | 49996 | 1056 | 151 | 3 |
23926 | 23926 | 2020-07-17 | Orange | 59 | 28309 | 469 | 405 | 3 |
24506 | 24506 | 2020-07-07 | Orange | 59 | 18892 | 369 | 1010 | 3 |
24622 | 24622 | 2020-07-05 | Orange | 59 | 16854 | 366 | 663 | 3 |
24680 | 24680 | 2020-07-04 | Orange | 59 | 16191 | 363 | 413 | 3 |
25028 | 25028 | 2020-06-28 | Orange | 59 | 12608 | 326 | 146 | 3 |
26536 | 26536 | 2020-06-02 | Orange | 59 | 6574 | 150 | 100 | 3 |
26768 | 26768 | 2020-05-29 | Orange | 59 | 5923 | 145 | 179 | 3 |
27696 | 27696 | 2020-05-13 | Orange | 59 | 3749 | 80 | 147 | 3 |
27928 | 27928 | 2020-05-09 | Orange | 59 | 3380 | 74 | 146 | 3 |
28564 | 28564 | 2020-04-28 | Orange | 59 | 2131 | 42 | 32 | 3 |
29147 | 29147 | 2020-04-17 | Orange | 59 | 1483 | 28 | 72 | 3 |
29200 | 29200 | 2020-04-16 | Orange | 59 | 1411 | 25 | 50 | 3 |
29253 | 29253 | 2020-04-15 | Orange | 59 | 1361 | 22 | 83 | 3 |
29939 | 29939 | 2020-04-02 | Orange | 59 | 648 | 13 | 54 | 3 |
29990 | 29990 | 2020-04-01 | Orange | 59 | 594 | 10 | 104 | 3 |
30041 | 30041 | 2020-03-31 | Orange | 59 | 490 | 7 | 38 | 3 |
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 );