American Community Survey (ACS), State of Missouri, 2006-2010, Unemployment and Poverty Related Variables - Missouri_Data.csv

Dataset description:

Five-year ACS data at county level for the State of Missouri between 2006 and 2010. Format: The data is in a csv file with 17 columns: perfambelowpov: percentage of families below the...

Source: American Community Survey (ACS), State of Missouri, 2006-2010, Unemployment and Poverty Related Variables

Additional Information

Field	Value
Data last updated	March 22, 2016
Metadata last updated	February 9, 2016
Created	February 9, 2016
Format	CSV
License	Creative Commons Attribution Share-Alike
Datastore active	False
Has views	False
Id	79464b07-42e7-4791-8db1-aeae142239d4
Package id	569ab7e1-17cd-4964-84eb-22a53a0394f8
Position	0
State	active
Url type	upload

Field

Value

Data last updated

March 22, 2016

Metadata last updated

February 9, 2016

Created

February 9, 2016

Format

CSV

License

Creative Commons Attribution Share-Alike

Datastore active

False

Has views

False

79464b07-42e7-4791-8db1-aeae142239d4

Package id

569ab7e1-17cd-4964-84eb-22a53a0394f8

Position

State

active

Url type

upload

Package	Version	Homepage	Summary
alabaster	0.7.16	None	A light, configurable Sphinx theme
alembic	1.13.2	https://alembic.sqlalchemy.org	A database migration tool for SQLAlchemy.
arrow	1.3.0	None	Better dates & times for Python
asttokens	3.0.0	https://github.com/gristlabs/asttokens	Annotate AST trees with source code positions
async-timeout	4.0.3	https://github.com/aio-libs/async-timeout	Timeout context manager for asyncio programs
autocommand	2.2.2	https://github.com/Lucretiel/autocommand	A library to create a command-line program from a function
Babel	2.15.0	https://babel.pocoo.org/	Internationalization utilities
backports.tarfile	1.2.0	None	Backport of CPython tarfile module
beautifulsoup4	4.12.3	None	Screen-scraping library
binaryornot	0.4.4	https://github.com/audreyr/binaryornot	Ultra-lightweight pure Python package to check if a file is binary or text.
bleach	6.1.0	https://github.com/mozilla/bleach	An easy safelist-based HTML-sanitizing tool.
blinker	1.8.2	None	Fast, simple object-to-object and broadcast signaling
build	1.2.2.post1	None	A simple, correct Python build frontend
cachelib	0.13.0	https://github.com/pallets-eco/cachelib/	A collection of cache libraries in the same API interface.
certifi	2024.7.4	https://github.com/certifi/python-certifi	Python package for providing Mozilla's CA Bundle.
chardet	5.2.0	https://github.com/chardet/chardet	Universal encoding detector for Python 3
charset-normalizer	3.3.2	https://github.com/Ousret/charset_normalizer	The Real First Universal Charset Detector. Open, modern and actively maintained alternative to Chardet.
ckan	2.11.2	http://ckan.org/	CKAN Software
click	8.1.7	https://palletsprojects.com/p/click/	Composable command line interface toolkit
cookiecutter	2.6.0	https://github.com/cookiecutter/cookiecutter	A command-line utility that creates projects from project templates, e.g. creating a Python package project from a Python package project template.
coverage	7.6.12	https://github.com/nedbat/coveragepy	Code coverage measurement for Python
coveralls	4.0.1	http://github.com/TheKevJames/coveralls-python	Show coverage stats online via coveralls.io
decorator	5.2.1	None	Decorators for Humans
docopt	0.6.2	http://docopt.org	Pythonic argument parser, that will make you smile
docutils	0.20.1	https://docutils.sourceforge.io/	Docutils -- Python Documentation Utilities
dominate	2.9.1	None	Dominate is a Python library for creating and manipulating HTML documents using an elegant DOM API.
exceptiongroup	1.2.2	None	Backport of PEP 654 (exception groups)
executing	2.2.0	https://github.com/alexmojaki/executing	Get the currently executing AST node of a frame, and other information
factory-boy	3.3.0	https://github.com/FactoryBoy/factory_boy	A versatile test fixtures replacement based on thoughtbot's factory_bot for Ruby.
Faker	26.0.0	https://github.com/joke2k/faker	Faker is a Python package that generates fake data for you.
feedgen	1.0.0	https://lkiesow.github.io/python-feedgen	Feed Generator (ATOM, RSS, Podcasts)
Flask	3.0.3	None	A simple framework for building complex web applications.
flask-babel	4.0.0	https://github.com/python-babel/flask-babel	Adds i18n/l10n support for Flask applications.
Flask-DebugToolbar	0.15.1	https://github.com/pallets-eco/flask-debugtoolbar	A toolbar overlay for debugging Flask applications.
Flask-Login	0.6.3	https://github.com/maxcountryman/flask-login	User authentication and session management for Flask.
Flask-Session	0.8.0	None	Server-side session support for Flask
Flask-WTF	1.2.1	None	Form rendering, validation, and CSRF protection for Flask with WTForms.
freezegun	1.5.1	https://github.com/spulec/freezegun	Let your Python tests travel through time
greenlet	3.0.3	https://greenlet.readthedocs.io/	Lightweight in-process concurrent programming
idna	3.7	None	Internationalized Domain Names in Applications (IDNA)
imagesize	1.4.1	https://github.com/shibukawa/imagesize_py	Getting image size from png/jpeg/jpeg2000/gif file
importlib_metadata	8.0.0	None	Read metadata from Python packages
importlib_metadata	8.0.0	None	Read metadata from Python packages
incremental	24.7.2	None	A small library that versions your Python projects.
inflect	7.3.1	None	Correctly generate plurals, singular nouns, ordinals, indefinite articles
inflection	0.5.1	https://github.com/jpvanhal/inflection	A port of Ruby on Rails inflector to Python
iniconfig	2.0.0	None	brain-dead simple config-ini parsing
ipdb	0.13.13	https://github.com/gotcha/ipdb	IPython-enabled pdb
ipython	8.34.0	None	IPython: Productive Interactive Computing
itsdangerous	2.2.0	None	Safely pass data to untrusted environments and back.
jaraco.collections	5.1.0	None	Collection objects similar to those in stdlib by jaraco
jaraco.context	5.3.0	https://github.com/jaraco/jaraco.context	Useful decorators and context managers
jaraco.functools	4.0.1	None	Functools like those found in stdlib
jaraco.text	3.12.1	None	Module for text manipulation
jedi	0.19.2	https://github.com/davidhalter/jedi	An autocompletion tool for Python that can be used for text editors.
Jinja2	3.1.5	None	A very fast and expressive template engine.
lxml	5.2.2	https://lxml.de/	Powerful and Pythonic XML processing library combining libxml2/libxslt with the ElementTree API.
Mako	1.3.5	https://www.makotemplates.org/	A super-fast templating language that borrows the best ideas from the existing templating languages.
Markdown	3.6	None	Python implementation of John Gruber's Markdown.
markdown-it-py	3.0.0	None	Python port of markdown-it. Markdown parsing, done right!
MarkupSafe	2.1.5	https://palletsprojects.com/p/markupsafe/	Safely add untrusted strings to HTML/XML markup.
matplotlib-inline	0.1.7	None	Inline Matplotlib backend for Jupyter
mdurl	0.1.2	None	Markdown URL utilities
more-itertools	10.3.0	None	More routines for operating on iterables, beyond itertools
msgspec	0.18.6	https://jcristharif.com/msgspec/	A fast serialization and validation library, with builtin support for JSON, MessagePack, YAML, and TOML.
mypy	1.10.1	https://www.mypy-lang.org/	Optional static typing for Python
mypy-extensions	1.0.0	https://github.com/python/mypy_extensions	Type system extensions for programs checked with the mypy type checker.
packaging	24.1	None	Core utilities for Python packages
packaging	24.2	None	Core utilities for Python packages
parso	0.8.4	https://github.com/davidhalter/parso	A Python Parser
passlib	1.7.4	https://passlib.readthedocs.io	comprehensive password hashing framework supporting over 30 schemes
pexpect	4.9.0	https://pexpect.readthedocs.io/	Pexpect allows easy control of interactive console applications.
pillow	10.4.0	None	Python Imaging Library (Fork)
pip	25.0.1	None	The PyPA recommended tool for installing Python packages.
pip-tools	7.4.1	None	pip-tools keeps your pinned dependencies fresh.
platformdirs	4.2.2	None	A small Python package for determining appropriate platform-specific dirs, e.g. a `user data dir`.
pluggy	1.5.0	https://github.com/pytest-dev/pluggy	plugin and hook calling mechanisms for python
polib	1.2.0	https://github.com/izimobil/polib/	A library to manipulate gettext files (po and mo files).
prompt_toolkit	3.0.50	https://github.com/prompt-toolkit/python-prompt-toolkit	Library for building powerful interactive command lines in Python
psycopg2	2.9.9	https://psycopg.org/	psycopg2 - Python-PostgreSQL Database Adapter
ptyprocess	0.7.0	https://github.com/pexpect/ptyprocess	Run a subprocess in a pseudo terminal
pure_eval	0.2.3	http://github.com/alexmojaki/pure_eval	Safely evaluate AST nodes without side effects
Pygments	2.19.1	None	Pygments is a syntax highlighting package written in Python.
PyJWT	2.8.0	https://github.com/jpadilla/pyjwt	JSON Web Token implementation in Python
pyparsing	3.1.2	None	pyparsing module - Classes and methods to define and execute parsing grammars
pyproject_hooks	1.2.0	None	Wrappers to call pyproject.toml-based build backend hooks.
pysolr	3.9.0	https://github.com/django-haystack/pysolr/	Lightweight Python client for Apache Solr
pytest	8.2.2	None	pytest: simple powerful testing with Python
pytest-cov	5.0.0	https://github.com/pytest-dev/pytest-cov	Pytest plugin for measuring coverage.
pytest-factoryboy	2.7.0	https://pytest-factoryboy.readthedocs.io/	Factory Boy support for pytest.
pytest-freezegun	0.4.2	https://github.com/ktosiek/pytest-freezegun	Wrap tests with fixtures in freeze_time
pytest-rerunfailures	14.0	None	pytest plugin to re-run tests to eliminate flaky failures
pytest-split	0.9.0	https://jerry-git.github.io/pytest-split	Pytest plugin which splits the test suite to equally sized sub suites based on test execution time.
python-dateutil	2.9.0.post0	https://github.com/dateutil/dateutil	Extensions to the standard Python datetime module
python-magic	0.4.27	http://github.com/ahupp/python-magic	File type identification using libmagic
python-slugify	8.0.4	https://github.com/un33k/python-slugify	A Python slugify application that also handles Unicode
pytz	2024.1	http://pythonhosted.org/pytz	World timezone definitions, modern and historical
PyYAML	6.0.1	https://pyyaml.org/	YAML parser and emitter for Python
redis	5.0.7	https://github.com/redis/redis-py	Python client for Redis database and key-value store
requests	2.32.3	https://requests.readthedocs.io	Python HTTP for Humans.
responses	0.25.3	https://github.com/getsentry/responses	A utility library for mocking out the `requests` Python library.
rich	13.9.4	https://github.com/Textualize/rich	Render rich text, tables, progress bars, syntax highlighting, markdown and more to the terminal
rq	1.16.2	None	RQ is a simple, lightweight, library for creating background jobs, and processing them.
setuptools	76.0.0	None	Easily download, build, install, upgrade, and uninstall Python packages
simplejson	3.19.2	https://github.com/simplejson/simplejson	Simple, fast, extensible JSON encoder/decoder for Python
six	1.16.0	https://github.com/benjaminp/six	Python 2 and 3 compatibility utilities
snowballstemmer	2.2.0	https://github.com/snowballstem/snowball	This package provides 29 stemmers for 28 languages generated from Snowball algorithms.
soupsieve	2.6	None	A modern CSS selector implementation for Beautiful Soup.
Sphinx	7.3.7	None	Python documentation generator
sphinx-rtd-theme	2.0.0	https://github.com/readthedocs/sphinx_rtd_theme	Read the Docs theme for Sphinx
sphinxcontrib-applehelp	2.0.0	None	sphinxcontrib-applehelp is a Sphinx extension which outputs Apple help books
sphinxcontrib-devhelp	2.0.0	None	sphinxcontrib-devhelp is a sphinx extension which outputs Devhelp documents
sphinxcontrib-htmlhelp	2.1.0	None	sphinxcontrib-htmlhelp is a sphinx extension which renders HTML help files
sphinxcontrib-jquery	4.1	None	Extension to include jQuery on newer Sphinx releases
sphinxcontrib-jsmath	1.0.1	http://sphinx-doc.org/	A sphinx extension which renders display math in HTML via JavaScript
sphinxcontrib-qthelp	2.0.0	None	sphinxcontrib-qthelp is a sphinx extension which outputs QtHelp documents
sphinxcontrib-serializinghtml	2.0.0	None	sphinxcontrib-serializinghtml is a sphinx extension which outputs "serialized" HTML files (json and pickle)
SQLAlchemy	1.4.52	https://www.sqlalchemy.org	Database Abstraction Library
sqlalchemy2-stubs	0.0.2a38	http://www.sqlalchemy.org	Typing Stubs for SQLAlchemy 1.4
sqlparse	0.5.0	None	A non-validating SQL parser.
stack-data	0.6.3	http://github.com/alexmojaki/stack_data	Extract data from python stack frames and tracebacks for informative displays
text-unidecode	1.3	https://github.com/kmike/text-unidecode/	The most basic Text::Unidecode port
toml	0.10.2	https://github.com/uiri/toml	Python Library for Tom's Obvious, Minimal Language
tomli	2.0.1	None	A lil' TOML parser
tomli	2.0.1	None	A lil' TOML parser
towncrier	23.11.0	None	Building newsfiles for your project.
traitlets	5.14.3	None	Traitlets Python configuration system
typeguard	4.3.0	None	Run-time type checker for Python
types-python-dateutil	2.9.0.20241206	https://github.com/python/typeshed	Typing stubs for python-dateutil
typing_extensions	4.12.2	None	Backported and Experimental Type Hints for Python 3.8+
typing_extensions	4.12.2	None	Backported and Experimental Type Hints for Python 3.8+
tzlocal	5.2	None	tzinfo object for the local timezone
urllib3	2.2.2	None	HTTP library with thread-safe connection pooling, file post, and more.
uWSGI	2.0.28	https://uwsgi-docs.readthedocs.io/en/latest/	The uWSGI server
watchdog	4.0.1	https://github.com/gorakhargosh/watchdog	Filesystem events monitoring
wcwidth	0.2.13	https://github.com/jquast/wcwidth	Measures the displayed width of unicode strings in a terminal
webassets	2.0	http://github.com/miracle2k/webassets/	Media asset management for Python, with glue code for various web frameworks
webencodings	0.5.1	https://github.com/SimonSapin/python-webencodings	Character encoding aliases for legacy web content
Werkzeug	3.0.6	None	The comprehensive WSGI web application library.
wheel	0.45.1	None	A built-package format for Python
wheel	0.43.0	None	A built-package format for Python
WTForms	3.1.2	None	Form validation and rendering for Python web development.
zipp	3.19.2	None	Backport of pathlib-compatible object wrapper for zip files
zipp	3.19.2	None	Backport of pathlib-compatible object wrapper for zip files
zope.interface	6.4.post2	https://github.com/zopefoundation/zope.interface	Interfaces for Python

Resource	Value
User CPU time	29.890 msec
System CPU time	0.647 msec
Total CPU time	30.537 msec
Elapsed time	34.647 msec
Context switches	20 voluntary, 0 involuntary

Key	Value
HTTP_ACCEPT	/
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_CONNECTION	close
HTTP_HOST	192.168.122.4
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
QUERY_STRING
REMOTE_ADDR	127.0.0.1
REQUEST_METHOD	GET
SCRIPT_NAME
SERVER_NAME	niasra-ckan
SERVER_PORT	8080
SERVER_PROTOCOL	HTTP/1.0

Variable	Value
csrf_token	<function generate_csrf at 0x7fe10bdccee0>
current_user	<ckan.model.user.AnonymousUser object at 0x7fe106d8eb00>
g	<flask.g of 'ckan.config.middleware.flask_app'>
request	<Request 'http://192.168.122.4/dataset/missouri_data/resource/79464b07-42e7-4791-8db1-aeae142239d4' [GET]>
session	<SecureCookieSession {'_csrf_token': 'c38c452692987322785ed93ee5ddcdc7aaa96d26'}>

Variable	Value
csrf_token	<function generate_csrf at 0x7fe10bdccee0>
current_resource_view	None
current_user	<ckan.model.user.AnonymousUser object at 0x7fe106d8eb00>
dataset_type	'dataset'
g	<flask.g of 'ckan.config.middleware.flask_app'>
package	{'author': '', 'author_email': '', 'creator_user_id': 'cabf1a6f-eac1-4b67-bc82-3123f6babe6f', 'id': '569ab7e1-17cd-4964-84eb-22a53a0394f8', 'isopen': True, 'license_id': 'cc-by-sa', 'license_title': 'Creative Commons Attribution Share-Alike', 'license_url': 'http://www.opendefinition.org/licenses/cc-by-sa', 'maintainer': 'Andrew Zammit-Mangion', 'maintainer_email': 'azm@uow.edu.au', 'metadata_created': '2016-02-09T05:18:33.025971', 'metadata_modified': '2017-02-06T02:10:22.145963', 'name': 'missouri_data', 'notes': "Five-year ACS data at county level for the State of Missouri between 2006 and 2010.\r\n\r\nFormat:\r\n======\r\nThe data is in a csv file with 17 columns:\r\n\r\n* `perfambelowpov`: percentage of families below the poverty line\r\n\r\n* `perfambelowpovMOE`: margin of error in measuring percentage of families below the poverty line\r\n\r\n[//]: # (`numberemplyed`: number of people employed)\r\n\r\n[//]: # ( `numemplyedMoe`: margin of error in measuring number of people employed)\r\n\r\n* `totalpeople`: population of the county (16 years and over)\r\n\r\n* `GEO.display-label`: name of county\r\n\r\n* `medianfamilyincome`: median family income\r\n\r\n* `didnotwork`: number of adults 16 years and over who worked less than one week per year\r\n\r\n* `didnotworkmoe`: margin of error in measuring number of adults 16 years and over who worked less than one week per year\r\n\r\n* `percentunemployed`: percentage of population over 16 who are unemployed\r\n\r\n* `percentunemployedMOE`: margin of error in measuring percentage of population over 16 who are unemployed\r\n\r\n* `Total; Estimate; Families` : total number of families, estimated from the ACS\r\n\r\n* `Total; Margin of Error; Families` : margin of error in measuring total number of families\r\n\r\n* `Total; Estimate; Population 16 years and over` : total number of people 16 years and over, estimated from the ACS\r\n\r\n* `Total; Margin of Error; Population 16 years and over` : margin of error in measuring total number of people 16 years and over\r\n\r\n* `In labor force; Estimate; Population 16 years and over` : percentage of people in the labor force, estimated from the ACS\r\n\r\n* `In labor force; Margin of Error; Population 16 years and over` : margin of error in measuring the percentage of people in the labor force\r\n\r\n* `Employed; Estimate; Population 16 years and over` : percentage of population over 16 who are employed, estimated from the ACS\r\n\r\n* `Employed; Margin of Error; Population 16 years and over` : margin of error in measuring the percentage of population over 16 who are employed.\r\n\r\nDescription:\r\n=======\r\n\r\nThe file contains 17 columns with the fields as described above. Each of the fields denote response summaries over a 5-year period. The margin or error is equal to 1.65sigma, where sigma^2 is the survey variance for that variable.\r\n\r\n[//]: # (The only variable not verified to be consistent is `numberemplyed`. Values in this column correspond to about 40% of the population, and this appears to be correct given employment is around 50-60% of people over 16. However, since these have not been verified it is not recommended that this field be used.)\r\n\r\nThe field `percentunemployed` can be verified from the fields `In labor force; Estimate; Population 16 years and over` and `Employed; Estimate; Population 16 years and over` using the following formula:\r\n\r\n%unemployed = (%in labor force - %employed) / (%in labor force).\r\n\r\nDue to rounding error, the values usually match only up to the first significant figure, however this can be used as an informal 'sanity check' to ensure the downloaded data is correct.\r\n\r\n[//]: # (Another data 'sanity check' is the following. First, the number of people in the labour force can be obtained from the variables `numberemplyed`, `In labor force; Estimate; Population 16 years and over` and `Employed; Estimate; Population 16 years and over` through the following formula:)\r\n\r\n[//]: # ( #in labor force = (#employed %in labor force) / (%employed).)\r\n\r\n[//]: # (The percent unemployed (%unemployed) can then be verified through the following:)\r\n\r\n[//]: # (%unemployed = (#in labor force - #employed) / (#in labor force).)\r\n\r\n[//]: # (Note that the variables used in Porter et al. (2015) were `percentunemployed` and `perfambelowpov`.).\r\n\r\nPercent below poverty line and percent unemployed:\r\n=====================\r\n\r\nPorter, Holan, and Wikle (2015a, 2015b) illustrated their spatial multivariate methodologies using the two variables: “percentage of families below the poverty line” and “percentage of population over 16 who are unemployed,” using four columns selected from those given in the Description above. The four columns are:\r\n\r\n* `perfambelowpov`: percentage of families below the poverty line\r\n\r\n* `perfambelowpovMOE`: margin of error in measuring percentage of families below the poverty line\r\n\r\n* `percentunemployed`: percentage of population over 16 who are unemployed\r\n\r\n* `percentunemployedMOE`: margin of error in measuring percentage of population over 16 who are unemployed\r\n \r\nRecall that the first and third columns denote response summaries over a 5-year period, and the margin of error is equal to 1.65*sigma, where sigma^2 is the survey variance for that variable.\r\n\r\nReferences:\r\n=========\r\nPorter, A.T., Holan, S.H., and Wikle, C.K. (2015a) Multivariate spatial hierarchical Bayesian empirical likelihood methods for small area estimation. STAT, 4: 108--116.\r\n\r\nPorter, A.T., Holan, S.H., and Wikle, C.K. (2015b) Small Area Estimation via Multivariate Fay-Herriot Models with Latent Spatial Dependence. Australian & New Zealand Journal of Statistics. 57, 15--29. ", 'num_resources': 1, 'num_tags': 0, 'organization': {'id': '4207b363-dfff-475d-a24c-fd97ca7f9e9a', 'name': 'cei', 'title': 'Centre for Environmental Informatics (CEI)', 'type': 'organization', 'description': '', 'image_url': 'http://niasra.uow.edu.au/content/groups/webasset/@web/@inf/@math/documents/mm/uow170808.png', 'created': '2014-11-25T12:33:11.014268', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': '4207b363-dfff-475d-a24c-fd97ca7f9e9a', 'private': False, 'state': 'active', 'title': 'American Community Survey (ACS), State of Missouri, 2006-2010, Unemployment and Poverty Related Variables', 'type': 'dataset', 'url': '', 'version': '', 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2016-02-09T16:24:55.941672', 'datastore_active': False, 'description': '', 'format': 'CSV', 'hash': '', 'id': '79464b07-42e7-4791-8db1-aeae142239d4', 'last_modified': '2016-03-22T05:02:50.203569', 'metadata_modified': '2016-02-09T16:24:55.941672', 'mimetype': None, 'mimetype_inner': None, 'name': 'Missouri_Data.csv', 'package_id': '569ab7e1-17cd-4964-84eb-22a53a0394f8', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'url': 'https://hpc.niasra.uow.edu.au/ckan/dataset/569ab7e1-17cd-4964-84eb-22a53a0394f8/resource/79464b07-42e7-4791-8db1-aeae142239d4/download/data528county1212.csv', 'url_type': 'upload', 'has_views': False}], 'tags': [], 'extras': [], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': []}
pkg	<Package id=569ab7e1-17cd-4964-84eb-22a53a0394f8 name=missouri_data title=American Community Survey (ACS), State of Missouri, 2006-2010, Unemployment and Poverty Related Variables version= url= author= author_email= maintainer=Andrew Zammit-Mangion maintainer_email=azm@uow.edu.au notes=Five-year ACS data at county level for the State of Missouri between 2006 and 2010. Format: ====== The data is in a csv file with 17 columns: * `perfambelowpov`: percentage of families below the poverty line * `perfambelowpovMOE`: margin of error in measuring percentage of families below the poverty line [//]: # (`numberemplyed`: number of people employed) [//]: # ( `numemplyedMoe`: margin of error in measuring number of people employed) * `totalpeople`: population of the county (16 years and over) * `GEO.display-label`: name of county * `medianfamilyincome`: median family income * `didnotwork`: number of adults 16 years and over who worked less than one week per year * `didnotworkmoe`: margin of error in measuring number of adults 16 years and over who worked less than one week per year * `percentunemployed`: percentage of population over 16 who are unemployed * `percentunemployedMOE`: margin of error in measuring percentage of population over 16 who are unemployed * `Total; Estimate; Families` : total number of families, estimated from the ACS * `Total; Margin of Error; Families` : margin of error in measuring total number of families * `Total; Estimate; Population 16 years and over` : total number of people 16 years and over, estimated from the ACS * `Total; Margin of Error; Population 16 years and over` : margin of error in measuring total number of people 16 years and over * `In labor force; Estimate; Population 16 years and over` : percentage of people in the labor force, estimated from the ACS * `In labor force; Margin of Error; Population 16 years and over` : margin of error in measuring the percentage of people in the labor force * `Employed; Estimate; Population 16 years and over` : percentage of population over 16 who are employed, estimated from the ACS * `Employed; Margin of Error; Population 16 years and over` : margin of error in measuring the percentage of population over 16 who are employed. Description: ======= The file contains 17 columns with the fields as described above. Each of the fields denote response summaries over a 5-year period. The margin or error is equal to 1.65sigma, where sigma^2 is the survey variance for that variable. [//]: # (The only variable not verified to be consistent is `numberemplyed`. Values in this column correspond to about 40% of the population, and this appears to be correct given employment is around 50-60% of people over 16. However, since these have not been verified it is not recommended that this field be used.) The field `percentunemployed` can be verified from the fields `In labor force; Estimate; Population 16 years and over` and `Employed; Estimate; Population 16 years and over` using the following formula: %unemployed = (%in labor force - %employed) / (%in labor force). Due to rounding error, the values usually match only up to the first significant figure, however this can be used as an informal 'sanity check' to ensure the downloaded data is correct. [//]: # (Another data 'sanity check' is the following. First, the number of people in the labour force can be obtained from the variables `numberemplyed`, `In labor force; Estimate; Population 16 years and over` and `Employed; Estimate; Population 16 years and over` through the following formula:) [//]: # ( #in labor force = (#employed %in labor force) / (%employed).) [//]: # (The percent unemployed (%unemployed) can then be verified through the following:) [//]: # (%unemployed = (#in labor force - #employed) / (#in labor force).) [//]: # (Note that the variables used in Porter et al. (2015) were `percentunemployed` and `perfambelowpov`.). Percent below poverty line and percent unemployed: ===================== Porter, Holan, and Wikle (2015a, 2015b) illustrated their spatial multivariate methodologies using the two variables: “percentage of families below the poverty line” and “percentage of population over 16 who are unemployed,” using four columns selected from those given in the Description above. The four columns are: * `perfambelowpov`: percentage of families below the poverty line * `perfambelowpovMOE`: margin of error in measuring percentage of families below the poverty line * `percentunemployed`: percentage of population over 16 who are unemployed * `percentunemployedMOE`: margin of error in measuring percentage of population over 16 who are unemployed Recall that the first and third columns denote response summaries over a 5-year period, and the margin of error is equal to 1.65*sigma, where sigma^2 is the survey variance for that variable. References: ========= Porter, A.T., Holan, S.H., and Wikle, C.K. (2015a) Multivariate spatial hierarchical Bayesian empirical likelihood methods for small area estimation. STAT, 4: 108--116. Porter, A.T., Holan, S.H., and Wikle, C.K. (2015b) Small Area Estimation via Multivariate Fay-Herriot Models with Latent Spatial Dependence. Australian & New Zealand Journal of Statistics. 57, 15--29. license_id=cc-by-sa type=dataset owner_org=4207b363-dfff-475d-a24c-fd97ca7f9e9a creator_user_id=cabf1a6f-eac1-4b67-bc82-3123f6babe6f metadata_created=2016-02-09 05:18:33.025971 metadata_modified=2017-02-06 02:10:22.145963 private=False state=active plugin_data=None>
pkg_dict	{'author': '', 'author_email': '', 'creator_user_id': 'cabf1a6f-eac1-4b67-bc82-3123f6babe6f', 'id': '569ab7e1-17cd-4964-84eb-22a53a0394f8', 'isopen': True, 'license_id': 'cc-by-sa', 'license_title': 'Creative Commons Attribution Share-Alike', 'license_url': 'http://www.opendefinition.org/licenses/cc-by-sa', 'maintainer': 'Andrew Zammit-Mangion', 'maintainer_email': 'azm@uow.edu.au', 'metadata_created': '2016-02-09T05:18:33.025971', 'metadata_modified': '2017-02-06T02:10:22.145963', 'name': 'missouri_data', 'notes': "Five-year ACS data at county level for the State of Missouri between 2006 and 2010.\r\n\r\nFormat:\r\n======\r\nThe data is in a csv file with 17 columns:\r\n\r\n* `perfambelowpov`: percentage of families below the poverty line\r\n\r\n* `perfambelowpovMOE`: margin of error in measuring percentage of families below the poverty line\r\n\r\n[//]: # (`numberemplyed`: number of people employed)\r\n\r\n[//]: # ( `numemplyedMoe`: margin of error in measuring number of people employed)\r\n\r\n* `totalpeople`: population of the county (16 years and over)\r\n\r\n* `GEO.display-label`: name of county\r\n\r\n* `medianfamilyincome`: median family income\r\n\r\n* `didnotwork`: number of adults 16 years and over who worked less than one week per year\r\n\r\n* `didnotworkmoe`: margin of error in measuring number of adults 16 years and over who worked less than one week per year\r\n\r\n* `percentunemployed`: percentage of population over 16 who are unemployed\r\n\r\n* `percentunemployedMOE`: margin of error in measuring percentage of population over 16 who are unemployed\r\n\r\n* `Total; Estimate; Families` : total number of families, estimated from the ACS\r\n\r\n* `Total; Margin of Error; Families` : margin of error in measuring total number of families\r\n\r\n* `Total; Estimate; Population 16 years and over` : total number of people 16 years and over, estimated from the ACS\r\n\r\n* `Total; Margin of Error; Population 16 years and over` : margin of error in measuring total number of people 16 years and over\r\n\r\n* `In labor force; Estimate; Population 16 years and over` : percentage of people in the labor force, estimated from the ACS\r\n\r\n* `In labor force; Margin of Error; Population 16 years and over` : margin of error in measuring the percentage of people in the labor force\r\n\r\n* `Employed; Estimate; Population 16 years and over` : percentage of population over 16 who are employed, estimated from the ACS\r\n\r\n* `Employed; Margin of Error; Population 16 years and over` : margin of error in measuring the percentage of population over 16 who are employed.\r\n\r\nDescription:\r\n=======\r\n\r\nThe file contains 17 columns with the fields as described above. Each of the fields denote response summaries over a 5-year period. The margin or error is equal to 1.65sigma, where sigma^2 is the survey variance for that variable.\r\n\r\n[//]: # (The only variable not verified to be consistent is `numberemplyed`. Values in this column correspond to about 40% of the population, and this appears to be correct given employment is around 50-60% of people over 16. However, since these have not been verified it is not recommended that this field be used.)\r\n\r\nThe field `percentunemployed` can be verified from the fields `In labor force; Estimate; Population 16 years and over` and `Employed; Estimate; Population 16 years and over` using the following formula:\r\n\r\n%unemployed = (%in labor force - %employed) / (%in labor force).\r\n\r\nDue to rounding error, the values usually match only up to the first significant figure, however this can be used as an informal 'sanity check' to ensure the downloaded data is correct.\r\n\r\n[//]: # (Another data 'sanity check' is the following. First, the number of people in the labour force can be obtained from the variables `numberemplyed`, `In labor force; Estimate; Population 16 years and over` and `Employed; Estimate; Population 16 years and over` through the following formula:)\r\n\r\n[//]: # ( #in labor force = (#employed %in labor force) / (%employed).)\r\n\r\n[//]: # (The percent unemployed (%unemployed) can then be verified through the following:)\r\n\r\n[//]: # (%unemployed = (#in labor force - #employed) / (#in labor force).)\r\n\r\n[//]: # (Note that the variables used in Porter et al. (2015) were `percentunemployed` and `perfambelowpov`.).\r\n\r\nPercent below poverty line and percent unemployed:\r\n=====================\r\n\r\nPorter, Holan, and Wikle (2015a, 2015b) illustrated their spatial multivariate methodologies using the two variables: “percentage of families below the poverty line” and “percentage of population over 16 who are unemployed,” using four columns selected from those given in the Description above. The four columns are:\r\n\r\n* `perfambelowpov`: percentage of families below the poverty line\r\n\r\n* `perfambelowpovMOE`: margin of error in measuring percentage of families below the poverty line\r\n\r\n* `percentunemployed`: percentage of population over 16 who are unemployed\r\n\r\n* `percentunemployedMOE`: margin of error in measuring percentage of population over 16 who are unemployed\r\n \r\nRecall that the first and third columns denote response summaries over a 5-year period, and the margin of error is equal to 1.65*sigma, where sigma^2 is the survey variance for that variable.\r\n\r\nReferences:\r\n=========\r\nPorter, A.T., Holan, S.H., and Wikle, C.K. (2015a) Multivariate spatial hierarchical Bayesian empirical likelihood methods for small area estimation. STAT, 4: 108--116.\r\n\r\nPorter, A.T., Holan, S.H., and Wikle, C.K. (2015b) Small Area Estimation via Multivariate Fay-Herriot Models with Latent Spatial Dependence. Australian & New Zealand Journal of Statistics. 57, 15--29. ", 'num_resources': 1, 'num_tags': 0, 'organization': {'id': '4207b363-dfff-475d-a24c-fd97ca7f9e9a', 'name': 'cei', 'title': 'Centre for Environmental Informatics (CEI)', 'type': 'organization', 'description': '', 'image_url': 'http://niasra.uow.edu.au/content/groups/webasset/@web/@inf/@math/documents/mm/uow170808.png', 'created': '2014-11-25T12:33:11.014268', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': '4207b363-dfff-475d-a24c-fd97ca7f9e9a', 'private': False, 'state': 'active', 'title': 'American Community Survey (ACS), State of Missouri, 2006-2010, Unemployment and Poverty Related Variables', 'type': 'dataset', 'url': '', 'version': '', 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2016-02-09T16:24:55.941672', 'datastore_active': False, 'description': '', 'format': 'CSV', 'hash': '', 'id': '79464b07-42e7-4791-8db1-aeae142239d4', 'last_modified': '2016-03-22T05:02:50.203569', 'metadata_modified': '2016-02-09T16:24:55.941672', 'mimetype': None, 'mimetype_inner': None, 'name': 'Missouri_Data.csv', 'package_id': '569ab7e1-17cd-4964-84eb-22a53a0394f8', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'url': 'https://hpc.niasra.uow.edu.au/ckan/dataset/569ab7e1-17cd-4964-84eb-22a53a0394f8/resource/79464b07-42e7-4791-8db1-aeae142239d4/download/data528county1212.csv', 'url_type': 'upload', 'has_views': False}], 'tags': [], 'extras': [], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': []}
request	<Request 'http://192.168.122.4/dataset/missouri_data/resource/79464b07-42e7-4791-8db1-aeae142239d4' [GET]>
resource	{'cache_last_updated': None, 'cache_url': None, 'created': '2016-02-09T16:24:55.941672', 'datastore_active': False, 'description': '', 'format': 'CSV', 'hash': '', 'id': '79464b07-42e7-4791-8db1-aeae142239d4', 'last_modified': '2016-03-22T05:02:50.203569', 'metadata_modified': '2016-02-09T16:24:55.941672', 'mimetype': None, 'mimetype_inner': None, 'name': 'Missouri_Data.csv', 'package_id': '569ab7e1-17cd-4964-84eb-22a53a0394f8', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'url': 'https://hpc.niasra.uow.edu.au/ckan/dataset/569ab7e1-17cd-4964-84eb-22a53a0394f8/resource/79464b07-42e7-4791-8db1-aeae142239d4/download/data528county1212.csv', 'url_type': 'upload', 'has_views': False}
resource_views	[]
session	<SecureCookieSession {'_csrf_token': 'c38c452692987322785ed93ee5ddcdc7aaa96d26'}>

Missouri_Data.csv

Dataset description:

Additional Information

Versions

Installed Packages

Resource Usage

HTTP Headers

Request Vars

View information

COOKIES Variables

SESSION Variables

GET Variables

POST Variables

Config

Templates

snippets/csrf_input.html

package/resource_read.html

SQLAlchemy queries

Queries Unavailable

Install required libraries:

Configure Flask-SQLAlchemy:

Log Messages

Route List

Profiler not active

flask.g content

Key	Value
__file__	`'/etc/ckan/default/ckan.ini'`
api_token.jwt.algorithm	`'HS256'`
api_token.jwt.decode.secret	`'string:OuonVd5Md43IixzaojMJc6OV1Pk'`
api_token.jwt.encode.secret	`'string:OuonVd5Md43IixzaojMJc6OV1Pk'`
api_token.nbytes	`32`
apitoken_header_name	`'Authorization'`
APPLICATION_ROOT	`'/'`
BABEL_DEFAULT_TIMEZONE	`'UTC'`
BABEL_DOMAIN	`'ckan'`
BABEL_TRANSLATION_DIRECTORIES	`'/usr/lib/ckan/default/lib/python3.10/site-packages/ckan/i18n'`
ckan.activity_list_limit	`31`
ckan.activity_list_limit_max	`100`
ckan.activity_streams_email_notifications	`False`
ckan.activity_streams_enabled	`True`
ckan.auth.allow_admin_collaborators	`True`
ckan.auth.allow_collaborators_to_change_owner_org	`True`
ckan.auth.allow_dataset_collaborators	`True`
ckan.auth.anon_create_dataset	`True`
ckan.auth.create_dataset_if_not_in_organization	`True`
ckan.auth.create_default_api_keys	`False`
ckan.auth.create_unowned_dataset	`True`
ckan.auth.create_user_via_api	`True`
ckan.auth.create_user_via_web	`True`
ckan.auth.enable_cookie_auth_in_api	`True`
ckan.auth.login_view	`'user.login'`
ckan.auth.public_activity_stream_detail	`True`
ckan.auth.public_user_details	`True`
ckan.auth.reveal_private_datasets	`True`
ckan.auth.roles_that_cascade_to_sub_groups	`['admin']`
ckan.auth.route_after_login	`'dashboard.datasets'`
ckan.auth.user_create_groups	`True`
ckan.auth.user_create_organizations	`True`
ckan.auth.user_delete_groups	`True`
ckan.auth.user_delete_organizations	`True`
ckan.base_public_folder	`'public'`
ckan.base_templates_folder	`'templates'`
ckan.cache_enabled	`False`
ckan.cache_expires	`0`
ckan.cors.origin_allow_all	`False`
ckan.cors.origin_whitelist	`[]`
ckan.csrf_protection.ignore_extensions	`True`
ckan.dataset.create_on_ui_requires_resources	`True`
ckan.datasets_per_page	`20`
ckan.datastore.default_fts_index_field_types	`['text', 'tsvector']`
ckan.datastore.default_fts_index_method	`'gist'`
ckan.datastore.default_fts_lang	`'english'`
ckan.datastore.read_url	`'postgresql://datastore_default:ckanniasra123!@localhost/datastore_default'`
ckan.datastore.search.rows_default	`100`
ckan.datastore.search.rows_max	`32000`
ckan.datastore.sqlalchemy.pool_pre_ping	`True`
ckan.datastore.sqlsearch.allowed_functions_file	`'/usr/lib/ckan/default/lib/python3.10/site-packages/ckanext/datastore/allowed_functions.txt'`
ckan.datastore.sqlsearch.enabled	`False`
ckan.datastore.write_url	`'postgresql://ckan_default:ckanniasra123!@localhost/datastore_default'`
ckan.debug_supress_header	`False`
ckan.default.group_type	`'group'`
ckan.default.organization_type	`'organization'`
ckan.default.package_type	`'dataset'`
ckan.default_group_sort	`'title'`
ckan.devserver.host	`'localhost'`
ckan.devserver.multiprocess	`1`
ckan.devserver.port	`5000`
ckan.devserver.ssl_cert	`''`
ckan.devserver.ssl_key	`''`
ckan.devserver.threaded	`True`
ckan.devserver.watch_patterns	`[]`
ckan.display_timezone	`'UTC'`
ckan.download_proxy	`''`
ckan.email_notifications_since	`'2 days'`
ckan.extra_resource_fields	`[]`
ckan.favicon	`'/base/images/ckan.ico'`
ckan.featured_groups	`[]`
ckan.featured_orgs	`[]`
ckan.feeds.author_link	`''`
ckan.feeds.author_name	`''`
ckan.feeds.authority_name	`''`
ckan.feeds.date	`''`
ckan.feeds.limit	`20`
ckan.gravatar_default	`'identicon'`
ckan.group_and_organization_list_all_fields_max	`25`
ckan.group_and_organization_list_max	`1000`
ckan.hide_activity_from_users	`['niasra-ckan']`
ckan.hide_version	`False`
ckan.i18n.extra_directory	`''`
ckan.i18n.extra_gettext_domain	`''`
ckan.i18n.extra_locales	`[]`
ckan.i18n.rtl_languages	`['he', 'ar', 'fa_IR']`
ckan.i18n.rtl_theme	`'css/main-rtl'`
ckan.i18n_directory	`''`
ckan.jobs.timeout	`180`
ckan.legacy_route_mappings	`'{}'`
ckan.locale_default	`'en'`
ckan.locale_order	`[]`
ckan.locales_filtered_out	`[]`
ckan.locales_offered	`[]`
ckan.max_image_size	`50`
ckan.max_resource_size	`10240`
ckan.mimetype_guess	`'file_ext'`
ckan.plugins	`['activity', 'datastore']`
ckan.recaptcha.privatekey	`''`
ckan.recaptcha.publickey	`''`
ckan.redis.url	`'redis://localhost:6379/0'`
ckan.requests.timeout	`5`
ckan.resource_formats	`'/usr/lib/ckan/default/lib/python3.10/site-packages/ckan/config/resource_formats.json'`
ckan.root_path	`'/ckan/{{LANG}}'`
ckan.search.default_include_private	`True`
ckan.search.default_package_sort	`'score desc, metadata_modified desc'`
ckan.search.remove_deleted_packages	`True`
ckan.search.rows_max	`1000`
ckan.search.show_all_types	`'dataset'`
ckan.search.solr_allowed_query_parsers	`[]`
ckan.search.solr_commit	`True`
ckan.site_about	'INTRODUCTION BY DIRECTOR: PROFESSOR Marijka Batterham \r\n----------------------\r\n\r\nThe National Institute for Applied Statistics Research Australia (NIASRA) at the University of Wollongong aims to identify Australia as a place where the discipline of applied statistics collaborates with academics and professionals in science, government, business and industry to tackle strategic problems. Methods for obtaining relevant and reliable data and methods that can be used to extract the information and evidence that the data can provide are fundamental in solving important and complex problems facing society. The huge increase in data available in all fields and relating to every issue challenging a modern society means that there are large gaps between the methods needed to fully exploit these data and the methods available to do so. New statistical methods are needed to handle uncertainty and risk in large and complex data structures and to generate knowledge that can be acted upon. NIASRA is undertaking a program of research developing new statistical methods for obtaining and analysing data relevant to agriculture, energy, engineering, environmental sciences, finance, health, medicine, mining, natural resources, and social sciences. The Institute aims to provide leading-edge research and consulting capacity in applied statistics for Australia and our region through the skills and activities of its staff and research students. \r\n \r\n\r\nNIASRA is committed to developing and applying innovative statistical methods to important problems. It conducts: \r\n\r\n- fundamental methodological research; \r\n- industry-focused and contract research; \r\n- major consulting projects;\r\n- professional education and training. \r\n \r\nNIASRA’s research is focused in Biometry and Bioinformatics, Environmental Informatics, Survey Methodology, and also research in Statistical Education and Statistical and Mathematical Methodology in Finance. It is led by Director Prof David Steel and includes: \r\n\r\n- Centre for Bioinformatics and Biometrics Research – Director Prof Brian Cullis;\r\n- Centre for Environmental Informatics – Director Distinguished Prof Noel Cressie;\r\n- Centre for Sample Survey Methodology – Director Prof Ray Chambers;\r\n- Statistical Consulting Centre - Director A/Professor Marijka Batterham, focussing on support for research within the University in design and analysis.\r\n \r\nThe institute is a Research Strength of the University of Wollongong and has over 20 academic staff members and 25 research students. It has been successful in developing long-term collaborative partnerships. It has two externally funded research professors: Professor Chambers is funded by the Australian Bureau of Statistics and Professor Brian Cullis is funded by CSIRO and the Grains Research Development Corporation. It has formal partnerships with the NZ Ministry of Health and the Australian Market and Social Research Society. \r\n \r\n\r\nThe themes that underpin the research at NIASRA are:\r\n\r\n- statistical design - developing efficient methods of obtaining relevant and reliable data in surveys, experiments, and other data collections;\r\n- complexity of data arising from observations in large scale real populations – often involving hierarchical or auto-correlated data - and computational methods to handle such data; and\r\n- working with major organisations on significant problems. \r\n \r\nInternationally competitive areas of methodological research include: statistical design - survey and experimental design; analysis of complex data from complex populations - survey, biometric, environmental, longitudinal, spatial, aggregated data, and also combining data; statistical modelling – methods for spatial, temporal and spatial-temporal data, semi-parametric and nonparametric methods, time series, quasi-likelihood, multi-level modelling, Bayesian analysis, and estimating equations;\r\ndata quality and survey methods - particularly telephone, household, internet and environmental surveys;\r\nstatistical confidentiality.\r\n \r\nNIASRA offers postgraduate and professional education courses and programs that build on our world-class staff, extensive experience and industry collaborations.'
ckan.site_custom_css	`'a[href]:after {\r\n content: none;\r\n}\r\n.hero {\r\n min-height:0px;\r\n}'`
ckan.site_description	`'National Institute for Applied Statistics Research Australia'`
ckan.site_id	`'niasra-ckan'`
ckan.site_intro_text	'This data portal hosts data of interest to, or used in projects by, researchers at the National Institute of Applied Research Australia (NIASRA), based at the University of Wollongong. All data available to the public can be considered open source. The open data portal software employed here is `CKAN`; more information can be found at http://ckan.org/.'
ckan.site_logo	`'niasra-logo.png'`
ckan.site_title	`'NIASRA'`
ckan.site_url	`'https://hpc.niasra.uow.edu.au'`
ckan.static_max_age	`3600`
ckan.storage_path	`'/var/lib/ckan/default'`
ckan.template_title_delimiter	`'-'`
ckan.theme	`'css/main'`
ckan.upload.group.mimetypes	`['image/png', 'image/gif', 'image/jpeg']`
ckan.upload.group.types	`['image']`
ckan.upload.user.mimetypes	`['image/png', 'image/gif', 'image/jpeg']`
ckan.upload.user.types	`['image']`
ckan.user.last_active_interval	`600`
ckan.user_list_limit	`20`
ckan.user_reset_landing_page	`'home.index'`
ckan.valid_url_schemes	`['http', 'https', 'ftp']`
ckan.views.default_views	`['image_view', 'datatables_view']`
ckan.webassets.path	`''`
ckan.webassets.url	`'/webassets'`
ckan.webassets.use_x_sendfile	`False`
clear_logo_upload	`''`
computed_template_paths	`['/usr/lib/ckan/default/lib/python3.10/site-packages/ckanext/activity/templates', '/usr/lib/ckan/default/lib/python3.10/site-packages/ckanext/datastore/templates', '/usr/lib/ckan/default/lib/python3.10/site-packages/ckan/templates']`
config.mode	`'strict'`
DEBUG	`True`
debug	`True`
DEBUG_TB_ENABLED	`True`
DEBUG_TB_HOSTS	`()`
DEBUG_TB_INTERCEPT_REDIRECTS	`False`
DEBUG_TB_PANELS	('flask_debugtoolbar.panels.versions.VersionDebugPanel', 'flask_debugtoolbar.panels.timer.TimerDebugPanel', 'flask_debugtoolbar.panels.headers.HeaderDebugPanel', 'flask_debugtoolbar.panels.request_vars.RequestVarsDebugPanel', 'flask_debugtoolbar.panels.config_vars.ConfigVarsDebugPanel', 'flask_debugtoolbar.panels.template.TemplateDebugPanel', 'flask_debugtoolbar.panels.sqlalchemy.SQLAlchemyDebugPanel', 'flask_debugtoolbar.panels.logger.LoggingPanel', 'flask_debugtoolbar.panels.route_list.RouteListDebugPanel', 'flask_debugtoolbar.panels.profiler.ProfilerDebugPanel', 'flask_debugtoolbar.panels.g.GDebugPanel')
email_to	`''`
error_email_from	`''`
EXPLAIN_TEMPLATE_LOADING	`False`
extra_public_paths	`''`
extra_template_paths	`''`
here	`'/etc/ckan/default'`
licenses_group_url	`''`
logo_upload	`''`
MAX_CONTENT_LENGTH	`None`
MAX_COOKIE_SIZE	`4093`
package_edit_return_url	`''`
package_hide_extras	`[]`
package_new_return_url	`''`
PERMANENT_SESSION_LIFETIME	`31536000`
plugin_public_paths	`['/usr/lib/ckan/default/lib/python3.10/site-packages/ckanext/activity/public']`
plugin_template_paths	`['/usr/lib/ckan/default/lib/python3.10/site-packages/ckanext/activity/templates', '/usr/lib/ckan/default/lib/python3.10/site-packages/ckanext/datastore/templates']`
PREFERRED_URL_SCHEME	`'http'`
PROPAGATE_EXCEPTIONS	`None`
REMEMBER_COOKIE_DOMAIN	`None`
REMEMBER_COOKIE_DURATION	`31536000`
REMEMBER_COOKIE_HTTPONLY	`True`
REMEMBER_COOKIE_NAME	`'remember_token'`
REMEMBER_COOKIE_PATH	`'/'`
REMEMBER_COOKIE_REFRESH_EACH_REQUEST	`False`
REMEMBER_COOKIE_SAMESITE	`'None'`
REMEMBER_COOKIE_SECURE	`False`
search.facets	`['organization', 'groups', 'tags', 'res_format', 'license_id']`
search.facets.default	`10`
search.facets.limit	`50`
SECRET_KEY	`'OuonVd5Md43IixzaojMJc6OV1Pk'`
SEND_FILE_MAX_AGE_DEFAULT	`None`
SERVER_NAME	`None`
SESSION_COOKIE_DOMAIN	`''`
SESSION_COOKIE_HTTPONLY	`True`
SESSION_COOKIE_NAME	`'ckan'`
SESSION_COOKIE_PATH	`''`
SESSION_COOKIE_SAMESITE	`'Lax'`
SESSION_COOKIE_SECURE	`False`
SESSION_KEY_PREFIX	`'session:'`
SESSION_PERMANENT	`True`
SESSION_REFRESH_EACH_REQUEST	`False`
SESSION_TYPE	`'cookie'`
SESSION_USE_SIGNER	`False`
smtp.mail_from	`''`
smtp.password	`''`
smtp.reply_to	`''`
smtp.server	`'localhost'`
smtp.starttls	`False`
smtp.user	`''`
solr_password	`''`
solr_timeout	`60`
solr_url	`'http://192.168.122.4:8983/solr/ckan'`
solr_user	`''`
sqlalchemy.pool_pre_ping	`True`
sqlalchemy.url	`'postgresql://ckan_default:ckanniasra123!@localhost/ckan_default'`
SQLALCHEMY_RECORD_QUERIES	`True`
TEMPLATES_AUTO_RELOAD	`None`
TESTING	`False`
testing	`False`
TRAP_BAD_REQUEST_ERRORS	`None`
TRAP_HTTP_EXCEPTIONS	`False`
use	`'egg:ckan'`
USE_X_SENDFILE	`False`
WTF_CSRF_CHECK_DEFAULT	`True`
WTF_CSRF_ENABLED	`True`
WTF_CSRF_FIELD_NAME	`'_csrf_token'`
WTF_CSRF_HEADERS	`['X-CSRFToken', 'X-CSRF-Token']`
WTF_CSRF_METHODS	`{'PUT', 'DELETE', 'POST', 'PATCH'}`
WTF_CSRF_SECRET_KEY	`'string:OuonVd5Md43IixzaojMJc6OV1Pk'`
WTF_CSRF_SSL_STRICT	`True`
WTF_CSRF_TIME_LIMIT	`3600`
WTF_I18N_ENABLED	`True`

URL route	Endpoint name	HTTP methods	Is alias	Redirect to
/	home.index	GET, HEAD, OPTIONS	False	None
/<path:filename>	static	GET, HEAD, OPTIONS	False	None
/about	home.about	GET, HEAD, OPTIONS	False	None
/api/	api.get_api	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/i18n/<lang>	api.i18n_js_translations	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/dataset/autocomplete	api.dataset_autocomplete	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/group/autocomplete	api.group_autocomplete	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/organization/autocomplete	api.organization_autocomplete	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/resource/format_autocomplete	api.format_autocomplete	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/snippet/<snippet_path>	api.snippet	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/tag/autocomplete	api.tag_autocomplete	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=2):ver>/util/user/autocomplete	api.user_autocomplete	GET, HEAD, OPTIONS	False	None
/api/<int(min=1, max=3):ver>	api.get_api	GET, HEAD, OPTIONS	False	None
/api/<int(min=3, max=3):ver>/action/<logic_function>	api.action	GET, HEAD, OPTIONS, POST	False	None
/api/action/<logic_function>	api.action	GET, HEAD, OPTIONS, POST	False	None
/api/i18n/<lang>	api.i18n_js_translations	GET, HEAD, OPTIONS	False	None
/api/util/dataset/autocomplete	api.dataset_autocomplete	GET, HEAD, OPTIONS	False	None
/api/util/group/autocomplete	api.group_autocomplete	GET, HEAD, OPTIONS	False	None
/api/util/organization/autocomplete	api.organization_autocomplete	GET, HEAD, OPTIONS	False	None
/api/util/resource/format_autocomplete	api.format_autocomplete	GET, HEAD, OPTIONS	False	None
/api/util/snippet/<snippet_path>	api.snippet	GET, HEAD, OPTIONS	False	None
/api/util/tag/autocomplete	api.tag_autocomplete	GET, HEAD, OPTIONS	False	None
/api/util/user/autocomplete	api.user_autocomplete	GET, HEAD, OPTIONS	False	None
/ckan-admin/	admin.index	GET, HEAD, OPTIONS	False	None
/ckan-admin/config	admin.config	GET, HEAD, OPTIONS, POST	False	None
/ckan-admin/reset_config	admin.reset_config	GET, HEAD, OPTIONS, POST	False	None
/ckan-admin/trash	admin.trash	GET, HEAD, OPTIONS, POST	False	None
/ckan/_debug_toolbar/static/<path:filename>	_debug_toolbar.static	GET, HEAD, OPTIONS	False	None
/dashboard/	activity.dashboard	GET, HEAD, OPTIONS	False	None
/dashboard/datasets	dashboard.datasets	GET, HEAD, OPTIONS	False	None
/dashboard/groups	dashboard.groups	GET, HEAD, OPTIONS	False	None
/dashboard/organizations	dashboard.organizations	GET, HEAD, OPTIONS	False	None
/dataset/	dataset.search	GET, HEAD, OPTIONS	False	None
/dataset/<id>	dataset.read	GET, HEAD, OPTIONS	False	None
/dataset/<id>/dictionary/<resource_id>	datastore.dictionary	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/history/<activity_id>	activity.package_history	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>	dataset_resource.read	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>	resource.read	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/delete	dataset_resource.delete	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/delete	resource.delete	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/download	dataset_resource.download	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/download	resource.download	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/download/<filename>	dataset_resource.download	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/download/<filename>	resource.download	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/edit	dataset_resource.edit	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/edit	resource.edit	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/edit_view/<view_id>	dataset_resource.edit_view	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/edit_view/<view_id>	resource.edit_view	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/new_view	dataset_resource.edit_view	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/new_view	resource.edit_view	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/<resource_id>/view	dataset_resource.view	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/view	resource.view	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/view/<view_id>	dataset_resource.view	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/view/<view_id>	resource.view	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/views	dataset_resource.views	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/<resource_id>/views	resource.views	GET, HEAD, OPTIONS	False	None
/dataset/<id>/resource/new	dataset_resource.new	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resource/new	resource.new	GET, HEAD, OPTIONS, POST	False	None
/dataset/<id>/resources/<resource_id>/history/<activity_id>	activity.resource_history	GET, HEAD, OPTIONS	False	None
/dataset/activity/<id>	activity.package_activity	GET, HEAD, OPTIONS	False	None
/dataset/changes/<id>	activity.package_changes	GET, HEAD, OPTIONS	False	None
/dataset/changes_multiple	activity.package_changes_multiple	GET, HEAD, OPTIONS	False	None
/dataset/collaborators/<id>	dataset.collaborators_read	GET, HEAD, OPTIONS	False	None
/dataset/collaborators/<id>/delete/<user_id>	dataset.collaborator_delete	GET, HEAD, OPTIONS, POST	False	None
/dataset/collaborators/<id>/new	dataset.new_collaborator	GET, HEAD, OPTIONS, POST	False	None
/dataset/delete/<id>	dataset.delete	GET, HEAD, OPTIONS, POST	False	None
/dataset/edit/<id>	dataset.edit	GET, HEAD, OPTIONS, POST	False	None
/dataset/follow/<id>	dataset.follow	OPTIONS, POST	False	None
/dataset/followers/<id>	dataset.followers	GET, HEAD, OPTIONS	False	None
/dataset/groups/<id>	dataset.groups	GET, HEAD, OPTIONS, POST	False	None
/dataset/new	dataset.new	GET, HEAD, OPTIONS, POST	False	None
/dataset/resources/<id>	dataset.resources	GET, HEAD, OPTIONS	False	None
/dataset/unfollow/<id>	dataset.unfollow	OPTIONS, POST	False	None
/datastore/dump/<resource_id>	datastore.dump	GET, HEAD, OPTIONS	False	None
/feeds/custom.atom	feeds.custom	GET, HEAD, OPTIONS	False	None
/feeds/dataset.atom	feeds.general	GET, HEAD, OPTIONS	False	None
/feeds/group/<string:id>.atom	feeds.group	GET, HEAD, OPTIONS	False	None
/feeds/organization/<string:id>.atom	feeds.organization	GET, HEAD, OPTIONS	False	None
/feeds/tag/<string:id>.atom	feeds.tag	GET, HEAD, OPTIONS	False	None
/group/	group.index	GET, HEAD, OPTIONS	False	None
/group/<id>	group.read	GET, HEAD, OPTIONS	False	None
/group/about/<id>	group.about	GET, HEAD, OPTIONS	False	None
/group/activity/<id>	activity.group_activity	GET, HEAD, OPTIONS	False	None
/group/admins/<id>	group.admins	GET, HEAD, OPTIONS, POST	False	None
/group/bulk_process/<id>	group.bulk_process	GET, HEAD, OPTIONS, POST	False	None
/group/changes/<id>	activity.group_changes	GET, HEAD, OPTIONS	False	None
/group/changes_multiple	activity.group_changes_multiple	GET, HEAD, OPTIONS	False	None
/group/delete/<id>	group.delete	GET, HEAD, OPTIONS, POST	False	None
/group/edit/<id>	group.edit	GET, HEAD, OPTIONS, POST	False	None
/group/follow/<id>	group.follow	OPTIONS, POST	False	None
/group/followers/<id>	group.followers	GET, HEAD, OPTIONS, POST	False	None
/group/manage_members/<id>	group.manage_members	GET, HEAD, OPTIONS, POST	False	None
/group/member_delete/<id>	group.member_delete	GET, HEAD, OPTIONS, POST	False	None
/group/member_dump/<id>	group.member_dump	GET, HEAD, OPTIONS	False	None
/group/member_new/<id>	group.member_new	GET, HEAD, OPTIONS, POST	False	None
/group/members/<id>	group.members	GET, HEAD, OPTIONS	False	None
/group/new	group.new	GET, HEAD, OPTIONS, POST	False	None
/group/unfollow/<id>	group.unfollow	OPTIONS, POST	False	None
/no/	home.redirect_locale	GET, HEAD, OPTIONS	False	None
/no/<path:path>	home.redirect_locale	GET, HEAD, OPTIONS	False	None
/organization/	organization.index	GET, HEAD, OPTIONS	False	None
/organization/<id>	organization.read	GET, HEAD, OPTIONS	False	None
/organization/about/<id>	organization.about	GET, HEAD, OPTIONS	False	None
/organization/activity/<id>	activity.organization_activity	GET, HEAD, OPTIONS	False	None
/organization/admins/<id>	organization.admins	GET, HEAD, OPTIONS, POST	False	None
/organization/bulk_process/<id>	organization.bulk_process	GET, HEAD, OPTIONS, POST	False	None
/organization/changes/<id>	activity.organization_changes	GET, HEAD, OPTIONS	False	None
/organization/changes_multiple	activity.organization_changes_multiple	GET, HEAD, OPTIONS	False	None
/organization/delete/<id>	organization.delete	GET, HEAD, OPTIONS, POST	False	None
/organization/edit/<id>	organization.edit	GET, HEAD, OPTIONS, POST	False	None
/organization/follow/<id>	organization.follow	OPTIONS, POST	False	None
/organization/followers/<id>	organization.followers	GET, HEAD, OPTIONS, POST	False	None
/organization/manage_members/<id>	organization.manage_members	GET, HEAD, OPTIONS, POST	False	None
/organization/member_delete/<id>	organization.member_delete	GET, HEAD, OPTIONS, POST	False	None
/organization/member_dump/<id>	organization.member_dump	GET, HEAD, OPTIONS	False	None
/organization/member_new/<id>	organization.member_new	GET, HEAD, OPTIONS, POST	False	None
/organization/members/<id>	organization.members	GET, HEAD, OPTIONS	False	None
/organization/new	organization.new	GET, HEAD, OPTIONS, POST	False	None
/organization/unfollow/<id>	organization.unfollow	OPTIONS, POST	False	None
/robots.txt	home.robots_txt	GET, HEAD, OPTIONS	False	None
/testing/primer	util.primer	GET, HEAD, OPTIONS	False	None
/user/	user.index	GET, HEAD, OPTIONS	False	None
/user/<id>	user.read	GET, HEAD, OPTIONS	False	None
/user/<id>/api-tokens	user.api_tokens	GET, HEAD, OPTIONS, POST	False	None
/user/<id>/api-tokens/<jti>/revoke	user.api_token_revoke	OPTIONS, POST	False	None
/user/<id>/groups	user.read_groups	GET, HEAD, OPTIONS	False	None
/user/<id>/organizations	user.read_organizations	GET, HEAD, OPTIONS	False	None
/user/_logout	user.logout	GET, HEAD, OPTIONS, POST	False	None
/user/activity/<id>	activity.user_activity	GET, HEAD, OPTIONS	False	None
/user/delete/<id>	user.delete	GET, HEAD, OPTIONS, POST	False	None
/user/edit	user.edit	GET, HEAD, OPTIONS, POST	False	None
/user/edit/<id>	user.edit	GET, HEAD, OPTIONS, POST	False	None
/user/follow/<id>	user.follow	OPTIONS, POST	False	None
/user/followers/<id>	user.followers	GET, HEAD, OPTIONS	False	None
/user/logged_out_redirect	user.logged_out_page	GET, HEAD, OPTIONS	False	None
/user/login	user.login	GET, HEAD, OPTIONS, POST	False	None
/user/me	user.me	GET, HEAD, OPTIONS	False	None
/user/register	user.register	GET, HEAD, OPTIONS, POST	False	None
/user/reset	user.request_reset	GET, HEAD, OPTIONS, POST	False	None
/user/reset/<id>	user.perform_reset	GET, HEAD, OPTIONS, POST	False	None
/user/sysadmin	user.sysadmin	OPTIONS, POST	False	None
/user/unfollow/<id>	user.unfollow	OPTIONS, POST	False	None
/util/redirect	util.internal_redirect	GET, HEAD, OPTIONS, POST	False	None
/webassets/<path:path>	webassets.index	GET, HEAD, OPTIONS	False	None
/zh_CN/	home.redirect_locale	GET, HEAD, OPTIONS	False	None
/zh_CN/<path:path>	home.redirect_locale	GET, HEAD, OPTIONS	False	None
/zh_TW/	home.redirect_locale	GET, HEAD, OPTIONS	False	None
/zh_TW/<path:path>	home.redirect_locale	GET, HEAD, OPTIONS	False	None