This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1035 | 1035 | 1898-10-29 | 3 | a-b-c | Strengthening China is like to curing an illness, only fundamental solutions will work. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1036 | 1036 | 1898-10-29 | 3 | c | Chinese men fight with Western youths in graveyard in West Wyalong, NSW when Chinese visit ancestors' graves. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1037 | 1037 | 1898-10-29 | 3 | c-d | Woman, daughter of tenant taken away when he could not pay rent. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1038 | 1038 | 1898-10-29 | 3 | d | His Majesty welcomes comments on state affairs. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1039 | 1039 | 1898-10-29 | 3 | d-e | Girl in Xinhui faced and overcame threat of ghost who harassed her. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1040 | 1040 | 1898-10-29 | 3 | e | Counterfeit money found in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1041 | 1041 | 1898-10-29 | 3 | e-f | Poor girl in Sydney commits suicide due to poverty. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1042 | 1042 | 1898-10-29 | 3 | f | Injuries occur as people in Shunde gather together to celebrate the Mid-Autumn Festival. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
1043 | 1043 | 1898-10-29 | 3 | f | Newspapers accessible to more and more people in Guangdong, who now learn more about outside world. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 |
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]);