Article Index

5 rows where "date" is on date 1928-05-26 and page_url = "http://trove.nla.gov.au/newspaper/page/24098818"

Filter results

This data as json, CSV (advanced)

Suggested facets: column, source, date (date)

Link rowid ▼ date page column title description source page_url trove_id
47059 47059 1928-05-26 2 b   Second and final part of the article written by He Peiyu on Confucianism and its relations with the current world. Tung Wah http://trove.nla.gov.au/newspaper/page/24098818 24098818
47060 47060 1928-05-26 2 c   Army commanders and soldiers issues a circular telegram on the current situation in China and their hope. China http://trove.nla.gov.au/newspaper/page/24098818 24098818
47061 47061 1928-05-26 2 e   Soviet Russia and its economic invasion in Mongolia. China http://trove.nla.gov.au/newspaper/page/24098818 24098818
47062 47062 1928-05-26 2 f   Japan's administration in Korea, Manchuria and Mongolia. China http://trove.nla.gov.au/newspaper/page/24098818 24098818
47063 47063 1928-05-26 2 f   Protest from the Beijing government against the Japanese troops sent to Shandong. China http://trove.nla.gov.au/newspaper/page/24098818 24098818

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