This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 142 | 142 | 1898-07-13 | 3 | a | NSW, Local council, appeal to government to help poor. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 143 | 143 | 1898-07-13 | 3 | a | Ship owner allows stowaway to continue travel from Liverpool to Sydney. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 144 | 144 | 1898-07-13 | 3 | a-b | The Governor of Hunan province, Wu Qingqing, writes an article praying for rain. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 145 | 145 | 1898-07-13 | 3 | b | Chinese prisoner committs suicide in Melbourne jail. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 146 | 146 | 1898-07-13 | 3 | b-c | Romantic young man in New Castle injured his girlfriend. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 147 | 147 | 1898-07-13 | 3 | c | Rumours that dynasty will change spread in Jiujiang, Jiangxi province. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 148 | 148 | 1898-07-13 | 3 | c-d | Prostitute in Guangzhou, preparation for opium smoking. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 149 | 149 | 1898-07-13 | 3 | d | Hundreds dies as French ocean liner sinks after colliding with ship. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 150 | 150 | 1898-07-13 | 3 | d-e | Court case, Sydney, woman lost her parrot, neighbour found it, judge ordered boy return parrot. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 151 | 151 | 1898-07-13 | 3 | e | Man from Suzhou, Jiangsu province, pretended to be rich to cheat prostitutes in Shanghai. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 152 | 152 | 1898-07-13 | 3 | e | Crime. Man sentenced for stealing clothes from Chinese in gambling house. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 153 | 153 | 1898-07-13 | 3 | f | Baby found abandoned near Sydney beach. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 154 | 154 | 1898-07-13 | 3-2 | f-a | Master approved of Buddhist nun in Guangdong marrying. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 155 | 155 | 1898-07-13 | 2 | a | Western Australia, discovery of gold, lake. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 156 | 156 | 1898-07-13 | 2 | a | Woman in Sydney unsuccessfully sued her three-year-old neighbour. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 157 | 157 | 1898-07-13 | 2 | a-b | Banana, grapes and similar materials can be used to manufacture sugar. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 158 | 158 | 1898-07-13 | 2 | b | Guangzhou, two men, court case, concubine. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 159 | 159 | 1898-07-13 | 2 | b-c | Woman and man had one night romance in his garden. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 160 | 160 | 1898-07-13 | 2 | c | Fighting between Yuan and Lei clans cause serious injuries. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 161 | 161 | 1898-07-13 | 2 | c-d | Hong Kong, hen laid strange, large egg. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 162 | 162 | 1898-07-13 | 2 | d | Sixth brother of His Imperial Majority dies. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 163 | 163 | 1898-07-13 | 2 | d-e | Rebells in Guangxi are marching towards provincial capital causing chaos. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 164 | 164 | 1898-07-13 | 2 | e | New South Wales, election of Members of Parliament, policy on Chinese immigration. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 165 | 165 | 1898-07-13 | 2 | e | Russia increases demands on Chinese government. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 166 | 166 | 1898-07-13 | 2 | e-f | Strange object flew over Melbourne factory while workers watched. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 167 | 167 | 1898-07-13 | 2 | f | Serious drought in Dongguan, Guangdong, causes disease epidemic. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 168 | 168 | 1898-07-13 | 2 | f | Guangzhou, serious disease epidemic. | http://trove.nla.gov.au/newspaper/page/24102059 | 24102059 | ||
| 169 | 169 | 1898-07-13 | 4 | b-c | War, Philippines. American troops fight Luzon army. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 170 | 170 | 1898-07-13 | 4 | c | Man aged 85 marries woman, 83, in Ireland. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 171 | 171 | 1898-07-13 | 4 | c | Russia sends more weapons to their army in northeast China. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 172 | 172 | 1898-07-13 | 4 | c-d | Adelaide. Chinese man sent to psychiatric hospital, now recovered. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 173 | 173 | 1898-07-13 | 4 | d | Sugarcane farmers in Queensland seek short-term workers. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 174 | 174 | 1898-07-13 | 4 | d | Man has wise wife. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 175 | 175 | 1898-07-13 | 4 | e | High-quality spring tea from Fujian province is coming to Australia. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 176 | 176 | 1898-07-13 | 4 | e | Price list of vegetables and groceries in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 | ||
| 177 | 177 | 1898-07-13 | 4 | e | Price list of vegetables and groceries in Melbourne market. | http://trove.nla.gov.au/newspaper/page/24102057 | 24102057 |
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]);