49100426Q0043 Attachment A.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Commercial Business Intelligence Data Feed Services Federal contract opportunity
- Solicitation number
- 49100426Q0043
About this file
Attachment A is a data specifications document that defines the technical requirements and data structure for the Commercial Business Intelligence Data Feed Services solicitation (49100426Q0043). The attachment includes an Excel file containing schema specifications for company and investor relationship data, along with NSF-specific scope information. The document establishes column definitions, data types, and field requirements for recurring data deliverables, including company identifiers, financial metrics, organizational details, business status information, and investor relations data. Key data elements required include CompanyID, CompanyName, legal and former names, award numbers, program information, principal investigator details, business status, location data, revenue figures, valuation information, and investor relationship tracking with investor status classifications and update timestamps.
The NSF_Scope file specifications outline additional required data fields specific to NSF awards, including matched company identifiers, organization details, award numbers, program managers, amendment dates, awarded amounts to date, contact information, NSF directorates, and abstract information. All files are designated for weekly frequency updates. The specification emphasizes data matching, entity resolution, standardized electronic file delivery, quality assurance, and periodic reporting of matching activities and data processing results to support NSF's SBIR/STTR public website, TIP Investment Explorer, and analytical initiatives within the Directorate for Technology, Innovation, and Partnerships (TIP).
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 49100426Q0043 Rev 01.pdf | ||
| 49100426Q0043.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
PB_CACHE
H4sIAAAAAAAEAM2Q30rDMBTGu1Wxog+Re0todXP2ojdWceCQQYc3Y8w0HGxYmtT8EbrH8IU1KZ1eeOGtJ5BzEvh+5+MLRkEQfLry3df52F1PS2ZofSvlDq26FjRasEoR1cXoGZRmUuQpvsQZTmJUWG6sglyANYrwGC1txRl9hG4ldyByYTk/9vDym7ntmduBiUtQjHC2JxWHgtAafv9crGS7gHfg/euOUeM8OG3ouCeDpaiQTUsUqGhOdF2yPQRhEH2Myk4baHAhOYdep/EDCLeBHvr9m3XbTHcAvKTr9aAqjWLiNUaNplJxVv0EMMGJP38HUM1mZEqn12l2NYHkJttsovGQ9Wk4DEd++I9WvbmzL/ndqIwkAgAA
Company
| File: | Company.csv | ||||
| Frequency: | Weekly | ||||
| Column | Column Name | Data Type | Sort | PK | Comments |
| 1 | CompanyID | VARCHAR(20) | 1 | x | Unique identifier for company (PBId) |
| 2 | CompanyName | VARCHAR(255) | |||
| 3 | CompanyAlsoKnownAs | VARCHAR(500) | |||
| 4 | CompanyFormerName | VARCHAR(Max) | |||
| 5 | CompanyLegalName | VARCHAR(Max) | |||
| 6 | AwardNumber | VARCHAR(Max) | Client Identifier | ||
| 7 | Title | VARCHAR(Max) | Client Identifier | ||
| 8 | Programs | VARCHAR(Max) | Client Identifier | ||
| 9 | StartDate | DATE | Client Identifier | ||
| 10 | EndDate | DATE | Client Identifier | ||
| 11 | PrincipalInvestigator | VARCHAR(Max) | Client Identifier | ||
| 12 | PIEmailAddress | VARCHAR(Max) | Client Identifier | ||
| 13 | Description | VARCHAR(Max) | |||
| 14 | TotalRaised | FLOAT | |||
| 15 | BusinessStatus | VARCHAR(50) | |||
| 16 | Website | VARCHAR(Max) | |||
| 17 | Employees | INT | |||
| 18 | Employee History | ||||
| 19 | YearFounded | INT | |||
| 20 | PrimaryIndustrySector | VARCHAR(100) | |||
| 21 | Verticals | ||||
| 22 | Keywords | ||||
| 23 | HQLocation | VARCHAR(100) | |||
| 24 | HQCity | VARCHAR(100) | |||
| 25 | HQState_Province | VARCHAR(100) | |||
| 26 | HQEmail | VARCHAR(255) | |||
| 27 | Revenue | FLOAT | |||
| 28 | FiscalPeriod | VARCHAR(10) | |||
| 29 | LastKnownValuation | FLOAT | |||
| 30 | LastKnownValuationDate | DATE | |||
| 31 | LastUpdated | DATE |
CompanyInvestorRelation
| File: | CompanyInvestorRelation.csv | ||||
| Frequency: | Weekly | ||||
| Column | Column Name | Data Type | Sort | PK | Comments |
| 1 | CompanyID | VARCHAR(20) | 1 | Unique identifier for company (PBId) | |
| 2 | InvestorID | VARCHAR(20) | Unique identifier for investor (PBId) | ||
| 3 | InvestorName | VARCHAR(200) | |||
| 4 | InvestorStatus | VARCHAR(50) | "Active", "Former", "Add-on Sponsor", "Acquirer", "Bidding", "Pending" (Sell Side)", Pending (Buy Side)", "Failed", "Non-Investors/Shareholders", Secondary Investors/Shareholders", "Other Investor" | ||
| 5 | HQLocation | VARCHAR(100) | Investor HQLocation | ||
| 6 | LastUpdated | DATE |
NSF Scope
| File: | NSF_Scope_yyyyymmdd.csv |
| Frequency: | Weekly |
| NSF appends new award information to the file. |
| Column | Column Name | Data Type | Sort | PK | Comments |
| 1 | MATCHED_BE | Company ID (To be provided by vendor) | |||
| 2 | Organization | ||||
| 3 | OrganizationCity | ||||
| 4 | OrganizationState | ||||
| 5 | OrganizationStreet | ||||
| 6 | AwardNumber | 1 | 1 | ||
| 7 | Title | ||||
| 8 | NSFOrganization | ||||
| 9 | Program(s) | ||||
| 10 | StartDate | ||||
| 11 | LastAmendmentDate | ||||
| 12 | PrincipalInvestigator | ||||
| 13 | State | ||||
| 14 | ProgramManager | ||||
| 15 | EndDate | ||||
| 16 | AwardedAmountToDate | ||||
| 17 | PIEmailAddress | ||||
| 18 | OrganizationZip | ||||
| 19 | OrganizationPhone | ||||
| 20 | NSFDirectorate | ||||
| 21 | Abstract | ||||
| 22 | Website |
File details come from the government source that posted it. Updated .