This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41010 | 41010 | 1924-02-02 | 3 | a-b | Zhang Qian suggests that a referendum would be necessary to finalise revision of the Chinese constitution. | China | http://trove.nla.gov.au/newspaper/page/24100589 | 24100589 | |
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 | |
41012 | 41012 | 1924-02-02 | 3 | c-e | A big fire in the Southeast (Dongnan) University in Nanjing, and report on the damages. | China | http://trove.nla.gov.au/newspaper/page/24100589 | 24100589 |
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]);