Discover a dataset

In this example you go through some basic steps to discover a Dataset in the Data Observatory.



In [1]:

    
from cartoframes.data.observatory import Catalog, Dataset

Catalog().country('usa').categories









    Out[1]:





[<Category.get('covid19')>,
 <Category.get('demographics')>,
 <Category.get('environmental')>,
 <Category.get('financial')>,
 <Category.get('geosocial')>,
 <Category.get('housing')>,
 <Category.get('human_mobility')>,
 <Category.get('points_of_interest')>,
 <Category.get('road_traffic')>]



In [2]:

    
Catalog().country('usa').category('demographics').providers









    Out[2]:





[<Provider.get('usa_bls')>,
 <Provider.get('usa_acs')>,
 <Provider.get('ags')>,
 <Provider.get('experian')>,
 <Provider.get('mbi')>]



In [3]:

    
datasets_acs_df = Catalog().country('usa').category('demographics').provider('usa_acs').datasets.to_dataframe()



In [4]:

    
datasets_acs_df.head()









    Out[4]:







  
    
      
      slug
      name
      description
      category_id
      country_id
      data_source_id
      provider_id
      geography_name
      geography_description
      temporal_aggregation
      time_coverage
      update_frequency
      is_public_data
      lang
      version
      category_name
      provider_name
      geography_id
      id
    
  
  
    
      0
      acs_sociodemogr_ecbce31e
      Sociodemographics - United States of America (...
      The American Community Survey (ACS) is an ongo...
      demographics
      usa
      sociodemographics
      usa_acs
      County - United States of America
      Shoreline clipped TIGER/Line boundaries. More ...
      3yrs
      [2007-01-01, 2010-01-01)
      yearly
      True
      eng
      20072009
      Demographics
      American Community Survey
      carto-do-public-data.carto.geography_usa_count...
      carto-do-public-data.usa_acs.demographics_soci...
    
    
      1
      acs_sociodemogr_516e1d44
      Sociodemographics - United States of America (...
      The American Community Survey (ACS) is an ongo...
      demographics
      usa
      sociodemographics
      usa_acs
      County - United States of America
      Shoreline clipped TIGER/Line boundaries. More ...
      3yrs
      [2011-01-01, 2014-01-01)
      yearly
      True
      eng
      20112013
      Demographics
      American Community Survey
      carto-do-public-data.carto.geography_usa_count...
      carto-do-public-data.usa_acs.demographics_soci...
    
    
      2
      acs_sociodemogr_477ca600
      Sociodemographics - United States of America (...
      The American Community Survey (ACS) is an ongo...
      demographics
      usa
      sociodemographics
      usa_acs
      County - United States of America
      Shoreline clipped TIGER/Line boundaries. More ...
      yearly
      [2009-01-01, 2010-01-01)
      yearly
      True
      eng
      2009
      Demographics
      American Community Survey
      carto-do-public-data.carto.geography_usa_count...
      carto-do-public-data.usa_acs.demographics_soci...
    
    
      3
      acs_sociodemogr_5f00d4dc
      Sociodemographics - United States of America (...
      The American Community Survey (ACS) is an ongo...
      demographics
      usa
      sociodemographics
      usa_acs
      Core-based Statistical Area - United States of...
      Shoreline clipped TIGER/Line boundaries. More ...
      5yrs
      [2007-01-01, 2012-01-01)
      yearly
      True
      eng
      20072011
      Demographics
      American Community Survey
      carto-do-public-data.carto.geography_usa_cbsa_...
      carto-do-public-data.usa_acs.demographics_soci...
    
    
      4
      acs_sociodemogr_18e867ac
      Sociodemographics - United States of America (...
      The American Community Survey (ACS) is an ongo...
      demographics
      usa
      sociodemographics
      usa_acs
      County - United States of America
      Shoreline clipped TIGER/Line boundaries. More ...
      5yrs
      [2011-01-01, 2016-01-01)
      yearly
      True
      eng
      20112015
      Demographics
      American Community Survey
      carto-do-public-data.carto.geography_usa_count...
      carto-do-public-data.usa_acs.demographics_soci...



In [5]:

    
datasets_acs_df[datasets_acs_df['geography_name'].str.contains('Block Groups')]









    Out[5]:







  
    
      
      slug
      name
      description
      category_id
      country_id
      data_source_id
      provider_id
      geography_name
      geography_description
      temporal_aggregation
      time_coverage
      update_frequency
      is_public_data
      lang
      version
      category_name
      provider_name
      geography_id
      id



In [6]:

    
dataset = Dataset.get('acs_sociodemogr_b758e778')



In [7]:

    
dataset.geom_coverage()

	slug	name	description	category_id	country_id	data_source_id	provider_id	geography_name	geography_description	temporal_aggregation	time_coverage	update_frequency	is_public_data	lang	version	category_name	provider_name	geography_id	id
0	acs_sociodemogr_ecbce31e	Sociodemographics - United States of America (...	The American Community Survey (ACS) is an ongo...	demographics	usa	sociodemographics	usa_acs	County - United States of America	Shoreline clipped TIGER/Line boundaries. More ...	3yrs	[2007-01-01, 2010-01-01)	yearly	True	eng	20072009	Demographics	American Community Survey	carto-do-public-data.carto.geography_usa_count...	carto-do-public-data.usa_acs.demographics_soci...
1	acs_sociodemogr_516e1d44	Sociodemographics - United States of America (...	The American Community Survey (ACS) is an ongo...	demographics	usa	sociodemographics	usa_acs	County - United States of America	Shoreline clipped TIGER/Line boundaries. More ...	3yrs	[2011-01-01, 2014-01-01)	yearly	True	eng	20112013	Demographics	American Community Survey	carto-do-public-data.carto.geography_usa_count...	carto-do-public-data.usa_acs.demographics_soci...
2	acs_sociodemogr_477ca600	Sociodemographics - United States of America (...	The American Community Survey (ACS) is an ongo...	demographics	usa	sociodemographics	usa_acs	County - United States of America	Shoreline clipped TIGER/Line boundaries. More ...	yearly	[2009-01-01, 2010-01-01)	yearly	True	eng	2009	Demographics	American Community Survey	carto-do-public-data.carto.geography_usa_count...	carto-do-public-data.usa_acs.demographics_soci...
3	acs_sociodemogr_5f00d4dc	Sociodemographics - United States of America (...	The American Community Survey (ACS) is an ongo...	demographics	usa	sociodemographics	usa_acs	Core-based Statistical Area - United States of...	Shoreline clipped TIGER/Line boundaries. More ...	5yrs	[2007-01-01, 2012-01-01)	yearly	True	eng	20072011	Demographics	American Community Survey	carto-do-public-data.carto.geography_usa_cbsa_...	carto-do-public-data.usa_acs.demographics_soci...
4	acs_sociodemogr_18e867ac	Sociodemographics - United States of America (...	The American Community Survey (ACS) is an ongo...	demographics	usa	sociodemographics	usa_acs	County - United States of America	Shoreline clipped TIGER/Line boundaries. More ...	5yrs	[2011-01-01, 2016-01-01)	yearly	True	eng	20112015	Demographics	American Community Survey	carto-do-public-data.carto.geography_usa_count...	carto-do-public-data.usa_acs.demographics_soci...