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 |
---|---|---|---|---|---|---|---|---|---|
46510 | 46510 | 1927-12-03 | 5 | a | Zhang Zuolin seeks to be the emperor of China. | Japan | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46511 | 46511 | 1927-12-03 | 5 | a | Declaration issued by Wu Chaoshu, foreign minister of the Nationalist government in Nanjing. The Communists instigate strike in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46513 | 46513 | 1927-12-03 | 5 | a | Farmers are on riots in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46522 | 46522 | 1927-12-03 | 7 | a | A notice issued by the Chinese Chamber of Commerce in Sydney on illegal Chinese immigrants and their deportation from Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 | |
46523 | 46523 | 1927-12-03 | 7 | a | Australia news/ The unemployment under the new state government in New South Wales. Ticket prices going up for train and trams in Sydney. Jeweller dies with his treasurer while on board of ferry Greycliffe. A young artist commit suicide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 |
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]);