This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50220 | 50220 | 1931-04-25 | 2 | e | Japanese senate veto the rights to vote for women. | Japan | http://trove.nla.gov.au/newspaper/page/24090357 | 24090357 | |
50221 | 50221 | 1931-04-25 | 2 | e | Hundreds of Chinese government officials charged with corruption. Disputes between Xikang, Tibet and Mongolia. Japanese students delegation visits Manchuria. Opium trade and smuggling in Chongqing, of Sichuan province. Sun Lianzhong and Zhu Shaoliang jointly suppress communists in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24090357 | 24090357 | |
50228 | 50228 | 1931-04-25 | 3 | e | The ceramic industry in Jingdezhen, of Jiangxi province, after the communist disasters. | China | http://trove.nla.gov.au/newspaper/page/24090356 | 24090356 | |
50232 | 50232 | 1931-04-25 | 5 | e | Notice issued by Chinese Consul-General in Australia Gui Zhi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090358 | 24090358 | |
50233 | 50233 | 1931-04-25 | 5 | e | A notice issued by the gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090358 | 24090358 | |
50248 | 50248 | 1931-04-25 | 8 | e | Two notices issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 | |
50249 | 50249 | 1931-04-25 | 8 | e | Notice for an inaugural meeting of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 |
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]);