This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55343 | 55343 | 1935-08-17 | 2 | b | Japanese have totally control the judicial system of China, claims by Wu Kaisheng. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55344 | 55344 | 1935-08-17 | 2 | b | Floods of the Yangtze River and the danger of Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55345 | 55345 | 1935-08-17 | 2 | d | The floods of Yellow River and victims in southwest Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55346 | 55346 | 1935-08-17 | 2 | e | Woman Wang Zhenkun becomes local administrator in Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55347 | 55347 | 1935-08-17 | 2 | f | The New Life Weekly is closed down in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55348 | 55348 | 1935-08-17 | 2 | f | Japanese troops in Tianjin have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 |
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]);