glam-datasets
7 rows where dataset_description = "Between 1788 and 1842 about 80,000 convicts were transported to New South Wales. Of these, about 85% were men and 15% were women. Almost two thirds of convicts were English (along with a small number of Scottish and Welsh), with the Irish making up the remaining one third. Convicts were usually given sentences of transportation for seven, 14 years or life. Some convicts in the 1830s received ten-year sentences. About one quarter of the convicts were sentenced to ‘the term of their natural lives’, and a proportion of these had reprieves from the death sentence. These seven indexes contain around 140,000 entries in total.", 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 · 7 ✖
publisher
licence
format
- CSV · 7 ✖
dataset_description ✖
- Between 1788 and 1842 about 80,000 convicts were transported to New South Wales. Of these, about 85% were men and 15% were women. Almost two thirds of convicts were English (along with a small number of Scottish and Welsh), with the Irish making up the remaining one third. Convicts were usually given sentences of transportation for seven, 14 years or life. Some convicts in the 1830s received ten-year sentences. About one quarter of the convicts were sentenced to ‘the term of their natural lives’, and a proportion of these had reprieves from the death sentence. These seven indexes contain around 140,000 entries in total. · 7 ✖
end_date (date) ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
935 | 935 | 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 convict bank accounts 1837-70 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/4cbdcbe0-e51f-41a1-ae44-25a16c2e06bc/download/bank-accounts-1837-70.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, D… | 2015-10-01T11:57:07.654001 | Creative Commons Attribution | ||||
936 | 936 | 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 Certificates of Freedom, 1823-69 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/07fb0a86-e7d6-4023-9033-c6ec50b077d5/download/certificates-of-freedom-1823-69.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, D… | 2015-10-01T11:59:46.136381 | Creative Commons Attribution | ||||
937 | 937 | 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 convict pardons, 1791-1825 and 1837-47 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/c3d46577-7ede-4ed0-96cb-9877af4727a2/download/pardons-1791-1825-and-1837-47.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Da… | 2015-10-01T12:02:20.325069 | Creative Commons Attribution | ||||
938 | 938 | 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 Exemption from Government Labour, 1827-32 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/bd235c5d-0690-441f-ad62-a5fa4eaa3761/download/tickets-of-exemption-from-govt-labor-1827-32.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Da… | 2015-10-01T12:05:30.634761 | Creative Commons Attribution | ||||
939 | 939 | 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, 1810-75 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/386608d7-a103-4440-adb7-adae2f8928db/download/tickets-of-leave-1810-75.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Da… | 2015-10-01T12:11:25.660171 | Creative Commons Attribution | ||||
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 | ||||
941 | 941 | 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 Passports, 1835-69 | https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0/resource/128a859e-120f-43e2-8f9f-9aadc05b8745/download/tickets-of-leave-passports-1835-69.csv | CSV | This dataset contains the following attributes: ID, Surname, First Name, Alias, Vessel, Year, No, Da… | 2015-10-01T12:14:59.685832 | 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]);