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 |
---|---|---|---|---|---|---|---|---|---|
46628 | 46628 | 1928-01-07 | 2 | a | Comments by Tung Wah Times on the occasion of New Year and the responsibilities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
46641 | 46641 | 1928-01-07 | 5 | a | The Nationalist government in Nanjing and Zhang Zuolin seek cooperation to wipe out the Communists. | Britain | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46642 | 46642 | 1928-01-07 | 5 | a | Japan's foreign trade. | Japan | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46643 | 46643 | 1928-01-07 | 5 | a | Refugees in Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46644 | 46644 | 1928-01-07 | 5 | a | Guangzhou is quiet. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46650 | 46650 | 1928-01-07 | 7 | a | Australia news/ A white man is arrested in Sydney for illegally raising funds among the Chinese community. Fire on the eve of New Year in Victoria. Fire in Adelaide. Tariff income of the federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 | |
46651 | 46651 | 1928-01-07 | 7 | a | The biggest bus in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 |
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]);