This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51656 | 51656 | 1932-07-02 | 3 | a | A speech of Japanese Prime Minister in the Parliament (on the China policy). | Japan | http://trove.nla.gov.au/newspaper/page/24090855 | 24090855 | |
51657 | 51657 | 1932-07-02 | 3 | c | Various Chinese troops in Jilin and Heilongjiang province fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090855 | 24090855 | |
51658 | 51658 | 1932-07-02 | 3 | d | Storm and heavy rain in Wuhan, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24090855 | 24090855 | |
51659 | 51659 | 1932-07-02 | 3 | d | A letter from Zhang Zhijiang to the Chinese women which advises them to practise martial arts in order to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090855 | 24090855 | |
51660 | 51660 | 1932-07-02 | 3 | e | Japanese occupy Chinese houses in Liaoyang, of Liaoning province. Chinese Ministry of Education will not send delegate to the international education conference in London. | China | http://trove.nla.gov.au/newspaper/page/24090855 | 24090855 | |
51661 | 51661 | 1932-07-02 | 3 | g | Advertisement of the Chinese Chamber of Commerce of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090855 | 24090855 |
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]);