My Digital Garden

Sample Steampipe queries for Hypothesis

Sample Steampipe queries for Hypothesis

My recent annotations with tags 

select
  created,
  uri,
  tags,
  group_id,
  username
from
  hypothesis_search
where
  query = 'user=synesthesia&group_id=AbGEqNA2'
  and jsonb_array_length(tags) > 0
order by
  created desc
limit
  10;

You get a CSV file that looks a bit like this:

created,uri,tags,group_id,username
2023-05-24T07:51:53.692663+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-24T07:51:43.402216+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-24T07:51:37.730272+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-24T07:51:29.028176+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-24T07:51:17.470179+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-24T07:51:01.230017+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-24T07:50:20.627833+00:00,https://futureoflife.org/wp-content/uploads/2023/04/FLI_Policymaking_In_The_Pause.pdf,"[""AI""]",__world__,synesthesia
2023-05-16T06:28:32.102262+00:00,https://openai.com/research/gpt-4,"[""ChatGPT LLM AI""]",__world__,synesthesia
2022-11-30T13:24:34.798761+00:00,https://hapgood.us/2019/06/19/sift-the-four-moves/,"[""SIFT"",""factchecking""]",__world__,synesthesia
2022-11-30T13:20:57.429452+00:00,https://hapgood.us/2019/06/19/sift-the-four-moves/,"[""SIFT"",""factchecking""]",__world__,synesthesia

See also