This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12888 | 12888 | 1904-03-12 | 2 | c | A letter from Sydney Chinese community to Japanese consul and Japanese government, signed by the community representatives Liu Ruxing, Ye Bingnan, Zheng Fanchang, Chen Xia, Chen Lianke, Wu Yanfan and Heyao. Donations accompanied. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800391 | 26800391 | |
12889 | 12889 | 1904-03-12 | 2 | d | The Sydney Chinese communities donate to help Japanese servicemen. More than 100 names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800391 | 26800391 | |
12891 | 12891 | 1904-03-12 | 3 | b | Mail from China awaits collection from the Tung Wah office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800390 | 26800390 | |
12892 | 12892 | 1904-03-12 | 3 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800390 | 26800390 |
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]);