latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
41 rows where fips = 25 and new_deaths = 2 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 |
---|---|---|---|---|---|---|---|---|
129 | 129 | 2021-08-31 | Imperial | 25 | 29974 | 753 | 255 | 2 |
535 | 535 | 2021-08-24 | Imperial | 25 | 29669 | 751 | 222 | 2 |
941 | 941 | 2021-08-17 | Imperial | 25 | 29396 | 748 | 159 | 2 |
4595 | 4595 | 2021-06-15 | Imperial | 25 | 28284 | 741 | 2 | 2 |
5233 | 5233 | 2021-06-04 | Imperial | 25 | 28172 | 738 | 6 | 2 |
5755 | 5755 | 2021-05-26 | Imperial | 25 | 28099 | 733 | 11 | 2 |
9699 | 9699 | 2021-03-19 | Imperial | 25 | 26851 | 691 | 34 | 2 |
9757 | 9757 | 2021-03-18 | Imperial | 25 | 26817 | 689 | 2 | 2 |
12309 | 12309 | 2021-02-02 | Imperial | 25 | 26184 | 551 | 27 | 2 |
13121 | 13121 | 2021-01-19 | Imperial | 25 | 24927 | 465 | 307 | 2 |
13759 | 13759 | 2021-01-08 | Imperial | 25 | 23472 | 446 | 153 | 2 |
14687 | 14687 | 2020-12-23 | Imperial | 25 | 21057 | 402 | 162 | 2 |
14803 | 14803 | 2020-12-21 | Imperial | 25 | 20788 | 396 | 615 | 2 |
15383 | 15383 | 2020-12-11 | Imperial | 25 | 18289 | 373 | 376 | 2 |
15789 | 15789 | 2020-12-04 | Imperial | 25 | 16555 | 360 | 48 | 2 |
15847 | 15847 | 2020-12-03 | Imperial | 25 | 16507 | 358 | 78 | 2 |
16427 | 16427 | 2020-11-23 | Imperial | 25 | 15257 | 355 | 537 | 2 |
16717 | 16717 | 2020-11-18 | Imperial | 25 | 14431 | 353 | 130 | 2 |
17065 | 17065 | 2020-11-12 | Imperial | 25 | 13789 | 343 | 92 | 2 |
17471 | 17471 | 2020-11-05 | Imperial | 25 | 13330 | 340 | 46 | 2 |
17877 | 17877 | 2020-10-29 | Imperial | 25 | 13023 | 338 | 40 | 2 |
19095 | 19095 | 2020-10-08 | Imperial | 25 | 12145 | 329 | 25 | 2 |
20197 | 20197 | 2020-09-19 | Imperial | 25 | 11558 | 314 | 24 | 2 |
20255 | 20255 | 2020-09-18 | Imperial | 25 | 11534 | 312 | 77 | 2 |
20719 | 20719 | 2020-09-10 | Imperial | 25 | 11183 | 303 | 90 | 2 |
21183 | 21183 | 2020-09-02 | Imperial | 25 | 10746 | 296 | 35 | 2 |
22633 | 22633 | 2020-08-08 | Imperial | 25 | 9693 | 244 | 64 | 2 |
22691 | 22691 | 2020-08-07 | Imperial | 25 | 9629 | 242 | 28 | 2 |
22807 | 22807 | 2020-08-05 | Imperial | 25 | 9546 | 234 | 33 | 2 |
22923 | 22923 | 2020-08-03 | Imperial | 25 | 9448 | 222 | 39 | 2 |
23619 | 23619 | 2020-07-22 | Imperial | 25 | 8799 | 165 | 193 | 2 |
23735 | 23735 | 2020-07-20 | Imperial | 25 | 8606 | 163 | 75 | 2 |
24373 | 24373 | 2020-07-09 | Imperial | 25 | 7654 | 127 | 190 | 2 |
25243 | 25243 | 2020-06-24 | Imperial | 25 | 5549 | 70 | 279 | 2 |
25649 | 25649 | 2020-06-17 | Imperial | 25 | 4478 | 54 | 89 | 2 |
25997 | 25997 | 2020-06-11 | Imperial | 25 | 3405 | 43 | 19 | 2 |
26577 | 26577 | 2020-06-01 | Imperial | 25 | 1751 | 29 | 117 | 2 |
26867 | 26867 | 2020-05-27 | Imperial | 25 | 1443 | 26 | 91 | 2 |
27157 | 27157 | 2020-05-22 | Imperial | 25 | 1145 | 23 | 69 | 2 |
27215 | 27215 | 2020-05-21 | Imperial | 25 | 1076 | 21 | 91 | 2 |
28815 | 28815 | 2020-04-23 | Imperial | 25 | 232 | 8 | 18 | 2 |
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 );