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 |
|---|---|---|---|---|---|---|---|---|---|
| 55444 | 55444 | 1935-09-21 | 2 | b | The Central Government in Nanjing regains its control over Sichuan provincial politics, a further report. | China | http://trove.nla.gov.au/newspaper/page/24096579 | 24096579 | |
| 55445 | 55445 | 1935-09-21 | 2 | b | Police in Beijing drive away modern women from the city. | China | http://trove.nla.gov.au/newspaper/page/24096579 | 24096579 | |
| 55446 | 55446 | 1935-09-21 | 2 | d | Support Thailand Chinese Association in Shanghai requests to boycott to rice from Thailand. | China | http://trove.nla.gov.au/newspaper/page/24096579 | 24096579 | |
| 55447 | 55447 | 1935-09-21 | 2 | d | Jiang Jieshi arrives secretly Jiangxi province to discuss diplomacy with Japan. | China | http://trove.nla.gov.au/newspaper/page/24096579 | 24096579 | |
| 55448 | 55448 | 1935-09-21 | 2 | f | Politicians from the north and the south meet in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096579 | 24096579 | |
| 55449 | 55449 | 1935-09-21 | 3 | c | New tariff rate for the trade between Vietnam and China. | China | http://trove.nla.gov.au/newspaper/page/24096578 | 24096578 | |
| 55450 | 55450 | 1935-09-21 | 3 | c | More than 1,000 Japanese planes on the way to Taiyuan, Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096578 | 24096578 | |
| 55451 | 55451 | 1935-09-21 | 3 | e | Tao Shanming is under house arrest in Japanese embassy. | China | http://trove.nla.gov.au/newspaper/page/24096578 | 24096578 | |
| 55452 | 55452 | 1935-09-21 | 3 | e | Bandits along the Great Wall. Gu Weijun is leaving China. | China | http://trove.nla.gov.au/newspaper/page/24096578 | 24096578 | |
| 55453 | 55453 | 1935-09-21 | 6-7 | a-f | Guangdong news/ Positions of Wang Jingwei and Hu Hanmin in the central government. Businessman returned from Hawaii is defrauded. Chen Jitang advises to the use of physical punishment. Provincial government issues the budget of 1935. The First Group Army to have exercise. Road transportation agreement between Guangdong, Hunan and Hubei province. Chen Jiongming's mother dies. Chinese consul in London reports the sale of Guangdong silk products in Britain. Dongguan county authority on the postal services. Woman arrested in Taishan county for the murder of her husband. Bandits in Nanhai county beat villager to death. Zhongshan county on the survey of land tax. | China | http://trove.nla.gov.au/newspaper/page/24096583 | 24096583 | |
| 55454 | 55454 | 1935-09-21 | 8 | a | Japan protests against China for borrowing loans from Britain. | China | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
| 55455 | 55455 | 1935-09-21 | 8 | a | Beautiful Swiss woman is actually a spy. | France | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
| 55456 | 55456 | 1935-09-21 | 8 | a | American customs imposes heavy tax on German products. | America | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
| 55457 | 55457 | 1935-09-21 | 8 | c | France supports the League of Nations. | France | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
| 55458 | 55458 | 1935-09-21 | 8 | c | Italian army and its military strategies. | Other... | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
| 55459 | 55459 | 1935-09-21 | 8 | e | Australia news/ Population increase in Australia. Robot visits Sydney. Chinese Chamber of Commerce farewells Dr Wu Liande. Proposal for lottery in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 |
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]);