This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29874 | 29874 | 1915-04-03 | 8 | a-b | Details of finding out a riot party organisation in Yunfu county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094798 | 24094798 | |
29875 | 29875 | 1915-04-03 | 8 | b-c | The details of exposing the riot party activities in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094798 | 24094798 | |
29876 | 29876 | 1915-04-03 | 8 | c-d | Guangdong news/Police commander Li sends officials to inspect police work in various counties in Guangdong. Police touring in the cities must be strict due to the riot parties' activities. Mei Jianzhang proposes to set up a Tou Qiang Hui to fight against Japan. The ceremony of people worshipping the heaven. Gambling tools are found in biscuits in Guangdong Custom. A pregnant woman attacks the custom police. A farmer in Xingpu, Guangdong plants cotton in wild land. A cock in Guangzhou lays eggs. A defending water conservency work is built in Dongsun, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094798 | 24094798 | |
29877 | 29877 | 1915-04-03 | 8 | d | Zhou Shiqi's poem. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094798 | 24094798 |
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]);