This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34914 | 34914 | 1919-09-20 | 8 | a | Poems by Zhen Shengli and Wu Tongbo. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097874 | 24097874 | |
34915 | 34915 | 1919-09-20 | 8 | a-b | Guangdong news/ Chinese communities in the Philippines recommend Wu Tingfang. Charity institutions in Guangdong recommend Long Jianzhang. Prices of vegetable oil are going up. Association set up by fabric merchants. Commercial chambers request to ban rice export. Mo Rongxin orders to suppress bandits. | China | http://trove.nla.gov.au/newspaper/page/24097874 | 24097874 | |
34916 | 34916 | 1919-09-20 | 8 | d | Liner timetable to Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097874 | 24097874 | |
34917 | 34917 | 1919-09-20 | 8 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097874 | 24097874 |
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]);