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 |
---|---|---|---|---|---|---|---|---|---|
47477 | 47477 | 1928-10-13 | 2 | b | Editorial by Tung Wah Times on the Confucianism. A picture of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47478 | 47478 | 1928-10-13 | 2 | c | American doctor on the control of population growth. | America | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47479 | 47479 | 1928-10-13 | 2 | c | Chen Gongbo is leaving China. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47480 | 47480 | 1928-10-13 | 2 | d | Qin Chunxuan and his son are brought to trial in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47481 | 47481 | 1928-10-13 | 2 | d | British inspector general of the Chinese Maritime Customs Bureau arrives Shanghai from Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47482 | 47482 | 1928-10-13 | 2 | e | The central government to be restructured and the prospect. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47483 | 47483 | 1928-10-13 | 2 | e | Journalism in Shanghai requests for privileges. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47484 | 47484 | 1928-10-13 | 2 | e | Military news from Shaanxi and Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47485 | 47485 | 1928-10-13 | 2 | e | Mongolian troops harass the border with Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47486 | 47486 | 1928-10-13 | 2 | f | Situation in Japan after the fall of Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47487 | 47487 | 1928-10-13 | 3 | b | Delegates from Xinjiang province in the north-west reports to the central government. | China | http://trove.nla.gov.au/newspaper/page/24098977 | 24098977 | |
47488 | 47488 | 1928-10-13 | 3 | c | Cruelty of Japanese troops in Jinan, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098977 | 24098977 | |
47489 | 47489 | 1928-10-13 | 3 | c | The Qing Dynasty graves after the looting. | China | http://trove.nla.gov.au/newspaper/page/24098977 | 24098977 | |
47490 | 47490 | 1928-10-13 | 3 | d | Dozens of students in Shanghai are arrested for distributing Communist leaflets. | China | http://trove.nla.gov.au/newspaper/page/24098977 | 24098977 | |
47491 | 47491 | 1928-10-13 | 5 | a | Hong Kong news/ Chen Gongbo arrives Hong Kong secretly. American naval fleet in the Far East. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098979 | 24098979 | |
47492 | 47492 | 1928-10-13 | 5 | b | Special report on the preparations by the Chinese Chamber of Commerce in Sydney for the National Day celebration on October 10 and the birthday celebration for Confucius. A photograph of the anniversary picnic committee of the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098979 | 24098979 | |
47493 | 47493 | 1928-10-13 | 6-7 | a-d | Guangdong news/ Provincial government investigates the corruption during the purchase of aeroplanes from overseas. Military headquarters to be abolished in Guangdong. Opium sales in Guangdong and disputes between two commercial firms. Different views on gambling in Guangdong. People dies in a fire in the Fangcun Village. Bandits in Zengcheng county. The Communists in Haifeng county. | China | http://trove.nla.gov.au/newspaper/page/24098982 | 24098982 | |
47494 | 47494 | 1928-10-13 | 8 | a | New York customs officers seize opium from a ship. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47495 | 47495 | 1928-10-13 | 8 | a | New organisational regulations for the national government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47496 | 47496 | 1928-10-13 | 8 | a | Postmen are on strike in China and the further report. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47497 | 47497 | 1928-10-13 | 8 | a | American archaeologist returns to Beiping after a work in central Asia. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47498 | 47498 | 1928-10-13 | 8 | a | Transportation minister Huang Fu on the development of national transportation. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47499 | 47499 | 1928-10-13 | 8 | b | The new China sees no freedom. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47500 | 47500 | 1928-10-13 | 8 | b | Bandits in New York. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47501 | 47501 | 1928-10-13 | 8 | b | Jiang Jieshi is elected president of China. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47502 | 47502 | 1928-10-13 | 8 | b | Muslims in Gansu province, China, on riots and the report. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47503 | 47503 | 1928-10-13 | 8 | b | New survey on residents in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 |
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]);