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 |
---|---|---|---|---|---|---|---|---|---|
45569 | 45569 | 1927-03-26 | 2 | c | Jiang Jieshi talks about his anti-Communist attitude and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
45579 | 45579 | 1927-03-26 | 7 | a-c | Australia news/ Meeting notice by the Chinese Chamber of Commerce. Welcome ceremony for the Duck and Duchess of York. Chinese Chamber of Commerce farewells Wei Zijing on his return to Melbourne, and Ye Tonggui, Chen Yin, Wu Tianbao and Li Xinshe. Fund-raising for the Dongguan hospital. Advertisement for The Primary Producers' Bank of Australia Ltd. Farming and grains in New South Wales. Tourism and theft in Sydney. Sharks caught in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 | |
45581 | 45581 | 1927-03-26 | 7 | d | A notice by the Dongguan gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 | |
45582 | 45582 | 1927-03-26 | 7 | e | A notice by the Chinese Presbyterian church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 |
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]);