This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23399 | 23399 | 1910-08-27 | 8 | a | A meeting of petition representatives in Beijing for the establishment of national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802752 | 26802752 | |
23400 | 23400 | 1910-08-27 | 8 | b | Jokes/ Ideal flying machine. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802752 | 26802752 | |
23401 | 23401 | 1910-08-27 | 8 | b-c | Political fiction/ A girl spy, part II. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802752 | 26802752 | |
23402 | 23402 | 1910-08-27 | 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/26802752 | 26802752 |
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]);