This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
320 | 320 | 1898-07-30 | 3 | a | Second part of article written by Zhang Zhidong to encourage learning. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
321 | 321 | 1898-07-30 | 3 | b | Famine in eastern Guangdong has followed by banditry; ocean liner arrived in Sydney from Hong Kong; poor harvest in Zengcheng; robbery in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
322 | 322 | 1898-07-30 | 3 | b-c | Two parting poems for Mr Bao Chi who is going to Perth, Western Australia. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
323 | 323 | 1898-07-30 | 3 | c | Russia change attitude, allows China to have British officers train Chinese navy. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
324 | 324 | 1898-07-30 | 3 | c | Woman in Guangzhou arrested for harbouring stolen goods. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
325 | 325 | 1898-07-30 | 3 | c-d | Comments of Gong Qinwang, brother of His Imperial Majesty, on government officials before passing away. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
326 | 326 | 1898-07-30 | 3 | d | Woman in Adelaide died at 102. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
327 | 327 | 1898-07-30 | 3 | d-e | MP candidate in NSW humiliated during election campaign. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
328 | 328 | 1898-07-30 | 3 | e | Man in Toowoomba lost all vision suddenly. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
329 | 329 | 1898-07-30 | 3 | e | Britain will build 40 more gunboats this year. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
330 | 330 | 1898-07-30 | 3 | e-f | Poor girl in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
331 | 331 | 1898-07-30 | 3 | f | London, Prince recovering from broken leg. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
332 | 332 | 1898-07-30 | 3 | f | Ship sailing for New Castle sighted big fish in sea. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
333 | 333 | 1898-07-30 | 3-2 | f-a | Businessman in Sydney penalised for employing child labour. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 |
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]);