This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 35082 | 35082 | 1919-11-29 | 2 | a-b | Editorial by the Tung Wah Times on the current situations in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097952 | 24097952 | |
| 35083 | 35083 | 1919-11-29 | 2-3 | b-e | Debates with the Republic News (min guo bao) on the celebration for the birthday of Confucius, the boycott to Japanese goods and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097952 | 24097952 | |
| 35084 | 35084 | 1919-11-29 | 3 | c | Japanese occupy an old temple in Boshan county, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24097951 | 24097951 | |
| 35085 | 35085 | 1919-11-29 | 3 | d | Negotiations with Portuguese on the territorial disputes near Macao. | China | http://trove.nla.gov.au/newspaper/page/24097951 | 24097951 | |
| 35086 | 35086 | 1919-11-29 | supplement | one page | Arguments with Huang Yougong and the Republic News (min guo bao). | Tung Wah | |||
| 35087 | 35087 | 1919-11-29 | 6 | a | Yan sheng gong, descent of Confucius, dies in Shandong. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35088 | 35088 | 1919-11-29 | 6 | a | Number of American troops. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35089 | 35089 | 1919-11-29 | 6 | a | Jin Yunpeng to organise new cabinet as the Chinese premier. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35090 | 35090 | 1919-11-29 | 6 | b | Students in Beijing have a class strike. | China | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35091 | 35091 | 1919-11-29 | 6 | b | American government and its strategy to suppress rebellions in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35092 | 35092 | 1919-11-29 | 6 | b | Turmoil in Cairo, capital of Egypt. | Britain | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35093 | 35093 | 1919-11-29 | 6 | b | British military officer flies from London to Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35094 | 35094 | 1919-11-29 | 6 | b | Germany is urged to sign the treaty. | Britain | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35095 | 35095 | 1919-11-29 | 6 | b | Coal miners in Chicago are on strike. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
| 35096 | 35096 | 1919-11-29 | 7 | a | Chinese community in New Zealand condemns traitors for their collaboration with Japanese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24097955 | 24097955 | |
| 35097 | 35097 | 1919-11-29 | 7 | b | Australia news/ Passenger liner Victoria organises a tea party in Brisbane for its resumed service to Hong Kong. Donations to the Australian Chinese Association against Discrimination. Hundreds of Chinese sailors arrive Sydney. A Chinese is arrested in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097955 | 24097955 | |
| 35098 | 35098 | 1919-11-29 | 7 | c | A folk song condemns Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097955 | 24097955 | |
| 35099 | 35099 | 1919-11-29 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097955 | 24097955 | |
| 35100 | 35100 | 1919-11-29 | 8 | a-b | Advertisement for the Hanyang China Iron Tools Company Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097958 | 24097958 |
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]);