This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21687 | 21687 | 1909-09-25 | 2 | d | Beijing news/ Duan Fang and his political proposal. China to purchase speedboat from America. Negotiation and agreement between Japan and China on the Changchun railroad. Transportation network designed for Manchuria and Mongolia. Government departments in Beijing to be reshuffled. | China | http://trove.nla.gov.au/newspaper/page/26802336 | 26802336 | |
21699 | 21699 | 1909-09-25 | 3 | d | Chinese graduates from Japanese university and other educational institutions. | Japan | http://trove.nla.gov.au/newspaper/page/26802335 | 26802335 | |
21700 | 21700 | 1909-09-25 | 3 | d | A notice issued by Chinese consulate in Melbourne on the fair that to be held in Nanjing next May. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802335 | 26802335 | |
21716 | 21716 | 1909-09-25 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802339 | 26802339 | |
21720 | 21720 | 1909-09-25 | 8 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802342 | 26802342 |
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]);