Article Index

3 rows where date = "1923-01-13" and trove_id = 24094258

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
39282 39282 1923-01-13 8 a-d   Guangdong news/ Sun Yatsen's troops return to Guangdong. Guangdong army in Guangxi and their defence plan. Report from the frontline in Guangxi. Guangdong governor Chen Xiru wants to conclude the negotiation with Portuguese authority for the Macao issues. Wong Shiliang is training his troops in Chaozhou. Ammunition factory is to resume production in Zhaoqing. Journalism association to be set up in Guangzhou. Chen Jiongming to ban opium smoking and gambling in the counties. News from Fujian province. A Portuguese ship is hijacked near Macao and the solution. Robbery in Xiangshan county. A martial arts girl beats three young men. Tung Wah http://trove.nla.gov.au/newspaper/page/24094258 24094258
39283 39283 1923-01-13 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094258 24094258
39284 39284 1923-01-13 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094258 24094258

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