Return Federal Office Information from a tibble
tbl_fpds_office_ids(
data,
column = "idOfficeContracting",
use_sam = F,
select_columns = c("isActive", "idCGACAgency", "nameAgencyCGAC", "isDefenseAccount",
"idOrganizationLevel", "idOrganizationSAMDepartment", "idOffice", "idOfficeFPDS",
"locationOrganization", "cityStateOrganization", "idOrganizationSAM",
"nameDepartment", "slugDepartment", "nameAgency", "nameCommandMajor",
"typeOrganization", "nameOrganization", "nameOrganizationParent", "nameCommandSub",
"idAgencyFPDS", "idOrganizationParent", "idOrganizationSAMAgency", "idOfficeAAC",
"idAddressSAM", "dateOrganizationStart", "slugCGAC",
"isSourceFPDS",
"codeAgencyOMB", "descriptionOffice", "addressStreet1Organization",
"addressStreet2Organization", "cityOrganization", "stateOrganization",
"zipcodeOrganization", "codeCountryOrganization", "hasContractAwards",
"hasContractFunding", "hasFinancialAssistanceFunding",
"hasFinancialAssistanceAwards")
)
office id column name
if TRUE
uses full SAM heirarchy - takes longer
vector of select columns