This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43324 | 43324 | 1925-06-13 | 3 | a | Wu Peifu's eight capable persons are under investigation for their involvement in bribery and their personal properties are confiscated. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43325 | 43325 | 1925-06-13 | 3 | a | Chinese delegates to the Pacific Conference include Yan Yangchu, Ma Yanchu, Hu Shi, and some others. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43326 | 43326 | 1925-06-13 | 3 | a-b | China and Peru resume their treaty talks and the treatment of Chinese residents in Peru. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43327 | 43327 | 1925-06-13 | 3 | b | Puyi is to move out Zhang Yuan in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43328 | 43328 | 1925-06-13 | 3 | b | Guangdong people in Beijing are against the appointment of eight civil administrators for the eight divided Guangdong regions. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43329 | 43329 | 1925-06-13 | 3 | b-c | Earth wall in Beijing is auctioned, which belongs to Princess Xiao hundreds of years ago. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43330 | 43330 | 1925-06-13 | 3 | c | Telegrams to Tang Jiyao from Xiong Kewu, Li Liejun and Lin Junting. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43331 | 43331 | 1925-06-13 | 3 | c | Zhou Yinren tries to retain Sa Zhenbing in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43332 | 43332 | 1925-06-13 | 3 | c | Liu Houwu, representative of the Chinese communities in Vietnam and Thailand, has arrived in Beijing and his contact with government authorities. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43333 | 43333 | 1925-06-13 | 3 | c-d | Chinese in Japan are murdered during the disaster relief after the earthquake and the investigation. | Japan | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 |
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]);