| Mailing Address Table from Advokit. One record per unique mailing address. Voters are linked to records in this table. Note that editing a mailing address record changes information for *all* voters who are linked to that mailing address. |
||||
| Field | Req'd Yes or No? | Size (in characters) | Explanation – what it is intended to be used for or very clear example of data that would go into the field | Default by Advokit? If empty, will import.pl automatically put a value in this field? If so what is it? |
| number | 11 | Numeric portion of a street address, e.g. ‘1552’. | Non-digit portions split out. E.g. "1A2B" becomes "12" (yes, this sucks) | |
| num_suffix | 10 | e.g. ‘ 1/2 ’, ‘A’, ‘-1’, etc. This is any non-numeric portion of a street address | Import.pl will split non-numeric portions of street addresses from the initial numeric portion, and put them into ‘number' and ‘num_suffix'. However you can map these fields directly to input fields, in which case import.pl will not automatically create ‘num-suffix' | |
| precompass | 10 | N, S, E etc | Prepended portion of street name indicating direction | |
| streetname | 30 | Elm | ||
| streettype | 20 | ST, Blvd, Road, etc | If not mapped from an input field, import.pl will attempt to split it out of the input street name field. Must match a street type in street types list in import script | |
| postcompass | 10 | N,S,E,W, SE, etc | Appended portion of street name indicating direction | |
| aptname | 10 | Building B | If an aptname is provided, it is written to this field. Otherwise if aptnum is provided, it is written here. If neither is provided, parsing of "line1" may populate this field. | |
| aptnum | 8 | 15 | If the aptname or aptnum contains non-digits, they are stripped out and the numeric characters are written to aptnum. If neither is provided, parsing of "line1" may populate this field. | |
| line1 | 40 | Concatenated address, line one | If not mapped from an input field, import.pl will assemble from street address fields. If street address fields are not provided, import.pl will attempt to parse line1 to populate those fields. | |
| line2 | 40 | Optional second address line | ||
| city | 30 | New Orleans | ||
| state_id | 2 | CA, NY (use standard two-letter state abbreviations) | Must match item in state list in import script | |
| zip | 5 | Only first 5 zip numbers here | ||
| zipplus4 | no | 4 | Only last 4 zip+4 numbers here | |
| county_id | 11 | You can put longer here Advokit will change to its own code | There is a bug in import.pl that requires a county_id to be included during import. You can put in whatever you want. | |
| Residence Table from Advokit. One record per unique residence address. Voters are linked to records in this table. Note that editing an existing residence record changes residence information for *all* voters who are linked to that address. |
||||
| Field | Req'd Yes or No? | Size (in characters) | Explanation – what it is intended to be used for or very clear example of data that would go into the field | Default by Advokit? If empty, will import.pl automatically put a value in this field? If so what is it? |
| number | yes | 11 | Numeric portion of a street address, e.g. ‘1552’. | Non-digit portions split out. E.g. "1A2B" becomes "12" (yes, this sucks) |
| num_suffix | no | 10 | e.g. ‘ 1/2 ’, ‘A’, ‘-1’, etc. This is any non-numeric portion of a street address | Import.pl will split non-numeric portions of street addresses from the initial numeric portion, and put them into ‘number’ and ‘num_suffix’. However you can map these fields directly to input fields, in which case import.pl will not automatically create ‘num-suffix’ |
| precompass | no | 10 | N, S, E etc | Prepended portion of street name indicating direction |
| streetname | yes | 30 | Elm | |
| streettype | no | 20 | ST, Blvd, Road, etc | If not mapped from an input field, import.pl will attempt to split it out of the input street name field. Must match a street type in street types list in import script |
| postcompass | no | 10 | N,S,E,W, SE, etc | Appended portion of street name indicating direction |
| aptname | no | 10 | Building B | If an aptname is provided, it is written to this field. Otherwise if aptnum is provided, it is written here. If neither is provided, parsing of "line1" may populate this field. |
| aptnum | no | 8 | 15 | If the aptname or aptnum contains non-digits, they are stripped out and the numeric characters are written to aptnum. If neither is provided, parsing of "line1" may populate this field. |
| line1 | no | 40 | Concatenated address, line one | If not mapped from an input field, import.pl will assemble from street address fields. If street address fields are not provided, import.pl will attempt to parse line1 to populate those fields. |
| line2 | no | 40 | Optional second address line | |
| city | yes | 30 | New Orleans | |
| state_id | yes | 2 | CA, NY (use standard two-letter state abbreviations) | Must match item in state list in import script |
| zip | yes | 5 | Only first 5 zip numbers here | |
| zipplus4 | no | 4 | Only last 4 zip+4 numbers here | |
| county_id | yes | 11 | You can put longer here Advokit will change to its own code | There is a bug in import.p that requires a county_id to be included during import. You can put in whatever you want if you do not have county data. |
| latitude | no | FLOAT | ||
| longitude | no | FLOAT | ||
| Respolis Table from Advokit. This table stores “political address” information. Import.pl will create one respolis record per unique “political address”. Voters are linked to records in this table. Note that editing an existing respolis record changes respolis information for *all* voters who are linked to that record. |
||||
| Field | Req'd Yes or No? | Size (in characters) | Explanation – what it is intended to be used for or very clear example of data that would go into the field | Default by Advokit? If empty, will import.pl automatically put a value in this field? If so what is it? |
| ward_number | no | 20 | If you have wards, use it. If not, ignore. If you have supervisorial district data put it here. | |
| precinct_number | no | 20 | If you have precincts, parishes, etc. that are identified numerically, use this field. | Import.pl will create a single record for each precinct number or name |
| precinct_name | no | 50 | If you have precincts, parishes, etc. that are not identified numerically, use this field. | If you have precinct "portions" make sure names reflect them or the portions will be ignored during import, ie. Use "AG001_A" and "AG001_B" instead of just "AG001" |
| us_rep_district | no | 20 | US Congressional district | |
| us_sen_district | no | 20 | Ignore (or use for your own purposes) | |
| st_rep_district | no | 20 | State representative district | |
| st_sen_district | no | 20 | State Senate district | |
| census_tract | no | 20 | Geographic designation from the US Census | |
| census_block | no | 20 | Geographic designation from the US Census | |
| Voter table from advokit. One voter record per voter. Note that residence address, mailing address, and “political address” (respolis) are extracted into other tables by import.pl. |
||||
| Field | Req'd Yes or No? | Size (in characters) | Explanation – what it is intended to be used for or very clear example of data that would go into the field | Default by Advokit? If empty, will Advokit automatically put a value in this field? If so what is it? Comments |
| instance_code | no | 11 | This is meant to support multiple campaigns and voter files – it can be ignored. Designates source of data from which this import comes | |
| instance_area | no | 10 | This is meant to support multiple campaigns and voter files – it can be ignored. | |
| salutation | no | 10 | Mr,Mrs,Ms, etc. | |
| nickname | no | 15 | e.g. Bob | copy of firstname |
| firstname | yes | 15 | e.g. “Robert”(for “Robert L. Smith”) | |
| middle_initial | no | 1 | e.g. “L” (for “Robert L. Smith”) | |
| lastname | yes | 35 | “Smith” (for “Robert L. Smith”) | |
| suffix | no | 10 | Jr., Sr. III, etc. | |
| birth_year | yes* | 4 | Year of birth, e.g. 1946 | |
| birth_month | yes* | 2 | 08 (two digits) | |
| birth_dom | yes* | 2 | Day of the month, e.g. if the birth date is May 31st, then this field would have “31” | *date of birth is used to display age – it is not strictly required |
| birthdate | no | Datetime | There is currently a bug in import.pl – the best approach is to provide birth_year, birth_month, and birth_dom. Leave birthdate unmapped.import.pl will then create birthdate correctly. | Import.pl will calculate this from birth_year, birth_month, and birth_dom |
| confidence_level | no | 1 | This is meant to allow you to indicate your confidence that the information in this voter record is accurate. | |
| gender | no | 1 | ‘M’, ‘F’, or ‘U’. | ‘U’ is the default |
| occupation | no | 20 | E.g. stone mason | |
| citizenship | no | 2 | Use ISO 3166-1two-letter country codes (a list can be found here: http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html) | ‘US’ is the default |
| is_registered | no | 1 | Is the person registered to vote? Y or N ? | ‘N’ |
| registeredon | no | Datetime | Date of voter registration. Format as (e.g.) ‘2006-01-31’ | |
| can_vote | no | 1 | Not clearly defined – intended to indicate whether or not the person will be able to vote. ‘Y’, ‘N’, ‘U’ | |
| will_vote | no | 1 | Not clearly defined – intended to indicate whether or not the person plans to vote. ‘Y’, ‘N’, ‘U’ | |
| absentee | no | 1 | . ‘Y’, ‘N’, ‘U’ – is this person an absentee voter? | ‘N’ |
| party_affiliation | no | 1 | Single character identifying political party affiliation. E.g. ‘D’, ‘R’ | Note:Check your local data before importing and convert to single unique character for each party or you'll end up with both "DEM" and "DTS" (declined to state) as "D" |
| ph_home | no | 12 | Home phone number. No required format, but use consistently (e.g. ###-###-####) to enable e.g. filtering by area code (e.g. ph_home like ‘212-%’) Assumed 7 or 10 digits | Adds dashes at 3-digit intervals |
| ph_office | no | 12 | Office phone number Assumed 7 or 10 digits | Adds dashes at 3-digit intervals |
| ph_mobile | no | 12 | Cell phone number Assumed 7 or 10 digits | Adds dashes at 3-digit intervals |
| no | 30 | Primary email address | ||
| alt_email | no | 30 | Alternate email address | |
| imid | no | 20 | Instant messaging identity/screen name | |
| imtype_id | no | 11 | Associated instant messaging service (e.g. ‘AOL’) type, must match record in imtypes table | |
| alt_imid | no | 20 | Second instant messaging identity/screen name | |
| alt_imtype_id | no | 11 | alternate instant messaging service (e.g. ‘MSN’) type, must match record in imtypes table | |
| uploaded | no | 1 | Originally intended to indicate if the voter record was created by voterfile upload, or entered interactively. Y or N | Set internally to indicate whether data was entered through advokit |
| notes | no | TEXT | Whatever you want can go in here. | |