This data as json, CSV (advanced)
Suggested facets: page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31844 | 31844 | 1916-12-30 | 2 | a-c | Editorial by Tung Wah Times on hygiene. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095531 | 24095531 | |
31855 | 31855 | 1916-12-30 | 6 | a-b | Fifth part of the diary written by Wu Guanyin on his service in the army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095535 | 24095535 | |
31857 | 31857 | 1916-12-30 | 7 | a | Australia news/ Federal government is planning to borrow the third internal loans. Show prices are going up in Sydney. Tax applies to theatre tickets in Sydney. New taxes on bank interests and real estate by the federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095534 | 24095534 | |
31859 | 31859 | 1916-12-30 | 7 | c-d | Article by Wan Shengzhong on the growing of roses and grapes (in Australia). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095534 | 24095534 | |
31860 | 31860 | 1916-12-30 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095534 | 24095534 | |
31863 | 31863 | 1916-12-30 | 8 | d-e | Poems by Sun Luzi, Zhan Huanpin, Gui Dongyuan and Huang Tifu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095536 | 24095536 |
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]);