|
8008
|
accepting_new_patients
|
|
10002
|
additional_phone
|
|
AddressOriginationDate
|
address_changed_on
|
|
8026
|
address_type_code
|
|
AddressDetailType
|
address_type_code
|
|
AddressType
|
address_type_code
|
|
FranchiseCodesNum
|
affiliation_ids
|
|
10007
|
alternative_name
|
|
8004
|
ami_board_certified_flag
|
|
8045
|
ami_board_certified_flag
|
|
8049
|
ami_board_certified_flag
|
|
8005
|
ami_hospital_number
|
|
10085
|
ami_license_number
|
|
8000
|
ami_medical_school_code
|
|
8047
|
ami_medical_school_code
|
|
8014
|
ami_national_provider_flag
|
|
8006
|
ami_physician_primary_specialty_code
|
|
8007
|
ami_physician_secondary_specialty_code
|
|
8002
|
ami_residency_hospital_code
|
|
8046
|
ami_residency_hospital_code
|
|
SegmentIDpos3-4inallAMILICattributes
|
ami_state_of_license
|
|
10448
|
ancestor_headquarters_ids
|
|
9371
|
ancestor_headquarters_ids
|
|
ParentNumber
|
ancestor_headquarters_ids
|
|
Bankruptcy Dismissal Flag
|
bankruptcy.dismissal
|
|
FilingDate
|
bankruptcy.filing_date
|
|
Filing Type
|
bankruptcy.filing_type
|
|
PublicFilingIndicator
|
bankruptcy.id
|
|
Association Code
|
bankruptcy.multiple_defendants
|
|
ReleaseDate
|
bankruptcy.release_date
|
|
10454
|
bbb_accredited
|
|
10452
|
bbb_business_review_url
|
|
AckID
|
benefit_plans.ack_id
|
|
10418
|
branch_count
|
|
10419
|
branch_count
|
|
10449
|
branch_count
|
|
FranchiseCodesNum
|
brand_ids
|
|
BuildingNumber
|
building_number
|
|
6018
|
bulk_updated_at
|
|
FranchiseCodesNum
|
business_type_ids
|
|
FranchiseCodesNum
|
car_make_ids
|
|
CarrierRoute
|
carrier_route_code
|
|
CbsaCode
|
cbsa_code
|
|
CbsaLevel
|
cbsa_level
|
|
CensusBlockGroup
|
census_block
|
|
CensusTract
|
census_tract
|
|
FranchiseCodesNum
|
chain_id
|
|
ShortCity
|
city
|
|
StandardCity
|
city
|
|
CMRAIndicator
|
cmra_flag
|
|
LocationAddressCMRA
|
cmra_flag
|
|
10147
|
company_description
|
|
ExecutiveDetailFlag
|
contacts_count
|
|
EmailFlag
|
contacts.email
|
|
InternetAddress
|
contacts.email
|
|
8022
|
contacts.first_name
|
|
8023
|
contacts.first_name
|
|
FirstName
|
contacts.first_name
|
|
ExecGender
|
contacts.gender
|
|
FemaleExecOwner
|
contacts.gender
|
|
GenderCode
|
contacts.gender
|
|
FunctionalAreaCode
|
contacts.job_function_id
|
|
LiteralTitleID
|
contacts.job_titles
|
|
8022
|
contacts.last_name
|
|
8023
|
contacts.last_name
|
|
LastName
|
contacts.last_name
|
|
RoleCode
|
contacts.management_level
|
|
ContactID
|
contacts.mapped_contact_id
|
|
ExecutiveID
|
contacts.mapped_contact_id
|
|
ProfessionalTitle
|
contacts.professional_title
|
|
EmailSuppressionIndicator
|
contacts.suppressed_fields
|
|
FemaleExecOwner
|
contacts.title_codes
|
|
HighIncomeExecutive
|
contacts.title_codes
|
|
TitleCode
|
contacts.title_codes
|
|
10204
|
corporate_employee_count
|
|
6027
|
corporate_employee_count
|
|
6028
|
corporate_employee_count
|
|
CorpEmployeeCode
|
corporate_employee_count
|
|
TrueFranchiseFlagY
|
corporate_franchising
|
|
10205
|
corporate_sales_revenue
|
|
6029
|
corporate_sales_revenue
|
|
6030
|
corporate_sales_revenue
|
|
CorpSalesVolumeCode
|
corporate_sales_revenue
|
|
CanadaInd
|
country_code
|
|
CountryCode
|
country_code
|
|
CountyCode
|
county_code
|
|
PostalCountyCode
|
county_code
|
|
DateInDatabaseyyyymm
|
created_at
|
|
NewToDatabaseDate
|
created_at
|
|
Year1stAppearedyyyy
|
created_at
|
|
YearCode
|
created_at
|
|
AbiCreditRatingCode
|
credit.grade
|
|
CreditGrade
|
credit.grade
|
|
CreditLimit
|
credit.limit
|
|
CreditLimitLJ
|
credit.limit
|
|
CreditScore
|
credit.score
|
|
10238
|
cross_street_address
|
|
CsaCode
|
csa_code
|
|
DelPtBarCode
|
delivery_point_bar_code
|
|
10036
|
dress_code
|
|
Current_ABI_Number
|
duplicate_of
|
|
6110
|
eins
|
|
10041
|
equipment_rentals
|
|
FleetSizeModel
|
estimated_fleet_size
|
|
ModeledEmployeeSizeFlag
|
estimated_location_employee_count
|
|
YearEstablishedyyyy
|
estimated_opened_for_business
|
|
LocAccExpenses
|
expenses.accounting
|
|
LocAdvExpenses
|
expenses.advertising
|
|
CHRExpenses
|
expenses.charities
|
|
LocCLCExpenses
|
expenses.contract_labor
|
|
ExpenseLevelCode
|
expenses.corporate
|
|
LocINSExpenses
|
expenses.insurance
|
|
LocLEGExpenses
|
expenses.legal
|
|
LICExpenses
|
expenses.licenses
|
|
MNTExpenses
|
expenses.maintenance
|
|
LocOFCExpenses
|
expenses.office_equipment_supplies
|
|
LocPACExpenses
|
expenses.packaging_shipping
|
|
LocPAYExpenses
|
expenses.payroll
|
|
LocPRNExpenses
|
expenses.printing
|
|
LocProExpenses
|
expenses.professional_services
|
|
LocRNTExpenses
|
expenses.rent_lease
|
|
LocCMPExpenses
|
expenses.technology
|
|
LocCOMExpenses
|
expenses.telecommunications
|
|
LocTRNExpenses
|
expenses.transportation
|
|
LocUTLExpenses
|
expenses.utilities
|
|
6017
|
express_updated_at
|
|
InternetAddress
|
facebook_url
|
|
URLTypeCode
|
facebook_url
|
|
6014
|
fax_number
|
|
faxphonenumber
|
fax_number
|
|
10556
|
federal_government_contractor
|
|
CensusCountyCode
|
fips_code
|
|
CensusStateCode
|
fips_code
|
|
CountyCode
|
fips_code
|
|
PostalCountyCode
|
fips_code
|
|
10209
|
fiscal_year_end_month
|
|
ForeignParentFlagY
|
foreign_parent_flag
|
|
9255
|
fortune_ranking
|
|
InternetAddress
|
foursquare_url
|
|
URLTypeCode
|
foursquare_url
|
|
VendorMatchLevel
|
geo_match_level
|
|
10058
|
greenscore
|
|
GreenBusinessScore
|
greenscore
|
|
7064
|
growing_business_code
|
|
7066
|
growing_business_code
|
|
GrowingBusinessFlag
|
growing_business_code
|
|
10017
|
happy_hours.days
|
|
10122
|
happy_hours.days
|
|
10017
|
happy_hours.description
|
|
10122
|
happy_hours.description
|
|
10017
|
happy_hours.end_time
|
|
10122
|
happy_hours.end_time
|
|
10017
|
happy_hours.special_activity
|
|
10122
|
happy_hours.special_activity
|
|
10017
|
happy_hours.special_drink
|
|
10122
|
happy_hours.special_drink
|
|
10017
|
happy_hours.special_food
|
|
10122
|
happy_hours.special_food
|
|
10017
|
happy_hours.special_other
|
|
10122
|
happy_hours.special_other
|
|
10017
|
happy_hours.start_time
|
|
10122
|
happy_hours.start_time
|
|
10438
|
has_ecommerce
|
|
10448
|
headquarters_id
|
|
9371
|
headquarters_id
|
|
ParentNumber
|
headquarters_id
|
|
SubsidiaryNumber
|
headquarters_id
|
|
6107(AKA)
|
historical_names
|
|
6108(DBA)
|
historical_names
|
|
6109(FKA)
|
historical_names
|
|
6112(blankorother).
|
historical_names
|
|
10060
|
hotel.cable_tv
|
|
10062
|
hotel.continental_breakfast
|
|
10063
|
hotel.elevator
|
|
10064
|
hotel.exercise_facility
|
|
10065
|
hotel.guest_laundry
|
|
10066
|
hotel.hot_tub
|
|
10067
|
hotel.indoor_pool
|
|
10068
|
hotel.kitchens
|
|
10069
|
hotel.outdoor_pool
|
|
10070
|
hotel.pet_friendly
|
|
10071
|
hotel.room_service
|
|
FulfillmentType
|
in_business
|
|
RecordGrade
|
in_business
|
|
AbiNumber
|
infogroup_id
|
|
Record ID
|
infogroup_id
|
|
InternetAddress
|
instagram_url
|
|
URLTypeCode
|
instagram_url
|
|
8009
|
insurances_accepted
|
|
ShortAddress
|
landmark_address
|
|
10083
|
languages_spoken
|
|
6025
|
languages_spoken
|
|
VendorLatitude
|
latitude
|
|
10569
|
legal_names
|
|
InternetAddress
|
linked_in_url
|
|
URLTypeCode
|
linked_in_url
|
|
EmailFlag
|
location_email_address
|
|
BigBusinessSegmentCode
|
location_employee_count
|
|
EmployeeSizeCode
|
location_employee_count
|
|
HighIncomeExecutive
|
location_employee_count
|
|
LocempHistory1
|
location_employee_count
|
|
LocempHistory2
|
location_employee_count
|
|
NumberOfEmpsLocation
|
location_employee_count
|
|
SmallMedBusinessOwner
|
location_employee_count
|
|
10555
|
location_parent_id
|
|
8019
|
location_parent_id
|
|
SiteNumber
|
location_parent_id
|
|
SiteNumberRaw
|
location_parent_id
|
|
10554
|
location_parent_relationship
|
|
OfficeSizeCode
|
location_professional_size_code
|
|
BankAssetCode
|
location_sales_volume
|
|
LocationOutputVolume
|
location_sales_volume
|
|
LocationOutputVolumeCode
|
location_sales_volume
|
|
InternetAddress
|
logo_url
|
|
URLTypeCode
|
logo_url
|
|
VendorLongitude
|
longitude
|
|
PrimaryAddress
|
mailing_address
|
|
ShortAddress
|
mailing_address
|
|
StandardAddress
|
mailing_address
|
|
CarrierRoute
|
mailing_address_carrier_route_code
|
|
ShortCity
|
mailing_address_city
|
|
StandardCity
|
mailing_address_city
|
|
CMRAIndicator
|
mailing_address_cmra_flag
|
|
MailingAddressCMRA
|
mailing_address_cmra_flag
|
|
DelPtBarCode
|
mailing_address_delivery_point_bar_code
|
|
MinimalPostalCode
|
mailing_address_postal_code
|
|
MailScore
|
mailing_address_score_code
|
|
State
|
mailing_address_state
|
|
AddressDetailType
|
mailing_address_type_code
|
|
AddressType
|
mailing_address_type_code
|
|
ZipCode
|
mailing_address_zip
|
|
Zip4
|
mailing_address_zip_four
|
|
MailScore
|
mailing_score_code
|
|
8011
|
medicaid_accepted
|
|
DEAFlag
|
medical_dea_number
|
|
8010
|
medicare_accepted
|
|
Naics2Code
|
naics_code_ids
|
|
Naics4Code
|
naics_code_ids
|
|
Naics6Code
|
naics_code_ids
|
|
NaicsCode
|
naics_code_ids
|
|
10176
|
name
|
|
10451
|
name
|
|
CompanyName
|
name
|
|
Infogroup Company Name
|
name
|
|
LocationName
|
name
|
|
10199
|
nbrc_corporate_date
|
|
10197
|
nbrc_corporation_filing_type
|
|
MultiTenantCount
|
number_of_tenants
|
|
MultiTenantRange
|
number_of_tenants
|
|
10392
|
opened_for_business_on
|
|
10450
|
opened_for_business_on
|
|
NBRCNewAddDate
|
opened_for_business_on
|
|
10169
|
operating_hours.days
|
|
FridayClose
|
operating_hours.days
|
|
FridayOpen
|
operating_hours.days
|
|
MondayClose
|
operating_hours.days
|
|
MondayOpen
|
operating_hours.days
|
|
SaturdayClose
|
operating_hours.days
|
|
SaturdayOpen
|
operating_hours.days
|
|
SundayClose
|
operating_hours.days
|
|
SundayOpen
|
operating_hours.days
|
|
ThursdayClose
|
operating_hours.days
|
|
ThursdayOpen
|
operating_hours.days
|
|
TuesdayClose
|
operating_hours.days
|
|
TuesdayOpen
|
operating_hours.days
|
|
WednesdayClose
|
operating_hours.days
|
|
WednesdayOpen
|
operating_hours.days
|
|
10169
|
operating_hours_description
|
|
FridayClose
|
operating_hours_description
|
|
FridayOpen
|
operating_hours_description
|
|
MondayClose
|
operating_hours_description
|
|
MondayOpen
|
operating_hours_description
|
|
SaturdayClose
|
operating_hours_description
|
|
SaturdayOpen
|
operating_hours_description
|
|
SundayClose
|
operating_hours_description
|
|
SundayOpen
|
operating_hours_description
|
|
ThursdayClose
|
operating_hours_description
|
|
ThursdayOpen
|
operating_hours_description
|
|
TuesdayClose
|
operating_hours_description
|
|
TuesdayOpen
|
operating_hours_description
|
|
WednesdayClose
|
operating_hours_description
|
|
WednesdayOpen
|
operating_hours_description
|
|
10169
|
operating_hours.end_time
|
|
FridayClose
|
operating_hours.end_time
|
|
FridayOpen
|
operating_hours.end_time
|
|
MondayClose
|
operating_hours.end_time
|
|
MondayOpen
|
operating_hours.end_time
|
|
SaturdayClose
|
operating_hours.end_time
|
|
SaturdayOpen
|
operating_hours.end_time
|
|
SundayClose
|
operating_hours.end_time
|
|
SundayOpen
|
operating_hours.end_time
|
|
ThursdayClose
|
operating_hours.end_time
|
|
ThursdayOpen
|
operating_hours.end_time
|
|
TuesdayClose
|
operating_hours.end_time
|
|
TuesdayOpen
|
operating_hours.end_time
|
|
WednesdayClose
|
operating_hours.end_time
|
|
WednesdayOpen
|
operating_hours.end_time
|
|
BaseFiller4_Pos1
|
operating_hours.id
|
|
10169
|
operating_hours.start_time
|
|
FridayClose
|
operating_hours.start_time
|
|
FridayOpen
|
operating_hours.start_time
|
|
MondayClose
|
operating_hours.start_time
|
|
MondayOpen
|
operating_hours.start_time
|
|
SaturdayClose
|
operating_hours.start_time
|
|
SaturdayOpen
|
operating_hours.start_time
|
|
SundayClose
|
operating_hours.start_time
|
|
SundayOpen
|
operating_hours.start_time
|
|
ThursdayClose
|
operating_hours.start_time
|
|
ThursdayOpen
|
operating_hours.start_time
|
|
TuesdayClose
|
operating_hours.start_time
|
|
TuesdayOpen
|
operating_hours.start_time
|
|
WednesdayClose
|
operating_hours.start_time
|
|
WednesdayOpen
|
operating_hours.start_time
|
|
ChangedToOutOfBusinessDate(nolongeranoverlayoffirst8ofBaseFiller6)
|
out_of_business_on
|
|
10243
|
parking.electric_charging_port_count
|
|
10105
|
parking.onsite
|
|
10522
|
parking.onsite
|
|
10104
|
parking.permit_required
|
|
10025
|
parking.valet
|
|
10029
|
parking.valet
|
|
10056
|
parking.valet
|
|
10072
|
parking.valet
|
|
10124
|
parking.valet
|
|
10022
|
payment_types
|
|
10026
|
payment_types
|
|
10045
|
payment_types
|
|
10057
|
payment_types
|
|
10079
|
payment_types
|
|
10106
|
payment_types
|
|
10132
|
payment_types
|
|
10302
|
payment_types
|
|
10482
|
payment_types
|
|
AcceptsCreditCards
|
payment_types
|
|
BaseFiller4_Pos2
|
payment_types
|
|
CreditCardsAccepted
|
payment_types
|
|
PrimaryPhoneNumber
|
phone
|
|
CallStatusCode
|
phone_call_status_code
|
|
10338
|
physician_year_of_birth
|
|
8001
|
physician_year_of_graduation
|
|
InternetAddress
|
pinterest_url
|
|
URLTypeCode
|
pinterest_url
|
|
BusinessStatusCode
|
place_type
|
|
BusStatusCodeHistory1
|
place_type
|
|
BusStatusCodeHistory2
|
place_type
|
|
IdentificationCode
|
place_type
|
|
BaseFiller4_Pos3
|
population_code_for_zip
|
|
PopulationDensity
|
population_density
|
|
MinimalPostalCode
|
postal_code
|
|
10107
|
price_range
|
|
EmailFlag
|
primary_contact.email
|
|
8022
|
primary_contact.first_name
|
|
8023
|
primary_contact.first_name
|
|
ExecGender
|
primary_contact.gender
|
|
FemaleExecOwner
|
primary_contact.gender
|
|
8022
|
primary_contact.last_name
|
|
8023
|
primary_contact.last_name
|
|
ContactID
|
primary_contact.mapped_contact_id
|
|
ExecutiveID
|
primary_contact.mapped_contact_id
|
|
ProfessionalTitle
|
primary_contact.professional_title
|
|
FemaleExecOwner
|
primary_contact.title_codes
|
|
HighIncomeExecutive
|
primary_contact.title_codes
|
|
TitleCode
|
primary_contact.title_codes
|
|
Naics2Code
|
primary_naics_code_id
|
|
Naics4Code
|
primary_naics_code_id
|
|
Naics6Code
|
primary_naics_code_id
|
|
NaicsCode
|
primary_naics_code_id
|
|
10207
|
primary_sic_code_id
|
|
7036
|
primary_sic_code_id
|
|
BankAssetCode
|
primary_sic_code_id
|
|
DatabaseSegmentationCode
|
primary_sic_code_id
|
|
GovernmentIndicator
|
primary_sic_code_id
|
|
HighTechBusinessFlag
|
primary_sic_code_id
|
|
SicCode
|
primary_sic_code_id
|
|
FranchiseCodesNum
|
professional_specialty_ids
|
|
professional_specialty_ids
|
professional_specialty_ids
|
|
10240
|
public_access
|
|
IndSpecFirstByte
|
public_access
|
|
7000
|
religious_denomination_ids
|
|
7036
|
religious_denomination_ids
|
|
7052
|
religious_denomination_ids
|
|
ACLFlag
|
religious_denomination_ids
|
|
FranchiseCodesNum
|
religious_denomination_ids
|
|
8035
|
residency_graduation_year
|
|
AttorneysCuisineCode
|
restaurant.cuisines
|
|
IndSpecFirstByte
|
restaurant.cuisines
|
|
RestaurantServiceType
|
restaurant.limited_service
|
|
10013
|
service_area.postal_codes
|
|
10014
|
shopping_center_atm
|
|
10207
|
sic_code_ids
|
|
7036
|
sic_code_ids
|
|
BankAssetCode
|
sic_code_ids
|
|
DatabaseSegmentationCode
|
sic_code_ids
|
|
GovernmentIndicator
|
sic_code_ids
|
|
HighTechBusinessFlag
|
sic_code_ids
|
|
SicCode
|
sic_code_ids
|
|
SquareFootage8
|
square_footage
|
|
State
|
state
|
|
10291
|
stock_exchange_code
|
|
10206
|
stock_ticker_symbol
|
|
CoHoldingStatusHistory1
|
stock_ticker_symbol
|
|
CoHoldingStatusHistory2
|
stock_ticker_symbol
|
|
CompanyHoldingStatus
|
stock_ticker_symbol
|
|
HouseNumber
|
street
|
|
PrimaryAddress
|
street
|
|
ShortAddress
|
street
|
|
StandardAddress
|
street
|
|
StreetName
|
street
|
|
StreetPostDirection
|
street
|
|
StreetPreDirection
|
street
|
|
StreetSuffix
|
street
|
|
UnitNumber
|
suite
|
|
AdSizeCode
|
tags.adsize_code
|
|
YearFirstAppearedyyyy
|
tags.created_at
|
|
Naics2Code
|
tags.naics_code_id
|
|
Naics4Code
|
tags.naics_code_id
|
|
Naics6Code
|
tags.naics_code_id
|
|
NaicsCode
|
tags.naics_code_id
|
|
PrimarySicDesignator
|
tags.primary
|
|
10207
|
tags.sic_code_id
|
|
7036
|
tags.sic_code_id
|
|
BankAssetCode
|
tags.sic_code_id
|
|
DatabaseSegmentationCode
|
tags.sic_code_id
|
|
GovernmentIndicator
|
tags.sic_code_id
|
|
HighTechBusinessFlag
|
tags.sic_code_id
|
|
SicCode
|
tags.sic_code_id
|
|
YellowPageCode
|
tags.yellow_page_code
|
|
BookNumber
|
tags.yppa_code
|
|
TeleresearchUpdateyyyymm
|
teleresearch_update_date
|
|
Dvx800Phone
|
toll_free_number
|
|
InternetAddress
|
tumblr_url
|
|
URLTypeCode
|
tumblr_url
|
|
InternetAddress
|
twitter_url
|
|
URLTypeCode
|
twitter_url
|
|
7056
|
updated_at
|
|
ChangeDate
|
updated_at
|
|
LastUpdateDate
|
updated_at
|
|
TransactionDate
|
updated_at
|
|
UpdateDateyyyymm
|
updated_at
|
|
YellowPageUpdateDate
|
updated_at
|
|
UPINFlag
|
upin
|
|
LastVerificationDate
|
verified_on
|
|
WealthCode
|
wealthy_area_flag
|
|
InternetAddress
|
website
|
|
URLTypeCode
|
website
|
|
10080
|
website_keywords
|
|
ActiveWebAddressFlag
|
website_status
|
|
WhiteCollarPercent
|
white_collar_percentage
|
|
CottageCodeFlag
|
work_at_home
|
|
SelfEmployedBusinessFlag
|
work_at_home
|
|
InternetAddress
|
yelp_url
|
|
URLTypeCode
|
yelp_url
|
|
InternetAddress
|
youtube_url
|
|
URLTypeCode
|
youtube_url
|
|
ZipCode
|
zip
|
|
Zip4
|
zip_four
|
