This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
45723 | 45723 | 1927-05-14 | 7 | b-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101987 | 24101987 | |
45724 | 45724 | 1927-05-14 | 7 | d | More report on the floods in America. | America | 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]);