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 |
---|---|---|---|---|---|---|---|---|---|
36523 | 36523 | 1921-01-22 | 2 | c-d | Chinese government seeks approval from foreign governments in order to impose surtax to the current customs duties. | China | http://trove.nla.gov.au/newspaper/page/24093402 | 24093402 | |
36524 | 36524 | 1921-01-22 | 2 | d | Loss caused by the mutiny in Yichang, Hubei province, and warning from Japanese ambassador in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093402 | 24093402 | |
36526 | 36526 | 1921-01-22 | 2 | d-e | Chinese government borrows another 5 million domestic loans. | China | http://trove.nla.gov.au/newspaper/page/24093402 | 24093402 | |
36527 | 36527 | 1921-01-22 | 2 | e | Racial relations between Muslims and Han people in Gansu province and the local administration. | China | http://trove.nla.gov.au/newspaper/page/24093402 | 24093402 | |
36529 | 36529 | 1921-01-22 | 3 | a | The Guangdong military government, under Sun Yatsen, Tang Shaoyi, Wu Tingfang and Tang Jiyao, issues open telegram to the nation, and makes appointment of government officials (Sun Yatsen, Tang Shaoyi, Tang Jiyao, Chen Jiongming, Wu Tingfang, Xu Qian, Li Liejun, and Ma Junwu). | China | http://trove.nla.gov.au/newspaper/page/24093401 | 24093401 | |
36530 | 36530 | 1921-01-22 | 3 | a-b | Guangdong military government prepares for another expedition to Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24093401 | 24093401 | |
36531 | 36531 | 1921-01-22 | 3 | b | Li Houji's reason and plan for his north expedition. | China | http://trove.nla.gov.au/newspaper/page/24093401 | 24093401 |
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]);