Publish Standards on data.gov for Supported Data Formats
In examining an interesting data set that is supplied as a Comma-Separated Values (CSV) file, I noticed that the CSV file does not have the header line. It is customary for a CSV file to have the first line be the column names separated by commas. This dataset does not have the header line: http://www.data.gov/details/1617 So, what is the solution here? I recommend that for each format supported on data.gov there exists ...more »
In examining an interesting data set that is supplied as a Comma-Separated Values (CSV) file, I noticed that the CSV file does not have the header line. It is customary for a CSV file to have the first line be the column names separated by commas.
This dataset does not have the header line:
http://www.data.gov/details/1617
So, what is the solution here? I recommend that for each format supported on data.gov there exists an endorsed standard (existing or newly created) for how that should be formatted by agencies.
So, in this case, data.gov would post on their site a standard for how agencies should produce CSV files and hopefully that would include a recommendation that each CSV file produced begins with a header line that has the column names separated by columns for the data.
(of course, each column name should have a definition in the data dictionary as proposed in a different idea).
« less full details »

Social Web