This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56037 | 56037 | 1936-07-11 | 2 | b | Circular telegrams issued by the Southwest authorities to protest against more Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56038 | 56038 | 1936-07-11 | 2 | c | Dispute between Guangzhou and Nanjing over the resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56039 | 56039 | 1936-07-11 | 2 | e | New deals between the Nanjing government and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56040 | 56040 | 1936-07-11 | 2 | f | Japanese argues for their military existence in north China. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56041 | 56041 | 1936-07-11 | 2 | f | Many students are leaving Tianjin for the south. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 |
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]);