1 row where file_description = "This XML file includes data about portraits and the people associated with them (biographical information and video interviews). **Please note** that images referenced in this data are not openly licensed. You may use the URLs supplied to make images appear in your apps but you may not republish them unless your use is non-commercial." and source = "data.gov.au"

View and edit SQL

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

source

  • data.gov.au · 1

format

file_description

  • This XML file includes data about portraits and the people associated with them (biographical information and video interviews). **Please note** that images referenced in this data are not openly licensed. You may use the URLs supplied to make images appear in your apps but you may not republish them unless your use is non-commercial. · 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
656 Portraits and people National Portrait Gallery National Portrait Gallery 2016-07-18T07:18:23.937739 2016-07-20T03:21:12.411631 This data describes around 3000 portraits in the National Portrait Collection and the people associa… data.gov.au https://data.gov.au/dataset/a0acec3b-b034-4bf7-9ed9-1cb70c8559c8 1728-11-07 2016-06-30 Portraits and people https://data.gov.au/data/dataset/a0acec3b-b034-4bf7-9ed9-1cb70c8559c8/resource/368da66e-f5e7-4fac-9022-d79244518919/download/portraitau-20160705.xml XML This XML file includes data about portraits and the people associated with them (biographical inform… 2016-07-19T13:08:41.403842 2016-07-05   Creative Commons Attribution 3.0 Australia

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