This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26344 | 26344 | 1912-07-06 | 3 | a | Change is to happen in French cabinet due to factional fight. | France | http://trove.nla.gov.au/newspaper/page/24092295 | 24092295 | |
26345 | 26345 | 1912-07-06 | 3 | a | More women doing white collar jobs in France. | Other... | http://trove.nla.gov.au/newspaper/page/24092295 | 24092295 | |
26346 | 26346 | 1912-07-06 | 3 | a | Shandong people hate foreigners there. | Other... | http://trove.nla.gov.au/newspaper/page/24092295 | 24092295 | |
26347 | 26347 | 1912-07-06 | 3 | a | Italian troops win over its battle against Turkish army in Xuesa (nnn) city. | Other... | http://trove.nla.gov.au/newspaper/page/24092295 | 24092295 | |
26348 | 26348 | 1912-07-06 | 3 | a | Another military coup crashed in Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24092295 | 24092295 | |
26349 | 26349 | 1912-07-06 | 3 | a | Crisis of China's borrowing foreign loans as foreign nations have right to monitor these loans but Chinese people reject foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24092295 | 24092295 | |
26365 | 26365 | 1912-07-06 | 8 | a | Notice for donation to renovation of Guanghua temple in Xiangshan, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092302 | 24092302 |
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]);