This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26555 | 26555 | 1912-08-10 | 7 | a-b | Chinese consul general issues regulations on donations to save Chinese nation in Australia for discussion. | Other... | http://trove.nla.gov.au/newspaper/page/24092339 | 24092339 | |
26556 | 26556 | 1912-08-10 | 7 | b | Chinese consul general's notice about donations to save Chinese nation. More than 50 names listed for their donations. | Other... | http://trove.nla.gov.au/newspaper/page/24092339 | 24092339 | |
26557 | 26557 | 1912-08-10 | 7 | b-c | Australian news/ Sydney Chinese primary school issues third year students' results. More than 20 names listed. Communication between Chinese consul general and Japanese consul general to Australia about Japanese king's death. New regulations for car drivers in New South Wales. Cordless radio company negotiates with government over its sale. Australia bans import of British beef as disease contamination found. A Chinese arrested for murder. Several illegal Chinese migrants arrested. | Other... | http://trove.nla.gov.au/newspaper/page/24092339 | 24092339 |
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]);