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 |
---|---|---|---|---|---|---|---|---|---|
36561 | 36561 | 1921-01-29 | 3 | a | An open letter from Sa Zhenbing, chief naval commander in China. | Other... | http://trove.nla.gov.au/newspaper/page/24093409 | 24093409 | |
36569 | 36569 | 1921-01-29 | 7 | a | Commonwealth government of Australia to conduct census on April 4. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093413 | 24093413 | |
36570 | 36570 | 1921-01-29 | 7 | a | Chinese gardener in New Castle Zhong Maolin, a native of Gaoyao county, is murdered on his way to sell vegetables in the city. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093413 | 24093413 | |
36571 | 36571 | 1921-01-29 | 7 | a | Many Chinese passengers choose the liner of China-Australia Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093413 | 24093413 | |
36576 | 36576 | 1921-01-29 | 8 | a | Chinese communities in Australia call for donations to the drought, flooding and famine areas in China. Donation collectors are: Wing On Co, Lee Sang & Co, On Chong & Co, Tiy Loy & Co, Tung Wah Times, Chinese Chamber of Commerce, Kwong War Chong & Co, and Sun Suiy Wah Store. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093416 | 24093416 | |
36577 | 36577 | 1921-01-29 | 8 | a | Chinese Chamber of Commerce in New South Wales calls for donations to the war disaster area in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093416 | 24093416 |
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]);