7 rows where format = "CSV", info_url = "https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0", publisher = "NSW State Archives" 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

  • NSW State Archives · 7

info_url

  • https://data.nsw.gov.au/data/dataset/acdd01d0-d700-465c-a183-735c4f139ca0 · 7

format

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