Pregnancy Risk Assessment Monitoring System (PRAMS)

The Pregnancy Risk Assessment Monitoring System (PRAMS) is an ongoing, population-based risk factor surveillance system designed to identify and monitor selected maternal experiences and behaviors that occur before, during, and shortly after pregnancy, among a stratified sample of mothers delivering a live birth. PRAMS is a partnership with the CDC and presently exists in 50 jurisdictions, including 47 states, New York City, Washington, D.C., and Puerto Rico. In NYC, PRAMS participants are randomly selected from the City’s birth certificate records (approximately 2,100 participants per year).

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 \"cityofnewyork-us/pregnancy-risk-assessment-monitoring-system-prams-rqgf-94xs\".\"pregnancy_risk_assessment_monitoring_system_prams\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.