This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27126 | 27126 | 1913-03-15 | 2 | c-d | Mongolia and Tibet determined to fight against Chinese troops. | Other... | http://trove.nla.gov.au/newspaper/page/24092609 | 24092609 | |
27142 | 27142 | 1913-03-15 | 3 | c-d | Guangdong news/ Guangdong-Macao railway organisers consult Sun Yat-sen. Treasury bonds start distribution in Guangdong. Provincial government is to sues Dongguan county mayor for scolding parliament members. Dongan county wedding looted by gangsters. Nanyang millionaire sends persons to explore mines in Guangdong. Daliang business in crisis. Fushan prostitute industry demands re-open. Strange visitors monitored by police due to many thefts. Former revolutionary arrested for anti current government. Kidnapped Gaoyao county kid returns. | Other... | http://trove.nla.gov.au/newspaper/page/24092608 | 24092608 | |
27153 | 27153 | 1913-03-15 | 8 | c-d | Monitor system for Guangdong Xinyong area first parliament members election. | Other... | http://trove.nla.gov.au/newspaper/page/24092615 | 24092615 |
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]);