This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43482 | 43482 | 1925-07-18 | 3 | c | Feng Yuxiang asks Zhang Jingyao to stay in Zhangjiakou. | China | http://trove.nla.gov.au/newspaper/page/24101207 | 24101207 | |
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 | |
43511 | 43511 | 1925-07-18 | 7 | c | A British warship leaves Malta for China. | Britain | http://trove.nla.gov.au/newspaper/page/24101211 | 24101211 | |
43512 | 43512 | 1925-07-18 | 7 | c | The aftermath of strike in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101211 | 24101211 |
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]);