This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42922 | 42922 | 1925-03-28 | 7 | a | Australia's trade with Germany and the statistics on import and export. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42923 | 42923 | 1925-03-28 | 7 | a | Population increases in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42924 | 42924 | 1925-03-28 | 7 | a | Italian consul in Australia suggests to accept more immigrants. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42925 | 42925 | 1925-03-28 | 7 | a | Quarrel between Chinese shop owner and white customer in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42926 | 42926 | 1925-03-28 | 7 | a | An old couple is crushed to death in a traffic accident in Parramatta, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42927 | 42927 | 1925-03-28 | 7 | a-b | Chinese Chamber of Commerce in Sydney gathers to congratulate their new board directors. Speakers include Su Yiguang, Wu Zhaoquan, Zhu Songqing, Chen Qingyi, Guo Jianying, Zheng Fanchang, Pan Yonghan, Liu Junchen, Wu Elou, Guo Jiexiu, Zhang Fu, Chen Zanhua, Lin Run, and Liu Guangfu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42928 | 42928 | 1925-03-28 | 7 | c | A Chinese wedding in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42929 | 42929 | 1925-03-28 | 7 | c | Korean people attack Japanese police bureau in the north of Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42930 | 42930 | 1925-03-28 | 7 | c | International peace conference to be held in San Francisco in 1926. | America | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42931 | 42931 | 1925-03-28 | 7 | c | Bandits in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42932 | 42932 | 1925-03-28 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 |
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]);