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 |
---|---|---|---|---|---|---|---|---|---|
34443 | 34443 | 1919-05-03 | 2 | d-f | The secret treaty between China and Japan is released for the first time. | China | http://trove.nla.gov.au/newspaper/page/24097702 | 24097702 | |
34444 | 34444 | 1919-05-03 | 2 | f | Report on the peace talks in Shanghai between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097702 | 24097702 | |
34445 | 34445 | 1919-05-03 | 3 | a | English Times in Beijing and Tianjin reveals the alliance of Japan and Germany. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34446 | 34446 | 1919-05-03 | 3 | b-c | Korean people and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34447 | 34447 | 1919-05-03 | 3 | d | Chinese labourers in France and their return to China. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34462 | 34462 | 1919-05-03 | 8 | a-b | Beijing news/ Conflict between the Chinese cabinet and the navy. Naval commander Sa Zhenbing is leaving for Europe. Chinese foreign ministry replies to ambassadors of Britain, America, France and Italy in Beijing. Zhang Qian writes to President Xu Shichang and requests to ban constitutional reform organisations. Air mail service between Beijing and Shanghai. Brazil to recruit some Chinese farmers. Chinese tea may have ready market in Europe. | China | http://trove.nla.gov.au/newspaper/page/24097708 | 24097708 | |
34463 | 34463 | 1919-05-03 | 8 | b-c | Guangdong news/ Road construction in Guangzhou. Preparation for the opening of the second provincial legislature. Rice price continues going down. Many people donate to the famine victims in Guangdong. Rice market in Dongguan county. Bandits in Dongguan. Bandits in Yangshan county. | China | http://trove.nla.gov.au/newspaper/page/24097708 | 24097708 |
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]);