Generated on 2019-10-21T12:17:27+0000
##root
filename => root.csv
# of rows => 10930
# of rows => 74
| Column |
|---|
| id |
| meta_filename |
| meta_doctype |
| meta_budget_year |
| meta_budget_cycle |
| meta_submission_date |
| meta_service_agency_name |
| meta_appropriation_code |
| meta_appropriation_name |
| record_@monetaryUnit |
| record_ProgramElementNumber_val |
| record_ProgramElementTitle_val |
| record_R1LineItemNumber_val |
| record_BudgetYear_val |
| record_BudgetCycle_val |
| record_SubmissionDate_val |
| record_ServiceAgencyName_val |
| record_AppropriationCode_val |
| record_AppropriationName_val |
| record_BudgetActivityNumber_val |
| record_BudgetActivityTitle_val |
| record_ProgramElementFunding_PriorYear_val |
| record_ProgramElementFunding_CurrentYear_val |
| record_ProgramElementFunding_BudgetYearOne_val |
| record_ProgramElementFunding_BudgetYearOneBase_val |
| record_ProgramElementFunding_BudgetYearOneOCO_val |
| record_ProgramElementFunding_BudgetYearTwo_val |
| record_ProgramElementFunding_BudgetYearThree_val |
| record_ProgramElementFunding_BudgetYearFour_val |
| record_ProgramElementFunding_BudgetYearFive_val |
| record_ProgramElementFunding_CostToComplete_val |
| record_ProgramElementFunding_TotalCost_val |
| record_ProgramElementFunding_AllPriorYears_val |
| record_ProgramElementNote_val |
| record_ProgramElementMissionDescription_val |
| record_ChangeSummary_PreviousPresidentBudget_PriorYear_val |
| record_ChangeSummary_PreviousPresidentBudget_CurrentYear_val |
| record_ChangeSummary_PreviousPresidentBudget_BudgetYearOne_val |
| record_ChangeSummary_PreviousPresidentBudget_BudgetYearOneBase_val |
| record_ChangeSummary_PreviousPresidentBudget_BudgetYearOneOCO_val |
| record_ChangeSummary_CurrentPresidentBudget_PriorYear_val |
| record_ChangeSummary_CurrentPresidentBudget_CurrentYear_val |
| record_ChangeSummary_CurrentPresidentBudget_BudgetYearOne_val |
| record_ChangeSummary_CurrentPresidentBudget_BudgetYearOneBase_val |
| record_ChangeSummary_CurrentPresidentBudget_BudgetYearOneOCO_val |
| record_ChangeSummary_TotalAdjustments_PriorYear_val |
| record_ChangeSummary_TotalAdjustments_CurrentYear_val |
| record_ChangeSummary_TotalAdjustments_BudgetYearOne_val |
| record_ChangeSummary_TotalAdjustments_BudgetYearOneBase_val |
| record_ChangeSummary_TotalAdjustments_BudgetYearOneOCO_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalGeneralReductions_CurrentYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalGeneralReductions_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalDirectedReductions_CurrentYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalDirectedReductions_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalRescissions_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalRescissions_CurrentYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalAdds_CurrentYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalAdds_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalDirectedTransfers_CurrentYear_val |
| record_ChangeSummary_AdjustmentDetails_CongressionalDirectedTransfers_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_Reprogrammings_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_Reprogrammings_CurrentYear_val |
| record_ChangeSummary_AdjustmentDetails_SBIRSTTRTransfer_PriorYear_val |
| record_ChangeSummary_AdjustmentDetails_SBIRSTTRTransfer_CurrentYear_val |
| record_ChangeSummary_SummaryExplanation_val |
| record_@format |
| record_MdapCodes_val |
| record_R1LineNumber_val |
| record_MdapCode_val |
| record_PriorYearsDelta_val |
| record_@classification |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
##root.record.ChangeSummary.AdjustmentDetails.OtherAdjustmentDetailList.OtherAdjustmentDetail
filename => root.record.ChangeSummary.AdjustmentDetails.OtherAdjustmentDetailList.OtherAdjustmentDetail.csv
# of rows => 15485
# of rows => 11
| Column |
|---|
| Title_val |
| Funding_PriorYear_val |
| Funding_CurrentYear_val |
| Funding_BudgetYearOne_val |
| Funding_BudgetYearOneBase_val |
| Funding_BudgetYearOneOCO_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project
filename => root.record.ProjectList.Project.csv
# of rows => 23506
# of rows => 50
| Column |
|---|
| ProjectNumber_val |
| ProjectTitle_val |
| ProjectFunding_PriorYear_val |
| ProjectFunding_CurrentYear_val |
| ProjectFunding_BudgetYearOne_val |
| ProjectFunding_BudgetYearOneBase_val |
| ProjectFunding_BudgetYearOneOCO_val |
| ProjectFunding_BudgetYearTwo_val |
| ProjectFunding_BudgetYearThree_val |
| ProjectFunding_BudgetYearFour_val |
| ProjectFunding_BudgetYearFive_val |
| ProjectFunding_CostToComplete_val |
| ProjectFunding_TotalCost_val |
| ProjectFunding_AllPriorYears_val |
| R2aExhibit_ProjectArticles_PriorYear_val |
| R2aExhibit_ProjectArticles_CurrentYear_val |
| R2aExhibit_ProjectArticles_BudgetYearOne_val |
| R2aExhibit_ProjectArticles_BudgetYearOneBase_val |
| R2aExhibit_ProjectArticles_BudgetYearOneOCO_val |
| R2aExhibit_ProjectArticles_BudgetYearTwo_val |
| R2aExhibit_ProjectArticles_BudgetYearThree_val |
| R2aExhibit_ProjectArticles_BudgetYearFour_val |
| R2aExhibit_ProjectArticles_BudgetYearFive_val |
| R2aExhibit_ProjectArticles_AllPriorYears_val |
| R2aExhibit_ProjectNote_val |
| R2aExhibit_ProjectMissionDescription_val |
| R2aExhibit_AcquisitionStrategy_val |
| R2aExhibit_PerformanceMetrics_val |
| R2aExhibit_OtherProgramFundingSummaryRemarks_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| R4Exhibit_ScheduleProfileNote_val |
| R4aExhibit_ScheduleDetailNote_val |
| R3Exhibit_Remarks_val |
| R5Exhibit_TerminationLiability_Cost_PriorYear_val |
| R5Exhibit_TerminationLiability_Cost_CurrentYear_val |
| R5Exhibit_TerminationLiability_Cost_BudgetYearOne_val |
| R5Exhibit_TerminationLiability_Cost_BudgetYearTwo_val |
| R5Exhibit_TerminationLiability_Cost_BudgetYearThree_val |
| R5Exhibit_TerminationLiability_Cost_BudgetYearFour_val |
| R5Exhibit_TerminationLiability_Cost_BudgetYearFive_val |
| R5Exhibit_TerminationLiability_Cost_AllPriorYears_val |
| R5Exhibit_TerminationLiability_Remarks_val |
| SpecialProject_val |
| MdapCode_val |
| PriorYearsDelta_val |
| @suppressProjectPDF |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R2aExhibit.AccomplishmentPlannedProgramList.AccomplishmentPlannedProgram
filename => root.record.ProjectList.Project.R2aExhibit.AccomplishmentPlannedProgramList.AccomplishmentPlannedProgram.csv
# of rows => 62773
# of rows => 22
| Column |
|---|
| Title_val |
| Description_val |
| Accomplishment_PriorYear_Funding_val |
| Accomplishment_PriorYear_Text_val |
| Accomplishment_PriorYear_Articles_val |
| PlannedProgram_CurrentYear_Funding_val |
| PlannedProgram_CurrentYear_Text_val |
| PlannedProgram_CurrentYear_Articles_val |
| PlannedProgram_BudgetYearOne_Funding_val |
| PlannedProgram_BudgetYearOne_Articles_val |
| PlannedProgram_BudgetYearOneBase_Funding_val |
| PlannedProgram_BudgetYearOneBase_Text_val |
| PlannedProgram_BudgetYearOneBase_Articles_val |
| PlannedProgram_BudgetYearOneOCO_Funding_val |
| PlannedProgram_BudgetYearOneOCO_Text_val |
| PlannedProgram_BudgetYearOneOCO_Articles_val |
| PlannedProgram_AppChangeSummary_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R2aExhibit.OtherProgramFundingSummaryList.OtherProgramFundingSummary
filename => root.record.ProjectList.Project.R2aExhibit.OtherProgramFundingSummaryList.OtherProgramFundingSummary.csv
# of rows => 26932
# of rows => 18
| Column |
|---|
| LineItem_val |
| Title_val |
| Funding_PriorYear_val |
| Funding_CurrentYear_val |
| Funding_BudgetYearOne_val |
| Funding_BudgetYearOneBase_val |
| Funding_BudgetYearOneOCO_val |
| Funding_BudgetYearTwo_val |
| Funding_BudgetYearThree_val |
| Funding_BudgetYearFour_val |
| Funding_BudgetYearFive_val |
| Funding_CostToComplete_val |
| Funding_TotalCost_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R2aExhibit.CongressionalAddDetailList.CongressionalAddDetail
filename => root.record.ProjectList.Project.R2aExhibit.CongressionalAddDetailList.CongressionalAddDetail.csv
# of rows => 2055
# of rows => 10
| Column |
|---|
| Title_val |
| CurrentYear_Funding_val |
| CurrentYear_Text_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| PriorYear_Funding_val |
| PriorYear_Text_val |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R4Exhibit.ScheduleProfile
filename => root.record.ProjectList.Project.R4Exhibit.ScheduleProfile.csv
# of rows => 10505
# of rows => 6
| Column |
|---|
| ImageFileName_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R4aExhibit.ScheduleDetailList.ScheduleDetail
filename => root.record.ProjectList.Project.R4aExhibit.ScheduleDetailList.ScheduleDetail.csv
# of rows => 56123
# of rows => 10
| Column |
|---|
| EventTitle_val |
| Schedule_Start_Quarter_val |
| Schedule_Start_Year_val |
| Schedule_End_Quarter_val |
| Schedule_End_Year_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R3Exhibit.CostCategoryGroupList.CostCategoryGroup
filename => root.record.ProjectList.Project.R3Exhibit.CostCategoryGroupList.CostCategoryGroup.csv
# of rows => 35157
# of rows => 7
| Column |
|---|
| Name_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| Remarks_val |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R3Exhibit.CostCategoryGroupList.CostCategoryGroup.CostCategoryItemList.CostCategoryItem
filename => root.record.ProjectList.Project.R3Exhibit.CostCategoryGroupList.CostCategoryGroup.CostCategoryItemList.CostCategoryItem.csv
# of rows => 136868
# of rows => 24
| Column |
|---|
| Name_val |
| ContractMethod_val |
| ContractType_val |
| PerformingActivity_val |
| PerformingActivityLocation_val |
| Cost_TotalPreviousYears_val |
| Cost_CurrentYear_Amount_val |
| Cost_CurrentYear_AwardDate_val |
| Cost_BudgetYearOne_Amount_val |
| Cost_BudgetYearOneBase_Amount_val |
| Cost_BudgetYearOneBase_AwardDate_val |
| Cost_BudgetYearOneOCO_Amount_val |
| Cost_BudgetYearOneOCO_AwardDate_val |
| Cost_CostToComplete_val |
| Cost_TotalCost_val |
| Cost_TargetValue_val |
| Cost_PriorYear_Amount_val |
| Cost_PriorYear_AwardDate_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| FundingVehicle_val |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R2aExhibit.JointFundingList.JointFunding
filename => root.record.ProjectList.Project.R2aExhibit.JointFundingList.JointFunding.csv
# of rows => 279
# of rows => 15
| Column |
|---|
| Title_val |
| Funding_PriorYear_val |
| Funding_CurrentYear_val |
| Funding_BudgetYearOne_val |
| Funding_BudgetYearOneBase_val |
| Funding_BudgetYearOneOCO_val |
| Funding_TotalPreviousYears_val |
| Funding_CostToComplete_val |
| Funding_TotalCost_val |
| Funding_TargetValue_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R4aExhibit.SubProjectScheduleList.SubProjectSchedule
filename => root.record.ProjectList.Project.R4aExhibit.SubProjectScheduleList.SubProjectSchedule.csv
# of rows => 10080
# of rows => 6
| Column |
|---|
| Title_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |
##root.record.ProjectList.Project.R4aExhibit.SubProjectScheduleList.SubProjectSchedule.ScheduleDetailList.ScheduleDetail
filename => root.record.ProjectList.Project.R4aExhibit.SubProjectScheduleList.SubProjectSchedule.ScheduleDetailList.ScheduleDetail.csv
# of rows => 91768
# of rows => 10
| Column |
|---|
| EventTitle_val |
| Schedule_Start_Quarter_val |
| Schedule_Start_Year_val |
| Schedule_End_Quarter_val |
| Schedule_End_Year_val |
| @SOURCE_FILENAME |
| @RECORDID |
| @ROWID |
| @PARENTROWID |
| @PARENT |