This data as json, CSV (advanced)
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]);