latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
51 rows where deaths = 6 and fips = 105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1329 | 1329 | 2021-08-11 | Trinity | 105 | 514 | 6 | 6 | 0 |
1387 | 1387 | 2021-08-10 | Trinity | 105 | 508 | 6 | 4 | 0 |
1445 | 1445 | 2021-08-09 | Trinity | 105 | 504 | 6 | 9 | 0 |
1503 | 1503 | 2021-08-08 | Trinity | 105 | 495 | 6 | 0 | 0 |
1561 | 1561 | 2021-08-07 | Trinity | 105 | 495 | 6 | 0 | 0 |
1619 | 1619 | 2021-08-06 | Trinity | 105 | 495 | 6 | 8 | 0 |
1677 | 1677 | 2021-08-05 | Trinity | 105 | 487 | 6 | 13 | 0 |
1735 | 1735 | 2021-08-04 | Trinity | 105 | 474 | 6 | 5 | 0 |
1793 | 1793 | 2021-08-03 | Trinity | 105 | 469 | 6 | 0 | 0 |
1851 | 1851 | 2021-08-02 | Trinity | 105 | 469 | 6 | 2 | 0 |
1909 | 1909 | 2021-08-01 | Trinity | 105 | 467 | 6 | 0 | 0 |
1967 | 1967 | 2021-07-31 | Trinity | 105 | 467 | 6 | 5 | 0 |
2025 | 2025 | 2021-07-30 | Trinity | 105 | 462 | 6 | 0 | 0 |
2083 | 2083 | 2021-07-29 | Trinity | 105 | 462 | 6 | 3 | 0 |
2141 | 2141 | 2021-07-28 | Trinity | 105 | 459 | 6 | 3 | 0 |
2199 | 2199 | 2021-07-27 | Trinity | 105 | 456 | 6 | 3 | 0 |
2257 | 2257 | 2021-07-26 | Trinity | 105 | 453 | 6 | 2 | 0 |
2315 | 2315 | 2021-07-25 | Trinity | 105 | 451 | 6 | 0 | 0 |
2373 | 2373 | 2021-07-24 | Trinity | 105 | 451 | 6 | 0 | 0 |
2431 | 2431 | 2021-07-23 | Trinity | 105 | 451 | 6 | 3 | 0 |
2489 | 2489 | 2021-07-22 | Trinity | 105 | 448 | 6 | 5 | 0 |
2547 | 2547 | 2021-07-21 | Trinity | 105 | 443 | 6 | 2 | 0 |
2605 | 2605 | 2021-07-20 | Trinity | 105 | 441 | 6 | 1 | 0 |
2663 | 2663 | 2021-07-19 | Trinity | 105 | 440 | 6 | 3 | 0 |
2721 | 2721 | 2021-07-18 | Trinity | 105 | 437 | 6 | 0 | 0 |
2779 | 2779 | 2021-07-17 | Trinity | 105 | 437 | 6 | 0 | 0 |
2837 | 2837 | 2021-07-16 | Trinity | 105 | 437 | 6 | 2 | 0 |
2895 | 2895 | 2021-07-15 | Trinity | 105 | 435 | 6 | 3 | 0 |
2953 | 2953 | 2021-07-14 | Trinity | 105 | 432 | 6 | 2 | 0 |
3011 | 3011 | 2021-07-13 | Trinity | 105 | 430 | 6 | 1 | 0 |
3069 | 3069 | 2021-07-12 | Trinity | 105 | 429 | 6 | 1 | 0 |
3127 | 3127 | 2021-07-11 | Trinity | 105 | 428 | 6 | 0 | 0 |
3185 | 3185 | 2021-07-10 | Trinity | 105 | 428 | 6 | 0 | 0 |
3243 | 3243 | 2021-07-09 | Trinity | 105 | 428 | 6 | 0 | 0 |
3301 | 3301 | 2021-07-08 | Trinity | 105 | 428 | 6 | 0 | 0 |
3359 | 3359 | 2021-07-07 | Trinity | 105 | 428 | 6 | 0 | 0 |
3417 | 3417 | 2021-07-06 | Trinity | 105 | 428 | 6 | 0 | 0 |
3475 | 3475 | 2021-07-05 | Trinity | 105 | 428 | 6 | 0 | 0 |
3533 | 3533 | 2021-07-04 | Trinity | 105 | 428 | 6 | 0 | 0 |
3591 | 3591 | 2021-07-03 | Trinity | 105 | 428 | 6 | 0 | 0 |
3649 | 3649 | 2021-07-02 | Trinity | 105 | 428 | 6 | 0 | 0 |
3707 | 3707 | 2021-07-01 | Trinity | 105 | 428 | 6 | 0 | 0 |
3765 | 3765 | 2021-06-30 | Trinity | 105 | 428 | 6 | 0 | 0 |
3823 | 3823 | 2021-06-29 | Trinity | 105 | 428 | 6 | 1 | 0 |
3881 | 3881 | 2021-06-28 | Trinity | 105 | 427 | 6 | 1 | 0 |
3939 | 3939 | 2021-06-27 | Trinity | 105 | 426 | 6 | 0 | 0 |
3997 | 3997 | 2021-06-26 | Trinity | 105 | 426 | 6 | 0 | 0 |
4055 | 4055 | 2021-06-25 | Trinity | 105 | 426 | 6 | 2 | 0 |
4113 | 4113 | 2021-06-24 | Trinity | 105 | 424 | 6 | 0 | 0 |
4171 | 4171 | 2021-06-23 | Trinity | 105 | 424 | 6 | 1 | 0 |
4229 | 4229 | 2021-06-22 | Trinity | 105 | 423 | 6 | 1 | 1 |
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 );