This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28490 | 28490 | 1914-02-21 | 8 | a | A notice issued by Mai Xixiang (William Ah Ket), acting Chinese Consul-General in Melbourne, on the application for passport to the United States of America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
28491 | 28491 | 1914-02-21 | 8 | a-b | Fifth part of the detailed report on the new administrative divisions in China. | China | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
28492 | 28492 | 1914-02-21 | 8 | b | Regulations issued by the Chinese Central Bank on the issue of new bank notes. | China | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
28493 | 28493 | 1914-02-21 | 8 | b | Sun Yatsen and Huang Xing arrives Nanyang. | Singapore | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
28494 | 28494 | 1914-02-21 | 8 | b-c | Guangdong news/ Notice issued by Chinese ministry of finance on the deficit. Provincial authority to ban gambling. Civil corps in Guangdong and their operations. Civil Party (gong min dang) sets up branch in Guangzhou. A man is arrested in Shunde county for counterfeit bank notes. A female robber in Xinhui county. Revolutionary rebels in Gaoming county are suppressed. Servicemen are punished for misconduct. Two criminals are executed in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 |
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]);