-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 30, 2022 at 05:21 PM
-- Server version: 10.2.41-MariaDB-cll-lve
-- PHP Version: 7.3.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `gerf5821_erp_smk`
--

-- --------------------------------------------------------

--
-- Table structure for table `covid_history`
--

CREATE TABLE `covid_history` (
  `id_history` int(11) NOT NULL,
  `id_covid` int(11) NOT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `alamat` varchar(100) DEFAULT NULL,
  `hp` varchar(30) DEFAULT NULL,
  `goldarah` varchar(5) DEFAULT NULL,
  `wilayah` varchar(10) DEFAULT NULL,
  `lingkungan` varchar(10) DEFAULT NULL,
  `umur` decimal(5,2) DEFAULT NULL,
  `tgl_positif` varchar(12) DEFAULT NULL,
  `isoman` varchar(1) DEFAULT NULL,
  `tgl_isoman` varchar(25) DEFAULT NULL,
  `tgl_opname` varchar(12) DEFAULT NULL,
  `nama_rs` varchar(50) DEFAULT NULL,
  `monitor_kondisi` varchar(10) DEFAULT NULL,
  `monitor_note` varchar(200) DEFAULT NULL,
  `monitor_tgl` varchar(12) DEFAULT NULL,
  `bantuan` varchar(200) DEFAULT NULL,
  `vaksin` varchar(1) DEFAULT NULL,
  `merk1` varchar(20) DEFAULT NULL,
  `merk2` varchar(20) DEFAULT NULL,
  `tgl_vaksin1` date DEFAULT NULL,
  `tgl_vaksin2` date DEFAULT NULL,
  `komorbid` varchar(1) DEFAULT NULL,
  `hamil` varchar(1) DEFAULT NULL,
  `updated_by` varchar(36) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `id_umat` varchar(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `covid_history`
--

INSERT INTO `covid_history` (`id_history`, `id_covid`, `nama`, `alamat`, `hp`, `goldarah`, `wilayah`, `lingkungan`, `umur`, `tgl_positif`, `isoman`, `tgl_isoman`, `tgl_opname`, `nama_rs`, `monitor_kondisi`, `monitor_note`, `monitor_tgl`, `bantuan`, `vaksin`, `merk1`, `merk2`, `tgl_vaksin1`, `tgl_vaksin2`, `komorbid`, `hamil`, `updated_by`, `updated_date`, `id_umat`) VALUES
(1, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', NULL, NULL, 'Yakobus', 'Yakobus 3', 0.00, '', 'T', '', '', 'RS Siti Khadijah Taman Sda', 'Meninggal', '', '2-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', NULL, NULL, 'Yakobus', 'Yakobus 3', 0.00, '', 'T', '', '', 'RS Siti Khadijah Taman Sda', 'Meninggal', '', '2-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', NULL, NULL, 'Yakobus', 'Yakobus 3', 59.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(4, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', '0812-3245-6002', NULL, 'Yakobus', 'Yakobus 3', 59.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(5, 144, 'Maria Marsha Magdalena (anak B Hurint)', 'PWI 1 Sda', NULL, NULL, 'Yakobus', 'Yakobus 3', 21.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(6, 143, 'Monica Asha Benning (anak B Hurint)', 'PWI 1 Sda', NULL, NULL, 'Yakobus', 'Yakobus 3', 25.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(7, 143, 'Monica Asha Benning (anak B Hurint)', 'PWI 1 Sda', '', NULL, 'Yakobus', 'Yakobus 3', 25.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(8, 144, 'Maria Marsha Magdalena (anak B Hurint)', 'PWI 1 Sda', '', NULL, 'Yakobus', 'Yakobus 3', 21.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(9, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', '0812-3245-6002', NULL, 'Yakobus', 'Yakobus 3', 59.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(10, 8, 'Eduardus Anggoro', 'Jambangan Sawah 38B', '81333224192', '', 'Blasius', 'Blasius 1', 38.00, '2-Jul-21', 'I', '', '-', '-', 'Sembuh', 'Sehat', '6-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(11, 8, 'Eduardus Anggoro', 'Jambangan Sawah 38B', '81333224192', '', 'Blasius', 'Blasius 1', 38.00, '2-Jul-21', '', '', '-', '-', 'Sembuh', 'Sehat', '6-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(12, 7, 'Amanda Gisele Dita Ayu Merizza', 'Jambangan Sawah 38B', '81333224192', '', 'Blasius', 'Blasius 1', 38.00, '2-Jul-21', 'T', '', '-', 'RSIA Graha Medika', 'Perawatan', 'Masih dirawat', '', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(13, 7, 'Amanda Gisele Dita Ayu Merizza', 'Jambangan Sawah 38B', '81333224192', 'A', 'Blasius', 'Blasius 1', 38.00, '2-Jul-21', 'T', '', '-', 'RSIA Graha Medika', 'Perawatan', 'Masih dirawat', '', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(14, 7, 'Amanda Gisele Dita Ayu Merizza', 'Jambangan Sawah 38B', '81333224192', 'A', 'Blasius', 'Blasius 1', 38.00, '2-Jul-21', 'T', '', '-', '', 'Sembuh', 'Sehat', '22 Juli 2021', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(15, 13, 'Maria Hartoeti', 'Palm Spring B-16', '81310468225', '', 'Blasius', 'Blasius 1', 84.00, '25-Jun-21', 'I', '', '-', '-', 'Pemulihan', 'Pemulihan', '8-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(16, 14, 'Veronika Joes Eka Bram Kuswarini', 'Palm Spring B-16', '81310468225', '', 'Blasius', 'Blasius 1', 65.00, '25-Jun-21', 'I', '', '-', '-', 'Pemulihan', 'Pemulihan', '8-Jul-21', '', 'S', 'v', 'v', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(17, 12, 'Suzana Handayani', 'Palm Resident B-21', '81259784300', '', 'Blasius', 'Blasius 1', 49.00, '25-Jun-21', 'I', '', '-', '-', 'Sembuh', 'Sehat', '16-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(18, 11, 'Stefanus Widodo', 'Palm Resident B-21', '81259784300', '', 'Blasius', 'Blasius 1', 48.00, '25-Jun-21', 'I', '', '-', '-', 'Sembuh', 'Sehat', '16-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(19, 11, 'Stefanus Widodo', 'Palm Resident B-21', '81259784300', '', 'Blasius', 'Blasius 1', 48.00, '25-Jun-21', '', '', '-', '-', 'Sembuh', 'Swab PCR', '16-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(20, 107, 'Fransisco Tommy Laodikia Utama', 'Taman Aloha H8/17', '81311635574', '', 'Yakobus', 'Yakobus 3', 27.00, '2-Jul-21', 'I', '', '2-Jul-21', 'JAKARTA', 'Pemulihan', '', '15-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(21, 108, 'Martinus Noval Utazzela', 'Taman Aloha H8/17', '895383482279', '', 'Yakobus', 'Yakobus 3', 24.00, '2-Jul-21', 'I', '', '2-Jul-21', 'RSAL OEPOMO, SURABAYA', 'Perawatan', '', '14-Jul-21', '', 'B', '', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(22, 73, 'Yosef Suparno', 'Menanggal Indah VIII/15', '82234598146', '', 'Thomas', 'Thomas 6', 75.00, '7/14/2021', 'I', '', '-', '', 'Perawatan', 'Masih isoman', '', 'Obat dan Vitamin', 'S', 'Sinovac', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(23, 73, 'Yosef Suparno', 'Menanggal Indah VIII/15', '82234598146', '', 'Thomas', 'Thomas 6', 75.00, '7/14/2021', '', '', '-', '', 'Sembuh', 'Masih isoman', '27/7/2021', 'Obat dan Vitamin', 'S', 'Sinovac', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(24, 72, 'Tiara Marfamasta', 'Menanggal Indah VIII/15', '81803806621', '', 'Thomas', 'Thomas 6', 40.00, '7/14/2021', 'I', '', '-', '', 'Perawatan', 'Masih isoman', '', 'Obat dan Vitamin', 'S', 'Sinovac', 'Sinovac', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(25, 73, 'Yosef Suparno', 'Menanggal Indah VIII/15', '82234598146', '', 'Thomas', 'Thomas 6', 75.00, '7/14/2021', '', '', '-', '', 'Sembuh', 'Masih isoman', '27/7/2021', 'Obat dan Vitamin', 'S', 'Sinovac', '', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(26, 72, 'Tiara Marfamasta', 'Menanggal Indah VIII/15', '81803806621', '', 'Thomas', 'Thomas 6', 40.00, '7/14/2021', '', '', '-', '', 'Sembuh', 'Masih isoman', '27/7/2021', 'Obat dan Vitamin', 'S', 'Sinovac', 'Sinovac', NULL, NULL, NULL, NULL, NULL, NULL, ''),
(27, 34, 'Agus Tri Yuono', 'Sepanjang Asri E-7', '81331819762', '', 'Blasius', 'Blasius 5', 54.00, '12-Jul-21', 'I', '12-Jul-21', '-', '-', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(28, 35, 'Elisabeth Rindang Prihandini Yuwono', 'Sepanjang Asri E-7', '', '', 'Blasius', 'Blasius 5', 26.00, '12-Jul-21', 'I', '12-Jul-21', '-', '-', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(29, 143, 'Monica Asha Benning (anak B Hurint)', 'PWI 1 Sda', '', NULL, 'Yakobus', 'Yakobus 3', 25.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(30, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', '0812-3245-6002', NULL, 'Yakobus', 'Yakobus 3', 59.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(31, 48, 'Veronika Tri Suci Maharani', 'Jl. Jatisari Permai IX/L-17', '87851455725', '', 'Petrus', 'Petrus 1', 31.00, '', 'I', '', '-', '', 'Perawatan', 'masih sakit', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(32, 48, 'Veronika Tri Suci Maharani', 'Jl. Jatisari Permai IX/L-17', '87851455725', '', 'Petrus', 'Petrus 1', 31.00, '', '', '', '-', '', 'Sembuh', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(33, 47, 'Shinta Ayu Indrarani Agnes', 'Jl. Jatisari Permai IX/L-17', '87851455725', '', 'Petrus', 'Petrus 1', 39.00, '', 'I', '', '-', '', 'Perawatan', 'masih sakit', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(34, 45, 'Dian Sujatmiko', 'Jl. Jatisari No. 4', '', '', 'Petrus', 'Petrus 1', 40.00, '18-Jul-2021', 'I', '', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(35, 92, 'Jefri Wijayanto', 'Griyo Wage Asri II Blok AF-6', '81249007778', '', 'Yakobus', 'Yakobus 2', 37.00, '', 'I', '18-Jul-21', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(36, 89, 'Benedictus Wahyu Wijayana', 'Griya Wage Sri I Blok K-9', '', '', 'Yakobus', 'Yakobus 2', 44.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(37, 87, 'Epivany Lily Megawati', 'Griya Wage Asri II Blok AC-9', '81233793727', '', 'Yakobus', 'Yakobus 2', 30.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(38, 88, 'Felicita Pinyungan Estuning Hyang', 'Griya Wage Asri II Blok AC-9', '', '', 'Yakobus', 'Yakobus 2', 14.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(39, 94, 'Fransisca Romana Merry Dwi Hastuti', 'Jl. Taruna Gg Mesjid 10 Wage', '85730635180', '', 'Yakobus', 'Yakobus 2', 46.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(40, 95, 'Leonardo Tegar Wicaksono', 'Jl. Taruna Gg Mesjid 10 Wage', '', '', 'Yakobus', 'Yakobus 2', 20.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(41, 86, 'Stefanus Chfrianto Pramudia', 'Griya Wage Asri I Blok L-14', '', '', 'Yakobus', 'Yakobus 2', 23.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(42, 91, 'Vincentius Restu Yogatama', 'Griyo Wage Asri II Blok AF-2', '88217950152', '', 'Yakobus', 'Yakobus 2', 20.00, '', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(43, 151, 'Stefanus Pepen Kurniawan', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 0.00, '18 Juli 2021', 'Y', '', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(44, 150, 'Agustinus sumadji', 'jambangan 6/32', '', 'O/+', 'Blasius', 'Blasius 2', 79.00, '21 juli 2021', 'T', '', '', 'RS Dr soetomo', 'Meninggal', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(45, 155, 'ANASTASIA CHRISTINA RACHMAWATI', 'JAMBANGAN VII D No. 18 ', '', 'O/+', 'Blasius', 'Blasius 2', 43.00, '25 Juni 2021', 'Y', '', '', '', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(46, 157, 'ANDREAS ERWIN DARIUS SOEGIARTO', 'JAMBANGAN VII D No. 18 ', '', '', 'Blasius', 'Blasius 2', 43.00, '25 Juni 2021', 'Y', '25 Juni 2021', '', '', 'Perawatan', '', '', '', 'S', 'Astrazeneca', '', '0000-00-00', '0000-00-00', 'N', '', NULL, NULL, ''),
(47, 153, 'ANNA GRACIA MARISKA CELESTINE', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 14.00, '19 juli 2021', 'T', '', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(48, 158, 'EMMANUELLA DYCA NOVAYANTI', 'JAMBANGAN TAMA I / 9', '', 'O/+', 'Blasius', 'Blasius 2', 23.00, '5 Juli 2021', 'Y', '5 Juli 2021', '', '', 'Perawatan', '', '', '', 'S', 'sinovac', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(49, 156, 'IMMACULATA HAGARKEMALA', 'JAMBANGAN VII D No. 18 ', '', 'B/+', 'Blasius', 'Blasius 2', 21.00, '25 Juni 2021', 'Y', '25 Juni 2021', '', '', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(50, 154, 'JULIA DWI HARIJANI', 'Jambangan Xb / 41 b', '', 'B/+', 'Blasius', 'Blasius 2', 54.00, '30 Juli 2021', 'T', '', '', '', 'Perawatan', '', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(51, 152, 'Marsella Monica Christy', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 42.00, '19 juli 2021', 'Y', '', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(52, 151, 'Stefanus Pepen Kurniawan', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 42.00, '18 Juli 2021', 'Y', '', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(53, 150, 'AGUSTINUS SUMADJI', 'JAMBANGAN VI / 32', '', 'O/+', 'Blasius', 'Blasius 2', 79.00, '21 juli 2021', 'T', '', '', 'RS Dr soetomo', 'Meninggal', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(54, 155, 'ANASTASIA CHRISTINA RACHMAWATI', 'JAMBANGAN VII D No. 18 ', '', 'O/+', 'Blasius', 'Blasius 2', 43.00, '25 Juni 2021', 'Y', '', '', '', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(55, 157, 'ANDREAS ERWIN DARIUS SOEGIARTO', 'JAMBANGAN VII D No. 18 ', '', '', 'Blasius', 'Blasius 2', 43.00, '25 Juni 2021', 'Y', '25 Juni 2021', '', '', 'Perawatan', '', '', '', 'S', 'Astrazeneca', '', '0000-00-00', '0000-00-00', 'N', '', NULL, NULL, ''),
(56, 156, 'IMMACULATA HAGARKEMALA', 'JAMBANGAN VII D No. 18 ', '', 'B/+', 'Blasius', 'Blasius 2', 21.00, '25 Juni 2021', 'Y', '25 Juni 2021', '', '', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(57, 153, 'ANNA GRACIA MARISKA CELESTINE', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 14.00, '19 juli 2021', 'T', '', '29 Juli 2021', 'RS Suwandi ', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(58, 152, 'Marsella Monica Christy', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 42.00, '19 juli 2021', 'Y', '19 juli 2021', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(59, 151, 'Stefanus Pepen Kurniawan', 'KEBONSARI NO 19', '', '', 'Blasius', 'Blasius 2', 42.00, '18 Juli 2021', 'Y', '18 Juli 2021', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(60, 158, 'EMMANUELLA DYCA NOVAYANTI', 'JAMBANGAN TAMA I / 9', '', 'O/+', 'Blasius', 'Blasius 2', 23.00, '5 Juli 2021', 'Y', '5 Juli 2021', '', '', 'Perawatan', '', '', '', 'S', 'sinovac', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(61, 154, 'JULIA DWI HARIJANI', 'Jambangan Xb / 41 b', '', 'B/+', 'Blasius', 'Blasius 2', 54.00, '30 Juli 2021', 'T', '', '', '', 'Perawatan', '', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(62, 154, 'JULIA DWI HARIJANI', 'Jambangan Xb / 41 b', '+62 812-1847-0471', 'B/+', 'Blasius', 'Blasius 2', 54.00, '30 Juli 2021', 'T', '', '', '', 'Perawatan', '', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(63, 15, 'Anastasius Bambang Trisoenarjoto P.', 'Palm Spring B-6', '82131323961', '', 'Blasius', 'Blasius 1', 82.00, 'Juni 2021', 'I', '', '-', '-', 'Perawatan', 'Masih dirawat', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(64, 15, 'Anastasius Bambang Trisoenarjoto P.', 'Palm Spring B-6', '82131323961', '', 'Blasius', 'Blasius 1', 82.00, 'Juni 2021', '', '', '-', '-', 'Pemulihan', 'Swab PCR negatif', '1 Agust 2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(65, 10, 'Nathanael Serafino Vielladeo', 'Palm Resident B-21', '81259784300', '', 'Blasius', 'Blasius 1', 14.00, '25-Jun-21', 'I', '', '-', '-', 'Sembuh', 'Sehat', '16-Jul-21', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(66, 113, 'Dewi', 'Pondok Wage Indah II BLOK O-6', '8155002171', '', 'Yakobus', 'Yakobus 4', 54.00, '10 Juli-21', 'I', '', '-', '', 'Perawatan', 'masih isoman', '', '', 'S', 'AZ', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(67, 117, 'Dominika Pricila Ayu', 'Pondok Wage Indah II BLOK r-8', '83119357817', '', 'Yakobus', 'Yakobus 4', 22.00, '17Juli-21', 'I', '17 juli-21', '-', '', 'Perawatan', 'masih isoman', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(68, 16, 'Andreas Matius William Novianto', 'Jl. Kebonsari V/33 Surabaya', '85102779836', '', 'Blasius', 'Blasius 3', NULL, 'Juli 2021', 'I', '', '-', '-', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(69, 21, 'Clara Erry Setiya Arianti', 'Kebonsari gang 7b no 11', '81217420265', '', 'Blasius', 'Blasius 3', NULL, 'Juli 2021', 'I', '', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(70, 20, 'Stefanus Bambang Setia Budi', 'Kebonsari gang 7b no 10', '81217420265', '', 'Blasius', 'Blasius 3', 60.00, 'Juli 2021', 'I', '', 'V', 'RKZ', 'Perawatan', '', '', '', 'S', 'v', 'v', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(71, 17, 'Veronica Katleen Yunita', 'Jl. Kebonsari V/33 Surabaya', '85102779836', '', 'Blasius', 'Blasius 3', NULL, 'Juli 2021', 'I', '', '-', '-', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(72, 18, 'YCR Bambang Rahardjo', 'Jl. Kebonsari V/33 Surabaya', '85102779836', '', 'Blasius', 'Blasius 3', 70.00, 'Juli 2021', 'I', '', 'V', 'RKZ', 'Perawatan', '', '', '', 'S', 'v', 'v', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(73, 19, 'Yohana Maria Sri Benowati', 'Jl. Kebonsari V/33 Surabaya', '85102779836', '', 'Blasius', 'Blasius 3', 60.00, 'Juli 2021', 'I', '', '-', '-', 'Pemulihan', '', '', '', 'S', 'v', 'v', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(74, 111, 'Emerentia Giovani', 'Pondok Wage Indah II BLOK d-18', '85707772416', '', 'Yakobus', 'Yakobus 4', 16.00, '12 Juli-21', 'I', '', '11 Juli-21', 'Rs Gotong Royong', 'Perawatan', 'masih opname', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(75, 115, 'F.X Cwanto', 'Pondok Wage Indah II BLOK P-1', '8123523228', '', 'Yakobus', 'Yakobus 4', 55.00, '6 Juli-21', 'I', '', '-', '', 'Perawatan', 'masih isoman', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(76, 117, 'Dominika Pricila Ayu', 'Pondok Wage Indah II BLOK r-8', '83119357817', '', 'Yakobus', 'Yakobus 4', 22.00, '17Juli-21', '', '17 juli-21', '-', '', 'Sembuh', '', '27-07-2021', '', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(77, 113, 'Dewi', 'Pondok Wage Indah II BLOK O-6', '8155002171', '', 'Yakobus', 'Yakobus 4', 54.00, '10 Juli-21', 'Y', '14-07-2021', '-', '', 'Sembuh', '', '28-07-2021', '', 'S', 'AZ', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(78, 114, 'Hartono Lukito', 'Pondok Wage Indah II BLOK O-6', '8155002171', '', 'Yakobus', 'Yakobus 4', 54.00, '10 Juli-21', 'I', '', '-', '', 'Perawatan', 'masih isoman', '', '', 'S', 'AZ', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(79, 118, 'Florentina Novi', 'Pondok Wage Indah II BLOK U-14', '82225299980', '', 'Yakobus', 'Yakobus 4', 24.00, '9 juli-21', 'I', '14 Juli-21', '-', '', 'Sembuh', 'Sudah sembuh', '14 Juli-21', '', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(80, 112, 'Marcelino Muhammad Taufik', 'Pondok Wage Indah II BLOK d-18', '85707772416', '', 'Yakobus', 'Yakobus 4', 39.00, '12 Juli-21', 'I', '', '11 Juli-21', 'Rs Gotong Royong', 'Perawatan', 'masih opname', '', '', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(81, 118, 'Florentina Novi', 'Pondok Wage Indah II BLOK U-14', '82225299980', '', 'Yakobus', 'Yakobus 4', 24.00, '9 juli-21', '', '14 Juli-21', '-', '', 'Sembuh', 'Sudah sembuh', '14 Juli-21', '', 'S', 'Sinovac', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(82, 119, 'Luciana mei', 'Pondok Wage Indah II BLOK U-2', 'lansia', '', 'Yakobus', 'Yakobus 4', 60.00, '30 Juni-21', 'I', '10 Juli-21', '-', '', 'Sembuh', 'sudah sembuh', '10 Juli-21', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(83, 109, 'Octavianus Rafael', 'Pondok Wage Indah II BLOK d-14', '81325936778', '', 'Yakobus', 'Yakobus 4', 17.00, '25 Juni-21', 'I', '', '-', '', 'Sembuh', 'sudah sembuh', '4 Juli-21', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(84, 110, 'Theresia Alica', 'Pondok Wage Indah II BLOK d-14', '81325936778', '', 'Yakobus', 'Yakobus 4', 13.00, '25 Juni-21', 'I', '', '-', '', 'Sembuh', 'sudah sembuh', '4 Juli-21', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(85, 120, 'Tri Harmanto', 'Pondok Wage Indah II BLOK U-9', '82143552633', '', 'Yakobus', 'Yakobus 4', 56.00, '15 Juli-21', 'I', '', '-', '', 'Perawatan', 'masih isoman', '', '', 'S', 'AZ', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(86, 159, 'bu ariyadi', 'pondok wage indah 2 bok p-33', '', '', 'Yakobus', 'Yakobus 4', 52.00, '14-07-2021', '', '', '28-07-2021', 'RKZ Surabaya', 'Perawatan', 'masih opname', '28-07-2021', 'memakai oxygen', '', '', '', '0000-00-00', '0000-00-00', '', 'B', NULL, NULL, ''),
(87, 111, 'Emerentia Giovani', 'Pondok Wage Indah II BLOK d-18', '85707772416', '', 'Yakobus', 'Yakobus 4', 16.00, '12 Juli-21', 'Y', '24-07-2021', '11 Juli-21', '', 'Perawatan', '', '26-07-2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(88, 160, 'yuliastuti', 'pondok wage indah 2 blok R-09', '', 'AB/+', 'Yakobus', 'Yakobus 4', 55.00, '26-07-2021', 'Y', '27-07-2021', '', '', 'Perawatan', '', '31-07-2021', 'RAWAT JALAN', 'S', 'SINOVAC', 'SINOVAC', '2021-01-12', '2021-03-12', 'Y', 'S', NULL, NULL, ''),
(89, 160, 'yuliastuti', 'pondok wage indah 2 blok R-09', '0895406194999', 'AB/+', 'Yakobus', 'Yakobus 4', 55.00, '26-07-2021', 'Y', '27-07-2021', '', '', 'Perawatan', 'isoman', '31-07-2021', 'RAWAT JALAN', 'S', 'SINOVAC', 'SINOVAC', '2021-01-12', '2021-03-12', 'Y', 'S', NULL, NULL, ''),
(90, 150, 'AGUSTINUS SUMADJI', 'JAMBANGAN VI / 32', '+62 812-3443-7301', 'O/+', 'Blasius', 'Blasius 2', 79.00, '21 juli 2021', 'T', '', '', 'RS Dr soetomo', 'Meninggal', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(91, 162, 'Theresia Sadiyem', 'pagesangan IIIa/7', '085816426478', '', 'Blasius', 'Blasius 5', 74.00, '26 Juli 2021', 'Y', '26 JUli 2021', '-', '-', 'Perawatan', '', '', 'belum mendapat bantuan', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(92, 30, 'Beatrix (Anak ke-2 Nicholas Maryanto)', 'Pagesangan Timur gg makam', '', '', 'Blasius', 'Blasius 5', NULL, '20-Jul-21', 'I', '20-Jul-21', '22-Jul-21', 'RS Haji Surabaya', 'Perawatan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(93, 31, 'Bonifasius (Anak ke-1 Nicholas Maryanto)', 'Pagesangan Timur gg makam', '', '', 'Blasius', 'Blasius 5', NULL, '20-Jul-21', 'I', '20-Jul-21', '22-Jul-21', 'RS Haji Surabaya', 'Perawatan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(94, 30, 'Beatrix (Anak ke-2 Nicholas Maryanto)', 'Pagesangan Timur gg makam', '082132106315', '', 'Blasius', 'Blasius 5', 12.00, '20-Jul-21', '', '20-Jul-21', '22-Jul-21', 'RS Haji Surabaya', 'Sembuh', '', '30 Juli 2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(95, 30, 'Beatrix (Anak ke-2 Nicholas Maryanto)', 'Pagesangan Timur gg makam', '082132106315', '-', 'Blasius', 'Blasius 5', 12.00, '20-Jul-21', '', '20-Jul-21', '22-Jul-21', 'RS Haji Surabaya', 'Sembuh', '', '30 Juli 2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(96, 32, 'Nicholas Maryanto', 'Pagesangan Timur gg makam', '81330104837', '', 'Blasius', 'Blasius 5', 45.00, '14-Jul-21', 'I', '14-Jul-21', '18-Jul-21', 'RSUD Bangkalan', 'Perawatan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(99, 30, 'Beatrix (Anak ke-2 Nicholas Maryanto)', 'Pagesangan Timur gg makam', '082132106315', '-', 'Blasius', 'Blasius 5', 12.00, '20-Jul-21', '', '20-Jul-21', '22-Jul-21', 'RS Haji Surabaya', 'Sembuh', '', '30 Juli 2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(100, 31, 'Bonifasius (Anak ke-1 Nicholas Maryanto)', 'Pagesangan Timur gg makam', '089524272623', '', 'Blasius', 'Blasius 5', 14.00, '20-Jul-21', '', '20-Jul-21', '22-Jul-21', 'RS Haji Surabaya', 'Sembuh', '', '30 Juli 2021', '', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(101, 29, 'Keluarga Dominicus Dedi', 'Pagesangan IV/109 gg angin sejuk', '81358623877', '', 'Blasius', 'Blasius 5', NULL, 'Juli 2021', 'I', 'Juli 2021', '-', '-', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(102, 29, 'Keluarga Dominicus Dedi', 'Pagesangan IV/109 gg angin sejuk', '', '', 'Blasius', 'Blasius 5', 39.00, 'Juli 2021', '', 'Juli 2021', '-', '-', 'Sembuh', 'Swab Antigen dan PCR', '', 'sudah mendapat bantuan dari PSE', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(103, 29, 'Keluarga Dominicus Dedi', 'Pagesangan IV/109 gg angin sejuk', '', 'B/+', 'Blasius', 'Blasius 5', 39.00, 'Juli 2021', '', 'Juli 2021', '-', '-', 'Sembuh', 'Swab PCR', '22 Juli 2021', 'sudah mendapat bantuan dari PSE', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(104, 97, 'B Heru', 'PWI 2', '', '', 'Yakobus', 'Yakobus 3', NULL, '14-Jul-21', 'I', '14-Jul-21', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(105, 145, 'Bp suwaji', 'Pondok wage indah 1', '082142469483', '', 'Yakobus', 'Yakobus 3', 0.00, '25 juli 2021', 'T', '', '25 juli 2021', 'RKZ', 'Perawatan', '', '27 juli 2021', 'Oxymeter lingkungan, susu dan roti utk putri2nya', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(106, 100, 'Devon (anak Ibu Hubaekar)', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '22-Jul-21', 'I', '', '22-Jul-21', 'RS Gempol Pasuruan', 'Perawatan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(107, 146, 'Ibu Suwaji', 'PWI 1 sda', '082142469483', '', 'Yakobus', 'Yakobus 3', 0.00, '25 juli 2021', 'T', '', '25 juli 2021', 'RKZ sby', 'Perawatan', '', '27 juli 2021', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(108, 99, 'Bismo', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '18-Jul-21', 'I', '18-Jul-21', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(109, 101, 'Dion (Anak FX. Rahardjo)', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '21-Jul-21', 'I', '21-Jul-21', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(110, 106, 'Fransiskus Sae', 'Taman Aloha F1/15', '81332410271', '', 'Yakobus', 'Yakobus 3', 53.00, '12-Jul-21', 'I', '12-Jul-21', '-', '', 'Pemulihan', 'Menunggu PCR', '', '', 'B', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(111, 103, 'Ibu FX. Rahardjo (B Yenny)', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '21-Jul-21', 'I', '21-Jul-21', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(112, 105, 'Odi (Anak FX. Rahardjo)', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '21-Jul-21', 'I', '21-Jul-21', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(113, 78, 'Anastasia Eny Kusrini', 'Jl. Bohar Timur 31 Bohar Taman Sidoarjo', '85645141864', '', 'Yakobus', 'Yakobus 1', 54.00, '29-Jun-21', 'I', '', '2-Jul-21', 'RSKZ', 'Perawatan', 'belum stabil', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(114, 79, 'Eleonora Deanita Anggraini', 'Jl. Bohar Timur 31 Bohar Taman Sidoarjo', '85102589420', '', 'Yakobus', 'Yakobus 1', 33.00, '23-Jun-21', 'I', '23 sd 27 Juni 2021', '28-Jun-21', 'RSKZ', 'Perawatan', 'stabil', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(115, 80, 'Antonius Mathias Wasno', 'Jl. Bohar Timur I/19 Bohar Taman Sdiaoarjo', '81331049854', '', 'Yakobus', 'Yakobus 1', 51.00, '5-Jul-21', 'I', '6-Jul-21', '-', '', 'Perawatan', 'stabil', '', '', 'S', 'AZ', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(116, 81, 'Louisa de Marillac Ika Andini', 'Jl. Bohar Timur I/19 Bohar Taman Sdiaoarjo', '81216526699', '', 'Yakobus', 'Yakobus 1', 21.00, '5-Jul-21', 'I', '6-Jul-21', '-', '', 'Perawatan', 'stabil', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(117, 80, 'Antonius Mathias Wasno', 'Jl. Bohar Timur I/19 Bohar Taman Sdiaoarjo', '81331049854', 'O/+', 'Yakobus', 'Yakobus 1', 51.00, '5-Jul-21', '', '6-Jul-21', '-', '', 'Sembuh', 'Sembuh', '21 Juli 2021', '', 'S', 'AZ', '', '2021-04-20', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(118, 83, 'Marcus Yudhi', 'Perum Grand Royal Edelweiis i4 No14 Suko', '8123065030', '', 'Yakobus', 'Yakobus 1', 40.00, '4-Jul-21', 'I', '4 sd sekarang', '-', '', 'Perawatan', 'Belum Stabil', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(119, 84, 'Patricia Gabby', 'Perum Grand Royal Edelweiis i4 No14 Suko', '8123065030', '', 'Yakobus', 'Yakobus 1', 13.00, '5-Jul-21', 'I', '4 sd sekarang', '-', '', 'Perawatan', 'stabil', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(120, 85, 'Selvi', 'Perum Grand Royal Edelweiis i4 No14 Suko', '8123065030', '', 'Yakobus', 'Yakobus 1', 39.00, '11-Jul-21', 'I', '4 sd sekarang', '-', '', 'Perawatan', 'stabil', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(121, 83, 'Marcus Yudhi', 'Perum Grand Royal Edelweiis i4 No14 Suko', '8123065030', '-', 'Yakobus', 'Yakobus 1', 40.00, '4-Jul-21', 'Y', '4-30 Juli 2021', '-', '', 'Pemulihan', ' Stabil', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(122, 121, 'Alfi', 'PWI 2 Blok EE - 15', '81331177785', '', 'Yakobus', 'Yakobus 5', 28.00, '7/2/2021', 'I', '7/2/2021', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(123, 125, 'Marcellinus Butsianto', 'PWI 2 Blok TT - 12', '81230730442', '', 'Yakobus', 'Yakobus 5', 42.00, '7/10/2021', 'I', '7/10/2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(124, 125, 'Marcellinus Butsianto', 'PWI 2 Blok TT - 12', '81230730442', '', 'Yakobus', 'Yakobus 5', 42.00, '7/10/2021', '', '7/10/2021', '', '', 'Sembuh', '', '24 -07-2021', '', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(125, 124, 'Anna Nur Wijayanti', 'PWI 2 Blok LL - 10', '85731106479', '', 'Yakobus', 'Yakobus 5', 37.00, '7/20/2021', 'I', '7/20/2021', '', '', 'Pemulihan', '', '', '', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(126, 128, 'Maria Margaretha Purwaningsih', 'PWI 2 Blok UU - 23', '81217356949', '', 'Yakobus', 'Yakobus 5', 44.00, '7/5/2021', 'I', '7/5/2021', '-', '', 'Pemulihan', '', '', '', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(127, 128, 'Maria Margaretha Purwaningsih', 'PWI 2 Blok UU - 23', '81217356949', '', 'Yakobus', 'Yakobus 5', 44.00, '7/5/2021', '', '7/5/2021', '-', '', 'Sembuh', '', '27-07-2021', '', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(128, 132, 'Augustina Heny Mulyani', 'PWI 2 Blok QQ - 27', '81615137476', '', 'Yakobus', 'Yakobus 5', 44.00, '7/22/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(129, 134, 'Agustinus Arya Bagus', 'PWI 2 Blok QQ - 27', '81615137476', '', 'Yakobus', 'Yakobus 5', 9.00, '7/22/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(130, 135, 'Johanes Adrian Hadinata', 'PWI 2 Blok QQ - 27', '81615137476', '', 'Yakobus', 'Yakobus 5', 7.00, '7/22/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(131, 135, 'Johanes Adrian Hadinata', 'PWI 2 Blok QQ - 27', '81615137476', '', 'Yakobus', 'Yakobus 5', 7.00, '7/22/2021', '', '7/22/2021', '', '', 'Sembuh', '', '05-08-2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(132, 133, 'Julius Alvian Aditya', 'PWI 2 Blok QQ - 27', '81615137476', '', 'Yakobus', 'Yakobus 5', 21.00, '7/22/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(133, 130, 'Natalia Farida Ariyani', 'PWI 2 Blok OO - 14', '85814075627', '', 'Yakobus', 'Yakobus 5', 44.00, '7/22/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(134, 123, 'Puspita Anggreny', 'PWI 2 Blok EE - 15', '81331177785', '', 'Yakobus', 'Yakobus 5', 27.00, '7/2/2021', 'I', '7/2/2021', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(135, 131, 'Romanus Susilo Hadi', 'PWI 2 Blok QQ - 27', '81615137476', '', 'Yakobus', 'Yakobus 5', 54.00, '7/22/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(136, 164, 'Cosmas Circus Widyolelono', 'Pondok Wage Indah 2 Blok OO - 2', '088217031541', '', 'Yakobus', 'Yakobus 5', 52.00, '05-08-2021', 'Y', '06-08-2021', '06-08-2021', 'RKZ', 'Pemulihan', '', '06-08-2021', '', 'S', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(137, 155, 'ANASTASIA CHRISTINA RACHMAWATI', 'JAMBANGAN VII D No. 18 ', '+62 821-3867-0699', 'O/+', 'Blasius', 'Blasius 2', 43.00, '25 Juni 2021', 'Y', '', '', '', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(138, 157, 'ANDREAS ERWIN DARIUS SOEGIARTO', 'JAMBANGAN VII D No. 18 ', '+62 821-3867-0699', '', 'Blasius', 'Blasius 2', 43.00, '25 Juni 2021', 'Y', '25 Juni 2021', '', '', 'Perawatan', '', '', '', 'S', 'Astrazeneca', '', '0000-00-00', '0000-00-00', 'N', '', NULL, NULL, ''),
(139, 158, 'EMMANUELLA DYCA NOVAYANTI', 'JAMBANGAN TAMA I / 9', '+62 856-0411-6052', 'O/+', 'Blasius', 'Blasius 2', 23.00, '5 Juli 2021', 'Y', '5 Juli 2021', '', '', 'Perawatan', '', '', '', 'S', 'sinovac', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(140, 156, 'IMMACULATA HAGARKEMALA', 'JAMBANGAN VII D No. 18 ', '+62 821-3867-0699', 'B/+', 'Blasius', 'Blasius 2', 21.00, '25 Juni 2021', 'Y', '25 Juni 2021', '', '', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(141, 98, 'P Heru', 'PWI 2', '', '', 'Yakobus', 'Yakobus 3', NULL, '14-Jul-21', 'I', '14-Jul-21', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(142, 153, 'ANNA GRACIA MARISKA CELESTINE', 'KEBONSARI NO 19', '+62 878-5545-5980', '', 'Blasius', 'Blasius 2', 14.00, '19 juli 2021', 'T', '', '29 Juli 2021', 'RS Suwandi ', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(143, 152, 'Marsella Monica Christy', 'KEBONSARI NO 19', '+62 878-5545-5980', '', 'Blasius', 'Blasius 2', 42.00, '19 juli 2021', 'Y', '19 juli 2021', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(144, 151, 'Stefanus Pepen Kurniawan', 'KEBONSARI NO 19', '+62 878-5545-5980', '', 'Blasius', 'Blasius 2', 42.00, '18 Juli 2021', 'Y', '18 Juli 2021', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(145, 129, 'Romanus Ruslan', 'PWI 2 Blok OO - 20', '81216361240', '', 'Yakobus', 'Yakobus 5', 48.00, '7/21/2021', 'I', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(146, 58, 'Emanuel Mario Calvindo', 'Gayung Kebonsari Manunggal Blok E-2', '81330718624', '', 'Thomas', 'Thomas 5', 25.00, '6/28/2021', 'I', '', '-', '', 'Perawatan', 'Sgot, d dimer, dan paru paru masih blm normal', '7/15/2021', 'Tidak Ada', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(147, 58, 'Emanuel Mario Calvindo', 'Gayung Kebonsari Manunggal Blok E-2', '81330718624', '', 'Thomas', 'Thomas 5', 25.00, '6/28/2021', '', '6/28/2021', '-', '', 'Perawatan', 'Pemulihan', '7/15/2021', 'Tidak Ada', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(148, 98, 'P Heru', 'PWI 2', '', '', 'Yakobus', 'Yakobus 3', 0.00, '14-Jul-21', '', '14-Jul-21', '', '', 'Sembuh', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(149, 97, 'B Heru', 'PWI 2', '', '', 'Yakobus', 'Yakobus 3', 0.00, '14-Jul-21', '', '14-Jul-21', '', '', 'Sembuh', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(150, 60, 'Imelda', 'Gayungsari Barat 3 / 11', '85706425559', '', 'Thomas', 'Thomas 5', 45.00, '6/29/2021', 'I', '', '-', '', 'Perawatan', 'Pengobatan lanjutan', '18-Jul-21', 'Sembako', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(151, 58, 'Emanuel Mario Calvindo', 'Gayung Kebonsari Manunggal Blok E-2', '81330718624', '', 'Thomas', 'Thomas 5', 25.00, '6/28/2021', '', '6/28/2021', '-', '', 'Sembuh', 'Pemulihan', '7/15/2021', 'Tidak Ada', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(152, 60, 'Imelda', 'Gayungsari Barat 3 / 11', '85706425559', '', 'Thomas', 'Thomas 5', 45.00, '6/29/2021', '', '6/29/2021', '-', '', 'Sembuh', 'Pemulihan', '18/7/2021', 'Sembako', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(153, 65, 'Indah Kartika', 'Gayungsari Barat 3 / 80', '8155221688', '', 'Thomas', 'Thomas 5', 44.00, '7/10/2021', 'I', '', '-', '', 'Pemulihan', 'Masa penyembuhan', '', 'Tidak Ada', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(154, 61, 'Meiliana Kumala', 'Gayungsari Barat 3 / 11', '81230889977', '', 'Thomas', 'Thomas 5', 35.00, '7/1/2021', 'I', '', '-', '', 'Pemulihan', 'Menunggu hasil PCR', '', 'Sembako', 'S', 'AZ', 'AZ', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(155, 62, 'Reni Handono', 'Gayungsari Barat 3 / 11', '85106405553', '', 'Thomas', 'Thomas 5', 49.00, '7/1/2021', 'I', '', '-', '', 'Perawatan', 'Pengobatan lanjutan', '14-Jul-21', 'Sembako', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(156, 59, 'Rosiana Hardjo Ali', 'Gayung Kebonsari Manunggal Blok E-2', '81330606075', '', 'Thomas', 'Thomas 5', 52.00, '6/28/2021', 'I', '', '-', '', 'Sembuh', 'Sembuh', '7/16/2021', 'Tidak Ada', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(157, 63, 'Sigit Honggowijono', 'Gayungsari Barat 3 / 11', '8113405929', '', 'Thomas', 'Thomas 5', 38.00, '7/3/2021', 'I', '', '7-Jul-21', 'RS Premier', 'Pemulihan', 'Penyembuhan', '', 'Sembako', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(158, 64, 'Yanti Wiriantono', 'Gayungsari Barat 3 / 11', '82141103969', '', 'Thomas', 'Thomas 5', 70.00, '7/1/2021', 'I', '', '-', '', 'Perawatan', 'dalam pengobatan lanjutan', '14-Jul-21', 'Sembako', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(159, 166, 'Vincentius Paulus Januar Honggowijono', 'Gayungsari Barat 3 / 11', '85100222362', '', 'Thomas', 'Thomas 5', 74.00, '1/7/2021', '', '1/7/2021', '-', '', 'Meninggal', '', '16/7/2021', 'Sembako', '', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(160, 165, 'Vincent (putra Bp Heru)', 'Taruna', '', '', 'Yakobus', 'Yakobus 3', 0.00, '1r-Jul-21', 'Y', '14-Jul-21', '', '', 'Pemulihan', 'Menunggu hasil PCR yg kedua', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(161, 77, 'Wahyu Mustika Roesli', 'Wisma Pagesangan 3/12', '816519132', '', 'Thomas', 'Thomas 6', 27.00, '17-Jul-21', 'I', '', '-', '', 'Sembuh', 'Sembuh', '10-Jul-21', 'Tidak Ada', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(162, 76, 'Naniek Hjang Puspita', 'Wisma Pagesangan 3/12', '816519132', '', 'Thomas', 'Thomas 6', 61.00, '17-Jun-21', 'I', '', '-', '', 'Sembuh', 'Sembuh', '10-Jul-21', 'Tidak Ada', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(163, 75, 'Honowahjoedi Roesli', 'Wisma Pagesangan 3/12', '816519132', '', 'Thomas', 'Thomas 6', 62.00, '19-Jun-21', 'I', '', '-', '', 'Sembuh', 'Sembuh', '10-Jul-21', 'Tidak Ada', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(164, 73, 'Yosef Suparno', 'Menanggal Indah VIII/15', '82234598146', '', 'Thomas', 'Thomas 6', 75.00, '7/14/2021', '', '', '-', '', 'Sembuh', 'Masih lemas', '27/7/2021', 'Obat dan Vitamin', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(165, 73, 'Yosef Suparno', 'Menanggal Indah VIII/15', '82234598146', '', 'Thomas', 'Thomas 6', 75.00, '14/07/2021', '', '', '-', '', 'Sembuh', 'Masih lemas', '27/7/2021', 'Obat dan Vitamin', 'S', 'Sinovac', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(166, 72, 'Tiara Marfamasta', 'Menanggal Indah VIII/15', '81803806621', '', 'Thomas', 'Thomas 6', 40.00, '7/14/2021', '', '', '-', '', 'Sembuh', '', '27/7/2021', 'Obat dan Vitamin', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(167, 74, 'Rio Lidianto Krishermono', 'Wisma Menanggal V/12', '85101902016', '', 'Thomas', 'Thomas 6', 43.00, '13-Jul-21', 'I', '', '15-Jul-21', 'Asrama Haji Surabaya', 'Perawatan', 'masih sakit', '', 'Sembako', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(168, 168, 'Kasiyani', 'Wisma Pagesangan 2/ 12', '', '', 'Thomas', 'Thomas 6', 0.00, '22/07/2021', '', '', '-', '', 'Pemulihan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(169, 71, 'Suprijadi Limpahsindu', 'Gayungsari Barat X/24', '81330373984', '', 'Thomas', 'Thomas 6', 74.00, '7/11/2021', 'I', '', '-', '', 'Perawatan', 'masih batuk.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(170, 66, 'Felix Rinaldo Limpahsindu', 'Gayungsari Barat X/24', '85233546014', '', 'Thomas', 'Thomas 6', 40.00, '7/9/2021', 'I', '', '-', '', 'Perawatan', 'Batuk agak keras.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(171, 67, 'Michael Jason Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889', '', 'Thomas', 'Thomas 6', 11.00, '7/11/2021', 'I', '', '-', '', 'Perawatan', 'Batuk pilek.', '', 'Dukungan Doa', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(172, 68, 'Natalia Liana Susanti', 'Gayungsari Barat X/24', '81330373984', '', 'Thomas', 'Thomas 6', 74.00, '7/11/2021', 'I', '', '-', '', 'Perawatan', 'masih batuk.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(173, 147, 'Romualdus Sugiyanto', 'Jl Jatisari Besar 3/62', '', '', 'Petrus', 'Petrus 1', 50.00, '25 Juli 2021', 'Y', '26 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Astra Zeneca', 'Astra Zeneca', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(174, 68, 'Natalia Liana Susanti', 'Gayungsari Barat X/24', '81330373984', '', 'Thomas', 'Thomas 6', 74.00, '11/07/2021', '', '', '-', '', 'Sembuh', 'masih batuk.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(175, 69, 'Scarlette Cathlyn Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889.', '', 'Thomas', 'Thomas 6', 9.00, '7/11/2021', 'I', '', '-', '', 'Sembuh', 'Baik, ceria.', '', 'Bantuan Doa', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(176, 67, 'Michael Jason Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889', '', 'Thomas', 'Thomas 6', 11.00, '11/07/2021', '', '', '-', '', 'Sembuh', 'Batuk pilek.', '', 'Dukungan Doa', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(177, 66, 'Felix Rinaldo Limpahsindu', 'Gayungsari Barat X/24', '85233546014', '', 'Thomas', 'Thomas 6', 40.00, '09/07/2021', '', '', '-', '', 'Sembuh', 'Batuk agak keras.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(178, 70, 'Sherly Lahonta', 'Gayungsari Barat X/24', '8113392889', '', 'Thomas', 'Thomas 6', 40.00, '7/11/2021', 'I', '', '-', '', 'Sembuh', 'tidak ada keluhan, masih isoman, banyak istirahat.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(179, 70, 'Sherly Lahonta', 'Gayungsari Barat X/24', '8113392889', '', 'Thomas', 'Thomas 6', 40.00, '7/11/2021', '', '', '-', '', 'Sembuh', '', '05/08/2021', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(180, 71, 'Suprijadi Limpahsindu', 'Gayungsari Barat X/24', '81330373984', '', 'Thomas', 'Thomas 6', 74.00, '11/07/2021', '', '', '-', '', 'Sembuh', 'masih batuk.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(181, 167, 'Sri Maharani Indah', 'Menanggal Indah VI/ 24', '', '', 'Thomas', 'Thomas 6', 0.00, '19/7/2021', 'Y', '', '', '', 'Sembuh', '', '2/8/2021', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(182, 67, 'Michael Jason Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889', '', 'Thomas', 'Thomas 6', 11.00, '11/07/2021', '', '', '-', '', 'Pemulihan', 'Batuk pilek.', '', 'Dukungan Doa', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(183, 68, 'Natalia Liana Susanti', 'Gayungsari Barat X/24', '81330373984', '', 'Thomas', 'Thomas 6', 74.00, '11/07/2021', '', '', '-', '', 'Pemulihan', 'masih batuk.', '', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(184, 69, 'Scarlette Cathlyn Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889.', '', 'Thomas', 'Thomas 6', 9.00, '7/11/2021', '', '', '-', '', 'Pemulihan', 'Baik, ceria.', '', 'Bantuan Doa', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(185, 148, 'Aditya', 'Jl Jatisari besar gang langgar no 66', '', '', 'Petrus', 'Petrus 1', 0.00, '', 'Y', '26 Juli 2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(186, 116, 'Alexandro', 'Pondok Wage Indah II BLOK r-16', '82132099550', '', 'Yakobus', 'Yakobus 4', 16.00, '12 Juli-21', 'I', '', '-', '', 'Perawatan', 'masih isoman', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(187, 120, 'Tri Harmanto', 'Pondok Wage Indah II BLOK U-9', '82143552633', '', 'Yakobus', 'Yakobus 4', 56.00, '15 Juli-21', '', '', '21-07-2021', 'RKZ Surabaya', 'Perawatan', 'Kritis di RKZ', '27-07-2021', 'Alat Pernafasan/oxygen', 'S', 'AZ', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(188, 160, 'yuliastuti', 'pondok wage indah 2 blok R-09', '0895406194999', 'AB/+', 'Yakobus', 'Yakobus 4', 55.00, '26-07-2021', 'Y', '27-07-2021', '', '', 'Perawatan', 'isoman', '31-07-2021', 'RAWAT JALAN', 'S', 'SINOVAC', 'SINOVAC', '2021-01-12', '2021-03-12', 'Y', 'S', NULL, NULL, ''),
(189, 111, 'Emerentia Giovani', 'Pondok Wage Indah II BLOK d-18', '85707772416', '', 'Yakobus', 'Yakobus 4', 16.00, '12 Juli-21', 'Y', '24-07-2021', '11 Juli-21', '', 'Perawatan', 'isoman', '26-07-2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(190, 169, 'Gabriel Danang Victoriawan', 'Menanggal Indah VI/ 24', '', '', 'Thomas', 'Thomas 6', 39.00, '19/07/2021', 'Y', '', '', '', 'Meninggal', '', '19/07/2021', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(191, 102, 'FX. Rahardjo', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '19-Jul-21', 'I', '', '18-Jul-21', 'RS Anwar Medika Krian', 'Meninggal', 'Meninggal', '20-Jul-21', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(192, 104, 'Ibu Hubaekar', 'Taman Aloha', '', '', 'Yakobus', 'Yakobus 3', NULL, '22-Jul-21', 'I', '22-Jul-21', '', '', 'Pemulihan', 'Pemulihan', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(193, 144, 'Maria Marsha Magdalena (anak B Hurint)', 'PWI 1 Sda', '', NULL, 'Yakobus', 'Yakobus 3', 21.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(194, 143, 'Monica Asha Benning (anak B Hurint)', 'PWI 1 Sda', '+62 877-5724-7761', '', 'Yakobus', 'Yakobus 3', 25.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(195, 161, 'bu ariyadi', 'pondok wage indah 2 blok p-33', '', '', 'Yakobus', 'Yakobus 4', 52.00, '14-07-2021', 'T', '', '', 'rumah sakit rkz', 'Perawatan', 'bantuan oxygen', '30-07-2021', 'oxygen', '', '', '', '0000-00-00', '0000-00-00', '', 'B', NULL, NULL, ''),
(196, 160, 'yuliastuti', 'pondok wage indah 2 blok R-09', '0895406194999', 'AB/+', 'Yakobus', 'Yakobus 4', 55.00, '26-07-2021', 'Y', '27-07-2021', '', '', 'Perawatan', 'isoman', '09-08-2021', 'RAWAT JALAN', 'S', 'SINOVAC', 'SINOVAC', '2021-01-12', '2021-03-12', 'Y', 'S', NULL, NULL, ''),
(197, 162, 'Theresia Sadiyem', 'pagesangan IIIa/7', '085816426478', '', 'Blasius', 'Blasius 5', 74.00, '26 Juli 2021', 'Y', '26 JUli 2021', '-', '-', 'Pemulihan', '', '', 'belum mendapat bantuan', 'S', '', '', '0000-00-00', '0000-00-00', 'Y', 'S', NULL, NULL, ''),
(198, 83, 'Marcus Yudhi', 'Perum Grand Royal Edelweiis i4 No14 Suko', '8123065030', '-', 'Yakobus', 'Yakobus 1', 40.00, '4-Jul-21', 'Y', '4-30 Juli 2021', '-', '', 'Pemulihan', ' Stabil', '30 juli 2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(199, 78, 'Anastasia Eny Kusrini', 'Jl. Bohar Timur 31 Bohar Taman Sidoarjo', '85645141864', 'B/+', 'Yakobus', 'Yakobus 1', 54.00, '29-Jun-21', '', '', '2-Jul-21', 'RSKZ', 'Pemulihan', 'belum stabil', '30 juli 2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(200, 22, 'Agus Suradi', 'Pagesangan Agung GG 1/45', '87851213733', '', 'Blasius', 'Blasius 4', NULL, '18-Jul-21', 'I', '', '21-Jul-21', 'RKZ', 'Perawatan', '', '', '', 'S', 'v', 'AZ', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(201, 23, 'Desi (Putri P Agus Suradi)', 'Pagesangan Agung GG 1/45', '', '', 'Blasius', 'Blasius 4', NULL, '21-Jul-21', 'I', '21-Jul-21', '', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(202, 57, 'A. E. Haryo Prasetianto', 'Jemur Gayungan II / 49', '87878310099', '', 'Thomas', 'Thomas 3', 46.00, '6/29/2021', 'I', '', '-', '', 'Pemulihan', 'Proses Pemulihan', '', 'Tidak Ada', 'S', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(203, 168, 'Kasiyani', 'Wisma Pagesangan 2/ 12', '', '', 'Thomas', 'Thomas 6', 0.00, '22/07/2021', '', '', '-', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(204, 67, 'Michael Jason Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889', '', 'Thomas', 'Thomas 6', 11.00, '11/07/2021', '', '', '-', '', 'Pemulihan', '', '08/08/2021', 'Dukungan Doa', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(205, 68, 'Natalia Liana Susanti', 'Gayungsari Barat X/24', '81330373984', '', 'Thomas', 'Thomas 6', 74.00, '11/07/2021', '', '', '-', '', 'Pemulihan', '', '08/08/2021', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(206, 69, 'Scarlette Cathlyn Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889.', '', 'Thomas', 'Thomas 6', 9.00, '7/11/2021', '', '', '-', '', 'Pemulihan', 'Baik, ceria.', '08/08/2021', 'Bantuan Doa', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, '');
INSERT INTO `covid_history` (`id_history`, `id_covid`, `nama`, `alamat`, `hp`, `goldarah`, `wilayah`, `lingkungan`, `umur`, `tgl_positif`, `isoman`, `tgl_isoman`, `tgl_opname`, `nama_rs`, `monitor_kondisi`, `monitor_note`, `monitor_tgl`, `bantuan`, `vaksin`, `merk1`, `merk2`, `tgl_vaksin1`, `tgl_vaksin2`, `komorbid`, `hamil`, `updated_by`, `updated_date`, `id_umat`) VALUES
(207, 69, 'Scarlette Cathlyn Rinaldo', 'Gayungsari Barat X/24', '085233546014 / 08113392889.', '', 'Thomas', 'Thomas 6', 9.00, '7/11/2021', '', '', '-', '', 'Pemulihan', 'Baik, ceria.', '14/08/2021', 'Bantuan Doa', 'S', '', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(208, 164, 'Cosmas Circus Widyolelono', 'Pondok Wage Indah 2 Blok OO - 2', '088217031541', '', 'Yakobus', 'Yakobus 5', 52.00, '05-08-2021', 'Y', '06-08-2021', '06-08-2021', 'RKZ', 'Pemulihan', '', '', '', 'S', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(209, 164, 'Cosmas Circus Widyolelono', 'Pondok Wage Indah 2 Blok OO - 2', '088217031541', '', 'Yakobus', 'Yakobus 5', 52.00, '', 'Y', '06-08-2021', '06-08-2021', 'RKZ', 'Sembuh', 'Sakit Vertigo (tidak positif covid)', '', '', 'S', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(210, 154, 'JULIA DWI HARIJANI', 'Jambangan Xb / 41 b', '+62 812-1847-0471', 'B/+', 'Blasius', 'Blasius 2', 54.00, '30 Juli 2021', 'T', '', '', 'Lapangan Tembak Kedung Cowek ', 'Perawatan', '', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(211, 20, 'Stefanus Bambang Setia Budi', 'Kebonsari gang 7b no 10', '81217420265', '', 'Blasius', 'Blasius 3', 60.00, 'Juli 2021', '', '', 'V', 'RKZ', 'Pemulihan', '', '', '', 'S', 'v', 'v', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(212, 122, 'Naomi Kayatun', 'PWI 2 Blok EE - 15', '8121772925', '', 'Yakobus', 'Yakobus 5', 44.00, '7/19/2021', 'I', '7/19/2021', '', '', 'Pemulihan', '', '', '', 'S', 'Sinovac', 'Sinovac', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(213, 122, 'Naomi Kayatun', 'PWI 2 Blok EE - 15', '8121772925', '', 'Yakobus', 'Yakobus 5', 44.00, '7/19/2021', '', '7/19/2021', '', '', 'Sembuh', '', '22-08-2021', '', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(214, 129, 'Romanus Ruslan', 'PWI 2 Blok OO - 20', '81216361240', '', 'Yakobus', 'Yakobus 5', 48.00, '7/21/2021', '', '7/22/2021', '', '', 'Pemulihan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(215, 122, 'Naomi Kayatun', 'PWI 2 Blok EE - 15', '8121772925', '', 'Yakobus', 'Yakobus 5', 44.00, '7/19/2021', '', '7/19/2021', '', '', 'Sembuh', '', '22-08-2021', '', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(216, 122, 'Naomi Kayatun', 'PWI 2 Blok OO - 20', '8121772925', '', 'Yakobus', 'Yakobus 5', 44.00, '7/19/2021', '', '7/19/2021', '', '', 'Sembuh', '', '22-08-2021', '', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(217, 142, 'Maria Goretti Hurint', 'PWI 1 Sda', '0812-3245-6002', '', 'Yakobus', 'Yakobus 3', 59.00, '25 Juli 2021', 'Y', '25 Juli 2021', '', '', 'Pemulihan', 'Berobat ke klinik Rafael Rkz', '25 jul 2021', '', 'S', 'Sinovac', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(218, 165, 'Vincent (putra Bp Heru)', 'Taruna', '', '', 'Yakobus', 'Yakobus 3', 0.00, '14-Jul-21', 'Y', '14-Jul-21', '', '', 'Pemulihan', 'Menunggu hasil PCR yg kedua', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(219, 32, 'Nicholas Maryanto', 'Pagesangan Timur gg makam', '81330104837', 'A/+', 'Blasius', 'Blasius 5', 45.00, '14-Jul-21', '', '14-Jul-21', '18-Jul-21', 'RSUD Bangkalan', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(220, 18, 'YCR Bambang Rahardjo', 'Jl. Kebonsari V/33 Surabaya', '85102779836', '', 'Blasius', 'Blasius 3', 70.00, 'Juli 2021', '', '', 'V', 'RKZ', 'Pemulihan', '', '', '', 'S', 'v', 'v', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(221, 96, 'Maria Mujiyem', 'TPL IV Blok H-25', '', '', 'Yakobus', 'Yakobus 2', 60.00, '', 'I', '', '-', 'Puskesmas Sukodono', 'Perawatan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(222, 170, 'ANTONIUS IWAN SOEGIHARTO', 'JAMBANGAN VII E / 8', '0821-3957-8901', 'A/+', 'Blasius', 'Blasius 2', 48.00, '14 Agustus ', 'Y', '14 Agustus ', '', '', 'Perawatan', 'Isoman di BLITAR', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', 'Y', '', NULL, NULL, ''),
(223, 170, 'ANTONIUS IWAN SOEGIHARTO', 'JAMBANGAN VII E / 8', '0821-3957-8901', 'A/+', 'Blasius', 'Blasius 2', 48.00, '14 Agustus ', 'Y', '14 Agustus ', '', '', 'Sembuh', 'Isoman di BLITAR', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', 'Y', '', NULL, NULL, ''),
(224, 147, 'Romualdus Sugiyanto', 'Jl Jatisari Besar 3/62', '', '', 'Petrus', 'Petrus 1', 50.00, '25 Juli 2021', 'Y', '26 Juli 2021', '', '', 'Pemulihan', '', '', '', 'S', 'Astra Zeneca', 'Astra Zeneca', '2021-03-30', '2021-06-30', 'N', '', NULL, NULL, ''),
(225, 171, 'Jack Melando Paulus Kalangi', 'Jl. Taruna 38 Wage', '082234159017', '', 'Yakobus', 'Yakobus 2', 37.00, '', 'Y', '', '', '', 'Sembuh', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(226, 66, 'Felix Rinaldo Limpahsindu', 'Gayungsari Barat X/24', '85233546014', '', 'Thomas', 'Thomas 6', 40.00, '09/07/2021', '', '', '-', '', 'Sembuh', 'Batuk agak keras.', '03/08/2021', 'Bantuan Doa', 'S', 'Sinovac', 'Sinovac', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(227, 73, 'Yosef Suparno', 'Menanggal Indah VIII/15', '82234598146', '', 'Thomas', 'Thomas 6', 75.00, '14/07/2021', '', '', '-', '', 'Sembuh', 'Masih lemas', '27/07/2021', 'Obat dan Vitamin', 'S', 'Sinovac', '', '0000-00-00', '0000-00-00', 'N', 'S', NULL, NULL, ''),
(228, 171, 'Jack Melando Paulus Kalangi', 'Jl. Taruna 38 Wage', '082234159017', '', 'Yakobus', 'Yakobus 2', 37.00, '', 'Y', '', '', '', 'Perawatan', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(229, 32, 'Nicholas Maryanto', 'Pagesangan Timur gg makam', '81330104837', 'A/+', 'Blasius', 'Blasius 5', 45.00, '14-Jul-21', '', '14-Jul-21', '18-Jul-21', 'RSUD Bangkalan', 'Perawatan', '', '', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(230, 32, 'Nicholas Maryanto', 'Pagesangan Timur gg makam', '81330104837', 'A/+', 'Blasius', 'Blasius 5', 45.00, '14-Jul-21', '', '14-Jul-21', '18-Jul-21', 'RSUD Bangkalan', 'Sembuh', 'Swab Antigen', '24/09/2021', '', 'B', '', '', '0000-00-00', '0000-00-00', 'N', 'B', NULL, NULL, ''),
(231, 52, 'Frisca Slamet', 'argopuro 8', '0851-0276-6469', '', 'Petrus', 'Petrus 2', 68.00, '7/10/2021', 'I', '10-Jul-21', '-', '', 'Pemulihan', '', '', '', 'B', '', '', NULL, NULL, 'N', 'S', NULL, NULL, ''),
(232, 172, 'Yohanes Baptista Taryono', 'Jambangan IV / 11-B', '', '', 'Blasius', 'Blasius 1', 75.00, '18/09/2021', 'T', '', '16/09/2021', 'RSAL', 'Perawatan', '', '20/09/2021', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(233, 151, 'Stefanus Pepen Kurniawan', 'KEBONSARI NO 19', '+62 878-5545-5980', '', 'Blasius', 'Blasius 2', 42.00, '18 Juli 2021', 'Y', '18 Juli 2021', '', '', 'Sembuh', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', '', NULL, NULL, ''),
(234, 152, 'Marsella Monica Christy', 'KEBONSARI NO 19', '+62 878-5545-5980', '', 'Blasius', 'Blasius 2', 42.00, '19 juli 2021', 'Y', '19 juli 2021', '', '', 'Sembuh', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(235, 154, 'JULIA DWI HARIJANI', 'Jambangan Xb / 41 b', '+62 812-1847-0471', 'B/+', 'Blasius', 'Blasius 2', 54.00, '30 Juli 2021', 'T', '', '', 'Lapangan Tembak Kedung Cowek ', 'Sembuh', '', '', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', '', 'S', NULL, NULL, ''),
(236, 170, 'ANTONIUS IWAN SOEGIHARTO', 'JAMBANGAN VII E / 8', '0821-3957-8901', 'A/+', 'Blasius', 'Blasius 2', 48.00, '14 Agustus ', 'Y', '14 Agustus ', '', '', 'Sembuh', '', '28 Agst 2021', '', 'S', 'sinovac', 'sinovac', '0000-00-00', '0000-00-00', 'Y', '', NULL, NULL, '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `covid_history`
--
ALTER TABLE `covid_history`
  ADD PRIMARY KEY (`id_history`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `covid_history`
--
ALTER TABLE `covid_history`
  MODIFY `id_history` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=237;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
