glam-datasets

1 row where dataset_description = "This dataset tells fascinating stories drawn from treasures of the National Archives collection - http://naa.gov.au/visit-us/exhibitions/memory-of-a-nation/interactive.aspx The dataset includes a digitised version of every original item that has been put on display in the Archives’ permanent exhibition Memory of a Nation, from its launch in 2007 through to the present day. This includes an original musical score of Waltzing Matilda, a petition for Aboriginal land rights from the Larrakia people of Darwin, and Charles Kingsford Smith’s 1921 application for a pilot’s licence. The dataset covers around 500 record items (eg. a file, object or photograph in the NAA collection). Examples of content - http://naa.gov.au/visit-us/exhibitions/memory-of-a-nation/index.aspx Record Item data fields include • Theme • Subtheme • Title • Keyword tags (names, places, government activities), • Short description • Long description • More info • Year (of record) • Series number (note: a series is a group of records that has resulted from the same filing process), • Control symbol and barcode (record item reference numbers) • Collection (i.e. the government agency or person that created the series) • Format (for example, photograph, letter, bound volume, plan, film, etc.) • File name for scanned images • Number of images • Notes • Digitised and Folio / page number " and publisher = "National Archives of Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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