latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
516 rows where county = "Lake" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18055 | 18055 | 2020-10-26 | Lake | 33 | 698 | 16 | 9 | 1 |
18113 | 18113 | 2020-10-25 | Lake | 33 | 689 | 15 | 0 | 0 |
18171 | 18171 | 2020-10-24 | Lake | 33 | 689 | 15 | 0 | 0 |
18229 | 18229 | 2020-10-23 | Lake | 33 | 689 | 15 | 10 | 0 |
18287 | 18287 | 2020-10-22 | Lake | 33 | 679 | 15 | 1 | 0 |
18345 | 18345 | 2020-10-21 | Lake | 33 | 678 | 15 | 0 | 0 |
18403 | 18403 | 2020-10-20 | Lake | 33 | 678 | 15 | 6 | 0 |
18461 | 18461 | 2020-10-19 | Lake | 33 | 672 | 15 | 14 | 0 |
18519 | 18519 | 2020-10-18 | Lake | 33 | 658 | 15 | 0 | 0 |
18577 | 18577 | 2020-10-17 | Lake | 33 | 658 | 15 | 0 | 0 |
18635 | 18635 | 2020-10-16 | Lake | 33 | 658 | 15 | 17 | 1 |
18693 | 18693 | 2020-10-15 | Lake | 33 | 641 | 14 | 2 | 0 |
18751 | 18751 | 2020-10-14 | Lake | 33 | 639 | 14 | 1 | 0 |
18809 | 18809 | 2020-10-13 | Lake | 33 | 638 | 14 | 8 | 1 |
18867 | 18867 | 2020-10-12 | Lake | 33 | 630 | 13 | 2 | 0 |
18925 | 18925 | 2020-10-11 | Lake | 33 | 628 | 13 | 0 | 0 |
18983 | 18983 | 2020-10-10 | Lake | 33 | 628 | 13 | 0 | 0 |
19041 | 19041 | 2020-10-09 | Lake | 33 | 628 | 13 | 28 | 1 |
19099 | 19099 | 2020-10-08 | Lake | 33 | 600 | 12 | 3 | 0 |
19157 | 19157 | 2020-10-07 | Lake | 33 | 597 | 12 | 2 | 0 |
19215 | 19215 | 2020-10-06 | Lake | 33 | 595 | 12 | 2 | 0 |
19273 | 19273 | 2020-10-05 | Lake | 33 | 593 | 12 | 12 | 1 |
19331 | 19331 | 2020-10-04 | Lake | 33 | 581 | 11 | 0 | 0 |
19389 | 19389 | 2020-10-03 | Lake | 33 | 581 | 11 | 0 | 0 |
19447 | 19447 | 2020-10-02 | Lake | 33 | 581 | 11 | 12 | 0 |
19505 | 19505 | 2020-10-01 | Lake | 33 | 569 | 11 | 3 | 0 |
19563 | 19563 | 2020-09-30 | Lake | 33 | 566 | 11 | 1 | 0 |
19621 | 19621 | 2020-09-29 | Lake | 33 | 565 | 11 | 6 | 0 |
19679 | 19679 | 2020-09-28 | Lake | 33 | 559 | 11 | 20 | 0 |
19737 | 19737 | 2020-09-27 | Lake | 33 | 539 | 11 | 0 | 0 |
19795 | 19795 | 2020-09-26 | Lake | 33 | 539 | 11 | 0 | 0 |
19853 | 19853 | 2020-09-25 | Lake | 33 | 539 | 11 | 5 | 0 |
19911 | 19911 | 2020-09-24 | Lake | 33 | 534 | 11 | 4 | 0 |
19969 | 19969 | 2020-09-23 | Lake | 33 | 530 | 11 | 14 | 0 |
20027 | 20027 | 2020-09-22 | Lake | 33 | 516 | 11 | 4 | 0 |
20085 | 20085 | 2020-09-21 | Lake | 33 | 512 | 11 | 47 | 1 |
20143 | 20143 | 2020-09-20 | Lake | 33 | 465 | 10 | 6 | 0 |
20201 | 20201 | 2020-09-19 | Lake | 33 | 459 | 10 | 0 | 0 |
20259 | 20259 | 2020-09-18 | Lake | 33 | 459 | 10 | 26 | 0 |
20317 | 20317 | 2020-09-17 | Lake | 33 | 433 | 10 | 0 | 0 |
20375 | 20375 | 2020-09-16 | Lake | 33 | 433 | 10 | 15 | 3 |
20433 | 20433 | 2020-09-15 | Lake | 33 | 418 | 7 | 2 | 0 |
20491 | 20491 | 2020-09-14 | Lake | 33 | 416 | 7 | 26 | 0 |
20549 | 20549 | 2020-09-13 | Lake | 33 | 390 | 7 | 0 | 0 |
20607 | 20607 | 2020-09-12 | Lake | 33 | 390 | 7 | 0 | 0 |
20665 | 20665 | 2020-09-11 | Lake | 33 | 390 | 7 | 12 | 1 |
20723 | 20723 | 2020-09-10 | Lake | 33 | 378 | 6 | 6 | 0 |
20781 | 20781 | 2020-09-09 | Lake | 33 | 372 | 6 | 4 | 0 |
20839 | 20839 | 2020-09-08 | Lake | 33 | 368 | 6 | 0 | 1 |
20897 | 20897 | 2020-09-07 | Lake | 33 | 368 | 5 | 8 | 0 |
20955 | 20955 | 2020-09-06 | Lake | 33 | 360 | 5 | 0 | 0 |
21013 | 21013 | 2020-09-05 | Lake | 33 | 360 | 5 | 0 | 0 |
21071 | 21071 | 2020-09-04 | Lake | 33 | 360 | 5 | 10 | 0 |
21129 | 21129 | 2020-09-03 | Lake | 33 | 350 | 5 | 0 | 0 |
21187 | 21187 | 2020-09-02 | Lake | 33 | 350 | 5 | 4 | 1 |
21245 | 21245 | 2020-09-01 | Lake | 33 | 346 | 4 | 1 | 0 |
21303 | 21303 | 2020-08-31 | Lake | 33 | 345 | 4 | 13 | 0 |
21361 | 21361 | 2020-08-30 | Lake | 33 | 332 | 4 | 0 | 0 |
21419 | 21419 | 2020-08-29 | Lake | 33 | 332 | 4 | 8 | 1 |
21477 | 21477 | 2020-08-28 | Lake | 33 | 324 | 3 | 9 | 0 |
21535 | 21535 | 2020-08-27 | Lake | 33 | 315 | 3 | 1 | 0 |
21593 | 21593 | 2020-08-26 | Lake | 33 | 314 | 3 | 10 | 0 |
21651 | 21651 | 2020-08-25 | Lake | 33 | 304 | 3 | 1 | 0 |
21709 | 21709 | 2020-08-24 | Lake | 33 | 303 | 3 | 13 | 0 |
21767 | 21767 | 2020-08-23 | Lake | 33 | 290 | 3 | 0 | 0 |
21825 | 21825 | 2020-08-22 | Lake | 33 | 290 | 3 | 0 | 0 |
21883 | 21883 | 2020-08-21 | Lake | 33 | 290 | 3 | 8 | 0 |
21941 | 21941 | 2020-08-20 | Lake | 33 | 282 | 3 | 1 | 0 |
21999 | 21999 | 2020-08-19 | Lake | 33 | 281 | 3 | 6 | 1 |
22057 | 22057 | 2020-08-18 | Lake | 33 | 275 | 2 | 3 | 0 |
22115 | 22115 | 2020-08-17 | Lake | 33 | 272 | 2 | 4 | 0 |
22173 | 22173 | 2020-08-16 | Lake | 33 | 268 | 2 | 0 | 0 |
22231 | 22231 | 2020-08-15 | Lake | 33 | 268 | 2 | 0 | 0 |
22289 | 22289 | 2020-08-14 | Lake | 33 | 268 | 2 | 1 | 0 |
22347 | 22347 | 2020-08-13 | Lake | 33 | 267 | 2 | 7 | 0 |
22405 | 22405 | 2020-08-12 | Lake | 33 | 260 | 2 | 7 | 0 |
22463 | 22463 | 2020-08-11 | Lake | 33 | 253 | 2 | 13 | 0 |
22521 | 22521 | 2020-08-10 | Lake | 33 | 240 | 2 | 20 | 0 |
22579 | 22579 | 2020-08-09 | Lake | 33 | 220 | 2 | 0 | 0 |
22637 | 22637 | 2020-08-08 | Lake | 33 | 220 | 2 | 0 | 0 |
22695 | 22695 | 2020-08-07 | Lake | 33 | 220 | 2 | 8 | 0 |
22753 | 22753 | 2020-08-06 | Lake | 33 | 212 | 2 | 0 | 0 |
22811 | 22811 | 2020-08-05 | Lake | 33 | 212 | 2 | 1 | 1 |
22869 | 22869 | 2020-08-04 | Lake | 33 | 211 | 1 | 3 | 0 |
22927 | 22927 | 2020-08-03 | Lake | 33 | 208 | 1 | 13 | 0 |
22985 | 22985 | 2020-08-02 | Lake | 33 | 195 | 1 | 0 | 0 |
23043 | 23043 | 2020-08-01 | Lake | 33 | 195 | 1 | 0 | 0 |
23101 | 23101 | 2020-07-31 | Lake | 33 | 195 | 1 | 12 | 0 |
23159 | 23159 | 2020-07-30 | Lake | 33 | 183 | 1 | 2 | 0 |
23217 | 23217 | 2020-07-29 | Lake | 33 | 181 | 1 | 1 | 0 |
23275 | 23275 | 2020-07-28 | Lake | 33 | 180 | 1 | 5 | 0 |
23333 | 23333 | 2020-07-27 | Lake | 33 | 175 | 1 | 7 | 0 |
23391 | 23391 | 2020-07-26 | Lake | 33 | 168 | 1 | 0 | 0 |
23449 | 23449 | 2020-07-25 | Lake | 33 | 168 | 1 | 0 | 0 |
23507 | 23507 | 2020-07-24 | Lake | 33 | 168 | 1 | 2 | 0 |
23565 | 23565 | 2020-07-23 | Lake | 33 | 166 | 1 | 8 | 0 |
23623 | 23623 | 2020-07-22 | Lake | 33 | 158 | 1 | 2 | 0 |
23681 | 23681 | 2020-07-21 | Lake | 33 | 156 | 1 | 5 | 0 |
23739 | 23739 | 2020-07-20 | Lake | 33 | 151 | 1 | 11 | 0 |
23797 | 23797 | 2020-07-19 | Lake | 33 | 140 | 1 | 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 );