This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53534 | 53534 | 1933-11-18 | 2 | b | An open letter issued by Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53535 | 53535 | 1933-11-18 | 2 | c | Sichuan troops on the way to suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53536 | 53536 | 1933-11-18 | 2 | c | Jiang Jieshi seeks direct dialogue with Japan. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53537 | 53537 | 1933-11-18 | 2 | d | Song Ziwen in Shanghai and his activities. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53538 | 53538 | 1933-11-18 | 2 | e | Wang Jingwei in Beijing convenes a conference on the independence of Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53539 | 53539 | 1933-11-18 | 2 | e | Song Ziwen has secured more foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53540 | 53540 | 1933-11-18 | 2 | f | Japanese in Tangshan, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53541 | 53541 | 1933-11-18 | 2 | f | More American cotton to arrive Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53542 | 53542 | 1933-11-18 | 2 | f | Jiang Zuobin to return to Japan. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
53543 | 53543 | 1933-11-18 | 3 | a | Japanese continue to encourage independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53544 | 53544 | 1933-11-18 | 3 | a | Russia to protect their railway by force. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53545 | 53545 | 1933-11-18 | 3 | b | More Russian troops reach the border of Manchuria. Russian planes fly along the Manchurian border. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53549 | 53549 | 1933-11-18 | 3 | e | Japanese commander is injured in Jinzhou, Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53550 | 53550 | 1933-11-18 | 3 | e | Manchurian state replies to the protest of Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53553 | 53553 | 1933-11-18 | 5 | e | Qin Chunxuan's son and his luxurious life. | China | http://trove.nla.gov.au/newspaper/page/24091439 | 24091439 | |
53554 | 53554 | 1933-11-18 | 5 | f | Sun Chuanfang turns to a monk. | China | http://trove.nla.gov.au/newspaper/page/24091439 | 24091439 | |
53555 | 53555 | 1933-11-18 | 7-8 | a-f | Guangdong news/ Election of the commercial chamber in Guangzhou and the chaos. Riots in Shantou at the Saving China Association. Sale of local rice in Guangzhou. Guan Zhang, Chinese man in America, is awarded for his aviation research and returns to China. Hong Kong dollars in the Guangzhou market. Sales of fabrics in Guangzhou. Bandits in Dongguan county. An old man in Dongguan murders his daughter-in-law. Taishan county authority to set up civil air defence association. Yang Kunru dies in Hong Kong. Ferries in Nanhai and their joint defence. | China | http://trove.nla.gov.au/newspaper/page/24091441 | 24091441 | |
53556 | 53556 | 1933-11-18 | 6 | a | Nonaggression pact drafted between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
53557 | 53557 | 1933-11-18 | 6 | a | Japanese military existence in Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
53559 | 53559 | 1933-11-18 | 6 | b | Foreigners are leaving Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
53560 | 53560 | 1933-11-18 | 6 | d | More Japanese troops enter Korea. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
53563 | 53563 | 1933-11-18 | 6 | e | Rebellions in Xinjiang, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 |
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]);