data

Custom SQL query returning 6 rows (show)

Query parameters

rowiddataset_titlepublisherauthordataset_issueddataset_modifieddataset_descriptionsourceinfo_urlstart_dateend_datefile_titledownload_urlformatfile_descriptionfile_createdfile_modifiedfile_sizelicence
691 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. 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*. 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 https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34/resource/b23219af-64ca-4e26-8342-68f9ed3454e8/download/prelude_to_the_epic_flight.csv CSV 23 articles **Explanation of fields** - **Heading** : Article heading - **Category** : Trove's categorisation of the type of newspaper content - **Title** : Newspaper title - **Page** : The number of the page on which the article appears - **Date** : Publication date - **TroveUrl** : URL of the article - **TrovePageUrl** : URL of the entire page containing the article - **Illustrated** : Yes or no - **WordCount** : Number of words in the article - **Relevance** : Trove's ranking of the article's relevance to the search term 'Ross Smith' 2019-06-24T02:48:58.462035 2019-06-24T02:48:58.400413   Creative Commons Attribution
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. 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*. 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 active hyperlinks. 2019-06-24T02:49:38.311522 2019-06-24T02:49:38.229915   Creative Commons Attribution
693 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. 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*. 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 https://data.sa.gov.au/data/dataset/1338ff17-9b2f-43b9-ae6c-711fc3644d34/resource/9ee013bb-ae93-4de8-99ed-74f75aab74c5/download/the_epic_flight.csv CSV 856 articles **Explanation of fields** - **Heading** : Article heading - **Category** : Trove's categorisation of the type of newspaper content - **Title** : Newspaper title - **Page** : The number of the page on which the article appears - **Date** : Publication date - **TroveUrl** : URL of the article - **TrovePageUrl** : URL of the entire page containing the article - **Illustrated** : Yes or no - **WordCount** : Number of words in the article - **Relevance** : Trove's ranking of the article's relevance to the search term 'Ross Smith' 2019-06-24T02:50:14.529743 2019-06-24T02:50:14.463004   Creative Commons Attribution
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. 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*. 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 active hyperlinks. 2019-06-24T02:50:54.596657 2019-06-24T02:50:54.510632   Creative Commons Attribution
695 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. 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*. 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/cd19b95a-093f-453a-b3a0-42427e231486/download/death_and_funeral.csv CSV 336 articles **Explanation of fields** - **Heading** : Article heading - **Category** : Trove's categorisation of the type of newspaper content - **Title** : Newspaper title - **Page** : The number of the page on which the article appears - **Date** : Publication date - **TroveUrl** : URL of the article - **TrovePageUrl** : URL of the entire page containing the article - **Illustrated** : Yes or no - **WordCount** : Number of words in the article - **Relevance** : Trove's ranking of the article's relevance to the search term 'Ross Smith' 2019-06-24T02:51:27.130577 2019-06-24T02:51:27.061884   Creative Commons Attribution
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. 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*. 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 active hyperlinks. 2019-06-24T02:52:04.053446 2019-06-24T02:52:03.974282   Creative Commons Attribution