3 rows where dataset_description = "The Tasmanian Index provides references to articles in the three metropolitan Tasmanian newspapers; the Mercury, the Examiner and the Advocate, and to most other Tasmanian journals and regional newspapers. The index was maintained from 1966 to 2010. This online version of the Tasmanian Index covers 1994 to 2010 with approximately 20,771 records. The records from [1966 to 1994](http://stors.tas.gov.au/tascardindex/) are available online as PDF files " and publisher = "Libraries Tasmania"

View and edit SQL

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

format

source

publisher

  • Libraries Tasmania · 3

dataset_description

  • The Tasmanian Index provides references to articles in the three metropolitan Tasmanian newspapers; the Mercury, the Examiner and the Advocate, and to most other Tasmanian journals and regional newspapers. The index was maintained from 1966 to 2010. This online version of the Tasmanian Index covers 1994 to 2010 with approximately 20,771 records. The records from [1966 to 1994](http://stors.tas.gov.au/tascardindex/) are available online as PDF files · 3
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
620 Tasmanian Newspaper Index Libraries Tasmania Libraries Tasmania 2016-04-06T01:52:36.573929 2021-11-02T14:45:50.083300 The Tasmanian Index provides references to articles in the three metropolitan Tasmanian newspapers; … data.gov.au https://data.gov.au/dataset/3e1eb60e-5ad1-4a20-8cb9-32be085e56f0 1994-01-01 2010 Tasmanian Index - CSV https://data.gov.au/data/dataset/3e1eb60e-5ad1-4a20-8cb9-32be085e56f0/resource/973d05c4-2f17-4609-bd98-1b96135d69c4/download/tas_index_marc.csv CSV   2016-04-06T11:53:19.611573 2021-11-02 234815808.0 Creative Commons Attribution 4.0 International
621 Tasmanian Newspaper Index Libraries Tasmania Libraries Tasmania 2016-04-06T01:52:36.573929 2021-11-02T14:45:50.083300 The Tasmanian Index provides references to articles in the three metropolitan Tasmanian newspapers; … data.gov.au https://data.gov.au/dataset/3e1eb60e-5ad1-4a20-8cb9-32be085e56f0 1994-01-01 2010 Tasmanian Index - XML https://data.gov.au/data/dataset/3e1eb60e-5ad1-4a20-8cb9-32be085e56f0/resource/37c714be-8ddd-4069-b131-bda352979a7f/download/tas_index_marc.xml XML   2016-04-06T11:55:56.106172 2021-11-02 564141376.0 Creative Commons Attribution 4.0 International
622 Tasmanian Newspaper Index Libraries Tasmania Libraries Tasmania 2016-04-06T01:52:36.573929 2021-11-02T14:45:50.083300 The Tasmanian Index provides references to articles in the three metropolitan Tasmanian newspapers; … data.gov.au https://data.gov.au/dataset/3e1eb60e-5ad1-4a20-8cb9-32be085e56f0 1994-01-01 2010 Tasmanian Index - JSON https://data.gov.au/data/dataset/3e1eb60e-5ad1-4a20-8cb9-32be085e56f0/resource/f0feae8b-d02a-467c-9329-e37a9c2f38ac/download/tas_index_marc.json JSON   2016-04-06T11:56:33.435970 2021-11-02 364757308.0 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]);