Article Index

6 rows where column = "c" and date = "1931-12-19"

Filter results

This data as json, CSV (advanced)

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

Link rowid ▼ date page column title description source page_url trove_id
50964 50964 1931-12-19 2 c   Ma Zhanshan, chairman of the Heilongjiang provincial government, fight Japanese invaders. Donations to the Heilongjiang army. Detailed report on Ma Zhanshan's resistance to Japanese. Japanese in Tianjin contribute to the invasion. China http://trove.nla.gov.au/newspaper/page/24090637 24090637
50968 50968 1931-12-19 3 c   Japanese government requests all Japanese ships in China to stop. China http://trove.nla.gov.au/newspaper/page/24090636 24090636
50969 50969 1931-12-19 3 c   Japanese troops land in Fuzhou, of Fujian province. China http://trove.nla.gov.au/newspaper/page/24090636 24090636
50977 50977 1931-12-19 6 c   Guangdong news/ Bao Mingling, secretary of the foreign ministry of the Nanjing government, is under investigation for misconduct. The Communist troops enter Longyan of Fujian province from Guangdong. Huang Shaoxiong is leaving Shanghai. Preparation for the Fourth Session of Plenary in Guangzhou. The cement factory in the south suburb of Guangzhou resume production. Hu Hanmin returns to Guangdong. Defence in Humen. China http://trove.nla.gov.au/newspaper/page/24090641 24090641
50980 50980 1931-12-19 7 c   The Australian Chinese School in Sydney to have an award ceremony at the headquarters of the Chinese Nationalist Party and the meeting notice. Tung Wah http://trove.nla.gov.au/newspaper/page/24090640 24090640
50988 50988 1931-12-19 8 c   Jiang Jieshi resigns once again. China http://trove.nla.gov.au/newspaper/page/24090643 24090643

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]);