This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37665 | 37665 | 1921-10-08 | 2 | b-c | Editorial on the war between Hunan and Hubei and its relations to the united provincial self-government (lian sheng zi zhi). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093711 | 24093711 | |
37669 | 37669 | 1921-10-08 | 3 | b-c | Miscellaneous report on the war between Hunan and Hubei. | China | http://trove.nla.gov.au/newspaper/page/24093710 | 24093710 | |
37678 | 37678 | 1921-10-08 | 6 | b-c | My view on overseas Chinese, written by Wen Si (anonymous author). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093715 | 24093715 | |
37693 | 37693 | 1921-10-08 | 8 | b-c | Guangdong news/ Guangdong military officer talks about Guangxi situations on his return. Sun Yatsen might appoint Ma Yuhang governor of Guangdong. Government security guards ransack school principal's house in Guangzhou. Engineers association in Guangzhou fights for their rights. Business groups to be organised in Zhaoqing. Nanhai county authority executes bandits. Qiu Yaoxi and his troops return to Zhaoqing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093717 | 24093717 |
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]);