This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48097 | 48097 | 1929-05-11 | 5 | a | Hong Kong news/ Guangdong delegates returning from Nanjing talks in Hong Kong the arrest of Li Jishen and other news from the central Nationalist authority. Rumour says Bai Chongxi has secretly arrived Hong Kong. The sale of Japanese goods going up following the solution to the case of Jinan. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099211 | 24099211 | |
48098 | 48098 | 1929-05-11 | 5 | c | No virgin girl in Leningrad, Soviet Union. France has more women than men. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099211 | 24099211 |
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]);