This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33523 | 33523 | 1918-08-17 | 2 | d-f | Chinese scholar in America, Dr Fu Kaisen, writes and comments on the constitution of China. | America | http://trove.nla.gov.au/newspaper/page/24097396 | 24097396 | |
34600 | 34600 | 1919-06-21 | 2 | d-f | Second part of the report written by American journalist that reveals Japan's conspiracy in China. | America | http://trove.nla.gov.au/newspaper/page/24097760 | 24097760 | |
38254 | 38254 | 1922-02-11 | 2 | d-f | Decision at the Washington Conference on Chinese tariff, withdrawal of foreign troops from China, abolition of likin, and increase of other taxes. China is permitted to increase customs duties for some import goods. It is hard to abolish the Twenty-one Demands. | America | http://trove.nla.gov.au/newspaper/page/24093864 | 24093864 | |
39259 | 39259 | 1923-01-13 | 2 | d-f | Zhi gong tang (former yi xing hui) in San Francisco expels Sun Yatsen from the association. | America | http://trove.nla.gov.au/newspaper/page/24094252 | 24094252 |
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]);