montgomerycountymd-gov/mcg-group-health-plan-rates-s4r5-7vv4
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 3 hours ago

MCG Group Health Plan Rates

Montgomery County offers medical, prescription, vision and dental plans for our employees, their families and their partners. Employees can choose between two Point-of-Service (POS) plans with CareFirst Blue Cross and Blue Shield (BCBS) and two Health Maintenance Organizations (HMO’s) with United HealthCare and Kaiser; two prescription plans with Caremark; National Vision Administrators (NVA) plan and two PPO and DHMO dental plans with United Concordia. The dataset contains all available plan rates, provider websites and contact numbers. In addition, this information is also available on the Office of Human Resources (OHR) website at https://www.montgomerycountymd.gov/HR/Benefits/EmployeeMedical.html#1

Update Frequency : Annually

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 \"montgomerycountymd-gov/mcg-group-health-plan-rates-s4r5-7vv4\".\"mcg_group_health_plan_rates\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • mcg_group_health_plan_rates
     
     
     
     
     
Upstream Metadata