This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33430 | 33430 | 1918-07-13 | 2 | e-f | A big gathering of the Chinese students in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24097354 | 24097354 | |
34264 | 34264 | 1919-03-15 | 2 | e-f | Japanese cabinet and their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24097646 | 24097646 | |
34921 | 34921 | 1919-09-27 | 2 | e-f | Japanese newspaper reports reconciliation in China between the south and the north. | Japan | http://trove.nla.gov.au/newspaper/page/24097876 | 24097876 | |
37998 | 37998 | 1921-12-17 | 2 | e-f | Japanese attitude on the Shandong problem. | Japan | http://trove.nla.gov.au/newspaper/page/24093791 | 24093791 | |
38848 | 38848 | 1922-06-10 | 3 | e-f | Japanese cabinet has different views on the withdrawal of troops from Siberia. | Japan | http://trove.nla.gov.au/newspaper/page/24094001 | 24094001 | |
40432 | 40432 | 1923-09-22 | 3 | e-f | Storm strikes Japan after the earthquake. | Japan | http://trove.nla.gov.au/newspaper/page/24094551 | 24094551 | |
40500 | 40500 | 1923-10-06 | 3 | e-f | More aftershocks in Japan and the report. | Japan | http://trove.nla.gov.au/newspaper/page/24094567 | 24094567 | |
41699 | 41699 | 1924-06-14 | 3 | e-f | American people in Tokyo are harassed by local residents. | Japan | http://trove.nla.gov.au/newspaper/page/24100752 | 24100752 | |
41891 | 41891 | 1924-08-02 | 3 | e-f | Lin Wenzhao, on behalf of the Chinese associations in Japan, sends a petition to Japanese cabinet and abolish the restrictions upon Chinese immigrants. | Japan | http://trove.nla.gov.au/newspaper/page/24100808 | 24100808 | |
42397 | 42397 | 1924-12-06 | 3 | e-f | Sun Yatsen turns to Japan for help. | Japan | http://trove.nla.gov.au/newspaper/page/24100954 | 24100954 | |
42914 | 42914 | 1925-03-28 | 3 | e-f | Fire in Tokyo and the casualties. | Japan | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 |
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]);