This data as json, CSV (advanced)
Suggested facets: date, column, title, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24274 | 24274 | 1911-02-04 | 20 | a-b | Mr Feng Ru invented an aeroboat and radio | Mr Feng Ru from Guangdong province invented an aeroboat and radio. A photograph of Mr Feng Ru with his invented aeroboat. | Other... | http://trove.nla.gov.au/newspaper/page/24091641 | 24091641 |
25802 | 25802 | 1912-02-24 | 20 | b | The republic of the blacks | Haiti is the only republic country of the blacks in the world. | Other... | http://trove.nla.gov.au/newspaper/page/24092136 | 24092136 |
25821 | 25821 | 1912-02-24 | 20 | a | Photo of Chinese students in America | Photo of more than fifty Chinese students in America. | Other... | http://trove.nla.gov.au/newspaper/page/24092136 | 24092136 |
25822 | 25822 | 1912-02-24 | 20 | b | Photo of Chinese students in America | Photo of more than 100 Chinese students in America. | Other... | http://trove.nla.gov.au/newspaper/page/24092136 | 24092136 |
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]);