用于处理德克萨斯州道德委员会原始文件的工具。
项目描述
轻松获取TEC文件数据！插入TEC文件ID，以CSV格式获取捐赠或支出数据。
安装
pip install tecfilingfetcher
工作原理
非常简单
usage: fetchfiling [-h] [-t {contributions,expenditures}] [-s]
filing_id [filing_id ...]
positional arguments:
filing_id The TEC filing ID(s) to fetch
optional arguments:
-h, --help show this help message and exit
-t {contributions,expenditures}, --type {contributions,expenditures}
The type of data you want to get
-s, --simple Returns only basic fields, good if you only want
numbers
示例
$ fetchfiling -s -t contributions 580604 # Texans for Rick Perry's July 2013 Semiannual .. Unique ID,Entity Code,Last/Organization Name,First Name(s),Title,Suffix,Street Address 1,Street Address 2,City,State,ZIP Code,Date,Amount/In-kind Value,Description,Employer,Principal Occupation/Job Title,Travel Outside Texas (If In-kind) 2,IND,London,Stacy,,,,,Houston,TX,77024,20130617,400.00,,Self,Real Estate, 1,IND,Cantwell,Michael,,,,,Leander,TX,78641,20130617,100.00,,,, 28,IND,Anwar,S. Javaid,Mr. and Mrs.,,,,Midland,TX,79705,20130620,16250.00,(See travel info),Midland Energy,Owner/President,X 2,,,,,,,,,,,,,,,,X 3,,,,,,,,,,,,,,,,X 4,,,,,,,,,,,,,,,,X 3,IND,Jones,Dale,,,,,Coppell,TX,75019,20130624,500.00,,Best Efforts,Best Efforts, 4,IND,Holmes,William,,,,,El Paso,TX,79912,20130624,1000.00,,Best Efforts,Best Efforts, 5,IND,Musil,Stephen,,,,,Cedar Park,TX,78613,20130624,25.00,,,, 6,IND,Vazquez,Laura,,,,,El Paso,TX,79936,20130624,25.00,,,, 7,IND,Lott,Thomas,Mr.,,,,Fulshear,TX,77441,20130624,100.00,,Andarko Petroleum,Geologist, 8,IND,Brunone,Dominick,,,,,The Hills,TX,78738,20130624,25.00,,,, 9,IND,Ciaccio,Michael,,,,,Sugar Land,TX,77496,20130624,10.00,,,, 10,IND,DiLorenzo,Mary,Ms.,,,,Bethpage,NY,11714,20130624,100.00,,Suffolk County National Bank,VP Financial Reporting Manager, 11,IND,Higginbotham,Lou,Ms.,,,,Dallas,TX,75205,20130624,500.00,,Retired,Retired, 12,IND,Baker,James,,,,,San Marcos,TX,78666,20130624,25.00,,Self,Real Estate, 15,IND,Holdren,David,Mr.,,,,San Angelo,TX,76903,20130625,10.00,,Retired,Retired, 14,IND,Pappas,Peter,,,,,Rockbridge,MO,65741,20130625,25.00,,Best Efforts,Best Efforts, 16,IND,Eskridge,Robert,,,,,Round Rock,TX,78681,20130625,100.00,,,,
文件获取器输出到stdout - 如果您需要保存它，将其直接导向文件。
fetchfiling -s -t contributions 580604 > texans_for_rick_perry_july13.csv
您现在可以通过传入空格分隔的文件ID一次获取多个报告。如果您需要为同一提交者获取多个报告，您可能需要这样做。报告本身不标识哪一行属于哪个提交者，因此请确保所有ID都指向同一个ID！
$ fetchfiling -s -t contributions 580604 599270 # Texans for Rick Perry's July 2013 Semiannual + January 2014 Semiannual
但是…这些ID从哪里来？
通过德克萨斯州道德委员会，通过竞选财务搜索表单。例如，您可以在此页面上找到Rick Perry的德克萨斯人文件ID。
