This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39354 | 39354 | 1923-02-03 | 3 | a-b | Fujian Fellows Association (tong xiang hui) in Shanghai sends telegram to the provincial governor Lin Sen, and other two military officers in the province on recent political chaos. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39355 | 39355 | 1923-02-03 | 3 | b | Japanese commit crime in Shanghai while trying to seek employment. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39356 | 39356 | 1923-02-03 | 3 | b | Muslims in the northwestern China fight for their own representative in the national parliament. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39357 | 39357 | 1923-02-03 | 3 | c | A foreign banker suggests condominium in China. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39358 | 39358 | 1923-02-03 | 3 | c | Wu Peifu in Luoyang has his own plan for national unification. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39359 | 39359 | 1923-02-03 | 3 | c-d | Guangxi provincial legislature assembly protest the approach of Guangdong and Yunnan armies. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39360 | 39360 | 1923-02-03 | 3 | d | Chinese community in Peru organises self-defence association in the anti-Chinese movement. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39361 | 39361 | 1923-02-03 | 3 | e-f | Yunnan and Guangxi armies approach Wuzhou. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39362 | 39362 | 1923-02-03 | 3 | f | Chinese parliament approves the organisation of new cabinet in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
| 39363 | 39363 | 1923-02-03 | 3 | f | Envoy of Lenin's Soviet Russian government, Adolf Joffe, talks with Sun Yatsen in Shanghai and a joint communique issued on communist movement in China. | America | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 |
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]);