This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26647 | 26647 | 1912-08-31 | 2 | b-c | Several President Yuan's orders about keeping good relations with neighbouring nations, unity of various political organisations, appointments of new governors including Li Yuanhong as Hubei governor, approval of Xiong Xiling's resign as financial minister, Wang Conghui as justice chief, Cai Yuanpei as education minister, Song Jiaoren as agriculture minister, Wang Zhengting as industry and commerce minister and new appointments of Zhao Bingjun as financial minister, Zhang Xinwu as industry and commerce minister. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26668 | 26668 | 1912-08-31 | 3 | b-c | British adviser to Chinese president writes to British The Times newspaper about his views on recent happenings in China. | Britain | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 | |
26673 | 26673 | 1912-08-31 | 6 | b-c | Other parts of Guomin Gongbao (National Newspaper) comments on China's political parties. | Other... | http://trove.nla.gov.au/newspaper/page/24092364 | 24092364 | |
26676 | 26676 | 1912-08-31 | 7 | b-c | More than 200 names listed for their donations to saving Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092363 | 24092363 |
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]);