{"id":30737,"date":"2024-03-30T18:14:14","date_gmt":"2024-03-31T01:14:14","guid":{"rendered":"https:\/\/www.podfeet.com\/blog\/?p=30737"},"modified":"2024-03-31T14:56:20","modified_gmt":"2024-03-31T21:56:20","slug":"ccatp-790","status":"publish","type":"post","link":"https:\/\/www.podfeet.com\/blog\/2024\/03\/ccatp-790\/","title":{"rendered":"CCATP #790 \u2014 Bart Busschots on PBS 164 of X \u2013 jq: Working with Lookup Tables"},"content":{"rendered":"<p>In our previous episode of Programming By Stealth, Bart Busschots taught us how to create lookup tables with jq from JSON data using the <code>from_entries<\/code> command. Just when we have that conquered, this time he teaches us how to do the exact opposite \u2013 disassemble lookup tables. I think this was a really fun lesson because taking data apart, reassembling it the way you want and then putting it back together again is a great way to really understand what we&#8217;re doing with jq. I got much more comfortable as I started to recognize the patterns in what Bart was doing. We also get to play with a new data set, the Have I Been Pwned data gathered by Troy Hunt.<\/p>\n<p>If you&#8217;re a data nerd, and really who amongst us isn&#8217;t, you&#8217;ll love this episode too.<\/p>\n<p>You can find Bart&#8217;s fabulous tutorial shownotes at <a href=\"https:\/\/pbs.bartificer.net\/pbs164\">pbs.bartificer.net<\/a>.<\/p>\n<audio class=\"wp-audio-shortcode\" id=\"audio-30737-1\" preload=\"none\" style=\"width: 100%;\" controls=\"controls\"><source type=\"audio\/mpeg\" src=\"https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/CCATP_2024_03_30.mp3?_=1\" \/><a href=\"https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/CCATP_2024_03_30.mp3\">https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/CCATP_2024_03_30.mp3<\/a><\/audio>\n<p><a title=\"mp3 download\" href=\"https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/CCATP_2024_03_30.mp3\" target=\"_blank\" rel=\"noopener noreferrer\">mp3 download<\/a><\/p>\n<p>Read an unedited, auto-generated transcript with chapter marks:   <a href=\"https:\/\/podfeet.com\/transcripts\/CCATP_2024_03_30.html\">CCATP_2024_03_30<\/a><\/p>\n<p>Join our Slack at <a href=\"https:\/\/podfeet.com\/slack\">podfeet.com\/slack<\/a> and look for the #pbs channel, and check out our <a href=\"https:\/\/github.com\/pbs-students\" target=\"_blank\" rel=\"noopener\">pbs-student GitHub Organization<\/a>. It&#8217;s by invitation only but all you have to do is ask Allison!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our previous episode of Programming By Stealth, Bart Busschots taught us how to create lookup tables with jq from JSON data using the from_entries command. Just when we have that conquered, this time he teaches us how to do the exact opposite \u2013 disassemble lookup tables. I think this was a really fun lesson [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":18994,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[147,172,1,213],"tags":[6120,3457,6520,177,240],"class_list":["post-30737","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-posts","category-ccatp","category-podcasts","category-programming-by-stealth","tag-jq","tag-json","tag-lookup-tables","tag-pbs","tag-programming-by-stealth"],"jetpack_featured_media_url":"https:\/\/www.podfeet.com\/blog\/wp-content\/uploads\/2019\/08\/PBS_Logo-1-300x300_no_alpha.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/30737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/comments?post=30737"}],"version-history":[{"count":1,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/30737\/revisions"}],"predecessor-version":[{"id":30738,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/30737\/revisions\/30738"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media\/18994"}],"wp:attachment":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media?parent=30737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/categories?post=30737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/tags?post=30737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}