latimes_county_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals

537 rows where county = "San Bernardino" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

county 1

  • San Bernardino · 537 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
36 36 2021-09-02 San Bernardino 71 332082 4924 484 6
94 94 2021-09-01 San Bernardino 71 331598 4918 689 1
152 152 2021-08-31 San Bernardino 71 330909 4917 2129 3
210 210 2021-08-30 San Bernardino 71 328780 4914 1025 4
268 268 2021-08-29 San Bernardino 71 327755 4910 0 0
326 326 2021-08-28 San Bernardino 71 327755 4910 0 0
384 384 2021-08-27 San Bernardino 71 327755 4910 773 2
442 442 2021-08-26 San Bernardino 71 326982 4908 589 3
500 500 2021-08-25 San Bernardino 71 326393 4905 1056 4
558 558 2021-08-24 San Bernardino 71 325337 4901 2290 2
616 616 2021-08-23 San Bernardino 71 323047 4899 935 6
674 674 2021-08-22 San Bernardino 71 322112 4893 0 0
732 732 2021-08-21 San Bernardino 71 322112 4893 0 0
790 790 2021-08-20 San Bernardino 71 322112 4893 957 15
848 848 2021-08-19 San Bernardino 71 321155 4878 2317 3
906 906 2021-08-18 San Bernardino 71 318838 4875 0 0
964 964 2021-08-17 San Bernardino 71 318838 4875 1638 1
1022 1022 2021-08-16 San Bernardino 71 317200 4874 947 7
1080 1080 2021-08-15 San Bernardino 71 316253 4867 0 0
1138 1138 2021-08-14 San Bernardino 71 316253 4867 0 0
1196 1196 2021-08-13 San Bernardino 71 316253 4867 1064 0
1254 1254 2021-08-12 San Bernardino 71 315189 4867 759 0
1312 1312 2021-08-11 San Bernardino 71 314430 4867 1281 2
1370 1370 2021-08-10 San Bernardino 71 313149 4865 1567 3
1428 1428 2021-08-09 San Bernardino 71 311582 4862 1082 1
1486 1486 2021-08-08 San Bernardino 71 310500 4861 0 0
1544 1544 2021-08-07 San Bernardino 71 310500 4861 0 0
1602 1602 2021-08-06 San Bernardino 71 310500 4861 697 0
1660 1660 2021-08-05 San Bernardino 71 309803 4861 301 3
1718 1718 2021-08-04 San Bernardino 71 309502 4858 622 2
1776 1776 2021-08-03 San Bernardino 71 308880 4856 828 0
1834 1834 2021-08-02 San Bernardino 71 308052 4856 1283 0
1892 1892 2021-08-01 San Bernardino 71 306769 4856 0 0
1950 1950 2021-07-31 San Bernardino 71 306769 4856 496 0
2008 2008 2021-07-30 San Bernardino 71 306273 4856 0 0
2066 2066 2021-07-29 San Bernardino 71 306273 4856 446 0
2124 2124 2021-07-28 San Bernardino 71 305827 4856 404 0
2182 2182 2021-07-27 San Bernardino 71 305423 4856 902 0
2240 2240 2021-07-26 San Bernardino 71 304521 4856 446 0
2298 2298 2021-07-25 San Bernardino 71 304075 4856 0 0
2356 2356 2021-07-24 San Bernardino 71 304075 4856 0 0
2414 2414 2021-07-23 San Bernardino 71 304075 4856 402 0
2472 2472 2021-07-22 San Bernardino 71 303673 4856 323 0
2530 2530 2021-07-21 San Bernardino 71 303350 4856 184 0
2588 2588 2021-07-20 San Bernardino 71 303166 4856 737 0
2646 2646 2021-07-19 San Bernardino 71 302429 4856 191 1
2704 2704 2021-07-18 San Bernardino 71 302238 4855 0 0
2762 2762 2021-07-17 San Bernardino 71 302238 4855 0 0
2820 2820 2021-07-16 San Bernardino 71 302238 4855 209 0
2878 2878 2021-07-15 San Bernardino 71 302029 4855 227 1
2936 2936 2021-07-14 San Bernardino 71 301802 4854 248 0
2994 2994 2021-07-13 San Bernardino 71 301554 4854 558 1
3052 3052 2021-07-12 San Bernardino 71 300996 4853 360 3
3110 3110 2021-07-11 San Bernardino 71 300636 4850 0 0
3168 3168 2021-07-10 San Bernardino 71 300636 4850 0 0
3226 3226 2021-07-09 San Bernardino 71 300636 4850 203 1
3284 3284 2021-07-08 San Bernardino 71 300433 4849 215 1
3342 3342 2021-07-07 San Bernardino 71 300218 4848 173 0
3400 3400 2021-07-06 San Bernardino 71 300045 4848 97 1
3458 3458 2021-07-05 San Bernardino 71 299948 4847 0 2
3516 3516 2021-07-04 San Bernardino 71 299948 4845 0 0
3574 3574 2021-07-03 San Bernardino 71 299948 4845 0 0
3632 3632 2021-07-02 San Bernardino 71 299948 4845 65 0
3690 3690 2021-07-01 San Bernardino 71 299883 4845 120 1
3748 3748 2021-06-30 San Bernardino 71 299763 4844 33 3
3806 3806 2021-06-29 San Bernardino 71 299730 4841 58 0
3864 3864 2021-06-28 San Bernardino 71 299672 4841 68 0
3922 3922 2021-06-27 San Bernardino 71 299604 4841 102 1
3980 3980 2021-06-26 San Bernardino 71 299502 4840 22 0
4038 4038 2021-06-25 San Bernardino 71 299480 4840 55 0
4096 4096 2021-06-24 San Bernardino 71 299425 4840 53 0
4154 4154 2021-06-23 San Bernardino 71 299372 4840 52 0
4212 4212 2021-06-22 San Bernardino 71 299320 4840 31 3
4270 4270 2021-06-21 San Bernardino 71 299289 4837 0 0
4328 4328 2021-06-20 San Bernardino 71 299289 4837 46 0
4386 4386 2021-06-19 San Bernardino 71 299243 4837 57 0
4444 4444 2021-06-18 San Bernardino 71 299186 4837 35 1
4502 4502 2021-06-17 San Bernardino 71 299151 4836 55 1
4560 4560 2021-06-16 San Bernardino 71 299096 4835 47 0
4618 4618 2021-06-15 San Bernardino 71 299049 4835 35 1
4676 4676 2021-06-14 San Bernardino 71 299014 4834 38 1
4734 4734 2021-06-13 San Bernardino 71 298976 4833 37 0
4792 4792 2021-06-12 San Bernardino 71 298939 4833 41 1
4850 4850 2021-06-11 San Bernardino 71 298898 4832 55 0
4908 4908 2021-06-10 San Bernardino 71 298843 4832 35 1
4966 4966 2021-06-09 San Bernardino 71 298808 4831 80 0
5024 5024 2021-06-08 San Bernardino 71 298728 4831 31 0
5082 5082 2021-06-07 San Bernardino 71 298697 4831 21 1
5140 5140 2021-06-06 San Bernardino 71 298676 4830 20 2
5198 5198 2021-06-05 San Bernardino 71 298656 4828 13 0
5256 5256 2021-06-04 San Bernardino 71 298643 4828 44 0
5314 5314 2021-06-03 San Bernardino 71 298599 4828 54 0
5372 5372 2021-06-02 San Bernardino 71 298545 4828 0 0
5430 5430 2021-06-01 San Bernardino 71 298545 4828 256 0
5488 5488 2021-05-31 San Bernardino 71 298289 4828 0 0
5546 5546 2021-05-30 San Bernardino 71 298289 4828 0 0
5604 5604 2021-05-29 San Bernardino 71 298289 4828 0 1
5662 5662 2021-05-28 San Bernardino 71 298289 4827 207 1
5720 5720 2021-05-27 San Bernardino 71 298082 4826 234 0
5778 5778 2021-05-26 San Bernardino 71 297848 4826 160 3

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);