Data Dictionary
This data dictionary lists all columns for each table in this data source.
Recommendation
Table: recommendation
Index: recom_no
| Column Name | Business Name | Definition |
|---|---|---|
| recom_no | RECOMMENDATION NUMBER | The recommendation identifier. |
| ltr_date_ntsb | LETTER DATE | The date for the most recent update in the dialogue between the NTSB and the FAA. |
| subject | SUBJECT | The subject of the recommendation(s). |
| classification_code | NTSB STATUS DESCRIPTION | The current status of the NTSB recommendations to the FAA and FAA responses for a given brief. |
Summary Document
Table: summary_document
Index: recom_no
| Column Name | Business Name | Definition |
|---|---|---|
| recom_no | RECOMMENDATION NUMBER | The recommendation identifier. |
| occurrence_text | Occurrence Text | Text describing the occurrence that prompted the NTSB safety recommendation. |
| recommendation_text | Recommendation Text | Full text of the NTSB safety recommendation. |
| response_text | Response Text | FAA response text to the NTSB recommendation. |
| plain_doc_text | NARRATIVE | The narrative, responses, and recommendations presented in a brief report format along with letter dates. |