This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47520 | 47520 | 1928-10-20 | 5 | a | Hong Kong news/ Plan for aviation industry development in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098987 | 24098987 | |
47522 | 47522 | 1928-10-20 | 8 | a | Bandits in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47523 | 47523 | 1928-10-20 | 8 | a | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47524 | 47524 | 1928-10-20 | 8 | a | Romanian authority deport Hungarian workers. | Canada | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47525 | 47525 | 1928-10-20 | 8 | a | Australia news/ Picnic organised by the Chinese Chamber of Commerce in New South Wales to celebrate the National Day on October 10 and the birthday of Confucius, and speakers include Wu Zhaoquan, Liu Guangfu, Guo Jianying, Zhang Fuxiang and others. Trial on the Sydney woman for her murder of husband. Strike and riots in Newcastle. Professor of history at University of Sydney commit suicide. Death of son on Anthony Horden and the redistribution of wealth. New survey on the factories in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 |
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]);