This data as json, CSV (advanced)
Suggested facets: column, title, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24769 | 24769 | 1911-07-29 | 6 | a | China-America joint ventures | China and America are to set up a China-America bank and China-America ship company. | China | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
24770 | 24770 | 1911-07-29 | 6 | b | Correspondence from Chicago | Sun Wen has a hard time in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
24771 | 24771 | 1911-07-29 | 6 | b | Opposition to nationalisation of railways | Thousands of peasants in Hubei is angry at nationalisation of railways. They destroy railway offices and killed several officials. | China | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
24772 | 24772 | 1911-07-29 | 6 | b | Opposition to nationalisation of railways | Thousands of peasants in Hubei destroyed several railway offices and killed several officials to show their anger against nationalisation of railways. | China | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
24773 | 24773 | 1911-07-29 | 6 | b | Premier does exercises | Premier does some exercise everyday. | China | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
24774 | 24774 | 1911-07-29 | 6 | b | Donations to famines in China | Donations to famines in Jiangsu and Anhui are received. Donators include Chen Wenyuan and Fu Kaishen dunhedun (nnn). | Other... | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
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]);