glam-datasets
1 row where file_description = "This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Date, Record Type, Citation, Remarks [Click here for more information about this index](http://www.records.nsw.gov.au/state-archives/indexes-online/indexes-to-convict-records/index-to-tickets-of-leave-certificates-and-pardons).", format = "CSV" and source = "data.nsw.gov.au"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date)
source
- data.nsw.gov.au · 1 ✖
publisher
licence
format
- CSV · 1 ✖
file_description ✖
- This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Date, Record Type, Citation, Remarks [Click here for more information about this index](http://www.records.nsw.gov.au/state-archives/indexes-online/indexes-to-convict-records/index-to-tickets-of-leave-certificates-and-pardons). · 1 ✖
Link | rowid ▼ | dataset_title | publisher | author | dataset_issued | dataset_modified | dataset_description | source | info_url | start_date | end_date | file_title | download_url | format | file_description | file_created | file_modified | file_size | licence |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
940 | 940 | Convict Indexes | NSW State Archives | State Records Authority | 2015-10-01T01:54:53.522981 | 2015-10-01T02:14:59.600322 | Between 1788 and 1842 about 80,000 convicts were transported to New South Wales. Of these, about 85%… | data.nsw.gov.au | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0 | Index to Tickets of Leave, Certificates of Emancipation, and Pardons, 1810-19 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/82b8128f-b0cf-44ef-b6c5-f4762688b000/download/tickets-of-leave-certificates-of-emancipation-pardons-1810-19.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Da… | 2015-10-01T12:13:36.362074 | Creative Commons Attribution |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [glam-datasets] ( [dataset_title] TEXT, [publisher] TEXT, [author] TEXT, [dataset_issued] TEXT, [dataset_modified] TEXT, [dataset_description] TEXT, [source] TEXT, [info_url] TEXT, [start_date] TEXT, [end_date] TEXT, [file_title] TEXT, [download_url] TEXT, [format] TEXT, [file_description] TEXT, [file_created] TEXT, [file_modified] TEXT, [file_size] TEXT, [licence] TEXT ); CREATE INDEX [idx_glam-datasets_source_publisher_format_licence] ON [glam-datasets] ([source], [publisher], [format], [licence]);