The same list of auroral observations for the Carrington Event of 1859 are given in the 

Great_Magnetic_Storm_of_1859_List_of_Auroral_Sightings.txt

and

Great_Magnetic_Storm_of_1859_List_of_Auroral_Sightings.csv

The .txt file contains the metadata at the top and the data is tab delimited.

The .csv files does not have the metadata at the top and the data is comma delimited.

The metadata is repeated below

# EventTableVersion: HPEevent 1.0 http://spase-group.org/docs/conventions/HDMC-Event-List-Specification-v1.0.4.pdf
#DOI: to be determined
#ListID: SPASE ID to be determined
#CreationDate: ISO 8601 Date and Time of the Table creation.
#ModifyDate: ISO 8601 Date and Time of the last modification of the list
#ListTitle: Great_Magnetic_Storm_of_1859_List_of_Auroral_Sightings
#ListBeginDate :1859-08-28T00:00Z
#ListEndDate:1859-09-04T00:00Z
#Contact: James A Green <jlgreen1@earthlink.net>; Scott A Boardsen <scott.a.boardsen@nasa.gov>
#Description: Partial list of Auroral Sightings during the Great Magnetic Storm of 1859 from August 28th to September 3rd. Location and times of sightings taken from Ship Deck Logs (mainly US and Royal Navy), contemporary diaries, letters, new papers, and journal articles. The times given in the sources are local time, we assumed that the sun is at greatest elevation at local noon and we converted the local times to UTC.  Not all end times are given so the null value is  "0001-01-01T00:00:00.000Z", some observations start at dusk or end at dawn for those cases the dawn/dusk time is defined by the terminator crossing at the observation location, no twilight correction was made. The latitudes and longitudes are in Geographic coordinates. See reference for greater detail. Note: the local start/stop time are given as integer month/integer day of month integer hour: integer minutes. A '?' in the stop_time_local means the stop time could not be identified in the historical record.
#Reference: Green, J. L., & Boardsen, S. (2006). Duration and extent of the great auroral storm of 1859. Advances in space research : the official journal of the Committee on Space Research (COSPAR), 38(2), 130–135. https://doi.org/10.1016/j.asr.2005.08.054
#FieldNames: start_time_utc  stop_time_utc start_time_local stop_time_local geo_latitude_deg geo_longitude_deg observatory source comments
#Observatory is the City/State or Country or Ship where the auroral was observed
#Source refers to the reference given the the paper.
#FieldUnits: DateTime DateTime degrees degrees  None None None None None 
#FieldTypes: char char float float char char char  char char
#FieldNulls: 0001-01-01T00:00:00.000Z  0001-01-01T00:00:00.000Z ******** ******** ******** ********  ******** ******** ******** 
#start_time_utc  stop_time_utc start_time_local stop_time_local geo_latitude_deg geo_longitude_deg  observatory source comments