This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2133 | 2133 | 1899-04-05 | 3 | b | More than 21,000 British people sign their names in a petition to the Queen. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2134 | 2134 | 1899-04-05 | 3 | c-d | The cost of war; the number of US soldiers who died in recent fighting; British doctors help to heal US soldiers; The Times in London comments on the war. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2135 | 2135 | 1899-04-05 | 3 | d | George Lee, 9, of Sydney, kicked to death by a horse. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2136 | 2136 | 1899-04-05 | 3 | d | Cost of living increases in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2137 | 2137 | 1899-04-05 | 3 | e | The market is dull in Nanjing, even before the Spring Festival. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2138 | 2138 | 1899-04-05 | 3 | e | The Governor of Jiangsu and Zhejiang cares about market operation. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2139 | 2139 | 1899-04-05 | 3 | e | Business in Hangzhou market decreases, prices increase. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2140 | 2140 | 1899-04-05 | 3 | e | Growth in Xiamen market this year is flat. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2141 | 2141 | 1899-04-05 | 3 | e-f | Market price is up in Jiangxi. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2142 | 2142 | 1899-04-05 | 3 | f | British army has preserved well traditional etiquette. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2143 | 2143 | 1899-04-05 | 3 | f-g | Bandit groups in Woyang area, Anhui province, disbanded by government. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2144 | 2144 | 1899-04-05 | 3 | g | People injured by fireworks in a festival celebration in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2145 | 2145 | 1899-04-05 | 3 | h | Woman in Yangzhou, Jiangsu province, beats three robbers. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2146 | 2146 | 1899-04-05 | 3 | h | Riot on the border of Russia and the northeast of China. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2147 | 2147 | 1899-04-05 | 3 | i | A kind of fast sledge in north America. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2148 | 2148 | 1899-04-05 | 3 | i | A golf match in London. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2149 | 2149 | 1899-04-05 | 3 | i | British man pays huge tax bill. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2150 | 2150 | 1899-04-05 | 3 | j | Melbourne man killed in Nanyang. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2151 | 2151 | 1899-04-05 | 3 | j | A new style of bicycle in China. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2152 | 2152 | 1899-04-05 | 3 | j | Big celebration party in Sydney. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2153 | 2153 | 1899-04-05 | 3 | k | Playing with dragons is not just a game for children. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2154 | 2154 | 1899-04-05 | 3 | l | China stops negotiating with Italy on issue of Sanmen Bay, new ambassador yet to arrive in Beijing. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2155 | 2155 | 1899-04-05 | 3 | l | Man in Belgium detained in France for spying. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2156 | 2156 | 1899-04-05 | 3 | l | Casualties of war between US and Spain in Luzon. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2157 | 2157 | 1899-04-05 | 3 | l | A bridge under construction in Tasmania collapses. Four workers killed in accident. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2158 | 2158 | 1899-04-05 | 3 | l | Britain prepares new budget for this year. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 |
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]);