This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34362 | 34362 | 1919-04-05 | 8 | a-b | The New South Wales Chinese Chamber of Commerce calls for donations to the famine victims in Guangdong. Names listed for donations received. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097676 | 24097676 | |
34363 | 34363 | 1919-04-05 | 8 | b | Beijing news/ Japanese ambassador in Beijing denies that Japanese troops on alert in Fengtian. Negotiations between America, Japan, Britain, China, Italy, France on the future of the Siberian railway. Port city to be opened in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24097676 | 24097676 | |
34364 | 34364 | 1919-04-05 | 8 | c | Guangdong news/ Election of members of the Guangdong provincial legislature assembly and the corruption. Huang Zaixing donates rice to famine victims in his hometown, Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097676 | 24097676 |
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]);