Saturday, May 23, 2015

Questions about the NYS Senate API

Some questions that you may have as a citizen of New York State are:
  • How many legislative bills are produced each year?
  • How many legislative bills are passed each year?
Those questions seem to be very basic and necessary to understand our legislative process in New York State.


See http://demo.redash.io/queries/278#349

This is Count of New York State Legislative Bills per year.  It appears to vary between 20,000 and 10,000 in alternating years. Is this possible?



But if we look at bill actions we see:

http://demo.redash.io/queries/287#366 (requires an account)

The bill actions seems to be consistently in the 60,000 range.  That seems like a lot of actions.



Who are the top sponsors of these actions?

See http://demo.redash.io/queries/291#369




See also

http://civic-data.github.io/laws-of-planet-earth/us/ny/scripts_openlegislation/getdata1_swtoolkit_bigquery_nys_bills.html#2014