25:["$","title",null,{"children":"Data table cell | Crystal Alchemist | Observable"}] 49: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"] ]4a:[{"id":"68c13c6f561dc74caa34cf234972e00edd2c5e340e8c683324d88070ac0c1d5bd73cd7ec1e0aa174f86c1fe65ab86ccac7cf142f9c45721a4cc59f4eb83587d2","href":"https://static.observableusercontent.com/files/68c13c6f561dc74caa34cf234972e00edd2c5e340e8c683324d88070ac0c1d5bd73cd7ec1e0aa174f86c1fe65ab86ccac7cf142f9c45721a4cc59f4eb83587d2","name":"convertToSQL@1.png","type":"image/png","lastModified":1687888717617.738,"size":102613},{"id":"4f7e7b94a78a39196e3e3f08a5b94ecfa767da4031637ce4d83f997436089a619ceb44ac39daa3d4d7a9b6b8ac73cc9397117fe1fb4532e76fcc74da42520551","href":"https://static.observableusercontent.com/files/4f7e7b94a78a39196e3e3f08a5b94ecfa767da4031637ce4d83f997436089a619ceb44ac39daa3d4d7a9b6b8ac73cc9397117fe1fb4532e76fcc74da42520551","name":"tableCell_Sort_Up_or_Down.png","type":"image/png","lastModified":1687888717617.738,"size":28048},{"id":"7c63c97b556b2f013f246aa66964b8a205716d6c59d98da8174b47bc65caba546d5d3443b5f84083fbd0165443930abe9464c1c645c481b58bb65128d7a6943e","href":"https://static.observableusercontent.com/files/7c63c97b556b2f013f246aa66964b8a205716d6c59d98da8174b47bc65caba546d5d3443b5f84083fbd0165443930abe9464c1c645c481b58bb65128d7a6943e","name":"tableCell_SortCriteria_Column.png","type":"image/png","lastModified":1687888717617.738,"size":38248},{"id":"8727cf81f8e7b96f38f58f69a7da8e88432cd958ae82ed1f52b7c1aa685ed9fe4d9eaeacee7a9dfe5fa661dac17e6d8176995fdd22efbbb6f7d9eb398ef96da7","href":"https://static.observableusercontent.com/files/8727cf81f8e7b96f38f58f69a7da8e88432cd958ae82ed1f52b7c1aa685ed9fe4d9eaeacee7a9dfe5fa661dac17e6d8176995fdd22efbbb6f7d9eb398ef96da7","name":"tableCell_FilterCriteria_ThreeFields.png","type":"image/png","lastModified":1687888717617.738,"size":11856},{"id":"bd9b1a7369fb25cfdafaae0d0512cfd7a8e92c6dca8a20176d29c305af397ff784f86b93249fb0acc582ed5475c4b48f623116c1df4d85e4857ce22d41557bd6","href":"https://static.observableusercontent.com/files/bd9b1a7369fb25cfdafaae0d0512cfd7a8e92c6dca8a20176d29c305af397ff784f86b93249fb0acc582ed5475c4b48f623116c1df4d85e4857ce22d41557bd6","name":"tableCell_FilterCriteria_Column.png","type":"image/png","lastModified":1687888717617.738,"size":35017},{"id":"b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","href":"https://static.observableusercontent.com/files/b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","name":"chinook.db","type":"application/x-sqlite3","lastModified":1687888717617.738,"size":884736},{"id":"a30eb26b17cdc418ea891e6ca89f0070aa271cd899fe4d0b081eb2a9cc1da1be44a0049d5cf22cc86b511c2ac75a1177a8cc9990ce3485ec288eb6440b1106cf","href":"https://static.observableusercontent.com/files/a30eb26b17cdc418ea891e6ca89f0070aa271cd899fe4d0b081eb2a9cc1da1be44a0049d5cf22cc86b511c2ac75a1177a8cc9990ce3485ec288eb6440b1106cf","name":"closeCellArrow_v2.png","type":"image/png","lastModified":1687888717617.738,"size":36336},{"id":"53b0913245e173bf55a62d6ab9df82aed58bb4ed3d8e2ee9b3b3dd2b8c1ff6ce4a8d1018921022784e16122a3ff4dae77b320646fd900b0db7e8a70f7ddfa6a2","href":"https://static.observableusercontent.com/files/53b0913245e173bf55a62d6ab9df82aed58bb4ed3d8e2ee9b3b3dd2b8c1ff6ce4a8d1018921022784e16122a3ff4dae77b320646fd900b0db7e8a70f7ddfa6a2","name":"myTableSlice_v2.png","type":"image/png","lastModified":1687888717617.738,"size":28189},{"id":"dccd4ce79413e55e2563feeb3ddc5dd488a78f5fe840870c37fa25a28100eeb89d1ab20df7effdfa04737afcb8f101b9604dc2c0d094e117bda6ff3edce1b20f","href":"https://static.observableusercontent.com/files/dccd4ce79413e55e2563feeb3ddc5dd488a78f5fe840870c37fa25a28100eeb89d1ab20df7effdfa04737afcb8f101b9604dc2c0d094e117bda6ff3edce1b20f","name":"myTableSort_v2.png","type":"image/png","lastModified":1687888717617.738,"size":28273},{"id":"997a7c2206f98b7e2b753a5bf4b48f95be6503dcec1dd97b6f87b6333eefece3dab8a3ec267d3eee62e0f4bfd8a7a8bde00391df3a7ce38998374343acf0f5f5","href":"https://static.observableusercontent.com/files/997a7c2206f98b7e2b753a5bf4b48f95be6503dcec1dd97b6f87b6333eefece3dab8a3ec267d3eee62e0f4bfd8a7a8bde00391df3a7ce38998374343acf0f5f5","name":"selectATable_v4.png","type":"image/png","lastModified":1687888717617.738,"size":26966},{"id":"4d0144e607d4d253411ec549ed695f19a2d3fa0a4a30634099709d86d1b81c8c60c46e3e99f1907cee546b4ea8ee49baa3a4d35fc4c8d1d3a39e13cd9c801acc","href":"https://static.observableusercontent.com/files/4d0144e607d4d253411ec549ed695f19a2d3fa0a4a30634099709d86d1b81c8c60c46e3e99f1907cee546b4ea8ee49baa3a4d35fc4c8d1d3a39e13cd9c801acc","name":"addDatabaseButton_v2.png","type":"image/png","lastModified":1687888717617.738,"size":20901},{"id":"de7fe2b8f55d1f7981a778db7892ce6996566a66958f1517bbdfaeba3ed1571cc007c91e99ffd10a43543ae555a0e99096331b7b1fb333bbfc8f267e974595f3","href":"https://static.observableusercontent.com/files/de7fe2b8f55d1f7981a778db7892ce6996566a66958f1517bbdfaeba3ed1571cc007c91e99ffd10a43543ae555a0e99096331b7b1fb333bbfc8f267e974595f3","name":"connectedDatabases_v2.png","type":"image/png","lastModified":1687888717617.738,"size":66124},{"id":"21c795b11b08fe435727b647ce7cadb8e9155da63e03afe46cb53709ab818fc4cb9dc5989c09180a44231975c7180f0c490d475015aa961bf30fce5bbd8c4634","href":"https://static.observableusercontent.com/files/21c795b11b08fe435727b647ce7cadb8e9155da63e03afe46cb53709ab818fc4cb9dc5989c09180a44231975c7180f0c490d475015aa961bf30fce5bbd8c4634","name":"tableCellColumnsShowAll.png","type":"image/png","lastModified":1687888717617.738,"size":30039},{"id":"83d4078255140309d3469b079e6d6ed70a35460886cb7ea5f64619002c6eb9635bc2e7371b12072673f67283330b7f49fe3653b462e235be93f7aad30b277e20","href":"https://static.observableusercontent.com/files/83d4078255140309d3469b079e6d6ed70a35460886cb7ea5f64619002c6eb9635bc2e7371b12072673f67283330b7f49fe3653b462e235be93f7aad30b277e20","name":"tableCellColumnsOnly.png","type":"image/png","lastModified":1687888717617.738,"size":33317},{"id":"3584cff9a5a3e4adc7469495c893e58152691d0d734933d336af07c825a5cf9ebd514e6138d236d5449b58d6c5b28a7e291cd1125fe05895ba55e2b21d26c17a","href":"https://static.observableusercontent.com/files/3584cff9a5a3e4adc7469495c893e58152691d0d734933d336af07c825a5cf9ebd514e6138d236d5449b58d6c5b28a7e291cd1125fe05895ba55e2b21d26c17a","name":"tableCellColumnsMenu.png","type":"image/png","lastModified":1687888717617.738,"size":32384},{"id":"c15cff551607b243d234499be5ac9d16bdd680155a62a1a03f8d5b5023a24fbe839a245dbbb974d7b38a0025557ce3d53d542b0945a2cb1e2bcfaa7b946e4f1b","href":"https://static.observableusercontent.com/files/c15cff551607b243d234499be5ac9d16bdd680155a62a1a03f8d5b5023a24fbe839a245dbbb974d7b38a0025557ce3d53d542b0945a2cb1e2bcfaa7b946e4f1b","name":"bestPictureNomineesCell.png","type":"image/png","lastModified":1687888717617.738,"size":75877},{"id":"ac677eb3c9a318fc7809361585ff62289cd0fb03848ae418ee18326545b747b38693a2eefab61a5b179d24117fd89ebc819d971dd5f7600a6a0a8169a6b92261","href":"https://static.observableusercontent.com/files/ac677eb3c9a318fc7809361585ff62289cd0fb03848ae418ee18326545b747b38693a2eefab61a5b179d24117fd89ebc819d971dd5f7600a6a0a8169a6b92261","name":"selectADataSource_v3.png","type":"image/png","lastModified":1687888717617.738,"size":22744},{"id":"91021b38896a437c003ebad8bab035a36ac1c61864d72f87f3083d1b2661ffebb3595e1aacb64ec1f3337d55c746ac8ee6d4e0663bf766b4812c6d154518af87","href":"https://static.observableusercontent.com/files/91021b38896a437c003ebad8bab035a36ac1c61864d72f87f3083d1b2661ffebb3595e1aacb64ec1f3337d55c746ac8ee6d4e0663bf766b4812c6d154518af87","name":"dataTableMenu_v6.png","type":"image/png","lastModified":1687888717617.738,"size":45705},{"id":"9afb0358fc9ff8ca8c80e03b22f4afc04d6e9f2401791b5073eb1ce936f3a15482d5127887e68b9eb54a1935cbdadf957767b64862bd91b1afbcea9f8e8d50fb","href":"https://static.observableusercontent.com/files/9afb0358fc9ff8ca8c80e03b22f4afc04d6e9f2401791b5073eb1ce936f3a15482d5127887e68b9eb54a1935cbdadf957767b64862bd91b1afbcea9f8e8d50fb","name":"tableCell_ColSumm_Messages_v2.png","type":"image/png","lastModified":1687888717617.738,"size":21654},{"id":"5003ee74747a765a5f3520b15ad21cec1db356e30ec9da45328f84d7d0a352e50c70b4c2855b8d4d316681eebd1a36c41125413a580e05d002e0c88ed48b9b28","href":"https://static.observableusercontent.com/files/5003ee74747a765a5f3520b15ad21cec1db356e30ec9da45328f84d7d0a352e50c70b4c2855b8d4d316681eebd1a36c41125413a580e05d002e0c88ed48b9b28","name":"tableCell_ArrayExpanded_v3.png","type":"image/png","lastModified":1687888717617.738,"size":583971},{"id":"397b477384f9c882ead5cb0b2ef36b899b9a11adb9e803ccafbefefcf7677000bc473b3c71443ead29c02f33f5d39a632d2db93421fa47cb6a8380bd7f0aa84e","href":"https://static.observableusercontent.com/files/397b477384f9c882ead5cb0b2ef36b899b9a11adb9e803ccafbefefcf7677000bc473b3c71443ead29c02f33f5d39a632d2db93421fa47cb6a8380bd7f0aa84e","name":"tableCell_RefToTable_v3.png","type":"image/png","lastModified":1687888717617.738,"size":27533},{"id":"f9c9b7f074314281e99545bee68b4584a9e9d979d46a6e5d0cb24224b02402b06cddc57b69be538a20fb4f1ac99251018895dbfac3a1036dc0b22a7ca80f62db","href":"https://static.observableusercontent.com/files/f9c9b7f074314281e99545bee68b4584a9e9d979d46a6e5d0cb24224b02402b06cddc57b69be538a20fb4f1ac99251018895dbfac3a1036dc0b22a7ca80f62db","name":"sliceFromTo.png","type":"image/png","lastModified":1687888717617.738,"size":22165},{"id":"6f84b4bf3e762b1a579d698527997d192ce9443984a83693fba5891d2413d33bac8efad1b669db81b46af232ec0f5a8eec347dc39863bb537f884265521a6b60","href":"https://static.observableusercontent.com/files/6f84b4bf3e762b1a579d698527997d192ce9443984a83693fba5891d2413d33bac8efad1b669db81b46af232ec0f5a8eec347dc39863bb537f884265521a6b60","name":"myTableColumns_v2.png","type":"image/png","lastModified":1687888717617.738,"size":28330},{"id":"8c4794af76dbc88f6a65b69902599ca5f98a1355f44de0d897bfdc2971da8532a01c6c51c4a88632375b97d0a64da854a4f5b32690850e80ba5810449c5ac75b","href":"https://static.observableusercontent.com/files/8c4794af76dbc88f6a65b69902599ca5f98a1355f44de0d897bfdc2971da8532a01c6c51c4a88632375b97d0a64da854a4f5b32690850e80ba5810449c5ac75b","name":"myTableFilter_v2.png","type":"image/png","lastModified":1687888717617.738,"size":28312},{"id":"681830f6c014a54f6d8cf3b4f0e45ae0201ebf288e2c71de5309341bf7f1511560d8f6aea03b9b7a93d42478c82d1e230d4aec064a8db3bbe4ec4da6ee2fcc1b","href":"https://static.observableusercontent.com/files/681830f6c014a54f6d8cf3b4f0e45ae0201ebf288e2c71de5309341bf7f1511560d8f6aea03b9b7a93d42478c82d1e230d4aec064a8db3bbe4ec4da6ee2fcc1b","name":"tableCellNameArea_v2.png","type":"image/png","lastModified":1687888717617.738,"size":28366},{"id":"c0d9d94135032b68ec31d7bb0c5c09cef0ade8d014f2dff507c621247c7102b7cd0f5e6e17fd80ec23f455013d0851b5e74e376cf5170152a109fcec6fa4af32","href":"https://static.observableusercontent.com/files/c0d9d94135032b68ec31d7bb0c5c09cef0ade8d014f2dff507c621247c7102b7cd0f5e6e17fd80ec23f455013d0851b5e74e376cf5170152a109fcec6fa4af32","name":"tableCellPopulated_v2.png","type":"image/png","lastModified":1687888717617.738,"size":243580},{"id":"79dbe77134c55e5a430cdb9f0448d1f6a6120910d3b0daeb50db53e3ceec1e3a9af4a22bed4456322190b609b3a491ad419aadfde3ab8e9611ab8f598daf686a","href":"https://static.observableusercontent.com/files/79dbe77134c55e5a430cdb9f0448d1f6a6120910d3b0daeb50db53e3ceec1e3a9af4a22bed4456322190b609b3a491ad419aadfde3ab8e9611ab8f598daf686a","name":"selectATableList_v3.png","type":"image/png","lastModified":1687888717617.738,"size":62796},{"id":"f66e73b2bdd166d0ba92a7d958ed8be927da8b630f4674c90d727afe432687069914247e8a6a967c6ab0b8bd2f041ff424794f059017006a4b26c76100e18a63","href":"https://static.observableusercontent.com/files/f66e73b2bdd166d0ba92a7d958ed8be927da8b630f4674c90d727afe432687069914247e8a6a967c6ab0b8bd2f041ff424794f059017006a4b26c76100e18a63","name":"selectDataSourceaapl.png","type":"image/png","lastModified":1687888717617.738,"size":35754},{"id":"aa5accc076296f786f0d387fc7111bf84ae59bbe56c035ccbcbcc03ff2889858db63d4a73776950701c7300301af0f60133d495e81d2e66a02ecc8889ffbc0ac","href":"https://static.observableusercontent.com/files/aa5accc076296f786f0d387fc7111bf84ae59bbe56c035ccbcbcc03ff2889858db63d4a73776950701c7300301af0f60133d495e81d2e66a02ecc8889ffbc0ac","name":"tableCellUnnamed_UI_v8.png","type":"image/png","lastModified":1687888717617.738,"size":30737},{"id":"b02cd0fb6b9bbc1127b362b115d50db8ad0c145c792d52910600684b77e856ff4c430b15be628275146a95c2be84ed5f6d7f24e99b7ea6a1516d217db4cbf1b0","href":"https://static.observableusercontent.com/files/b02cd0fb6b9bbc1127b362b115d50db8ad0c145c792d52910600684b77e856ff4c430b15be628275146a95c2be84ed5f6d7f24e99b7ea6a1516d217db4cbf1b0","name":"adelieGentoo.png","type":"image/png","lastModified":1687888717617.738,"size":40186},{"id":"bc42d808d751f405a2ec9293f3460376d06e226c67776dafcfa270ff9a4b184eada72d76aa975c8f485def7dbd3250b0c70485dd458f2ecdbf5c7ed01532d342","href":"https://static.observableusercontent.com/files/bc42d808d751f405a2ec9293f3460376d06e226c67776dafcfa270ff9a4b184eada72d76aa975c8f485def7dbd3250b0c70485dd458f2ecdbf5c7ed01532d342","name":"adelieGentooFilter.png","type":"image/png","lastModified":1687888717617.738,"size":49198},{"id":"dc42a88ecfc7c04200ede7f716ac3f53025c2766c6430f3423df65bbd955f7268848126a61245ef04d80aa0e6cfa7e06eb01d86e35aaadcccf70027adaaba415","href":"https://static.observableusercontent.com/files/dc42a88ecfc7c04200ede7f716ac3f53025c2766c6430f3423df65bbd955f7268848126a61245ef04d80aa0e6cfa7e06eb01d86e35aaadcccf70027adaaba415","name":"flipperLengthHistogramAll.png","type":"image/png","lastModified":1687888717617.738,"size":15102},{"id":"b90d3bca204fa3853deb8426c44fc6a3a5a1938e5017f1a12631412762b098a2b5c1f2d971eec7760d4010addd37ebb411085812e4eed6e7ea327b855538b239","href":"https://static.observableusercontent.com/files/b90d3bca204fa3853deb8426c44fc6a3a5a1938e5017f1a12631412762b098a2b5c1f2d971eec7760d4010addd37ebb411085812e4eed6e7ea327b855538b239","name":"flipperLengthHistogramOneBar.png","type":"image/png","lastModified":1687888717617.738,"size":16763},{"id":"354ed9b0c5b539c020c5d937a62b7b4d2242b0b4c7f65c85e3b6c5982b37c620a725eb42c4772fe16b82eceb8f98816740371193b4295fa65d7f60cbed0141a2","href":"https://static.observableusercontent.com/files/354ed9b0c5b539c020c5d937a62b7b4d2242b0b4c7f65c85e3b6c5982b37c620a725eb42c4772fe16b82eceb8f98816740371193b4295fa65d7f60cbed0141a2","name":"flipperLengthNaN.png","type":"image/png","lastModified":1687888717617.738,"size":19918},{"id":"140012f9cc3c47b3f9541c35c6262fa83aed7a9fe324fd7ca4890762ad63dd1ffcb37c50599966b5c3dc4443aba828ee66a9845a75d9919c9e6f456ba98063ce","href":"https://static.observableusercontent.com/files/140012f9cc3c47b3f9541c35c6262fa83aed7a9fe324fd7ca4890762ad63dd1ffcb37c50599966b5c3dc4443aba828ee66a9845a75d9919c9e6f456ba98063ce","name":"histogramSelectionRange.mov","type":"video/quicktime","lastModified":1687888717617.738,"size":432209},{"id":"0c775d70d9a2afc92bb906c4ad90a01e089c25f353eb32af1cea5e1080240fd50159f57efc678934c8299b3ad9528735a881bcaa433ed742482fc606d7b4d2fe","href":"https://static.observableusercontent.com/files/0c775d70d9a2afc92bb906c4ad90a01e089c25f353eb32af1cea5e1080240fd50159f57efc678934c8299b3ad9528735a881bcaa433ed742482fc606d7b4d2fe","name":"nullSign.png","type":"image/png","lastModified":1687888717617.738,"size":14925},{"id":"3a04e3c38a080ab1389c7cd5a77a60b56cbdfa7f44ef793b5129ea7876ea583220595b226747550ddd593468121ab1f2a7131f76dcdf6947c8fb9e14694c7a97","href":"https://static.observableusercontent.com/files/3a04e3c38a080ab1389c7cd5a77a60b56cbdfa7f44ef793b5129ea7876ea583220595b226747550ddd593468121ab1f2a7131f76dcdf6947c8fb9e14694c7a97","name":"penguinsRowInteractivity.png","type":"image/png","lastModified":1687888717617.738,"size":133672},{"id":"3cae30e0d5342a0fb428699baa8043e5feababc457834888f22af844cbf48156578e01b119db7b1ad310956141c5eb2beb0d76c40fd843035ae1e08586f9af1d","href":"https://static.observableusercontent.com/files/3cae30e0d5342a0fb428699baa8043e5feababc457834888f22af844cbf48156578e01b119db7b1ad310956141c5eb2beb0d76c40fd843035ae1e08586f9af1d","name":"summaryChartAdelieOnly.png","type":"image/png","lastModified":1687888717617.738,"size":70007},{"id":"7ca70a95ff48042a5c6f5628f9e6433d2d1690c33e81194952349f836c1cf1412138dd49abcdc867e77ff602fa4ae5bdb34a6d2d54d15ccb7daaaf22e5d2d586","href":"https://static.observableusercontent.com/files/7ca70a95ff48042a5c6f5628f9e6433d2d1690c33e81194952349f836c1cf1412138dd49abcdc867e77ff602fa4ae5bdb34a6d2d54d15ccb7daaaf22e5d2d586","name":"summaryChartHeadersPenguins.png","type":"image/png","lastModified":1687888717617.738,"size":73817},{"id":"38cc369899f398c6ae325c8f296510c9b99e7c2f8430f6c265bdf494622d7b0df6840f7750b96d9692a234d7a33cd58ec71ec2137a48a9a6cec30a7efde6bb77","href":"https://static.observableusercontent.com/files/38cc369899f398c6ae325c8f296510c9b99e7c2f8430f6c265bdf494622d7b0df6840f7750b96d9692a234d7a33cd58ec71ec2137a48a9a6cec30a7efde6bb77","name":"columnDerivationBadColumnName.png","type":"image/png","lastModified":1687888717617.738,"size":226628},{"id":"e437d1d3e3843877522f6794ff0bb0b95765bd7821cd32dd263a2945089d8cda3bd4a82d058cef1e5128244bded528f2618af8d5ef5631a5a28eecc7483e6861","href":"https://static.observableusercontent.com/files/e437d1d3e3843877522f6794ff0bb0b95765bd7821cd32dd263a2945089d8cda3bd4a82d058cef1e5128244bded528f2618af8d5ef5631a5a28eecc7483e6861","name":"columnDerivationRuntimeError1.png","type":"image/png","lastModified":1687888717617.738,"size":90012},{"id":"43536a8863579bb4523e253ca1973054a90dc4c8ca001068dfc6ed2d56a7a9bf36117a4c7e07dc78a739517b2180bc900e59a91039a6a9d9328856c0a6cb04dd","href":"https://static.observableusercontent.com/files/43536a8863579bb4523e253ca1973054a90dc4c8ca001068dfc6ed2d56a7a9bf36117a4c7e07dc78a739517b2180bc900e59a91039a6a9d9328856c0a6cb04dd","name":"columnDerivationRuntimeError2.png","type":"image/png","lastModified":1687888717617.738,"size":81336},{"id":"6880898af9c81d09aa54e99d04b086859f430befa472b503fac4aae3bd3c778021bbdd6ed5d6bbe9c8903bf1a656b7c28c8d6a7e54e2ecbdd85a4e35be9f3ace","href":"https://static.observableusercontent.com/files/6880898af9c81d09aa54e99d04b086859f430befa472b503fac4aae3bd3c778021bbdd6ed5d6bbe9c8903bf1a656b7c28c8d6a7e54e2ecbdd85a4e35be9f3ace","name":"tableCellCreateColumnButton.png","type":"image/png","lastModified":1687888717617.738,"size":200165},{"id":"a511c78d019707c4a28a4ef296b21bde987a222964e84211e633acde3dec0860edadebff89903a864641d748c4a276d2c742a5a4feccb1c6a8d1fc76cc62ec64","href":"https://static.observableusercontent.com/files/a511c78d019707c4a28a4ef296b21bde987a222964e84211e633acde3dec0860edadebff89903a864641d748c4a276d2c742a5a4feccb1c6a8d1fc76cc62ec64","name":"tableCellCreatedColumn.png","type":"image/png","lastModified":1687888717617.738,"size":197265},{"id":"ca4959a2c15edc2b02d1acccd42e5dc3dcd886c90ab39da8dedd67d76b0199637208eca1a219ccd6ab4ccaa321196d4ce00710774822ca836f16e9dd57e15965","href":"https://static.observableusercontent.com/files/ca4959a2c15edc2b02d1acccd42e5dc3dcd886c90ab39da8dedd67d76b0199637208eca1a219ccd6ab4ccaa321196d4ce00710774822ca836f16e9dd57e15965","name":"tableCellCreatedColumnEditor2@2.png","type":"image/png","lastModified":1687888717617.738,"size":204476},{"id":"688b8f8d393e788c0a43da758fda18fb8e317aef36c75c7d09ad7a58c16089578239b7ca8dcf60b4697ce23c31efd11219f2c90646e1f044e6c5decc42ef61b1","href":"https://static.observableusercontent.com/files/688b8f8d393e788c0a43da758fda18fb8e317aef36c75c7d09ad7a58c16089578239b7ca8dcf60b4697ce23c31efd11219f2c90646e1f044e6c5decc42ef61b1","name":"tableCellCreatedColumnEditorReopen@1.png","type":"image/png","lastModified":1687888717617.738,"size":210034},{"id":"fda33c4faec8b73051f1625ec3a57ffd7921ac5f6297935eb2d88cc8a327912dc28c864701432ecde7cd0b5ff4665c6e2520e05d4379a6d4b3507df6ff47f58f","href":"https://static.observableusercontent.com/files/fda33c4faec8b73051f1625ec3a57ffd7921ac5f6297935eb2d88cc8a327912dc28c864701432ecde7cd0b5ff4665c6e2520e05d4379a6d4b3507df6ff47f58f","name":"convertedSQLCell@2.png","type":"image/png","lastModified":1687888717617.738,"size":248021}] 29:{"id":"b3c82c9e596f19db","slug":null,"title":"Data table cell","thumbnail":"9b41f73158acfed5e897ccc4ca414e13716e636627b63efc649ffc01c465e038","access_level":"public","create_time":"$D2023-06-27T17:58:37.617Z","update_time":"$D2023-06-27T17:58:37.617Z","view_time":null,"first_public_time":"$D2023-06-27T17:58:37.617Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"25df1abe34779faa","login":"crystalalchemist","name":"Crystal Alchemist ","avatar_url":"https://avatars-next.observableusercontent.com/f41290ca5dd6916d8e426c7235d1eff256ab9043a340e272de6d9d2223af2931","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1306,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"c920f5c857fc6ff9","login":"crystalalchemist","name":"Crystal Alchemist ","avatar_url":"https://avatars-next.observableusercontent.com/f41290ca5dd6916d8e426c7235d1eff256ab9043a340e272de6d9d2223af2931","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"c920f5c857fc6ff9","login":"crystalalchemist","name":"Crystal Alchemist ","avatar_url":"https://avatars-next.observableusercontent.com/f41290ca5dd6916d8e426c7235d1eff256ab9043a340e272de6d9d2223af2931","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Data table cell","cells":[{"id":0,"value":"# Data table cell","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1072,"value":"example = await FileAttachment(\"chinook.db\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"example","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":103,"value":"## Creating a data table cell","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":124,"value":"

\n \n

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

\n \n

A new, unnamed data table cell.

\n \n

Click to select a data source.

\n \n

Example of an in-memory data source.

\n \n

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

\n \n

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

\n \n

Use Add database to set up database connections.

\n \n

Databases lists the connected databases.

\n \n

Click Select a table after you have chosen a database.

\n \n

Select a table from the menu.

\n \n

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

\n \n

Enter the name for the data table cell.

\n \n

Select Filter to define filtering conditions to apply.

\n \n

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

\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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":570,"value":"- Object values do not support operators.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":430,"value":"It is possible to define filter criteria that are contradictory; for example:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":443,"value":"`// This will return no results:`\n\n ID_number < 9\n ID_number > 100","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":299,"value":"The order in which you define the filtering criteria does not matter.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"### Showing and hiding columns","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"showHideSection","database":"$undefined"},{"id":309,"value":"Click **Columns** to display the list of table columns. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":187,"value":"

\n \n

Click Columns to see the list of table columns.

\n\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":598,"value":"The resulting list displays checkboxes indicating which columns are to be shown.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":481,"value":"

\n \n

Checkboxes indicate the columns to show.

\n \n

Click only to show only that column.

\n \n

Click Show all to restore all columns.

\n \n

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

\n \n

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

\n \n

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

\n \n

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

\n \n

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

\n \n

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

\n \n

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

\n \n

Select Sort to define the sorting criteria.

\n \n

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

\n \n

Choose either a Descending or an Ascending sort.

\n \n

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

\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 \n

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

\n \n

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

\n \n

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

\n \n

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

\n \n

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

\n \n

A histogram summary chart after the tallest bar is highlighted.

\n \n

The null sign represents invalid values.

\n \n

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

\n \n

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

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

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1247,"value":"

\n \n

Column result selections can be saved as a filter.

\n \n

Summary charts display text when appropriate.

\n \n

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

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":892,"value":"## Converting to SQL","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":896,"value":"

\n \n\n \n

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

\n \n

The SQL code in the converted cell.