This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52923 | 52923 | 1933-05-27 | 7-8 | a-f | Guangdong news/ Jiang Jieshi convenes a military conference and Chen Cheng is removed from his position. The 19th Route Army on the way to fight Japanese invaders. Road project in Luofu. Provincial government repeats to respect the human rights. A naked swimming in Hong Kong. A martial arts performance in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091239 | 24091239 |
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]);