This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55737 | 55737 | 1936-01-18 | 6-7 | a-d | Guangdong news/ Zhongshan University students and their demonstration against Japanese invasion. Chinese airforce troops are stronger. The southwest authority putss forward their proposals to the central government to resistance of Japanese invasion. The business in Guangzhou. Illeal opium growing in Panyu county. | China | http://trove.nla.gov.au/newspaper/page/24096716 | 24096716 |
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]);