Political Contributions By Venture Capitalists - Revision history

imported>Ed at 20:45, 17 October 2011

2011-10-17T20:45:33Z

128.32.74.87 at 23:51, 1 December 2009

2009-12-01T23:51:49Z

128.32.74.87 at 23:50, 1 December 2009

2009-12-01T23:50:28Z

128.32.74.87 at 23:34, 29 September 2009

2009-09-29T23:34:30Z

128.32.74.87 at 23:15, 29 September 2009

2009-09-29T23:15:52Z

128.32.74.87 at 23:13, 29 September 2009

2009-09-29T23:13:47Z

128.32.74.87 at 22:33, 29 September 2009

2009-09-29T22:33:09Z

imported>Ed at 21:52, 16 September 2009

2009-09-16T21:52:18Z

imported>Ed at 21:52, 16 September 2009

2009-09-16T21:52:02Z

imported>Ed at 21:51, 16 September 2009

2009-09-16T21:51:27Z

← Older revision		Revision as of 20:45, 17 October 2011
Line 55:		Line 55:
	*203 - can not use both imsp_sector_code and imsp_industry_code at the same time, please limit your use to just one of them (abort)		*203 - can not use both imsp_sector_code and imsp_industry_code at the same time, please limit your use to just one of them (abort)
	*300 - missing required input - input_argument is required (abort)		*300 - missing required input - input_argument is required (abort)
		+
		+	==Paper(s)==
		+
		+	See:
		+	*PHDBA279 (Berkeley): Non-Market Strategy in Venture Capital [[Media:Egan_(2009)_-_NonMarket_Strategy_in_Venture_Capital_--_Submitted_for_PHDBA279.pdf \|(Download PDF)]]

@@ Line 41: / Line 41: @@
   process_timestamp="08-21-2006 17:20:43" update_timestamp="08-17-2006 03:15:00">
-There following error codes may be returned (the perl module action is in square brackets):
+There following error codes may be returned (the perl module action is in brackets):
-*100 - invalid key [abort]
+*100 - invalid key (abort)
-*101 - access denied - restricted api [abort]
+*101 - access denied - restricted api (abort)
-*102 - total API call limit has been reached [abort]
+*102 - total API call limit has been reached (abort)
-*103 - total API bytes limit has been reached [abort]
+*103 - total API bytes limit has been reached (abort)
-*104 - total API records limit has been reached [abort]
+*104 - total API records limit has been reached (abort)
-*105 - call limit for this API method has been reached [wait and retry]
+*105 - call limit for this API method has been reached (wait and retry)
-*106 - bytes limit for this API method has been reached [wait and retry]
+*106 - bytes limit for this API method has been reached (wait and retry)
-*107 - records limit for this API method has been reached [wait and retry]
+*107 - records limit for this API method has been reached (wait and retry)
-*200 - no records found [record stub]
+*200 - no records found (record stub)
-*201 - id# not found - invalid imsp_committee_id number [record stub]
+*201 - id# not found - invalid imsp_committee_id number (record stub)
-*202 - id# not found - invalid imsp_candidate_id number [record stub]
+*202 - id# not found - invalid imsp_candidate_id number (record stub)
-*203 - can not use both imsp_sector_code and imsp_industry_code at the same time, please limit your use to just one of them [abort]
+*203 - can not use both imsp_sector_code and imsp_industry_code at the same time, please limit your use to just one of them (abort)
-*300 - missing required input - input_argument is required [abort]
+*300 - missing required input - input_argument is required (abort)

@@ Line 7: / Line 7: @@
 ==Data on Political Contributions==
-This project uses data from [http://www.followthemoney.org FollowTheMoney.Org]. The [http://www.followthemoney.org/services/document.phtml Basic documentation on the API] states that requests should be of the form:
+===FollowTheMoney.org===
   http://api.followthemoney.org/api_method.php?key=123456789ABCDEF
-where the key is the user assigned key. Error codes are returned as XML in the format:
+where the key is the user assigned key (sign-up to get a key!).
-  <error code="101" text="access denied - restricted api"
+A Perl module FollowTheMoney.pm (© Ed Egan, 2009) retrieves data through the XML API and creates tab-delimited text files. This module and other scripts are detailed below.
- origin="National Institute on Money in State Politics"
- process_timestamp="08-21-2006 17:20:43" update_timestamp="08-17-2006 03:15:00">
+===API Methods===
 A [http://www.followthemoney.org/services/methods.phtml full list of methods that can be called through the API], with links to their documentation, is provided. Of particular interest to this research are (required request fields are in brackets):
@@ Line 25: / Line 27: @@
 *ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.
-Requests to the server become very slow when the page number is high. At a restriction rate of 1000 records/minute and 200 records per page, the page requests are slower than the restriction (i.e. no throttling back is required) beyond about page 20. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests.
+===Requesting data through the API===
-One work-around this problem is to request candidates by state. The <tt>state_postal_code</tt> variable, requested as <tt>state</tt> unless in a sort, (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt]. Sept '09 estimates of number of candidates in the dataset are about 120,000. Given 200 per page, that is about 600 pages. Given 50 states, we expect about 12 pages per state with variation.
+There following error codes may be returned (the perl module action is in square brackets):

← Older revision		Revision as of 23:34, 29 September 2009
Line 27:		Line 27:
	Requests to the server become very slow when the page number is high. At a restriction rate of 1000 records/minute and 200 records per page, the page requests are slower than the restriction (i.e. no throttling back is required) beyond about page 20. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests.		Requests to the server become very slow when the page number is high. At a restriction rate of 1000 records/minute and 200 records per page, the page requests are slower than the restriction (i.e. no throttling back is required) beyond about page 20. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests.

−	One work-around this problem is to request candidates by state. The <tt>state_postal_code</tt> variable, requested as <tt>state</tt> unless in a sort, (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt].	+	One work-around this problem is to request candidates by state. The <tt>state_postal_code</tt> variable, requested as <tt>state</tt> unless in a sort, (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt]. Sept '09 estimates of number of candidates in the dataset are about 120,000. Given 200 per page, that is about 600 pages. Given 50 states, we expect about 12 pages per state with variation.

← Older revision		Revision as of 23:15, 29 September 2009
Line 25:		Line 25:
	*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.		*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.

−	Requests to the server become very slow when the page number is high. At a restriction rate of 1000 records/minute and 200 records per page, the page requests are slower than the restriction (i.e. no throttling back is required) beyond about page 20. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests. One work-around this problem is to request candidates by state. The state_postal_code variable (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt].	+	Requests to the server become very slow when the page number is high. At a restriction rate of 1000 records/minute and 200 records per page, the page requests are slower than the restriction (i.e. no throttling back is required) beyond about page 20. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests.
		+
		+	One work-around this problem is to request candidates by state. The <tt>state_postal_code</tt> variable, requested as <tt>state</tt> unless in a sort, (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt].

← Older revision		Revision as of 23:13, 29 September 2009
Line 25:		Line 25:
	*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.		*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.

−	Requests to the server become very slow when the page number is high. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests. One work-around this problem is to request candidates by state. The state_postal_code variable (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt].	+	Requests to the server become very slow when the page number is high. At a restriction rate of 1000 records/minute and 200 records per page, the page requests are slower than the restriction (i.e. no throttling back is required) beyond about page 20. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests. One work-around this problem is to request candidates by state. The state_postal_code variable (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt].

← Older revision		Revision as of 22:33, 29 September 2009
Line 24:		Line 24:
	*ballot_measures.committees.php - (key) Provides details on ballet measure committees, including committee ID		*ballot_measures.committees.php - (key) Provides details on ballet measure committees, including committee ID
	*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.		*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.
		+
		+	Requests to the server become very slow when the page number is high. This maybe due to a lack of database caching (particularly, the php scripts may be requesting data from the first page each time). This is particularly problematic when requesting the candidates list, which for most research purposes will be needed as a starting point for subsequent requests. One work-around this problem is to request candidates by state. The state_postal_code variable (presumably) follows the [http://www.usps.com/ncsc/lookups/usps_abbreviations.html USPS state abbreviation convention]. The codes provided in [http://www.edegan.com/repository/USPS-StateCodes.txt USPS-StateCodes.txt].

@@ Line 2: / Line 2: @@
 #Are political contributions by venture capitalists systematic and meaningful?
 #Are contributions related to a competition effect between private and government-sponsored venture capitalists? This might be attributable to either:
-**A Crowding-Out Effect
+##A Crowding-Out Effect
-**That the presence of GVCs gives entrepreneurs an outside option in negotiation with PVCs, reducing their bargaining surplus
+##That the presence of GVCs gives entrepreneurs an outside option in negotiation with PVCs, reducing their bargaining surplus
 ==Data on Political Contributions==

@@ Line 17: / Line 17: @@
   process_timestamp="08-21-2006 17:20:43" update_timestamp="08-17-2006 03:15:00">
-A [http://www.followthemoney.org/services/methods.phtml full list of methods that can be called through the API], with links to their documentation, is provided. Of particular interest to this research are:
+A [http://www.followthemoney.org/services/methods.phtml full list of methods that can be called through the API], with links to their documentation, is provided. Of particular interest to this research are (required request fields are in brackets):
 *candidates.list.php - (key) Provides a list of all candidates, including their IDs
 *candidates.contributions.php - (key,candidate_id) Provides details on all contributions, including contributor name
@@ Line 23: / Line 23: @@
 *ballot_measures.list.php - (key) Provides details on ballot measures
 *ballot_measures.committees.php - (key) Provides details on ballet measure committees, including committee ID
-ballot_measures.committees.contributions.php - (Key,committee_id) Provides details on contributions to specific ballot measures.
+*ballot_measures.committees.contributions.php - (key,committee_id) Provides details on contributions to specific ballot measures.