This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29628 | 29628 | 1915-01-23 | 8 | a-b | Travel records/ tradition and customs in Brazil. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 | |
29629 | 29629 | 1915-01-23 | 8 | b | China Associations in America are against Chinese government's plan of making loans from American capitalists. | America | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 | |
29630 | 29630 | 1915-01-23 | 8 | b | Overseas Chinese in Mexico are leading miserable life after the Mexico revolution. | Other... | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 | |
29631 | 29631 | 1915-01-23 | 8 | b-c | Guangdong news (continued)/ Artillery for shooting planes is installed in Xiou Shan, Guangdong. A womon detective in Guangdong is arrested for illegally breaking in houses. Li Wenfu is leading a troop attacking bandits in Tong Wan, Guangdong. An extraordinary grass is found in Guangdong. A good harvest year is expected for Gaoyao, Guangdong. Some detectives are using strange words to disturb passengers. A man is arrested for illegally own guns in Guangzhou. Guanghua Hospital in Guangzhou has removed a huge tumour in a womon. Two airships from America are transported to Guangzhou. Hong Kong businessnen gather to protest banning Republic Newspaper. | China | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 |
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]);