This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45421 | 45421 | 1927-01-15 | 2 | e | Yang Yuting on the current situation and the strategies of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24101848 | 24101848 | |
45422 | 45422 | 1927-01-15 | 3 | c | Wu Peifu understands Yang Sen. | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
45423 | 45423 | 1927-01-15 | 3 | c-d | Second part of the open letter issued by commander-in-chief Jiang Jieshi to the nation wide. | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
45424 | 45424 | 1927-01-15 | 3 | d-e | Prominent Guomindang figures arrives Jiangxi province (Song Ziwen, Song Qingling, Yan Mengyu, Sun Ke, and Borodin). | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
45425 | 45425 | 1927-01-15 | 3 | f | Report on the conference in Zhengzhou attended by Qi Xieyuan, Tian Weiqin and others. | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
45429 | 45429 | 1927-01-15 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101849 | 24101849 | |
45431 | 45431 | 1927-01-15 | 8 | a-d | Guangdong news/ Director of the public security bureau in Guangzhou takes over the tap water company. Production resumed at the munitions factory in Guangdong. Jiang Jieshi rebuffs proposal to move the capital of Nationalist government. Civil corps in Luoding. Manslaughter in Gaoyao county. Proposal to close down all private schools in Guangzhou. Bandits in Zengcheng county and their robbery. Clash over the tap water company in Guangzhou. Ban on workers' fighting in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101854 | 24101854 |
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]);