This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1135 | 1135 | 1898-11-12 | 3 | a | Governments in Nanhai and Panyu counties pursue family members of Kang Youwei and Liang Qichao. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1136 | 1136 | 1898-11-12 | 3 | a-b | Young woman and and matchmaker collaborate in order to make money from men. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1137 | 1137 | 1898-11-12 | 3 | b | International relations, Japanese government sends representative to visit China, greeted with welcoming ceremony. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1138 | 1138 | 1898-11-12 | 3 | b-c | Man in Guangzhou quit opium smoking and wrote poems. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1139 | 1139 | 1898-11-12 | 3 | c | Man in Dongguan faces disaster after trying to remarry. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1140 | 1140 | 1898-11-12 | 3 | c-d | Merry nun in Guangzhou married finally. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1141 | 1141 | 1898-11-12 | 3 | d-e | Gangsters, bandits discovered near Beijing; Chinese ambassador to Russia and Germany, Mr Xu Jingcheng, recalled; Japanese envoy visits China with letter from Japanese Emperor. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1142 | 1142 | 1898-11-12 | 3 | e | White ants in India destroy grains. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1143 | 1143 | 1898-11-12 | 3 | e | Daughter-in-law and her new life; fighting between two family clans. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
1144 | 1144 | 1898-11-12 | 3 | f | American oil ship from New York to Yokohama changes its route to Adelaide due to bad weather. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 |
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]);