This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43356 | 43356 | 1925-06-20 | 3 | a-b | China and Japan reach agreement on cultural exchange in the future. | China | http://trove.nla.gov.au/newspaper/page/24101173 | 24101173 | |
43357 | 43357 | 1925-06-20 | 3 | b-c | Liu Chengyu questions Zou Lu on the bribery issues. | China | http://trove.nla.gov.au/newspaper/page/24101173 | 24101173 | |
43358 | 43358 | 1925-06-20 | 3 | c | The Nationalist Party (Guomindang) to have a national conference in Beijing by August (and involvement by Yu Youren, Li Liejun, Ding Shude, Zou Lu, Dai Jitao, Wang Jingwei, Wu Zhihui, Liu Mengshuo, Shi Qingyang, Wang Faqin and others). | China | http://trove.nla.gov.au/newspaper/page/24101173 | 24101173 | |
43359 | 43359 | 1925-06-20 | 3 | c | Wu Peifu is inflicted by mysterious disease. | China | http://trove.nla.gov.au/newspaper/page/24101173 | 24101173 | |
43360 | 43360 | 1925-06-20 | 3 | c | Buddhist leader from Japan comes to visit Panchen Lama in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101173 | 24101173 | |
43361 | 43361 | 1925-06-20 | 3 | c | Panchen Lama arrives Shanghai and will visit Putuo Mountain in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24101173 | 24101173 |
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]);