This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24721 | 24721 | 1911-07-22 | 2 | a-b | An editorial | An editorial is on carving up of world economy. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24722 | 24722 | 1911-07-22 | 2 | b | Brief headline news | Minister for Transport issues policies for nationalisation of private railways. Zhang Qian arrives in Beijing for talks about establishment of a China-America bank. Department of Agriculture and Commerce holds a meeting for the issue of establishment of a China-America bank. Coin factories are asked to make more money. Yunnan governor reported to Beijing about its government and military. The cabinet asks each province to have a new inspector's office. Only government owns the right of salt sale. The advisory committee has two memorials to the throne. Zhang Qian prepares for opening of China-America bank. Chen Yanlong is on leave. Russian troops in Xiangjiang are cavalry. The office of minister for transport receives thousands of applications for jobs. Liang Dunyan returns next month. The Transport Department asks for standardised rails. The Transport Department employed 150 graduates. Several riots against nationalisation of railways. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24723 | 24723 | 1911-07-22 | 2 | b-c | Overseas students in America | The number of students and graduates in America this year is the highest. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24724 | 24724 | 1911-07-22 | 2 | c | Massacre of overseas Chinese in Mexico | Many overseas Chinese were killed in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24725 | 24725 | 1911-07-22 | 2 | c-d | Minister for transport asks for more foreign loans | Minister for transport asks for more foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24726 | 24726 | 1911-07-22 | 2 | d | Foreign advisors | Many departments employ several foreign advisors. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24727 | 24727 | 1911-07-22 | 2 | d | Emperor's assistance office | Emperor's assistance office is to be opened. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24728 | 24728 | 1911-07-22 | 2 | d | Economic crisis in Guangdong | An economic cirisis happens in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
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]);