This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20801 | 20801 | 1909-03-20 | 2 | c | Photograph of Emperor Xuantong, his father Prince Regent and his brother Pu Jie. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802116 | 26802116 | |
20814 | 20814 | 1909-03-20 | 6 | c | Business in Saigon is booming. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
20815 | 20815 | 1909-03-20 | 6 | c | Diplomacy and negotiations between China and Japan in 1908. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
20816 | 20816 | 1909-03-20 | 6 | c | Vietnamese authority imposes higher poll tax upon Chinese from 1909. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
20817 | 20817 | 1909-03-20 | 6 | c | American authority in the Philippines imposes new and stricter regulations upon Chinese immigration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
20827 | 20827 | 1909-03-20 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 | |
20828 | 20828 | 1909-03-20 | 7 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 |
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]);