设万维读者为首页 广告服务 技术服务 联系我们 关于万维
简体 繁体 手机版
分类广告
版主:阿飞的剑
万维读者网 > 茗香茶语 > 跟帖
mail in data
送交者: pifu01 2020月12月04日12:35:25 于 [茗香茶语] 发送悄悄话
回  答: voter form, 行和列置换了一下以方便看pifu01 于 2020-12-04 12:14:16
voterregnumber700875825700875830700875830
lastnamedoedoe1doe1
firstnamejnejane1jane1
middlenameLynn

suffix


voterstatusActiveActiveActive
voterstatusreasonRegisteredRegisteredRegistered
votertypeRegularRegularRegular
address1123 6TH ST S4567 BADGER ST RM 223B4567 BADGER ST RM 223B
address2LA CROSSE WI 54601-4546LA CROSSE WI 54601-3610LA CROSSE WI 54601-3610
housenumber12345674567
streetname6TH ST SBADGER STBADGER ST
unittype
RMRM
unitnumber
223B223B
zipcode54601-454654601-361054601-3610
mailingaddress1


mailingaddress2


mailingcitystatezip


phonenumber(xxx)xxxxxxx

emailaddress


jurisdictionCITY OF LA CROSSE - LA CROSSE   COUNTYCITY OF LA CROSSE - LA CROSSE   COUNTYCITY OF LA CROSSE - LA CROSSE   COUNTY
countyLa Crosse CountyLa Crosse CountyLa Crosse County
absapplicationdate10/30/20203/16/20209/15/2020
applicationsourceVoted in PersonEmailOnline
applicationtypeRegularRegularRegular
absenteeaddressname921 6TH ST S, LA CROSSE, WI   54601-45463214 W 61ST PL, CHICAGO, IL 60629521 Tenth St N APT 2, La Crosse,   WI 54601
electionname2020 General Election2020 Spring Election and   Presidential Preference Vote2020 General Election
ballotreasontype


ballottypeOfficialOfficialOfficial
ballotstatusActiveActiveActive
districtcombo32246-014-2849-132246-008-2849-132246-008-2849-1
wardnameCity of La Crosse - Ward 14City of La Crosse - Ward 8City of La Crosse - Ward 8
ballotstatusreasonReturnedReturnedReturned
ballotdeliverymethodVoted In PersonMailMail
dateballotsent10/30/20203/16/20209/18/2020
dateballotreturned10/30/20203/26/20209/30/2020

这个表格里有election name, 各种election都在里面,有人每个election都投了票的就有多个entry,所以如果要统计需要clean up data

0%(0)
0%(0)
标  题 (必选项):
内  容 (选填项):
实用资讯
回国机票$360起 | 商务舱省$200 | 全球最佳航空公司出炉:海航获五星
海外华人福利!在线看陈建斌《三叉戟》热血归回 豪情筑梦 高清免费看 无地区限制