6 rows where file_description = "" and format = "ZIP"

View and edit SQL

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

file_modified (date)

format

file_description

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
563 National Library of Australia Sheet Music collection National Library of Australia National Library of Australia 2013-05-12T08:15:33.163142 2015-03-07T09:32:57.119742 The National Library of Australia Sheet Music collection includes printed music created by Aus… data.gov.au https://data.gov.au/dataset/c53ab05a-03f8-4414-9f31-68359e8ebdac 1800-2002   nla-sheet-music-collection-2013-01-16.zip http://data.gov.au/storage/f/2013-05-12T181502/tmphjqDQwnla-sheet-music-collection-2013-01-16.zip ZIP   2013-05-12T08:15:55.459229   13649039.0 Creative Commons Attribution 3.0 Australia
564 Journal of the H.M.S. Endeavour, 1768-1771 National Library of Australia National Library of Australia 2013-05-12T09:50:02.783472 2015-03-07T09:32:18.214501 James Cook was born in 1728 in Yorkshire. Apprenticed to a coal shipper in Whitby he began to … data.gov.au https://data.gov.au/dataset/7f03ac78-7210-4702-8cd5-f3e373f4097b 1768-1771   endeavour-journal.zip http://data.gov.au/storage/f/2013-05-12T194932/tmpeCKIYWendeavour-journal.zip ZIP   2013-05-12T09:50:10.709889   941044.0 Creative Commons Attribution 3.0 Australia
565 Picture Australia metadata National Library of Australia National Library of Australia 2013-05-12T09:30:42.974512 2015-03-07T09:30:46.559457 [Picture Australia](http://www.pictureaustralia.org) is an Internet based service that allows … data.gov.au https://data.gov.au/dataset/86bb09b6-acc9-4666-b464-9cf3fe59080b Not specified   picture-australia.zip http://data.gov.au/storage/f/2013-05-12T193018/tmpGGITPopicture-australia.zip ZIP   2013-05-12T09:35:22.997881 2013-05-12 216396788.0 notspecified
1189 Unassisted Inward Passengers 1852-1923 Public Records Office Victoria   2020-10-27T07:29:15.762164 2020-10-27T07:29:15.762170 Our shipping list data is a great place to start when searching for a family member who may have arr… data.vic.gov.au https://www.data.vic.gov.au/data/dataset/f71a0ad2-27a2-40ee-9595-742245f1752d     Unassisted Inward Passengers 1852-1923 http://metadata.prov.vic.gov.au/datasets/2020/Unassisted%20Inward%20Passengers%201852-1923.7z ZIP   2020-10-27T00:59:44.316551     Creative Commons Attribution 4.0 International
1190 Outwards Passengers from Victoria 1852-1915 Public Records Office Victoria   2014-08-01T05:02:55.815527 2016-03-08T06:58:34.851050 The data includes the name and age of the passenger, name of the ship and captain, date of arrival, … data.vic.gov.au https://www.data.vic.gov.au/data/dataset/9ae281eb-d3f5-4738-98ef-44976e980eb5     Outwards Passengers from Victoria 1852-1915 https://discover.data.vic.gov.au/dataset/9ae281eb-d3f5-4738-98ef-44976e980eb5/resource/a7e4f8e2-5cfe-4548-8dfa-755591b9eade/download/outwardspassengers18521915.zip ZIP   2014-08-01T15:13:21.157009 2019-04-27T01:55:00.185559   Creative Commons Attribution 4.0 International
1191 British Assisted Passengers to Victoria 1839-1871 Public Records Office Victoria   2014-08-01T05:02:39.395392 2016-03-07T10:21:09.161420 The data includes the name and age of the passenger, name of the ship and captain, date of arrival, … data.vic.gov.au https://www.data.vic.gov.au/data/dataset/1bcc6d77-d223-4a26-83c2-2f8b6325af50     British Assisted Passengers to Victoria 1839-1871 https://discover.data.vic.gov.au/dataset/1bcc6d77-d223-4a26-83c2-2f8b6325af50/resource/83ee19af-0655-45b9-bc5d-68144a8b58de/download/assistedbritishpassengers18391871.zip ZIP   2014-08-01T15:02:54.869800 2019-04-27T01:53:45.708359   Creative Commons Attribution 4.0 International

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