This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40877 | 40877 | 1923-12-29 | 8 | a-d | Guangdong news/ A junior officer reports the battle. Army looting near Guangzhou. Many government employees flea to Macao. Zhang Zurong joins Guangdong army. Zheng Runqi leads his army back to Guangdong. Army in the north starts attack on Shixing county. Guangdong army has arrived Huaxian county. The retreat of Guangdong army. Shilong town after being taken over by Guangdong army. Xiangshan people are against the new magistrate Lin Jingchun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 | |
40878 | 40878 | 1923-12-29 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 | |
40879 | 40879 | 1923-12-29 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 |
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]);