Article Index

10 rows where "date" is on date 1934-01-27 and source = "China"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, column, page_url, trove_id, date (date)

Link rowid ▼ date page column title description source page_url trove_id
53795 53795 1934-01-27 2 a   Second part of an open letter from Hu Hanmin on the current situations. China http://trove.nla.gov.au/newspaper/page/24091511 24091511
53796 53796 1934-01-27 2 c   Civilian associations in Fujian province urge Jiang Jieshi to stop bombing. China http://trove.nla.gov.au/newspaper/page/24091511 24091511
53797 53797 1934-01-27 2 d   Zhu Qiqing and his suggestions to save China. China http://trove.nla.gov.au/newspaper/page/24091511 24091511
53798 53798 1934-01-27 2 e   Troops of the Nanjing government take over Mawei Port on the coast of Fujian province. China http://trove.nla.gov.au/newspaper/page/24091511 24091511
53799 53799 1934-01-27 2 f   Resolutions of the Fujian province. China http://trove.nla.gov.au/newspaper/page/24091511 24091511
53800 53800 1934-01-27 2 f   Shanghai to build the biggest airport in Asia. China http://trove.nla.gov.au/newspaper/page/24091511 24091511
53801 53801 1934-01-27 3 a   Jiang Jieshi's warplanes show off in Fujian. Other news on the military conflict between Fujian and the Nanjing government. China http://trove.nla.gov.au/newspaper/page/24091510 24091510
53807 53807 1934-01-27 7-8 a-f   Guangdong news/ Xiao Focheng condemns the Nanjing government for their bombing of Fujian. Report on the bombing of Fujian by Jiang Jieshi's warplanes. Decline of the silk industry in Guangdong. Business in Shiqi town, Shunde county. Villagers in Nanhai county set fire on the police office. China http://trove.nla.gov.au/newspaper/page/24091514 24091514
53808 53808 1934-01-27 6 a   The puppet Manchurian state restores emperor system. China http://trove.nla.gov.au/newspaper/page/24091515 24091515
53809 53809 1934-01-27 6 b   Resistance of revolutionary army in Fuzhou, capital of Fujian province. China http://trove.nla.gov.au/newspaper/page/24091515 24091515

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
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]);