This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35553 | 35553 | 1920-04-03 | 2 | b-c | Second part of report on the students' demonstration in Beijing and the arrests. | China | http://trove.nla.gov.au/newspaper/page/24098109 | 24098109 | |
35565 | 35565 | 1920-04-03 | 6 | b-c | Peace talks in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24098113 | 24098113 | |
35571 | 35571 | 1920-04-03 | 8 | b-c | Guangdong news/ Preparation for the set-up of the Southwest University. Yunnan troops are leaving Guangdong. Market report from Guangzhou. Transportation in north Guangdong is blocked. Bandits in Guangdong. Special educational institution set up in Guangzhou for the homeless people. | China | http://trove.nla.gov.au/newspaper/page/24098115 | 24098115 |
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]);