This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22937 | 22937 | 1910-06-11 | 3 | a-b | Guangdong news/ Yuan Shuxun explains why Hong Kong newspapers are banned. Guangdong pays its share for the mausoleum project of the late Emperor Guangxu. Revenue and expenditure of Guangdong in 1909. Japanese are spying fortification sites in Guangdong. Chinese consul in Singapore Zuo Binglong reports that Ou Jujia is found smuggling weapons. County magistrate of Panyu interrogates Luo Mubao who allegedly murder Liu Shiji. Building of naval fortification in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 | |
22938 | 22938 | 1910-06-11 | 3 | b | China in crisis/ Inflation and high prices. Anti-Manchurian feelings. Revolutionary movement, their slogans and warnings to foreigners in China, and assistance from overseas Chinese communities. | Britain | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 | |
22939 | 22939 | 1910-06-11 | 3 | c | Chinese communities in San Francisco and other American cities ask for permission from Chinese government to cut their pigtails. | America | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 | |
22940 | 22940 | 1910-06-11 | 3 | c | American President William Taft calls for an international peace conference for disarmament. | Britain | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 | |
22941 | 22941 | 1910-06-11 | 3 | c | Emperor of Austria tours Balkan peninsula. | Britain | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 | |
22942 | 22942 | 1910-06-11 | 3 | c-d | New York to have an international exhibition in 1913. | America | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 | |
22943 | 22943 | 1910-06-11 | 3 | d | A letter from Hong Kong on the demarcation of Macao border. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26802657 | 26802657 |
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]);