This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35817 | 35817 | 1920-06-19 | 3 | a | Tang Jiyao on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35818 | 35818 | 1920-06-19 | 3 | a | Japanese build munitions factory in Andong, of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35819 | 35819 | 1920-06-19 | 3 | c | Financial crisis in Japan and its influence upon the business in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35820 | 35820 | 1920-06-19 | 3 | c | Sydney newspapers reports that Chinese authority imposes new restrictions upon women's clothes. | Australia | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35821 | 35821 | 1920-06-19 | 3 | d | The hope for peace in China between the south and the north. | Britain | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35822 | 35822 | 1920-06-19 | 3 | d | Pessimism on the business in Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35823 | 35823 | 1920-06-19 | 3 | d | Robbery in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35824 | 35824 | 1920-06-19 | 3 | d | Chinese president has new advisor after the death of George Morrison. | Britain | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35825 | 35825 | 1920-06-19 | 3 | d | British Prime Minister replies to the parliament questions. | Britain | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35826 | 35826 | 1920-06-19 | 3 | e | Many factories in Japan are closed down. | Britain | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35827 | 35827 | 1920-06-19 | 3 | e | Oil ship in Kobe are on fire. | Canada | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 |
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]);