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 |
---|---|---|---|---|---|---|---|---|---|
50128 | 50128 | 1931-03-28 | 2 | b | Second and final part of comments by Tung Wah Times on Japan's new policy on railway construction and management in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090325 | 24090325 | |
50136 | 50136 | 1931-03-28 | 5 | d | Tea waiter in the Shanghai court. Waitress and the restaurants in Beijing. Academic field in Fuzhou, Fujian province, and their stories. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090326 | 24090326 | |
50137 | 50137 | 1931-03-28 | 5 | e | Farewell message by Lei Miaobing on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090326 | 24090326 | |
50138 | 50138 | 1931-03-28 | 5 | e | A notice by Wu Tongbo of the Kwong Wing Chong & Co in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090326 | 24090326 | |
50139 | 50139 | 1931-03-28 | 5 | e | A notice by the Dongguan gong yi tang in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090326 | 24090326 | |
50151 | 50151 | 1931-03-28 | 8 | c | Australia news/ Unemployed people are punished in Sydney for overclaiming grain supplies. A man in Sydney commit suicide. A passenger plane disappears on its way from Sydney to Melbourne. Federal government in heavy debts. Chinese sailor runs away in Sydney. Labour government of NSW proposes to abandon the senate and to replace the state governor. Parcels lost in a train. Food cheque stolen in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 |
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]);