27:null 28:["$","title",null,{"children":"Data Table Cell | Karthik Kaliyaperumal | Observable"}] 2d: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"] ]2e:[{"id":"c2398169828dc179c0124d0f8eccdce2fc50f602cb876b291186d6e7819b4df4df0ae7950acde12eac3b4ba24e8c693c24f1603e80dce44d2cd879413f28ceaf","href":"https://static.observableusercontent.com/files/c2398169828dc179c0124d0f8eccdce2fc50f602cb876b291186d6e7819b4df4df0ae7950acde12eac3b4ba24e8c693c24f1603e80dce44d2cd879413f28ceaf","name":"convertToSQL_modal_v2.png","type":"image/png","lastModified":1672916099671.929,"size":66829},{"id":"4f7e7b94a78a39196e3e3f08a5b94ecfa767da4031637ce4d83f997436089a619ceb44ac39daa3d4d7a9b6b8ac73cc9397117fe1fb4532e76fcc74da42520551","href":"https://static.observableusercontent.com/files/4f7e7b94a78a39196e3e3f08a5b94ecfa767da4031637ce4d83f997436089a619ceb44ac39daa3d4d7a9b6b8ac73cc9397117fe1fb4532e76fcc74da42520551","name":"tableCell_Sort_Up_or_Down.png","type":"image/png","lastModified":1672916099671.929,"size":28048},{"id":"7c63c97b556b2f013f246aa66964b8a205716d6c59d98da8174b47bc65caba546d5d3443b5f84083fbd0165443930abe9464c1c645c481b58bb65128d7a6943e","href":"https://static.observableusercontent.com/files/7c63c97b556b2f013f246aa66964b8a205716d6c59d98da8174b47bc65caba546d5d3443b5f84083fbd0165443930abe9464c1c645c481b58bb65128d7a6943e","name":"tableCell_SortCriteria_Column.png","type":"image/png","lastModified":1672916099671.929,"size":38248},{"id":"8727cf81f8e7b96f38f58f69a7da8e88432cd958ae82ed1f52b7c1aa685ed9fe4d9eaeacee7a9dfe5fa661dac17e6d8176995fdd22efbbb6f7d9eb398ef96da7","href":"https://static.observableusercontent.com/files/8727cf81f8e7b96f38f58f69a7da8e88432cd958ae82ed1f52b7c1aa685ed9fe4d9eaeacee7a9dfe5fa661dac17e6d8176995fdd22efbbb6f7d9eb398ef96da7","name":"tableCell_FilterCriteria_ThreeFields.png","type":"image/png","lastModified":1672916099671.929,"size":11856},{"id":"bd9b1a7369fb25cfdafaae0d0512cfd7a8e92c6dca8a20176d29c305af397ff784f86b93249fb0acc582ed5475c4b48f623116c1df4d85e4857ce22d41557bd6","href":"https://static.observableusercontent.com/files/bd9b1a7369fb25cfdafaae0d0512cfd7a8e92c6dca8a20176d29c305af397ff784f86b93249fb0acc582ed5475c4b48f623116c1df4d85e4857ce22d41557bd6","name":"tableCell_FilterCriteria_Column.png","type":"image/png","lastModified":1672916099671.929,"size":35017},{"id":"b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","href":"https://static.observableusercontent.com/files/b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","name":"chinook.db","type":"application/x-sqlite3","lastModified":1672916099671.929,"size":884736},{"id":"a30eb26b17cdc418ea891e6ca89f0070aa271cd899fe4d0b081eb2a9cc1da1be44a0049d5cf22cc86b511c2ac75a1177a8cc9990ce3485ec288eb6440b1106cf","href":"https://static.observableusercontent.com/files/a30eb26b17cdc418ea891e6ca89f0070aa271cd899fe4d0b081eb2a9cc1da1be44a0049d5cf22cc86b511c2ac75a1177a8cc9990ce3485ec288eb6440b1106cf","name":"closeCellArrow_v2.png","type":"image/png","lastModified":1672916099671.929,"size":36336},{"id":"53b0913245e173bf55a62d6ab9df82aed58bb4ed3d8e2ee9b3b3dd2b8c1ff6ce4a8d1018921022784e16122a3ff4dae77b320646fd900b0db7e8a70f7ddfa6a2","href":"https://static.observableusercontent.com/files/53b0913245e173bf55a62d6ab9df82aed58bb4ed3d8e2ee9b3b3dd2b8c1ff6ce4a8d1018921022784e16122a3ff4dae77b320646fd900b0db7e8a70f7ddfa6a2","name":"myTableSlice_v2.png","type":"image/png","lastModified":1672916099671.929,"size":28189},{"id":"dccd4ce79413e55e2563feeb3ddc5dd488a78f5fe840870c37fa25a28100eeb89d1ab20df7effdfa04737afcb8f101b9604dc2c0d094e117bda6ff3edce1b20f","href":"https://static.observableusercontent.com/files/dccd4ce79413e55e2563feeb3ddc5dd488a78f5fe840870c37fa25a28100eeb89d1ab20df7effdfa04737afcb8f101b9604dc2c0d094e117bda6ff3edce1b20f","name":"myTableSort_v2.png","type":"image/png","lastModified":1672916099671.929,"size":28273},{"id":"9a6ac655e536ce76eaabfe407a3441849908e4e32e37e7b145e17d5e02c91e7e3d22cec2aac17bd0f9cb253e66e64b5c562d5b85ad14d79e126f16fdb85213e2","href":"https://static.observableusercontent.com/files/9a6ac655e536ce76eaabfe407a3441849908e4e32e37e7b145e17d5e02c91e7e3d22cec2aac17bd0f9cb253e66e64b5c562d5b85ad14d79e126f16fdb85213e2","name":"tableCellHistogramAfter.png","type":"image/png","lastModified":1672916099671.929,"size":14198},{"id":"3c30c4685465dccada5f2c444afd6628b841c86ca9d94509c0eacf12814083db0b1b5d48833037741c7f6b04a2ebae1b02813ef3b2c7b2e5bb82815b3af04728","href":"https://static.observableusercontent.com/files/3c30c4685465dccada5f2c444afd6628b841c86ca9d94509c0eacf12814083db0b1b5d48833037741c7f6b04a2ebae1b02813ef3b2c7b2e5bb82815b3af04728","name":"tableCellHistogramBefore.png","type":"image/png","lastModified":1672916099671.929,"size":12172},{"id":"4f8b680a3f8902b3b233f8002c9b1b2eb2f66e9864617f54da8a9c0365438470c70b4f1692621df95790cbf5d6eceb2e10c72420c641511f7376a9d7e4926e09","href":"https://static.observableusercontent.com/files/4f8b680a3f8902b3b233f8002c9b1b2eb2f66e9864617f54da8a9c0365438470c70b4f1692621df95790cbf5d6eceb2e10c72420c641511f7376a9d7e4926e09","name":"summaryTableCanada.png","type":"image/png","lastModified":1672916099671.929,"size":45616},{"id":"4f7dc85aeace1b5b69c8a1f6fc5945a3f5679bc36bc3b56627b449d0a2588ebf922343776221d688fe61398e363e464657e3ebb6c1bab8f8164dc8266cfb421f","href":"https://static.observableusercontent.com/files/4f7dc85aeace1b5b69c8a1f6fc5945a3f5679bc36bc3b56627b449d0a2588ebf922343776221d688fe61398e363e464657e3ebb6c1bab8f8164dc8266cfb421f","name":"summaryTableHeadersOnly.png","type":"image/png","lastModified":1672916099671.929,"size":51594},{"id":"997a7c2206f98b7e2b753a5bf4b48f95be6503dcec1dd97b6f87b6333eefece3dab8a3ec267d3eee62e0f4bfd8a7a8bde00391df3a7ce38998374343acf0f5f5","href":"https://static.observableusercontent.com/files/997a7c2206f98b7e2b753a5bf4b48f95be6503dcec1dd97b6f87b6333eefece3dab8a3ec267d3eee62e0f4bfd8a7a8bde00391df3a7ce38998374343acf0f5f5","name":"selectATable_v4.png","type":"image/png","lastModified":1672916099671.929,"size":26966},{"id":"4d0144e607d4d253411ec549ed695f19a2d3fa0a4a30634099709d86d1b81c8c60c46e3e99f1907cee546b4ea8ee49baa3a4d35fc4c8d1d3a39e13cd9c801acc","href":"https://static.observableusercontent.com/files/4d0144e607d4d253411ec549ed695f19a2d3fa0a4a30634099709d86d1b81c8c60c46e3e99f1907cee546b4ea8ee49baa3a4d35fc4c8d1d3a39e13cd9c801acc","name":"addDatabaseButton_v2.png","type":"image/png","lastModified":1672916099671.929,"size":20901},{"id":"de7fe2b8f55d1f7981a778db7892ce6996566a66958f1517bbdfaeba3ed1571cc007c91e99ffd10a43543ae555a0e99096331b7b1fb333bbfc8f267e974595f3","href":"https://static.observableusercontent.com/files/de7fe2b8f55d1f7981a778db7892ce6996566a66958f1517bbdfaeba3ed1571cc007c91e99ffd10a43543ae555a0e99096331b7b1fb333bbfc8f267e974595f3","name":"connectedDatabases_v2.png","type":"image/png","lastModified":1672916099671.929,"size":66124},{"id":"21c795b11b08fe435727b647ce7cadb8e9155da63e03afe46cb53709ab818fc4cb9dc5989c09180a44231975c7180f0c490d475015aa961bf30fce5bbd8c4634","href":"https://static.observableusercontent.com/files/21c795b11b08fe435727b647ce7cadb8e9155da63e03afe46cb53709ab818fc4cb9dc5989c09180a44231975c7180f0c490d475015aa961bf30fce5bbd8c4634","name":"tableCellColumnsShowAll.png","type":"image/png","lastModified":1672916099671.929,"size":30039},{"id":"83d4078255140309d3469b079e6d6ed70a35460886cb7ea5f64619002c6eb9635bc2e7371b12072673f67283330b7f49fe3653b462e235be93f7aad30b277e20","href":"https://static.observableusercontent.com/files/83d4078255140309d3469b079e6d6ed70a35460886cb7ea5f64619002c6eb9635bc2e7371b12072673f67283330b7f49fe3653b462e235be93f7aad30b277e20","name":"tableCellColumnsOnly.png","type":"image/png","lastModified":1672916099671.929,"size":33317},{"id":"3584cff9a5a3e4adc7469495c893e58152691d0d734933d336af07c825a5cf9ebd514e6138d236d5449b58d6c5b28a7e291cd1125fe05895ba55e2b21d26c17a","href":"https://static.observableusercontent.com/files/3584cff9a5a3e4adc7469495c893e58152691d0d734933d336af07c825a5cf9ebd514e6138d236d5449b58d6c5b28a7e291cd1125fe05895ba55e2b21d26c17a","name":"tableCellColumnsMenu.png","type":"image/png","lastModified":1672916099671.929,"size":32384},{"id":"c15cff551607b243d234499be5ac9d16bdd680155a62a1a03f8d5b5023a24fbe839a245dbbb974d7b38a0025557ce3d53d542b0945a2cb1e2bcfaa7b946e4f1b","href":"https://static.observableusercontent.com/files/c15cff551607b243d234499be5ac9d16bdd680155a62a1a03f8d5b5023a24fbe839a245dbbb974d7b38a0025557ce3d53d542b0945a2cb1e2bcfaa7b946e4f1b","name":"bestPictureNomineesCell.png","type":"image/png","lastModified":1672916099671.929,"size":75877},{"id":"ac677eb3c9a318fc7809361585ff62289cd0fb03848ae418ee18326545b747b38693a2eefab61a5b179d24117fd89ebc819d971dd5f7600a6a0a8169a6b92261","href":"https://static.observableusercontent.com/files/ac677eb3c9a318fc7809361585ff62289cd0fb03848ae418ee18326545b747b38693a2eefab61a5b179d24117fd89ebc819d971dd5f7600a6a0a8169a6b92261","name":"selectADataSource_v3.png","type":"image/png","lastModified":1672916099671.929,"size":22744},{"id":"91021b38896a437c003ebad8bab035a36ac1c61864d72f87f3083d1b2661ffebb3595e1aacb64ec1f3337d55c746ac8ee6d4e0663bf766b4812c6d154518af87","href":"https://static.observableusercontent.com/files/91021b38896a437c003ebad8bab035a36ac1c61864d72f87f3083d1b2661ffebb3595e1aacb64ec1f3337d55c746ac8ee6d4e0663bf766b4812c6d154518af87","name":"dataTableMenu_v6.png","type":"image/png","lastModified":1672916099671.929,"size":45705},{"id":"640ea7a05148d5c506862e0d1c43a3c3de537a17650cdf700256ecb98a0d801a320f4e0f9c3a3997e7752aa5b1efc86569926f74a0826121c747bdce5530d2be","href":"https://static.observableusercontent.com/files/640ea7a05148d5c506862e0d1c43a3c3de537a17650cdf700256ecb98a0d801a320f4e0f9c3a3997e7752aa5b1efc86569926f74a0826121c747bdce5530d2be","name":"convertedSQLCell_v3.png","type":"image/png","lastModified":1672916099671.929,"size":229134},{"id":"43a0ec54bdc2a28d76d3253794d596dba600a0f56b268de2645cec676af01c84b3da156699b9a50efd12cb134f2578bc590629f330bb04db5454c38baf818ddb","href":"https://static.observableusercontent.com/files/43a0ec54bdc2a28d76d3253794d596dba600a0f56b268de2645cec676af01c84b3da156699b9a50efd12cb134f2578bc590629f330bb04db5454c38baf818ddb","name":"convertToSQL_v4.png","type":"image/png","lastModified":1672916099671.929,"size":28295},{"id":"cbe533ea65b2307677b09f5fad7920cddbb299c5a7fbfed71d8f30b006e7392649ec0bbd0c0e7c40a18190b0c038a57cb6be33b0074c9ceb383cf790232d9669","href":"https://static.observableusercontent.com/files/cbe533ea65b2307677b09f5fad7920cddbb299c5a7fbfed71d8f30b006e7392649ec0bbd0c0e7c40a18190b0c038a57cb6be33b0074c9ceb383cf790232d9669","name":"tableCellRowHover_v4.png","type":"image/png","lastModified":1672916099671.929,"size":233428},{"id":"9afb0358fc9ff8ca8c80e03b22f4afc04d6e9f2401791b5073eb1ce936f3a15482d5127887e68b9eb54a1935cbdadf957767b64862bd91b1afbcea9f8e8d50fb","href":"https://static.observableusercontent.com/files/9afb0358fc9ff8ca8c80e03b22f4afc04d6e9f2401791b5073eb1ce936f3a15482d5127887e68b9eb54a1935cbdadf957767b64862bd91b1afbcea9f8e8d50fb","name":"tableCell_ColSumm_Messages_v2.png","type":"image/png","lastModified":1672916099671.929,"size":21654},{"id":"5003ee74747a765a5f3520b15ad21cec1db356e30ec9da45328f84d7d0a352e50c70b4c2855b8d4d316681eebd1a36c41125413a580e05d002e0c88ed48b9b28","href":"https://static.observableusercontent.com/files/5003ee74747a765a5f3520b15ad21cec1db356e30ec9da45328f84d7d0a352e50c70b4c2855b8d4d316681eebd1a36c41125413a580e05d002e0c88ed48b9b28","name":"tableCell_ArrayExpanded_v3.png","type":"image/png","lastModified":1672916099671.929,"size":583971},{"id":"397b477384f9c882ead5cb0b2ef36b899b9a11adb9e803ccafbefefcf7677000bc473b3c71443ead29c02f33f5d39a632d2db93421fa47cb6a8380bd7f0aa84e","href":"https://static.observableusercontent.com/files/397b477384f9c882ead5cb0b2ef36b899b9a11adb9e803ccafbefefcf7677000bc473b3c71443ead29c02f33f5d39a632d2db93421fa47cb6a8380bd7f0aa84e","name":"tableCell_RefToTable_v3.png","type":"image/png","lastModified":1672916099671.929,"size":27533},{"id":"f9c9b7f074314281e99545bee68b4584a9e9d979d46a6e5d0cb24224b02402b06cddc57b69be538a20fb4f1ac99251018895dbfac3a1036dc0b22a7ca80f62db","href":"https://static.observableusercontent.com/files/f9c9b7f074314281e99545bee68b4584a9e9d979d46a6e5d0cb24224b02402b06cddc57b69be538a20fb4f1ac99251018895dbfac3a1036dc0b22a7ca80f62db","name":"sliceFromTo.png","type":"image/png","lastModified":1672916099671.929,"size":22165},{"id":"6f84b4bf3e762b1a579d698527997d192ce9443984a83693fba5891d2413d33bac8efad1b669db81b46af232ec0f5a8eec347dc39863bb537f884265521a6b60","href":"https://static.observableusercontent.com/files/6f84b4bf3e762b1a579d698527997d192ce9443984a83693fba5891d2413d33bac8efad1b669db81b46af232ec0f5a8eec347dc39863bb537f884265521a6b60","name":"myTableColumns_v2.png","type":"image/png","lastModified":1672916099671.929,"size":28330},{"id":"8c4794af76dbc88f6a65b69902599ca5f98a1355f44de0d897bfdc2971da8532a01c6c51c4a88632375b97d0a64da854a4f5b32690850e80ba5810449c5ac75b","href":"https://static.observableusercontent.com/files/8c4794af76dbc88f6a65b69902599ca5f98a1355f44de0d897bfdc2971da8532a01c6c51c4a88632375b97d0a64da854a4f5b32690850e80ba5810449c5ac75b","name":"myTableFilter_v2.png","type":"image/png","lastModified":1672916099671.929,"size":28312},{"id":"681830f6c014a54f6d8cf3b4f0e45ae0201ebf288e2c71de5309341bf7f1511560d8f6aea03b9b7a93d42478c82d1e230d4aec064a8db3bbe4ec4da6ee2fcc1b","href":"https://static.observableusercontent.com/files/681830f6c014a54f6d8cf3b4f0e45ae0201ebf288e2c71de5309341bf7f1511560d8f6aea03b9b7a93d42478c82d1e230d4aec064a8db3bbe4ec4da6ee2fcc1b","name":"tableCellNameArea_v2.png","type":"image/png","lastModified":1672916099671.929,"size":28366},{"id":"c0d9d94135032b68ec31d7bb0c5c09cef0ade8d014f2dff507c621247c7102b7cd0f5e6e17fd80ec23f455013d0851b5e74e376cf5170152a109fcec6fa4af32","href":"https://static.observableusercontent.com/files/c0d9d94135032b68ec31d7bb0c5c09cef0ade8d014f2dff507c621247c7102b7cd0f5e6e17fd80ec23f455013d0851b5e74e376cf5170152a109fcec6fa4af32","name":"tableCellPopulated_v2.png","type":"image/png","lastModified":1672916099671.929,"size":243580},{"id":"79dbe77134c55e5a430cdb9f0448d1f6a6120910d3b0daeb50db53e3ceec1e3a9af4a22bed4456322190b609b3a491ad419aadfde3ab8e9611ab8f598daf686a","href":"https://static.observableusercontent.com/files/79dbe77134c55e5a430cdb9f0448d1f6a6120910d3b0daeb50db53e3ceec1e3a9af4a22bed4456322190b609b3a491ad419aadfde3ab8e9611ab8f598daf686a","name":"selectATableList_v3.png","type":"image/png","lastModified":1672916099671.929,"size":62796},{"id":"f66e73b2bdd166d0ba92a7d958ed8be927da8b630f4674c90d727afe432687069914247e8a6a967c6ab0b8bd2f041ff424794f059017006a4b26c76100e18a63","href":"https://static.observableusercontent.com/files/f66e73b2bdd166d0ba92a7d958ed8be927da8b630f4674c90d727afe432687069914247e8a6a967c6ab0b8bd2f041ff424794f059017006a4b26c76100e18a63","name":"selectDataSourceaapl.png","type":"image/png","lastModified":1672916099671.929,"size":35754},{"id":"aa5accc076296f786f0d387fc7111bf84ae59bbe56c035ccbcbcc03ff2889858db63d4a73776950701c7300301af0f60133d495e81d2e66a02ecc8889ffbc0ac","href":"https://static.observableusercontent.com/files/aa5accc076296f786f0d387fc7111bf84ae59bbe56c035ccbcbcc03ff2889858db63d4a73776950701c7300301af0f60133d495e81d2e66a02ecc8889ffbc0ac","name":"tableCellUnnamed_UI_v8.png","type":"image/png","lastModified":1672916099671.929,"size":30737}] 2b:{"id":"eb5f0d0a0804e223","slug":null,"title":"Data Table Cell","thumbnail":"11dbe12c29dccd7ed09a1f50504857561440a14a04fa84830ac267d1c7fc4208","access_level":"public","create_time":"$D2023-01-05T10:54:59.671Z","update_time":"$D2023-01-31T03:38:49.260Z","view_time":null,"first_public_time":"$D2023-01-05T10:54:59.671Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"391116a991e5bc15","login":"karthik-kaliyaperumal","name":"Karthik Kaliyaperumal","avatar_url":"https://avatars-next.observableusercontent.com/ffb3669a2738d729621b94045292a46e2ea9f763c6056acde47fa246125062df","tier":"starter_2024"},"version":1230,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b2212584aae5f90d","login":"karthik-kaliyaperumal","name":"Karthik Kaliyaperumal","avatar_url":"https://avatars-next.observableusercontent.com/ffb3669a2738d729621b94045292a46e2ea9f763c6056acde47fa246125062df","tier":null}],"members":[{"type":"individual","id":"b2212584aae5f90d","login":"karthik-kaliyaperumal","name":"Karthik Kaliyaperumal","avatar_url":"https://avatars-next.observableusercontent.com/ffb3669a2738d729621b94045292a46e2ea9f763c6056acde47fa246125062df","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Data Table Cell","cells":[{"id":0,"value":"# Data Table Cell","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$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","output":"","database":"$undefined"},{"id":1072,"value":"await FileAttachment(\"chinook.db\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","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","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- 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","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","output":"","database":"$undefined"},{"id":103,"value":"## Creating a data table cell","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$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","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":127,"value":"The new data table cell appears:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":96,"value":"

\n \n

A new, unnamed data table cell.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1190,"value":"## Using an existing cell as a data source","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1188,"value":"$2d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1186,"value":"

\n \n

Click to select a data source.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1185,"value":"

\n \n

Example of an in-memory data source.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1184,"value":"Here is the resulting data table cell.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1183,"value":"bestPictureNominees","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1223,"value":"## Hiding (and restoring) the data editor toolbar","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1221,"value":"

\n \n

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

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1220,"value":"Click the arrow again to restore the data editor toolbar.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1181,"value":"## Preparing data sources from .csv, .tsv, or SQLite files","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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- 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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1178,"value":"

\n \n

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

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":55,"value":"## Selecting a data source from a connected database","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":224,"value":"

\n \n

Use Add database to set up database connections.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":181,"value":"

\n \n

Databases lists the connected databases.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":159,"value":"## Selecting a table","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":184,"value":"

\n \n

Click Select a table after you have chosen a database.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"

\n \n

Select a table from the menu.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":239,"value":"Once you have selected a database and table, the tabular data will populate the cell.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":161,"value":"tableNameSection = md `## Naming the data table cell`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":171,"value":"

\n \n

Enter the name for the data table cell.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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 and hiding specific **columns**\n - Applying **sort**ing\n - Limiting the display to only certain rows (creating a **slice**)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":15,"value":"filterSection = md `### Filtering`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"

\n \n

Select Filter to define filtering conditions to apply.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$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","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","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","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","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","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","output":"","database":"$undefined"},{"id":570,"value":"- Object values do not support operators.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$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","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","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","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","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","output":"","database":"$undefined"},{"id":16,"value":"showHideSection = md `### Showing / Hiding columns`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"Click **Columns** to display the list of table columns. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$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","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","output":"","database":"$undefined"},{"id":481,"value":"

\n \n

Checkboxes indicate the columns to show.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":611,"value":"

\n \n

Click only to show only that column.

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

\n \n

Click Show all to restore all columns.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"sortSection = md `### Sorting`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"

\n \n

Select Sort to define the sorting criteria.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":635,"value":"

\n \n

Choose either a Descending or an Ascending sort.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"sliceSection = md `### Slicing`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":34,"value":"tableRefSection = md `## Referring to a data table cell`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":831,"value":"

\n \n

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

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":835,"value":"The array can be expanded for viewing:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"summaryChartSection = md `## Summary charts`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":341,"value":"

\n \n

Each small chart provides a summary of that column's data.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":681,"value":"

\n \n

Highlighting an individual value in a Summary Chart causes the accompanying text to reflect that value's data.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":762,"value":"By hovering over the dark bar in the highlighted chart above, we now see additional information:\n- The bar represents 141 rows of the total, or 14%.\n- The country selected is CA (Canada).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":772,"value":"Here is another example, this time a histogram. Before hovering over an individual vertical bar:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":777,"value":"

\n \n

A histogram Summary Chart before any individual vertical bar is highlighted.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":780,"value":"Here is the same histogram, after the pointer is hovered over the tallest vertical bar:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":783,"value":"

\n \n

A histogram Summary Chart after the tallest bar is highlighted.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":790,"value":"We now see additional information:\n- The bar represents 282 rows of the total, or 36%.\n- The values in that column range from 10 to 20.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":733,"value":"

\n \n

Summary Charts display text when appropriate.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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 row with \"Google Chicago Campus Bottle\". This results in the vertical bar for \"Campus Collection\" to be highlighted. In the **id** column, the value of the id (4) is also highlighted. (Values in the other columns are also highlighted.)\n\n

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

\n \n

Click SQL to convert the data table cell to a SQL cell.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":907,"value":"Before the conversion is completed, you are asked to confirm. Note that you can revert the operation using the History panel.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":901,"value":"

\n \n

A modal allows you to confirm the conversion.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":909,"value":"Click **Convert** to complete the conversion. The converted SQL cell appears.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":911,"value":"

\n \n

The SQL code in the converted cell.

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1095,"value":"## SQL mystery game / data table cell tutorial","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":133,"value":"---\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":402,"value":"note = {\n const scope = DOM.uid(\"note\").id;\n const style = document.head.appendChild(htl.html`