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 |
---|---|---|---|---|---|---|---|---|---|
33235 | 33235 | 1918-05-04 | 2 | a-c | Fifth part of Kang Youwei's article on the Chinese Republic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097272 | 24097272 | |
33249 | 33249 | 1918-05-04 | 6 | c | How to know the poisonous mushroom, written by Mao Fuquan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097276 | 24097276 | |
33250 | 33250 | 1918-05-04 | 7 | b-c | Australia news/ Chinese Chamber of Commerce in Sydney meets for disaster relief in China. Who is responsible for the loss of mails in the Sydney Post Office. Sale of the Sixth War Loan concludes. Fundraising for the Red Cross in Sydney and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097275 | 24097275 | |
33253 | 33253 | 1918-05-04 | 7 | d | A mysterious animal in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097275 | 24097275 | |
33254 | 33254 | 1918-05-04 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097275 | 24097275 | |
33255 | 33255 | 1918-05-04 | 8 | a | Chinese communities in Sydney donate to the disaster relief in Guangdong and Fujian (earthquake), and Zhili and Fengtian (floods), names listed for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097279 | 24097279 |
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]);