This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24694 | 24694 | 1911-07-15 | 2 | a-b | On protection of ancient official buildings | Ancient official buildings in China should be protected. | Other... | http://trove.nla.gov.au/newspaper/page/24091843 | 24091843 |
24703 | 24703 | 1911-07-15 | 3 | a-b | Riots in Morocco | Several nations such as Germany and France have sent their troops to Morocco due to riots there. | Other... | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
24714 | 24714 | 1911-07-15 | 6 | a-b | Donations and anniversary celebration | More than 50 names listed who made donations to those massacred in Mexico and Sydney Association for Imperial Constitution held a celebration its anniversay. | Other... | http://trove.nla.gov.au/newspaper/page/24091847 | 24091847 |
24716 | 24716 | 1911-07-15 | 7 | a-b | Australian news | The banana battle between Queensland and Fiji. Chinese Consul-General to Australia wrote to Governor General for congratulation of British coronation. Australia restricts coloured people's entry into Australia. Proposal for universalisation of education in New South Wales. Federal parliament closes its meeting. Western Australia welcomes European migrants. An Australian woman suicided. A note by Chinese consulate to Britain about the fourth agricultural fair. A list of students who got excellent results in the first semester of second academic year from Sydney Chinese Primary School. They include Li Sihua, Situ Xuanrong, Ma Xuanli, Huang Liuying, Zhan Zhuoying, Ye Sihao, Huang Hongle, Ma Antu, Feng Xiuzhen, Guo Dihuo, Chen Shikui, Ye Yuezu, Situ Fengliang, Huang Hua, Huang Zhaoji and Cao Fenglan. | Other... | http://trove.nla.gov.au/newspaper/page/24091846 | 24091846 |
24717 | 24717 | 1911-07-15 | 8 | a-b | Mr Liang Rengong's response | Mr Liang Rengong replies to a recent attack on him. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091849 | 24091849 |
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]);