latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
28 rows where county = "Imperial" and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
2971 | 2971 | 2021-07-13 | Imperial | 25 | 28559 | 745 | 76 | 3 |
5349 | 5349 | 2021-06-02 | Imperial | 25 | 28166 | 736 | 35 | 3 |
6219 | 6219 | 2021-05-18 | Imperial | 25 | 28045 | 729 | 93 | 3 |
6683 | 6683 | 2021-05-10 | Imperial | 25 | 27837 | 721 | 0 | 3 |
10511 | 10511 | 2021-03-05 | Imperial | 25 | 26708 | 641 | 34 | 3 |
10685 | 10685 | 2021-03-02 | Imperial | 25 | 26674 | 638 | 0 | 3 |
11149 | 11149 | 2021-02-22 | Imperial | 25 | 26574 | 587 | 0 | 3 |
13353 | 13353 | 2021-01-15 | Imperial | 25 | 24620 | 463 | 137 | 3 |
13527 | 13527 | 2021-01-12 | Imperial | 25 | 24158 | 449 | 324 | 3 |
13875 | 13875 | 2021-01-06 | Imperial | 25 | 23006 | 437 | 99 | 3 |
14281 | 14281 | 2020-12-30 | Imperial | 25 | 22128 | 414 | 171 | 3 |
15209 | 15209 | 2020-12-14 | Imperial | 25 | 19394 | 376 | 1105 | 3 |
16833 | 16833 | 2020-11-16 | Imperial | 25 | 14135 | 351 | 289 | 3 |
19385 | 19385 | 2020-10-03 | Imperial | 25 | 12047 | 326 | 45 | 3 |
19501 | 19501 | 2020-10-01 | Imperial | 25 | 11993 | 323 | 85 | 3 |
19559 | 19559 | 2020-09-30 | Imperial | 25 | 11908 | 320 | 31 | 3 |
19965 | 19965 | 2020-09-23 | Imperial | 25 | 11658 | 317 | 52 | 3 |
21531 | 21531 | 2020-08-27 | Imperial | 25 | 10573 | 286 | 64 | 3 |
21821 | 21821 | 2020-08-22 | Imperial | 25 | 10393 | 272 | 27 | 3 |
21879 | 21879 | 2020-08-21 | Imperial | 25 | 10366 | 269 | 41 | 3 |
23503 | 23503 | 2020-07-24 | Imperial | 25 | 8967 | 173 | 48 | 3 |
24257 | 24257 | 2020-07-11 | Imperial | 25 | 7827 | 135 | 68 | 3 |
24547 | 24547 | 2020-07-06 | Imperial | 25 | 7190 | 117 | 45 | 3 |
24779 | 24779 | 2020-07-02 | Imperial | 25 | 6824 | 100 | 301 | 3 |
25185 | 25185 | 2020-06-25 | Imperial | 25 | 5744 | 73 | 195 | 3 |
26055 | 26055 | 2020-06-10 | Imperial | 25 | 3386 | 41 | 253 | 3 |
26345 | 26345 | 2020-06-05 | Imperial | 25 | 2568 | 33 | 75 | 3 |
27331 | 27331 | 2020-05-19 | Imperial | 25 | 902 | 18 | 26 | 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 );