1 row where "end_date" is on date 2014-12-31, file_description = "Data from 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. This data set can also be used in conjunction with Trove [http://trove.nla.gov.au/newspaper?q](http://trove.nla.gov.au/newspaper?q) and the Trove API [http://trove.nla.gov.au/general/api](http://trove.nla.gov.au/general/api). **Explanation of fields** - **RECORD #** : : SLSA unique identifier eg "b2148630x" - **TITLE** : Title of item - **ALT TITLE** : Alternative title of item - **Dates/publication details** : Publication date - **Description/Quantity** : Number of folders containing this ephemera - **SUMMARY** or **HISTORY** : Summary information about the election/referendum for which this ephemera was published - **SUBJECT** : Subject headings assigned by the Library to assist searching; includes names of candidates, political parties and electoral districts - **ADDED NAME** : Additional name subject headings" and format = "CSV"

View and edit SQL

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

source

format

file_description

  • Data from 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. This data set can also be used in conjunction with Trove [http://trove.nla.gov.au/newspaper?q](http://trove.nla.gov.au/newspaper?q) and the Trove API [http://trove.nla.gov.au/general/api](http://trove.nla.gov.au/general/api). **Explanation of fields** - **RECORD #** : : SLSA unique identifier eg "b2148630x" - **TITLE** : Title of item - **ALT TITLE** : Alternative title of item - **Dates/publication details** : Publication date - **Description/Quantity** : Number of folders containing this ephemera - **SUMMARY** or **HISTORY** : Summary information about the election/referendum for which this ephemera was published - **SUBJECT** : Subject headings assigned by the Library to assist searching; includes names of candidates, political parties and electoral districts - **ADDED NAME** : Additional name subject headings · 1

end_date (date)

  • 2014-12-31 · 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
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

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