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 |
---|---|---|---|---|---|---|---|---|---|
31063 | 31063 | 1916-03-25 | 3 | c | Protect the Nation Army (Hu guo jun) in Yunnan province and their moves. | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31069 | 31069 | 1916-03-25 | 6 | c | Monster of Dictatorship writes to the Soul of Republic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095207 | 24095207 | |
31070 | 31070 | 1916-03-25 | 6 | c | Poems by Shuquan and Suiting (anonymous authors). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095207 | 24095207 | |
31073 | 31073 | 1916-03-25 | 7 | c | Miscellaneous reports on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31075 | 31075 | 1916-03-25 | 7 | c | A notice issued by the Wing On Insurance Company in Hong Kong on its branches and managers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31078 | 31078 | 1916-03-25 | 8 | c | 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/24095208 | 24095208 | |
31079 | 31079 | 1916-03-25 | 8 | c | Mails for pickup at the Tung Wah Times. Names listed. | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 |
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]);