This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43333 | 43333 | 1925-06-13 | 3 | c-d | Chinese in Japan are murdered during the disaster relief after the earthquake and the investigation. | Japan | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
43342 | 43342 | 1925-06-13 | 7 | a | American and Japanese navel fleet arrive Shanghai to deal with the chaos and demonstrations. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43345 | 43345 | 1925-06-13 | 7 | c | Chinese students in Japan and their request on the solution to the May 30 demonstration in Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43347 | 43347 | 1925-06-13 | 7 | d | More Japanese cruisers are on the way to China. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 |
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]);