This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22205 | 22205 | 1910-01-01 | 6 | a-b | An open letter from The Chinese Association in Wellington, New Zealand, to Mr Liu and Mr Lu of Melbourne in regards to the history of Chinese communities and The Chinese Association (zhong hua hui guan) in New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802452 | 26802452 | |
22206 | 22206 | 1910-01-01 | 6 | b | The truth about the border of Macao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802452 | 26802452 | |
22207 | 22207 | 1910-01-01 | 6 | b-c | A report from London claims that Prince Regent is assassinated by revolutionaries from the south, however, Chinese consulate in Melbourne says it is not true. | Britain | http://trove.nla.gov.au/newspaper/page/26802452 | 26802452 | |
22208 | 22208 | 1910-01-01 | 6 | c | Chinese students in Japan discuss to save China. | Japan | http://trove.nla.gov.au/newspaper/page/26802452 | 26802452 |
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]);