latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
492 rows where county = "Trinity" and fips = 105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
53 | 53 | 2021-09-02 | Trinity | 105 | 692 | 10 | 17 | 0 |
111 | 111 | 2021-09-01 | Trinity | 105 | 675 | 10 | 22 | 0 |
169 | 169 | 2021-08-31 | Trinity | 105 | 653 | 10 | 12 | 2 |
227 | 227 | 2021-08-30 | Trinity | 105 | 641 | 8 | 9 | 0 |
285 | 285 | 2021-08-29 | Trinity | 105 | 632 | 8 | 0 | 0 |
343 | 343 | 2021-08-28 | Trinity | 105 | 632 | 8 | 0 | 0 |
401 | 401 | 2021-08-27 | Trinity | 105 | 632 | 8 | 10 | 0 |
459 | 459 | 2021-08-26 | Trinity | 105 | 622 | 8 | 12 | 0 |
517 | 517 | 2021-08-25 | Trinity | 105 | 610 | 8 | 13 | 0 |
575 | 575 | 2021-08-24 | Trinity | 105 | 597 | 8 | 13 | 0 |
633 | 633 | 2021-08-23 | Trinity | 105 | 584 | 8 | 19 | 0 |
691 | 691 | 2021-08-22 | Trinity | 105 | 565 | 8 | 0 | 0 |
749 | 749 | 2021-08-21 | Trinity | 105 | 565 | 8 | 0 | 0 |
807 | 807 | 2021-08-20 | Trinity | 105 | 565 | 8 | 10 | 0 |
865 | 865 | 2021-08-19 | Trinity | 105 | 555 | 8 | 10 | 0 |
923 | 923 | 2021-08-18 | Trinity | 105 | 545 | 8 | 3 | 1 |
981 | 981 | 2021-08-17 | Trinity | 105 | 542 | 7 | 10 | 0 |
1039 | 1039 | 2021-08-16 | Trinity | 105 | 532 | 7 | 6 | 0 |
1097 | 1097 | 2021-08-15 | Trinity | 105 | 526 | 7 | 0 | 0 |
1155 | 1155 | 2021-08-14 | Trinity | 105 | 526 | 7 | 0 | 0 |
1213 | 1213 | 2021-08-13 | Trinity | 105 | 526 | 7 | 7 | 0 |
1271 | 1271 | 2021-08-12 | Trinity | 105 | 519 | 7 | 5 | 1 |
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 |
4287 | 4287 | 2021-06-21 | Trinity | 105 | 422 | 5 | 0 | 0 |
4345 | 4345 | 2021-06-20 | Trinity | 105 | 422 | 5 | 0 | 0 |
4403 | 4403 | 2021-06-19 | Trinity | 105 | 422 | 5 | 0 | 0 |
4461 | 4461 | 2021-06-18 | Trinity | 105 | 422 | 5 | 0 | 0 |
4519 | 4519 | 2021-06-17 | Trinity | 105 | 422 | 5 | 0 | 0 |
4577 | 4577 | 2021-06-16 | Trinity | 105 | 422 | 5 | 5 | 0 |
4635 | 4635 | 2021-06-15 | Trinity | 105 | 417 | 5 | 0 | 0 |
4693 | 4693 | 2021-06-14 | Trinity | 105 | 417 | 5 | 1 | 0 |
4751 | 4751 | 2021-06-13 | Trinity | 105 | 416 | 5 | 0 | 0 |
4809 | 4809 | 2021-06-12 | Trinity | 105 | 416 | 5 | 0 | 0 |
4867 | 4867 | 2021-06-11 | Trinity | 105 | 416 | 5 | 0 | 0 |
4925 | 4925 | 2021-06-10 | Trinity | 105 | 416 | 5 | 0 | 0 |
4983 | 4983 | 2021-06-09 | Trinity | 105 | 416 | 5 | 0 | 0 |
5041 | 5041 | 2021-06-08 | Trinity | 105 | 416 | 5 | 2 | 0 |
5099 | 5099 | 2021-06-07 | Trinity | 105 | 414 | 5 | 3 | 0 |
5157 | 5157 | 2021-06-06 | Trinity | 105 | 411 | 5 | 0 | 0 |
5215 | 5215 | 2021-06-05 | Trinity | 105 | 411 | 5 | 0 | 0 |
5273 | 5273 | 2021-06-04 | Trinity | 105 | 411 | 5 | 0 | 0 |
5331 | 5331 | 2021-06-03 | Trinity | 105 | 411 | 5 | 0 | 0 |
5389 | 5389 | 2021-06-02 | Trinity | 105 | 411 | 5 | 0 | 0 |
5447 | 5447 | 2021-06-01 | Trinity | 105 | 411 | 5 | 0 | 0 |
5505 | 5505 | 2021-05-31 | Trinity | 105 | 411 | 5 | 0 | 0 |
5563 | 5563 | 2021-05-30 | Trinity | 105 | 411 | 5 | 0 | 0 |
5621 | 5621 | 2021-05-29 | Trinity | 105 | 411 | 5 | 0 | 0 |
5679 | 5679 | 2021-05-28 | Trinity | 105 | 411 | 5 | 0 | 0 |
5737 | 5737 | 2021-05-27 | Trinity | 105 | 411 | 5 | 0 | 0 |
5795 | 5795 | 2021-05-26 | Trinity | 105 | 411 | 5 | 1 | 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 );