This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26812 | 26812 | 1912-09-28 | 7 | a | China's consul general to Australia's notice about change of Australian regulations for Chinese students and businessmen's entry into Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092395 | 24092395 | |
26813 | 26813 | 1912-09-28 | 7 | a-b | Australian new regulations for Chinese students and businessmen's entry into Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092395 | 24092395 | |
26814 | 26814 | 1912-09-28 | 7 | b | Guangdong railway company issues third shares. | Other... | http://trove.nla.gov.au/newspaper/page/24092395 | 24092395 | |
26815 | 26815 | 1912-09-28 | 7 | b-c | Australian news/ Parliament member tells white Australians can live in Northern Territory after his visit there. Australian Aircraft School pilot coach allowed to resign. Sydney municipal council intends to borrow loans. Three Victorian teenagers imitate movies figures to do robberies. Melbourne robber sentenced to death. | Other... | http://trove.nla.gov.au/newspaper/page/24092395 | 24092395 |
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]);