This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28794 | 28794 | 1914-05-09 | 2 | a-b | Kang Youwei is planning to tour Japan once again and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093102 | 24093102 | |
28801 | 28801 | 1914-05-09 | 3 | a-b | A visitor to Taiwan talks about the conquered nation (the people, Japan's administration, and others) on his return. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28814 | 28814 | 1914-05-09 | 6 | a-b | News in brief/ Sun Baoqi suggests to set up more consular offices overseas. China to compensate foreign countries for their loss during the Revolution. The cabinet meeting in Beijing. Some people in Hong Kong recommend Kang Youwei to be the President of China. President Yuan Shikai suggests to revise the provisional constitution. | China | http://trove.nla.gov.au/newspaper/page/24093106 | 24093106 |
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]);