Article Index

3 rows where date = "1923-05-19" and trove_id = 24094414

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
39881 39881 1923-05-19 8 a-d   Guangdong news/ Sun Yatsen orders to collect extra taxes for military purpose. Business in panic in Guangzhou. Shen Hongying sends niece to pay homage at his ancestor's mausoleum in Enping county, Guangdong. Education association in Guangzhou protests against the sale of school campus, and Chen Shuren demands an investigation from Sun Yatsen. A high school in Zhaoqing is set on fire. Liu Minwei and other Nationalist Party members condemn the sale of public property. Authorities in Guangzhou sell public farm and other properties. Sun Yatsen borrows loans from Hong Kong businessmen and the mortgage. Troops sell school facilities in Guangzhou. Gentry in Dongguan organise civil corps. Army robbery in Enping county. Tung Wah http://trove.nla.gov.au/newspaper/page/24094414 24094414
39882 39882 1923-05-19 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094414 24094414
39883 39883 1923-05-19 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094414 24094414

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