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 |
|---|---|---|---|---|---|---|---|---|---|
| 49612 | 49612 | 1930-10-25 | 2 | b | Second part of a letter from Zhang Junmai to Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24099822 | 24099822 | |
| 49613 | 49613 | 1930-10-25 | 2 | d | Miscellaneous report on the war of warlords in China. | China | http://trove.nla.gov.au/newspaper/page/24099822 | 24099822 | |
| 49614 | 49614 | 1930-10-25 | 3 | a | Dethroned emperor of Qing dynasty Puyi offers sacrifices to the East Graves. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
| 49615 | 49615 | 1930-10-25 | 3 | a | Another court hearing to be organised for the case of Liu Jiwen. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
| 49616 | 49616 | 1930-10-25 | 3 | b | War planes from Nanjing to bomb Zhengzhou, capital of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
| 49617 | 49617 | 1930-10-25 | 3 | b | Report from the battle field in the east of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
| 49618 | 49618 | 1930-10-25 | 3 | d | Movement in Hunan province to suppress the Communists. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
| 49619 | 49619 | 1930-10-25 | 3 | e | Wang Zhengting reports the foreign affairs. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
| 49620 | 49620 | 1930-10-25 | 5 | a | Hong Kong news/ Silver import in Hong Kong. More private banks set up in Hong Kong. More than 40 people are poisoned in Hong Kong. Solutions to the labour disputes. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099823 | 24099823 | |
| 49621 | 49621 | 1930-10-25 | 6-7 | a-d | Guangdong news/ Police in Guangzhou search and arrest communist members. Why the Huangpu Military Academy is closed and the true causes. Butchers request to be exempt from exorbitant taxes. Monopoly of sales of human droppings and urine. News on the Guangxi army. Chen Jitang sets up an engineering troops. Insect pest in the Beijiang area. Taishan county convenes a joint defence conference. Bandits loot villages. A case of murder in Zengcheng. Zhongshan county authority takes over the sand land bureau. Bandits in Zhongshan. Silly woman in Xinhui gives birth to a snake. Nanhai county abolish government bonds. Superstitious books burned in Yangjiang county. New market in Heshan county. | China | http://trove.nla.gov.au/newspaper/page/24099826 | 24099826 | |
| 49622 | 49622 | 1930-10-25 | 8 | b | Indian government raises funds. | Britain | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49623 | 49623 | 1930-10-25 | 8 | b | Workers in Germany on strike. | Germany | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49624 | 49624 | 1930-10-25 | 8 | b | Two female British missionaries are murdered in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49625 | 49625 | 1930-10-25 | 8 | b | American missionary is kidnapped in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49626 | 49626 | 1930-10-25 | 8 | c | British police search Indian parliament. | Other... | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49627 | 49627 | 1930-10-25 | 8 | c | Earthquake in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49628 | 49628 | 1930-10-25 | 8 | c | Brazil banks transport case to Britain and America. | Canada | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49629 | 49629 | 1930-10-25 | 8 | d | Clash between the communists and police in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49630 | 49630 | 1930-10-25 | 8 | d | Communists kidnap foreign missionaries in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49631 | 49631 | 1930-10-25 | 8 | d | Australia news/ Celebration on the World Day of Thrifty. Underground mint crushed in Sydney. Financial situations in South Australia. NSW exports rice. Price of wheat is low. Chinese Chamber of Commerce in Sydney celebrates the National Day on October 10 and the birthday of Confucius. A bandit robs bank and injured the manager in Sydney. Federal government to increase tax rate. Chinese communities in New Zealand celebrate the National Day on October 10. Two bandits are arrested in Sydney for bank robbery. More than 250 gamblers arrested in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 |
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]);