This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46850 | 46850 | 1928-03-17 | 7 | a | The Communist forces are defeated in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46851 | 46851 | 1928-03-17 | 7 | a | A passenger ship is stranded in Boston. | Canada | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46852 | 46852 | 1928-03-17 | 7 | a | Li Jishen personally welcomes the governor of Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46853 | 46853 | 1928-03-17 | 7 | a | Relations between Britain and China. | China | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46854 | 46854 | 1928-03-17 | 7 | a | Prince of Japan to visit Australia | Japan | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46855 | 46855 | 1928-03-17 | 7 | a | Bandits arrested in Shanghai. Foreign missions in Beijing to jointly ban import of weapons into China. | China | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46856 | 46856 | 1928-03-17 | 7 | b | Australia news/ A priest in Melbourne is on trial for murder of his wife. Bandits are shot dead in Manly, Sydney. Chinese man is robbed in Sydney on his way to deposit in the bank. A British pilot arrives Sydney and the welcome ceremony. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 |
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]);