latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_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, did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
56 | 56 | Trinity | Trinity | 105 | 2021-09-02 | 692 | 10 | |
117 | 117 | Trinity | Trinity | 105 | 2021-09-01 | 675 | 10 | |
178 | 178 | Trinity | Trinity | 105 | 2021-08-31 | 653 | 10 | |
239 | 239 | Trinity | Trinity | 105 | 2021-08-30 | 641 | 8 | |
300 | 300 | Trinity | Trinity | 105 | 2021-08-29 | 632 | 8 | TRUE |
361 | 361 | Trinity | Trinity | 105 | 2021-08-28 | 632 | 8 | TRUE |
422 | 422 | Trinity | Trinity | 105 | 2021-08-27 | 632 | 8 | |
483 | 483 | Trinity | Trinity | 105 | 2021-08-26 | 622 | 8 | |
544 | 544 | Trinity | Trinity | 105 | 2021-08-25 | 610 | 8 | |
605 | 605 | Trinity | Trinity | 105 | 2021-08-24 | 597 | 8 | |
666 | 666 | Trinity | Trinity | 105 | 2021-08-23 | 584 | 8 | |
727 | 727 | Trinity | Trinity | 105 | 2021-08-22 | 565 | 8 | TRUE |
788 | 788 | Trinity | Trinity | 105 | 2021-08-21 | 565 | 8 | TRUE |
849 | 849 | Trinity | Trinity | 105 | 2021-08-20 | 565 | 8 | |
910 | 910 | Trinity | Trinity | 105 | 2021-08-19 | 555 | 8 | |
971 | 971 | Trinity | Trinity | 105 | 2021-08-18 | 545 | 8 | |
1032 | 1032 | Trinity | Trinity | 105 | 2021-08-17 | 542 | 7 | |
1093 | 1093 | Trinity | Trinity | 105 | 2021-08-16 | 532 | 7 | |
1154 | 1154 | Trinity | Trinity | 105 | 2021-08-15 | 526 | 7 | TRUE |
1215 | 1215 | Trinity | Trinity | 105 | 2021-08-14 | 526 | 7 | TRUE |
1276 | 1276 | Trinity | Trinity | 105 | 2021-08-13 | 526 | 7 | |
1337 | 1337 | Trinity | Trinity | 105 | 2021-08-12 | 519 | 7 | |
1398 | 1398 | Trinity | Trinity | 105 | 2021-08-11 | 514 | 6 | |
1459 | 1459 | Trinity | Trinity | 105 | 2021-08-10 | 508 | 6 | |
1520 | 1520 | Trinity | Trinity | 105 | 2021-08-09 | 504 | 6 | |
1581 | 1581 | Trinity | Trinity | 105 | 2021-08-08 | 495 | 6 | TRUE |
1642 | 1642 | Trinity | Trinity | 105 | 2021-08-07 | 495 | 6 | TRUE |
1703 | 1703 | Trinity | Trinity | 105 | 2021-08-06 | 495 | 6 | |
1764 | 1764 | Trinity | Trinity | 105 | 2021-08-05 | 487 | 6 | |
1825 | 1825 | Trinity | Trinity | 105 | 2021-08-04 | 474 | 6 | |
1886 | 1886 | Trinity | Trinity | 105 | 2021-08-03 | 469 | 6 | |
1947 | 1947 | Trinity | Trinity | 105 | 2021-08-02 | 469 | 6 | |
2008 | 2008 | Trinity | Trinity | 105 | 2021-08-01 | 467 | 6 | TRUE |
2069 | 2069 | Trinity | Trinity | 105 | 2021-07-31 | 467 | 6 | |
2130 | 2130 | Trinity | Trinity | 105 | 2021-07-30 | 462 | 6 | TRUE |
2191 | 2191 | Trinity | Trinity | 105 | 2021-07-29 | 462 | 6 | |
2252 | 2252 | Trinity | Trinity | 105 | 2021-07-28 | 459 | 6 | |
2313 | 2313 | Trinity | Trinity | 105 | 2021-07-27 | 456 | 6 | |
2374 | 2374 | Trinity | Trinity | 105 | 2021-07-26 | 453 | 6 | |
2435 | 2435 | Trinity | Trinity | 105 | 2021-07-25 | 451 | 6 | TRUE |
2496 | 2496 | Trinity | Trinity | 105 | 2021-07-24 | 451 | 6 | TRUE |
2557 | 2557 | Trinity | Trinity | 105 | 2021-07-23 | 451 | 6 | |
2618 | 2618 | Trinity | Trinity | 105 | 2021-07-22 | 448 | 6 | |
2679 | 2679 | Trinity | Trinity | 105 | 2021-07-21 | 443 | 6 | |
2740 | 2740 | Trinity | Trinity | 105 | 2021-07-20 | 441 | 6 | |
2801 | 2801 | Trinity | Trinity | 105 | 2021-07-19 | 440 | 6 | |
2862 | 2862 | Trinity | Trinity | 105 | 2021-07-18 | 437 | 6 | TRUE |
2923 | 2923 | Trinity | Trinity | 105 | 2021-07-17 | 437 | 6 | TRUE |
2984 | 2984 | Trinity | Trinity | 105 | 2021-07-16 | 437 | 6 | |
3045 | 3045 | Trinity | Trinity | 105 | 2021-07-15 | 435 | 6 | |
3106 | 3106 | Trinity | Trinity | 105 | 2021-07-14 | 432 | 6 | |
3167 | 3167 | Trinity | Trinity | 105 | 2021-07-13 | 430 | 6 | |
3228 | 3228 | Trinity | Trinity | 105 | 2021-07-12 | 429 | 6 | |
3289 | 3289 | Trinity | Trinity | 105 | 2021-07-11 | 428 | 6 | TRUE |
3350 | 3350 | Trinity | Trinity | 105 | 2021-07-10 | 428 | 6 | TRUE |
3411 | 3411 | Trinity | Trinity | 105 | 2021-07-09 | 428 | 6 | |
3472 | 3472 | Trinity | Trinity | 105 | 2021-07-08 | 428 | 6 | |
3533 | 3533 | Trinity | Trinity | 105 | 2021-07-07 | 428 | 6 | TRUE |
3594 | 3594 | Trinity | Trinity | 105 | 2021-07-06 | 428 | 6 | TRUE |
3655 | 3655 | Trinity | Trinity | 105 | 2021-07-05 | 428 | 6 | TRUE |
3716 | 3716 | Trinity | Trinity | 105 | 2021-07-04 | 428 | 6 | TRUE |
3777 | 3777 | Trinity | Trinity | 105 | 2021-07-03 | 428 | 6 | TRUE |
3838 | 3838 | Trinity | Trinity | 105 | 2021-07-02 | 428 | 6 | |
3899 | 3899 | Trinity | Trinity | 105 | 2021-07-01 | 428 | 6 | |
3960 | 3960 | Trinity | Trinity | 105 | 2021-06-30 | 428 | 6 | |
4021 | 4021 | Trinity | Trinity | 105 | 2021-06-29 | 428 | 6 | |
4082 | 4082 | Trinity | Trinity | 105 | 2021-06-28 | 427 | 6 | |
4143 | 4143 | Trinity | Trinity | 105 | 2021-06-27 | 426 | 6 | TRUE |
4204 | 4204 | Trinity | Trinity | 105 | 2021-06-26 | 426 | 6 | TRUE |
4265 | 4265 | Trinity | Trinity | 105 | 2021-06-25 | 426 | 6 | |
4326 | 4326 | Trinity | Trinity | 105 | 2021-06-24 | 424 | 6 | |
4387 | 4387 | Trinity | Trinity | 105 | 2021-06-23 | 424 | 6 | |
4448 | 4448 | Trinity | Trinity | 105 | 2021-06-22 | 423 | 6 | |
4509 | 4509 | Trinity | Trinity | 105 | 2021-06-21 | 422 | 5 | |
4570 | 4570 | Trinity | Trinity | 105 | 2021-06-20 | 422 | 5 | TRUE |
4631 | 4631 | Trinity | Trinity | 105 | 2021-06-19 | 422 | 5 | TRUE |
4692 | 4692 | Trinity | Trinity | 105 | 2021-06-18 | 422 | 5 | |
4753 | 4753 | Trinity | Trinity | 105 | 2021-06-17 | 422 | 5 | TRUE |
4814 | 4814 | Trinity | Trinity | 105 | 2021-06-16 | 422 | 5 | |
4875 | 4875 | Trinity | Trinity | 105 | 2021-06-15 | 417 | 5 | TRUE |
4936 | 4936 | Trinity | Trinity | 105 | 2021-06-14 | 417 | 5 | |
4997 | 4997 | Trinity | Trinity | 105 | 2021-06-13 | 416 | 5 | TRUE |
5058 | 5058 | Trinity | Trinity | 105 | 2021-06-12 | 416 | 5 | TRUE |
5119 | 5119 | Trinity | Trinity | 105 | 2021-06-11 | 416 | 5 | TRUE |
5180 | 5180 | Trinity | Trinity | 105 | 2021-06-10 | 416 | 5 | |
5241 | 5241 | Trinity | Trinity | 105 | 2021-06-09 | 416 | 5 | |
5302 | 5302 | Trinity | Trinity | 105 | 2021-06-08 | 416 | 5 | |
5363 | 5363 | Trinity | Trinity | 105 | 2021-06-07 | 414 | 5 | |
5424 | 5424 | Trinity | Trinity | 105 | 2021-06-06 | 411 | 5 | TRUE |
5485 | 5485 | Trinity | Trinity | 105 | 2021-06-05 | 411 | 5 | TRUE |
5546 | 5546 | Trinity | Trinity | 105 | 2021-06-04 | 411 | 5 | |
5607 | 5607 | Trinity | Trinity | 105 | 2021-06-03 | 411 | 5 | |
5668 | 5668 | Trinity | Trinity | 105 | 2021-06-02 | 411 | 5 | TRUE |
5729 | 5729 | Trinity | Trinity | 105 | 2021-06-01 | 411 | 5 | |
5790 | 5790 | Trinity | Trinity | 105 | 2021-05-31 | 411 | 5 | TRUE |
5851 | 5851 | Trinity | Trinity | 105 | 2021-05-30 | 411 | 5 | |
5912 | 5912 | Trinity | Trinity | 105 | 2021-05-29 | 411 | 5 | TRUE |
5973 | 5973 | Trinity | Trinity | 105 | 2021-05-28 | 411 | 5 | |
6034 | 6034 | Trinity | Trinity | 105 | 2021-05-27 | 411 | 5 | |
6095 | 6095 | Trinity | Trinity | 105 | 2021-05-26 | 411 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );