This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41005 | 41005 | 1924-02-02 | 2 | b-c | Beijing government discusses on the negotiation over the administration of the Guangzhou customs. | China | http://trove.nla.gov.au/newspaper/page/24100590 | 24100590 | |
41011 | 41011 | 1924-02-02 | 3 | b-c | Chinese Chamber of Commerce in Java (Jawa) replies to the declaration issued by Feng Ziyou, representative of overseas Chinese communities in the national Parliament of China (about the bribery and presidential election in Beijing). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100589 | 24100589 | |
41016 | 41016 | 1924-02-02 | 6 | b-c | A circular telegram issued by the Chinese cabinet on the case of gold Franc. | China | http://trove.nla.gov.au/newspaper/page/24100594 | 24100594 | |
41027 | 41027 | 1924-02-02 | 7 | b-c | News from the hometown, Xiangshan county. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100593 | 24100593 |
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]);