Article Index

1 row where date = "1936-11-28" and trove_id = 24097077

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
56447 56447 1936-11-28 2 c   Yang Yongtai, governor of Hubei province, is assassinated. Manchurian troops on the way to Suiyuan. China and Japan sign agreement on aviation cooperation. Japanese new demands to the Nanjing government. Newspapers office in Nanjing on fire. Japanese troops in Fengtai have an exercise and the damages to crops. China http://trove.nla.gov.au/newspaper/page/24097077 24097077

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