This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30081 | 30081 | 1915-05-22 | 6 | a-b | Headline news miscellany from China/25 news on activities of Japanese troops in China, Chinese reactions to Japan's invasion, state policies, important events, official activities. Yuan Shikai, Lu Zhenqiang, Long Jiguang, Liang Qicao, Lu Yu are included. | China | http://trove.nla.gov.au/newspaper/page/24094853 | 24094853 | |
30082 | 30082 | 1915-05-22 | 6 | b | Comment on developing industry in East Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24094853 | 24094853 |
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]);