This builds on the schema developed by the get.bills module.
There's a sponsor_uri column in the bills table generated by the get.bills module which we can use to get metadata about primary sponsor legislation.
We need to figure out if we care about cosponsorship. I think cosponsorship needs to come directly from the /bills endpoint of the ProPublica API (the sponsor_uri endpoint is simply just a link to the single /members endpoint for the given sponsor).
todo:
[x] create a table (or db?, probably a table) that contains all of the legislators referenced in the bills table
[x] create a table that links each of those legislators to bills that they primarily sponsor. This table should have a "sponsorship_type" field to eventually support the addition of cosponsorship relations
This builds on the schema developed by the get.bills module.
There's a
sponsor_uricolumn in the bills table generated by the get.bills module which we can use to get metadata about primary sponsor legislation.We need to figure out if we care about cosponsorship. I think cosponsorship needs to come directly from the /bills endpoint of the ProPublica API (the
sponsor_uriendpoint is simply just a link to the single/membersendpoint for the given sponsor).todo: