This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36196 | 36196 | 1920-10-16 | 2 | a-c | Second part of a letter from the Chinese community in Mexico to the Chinese government in Beijing (to reduce number of troops, to build more warships, to set up more consulates in America, to protect overseas Chinese, and to send students for overseas study). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098345 | 24098345 | |
36197 | 36197 | 1920-10-16 | 2 | c | Tung Wah Times comments on the war between Guangdong and Fujian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098345 | 24098345 | |
36198 | 36198 | 1920-10-16 | 2 | d | Orders issued by Chinese President Xu Shichang. | China | http://trove.nla.gov.au/newspaper/page/24098345 | 24098345 | |
36199 | 36199 | 1920-10-16 | 2 | e | Japan and Russia join together in order to control the Siberian railway. | China | http://trove.nla.gov.au/newspaper/page/24098345 | 24098345 | |
36200 | 36200 | 1920-10-16 | 2 | e | The war in Huizhou, of Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098345 | 24098345 |
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]);