Webinar: Need Health Data? Discover the New NCHS Data Query System (9/17/2024)

CDC
258 followers
1 Video View·Dec 7, 2024
This webinar introduced the National Center for Health Statistics (NCHS) Data Query System (DQS).
Presenters demonstrated how to learn more about a health topic or a specific group—by customizing searches based on: demographic categories, like age and marital status; geographic categories, like region and metro area size; and socioeconomic categories, like employment status and poverty level.
The webinar also included a demonstration of how to create visualizations of specific health information in DQS.
0:00 Intro
1:20 Presentation
25:50 Q&A
This video can also be viewed at
https://www.cdc.gov/nchs/video/dqs/24-355616-Post-Production-Webinar-Services-DQS-DAE-Final-lowres.wmv
welcome and thank you for standing by at
this time all participants are in a
listen only mode today's call is being
recorded if you have any objections you
may disconnect at this time a link to
live Clos captioning Services is
available in the zoom chat
window my name is Megan Walters and I am
a health policy Analyst at the national
Center for Health statistics I'm pleased
to introduce today's webinar on the nchs
data query system or dqs a new tool that
makes Health Data more discoverable
usable and
customizable this webinar will
demonstrate how to customize searches
and data visualizations based on
demographic Geographic and so
socioeconomic categories to learn more
about a specific Health topic or
population group The presid presentation
and live demonstration will be followed
by a question and answer
session as a reminder the audience is in
a listen only mode questions or comments
may be entered through the zoom Q&A
feature at the bottom of your screen and
we will address them as time permits
during the Q&A session at the end now
I'd like to turn things over to Irma
Aris the director of n chs's division of
analysis and epidemiology to get us
started
Irma thank you Megan
good afternoon my name is imaris and I'm
the director of the anal of the division
of analysis and epidemiology at the
national Center for Health statistics I
identify as Latina my pronouns are she
her I have gray hair I'm wearing a blue
shirt and glasses I'm joined today by
Lorraine Escobedo Zakia Nelson and Amber
Wilson and we're thrilled to introduce
you to n chs's new data dissemination
and query tool the nchs data query
system or as we call it the dqf next
slide
please before we begin I'd like to give
you a little background on nchs and on
the origin of the dqs nchs is the
nation's principal statistical Agency
for health and we're also part of the
Centers for Disease Control and
prevention statistical agencies are
those agencies and organizational units
whose primary mission is about
collecting compiling processing and
anzing information for statistical
purposes our mission is to provide
timely relevant statistical information
to inform and guide actions and policies
to improve the health of the American
people the nchs data query system that
you'll hear about today is part of our
mission and in particular part of our
strategic plan goal to accelerate Health
Data capabilities by modernizing our
core data systems as well as our
approaches for disseminating data next
Slide the nchs data query system is also
part of cdc's moving forward initiative
moving forward is cdc's agency-wide
commitment to enhance our agency's
structure processes and systems to
protect the health Safety and Security
of all Americans and the dqs addresses
several key moving forward goals
including sharing scientific findings
and data faster translating science into
practical easy to understand policy
prioritizing public health communication
integrating Health Equity and
modernizing data next
slide as with cdc's moving forward
initiative the nchd nchs dqs is aimed at
addressing the need for Rapid access to
high quality information for the
American people so it's designed to
provide clear communication to the
audiences that you see here including
Academia our federal statistical
agencies and other Federal agencies the
general public and the Public Health
Community next
slide to achieve the gr the goals of
improving access and translating data
into information the dqs brings together
data from across nchs and other external
sources now the four sources you see on
the left side of this screen are n chs's
core data systems the national Vital
Statistics system is the oldest and most
successful example of intergovernmental
data sharing between public health and
the states it provides the nation's
official
statistics the National Health Care
surveys are a family of provider-based
surveys that look at the use of Health
Care Services the quality of health care
including um patient safety disparities
in health care services provided to
population groups in the US the national
health and nutrition examination survey
is a program of health studies that
combines interviews and physical
examinations to provide information on
the prevalence of diseases and risk
factors information from enhs is used to
assess nutritional status and its
association with health promotion and
Nan's findings are also the basis for
national standards for measurements such
as height weight and blood
pressure next is the National Health
interview survey now that's a survey a
household information survey survey
conducted since 1956 and it provides
information on a broad range of topics
nhis data are used to track health
status Health Care access and progress
toward National goals and the final
source is an nchs initiative known as
health United States Health us uses data
from these MCHS sources and other
sources to provide information on health
status and determinants Health Resources
utilization and expenditures
next slide
please so as you can see from the
previous slide nchs has many data
sources that provide different types of
health information and this can
sometimes make it hard for data users to
find the information that they're
looking for the nchs data query system
is Enterprise focused and by that we
mean that it centralizes Access to
Health Data from nchs and those other
sources next slide
I'm going to close my portion of the
presentation with a brief summary of
some of the strengths of the dqs I'll
just mention these now and you'll be
seeing them in real time with L's
demonstration the dqs offers estimates
of thousands of Health estimates from
over 120 Health topics from multiple
data
systems um the the dqs provides pre-
tabulated summary estimates not Micro
Data that now that means you don't have
to go get the data file and analy and
analyze the data yourself the estimates
are already compiled for you the dqs
provides diverse socio demographic and
intersectional data so that you can sort
data on a variety of
subgroups the titles sources and
methodological data about these
estimates change dynamically when you
make your selections so that means that
you not only see the data that you're
looking for but you can see the
attributes and characteristics of the
data and finally its flexible and
responsive design can means that it can
be continually adapted based on user
interests and
selections so that concludes my portion
of the presentation and now I I'm
pleased to turn it to Lorraine Esco who
will give us a live demonstration thank
you thank you so much yma good afternoon
everyone my name is Lorraine Escobedo my
pronouns are she her and I'm a health
statistician for the health United
States and NHS data quer system in the
division of analysis and epidemiology in
the population Health reporting and
dissemination Branch here at the
national Center for Health statistics I
have brown skin with a midlength um
black and gray hair and I'm wearing a
lilac colored uh long sleeve
shirt now let me share my
browser now let's look at the main
features of the dqs that can help you
customize your searches and data
visualization and Megan will share the
link to the dqs in in the
chat first step is to select a topic and
we can uh we can choose a help topic by
scrolling down on the topics or by
searching it here on the search topic
list or um you can go to the dqs health
topics page also and uh we'll talk more
about the health topics page in um later
on another way to select a topic is to
use the advanced topic
selection so once you click on that a
pop-up window will open that will allow
you to select a filter category either
by um population characteristic or by um
sources um as Irma mentioned earlier dqs
provides users access to health
statistics from different um um nchs
data sources and systems and it is
designed in a way that all users would
need to know is the topic of
Interest however if a user is interested
in looking for health statistics from a
particular population group or
characteristic or they're interested in
topics coming from a specific nchs data
source this is where uh they can apply
filters and find those topics for
example if I'm looking for um uh topics
specific to um children and Adolescence
I I can click that um filter here and
immediately um I see that there are 81
selections available in the topic drop
down or if I want to um uh stratified by
poverty level I can click the check box
next to poverty level and now I see that
there are 80 selections
available I can also go to sources to
filter my data source and the list here
includes NHS Data Systems and sources
that are currently in the dqs but it it
can accommodate much more we also have
external data sources um not listed here
such as the American Dental Association
and the American Medical American
Hospital
Association and once you have major
selection you can um click apply and
that will close the advanced topic
selection
window and to clear your filters you can
or to start a new search you can just um
click on the clear selections here
located below the selectors on the right
right
side so once I've chosen a topic I can
now select a group by default the first
group um that is shown is the
total in under groups I can customize my
charts and break down estimates by
demographic uh Geographic and
socioeconomic
characteristics uh for this example
let's look at employment
status the title as um you may have
noticed atomically change when I change
the group the details in the footnotes
and let me scroll down here so you can
see would also change based on these
selections next are the subgroups for
this group there are six subgroups but I
can select and unselect um each subgroup
if I
want right now you can select a maximum
of seven subgroups at a time on the
charts and and that was a 508 compliance
um issue to avoid having um a very busy
looking
visualization we receive feedback that
seven might not be enough especially
when comparing multiple um
intersectional characteristics like sex
and raisin Hispanic origin so in
response uh we are working on increasing
that limit from 7 to 11 which is planned
for the next
release next I can choose the time
period I can keep it as is and show all
the time periods on a line chart like
this or I can um check view single
period and choose the period I want to
show on a bar
chart so now I can make observations
regarding this topic and this grouping
and let me emphasize that all data in
the dqs have pre- tabulated summary
estimates I can hover on the chart um to
see the popups um with a year the
estimate and when available the
confidence intervals around the
estimates and these pop-ups are
available throughout the data
visualization in the charts and on the
maps um and we'll look at a a map
example um in a little bit in a little
bit so this topic provides um confidence
intervals and if I want a reminder of
what confidence interval is I can just
um hover my mouse on the words underline
confidence interval and um here I will
see a
description I can even customize my
chart and add those confidence intervals
by turning on this this show confidence
in our
goal if I want to include an image of
this chart in a presentation or a report
I can easily download a PNG file by
clicking on um this download image
button on uh below the data
visualization on the right side and this
image would also have the customized
titles and
Legend so that's the chart View and if I
want to see this table this data in a
table format I will just um click on the
table
tab here I'm able to add all the
subgroups not just the five I selected
so it will include all the six
subgroups and I'm also able to download
the data uh the table specific to my
selections by clicking clicking on the
download data button um located Below on
the right side of the
table below the table and the chart are
the footnotes that would have extensive
information tailored to my select c
s these footnotes contain information
about the reliability of the estimates
the source of the data the description
of the topic how groups and subgroups
are defined and
methodology you may notice that uh dqs
really aims to be a system that is
responsive to users of different levels
of expertise and different interests so
earlier I showed you how to get a simple
description of confidence intervals
while here in the footnotes we have
links to the data sources document ation
for users who may want to read the
detailed uh detailed technical aspects
like how data was collected or how a
question was asked or how or what the
sampling weights were so now if I'm
going to include any of these statistics
and charts in my reporter presentation I
can just site um the reference by
clicking on the copy citation located on
the bottom right of the
page as mentioned earlier dqs was
created in response to the data
modernization initiative that calls for
ways to provide faster more actionable
data and insights for decision making at
all levels of Public Health and one more
way that dqs is supporting that is by
providing more open publicly available
data so the dqs is seamlessly integrated
with open data on data.
cdc.gov and you can get to that by
clicking on the view data on data.
cdc.gov button located right below the
table or chart on the left
side on data. cdc.gov I can get more
details such as description of this
table contact email references and
footnote
file in addition these tables when
appropriate are also tagged to the
social determinance of Health s dooh
categories that are associated with the
healthy people
framework also from this page I can
directly export the file or get the open
uh the AP open API endpoint to use in my
programs or applications if I want to do
further
analysis I want to show um is the map
view available for some topics let us go
back to the dqs um application and and
now um whenever a topic has state level
data um like um let's scroll down here
dentist dentist has state level data
so if a topic is state level data a map
tab will appear next to the chart and um
table
tabs um and I can choose the estimate
type here so in the dqs estimate types
may be presented as counts rates or
percent among others and more are coming
as we add more topics to the dqs if more
than one topic is um more than one uh
type is available for a particular topic
like we have here in dentists I'll be
able to select the type um I want to
show in the select estimate
type on the left side of the map are the
time periods and I can click on the play
button to allow the map to move through
the time periods or I can select
manually the time
period i can hover on the map to see
more details pop up and I can download
the image of the map um that would have
also the customized
titles and the map uses quartile
classification when classifying data and
as in the confidence intervals I can
hover on the underlined
quartile um to get a
description by default the quartiles are
specific for each time period but I can
also use the same consistent quartiles
for all time periods I can just do that
by uh turning on that option show quals
based on the most recent available
period now I said that we will talk
about the health topics page we can go
to that page from this app the
application by clicking on the link uh
located conveniently above the selectors
so it says here data from some health
topics were collected from more than one
source explore the NHS data quer system
all topics to this decide you want to
select we can go to the health Topics by
clicking on
them the dqs has more than 120 Health
topics from multiple data systems and
sources and the health topics page helps
direct users to the type of information
that they need so here users get a
concise um compilation of the topics
available in the dqs so I would highly
recommend exploring this
page users can go directly
uh to the topic of Interest so say I'm
looking for um cardiovascular dis
disease so I'm going to scroll down so
here I see
it under cardiovascular diseases I see
the following topics currently in the
dqs but we are continuously working to
add more so stay
tuned um what's available in the dqs for
high cholesterol
we can see here that there is an
indicator just make it a little
bigger we can see here that there's an
indicator of high cholesterol from the
National Health interview survey that is
based on self-report and one from the
national health and nutrition
examination survey that is based on
Laboratory Testing dqs provides users
the ability to find and understand these
different indicators related to
cholesterol in one place Plus we have
added a direct link from these specific
topics to the data visualization so
here's an example explore and sites data
deest data on high cholesterol total
measured so if I click on
that that should open
up high cholesteral tool measured in the
dqs so let me go back to the health
topic Pages page for one second it'll
show
you that there are buttons um directly
to go to the dqs homepage and the dqs
application from here so let's go to the
homepage on the homepage I can go to the
dqs application by clicking on the enter
dqs
application um I also have a button for
user guide that has stepbystep
instructions for using the dqs so if you
miss something in the demo chances are
you'll find it
here the get updates button will take
you to the ler signups so um if you want
to get the latest news on dqs so please
sign up because we're so excited to
share what we've been what we've been
working
on we also have the parter toolkit where
you can access text and Graphics that
you can use to help us promote dqs of
social media and the
web and if you have any questions or
feedback after this webinar please feel
free to email the dqs team and there's a
direct link um in the questions button
here and that's it for the demo I'll
hand it over to zakiya who will
summarize our presentation and let me
bring back our
slides line we have um one question in
the in the chat which is about um the
underlying software used for the data
aggregation so uh just to answer that
question um the data are programmed
mostly uh from well directly from the
data files themselves so we uh develop
the estimates and those estimates are uh
put into a file and that's the file that
is in for each um for each data source
uh and or I guess we call them data
assets and data.
cdc.gov I hope that answers your
question hello my name is AIA Nelson I'm
an epidemiologist and contractor with
nchs I'm a light medium skinned woman
with long black care and I'm wearing
black and white I use pronouns she her
so thank you for the demonstration
Lorraine by now you can see how finding
visualizing and downloading Health Data
is fast and easy with nchs dqs here's an
overview of some of the D data user
concerns that dqs has addressed first
from our user research we know Health
Data users want to be able to access and
customize their searches online so dqs
searching was programmed from scratch to
be intuitive mobile friendly and
customizable
second we heard users didn't always know
where to find the data they were looking
for and it was timec consuming to search
through multiple sites to gather the
data they wanted so dqs has thousands of
estimates from all major nchs and even
external sources in one place third in
some cases more than one data source
collects information on a topic as you
saw in the demonstration dqs
differentiates those clearly in the
topic descriptions additionally
different data sources don't always use
the same labeling for information like
race and his Hispanic origin categories
even when the definition is the same in
dqs we've addressed that by using
consistent descriptions and labeling
wherever
possible lastly no matter what level of
understanding a user has about
statistical Concepts like competence
intervals there are plenty of
straightforward details about the
concepts and methodology throughout the
system to guide you in understanding and
interpreting the data next slide
please I've listed some of my favorite
qualities of dqs here but check out the
application yourself and see what you
think
as someone who does public health
research it's an enormous advantage to
have all these Health estimates
centralized with one access
point sometimes I know exactly what
health topic I want data for but a lot
of the time I'm looking for a fuller
picture of Health on a particular
subgroup of the population and dqs makes
it easy to search for data either
way it is so convenient to have the
reliability and the methodologic
information presented automatically with
my selections so I'm not searching for
important details like how a group is
defined or if there are compr issues
over time nqs links right to the
original data source if I want more
information and after I make my
selections and get these charts tables
and Maps I can just press a button and
download them format with a title and
the source for use elsewhere or I can
download all the summary estimates to do
more work on my own next slide
please the dqs team is busy on a regular
basis dqs is adding New Years of data to
topics that are already existing in the
system and new health topics so users
can find more of the Health Data they
want in the application on top of that
dqs is using feedback to optimize
existing functionality and add new
exciting features for users next slide
please so that's why your feedback
matters we want to hear from you about
what new data and features you'd like to
see so feel free to email us to stay up
toate on dqs subscribe to our list serve
thank you for joining us today to learn
more about nchs dqs now we'll open a
question and answer session with Amber
Wilson
thank you Zakia uh my name is Amber
Wilson and I'm a Contractor on the grasp
team at CDC and I work on dqs as the
communication specialist I use she her
pronouns and I am a white woman with
brown hair and I'm wearing a floral
shirt so I'll be assisting with the
question answer portion of this webinar
um please use the Q&A option to input
your questions to be answered and we do
have some questions already um to kick
things off and some have already been
answered as well um first up can you
search across conditions for instance
can you search for the leading causes of
death and disability that is the first
question uh hi this is Irma I I wanted
toh answer that question so at right now
um as as a key pointed out we are adding
things to the dqs all the time it's kind
of in Prototype form and we're
collecting information on what um what
people are looking for and we have
leading causes of death is one of the
areas that we're exploring to add to the
dqs and so although it is not presently
in the dqs it's something that we're
looking at and of course you can find
these data on the nchs website um in
other places they're just not in the dqs
yet thank you Irma um the next is the
next question that is come in is is the
dqs a customizable program that was
developed we have been using powerbi to
create dashboards pulling data from
various
sources so I will take a crack at that
and then uh ask Lorraine and Zaki if
they have anything to add to that we um
went with a custom application and the
reason that the
dqs U that we we made that decision is
because we wanted to be able to display
statistical precision and in order to do
that we wanted to um there were several
features that didn't exist on C on
off-the-shelf products and um so that
that's the decision that we ended up
making for the type of data that we had
and the type of
documentation um that nchs provides so
um it we do uh say it's customizable in
that we have um the estimates are broken
down by different subgroups and so you
can customize within the data source the
type or or within the topic that you're
searching the health topic that you're
searching the kind of data that you want
to display the subgroups you want to
display and we have a feature that we're
working on um that we are now calling
query and compare that would allow you
to display multiple uh visualizations uh
two two visualizations at the same
time and I don't know
or if you had anything to add to the
customizable aspect of the
dqs I don't have anything thank you
thank
you okay next is how does this work with
Wonder CDC Perma I see you oh that's a
yeah that's a great that's a great
question so we pulled some uh pull some
of the data for the dqs from Wonder the
mortality data for example some of that
we are drawing for Wonder it's not um
it's not intended the dqs is not
intended to replace one or the other
they're extremely complimentary one of
the uh added values of the dqs is that
we retrieve information from Wonder and
compile it into these underlying
estimates that can be viewed in
subgroups in a very easy format so
there's a there's more data manipulation
you need to do to pull the data to be
able from Wonder to examine for example
mortality statistics by subgroup and so
and across years by subgroup so we've
created that information in a way that
makes it more accessible and faster and
that's kind of our goal um in the moving
forward initiative to be able to make
those statistics uh have them more at
the ready for you to to
use
great continue to input your questions
into the Q&A box
um I have some other questions as well
um is dqs mobile
friendly yes it is we have a mobile uh
version of the dqs and that was part of
the custom build
yeah I wanted to Amber just come back to
one question we had earlier um which was
the northern uh someone asked about the
um the designation mp on the map that um
that Lorraine presented and so that is
for the northern Marana
islands and then Irma are there any
others that have been answered um typed
out would you like me to go back to such
as um the question on
covid or the underlying software being
used any of those questions I think the
uh I typed if I typed in the answer to
the covid question I don't know if it
displayed properly so if if it um yes it
looks like it did sorry about that great
no problem no problem just need to hit
refresh okay that's okay and the
underlying software I also uh it is
usually if SAS some of the tables were
programmed in R but they call they take
from the um underlying data file and uh
you know create the estimates and the
Precision of the estimates and that's uh
then once those estimates are compiled
they are loaded into to the dqs as a
data file as a data asset and uh as
Lorraine uh displayed uh can be accessed
from data. cdc.gov for further
analysis
great um another question is can you
visualize the data at a state level at
the state
level um I believe we do have some State
estimates now um we have uh so you know
one of the decisions about putting data
into the dqs is making sure that the
data that are provided um give us State
estimates with good precision and so
right now we're uh you we're early in
the process we do have some State
estimates and uh in those cases you will
see you'll be able to look uh not only
at the visualization of the trend data
but the actual map view and I think that
the information that Lorraine presented
on dentist was an example of the state
data that are
available great um line you did touch on
this but maybe some more detail um can I
select more than seven subgroups to show
on a to show on a
chart um currently we the maximum um Lim
the the maximum number of subgroups who
can select is seven
um but as you can um as I mentioned in
the demo we did receive feedback that
seven might not be enough especially if
we want to show um you know
intersectional
characteristics um and so um you know we
do listen to user feedback and we
encourage them so feel free to uh
provide those feedback so in response to
that we are um working to uh increase
that limit from 7 to 11 and that would
be in the next
release wonderful
um another question that has come in is
Will other
vaccination I think it just got answered
but um will other vaccination data be
added to the system or only affluenza
data and zakiya did answer that that us
go ahead no problem as I mentioned
before um the addition of new topics in
addition to uh the most updated data for
the existing topics in the in the system
is happening on a regular basis so um if
there is some that you're not seeing in
the system now it certainly may be there
very soon and um if you have you know an
interest in reaching out to us and
letting us know what particular data
you'd like to see we're definitely
trying to take that into
consideration great thank
you um
let's see how often do you update the
dqs so we're working on rolling updates
and actually we just had a Blog uh post
last week for uh the system was launched
on May 7th and we uh have
updated uh we just had a blog post I
guess yeah last week that um it's been
updated with the 20123 data from the
National Health interview survey with uh
new data from Health United States
and uh estimates from the national
health and nutrition examination survey
so they are we are updating as the data
become available we will be going
through the fall and into January adding
some uh new information so stay tuned
and as Zakia nicely pointed out please
email us if you'd like if there are
things that you'd like to see in the
data in the um query system that would
be uh what it's we we're definitely very
interested in user
feedback um one of the other things I'll
just mention is that we're also working
on inclusion and exclusion criteria so
one of the things we want to make sure
is that there're many dashboards in the
world and just so uh we want to make
sure that what we are providing is uh is
you know value added to users and so
understanding the relationship between
dashboards can be as important as
understanding the differences between
individual indicators and so we are
working on a process for trying to make
those decisions in a way that helps keep
the dqs as valuable as it can be and I
see Line's put the blog in in the post
thanks great um you did touch on this a
little how are you receiving feedback
from
users you can send us you can visit the
dqs you can email us you can uh uh email
US Direct or or directly to the dqs and
we're happy to receive it as you however
you'd like to provide that
information great and then
um what is the public health impact of
dqs I would say that um the most
important impact is the ability to get
access to data quickly and that's one
thing that we are as um as an as nchs is
is addressing this issue CDC is in is
addressing this issue and I think
Governor uh government more widely to
really try to make sure that we
modernize our systems and we learned a
lot from the pandemic about the need to
modernize and the need
to understand differences between
estimates so you know first you need to
be able to find the estimates and second
of all you have to understand what it is
so one of the features within the dqs is
where there are two estimates that have
the same name for example or or on a
given topic there are many ways to look
at um let's take obesity for example you
can look at BMI you can look at measured
obesity you can look at self-reported
obesity and so what we've tried to do
and what we're trying to do is is be
very uh purposeful in how we include
those measures and how those measur are
described because each measure needs to
be fit for its purpose it needs to be uh
responsive to your needs as a as a user
so this the system is designed to give
as much explanation as possible so that
you can make the most informed choice of
what you'd like to to um to use for for
the analysis that you are looking to
do wonderful thank you Irma Andia andain
um that's all the questions that have
come in and that we have for today Megan
I'm going to turn it back over to you as
I know you have some closing remarks
thank
you great thanks Amber and thanks to all
of our presenters today that was a
really insightful presentation we hope
that all of the audience gets a lot of
value out of the data query system that
you all have worked so hard on so that
is it for today's webinar thank you for
your attendance and your questions um a
recording of the webinar along with the
slides will be posted on the nchs web
page in the coming weeks so keep an eye
out for that and check back um like we
said to the dqs um page and just the
nchs homepage as well which was in some
of the Q&A so thank you so much and have
a great
afternoon thank you everyone thank you
everyone
