31:T48e,bestPictureNominees = [ ["1939", "Gone with the Wind*", "Selznick International Pictures"], ["1939", "Dark Victory", "Warner Bros.-First National"], ["1939", "Goodbye, Mr. Chips", "Metro-Goldwyn-Mayer"], ["1939", "Love Affair", "RKO Radio"], ["1939", "Mr. Smith Goes to Washington", "Columbia"], ["1939", "Ninotchka", "Metro-Goldwyn-Mayer"], ["1939", "Of Mice and Men", "Hal Roach (production company)"], ["1939", "Stagecoach", "Walter Wanger (production company)"], ["1939", "The Wizard of Oz", "Metro-Goldwyn-Mayer"], ["1939", "Wuthering Heights", "Samuel Goldwyn Productions"], ["1940", "Rebecca*", "Selznick International Pictures"], ["1940", "All This, and Heaven Too", "Warner Bros."], ["1940", "Foreign Correspondent", "Walter Wanger (production company)"], ["1940", "The Grapes of Wrath", "20th Century Fox"], ["1940", "The Great Dictator", "Charles Chaplin Productions"], ["1940", "Kitty Foyle", "RKO Radio"], ["1940", "The Letter", "Warner Bros."], ["1940", "The Long Voyage Home", "Argosy-Wanger"], ["1940", "Our Town", "Sol Lesser (production company)"], ["1940", "The Philadelphia Story", "Metro-Goldwyn-Mayer"] ]32:[{"id":"74c55b19551490e929639dc0e140b02a75dccac1e6e84767fb35dc1115360a6d5e99a23d92e6ce3590347eedebb9c2a50c838a431f71640a169ad26b254a1050","href":"https://static.observableusercontent.com/files/74c55b19551490e929639dc0e140b02a75dccac1e6e84767fb35dc1115360a6d5e99a23d92e6ce3590347eedebb9c2a50c838a431f71640a169ad26b254a1050","name":"tableCellSelectDB_UI_v6.png","type":"image/png","lastModified":1655398892209.638,"size":32451},{"id":"cea64b37b71dba9fa59c80abe6f35b0f0c3e9e81cfe5ee15df2b9c76d3965cc048f29f0106befa19d8a224e5a7abbafe774466ff32de4bc5c71398586b2681f9","href":"https://static.observableusercontent.com/files/cea64b37b71dba9fa59c80abe6f35b0f0c3e9e81cfe5ee15df2b9c76d3965cc048f29f0106befa19d8a224e5a7abbafe774466ff32de4bc5c71398586b2681f9","name":"tableCellUnnamed_UI_v6.png","type":"image/png","lastModified":1655398892209.638,"size":35621},{"id":"89ea24f8701c164859ed6e7a3678f0ccd437f1cfd817358c3b9537ae4deee841119bf0f73e62dd832d2e553873ddc8b4564f9c327c0d1ea3e73e480b7242bb19","href":"https://static.observableusercontent.com/files/89ea24f8701c164859ed6e7a3678f0ccd437f1cfd817358c3b9537ae4deee841119bf0f73e62dd832d2e553873ddc8b4564f9c327c0d1ea3e73e480b7242bb19","name":"tableCell_Columns_Show_All_v2.png","type":"image/png","lastModified":1655398892209.638,"size":30739},{"id":"ad39918767b97d940ec536e6405934759392ee6ef33fe3f06a759eef53eaccfa3348085db684d115116f9cba7a7b6733fec8917e39ad2059267b42a612504ad8","href":"https://static.observableusercontent.com/files/ad39918767b97d940ec536e6405934759392ee6ef33fe3f06a759eef53eaccfa3348085db684d115116f9cba7a7b6733fec8917e39ad2059267b42a612504ad8","name":"tableCell_Columns_only_v2.png","type":"image/png","lastModified":1655398892209.638,"size":35529},{"id":"93f539b66ed0e2f037eac3a350e264060a1078b583676d0d7a640bbca7e6024e5b9e114c3f49bef5bc9e0f4472bde69f9120bae4a762703ee85591ca4f423671","href":"https://static.observableusercontent.com/files/93f539b66ed0e2f037eac3a350e264060a1078b583676d0d7a640bbca7e6024e5b9e114c3f49bef5bc9e0f4472bde69f9120bae4a762703ee85591ca4f423671","name":"tableCell_Columns_v3.png","type":"image/png","lastModified":1655398892209.638,"size":34552},{"id":"249be4d4a1fa30fd863b7cac2609361ee3d1650ddc4c594eee9c3480f3c85469d78d28aa3b9e1e0163ab148c4c46ffbc324bba8243c5457f73ce6bc36ded2650","href":"https://static.observableusercontent.com/files/249be4d4a1fa30fd863b7cac2609361ee3d1650ddc4c594eee9c3480f3c85469d78d28aa3b9e1e0163ab148c4c46ffbc324bba8243c5457f73ce6bc36ded2650","name":"convertedSQLCell.png","type":"image/png","lastModified":1655398892209.638,"size":241338},{"id":"c2398169828dc179c0124d0f8eccdce2fc50f602cb876b291186d6e7819b4df4df0ae7950acde12eac3b4ba24e8c693c24f1603e80dce44d2cd879413f28ceaf","href":"https://static.observableusercontent.com/files/c2398169828dc179c0124d0f8eccdce2fc50f602cb876b291186d6e7819b4df4df0ae7950acde12eac3b4ba24e8c693c24f1603e80dce44d2cd879413f28ceaf","name":"convertToSQL_modal_v2.png","type":"image/png","lastModified":1655398892209.638,"size":66829},{"id":"a9bdaff6fa25bd89e2d307144ba9fefd2744ec2ba25c32b428f274d8e267c62a11bd8775ed8501b805e72141e30dadb4699bc9f61ac9ab6f478ade9bebd1ca87","href":"https://static.observableusercontent.com/files/a9bdaff6fa25bd89e2d307144ba9fefd2744ec2ba25c32b428f274d8e267c62a11bd8775ed8501b805e72141e30dadb4699bc9f61ac9ab6f478ade9bebd1ca87","name":"convertToSQL_v2.png","type":"image/png","lastModified":1655398892209.638,"size":36922},{"id":"330ed07508bdbdedc33b309da25bfbd3b4a40976240eb6cbc6b6c98e0ef1892b6a889d84594cdd9ed1fe0546e9608f972c4408d9a28bf9c85cf0c1803542fbb4","href":"https://static.observableusercontent.com/files/330ed07508bdbdedc33b309da25bfbd3b4a40976240eb6cbc6b6c98e0ef1892b6a889d84594cdd9ed1fe0546e9608f972c4408d9a28bf9c85cf0c1803542fbb4","name":"tableCellRowHover_v2.png","type":"image/png","lastModified":1655398892209.638,"size":236298},{"id":"062a2efe97f6c4345e5f3ef85b834558467ac357ed11e81ad5728d05af1ecc4a46e9bc54f840bd256ffc08b5ade608db1edc0a96beee88c7e25058f30edc8f43","href":"https://static.observableusercontent.com/files/062a2efe97f6c4345e5f3ef85b834558467ac357ed11e81ad5728d05af1ecc4a46e9bc54f840bd256ffc08b5ade608db1edc0a96beee88c7e25058f30edc8f43","name":"summaryTableInteractive_v5-1.png","type":"image/png","lastModified":1655398892209.638,"size":85271},{"id":"ec07b76253e43be39252f54e12a2d42a5b41bf7b322122a21b9e192666eaed4c99bca62ad881d92fbe781fd0af1bb6ba5abc52c948fc28bace4f8d76669755fc","href":"https://static.observableusercontent.com/files/ec07b76253e43be39252f54e12a2d42a5b41bf7b322122a21b9e192666eaed4c99bca62ad881d92fbe781fd0af1bb6ba5abc52c948fc28bace4f8d76669755fc","name":"tableCell_summaryTableHeaders_v4.png","type":"image/png","lastModified":1655398892209.638,"size":84370},{"id":"828a34f9af025d4524d5ce00dd312befe934c71b2574eade6b27094b48fd6189f769ba2081f5cccdbb0e9904943f867a2b1c94d47e61216b3c4704ac685dd89b","href":"https://static.observableusercontent.com/files/828a34f9af025d4524d5ce00dd312befe934c71b2574eade6b27094b48fd6189f769ba2081f5cccdbb0e9904943f867a2b1c94d47e61216b3c4704ac685dd89b","name":"tableCellSlice_UI_v8.png","type":"image/png","lastModified":1655398892209.638,"size":36710},{"id":"5754fec314942df03475d67a9fbc45aee8024ec07a9b0091457225246d99877d8d464b00e7629f36ee61f1f251867429c6e6a197480ae715b65c1e568dffe9b0","href":"https://static.observableusercontent.com/files/5754fec314942df03475d67a9fbc45aee8024ec07a9b0091457225246d99877d8d464b00e7629f36ee61f1f251867429c6e6a197480ae715b65c1e568dffe9b0","name":"tableCellSort_UI_v6.png","type":"image/png","lastModified":1655398892209.638,"size":36904},{"id":"7127435389d8e690aee8c8efa0727786db1aad97e2105b633c9449b5409a3284eaca22a0f3ac3ed764fad07d67213baec06853b58ee5b52fef101b884227d189","href":"https://static.observableusercontent.com/files/7127435389d8e690aee8c8efa0727786db1aad97e2105b633c9449b5409a3284eaca22a0f3ac3ed764fad07d67213baec06853b58ee5b52fef101b884227d189","name":"tableCellColumns_UI_v6.png","type":"image/png","lastModified":1655398892209.638,"size":36880},{"id":"c055fd9c4d4f28ba91e1583735e6c3467bb399d0c6986df0294f7ebe23d16bef75a50dea82c652a4117f610dde3d6cc3ef574f4085a7dabcd7240cfe7ac0ce14","href":"https://static.observableusercontent.com/files/c055fd9c4d4f28ba91e1583735e6c3467bb399d0c6986df0294f7ebe23d16bef75a50dea82c652a4117f610dde3d6cc3ef574f4085a7dabcd7240cfe7ac0ce14","name":"tableCellDemoSelectTable_UI_v6.png","type":"image/png","lastModified":1655398892209.638,"size":29983},{"id":"0e3c9ce52571f8b533d3c13615e80e356dd7e467e259b81a80bb1241d1bf16afbe04dbb59f5f8c4c262255277c9e914270a24b81265ea4652c1117211edcc50d","href":"https://static.observableusercontent.com/files/0e3c9ce52571f8b533d3c13615e80e356dd7e467e259b81a80bb1241d1bf16afbe04dbb59f5f8c4c262255277c9e914270a24b81265ea4652c1117211edcc50d","name":"tableCell_myTable_filter_v6@1.png","type":"image/png","lastModified":1655398892209.638,"size":36813},{"id":"49b70b8a6c8e0800256385fd9798b0ef1b33c2eb5c4ffaa092df8d841da52ac45f3320abb2e075ee6f69ad6194d1cfcc2e5da1c539b5ad0db816f6e0a3e49d0a","href":"https://static.observableusercontent.com/files/49b70b8a6c8e0800256385fd9798b0ef1b33c2eb5c4ffaa092df8d841da52ac45f3320abb2e075ee6f69ad6194d1cfcc2e5da1c539b5ad0db816f6e0a3e49d0a","name":"tableCellSelectDBMenu_UI_v6.png","type":"image/png","lastModified":1655398892209.638,"size":44388},{"id":"5da496a869254cf72de60cc14cb05ebcfc00bb766a7fffbf83f0d899b4f5ba983391d5192ee39e4af87b0b750e081728b6549cbd0b1eb421d5330e7ea5d86c8d","href":"https://static.observableusercontent.com/files/5da496a869254cf72de60cc14cb05ebcfc00bb766a7fffbf83f0d899b4f5ba983391d5192ee39e4af87b0b750e081728b6549cbd0b1eb421d5330e7ea5d86c8d","name":"tableCellName_UI_v6@2.png","type":"image/png","lastModified":1655398892209.638,"size":36678},{"id":"fc73bce0ac17eb3680ddfe4444aee5a53512f2c0d517b05aec7cf696bf437f74591b7eea7f6d64af5ef8010c272ede6546ee8915a869abe1d2bc58c1a9026c50","href":"https://static.observableusercontent.com/files/fc73bce0ac17eb3680ddfe4444aee5a53512f2c0d517b05aec7cf696bf437f74591b7eea7f6d64af5ef8010c272ede6546ee8915a869abe1d2bc58c1a9026c50","name":"table_overview_v6.png","type":"image/png","lastModified":1655398892209.638,"size":246165},{"id":"7aa537eeb97445ed6564aeeb7797535a42a690a9d6e2dec4f5ef0937a629caa1f57c93206240036f7cd7613d98b7aea9fef8c16bd54ebeda321c2975c28c7090","href":"https://static.observableusercontent.com/files/7aa537eeb97445ed6564aeeb7797535a42a690a9d6e2dec4f5ef0937a629caa1f57c93206240036f7cd7613d98b7aea9fef8c16bd54ebeda321c2975c28c7090","name":"tableCellPopulated_UI_v6@1.png","type":"image/png","lastModified":1655398892209.638,"size":258769},{"id":"26aa9b33e35a0c6fb3b418ccb8665a9b3d36430a46f7197400bc36ec12f32ac5d1e79e44a0397c64283d3d83b4e12fd37d2a0a5371678262cd62ddd6e95e5042","href":"https://static.observableusercontent.com/files/26aa9b33e35a0c6fb3b418ccb8665a9b3d36430a46f7197400bc36ec12f32ac5d1e79e44a0397c64283d3d83b4e12fd37d2a0a5371678262cd62ddd6e95e5042","name":"tableCellDemoTableMenu_UI_v5.png","type":"image/png","lastModified":1655398892209.638,"size":46487},{"id":"8b067e2c09486a75addee2c490d3da9c580a39962e31d3b53e6faab9c4f030e98350c1e01d0d3feb8d46a50588bda201acf28bfca2696e5d037f2e42a8ae2b59","href":"https://static.observableusercontent.com/files/8b067e2c09486a75addee2c490d3da9c580a39962e31d3b53e6faab9c4f030e98350c1e01d0d3feb8d46a50588bda201acf28bfca2696e5d037f2e42a8ae2b59","name":"dataTableMenu_v2.png","type":"image/png","lastModified":1655398892209.638,"size":54244},{"id":"2c96038086dabd08ffa4834e85e880ff05fd9a5ff6fb00ca42ab14eaf7b941c01010d3cc866861a810ec18964044b5893223dec6120c07229c9216d877234ec7","href":"https://static.observableusercontent.com/files/2c96038086dabd08ffa4834e85e880ff05fd9a5ff6fb00ca42ab14eaf7b941c01010d3cc866861a810ec18964044b5893223dec6120c07229c9216d877234ec7","name":"tableCell_ArrayExpanded.png","type":"image/png","lastModified":1655398892209.638,"size":580317},{"id":"fd807e46d4fe284f4c9ca4ce8f7b54d69c450794e1005b3f2de57647a8ac5939c3a147fa9f73f77aa030ecd911ac045e54662eb750b68f501641e0f08cc593cb","href":"https://static.observableusercontent.com/files/fd807e46d4fe284f4c9ca4ce8f7b54d69c450794e1005b3f2de57647a8ac5939c3a147fa9f73f77aa030ecd911ac045e54662eb750b68f501641e0f08cc593cb","name":"tableCell_RefToTable.png","type":"image/png","lastModified":1655398892209.638,"size":30468},{"id":"559ae272ca2231ffa4d295f48dedae5cdf58bfa256f8c0d957d02ecee1d9966385d00077d308750e188b2a0bb0954825310b05fdb425a9926ed92670ae300b5d","href":"https://static.observableusercontent.com/files/559ae272ca2231ffa4d295f48dedae5cdf58bfa256f8c0d957d02ecee1d9966385d00077d308750e188b2a0bb0954825310b05fdb425a9926ed92670ae300b5d","name":"tableCell_ColSumm_Messages.png","type":"image/png","lastModified":1655398892209.638,"size":26367},{"id":"eeca55403de3dd9fffebf6949844eae5eba8f8abe3e4986bde06a3d394a194bfe74136943065697aebd2f44845410cc78a8b5e7525691660fe60d4e8f05c49b4","href":"https://static.observableusercontent.com/files/eeca55403de3dd9fffebf6949844eae5eba8f8abe3e4986bde06a3d394a194bfe74136943065697aebd2f44845410cc78a8b5e7525691660fe60d4e8f05c49b4","name":"tableCellSlice_UI_v5.png","type":"image/png","lastModified":1655398892209.638,"size":17849},{"id":"af2a6aaa4eb1353d67749c69e58a5c708e32babb8d6d3d859bf35089b2580da665804b106b91645243ce27990460ca69393f1aaecc54c158dd199b28b83232bc","href":"https://static.observableusercontent.com/files/af2a6aaa4eb1353d67749c69e58a5c708e32babb8d6d3d859bf35089b2580da665804b106b91645243ce27990460ca69393f1aaecc54c158dd199b28b83232bc","name":"tableCell_ColSumm_Hist_After.png","type":"image/png","lastModified":1655398892209.638,"size":13648},{"id":"cfb4e200c946b9e78fd6572e3cfddb6322393f4f69c58e9ab7e3a7d1679e6acb2168e652f44099461cf8fa09242e022c6d6c3f6ee8c231122ddb9583048bc820","href":"https://static.observableusercontent.com/files/cfb4e200c946b9e78fd6572e3cfddb6322393f4f69c58e9ab7e3a7d1679e6acb2168e652f44099461cf8fa09242e022c6d6c3f6ee8c231122ddb9583048bc820","name":"tableCell_ColSumm_Hist_Before.png","type":"image/png","lastModified":1655398892209.638,"size":11431},{"id":"4f7e7b94a78a39196e3e3f08a5b94ecfa767da4031637ce4d83f997436089a619ceb44ac39daa3d4d7a9b6b8ac73cc9397117fe1fb4532e76fcc74da42520551","href":"https://static.observableusercontent.com/files/4f7e7b94a78a39196e3e3f08a5b94ecfa767da4031637ce4d83f997436089a619ceb44ac39daa3d4d7a9b6b8ac73cc9397117fe1fb4532e76fcc74da42520551","name":"tableCell_Sort_Up_or_Down.png","type":"image/png","lastModified":1655398892209.638,"size":28048},{"id":"7c63c97b556b2f013f246aa66964b8a205716d6c59d98da8174b47bc65caba546d5d3443b5f84083fbd0165443930abe9464c1c645c481b58bb65128d7a6943e","href":"https://static.observableusercontent.com/files/7c63c97b556b2f013f246aa66964b8a205716d6c59d98da8174b47bc65caba546d5d3443b5f84083fbd0165443930abe9464c1c645c481b58bb65128d7a6943e","name":"tableCell_SortCriteria_Column.png","type":"image/png","lastModified":1655398892209.638,"size":38248},{"id":"8727cf81f8e7b96f38f58f69a7da8e88432cd958ae82ed1f52b7c1aa685ed9fe4d9eaeacee7a9dfe5fa661dac17e6d8176995fdd22efbbb6f7d9eb398ef96da7","href":"https://static.observableusercontent.com/files/8727cf81f8e7b96f38f58f69a7da8e88432cd958ae82ed1f52b7c1aa685ed9fe4d9eaeacee7a9dfe5fa661dac17e6d8176995fdd22efbbb6f7d9eb398ef96da7","name":"tableCell_FilterCriteria_ThreeFields.png","type":"image/png","lastModified":1655398892209.638,"size":11856},{"id":"bd9b1a7369fb25cfdafaae0d0512cfd7a8e92c6dca8a20176d29c305af397ff784f86b93249fb0acc582ed5475c4b48f623116c1df4d85e4857ce22d41557bd6","href":"https://static.observableusercontent.com/files/bd9b1a7369fb25cfdafaae0d0512cfd7a8e92c6dca8a20176d29c305af397ff784f86b93249fb0acc582ed5475c4b48f623116c1df4d85e4857ce22d41557bd6","name":"tableCell_FilterCriteria_Column.png","type":"image/png","lastModified":1655398892209.638,"size":35017},{"id":"b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","href":"https://static.observableusercontent.com/files/b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","name":"chinook.db","type":"application/x-sqlite3","lastModified":1655409281743.193,"size":884736},{"id":"a30eb26b17cdc418ea891e6ca89f0070aa271cd899fe4d0b081eb2a9cc1da1be44a0049d5cf22cc86b511c2ac75a1177a8cc9990ce3485ec288eb6440b1106cf","href":"https://static.observableusercontent.com/files/a30eb26b17cdc418ea891e6ca89f0070aa271cd899fe4d0b081eb2a9cc1da1be44a0049d5cf22cc86b511c2ac75a1177a8cc9990ce3485ec288eb6440b1106cf","name":"closeCellArrow_v2.png","type":"image/png","lastModified":1667426792567.623,"size":36336},{"id":"53b0913245e173bf55a62d6ab9df82aed58bb4ed3d8e2ee9b3b3dd2b8c1ff6ce4a8d1018921022784e16122a3ff4dae77b320646fd900b0db7e8a70f7ddfa6a2","href":"https://static.observableusercontent.com/files/53b0913245e173bf55a62d6ab9df82aed58bb4ed3d8e2ee9b3b3dd2b8c1ff6ce4a8d1018921022784e16122a3ff4dae77b320646fd900b0db7e8a70f7ddfa6a2","name":"myTableSlice_v2.png","type":"image/png","lastModified":1667348221194.019,"size":28189},{"id":"dccd4ce79413e55e2563feeb3ddc5dd488a78f5fe840870c37fa25a28100eeb89d1ab20df7effdfa04737afcb8f101b9604dc2c0d094e117bda6ff3edce1b20f","href":"https://static.observableusercontent.com/files/dccd4ce79413e55e2563feeb3ddc5dd488a78f5fe840870c37fa25a28100eeb89d1ab20df7effdfa04737afcb8f101b9604dc2c0d094e117bda6ff3edce1b20f","name":"myTableSort_v2.png","type":"image/png","lastModified":1667348221194.019,"size":28273},{"id":"9a6ac655e536ce76eaabfe407a3441849908e4e32e37e7b145e17d5e02c91e7e3d22cec2aac17bd0f9cb253e66e64b5c562d5b85ad14d79e126f16fdb85213e2","href":"https://static.observableusercontent.com/files/9a6ac655e536ce76eaabfe407a3441849908e4e32e37e7b145e17d5e02c91e7e3d22cec2aac17bd0f9cb253e66e64b5c562d5b85ad14d79e126f16fdb85213e2","name":"tableCellHistogramAfter.png","type":"image/png","lastModified":1667348221194.019,"size":14198},{"id":"3c30c4685465dccada5f2c444afd6628b841c86ca9d94509c0eacf12814083db0b1b5d48833037741c7f6b04a2ebae1b02813ef3b2c7b2e5bb82815b3af04728","href":"https://static.observableusercontent.com/files/3c30c4685465dccada5f2c444afd6628b841c86ca9d94509c0eacf12814083db0b1b5d48833037741c7f6b04a2ebae1b02813ef3b2c7b2e5bb82815b3af04728","name":"tableCellHistogramBefore.png","type":"image/png","lastModified":1667348221194.019,"size":12172},{"id":"4f8b680a3f8902b3b233f8002c9b1b2eb2f66e9864617f54da8a9c0365438470c70b4f1692621df95790cbf5d6eceb2e10c72420c641511f7376a9d7e4926e09","href":"https://static.observableusercontent.com/files/4f8b680a3f8902b3b233f8002c9b1b2eb2f66e9864617f54da8a9c0365438470c70b4f1692621df95790cbf5d6eceb2e10c72420c641511f7376a9d7e4926e09","name":"summaryTableCanada.png","type":"image/png","lastModified":1667348221194.019,"size":45616},{"id":"4f7dc85aeace1b5b69c8a1f6fc5945a3f5679bc36bc3b56627b449d0a2588ebf922343776221d688fe61398e363e464657e3ebb6c1bab8f8164dc8266cfb421f","href":"https://static.observableusercontent.com/files/4f7dc85aeace1b5b69c8a1f6fc5945a3f5679bc36bc3b56627b449d0a2588ebf922343776221d688fe61398e363e464657e3ebb6c1bab8f8164dc8266cfb421f","name":"summaryTableHeadersOnly.png","type":"image/png","lastModified":1667348221194.019,"size":51594},{"id":"997a7c2206f98b7e2b753a5bf4b48f95be6503dcec1dd97b6f87b6333eefece3dab8a3ec267d3eee62e0f4bfd8a7a8bde00391df3a7ce38998374343acf0f5f5","href":"https://static.observableusercontent.com/files/997a7c2206f98b7e2b753a5bf4b48f95be6503dcec1dd97b6f87b6333eefece3dab8a3ec267d3eee62e0f4bfd8a7a8bde00391df3a7ce38998374343acf0f5f5","name":"selectATable_v4.png","type":"image/png","lastModified":1667348221194.019,"size":26966},{"id":"4d0144e607d4d253411ec549ed695f19a2d3fa0a4a30634099709d86d1b81c8c60c46e3e99f1907cee546b4ea8ee49baa3a4d35fc4c8d1d3a39e13cd9c801acc","href":"https://static.observableusercontent.com/files/4d0144e607d4d253411ec549ed695f19a2d3fa0a4a30634099709d86d1b81c8c60c46e3e99f1907cee546b4ea8ee49baa3a4d35fc4c8d1d3a39e13cd9c801acc","name":"addDatabaseButton_v2.png","type":"image/png","lastModified":1667348221194.019,"size":20901},{"id":"de7fe2b8f55d1f7981a778db7892ce6996566a66958f1517bbdfaeba3ed1571cc007c91e99ffd10a43543ae555a0e99096331b7b1fb333bbfc8f267e974595f3","href":"https://static.observableusercontent.com/files/de7fe2b8f55d1f7981a778db7892ce6996566a66958f1517bbdfaeba3ed1571cc007c91e99ffd10a43543ae555a0e99096331b7b1fb333bbfc8f267e974595f3","name":"connectedDatabases_v2.png","type":"image/png","lastModified":1667348221194.019,"size":66124},{"id":"21c795b11b08fe435727b647ce7cadb8e9155da63e03afe46cb53709ab818fc4cb9dc5989c09180a44231975c7180f0c490d475015aa961bf30fce5bbd8c4634","href":"https://static.observableusercontent.com/files/21c795b11b08fe435727b647ce7cadb8e9155da63e03afe46cb53709ab818fc4cb9dc5989c09180a44231975c7180f0c490d475015aa961bf30fce5bbd8c4634","name":"tableCellColumnsShowAll.png","type":"image/png","lastModified":1667348221194.019,"size":30039},{"id":"83d4078255140309d3469b079e6d6ed70a35460886cb7ea5f64619002c6eb9635bc2e7371b12072673f67283330b7f49fe3653b462e235be93f7aad30b277e20","href":"https://static.observableusercontent.com/files/83d4078255140309d3469b079e6d6ed70a35460886cb7ea5f64619002c6eb9635bc2e7371b12072673f67283330b7f49fe3653b462e235be93f7aad30b277e20","name":"tableCellColumnsOnly.png","type":"image/png","lastModified":1667348221194.019,"size":33317},{"id":"3584cff9a5a3e4adc7469495c893e58152691d0d734933d336af07c825a5cf9ebd514e6138d236d5449b58d6c5b28a7e291cd1125fe05895ba55e2b21d26c17a","href":"https://static.observableusercontent.com/files/3584cff9a5a3e4adc7469495c893e58152691d0d734933d336af07c825a5cf9ebd514e6138d236d5449b58d6c5b28a7e291cd1125fe05895ba55e2b21d26c17a","name":"tableCellColumnsMenu.png","type":"image/png","lastModified":1667348221194.019,"size":32384},{"id":"c15cff551607b243d234499be5ac9d16bdd680155a62a1a03f8d5b5023a24fbe839a245dbbb974d7b38a0025557ce3d53d542b0945a2cb1e2bcfaa7b946e4f1b","href":"https://static.observableusercontent.com/files/c15cff551607b243d234499be5ac9d16bdd680155a62a1a03f8d5b5023a24fbe839a245dbbb974d7b38a0025557ce3d53d542b0945a2cb1e2bcfaa7b946e4f1b","name":"bestPictureNomineesCell.png","type":"image/png","lastModified":1667348221194.019,"size":75877},{"id":"ac677eb3c9a318fc7809361585ff62289cd0fb03848ae418ee18326545b747b38693a2eefab61a5b179d24117fd89ebc819d971dd5f7600a6a0a8169a6b92261","href":"https://static.observableusercontent.com/files/ac677eb3c9a318fc7809361585ff62289cd0fb03848ae418ee18326545b747b38693a2eefab61a5b179d24117fd89ebc819d971dd5f7600a6a0a8169a6b92261","name":"selectADataSource_v3.png","type":"image/png","lastModified":1667348221194.019,"size":22744},{"id":"91021b38896a437c003ebad8bab035a36ac1c61864d72f87f3083d1b2661ffebb3595e1aacb64ec1f3337d55c746ac8ee6d4e0663bf766b4812c6d154518af87","href":"https://static.observableusercontent.com/files/91021b38896a437c003ebad8bab035a36ac1c61864d72f87f3083d1b2661ffebb3595e1aacb64ec1f3337d55c746ac8ee6d4e0663bf766b4812c6d154518af87","name":"dataTableMenu_v6.png","type":"image/png","lastModified":1667348221194.019,"size":45705},{"id":"640ea7a05148d5c506862e0d1c43a3c3de537a17650cdf700256ecb98a0d801a320f4e0f9c3a3997e7752aa5b1efc86569926f74a0826121c747bdce5530d2be","href":"https://static.observableusercontent.com/files/640ea7a05148d5c506862e0d1c43a3c3de537a17650cdf700256ecb98a0d801a320f4e0f9c3a3997e7752aa5b1efc86569926f74a0826121c747bdce5530d2be","name":"convertedSQLCell_v3.png","type":"image/png","lastModified":1667348221194.019,"size":229134},{"id":"43a0ec54bdc2a28d76d3253794d596dba600a0f56b268de2645cec676af01c84b3da156699b9a50efd12cb134f2578bc590629f330bb04db5454c38baf818ddb","href":"https://static.observableusercontent.com/files/43a0ec54bdc2a28d76d3253794d596dba600a0f56b268de2645cec676af01c84b3da156699b9a50efd12cb134f2578bc590629f330bb04db5454c38baf818ddb","name":"convertToSQL_v4.png","type":"image/png","lastModified":1667348221194.019,"size":28295},{"id":"cbe533ea65b2307677b09f5fad7920cddbb299c5a7fbfed71d8f30b006e7392649ec0bbd0c0e7c40a18190b0c038a57cb6be33b0074c9ceb383cf790232d9669","href":"https://static.observableusercontent.com/files/cbe533ea65b2307677b09f5fad7920cddbb299c5a7fbfed71d8f30b006e7392649ec0bbd0c0e7c40a18190b0c038a57cb6be33b0074c9ceb383cf790232d9669","name":"tableCellRowHover_v4.png","type":"image/png","lastModified":1667348221194.019,"size":233428},{"id":"9afb0358fc9ff8ca8c80e03b22f4afc04d6e9f2401791b5073eb1ce936f3a15482d5127887e68b9eb54a1935cbdadf957767b64862bd91b1afbcea9f8e8d50fb","href":"https://static.observableusercontent.com/files/9afb0358fc9ff8ca8c80e03b22f4afc04d6e9f2401791b5073eb1ce936f3a15482d5127887e68b9eb54a1935cbdadf957767b64862bd91b1afbcea9f8e8d50fb","name":"tableCell_ColSumm_Messages_v2.png","type":"image/png","lastModified":1667348221194.019,"size":21654},{"id":"5003ee74747a765a5f3520b15ad21cec1db356e30ec9da45328f84d7d0a352e50c70b4c2855b8d4d316681eebd1a36c41125413a580e05d002e0c88ed48b9b28","href":"https://static.observableusercontent.com/files/5003ee74747a765a5f3520b15ad21cec1db356e30ec9da45328f84d7d0a352e50c70b4c2855b8d4d316681eebd1a36c41125413a580e05d002e0c88ed48b9b28","name":"tableCell_ArrayExpanded_v3.png","type":"image/png","lastModified":1667348221194.019,"size":583971},{"id":"397b477384f9c882ead5cb0b2ef36b899b9a11adb9e803ccafbefefcf7677000bc473b3c71443ead29c02f33f5d39a632d2db93421fa47cb6a8380bd7f0aa84e","href":"https://static.observableusercontent.com/files/397b477384f9c882ead5cb0b2ef36b899b9a11adb9e803ccafbefefcf7677000bc473b3c71443ead29c02f33f5d39a632d2db93421fa47cb6a8380bd7f0aa84e","name":"tableCell_RefToTable_v3.png","type":"image/png","lastModified":1667348221194.019,"size":27533},{"id":"f9c9b7f074314281e99545bee68b4584a9e9d979d46a6e5d0cb24224b02402b06cddc57b69be538a20fb4f1ac99251018895dbfac3a1036dc0b22a7ca80f62db","href":"https://static.observableusercontent.com/files/f9c9b7f074314281e99545bee68b4584a9e9d979d46a6e5d0cb24224b02402b06cddc57b69be538a20fb4f1ac99251018895dbfac3a1036dc0b22a7ca80f62db","name":"sliceFromTo.png","type":"image/png","lastModified":1667348221194.019,"size":22165},{"id":"6f84b4bf3e762b1a579d698527997d192ce9443984a83693fba5891d2413d33bac8efad1b669db81b46af232ec0f5a8eec347dc39863bb537f884265521a6b60","href":"https://static.observableusercontent.com/files/6f84b4bf3e762b1a579d698527997d192ce9443984a83693fba5891d2413d33bac8efad1b669db81b46af232ec0f5a8eec347dc39863bb537f884265521a6b60","name":"myTableColumns_v2.png","type":"image/png","lastModified":1667348221194.019,"size":28330},{"id":"8c4794af76dbc88f6a65b69902599ca5f98a1355f44de0d897bfdc2971da8532a01c6c51c4a88632375b97d0a64da854a4f5b32690850e80ba5810449c5ac75b","href":"https://static.observableusercontent.com/files/8c4794af76dbc88f6a65b69902599ca5f98a1355f44de0d897bfdc2971da8532a01c6c51c4a88632375b97d0a64da854a4f5b32690850e80ba5810449c5ac75b","name":"myTableFilter_v2.png","type":"image/png","lastModified":1667348221194.019,"size":28312},{"id":"681830f6c014a54f6d8cf3b4f0e45ae0201ebf288e2c71de5309341bf7f1511560d8f6aea03b9b7a93d42478c82d1e230d4aec064a8db3bbe4ec4da6ee2fcc1b","href":"https://static.observableusercontent.com/files/681830f6c014a54f6d8cf3b4f0e45ae0201ebf288e2c71de5309341bf7f1511560d8f6aea03b9b7a93d42478c82d1e230d4aec064a8db3bbe4ec4da6ee2fcc1b","name":"tableCellNameArea_v2.png","type":"image/png","lastModified":1667348221194.019,"size":28366},{"id":"c0d9d94135032b68ec31d7bb0c5c09cef0ade8d014f2dff507c621247c7102b7cd0f5e6e17fd80ec23f455013d0851b5e74e376cf5170152a109fcec6fa4af32","href":"https://static.observableusercontent.com/files/c0d9d94135032b68ec31d7bb0c5c09cef0ade8d014f2dff507c621247c7102b7cd0f5e6e17fd80ec23f455013d0851b5e74e376cf5170152a109fcec6fa4af32","name":"tableCellPopulated_v2.png","type":"image/png","lastModified":1667348221194.019,"size":243580},{"id":"79dbe77134c55e5a430cdb9f0448d1f6a6120910d3b0daeb50db53e3ceec1e3a9af4a22bed4456322190b609b3a491ad419aadfde3ab8e9611ab8f598daf686a","href":"https://static.observableusercontent.com/files/79dbe77134c55e5a430cdb9f0448d1f6a6120910d3b0daeb50db53e3ceec1e3a9af4a22bed4456322190b609b3a491ad419aadfde3ab8e9611ab8f598daf686a","name":"selectATableList_v3.png","type":"image/png","lastModified":1667348221194.019,"size":62796},{"id":"f66e73b2bdd166d0ba92a7d958ed8be927da8b630f4674c90d727afe432687069914247e8a6a967c6ab0b8bd2f041ff424794f059017006a4b26c76100e18a63","href":"https://static.observableusercontent.com/files/f66e73b2bdd166d0ba92a7d958ed8be927da8b630f4674c90d727afe432687069914247e8a6a967c6ab0b8bd2f041ff424794f059017006a4b26c76100e18a63","name":"selectDataSourceaapl.png","type":"image/png","lastModified":1667348221194.019,"size":35754},{"id":"aa5accc076296f786f0d387fc7111bf84ae59bbe56c035ccbcbcc03ff2889858db63d4a73776950701c7300301af0f60133d495e81d2e66a02ecc8889ffbc0ac","href":"https://static.observableusercontent.com/files/aa5accc076296f786f0d387fc7111bf84ae59bbe56c035ccbcbcc03ff2889858db63d4a73776950701c7300301af0f60133d495e81d2e66a02ecc8889ffbc0ac","name":"tableCellUnnamed_UI_v8.png","type":"image/png","lastModified":1667348221194.019,"size":30737},{"id":"b02cd0fb6b9bbc1127b362b115d50db8ad0c145c792d52910600684b77e856ff4c430b15be628275146a95c2be84ed5f6d7f24e99b7ea6a1516d217db4cbf1b0","href":"https://static.observableusercontent.com/files/b02cd0fb6b9bbc1127b362b115d50db8ad0c145c792d52910600684b77e856ff4c430b15be628275146a95c2be84ed5f6d7f24e99b7ea6a1516d217db4cbf1b0","name":"adelieGentoo.png","type":"image/png","lastModified":1676660189945.082,"size":40186},{"id":"bc42d808d751f405a2ec9293f3460376d06e226c67776dafcfa270ff9a4b184eada72d76aa975c8f485def7dbd3250b0c70485dd458f2ecdbf5c7ed01532d342","href":"https://static.observableusercontent.com/files/bc42d808d751f405a2ec9293f3460376d06e226c67776dafcfa270ff9a4b184eada72d76aa975c8f485def7dbd3250b0c70485dd458f2ecdbf5c7ed01532d342","name":"adelieGentooFilter.png","type":"image/png","lastModified":1676660189945.082,"size":49198},{"id":"dc42a88ecfc7c04200ede7f716ac3f53025c2766c6430f3423df65bbd955f7268848126a61245ef04d80aa0e6cfa7e06eb01d86e35aaadcccf70027adaaba415","href":"https://static.observableusercontent.com/files/dc42a88ecfc7c04200ede7f716ac3f53025c2766c6430f3423df65bbd955f7268848126a61245ef04d80aa0e6cfa7e06eb01d86e35aaadcccf70027adaaba415","name":"flipperLengthHistogramAll.png","type":"image/png","lastModified":1676660189945.082,"size":15102},{"id":"b90d3bca204fa3853deb8426c44fc6a3a5a1938e5017f1a12631412762b098a2b5c1f2d971eec7760d4010addd37ebb411085812e4eed6e7ea327b855538b239","href":"https://static.observableusercontent.com/files/b90d3bca204fa3853deb8426c44fc6a3a5a1938e5017f1a12631412762b098a2b5c1f2d971eec7760d4010addd37ebb411085812e4eed6e7ea327b855538b239","name":"flipperLengthHistogramOneBar.png","type":"image/png","lastModified":1676660189945.082,"size":16763},{"id":"354ed9b0c5b539c020c5d937a62b7b4d2242b0b4c7f65c85e3b6c5982b37c620a725eb42c4772fe16b82eceb8f98816740371193b4295fa65d7f60cbed0141a2","href":"https://static.observableusercontent.com/files/354ed9b0c5b539c020c5d937a62b7b4d2242b0b4c7f65c85e3b6c5982b37c620a725eb42c4772fe16b82eceb8f98816740371193b4295fa65d7f60cbed0141a2","name":"flipperLengthNaN.png","type":"image/png","lastModified":1676660189945.082,"size":19918},{"id":"140012f9cc3c47b3f9541c35c6262fa83aed7a9fe324fd7ca4890762ad63dd1ffcb37c50599966b5c3dc4443aba828ee66a9845a75d9919c9e6f456ba98063ce","href":"https://static.observableusercontent.com/files/140012f9cc3c47b3f9541c35c6262fa83aed7a9fe324fd7ca4890762ad63dd1ffcb37c50599966b5c3dc4443aba828ee66a9845a75d9919c9e6f456ba98063ce","name":"histogramSelectionRange.mov","type":"video/quicktime","lastModified":1676660189945.082,"size":432209},{"id":"0c775d70d9a2afc92bb906c4ad90a01e089c25f353eb32af1cea5e1080240fd50159f57efc678934c8299b3ad9528735a881bcaa433ed742482fc606d7b4d2fe","href":"https://static.observableusercontent.com/files/0c775d70d9a2afc92bb906c4ad90a01e089c25f353eb32af1cea5e1080240fd50159f57efc678934c8299b3ad9528735a881bcaa433ed742482fc606d7b4d2fe","name":"nullSign.png","type":"image/png","lastModified":1676660189945.082,"size":14925},{"id":"3a04e3c38a080ab1389c7cd5a77a60b56cbdfa7f44ef793b5129ea7876ea583220595b226747550ddd593468121ab1f2a7131f76dcdf6947c8fb9e14694c7a97","href":"https://static.observableusercontent.com/files/3a04e3c38a080ab1389c7cd5a77a60b56cbdfa7f44ef793b5129ea7876ea583220595b226747550ddd593468121ab1f2a7131f76dcdf6947c8fb9e14694c7a97","name":"penguinsRowInteractivity.png","type":"image/png","lastModified":1676660189945.082,"size":133672},{"id":"3cae30e0d5342a0fb428699baa8043e5feababc457834888f22af844cbf48156578e01b119db7b1ad310956141c5eb2beb0d76c40fd843035ae1e08586f9af1d","href":"https://static.observableusercontent.com/files/3cae30e0d5342a0fb428699baa8043e5feababc457834888f22af844cbf48156578e01b119db7b1ad310956141c5eb2beb0d76c40fd843035ae1e08586f9af1d","name":"summaryChartAdelieOnly.png","type":"image/png","lastModified":1676660189945.082,"size":70007},{"id":"7ca70a95ff48042a5c6f5628f9e6433d2d1690c33e81194952349f836c1cf1412138dd49abcdc867e77ff602fa4ae5bdb34a6d2d54d15ccb7daaaf22e5d2d586","href":"https://static.observableusercontent.com/files/7ca70a95ff48042a5c6f5628f9e6433d2d1690c33e81194952349f836c1cf1412138dd49abcdc867e77ff602fa4ae5bdb34a6d2d54d15ccb7daaaf22e5d2d586","name":"summaryChartHeadersPenguins.png","type":"image/png","lastModified":1676660189945.082,"size":73817},{"id":"38cc369899f398c6ae325c8f296510c9b99e7c2f8430f6c265bdf494622d7b0df6840f7750b96d9692a234d7a33cd58ec71ec2137a48a9a6cec30a7efde6bb77","href":"https://static.observableusercontent.com/files/38cc369899f398c6ae325c8f296510c9b99e7c2f8430f6c265bdf494622d7b0df6840f7750b96d9692a234d7a33cd58ec71ec2137a48a9a6cec30a7efde6bb77","name":"columnDerivationBadColumnName.png","type":"image/png","lastModified":1685112176339.848,"size":226628},{"id":"e437d1d3e3843877522f6794ff0bb0b95765bd7821cd32dd263a2945089d8cda3bd4a82d058cef1e5128244bded528f2618af8d5ef5631a5a28eecc7483e6861","href":"https://static.observableusercontent.com/files/e437d1d3e3843877522f6794ff0bb0b95765bd7821cd32dd263a2945089d8cda3bd4a82d058cef1e5128244bded528f2618af8d5ef5631a5a28eecc7483e6861","name":"columnDerivationRuntimeError1.png","type":"image/png","lastModified":1685112176339.848,"size":90012},{"id":"43536a8863579bb4523e253ca1973054a90dc4c8ca001068dfc6ed2d56a7a9bf36117a4c7e07dc78a739517b2180bc900e59a91039a6a9d9328856c0a6cb04dd","href":"https://static.observableusercontent.com/files/43536a8863579bb4523e253ca1973054a90dc4c8ca001068dfc6ed2d56a7a9bf36117a4c7e07dc78a739517b2180bc900e59a91039a6a9d9328856c0a6cb04dd","name":"columnDerivationRuntimeError2.png","type":"image/png","lastModified":1685112176339.848,"size":81336},{"id":"6880898af9c81d09aa54e99d04b086859f430befa472b503fac4aae3bd3c778021bbdd6ed5d6bbe9c8903bf1a656b7c28c8d6a7e54e2ecbdd85a4e35be9f3ace","href":"https://static.observableusercontent.com/files/6880898af9c81d09aa54e99d04b086859f430befa472b503fac4aae3bd3c778021bbdd6ed5d6bbe9c8903bf1a656b7c28c8d6a7e54e2ecbdd85a4e35be9f3ace","name":"tableCellCreateColumnButton.png","type":"image/png","lastModified":1685112176339.848,"size":200165},{"id":"3ef4e741ef748be4f2ced23e5103335787c3eedb37196f40be905bda1481d61b0829be51da04e5e8e69e837bba13da9cfdb79288630670dea07828a26bc4e86d","href":"https://static.observableusercontent.com/files/3ef4e741ef748be4f2ced23e5103335787c3eedb37196f40be905bda1481d61b0829be51da04e5e8e69e837bba13da9cfdb79288630670dea07828a26bc4e86d","name":"tableCellCreateColumnError.png","type":"image/png","lastModified":1685112176339.848,"size":210417},{"id":"a511c78d019707c4a28a4ef296b21bde987a222964e84211e633acde3dec0860edadebff89903a864641d748c4a276d2c742a5a4feccb1c6a8d1fc76cc62ec64","href":"https://static.observableusercontent.com/files/a511c78d019707c4a28a4ef296b21bde987a222964e84211e633acde3dec0860edadebff89903a864641d748c4a276d2c742a5a4feccb1c6a8d1fc76cc62ec64","name":"tableCellCreatedColumn.png","type":"image/png","lastModified":1685112176339.848,"size":197265},{"id":"ca4959a2c15edc2b02d1acccd42e5dc3dcd886c90ab39da8dedd67d76b0199637208eca1a219ccd6ab4ccaa321196d4ce00710774822ca836f16e9dd57e15965","href":"https://static.observableusercontent.com/files/ca4959a2c15edc2b02d1acccd42e5dc3dcd886c90ab39da8dedd67d76b0199637208eca1a219ccd6ab4ccaa321196d4ce00710774822ca836f16e9dd57e15965","name":"tableCellCreatedColumnEditor2@2.png","type":"image/png","lastModified":1685112176339.848,"size":204476},{"id":"688b8f8d393e788c0a43da758fda18fb8e317aef36c75c7d09ad7a58c16089578239b7ca8dcf60b4697ce23c31efd11219f2c90646e1f044e6c5decc42ef61b1","href":"https://static.observableusercontent.com/files/688b8f8d393e788c0a43da758fda18fb8e317aef36c75c7d09ad7a58c16089578239b7ca8dcf60b4697ce23c31efd11219f2c90646e1f044e6c5decc42ef61b1","name":"tableCellCreatedColumnEditorReopen@1.png","type":"image/png","lastModified":1685112176339.848,"size":210034},{"id":"fda33c4faec8b73051f1625ec3a57ffd7921ac5f6297935eb2d88cc8a327912dc28c864701432ecde7cd0b5ff4665c6e2520e05d4379a6d4b3507df6ff47f58f","href":"https://static.observableusercontent.com/files/fda33c4faec8b73051f1625ec3a57ffd7921ac5f6297935eb2d88cc8a327912dc28c864701432ecde7cd0b5ff4665c6e2520e05d4379a6d4b3507df6ff47f58f","name":"convertedSQLCell@2.png","type":"image/png","lastModified":1680894048125.68,"size":248021},{"id":"68c13c6f561dc74caa34cf234972e00edd2c5e340e8c683324d88070ac0c1d5bd73cd7ec1e0aa174f86c1fe65ab86ccac7cf142f9c45721a4cc59f4eb83587d2","href":"https://static.observableusercontent.com/files/68c13c6f561dc74caa34cf234972e00edd2c5e340e8c683324d88070ac0c1d5bd73cd7ec1e0aa174f86c1fe65ab86ccac7cf142f9c45721a4cc59f4eb83587d2","name":"convertToSQL@1.png","type":"image/png","lastModified":1680894048125.68,"size":102613}] 2f:{"title":"Data table cell","cells":[{"id":0,"value":"# Data table cell","pinned":false,"hidden":false,"mode":"md"},{"id":68,"value":"The **data table cell** cell mode provides you with an easy way to put your data in table form. \n- You can quickly scan multiple columns of information.\n- Mouse over top-of-column summaries to explore the range of values.","pinned":false,"hidden":false,"mode":"md"},{"id":1072,"value":"example = await FileAttachment(\"chinook.db\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":3,"value":"Once you have created a data table cell, you can quickly sift through your data using common data manipulation operations:\n- [Filter](#filterSection) - Limit displayed results to matched criteria.\n- [Columns (Show/Hide)](#showHideSection) - Show or hide only certain columns.\n- [Sort](#sortSection) - Sort columns into ascending or descending order.\n- [Slice](#sliceSection) - Define a slice of data so that only limited rows are shown.\n","pinned":false,"hidden":false,"mode":"md"},{"id":20,"value":"You decide where the data in the data table cell comes from. This is your *data source*, and can be any of the following:\n- A cell in your notebook that contains data\n- An attached `.csv`, `.tsv`, JSON, or SQLite file\n- An Apache Arrow or Parquet file\n- A database that you have connected (for instructions, see [Connecting to databases](https://observablehq.com/@observablehq/databases))","pinned":false,"hidden":false,"mode":"md"},{"id":1194,"value":"To get started:\n1. Create the data table cell from the cell menu.\n2. If necessary, prepare a data source by attaching a file or connecting to a database.\n3. Select the data source (and table, if using a database) from the data table cell.","pinned":false,"hidden":false,"mode":"md"},{"id":103,"value":"## Creating a data table cell","pinned":false,"hidden":false,"mode":"md"},{"id":114,"value":"To create a data table cell, click the plus sign (+) to create a new cell, then select **Data table** from the cell menu:","pinned":false,"hidden":false,"mode":"md"},{"id":124,"value":"

\n \n

To create a data table cell, select Data table from the cell menu.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":127,"value":"The new data table cell appears:","pinned":false,"hidden":false,"mode":"md"},{"id":96,"value":"

\n \n

A new, unnamed data table cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":156,"value":"This is the data editor toolbar. From here, you can choose your data source, then do filtering, column operations, sorting, and so on. The next step is to prepare a data source.","pinned":false,"hidden":false,"mode":"md"},{"id":1190,"value":"## Using an existing cell as a data source","pinned":false,"hidden":false,"mode":"md"},{"id":1189,"value":"If you have a named cell in your notebook that already contains data (that is, an array of objects), you are able to directly select that cell as your data source. For example, the following cell has a small set of American motion picture data (from [Wikipedia](https://en.wikipedia.org/wiki/Academy_Award_for_Best_Picture)):","pinned":false,"hidden":false,"mode":"md"},{"id":1188,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":1187,"value":"Since the data is already available, we only need to click **Select a data source** and then select the `bestPictureNominees` cell as a data source:","pinned":false,"hidden":false,"mode":"md"},{"id":1186,"value":"

\n \n

Click to select a data source.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1185,"value":"

\n \n

Example of an in-memory data source.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1184,"value":"Here is the resulting data table cell.","pinned":false,"hidden":false,"mode":"md"},{"id":1183,"value":"bestPictureNominees","pinned":false,"hidden":false,"mode":"ojs"},{"id":1182,"value":"Things to notice:\n- You can scroll the results to view all returned rows.\n- You can see the selected data source in the data table cell controls.","pinned":false,"hidden":false,"mode":"md"},{"id":1223,"value":"## Hiding (and restoring) the data editor toolbar","pinned":false,"hidden":false,"mode":"md"},{"id":1222,"value":"If you want to display only the table, you can hide the data editor toolbar by clicking the Close Cell arrow to the left of the data table cell:","pinned":false,"hidden":false,"mode":"md"},{"id":1221,"value":"

\n \n

Click the Close Cell arrow to hide the data editor toolbar.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1220,"value":"Click the arrow again to restore the data editor toolbar.","pinned":false,"hidden":false,"mode":"md"},{"id":1181,"value":"## Preparing data sources from .csv, .tsv, Arrow, Parquet, JSON, or SQLite files","pinned":false,"hidden":false,"mode":"md"},{"id":1180,"value":"Data sources can be prepared easily from any of these types of files:\n- .`csv` (comma-separated values)\n- .`tsv` (tab-separated values)\n- Apache Arrow or Parquet ([examples](https://observablehq.com/@observablehq/example-arrow-and-parquet-files-in-data-table-cells?collection=@observablehq/getting-data-in-and-out))\n- JSON (JavaScript Object Notation)\n- SQLite\n\nYou can attach the file to your notebook (click the paper clip icon to attach a file) and then select the file from **Select a data source**, as shown earlier.","pinned":false,"hidden":false,"mode":"md"},{"id":1179,"value":"For example, there is a file named `aapl.csv` attached to this notebook. If you create a data table cell and then click **Select a data source**, you can see the `aapl.csv` file under **File attachments**:","pinned":false,"hidden":false,"mode":"md"},{"id":1178,"value":"

\n \n

A data source can be a .csv file attached to the notebook.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1177,"value":"Similarly, if you have a SQLite file attached to the notebook, it too can be seen and selected under **File attachments**.","pinned":false,"hidden":false,"mode":"md"},{"id":55,"value":"## Selecting a data source from a connected database","pinned":false,"hidden":false,"mode":"md"},{"id":579,"value":"If you have not yet defined a database, click **Add database** to be taken to the Databases page in your Settings, where you can add a database using `DatabaseClient` (that process is described in [Connecting to databases](https://observablehq.com/@observablehq/databases?collection=@observablehq/working-with-data)).","pinned":false,"hidden":false,"mode":"md"},{"id":224,"value":"

\n \n

Use Add database to set up database connections.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":586,"value":"After your database is connected, click **Select a data source** and choose your database from the list of available databases. ","pinned":false,"hidden":false,"mode":"md"},{"id":181,"value":"

\n \n

Databases lists the connected databases.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":159,"value":"## Selecting a table","pinned":false,"hidden":false,"mode":"md"},{"id":231,"value":"Once you have selected a database, you next need to select a table from that database (this is not needed for file attachments and existing-cell data sources).","pinned":false,"hidden":false,"mode":"md"},{"id":184,"value":"

\n \n

Click Select a table after you have chosen a database.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":960,"value":"bigQueryNote = note(htl.html`\n Note: If you selected a BigQuery database, you need to enter the projectname.schemaname.tablename, rather than selecting a table name.\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"

\n \n

Select a table from the menu.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":239,"value":"Once you have selected a database and table, the tabular data will populate the cell.","pinned":false,"hidden":false,"mode":"md"},{"id":243,"value":"

\n \n

The data table cell fills with data once you select a database and table.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":161,"value":"tableNameSection = md `## Naming the data table cell`","pinned":false,"hidden":false,"mode":"ojs"},{"id":166,"value":"It isn't required to name the data table cell, but if you want to [refer](#tableRefSection) to the table data from another cell, you will need to give the data table cell a name. Type the name into the name area:","pinned":false,"hidden":false,"mode":"md"},{"id":171,"value":"

\n \n

Enter the name for the data table cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":52,"value":"## Filter, Columns, Sort, Slice \n- Data table cells contain user interface controls for:\n - **Filter**ing the data so that only data meeting your criteria appear\n - Showing/hiding specific **columns** and deriving new ones\n - Applying **sort**ing\n - Limiting the display to only certain rows (creating a **slice**)","pinned":false,"hidden":false,"mode":"md"},{"id":15,"value":"filterSection = md `### Filtering`","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"

\n \n

Select Filter to define filtering conditions to apply.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":268,"value":"Use filtering to define what part of the data to display. Just as an optical infrared filter that cuts off at 830 nanometers will not allow visible light through, you can define a filter to show only the results that you want to see.","pinned":false,"hidden":false,"mode":"md"},{"id":273,"value":"To define the filtering criteria, click on **Filter**. You then see pulldown menus that initially specify **Column** and **Operator**. ","pinned":false,"hidden":false,"mode":"md"},{"id":458,"value":"

\n \n

Click the black triangle to display the available choices for the Column field.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":466,"value":"Once you have selected an item from the Column menu, appropriate choices appear in the Operator menu, and an additional field appears so that you can enter detailed criteria:","pinned":false,"hidden":false,"mode":"md"},{"id":471,"value":"

\n \n

After you select a Column item, appropriate fields appear so that you can specify additional criteria.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":283,"value":"The types of comparison operators available depend on the type of value in the Column field.\n- String values have the following types of comparison operators available:\n - is\n - is not\n - contains\n - does not contain\n - is in\n - is not in\n - is null\n - is not null","pinned":false,"hidden":false,"mode":"md"},{"id":951,"value":"containsNote = note(htl.html`\n Note: The contains operator is case sensitive in some databases and not case sensitive in others. That behavior is database-dependent.\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":417,"value":"- Numeric values have the following types of comparison operators available:\n - =\n - ≠\n - <\n - `>`\n - `<=`\n - `>=`\n - is in\n - is not in\n - is null\n - is not null","pinned":false,"hidden":false,"mode":"md"},{"id":1060,"value":"numericNullNote = note(htl.html`\n Note: Some numeric items may not allow is null/is not null comparisons.\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":487,"value":"- Boolean values (TRUE or FALSE) have the following types of comparison operators available:\n - =\n - ≠\n - is null\n - is not null","pinned":false,"hidden":false,"mode":"md"},{"id":511,"value":"- Date values have the following types of comparison operators available:\n - is before ``\n - is after ``\n - is on or before ``\n - is on or after ``\n - is null\n - is not null","pinned":false,"hidden":false,"mode":"md"},{"id":570,"value":"- Object values do not support operators.","pinned":false,"hidden":false,"mode":"md"},{"id":293,"value":"You can define multiple filter criteria. Once you complete the first row of filter criteria, a second row appears. You can then define filter criteria based on a second column of data.","pinned":false,"hidden":false,"mode":"md"},{"id":430,"value":"It is possible to define filter criteria that are contradictory; for example:","pinned":false,"hidden":false,"mode":"md"},{"id":443,"value":"`// This will return no results:`\n\n ID_number < 9\n ID_number > 100","pinned":false,"hidden":false,"mode":"md"},{"id":299,"value":"The order in which you define the filtering criteria does not matter.","pinned":false,"hidden":false,"mode":"md"},{"id":436,"value":"To delete a row of filter criteria, click the \"x\" that appears to the right of each row.","pinned":false,"hidden":false,"mode":"md"},{"id":16,"value":"### Showing and hiding columns","pinned":false,"hidden":false,"mode":"md"},{"id":309,"value":"Click **Columns** to display the list of table columns. ","pinned":false,"hidden":false,"mode":"md"},{"id":187,"value":"

\n \n

Click Columns to see the list of table columns.

\n\n","pinned":false,"hidden":false,"mode":"html"},{"id":598,"value":"The resulting list displays checkboxes indicating which columns are to be shown.","pinned":false,"hidden":false,"mode":"md"},{"id":481,"value":"

\n \n

Checkboxes indicate the columns to show.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":753,"value":"By default, all columns are shown. You can hide specific columns by unchecking the checkbox for a given column.","pinned":false,"hidden":false,"mode":"md"},{"id":608,"value":"If you hover the pointer over an individual item in the list, the word **only** appears. If you click **only**, all other columns are de-selected.","pinned":false,"hidden":false,"mode":"md"},{"id":611,"value":"

\n \n

Click only to show only that column.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":617,"value":"To restore all columns to visibility, click **Show all**.","pinned":false,"hidden":false,"mode":"md"},{"id":620,"value":"

\n \n

Click Show all to restore all columns.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":332,"value":"Note that if you de-select all columns one-by-one and then add them back individually, the columns appear in the order in which they are added. Clicking **Show all** (or selecting all columns) restores the original display order.","pinned":false,"hidden":false,"mode":"md"},{"id":1300,"value":"### Creating new columns for column derivations","pinned":false,"hidden":false,"mode":"md"},{"id":1299,"value":"New columns, derived from the original columns, can also be added to the data table cell. To do so, click the `+` button in the upper right-hand corner of the table view, as seen here:","pinned":false,"hidden":false,"mode":"md"},{"id":1298,"value":"

\n \n

Click + in the upper right-hand corner of the table to create a new column.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1297,"value":"and the new column will appear highlighted in blue to the right of the original columns:","pinned":false,"hidden":false,"mode":"md"},{"id":1296,"value":"

\n \n

The new column will appear to the right of the columns already shown.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1295,"value":"The editor also appears when you first create a column:","pinned":false,"hidden":false,"mode":"md"},{"id":1294,"value":"

\n \n

The editor has appeared near the bottom of the Data Table Cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1293,"value":"which allows you to name your new column and define the derivation with an expression.","pinned":false,"hidden":false,"mode":"md"},{"id":1292,"value":"dataTypesDeviredColumnsNote = note(htl.html`\n Note: Data types for derived columns are inferred and overridable just like the other columns in the table.\n`)\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1291,"value":"After you click the **Done** button, the view of the **Data cell table** will revert back to normal. However, you can edit an existing expression as needed by clicking the {} icon in the column heading:\n\n","pinned":false,"hidden":false,"mode":"md"},{"id":1290,"value":"

\n \n

To reopen the editor for editing the column name and expression click the {} button in the column heading.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1289,"value":"#### Writing Expressions to define a newly created column","pinned":false,"hidden":false,"mode":"md"},{"id":1288,"value":"A built-in object called **row** allows you to access other column data that can then be applied to each row one at a time in the derived column. For instance, the above screenshot derives a new \"power to weight\" column by dividing the value from each row in the \"power (hp)\" column by value from each row in the \"weight (lb)\" column.\n","pinned":false,"hidden":false,"mode":"md"},{"id":1287,"value":"You can perform most of the computation available in normal JavaScript cells. This includes the ability to write arbitrary JavaScript expressions, reference the output of other cells, and call functions defined in other cells. There are some notable limitations to what you can do with this cell:\n - You cannot render HTML or a Plot in the cell.\n - You cannot render an [input](https://observablehq.com/@observablehq/inputs?collection=@observablehq/notebook-fundamentals) in the cell.\n - You cannot reference another derived cell.\n - You cannot access an entire column of data from within the expression cell (i.e. all of the rows at once), only each row one at a time (i.e. using the **row** object).","pinned":false,"hidden":false,"mode":"md"},{"id":1286,"value":"#### Error Handling for deriving new columns","pinned":false,"hidden":false,"mode":"md"},{"id":1285,"value":"There are a couple of scenarios that cause errors with column derivation:\n- Referencing a bad or non-existent column name, or make a syntax error in the expression cell, the table produces invalid results like `undefined` or `NaN`.\n ","pinned":false,"hidden":false,"mode":"md"},{"id":1284,"value":"

\n \n

Referencing a bad or non-existent column name in the expression editor.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1281,"value":"- When you run the cell using either `Shift+Enter` or the play button, but include a mistake that causes a runtime error (for instance, by using an undefined variable) the data table cell collapses other than the column headings, a search field, and the expression editor. You can then use the expression editor to fix the code.","pinned":false,"hidden":false,"mode":"md"},{"id":1280,"value":"

\n \n

A runtime error when you enter Shift+Enter or the play button.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1279,"value":"- When you cause a runtime error, but select the **Done** button instead of `Shift+Enter` or the play button first, the table collapses and the expression editor is closed. You can open the editor back up by selecting the `{}` button at the top of the new column and fix your the code accordingly.","pinned":false,"hidden":false,"mode":"md"},{"id":1278,"value":"

\n \n

A runtime error for an undefined variable when selecting the Done button instead of the play button.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":8,"value":"sortSection = md `### Sorting`","pinned":false,"hidden":false,"mode":"ojs"},{"id":195,"value":"

\n \n

Select Sort to define the sorting criteria.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":336,"value":"Use **Sort** to arrange the items in the table into order, using any of the columns as a sort key.","pinned":false,"hidden":false,"mode":"md"},{"id":627,"value":"

\n \n

Click the black triangle to display the available sort key choices for the Column field.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":548,"value":"You can define multiple sort keys, which is useful when there are duplicate values in some columns.","pinned":false,"hidden":false,"mode":"md"},{"id":631,"value":"For each sort key column, use the **Direction** pulldown to select a **Descending** sort or an **Ascending** sort.","pinned":false,"hidden":false,"mode":"md"},{"id":635,"value":"

\n \n

Choose either a Descending or an Ascending sort.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":536,"value":"You may wish to define your Filter criteria first, to limit the returned results, and then do sorting.","pinned":false,"hidden":false,"mode":"md"},{"id":13,"value":"sliceSection = md `### Slicing`","pinned":false,"hidden":false,"mode":"ojs"},{"id":200,"value":"

\n \n

Select Slice to define a reduced portion of the tabular data to display.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":552,"value":"Use **Slice** to display only a limited number of rows from the table—for example, the first *N* rows. (You may want to define your filter and sorting criteria first.) By default, **Slice** is set to display rows 0-1000.","pinned":false,"hidden":false,"mode":"md"},{"id":662,"value":"

\n \n

Click Start to start the slice from the start of data. Click End to conclude the slice at the end of data.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":666,"value":"Once you have defined the lower and upper limits of the slice, press Enter to apply the limits (or click the **Slice** button again). ","pinned":false,"hidden":false,"mode":"md"},{"id":34,"value":"tableRefSection = md `## Referring to a data table cell`","pinned":false,"hidden":false,"mode":"ojs"},{"id":644,"value":"If you have given a [name](#tableNameSection) to your data table cell, you can then refer to it in other parts of the notebook.","pinned":false,"hidden":false,"mode":"md"},{"id":831,"value":"

\n \n

You can refer to the data in a named data table cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":835,"value":"The array can be expanded for viewing:","pinned":false,"hidden":false,"mode":"md"},{"id":837,"value":"

\n \n

Click the black triangle to the left of Array to expand the data.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":43,"value":"## Summary charts","pinned":false,"hidden":false,"mode":"md"},{"id":343,"value":"These small graphics at the top of each column provide a quick summary of key data characteristics for each column below.","pinned":false,"hidden":false,"mode":"md"},{"id":341,"value":"

\n \n

Each small chart provides a summary of that column's data. Columns are width-adjustable.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":392,"value":"Note also, that the small charts are *interactive*. When you hover the pointer over each chart, you can get even more detailed information. By sliding your mouse along the displayed values, you can see individual values for each histogram or bar chart segment. Compare the following figure with the previous one:","pinned":false,"hidden":false,"mode":"md"},{"id":681,"value":"

\n \n

Highlighting an individual value in a summary chart causes the text above to reflect that value's data.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":762,"value":"By hovering over the dark bar in the highlighted chart above, we now see additional information:\n- The bar represents 152 rows of the total, or 44%.\n- The variety of penguin selected is \"Adelie\".","pinned":false,"hidden":false,"mode":"md"},{"id":772,"value":"Here is another example, this time a histogram. Before hovering under an individual vertical bar:","pinned":false,"hidden":false,"mode":"md"},{"id":777,"value":"

\n \n

A histogram summary chart before any individual vertical bar is highlighted.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":780,"value":"Here is the same histogram, after the pointer is hovered just under the tallest vertical bar:","pinned":false,"hidden":false,"mode":"md"},{"id":783,"value":"

\n \n

A histogram summary chart after the tallest bar is highlighted.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":790,"value":"We now see additional information:\n- The bar represents 62 rows of the total, or 18%.\n- The values in that column range from 190 to 195.","pinned":false,"hidden":false,"mode":"md"},{"id":1262,"value":"### Null sign results","pinned":false,"hidden":false,"mode":"md"},{"id":1261,"value":"md`Earlier we saw a histogram bar with the null sign (\\u2205).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1260,"value":"

\n \n

The null sign represents invalid values.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1259,"value":"This bar represents results that are invalid. Hovering under this bar causes a message to that effect to be displayed. If you click the bar, the column will display the invalid results. In the following example, \"NaN\" stands for \"Not a Number\". ","pinned":false,"hidden":false,"mode":"md"},{"id":1258,"value":"

\n \n

\"NaN\" stands for \"Not a Number\".

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1257,"value":"To de-select the invalid results, click the null set bar again.","pinned":false,"hidden":false,"mode":"md"},{"id":1256,"value":"### Selecting results","pinned":false,"hidden":false,"mode":"md"},{"id":1255,"value":"By pressing the Command/Ctrl key while clicking on a summary chart, you can select partial results in a column. Only the selected results display:","pinned":false,"hidden":false,"mode":"md"},{"id":1254,"value":"

\n \n

Use the Command/Ctrl key to select results within a column.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1253,"value":"Notice also that the background shading of the column changes. To clear the selection, click on the selected result again.","pinned":false,"hidden":false,"mode":"md"},{"id":1252,"value":"For a column displaying continuous results in a histogram, you can define a selection range, which can be adjusted in size, or dragged to a new location.","pinned":false,"hidden":false,"mode":"md"},{"id":1251,"value":"

You can define a selection range over a summary chart histogram.

","pinned":false,"hidden":false,"mode":"html"},{"id":1250,"value":"crosshairNote = note(htl.html`\n Note: When defining a selection range, be sure the crosshair (+) cursor is visible..\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1249,"value":"To clear a selection in a histogram, click the crosshair cursor outside the selection (but still in the histogram area).","pinned":false,"hidden":false,"mode":"md"},{"id":1248,"value":"### Saving column result selections\nIf you have defined a column result selection (as described in [Selecting results](#selectingResults)), you can click the blue **Save** button and your selections are saved as a filter:","pinned":false,"hidden":false,"mode":"md"},{"id":1247,"value":"

\n \n

Column result selections can be saved as a filter.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1246,"value":"To clear the filter, click the \"x\" at the right of the filter specification.","pinned":false,"hidden":false,"mode":"md"},{"id":1245,"value":"### Text results","pinned":false,"hidden":false,"mode":"md"},{"id":730,"value":"If the column contains values that are best represented by text only, the summary charts display a descriptive message:","pinned":false,"hidden":false,"mode":"md"},{"id":733,"value":"

\n \n

Summary charts display text when appropriate.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1242,"value":"### Interacting with rows of data","pinned":false,"hidden":false,"mode":"md"},{"id":921,"value":"In addition to interacting with the columns in the summary charts, you can interact with the rows of data. Hovering over a row of data causes individual marks in the summary chart to highlight. \n\nIn the following example, the pointer is hovered over the highlighted row. The summary charts have changed to reflect the values in that row.\n\n

\n \n

Hovering over a row of data highlights individual marks in the summary charts.

\n","pinned":false,"hidden":false,"mode":"md"},{"id":711,"value":"summaryTableNote = note(htl.html`\n Note: The summary charts are an extension of previous work on the Summary Table.\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":892,"value":"## Converting to SQL","pinned":false,"hidden":false,"mode":"md"},{"id":894,"value":"If you want to create a hand-tuned SQL query on selected results, you can convert a populated data table cell to a [SQL cell](https://observablehq.com/@observablehq/sql). Click the **+** below a data table cell and select **Convert to SQL**.","pinned":false,"hidden":false,"mode":"md"},{"id":896,"value":"

\n \n\n \n

Click Convert to SQL to make a new SQL cell with the equivalent query.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":909,"value":"A new SQL cell appears, with the same columns, filters, sorts, and slices:","pinned":false,"hidden":false,"mode":"md"},{"id":911,"value":"

\n \n

The SQL code in the converted cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":936,"value":"## Custom database clients\n\nYou can also use a custom database client as a data source for a data table cell. In order for a database client to be recognized as a valid data source, it must satisfy the requirements outlined in [DatabaseClient Specification](https://observablehq.com/@observablehq/database-client-specification).","pinned":false,"hidden":false,"mode":"md"},{"id":1232,"value":"## Databases Panel and Schema Viewer \nIn combination with the data table cell, you can make use of the [Databases Panel and Schema Viewer](https://observablehq.com/@observablehq/databases-panel-and-schema-viewer?collection=@observablehq/getting-data-in-and-out) to view a database's schema and insert cells pre-configured for a given database.","pinned":false,"hidden":false,"mode":"md"},{"id":1095,"value":"## SQL mystery game / data table cell tutorial","pinned":false,"hidden":false,"mode":"md"},{"id":1097,"value":"If you're up for a challenge, the [SQL mystery game](https://observablehq.com/@observablehq/sql-mystery-game-data-table-tutorial?collection=@observablehq/sql-mystery-game) notebook asks you to solve a mystery using data table cells. Take a look!","pinned":false,"hidden":false,"mode":"md"},{"id":133,"value":"---\n## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":402,"value":"note = {\n const scope = DOM.uid(\"note\").id;\n const style = document.head.appendChild(htl.html`