cdph-vaccination-zipcode-totals

Table actions

California's Department of Public Health is releasing zipcode-level vaccination totals. Our team extracts and logs the data each day. Population estimates from the U.S. Census Bureau, gathered by The Times, are used to calculate the percentage of the total population that is vaccinated.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

date
The date for which data were reported in ISO 8601 format.
id
The unique identifer of the ZIP Code.
county
The name of the county.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
population
The number of people who live in the county.
partially_vaccinated
The total number of partially vaccinated people as of this date.
at_least_one_dose
The total number of people who have received at least one dose any vaccine given as of this date.
fully_vaccinated
The total number of fully vaccinated people as of this date.
partially_vaccinated_percent
The percentage of people who were partially vaccinated as of this date.
at_least_one_dose_percent
The percentage of people who received at least one dose any vaccine as of this date.
fully_vaccinated_percent
The percentage of people who were fully vaccinated as of this date.

1,601 rows where "date" is on date 2022-12-27

✎ View and edit SQL

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

Link rowid ▼ date id county fips population partially_vaccinated at_least_one_dose fully_vaccinated partially_vaccinated_percent at_least_one_dose_percent fully_vaccinated_percent
107676 107676 2022-12-27 90001 Los Angeles 37 58975.0 13775 58177 44402 0.23 0.99 0.75
107677 107677 2022-12-27 90002 Los Angeles 37 53111.0 5277 40518 35241 0.1 0.76 0.66
107678 107678 2022-12-27 90003 Los Angeles 37 72741.0 8394 57133 48739 0.12 0.79 0.67
107679 107679 2022-12-27 90004 Los Angeles 37 61586.0 5885 52976 47091 0.1 0.86 0.76
107680 107680 2022-12-27 90005 Los Angeles 37 39479.0 4346 33724 29378 0.11 0.85 0.74
107681 107681 2022-12-27 90006 Los Angeles 37 61698.0 6847 50550 43703 0.11 0.82 0.71
107682 107682 2022-12-27 90007 Los Angeles 37 41716.0 6021 40884 34863 0.14 0.98 0.84
107683 107683 2022-12-27 90008 Los Angeles 37 31739.0 2487 24207 21720 0.08 0.76 0.68
107684 107684 2022-12-27 90010 Los Angeles 37 3702.0 861 5095 4234 0.23 1.38 1.14
107685 107685 2022-12-27 90011 Los Angeles 37 109414.0 15416 84431 69015 0.14 0.77 0.63
107686 107686 2022-12-27 90012 Los Angeles 37 35913.0 5378 37513 32135 0.15 1.04 0.89
107687 107687 2022-12-27 90013 Los Angeles 37 11937.0 2639 12619 9980 0.22 1.06 0.84
107688 107688 2022-12-27 90014 Los Angeles 37 8335.0 1611 9201 7590 0.19 1.1 0.91
107689 107689 2022-12-27 90015 Los Angeles 37 21801.0 3656 22518 18862 0.17 1.03 0.87
107690 107690 2022-12-27 90016 Los Angeles 37 46581.0 4131 39810 35679 0.09 0.85 0.77
107691 107691 2022-12-27 90017 Los Angeles 37 26728.0 5121 25375 20254 0.19 0.95 0.76
107692 107692 2022-12-27 90018 Los Angeles 37 53256.0 5324 42213 36889 0.1 0.79 0.69
107693 107693 2022-12-27 90019 Los Angeles 37 66245.0 5701 53281 47580 0.09 0.8 0.72
107694 107694 2022-12-27 90020 Los Angeles 37 39102.0 4115 35008 30893 0.11 0.9 0.79
107695 107695 2022-12-27 90021 Los Angeles 37 2922.0 709 3809 3100 0.24 1.3 1.06
107696 107696 2022-12-27 90022 Los Angeles 37 65890.0 5751 55253 49502 0.09 0.84 0.75
107697 107697 2022-12-27 90023 Los Angeles 37 46780.0 4912 39625 34713 0.11 0.85 0.74
107698 107698 2022-12-27 90024 Los Angeles 37 50288.0 5678 33640 27962 0.11 0.67 0.56
107699 107699 2022-12-27 90025 Los Angeles 37 47967.0 4465 40514 36049 0.09 0.84 0.75
107700 107700 2022-12-27 90026 Los Angeles 37 69589.0 6084 54748 48664 0.09 0.79 0.7
107701 107701 2022-12-27 90027 Los Angeles 37 44686.0 4178 39461 35283 0.09 0.88 0.79
107702 107702 2022-12-27 90028 Los Angeles 37 30734.0 4779 29353 24574 0.16 0.96 0.8
107703 107703 2022-12-27 90029 Los Angeles 37 37898.0 3329 30126 26797 0.09 0.79 0.71
107704 107704 2022-12-27 90031 Los Angeles 37 38535.0 3147 32328 29181 0.08 0.84 0.76
107705 107705 2022-12-27 90032 Los Angeles 37 47627.0 3237 36767 33530 0.07 0.77 0.7
107706 107706 2022-12-27 90033 Los Angeles 37 47583.0 4754 44284 39530 0.1 0.93 0.83
107707 107707 2022-12-27 90034 Los Angeles 37 55652.0 4913 50551 45638 0.09 0.91 0.82
107708 107708 2022-12-27 90035 Los Angeles 37 28085.0 2854 24576 21722 0.1 0.88 0.77
107709 107709 2022-12-27 90036 Los Angeles 37 37988.0 4488 33978 29490 0.12 0.89 0.78
107710 107710 2022-12-27 90037 Los Angeles 37 65016.0 8765 52846 44081 0.13 0.81 0.68
107711 107711 2022-12-27 90038 Los Angeles 37 27660.0 2879 23991 21112 0.1 0.87 0.76
107712 107712 2022-12-27 90039 Los Angeles 37 29589.0 2278 25672 23394 0.08 0.87 0.79
107713 107713 2022-12-27 90040 Los Angeles 37 12645.0 1701 12397 10696 0.13 0.98 0.85
107714 107714 2022-12-27 90041 Los Angeles 37 29516.0 1939 23731 21792 0.07 0.8 0.74
107715 107715 2022-12-27 90042 Los Angeles 37 63911.0 4318 49756 45438 0.07 0.78 0.71
107716 107716 2022-12-27 90043 Los Angeles 37 44627.0 3625 35827 32202 0.08 0.8 0.72
107717 107717 2022-12-27 90044 Los Angeles 37 96436.0 9347 70291 60944 0.1 0.73 0.63
107718 107718 2022-12-27 90045 Los Angeles 37 41149.0 6185 46685 40500 0.15 1.13 0.98
107719 107719 2022-12-27 90046 Los Angeles 37 50587.0 4699 42351 37652 0.09 0.84 0.74
107720 107720 2022-12-27 90047 Los Angeles 37 48883.0 3907 38502 34595 0.08 0.79 0.71
107721 107721 2022-12-27 90048 Los Angeles 37 22892.0 2857 20858 18001 0.12 0.91 0.79
107722 107722 2022-12-27 90049 Los Angeles 37 36964.0 3193 33141 29948 0.09 0.9 0.81
107723 107723 2022-12-27 90056 Los Angeles 37 7795.0 544 7252 6708 0.07 0.93 0.86
107724 107724 2022-12-27 90057 Los Angeles 37 49492.0 5336 36396 31060 0.11 0.74 0.63
107725 107725 2022-12-27 90058 Los Angeles 37 2758.0 967 5748 4781 0.35 2.08 1.73
107726 107726 2022-12-27 90059 Los Angeles 37 45952.0 4228 32105 27877 0.09 0.7 0.61
107727 107727 2022-12-27 90061 Los Angeles 37 27646.0 2735 21541 18806 0.1 0.78 0.68
107728 107728 2022-12-27 90062 Los Angeles 37 34422.0 3234 26756 23522 0.09 0.78 0.68
107729 107729 2022-12-27 90063 Los Angeles 37 52951.0 4350 43333 38983 0.08 0.82 0.74
107730 107730 2022-12-27 90064 Los Angeles 37 25429.0 2513 26327 23814 0.1 1.04 0.94
107731 107731 2022-12-27 90065 Los Angeles 37 47887.0 3404 39227 35823 0.07 0.82 0.75
107732 107732 2022-12-27 90066 Los Angeles 37 59394.0 4505 49593 45088 0.08 0.83 0.76
107733 107733 2022-12-27 90067 Los Angeles 37 2314.0 456 3480 3024 0.2 1.5 1.31
107734 107734 2022-12-27 90068 Los Angeles 37 20982.0 2296 20075 17779 0.11 0.96 0.85
107735 107735 2022-12-27 90069 Los Angeles 37 20435.0 2670 20390 17720 0.13 1.0 0.87
107736 107736 2022-12-27 90071 Los Angeles 37 0.0 595 1591 996 inf inf inf
107737 107737 2022-12-27 90077 Los Angeles 37 8993.0 761 8269 7508 0.08 0.92 0.83
107738 107738 2022-12-27 90094 Los Angeles 37 9368.0 971 8875 7904 0.1 0.95 0.84
107739 107739 2022-12-27 90201 Los Angeles 37 102433.0 8207 77534 69327 0.08 0.76 0.68
107740 107740 2022-12-27 90210 Los Angeles 37 19909.0 2752 20348 17596 0.14 1.02 0.88
107741 107741 2022-12-27 90211 Los Angeles 37 7969.0 870 8005 7135 0.11 1.0 0.9
107742 107742 2022-12-27 90212 Los Angeles 37 13156.0 1317 11044 9727 0.1 0.84 0.74
107743 107743 2022-12-27 90220 Los Angeles 37 53703.0 4107 37576 33469 0.08 0.7 0.62
107744 107744 2022-12-27 90221 Los Angeles 37 52322.0 4942 40824 35882 0.09 0.78 0.69
107745 107745 2022-12-27 90222 Los Angeles 37 32850.0 3019 23924 20905 0.09 0.73 0.64
107746 107746 2022-12-27 90230 Los Angeles 37 32808.0 2624 29426 26802 0.08 0.9 0.82
107747 107747 2022-12-27 90232 Los Angeles 37 14660.0 1389 15578 14189 0.09 1.06 0.97
107748 107748 2022-12-27 90240 Los Angeles 37 26205.0 1831 22114 20283 0.07 0.84 0.77
107749 107749 2022-12-27 90241 Los Angeles 37 44143.0 3168 35982 32814 0.07 0.82 0.74
107750 107750 2022-12-27 90242 Los Angeles 37 42553.0 2837 34409 31572 0.07 0.81 0.74
107751 107751 2022-12-27 90245 Los Angeles 37 16850.0 2540 17873 15333 0.15 1.06 0.91
107752 107752 2022-12-27 90247 Los Angeles 37 47531.0 3732 39818 36086 0.08 0.84 0.76
107753 107753 2022-12-27 90248 Los Angeles 37 11512.0 771 9308 8537 0.07 0.81 0.74
107754 107754 2022-12-27 90249 Los Angeles 37 26587.0 1970 22398 20428 0.07 0.84 0.77
107755 107755 2022-12-27 90250 Los Angeles 37 96836.0 7927 76143 68216 0.08 0.79 0.7
107756 107756 2022-12-27 90254 Los Angeles 37 19650.0 1579 17497 15918 0.08 0.89 0.81
107757 107757 2022-12-27 90255 Los Angeles 37 75560.0 6844 59285 52441 0.09 0.78 0.69
107758 107758 2022-12-27 90260 Los Angeles 37 35161.0 2584 28078 25494 0.07 0.8 0.73
107759 107759 2022-12-27 90262 Los Angeles 37 70936.0 6364 54812 48448 0.09 0.77 0.68
107760 107760 2022-12-27 90263 Los Angeles 37 1846.0 205 697 492 0.11 0.38 0.27
107761 107761 2022-12-27 90265 Los Angeles 37 18389.0 1256 11920 10664 0.07 0.65 0.58
107762 107762 2022-12-27 90266 Los Angeles 37 35573.0 3108 33249 30141 0.09 0.93 0.85
107763 107763 2022-12-27 90270 Los Angeles 37 27454.0 2379 20946 18567 0.09 0.76 0.68
107764 107764 2022-12-27 90272 Los Angeles 37 22551.0 1925 21306 19381 0.09 0.94 0.86
107765 107765 2022-12-27 90274 Los Angeles 37 25279.0 1759 23987 22228 0.07 0.95 0.88
107766 107766 2022-12-27 90275 Los Angeles 37 42421.0 2855 37816 34961 0.07 0.89 0.82
107767 107767 2022-12-27 90277 Los Angeles 37 34506.0 2582 31612 29030 0.07 0.92 0.84
107768 107768 2022-12-27 90278 Los Angeles 37 40649.0 2869 36614 33745 0.07 0.9 0.83
107769 107769 2022-12-27 90280 Los Angeles 37 95103.0 7311 77141 69830 0.08 0.81 0.73
107770 107770 2022-12-27 90290 Los Angeles 37 5371.0 402 5053 4651 0.07 0.94 0.87
107771 107771 2022-12-27 90291 Los Angeles 37 27525.0 2787 24382 21595 0.1 0.89 0.78
107772 107772 2022-12-27 90292 Los Angeles 37 22490.0 2786 23263 20477 0.12 1.03 0.91
107773 107773 2022-12-27 90293 Los Angeles 37 12694.0 959 10464 9505 0.08 0.82 0.75
107774 107774 2022-12-27 90301 Los Angeles 37 37291.0 3457 29586 26129 0.09 0.79 0.7
107775 107775 2022-12-27 90302 Los Angeles 37 30828.0 2102 21670 19568 0.07 0.7 0.63

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-vaccination-zipcode-totals" (
   [date] TEXT,
   [id] INTEGER,
   [county] TEXT,
   [fips] INTEGER,
   [population] FLOAT,
   [partially_vaccinated] INTEGER,
   [at_least_one_dose] INTEGER,
   [fully_vaccinated] INTEGER,
   [partially_vaccinated_percent] FLOAT,
   [at_least_one_dose_percent] FLOAT,
   [fully_vaccinated_percent] FLOAT
);