This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34063 | 34063 | 1919-02-01 | 8 | a-b | Chinese communities in Australia donate to the Australian Chinese Association against Discrimination (ao zhou hua qiao wei chi jin li hui). Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097596 | 24097596 | |
34064 | 34064 | 1919-02-01 | 8 | b-c | Beijing news/ Sufferings of the Chinese in Russia. Governor of Jiangxi province Chen Xiufeng stays in Beijing. Proposal for separate government in the south and in the north of China. Princess of Thailand comes to visit China. | China | http://trove.nla.gov.au/newspaper/page/24097596 | 24097596 | |
34065 | 34065 | 1919-02-01 | 8 | c | Guangdong news/ Qin Chunxuan resigns from the position of peace representation. The war expense of the south and the north. Business report from Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24097596 | 24097596 |
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]);