This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35814 | 35814 | 1920-06-19 | 2 | a-c | Editorial by Tung Wah Times on the collapse of the Guangdong military government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098202 | 24098202 | |
35829 | 35829 | 1920-06-19 | 6 | a-c | Second part of travel notes to the Blue Mountain in New South Wales, written by Guo Jianying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098206 | 24098206 | |
35835 | 35835 | 1920-06-19 | 8 | a-c | Guangdong news/ China navy and the exercise. Provincial government asks the Beijing government to pay the provisions. Protest against the poultry tax in Guangzhou. Efforts to suppress bandits in Guangdong. Wu Tingfang is removed from his current position. Bandits in Xinxing county. | China | http://trove.nla.gov.au/newspaper/page/24098209 | 24098209 |
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]);