This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
26669 | 26669 | 1912-08-31 | 3 | c | Beijing news/ British diplomat prosecutes Sun Yat-sen for defamation. Qing imperial family members and education minister plan to build huge library. Financial minister decides to reform financial system. Senate investigates impeachment of governors. Sichuan army wins over Tibetan troops. Russia intends to add more troops in Xinjiang. Nanjing army regiment disposed. Korean intends to assassinate Japanese foreign minister on his visit to northern China. | Other... | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 | |
26677 | 26677 | 1912-08-31 | 7 | c | Tung Wah Times receives donations to floods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092363 | 24092363 | |
26678 | 26678 | 1912-08-31 | 7 | c | Donations to floods in Guangdong from Su Yinfang, Zheng Shou, Su Chaofan, Ouyang Ruqiao. | 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]);