Assemble a Query for an Endpoint
Examples
assemble(
endpoint("drug_state"),
query(year = 2022:2024,
state = any_of("GA", "NY")))
#> https://data.medicaid.gov/api/1/datastore/query/61729e5a-7aa8-448c-8903-ba3e0cd0ea3c/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=GA&conditions[0][value][]=NY
#> https://data.medicaid.gov/api/1/datastore/query/d890d3a9-6b00-43fd-8b31-fcba4c8e2909/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=GA&conditions[0][value][]=NY
#> https://data.medicaid.gov/api/1/datastore/query/200c2cba-e58d-4a95-aa60-14b99736808d/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=GA&conditions[0][value][]=NY
assemble(
endpoint("enroll_prov"),
query(enrlmt_id = "I20040309000221"))
#> [1] "https://data.cms.gov/data-api/v1/dataset/2457ea29-fc82-48b0-86ec-3b0755de7515/data-viewer/stats?offset=0&size=1&filter[1][condition][path]=ENRLMT_ID&filter[1][condition][operator]==&filter[1][condition][value]=I20040309000221"
assemble(
collection("dialysis"),
query(state = "AL"))
#> $dial_listing
#> [1] "https://data.cms.gov/provider-data/api/1/datastore/query/23ew-n7w9/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]==&conditions[0][value]=AL"
#>
#> $dial_nation
#> [1] "https://data.cms.gov/provider-data/api/1/datastore/query/2rkq-ygai/0"
#>
#> $dial_state
#> [1] "https://data.cms.gov/provider-data/api/1/datastore/query/2fpu-cgbb/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]==&conditions[0][value]=AL"
#>
assemble(
endpoint("dial_facility"),
query(
state = "GA",
city = "Atlanta",
provcity = "Atlanta",
provider_name = starts_with("C"),
provname = starts_with("C")
)
)
#> https://data.cms.gov/data-api/v1/dataset/7d4e7bd1-f08a-4fca-8085-6af24026a19a/data/stats?offset=0&size=1&filter[1][condition][path]=state&filter[1][condition][operator]==&filter[1][condition][value]=GA&filter[2][condition][path]=Provider_Name&filter[2][condition][operator]=STARTS_WITH&filter[2][condition][value]=C&filter[3][condition][path]=city&filter[3][condition][operator]==&filter[3][condition][value]=Atlanta
#> https://data.cms.gov/data-api/v1/dataset/62d125ff-c959-4c5c-8a46-8cacba50bfd4/data/stats?offset=0&size=1&filter[1][condition][path]=state&filter[1][condition][operator]==&filter[1][condition][value]=GA&filter[2][condition][path]=Provider_Name&filter[2][condition][operator]=STARTS_WITH&filter[2][condition][value]=C&filter[3][condition][path]=city&filter[3][condition][operator]==&filter[3][condition][value]=Atlanta
#> https://data.cms.gov/data-api/v1/dataset/200e7e7e-a5a6-4450-ba18-ab53d237cc45/data/stats?offset=0&size=1&filter[1][condition][path]=state&filter[1][condition][operator]==&filter[1][condition][value]=GA&filter[2][condition][path]=Provider_Name&filter[2][condition][operator]=STARTS_WITH&filter[2][condition][value]=C&filter[3][condition][path]=city&filter[3][condition][operator]==&filter[3][condition][value]=Atlanta
#> https://data.cms.gov/data-api/v1/dataset/ebc64ad1-164c-455a-80ca-cb0753e44a46/data/stats?offset=0&size=1&filter[1][condition][path]=state&filter[1][condition][operator]==&filter[1][condition][value]=GA&filter[2][condition][path]=Provider_Name&filter[2][condition][operator]=STARTS_WITH&filter[2][condition][value]=C&filter[3][condition][path]=city&filter[3][condition][operator]==&filter[3][condition][value]=Atlanta
#> https://data.cms.gov/data-api/v1/dataset/e66eaf03-398f-4a8c-9d1b-6aaf25fb6425/data/stats?offset=0&size=1&filter[1][condition][path]=State&filter[1][condition][operator]==&filter[1][condition][value]=GA&filter[2][condition][path]=Provider+Name&filter[2][condition][operator]=STARTS_WITH&filter[2][condition][value]=C&filter[3][condition][path]=City&filter[3][condition][operator]==&filter[3][condition][value]=Atlanta
#> https://data.cms.gov/data-api/v1/dataset/44aedde0-c535-497d-ab27-b415ec12ff5a/data/stats?offset=0&size=1&filter[1][condition][path]=state&filter[1][condition][operator]==&filter[1][condition][value]=GA&filter[2][condition][path]=provname&filter[2][condition][operator]=STARTS_WITH&filter[2][condition][value]=C&filter[3][condition][path]=provcity&filter[3][condition][operator]==&filter[3][condition][value]=Atlanta
assemble(
endpoint("qppe"),
query(
year = 2021:2023,
practice_state_or_us_territory = any_of("GA", "FL"),
practice_size = less_than(10, or_equal = TRUE)
)
)
#> https://data.cms.gov/data-api/v1/dataset/3545dc8e-7037-41ee-8a1d-9f3198fe4927/data/stats?offset=0&size=1&filter[1][condition][path]=practice+state+or+us+territory&filter[1][condition][operator]=IN&filter[1][condition][value][1]=GA&filter[1][condition][value][2]=FL&filter[2][condition][path]=practice+size&filter[2][condition][operator]=<=&filter[2][condition][value]=10
#> https://data.cms.gov/data-api/v1/dataset/b3438273-b4a6-44ca-8fb2-9e6026b74642/data/stats?offset=0&size=1&filter[1][condition][path]=practice+state+or+us+territory&filter[1][condition][operator]=IN&filter[1][condition][value][1]=GA&filter[1][condition][value][2]=FL&filter[2][condition][path]=practice+size&filter[2][condition][operator]=<=&filter[2][condition][value]=10
#> https://data.cms.gov/data-api/v1/dataset/8c2ab3e4-597e-43c9-9d94-7223c66d7f25/data/stats?offset=0&size=1&filter[1][condition][path]=practice+state+or+us+territory&filter[1][condition][operator]=IN&filter[1][condition][value][1]=GA&filter[1][condition][value][2]=FL&filter[2][condition][path]=practice+size&filter[2][condition][operator]=<=&filter[2][condition][value]=10
assemble(
endpoint("hc_quality"),
query(state = any_of("Georgia", "Alabama"),
year = 2020:2023))
#> https://data.medicaid.gov/api/1/datastore/query/e85033c7-367e-467e-9e81-8e85048102b8/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=Georgia&conditions[0][value][]=Alabama
#> https://data.medicaid.gov/api/1/datastore/query/dfd13757-d763-4f7a-9641-3f06ce21b4c6/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=Georgia&conditions[0][value][]=Alabama
#> https://data.medicaid.gov/api/1/datastore/query/a058ef78-e18b-4435-94aa-b70ab6ce5904/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=Georgia&conditions[0][value][]=Alabama
#> https://data.medicaid.gov/api/1/datastore/query/fbbe1734-b448-4e5a-bc94-3f8688534741/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=state&conditions[0][operator]=in&conditions[0][value][]=Georgia&conditions[0][value][]=Alabama
assemble(
endpoint("pdc_clinician"),
query(
provider_first_name = starts_with("An"),
provider_last_name = contains("JE"),
state = any_of("CA", "GA", "NY")))
#> [1] "https://data.cms.gov/provider-data/api/1/datastore/query/mj5m-pzi6/0?count=true&results=true&offset=0&limit=1&conditions[0][property]=provider_last_name&conditions[0][operator]=contains&conditions[0][value]=JE&conditions[1][property]=provider_first_name&conditions[1][operator]=starts+with&conditions[1][value]=An&conditions[2][property]=state&conditions[2][operator]=in&conditions[2][value][]=CA&conditions[2][value][]=GA&conditions[2][value][]=NY"