Article Index

3 rows where date = "1923-05-12" and trove_id = 24094406

Filter results

This data as json, CSV (advanced)

Suggested facets: column

trove_id 1 ✖

  • 24094406 · 3 ✖

date (date) 1 ✖

Link rowid ▼ date page column title description source page_url trove_id
39855 39855 1923-05-12 8 a-d   Guangdong news/ Sun Yatsen moves his headquarters in Guangzhou. Sun Yatsen's headquarters detains an army commander. Shen Hongying's troops detain 13 military officers in Guangdong. Military situation in Xijiang River area. Sun Yatsen sells some agricultural experiment farm. Speaker of the provincial legislature assembly is against Sun Yatsen who is trying to borrow foreign loans. Protest against the kidnap of businessmen in Guangdong. Troops in Guangzhou commit robbery. Liu Zhenhuan's troops and their looting in Dongguan county. Dyke building in Songlong town, of Gaoyao county. Tung Wah http://trove.nla.gov.au/newspaper/page/24094406 24094406
39856 39856 1923-05-12 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094406 24094406
39857 39857 1923-05-12 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094406 24094406

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