glam-datasets
1 row where dataset_description = "This index was compiled from the [Register of passage certificates](https://www.archivessearch.qld.gov.au/series/S7002) kept by the Sub-Immigration Agent, Warwick, recording applications by sponsors of immigrants for the period 1887 to 1906. The records are held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives).", "dataset_modified" is on date 2022-06-20 and format = "JSON"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)
source
publisher
licence
format
- JSON · 1 ✖
dataset_description ✖
- This index was compiled from the [Register of passage certificates](https://www.archivessearch.qld.gov.au/series/S7002) kept by the Sub-Immigration Agent, Warwick, recording applications by sponsors of immigrants for the period 1887 to 1906. The records are held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives). · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
484 | 484 | Passage certificates 1887 to 1906 | Queensland State Archives | info@archives.qld.gov.au | 2013-06-26T01:39:38.432133 | 2022-06-20T04:13:09.688383 | This index was compiled from the [Register of passage certificates](https://www.archivessearch.qld.g… | data.qld.gov.au | https://data.qld.gov.au/dataset/8a682383-88a8-4799-8c18-3845040daef3 | Passage certificates 1887 to 1906 JSON | https://www.data.qld.gov.au/dataset/8a682383-88a8-4799-8c18-3845040daef3/resource/b8889ae7-fa1d-456d-8127-29b0f6470a99/download/passage-certificates-1887-1906.json | JSON | This open data file lists the names of applicants and nominees as recorded in the register of passag… | 2018-09-04T04:08:57.735706 | 2018-09-04T04:08:57.650225 | 239104.0 | Creative Commons Attribution 4.0 |
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]);