rowid	date	county	fips	confirmed_cases	deaths	new_confirmed_cases	new_deaths
1	2021-09-02	Alameda	1	109537	1316	655	2
2	2021-09-02	Alpine	3	89	0	0	0
3	2021-09-02	Amador	5	4559	53	33	0
4	2021-09-02	Butte	7	16281	209	108	0
5	2021-09-02	Calaveras	9	2948	63	25	0
6	2021-09-02	Colusa	11	2754	18	0	0
7	2021-09-02	Contra Costa	13	90440	882	193	10
8	2021-09-02	Del Norte	15	3012	25	44	2
9	2021-09-02	El Dorado	17	13678	122	60	0
10	2021-09-02	Fresno	19	117492	1801	337	0
11	2021-09-02	Glenn	21	2647	30	33	0
12	2021-09-02	Humboldt	23	7308	75	139	0
13	2021-09-02	Imperial	25	30031	753	57	0
14	2021-09-02	Inyo	27	1589	39	0	0
15	2021-09-02	Kern	29	126250	1478	614	5
16	2021-09-02	Kings	31	26715	266	194	0
17	2021-09-02	Lake	33	5396	77	37	3
18	2021-09-02	Lassen	35	6341	27	0	0
19	2021-09-02	Los Angeles	37	1412379	25366	2695	40
20	2021-09-02	Madera	39	18670	250	0	0
21	2021-09-02	Marin	41	16365	217	33	0
22	2021-09-02	Mariposa	43	833	10	8	0
23	2021-09-02	Mendocino	45	6117	64	42	0
24	2021-09-02	Merced	47	37265	513	178	1
25	2021-09-02	Modoc	49	627	8	6	1
26	2021-09-02	Mono	51	1461	5	3	0
27	2021-09-02	Monterey	53	46684	542	28	0
28	2021-09-02	Napa	55	11706	91	32	0
29	2021-09-02	Nevada	57	7503	85	140	0
30	2021-09-02	Orange	59	286536	5236	437	7
31	2021-09-02	Placer	61	31104	331	308	5
32	2021-09-02	Plumas	63	1017	6	0	0
33	2021-09-02	Riverside	65	337921	4749	846	11
34	2021-09-02	Sacramento	67	137854	1941	622	7
35	2021-09-02	San Benito	69	6767	65	37	0
36	2021-09-02	San Bernardino	71	332082	4924	484	6
37	2021-09-02	San Diego	73	335302	3908	925	20
38	2021-09-02	San Francisco	75	47465	591	210	4
39	2021-09-02	San Joaquin	77	87365	1540	0	0
40	2021-09-02	San Luis Obispo	79	25729	284	0	0
41	2021-09-02	San Mateo	81	49186	595	158	0
42	2021-09-02	Santa Barbara	83	39500	481	111	1
43	2021-09-02	Santa Clara	85	135732	1731	357	0
44	2021-09-02	Santa Cruz	87	18518	210	178	0
45	2021-09-02	Shasta	89	15889	255	159	1
46	2021-09-02	Sierra	91	198	0	7	0
47	2021-09-02	Siskiyou	93	3443	41	41	0
48	2021-09-02	Solano	95	41521	273	0	0
49	2021-09-02	Sonoma	97	37055	356	249	0
50	2021-09-02	Stanislaus	99	68020	1159	263	9
51	2021-09-02	Sutter	101	12161	124	75	1
52	2021-09-02	Tehama	103	7143	72	75	0
53	2021-09-02	Trinity	105	692	10	17	0
54	2021-09-02	Tulare	107	55762	869	472	0
55	2021-09-02	Tuolumne	109	5778	93	46	1
56	2021-09-02	Ventura	111	90731	1084	0	3
57	2021-09-02	Yolo	113	17244	231	68	0
58	2021-09-02	Yuba	115	8865	52	81	0
59	2021-09-01	Alameda	1	108882	1314	1200	2
60	2021-09-01	Alpine	3	89	0	0	0
61	2021-09-01	Amador	5	4526	53	43	0
62	2021-09-01	Butte	7	16173	209	149	0
63	2021-09-01	Calaveras	9	2923	63	59	2
64	2021-09-01	Colusa	11	2754	18	0	0
65	2021-09-01	Contra Costa	13	90247	872	293	3
66	2021-09-01	Del Norte	15	2968	23	34	0
67	2021-09-01	El Dorado	17	13618	122	28	0
68	2021-09-01	Fresno	19	117155	1801	1288	9
69	2021-09-01	Glenn	21	2614	30	7	0
70	2021-09-01	Humboldt	23	7169	75	58	0
71	2021-09-01	Imperial	25	29974	753	0	0
72	2021-09-01	Inyo	27	1589	39	0	0
73	2021-09-01	Kern	29	125636	1473	693	8
74	2021-09-01	Kings	31	26521	266	38	1
75	2021-09-01	Lake	33	5359	74	36	0
76	2021-09-01	Lassen	35	6341	27	0	0
77	2021-09-01	Los Angeles	37	1409684	25326	3895	73
78	2021-09-01	Madera	39	18670	250	0	0
79	2021-09-01	Marin	41	16332	217	21	2
80	2021-09-01	Mariposa	43	825	10	9	0
81	2021-09-01	Mendocino	45	6075	64	48	0
82	2021-09-01	Merced	47	37087	512	170	3
83	2021-09-01	Modoc	49	621	7	7	0
84	2021-09-01	Mono	51	1458	5	7	0
85	2021-09-01	Monterey	53	46656	542	111	0
86	2021-09-01	Napa	55	11674	91	48	4
87	2021-09-01	Nevada	57	7363	85	207	0
88	2021-09-01	Orange	59	286099	5229	646	4
89	2021-09-01	Placer	61	30796	326	0	0
90	2021-09-01	Plumas	63	1017	6	0	0
91	2021-09-01	Riverside	65	337075	4738	1022	7
92	2021-09-01	Sacramento	67	137232	1934	615	11
93	2021-09-01	San Benito	69	6730	65	34	0
94	2021-09-01	San Bernardino	71	331598	4918	689	1
95	2021-09-01	San Diego	73	334377	3888	0	0
96	2021-09-01	San Francisco	75	47255	587	382	3
97	2021-09-01	San Joaquin	77	87365	1540	1443	12
98	2021-09-01	San Luis Obispo	79	25729	284	0	0
99	2021-09-01	San Mateo	81	49028	595	268	0
100	2021-09-01	Santa Barbara	83	39389	480	175	2