31:[{"id":"a9106cb27c278215f1e8828e0ccb7dfd7dfe25d9dfea21bf6fd8a5178f0a0596b017d9e2984538811ee2a51ddc8c2b1aa98a26cf6195c4d0d0c66b9fe9c1588b","href":"https://static.observableusercontent.com/files/a9106cb27c278215f1e8828e0ccb7dfd7dfe25d9dfea21bf6fd8a5178f0a0596b017d9e2984538811ee2a51ddc8c2b1aa98a26cf6195c4d0d0c66b9fe9c1588b","name":"episode_names.json","type":"application/json","lastModified":1664222096558.59,"size":21063},{"id":"5daa1d3d31087bc1e1e0505f6e69ab01e255eef216da2a7592d574560e26b2cac2c2176c23e5cb00f2e8b0f724e540974fdf5b4ae8e614c3110029c806b4a361","href":"https://static.observableusercontent.com/files/5daa1d3d31087bc1e1e0505f6e69ab01e255eef216da2a7592d574560e26b2cac2c2176c23e5cb00f2e8b0f724e540974fdf5b4ae8e614c3110029c806b4a361","name":"episode_links.json","type":"application/json","lastModified":1664222098408.713,"size":6866},{"id":"902ea2d2daf7f6bfe218ab7b096ddd1580df8a99ecc9f6beef17bd60fc7393e2b7353942b7b4d9efd94c6e9acf3a09318ce3f6c4b57ae596ff37ccbde7bdeecb","href":"https://static.observableusercontent.com/files/902ea2d2daf7f6bfe218ab7b096ddd1580df8a99ecc9f6beef17bd60fc7393e2b7353942b7b4d9efd94c6e9acf3a09318ce3f6c4b57ae596ff37ccbde7bdeecb","name":"transcriptions@2.parquet","type":"application/octet-stream","lastModified":1664223173066.784,"size":23692404}] 2f:{"title":"Lex Friedman podcasts","cells":[{"id":0,"value":"# Lex Friedman podcasts\n## The dumbest search on the smartest transcripts\n\nTranscripts by [OpenAI Whisper via Andrej Karpathy](https://karpathy.ai/lexicap/)","pinned":false,"hidden":false,"mode":"md"},{"id":13,"value":"viewof search = Inputs.text({submit:true, placeholder: 'Search something'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":334,"value":"{\n if (search != \"\") {\n return md`*select any entry to see its context*`\n } else {\n return md``\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"viewof table = Inputs.table(dfi, {\n columns: ['episode_name', 'text', 'link'], \n width: {\n text: width * .65,\n link: 30\n }, \n format: {\n episode_name: d => html`${\"\" + d.split(':')[0] + \":\" + \"\" + d.split(':')[1] + \"\"}`, \n link: d => htl.html`▶`, \n text: d => md`${d.replace(search, '**' + search + '**')}`},\n rows: 25, \n multiple: false,\n header: {episode_name: 'Episode', text: 'Text', link: 'Link'}\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":313,"value":"viewof context_seconds = Inputs.range([20,120], {value: 40, step: 20, label: 'seconds of context'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":287,"value":"{\n if (table) {\n return md`*${context.toArray().map(d => d.seconds == table.seconds ? \"**\" + d.text.trim() + \"**\" : d.text.trim()).join(' ')}*`\n } else {\n return md``\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":188,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"db = DuckDBClient.of({'trans': FileAttachment(\"transcriptions@2.parquet\")})","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"df = {\n if (search.trim() != '') {\n const results = await db.query(`select * from trans where text like '%${search}%'`)\n return aq.from(results.toArray())\n } else {\n return empty\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"dfi = df.\n derive({\n 'link': aq.escape(d => `https://www.youtube.com/watch?v=${links[d.episode]}&t=${d.seconds}`),\n 'episode_name': aq.escape(d => episodes[d.episode])\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"episodes = FileAttachment(\"episode_names.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":57,"value":"links = FileAttachment(\"episode_links.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":85,"value":"empty = aq.table({'episode': [],'text': [], 'link': []})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"import {DuckDBClient} from \"@cmudig/duckdb\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"import {aq, op} from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":275,"value":"context = {\n if (table) {\n return db.query(`select * from trans where episode == ${table.episode} and seconds > ${Number(table.seconds) - context_seconds} and seconds < ${Number(table.seconds) + context_seconds}`)\n } else {\n return \"\"\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"","pinned":false,"hidden":false,"mode":"html"}],"files":"$W31","stdlib":"1","titling":"auto"}