This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46374 | 46374 | 1927-10-29 | 7 | a | Warning to the compatriots who want to take risk overseas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46375 | 46375 | 1927-10-29 | 7 | b | Australia news/ Illegal Chinese immigrants in Sydney and the tragedy. Two Chinese brothers in Melbourne fight and injure each others. State government of New South Wales tries to retain the police commissioner. Two ships collide near Sydney. New South Wales government appoints new representative to London. The Melbourne Cup and horse racing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46376 | 46376 | 1927-10-29 | 7 | c | Troops from Nanjing on the way to Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46377 | 46377 | 1927-10-29 | 7 | c | Foreign gunboats in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46378 | 46378 | 1927-10-29 | 7 | c | Leon Trotsky is removed from the Bolshevik Party. | Russia | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46379 | 46379 | 1927-10-29 | 7 | c | A big Japanese girl comes to visit Guangdong. | Japan | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 |
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]);