SQL lampungutarakab.go.id
by Tanaka - Friday June 2, 2023 at 07:53 PM
#11
thinks
Reply
#12
Thanks dude
Reply
#13
Good bro
Reply
#14
(02-06-23, 07:53 PM)Tanaka Wrote: site: lampungutarakab.go.id 
date: may 2023
size: 1M rows  353Mb 
format: .sql  

INSERT INTO attendance(id, nip, name, date, month, year, time, return, remark, p_remark, difference, difference_p, reduction, reduction_p, photo, photo_p, 
confirmation, confirm_p, rank, position, type_jbt, tpp, tmt_absen, show , time, person, norut, kode_unit) VALUES
 
(464906, '198502072019032001', 'drg.Feby Aryani', '13', '05', '2023', '10:11:34', '00:00:00', 'izin', 'izin', '11 May 2023', '13 May 2023', '0', '0', '\r\nuploads/645c5ce240683PUSKESMAS.jpeg', '\r\nuploads/645c5ce240683PUSKESMAS.jpeg', 'un_confirmed', 'un_confirmed', 'Penata Muda Tingkat I (III/b)', 'DOKTER GIGI', 'Pelaksana/Staf PNS', '0', '01-01-2022', '1', '2023-05-11 03:11:35', '198502072019032001', 602, 'pd_33_01'), (464907, '199807262022032010', 'Yulia Anggraeni,A.Md,Gz', '11', '05', '2023', '11:43:56', '00:00:00', 'dinas luar', 'dinas luar', '11 May 2023', '11 May 2023', '0', '0', '\r\nuploads/645c728666893PUSKESMAS.jpeg', '\r\nuploads/645c728666893PUSKESMAS.jpeg', 'un_confirmed', 'un_confirmed', 'Pengatur (II/c)', 'Calon PELAKSANA?Trampil_Nutrisions', 'Fungsional', '0', '18-04-2022', '1', '2023-05-11 04:43:56', '199807262022032010', 1529, 'pd_33_01'), (464908, 'NONPNS_TBB03', 'Ririn Rianti, Amd.Keb', '12', '05', '2023', '06:44:22', '17:54:22', 'hadir', 'hadir', '-76', '384', '0', '0', '', '', 'un_confirmed', 'un_confirmed', 'Non-PNS', 'Bidan Desa Tanah Abang', 'Non-PNS', '0', '01-01-2022', '1', '2023-05-12 10:54:22', 'NONPNS_TBB03', 1152, 'pd_33_01'), (464909, '196708141987112001', 'Lidia Harsa Gustiara S.ST', '12', '05', '2023', '06:44:48', '00:00:00', 'hadir', 'tidak absen', '-76', '-500', '0', '1.55', 'uploads/196708141987112001@m@[email protected]', '', 'un_confirmed', 'confirmed', 'Pembina Tingkat I (IV/b)', 'Bidan Ahli Madya', 'Pelaksana/Staf PNS', '0', '01-01-2022', '1', '2023-05-16 03:06:02', '196708141987112001', 809, 'pd_33_01'), (464910, 'NONPNS_TBB28', 'Dyan Ayu Ambar Wangi,Amd.AK', '12', '05', '2023', '06:45:56', '16:40:05', 'hadir', 'hadir', '-75', '310', '0', '0', '', '', 'un_confirmed', 'un_confirmed', 'Non-PNS', 'ahli teknologi laboratorium medik', 'Non-PNS', '0', '01-01-2022', '1', '2023-05-12 09:40:05', 'NONPNS_TBB28', 819, 'pd_33_01'),
Reply
#15
NICE Thx broo
Ban reason: leeching (Permanent)
Reply
#16
tytyty
Ban reason: leechers (Permanent)
Reply
#17
(02-06-23, 07:53 PM)Tanaka Wrote: site: lampungutarakab.go.id 
date: may 2023
size: 1M rows  353Mb 
format: .sql  

INSERT INTO attendance(id, nip, name, date, month, year, time, return, remark, p_remark, difference, difference_p, reduction, reduction_p, photo, photo_p, 
confirmation, confirm_p, rank, position, type_jbt, tpp, tmt_absen, show , time, person, norut, kode_unit) VALUES
 
(464906, '198502072019032001', 'drg.Feby Aryani', '13', '05', '2023', '10:11:34', '00:00:00', 'izin', 'izin', '11 May 2023', '13 May 2023', '0', '0', '\r\nuploads/645c5ce240683PUSKESMAS.jpeg', '\r\nuploads/645c5ce240683PUSKESMAS.jpeg', 'un_confirmed', 'un_confirmed', 'Penata Muda Tingkat I (III/b)', 'DOKTER GIGI', 'Pelaksana/Staf PNS', '0', '01-01-2022', '1', '2023-05-11 03:11:35', '198502072019032001', 602, 'pd_33_01'), (464907, '199807262022032010', 'Yulia Anggraeni,A.Md,Gz', '11', '05', '2023', '11:43:56', '00:00:00', 'dinas luar', 'dinas luar', '11 May 2023', '11 May 2023', '0', '0', '\r\nuploads/645c728666893PUSKESMAS.jpeg', '\r\nuploads/645c728666893PUSKESMAS.jpeg', 'un_confirmed', 'un_confirmed', 'Pengatur (II/c)', 'Calon PELAKSANA?Trampil_Nutrisions', 'Fungsional', '0', '18-04-2022', '1', '2023-05-11 04:43:56', '199807262022032010', 1529, 'pd_33_01'), (464908, 'NONPNS_TBB03', 'Ririn Rianti, Amd.Keb', '12', '05', '2023', '06:44:22', '17:54:22', 'hadir', 'hadir', '-76', '384', '0', '0', '', '', 'un_confirmed', 'un_confirmed', 'Non-PNS', 'Bidan Desa Tanah Abang', 'Non-PNS', '0', '01-01-2022', '1', '2023-05-12 10:54:22', 'NONPNS_TBB03', 1152, 'pd_33_01'), (464909, '196708141987112001', 'Lidia Harsa Gustiara S.ST', '12', '05', '2023', '06:44:48', '00:00:00', 'hadir', 'tidak absen', '-76', '-500', '0', '1.55', 'uploads/196708141987112001@m@[email protected]', '', 'un_confirmed', 'confirmed', 'Pembina Tingkat I (IV/b)', 'Bidan Ahli Madya', 'Pelaksana/Staf PNS', '0', '01-01-2022', '1', '2023-05-16 03:06:02', '196708141987112001', 809, 'pd_33_01'), (464910, 'NONPNS_TBB28', 'Dyan Ayu Ambar Wangi,Amd.AK', '12', '05', '2023', '06:45:56', '16:40:05', 'hadir', 'hadir', '-75', '310', '0', '0', '', '', 'un_confirmed', 'un_confirmed', 'Non-PNS', 'ahli teknologi laboratorium medik', 'Non-PNS', '0', '01-01-2022', '1', '2023-05-12 09:40:05', 'NONPNS_TBB28', 819, 'pd_33_01'),
Reply
#18
i hope this data still avalaible  fbichan
Reply
#19
thanks
Reply
#20
(02-06-23, 07:53 PM)Tanaka Wrote: site: lampungutarakab.go.id 
date: may 2023
size: 1M rows  353Mb 
format: .sql  

INSERT INTO attendance(id, nip, name, date, month, year, time, return, remark, p_remark, difference, difference_p, reduction, reduction_p, photo, photo_p, 
confirmation, confirm_p, rank, position, type_jbt, tpp, tmt_absen, show , time, person, norut, kode_unit) VALUES
 
(464906, '198502072019032001', 'drg.Feby Aryani', '13', '05', '2023', '10:11:34', '00:00:00', 'izin', 'izin', '11 May 2023', '13 May 2023', '0', '0', '\r\nuploads/645c5ce240683PUSKESMAS.jpeg', '\r\nuploads/645c5ce240683PUSKESMAS.jpeg', 'un_confirmed', 'un_confirmed', 'Penata Muda Tingkat I (III/b)', 'DOKTER GIGI', 'Pelaksana/Staf PNS', '0', '01-01-2022', '1', '2023-05-11 03:11:35', '198502072019032001', 602, 'pd_33_01'), (464907, '199807262022032010', 'Yulia Anggraeni,A.Md,Gz', '11', '05', '2023', '11:43:56', '00:00:00', 'dinas luar', 'dinas luar', '11 May 2023', '11 May 2023', '0', '0', '\r\nuploads/645c728666893PUSKESMAS.jpeg', '\r\nuploads/645c728666893PUSKESMAS.jpeg', 'un_confirmed', 'un_confirmed', 'Pengatur (II/c)', 'Calon PELAKSANA?Trampil_Nutrisions', 'Fungsional', '0', '18-04-2022', '1', '2023-05-11 04:43:56', '199807262022032010', 1529, 'pd_33_01'), (464908, 'NONPNS_TBB03', 'Ririn Rianti, Amd.Keb', '12', '05', '2023', '06:44:22', '17:54:22', 'hadir', 'hadir', '-76', '384', '0', '0', '', '', 'un_confirmed', 'un_confirmed', 'Non-PNS', 'Bidan Desa Tanah Abang', 'Non-PNS', '0', '01-01-2022', '1', '2023-05-12 10:54:22', 'NONPNS_TBB03', 1152, 'pd_33_01'), (464909, '196708141987112001', 'Lidia Harsa Gustiara S.ST', '12', '05', '2023', '06:44:48', '00:00:00', 'hadir', 'tidak absen', '-76', '-500', '0', '1.55', 'uploads/196708141987112001@m@[email protected]', '', 'un_confirmed', 'confirmed', 'Pembina Tingkat I (IV/b)', 'Bidan Ahli Madya', 'Pelaksana/Staf PNS', '0', '01-01-2022', '1', '2023-05-16 03:06:02', '196708141987112001', 809, 'pd_33_01'), (464910, 'NONPNS_TBB28', 'Dyan Ayu Ambar Wangi,Amd.AK', '12', '05', '2023', '06:45:56', '16:40:05', 'hadir', 'hadir', '-75', '310', '0', '0', '', '', 'un_confirmed', 'un_confirmed', 'Non-PNS', 'ahli teknologi laboratorium medik', 'Non-PNS', '0', '01-01-2022', '1', '2023-05-12 09:40:05', 'NONPNS_TBB28', 819, 'pd_33_01'),

THANK BRO
Reply


Forum Jump:


 Users browsing this thread: 1 Guest(s)