This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, 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 | |
| 55214 | 55214 | 1935-06-22 | 3 | a | Thailand authority responds to China's protest over the anti-Chinese movement. | China | http://trove.nla.gov.au/newspaper/page/24096472 | 24096472 | |
| 55215 | 55215 | 1935-06-22 | 3 | b | American customs ban entry of foreign silver. | Britain | http://trove.nla.gov.au/newspaper/page/24096472 | 24096472 | |
| 55216 | 55216 | 1935-06-22 | 3 | c | Germany invents torpedo cruisers. | Germany | http://trove.nla.gov.au/newspaper/page/24096472 | 24096472 | |
| 55217 | 55217 | 1935-06-22 | 3 | d | Number of opium addicts in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/24096472 | 24096472 | |
| 55218 | 55218 | 1935-06-22 | 6-7 | a-e | Guangdong news/ Jiang Jieshi leaves Yunnan. Guangdong to build a shipyard. Police officers of local counties to be appointed by the provincial authority. Famine in Yangjiang and Yangshan counties. Businessmen to start trolleybus service in Guangzhou. Illness of Hu Hanmin. Guangzhou Chamber of Commerce requests to reduce export tariff of Chinese herbal products. Second part of the statistics about Zengcheng. Clan fighting in Taishan between Huang and Chen families. | China | http://trove.nla.gov.au/newspaper/page/24096477 | 24096477 | |
| 55219 | 55219 | 1935-06-22 | 8 | a | Various report on the current situations in north China. | China | http://trove.nla.gov.au/newspaper/page/24096479 | 24096479 | |
| 55220 | 55220 | 1935-06-22 | 8 | e | America to expand its naval forces. | America | http://trove.nla.gov.au/newspaper/page/24096479 | 24096479 | |
| 55221 | 55221 | 1935-06-22 | 8 | e | Earthquake in the east part of Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096479 | 24096479 | |
| 55222 | 55222 | 1935-06-22 | 8 | f | Australia news/ Growth of freight service in Sydney. Wedding of daughter of Liu Junrong, Chinese businessman in Sydney. Factory robbery in Newcastle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096479 | 24096479 |
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]);