latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
537 rows where agency = "San Bernardino", county = "San Bernardino" and fips = 71 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
39 | 39 | San Bernardino | San Bernardino | 71 | 2021-09-02 | 332082 | 4924 | |
100 | 100 | San Bernardino | San Bernardino | 71 | 2021-09-01 | 331598 | 4918 | |
161 | 161 | San Bernardino | San Bernardino | 71 | 2021-08-31 | 330909 | 4917 | |
222 | 222 | San Bernardino | San Bernardino | 71 | 2021-08-30 | 328780 | 4914 | |
283 | 283 | San Bernardino | San Bernardino | 71 | 2021-08-29 | 327755 | 4910 | TRUE |
344 | 344 | San Bernardino | San Bernardino | 71 | 2021-08-28 | 327755 | 4910 | TRUE |
405 | 405 | San Bernardino | San Bernardino | 71 | 2021-08-27 | 327755 | 4910 | |
466 | 466 | San Bernardino | San Bernardino | 71 | 2021-08-26 | 326982 | 4908 | |
527 | 527 | San Bernardino | San Bernardino | 71 | 2021-08-25 | 326393 | 4905 | |
588 | 588 | San Bernardino | San Bernardino | 71 | 2021-08-24 | 325337 | 4901 | |
649 | 649 | San Bernardino | San Bernardino | 71 | 2021-08-23 | 323047 | 4899 | |
710 | 710 | San Bernardino | San Bernardino | 71 | 2021-08-22 | 322112 | 4893 | TRUE |
771 | 771 | San Bernardino | San Bernardino | 71 | 2021-08-21 | 322112 | 4893 | TRUE |
832 | 832 | San Bernardino | San Bernardino | 71 | 2021-08-20 | 322112 | 4893 | |
893 | 893 | San Bernardino | San Bernardino | 71 | 2021-08-19 | 321155 | 4878 | |
954 | 954 | San Bernardino | San Bernardino | 71 | 2021-08-18 | 318838 | 4875 | TRUE |
1015 | 1015 | San Bernardino | San Bernardino | 71 | 2021-08-17 | 318838 | 4875 | |
1076 | 1076 | San Bernardino | San Bernardino | 71 | 2021-08-16 | 317200 | 4874 | |
1137 | 1137 | San Bernardino | San Bernardino | 71 | 2021-08-15 | 316253 | 4867 | TRUE |
1198 | 1198 | San Bernardino | San Bernardino | 71 | 2021-08-14 | 316253 | 4867 | TRUE |
1259 | 1259 | San Bernardino | San Bernardino | 71 | 2021-08-13 | 316253 | 4867 | |
1320 | 1320 | San Bernardino | San Bernardino | 71 | 2021-08-12 | 315189 | 4867 | |
1381 | 1381 | San Bernardino | San Bernardino | 71 | 2021-08-11 | 314430 | 4867 | |
1442 | 1442 | San Bernardino | San Bernardino | 71 | 2021-08-10 | 313149 | 4865 | |
1503 | 1503 | San Bernardino | San Bernardino | 71 | 2021-08-09 | 311582 | 4862 | |
1564 | 1564 | San Bernardino | San Bernardino | 71 | 2021-08-08 | 310500 | 4861 | TRUE |
1625 | 1625 | San Bernardino | San Bernardino | 71 | 2021-08-07 | 310500 | 4861 | TRUE |
1686 | 1686 | San Bernardino | San Bernardino | 71 | 2021-08-06 | 310500 | 4861 | |
1747 | 1747 | San Bernardino | San Bernardino | 71 | 2021-08-05 | 309803 | 4861 | |
1808 | 1808 | San Bernardino | San Bernardino | 71 | 2021-08-04 | 309502 | 4858 | |
1869 | 1869 | San Bernardino | San Bernardino | 71 | 2021-08-03 | 308880 | 4856 | |
1930 | 1930 | San Bernardino | San Bernardino | 71 | 2021-08-02 | 308052 | 4856 | |
1991 | 1991 | San Bernardino | San Bernardino | 71 | 2021-08-01 | 306769 | 4856 | |
2052 | 2052 | San Bernardino | San Bernardino | 71 | 2021-07-31 | 306769 | 4856 | |
2113 | 2113 | San Bernardino | San Bernardino | 71 | 2021-07-30 | 306273 | 4856 | |
2174 | 2174 | San Bernardino | San Bernardino | 71 | 2021-07-29 | 306273 | 4856 | |
2235 | 2235 | San Bernardino | San Bernardino | 71 | 2021-07-28 | 305827 | 4856 | |
2296 | 2296 | San Bernardino | San Bernardino | 71 | 2021-07-27 | 305423 | 4856 | |
2357 | 2357 | San Bernardino | San Bernardino | 71 | 2021-07-26 | 304521 | 4856 | |
2418 | 2418 | San Bernardino | San Bernardino | 71 | 2021-07-25 | 304075 | 4856 | TRUE |
2479 | 2479 | San Bernardino | San Bernardino | 71 | 2021-07-24 | 304075 | 4856 | TRUE |
2540 | 2540 | San Bernardino | San Bernardino | 71 | 2021-07-23 | 304075 | 4856 | |
2601 | 2601 | San Bernardino | San Bernardino | 71 | 2021-07-22 | 303673 | 4856 | |
2662 | 2662 | San Bernardino | San Bernardino | 71 | 2021-07-21 | 303350 | 4856 | |
2723 | 2723 | San Bernardino | San Bernardino | 71 | 2021-07-20 | 303166 | 4856 | |
2784 | 2784 | San Bernardino | San Bernardino | 71 | 2021-07-19 | 302429 | 4856 | |
2845 | 2845 | San Bernardino | San Bernardino | 71 | 2021-07-18 | 302238 | 4855 | TRUE |
2906 | 2906 | San Bernardino | San Bernardino | 71 | 2021-07-17 | 302238 | 4855 | TRUE |
2967 | 2967 | San Bernardino | San Bernardino | 71 | 2021-07-16 | 302238 | 4855 | |
3028 | 3028 | San Bernardino | San Bernardino | 71 | 2021-07-15 | 302029 | 4855 | |
3089 | 3089 | San Bernardino | San Bernardino | 71 | 2021-07-14 | 301802 | 4854 | |
3150 | 3150 | San Bernardino | San Bernardino | 71 | 2021-07-13 | 301554 | 4854 | |
3211 | 3211 | San Bernardino | San Bernardino | 71 | 2021-07-12 | 300996 | 4853 | |
3272 | 3272 | San Bernardino | San Bernardino | 71 | 2021-07-11 | 300636 | 4850 | TRUE |
3333 | 3333 | San Bernardino | San Bernardino | 71 | 2021-07-10 | 300636 | 4850 | TRUE |
3394 | 3394 | San Bernardino | San Bernardino | 71 | 2021-07-09 | 300636 | 4850 | |
3455 | 3455 | San Bernardino | San Bernardino | 71 | 2021-07-08 | 300433 | 4849 | |
3516 | 3516 | San Bernardino | San Bernardino | 71 | 2021-07-07 | 300218 | 4848 | |
3577 | 3577 | San Bernardino | San Bernardino | 71 | 2021-07-06 | 300045 | 4848 | |
3638 | 3638 | San Bernardino | San Bernardino | 71 | 2021-07-05 | 299948 | 4847 | |
3699 | 3699 | San Bernardino | San Bernardino | 71 | 2021-07-04 | 299948 | 4845 | TRUE |
3760 | 3760 | San Bernardino | San Bernardino | 71 | 2021-07-03 | 299948 | 4845 | TRUE |
3821 | 3821 | San Bernardino | San Bernardino | 71 | 2021-07-02 | 299948 | 4845 | |
3882 | 3882 | San Bernardino | San Bernardino | 71 | 2021-07-01 | 299883 | 4845 | |
3943 | 3943 | San Bernardino | San Bernardino | 71 | 2021-06-30 | 299763 | 4844 | |
4004 | 4004 | San Bernardino | San Bernardino | 71 | 2021-06-29 | 299730 | 4841 | |
4065 | 4065 | San Bernardino | San Bernardino | 71 | 2021-06-28 | 299672 | 4841 | |
4126 | 4126 | San Bernardino | San Bernardino | 71 | 2021-06-27 | 299604 | 4841 | |
4187 | 4187 | San Bernardino | San Bernardino | 71 | 2021-06-26 | 299502 | 4840 | |
4248 | 4248 | San Bernardino | San Bernardino | 71 | 2021-06-25 | 299480 | 4840 | |
4309 | 4309 | San Bernardino | San Bernardino | 71 | 2021-06-24 | 299425 | 4840 | |
4370 | 4370 | San Bernardino | San Bernardino | 71 | 2021-06-23 | 299372 | 4840 | |
4431 | 4431 | San Bernardino | San Bernardino | 71 | 2021-06-22 | 299320 | 4840 | |
4492 | 4492 | San Bernardino | San Bernardino | 71 | 2021-06-21 | 299289 | 4837 | |
4553 | 4553 | San Bernardino | San Bernardino | 71 | 2021-06-20 | 299289 | 4837 | |
4614 | 4614 | San Bernardino | San Bernardino | 71 | 2021-06-19 | 299243 | 4837 | |
4675 | 4675 | San Bernardino | San Bernardino | 71 | 2021-06-18 | 299186 | 4837 | |
4736 | 4736 | San Bernardino | San Bernardino | 71 | 2021-06-17 | 299151 | 4836 | |
4797 | 4797 | San Bernardino | San Bernardino | 71 | 2021-06-16 | 299096 | 4835 | |
4858 | 4858 | San Bernardino | San Bernardino | 71 | 2021-06-15 | 299049 | 4835 | |
4919 | 4919 | San Bernardino | San Bernardino | 71 | 2021-06-14 | 299014 | 4834 | |
4980 | 4980 | San Bernardino | San Bernardino | 71 | 2021-06-13 | 298976 | 4833 | |
5041 | 5041 | San Bernardino | San Bernardino | 71 | 2021-06-12 | 298939 | 4833 | |
5102 | 5102 | San Bernardino | San Bernardino | 71 | 2021-06-11 | 298898 | 4832 | |
5163 | 5163 | San Bernardino | San Bernardino | 71 | 2021-06-10 | 298843 | 4832 | |
5224 | 5224 | San Bernardino | San Bernardino | 71 | 2021-06-09 | 298808 | 4831 | |
5285 | 5285 | San Bernardino | San Bernardino | 71 | 2021-06-08 | 298728 | 4831 | |
5346 | 5346 | San Bernardino | San Bernardino | 71 | 2021-06-07 | 298697 | 4831 | |
5407 | 5407 | San Bernardino | San Bernardino | 71 | 2021-06-06 | 298676 | 4830 | |
5468 | 5468 | San Bernardino | San Bernardino | 71 | 2021-06-05 | 298656 | 4828 | |
5529 | 5529 | San Bernardino | San Bernardino | 71 | 2021-06-04 | 298643 | 4828 | |
5590 | 5590 | San Bernardino | San Bernardino | 71 | 2021-06-03 | 298599 | 4828 | |
5651 | 5651 | San Bernardino | San Bernardino | 71 | 2021-06-02 | 298545 | 4828 | TRUE |
5712 | 5712 | San Bernardino | San Bernardino | 71 | 2021-06-01 | 298545 | 4828 | |
5773 | 5773 | San Bernardino | San Bernardino | 71 | 2021-05-31 | 298289 | 4828 | TRUE |
5834 | 5834 | San Bernardino | San Bernardino | 71 | 2021-05-30 | 298289 | 4828 | |
5895 | 5895 | San Bernardino | San Bernardino | 71 | 2021-05-29 | 298289 | 4828 | TRUE |
5956 | 5956 | San Bernardino | San Bernardino | 71 | 2021-05-28 | 298289 | 4827 | |
6017 | 6017 | San Bernardino | San Bernardino | 71 | 2021-05-27 | 298082 | 4826 | |
6078 | 6078 | San Bernardino | San Bernardino | 71 | 2021-05-26 | 297848 | 4826 |
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 );