This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40844 | 40844 | 1923-12-29 | 2 | a-b | Editorial on the dead end of Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
40872 | 40872 | 1923-12-29 | 7 | b-c | Miscellaneous report on the visit and match of Chinese football team in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40873 | 40873 | 1923-12-29 | 7 | c | A report from Zengcheng county on the war between Chen Jiongming and Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40876 | 40876 | 1923-12-29 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
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]);