Computer Science / Healthcare Informatics

Data mining of Clinical Databases - CDSS 1

Brought by: Coursera

Overview

This course will introduce MIMIC-III, which is the largest publicly Electronic Health Record (EHR) database available to benchmark machine learning algorithms. In particular, you will learn about the design of this relational database, what tools are available to query, extract and visualise descriptive analytics.

The schema and International Classification of Diseases coding is important to understand how to map research questions to data and how to extract key clinical outcomes in order to develop clinically useful machine learning algorithms.

Syllabus

  • Electronic Health Records and Public Databases
    • This module will introduce MIMIC-III, which is the largest publicly Electronic Health Record (EHR) database available to benchmark machine learning algorithms. In particular, you will learn about the design of this relational database, what tools are available to query, extract and visualise descriptive analytics.
      The schema and International Classification of Diseases coding is important to understand how to map research questions to data and how to extract key clinical outcomes in order to develop clinically useful machine learning algorithms.
  • MIMIC III as a relational database
    • This week includes a discussion of the basic structure of MIMIC III database and practical exercises on how to extract and visualise summary statistics. We will understand the difficulty in defining clinical outcomes and we are going to examine clinical variables related to a specific patient.
  • International Classification of Disease System
    • This week discusses the history of the International Classification of Diseases (ICD) system, which has been developed collaboratively so that the medical terms and information in death certificates can be grouped together for statistical purposes. Practical examples shows how to extract ICD-9 codes from MIMIC III database and visualise them. Furthermore, we discuss differences between ICD-9, ICD-10 and ICD-11 systems.
  • Concepts in MIMIC-III and an example of patients inclusion flowchart
    • This week includes an overview of clinical concepts, which are statistical tools to provide illness scores. They are developed based on expert opinion and subsequently extended based on data-driven methods. These models are the precursor of machine learning models for precision medicine. Finally, the practical exercises of this week provides the opportunity to implement a complex flowchart of patients inclusion.

Taught by

Fani Deligianni

Computer Science / Healthcare Informatics
Data mining of Clinical Databases - CDSS 1
Go to course

Data mining of Clinical Databases - CDSS 1

Brought by: Coursera

  • Coursera
  • Free
  • English
  • Certificate Available
  • Available at any time
  • intermediate
  • English, Kazakh, German, Hindi, Russian, Swedish, Korean, Portuguese, Greek, Italian, French, Chinese, Spanish, Arabic, Thai, Ukrainian, Japanese, Indonesian, Polish, Dutch, Turkish
MessagesTimelineExceptionsViews14RouteQueries7Models6GateSessionRequest
8.1.2PHP Version301msRequest Duration2MBMemory UsageGET en/courses/{slug}Route
    • Booting (191ms)
    • Application (108ms)
    • 1 x Booting (63.7%)
      191.49ms
      1 x Application (36.06%)
      108.40ms
      14 templates were rendered
      • public.courses.show (resources/views/public/courses/show.blade.php)3bladefile
        Params
        0
        course
        1
        links
        2
        config
      • public.courses.partials.breadcrumbs (resources/views/public/courses/partials/breadcrumbs.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.courses.partials.heading (resources/views/public/courses/partials/heading.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        classes
      • public.courses.partials.details (resources/views/public/courses/partials/details.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.courses.partials.breadcrumbs (resources/views/public/courses/partials/breadcrumbs.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.courses.partials.heading (resources/views/public/courses/partials/heading.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        classes
      • public.layouts.main (resources/views/public/layouts/main.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.layouts.partials.meta (resources/views/public/layouts/partials/meta.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.layouts.partials.navbar (resources/views/public/layouts/partials/navbar.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.auth.profile.partials.links (resources/views/public/auth/profile/partials/links.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        route
        7
        title
      • public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        route
        7
        title
      • public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        route
        7
        title
      • public.layouts.partials.flash-session (resources/views/public/layouts/partials/flash-session.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      uri
      GET en/courses/{slug}
      middleware
      web, localize:en
      controller
      App\Http\Controllers\CourseController@show
      as
      en.courses.show
      namespace
      prefix
      /en
      where
      file
      app/Http/Controllers/CourseController.php:17-35
      7 statements were executed4.43ms
      corspedia
      • select * from `courses` where `slug_en` = 'data-mining-of-clinical-databases---cdss-1' limit 1
        2.47ms/app/Http/Controllers/CourseController.php:20corspedia
        Metadata
        Bindings
        • 0. data-mining-of-clinical-databases---cdss-1
        Backtrace
        • 17. /app/Http/Controllers/CourseController.php:20
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • update `courses` set `visitors` = `visitors` + 1, `courses`.`updated_at` = '2025-03-08 07:12:58' where `id` = 317
        500μs/app/Http/Controllers/CourseController.php:21corspedia
        Metadata
        Bindings
        • 0. 2025-03-08 07:12:58
        • 1. 317
        Backtrace
        • 17. /app/Http/Controllers/CourseController.php:21
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id`, `name_en`, `name_ar`, `topic_id`, `slug_en`, `slug_ar` from `subjects` where `subjects`.`id` in (9)
        390μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CourseController.php:23
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id`, `name_en`, `name_ar`, `slug_en`, `slug_ar` from `topics` where `topics`.`id` in (1)
        250μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 25. /app/Http/Controllers/CourseController.php:23
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `institutions` where `institutions`.`id` in (56) and `institutions`.`deleted_at` is null
        310μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CourseController.php:23
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `providers` where `providers`.`id` in (2) and `providers`.`deleted_at` is null
        260μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CourseController.php:23
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `html_files` where `html_files`.`id` = 311 limit 1
        250μs/app/Models/Course.php:84corspedia
        Metadata
        Bindings
        • 0. 311
        Backtrace
        • 21. /app/Models/Course.php:84
        • 28. view::public.courses.show:29
        • 30. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 31. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 32. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      App\Models\HtmlFile
      1
      App\Models\Provider
      1
      App\Models\Institution
      1
      App\Models\Topic
      1
      App\Models\Subject
      1
      App\Models\Course
      1
        _token
        v4od01yFZCdrAlYYud5e0AmPxYO4JnCm9k3edIOR
        locale
        en
        _previous
        array:1 [ "url" => "https://www.corspedia.com/en/courses/data-mining-of-clinical-databases---cdss-...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/courses/data-mining-of-clinical-databases---cdss-1
        status_code
        200
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        request_request
        []
        request_headers
          0 of 0   
        array:24 [▼
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.144.119.207"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.144.119.207"
  ]
  "cf-ray" => array:1 [▶
    0 => "91d086f8c89a811f-ORD"
  ]
  "host" => array:1 [▶
    0 => "www.corspedia.com"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]
        request_server
          0 of 0   
        array:50 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_CF_CONNECTING_IP" => "3.144.119.207"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_X_FORWARDED_FOR" => "3.144.119.207"
  "HTTP_CF_RAY" => "91d086f8c89a811f-ORD"
  "HTTP_HOST" => "www.corspedia.com"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "corspedia.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "141.95.147.152"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "40176"
  "REMOTE_ADDR" => "172.70.131.140"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/var/www/corspedia/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/en/courses/data-mining-of-clinical-databases---cdss-1"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/corspedia/public/index.php"
  "PATH_INFO" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1741417977.995
  "REQUEST_TIME" => 1741417977
]
        request_cookies
        []
        response_headers
          0 of 0   
        array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 08 Mar 2025 07:12:58 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBSbWg3aUdnRkhkOTFmZCtiRkkxWVE9PSIsInZhbHVlIjoieitmdTBITUFRNHVyS28vM3pPWjNtSHlZZGZmaytBWkpPamErT3pLOUFUOFRnZllZaFF3cXcweUFwclkwc2NOK0JrdnJpcStwTzIwZkU1bFY5S2tBajBKRGlDUUVza1F4bWlCTHl3TWtPS3FXcW9VSWU2V3J5WFNpakN0amxseEciLCJtYWMiOiJkZGVjNThhNzU1ZjhmNDZmOTlmZGRiZTY5ZGNhNjE4YmE5ZWRjZGIxOWJhMzgxNTllNjMyNmIyYTc2ODllNGUxIiwidGFnIjoiIn0%3D; expires=Sat, 08 Mar 2025 09:12:58 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InBSbWg3aUdnRkhkOTFmZCtiRkkxWVE9PSIsInZhbHVlIjoieitmdTBITUFRNHVyS28vM3pPWjNtSHlZZGZmaytBWkpPamErT3pLOUFUOFRnZllZaFF3cXcweUFwclkwc2NOK0JrdnJpc ▶"
    1 => "laravel_session=eyJpdiI6IjZraERwYmxmTTlWMVdkZUZ2NTVWSHc9PSIsInZhbHVlIjoib1k3cUdwd1pTaTFQY2NDdmlrMytyV0FDVTdiMVcrSks2RzJWWVEvdG5CSzZKdU5ORWlsdXFuYWdnVlVPZzAydW14aEhKd25PR3phZlM4MFVObmk4ekRwRnQ4WXdZY051WEpYOWpEc1paZWpTaXZkQXA4cjZBNkhsRUJOWEx1VmEiLCJtYWMiOiIxYzNiYzFhMTYxNDkwNmMwNDZiMWJlYTc0ZTI2NWU1YjgyYTYxYWRhNTRkZmE4YTY2YmViNDU0YzQ1ZjY0ZWIzIiwidGFnIjoiIn0%3D; expires=Sat, 08 Mar 2025 09:12:58 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjZraERwYmxmTTlWMVdkZUZ2NTVWSHc9PSIsInZhbHVlIjoib1k3cUdwd1pTaTFQY2NDdmlrMytyV0FDVTdiMVcrSks2RzJWWVEvdG5CSzZKdU5ORWlsdXFuYWdnVlVPZzAydW14 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBSbWg3aUdnRkhkOTFmZCtiRkkxWVE9PSIsInZhbHVlIjoieitmdTBITUFRNHVyS28vM3pPWjNtSHlZZGZmaytBWkpPamErT3pLOUFUOFRnZllZaFF3cXcweUFwclkwc2NOK0JrdnJpcStwTzIwZkU1bFY5S2tBajBKRGlDUUVza1F4bWlCTHl3TWtPS3FXcW9VSWU2V3J5WFNpakN0amxseEciLCJtYWMiOiJkZGVjNThhNzU1ZjhmNDZmOTlmZGRiZTY5ZGNhNjE4YmE5ZWRjZGIxOWJhMzgxNTllNjMyNmIyYTc2ODllNGUxIiwidGFnIjoiIn0%3D; expires=Sat, 08-Mar-2025 09:12:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InBSbWg3aUdnRkhkOTFmZCtiRkkxWVE9PSIsInZhbHVlIjoieitmdTBITUFRNHVyS28vM3pPWjNtSHlZZGZmaytBWkpPamErT3pLOUFUOFRnZllZaFF3cXcweUFwclkwc2NOK0JrdnJpc ▶"
    1 => "laravel_session=eyJpdiI6IjZraERwYmxmTTlWMVdkZUZ2NTVWSHc9PSIsInZhbHVlIjoib1k3cUdwd1pTaTFQY2NDdmlrMytyV0FDVTdiMVcrSks2RzJWWVEvdG5CSzZKdU5ORWlsdXFuYWdnVlVPZzAydW14aEhKd25PR3phZlM4MFVObmk4ekRwRnQ4WXdZY051WEpYOWpEc1paZWpTaXZkQXA4cjZBNkhsRUJOWEx1VmEiLCJtYWMiOiIxYzNiYzFhMTYxNDkwNmMwNDZiMWJlYTc0ZTI2NWU1YjgyYTYxYWRhNTRkZmE4YTY2YmViNDU0YzQ1ZjY0ZWIzIiwidGFnIjoiIn0%3D; expires=Sat, 08-Mar-2025 09:12:58 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjZraERwYmxmTTlWMVdkZUZ2NTVWSHc9PSIsInZhbHVlIjoib1k3cUdwd1pTaTFQY2NDdmlrMytyV0FDVTdiMVcrSks2RzJWWVEvdG5CSzZKdU5ORWlsdXFuYWdnVlVPZzAydW14 ▶"
  ]
]
        session_attributes
          0 of 0   
        array:5 [▼
  "_token" => "v4od01yFZCdrAlYYud5e0AmPxYO4JnCm9k3edIOR"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://www.corspedia.com/en/courses/data-mining-of-clinical-databases---cdss-1"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]