This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55210 | 55210 | 1935-06-22 | 2 | a | Advertisement of The Wing On Bank Ltd, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096473 | 24096473 | |
55211 | 55211 | 1935-06-22 | 2 | a | Advertisement of the Public Herald or Tai Chung Yai Po (da zhong ri bao), published in Hong Kong by the 19th Route Army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096473 | 24096473 | |
55212 | 55212 | 1935-06-22 | 2 | b | Editorial on the promotion of China's international status. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096473 | 24096473 | |
55213 | 55213 | 1935-06-22 | 2 | d | Long Yun entertains Jiang Jieshi in Kunming. Sun Ke visits Xi'an. Japanese banking delegation visit Manchuria. Guizhou province under its new governor Wu Zhongxin. Nanjing authority to collect personal income tax. Cai E's mother dies. | China | http://trove.nla.gov.au/newspaper/page/24096473 | 24096473 |
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]);