►
From YouTube: Sorting and Filtering Open Data
Description
How to sort and filter data in the City of Boulder's open data catalog
A
Hi,
my
name
is
katie
bridges,
I'm
a
senior
data
analyst
for
the
city
of
boulder's
it
department,
and
today
I'm
going
to
be
talking
about
sorting
and
filtering
data
in
the
city
of
boulder
open
data
page
to
get
to
this
page,
you
can
go
to
open
open-data.bouldercolorado.gov
and
there
is
a
separate
video
for
how
to
navigate
the
site.
If
there's
a
particular
dataset
you're.
Looking
for
today,
we're
going
to
be
looking
at
the
boulder
fire
department's
response
time
to
demonstrate
sorting
and
filtering
to
get
to
that
data
set
in
the
top
right
corner.
A
I'm
going
to
use
this
magnifying
glass,
I'm
going
to
start
to
type
in
fire,
you'll
notice,
all
of
the
corresponding
data
sets
come
up.
I
am
interested
in
the
response
times
for
bolder
fire
rescue,
so
I
will
click
on
that
data
set.
This
data
set
does
have
geospatial
data,
so
it
will
load
a
map.
Initially,
there
are
a
lot
of
records
here.
So
you'll
see
this
notice
that
there
are
too
many
records
we
can
zoom
in.
A
However,
we're
going
to
be
looking
at
data
in
a
table
perspective,
so
we're
going
to
click
on
the
top
right
corner.
That
says
view
table
and
I'm
going
to
x
out
of
this
notice
that
there
are
too
many
records
here.
We
can
look
at
the
data
and
sort
and
filter
it.
For
example,
when
we
log
in
we
see
that
the
first
record
here
shows
a
response
date
of
12
3,
2016.
A
we'd
like
to
know
when
the
last
time
this
data
was
updated,
so
we
can
sort
response
date
descending
to
do
that,
we'll
hover
over
the
column,
header
for
response
date,
and
we
will
click
on
it.
Initially,
it
will
sort
ascending
so
we'll
have
the
oldest
record
first.
So
we
can
see
this
data
starts
at
the
beginning
of
2015..
A
A
Now
that
we
know
the
response
date,
we
may
be
interested
in
filtering
this
data
to
look
at
his
first
particular
time
or
type
of
incident.
For
example,
if
we
scroll
over-
and
we
look
at
some
of
the
problems
that
the
boulder
fire
department
addresses,
we
may
be
interested
in
knowing
how
many
unconscious
fainting
calls.
Does
the
fire
department
respond
to
or
how
many
seizure
and
unconsciousness
call
types
do
they
receive?
A
We
could
filter
on
either
of
those
categories
to
do
that.
On
the
left
hand,
side
of
the
page
here
you'll
see
this
icon.
That
looks
like
an
hourglass.
It
says:
filter
data,
we're
going
to
click
on
that
icon.
Once
you
click
on
that
icon,
you
will
see
all
of
the
field
headers
populate
in
the
left
hand,
column.
A
You
will
check
the
one
that
you
are
interested
in
filtering.
If
we
are
interested
in
filtering
call
type.
For
example,
we
will
select
call
type
once
we
do
that
our
call
types
will
populate
in
the
top
of
that
column.
So
here
we
might
be
interested
in
seeing
seizure
and
unconsciousness.
So
we
could
choose
seizure
and
unconsciousness,
we'll
see
that
immediately
the
data
is
filtered
to
only
show
the
6000
records
that
are
seizure
and
unconsciousness
that
the
boulder
fire
department
has
responded
to.
A
If
there
is
a
call
type
that
you
don't
see
in
this
call
type
area
here,
this
is
only
the
top
five
call
types,
so
you
may
uncheck
that
and
want
to
search
for
other
values,
for
example,
difficulty
breathing,
which
we
can
see
in
the
data
set
as
a
call
type,
is
not
shown
here.
But
if
we
began
searching
difficulty
breathing
we
could
select
that
and
then
we
could
filter
the
data
by
the
call
types
of
difficulty
breathing
and
that
would
pop
up
as
an
option
now
in
our
call
type.
A
So
if
ever
you
don't
see
what
you're
looking
for
as
an
option
once
you've
selected
the
field
go
ahead
and
type
it
in
this
box
below,
you
could
also
filter
on
multiple
fields.
So
if
we
were
interested
where
the
call
type
was
difficulty
breathing
and
the
response
here
is
2021,
we
could
then
scroll
down
down
to
the
bottom
here
where
it
says,
select,
attribute
filters
and
check
response
year
as
well.