This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26475 | 26475 | 1912-07-27 | 7 | a-b | Chinese consulate issues regulations on promotion of donations to Chinese nation in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092323 | 24092323 | |
26476 | 26476 | 1912-07-27 | 7 | b | Chinese consul general's explanation about the regulations on promotion of donations to Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092323 | 24092323 | |
26477 | 26477 | 1912-07-27 | 7 | b | Sydney branch's regulations on promotion of donations to Chinese nation and committee members. | Other... | http://trove.nla.gov.au/newspaper/page/24092323 | 24092323 | |
26478 | 26478 | 1912-07-27 | 7 | b-c | Congress for promotion of donations to Chinese nation held in Sydney. Chinese consul general hands over collected donations from Sydney to Chinese foreign affairs department. Australia plans to build wool manufacturing factory. Hong Kong ship caught in Sydney for smuggling illegal migrants. Australian-Chinese's wife is asked to leave Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092323 | 24092323 |
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]);