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,523 rows where "date" is on date 2021-11-09

✎ View and edit SQL

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

Suggested facets: date (date)

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
14012 14012 2021-11-09 90001 Los Angeles 37 58975.0 12753 49495 36742 0.22 0.84 0.62
14013 14013 2021-11-09 90002 Los Angeles 37 53111.0 4656 32886 28230 0.09 0.62 0.53
14014 14014 2021-11-09 90003 Los Angeles 37 72741.0 7048 45870 38822 0.1 0.63 0.53
14015 14015 2021-11-09 90004 Los Angeles 37 61586.0 4617 45610 40993 0.07 0.74 0.67
14016 14016 2021-11-09 90005 Los Angeles 37 39479.0 3469 28954 25485 0.09 0.73 0.65
14017 14017 2021-11-09 90006 Los Angeles 37 61698.0 5669 42622 36953 0.09 0.69 0.6
14018 14018 2021-11-09 90007 Los Angeles 37 41716.0 3759 34389 30630 0.09 0.82 0.73
14019 14019 2021-11-09 90008 Los Angeles 37 31739.0 2191 20583 18392 0.07 0.65 0.58
14020 14020 2021-11-09 90010 Los Angeles 37 3702.0 518 4385 3867 0.14 1.18 1.04
14021 14021 2021-11-09 90011 Los Angeles 37 109414.0 13160 69391 56231 0.12 0.63 0.51
14022 14022 2021-11-09 90012 Los Angeles 37 35913.0 3524 31453 27929 0.1 0.88 0.78
14023 14023 2021-11-09 90013 Los Angeles 37 11937.0 2064 10702 8638 0.17 0.9 0.72
14024 14024 2021-11-09 90014 Los Angeles 37 8335.0 1077 7789 6712 0.13 0.93 0.81
14025 14025 2021-11-09 90015 Los Angeles 37 21801.0 2582 19056 16474 0.12 0.87 0.76
14026 14026 2021-11-09 90016 Los Angeles 37 46581.0 3497 33773 30276 0.08 0.73 0.65
14027 14027 2021-11-09 90017 Los Angeles 37 26728.0 3676 20964 17288 0.14 0.78 0.65
14028 14028 2021-11-09 90018 Los Angeles 37 53256.0 4614 35878 31264 0.09 0.67 0.59
14029 14029 2021-11-09 90019 Los Angeles 37 66245.0 4856 46232 41376 0.07 0.7 0.62
14030 14030 2021-11-09 90020 Los Angeles 37 39102.0 3179 30266 27087 0.08 0.77 0.69
14031 14031 2021-11-09 90021 Los Angeles 37 2922.0 547 3264 2717 0.19 1.12 0.93
14032 14032 2021-11-09 90022 Los Angeles 37 65890.0 4789 46911 42122 0.07 0.71 0.64
14033 14033 2021-11-09 90023 Los Angeles 37 46780.0 3817 32907 29090 0.08 0.7 0.62
14034 14034 2021-11-09 90024 Los Angeles 37 50288.0 2640 27763 25123 0.05 0.55 0.5
14035 14035 2021-11-09 90025 Los Angeles 37 47967.0 2797 35491 32694 0.06 0.74 0.68
14036 14036 2021-11-09 90026 Los Angeles 37 69589.0 4743 47768 43025 0.07 0.69 0.62
14037 14037 2021-11-09 90027 Los Angeles 37 44686.0 3056 34705 31649 0.07 0.78 0.71
14038 14038 2021-11-09 90028 Los Angeles 37 30734.0 3083 25111 22028 0.1 0.82 0.72
14039 14039 2021-11-09 90029 Los Angeles 37 37898.0 2559 25957 23398 0.07 0.68 0.62
14040 14040 2021-11-09 90031 Los Angeles 37 38535.0 2781 28267 25486 0.07 0.73 0.66
14041 14041 2021-11-09 90032 Los Angeles 37 47627.0 2803 32121 29318 0.06 0.67 0.62
14042 14042 2021-11-09 90033 Los Angeles 37 47583.0 3818 38002 34184 0.08 0.8 0.72
14043 14043 2021-11-09 90034 Los Angeles 37 55652.0 3344 44146 40802 0.06 0.79 0.73
14044 14044 2021-11-09 90035 Los Angeles 37 28085.0 2076 21594 19518 0.07 0.77 0.69
14045 14045 2021-11-09 90036 Los Angeles 37 37988.0 2928 29481 26553 0.08 0.78 0.7
14046 14046 2021-11-09 90037 Los Angeles 37 65016.0 7271 43132 35861 0.11 0.66 0.55
14047 14047 2021-11-09 90038 Los Angeles 37 27660.0 2134 20546 18412 0.08 0.74 0.67
14048 14048 2021-11-09 90039 Los Angeles 37 29589.0 1916 22653 20737 0.06 0.77 0.7
14049 14049 2021-11-09 90040 Los Angeles 37 12645.0 1384 10733 9349 0.11 0.85 0.74
14050 14050 2021-11-09 90041 Los Angeles 37 29516.0 1529 20801 19272 0.05 0.7 0.65
14051 14051 2021-11-09 90042 Los Angeles 37 63911.0 3358 43483 40125 0.05 0.68 0.63
14052 14052 2021-11-09 90043 Los Angeles 37 44627.0 3214 30604 27390 0.07 0.69 0.61
14053 14053 2021-11-09 90044 Los Angeles 37 96436.0 7922 57145 49223 0.08 0.59 0.51
14054 14054 2021-11-09 90045 Los Angeles 37 41149.0 3710 40469 36759 0.09 0.98 0.89
14055 14055 2021-11-09 90046 Los Angeles 37 50587.0 3214 37854 34640 0.06 0.75 0.68
14056 14056 2021-11-09 90047 Los Angeles 37 48883.0 3655 32674 29019 0.07 0.67 0.59
14057 14057 2021-11-09 90048 Los Angeles 37 22892.0 1860 18383 16523 0.08 0.8 0.72
14058 14058 2021-11-09 90049 Los Angeles 37 36964.0 2517 29323 26806 0.07 0.79 0.73
14059 14059 2021-11-09 90056 Los Angeles 37 7795.0 533 6475 5942 0.07 0.83 0.76
14060 14060 2021-11-09 90057 Los Angeles 37 49492.0 4477 30119 25642 0.09 0.61 0.52
14061 14061 2021-11-09 90058 Los Angeles 37 2758.0 901 5242 4341 0.33 1.9 1.57
14062 14062 2021-11-09 90059 Los Angeles 37 45952.0 3800 26143 22343 0.08 0.57 0.49
14063 14063 2021-11-09 90061 Los Angeles 37 27646.0 2366 17770 15404 0.09 0.64 0.56
14064 14064 2021-11-09 90062 Los Angeles 37 34422.0 2850 22465 19615 0.08 0.65 0.57
14065 14065 2021-11-09 90063 Los Angeles 37 52951.0 3686 36710 33024 0.07 0.69 0.62
14066 14066 2021-11-09 90064 Los Angeles 37 25429.0 1790 22828 21038 0.07 0.9 0.83
14067 14067 2021-11-09 90065 Los Angeles 37 47887.0 2968 34252 31284 0.06 0.72 0.65
14068 14068 2021-11-09 90066 Los Angeles 37 59394.0 3230 43197 39967 0.05 0.73 0.67
14069 14069 2021-11-09 90067 Los Angeles 37 2314.0 350 3156 2806 0.15 1.36 1.21
14070 14070 2021-11-09 90068 Los Angeles 37 20982.0 1572 17778 16206 0.07 0.85 0.77
14071 14071 2021-11-09 90069 Los Angeles 37 20435.0 1712 18340 16628 0.08 0.9 0.81
14072 14072 2021-11-09 90071 Los Angeles 37 0.0 341 1204 863 inf inf inf
14073 14073 2021-11-09 90077 Los Angeles 37 8993.0 668 7261 6593 0.07 0.81 0.73
14074 14074 2021-11-09 90094 Los Angeles 37 9368.0 591 7536 6945 0.06 0.8 0.74
14075 14075 2021-11-09 90201 Los Angeles 37 102433.0 6926 65735 58809 0.07 0.64 0.57
14076 14076 2021-11-09 90210 Los Angeles 37 19909.0 2030 17964 15934 0.1 0.9 0.8
14077 14077 2021-11-09 90211 Los Angeles 37 7969.0 598 7054 6456 0.08 0.89 0.81
14078 14078 2021-11-09 90212 Los Angeles 37 13156.0 956 9816 8860 0.07 0.75 0.67
14079 14079 2021-11-09 90220 Los Angeles 37 53703.0 3769 31216 27447 0.07 0.58 0.51
14080 14080 2021-11-09 90221 Los Angeles 37 52322.0 4323 33882 29559 0.08 0.65 0.56
14081 14081 2021-11-09 90222 Los Angeles 37 32850.0 2700 19612 16912 0.08 0.6 0.51
14082 14082 2021-11-09 90230 Los Angeles 37 32808.0 1893 25208 23315 0.06 0.77 0.71
14083 14083 2021-11-09 90232 Los Angeles 37 14660.0 1017 13564 12547 0.07 0.93 0.86
14084 14084 2021-11-09 90240 Los Angeles 37 26205.0 1505 19393 17888 0.06 0.74 0.68
14085 14085 2021-11-09 90241 Los Angeles 37 44143.0 2720 31501 28781 0.06 0.71 0.65
14086 14086 2021-11-09 90242 Los Angeles 37 42553.0 2456 30056 27600 0.06 0.71 0.65
14087 14087 2021-11-09 90245 Los Angeles 37 16850.0 1776 15253 13477 0.11 0.91 0.8
14088 14088 2021-11-09 90247 Los Angeles 37 47531.0 3342 34667 31325 0.07 0.73 0.66
14089 14089 2021-11-09 90248 Los Angeles 37 11512.0 695 8209 7514 0.06 0.71 0.65
14090 14090 2021-11-09 90249 Los Angeles 37 26587.0 1761 19524 17763 0.07 0.73 0.67
14091 14091 2021-11-09 90250 Los Angeles 37 96836.0 6452 64483 58031 0.07 0.67 0.6
14092 14092 2021-11-09 90254 Los Angeles 37 19650.0 1125 15512 14387 0.06 0.79 0.73
14093 14093 2021-11-09 90255 Los Angeles 37 75560.0 5914 50149 44235 0.08 0.66 0.59
14094 14094 2021-11-09 90260 Los Angeles 37 35161.0 2175 24460 22285 0.06 0.7 0.63
14095 14095 2021-11-09 90262 Los Angeles 37 70936.0 5580 45917 40337 0.08 0.65 0.57
14096 14096 2021-11-09 90265 Los Angeles 37 18389.0 963 10734 9771 0.05 0.58 0.53
14097 14097 2021-11-09 90266 Los Angeles 37 35573.0 2306 29064 26758 0.06 0.82 0.75
14098 14098 2021-11-09 90270 Los Angeles 37 27454.0 1965 17651 15686 0.07 0.64 0.57
14099 14099 2021-11-09 90272 Los Angeles 37 22551.0 1461 18663 17202 0.06 0.83 0.76
14100 14100 2021-11-09 90274 Los Angeles 37 25279.0 1491 21606 20115 0.06 0.85 0.8
14101 14101 2021-11-09 90275 Los Angeles 37 42421.0 2411 33671 31260 0.06 0.79 0.74
14102 14102 2021-11-09 90277 Los Angeles 37 34506.0 2170 28397 26227 0.06 0.82 0.76
14103 14103 2021-11-09 90278 Los Angeles 37 40649.0 2432 31612 29180 0.06 0.78 0.72
14104 14104 2021-11-09 90280 Los Angeles 37 95103.0 6699 66232 59533 0.07 0.7 0.63
14105 14105 2021-11-09 90290 Los Angeles 37 5371.0 306 4519 4213 0.06 0.84 0.78
14106 14106 2021-11-09 90291 Los Angeles 37 27525.0 1798 21388 19590 0.07 0.78 0.71
14107 14107 2021-11-09 90292 Los Angeles 37 22490.0 1842 20592 18750 0.08 0.92 0.83
14108 14108 2021-11-09 90293 Los Angeles 37 12694.0 664 9412 8748 0.05 0.74 0.69
14109 14109 2021-11-09 90301 Los Angeles 37 37291.0 2690 25132 22442 0.07 0.67 0.6
14110 14110 2021-11-09 90302 Los Angeles 37 30828.0 1736 18402 16666 0.06 0.6 0.54
14111 14111 2021-11-09 90303 Los Angeles 37 24693.0 1842 16832 14990 0.07 0.68 0.61

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
);