# LoanApps India DB — recovered

Recovery complete 2026-09-20 (Taildrop from Thinkpad). The dbhub.io/srikanthlogic/loanapps.db URL 404s; this folder holds the published file byte-exact plus working copies and builder code.

## The DBs

| File | What it is | Apps (distinct appId) | Proof |
|---|---|---|---|
| `loanapps_dbhub_20220227.db` | **The published dbhub file** (30,461,952 B — exact byte match with Wayback-archived page metadata) | **1,038** (725 playdata + 764 archive + 339 deleted) | sha256 + integrity ok |
| `loanapps_master_20210309.db` | Working master, GPlayLendingApps (44 MB, 8 tables incl. koodous tables) | 1,320 (incl. playdata3) | integrity ok |
| `loanapps_20201228.db` | DB4S .remotedb snapshot, 28 Dec 2020 | 426 + 260 deleted | integrity ok |
| `loanapps_alpha_20201224.db` | DB4S .remotedb snapshot, 24 Dec 2020 (alpha) | 181 | integrity ok |

Matches the killerloanapps post claim: "Database of 1000+ loan apps, Dec 25 2020 – Jan 15 2021".

## code/ — builder artifacts (Thinkpad GPlayLendingApps)
- `LoanApp.py` — Play scraper that built the DB
- `applist.txt` — app id list input; `snippets.txt` — Koodous snippet target
- `KoodousQuery.py` + `KoodousQueries.json` — Koodous (AndroMalShare) APK search
- `NewApps_Feb21.txt` — Feb 2021 additions

## Provenance
- `/media/data/Research/CC/loanapps.db` = published copy; `/media/data/code/GPlayLendingApps/loanapps.db` = master
- `loanapps_old1.db` on Thinkpad is corrupt (91 B); `loanapps_old.db` intact; Play CSV in `GPlayLendingApps/play/`
- India scoping via search terms + description filters (currency column is a Play-API artifact: USD)
- Also on Thinkpad: `/media/data/Research/CC/LoanApps/` (research APKs, MCA data, leaked loan-app PHP backend + infolist) and `/media/data/Research/CC/Digital Lending/`