6 rows where dataset_description = "365 catalogue records including material that has been collected from Local, State and Federal elections related to South Australian candidates. Also includes State and Federal referendums; Local elections 1879 – 2010; State elections 1893 – 2014; Federal elections 1901 – 2010; Referendums 1911 – 1999; State referendums 1965, 1970, 1982. Includes details of candidates, electorates, dates of elections, slogans. Ephemera are everyday items such as theatre posters and advertising flyers, not produced for sale. Their intrinsic value is in the information they provide about social life, the development of industries (for example, printing or paper making), and the provision of services or aspects of cultural change. Ephemera may be the only printed record of an organisation, event or activity. ", "end_date" is on date 2014-12-31 and format = "CSV"

View and edit SQL

Suggested facets: file_title, file_description, file_modified, file_size, dataset_issued (date), dataset_modified (date), start_date (date), file_created (date), file_modified (date)

source

format

end_date (date)

  • 2014-12-31 · 6

dataset_description

  • 365 catalogue records including material that has been collected from Local, State and Federal elections related to South Australian candidates. Also includes State and Federal referendums; Local elections 1879 – 2010; State elections 1893 – 2014; Federal elections 1901 – 2010; Referendums 1911 – 1999; State referendums 1965, 1970, 1982. Includes details of candidates, electorates, dates of elections, slogans. Ephemera are everyday items such as theatre posters and advertising flyers, not produced for sale. Their intrinsic value is in the information they provide about social life, the development of industries (for example, printing or paper making), and the provision of services or aspects of cultural change. Ephemera may be the only printed record of an organisation, event or activity. · 6
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
784 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Leaflets https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651/resource/3f49252e-c441-4c31-b07f-031f48c75d8e/download/electionleaflets.csv CSV Data from catalogue records including material that has been collected from Local, State and Federal… 2016-07-01T15:36:56.482319 2016-07-01T05:36:56.339912   Creative Commons Attribution
785 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Posters https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651/resource/c57266e9-dfa6-4dd9-ba56-2be792d252b4/download/electionposters.csv CSV Data from catalogue records including material that has been collected from Local, State and Federal… 2016-07-01T15:43:56.445420 2016-07-01T05:43:56.259717   Creative Commons Attribution
786 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Leaflets https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651/resource/92abbc3b-955c-44d5-8b73-f5eb5790198a/download/electionleaflets.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T13:11:56.216154     Creative Commons Attribution
787 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Posters https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651/resource/03a27394-2d6c-4c22-b5e6-362f7f122ec6/download/electionposters.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T13:13:24.709727     Creative Commons Attribution
788 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Leaflets https://data.sa.gov.au/data/storage/f/2014-07-03T01%3A16%3A33.173Z/2014electionleaflets.csv CSV Compiled 2013. This data set has been superseded by an updated version at the top of this Data and R… 2013-05-08T22:21:11.961760 2014-10-30T09:01:31 293099.0 Creative Commons Attribution
789 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Posters https://data.sa.gov.au/data/storage/f/2014-07-03T01%3A17%3A37.439Z/2014electionposters.csv CSV Compiled 2013. This data set has been superseded by an updated version above this in the Data and Re… 2013-05-08T22:22:32.329121 2014-10-30T09:01:05 88931.0 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]);