This data as json, CSV (advanced)
Suggested facets: page, description, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27287 | 27287 | 1913-04-19 | 2 | a-b | Liang Qichao's article on national financial policies. | Other... | http://trove.nla.gov.au/newspaper/page/24092649 | 24092649 | |
27301 | 27301 | 1913-04-19 | 3 | a-b | Japan asks against America as it bans Japanese entry into America. | Japan | http://trove.nla.gov.au/newspaper/page/24092648 | 24092648 | |
27302 | 27302 | 1913-04-19 | 3 | a-b | Japan asks against America as it bans Japanese entry into America. | Japan | http://trove.nla.gov.au/newspaper/page/24092648 | 24092648 | |
27315 | 27315 | 1913-04-19 | 6 | a-b | Revised regulations for awarding those who donate to save China. | Other... | http://trove.nla.gov.au/newspaper/page/24092653 | 24092653 | |
27324 | 27324 | 1913-04-19 | 8 | a-b | Guangdong news/ General Office of National Business Association opens. Foreign Affairs Ministry asks all governors to ban selling land to foreigners. Zengcheng rice allowed to sell to foreign nations. Fujian, Guangdong and Guangxi have joint venture to build railways. House of correction for poor in Xiangshan. Soldiers rob village. Opium dealers arrested. Tea house owner is robbed. | Other... | http://trove.nla.gov.au/newspaper/page/24092655 | 24092655 |
JSON shape: default, array, newline-delimited
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]);