latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
537 rows where county = "San Bernardino" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6139 | 6139 | San Bernardino | San Bernardino | 71 | 2021-05-25 | 297688 | 4823 | |
6200 | 6200 | San Bernardino | San Bernardino | 71 | 2021-05-24 | 297615 | 4822 | |
6261 | 6261 | San Bernardino | San Bernardino | 71 | 2021-05-23 | 297566 | 4822 | |
6322 | 6322 | San Bernardino | San Bernardino | 71 | 2021-05-22 | 297539 | 4820 | |
6383 | 6383 | San Bernardino | San Bernardino | 71 | 2021-05-21 | 297479 | 4819 | |
6444 | 6444 | San Bernardino | San Bernardino | 71 | 2021-05-20 | 297417 | 4816 | |
6505 | 6505 | San Bernardino | San Bernardino | 71 | 2021-05-19 | 297349 | 4815 | |
6566 | 6566 | San Bernardino | San Bernardino | 71 | 2021-05-18 | 297300 | 4813 | |
6627 | 6627 | San Bernardino | San Bernardino | 71 | 2021-05-17 | 297261 | 4812 | |
6688 | 6688 | San Bernardino | San Bernardino | 71 | 2021-05-16 | 297165 | 4812 | TRUE |
6749 | 6749 | San Bernardino | San Bernardino | 71 | 2021-05-15 | 297165 | 4812 | |
6810 | 6810 | San Bernardino | San Bernardino | 71 | 2021-05-14 | 296903 | 4812 | |
6871 | 6871 | San Bernardino | San Bernardino | 71 | 2021-05-13 | 296839 | 4811 | |
6932 | 6932 | San Bernardino | San Bernardino | 71 | 2021-05-12 | 296782 | 4807 | |
6993 | 6993 | San Bernardino | San Bernardino | 71 | 2021-05-11 | 296700 | 4804 | |
7054 | 7054 | San Bernardino | San Bernardino | 71 | 2021-05-10 | 296655 | 4803 | |
7115 | 7115 | San Bernardino | San Bernardino | 71 | 2021-05-09 | 296596 | 4803 | |
7176 | 7176 | San Bernardino | San Bernardino | 71 | 2021-05-08 | 296514 | 4802 | |
7237 | 7237 | San Bernardino | San Bernardino | 71 | 2021-05-07 | 296425 | 4800 | |
7298 | 7298 | San Bernardino | San Bernardino | 71 | 2021-05-06 | 296324 | 4799 | |
7359 | 7359 | San Bernardino | San Bernardino | 71 | 2021-05-05 | 296257 | 4799 | |
7420 | 7420 | San Bernardino | San Bernardino | 71 | 2021-05-04 | 296188 | 4799 | |
7481 | 7481 | San Bernardino | San Bernardino | 71 | 2021-05-03 | 296146 | 4796 | |
7542 | 7542 | San Bernardino | San Bernardino | 71 | 2021-05-02 | 296089 | 4794 | |
7603 | 7603 | San Bernardino | San Bernardino | 71 | 2021-05-01 | 296009 | 4792 | |
7664 | 7664 | San Bernardino | San Bernardino | 71 | 2021-04-30 | 295899 | 4791 | |
7725 | 7725 | San Bernardino | San Bernardino | 71 | 2021-04-29 | 295806 | 4791 | |
7786 | 7786 | San Bernardino | San Bernardino | 71 | 2021-04-28 | 295752 | 4789 | |
7847 | 7847 | San Bernardino | San Bernardino | 71 | 2021-04-27 | 295665 | 4789 | |
7908 | 7908 | San Bernardino | San Bernardino | 71 | 2021-04-26 | 295565 | 4787 | |
7969 | 7969 | San Bernardino | San Bernardino | 71 | 2021-04-25 | 295510 | 4786 | |
8030 | 8030 | San Bernardino | San Bernardino | 71 | 2021-04-24 | 295452 | 4785 | |
8091 | 8091 | San Bernardino | San Bernardino | 71 | 2021-04-23 | 295390 | 4785 | |
8152 | 8152 | San Bernardino | San Bernardino | 71 | 2021-04-22 | 295315 | 4785 | |
8213 | 8213 | San Bernardino | San Bernardino | 71 | 2021-04-21 | 295131 | 4784 | |
8274 | 8274 | San Bernardino | San Bernardino | 71 | 2021-04-20 | 294973 | 4780 | |
8335 | 8335 | San Bernardino | San Bernardino | 71 | 2021-04-19 | 294883 | 4777 | |
8396 | 8396 | San Bernardino | San Bernardino | 71 | 2021-04-18 | 294779 | 4776 | |
8457 | 8457 | San Bernardino | San Bernardino | 71 | 2021-04-17 | 294577 | 4775 | |
8518 | 8518 | San Bernardino | San Bernardino | 71 | 2021-04-16 | 294464 | 4773 | |
8579 | 8579 | San Bernardino | San Bernardino | 71 | 2021-04-15 | 294262 | 4773 | |
8640 | 8640 | San Bernardino | San Bernardino | 71 | 2021-04-14 | 294101 | 4772 | |
8701 | 8701 | San Bernardino | San Bernardino | 71 | 2021-04-13 | 293925 | 4770 | |
8762 | 8762 | San Bernardino | San Bernardino | 71 | 2021-04-12 | 293835 | 4767 | |
8823 | 8823 | San Bernardino | San Bernardino | 71 | 2021-04-11 | 293638 | 4766 | |
8884 | 8884 | San Bernardino | San Bernardino | 71 | 2021-04-10 | 292558 | 4764 | |
8945 | 8945 | San Bernardino | San Bernardino | 71 | 2021-04-09 | 292358 | 4762 | |
9006 | 9006 | San Bernardino | San Bernardino | 71 | 2021-04-08 | 292160 | 4759 | |
9067 | 9067 | San Bernardino | San Bernardino | 71 | 2021-04-07 | 291989 | 4755 | |
9128 | 9128 | San Bernardino | San Bernardino | 71 | 2021-04-06 | 291728 | 4753 | |
9189 | 9189 | San Bernardino | San Bernardino | 71 | 2021-04-05 | 291727 | 4752 | |
9250 | 9250 | San Bernardino | San Bernardino | 71 | 2021-04-04 | 291648 | 4748 | |
9311 | 9311 | San Bernardino | San Bernardino | 71 | 2021-04-03 | 291360 | 4747 | |
9372 | 9372 | San Bernardino | San Bernardino | 71 | 2021-04-02 | 291199 | 4744 | |
9433 | 9433 | San Bernardino | San Bernardino | 71 | 2021-04-01 | 291022 | 4744 | |
9494 | 9494 | San Bernardino | San Bernardino | 71 | 2021-03-31 | 290954 | 4740 | |
9555 | 9555 | San Bernardino | San Bernardino | 71 | 2021-03-30 | 290803 | 4735 | |
9616 | 9616 | San Bernardino | San Bernardino | 71 | 2021-03-29 | 290715 | 4733 | |
9677 | 9677 | San Bernardino | San Bernardino | 71 | 2021-03-28 | 290630 | 4729 | |
9738 | 9738 | San Bernardino | San Bernardino | 71 | 2021-03-27 | 290505 | 4727 | |
9799 | 9799 | San Bernardino | San Bernardino | 71 | 2021-03-26 | 290315 | 4727 | |
9860 | 9860 | San Bernardino | San Bernardino | 71 | 2021-03-25 | 290155 | 4719 | |
9921 | 9921 | San Bernardino | San Bernardino | 71 | 2021-03-24 | 290030 | 4716 | |
9982 | 9982 | San Bernardino | San Bernardino | 71 | 2021-03-23 | 289892 | 4714 | |
10043 | 10043 | San Bernardino | San Bernardino | 71 | 2021-03-22 | 289846 | 4714 | |
10104 | 10104 | San Bernardino | San Bernardino | 71 | 2021-03-21 | 289773 | 4710 | |
10165 | 10165 | San Bernardino | San Bernardino | 71 | 2021-03-20 | 289610 | 4710 | |
10226 | 10226 | San Bernardino | San Bernardino | 71 | 2021-03-19 | 289405 | 4703 | |
10287 | 10287 | San Bernardino | San Bernardino | 71 | 2021-03-18 | 289242 | 4700 | |
10348 | 10348 | San Bernardino | San Bernardino | 71 | 2021-03-17 | 289057 | 4697 | |
10409 | 10409 | San Bernardino | San Bernardino | 71 | 2021-03-16 | 288932 | 4693 | |
10470 | 10470 | San Bernardino | San Bernardino | 71 | 2021-03-15 | 288868 | 4689 | |
10531 | 10531 | San Bernardino | San Bernardino | 71 | 2021-03-14 | 288787 | 4687 | |
10592 | 10592 | San Bernardino | San Bernardino | 71 | 2021-03-13 | 288599 | 4686 | |
10653 | 10653 | San Bernardino | San Bernardino | 71 | 2021-03-12 | 288364 | 4684 | |
10714 | 10714 | San Bernardino | San Bernardino | 71 | 2021-03-11 | 288297 | 4681 | |
10775 | 10775 | San Bernardino | San Bernardino | 71 | 2021-03-10 | 288135 | 4679 | |
10836 | 10836 | San Bernardino | San Bernardino | 71 | 2021-03-09 | 288045 | 4674 | |
10897 | 10897 | San Bernardino | San Bernardino | 71 | 2021-03-08 | 288044 | 4669 | |
10958 | 10958 | San Bernardino | San Bernardino | 71 | 2021-03-07 | 287867 | 4660 | |
11019 | 11019 | San Bernardino | San Bernardino | 71 | 2021-03-06 | 287782 | 4655 | |
11080 | 11080 | San Bernardino | San Bernardino | 71 | 2021-03-05 | 287513 | 4648 | |
11141 | 11141 | San Bernardino | San Bernardino | 71 | 2021-03-04 | 287246 | 4643 | |
11202 | 11202 | San Bernardino | San Bernardino | 71 | 2021-03-03 | 287055 | 4636 | |
11263 | 11263 | San Bernardino | San Bernardino | 71 | 2021-03-02 | 286814 | 4630 | |
11324 | 11324 | San Bernardino | San Bernardino | 71 | 2021-03-01 | 286755 | 4628 | |
11385 | 11385 | San Bernardino | San Bernardino | 71 | 2021-02-28 | 286607 | 4619 | |
11446 | 11446 | San Bernardino | San Bernardino | 71 | 2021-02-27 | 286291 | 4613 | |
11507 | 11507 | San Bernardino | San Bernardino | 71 | 2021-02-26 | 286077 | 4606 | |
11568 | 11568 | San Bernardino | San Bernardino | 71 | 2021-02-25 | 285334 | 4599 | TRUE |
11629 | 11629 | San Bernardino | San Bernardino | 71 | 2021-02-24 | 285334 | 4590 | |
11690 | 11690 | San Bernardino | San Bernardino | 71 | 2021-02-23 | 285081 | 4580 | |
11751 | 11751 | San Bernardino | San Bernardino | 71 | 2021-02-22 | 284866 | 4571 | |
11812 | 11812 | San Bernardino | San Bernardino | 71 | 2021-02-21 | 284639 | 4564 | |
11873 | 11873 | San Bernardino | San Bernardino | 71 | 2021-02-20 | 284280 | 4556 | |
11934 | 11934 | San Bernardino | San Bernardino | 71 | 2021-02-19 | 283873 | 4550 | |
11995 | 11995 | San Bernardino | San Bernardino | 71 | 2021-02-18 | 283356 | 4534 | |
12056 | 12056 | San Bernardino | San Bernardino | 71 | 2021-02-17 | 282736 | 4524 | |
12117 | 12117 | San Bernardino | San Bernardino | 71 | 2021-02-16 | 282494 | 4511 | |
12178 | 12178 | San Bernardino | San Bernardino | 71 | 2021-02-15 | 282494 | 4497 |
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 );