-- check database row count
select count(*)
FROM seattle_mortgage
| count |
|---|
| 1012 |
-- (Panel) Overall distress property market trend
select "SERIES", "YEAR", "QUARTER", "MARKET", "VALUE"
FROM seattle_mortgage
where "SERIES" != 'Percent in Forbearance'
| SERIES | YEAR | QUARTER | MARKET | VALUE |
|---|---|---|---|---|
| Percent 30 or 60 Days Past Due Date | 2002 | 1 | Enterprise | 0.7 |
| Percent 30 or 60 Days Past Due Date | 2002 | 2 | Enterprise | 0.7 |
| Percent 30 or 60 Days Past Due Date | 2002 | 3 | Enterprise | 0.8 |
| Percent 30 or 60 Days Past Due Date | 2002 | 4 | Enterprise | 0.8 |
| Percent 30 or 60 Days Past Due Date | 2003 | 1 | Enterprise | 0.7 |
| Percent 30 or 60 Days Past Due Date | 2003 | 2 | Enterprise | 0.7 |
| Percent 30 or 60 Days Past Due Date | 2003 | 3 | Enterprise | 0.8 |
| Percent 30 or 60 Days Past Due Date | 2003 | 4 | Enterprise | 0.9 |
| Percent 30 or 60 Days Past Due Date | 2004 | 1 | Enterprise | 0.7 |
| Percent 30 or 60 Days Past Due Date | 2004 | 2 | Enterprise | 0.6 |
-- (Panel) Residential/conventional home loan market
select "SERIES", "YEAR", "QUARTER", "MARKET", "VALUE"
FROM seattle_mortgage
where "SERIES" != 'Percent in Forbearance'
and "MARKET" = 'Other Conventional'
| SERIES | YEAR | QUARTER | MARKET | VALUE |
|---|---|---|---|---|
| Percent 30 or 60 Days Past Due Date | 2002 | 1 | Other Conventional | 2.1 |
| Percent 30 or 60 Days Past Due Date | 2002 | 2 | Other Conventional | 1.9 |
| Percent 30 or 60 Days Past Due Date | 2002 | 3 | Other Conventional | 2.2 |
| Percent 30 or 60 Days Past Due Date | 2002 | 4 | Other Conventional | 2.3 |
| Percent 30 or 60 Days Past Due Date | 2003 | 1 | Other Conventional | 2.0 |
| Percent 30 or 60 Days Past Due Date | 2003 | 2 | Other Conventional | 1.8 |
| Percent 30 or 60 Days Past Due Date | 2003 | 3 | Other Conventional | 1.8 |
| Percent 30 or 60 Days Past Due Date | 2003 | 4 | Other Conventional | 2.1 |
| Percent 30 or 60 Days Past Due Date | 2004 | 1 | Other Conventional | 1.8 |
| Percent 30 or 60 Days Past Due Date | 2004 | 2 | Other Conventional | 1.7 |
-- (Agg. Val.) Average appraisal value
select CEILING(AVG(TO_NUMBER("Appraised Value", 'FM99G999G999' ))) as "Average"
from "SeattleDistressedProp"
| Average |
|---|
| 493907 |
-- (Cross-sectional) List of distressed properties in the king county area
select "Record Date","PID","Address","Appraised Value","Latitude","Longitude","Neighborhood","Metro","Grantee"
from "SeattleDistressedProp"
ORDER BY "Record Date"
| Record Date | PID | Address | Appraised Value | Latitude | Longitude | Neighborhood | Metro | Grantee |
|---|---|---|---|---|---|---|---|---|
| 06/21/2022 | 7225500280 | 30537 5TH AVE SW 98023 | 519,000 | 47.327724599999996 | -122.34113418535375 | Mirror Lake | Federal Way | CLEAR RECON CORPAEGIS LAND TITLE GROUP... |
| 06/22/2022 | 0699002230 | 12932 NE 131ST ST 98034 | 328,000 | 47.7175885 | -122.16798441313318 | Kirkland | King County | NORTH STAR TRUSTEE LLCHOMESTREET BANK... |
| 06/22/2022 | 1222069101 | 19324 HOLLYHILLS DR NE 98011 | 989,000 | 47.76782685 | -122.17036347613123 | North Creek | Bothell | ACKER SEAN DACKER HEIDI J... |
| 06/23/2022 | 3971701899 | 22024 260TH AVE SE 98038 | 682,000 | 47.40390495 | -121.99406930091548 | Maple Valley | King County | QUALITY LOAN SERVICE CORPORATION OF WALAKEVIEW LOAN SERVICING LLC... |
| 06/23/2022 | 3546000540 | 24230 116TH PL SE | 465,000 | 47.384213700000004 | -122.1859362960468 | East Pointe | Kent | BEACH MORTGAGE COMPANYQUALITY LOAN SERVICE CORPORATION OF WA... |
| 06/23/2022 | 2122059213 | 4729 ROOSEVELT WAY NE 98105 | 839,000 | 47.66402575 | -122.31770574597698 | University Heights | University District | PNC BANK NAQUALITY LOAN SERVICE CORPORATION OF WA |
| 06/23/2022 | 5335200070 | 21518 117TH AVE SE 98031 | 1,521,000 | 47.40944485 | -122.18516267433654 | Hillshire Terrace | Kent | NORTH STAR TRUSTEE LLCWILMINGTON TRUST NA |
| 06/23/2022 | 1459750120 | 119 37TH AVE E 98112 | 536,000 | 47.61898334999999 | -122.28674057451731 | Denny-Blaine | Harrison/Denny–Blaine | NORTH STAR TRUSTEE LLCSERVICEMAC LLC |
| 06/23/2022 | 9103000450 | 1822 NE 190TH ST 98155 | 869,000 | 47.76668377777778 | -122.30996488888889 | Shoreline | King County | BORREGO MANAGEMENT LLCKLAVANO JIM... |
| 06/24/2022 | 7129302745 | 12508 SE 273RD PL 98030 | 263,000 | 47.356899 | -122.17383036668008 | Kent | King County | CULVER GARY EKROHN GARY |