This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34894 | 34894 | 1919-09-13 | 8 | a | A public notice issued by Ordinary People to Save China Association in Xiangshan county, China, on the national shame. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097866 | 24097866 | |
34895 | 34895 | 1919-09-13 | 8 | a-b | Guangdong news/ Zhang Jinfang to keep the disaster relief offices. Progress of the disaster relief in Guangdong. Magistrate of Xinhui county tries to stop rice export. Local gentry in Heshan county complain looting by troops. Robbery in Qingyuan county in day time. A man in Guangzhou is punished for his concubine. | China | http://trove.nla.gov.au/newspaper/page/24097866 | 24097866 |
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]);