This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47150 | 47150 | 1928-06-16 | 8 | a | A failed attempt to assassinate Japanese prime minister. | Japan | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47151 | 47151 | 1928-06-16 | 8 | a | Zhang Zongchang demands more payment before retreat. Feng Yuxiang and his defection. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47152 | 47152 | 1928-06-16 | 8 | a | A passenger ship is stranded on its way from Hong Kong to Wuzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47153 | 47153 | 1928-06-16 | 8 | a | Report says Beijing is quiet at the moment. | Britain | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47154 | 47154 | 1928-06-16 | 8 | b | The Nationalist government in Nanjing and its declaration of foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47155 | 47155 | 1928-06-16 | 8 | b | Japanese residence in Shanghai is bombed. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47156 | 47156 | 1928-06-16 | 8 | c | Nanjing has become capital of the Nationalist government. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47157 | 47157 | 1928-06-16 | 8 | c | The death of Zhang Zuolin is confirmed. | Japan | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47158 | 47158 | 1928-06-16 | 8 | c | Australia news/ A man in Sydney is punished for illegal wine. Young woman dies of abortion in Sydney hospital. Further report on the direct flight from North America to Australia. Further report on the strike of chefs on board of passenger liners in Sydney. Investigation on the murder of Chinese father and son in Brisbane. Long distance telephone call will be better. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 |
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]);