This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36303 | 36303 | 1920-11-20 | 2 | a-b | Mo Rongxin leaves the office of Guangdong military governor after being paid 2 million dollars and the comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098387 | 24098387 | |
36323 | 36323 | 1920-11-20 | 7 | a-b | Australia news/ A Chinese is beaten in Alexandria, Sydney. Former American consul to Shanghai talks in Sydney. An attempt to rape on the Sydney train. Baby girl found abandoned in Darlinghurst, Sydney. Chinese is detained for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098390 | 24098390 | |
36328 | 36328 | 1920-11-20 | 8 | a-b | Chinese communities throughout Australia donate to famine victims in north China, and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098393 | 24098393 |
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]);