This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46480 | 46480 | 1927-11-26 | 5 | a | Disasters of war, locusts and drought in Shandong province. Political changes in Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46481 | 46481 | 1927-11-26 | 5 | a | A passenger train hijacked in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46482 | 46482 | 1927-11-26 | 5 | a | Troops from Nanjing occupy Hankou and the report. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46489 | 46489 | 1927-11-26 | 7 | a | Notice issued by Liu Guangfu and Ye Tonggui on shareholders' meeting of the China-Australia Mail Line at the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098611 | 24098611 | |
46490 | 46490 | 1927-11-26 | 7 | a | Australia news/ A couple in Sydney commits suicide. Butter factory in Melbourne on blaze. Five illegal Chinese immigrants are detained in Sydney. Freemantle customs authority in Western Australia to deport illegal Chinese immigrants soon. Thieves steal post stamps in Sydney. Unemployment in Sydney. Advertisement for Mason Harris & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098611 | 24098611 |
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]);