Home

Dataset:

Name profile-of-enrolled-medi-cal-fee-for-service-ffs-providers
Updated 2025-06-30
Current False
Tables
enrolled_medi_cal_fee_for_service_ffs_providers    objectid - varchar(11)
provider_source - varchar(34)
provider_number - varchar(15)
npi - varchar(10)
owner_number - varchar(12)
service_location_number - varchar(23)
legal_name - varchar(50)
enroll_status_eff_dt - varchar(20)
provider_taxonomy - varchar(23)
nemt_nmt_provider_type - varchar(24)
anc_provider_type - varchar(36)
fi_provider_type_cd - varchar(19)
fi_provider_type - varchar(85)
provider_license - varchar(16)
fi_provider_specialty_cd - varchar(24)
fi_provider_specialty - varchar(51)
out_of_state_indicator - varchar(22)
in_out_state - varchar(56)
address_attention - varchar(43)
address - varchar(24)
address2 - varchar(24)
city - varchar(17)
state - varchar(5)
zip - varchar(5)
zip_4 - varchar(5)
dhcs_county_cd - varchar(14)
fips_county_cd - varchar(14)
county - varchar(15)
latitude - decimal(12,8)
longitude - decimal(12,8)
countyname - varchar(46)
fi_provider_specialty_code_reference    provider_spec_cd - varchar(16)
provider_spec_desc - varchar(77)
fi_provider_type_code_reference    provider_type_cd - varchar(16)
provider_type_desc - varchar(85)
Sources medi-cal-provider-application.html --> None
enrolled-medi-cal-fee-for-service-ffs-providers.csv --> enrolled_medi_cal_fee_for_service_ffs_providers
fi-provider-specialty-code-reference.csv --> fi_provider_specialty_code_reference
fi-provider-type-code-reference.csv --> fi_provider_type_code_reference
Updates
2025-06-25 12:58:56      0
2025-06-06 12:17:29      0
2025-04-11 11:36:17      1
2025-03-28 19:29:25      0
2025-03-21 14:14:01      0
2025-03-15 10:15:39      0
2025-03-10 09:59:42      1
2025-02-22 13:36:29      1
2025-02-16 17:02:15      0
2025-02-06 15:55:59      0
2025-02-06 14:51:25      0
2025-02-04 17:44:20      0
2025-02-02 18:55:13      0
2025-01-31 10:03:08      0
2025-01-03 14:48:48      0
2024-12-29 00:08:59      0
2024-12-27 20:55:37      0
2024-12-27 20:52:57      1
2024-11-18 11:13:31      None
2024-11-16 14:52:09      None
2024-09-18 13:19:12      None
2024-09-09 16:01:28      None
2024-09-09 13:48:58      None
2024-09-08 21:07:15      None
2024-09-03 11:41:36      None
2024-09-03 10:36:06      None
2024-08-15 14:01:22      None
2024-08-15 14:00:43      None
2024-08-15 14:00:25      None
2024-08-15 13:52:12      None
2024-08-15 13:50:34      None
2024-08-15 13:49:34      None