This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47339 | 47339 | 1928-08-18 | 5 | a | Hong Kong news/ Chinese businessmen in Hong Kong to set up the South China Textile Company. Submarine tunnel to be built in Kowloon. Various bank notes issued by different banks. Business dull for clothes shop. He Xiangni leaves Hong Kong for Shanghai. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098915 | 24098915 | |
47340 | 47340 | 1928-08-18 | 5 | b | Third part of the survey on the mercurial mining resources in Guizhou province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098915 | 24098915 | |
47341 | 47341 | 1928-08-18 | 5 | d | Concubines on the platform of big companies in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098915 | 24098915 |
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]);