Join SAM data
tbl_sam_data(
data,
duns_column = "id_duns",
sam_select_columns = c("dateSAMData", "idUniqueEntity", "slugCAGE",
"nameCompanyLegalClean", "nameCompanyLegal", "isExpiredSAMEntity",
"slugDeptDefenseAddressCode", "dateRegistrationInitial", "dateExpiration",
"dateLastUpdate", "dateActivation", "dateCompanyStart", "monthdayFiscalYearEnd",
"urlCompany", "nameCompanyDBA", "nameCompanyDivision", "countSBATypes",
"typeEntityStructure", "typeSAMExtract", "typeRegistrationPurpose",
"isNonPublicSAMRegistered", "nameNAICSPrimary", "nameSectorNAICS",
"nameSubSectorNAICS", "nameIndustryGroupNAICS",
"nameIndustryNAICS",
"nameContactGovernment", "nameContactGovernmentAlt", "nameContactPastPerformance",
"nameContactElectronic", "typeEntity", "isTaxExemptEntity",
"isForeignLocatedCompany", "isForeignIncorporatedcompany", "locationCompany",
"addressStreet1Company", "addressStreet2Company", "cityStateCompany",
"locationMailingCompany", "cityStateMailingCompany", "cityCompany", "stateCompany",
"zipcodeCompany", "zipcode4Company", "codeCountryCompany",
"idCongressionalDistrictCompany", "slugEntityStructure",
"stateIncorporation",
"codeCountryIncorporation", "countBusinessTypes", "idNAICSPrimary", "countNAICS",
"countProductServiceCodes", "emailPointOfContactGovt", "dataBusinessTypes",
"dataDisasterResponse", "dataNAICS", "dataNAICSExceptions",
"dataProductServiceCodes", "dataSBA", "urlFARPDF", "urlDFARPDF"),
snake_names = T
)