This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54135 | 54135 | 1934-05-12 | 3 | e | The independence of the Philippines from America. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
54136 | 54136 | 1934-05-12 | 3 | e | Zhang Xiaoxu in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
54147 | 54147 | 1934-05-12 | 6 | e | Australia news/ Trade statistics between China and Australia in the past six years. Bandits fail to rob treasury of the Sydney city council. Visitor talks about modern China on his return. Chinese government entertains Australian trade commissioner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 |
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]);