This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12119 | 12119 | 1903-08-15 | 2 | a | Second and final part of an article claiming Manchuria's problems stem from the Manchu dynasty, not Russia's presence in the region. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800273 | 26800273 | |
12120 | 12120 | 1903-08-15 | 2 | a | Talks between Empress Dowager and ministers on imperial examination, modern education, and overseas students. | China | http://trove.nla.gov.au/newspaper/page/26800273 | 26800273 | |
12121 | 12121 | 1903-08-15 | 2 | a | Zhang Baixi and Zhang Zhidong talk on Beijing University, modern education, students' strike, and the imperial examination. | China | http://trove.nla.gov.au/newspaper/page/26800273 | 26800273 | |
12127 | 12127 | 1903-08-15 | 3 | a | Chinese students in Japan sent their representatives to ask for battle assignment from Yuan Shikai in Tianjin but was refused. | China | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12128 | 12128 | 1903-08-15 | 3 | a | Bandits loot the Summer Palace. | China | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12129 | 12129 | 1903-08-15 | 3 | a | President Roosevelt of America is seeking another term of office. | America | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12130 | 12130 | 1903-08-15 | 3 | a | British Prime Minister has withdrew from politics and now living in seclusion. | Britain | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12131 | 12131 | 1903-08-15 | 3 | a | Chinese student Wang Chonghui was admitted to the degree of Master of Law in Yale University, Zhang Yuquan bachelor's degree. | America | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 |
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]);