Defendant Court Dates - Public Defender

Court appearance dates, crime types, demographic information, text notifications, and appearance outcomes for defendants represented by the Marin County Public Defender. Data is updated daily and begins in August 2019.

Information about each Defendant includes the number of text notifications he or she received, whether the court date is for a misdemeanor or felony, the crime type, the age range of the defendant at the time of the court date, ethnicity and gender. Also included is whether the Defendant appeared or failed to appear for the court date.

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 \"marincounty/defendant-court-dates-public-defender-f8iq-5syg\".\"defendant_court_dates_public_defender\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.