This data as json, CSV (advanced)
Suggested facets: page, column, 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 |
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]);