This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24166 | 24166 | 1911-01-14 | 6 | a | Beijing correspondence | The progress relating to the production of new money coins and notes in Beijing Mint; problems relating to the employee selection system of the Department of Mint; an example of one poorly qualified Hubei Mint manager. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
24167 | 24167 | 1911-01-14 | 6 | a-b | A supplementary of the Cabinet interpellation | Chen Yinzhou interpellates the Ministry of Foreign Affairs on the issue concerning Northeastern China's territorial integrity. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
24168 | 24168 | 1911-01-14 | 6 | b | Zhang Renjun's talented staff | It is suggested that Zhang Renjun, the military commander of Jiangsu, has his talent, Yu Hefu took charge of all the government letters and proposals. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
24169 | 24169 | 1911-01-14 | 6 | b | Russian diplomat asked for clarification of border issue | Two Chinese officials, Zhou Jialai and Hu Cao, will set a meeting to discuss the border issue (the border of Heilong-jian province) with Russian diplomat. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
24170 | 24170 | 1911-01-14 | 6 | b | Sure impeach the traitor | Shun Daoren impeached Zhang Yi because the latter rejected the case of Kaiping mine. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
24171 | 24171 | 1911-01-14 | 6 | b | Beijing news | The Legislative Department made profits out of fees it charged for each procedure to attend its examination, obtain results, and issue certificate. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
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]);