About this Dataset

Office-based Health Care Providers Database

ONC uses the SK&A Office-based Provider Database to calculate the counts of medical doctors, doctors of osteopathy, nurse practitioners, and physician assistants at the state and count level from 2011 through 2013. These counts are grouped as a total, as well as segmented by each provider type and separately as counts of primary care providers.
Organization: U.S. Department of Health & Human Services
Last updated: 2022-01-25T02:03:24.056000
Tags: health-information-technology, health-it, non-primary-physicians, nurse-practitioners, office-based-physicians, physician-assistants, primary-care-physicians, providers

Tables

SKA State County Data 2011-2013

@usgov.hhs_gov_office_based_health_care_providers_database.ska_state_county_data_2011_2013

158.14 kB
9,568 rows
14 columns

CREATE TABLE ska_state_county_data_2011_2013 (
  "region" VARCHAR,
  "region_code" VARCHAR,
  "period" BIGINT,
  "state_fips" BIGINT,
  "county_fips" DOUBLE,
  "fips" DOUBLE,
  "all_providers" BIGINT,
  "all_primary_care_providers" BIGINT,
  "all_physicians" BIGINT,
  "all_primary_care_physicians" BIGINT,
  "all_nurse_practitioners" BIGINT,
  "all_primary_care_nurse_practitioners" BIGINT,
  "all_physician_assistants" BIGINT,
  "all_primary_care_physician_assistants" BIGINT
);