Expenditures Data

Expenditures includes the financial transactions conducted by the county. Names in some of the transactions have been redacted to protect individual names when providing them may violate privacy as per HIPPA, MGDPA, or other regulations. In these cases, the vendor name is replaced with the description of the account and "(redacted)".

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 \"ramseycounty-us/expenditures-data-4htu-nawa\".\"expenditures_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.