This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22724 | 22724 | 1910-04-30 | 6 | a | Guo feng bao is available from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802611 | 26802611 | |
22729 | 22729 | 1910-04-30 | 7 | a | Chinese consulate in New Zealand has new address which is: Chinese Consulate, Burnell Avenue, Thorndon, Wellington, New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802610 | 26802610 | |
22730 | 22730 | 1910-04-30 | 7 | a | Examination result and honour list of the Chinese School in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802610 | 26802610 | |
22731 | 22731 | 1910-04-30 | 7 | a | Chinese businessman in Melbourne Huang Shiyan is going back to China, and the farewell from Chinese consul general Liang Lanxun, Kong Chew Society and the Chinese Empire Reform Association in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802610 | 26802610 | |
22732 | 22732 | 1910-04-30 | 7 | a | Quite a few Chinese are arrested in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802610 | 26802610 |
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]);