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"

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date)

source

  • data.nsw.gov.au · 7

publisher

format

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 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 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 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 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 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 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 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

CSV options:

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]);