glam-datasets
3 rows where dataset_description = "Newspaper articles relating to Sir Ross Smith and the 1919 Epic Flight from England to Australia. Datasets are divided into themes of prelude to the epic flight, the epic flight and death and funeral of Sir Ross Smith. Articles are sourced from South Australian newspapers *The Advertiser*, *Daily Herald*, *The Observer* and *The Register*.", end_date = "1922-12-31", format = "XLSX", licence = "Creative Commons Attribution", publisher = "State Library of South Australia" and source = "data.sa.gov.au"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date), file_modified (date)
source
- data.sa.gov.au · 3 ✖
publisher
- State Library of South Australia · 3 ✖
licence
- Creative Commons Attribution · 3 ✖
format
- XLSX · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
692 | 692 | Newspaper Articles relating to Sir Ross Smith | State Library of South Australia | State Library of South Australia | 2019-06-24T02:47:32.528709 | 2019-08-29T04:43:40.630658 | Newspaper articles relating to Sir Ross Smith and the 1919 Epic Flight from England to Australia. Da… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34 | 1918-01-01 | 1922-12-31 | Prelude to the epic flight - Excel workbook | https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34/resource/c14475be-f9ad-40e4-9df4-d0434272cd10/download/prelude_to_the_epic_flight.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2019-06-24T02:49:38.311522 | 2019-06-24T02:49:38.229915 | Creative Commons Attribution | |
694 | 694 | Newspaper Articles relating to Sir Ross Smith | State Library of South Australia | State Library of South Australia | 2019-06-24T02:47:32.528709 | 2019-08-29T04:43:40.630658 | Newspaper articles relating to Sir Ross Smith and the 1919 Epic Flight from England to Australia. Da… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34 | 1918-01-01 | 1922-12-31 | The Epic Flight - Excel workbook | https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34/resource/92fb0c0f-6386-4d50-8a0e-2e35638537aa/download/the_epic_flight.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2019-06-24T02:50:54.596657 | 2019-06-24T02:50:54.510632 | Creative Commons Attribution | |
696 | 696 | Newspaper Articles relating to Sir Ross Smith | State Library of South Australia | State Library of South Australia | 2019-06-24T02:47:32.528709 | 2019-08-29T04:43:40.630658 | Newspaper articles relating to Sir Ross Smith and the 1919 Epic Flight from England to Australia. Da… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34 | 1918-01-01 | 1922-12-31 | Death and Funeral | https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34/resource/d7f27906-8703-44f5-921d-a44a1ad75ff8/download/death_and_funeral.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2019-06-24T02:52:04.053446 | 2019-06-24T02:52:03.974282 | 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]);