This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24644 | 24644 | 1911-07-01 | 2 | a | Editorial | An editorial comments on the staff of the new Cabinet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24645 | 24645 | 1911-07-01 | 2 | b | Opposition to nationalisation of main railway lines | An opposition to the nationalisation of main railway lines in China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24646 | 24646 | 1911-07-01 | 2 | b | Reports of resignation submitted by Prince Qing, Xu Shichang and Na Tong | Reports of resignation submitted by Premier Prince Qing, Vice-premier Na Tong, and Vice-premier Xu Shichang. | China | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24647 | 24647 | 1911-07-01 | 2 | c | German colony applies to recruit Chinese labourers but refused | A German company applied to recruit Chinese labourers in Guangdong but was refused. | China | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24648 | 24648 | 1911-07-01 | 2 | c | Opium consumption in China | Statistics of opium consumption in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24649 | 24649 | 1911-07-01 | 2 | d | Overseas Chinese students | Statistics of Chinese students in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24650 | 24650 | 1911-07-01 | 2 | d | Population of Korea | Census and population in Korea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24651 | 24651 | 1911-07-01 | 2 | d | Japan's debt | Statistics of Japan's debt. | Japan | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
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]);