2 hours ago
Cassila4Sec here.
Another day, another government database left wide open. Today might be a bad day for the Surakarta City Government (Central Java). They love showing off their aid programs on TV. But they leave the back door wide open. If you can't protect the data of the people you claim to be helping, maybe you shouldn't be collecting it in the first place. We found the entire list of recipients with no protection at all.
It's really sad..
Leak Information
Sample
Download Here
Notes
— Cassila4Sec
Another day, another government database left wide open. Today might be a bad day for the Surakarta City Government (Central Java). They love showing off their aid programs on TV. But they leave the back door wide open. If you can't protect the data of the people you claim to be helping, maybe you shouldn't be collecting it in the first place. We found the entire list of recipients with no protection at all.
It's really sad..
Leak Information
Quote:Source : Pemerintah Kota Surakarta (2025 & 2026)
Format : SQL, CSV, & JSON
Count : 350+ Records
Fields : no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang
Sample
-- Tabel Penerima Bantuan Rumah Swadaya Kota Surakarta
-- Author: Cassila4Sec
-- Total data: 350
DROP TABLE IF EXISTS penerima_bantuan_rumah_swadaya;
CREATE TABLE penerima_bantuan_rumah_swadaya (
no INTEGER NOT NULL,
nama VARCHAR(100) NOT NULL,
no_ktp VARCHAR(20) NOT NULL,
kelurahan VARCHAR(50) NOT NULL,
kecamatan VARCHAR(30) NOT NULL,
rt SMALLINT,
rw SMALLINT,
material BIGINT NOT NULL DEFAULT 17500000,
tukang BIGINT NOT NULL DEFAULT 2500000
);
CREATE INDEX idx_penerima_kecamatan ON penerima_bantuan_rumah_swadaya(kecamatan);
CREATE INDEX idx_penerima_kelurahan ON penerima_bantuan_rumah_swadaya(kelurahan);
CREATE INDEX idx_penerima_no_ktp ON penerima_bantuan_rumah_swadaya(no_ktp);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (1, 'JONO', '3372051103660001', 'GILINGAN', 'BANJARSARI', 1, 18, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (2, 'SETU WALUYO', '3372050102710002', 'KESTALAN', 'BANJARSARI', 2, 4, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (3, 'SUWITO', '3372051302630005', 'KESTALAN', 'BANJARSARI', 2, 4, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (4, 'SUKATNO', '3372050412700001', 'NUSUKAN', 'BANJARSARI', 3, 18, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (5, 'HANUNGKI ARTA TRIYADI', '3372041801990002', 'GANDEKAN', 'JEBRES', 1, 4, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (1, 'SUPRIYADI', '3312061005890002', 'BANJARSARI', 'BANJARSARI', 1, 22, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (2, 'SUPARMI', '3372056106720003', 'BANJARSARI', 'BANJARSARI', 1, 22, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (3, 'BAGUS SRI KUNCORO', '3372050908860028', 'GILINGAN', 'BANJARSARI', 2, 21, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (4, 'SUMINAH', '3372055806740001', 'GILINGAN', 'BANJARSARI', 2, 21, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (5, 'ENDANG RUMINAH', '3372054412770006', 'GILINGAN', 'BANJARSARI', 2, 17, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (1, 'SUPARMI', '3372054108620027', 'BANJARSARI', 'BANJARSARI', 4, 2, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (2, 'SUTRISNI', '3372056310680002', 'BANJARSARI', 'BANJARSARI', 5, 1, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (3, 'DJOKO WASIS', '3372052308770008', 'BANYUANYAR', 'BANJARSARI', 1, 1, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (4, 'MUJIANTO', '3372052505770007', 'BANYUANYAR', 'BANJARSARI', 1, 1, 17500000, 2500000);
INSERT INTO penerima_bantuan_rumah_swadaya (no, nama, no_ktp, kelurahan, kecamatan, rt, rw, material, tukang) VALUES (5, 'SUPAMI', '3372057112610179', 'BANYUANYAR', 'BANJARSARI', 3, 8, 17500000, 2500000);Download Here
Quote:- Verify the files before importing.
- I don't care what you do with it.
— Cassila4Sec
