This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49815 | 49815 | 1930-12-20 | 5 | a | Hong Kong news/ Competition of fishing industry. Transportation between Hong Kong and Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099887 | 24099887 | |
49816 | 49816 | 1930-12-20 | 5 | c | Chinese consul in Mexico Chen Chengmo prohibits Chinese communities from hanging the new national flag of China and the conflicts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099887 | 24099887 | |
49817 | 49817 | 1930-12-20 | 5 | d | A notice issued by the Chinese Consulate-General in Melbourne on the insurance inheritance of Charles Lin Kee of Canton Cafe, Swanston Street, Melbourne, at the National Mutual Life Insurance Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099887 | 24099887 | |
49818 | 49818 | 1930-12-20 | 5 | e | Garden to lease by Hop Sing at Condobolin in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099887 | 24099887 |
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]);