This data as json, CSV (advanced)
Suggested facets: page, column, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25846 | 25846 | 1912-03-09 | 6 | c | Number of Italian soldier died in the battles | Statistics of Italians died in the war between Italy and Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24092161 | 24092161 |
25847 | 25847 | 1912-03-09 | 6 | c | The previous Parse king leaves his country | Parse king leaves for a retreat after abdication, and Parse government decides to provide sufficient fund for him. | Other... | http://trove.nla.gov.au/newspaper/page/24092161 | 24092161 |
25849 | 25849 | 1912-03-09 | 6 | c | Wireless telephone | A man named Xie Ke (nnn) invested a wireless telephone for navigating. | Other... | http://trove.nla.gov.au/newspaper/page/24092161 | 24092161 |
25854 | 25854 | 1912-03-09 | 8 | a-b | Miscellany of constitutions in democratic countries | Development of democracy in France, | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
25855 | 25855 | 1912-03-09 | 8 | b | Guangdong railway issue | Guangdong railway sharers hold its general meeting. | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
25856 | 25856 | 1912-03-09 | 8 | b-c | Guangdong temporary provincial government's meeting | Guangdong temporary provincial government holds meeting discussing about demolising city walls. | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
25857 | 25857 | 1912-03-09 | 8 | d | Appeal for donations to republic army | Notice of those in Hong Kong appeal for donations to republic army. | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
25858 | 25858 | 1912-03-09 | 8 | d | Xiangshan county mayor's notice | Xiangshan county mayor issues notice about donations to republic army. | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
25859 | 25859 | 1912-03-09 | 8 | d | Organisation for donation set up in Sydney | Organisation for donation to republic army set up in Sydney. Organisation members' names listed. | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
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]);