This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30314 | 30314 | 1915-07-24 | 7 | a | Notice of consul general in Australia on calling for donations for Guangdong floods and cable letter from Guangdong government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094924 | 24094924 | |
30315 | 30315 | 1915-07-24 | 7 | a-b | Australian news/ A branch organisation of China's Trade and Business Association is established in Bendigo, Victoria. China's Trade and Business Association in Australia works on relieving Guangdong floods. Tongwan people from Guangdong in Sydney are competing to donate for Guangdong floods. Australian foreign ministry announces that Swaziland joining the Europe War is not true. Portland entreats Australian people donate to relieve its difficulties. … | Australia | http://trove.nla.gov.au/newspaper/page/24094924 | 24094924 | |
30316 | 30316 | 1915-07-24 | 7 | b-c | Battle situation in east Europe between Austrian, German and Russian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094924 | 24094924 |
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]);