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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
47500 | 47500 | 1928-10-13 | 8 | b | Bandits in New York. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
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 | |
47479 | 47479 | 1928-10-13 | 2 | c | Chen Gongbo is leaving China. | China | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47488 | 47488 | 1928-10-13 | 3 | c | Cruelty of Japanese troops in Jinan, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098977 | 24098977 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47501 | 47501 | 1928-10-13 | 8 | b | Jiang Jieshi is elected president of China. | China | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
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 | |
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 | |
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 | |
47503 | 47503 | 1928-10-13 | 8 | b | New survey on residents in Shanghai. | 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 | |
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 | |
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 | |
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 | |
47489 | 47489 | 1928-10-13 | 3 | c | The Qing Dynasty graves after the looting. | China | http://trove.nla.gov.au/newspaper/page/24098977 | 24098977 | |
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 | |
47499 | 47499 | 1928-10-13 | 8 | b | The new China sees no freedom. | 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 |
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]);