This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26645 | 26645 | 1912-08-31 | 2 | a | Sydney Nationalist Association's notice about change of its name. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26646 | 26646 | 1912-08-31 | 2 | a-b | Guangdong provincial parliament asks national senate for advice on impeachment of its governor Hu Hanmin. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
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 | |
26648 | 26648 | 1912-08-31 | 2 | c | Vice president orders ban on illegal promotion of donations to saving nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26649 | 26649 | 1912-08-31 | 2 | c | National Association of Donations to Saving Chinese Nation in Nanjing angry of being asked to hand over all donations to financial ministry, instead intending to have a bank to administrate all donations. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26650 | 26650 | 1912-08-31 | 2 | c-d | Beijing army succeeds in maintaining peace in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26651 | 26651 | 1912-08-31 | 2 | d | Several senior army officials appointed. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26652 | 26652 | 1912-08-31 | 2 | d | Detailed amounts of provincial financial contributions to central government. | Other... | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26653 | 26653 | 1912-08-31 | 2 | d | Japan-Russian treaty on invasion of Manchu and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 |
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]);