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 |
---|---|---|---|---|---|---|---|---|---|
45514 | 45514 | 1927-03-05 | 2 | d | Belgium return the concession in Tianjin to China, and China's preparation for the take-over. | China | http://trove.nla.gov.au/newspaper/page/24101900 | 24101900 | |
45515 | 45515 | 1927-03-05 | 2 | f | The draft outline issued by Wu Peifu for the nation building in China. | China | http://trove.nla.gov.au/newspaper/page/24101900 | 24101900 | |
45516 | 45516 | 1927-03-05 | 3 | e | Investigation on the loss of treasuries from the Forbidden City in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101899 | 24101899 | |
45517 | 45517 | 1927-03-05 | 3 | f | Chen Youren talks to Western journalist on the revolutionary movement in China. | China | http://trove.nla.gov.au/newspaper/page/24101899 | 24101899 | |
45518 | 45518 | 1927-03-05 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101901 | 24101901 | |
45520 | 45520 | 1927-03-05 | 7 | b | Shanghai commercial chamber seeks to host the exhibition of Chinese Republic. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45521 | 45521 | 1927-03-05 | 7 | b | Foreign banks in Guangzhou and their profit. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45522 | 45522 | 1927-03-05 | 7 | b | Zhang Xueliang on the case of Hankou and Jiujiang. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45523 | 45523 | 1927-03-05 | 7 | c | The International Air Safety Committee. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45529 | 45529 | 1927-03-05 | 8 | a-d | Guangdong news/ Li Fulin personally leads his troops to attack Yunnan province. Saint Heart School in Guangzhou is required to teach the Three People's Principles (Nationalism, Democracy and the People's Livelihood) and resistance. University of Hong Kong to teach Chinese literature. People are frozen to death in Guangzhou. The kidnap of Liang Peiji and the investigation. Racing course to be built in Guangzhou. Peasants' association in Dongguan county detains the government officials. Kidnap in Xiangshan county. Land Bureau on the amount of tax to be collected. Bandits in the Beijiang area. | China | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 |
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]);