This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24787 | 24787 | 1911-08-05 | 2 | c | Brief headline news | New money is to be in use. Russia horse cavalry is three times more than Chinese's in Manchu and Mongolia. Governor Zhang Renjun orders Dai Naihuang to pay his debts. Money supplies for empress's life at Summer Palace. The design of uniform for diplomats. Flood in Hunan. The navy department asks the cruiser to go to Germany after its visit to America. | Other... | http://trove.nla.gov.au/newspaper/page/24091867 | 24091867 |
24802 | 24802 | 1911-08-05 | 3 | c | Beijing news | Yuan Shikai is to take office of Zi Zhen Yuan. Imperial meeting to deal with opposition to imperial cabinet. Foreign Affairs Ministry gives away a rich mine to the Japanese. No results got from Pian Ma negotiation. Duan Fang has a different view to removed officials. | China | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
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]);