This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28582 | 28582 | 1914-03-14 | 8 | a-b | Third part of the regulations issued by Chinese government on merchants and their business activities. | China | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 | |
28583 | 28583 | 1914-03-14 | 8 | b | Shanghai authority is trying to arrest Huang Xintai who hides in a foreign hotel in Hongkou, Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 | |
28584 | 28584 | 1914-03-14 | 8 | b | The New tong meng hui sets prices for assassinations. | China | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 | |
28585 | 28585 | 1914-03-14 | 8 | b | Priests of the China Inland Mission in Shanxi province plea to stop the killing of baby girl. | China | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 | |
28586 | 28586 | 1914-03-14 | 8 | b-c | Military governor of Yunnan province Cai E requests to resign and approval by the Chinese President Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 | |
28587 | 28587 | 1914-03-14 | 8 | c | A man in Berlin theatre jumps over to the stage while watching female performance. | Other... | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 | |
28588 | 28588 | 1914-03-14 | 8 | c | Guangdong news/ Overseas Chinese businessmen help to set up the bank in Guangzhou for disaster relief. Provincial authority entertains businessmen returned from overseas like Xian Junhao. Zhou Ziting, rich businessmen from British Colombia in Canada, returns to Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24093044 | 24093044 |
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]);