This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52718 | 52718 | 1933-04-01 | 3 | e | Russian ship arrives Shanghai after the resumption of diplomatic relations. | China | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52719 | 52719 | 1933-04-01 | 3 | e | New regulations for Chinese immigration to Thailand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52724 | 52724 | 1933-04-01 | 5 | e | Sydney Chinese Saving China Association and their call for donations to the war of resistance in China. Chinese communities in Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091173 | 24091173 | |
52736 | 52736 | 1933-04-01 | 6 | e | Storm in Fiji. | Other... | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52737 | 52737 | 1933-04-01 | 6 | e | The war in north China between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 |
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]);