About this Dataset

Dental Utilization By Provider

This dataset provides beneficiary and service counts for annual dental visits, dental preventive services, dental treatment, and dental exams by rendering providers (by NPI) for calendar year (CY) 2020. It includes Fee-For-Service (FFS), Geographic Managed Care (GMC), and Pre-Paid Health (PHP) Plans delivery systems. Rendering providers are categorized as either rendering or rendering at a safety net clinic. Beneficiaries are grouped by Age 0-20 and Age 21+.
Organization: State of California
Last updated: 2024-11-27T01:05:46.298997
Tags: california-department-of-health-care-services, dental, dental-providers, dhcs, per-provider

Tables

Dental Utilization By Provider CY2019

@usgov.ca_gov_dental_utilization_by_provider_33d9f.dental_utilization_by_provider_cy2019

703.14 kB
25,038 rows
22 columns

CREATE TABLE dental_utilization_by_provider_cy2019 (
  "rendering_npi" BIGINT,
  "provider_legal_name" VARCHAR,
  "calendar_year" BIGINT,
  "delivery_system" VARCHAR,
  "provider_type" VARCHAR,
  "age_group" VARCHAR,
  "adv_user_cnt" DOUBLE,
  "adv_user_annotation_code" DOUBLE,
  "adv_svc_cnt" DOUBLE,
  "adv_svc_annotation_code" DOUBLE,
  "prev_user_cnt" DOUBLE,
  "prev_user_annotation_code" DOUBLE,
  "prev_svc_cnt" DOUBLE,
  "prev_svc_annotation_code" DOUBLE,
  "txmt_user_cnt" DOUBLE,
  "txmt_user_annotation_code" DOUBLE,
  "txmt_svc_cnt" DOUBLE,
  "txmt_svc_annotation_code" DOUBLE,
  "exam_user_cnt" DOUBLE,
  "exam_user_annotation_code" DOUBLE,
  "exam_svc_cnt" DOUBLE,
  "exam_svc_annotation_code" DOUBLE
);

Dental Utilization By Provider CY2020

@usgov.ca_gov_dental_utilization_by_provider_33d9f.dental_utilization_by_provider_cy2020

692.91 kB
25,164 rows
22 columns

CREATE TABLE dental_utilization_by_provider_cy2020 (
  "rendering_npi" BIGINT,
  "provider_legal_name" VARCHAR,
  "calendar_year" BIGINT,
  "delivery_system" VARCHAR,
  "provider_type" VARCHAR,
  "age_group" VARCHAR,
  "adv_user_cnt" DOUBLE,
  "adv_user_annotation_code" DOUBLE,
  "adv_svc_cnt" DOUBLE,
  "adv_svc_annotation_code" DOUBLE,
  "prev_user_cnt" DOUBLE,
  "prev_user_annotation_code" DOUBLE,
  "prev_svc_cnt" DOUBLE,
  "prev_svc_annotation_code" DOUBLE,
  "txmt_user_cnt" DOUBLE,
  "txmt_user_annotation_code" DOUBLE,
  "txmt_svc_cnt" DOUBLE,
  "txmt_svc_annotation_code" DOUBLE,
  "exam_user_cnt" DOUBLE,
  "exam_user_annotation_code" DOUBLE,
  "exam_svc_cnt" DOUBLE,
  "exam_svc_annotation_code" DOUBLE
);

Dental Utilization By Provider CY2021

@usgov.ca_gov_dental_utilization_by_provider_33d9f.dental_utilization_by_provider_cy2021

715 kB
25,522 rows
22 columns

CREATE TABLE dental_utilization_by_provider_cy2021 (
  "rendering_npi" BIGINT,
  "provider_legal_name" VARCHAR,
  "calendar_year" BIGINT,
  "delivery_system" VARCHAR,
  "provider_type" VARCHAR,
  "age_group" VARCHAR,
  "adv_user_cnt" DOUBLE,
  "adv_user_annotation_code" DOUBLE,
  "adv_svc_cnt" DOUBLE,
  "adv_svc_annotation_code" DOUBLE,
  "prev_user_cnt" DOUBLE,
  "prev_user_annotation_code" DOUBLE,
  "prev_svc_cnt" DOUBLE,
  "prev_svc_annotation_code" DOUBLE,
  "txmt_user_cnt" DOUBLE,
  "txmt_user_annotation_code" DOUBLE,
  "txmt_svc_cnt" DOUBLE,
  "txmt_svc_annotation_code" DOUBLE,
  "exam_user_cnt" DOUBLE,
  "exam_user_annotation_code" DOUBLE,
  "exam_svc_cnt" DOUBLE,
  "exam_svc_annotation_code" DOUBLE
);

Dental Utilization By Provider CY2022

@usgov.ca_gov_dental_utilization_by_provider_33d9f.dental_utilization_by_provider_cy2022

709.06 kB
25,078 rows
22 columns

CREATE TABLE dental_utilization_by_provider_cy2022 (
  "rendering_npi" BIGINT,
  "provider_legal_name" VARCHAR,
  "calendar_year" BIGINT,
  "delivery_system" VARCHAR,
  "provider_type" VARCHAR,
  "age_group" VARCHAR,
  "adv_user_cnt" DOUBLE,
  "adv_user_annotation_code" DOUBLE,
  "adv_svc_cnt" DOUBLE,
  "adv_svc_annotation_code" DOUBLE,
  "prev_user_cnt" DOUBLE,
  "prev_user_annotation_code" DOUBLE,
  "prev_svc_cnt" DOUBLE,
  "prev_svc_annotation_code" DOUBLE,
  "txmt_user_cnt" DOUBLE,
  "txmt_user_annotation_code" DOUBLE,
  "txmt_svc_cnt" DOUBLE,
  "txmt_svc_annotation_code" DOUBLE,
  "exam_user_cnt" DOUBLE,
  "exam_user_annotation_code" DOUBLE,
  "exam_svc_cnt" DOUBLE,
  "exam_svc_annotation_code" DOUBLE
);

Dental Utilization By Provider CY2023

@usgov.ca_gov_dental_utilization_by_provider_33d9f.dental_utilization_by_provider_cy2023

737.77 kB
25,955 rows
22 columns

CREATE TABLE dental_utilization_by_provider_cy2023 (
  "rendering_npi" BIGINT,
  "provider_legal_name" VARCHAR,
  "calendar_year" BIGINT,
  "delivery_system" VARCHAR,
  "provider_type" VARCHAR,
  "age_group" VARCHAR,
  "adv_user_cnt" DOUBLE,
  "adv_user_annotation_code" DOUBLE,
  "adv_svc_cnt" DOUBLE,
  "adv_svc_annotation_code" DOUBLE,
  "prev_user_cnt" DOUBLE,
  "prev_user_annotation_code" DOUBLE,
  "prev_svc_cnt" DOUBLE,
  "prev_svc_annotation_code" DOUBLE,
  "txmt_user_cnt" DOUBLE,
  "txmt_user_annotation_code" DOUBLE,
  "txmt_svc_cnt" DOUBLE,
  "txmt_svc_annotation_code" DOUBLE,
  "exam_user_cnt" DOUBLE,
  "exam_user_annotation_code" DOUBLE,
  "exam_svc_cnt" DOUBLE,
  "exam_svc_annotation_code" DOUBLE
);