Ray Kiddy

Results 49 comments of Ray Kiddy

What I did in my version of this is add a amend_id column to the filer_filings table. From the SoS, that table has a row for each filing but does...

Just put in the pull-request for this. FYI, after running this, here are the counts of the different high amend_id values. At first, I was getting duplicates in the filing_id...

The OpenStates people only have IDs for the elected members of the state legislature. Am I right about that? That is not a large fraction of the names that appear...

This is a MyISAM vs InnoDB issue in the sense that MyISAM does not support foreign keys, and therefore does not support foreign key constraints, and InnoDB does. But are...

I believe I see where the problem is. In the expenditures.py file, you have this right up near the top: ``` committee = models.ForeignKey( 'Committee', related_name='expenditures_to' ) ``` So, I...

Perhaps the export could be directly to a xls file, instead of to a csv. Most people are going to put the data into a spreadsheet anyway.

Keep in mind also, when looking at the sums, that the filings include amended filings. One has to be careful to not over-count. If you have {filing_id=x,amend_id=0,amount=1000.00}, {filing_id=x,amend_id=1,amount=1500.00}, and {filing_id=x,amend_id=2,amount=2000.00},...

@jordan-gillard Is there anything in process on this? I am not seeing anything in your fork. Which mocking modules do you usually use? I can start something but would want...

Sorry if this seems lame, but can someone demonstrate how to run something in the local source. I do a lot with python, but mostly with flask apps and I...