This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52689 | 52689 | 1933-03-25 | 3 | a | The war between Chinese and Japanese troops in Rehe. The response of Chinese government to Japanese invasion of Rehe. | China | http://trove.nla.gov.au/newspaper/page/24091163 | 24091163 | |
52690 | 52690 | 1933-03-25 | 3 | c | Proposals of the League of Nations to the Manchurian issues. | Other... | http://trove.nla.gov.au/newspaper/page/24091163 | 24091163 | |
52691 | 52691 | 1933-03-25 | 3 | d | American government responds to Japanese intention to occupy Pacific islands. | Japan | http://trove.nla.gov.au/newspaper/page/24091163 | 24091163 | |
52692 | 52692 | 1933-03-25 | 3 | e | The Filipino authority increases poll tax on all immigrants. | Other... | http://trove.nla.gov.au/newspaper/page/24091163 | 24091163 | |
52693 | 52693 | 1933-03-25 | 3 | f | Number of Chinese in America. | China | http://trove.nla.gov.au/newspaper/page/24091163 | 24091163 | |
52694 | 52694 | 1933-03-25 | 3 | g | Zhang Xiaoxu's son dies in Changchun. | China | http://trove.nla.gov.au/newspaper/page/24091163 | 24091163 |
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]);