This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
122 | 122 | 1898-07-09 | 2 | a | Letter from a friend in Gaoyao, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
123 | 123 | 1898-07-09 | 2 | a | American Embassy in Sydney celebrates Independence day on July 4. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
124 | 124 | 1898-07-09 | 2 | a | Man in Sydney was detained and penalised for carrying gun without license. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
125 | 125 | 1898-07-09 | 2 | a-b | Sydney church. Farewell part held for Yang Guancai, who was returning to China. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
126 | 126 | 1898-07-09 | 2 | b | Monk in Jiangsu province gives different interpretation to Buddhist sutra. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
127 | 127 | 1898-07-09 | 2 | b-c | Assorment of items: newspapers in Britain, post offices in America, different types of roses, distance between earth and the moon, etc. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
128 | 128 | 1898-07-09 | 2 | c | Owner of Sydney newspaper penalised for illegal registration of his business. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
129 | 129 | 1898-07-09 | 2 | c | Crime. Robbery occurred in gold mine in Victoria. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
130 | 130 | 1898-07-09 | 2 | c-d | Hypoplastic woman in Guangzhou is pregnant. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
131 | 131 | 1898-07-09 | 2 | d | War, Philippines, American troops and Luzon forces clash again. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
132 | 132 | 1898-07-09 | 2 | d-e | International diplomacy, five central and south American countries engage in friendly negotiations. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
133 | 133 | 1898-07-09 | 2 | e | Money sent to Honolulu was returned, now unclaimed. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
134 | 134 | 1898-07-09 | 2 | e | Cattle injured, train accident, Victoria. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
135 | 135 | 1898-07-09 | 2 | e-f | Chinese businessman, cheated, paying money without receipt. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
136 | 136 | 1898-07-09 | 2 | f | Yang Guancai, a philanthropist, in Chinese community. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
137 | 137 | 1898-07-09 | 2 | f | French soldiers in gunboat near Guangzhou whip Chinese for allegedly failing to deliver goods. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
138 | 138 | 1898-07-09 | 2 | f | Several Chinese sentenced for six months imprisonment crossing WA, QLD border. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 |
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]);