This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3712 | 3712 | 1899-09-30 | 3 | a-c | A picture of the building of Wing Sang & Co., 20-22 Campbell St, Sydney. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3713 | 3713 | 1899-09-30 | 3 | a-b | A Japanese ship saves dozens of Sydney boys. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3714 | 3714 | 1899-09-30 | 3 | b-c | The owner of a big newspaper in Sydney was charged and penalised; two female thieves sentenced; Chinese robbed in Sydney by two men (one of whom has been caught by police); a young doctor on York Street commits suicide; boy falls from train from Sydney to Melbourne; silver plate stolen from a Catholic church in Ballarat; Wollongong man starves to death; gold transportation from Queensland by a Sydney steamship company. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3715 | 3715 | 1899-09-30 | 3 | d | Victoria expects a good harvest this year; a Chinese in Melbourne was fined for working overtime; a couple drown in Wellington. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3716 | 3716 | 1899-09-30 | 3 | d | Bullies target a man in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3717 | 3717 | 1899-09-30 | 3 | d | Boy punished for attempted theft. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3718 | 3718 | 1899-09-30 | 3 | d | A young woman in Perth sues her boyfriend for refusing to marry her. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3719 | 3719 | 1899-09-30 | 3 | e | A girl in Melbourne was compensated for being bitten by a dog. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3720 | 3720 | 1899-09-30 | 3 | e | The numbers printed on coins indicate whether or not they are counterfeit. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3721 | 3721 | 1899-09-30 | 3 | e | Queensland cares for orphans. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3722 | 3722 | 1899-09-30 | 3 | e | Man charged with rape; Chinese man in Shepparton faces court charge with rape. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3723 | 3723 | 1899-09-30 | 3 | e | A father in Melbourne was sentenced to seven years' imprisonment for committing incest. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3724 | 3724 | 1899-09-30 | 3 | f | A priest who provoked his audience narrowly escapes from being attacked. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3725 | 3725 | 1899-09-30 | 3 | f | All carpenters should not work on Sundays. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3726 | 3726 | 1899-09-30 | 3 | f | Arrival and departure of ocean liners. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3727 | 3727 | 1899-09-30 | 3 | f | Gold price in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 |
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]);