This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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]);