Article Index

2 rows where date = "1910-08-13" and source = "America"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
23292 23292 1910-08-13 2 c-d   Correspondence from America/ Chinese students in American university and their excellent performance, such as Yang Boluo, Liu Jixian, Liu Yulan, Liu Yuliu, and Cao Chuanmei. Chinese girl Huang Qiongfeng sends her painting to the National Industrial Exposition in Nanjing. America http://trove.nla.gov.au/newspaper/page/26802730 26802730
23309 23309 1910-08-13 6 a-b   Chinese communities in America fight for a fair treatment and their request. America http://trove.nla.gov.au/newspaper/page/26802734 26802734

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