This data as json, CSV (advanced)
Suggested facets: column, date (date)
page_url 1 ✖
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 |
JSON shape: default, array, newline-delimited
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]);