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 |
|---|---|---|---|---|---|---|---|---|---|
| 49632 | 49632 | 1930-11-01 | 2 | b | Third and final part of a letter from Zhang Junmai to Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24099830 | 24099830 | |
| 49633 | 49633 | 1930-11-01 | 2 | d | Miscellaneous report on China on the war of warlords. | China | http://trove.nla.gov.au/newspaper/page/24099830 | 24099830 | |
| 49634 | 49634 | 1930-11-01 | 3 | a | Japanese government deports Chinese nationals and the negotiations. | China | http://trove.nla.gov.au/newspaper/page/24099829 | 24099829 | |
| 49635 | 49635 | 1930-11-01 | 3 | b | Protest against the sale of Fushun coal mine in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24099829 | 24099829 | |
| 49636 | 49636 | 1930-11-01 | 3 | c | The Communist forces in the west of Fujian province and the effort to suppress them. | China | http://trove.nla.gov.au/newspaper/page/24099829 | 24099829 | |
| 49637 | 49637 | 1930-11-01 | 3 | c | Tobacco company in Qingdao, Shandong province, is on fire. | China | http://trove.nla.gov.au/newspaper/page/24099829 | 24099829 | |
| 49638 | 49638 | 1930-11-01 | 3 | d | Disasters of war and floods in east Henan and west Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099829 | 24099829 | |
| 49639 | 49639 | 1930-11-01 | 5 | a | Hong Kong news/ Sugar sales in Hong Kong. Crafts art school to be built. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099831 | 24099831 | |
| 49640 | 49640 | 1930-11-01 | 5 | b | Daughter-in-law is boiled in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24099831 | 24099831 | |
| 49641 | 49641 | 1930-11-01 | 5 | c | The aftermath of ban on prostitution in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099831 | 24099831 | |
| 49642 | 49642 | 1930-11-01 | 5 | c | Notice issued by the Chinese Consul-General in Australia Song Faxiang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099831 | 24099831 | |
| 49643 | 49643 | 1930-11-01 | 6-7 | a-d | Guangdong news/ Restaurants in Guangzhou resume business and the report. Guangzhou to become a dirty city and the report. New regulations on the examination for all export products. Military news from Guangxi. Financial authority on some new taxes. Guangdong authority applies to develop the port in Huangpu. Bandits in Zhongshan rob a ferry. Yuan Dai and his efforts to suppress bandits in Zhongshan. Bandits in Dongguan and Zengcheng. Restaurants in Taishan fight to abolish the exorbitant taxes. Taishan county magistrate checks newspaper publication. Suspicious office crushed in Xinhui. Boatmen plead to reduce police levy. Road projects in Kaiping. Pagoda built in Kaiping in memory of padagon of charity. Retail tax in Nanxiong county and the protest. | China | http://trove.nla.gov.au/newspaper/page/24099834 | 24099834 | |
| 49644 | 49644 | 1930-11-01 | 8 | b | Foreign missionaries kidnapped in China and the report. | China | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49645 | 49645 | 1930-11-01 | 8 | b | Exercise of Japanese navy and the injuries. | Japan | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49646 | 49646 | 1930-11-01 | 8 | b | British government subsidises aviation industry. | Britain | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49647 | 49647 | 1930-11-01 | 8 | c | American President Hoover bans weapon sales to rebellions in Brazil. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49648 | 49648 | 1930-11-01 | 8 | c | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49649 | 49649 | 1930-11-01 | 8 | c | Unemployed workers in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49650 | 49650 | 1930-11-01 | 8 | c | American government helps the unemployed. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49651 | 49651 | 1930-11-01 | 8 | c | German politicians cut their salary. | Germany | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49652 | 49652 | 1930-11-01 | 8 | c | Revolution in Brazil and the robberies during the revolution. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49653 | 49653 | 1930-11-01 | 8 | d | Floods in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49654 | 49654 | 1930-11-01 | 8 | d | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49655 | 49655 | 1930-11-01 | 8 | d | Australia news/ Police in Melbourne raid communist offices. Restaurant in King Street, Sydney, is sealed off. Gamblers arrested in Sydney. Earthquake in Sydney. Result of the state election in NSW. Coal miners celebrate the victory of Labour Party. Prices of long distance call between Australia and America. Article written by Ruan Yongchang advises Chinese to live a thrift life. Man on trial in Sydney for murder of his daughter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 |
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]);