Published November 10, 2021 | Version v1
Dataset Open

School exemptions in the United States

  • 1. Georgetown University

Description

Once-eliminated vaccine-preventable childhood diseases, such as measles, are resurging across the United States. Understanding the spatio-temporal trends in vaccine exemptions is crucial to targeting public health intervention to increase vaccine uptake and anticipating vulnerable populations as cases surge. However, prior available data on childhood disease vaccination is either on too rough a spatial scale for this spatially-heterogeneous issue, or is only available for small geographic regions, making general conclusions infeasible. Here, we have collated school vaccine exemption data across the United States and provide it at the county-level for all years available. We demonstrate the fine-scale spatial heterogeneity in vaccine exemption levels, and show that many counties may fall below the herd immunity threshold. We also show that vaccine exemptions increase over time in most states, and non-medical exemptions are highly prevalent where allowed. Our dataset also highlights the need for greater data sharing and standardized reporting across the United States. 

Notes

This dataset contains: 1) a master file of cleaned and joined data. This dataset contains the year, state, county FIPS code, and pertinent age group for each record. Each county-year combination that is available has entries for total enrolled, total medical exemptions, total non-medical exemption, religious exemptions, philosophical exemptions, pertussis exemptions, measles exemptions, varicella exemptions, and flu exemptions. 

2) the raw and uncleaned files that were used to produce the master file. There is a file for each state-year combination available. The columns included are:

Year: year that data is reported for

State: name of state

County: name of county

School_district: name of school district

City: name of city

Number_reporting: number of establishments within the given reporting area (e.g., number of schools contributing data within a given county or district)

School: name of school, where data is at the school level

Public/private: whether data is reported by public schools only, private schools only, or both

Age: what age groups the data is reported for (CC: childcare/preschool, KG: kindergarten, FG: first grade, MS: middle school/6th/7th grade, K12: kindergarten-high school/mixed grades)

Total_enrolled: total number of students for the given reporting area (e.g., school, district, or county)

Total_completed: total number of students that are up-to-date/compliant for all vaccines required by a particular reporting area (e.g., county or state)

Total_exempt: total number of students exempt for 1+ vaccines for under any type of exemption within the given reporting area

ME_total: all medical exemptions for the given reporting area (e.g., both permanent and temporary)

PME_total: all permanent medical exemptions for the given reporting area

TME_total: all temporary medical exemptions for the given reporting area

PBE_total: total number of students with any type of personal belief exemption for 1+ vaccine within the given reporting area (e.g., no distinction between philosophical or religious belief exemptions)

PBE_total-philosophy: total number of students with a philosophical exemption for 1+ vaccine within the given reporting area

PBE_total-religion: total number of students with a religious belief exemption for 1+ vaccine within the given reporting area

**PBE_total does not necessarily equal (PBE_total-philosophy + PBE_total-religion). Some states report additional exemptions (e.g., McKinney-Vento exemption for children experiencing homelessness) and reasons for non-compliance (conditional school entrance), while others do not. For states that do not report these other exceptions, it is unclear what the true total number of exemptions is and so the PBE_total column is left empty.

TDaP: completion of all recommended TDaP doses

TDaP_exempt: exemptions for TDaP vaccine

Var: completion of all recommended varicalla doses

Var_exempt: exemptions for varicella vaccine

HepB: completion of all recommended HepB doses

HepB_exempt: exemptions for HepB vaccine

HepA: completion of all recommended HepA doses

HepA_exempt: exemptions for HepA vaccine

MMR: completion of all recommended MMR doses

Mumps_exempt: exemptions for mumps vaccine

Rubella_exempt: exemptions for rubella vaccine

Measles2: completion of all recommended measles vaccine doses

Measles2_exempt: exemptions for measles vaccine

Polio(IPV): completion of all recommended IPV doses

Polio(IPV)_exempt: exemptions for polio vaccine

DTaP: completion of all recommended DTaP doses

DTaP_exempt: exemptions for DTaP vaccine

HIB1: completion of all recommended HIB1 doses

HIB1_exempt: exemptions for HIB1 vaccine

MCV4: completion of all recommended MCV4 doses

MCV4_exempt: exemptions for MCV4 vaccine

PCV13: completion of all recommended PCV13 doses

PCV13_exempt: exemptions for PCV13 vaccine

Influenza: completion of all recommended influenza vaccine doses

Influenza_exempt: exemptions for influenza vaccine

No_record: the number of students for which the institution was not able to acquire/report their immunization record

States report different data in different formats. 

The code used to produce the figures included in the manuscript as well as the full cleaned and raw datasets are available on Github at https://github.com/bansallab/exemptions-landscape. The code runs in Python 3.6.

Funding provided by: National Institutes of Health
Crossref Funder Registry ID: http://dx.doi.org/10.13039/100000002
Award Number: R01GM123007

Files

AL_2014.csv

Files (4.4 MB)

Name Size Download all
md5:9cf4e5b52aad6e441a003a59162ecded
20.4 kB Preview Download
md5:7e6158fba546ed529d9258febef59af3
20.1 kB Preview Download
md5:96e579cadec030ac4f5488c0ba35c5ec
20.0 kB Preview Download
md5:4e5881289a0923edb27804da942f5892
20.0 kB Preview Download
md5:d783d844d912358623accc39f084b0f7
5.2 kB Preview Download
md5:ce2a5893275cb7d0cade0799b2ca2c01
5.2 kB Preview Download
md5:f08b7d5d7fb10270a3391703dc1470b0
7.7 kB Preview Download
md5:b303254b45ec3a94de882a71abdf5eaa
7.4 kB Preview Download
md5:d4030b959e588682f45b476fd0439451
7.6 kB Preview Download
md5:e5b3b45b25be1997f57a50acbd39a53a
4.8 kB Preview Download
md5:d73756102633bc50f2b30720050dd051
6.1 kB Preview Download
md5:3c79e20825a1ec39034fb0c0c40ea183
6.2 kB Preview Download
md5:2e169d8ac6c5d519d2a77f708f6cebd3
7.3 kB Preview Download
md5:6d8542629e8fd3a0af6d1d320078dbd6
6.2 kB Preview Download
md5:635207bc082b08aa00830182552d1f3d
6.2 kB Preview Download
md5:3b4a3f0c56b8b655111742cf7a19da14
6.2 kB Preview Download
md5:336c54e4826442ea442ee9ac30d2616f
6.2 kB Preview Download
md5:2ddc64e97135bccbbc58808d12f06551
6.2 kB Preview Download
md5:fcbca5ed9073f721b26ce4430b35f1e9
6.2 kB Preview Download
md5:be473c5a74574d52b7b837bd0ff6d753
6.2 kB Preview Download
md5:edb103c71429c80d960420281bf79de1
6.2 kB Preview Download
md5:777857f734eb6bb697faa6c28fbc7cb2
16.8 kB Preview Download
md5:1e22af36d6c980eddb11c1923f0409fe
20.9 kB Preview Download
md5:4ecda68d920642e295df4de6c4756917
20.6 kB Preview Download
md5:bade3c09370c631bc295d50cfed9a6eb
21.4 kB Preview Download
md5:70675298d02f6398145d29241f87d1d0
21.2 kB Preview Download
md5:71feb31a08af6948945331ddb0238c9e
6.2 kB Preview Download
md5:12ef88610e8a09f2768f4de1a42b0875
6.2 kB Preview Download
md5:f78862c08c827d5c97aa50f2829db5a6
6.1 kB Preview Download
md5:e8ca383cd401f8eb65cd10b30c30da47
8.1 kB Preview Download
md5:cb63bbb642b8deae2e050ce7f73b621d
2.9 kB Preview Download
md5:2f47db23c8356e07e376d2603582e66a
8.2 kB Preview Download
md5:5a4ef6f26de60fc6435c0f60f73ea0ce
8.2 kB Preview Download
md5:6227154ffa8bcb26e5069716011c57da
8.2 kB Preview Download
md5:ee90732e24c45ff7014bcf672b574568
8.2 kB Preview Download
md5:4abc7d70059998d94c038800190d0e4a
8.2 kB Preview Download
md5:cf9ada8d6b9c22d50284e80cabf23ce6
40.2 kB Preview Download
md5:ce5de881ad1d9fbfc89c82e286ce5a98
40.4 kB Preview Download
md5:36e5913db8799694b5023dc3c7e257c7
40.3 kB Preview Download
md5:dcde50b5632095a47d218f5cf09c83db
40.3 kB Preview Download
md5:90db9e76db4de09a3b17eec6a43b1fee
40.3 kB Preview Download
md5:43143f51e977e3404a19616f20cbec04
40.3 kB Preview Download
md5:5416e67e2ae559cb5152eaedc0b9e9a9
40.3 kB Preview Download
md5:b1e51a487078bb2acf26447ee97fa1ce
40.3 kB Preview Download
md5:0b50f927833d817f0a8f7eb19881afa4
40.3 kB Preview Download
md5:49192b0f31e172a09f8d195ee66067b5
40.3 kB Preview Download
md5:a6594533e25856bb3a3f3a04f0b6562c
40.3 kB Preview Download
md5:63e7a80d47bb2c3f9662675eb939534a
56.0 kB Preview Download
md5:d7f942ecb327825029537162908ef4bc
56.2 kB Preview Download
md5:3e331f4388b6f090e4a012d083230392
56.0 kB Preview Download
md5:75eb6b651e0df14a13fd94efa2ea79ba
56.0 kB Preview Download
md5:64eba50f78aa1a0547418ad00d3c11b9
56.0 kB Preview Download
md5:3a1dfa847d26d731ca291040b0609672
56.0 kB Preview Download
md5:e7343532a5727604e69e3d7b8925f319
56.0 kB Preview Download
md5:c78976113ec73efb4636392fdda1b388
56.0 kB Preview Download
md5:d36d92143fd2d48fd511201f294a51fe
56.7 kB Preview Download
md5:953c20c588dbb982bcddd37145aae758
56.7 kB Preview Download
md5:224b828948c4cf30b0f0632a87ba843e
56.7 kB Preview Download
md5:8ca436b9ac47c15ad3d5975314fb5494
16.3 kB Preview Download
md5:ce074afb100b09f448990aa71b0b8787
7.8 kB Preview Download
md5:3484e284395a232cdaf684b0c419d07e
7.8 kB Preview Download
md5:55f6b19fc363edbd92aa6124ae09d6a3
7.7 kB Preview Download
md5:78bfb046705cb48b367aaee0594cbf68
7.8 kB Preview Download
md5:77d34de51c7d40f8f506a642167baebf
7.8 kB Preview Download
md5:b31b433bc711c08b8a1731d53040f5fa
17.8 kB Preview Download
md5:3255919f1be4e3cb5c6cc6e402cee5fe
9.4 kB Preview Download
md5:04154babb05b802d59fc085dac3b9af2
13.8 kB Preview Download
md5:15876fa3a10228a94ee10c6498f2799b
13.8 kB Preview Download
md5:7e7587a36d52507871ec8a4762a528f4
14.0 kB Preview Download
md5:a389de9ab5f00c33b18f63568cf9798f
9.5 kB Preview Download
md5:f52d00cbc6b03a0878fa27f91f4383b9
4.7 kB Preview Download
md5:eb22af993a25ac81c8b7d632640aedb4
4.7 kB Preview Download
md5:6bd88c3299432d12e551a20656fa7798
5.7 kB Preview Download
md5:b9c9436137757ae6736f52e5fff4d644
5.1 kB Preview Download
md5:fdce3cf6b47fedfab08a2fc27f0b2821
5.4 kB Preview Download
md5:0af101d0f6eb4d3a7cd5e333ebb0ff0f
21.2 kB Preview Download
md5:00a653f71157dcf8c528705f0dcf0437
54.4 kB Preview Download
md5:7852a80c99976071b849fe8f4f28ea24
54.5 kB Preview Download
md5:09d8d6c526b42c7d4f2d8c0cdb600e0f
54.7 kB Preview Download
md5:200e131b449c2ae5f273210b864c22a2
54.7 kB Preview Download
md5:af08ecf1a0a291ce7e540c51f457997f
54.8 kB Preview Download
md5:9c68f4070ca08be9fb683c864c0fa0e6
17.7 kB Preview Download
md5:64824805f4c901fb4b3449487569b266
25.1 kB Preview Download
md5:ee70d081b51a656e0aa184f708329247
25.2 kB Preview Download
md5:b8b1c65bbe02fb50f36fd3bf842b83ae
25.1 kB Preview Download
md5:a1b72c3b7ed568de6fb3611e72acd4c7
25.1 kB Preview Download
md5:b26495afceea2b9db81de499e71240aa
25.1 kB Preview Download
md5:d81972769074feec68bb6904541b324d
5.6 kB Preview Download
md5:0bfff01e284af76ce9b4254d9130d61f
5.6 kB Preview Download
md5:50e8d3c0b73fee6be83cf85fb1d8baa4
5.6 kB Preview Download
md5:4766870e5c20755593a9f8099060ee36
5.6 kB Preview Download
md5:e1834c640e1ac13ce113ff5c0c46aee1
5.6 kB Preview Download
md5:9b78e0a33c496fcfcf51f52b45790e78
5.6 kB Preview Download
md5:ae2584d02469ec8b7a334fce55b8113e
3.9 kB Preview Download
md5:c62dbe2f82af057fde09a76e1221f413
6.4 kB Preview Download
md5:bb4a74e2b59c1efda7bce2a900519ffe
6.7 kB Preview Download
md5:79e7c29e593467ba870452ddbc469771
6.7 kB Preview Download
md5:82e164c00fb2a0c051086ab0c1a5f384
12.6 kB Preview Download
md5:c65078c32cb141aca478968bfbb03524
42.3 kB Preview Download
md5:a4c1b9037516fc080f8207ef091a4c87
13.7 kB Preview Download
md5:60b8482b083c35b7fc32708631b8f834
42.4 kB Preview Download
md5:cd594de7b4994733e608ba0e5de66b2f
42.6 kB Preview Download
md5:60fa3b55decf70a8304e8e93abdc4d8c
42.6 kB Preview Download
md5:bf749e1c3b1dd769226facf3f777d670
42.5 kB Preview Download
md5:b1d57e8731e1608db10f35806244617c
42.3 kB Preview Download
md5:ca7ea8fffc760873554a329804cb7dfc
7.0 kB Preview Download
md5:107c3cb60b72291de358af6d4b7a6d1a
7.3 kB Preview Download
md5:4efc5bb2859f45c4458879a333dcfc3e
14.3 kB Preview Download
md5:be1c1934622e95b8df399f1683f2470f
14.6 kB Preview Download
md5:1f4d9145ab8a147a89a5197ed4687fc5
8.5 kB Preview Download
md5:f24a003f1e895ae38f848d9ef79981cb
71.1 kB Preview Download
md5:2b34ee06e80969abcc1207eadbd80d6a
71.1 kB Preview Download
md5:1d16c74d58730bbb36bf7e0a9456d608
71.2 kB Preview Download
md5:aa78c7c578218552c406132ad2258c6f
71.2 kB Preview Download
md5:f4ab035840e31bffe3f303c12f2b51cc
71.1 kB Preview Download
md5:8722f8b390a30f12172a6f1e17d4b0fb
17.1 kB Preview Download
md5:577dc10b4fe78f0ada88a252b0a53ac8
17.1 kB Preview Download
md5:4d5cae75339bc793edc59bbdca70d4e7
1.3 MB Preview Download
md5:8911c6ac8fddf1e1ed96b473d40da786
11.3 kB Preview Download
md5:a4c488884b8bcb92eb10ee54fd68b19a
25.8 kB Preview Download
md5:7be05faa717211a106d40ba2a0b5deb0
25.4 kB Preview Download
md5:6828db941b7e77d1f5e7c51edcb6d6f7
26.0 kB Preview Download
md5:cb56000f38686fb76eaaad6b914a6569
25.8 kB Preview Download
md5:3f06c9a59c4e2b852b6b4bf53431005f
25.2 kB Preview Download
md5:71cb40cde9261ac168aa20b4ad019f92
25.0 kB Preview Download
md5:f44158c5a4b1948035b9a12832c8eb2e
25.8 kB Preview Download
md5:b400194108f0c00cf42dd6a8e75261e7
24.2 kB Preview Download
md5:430fd2d198a2e7115803e2ccc841ad72
25.4 kB Preview Download
md5:8970fc77336d6b131964d945c38e224a
25.8 kB Preview Download
md5:602cbc794a4d637345842724e37ed183
3.9 kB Preview Download
md5:2174784a6d8e394b1e23b92b29329014
5.1 kB Preview Download
md5:617f8232e47859432661ee5db34ebce7
5.6 kB Preview Download
md5:534ad4d639678e14d138affb13530aa1
5.7 kB Preview Download
md5:ffda529f8a4161b74e5d427bae99a568
5.7 kB Preview Download
md5:30d568682499dc0f52d9969809301f6b
4.8 kB Preview Download

Additional details

Related works