Lobbying Reporting System: Lobbyist Activity Reports - November 2005 to April 2017

This dataset shows expenses made by registered lobbyists as part of activities on behalf of registered employers from 2005 to 2017.

Data are provided by the Maryland State Ethics Commission. To view the most updated data, please visit: http://search.lobby.ethics.state.md.us:8080/search.

The fields B1, B2, B3, and so on represent different types and sums of expenses and compensation which lobbyists are required to report in activity reports. Additional information on activity reports can be found here: http://ethics.maryland.gov/lobbyists/file-an-activity-report/.

A lobbying year runs from November 1 through October 31. Activity reports are filed for each six-month period from November 1 to April 30 and May 1 to October 31.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"opendata-maryland-gov/lobbying-reporting-system-lobbyist-activity-p6kr-u5k5\".\"lobbying_reporting_system_lobbyist_activity\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.