This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21721 | 21721 | 1909-10-02 | 2 | a-b | Editorial on foreign loans and railway construction in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802344 | 26802344 | |
21726 | 21726 | 1909-10-02 | 3 | a-b | News on the rebuilding of Chinese navy (appointment of commanders, detailed draft plan, naval ports, etc). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802343 | 26802343 | |
21735 | 21735 | 1909-10-02 | 6 | a-b | A recent survey in Manchuria (geography, agriculture, mining resources and others in Heilongjiang province). | Other... | http://trove.nla.gov.au/newspaper/page/26802348 | 26802348 | |
21745 | 21745 | 1909-10-02 | 7 | a-b | Further report on the refusal by Australian federal government to allow the entry of Chinese teacher Lu Yijun from Hong Kong (debate in the Commonwealth parliament and comments by English newspapers). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802347 | 26802347 |
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]);