This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15559 | 15559 | 1906-04-07 | 6 | a | Report in a New Zealand newspaper fabricates a case against Chinese in Australia and South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800946 | 26800946 | |
15560 | 15560 | 1906-04-07 | 6 | a | Stories of Japanese army commander Koshaku Togo Heihachiro. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800946 | 26800946 | |
15561 | 15561 | 1906-04-07 | 6 | b | Jokes between a couple on officials ranks. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800946 | 26800946 | |
15562 | 15562 | 1906-04-07 | 6 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800946 | 26800946 | |
15563 | 15563 | 1906-04-07 | 6 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800946 | 26800946 |
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]);