This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23089 | 23089 | 1910-07-02 | 8 | a | A memorial report submitted by Jiang Chunlin to impeach Prince Zai Xun and Prince Zai Tao. | China | http://trove.nla.gov.au/newspaper/page/26802688 | 26802688 | |
23090 | 23090 | 1910-07-02 | 8 | a-b | More petitions to the establishment of national parliament in China. | China | http://trove.nla.gov.au/newspaper/page/26802688 | 26802688 | |
23091 | 23091 | 1910-07-02 | 8 | b | Chinese communities in Australia donate to the orphanage in Xiangshan county, Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802688 | 26802688 | |
23092 | 23092 | 1910-07-02 | 8 | c | A notice from tong shan tang in Brisbane on the transfer of remains of deceased fellows back to China. The areas covered are Brisbane, Ipswich, Toowoomba, Warwick, Killarney, Inglewood, Stanthorpe, Texas, Goondiwindi, Mungindi, Esk, Dalby, Miles, Youlba, Roma, Surat, Mitchell, Morven, Charleville, Cunnamulla, Thargomindah, Rulo, Adaville, Windorah, Jundah, Isisford, Blackall, Tombo, Augathella, Gympie, Kilkivan, Maryberough, Gayndah, Chinders, Mount Perry, Eidsvold, Toroom, Bundaberg, and Gladstone. The people to contact are Sue On Lee, Roma Street, Brisbane; Lun Sing, Wickham Street, Brisbane; Dickson, Melbourne Street, Brisbane; You Sang, Roma Street Market, Brisbane; S. Jue Yow & Sons, 20 Roma Street, Brisbane; On War Tiy & Co., Wickham Street, Brisbane; See War & Co., 24-27 Brunswick Street, Brisbane; and Jim Yin, Wharf Street, Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802688 | 26802688 |
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]);