Table: family_pact_providers_profile_cy_2019
, provider_business_legal_name like Z*
| provider_number |
npi_provider_number |
owner_number |
service_location_number |
provider_business_legal_name |
enrollment_status_effective_date |
provider_type_code |
provider_type_code_desc |
provider_license_number |
provider_specialty_code |
provider_specialty_code_desc |
out_of_state_ind |
out_of_state_ind_desc |
provider_address_county_code |
provider_address_county_code_description |
attention_line |
provider_address_line1 |
provider_address_line2 |
provider_address_city |
provider_address_state |
provider_address_zip |
provider_address_latitude |
provider_address_longitude |
mssa_id |
tract_id |
| 1750442836 |
1750442836 |
1 |
2 |
ZACOALCO MEDICAL GROUP |
13-Jul-98 |
Physicians Group (022) |
PHYSICIANS GROUP |
FNP024838 |
1 |
General Practice |
0 |
In state provider |
19 |
Los Angeles |
None |
1414 E FLORENCE AVE |
None |
LOS ANGELES |
CA |
90001 |
33.974773 |
-118.249384 |
78.2mmm |
5329 |