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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
53534 | 53534 | 1933-11-18 | 2 | b | An open letter issued by Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091438 | 24091438 | |
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 | |
53559 | 53559 | 1933-11-18 | 6 | b | Foreigners are leaving Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
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 | |
53560 | 53560 | 1933-11-18 | 6 | d | More Japanese troops enter Korea. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
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 | |
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 | |
53563 | 53563 | 1933-11-18 | 6 | e | Rebellions in Xinjiang, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
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 | |
53554 | 53554 | 1933-11-18 | 5 | f | Sun Chuanfang turns to a monk. | China | http://trove.nla.gov.au/newspaper/page/24091439 | 24091439 |
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]);