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 |
---|---|---|---|---|---|---|---|---|---|
47139 | 47139 | 1928-06-16 | 2 | c | Report on Japanese invasion in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
47147 | 47147 | 1928-06-16 | 5 | c | Two women in Sichuan province share a husband and the report. | China | http://trove.nla.gov.au/newspaper/page/24098843 | 24098843 | |
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]);