Article Index

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

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
56455 56455 1936-11-28 6-7 a-d   Guangdong news/ The central government troops are leaving Guangdong. Villagers are injured in a bomb blast in their farm. The Guangxi province after the peace negotiation. Japanese in Shantou. Gamblers in Shantou. Provincial government to enlist more soldiers. Japanese spy in Nanhai. Villagers shoot dead tiger in Luoding county. China http://trove.nla.gov.au/newspaper/page/24097081 24097081

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