\begin{longtable}{rllllrrll} \hline rowid & id & name & date & county & fips & confirmed\_cases & note & population \\ \hline \endhead 1 & 94501 & 94501: Alameda & 2022-12-30 & Alameda & 1 & 11911 & & 62826 \\ 2 & 94502 & 94502: Alameda & 2022-12-30 & Alameda & 1 & 2057 & & 14117 \\ 3 & 94505 & 94505: Discovery Bay & 2022-12-30 & Alameda & 1 & 4 & & 16382 \\ 4 & 94514 & 94514: Byron & 2022-12-30 & Alameda & 1 & 3 & & 1461 \\ 5 & 94536 & 94536: Fremont & 2022-12-30 & Alameda & 1 & 13610 & & 72976 \\ 6 & 94538 & 94538: Fremont & 2022-12-30 & Alameda & 1 & 14303 & & 63911 \\ 7 & 94539 & 94539: Fremont & 2022-12-30 & Alameda & 1 & 7755 & & 52960 \\ 8 & 94541 & 94541: Hayward & 2022-12-30 & Alameda & 1 & 19284 & & 65132 \\ 9 & 94542 & 94542: Hayward & 2022-12-30 & Alameda & 1 & 3054 & & 13973 \\ 10 & 94544 & 94544: Hayward & 2022-12-30 & Alameda & 1 & 23527 & & 77121 \\ 11 & 94545 & 94545: Hayward & 2022-12-30 & Alameda & 1 & 9166 & & 31657 \\ 12 & 94546 & 94546: Castro Valley & 2022-12-30 & Alameda & 1 & 9576 & & 45536 \\ 13 & 94550 & 94550: Livermore & 2022-12-30 & Alameda & 1 & 9399 & & 50138 \\ 14 & 94551 & 94551: Livermore & 2022-12-30 & Alameda & 1 & 8839 & & 38986 \\ 15 & 94552 & 94552: Castro Valley & 2022-12-30 & Alameda & 1 & 2419 & & 15204 \\ 16 & 94555 & 94555: Fremont & 2022-12-30 & Alameda & 1 & 6028 & & 36037 \\ 17 & 94560 & 94560: Newark & 2022-12-30 & Alameda & 1 & 11902 & & 44245 \\ 18 & 94566 & 94566: Pleasanton & 2022-12-30 & Alameda & 1 & 7054 & & 45046 \\ 19 & 94568 & 94568: Dublin & 2022-12-30 & Alameda & 1 & 14203 & & 58399 \\ 20 & 94577 & 94577: San Leandro & 2022-12-30 & Alameda & 1 & 11851 & & 48666 \\ 21 & 94578 & 94578: San Leandro & 2022-12-30 & Alameda & 1 & 11167 & & 40150 \\ 22 & 94579 & 94579: San Leandro & 2022-12-30 & Alameda & 1 & 5515 & & 20237 \\ 23 & 94580 & 94580: San Lorenzo & 2022-12-30 & Alameda & 1 & 8047 & & 28970 \\ 24 & 94586 & 94586: Sunol & 2022-12-30 & Alameda & 1 & 146 & & 797 \\ 25 & 94587 & 94587: Union City & 2022-12-30 & Alameda & 1 & 16574 & & 72446 \\ 26 & 94588 & 94588: Pleasanton & 2022-12-30 & Alameda & 1 & 5863 & & 31895 \\ 27 & 94601 & 94601: Oakland & 2022-12-30 & Alameda & 1 & 16510 & & 53261 \\ 28 & 94602 & 94602: Oakland & 2022-12-30 & Alameda & 1 & 6025 & & 29770 \\ 29 & 94603 & 94603: Oakland & 2022-12-30 & Alameda & 1 & 11584 & & 33241 \\ 30 & 94605 & 94605: Oakland & 2022-12-30 & Alameda & 1 & 10983 & & 42375 \\ 31 & 94606 & 94606: Oakland & 2022-12-30 & Alameda & 1 & 8752 & & 37076 \\ 32 & 94607 & 94607: Oakland & 2022-12-30 & Alameda & 1 & 6784 & & 26646 \\ 33 & 94608 & 94608: Emeryville & 2022-12-30 & Alameda & 1 & 7113 & & 31000 \\ 34 & 94609 & 94609: Oakland & 2022-12-30 & Alameda & 1 & 5244 & & 22293 \\ 35 & 94610 & 94610: Oakland & 2022-12-30 & Alameda & 1 & 5747 & & 30862 \\ 36 & 94611 & 94611: Oakland & 2022-12-30 & Alameda & 1 & 6604 & & 37826 \\ 37 & 94612 & 94612: Oakland & 2022-12-30 & Alameda & 1 & 4227 & & 17279 \\ 38 & 94613 & 94613: Oakland & 2022-12-30 & Alameda & 1 & 8 & & 212 \\ 39 & 94618 & 94618: Oakland & 2022-12-30 & Alameda & 1 & 2309 & & 15545 \\ 40 & 94619 & 94619: Oakland & 2022-12-30 & Alameda & 1 & 5343 & & 24080 \\ 41 & 94621 & 94621: Oakland & 2022-12-30 & Alameda & 1 & 11341 & & 32915 \\ 42 & 94702 & 94702: Berkeley & 2022-12-30 & Alameda & 1 & 3433 & & 16520 \\ 43 & 94703 & 94703: Berkeley & 2022-12-30 & Alameda & 1 & 3841 & & 19805 \\ 44 & 94704 & 94704: Berkeley & 2022-12-30 & Alameda & 1 & 5322 & & 29129 \\ 45 & 94705 & 94705: Berkeley & 2022-12-30 & Alameda & 1 & 2170 & & 13152 \\ 46 & 94706 & 94706: Albany & 2022-12-30 & Alameda & 1 & 2913 & & 19921 \\ 47 & 94707 & 94707: Berkeley & 2022-12-30 & Alameda & 1 & 1202 & & 12862 \\ 48 & 94708 & 94708: Berkeley & 2022-12-30 & Alameda & 1 & 1114 & & 11725 \\ 49 & 94709 & 94709: Berkeley & 2022-12-30 & Alameda & 1 & 1743 & & 11796 \\ 50 & 94710 & 94710: Berkeley & 2022-12-30 & Alameda & 1 & 2086 & & 8059 \\ 51 & 94720 & 94720: Berkeley & 2022-12-30 & Alameda & 1 & 1132 & & 1336 \\ 52 & 95377 & 95377: Tracy & 2022-12-30 & Alameda & 1 & 1 & & 32091 \\ 53 & 95391 & 95391: Mountain House & 2022-12-30 & Alameda & 1 & 2 & & 20131 \\ 54 & 95221, 95222 & 95221, 95222 & 2022-12-30 & Calaveras & 9 & 140 & & 5029 \\ 55 & 95223 & 95223 & 2022-12-30 & Calaveras & 9 & 51 & & 2666 \\ 56 & 95225 & 95225 & 2022-12-30 & Calaveras & 9 & 17 & & 378 \\ 57 & 95226, 95252 & 95226, 95252 & 2022-12-30 & Calaveras & 9 & 435 & & 16262 \\ 58 & 95228 & 95228 & 2022-12-30 & Calaveras & 9 & 119 & & 4541 \\ 59 & 95232, 95245 & 95232, 95245 & 2022-12-30 & Calaveras & 9 & 34 & & 161 \\ 60 & 95233, 95224, 95247, 95251, 95229 & 95233, 95224, 95247, 95251, 95229 & 2022-12-30 & Calaveras & 9 & 135 & & 5364 \\ 61 & 95246, 95250 & 95246, 95250 & 2022-12-30 & Calaveras & 9 & 36 & & 1159 \\ 62 & 95249 & 95249 & 2022-12-30 & Calaveras & 9 & 140 & & 5444 \\ 63 & 95254 & 95254 & 2022-12-30 & Calaveras & 9 & 26 & & 1035 \\ 64 & 95255, 95257, 95248 & 95255, 95257, 95248 & 2022-12-30 & Calaveras & 9 & 35 & & 1802 \\ 65 & Other & Other & 2022-12-30 & Calaveras & 9 & 43 & & \\ 66 & Alamo & Alamo & 2022-12-30 & Contra Costa & 13 & 2429 & & 14750 \\ 67 & Antioch & Antioch & 2022-12-30 & Contra Costa & 13 & 36594 & & 112520 \\ 68 & Bay Point & Bay Point & 2022-12-30 & Contra Costa & 13 & 8291 & & 22639 \\ 69 & Bethel Island & Bethel Island & 2022-12-30 & Contra Costa & 13 & 397 & & 2137 \\ 70 & Brentwood & Brentwood & 2022-12-30 & Contra Costa & 13 & 18749 & & 65118 \\ 71 & Byron & Byron & 2022-12-30 & Contra Costa & 13 & 349 & & 1325 \\ 72 & Clayton & Clayton & 2022-12-30 & Contra Costa & 13 & 2132 & & 11337 \\ 73 & Concord & Concord & 2022-12-30 & Contra Costa & 13 & 30127 & & 130143 \\ 74 & Crockett & Crockett & 2022-12-30 & Contra Costa & 13 & 654 & & 3044 \\ 75 & Danville & Danville & 2022-12-30 & Contra Costa & 13 & 9666 & & 43876 \\ 76 & Diablo & Diablo & 2022-12-30 & Contra Costa & 13 & 153 & & 818 \\ 77 & Discovery Bay & Discovery Bay & 2022-12-30 & Contra Costa & 13 & 3417 & & 13352 \\ 78 & El Cerrito & El Cerrito & 2022-12-30 & Contra Costa & 13 & 4540 & & 24953 \\ 79 & Hercules & Hercules & 2022-12-30 & Contra Costa & 13 & 6580 & & 25530 \\ 80 & Kensington & Kensington & 2022-12-30 & Contra Costa & 13 & 592 & & 5077 \\ 81 & Knightsen & Knightsen & 2022-12-30 & Contra Costa & 13 & 105 & & 1500 \\ 82 & Lafayette & Lafayette & 2022-12-30 & Contra Costa & 13 & 4314 & & 25604 \\ 83 & Martinez & Martinez & 2022-12-30 & Contra Costa & 13 & 10486 & & 37106 \\ 84 & Moraga & Moraga & 2022-12-30 & Contra Costa & 13 & 2299 & & 16946 \\ 85 & Oakley & Oakley & 2022-12-30 & Contra Costa & 13 & 13815 & & 42461 \\ 86 & Orinda & Orinda & 2022-12-30 & Contra Costa & 13 & 2799 & & 19009 \\ 87 & Pacheco & Pacheco & 2022-12-30 & Contra Costa & 13 & 1020 & & 3685 \\ 88 & Pinole & Pinole & 2022-12-30 & Contra Costa & 13 & 5010 & & 19505 \\ 89 & Pittsburg & Pittsburg & 2022-12-30 & Contra Costa & 13 & 22663 & & 74321 \\ 90 & Pleasant Hill & Pleasant Hill & 2022-12-30 & Contra Costa & 13 & 7029 & & 34267 \\ 91 & Richmond & Richmond & 2022-12-30 & Contra Costa & 13 & 39779 & & 111217 \\ 92 & Rodeo & Rodeo & 2022-12-30 & Contra Costa & 13 & 2590 & & 8679 \\ 93 & San Pablo & San Pablo & 2022-12-30 & Contra Costa & 13 & 16631 & & 31413 \\ 94 & San Ramon & San Ramon & 2022-12-30 & Contra Costa & 13 & 15025 & & 83118 \\ 95 & Walnut Creek & Walnut Creek & 2022-12-30 & Contra Costa & 13 & 15575 & & 70860 \\ 96 & Auberry & Auberry & 2022-12-30 & Fresno & 19 & 407 & & 3994 \\ 97 & Biola & Biola & 2022-12-30 & Fresno & 19 & 469 & & 949 \\ 98 & Cantua Creek & Cantua Creek & 2022-12-30 & Fresno & 19 & 306 & & 1125 \\ 99 & Caruthers & Caruthers & 2022-12-30 & Fresno & 19 & 1583 & & 5887 \\ 100 & Clovis & Clovis & 2022-12-30 & Fresno & 19 & 28757 & & 122949 \\ 101 & Coalinga & Coalinga & 2022-12-30 & Fresno & 19 & 7754 & & 19345 \\ \hline \end{longtable}