Article Index

6 rows where date = "1899-06-21" and page_url = "http://trove.nla.gov.au/newspaper/page/24102440"

Filter results

This data as json, CSV (advanced)

Suggested facets: column, date (date)

Link rowid ▼ date page column title description source page_url trove_id
2811 2811 1899-06-21 2 a-c   The fourth and final part of a report submitted by Qing Qin Wang.   http://trove.nla.gov.au/newspaper/page/24102440 24102440
2812 2812 1899-06-21 2 c-e   The fourth and final part of an essay on business association and local and national administration.   http://trove.nla.gov.au/newspaper/page/24102440 24102440
2813 2813 1899-06-21 2 e   An article written by Zhu Yutang advising Chinese to quit opium-smoking.   http://trove.nla.gov.au/newspaper/page/24102440 24102440
2814 2814 1899-06-21 2 e-f   Chinese fellow, Yong Li, of Sussex Street, Sydney, was robbed.   http://trove.nla.gov.au/newspaper/page/24102440 24102440
2815 2815 1899-06-21 2 f   More than 200 people die while mining gold in South Africa.   http://trove.nla.gov.au/newspaper/page/24102440 24102440
2816 2816 1899-06-21 2 f   A man from Austria explores Antarctica.   http://trove.nla.gov.au/newspaper/page/24102440 24102440

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
CREATE TABLE [article_index] (
   [date] TEXT,
   [page] TEXT,
   [column] TEXT,
   [title] TEXT,
   [description] TEXT,
   [source] TEXT,
   [page_url] TEXT,
   [trove_id] TEXT
);
CREATE INDEX [idx_article_index_date]
    ON [article_index] ([date]);