This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 43485 | 43485 | 1925-07-18 | 5 | a | Further report on the demonstration and strike in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43486 | 43486 | 1925-07-18 | 5 | a | Hong Kong authority drives out Chinese labourers. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43487 | 43487 | 1925-07-18 | 5 | a | British and Australian troops in Hong Kong. Christian general Feng Yuxiang asks Chinese Christians to pray for the future. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43488 | 43488 | 1925-07-18 | 5 | a-b | More report on the strike and demonstration in Shanghai and Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43489 | 43489 | 1925-07-18 | 5 | b | Panic in Soviet Russia and its diplomatic relation with Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43490 | 43490 | 1925-07-18 | 5 | b | Soviet Russian seeks to send 70 trade commissioners to Japan but the request is declined. | Japan | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43491 | 43491 | 1925-07-18 | 5 | b | A company in Hong Kong is bombed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43492 | 43492 | 1925-07-18 | 5 | b | Japanese ambassador issues protest to the Chinese government for demonstrations in Shanghai, Hankou, Jiujiang, Zhenjiang, Guangzhou and Chongqing. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43493 | 43493 | 1925-07-18 | 5 | b-c | Cadets of the Huangpu Military Academy suggest to take over Shamian and Kowloon. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43494 | 43494 | 1925-07-18 | 5 | c | Japan demands compensation from China for their loss caused by the strike and demonstration. Grains in shortage in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43495 | 43495 | 1925-07-18 | 5 | c | Shanghai sees alleviation of industrial tensions. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43496 | 43496 | 1925-07-18 | 5 | c | British missionaries of the Presbyterian church in Puning county, Guangdong, are seriously injured by the army. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43497 | 43497 | 1925-07-18 | 5 | c | More riots are plotted in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43498 | 43498 | 1925-07-18 | 5 | c | American president Calvin Coolidge to organise an international conference on the Far East issues. | America | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
| 43499 | 43499 | 1925-07-18 | 5 | c | Feng Yuxiang is against the Communist party. | China | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 |
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]);