This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22416 | 22416 | 1910-02-26 | 2 | c | Prince Regent, Xi Liang, Cheng Dequan, and others donate to the repayment of foreign debt. | China | http://trove.nla.gov.au/newspaper/page/26802536 | 26802536 | |
22417 | 22417 | 1910-02-26 | 2 | c | Chinese soldiers to cut their hair and to change their uniform. | China | http://trove.nla.gov.au/newspaper/page/26802536 | 26802536 | |
22427 | 22427 | 1910-02-26 | 3 | c | A public notice from the Chinese Consulate General in Melbourne on a census of Chinese population in Australia, and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22432 | 22432 | 1910-02-26 | 6 | c | Chinese almanac available from The Chinese Association in New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802540 | 26802540 | |
22437 | 22437 | 1910-02-26 | 7 | c | Message from priest/ Extracts of the New Testament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802539 | 26802539 | |
22439 | 22439 | 1910-02-26 | 8 | c | A reader's letter to the Tung Wah Times on the Chinese New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802542 | 26802542 | |
22440 | 22440 | 1910-02-26 | 8 | c | Jokes/ Opium addict writes to sport game. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802542 | 26802542 | |
22441 | 22441 | 1910-02-26 | 8 | c | Tung Wah Times comments on the silent China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802542 | 26802542 |
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]);