This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46448 | 46448 | 1927-11-19 | 5 | a | Leon Trotsky and different voices in the 10th anniversary celebration of the October Revolution in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46449 | 46449 | 1927-11-19 | 5 | a | British treasurer reports the expenses of their troops in China. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46450 | 46450 | 1927-11-19 | 5 | a | Bandits in Sichuan province. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46451 | 46451 | 1927-11-19 | 5 | a | Britain expands its naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46452 | 46452 | 1927-11-19 | 5 | a | Peasants in the suburbs of Wuxi support the Chinese Communist Party and the report. | China | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46453 | 46453 | 1927-11-19 | 5 | b | An international anti-Communist conference in Hague. | Other... | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46454 | 46454 | 1927-11-19 | 5 | b | The unemployed workers in Tokyo and their requests. | Japan | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46455 | 46455 | 1927-11-19 | 5 | b | German invents new ship. | Germany | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46456 | 46456 | 1927-11-19 | 5 | b | Dutch liner Almkerk sacks all Chinese sailors. | Other... | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46457 | 46457 | 1927-11-19 | 5 | b | Korean woman arrested in Tokyo after a celebration of the October Revolution. | Japan | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46458 | 46458 | 1927-11-19 | 5 | b | France and Yugoslavia sign a treaty. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46459 | 46459 | 1927-11-19 | 5 | c | Russian refugees in Shanghai attack the Soviet Russian consulate and the report. Chaos in Hankou following the attack from Nanjing and the flee of Tang Shengzhi. Sun Chuanfang leads his troops moving south. | China | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46460 | 46460 | 1927-11-19 | 5 | c | Italy and Hungary resume their talks. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46461 | 46461 | 1927-11-19 | 5 | c | Troops from Nanjing occupy Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46462 | 46462 | 1927-11-19 | 5 | c | Gas explosion in Pittsburgh, America. | America | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 |
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]);