nadac_distrID=Promise.all(medicaid.map(({title})=>title).sort().filter(el=>el.includes("NADAC (National Average Drug Acquisition Cost) 2023")).map(title=>{returnmedicaid.find(obj=>obj.title===title)["identifier"]}).map(id=>sdk.convertDatasetToDistributionId(id)))
nadac=Promise.all(nadac_distrID.map(id=>{returnsdk.getDatastoreQuerySql(`[SELECT * FROM ${id}][LIMIT 500000]`)}))
data=sdk.getDatastoreQuerySql('[SELECT state,state_rate FROM 11196f15-1a77-5b80-97f3-c46c0ce19894][WHERE measure_name = "Percentage of Eligibles Who Received Preventive Dental Services: Ages 1-20"]')
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.