MRT README - JSON

Data File Title

Digest Machine Readable Table (MRT) File

Data File Description

MRT files are created to increase the usability and accessibility of current and future Digest tables. The MRT files have a uniform design; this allows Digest table data to be read in a standard format and provides the table-specific metadata information pertaining to the table. Typically, each MRT file contains data from one Digest table. The MRT format is intended to facilitate access to Digest table data by statistical software programs. Those seeking to simply view the data or make a simple calculation can access these data in a traditional tabular format (see URL field provided in the file).

MRT File Format

JSON

Access Control

Public; no access restrictions

Contact Information

ARIS.NCES@ed.gov

List of meta variables and descriptions

Variable Name	Description
digest_table_id	Digest table number. Unique when using in combination with digest_table_year and digest_table_sub_id.
digest_table_year	Digest table edition year.
digest_table_url	The Uniform Resource Locator (URL) for the Digest table.
general_note	General note.
has_se	Indicates whether estimates presented in the table have standard errors.
headnote	Digest table headnote.
last_prepared	Time table was last prepared.
mrt_version	Version of this MRT file. For more information, see the "changelog" above.
source_note	Data source note.
stub_head	Digest table stub head.
table_title	Digest table title.

List of data variables and descriptions

Variable Name	Description
cell_note	Reference and special notes at cell level.
column_index	Column identifier in alphabetic order starting from the first column of data to the last column from left to right.
column_level	Concatenated column level headers separated by three colons “:::”. Seven levels of column headers are included and presented in a delimited format: the first column level is presented, followed by three colons (as a delimiter), and then the second column level is presented. This continues until all of the column level information is shown.
column_level_[1-7]	Concatenated column level header.
column_level_[1-7]_ref_note	Reference note corresponding to the column level. For example, column_level_1_ref_note is the note for column_level_1.
deflator	Deflator used in the table. The deflator is defined as the ratio of Consumer Price Index (CPI) of the current year to the CPI of the base year.
digest_table_sub_id	Digest table sub-ID if one Digest table is broken into multiple subtables. If there is only one main table, this entry will have the value of “A”.
digest_table_sub_title	Digest table sub title if one Digest table is broken into multiple subtables.
digest_table_sub_title_note	Digest table sub title note if one Digest table is broken into multiple subtables.
location	Geographic location.
location_type	The type of location.
row_index	Row identifier in numeric order starting from the first row of data to the last row from top to the bottom.
row_level	Concatenated row level headers separated by three colons “:::”. Seven levels of row headers are included and presented in a delimited format: the top row level is presented, followed by three colons (as a delimiter), and then the second row level is presented. This continues until all of the row level information is shown.
row_level_[1-7]	Concatenated row level header.
row_level_[1-7]_ref_note	Reference note corresponding to the row level. For example, row_level_1_ref_note is the note for row_level_1.
standard_error	Standard error. If the entry does not contain specific number or is blank, please check the variable “standard_error_cell_note” for details.
standard_error_cell_note	Reference and special notes at cell level for standard error.
value	Data value. If the entry does not contain specific number or is blank, please check the variable “cell_note” for details.
year	Year of data presented.

Top