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 |
---|---|---|---|---|---|---|---|---|---|
45701 | 45701 | 1927-05-14 | 2 | b | Chinese football team comes to visit Australia and the comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
45705 | 45705 | 1927-05-14 | 2 | c-d | Flipino customs officers investigate new immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
45721 | 45721 | 1927-05-14 | 7 | a | Chinese football team, Lehua, has arrived Sydney and the members. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101987 | 24101987 | |
45722 | 45722 | 1927-05-14 | 7 | a-b | Australia news/ A newspaper boy dies in tram accident. A white woman dies in Chinese restaurant in Sydney. The Australian federal government moves to Canberra and the ceremony. Ye Bingnan, Zhu Songqing, Wu Zhaoquan and Liu Guangfu welcome the Chinese football team on behalf of the Chinese Chamber of Commerce in Sydney. Peanut import is banned. New coins issued to commemorate the move of national capital from Melbourne to Canberra. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101987 | 24101987 | |
45725 | 45725 | 1927-05-14 | 7 | d | A notice by the Chinese Presbyterian Church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101987 | 24101987 |
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]);