This data as json, CSV (advanced)
Suggested facets: page, column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29560 | 29560 | 1915-01-09 | 8 | a | St Francisco Constitutional Party organises New World Airship Company, which is to provide airships for China. | America | http://trove.nla.gov.au/newspaper/page/24094686 | 24094686 | |
29561 | 29561 | 1915-01-09 | 8 | a | Xia Xiefu's letter to Tan Mingsan on issues of St Francisco Constitutional Party sending airships to China. | China | http://trove.nla.gov.au/newspaper/page/24094686 | 24094686 | |
29562 | 29562 | 1915-01-09 | 8 | a-b | Notice of New World Airship Company on why the airships can't go to China for exhibition. | China | http://trove.nla.gov.au/newspaper/page/24094686 | 24094686 | |
29563 | 29563 | 1915-01-09 | 8 | b-c | Guangdong news (continued)/Guangdong is to establish a coast defending organisation. Overseas Chinese girl students in Southeast Asia are enthusiastic in buying China's public loans. A Guangdong girl meets a bird speaking human language. A woman who makes a false charge on her husband is sentenced to death in Guangdong. Guangdong people are against the establishment of gambling sites. Guangdong is to develop its mining industry with help of overseas Chinese. Yongan village outside of Guangzhou city receives funds from overseas Chinese for its defending organisation. | China | http://trove.nla.gov.au/newspaper/page/24094686 | 24094686 |
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]);