Defaulted Bills > 5 Yrs Old

Dataset Info

Total Rows
45,520
Columns
23
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.
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 45,520 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_
1984198419840171211265008198401594791-- None --005-001REDLANDS CITY610.5172.381245.94UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1984198419840171211265008198401594792-- None --005-001REDLANDS CITY635.4372.371245.94UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
198419841984105728111P000198407349891-- None --061-001CHINO UNIFIED12352.211464.424729.5UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-1057281111000-000000000001985-07-01Active314406No
198419841984105728111P000198407349892-- None --061-001CHINO UNIFIED12377.291464.4124729.5UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-1057281111000-000000000001985-07-01Active314406No
1985198519850171211265008198501336571-- None --005-001REDLANDS CITY591.7171.681193.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1985198519850171211265008198501336572-- None --005-001REDLANDS CITY601.4671.651193.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
198519851985105728111P000198507031821-- None --061-001CHINO UNIFIED12358.881497.1424727.68UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-1057281111000-000000000001985-07-01Active314406No
198519851985105728111P000198507031822-- None --061-001CHINO UNIFIED12368.81497.1324727.68UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-1057281111000-000000000001985-07-01Active314406No
1986198619860171211265008198601153961-- None --005-001REDLANDS CITY581.7172.041173.18UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1986198619860171211265008198601153962-- None --005-001REDLANDS CITY591.4772.011173.18UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1986198619861200421060000198602226201-- None --107-032SAN BERNARDINO UNIFIED098.081279.66Paid in FullUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1986198619861200421060000198602226202-- None --107-032SAN BERNARDINO UNIFIED1279.6698.041279.66UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1987198719870171211265008198700686411-- None --005-001REDLANDS CITY569.0672.081148.12UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1987198719870171211265008198700686412-- None --005-001REDLANDS CITY579.0672.081148.12UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1987198719871200421060000198701873461-- None --107-032SAN BERNARDINO UNIFIED764.2396.81538.22UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1987198719871200421060000198701873462-- None --107-032SAN BERNARDINO UNIFIED773.9996.771538.22UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1988198819880171211265008198800693851-- None --005-001REDLANDS CITY583.0175.571175.87UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1988198819880171211265008198800693852-- None --005-001REDLANDS CITY592.8675.551175.87UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1988198819881020263250000198805723291-- None --001-001CHINO CITY101.9113.211301.58UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1988198819881020263250000198805723292-- None --001-001CHINO CITY1199.6713.181301.58UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1988198819881200421060000198801922531-- None --018-050HIGHLAND CITY165.0121.39339.94UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1988198819881200421060000198801922532-- None --018-050HIGHLAND CITY174.9321.38339.94UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1989198919890127611090000198900478101-- None --006-000RIALTO CITY91.8412.191281.68UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1989198919890127611090000198900478102-- None --006-000RIALTO CITY1189.8412.191281.68UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1989198919890136061320000198900593491-- None --007-001SAN BERNARDINO CITY28.253.751154.5UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0136061320000-000000000001990-07-01Active5777.09No
1989198919890136061320000198900593492-- None --007-001SAN BERNARDINO CITY1126.253.751154.5UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0136061320000-000000000001990-07-01Active5777.09No
1989198919890171211265008198901101201-- None --005-001REDLANDS CITY582.9777.371175.64UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1989198919890171211265008198901101202-- None --005-001REDLANDS CITY592.6777.331175.64UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1989198919891020263250000198906204261-- None --001-001CHINO CITY99.6113.22208.98UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1989198919891020263250000198906204262-- None --001-001CHINO CITY109.3713.19208.98UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1989198919891200421060000198902336841-- None --018-050HIGHLAND CITY240.4431.91490.64UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1989198919891200421060000198902336842-- None --018-050HIGHLAND CITY250.231.88490.64UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1989198919893067071240000198903590931-- None --101-014SNOWLINE UNIFIED43.75.81185.4UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0401321490000-000000000001990-07-01Active2927.77No
1989198919893067071240000198903590932-- None --101-014SNOWLINE UNIFIED1141.75.81185.4UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0401321490000-000000000001990-07-01Active2927.77No
1989198919893067071250000198903590941-- None --101-014SNOWLINE UNIFIED43.75.81185.4UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0401321500000-000000000001990-07-01Active2927.77No
1989198919893067071250000198903590942-- None --101-014SNOWLINE UNIFIED1141.75.81185.4UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0401321500000-000000000001990-07-01Active2927.77No
1990199019900127611090000199000080051-- None --006-000RIALTO CITY84.2811.46178.48UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1990199019900127611090000199000080052-- None --006-000RIALTO CITY94.211.45178.48UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1990199019900135191070000199000193871-- None --007-062SAN BERNARDINO CITY99.6513.551297.08UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0135191070000-000000000001991-07-01Active12190.53No
1990199019900135191070000199000193872-- None --007-062SAN BERNARDINO CITY1197.4313.521297.08UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0135191070000-000000000001991-07-01Active12190.53No
1990199019900136061320000199000197711-- None --007-001SAN BERNARDINO CITY27.643.7665.21UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0136061320000-000000000001990-07-01Active5777.09No
1990199019900136061320000199000197712-- None --007-001SAN BERNARDINO CITY37.573.7565.21UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0136061320000-000000000001990-07-01Active5777.09No
1990199019900136391180000199000206891-- None --007-007SAN BERNARDINO CITY93.6912.741285.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0136391180000-000000000001991-07-01Active5315.47No
1990199019900136391180000199000206892-- None --007-007SAN BERNARDINO CITY1191.4812.711285.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0136391180000-000000000001991-07-01Active5315.47No
1990199019900138013130000199000219281-- None --007-001SAN BERNARDINO CITY88.8925.62202.75UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0138013130000-000000000001991-07-01Active1281.43No
1990199019900138013130000199000219282-- None --007-001SAN BERNARDINO CITY113.8625.61202.75UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0138013130000-000000000001991-07-01Active1281.43No
19901990199001402314500001990002694818888 - NO ACTIVE BILLED OWNER007-001SAN BERNARDINO CITY93.6912.741285.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0140231450000-000000000001991-07-01Active5503.05No
19901990199001402314500001990002694828888 - NO ACTIVE BILLED OWNER007-001SAN BERNARDINO CITY1191.4812.711285.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0140231450000-000000000001991-07-01Active5503.05No
1990199019900171211265008199000711951-- None --005-001REDLANDS CITY577.4478.511164.72UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1990199019900171211265008199000711952-- None --005-001REDLANDS CITY587.2878.491164.72UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1990199019900467831430000199004303591-- None --078-005HELENDALE ELEM094.131079.95Paid in FullUnpaidRedemptionRedemptionSecuredAnnual1991-0467811530000-000000000001991-07-01Active1755.1No
1990199019900467831430000199004303592-- None --078-005HELENDALE ELEM1079.9594.081079.95UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0467811530000-000000000001991-07-01Active1755.1No
1990199019901020263250000199005913161-- None --001-001CHINO CITY97.313.23204.38UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1990199019901020263250000199005913162-- None --001-001CHINO CITY107.0813.2204.38UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1990199019901200421060000199002006391-- None --018-050HIGHLAND CITY230.531.34470.78UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1990199019901200421060000199002006392-- None --018-050HIGHLAND CITY240.2831.31470.78UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1991199119910127611090000199100080341-- None --006-000RIALTO CITY82.2111.46174.35UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1991199119910127611090000199100080342-- None --006-000RIALTO CITY92.1411.45174.35UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1991199119910135191070000199100194841-- None --007-062SAN BERNARDINO CITY99.1513.82208.16UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0135191070000-000000000001991-07-01Active12190.53No
1991199119910135191070000199100194842-- None --007-062SAN BERNARDINO CITY109.0113.8208.16UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0135191070000-000000000001991-07-01Active12190.53No
1991199119910136061320000199100198671-- None --007-185SAN BERNARDINO CITY26.973.7663.94UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0136061320000-000000000001990-07-01Active5777.09No
1991199119910136061320000199100198672-- None --007-185SAN BERNARDINO CITY36.973.7663.94UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0136061320000-000000000001990-07-01Active5777.09No
1991199119910136391180000199100207871-- None --007-007SAN BERNARDINO CITY93.1212.98196.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0136391180000-000000000001991-07-01Active5315.47No
1991199119910136391180000199100207872-- None --007-007SAN BERNARDINO CITY103.0512.97196.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0136391180000-000000000001991-07-01Active5315.47No
1991199119910138013130000199100220231-- None --007-001SAN BERNARDINO CITY85.9326.12181.83UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0138013130000-000000000001991-07-01Active1281.43No
1991199119910138013130000199100220232-- None --007-001SAN BERNARDINO CITY95.926.11181.83UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0138013130000-000000000001991-07-01Active1281.43No
19911991199101402314500001991002703118888 - NO ACTIVE BILLED OWNER007-185SAN BERNARDINO CITY93.1212.98196.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0140231450000-000000000001991-07-01Active5503.05No
19911991199101402314500001991002703128888 - NO ACTIVE BILLED OWNER007-185SAN BERNARDINO CITY103.0512.97196.17UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0140231450000-000000000001991-07-01Active5503.05No
199119911991014824116P004199100416641-- None --007-001SAN BERNARDINO CITY3317.56462.386659.98UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0148241161000-000000000001992-07-01Active14589.09No
199119911991014824116P004199100416642-- None --007-001SAN BERNARDINO CITY3342.42462.366659.98UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0148241161000-000000000001992-07-01Active14589.09No
1991199119910171211265008199100718971-- None --005-001REDLANDS CITY569.6179.391149.08UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1991199119910171211265008199100718972-- None --005-001REDLANDS CITY579.4779.371149.08UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-0171211265008-000000000001985-07-01Active19378.53No
1991199119910307071710000199102309311-- None --017-004BIG BEAR LAKE CITY302.0642.11702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071710000-000000000001992-07-01Active4227.34No
1991199119910307071710000199102309312-- None --017-004BIG BEAR LAKE CITY1399.9842.091702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071710000-000000000001992-07-01Active4227.34No
1991199119910307071730000199102309841-- None --017-004BIG BEAR LAKE CITY302.0642.11702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071730000-000000000001992-07-01Active4227.34No
1991199119910307071730000199102309842-- None --017-004BIG BEAR LAKE CITY1399.9842.091702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071730000-000000000001992-07-01Active4227.34No
1991199119910307071760000199102311401-- None --017-004BIG BEAR LAKE CITY302.0642.11702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071760000-000000000001992-07-01Active4227.34No
1991199119910307071760000199102311402-- None --017-004BIG BEAR LAKE CITY1399.9842.091702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071760000-000000000001992-07-01Active4227.34No
1991199119910307071810000199102314001-- None --017-004BIG BEAR LAKE CITY302.0642.11702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071810000-000000000001992-07-01Active4227.34No
1991199119910307071810000199102314002-- None --017-004BIG BEAR LAKE CITY1399.9842.091702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071810000-000000000001992-07-01Active4227.34No
1991199119910307071900000199102318681-- None --017-004BIG BEAR LAKE CITY302.0642.11702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071900000-000000000001992-07-01Active4227.34No
1991199119910307071900000199102318682-- None --017-004BIG BEAR LAKE CITY1399.9842.091702.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0307071900000-000000000001992-07-01Active4227.34No
1991199119910532011172000199104811631-- None --109-043SILVER VALLEY UNIFIED3508.574897042.14UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0532011172000-000000000001992-07-01Active32813.59No
1991199119910532011172000199104811632-- None --109-043SILVER VALLEY UNIFIED3533.574897042.14UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0532011172000-000000000001992-07-01Active32813.59No
1991199119910660161120000199105515041-- None --003-012NEEDLES CITY21.5231141.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0660161120000-000000000001992-07-01Active4056.73No
1991199119910660161120000199105515042-- None --003-012NEEDLES CITY1119.5231141.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0660161120000-000000000001992-07-01Active4056.73No
1991199119910660192080000199105515291-- None --003-012NEEDLES CITY21.5231141.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0660192080000-000000000001992-07-01Active4056.73No
1991199119910660192080000199105515292-- None --003-012NEEDLES CITY1119.5231141.04UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0660192080000-000000000001992-07-01Active4056.73No
1991199119910660231030000199105515821-- None --003-001NEEDLES CITY23.313.251144.62UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0660231030000-000000000001992-07-01Active4077.3No
1991199119910660231030000199105515822-- None --003-001NEEDLES CITY1121.313.251144.62UnpaidUnpaidRedemptionRedemptionSecuredAnnual1992-0660231030000-000000000001992-07-01Active4077.3No
1991199119911020263250000199106015481-- None --001-001CHINO CITY94.8513.22199.47UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
1991199119911020263250000199106015482-- None --001-001CHINO CITY104.6213.19199.47UnpaidUnpaidRedemptionRedemptionSecuredAnnual1989-1020263250000-000000000001989-07-01Active7455.88No
199119911991105728111P000199106444011-- None --061-001CHINO UNIFIED28999.194041.758008.16UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-1057281111000-000000000001985-07-01Active314406No
199119911991105728111P000199106444012-- None --061-001CHINO UNIFIED29008.974041.6758008.16UnpaidUnpaidRedemptionRedemptionSecuredAnnual1985-1057281111000-000000000001985-07-01Active314406No
1991199119911200421060000199102031931-- None --018-050HIGHLAND CITY235.8332.87481.59UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1991199119911200421060000199102031932-- None --018-050HIGHLAND CITY245.7632.86481.59UnpaidUnpaidRedemptionRedemptionSecuredAnnual1987-0287201030000-000000000001987-07-01Active13713.57No
1992199219920127611090000199200080641-- None --006-000RIALTO CITY88.0512.59186.1UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1992199219920127611090000199200080642-- None --006-000RIALTO CITY98.0512.59186.1UnpaidUnpaidRedemptionRedemptionSecuredAnnual1990-0127611090000-000000000001990-07-01Active6709.13No
1992199219920135191070000199200195281-- None --007-062SAN BERNARDINO CITY94.713.54199.27UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0135191070000-000000000001991-07-01Active12190.53No
1992199219920135191070000199200195282-- None --007-062SAN BERNARDINO CITY104.5713.52199.27UnpaidUnpaidRedemptionRedemptionSecuredAnnual1991-0135191070000-000000000001991-07-01Active12190.53No