This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 54604 | 54604 | 1934-10-20 | 2 | c | The revised military service law promulgated by the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096198 | 24096198 | |
| 54605 | 54605 | 1934-10-20 | 2 | d | He Yingqin in Beijing entertains Japanese pilots and journalists. | China | http://trove.nla.gov.au/newspaper/page/24096198 | 24096198 | |
| 54607 | 54607 | 1934-10-20 | 2 | e | Shandong provincial government to refurbish Confucian temples. | China | http://trove.nla.gov.au/newspaper/page/24096198 | 24096198 | |
| 54608 | 54608 | 1934-10-20 | 2 | f | Rich mineral resources in the Tianshan Mountain of Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24096198 | 24096198 | |
| 54609 | 54609 | 1934-10-20 | 2 | f | Sun Ke and Wang Jingwei going to Jiangxi. | China | http://trove.nla.gov.au/newspaper/page/24096198 | 24096198 | |
| 54611 | 54611 | 1934-10-20 | 3 | a | Japanese supporters gather in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
| 54612 | 54612 | 1934-10-20 | 3 | b | Two major ship building companies in the world. | China | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
| 54613 | 54613 | 1934-10-20 | 3 | c | Taiwanese people fight for autonomy. | China | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
| 54614 | 54614 | 1934-10-20 | 3 | c | Foreigners are selling drugs in China and response of the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
| 54615 | 54615 | 1934-10-20 | 3 | c | Memorial services nation-wide in China on September 18. | China | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
| 54619 | 54619 | 1934-10-20 | 7-8 | a-f | Guangdong news/ Second part of proposals by Hu Hanmin and others in the southwest to the central authority in Nanjing. Construction of the railway from Guangzhou to Shantou. The Wing On Bank is opened in Hong Kong. Provincial government organises memorial ceremony on the birthday of Confucius. Jiang Jieshi refuses to accept proposals of the southwest authority. Bai Chongxi leaves Guangdong for Guangxi. Promotion of Chinese local products. Bandits in Dongguan. Clan fighting in Panyu. Memorial service in Nanhai for Confucius. | China | http://trove.nla.gov.au/newspaper/page/24096201 | 24096201 | |
| 54622 | 54622 | 1934-10-20 | 6 | c | The communists in Guizhou province kidnap foreign missionaries. | China | http://trove.nla.gov.au/newspaper/page/24096202 | 24096202 |
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]);