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 |
---|---|---|---|---|---|---|---|---|---|
25121 | 25121 | 1911-10-14 | 2 | a | Notice for celebration of Confucius's birthday | Celebration of Confucius's birthday is to be held in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24091956 | 24091956 |
25129 | 25129 | 1911-10-14 | 3 | a | Chinese Navy budget within 7 years | A number of warships are to be built for expanding navy power. | China | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25130 | 25130 | 1911-10-14 | 3 | a | Riots in Shichuan | Riots in Chengdu resulted in huge casualties. | China | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25131 | 25131 | 1911-10-14 | 3 | a | War between Italy and Turkey | Description of battles between Italian troops and Turkish soilders. | Other... | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25146 | 25146 | 1911-10-14 | 7 | a | Call on donations for Anhui flooding | Sydney Empire Constitutional Association calls on donations for Anhui flooding. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25147 | 25147 | 1911-10-14 | 7 | a | Australia news | Australian businessman is well treated in Japan. Labour Party of south Australia wins its parliament majority. Chief of British opium ban association comes to Australia. Newcastle's coal export in September. Federal Foreign Minister passed away. Labour power increases and leads to loss of both labour and capital. A Chinese shop in Melbourne is found doing gambling business. Memorising Confucius birthday in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25158 | 25158 | 1911-10-14 | suppl | a | The seventh attack on East Warning newspaper | Criticising racism revolution of the revolutionary party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091963 | 24091963 |
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]);