This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21690 | 21690 | 1909-09-25 | 3 | b | Russian want to occupy Mongolia. German and their ambition in Shandong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802335 | 26802335 | |
21702 | 21702 | 1909-09-25 | 6 | b | The Miao people in Guizhou province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802340 | 26802340 | |
21713 | 21713 | 1909-09-25 | 7 | b | Chinese community in Sydney sets up a Chinese school and invites Lu Yijun from Hong Kong to teach in the school. However the Australian government refuses to issue him visa. And response to this matter by the Chinese communities and English newspapers in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802339 | 26802339 |
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]);