Defaulted Bills 5 Years or Newer

Dataset Info

Total Rows
171,796
Columns
23
Updated each Sunday for Roll Years 5 years old or newer - Info on secured annual bills that are unpaid and in default status. Current year overdue bills are not included.
Visit Dataset

AI Agent

Online
ATC OpenData Agent

SQL Expert • San Bernardino County

Hi, I'm ATC OpenData Agent!

I can help you explore this dataset, write SQL queries, and create visualizations. What would you like to know?

Chart Builder

Group your data by these columns (e.g., Year, Category, Name)
Numeric values to visualize (e.g., Amount, Count, Total)
5 20 100

Data Preview — 100 of 171,796 rows

Custom SQL Query SELECT Only
Query Error
Use [TableData] to reference the data table. Only SELECT queries are allowed.
Data preview table
Roll_YrTax_Rate_YrAssessment_YearAccount_NumberBill_NumberInstallment_NumberEscrow_CompanyTRA_CodeTRA_NameInstallment_BalanceBill_AmountBill_BalanceBalance_StatusAccount_StatusRollTransfer_DestinationBill_TypeBill_CategoryTax_Default_NumberTax_Default_DateRedemption_StatusRedemption_TotalIn_Active_Payment_Plan_
2021202120210108362080000202100001911-- None --004-091ONTARIO CITY1796.81012.293603.48UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0108362080000-000000000002020-07-01Active18505.24No
2021202120210108362080000202100001912-- None --004-091ONTARIO CITY1806.681012.223603.48UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0108362080000-000000000002020-07-01Active18505.24No
2021202120210110013730000202100016721-- None --004-002ONTARIO CITY443.14249.66896.23UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0110013730000-000000000002021-07-01Active4082.7No
2021202120210110013730000202100016722-- None --004-002ONTARIO CITY453.09249.63896.23UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0110013730000-000000000002021-07-01Active4082.7No
2021202120210110131240000202100019581-- None --004-001ONTARIO CITY18.7810.5947.48UnpaidUnpaidRedemptionRedemptionSecuredAnnual2014-0110131240000-000000000002014-07-01Active2030.95No
2021202120210110131240000202100019582-- None --004-001ONTARIO CITY28.710.5447.48UnpaidUnpaidRedemptionRedemptionSecuredAnnual2014-0110131240000-000000000002014-07-01Active2030.95No
2021202120210110202450000202100022401-- None --004-002ONTARIO CITY328.33184.98666.59UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0110202450000-000000000002021-07-01Active2683.74No
2021202120210110202450000202100022402-- None --004-002ONTARIO CITY338.26184.94666.59UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0110202450000-000000000002021-07-01Active2683.74No
2021202120210110322280000202100028181-- None --004-080ONTARIO CITY13.217.4536.41UnpaidUnpaidRedemptionRedemptionSecuredAnnual2013-0110322280000-000000000002013-07-01Active1895.72No
2021202120210110322280000202100028182-- None --004-080ONTARIO CITY23.27.4436.41UnpaidUnpaidRedemptionRedemptionSecuredAnnual2013-0110322280000-000000000002013-07-01Active1895.72No
2021202120210110332010000202100028301-- None --004-085ONTARIO CITY2700.331661.755410.65UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0110332010000-000000000002020-07-01Active23008.92Yes
2021202120210110332010000202100028302-- None --004-085ONTARIO CITY2710.321661.745410.65UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0110332010000-000000000002020-07-01Active23008.92Yes
2021202120210110332020000202100028311-- None --004-085ONTARIO CITY5133.513159.0910276.97UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0110332020000-000000000002020-07-01Active22987.58Yes
2021202120210110332020000202100028312-- None --004-085ONTARIO CITY5143.463159.0610276.97UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0110332020000-000000000002020-07-01Active22987.58Yes
2021202020200110361040000202108610861-- None --004-002ONTARIO CITY124.6278.14274.21UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0110361040000-000000000002023-07-01Active3357.28No
2021202020200110361040000202108610862-- None --004-002ONTARIO CITY149.5978.12274.21UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0110361040000-000000000002023-07-01Active3357.28No
2021202120210110361040000202108610871-- None --004-002ONTARIO CITY1536.55963.363083.07UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0110361040000-000000000002023-07-01Active3357.28No
2021202120210110361040000202108610872-- None --004-002ONTARIO CITY1546.52963.343083.07UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0110361040000-000000000002023-07-01Active3357.28No
2021202120210113415170000202100041551-- None --004-085ONTARIO CITY4211.452615.818447.81UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0113415170000-000000000002022-07-01Active92499.75Yes
2021202120210113415170000202100041552-- None --004-085ONTARIO CITY4236.362615.768447.81UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0113415170000-000000000002022-07-01Active92499.75Yes
2021202020200113415170000202109252081-- None --004-085ONTARIO CITY1024.08716.152058.1UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0113415170000-000000000002022-07-01Active92499.75Yes
2021202020200113415170000202109252082-- None --004-085ONTARIO CITY1034.02716.12058.1UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0113415170000-000000000002022-07-01Active92499.75Yes
2021202120210113415170000202109252091-- None --004-085ONTARIO CITY12858.598992.0325727.18UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0113415170000-000000000002022-07-01Active92499.75Yes
2021202120210113415170000202109252092-- None --004-085ONTARIO CITY12868.598992.0325727.18UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0113415170000-000000000002022-07-01Active92499.75Yes
2021202020200127052050000202108611661-- None --006-003RIALTO CITY633.22397.011291.43UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127052050000-000000000002023-07-01Active1291.43No
2021202020200127052050000202108611662-- None --006-003RIALTO CITY658.213971291.43UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127052050000-000000000002023-07-01Active1291.43No
2021202120210127123030000202100054061-- None --006-003RIALTO CITY1844.581039.23699.11UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0127123030000-000000000002021-07-01Active14460.8No
2021202120210127123030000202100054062-- None --006-003RIALTO CITY1854.531039.183699.11UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0127123030000-000000000002021-07-01Active14460.8No
2021202120210127152220000202100056241-- None --006-003RIALTO CITY02029.153626.71Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0127152220000-000000000002022-07-01Active3626.71No
2021202120210127152220000202100056242-- None --006-003RIALTO CITY3626.712029.143626.71UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0127152220000-000000000002022-07-01Active3626.71No
2021202020200127212200000202108612001-- None --006-003RIALTO CITY0407.67491.74Paid in FullUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127212200000-000000000002023-07-01Active1826.85Yes
2021202020200127212200000202108612002-- None --006-003RIALTO CITY491.74407.64491.74UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127212200000-000000000002023-07-01Active1826.85Yes
2021202120210127212200000202108612011-- None --006-003RIALTO CITY01596.071837.46Paid in FullUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127212200000-000000000002023-07-01Active1826.85Yes
2021202120210127212200000202108612012-- None --006-003RIALTO CITY1837.461596.041837.46UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127212200000-000000000002023-07-01Active1826.85Yes
2021202120210127294470000202109252401-- None --006-111RIALTO CITY1855.491163.323735.92UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127294470000-000000000002023-07-01Active3735.92No
2021202120210127294470000202109252402-- None --006-111RIALTO CITY1880.431163.293735.92UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0127294470000-000000000002023-07-01Active3735.92No
2021202020200127372100000202108257611-- None --006-000RIALTO CITY568.32320.191161.64UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0127372100000-000000000002022-07-01Active1161.64No
2021202020200127372100000202108257612-- None --006-000RIALTO CITY593.32320.191161.64UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0127372100000-000000000002022-07-01Active1161.64No
2021202120210127394060000202100068391-- None --006-111RIALTO CITY2429.891368.964884.78UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0127394060000-000000000002022-07-01Active17002.7No
2021202120210127394060000202100068392-- None --006-111RIALTO CITY2454.891368.964884.78UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0127394060000-000000000002022-07-01Active17002.7No
2021202120210127454130000202100072191-- None --006-111RIALTO CITY1002.55564.822015.08UnpaidUnpaidRedemptionRedemptionSecuredAnnual2019-0127454130000-000000000002019-07-01Active26492.57No
2021202120210127454130000202100072192-- None --006-111RIALTO CITY1012.53564.812015.08UnpaidUnpaidRedemptionRedemptionSecuredAnnual2019-0127454130000-000000000002019-07-01Active26492.57No
2021202120210127582170000202100081641-- None --006-111RIALTO CITY01862.543330.91Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0127582170000-000000000002022-07-01Active19770.4No
2021202120210127582170000202100081642-- None --006-111RIALTO CITY3330.911862.493330.91UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0127582170000-000000000002022-07-01Active19770.4No
2021202120210128062290000202100084201-- None --006-014RIALTO CITY3569.992011.277164.9UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128062290000-000000000002022-07-01Active24877.79No
2021202120210128062290000202100084202-- None --006-014RIALTO CITY3594.912011.227164.9UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128062290000-000000000002022-07-01Active24877.79No
2021202020200128271290000202108257731-- None --006-004RIALTO CITY2087.31175.954199.55UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0128271290000-000000000002022-07-01Active4199.55No
2021202020200128271290000202108257732-- None --006-004RIALTO CITY2112.251175.924199.55UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0128271290000-000000000002022-07-01Active4199.55No
2021202120210128322280000202100092731-- None --006-000RIALTO CITY01952.383490.43Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0128322280000-000000000002022-07-01Active20721.4No
2021202120210128322280000202100092732-- None --006-000RIALTO CITY3490.431952.363490.43UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128322280000-000000000002022-07-01Active20721.4No
2021202020200128351020000202108257771-- None --006-004RIALTO CITY1248.94703.632522.83UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0128351020000-000000000002022-07-01Active2522.83No
2021202020200128351020000202108257772-- None --006-004RIALTO CITY1273.89703.62522.83UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0128351020000-000000000002022-07-01Active2522.83No
2021202120210128381700000202100097131-- None --006-000RIALTO CITY5552.683128.2811130.33UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128381700000-000000000002022-07-01Active38212.39No
2021202120210128381700000202100097132-- None --006-000RIALTO CITY5577.653128.2611130.33UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128381700000-000000000002022-07-01Active38212.39No
2021202120210128431280000202109253491-- None --006-000RIALTO CITY2114.641799.74254.25UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128431280000-000000000002023-07-01Active1996.81Yes
2021202120210128431280000202109253492-- None --006-000RIALTO CITY2139.611799.684254.25UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128431280000-000000000002023-07-01Active1996.81Yes
2021202020200128462310000202108257871-- None --006-005RIALTO CITY2337.271316.784699.51UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0128462310000-000000000002022-07-01Active4699.51No
2021202020200128462310000202108257872-- None --006-005RIALTO CITY2362.241316.764699.51UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0128462310000-000000000002022-07-01Active4699.51No
2021202020200128551190000202108613641-- None --006-000RIALTO CITY904.365671833.67UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128551190000-000000000002023-07-01Active6033.16No
2021202020200128551190000202108613642-- None --006-000RIALTO CITY929.31566.971833.67UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128551190000-000000000002023-07-01Active6033.16No
2021202120210128551190000202108613651-- None --006-000RIALTO CITY2094.771313.344199.49UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128551190000-000000000002023-07-01Active6033.16No
2021202120210128551190000202108613652-- None --006-000RIALTO CITY2104.721313.314199.49UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128551190000-000000000002023-07-01Active6033.16No
2021202120210128641350000202100114241-- None --006-005RIALTO CITY4275.882408.958576.72UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128641350000-000000000002022-07-01Active17080.77No
2021202120210128641350000202100114242-- None --006-005RIALTO CITY4300.842408.938576.72UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128641350000-000000000002022-07-01Active17080.77No
2021202120210128651480000202100115091-- None --006-000RIALTO CITY01587.332842.45Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0128651480000-000000000002022-07-01Active16878.94No
2021202120210128651480000202100115092-- None --006-000RIALTO CITY2842.451587.32842.45UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128651480000-000000000002022-07-01Active16878.94No
2021202120210128671030000202100116031-- None --006-005RIALTO CITY3143.491770.996311.95UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128671030000-000000000002022-07-01Active21532.98No
2021202120210128671030000202100116032-- None --006-005RIALTO CITY3168.461770.976311.95UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0128671030000-000000000002022-07-01Active21532.98No
2021202120210128701300000202109253711-- None --006-000RIALTO CITY2613.431638.525251.81UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128701300000-000000000002023-07-01Active5251.81No
2021202120210128701300000202109253712-- None --006-000RIALTO CITY2638.381638.495251.81UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128701300000-000000000002023-07-01Active5251.81No
2021202020200128771080000202108614311-- None --006-000RIALTO CITY23.0414.4571.06UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128771080000-000000000002023-07-01Active218.37No
2021202020200128771080000202108614312-- None --006-000RIALTO CITY48.0214.4471.06UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128771080000-000000000002023-07-01Active218.37No
2021202120210128771080000202108614321-- None --006-000RIALTO CITY68.6743.06147.31UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128771080000-000000000002023-07-01Active218.37No
2021202120210128771080000202108614322-- None --006-000RIALTO CITY78.6443.04147.31UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2023-0128771080000-000000000002023-07-01Active218.37No
2021202120210130033310000202100125001-- None --006-088RIALTO CITY1394.87785.852799.71UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0130033310000-000000000002021-07-01Active12856.79No
2021202120210130033310000202100125002-- None --006-088RIALTO CITY1404.84785.832799.71UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0130033310000-000000000002021-07-01Active12856.79No
2021202120210130033320000202100125011-- None --006-088RIALTO CITY08371.3314884.07Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0130033320000-000000000002022-07-01Active88513.74No
2021202120210130033320000202100125012-- None --006-088RIALTO CITY14884.078371.3114884.07UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130033320000-000000000002022-07-01Active88513.74No
2021202020200130041210000202108258051-- None --006-088RIALTO CITY1294.28729.182613.54UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0130041210000-000000000002022-07-01Active2613.54No
2021202020200130041210000202108258052-- None --006-088RIALTO CITY1319.26729.172613.54UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0130041210000-000000000002022-07-01Active2613.54No
2021202120210130061260000202100126621-- None --006-111RIALTO CITY521.61293.871053.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0130061260000-000000000002021-07-01Active3935.5No
2021202120210130061260000202100126622-- None --006-111RIALTO CITY531.56293.841053.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual2021-0130061260000-000000000002021-07-01Active3935.5No
2021202120210130172330000202100129541-- None --006-088RIALTO CITY1573.74933.983172.44UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130172330000-000000000002022-07-01Active7181.13Yes
2021202120210130172330000202100129542-- None --006-088RIALTO CITY1598.7933.953172.44UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130172330000-000000000002022-07-01Active7181.13Yes
2021202120210130241290000202100130511-- None --006-088RIALTO CITY01173.422107.78Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0130241290000-000000000002022-07-01Active28530.5No
2021202120210130241290000202100130512-- None --006-088RIALTO CITY2107.781173.42107.78UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130241290000-000000000002022-07-01Active28530.5No
20212021202101302511600002021100627915802 - LERETA CORP006-088RIALTO CITY6028.263815.3612066.52UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0130251160000-000000000002020-07-01Active61016.25Yes
20212021202101302511600002021100627925802 - LERETA CORP006-088RIALTO CITY6038.263815.3612066.52UnpaidUnpaidRedemptionRedemptionSecuredAnnual2020-0130251160000-000000000002020-07-01Active61016.25Yes
2021202120210130251380000202100130771-- None --006-088RIALTO CITY02021.792946.43Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0130251380000-000000000002022-07-01Active5503.33Yes
2021202120210130251380000202100130772-- None --006-088RIALTO CITY2946.432021.762946.43UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130251380000-000000000002022-07-01Active5503.33Yes
2021202120210130291470000202108440151-- None --006-088RIALTO CITY01732.613100.36Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0130291470000-000000000002022-07-01Active7460.18No
2021202120210130291470000202108440152-- None --006-088RIALTO CITY3100.361732.63100.36UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130291470000-000000000002022-07-01Active7460.18No
2021202120210130291480000202108589661-- None --006-088RIALTO CITY02483.410697.07Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2022-0130291480000-000000000002022-07-01Active24520.32No
2021202120210130291480000202108589662-- None --006-088RIALTO CITY10697.079279.9710697.07UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0130291480000-000000000002022-07-01Active24520.32No
2021202120210130335050000202100132851-- None --006-000RIALTO CITY0967.931423.13Paid in FullUnpaidRedemptionRedemptionSecuredAnnual2019-0130335050000-000000000002019-07-01Active3460.07Yes
2021202120210130335050000202100132852-- None --006-000RIALTO CITY1423.13967.91423.13UnpaidUnpaidRedemptionRedemptionSecuredAnnual2019-0130335050000-000000000002019-07-01Active3460.07Yes
2021202120210131063380000202100144691-- None --006-088RIALTO CITY758.7427.441542.36UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0131063380000-000000000002022-07-01Active5325.64No
2021202120210131063380000202100144692-- None --006-088RIALTO CITY783.66427.421542.36UnpaidUnpaidRedemptionRedemptionSecuredAnnual2022-0131063380000-000000000002022-07-01Active5325.64No
2021202020200131092150000202108258181-- None --006-111RIALTO CITY0647.91174.99Paid in FullUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0131092150000-000000000002022-07-01Active1744.89No
2021202020200131092150000202108258182-- None --006-111RIALTO CITY1174.99647.891174.99UnpaidUnpaidRedemptionRedemptionSecured SupplementalSupplemental2022-0131092150000-000000000002022-07-01Active1744.89No