This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48207 | 48207 | 1929-06-15 | 8 | a | Deterioration of the diplomatic relations between China and Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
48208 | 48208 | 1929-06-15 | 8 | a | Documents seized from the Soviet Russian consulate in Harbin. | China | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
48209 | 48209 | 1929-06-15 | 8 | a | Water shortage in Hong Kong. | Canada | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
48210 | 48210 | 1929-06-15 | 8 | a-c | Australia news/ Limit for the use of gas in Sydney. Coal miners on strike in New South Wales. Opium smugglers detained in Sydney. Amount of rice produced in New South Wales this year. A man is punished for speeding. Telephone company in Sydney sacks an employee for illegally installing telephone machine for customer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 |
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]);