This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26594 | 26594 | 1912-08-17 | 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/24092347 | 24092347 | |
26595 | 26595 | 1912-08-17 | 7 | b | Chinese consul general's notice on regulations on donations to save Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 | |
26596 | 26596 | 1912-08-17 | 7 | b | Australian news/ Australian navy stronger due to more warships added. False application for Australian citzenship are to be prosecuted. Shop owner fined for cheating customers. Millionaire miser dies of hunger on street. Boy soldiers fined for not joining exercise. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 | |
26597 | 26597 | 1912-08-17 | 7 | b-c | Several ships heavily fined for smuggling illegal migrants to Australia. Chinese woman extended her visa to six months. Pan Ru's wife ordered to leave Australia when visa expires. Several Chinese gamblers caught on spot by police. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 | |
26598 | 26598 | 1912-08-17 | 7 | c | American with strange behaviours. Austria not allow import of Chinese cut pigtails. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 | |
26599 | 26599 | 1912-08-17 | 7 | c | More than 10 names listed for their donations to Guangdong floods. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 |
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]);