latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
26 rows where county = "San Diego", fips = 73 and new_deaths = 7 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 |
---|---|---|---|---|---|---|---|---|
791 | 791 | 2021-08-20 | San Diego | 73 | 321102 | 3846 | 1520 | 7 |
6823 | 6823 | 2021-05-08 | San Diego | 73 | 277759 | 3725 | 226 | 7 |
7809 | 7809 | 2021-04-21 | San Diego | 73 | 275251 | 3681 | 0 | 7 |
9201 | 9201 | 2021-03-28 | San Diego | 73 | 269480 | 3547 | 205 | 7 |
15697 | 15697 | 2020-12-06 | San Diego | 73 | 92171 | 1062 | 1703 | 7 |
15813 | 15813 | 2020-12-04 | San Diego | 73 | 88181 | 1047 | 2039 | 7 |
16683 | 16683 | 2020-11-19 | San Diego | 73 | 68140 | 952 | 899 | 7 |
16799 | 16799 | 2020-11-17 | San Diego | 73 | 66319 | 933 | 718 | 7 |
17205 | 17205 | 2020-11-10 | San Diego | 73 | 61053 | 915 | 483 | 7 |
18017 | 18017 | 2020-10-27 | San Diego | 73 | 55210 | 877 | 269 | 7 |
19177 | 19177 | 2020-10-07 | San Diego | 73 | 49175 | 813 | 354 | 7 |
21207 | 21207 | 2020-09-02 | San Diego | 73 | 39121 | 695 | 250 | 7 |
22077 | 22077 | 2020-08-18 | San Diego | 73 | 35162 | 633 | 202 | 7 |
22309 | 22309 | 2020-08-14 | San Diego | 73 | 34065 | 622 | 406 | 7 |
22367 | 22367 | 2020-08-13 | San Diego | 73 | 33659 | 615 | 266 | 7 |
22657 | 22657 | 2020-08-08 | San Diego | 73 | 32330 | 593 | 551 | 7 |
23585 | 23585 | 2020-07-23 | San Diego | 73 | 25608 | 512 | 501 | 7 |
23933 | 23933 | 2020-07-17 | San Diego | 73 | 22489 | 472 | 634 | 7 |
24455 | 24455 | 2020-07-08 | San Diego | 73 | 17842 | 406 | 264 | 7 |
24861 | 24861 | 2020-07-01 | San Diego | 73 | 14623 | 372 | 474 | 7 |
26485 | 26485 | 2020-06-03 | San Diego | 73 | 7798 | 283 | 124 | 7 |
26543 | 26543 | 2020-06-02 | San Diego | 73 | 7674 | 276 | 120 | 7 |
27123 | 27123 | 2020-05-23 | San Diego | 73 | 6559 | 249 | 125 | 7 |
28051 | 28051 | 2020-05-07 | San Diego | 73 | 4429 | 165 | 110 | 7 |
29154 | 29154 | 2020-04-17 | San Diego | 73 | 2158 | 70 | 71 | 7 |
29260 | 29260 | 2020-04-15 | San Diego | 73 | 2012 | 60 | 82 | 7 |
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 );