latimes_county_totals
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 new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
268 | 268 | 2021-08-29 | San Bernardino | 71 | 327755 | 4910 | 0 | 0 |
326 | 326 | 2021-08-28 | San Bernardino | 71 | 327755 | 4910 | 0 | 0 |
674 | 674 | 2021-08-22 | San Bernardino | 71 | 322112 | 4893 | 0 | 0 |
732 | 732 | 2021-08-21 | San Bernardino | 71 | 322112 | 4893 | 0 | 0 |
906 | 906 | 2021-08-18 | San Bernardino | 71 | 318838 | 4875 | 0 | 0 |
1080 | 1080 | 2021-08-15 | San Bernardino | 71 | 316253 | 4867 | 0 | 0 |
1138 | 1138 | 2021-08-14 | San Bernardino | 71 | 316253 | 4867 | 0 | 0 |
1486 | 1486 | 2021-08-08 | San Bernardino | 71 | 310500 | 4861 | 0 | 0 |
1544 | 1544 | 2021-08-07 | San Bernardino | 71 | 310500 | 4861 | 0 | 0 |
1892 | 1892 | 2021-08-01 | San Bernardino | 71 | 306769 | 4856 | 0 | 0 |
2008 | 2008 | 2021-07-30 | San Bernardino | 71 | 306273 | 4856 | 0 | 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 |
2704 | 2704 | 2021-07-18 | San Bernardino | 71 | 302238 | 4855 | 0 | 0 |
2762 | 2762 | 2021-07-17 | San Bernardino | 71 | 302238 | 4855 | 0 | 0 |
3110 | 3110 | 2021-07-11 | San Bernardino | 71 | 300636 | 4850 | 0 | 0 |
3168 | 3168 | 2021-07-10 | San Bernardino | 71 | 300636 | 4850 | 0 | 0 |
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 |
4270 | 4270 | 2021-06-21 | San Bernardino | 71 | 299289 | 4837 | 0 | 0 |
5372 | 5372 | 2021-06-02 | San Bernardino | 71 | 298545 | 4828 | 0 | 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 |
6358 | 6358 | 2021-05-16 | San Bernardino | 71 | 297165 | 4812 | 0 | 0 |
10998 | 10998 | 2021-02-25 | San Bernardino | 71 | 285334 | 4599 | 0 | 9 |
11520 | 11520 | 2021-02-16 | San Bernardino | 71 | 282494 | 4511 | 0 | 14 |
12042 | 12042 | 2021-02-07 | San Bernardino | 71 | 277949 | 4338 | 0 | 24 |
14130 | 14130 | 2021-01-02 | San Bernardino | 71 | 194377 | 2816 | 0 | 54 |
14188 | 14188 | 2021-01-01 | San Bernardino | 71 | 194377 | 2762 | 0 | 55 |
14594 | 14594 | 2020-12-25 | San Bernardino | 71 | 174091 | 2369 | 0 | 64 |
14884 | 14884 | 2020-12-20 | San Bernardino | 71 | 157655 | 2103 | 0 | 39 |
16276 | 16276 | 2020-11-26 | San Bernardino | 71 | 88453 | 1428 | 0 | 9 |
20858 | 20858 | 2020-09-08 | San Bernardino | 71 | 49691 | 1031 | 0 | 6 |
21090 | 21090 | 2020-09-04 | San Bernardino | 71 | 48615 | 1010 | 0 | 3 |
23990 | 23990 | 2020-07-16 | San Bernardino | 71 | 21468 | 480 | 0 | 13 |
25092 | 25092 | 2020-06-27 | San Bernardino | 71 | 11290 | 304 | 0 | 4 |
26252 | 26252 | 2020-06-07 | San Bernardino | 71 | 6040 | 234 | 0 | 0 |
27006 | 27006 | 2020-05-25 | San Bernardino | 71 | 4365 | 196 | 0 | 3 |
28224 | 28224 | 2020-05-04 | San Bernardino | 71 | 2182 | 121 | 0 | 3 |
28282 | 28282 | 2020-05-03 | San Bernardino | 71 | 2182 | 118 | 0 | 1 |
29312 | 29312 | 2020-04-14 | San Bernardino | 71 | 977 | 50 | 0 | 6 |
29471 | 29471 | 2020-04-11 | San Bernardino | 71 | 810 | 35 | 0 | 3 |
30096 | 30096 | 2020-03-30 | San Bernardino | 71 | 111 | 7 | 0 | 2 |
30411 | 30411 | 2020-03-23 | San Bernardino | 71 | 17 | 0 | 0 | 0 |
30566 | 30566 | 2020-03-19 | San Bernardino | 71 | 5 | 0 | 0 | 0 |
8678 | 8678 | 2021-04-06 | San Bernardino | 71 | 291728 | 4753 | 1 | 1 |
10302 | 10302 | 2021-03-09 | San Bernardino | 71 | 288045 | 4674 | 1 | 5 |
29789 | 29789 | 2020-04-05 | San Bernardino | 71 | 373 | 19 | 1 | 4 |
30282 | 30282 | 2020-03-26 | San Bernardino | 71 | 55 | 3 | 1 | 1 |
30493 | 30493 | 2020-03-21 | San Bernardino | 71 | 10 | 0 | 1 | 0 |
30635 | 30635 | 2020-03-17 | San Bernardino | 71 | 3 | 0 | 1 | 0 |
30667 | 30667 | 2020-03-16 | San Bernardino | 71 | 2 | 0 | 1 | 0 |
30601 | 30601 | 2020-03-18 | San Bernardino | 71 | 5 | 0 | 2 | 0 |
19698 | 19698 | 2020-09-28 | San Bernardino | 71 | 54482 | 1110 | 4 | 5 |
30531 | 30531 | 2020-03-20 | San Bernardino | 71 | 9 | 0 | 4 | 0 |
30453 | 30453 | 2020-03-22 | San Bernardino | 71 | 17 | 0 | 7 | 0 |
30238 | 30238 | 2020-03-27 | San Bernardino | 71 | 64 | 3 | 9 | 0 |
20510 | 20510 | 2020-09-14 | San Bernardino | 71 | 50709 | 1061 | 10 | 7 |
30191 | 30191 | 2020-03-28 | San Bernardino | 71 | 76 | 4 | 12 | 1 |
5198 | 5198 | 2021-06-05 | San Bernardino | 71 | 298656 | 4828 | 13 | 0 |
30326 | 30326 | 2020-03-25 | San Bernardino | 71 | 54 | 2 | 16 | 0 |
29683 | 29683 | 2020-04-07 | San Bernardino | 71 | 547 | 25 | 17 | 3 |
28676 | 28676 | 2020-04-26 | San Bernardino | 71 | 1751 | 94 | 19 | 0 |
29259 | 29259 | 2020-04-15 | San Bernardino | 71 | 996 | 53 | 19 | 3 |
29841 | 29841 | 2020-04-04 | San Bernardino | 71 | 372 | 15 | 19 | 1 |
5140 | 5140 | 2021-06-06 | San Bernardino | 71 | 298676 | 4830 | 20 | 2 |
5082 | 5082 | 2021-06-07 | San Bernardino | 71 | 298697 | 4831 | 21 | 1 |
28623 | 28623 | 2020-04-27 | San Bernardino | 71 | 1772 | 97 | 21 | 3 |
30369 | 30369 | 2020-03-24 | San Bernardino | 71 | 38 | 2 | 21 | 2 |
3980 | 3980 | 2021-06-26 | San Bernardino | 71 | 299502 | 4840 | 22 | 0 |
5952 | 5952 | 2021-05-23 | San Bernardino | 71 | 297566 | 4822 | 27 | 2 |
28835 | 28835 | 2020-04-23 | San Bernardino | 71 | 1608 | 87 | 30 | 4 |
4212 | 4212 | 2021-06-22 | San Bernardino | 71 | 299320 | 4840 | 31 | 3 |
5024 | 5024 | 2021-06-08 | San Bernardino | 71 | 298728 | 4831 | 31 | 0 |
3748 | 3748 | 2021-06-30 | San Bernardino | 71 | 299763 | 4844 | 33 | 3 |
4444 | 4444 | 2021-06-18 | San Bernardino | 71 | 299186 | 4837 | 35 | 1 |
4618 | 4618 | 2021-06-15 | San Bernardino | 71 | 299049 | 4835 | 35 | 1 |
4908 | 4908 | 2021-06-10 | San Bernardino | 71 | 298843 | 4832 | 35 | 1 |
30144 | 30144 | 2020-03-29 | San Bernardino | 71 | 111 | 5 | 35 | 1 |
29206 | 29206 | 2020-04-16 | San Bernardino | 71 | 1032 | 61 | 36 | 8 |
4734 | 4734 | 2021-06-13 | San Bernardino | 71 | 298976 | 4833 | 37 | 0 |
4676 | 4676 | 2021-06-14 | San Bernardino | 71 | 299014 | 4834 | 38 | 1 |
6242 | 6242 | 2021-05-18 | San Bernardino | 71 | 297300 | 4813 | 39 | 1 |
4792 | 4792 | 2021-06-12 | San Bernardino | 71 | 298939 | 4833 | 41 | 1 |
7054 | 7054 | 2021-05-04 | San Bernardino | 71 | 296188 | 4799 | 42 | 3 |
5256 | 5256 | 2021-06-04 | San Bernardino | 71 | 298643 | 4828 | 44 | 0 |
6648 | 6648 | 2021-05-11 | San Bernardino | 71 | 296700 | 4804 | 45 | 1 |
27644 | 27644 | 2020-05-14 | San Bernardino | 71 | 3198 | 161 | 45 | 3 |
4328 | 4328 | 2021-06-20 | San Bernardino | 71 | 299289 | 4837 | 46 | 0 |
9490 | 9490 | 2021-03-23 | San Bernardino | 71 | 289892 | 4714 | 46 | 0 |
26658 | 26658 | 2020-05-31 | San Bernardino | 71 | 5246 | 220 | 46 | 2 |
4560 | 4560 | 2021-06-16 | San Bernardino | 71 | 299096 | 4835 | 47 | 0 |
27470 | 27470 | 2020-05-17 | San Bernardino | 71 | 3511 | 168 | 48 | 2 |
5894 | 5894 | 2021-05-24 | San Bernardino | 71 | 297615 | 4822 | 49 | 0 |
6184 | 6184 | 2021-05-19 | San Bernardino | 71 | 297349 | 4815 | 49 | 2 |
29893 | 29893 | 2020-04-03 | San Bernardino | 71 | 353 | 14 | 49 | 1 |
27064 | 27064 | 2020-05-24 | San Bernardino | 71 | 4365 | 193 | 50 | 3 |
29945 | 29945 | 2020-04-02 | San Bernardino | 71 | 304 | 13 | 50 | 4 |
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 );