This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24460 | 24460 | 1911-03-25 | 2 | a-c | Comments on Japanese foreign policies | From Guofeng Bao, comments were made on Japanese foreign policies. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091710 | 24091710 |
24461 | 24461 | 1911-03-25 | 2 | c-d | A big plan for China's navy | A big plan has been developed for China's navy. | Other... | http://trove.nla.gov.au/newspaper/page/24091710 | 24091710 |
24462 | 24462 | 1911-03-25 | 2 | d | Japan intends to invade Shandong | Japan intends to invade Shandong. | Other... | http://trove.nla.gov.au/newspaper/page/24091710 | 24091710 |
24463 | 24463 | 1911-03-25 | 2 | d | Oveseas Koreans in China | Oveaseas Koreans have to decide whether they stay in China or back to Korea after the establishment of formal diplomatic relations between Japan and Korea. | China | http://trove.nla.gov.au/newspaper/page/24091710 | 24091710 |
24464 | 24464 | 1911-03-25 | 2 | d | The progress of the Guangdong railway | The Guangdong railway is proposed to be finished in two years. | Other... | http://trove.nla.gov.au/newspaper/page/24091710 | 24091710 |
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]);