This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25052 | 25052 | 1911-09-30 | 2 | c | A new subway in New York | A opening ceremony is held for a new subway in New York. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25067 | 25067 | 1911-09-30 | 3 | c | Beijing news | The Regent is to chair a cabinet meeting. The issue of salary for cabinet members. Prince Zhen proposes pigtails cutting and change of Chinese traditional uniform. Navy budget. Prince Zhen might be promoted. An American adviser in the Department of Transport. Corrupted inspector to Sichuan and Guangdong railways. Foreign troops in Beijing and Tianjin. | Other... | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25077 | 25077 | 1911-09-30 | 7 | c | New Chinese consul to New Zealand | New Chinese consul to New Zealand is welcomed by several Chinese organisation in New Zealand. | Other... | http://trove.nla.gov.au/newspaper/page/24091941 | 24091941 |
25080 | 25080 | 1911-09-30 | 8 | c | Debates with Jingdong Newspaper | The Tung Wah Times has its debates with Jingdong Newspaper over the issue of revolution led by Sun Wen and Huang Xing. | Other... | http://trove.nla.gov.au/newspaper/page/24091944 | 24091944 |
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]);