{"id":255,"date":"2015-07-09T13:10:13","date_gmt":"2015-07-09T13:10:13","guid":{"rendered":"https:\/\/www.science.smith.edu\/wai-database\/?page_id=255"},"modified":"2025-09-26T16:35:16","modified_gmt":"2025-09-26T16:35:16","slug":"download-data","status":"publish","type":"page","link":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/","title":{"rendered":"Download data"},"content":{"rendered":"

What is available?<\/strong><\/h2>\n

Studies currently in the database are listed here — <\/a>click on PI Information at the top — there will be a delay while the site loads. You can choose which studies and subjects you want to download or you can download the entire database.<\/p>\n

Structure of Database<\/strong><\/h2>\n

The database is formatted in MySQL and includes three tables (PI_Info, Subjects, Measurements) that are described below:<\/p>\n

\"\"<\/a><\/p>\n

To use the data, you will need to download the three tables from the MySQL database to your computer. Below are directions for three different methods you can choose from to download the tables;  you only need to use one of these methods.  Once the tables are on your computer, you can analyze the data in any software you choose.  Example analysis scripts for Matlab are available under Graph Data<\/a>.<\/p>\n

Download most up to date data with MySQL Workbench (Directly from database)<\/strong><\/h2>\n

MySQL workbench can be downloaded for free and used as the link between the database and your computer. Directions for installing MySQL workbench are here: http:\/\/dev.mysql.com\/downloads\/workbench\/<\/a><\/p>\n

Once MySQL workbench is installed, establish a connection to the WAI database by following these instructions<\/a>.<\/p>\n

Select the data in the database and download it to your computer following these instructions<\/a>.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

What is available? Studies currently in the database are listed here — click on PI Information at the top — there will be a delay while the site loads. You … Continue reading “Download data”<\/span><\/a><\/p>\n","protected":false},"author":77,"featured_media":0,"parent":133,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ngg_post_thumbnail":0,"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"class_list":["post-255","page","type-page","status-publish","hentry"],"yoast_head":"\nDownload data - WAI-DATABASE<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Download data - WAI-DATABASE\" \/>\n<meta property=\"og:description\" content=\"What is available? Studies currently in the database are listed here — click on PI Information at the top — there will be a delay while the site loads. You … Continue reading "Download data"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/\" \/>\n<meta property=\"og:site_name\" content=\"WAI-DATABASE\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-26T16:35:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.science.smith.edu\/wai-database\/wp-content\/uploads\/sites\/28\/2024\/06\/DataBaseTables4Poster-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2228\" \/>\n\t<meta property=\"og:image:height\" content=\"2560\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/\",\"url\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/\",\"name\":\"Download data - WAI-DATABASE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/wp-content\\\/uploads\\\/sites\\\/28\\\/2024\\\/06\\\/DataBaseTables4Poster-891x1024.jpg\",\"datePublished\":\"2015-07-09T13:10:13+00:00\",\"dateModified\":\"2025-09-26T16:35:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/wp-content\\\/uploads\\\/sites\\\/28\\\/2024\\\/06\\\/DataBaseTables4Poster-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/wp-content\\\/uploads\\\/sites\\\/28\\\/2024\\\/06\\\/DataBaseTables4Poster-scaled.jpg\",\"width\":2228,\"height\":2560},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/home\\\/download-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Download data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/#website\",\"url\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/\",\"name\":\"WAI-DATABASE\",\"description\":\"Wideband Acoustic Immittance Database\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.science.smith.edu\\\/wai-database\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Download data - WAI-DATABASE","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/","og_locale":"en_US","og_type":"article","og_title":"Download data - WAI-DATABASE","og_description":"What is available? Studies currently in the database are listed here — click on PI Information at the top — there will be a delay while the site loads. You … Continue reading \"Download data\"","og_url":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/","og_site_name":"WAI-DATABASE","article_modified_time":"2025-09-26T16:35:16+00:00","og_image":[{"width":2228,"height":2560,"url":"https:\/\/www.science.smith.edu\/wai-database\/wp-content\/uploads\/sites\/28\/2024\/06\/DataBaseTables4Poster-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/","url":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/","name":"Download data - WAI-DATABASE","isPartOf":{"@id":"https:\/\/www.science.smith.edu\/wai-database\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/#primaryimage"},"image":{"@id":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.science.smith.edu\/wai-database\/wp-content\/uploads\/sites\/28\/2024\/06\/DataBaseTables4Poster-891x1024.jpg","datePublished":"2015-07-09T13:10:13+00:00","dateModified":"2025-09-26T16:35:16+00:00","breadcrumb":{"@id":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/#primaryimage","url":"https:\/\/www.science.smith.edu\/wai-database\/wp-content\/uploads\/sites\/28\/2024\/06\/DataBaseTables4Poster-scaled.jpg","contentUrl":"https:\/\/www.science.smith.edu\/wai-database\/wp-content\/uploads\/sites\/28\/2024\/06\/DataBaseTables4Poster-scaled.jpg","width":2228,"height":2560},{"@type":"BreadcrumbList","@id":"https:\/\/www.science.smith.edu\/wai-database\/home\/download-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.science.smith.edu\/wai-database\/"},{"@type":"ListItem","position":2,"name":"Download data"}]},{"@type":"WebSite","@id":"https:\/\/www.science.smith.edu\/wai-database\/#website","url":"https:\/\/www.science.smith.edu\/wai-database\/","name":"WAI-DATABASE","description":"Wideband Acoustic Immittance Database","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.science.smith.edu\/wai-database\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/pages\/255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/comments?post=255"}],"version-history":[{"count":62,"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/pages\/255\/revisions"}],"predecessor-version":[{"id":946,"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/pages\/255\/revisions\/946"}],"up":[{"embeddable":true,"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/pages\/133"}],"wp:attachment":[{"href":"https:\/\/www.science.smith.edu\/wai-database\/wp-json\/wp\/v2\/media?parent=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}