This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50809 | 50809 | 1931-10-17 | 6 | a | A notice issued by the Dongguan gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090563 | 24090563 | |
50810 | 50810 | 1931-10-17 | 6 | b | Chinese communities in Melbourne donate to the flooding victims in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090563 | 24090563 | |
50811 | 50811 | 1931-10-17 | 6-7 | a-d | Guangdong news/ Tobacco factories in Shanghai request to stop the monopoly of sales of tobacco products. The second bridge to be built on the Zhujiang River. Pressgang in Guangzhou. Commercial chamber in Guangzhou and sale of military bonds. Disasters in Puning county. Ship sinks in Taishan county. Charity institutions help hospital patients. Sericulture in Nanhai and Shunde county. Bandit in Panyu murders his father. Doctor in Xinhui county is accused with negligence. | China | http://trove.nla.gov.au/newspaper/page/24090563 | 24090563 |
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]);