Bulk Data Feed - Healthcare: Provider Organization Firmographics
A BrightQuery dataset with 66 fields. View the BrightQuery profile.
Product details
| API type | BulkFeed |
|---|---|
| Match keys | bq_id, company_name, domain, ein, npi |
| Geo coverage | US |
| Refresh cadence | Monthly |
| Historical depth | Point-in-time + MR/TS/TSQ/TSM time-series |
| PII sensitivity | BizContactPII |
| Compliance | CMS/NPPES public provider data |
| Delivery | Bulk file (S3/Snowflake) |
| Lifecycle | GA |
| Pricing model | bulk_flat - Flat bulk licence (uncredited) |
| Last verified | 2026-07-18 |
Bulk Data Feed - Healthcare: Provider Organization Firmographics fields
| Field | API name | Category | Type | Fill rate | Description |
|---|---|---|---|---|---|
| Healthcare Provider Alternative Names | bq_healthcare_provider_organization_alternative_names | Healthcare & Specialty | String | 32% | An alternative name used by the healthcare provider organization; could be a DBA or a former legal business name. |
| Healthcare Provider Legal Business Name | bq_healthcare_provider_organization_legal_business_name | Healthcare & Specialty | String | 100% | Legal name of the healthcare provider organization. |
| Provider Taxonomy | bq_healthcare_provider_organization_primary_taxonomy_description | Healthcare & Specialty | Number (Decimal) | 99% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Provider Taxonomy | bq_healthcare_provider_organization_taxonomy_group_codes_all | Healthcare & Specialty | String | 100% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Address County | bq_healthcare_provider_organization_mailing_address_county_name | Location & Geography | Number (Integer) | 100% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address Line 1 | bq_healthcare_provider_organization_mailing_address_line_1 | Location & Geography | String | 100% | The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP. |
| Healthcare Provider Primary License Number | bq_healthcare_provider_organization_primary_license_number | Healthcare & Specialty | String | 99% | Primary license number associated with the healthcare provider. |
| NPI (Provider ID) | bq_healthcare_provider_organization_npi_certification_date | Healthcare & Specialty | Date | 34% | Unique 10-digit ID assigned to the healthcare provider (NPI). A healthcare provider can be an individual provider (e.g., physician, psychologist, etc.), referred to as Type 1, or an organizational provider (e.g.… |
| Payer Enrollment ID | bq_healthcare_provider_organization_medicaid_state_code | Healthcare & Specialty | String | 21% | Medicaid ID of the Healthcare Provider (Organization). This is an alternative identifier and is relevant to external datasets. |
| Provider Taxonomy | bq_healthcare_provider_organization_taxonomy_descriptions_all | Healthcare & Specialty | String | 100% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| NPI (Provider ID) | bq_healthcare_provider_organization_npis_related | Healthcare & Specialty | String | - | Unique 10-digit ID assigned to the healthcare provider (NPI). A healthcare provider can be an individual provider (e.g., physician, psychologist, etc.), referred to as Type 1, or an organizational provider (e.g.… |
| Address Zip (5-Digit) | bq_healthcare_provider_organization_mailing_address_zip_5 | Location & Geography | String | 100% | The standard 5-digit ZIP code of an address. |
| Company Phone | bq_healthcare_provider_organization_authorized_official_telephone_number | Contact Information | Phone (String) | 100% | Phone of the prior company. |
| Provider Taxonomy | bq_healthcare_provider_organization_taxonomy_group_descriptions_all | Healthcare & Specialty | String | 100% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Address Geo-Coordinates | bq_healthcare_provider_organization_mailing_address_longitude | Location & Geography | Number (Decimal) | 100% | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address County | bq_healthcare_provider_organization_mailing_address_county_fips | Location & Geography | Number (Integer) | 100% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Healthcare Provider Warning Flag | bq_healthcare_provider_organization_warning_flag | Healthcare & Specialty | String | 3% | Flag indicating the healthcare provider's record matches a listing in the federal excluded providers database (LEIE), suggesting they may be barred from billing Medicare. |
| Address Building Default Indicator (USPS) | bq_healthcare_provider_organization_mailing_address_building_default_indicator | Location & Geography | Boolean | 10% | Indicates whether an address is the "default" address for a building (e.g. the main lobby). |
| Provider Taxonomy | bq_healthcare_provider_organization_taxonomy_codes_all | Healthcare & Specialty | String | 100% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Healthcare Provider Emergency Service Availability Flag | bq_healthcare_provider_organization_emergency_service_availability | Healthcare & Specialty | String | 69% | Flag indicating whether the healthcare facility provides emergency services. |
| Address DPV Match Code (USPS) | bq_healthcare_provider_organization_mailing_address_dpv_match_code | Location & Geography | String | 99% | Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV). |
| Address Geo-Coordinates | bq_healthcare_provider_organization_mailing_address_latitude | Location & Geography | Number (Decimal) | 100% | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address Zip Type (USPS) | bq_healthcare_provider_organization_mailing_address_zip_type | Location & Geography | String | 100% | Zip code classification of an address indicating whether it is a P.O. Box or not. |
| Address State | bq_healthcare_provider_organization_mailing_address_state | Location & Geography | String | 100% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Congressional District | bq_healthcare_provider_organization_mailing_address_congressional_district | Location & Geography | String | 99% | The U.S. congressional district associated with an address, as determined by USPS-standardized address matching. |
| Address City | bq_healthcare_provider_organization_mailing_address_city | Location & Geography | String | 100% | City of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Healthcare Provider Deactivation Date | bq_healthcare_provider_organization_deactivation_date | Healthcare & Specialty | Date | 13% | Date the healthcare provider's NPI record was deactivated. |
| Address Line 2 | bq_healthcare_provider_organization_mailing_address_secondary_number | Location & Geography | String | 38% | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Address Zip+4 (9-Digit) | bq_healthcare_provider_organization_mailing_address_zip_9 | Location & Geography | String | 100% | The full 9-digit ZIP+4 postal code of an address. |
| Healthcare Provider Authorized Official Credential | bq_healthcare_provider_organization_authorized_official_credential_text | Healthcare & Specialty | String | 48% | Professional credentials of the person officially authorized to act on behalf of the healthcare provider organization (e.g., MBA, CPA). |
| Healthcare Provider Enumeration Date | bq_healthcare_provider_organization_enumeration_date | Financial | Date | 100% | Date the healthcare provider's information was listed on the NPI registry. |
| Address Line 2 | bq_healthcare_provider_organization_mailing_address_line_2 | Location & Geography | String | 2% | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Healthcare Provider Authorized Official First Name | bq_healthcare_provider_organization_authorized_official_first_name | Healthcare & Specialty | String | 100% | First name of the person officially authorized to act on behalf of the healthcare provider organization. |
| Address State | bq_healthcare_provider_organization_mailing_address_state_name | Location & Geography | String | 100% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Residential Delivery Indicator (RDI) | bq_healthcare_provider_organization_mailing_address_rdi | Location & Geography | String | 100% | Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting. |
| Healthcare Provider Exclusion Date | bq_healthcare_provider_organization_exclusion_date | Healthcare & Specialty | Date | 3% | Date the healthcare provider was excluded, as reported in the federal excluded providers database (LEIE). |
| Address Mailability Summary (USPS) | bq_healthcare_provider_organization_mailing_address_summary | Location & Geography | String | 100% | Classification indicating whether an address is Match-Mailable or Non-Mailable per USPS reporting. |
| Payer Enrollment ID | bq_healthcare_provider_organization_medicaid_id | Healthcare & Specialty | String | 21% | Medicaid ID of the Healthcare Provider (Organization). This is an alternative identifier and is relevant to external datasets. |
| Healthcare Provider Ownership Structure | bq_healthcare_provider_organization_ownership_structure | Healthcare & Specialty | String | 69% | Ownership structure of the healthcare facility (e.g., Government - Federal, Proprietary, Voluntary non-profit). |
| Healthcare Provider PECOS Enrollment Flag | bq_healthcare_provider_organization_pecos_enrollment_indicator | Healthcare & Specialty | Boolean | 100% | Flag indicating the healthcare provider is enrolled in PECOS (Provider Enrollment, Chain and Ownership System). |
| Healthcare Provider Primary License State Code | bq_healthcare_provider_organization_primary_license_state_code | Healthcare & Specialty | String | 99% | State code where the healthcare provider's primary license is registered. |
| Healthcare Provider Authorized Official Name Prefix | bq_healthcare_provider_organization_authorized_official_name_prefix_text | Healthcare & Specialty | String | 43% | Name prefix (e.g., Dr., Mr.) of the person officially authorized to act on behalf of the healthcare provider organization. |
| NPI (Provider ID) | bq_healthcare_provider_npi | Healthcare & Specialty | String | 100% | Unique 10-digit ID assigned to the healthcare provider (NPI). A healthcare provider can be an individual provider (e.g., physician, psychologist, etc.), referred to as Type 1, or an organizational provider (e.g.… |
| Healthcare Provider Location Fax Number | bq_healthcare_provider_organization_mailing_address_fax_number | Location & Geography | String | 56% | Fax number associated with the healthcare provider's physical practice and/or secondary location address. |
| Provider Taxonomy | bq_healthcare_provider_organization_primary_taxonomy_group_code | Healthcare & Specialty | Number (Decimal) | 99% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Healthcare Provider Reactivation Date | bq_healthcare_provider_organization_reactivation_date | Healthcare & Specialty | Date | 13% | Date the healthcare provider's NPI record was reactivated after being inactive. |
| Healthcare Provider Commonly Known As Name | bq_healthcare_provider_organization_commonly_known_as_name | Healthcare & Specialty | String | 27% | Name the healthcare provider organization may be commonly known as. |
| Healthcare Provider License State Codes (All) | bq_healthcare_provider_organization_license_state_codes_all | Healthcare & Specialty | String | 100% | State codes for each state where the healthcare provider's licenses are registered. |
| Healthcare Provider License Numbers (All) | bq_healthcare_provider_organization_license_numbers_all | Healthcare & Specialty | String | 100% | All known license numbers associated with the healthcare provider. |
| Healthcare Provider CCN | bq_healthcare_provider_organization_ccn | Healthcare & Specialty | String | 69% | CMS Certification Number (CCN) of the hospital associated with the healthcare provider. |
| Healthcare Provider Exclusion Type Code | bq_healthcare_provider_organization_exclusion_type_code | Healthcare & Specialty | String | 3% | Code specifying the reason for a healthcare provider's exclusion from billing Medicare and from the LEIE database. |
| Healthcare Provider Authorized Official Last Name | bq_healthcare_provider_organization_authorized_official_last_name | Healthcare & Specialty | String | 100% | Last name of the person officially authorized to act on behalf of the healthcare provider organization. |
| Healthcare Provider Last Update Date | bq_healthcare_provider_organization_last_update_date | Healthcare & Specialty | Date | 100% | Most recent date the healthcare provider's NPI record was changed or updated. |
| Healthcare Provider Authorized Official Name Suffix | bq_healthcare_provider_organization_authorized_official_name_suffix_text | Healthcare & Specialty | String | 2% | Name suffix (e.g., Jr., Esq.) of the person officially authorized to act on behalf of the healthcare provider organization. |
| Healthcare Provider Authorized Official Middle Name | bq_healthcare_provider_organization_authorized_official_middle_name | Healthcare & Specialty | String | 46% | Middle name of the person officially authorized to act on behalf of the healthcare provider organization. |
| Provider Taxonomy | bq_healthcare_provider_organization_primary_taxonomy_group_description | Healthcare & Specialty | Number (Decimal) | 99% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Address Country | bq_healthcare_provider_organization_mailing_address_country | Location & Geography | Number (Integer) | 100% | Two digit ISO country code of the Legal Entity's address. |
| CBSA Code | bq_healthcare_provider_organization_mailing_address_cbsa_code | Location & Geography | String | 100% | The Core-Based Statistical Area (CBSA) 5-digit numeric code which identifies the Metropolitan Statistical Area or Micropolitan Statistical Area in which an address lies, according to USPS. Entity-differentiated… |
| CBSA Type | bq_healthcare_provider_organization_mailing_address_cbsa_type | Location & Geography | String | 79% | Metro vs. Micro classification of the Core-Based Statistical Area (CBSA) in which an address lies, according to USPS. Entity-differentiated (Company, Legal Entity, Contact, Executive, Officer, Location, Franchise… |
| Healthcare Provider Authorized Official Title | bq_healthcare_provider_organization_authorized_official_title | Healthcare & Specialty | String | 100% | Job title or position of the person officially authorized to act on behalf of the healthcare provider organization (e.g., CEO, President). |
| Healthcare Provider Subpart Flag | bq_healthcare_provider_organization_subpart_indicator | Healthcare & Specialty | Boolean | 100% | Flag indicating the healthcare provider organization's NPI belongs to a specific part or unit of a larger parent organization. |
| Provider Taxonomy | bq_healthcare_provider_organization_primary_taxonomy_code | Healthcare & Specialty | Number (Decimal) | 99% | All known Taxonomy Group Codes associated with the Healthcare Provider (Organization). There are two special taxonomy codes used to identify practice groups: 193200000X identifies multi-specialty groups (groups having… |
| Address Active Indicator (USPS) | bq_healthcare_provider_organization_mailing_address_active_indicator | Location & Geography | Boolean | 100% | Indicates whether an address is currently active per USPS address verification. |
| Healthcare Provider Group Practice Flag | bq_healthcare_provider_organization_group_practice_indicator | Healthcare & Specialty | Boolean | 50% | Flag indicating the healthcare provider is reported as part of a group practice (multi- or single-specialty). |
| CBSA Name | bq_healthcare_provider_organization_mailing_address_cbsa_name | Location & Geography | String | 79% | Name of the Core-Based Statistical Area (CBSA) — the Metropolitan or Micropolitan Statistical Area — in which an address lies, according to USPS. Entity-differentiated (Company, Legal Entity, Contact, Executive… |
| Company Phone | bq_healthcare_provider_organization_mailing_address_telephone_number | Contact Information | Phone (String) | 89% | Phone of the prior company. |
More from BrightQuery
- Bulk Data Feed - Organization Executives
- Bulk Data Feed - Organization Contacts
- Bulk Data Feed - Franchise: Franchisor Affiliates
- Bulk Data Feed - Stock Filings: Legal Entity
- Bulk Data Feed - Healthcare: Provider Individuals
- Bulk Data Feed - Dept. of Transportation
- Bulk Data Feed - Organization All Names
- Bulk Data Feed - Firmographics
- Bulk Data Feed - Legal Entity Officers & Directors
- Bulk Data Feed - Financials & Employment (Most Recent)
- Bulk Data Feed - Franchise: Franchisee / Controlled Entity
- Bulk Data Feed - Family Tree / Legal Entity
- Bulk Data Feed - Address Universe: Building Unit Address
- Bulk Data Feed - Establishments
- Bulk Data Feed - Organization Locations
- Bulk Data Feed - Stock Filings: Transaction Filing Types
- Bulk Data Feed - Stock Filings: Class Series (Time Series)
- Bulk Data Feed - Stock Filings: Corporate Status & Fees
- Bulk Data Feed - Stock Filings: Stock Events
- Bulk Data Feed - Employment (Monthly Time Series)
- Bulk Data Feed - Stock Filings: Classes of Stock Issued
- Bulk Data Feed - Stock Filings: Stock Group (Time Series)
- Bulk Data Feed - Franchise: Franchisor / Controlling Entity
- Bulk Data Feed - Franchise: Brand & Franchisor Parent
- Bulk Data Feed - Healthcare: Provider Location
- Bulk Data Feed - Healthcare: Individual Details
- Bulk Data Feed - SBA 7(a) & 504 Loans
- Bulk Data Feed - Franchise: Brands
- Bulk Data Feed - Address Universe: Building Address
- Bulk Data Feed - Organization Mapping
- Bulk Data Feed - Stock Filings: Event Timeline
- Bulk Data Feed - Franchise: Affiliates Mapping
- Bulk Data Feed - Address Universe: Unit-Organization Mapping
- Bulk Data Feed - Address Universe: Unit-Location Mapping
- Bulk Data Feed - Healthcare: Group-Individual Mapping
- Bulk Data Feed - Address Universe: Unit-Legal Entity Mapping
- Bulk Data Feed - Healthcare: Group Practice
- Bulk Data Feed - Healthcare: Org-Individual Mapping
Bulk Data Feed - Healthcare: Provider Organization Firmographics FAQ
What fields are in Bulk Data Feed - Healthcare: Provider Organization Firmographics?
Bulk Data Feed - Healthcare: Provider Organization Firmographics from BrightQuery has 66 fields across healthcare & specialty, location & geography, contact information and financial, including Healthcare Provider Legal Business Name, Provider Taxonomy and Address County. Average fill rate: 76%.
What do I need to match against Bulk Data Feed - Healthcare: Provider Organization Firmographics?
Bulk Data Feed - Healthcare: Provider Organization Firmographics matches on bq_id, company_name, domain, ein and npi.
How is Bulk Data Feed - Healthcare: Provider Organization Firmographics priced?
bulk_flat - Flat bulk licence (uncredited). Request a quote or a sample on SpringDB.