datacurator_table_schema.json

{
	"fields": [
		{
			"constraints": {
				"required": true,
				"unique": true
			},
			"description": "Unique identifier for the transaction (i.e. not the voter). IDs should remain consistent, regardless of when an export is created.",
			"format": "default",
			"name": "ID",
			"title": "Identifier",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"constraints": {
				"required": true
			},
			"description": "Identifier that uniquely identifies a voter, but is not required to be unique within the dataset. This number must be obfuscated from the original voter identifier in the jurisdiction's registration database. This field helps analyze how effective each type of transaction is for an individual voter. In addition, if there are questions about a particular voter's transactions, an organization could provide this identifier back to the jurisdiction to glean more information about the voter's experience.",
			"format": "default",
			"name": "VoterID",
			"title": "Voter Identifier",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"constraints": {
				"enum": [
					"email",
					"fax",
					"in-person",
					"mail",
					"online",
					"phone",
					"untracked",
					"other"
				],
				"required": true
			},
			"description": "Specifies the method by which the application request was received. Possible values are **email**, which signifies the application was received via email; **fax**, which denotes the application was received by fax; **in-person**, which means the application was delivered by a person (NB: this does not necessarily signify the voter themselves delivered the application); **mail**, which signifies the application was received via mail; **online**, which means the application was submitted via online form or system; **phone**, which means the request was placed via phone call; **untracked**, which signifies that this variable is not tracked in the system; and, **other**, which is a catch-all for any values that fall outside of the other values.",
			"format": "default",
			"name": "ApplicationRequestMethod",
			"title": "Application Request Method",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "If ApplicationRequestMethod fails to cover all of the possible request methods for a particular voter transaction, this field specifies an alternate method by which the application request was received.",
			"format": "default",
			"name": "ApplicationRequestOtherMethod",
			"title": "Other Application Request Method",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "Specifies the date the request was postmarked. If there is any confusion as to the whether the date the application was recorded was the date on the postmark or the date the application was physically received by the election administration entity, assume postmark and use this field rather than ApplicationRequestReceivedDate.",
			"format": "default",
			"name": "ApplicationRequestPostmarkDate",
			"title": "Date Application Request Was Postmarked",
			"type": "date",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "Specifies the date the request was processed by the local or state election official.",
			"format": "default",
			"name": "ApplicationRequestProcessedDate",
			"title": "Date Application Request Was Processed",
			"type": "date",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "Specifies the date the application request was received by the local or state election official. In mail-only states, this date is the most recent date the voter became an active UOCAVA voter.",
			"format": "default",
			"name": "ApplicationRequestReceivedDate",
			"title": "Application Request Received Date",
			"type": "date",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"constraints": {
				"required": false
			},
			"description": "If ApplicationRequestStatusType is **rejected** or **cured**, then specifies the reason the application was rejected. Possible values are **duplicate**, which  denotes that the election official already received an application for the voter, **invalid**, which means the application was invalid, **mismatch-voter-signature**, which means the application signature did not match the voter signature on file, **missing-identification** which means that an unspecified identifier was required and missing from the application, **missing-ssn**, denoting that the Social Security Number was missing from the application, **missing-state-id-number**, which means the state identifier was required and missing from the application,  **missing-voter-signature**, meaning the voter did not sign the application, and **other**, which is a catch-all for any values that fall outside of the other values. Multiple values are possible for this field.",
			"format": "default",
			"name": "ApplicationRequestRejectionType",
			"title": "Application Request Rejection Type",
			"type": "array",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "If ApplicationRequestRejectionType fails to cover all possible types of Application Rejection reasons, this field will list an alternate type.",
			"format": "default",
			"name": "ApplicationRequestRejectionOtherType",
			"title": "Other Application Rejection Status Type",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"constraints": {
				"enum": [
					"accepted",
					"cured",
					"pending",
					"rejected"
				],
				"required": true
			},
			"description": "Specifies the current status of the application. Possible values are **accepted**, which denotes that the application was successfully processed; **cured** which means the application was supplemented with additional information to make it valid; **pending**, which signifies that application is still being processed; **rejected** which means the application was not successfully processed.",
			"format": "default",
			"name": "ApplicationRequestStatusType",
			"title": "Application Request Status",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"constraints": {
				"enum": [
					"fpca",
					"fwab",
					"informal-request",
					"nvra",
					"state-application",
					"untracked"
				],
				"required": true
			},
			"description": "Specifies the type of ballot application request. Possible values are **fpca**, which means a voter submitted a Federal Postcard Application; **fwab**, which denotes a voter returned a Federal Write-In Absentee Ballot prior to receiving or requesting a ballot through other means; **informal-request**, which signifies a voter requested a ballot through a less formal process, such as a letter or phone call; **nvra**, which means a voter used a National Voter Registration (Act) form; **state-application**, which denotes a state form used for ballot requests; and **untracked**, which means the type of application is not tracked.",
			"format": "default",
			"name": "ApplicationRequestType",
			"title": "Type of Application Request",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"constraints": {
			},
			"description": "Specifies the reason why the ballot was rejected. Possible values are **mismatch-voter-signature**, which denotes the signature on file did not match the signature on the returned envelope or document; **missing-voter-signature**, which signifies that the voter signature is missing on the returned documents; **not-timely**, which means the ballot was received after the required deadline; **postmark**, which signifies the ballot was postmarked after the required date; **rejected**, which signifies the ballot was rejected for an unspecified reason; **undeliverable**, which denotes the ballot was returned as undeliverable to the address where it was sent; **untracked**, which signifies that this variable is not tracked in the system; **voided-spoiled**, which means the ballot had to be voided or spoiled either by the administration or the voter; **voter-died**, which signifies the voter died thereby impacting the ability to count the ballot (NB: this is largely dependent on state law); **voter-moved**, which signifies the voter moved from their registered address; **voter-unregistered**, which means the voter is not registered to vote; and, **other**, which is a catch-all for any values that fall outside of the other values.",
			"format": "default",
			"name": "BallotRejectionType",
			"title": "Ballot Rejection Type",
			"type": "array",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "If BallotRejectionType fails to cover all of the possible ways a ballot may be rejected, this field specifies an alternate reason why the reason the ballot was rejected.",
			"format": "default",
			"name": "BallotRejectionOtherType",
			"title": "Other Ballot Rejection Type",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "Specifies the date the voter returned the ballot to the local or state election official.",
			"format": "default",
			"name": "BallotReturnDate",
			"title": "Ballot Returned Date",
			"type": "date"
		},
		{
			"constraints": {
				"enum": [
					"email",
					"fax",
					"in-person",
					"mail",
					"online",
					"untracked",
					"other"
				]
			},
			"description": "Specifies the method by which the voter returned the ballot to the local or state election official. Possible values are **email**, which signifies the ballot was received via email; **fax**, which denotes the ballot was received by fax; **in-person**, which means the ballot was delivered by a person (NB: this does not necessarily signify the voter themselves delivered the ballot); **mail**, which signifies the ballot was received via mail; **online**, which means the ballot was submitted via online form or system; **untracked**, which signifies that this variable is not tracked in the system; and, **other**, which is a catch-all for any values that fall outside of the other values.",
			"format": "default",
			"name": "BallotReturnType",
			"title": "Ballot Return Type",
			"type": "string",
			"trueValues": [
				"true",
				"True",
				"TRUE",
				"1"
			],
			"falseValues": [
				"false",
				"False",
				"FALSE",
				"0"
			],
			"decimalChar": ".",
			"groupChar": "",
			"bareNumber": true
		},
		{
			"description": "If BallotReturnType fails to cover all of the possible return types for a particular voter transaction, this field specifies an alternate method by which the voter returned the ballot to the local or state election official.",
			"format": "default",
			"name": "BallotReturnOtherType",
			"title": "Ballot Return Type",
			"type": "string"
		},
		{
			"description": "Specifies the date the local or state election official sent the ballot to the voter.",
			"format": "default",
			"name": "BallotTransmissionDate",
			"title": "Ballot Transmission Date",
			"type": "date"
		},
		{
			"constraints": {
				"enum": [
					"email",
					"fax",
					"in-person",
					"mail",
					"online",
					"untracked",
					"other"
				]
			},
			"description": "Specifies the method in which the ballot was sent to the voter. Possible values are **email**, which signifies the ballot was transmitted via email; **fax**, which denotes the ballot was transmitted by fax; **in-person**, which means the ballot given to a person; **mail**, which signifies the ballot was transmitted via mail; **online**, which means the ballot was transmitted via online form or system; **untracked**, which signifies that this variable is not tracked in the system; and, **other**, which is a catch-all for any values that fall outside of the other values.",
			"format": "default",
			"name": "BallotTransmissionType",
			"title": "Ballot Transmission Type",
			"type": "string"
		},
		{
			"description": "If BallotTransmissionType fails to cover all of the possible transmission types for a particular transaction, this field specifies an alternate method in which the local or state election official sent the ballot to the voter.",
			"format": "default",
			"name": "BallotTransmissionOtherType",
			"title": "Other Ballot Transmission Type",
			"type": "string"
		},
		{
			"constraints": {
				"enum": [
					"absentee",
					"federal",
					"full",
					"fwab",
					"provisional",
					"untracked"
				]
			},
			"description": "Specifies the type of ballot transferred to the voter. Possible values are **absentee**, which is a general catch-all for any type of absentee ballot, **federal**, which denotes the voter only received a ballot that allows voting on federal contests, **full**, which denotes a ballot with all possible contests in the voter's assigned precinct; **fwab**, which specifies a Federal Write-In Absentee Ballot, and **provisional**, which denotes a provisional ballot; and, **untracked**, which signifies that this variable is not tracked in the system.",
			"format": "default",
			"name": "BallotType",
			"title": "Ballot Type",
			"type": "string"
		},
		{
			"constraints": {
				"required": true
			},
			"description": "Specifies the date the election took place.",
			"format": "default",
			"name": "ElectionDate",
			"title": "Election Date",
			"type": "date"
		},
		{
			"constraints": {
				"required": true
			},
			"description": "Specifies the name of the election.",
			"format": "default",
			"name": "ElectionName",
			"title": "Election Name",
			"type": "string"
		},
		{
			"constraints": {
				"required": true
			},
			"description": "Specifies a unique identifier for the jurisdiction.",
			"format": "default",
			"name": "JurisdictionId",
			"title": "Jurisdiction Identifier",
			"type": "string"
		},
		{
			"constraints": {
				"enum": [
					"ocd-id",
					"fips",
					"local"
				],
				"required": true
			},
			"description": "Specifies the type of identifier used to identify the jurisdiction in JurisdictionId. Possible values are **local**, which dictates the jurisdiction created the identifier, **fips**, which means the identifier follows the Federal Information Processing Standard (FIPS) code, or **ocd-id**, which means the identifier follows the Open Civic Data Division Identifier (OCDID) standard.",
			"format": "default",
			"name": "JurisdictionIdType",
			"title": "Jurisdiction Identifier Type",
			"type": "string"
		},
		{
			"constraints": {
				"required": true
			},
			"description": "Specifies the name of the jurisdiction in which the voter is registered.",
			"format": "default",
			"name": "JurisdictionName",
			"title": "Jurisdiction Name",
			"type": "string"
		},
		{
			"constraints": {
				"enum": [
					"Alabama",
					"Alaska",
					"American Samoa",
					"Arizona",
					"Arkansas",
					"California",
					"Colorado",
					"Connecticut",
					"Delaware",
					"District Of Columbia",
					"Federated States Of Micronesia",
					"Florida",
					"Georgia",
					"Guam",
					"Hawaii",
					"Idaho",
					"Illinois",
					"Indiana",
					"Iowa",
					"Kansas",
					"Kentucky",
					"Louisiana",
					"Maine",
					"Marshall Islands",
					"Maryland",
					"Massachusetts",
					"Michigan",
					"Minnesota",
					"Mississippi",
					"Missouri",
					"Montana",
					"Nebraska",
					"Nevada",
					"New Hampshire",
					"New Jersey",
					"New Mexico",
					"New York",
					"North Carolina",
					"North Dakota",
					"Northern Mariana Islands",
					"Ohio",
					"Oklahoma",
					"Oregon",
					"Palau",
					"Pennsylvania",
					"Puerto Rico",
					"Rhode Island",
					"South Carolina",
					"South Dakota",
					"Tennessee",
					"Texas",
					"Utah",
					"Vermont",
					"Virgin Islands",
					"Virginia",
					"Washington",
					"West Virginia",
					"Wisconsin",
					"Wyoming"
				],
				"required": true
			},
			"description": "Specifies the name of the state in which the voter is registered.",
			"format": "default",
			"name": "StateName",
			"title": "State Name",
			"type": "string"
		},
		{
			"description": "Specifies what country to which the ballot was mailed. The country should be a recognized country name according to ISO 3166.",
			"format": "default",
			"name": "VoterMailingCountry",
			"title": "Voter's Mailing Country",
			"type": "string"
		},
		{
			"constraints": {
				"enum": [
					"domestic-military",
					"domestic-military-spouse-dependent",
					"military",
					"military-spouse-dependent",
					"overseas-citizen",
					"overseas-military",
					"overseas-military-spouse-dependent",
					"other"
				]
			},
			"description": "Specifies whether the voter is domestic or overseas military (or simply military if the designation is unknown), a spouse or dependent of a member of the military, or other if the type of voter falls outside the previous designations.",
			"format": "default",
			"name": "VoterType",
			"title": "Voter Type",
			"type": "string"
		},
		{
			"description": "**Deprecated.** Specifies whether the application request was accepted or rejected.",
			"format": "default",
			"name": "WasApplicationRejected",
			"title": "Was the Application Rejected",
			"type": "boolean"
		}
	],
	"missingValues": [
		""
	]
}