Defaulted Bills > 5 Yrs Old - Defaulted-Bills-5-Yrs-Old-Bill-Installments.db

Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)

Additional Information

Field	Value
Data last updated	October 1, 2025
Metadata last updated	October 1, 2025
Created	October 1, 2025
Format	SQLite
License	No License Provided
Has views	False
Id	ec4f653d-44fa-46d3-9df1-f4e2f81094e3
Package id	2805798c-e431-491a-b75c-f3ce07132466
Position	1
State	active
Tracking summary	{'total': 0, 'recent': 0}

Field

Value

Data last updated

October 1, 2025

Metadata last updated

October 1, 2025

Created

October 1, 2025

Format

SQLite

License

No License Provided

Has views

False

ec4f653d-44fa-46d3-9df1-f4e2f81094e3

Package id

2805798c-e431-491a-b75c-f3ce07132466

Position

State

active

Tracking summary

{'total': 0, 'recent': 0}

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
attrs	25.3.0	None	Classes Without Boilerplate
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
boto3	1.38.30	https://github.com/boto/boto3	The AWS SDK for Python
botocore	1.38.30	https://github.com/boto/botocore	Low-level, data-driven core of boto 3.
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
ckanext-pages	0.0.1	None	Custom pages for CKAN
ckanext-xloader	2.1.0	None	Express Loader - quickly load data into CKAN DataStore
ckantoolkit	0.0.7	https://github.com/ckan/ckantoolkit	None
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.8.2	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.
et_xmlfile	2.0.0	https://foss.heptapod.net/openpyxl/et_xmlfile	An implementation of lxml.xmlfile for the standard library
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)
ijson	3.4.0	None	Iterative JSON parser with standard Python iterator interfaces
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.1.0	None	brain-dead simple config-ini parsing
ipdb	0.13.13	https://github.com/gotcha/ipdb	IPython-enabled pdb
ipython	9.3.0	None	IPython: Productive Interactive Computing
ipython_pygments_lexers	1.1.1	None	Defines a variety of Pygments lexers for highlighting IPython code.
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.
jmespath	1.0.1	https://github.com/jmespath/jmespath.py	JSON Matching Expressions
jsonlines	4.0.0	https://github.com/wbolster/jsonlines	Library with helpers for the jsonlines file format
linear-tsv	1.1.0	https://github.com/solidsnack/tsv	Line-oriented, tab-separated value format
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.
openpyxl	3.1.5	https://openpyxl.readthedocs.io	A Python library to read/write Excel 2010 xlsx/xlsm files
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.1.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.6.0	None	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.51	None	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	14.0.0	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.
s3transfer	0.13.0	https://github.com/boto/s3transfer	An Amazon S3 Transfer Manager
setuptools	80.9.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	3.0.1	https://github.com/snowballstem/snowball	This package provides 32 stemmers for 30 languages generated from Snowball algorithms.
soupsieve	2.7	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
tabulator	1.53.5	https://github.com/frictionlessdata/tabulator-py	Consistent interface for stream reading and writing tabular data (csv/xls/json/etc)
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.20250516	None	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
unicodecsv	0.14.1	https://github.com/jdunck/python-unicodecsv	Python2's stdlib csv module is nice, but it doesn't support unicode. This module is a drop-in replacement which does.
Unidecode	1.0.22	UNKNOWN	ASCII transliterations of Unicode text
urllib3	2.2.2	None	HTTP library with thread-safe connection pooling, file post, and more.
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.45.1	None	A built-package format for Python
WTForms	3.1.2	None	Form validation and rendering for Python web development.
xlrd	2.0.1	http://www.python-excel.org/	Library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files
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	33.516 msec
System CPU time	2.178 msec
Total CPU time	35.694 msec
Elapsed time	41.709 msec
Context switches	24 voluntary, 0 involuntary

Key	Value
CONTENT_TYPE
HTTP_ACCEPT	/
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_HOST	opendata.sbcountyatc.gov
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
QUERY_STRING
REMOTE_ADDR	216.73.216.144
REQUEST_METHOD	GET
SCRIPT_NAME
SERVER_NAME	opendata.sbcountyatc.gov
SERVER_PORT	443
SERVER_PROTOCOL	HTTP/1.1

Variable	Value
csrf_token	<function generate_csrf at 0x71ced53c8540>
current_resource_view	None
current_user	<ckan.model.user.AnonymousUser object at 0x71ced2d359a0>
dataset_type	'dataset'
g	<flask.g of 'ckan.config.middleware.flask_app'>
package	{'author': None, 'author_email': None, 'creator_user_id': 'c4b1ecf4-142f-49c5-a221-58d906674aa3', 'id': '2805798c-e431-491a-b75c-f3ce07132466', 'isopen': False, 'license_id': None, 'license_title': None, 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2025-10-01T11:45:05.773805', 'metadata_modified': '2025-10-01T12:10:22.975457', 'name': '9bb708264b2811f08edbee73736cf94a', 'notes': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'num_resources': 6, 'num_tags': 2, 'organization': {'id': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'name': 'atc', 'title': 'ATC', 'type': 'organization', 'description': "The official website for the San Bernardino County Treasurer-Tax Collector's Office. It provides a convenient platform for residents to pay property taxes, search for tax bills, view payment history, and access important tax information. The site also offers resources for tax rates, deadlines, and payment options, ensuring transparency and ease of use for taxpayers.", 'image_url': '2025-06-26-171720.7318572025-02-03-210642.396764sb-logo-blue-1.png', 'created': '2025-06-26T17:17:20.743770', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'private': False, 'state': 'active', 'title': 'Defaulted Bills > 5 Yrs Old', 'type': 'dataset', 'url': None, 'version': None, 'extras': [{'key': 'columns', 'value': '[\n "Roll Yr",\n "Tax Rate Yr",\n "Tax Year",\n "Account Number",\n "Bill Number",\n "Installment Number",\n "Escrow Company",\n "TRA Code",\n "TRA Name",\n "Installment Balance",\n "Bill Amount",\n "Bill Balance",\n "Balance Status",\n "Account Status",\n "Roll",\n "Transfer Destination",\n "Bill Type",\n "Bill Category",\n "Tax Default Number",\n "Tax Default Date",\n "Redemption Status",\n "Redemption Total",\n "In Active Payment Plan?"\n ]'}, {'key': 'last_refreshed', 'value': '2025-10-01 04:32:02'}, {'key': 'uuid', 'value': '9BB70826-4B28-11F0-8EDB-EE73736CF94A'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:45:05.776573', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'format': 'CSV', 'hash': '', 'id': '5602e651-4e72-4592-8a2d-867cae013ad3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:45:05.765689', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://county-reports.com/ca-sanbernardino/Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:50:23.343093', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)', 'format': 'SQLite', 'hash': '', 'id': 'ec4f653d-44fa-46d3-9df1-f4e2f81094e3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:50:23.331409', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.db', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 1, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.db', 'url_type': None, 'has_views': False}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:55:25.842055', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (JSON format for web applications)', 'format': 'JSON', 'hash': '', 'id': 'd33fbfca-a8cd-487b-93b0-e48df2a35aea', 'last_modified': None, 'metadata_modified': '2025-10-01T11:55:25.828381', 'mimetype': 'application/json', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.json', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 2, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.json', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:00:25.007373', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (XML format for structured data exchange)', 'format': 'XML', 'hash': '', 'id': '3d3ca6f0-7cf2-4e8d-b3f2-36958b07ce21', 'last_modified': None, 'metadata_modified': '2025-10-01T12:00:24.997135', 'mimetype': 'application/xml', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.xml', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 3, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.xml', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:05:22.805687', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (TSV format for tab-separated data analysis)', 'format': 'TSV', 'hash': '', 'id': '57d52de5-4e0c-4bbe-bac9-746be9114ac6', 'last_modified': None, 'metadata_modified': '2025-10-01T12:05:22.799474', 'mimetype': 'text/tab-separated-values', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.tsv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 4, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.tsv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:10:22.987009', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (Parquet format for efficient columnar data storage)', 'format': 'PARQUET', 'hash': '', 'id': '9a2a0350-448f-487e-b70e-2234be0ba863', 'last_modified': None, 'metadata_modified': '2025-10-01T12:10:22.980818', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.parquet', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 5, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.parquet', 'url_type': None}], 'tags': [{'display_name': 'Open-Data', 'id': 'deeacb4c-3824-4648-b165-f696f19945bf', 'name': 'Open-Data', 'state': 'active', 'vocabulary_id': None}, {'display_name': 'Tax Collector Open Data', 'id': 'ab6acf0d-4cd6-4512-8b96-19857e33151f', 'name': 'Tax Collector Open Data', 'state': 'active', 'vocabulary_id': None}], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': [], 'tracking_summary': {'total': 0, 'recent': 0}}
pkg	<Package id=2805798c-e431-491a-b75c-f3ce07132466 name=9bb708264b2811f08edbee73736cf94a title=Defaulted Bills > 5 Yrs Old version=None url=None author=None author_email=None maintainer=None maintainer_email=None notes=Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. license_id=None type=dataset owner_org=bbe4322c-6aeb-41bf-ad08-1579339624da creator_user_id=c4b1ecf4-142f-49c5-a221-58d906674aa3 metadata_created=2025-10-01 11:45:05.773805 metadata_modified=2025-10-01 12:10:22.975457 private=False state=active plugin_data=None>
pkg_dict	{'author': None, 'author_email': None, 'creator_user_id': 'c4b1ecf4-142f-49c5-a221-58d906674aa3', 'id': '2805798c-e431-491a-b75c-f3ce07132466', 'isopen': False, 'license_id': None, 'license_title': None, 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2025-10-01T11:45:05.773805', 'metadata_modified': '2025-10-01T12:10:22.975457', 'name': '9bb708264b2811f08edbee73736cf94a', 'notes': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'num_resources': 6, 'num_tags': 2, 'organization': {'id': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'name': 'atc', 'title': 'ATC', 'type': 'organization', 'description': "The official website for the San Bernardino County Treasurer-Tax Collector's Office. It provides a convenient platform for residents to pay property taxes, search for tax bills, view payment history, and access important tax information. The site also offers resources for tax rates, deadlines, and payment options, ensuring transparency and ease of use for taxpayers.", 'image_url': '2025-06-26-171720.7318572025-02-03-210642.396764sb-logo-blue-1.png', 'created': '2025-06-26T17:17:20.743770', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'private': False, 'state': 'active', 'title': 'Defaulted Bills > 5 Yrs Old', 'type': 'dataset', 'url': None, 'version': None, 'extras': [{'key': 'columns', 'value': '[\n "Roll Yr",\n "Tax Rate Yr",\n "Tax Year",\n "Account Number",\n "Bill Number",\n "Installment Number",\n "Escrow Company",\n "TRA Code",\n "TRA Name",\n "Installment Balance",\n "Bill Amount",\n "Bill Balance",\n "Balance Status",\n "Account Status",\n "Roll",\n "Transfer Destination",\n "Bill Type",\n "Bill Category",\n "Tax Default Number",\n "Tax Default Date",\n "Redemption Status",\n "Redemption Total",\n "In Active Payment Plan?"\n ]'}, {'key': 'last_refreshed', 'value': '2025-10-01 04:32:02'}, {'key': 'uuid', 'value': '9BB70826-4B28-11F0-8EDB-EE73736CF94A'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:45:05.776573', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'format': 'CSV', 'hash': '', 'id': '5602e651-4e72-4592-8a2d-867cae013ad3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:45:05.765689', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://county-reports.com/ca-sanbernardino/Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:50:23.343093', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)', 'format': 'SQLite', 'hash': '', 'id': 'ec4f653d-44fa-46d3-9df1-f4e2f81094e3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:50:23.331409', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.db', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 1, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.db', 'url_type': None, 'has_views': False}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:55:25.842055', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (JSON format for web applications)', 'format': 'JSON', 'hash': '', 'id': 'd33fbfca-a8cd-487b-93b0-e48df2a35aea', 'last_modified': None, 'metadata_modified': '2025-10-01T11:55:25.828381', 'mimetype': 'application/json', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.json', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 2, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.json', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:00:25.007373', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (XML format for structured data exchange)', 'format': 'XML', 'hash': '', 'id': '3d3ca6f0-7cf2-4e8d-b3f2-36958b07ce21', 'last_modified': None, 'metadata_modified': '2025-10-01T12:00:24.997135', 'mimetype': 'application/xml', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.xml', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 3, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.xml', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:05:22.805687', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (TSV format for tab-separated data analysis)', 'format': 'TSV', 'hash': '', 'id': '57d52de5-4e0c-4bbe-bac9-746be9114ac6', 'last_modified': None, 'metadata_modified': '2025-10-01T12:05:22.799474', 'mimetype': 'text/tab-separated-values', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.tsv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 4, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.tsv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:10:22.987009', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (Parquet format for efficient columnar data storage)', 'format': 'PARQUET', 'hash': '', 'id': '9a2a0350-448f-487e-b70e-2234be0ba863', 'last_modified': None, 'metadata_modified': '2025-10-01T12:10:22.980818', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.parquet', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 5, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.parquet', 'url_type': None}], 'tags': [{'display_name': 'Open-Data', 'id': 'deeacb4c-3824-4648-b165-f696f19945bf', 'name': 'Open-Data', 'state': 'active', 'vocabulary_id': None}, {'display_name': 'Tax Collector Open Data', 'id': 'ab6acf0d-4cd6-4512-8b96-19857e33151f', 'name': 'Tax Collector Open Data', 'state': 'active', 'vocabulary_id': None}], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': [], 'tracking_summary': {'total': 0, 'recent': 0}}
request	<Request 'https://opendata.sbcountyatc.gov/dataset/2805798c-e431-491a-b75c-f3ce07132466/resource/ec4f653d-44fa-46d3-9df1-f4e2f81094e3' [GET]>
resource	{'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:50:23.343093', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)', 'format': 'SQLite', 'hash': '', 'id': 'ec4f653d-44fa-46d3-9df1-f4e2f81094e3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:50:23.331409', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.db', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 1, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.db', 'url_type': None, 'has_views': False}
resource_views	[]
session	<SecureCookieSession {'_csrf_token': '3d81f77b63200f6449e1fcdb60a8769e877c6157'}>

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
/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
/data-api/	pages.data_api	GET, HEAD, OPTIONS	False	None
/dataset/	dataset.search	GET, HEAD, OPTIONS	False	None
/dataset/<id>	dataset.read	GET, HEAD, OPTIONS	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
/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
/metrics/	pages.metrics	GET, HEAD, OPTIONS	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-guide/	pages.user_guide	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

Menu

Defaulted-Bills-5-Yrs-Old-Bill-Installments.db

Additional Information

Versions

Installed Packages

Resource Usage

HTTP Headers

Request Vars

View information

COOKIES Variables

SESSION Variables

GET Variables

POST Variables

Config

Templates

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:jB-yP9UdbyONHuObMFgSXDz6iCI'`
api_token.jwt.encode.secret	`'string:jB-yP9UdbyONHuObMFgSXDz6iCI'`
api_token.nbytes	`32`
apitoken_header_name	`'Authorization'`
APPLICATION_ROOT	`'/'`
BABEL_DEFAULT_TIMEZONE	`'UTC'`
BABEL_DOMAIN	`'ckan'`
BABEL_TRANSLATION_DIRECTORIES	`'/usr/lib/ckan/default/src/ckan/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	`False`
ckan.auth.allow_dataset_collaborators	`True`
ckan.auth.anon_create_dataset	`False`
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	`False`
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	`False`
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	`True`
ckan.cache_expires	`600`
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.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	`False`
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	`['default']`
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	`2`
ckan.max_resource_size	`10`
ckan.mimetype_guess	`'file_ext'`
ckan.plugins	`['activity', 'pages', 'tracking']`
ckan.recaptcha.privatekey	`''`
ckan.recaptcha.publickey	`''`
ckan.redis.url	`'redis://localhost:6379/0'`
ckan.requests.timeout	`5`
ckan.resource_formats	`'/usr/lib/ckan/default/src/ckan/ckan/config/resource_formats.json'`
ckan.root_path	`''`
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	`''`
ckan.site_custom_css	`''`
ckan.site_description	`''`
ckan.site_id	`'default'`
ckan.site_intro_text	`''`
ckan.site_logo	`'/base/images/ckan-logo.png'`
ckan.site_title	`'ATC OpenData'`
ckan.site_url	`'https://opendata.sbcountyatc.gov'`
ckan.static_max_age	`3600`
ckan.storage_path	`'/var/lib/ckan/default'`
ckan.template_title_delimiter	`'-'`
ckan.theme	`'css/main'`
ckan.tracking.enabled	`'true'`
ckan.tracking.frequency	`'1h'`
ckan.tracking.summary.all	`'true'`
ckan.tracking.summary.recent	`'14'`
ckan.tracking.summary.recent_views	`'true'`
ckan.tracking.type	`'click'`
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/src/ckan/ckanext/activity/templates', '/usr/lib/ckan/default/src/ckan/ckanext-pages/ckanext/pages/templates', '/usr/lib/ckan/default/src/ckan/ckanext/tracking/templates', '/usr/lib/ckan/default/src/ckan/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/src/ckan/ckanext/activity/public', '/usr/lib/ckan/default/src/ckan/ckanext-pages/ckanext/pages/public']`
plugin_template_paths	`['/usr/lib/ckan/default/src/ckan/ckanext/activity/templates', '/usr/lib/ckan/default/src/ckan/ckanext-pages/ckanext/pages/templates', '/usr/lib/ckan/default/src/ckan/ckanext/tracking/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	`'jB-yP9UdbyONHuObMFgSXDz6iCI'`
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://127.0.0.1:8983/solr/ckan'`
solr_user	`''`
sqlalchemy.pool_pre_ping	`True`
sqlalchemy.url	`'postgresql://ckansql:1DevTest@localhost/ckandb'`
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	`{'POST', 'PUT', 'DELETE', 'PATCH'}`
WTF_CSRF_SECRET_KEY	`'string:jB-yP9UdbyONHuObMFgSXDz6iCI'`
WTF_CSRF_SSL_STRICT	`True`
WTF_CSRF_TIME_LIMIT	`3600`
WTF_I18N_ENABLED	`True`

Key	Value
__timer	1761503668.0647147
_csrf_token	IjNkODFmNzdiNjMyMDBmNjQ0OWUxZmNkYjYwYTg3NjllODc3YzYxNTci.aP5ptA.b9YRoRJG6ldKEt3YqE-YnfgQ3gw
_flask_babel	namespace(babel_domain=<Domain(None, ['ckan'])>, babel_locale=Locale('en'), babel_tzinfo=<UTC>)
_login_user	<ckan.model.user.AnonymousUser object at 0x71ced2d359a0>
_webassets	{'style': [], 'script': [], 'included': {'vendor/jquery', 'ckanext-activity/activity', 'vendor/fontawesome', 'vendor/vendor', 'vendor/bootstrap', 'css/main', 'tracking/tracking', 'vendor/htmx', 'vendor/select2-css', 'base/ckan', 'ckanext-activity/activity-css', 'base/main'}}
author	216.73.216.144
blueprint	dataset_resource
csrf_field_name	_csrf_token
debug_toolbar	<flask_debugtoolbar.DebugToolbarExtension object at 0x71ced4c7d6a0>
login_via_auth_header	True
package	{'author': None, 'author_email': None, 'creator_user_id': 'c4b1ecf4-142f-49c5-a221-58d906674aa3', 'id': '2805798c-e431-491a-b75c-f3ce07132466', 'isopen': False, 'license_id': None, 'license_title': None, 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2025-10-01T11:45:05.773805', 'metadata_modified': '2025-10-01T12:10:22.975457', 'name': '9bb708264b2811f08edbee73736cf94a', 'notes': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'num_resources': 6, 'num_tags': 2, 'organization': {'id': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'name': 'atc', 'title': 'ATC', 'type': 'organization', 'description': "The official website for the San Bernardino County Treasurer-Tax Collector's Office. It provides a convenient platform for residents to pay property taxes, search for tax bills, view payment history, and access important tax information. The site also offers resources for tax rates, deadlines, and payment options, ensuring transparency and ease of use for taxpayers.", 'image_url': '2025-06-26-171720.7318572025-02-03-210642.396764sb-logo-blue-1.png', 'created': '2025-06-26T17:17:20.743770', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'private': False, 'state': 'active', 'title': 'Defaulted Bills > 5 Yrs Old', 'type': 'dataset', 'url': None, 'version': None, 'extras': [{'key': 'columns', 'value': '[\n "Roll Yr",\n "Tax Rate Yr",\n "Tax Year",\n "Account Number",\n "Bill Number",\n "Installment Number",\n "Escrow Company",\n "TRA Code",\n "TRA Name",\n "Installment Balance",\n "Bill Amount",\n "Bill Balance",\n "Balance Status",\n "Account Status",\n "Roll",\n "Transfer Destination",\n "Bill Type",\n "Bill Category",\n "Tax Default Number",\n "Tax Default Date",\n "Redemption Status",\n "Redemption Total",\n "In Active Payment Plan?"\n ]'}, {'key': 'last_refreshed', 'value': '2025-10-01 04:32:02'}, {'key': 'uuid', 'value': '9BB70826-4B28-11F0-8EDB-EE73736CF94A'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:45:05.776573', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'format': 'CSV', 'hash': '', 'id': '5602e651-4e72-4592-8a2d-867cae013ad3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:45:05.765689', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://county-reports.com/ca-sanbernardino/Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:50:23.343093', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)', 'format': 'SQLite', 'hash': '', 'id': 'ec4f653d-44fa-46d3-9df1-f4e2f81094e3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:50:23.331409', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.db', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 1, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.db', 'url_type': None, 'has_views': False}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:55:25.842055', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (JSON format for web applications)', 'format': 'JSON', 'hash': '', 'id': 'd33fbfca-a8cd-487b-93b0-e48df2a35aea', 'last_modified': None, 'metadata_modified': '2025-10-01T11:55:25.828381', 'mimetype': 'application/json', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.json', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 2, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.json', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:00:25.007373', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (XML format for structured data exchange)', 'format': 'XML', 'hash': '', 'id': '3d3ca6f0-7cf2-4e8d-b3f2-36958b07ce21', 'last_modified': None, 'metadata_modified': '2025-10-01T12:00:24.997135', 'mimetype': 'application/xml', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.xml', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 3, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.xml', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:05:22.805687', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (TSV format for tab-separated data analysis)', 'format': 'TSV', 'hash': '', 'id': '57d52de5-4e0c-4bbe-bac9-746be9114ac6', 'last_modified': None, 'metadata_modified': '2025-10-01T12:05:22.799474', 'mimetype': 'text/tab-separated-values', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.tsv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 4, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.tsv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:10:22.987009', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (Parquet format for efficient columnar data storage)', 'format': 'PARQUET', 'hash': '', 'id': '9a2a0350-448f-487e-b70e-2234be0ba863', 'last_modified': None, 'metadata_modified': '2025-10-01T12:10:22.980818', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.parquet', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 5, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.parquet', 'url_type': None}], 'tags': [{'display_name': 'Open-Data', 'id': 'deeacb4c-3824-4648-b165-f696f19945bf', 'name': 'Open-Data', 'state': 'active', 'vocabulary_id': None}, {'display_name': 'Tax Collector Open Data', 'id': 'ab6acf0d-4cd6-4512-8b96-19857e33151f', 'name': 'Tax Collector Open Data', 'state': 'active', 'vocabulary_id': None}], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': [], 'tracking_summary': {'total': 0, 'recent': 0}}
pkg	<Package id=2805798c-e431-491a-b75c-f3ce07132466 name=9bb708264b2811f08edbee73736cf94a title=Defaulted Bills > 5 Yrs Old version=None url=None author=None author_email=None maintainer=None maintainer_email=None notes=Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. license_id=None type=dataset owner_org=bbe4322c-6aeb-41bf-ad08-1579339624da creator_user_id=c4b1ecf4-142f-49c5-a221-58d906674aa3 metadata_created=2025-10-01 11:45:05.773805 metadata_modified=2025-10-01 12:10:22.975457 private=False state=active plugin_data=None>
pkg_dict	{'author': None, 'author_email': None, 'creator_user_id': 'c4b1ecf4-142f-49c5-a221-58d906674aa3', 'id': '2805798c-e431-491a-b75c-f3ce07132466', 'isopen': False, 'license_id': None, 'license_title': None, 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2025-10-01T11:45:05.773805', 'metadata_modified': '2025-10-01T12:10:22.975457', 'name': '9bb708264b2811f08edbee73736cf94a', 'notes': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'num_resources': 6, 'num_tags': 2, 'organization': {'id': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'name': 'atc', 'title': 'ATC', 'type': 'organization', 'description': "The official website for the San Bernardino County Treasurer-Tax Collector's Office. It provides a convenient platform for residents to pay property taxes, search for tax bills, view payment history, and access important tax information. The site also offers resources for tax rates, deadlines, and payment options, ensuring transparency and ease of use for taxpayers.", 'image_url': '2025-06-26-171720.7318572025-02-03-210642.396764sb-logo-blue-1.png', 'created': '2025-06-26T17:17:20.743770', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'bbe4322c-6aeb-41bf-ad08-1579339624da', 'private': False, 'state': 'active', 'title': 'Defaulted Bills > 5 Yrs Old', 'type': 'dataset', 'url': None, 'version': None, 'extras': [{'key': 'columns', 'value': '[\n "Roll Yr",\n "Tax Rate Yr",\n "Tax Year",\n "Account Number",\n "Bill Number",\n "Installment Number",\n "Escrow Company",\n "TRA Code",\n "TRA Name",\n "Installment Balance",\n "Bill Amount",\n "Bill Balance",\n "Balance Status",\n "Account Status",\n "Roll",\n "Transfer Destination",\n "Bill Type",\n "Bill Category",\n "Tax Default Number",\n "Tax Default Date",\n "Redemption Status",\n "Redemption Total",\n "In Active Payment Plan?"\n ]'}, {'key': 'last_refreshed', 'value': '2025-10-01 04:32:02'}, {'key': 'uuid', 'value': '9BB70826-4B28-11F0-8EDB-EE73736CF94A'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:45:05.776573', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.', 'format': 'CSV', 'hash': '', 'id': '5602e651-4e72-4592-8a2d-867cae013ad3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:45:05.765689', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 0, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://county-reports.com/ca-sanbernardino/Defaulted-Bills-5-Yrs-Old-Bill-Installments.csv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:50:23.343093', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)', 'format': 'SQLite', 'hash': '', 'id': 'ec4f653d-44fa-46d3-9df1-f4e2f81094e3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:50:23.331409', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.db', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 1, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.db', 'url_type': None, 'has_views': False}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:55:25.842055', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (JSON format for web applications)', 'format': 'JSON', 'hash': '', 'id': 'd33fbfca-a8cd-487b-93b0-e48df2a35aea', 'last_modified': None, 'metadata_modified': '2025-10-01T11:55:25.828381', 'mimetype': 'application/json', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.json', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 2, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.json', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:00:25.007373', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (XML format for structured data exchange)', 'format': 'XML', 'hash': '', 'id': '3d3ca6f0-7cf2-4e8d-b3f2-36958b07ce21', 'last_modified': None, 'metadata_modified': '2025-10-01T12:00:24.997135', 'mimetype': 'application/xml', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.xml', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 3, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.xml', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:05:22.805687', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (TSV format for tab-separated data analysis)', 'format': 'TSV', 'hash': '', 'id': '57d52de5-4e0c-4bbe-bac9-746be9114ac6', 'last_modified': None, 'metadata_modified': '2025-10-01T12:05:22.799474', 'mimetype': 'text/tab-separated-values', 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.tsv', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 4, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.tsv', 'url_type': None}, {'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T12:10:22.987009', 'datastore_active': False, 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (Parquet format for efficient columnar data storage)', 'format': 'PARQUET', 'hash': '', 'id': '9a2a0350-448f-487e-b70e-2234be0ba863', 'last_modified': None, 'metadata_modified': '2025-10-01T12:10:22.980818', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.parquet', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 5, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.parquet', 'url_type': None}], 'tags': [{'display_name': 'Open-Data', 'id': 'deeacb4c-3824-4648-b165-f696f19945bf', 'name': 'Open-Data', 'state': 'active', 'vocabulary_id': None}, {'display_name': 'Tax Collector Open Data', 'id': 'ab6acf0d-4cd6-4512-8b96-19857e33151f', 'name': 'Tax Collector Open Data', 'state': 'active', 'vocabulary_id': None}], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': [], 'tracking_summary': {'total': 0, 'recent': 0}}
remote_addr	216.73.216.144
resource	{'cache_last_updated': None, 'cache_url': None, 'created': '2025-10-01T11:50:23.343093', 'description': 'Updated on 1st of month for Roll Years more than 5 years old - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included. (SQLite Database format for querying)', 'format': 'SQLite', 'hash': '', 'id': 'ec4f653d-44fa-46d3-9df1-f4e2f81094e3', 'last_modified': None, 'metadata_modified': '2025-10-01T11:50:23.331409', 'mimetype': None, 'mimetype_inner': None, 'name': 'Defaulted-Bills-5-Yrs-Old-Bill-Installments.db', 'package_id': '2805798c-e431-491a-b75c-f3ce07132466', 'position': 1, 'resource_type': None, 'size': None, 'state': 'active', 'tracking_summary': {'total': 0, 'recent': 0}, 'url': 'https://opendata.sbcountyatc.gov/atc-api/download/2805798c-e431-491a-b75c-f3ce07132466/9bb708264b2811f08edbee73736cf94a.db', 'url_type': None, 'has_views': False}
user
userobj
view	read