data: glam-datasets: 1 row where where file_description = "**Community History Endpoints** **Organisations** http://data.history.sa.gov.au/communityhistory/organisations **News** http://data.history.sa.gov.au/communityhistory/news **Events** http://data.history.sa.gov.au/communityhistory/events **Blogs** http://data.history.sa.gov.au/communityhistory/blogs **Article Detail** The nid field on each of the items (listed using any of the above endpoints) can be used to get specific detail using the following endpoint: http://data.history.sa.gov.au/communityhistory/{nid} Replace {nid} with the nid obtained from one of the above endpoints. **Files** The nid field on each of the events (listed using any of the above endpoints) can be used to get associated files (including base64 values) using the following endpoint: http://data.history.sa.gov.au/communityhistory/{nid}/files Replace {nid} with the nid obtained from one of the above endpoints. **Taxonomy** http://data.history.sa.gov.au/communityhistory/taxonomy/{id} Replace {id} with the taxonomy term id (represented by target_id throughout content)" and publisher = "History Trust of South Australia"

1 row where file_description = "Community History Endpoints Organisations http://data.history.sa.gov.au/communityhistory/organisations News http://data.history.sa.gov.au/communityhistory/news Events http://data.history.sa.gov.au/communityhistory/events Blogs http://data.history.sa.gov.au/communityhistory/blogs Article Detail The nid field on each of the items (listed using any of the above endpoints) can be used to get specific detail using the following endpoint: http://data.history.sa.gov.au/communityhistory/{nid} Replace {nid} with the nid obtained from one of the above endpoints. Files The nid field on each of the events (listed using any of the above endpoints) can be used to get associated files (including base64 values) using the following endpoint: http://data.history.sa.gov.au/communityhistory/{nid}/files Replace {nid} with the nid obtained from one of the above endpoints. Taxonomy http://data.history.sa.gov.au/communityhistory/taxonomy/{id} Replace {id} with the taxonomy term id (represented by target_id throughout content)" and publisher = "History Trust of South Australia"

Search:

descending

Link	rowid ▼	dataset_title	publisher	author	dataset_issued	dataset_modified	dataset_description	source	info_url	start_date	end_date	file_title	download_url	format	file_description	file_created	file_modified	file_size	licence
839	839	Community History Live Stream	History Trust of South Australia	History Trust of South Australia	2015-05-15T01:26:37.366511	2017-06-27T02:08:43.727429	The community history website is a place for community organisations, historical groups and individu…	data.sa.gov.au	https://data.sa.gov.au/data/dataset/2ce2ab30-d17f-4902-b344-314e4b34538a	2011-04-01	2015-05-31	Community History Live Stream	https://data.history.sa.gov.au/communityhistory/	API	Community History Endpoints Organisations http://data.history.sa.gov.au/communityhistory/o…	2015-05-15T11:33:00.199640			Creative Commons Attribution

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [glam-datasets] (
   [dataset_title] TEXT,
   [publisher] TEXT,
   [author] TEXT,
   [dataset_issued] TEXT,
   [dataset_modified] TEXT,
   [dataset_description] TEXT,
   [source] TEXT,
   [info_url] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [file_title] TEXT,
   [download_url] TEXT,
   [format] TEXT,
   [file_description] TEXT,
   [file_created] TEXT,
   [file_modified] TEXT,
   [file_size] TEXT,
   [licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
    ON [glam-datasets] ([source], [publisher], [format], [licence]);