This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31038 | 31038 | 1916-03-18 | 2 | d-e | Tang Jiyao cables to various provinces in China that all Chinese should oppose imperial system and defend republicanism. | China | http://trove.nla.gov.au/newspaper/page/24095195 | 24095195 | |
31047 | 31047 | 1916-03-18 | 3 | d-e | Battle situation in west Europe between the Ally and German-Austrian troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095194 | 24095194 | |
31057 | 31057 | 1916-03-18 | 8 | d-e | Wing On & Company in Hong Kong raises more funds by floating shares and its notice, signed by Guo Le, Guo Quan, Yang Huiting, Du Zewen, Li Gen, Lin Zesheng, Li Yanxiang, Sun Zhixing, Yang Jinhua and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095200 | 24095200 |
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]);