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 |
---|---|---|---|---|---|---|---|---|---|
37964 | 37964 | 1921-12-10 | 3 | b | Chen Jiongming disagrees to the north expedition. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093782 | 24093782 | |
37976 | 37976 | 1921-12-10 | 6 | b | The Washington Conference sees different opinions on the return of international concessions to Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
37981 | 37981 | 1921-12-10 | 7 | b | A fashion shop on Castlereagh Street, Sydney, is burglarised. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093786 | 24093786 | |
37982 | 37982 | 1921-12-10 | 7 | b | A Chinese businessman in Sydney applies for divorce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093786 | 24093786 | |
37983 | 37983 | 1921-12-10 | 7 | b | An aeroplane accident in Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24093786 | 24093786 | |
37984 | 37984 | 1921-12-10 | 7 | b | French and Chinese businessmen to jointly set up a steamship company for the route of Australia, Singapore, Saigon, Java, Fremantle, Adelaide, Melbourne, and Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093786 | 24093786 | |
37985 | 37985 | 1921-12-10 | 7 | b | Sydney Chinese community farewells Lin Run, an editor of the Tung Wah Times, and Huang Zhu, chairman of the Chi Kung Tong (zhi gong tang). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093786 | 24093786 |
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]);