05-07-23, 12:34 PM
website: rockpointlegalfunding.com
Format - .SQL
Size sql file - 5GB
Date - 2023
All Rows - 9kk
SAMPLE
Format - .SQL
Size sql file - 5GB
Date - 2023
All Rows - 9kk
Code:
INSERT INTO `user_activity_log` (`id`, `created_on`, `requested_uri`, `resource_type`, `resource_id`, `payload`, `message`, `response_code`, `user_id`, `user_name`, `request_method`) VALUES
INSERT INTO `sms_messages` (`id`, `applicant_id`, `from_number`, `to_number`, `body`, `account_sid`, `messaging_service_sid`, `message_sid`, `status`, `segments`, `direction`, `error_code`, `error_message`, `accepted_at`, `queued_at`, `sending_at`, `sent_at`, `receiving_at`, `received_at`, `delivered_at`, `undelivered_at`, `failed_at`, `raw_data`, `action_taken_by`, `action_taken_at`, `send_by_id`) VALUES
INSERT INTO `data_history_log` (`id`, `logged_user_id`, `logged_user_name`, `context`, `action`, `entity`, `entity_id`, `diff`, `ip`, `location`, `created_at`) VALUES
INSERT INTO `contract_documents` (`id`, `template_id`, `filename`, `local_path`, `created_on`, `state`, `docusign_status`, `docusign_envelope_id`, `docusign_sent_on`, `docusign_last_update_on`, `docusign_recipients_mapping`, `docusign_data`, `documents_status`, `title`, `funding_contract_id`) VALUESSAMPLE
Code:
INSERT INTO `user_activity_log` (`id`, `created_on`, `requested_uri`, `resource_type`, `resource_id`, `payload`, `message`, `response_code`, `user_id`, `user_name`, `request_method`) VALUES
(UNHEX('F7E18800C05F4EFBABA829DB902A5341'), '2018-09-05 22:28:08', '/api/fundings/11857', NULL, NULL, '{\"wireDate\": {\"day\": 5, \"year\": 2018, \"month\": 9}, \"checkDate\": {\"day\": null, \"year\": null, \"month\": null}, \"wireAmount\": 403, \"checkAmount\": null, \"checkNumber\": null, \"feesCharged\": 97, \"checkCashedDate\": {\"day\": null, \"year\": null, \"month\": null}, \"fundsReceivmentOption\": \"5\", \"wireConfirmationNumber\": \"MTCN : 508-896-4387\"}', 'Universal patch method - Funding', 200, 2027, '[email protected]', 'PATCH'),
(UNHEX('F7E18852C1F441CA800930D1AE39D4AA'), '2019-05-01 17:25:15', '/api/fundings/17498', NULL, NULL, '{\"instructions\": \"Standard Contract 3 month tranche $ 4,000 10% JG FEE Free Delivery send me a PDF\"}', 'Universal patch method - Funding', 200, 1587, '[email protected]', 'PATCH'),
(UNHEX('F7E1AD717B93456C9548618B74FF245C'), '2023-03-16 17:59:27', '/api/auth/login', NULL, NULL, '{\"username\":\"[email protected]\",\"password\":\"**MASKED**\",\"oneTimeToken\":\"**MASKED**\"}', 'Login attempt successful for username: [email protected].', 200, 9802, '[email protected]', 'POST'),
(UNHEX('F7E1BD98CC55461B8324C4E17368F263'), '2018-10-16 20:26:39', '/api/fundings/12837', NULL, NULL, '{\"plaintiffWhiteboardStatus\": \"ready_for_payment\"}', 'Universal patch method - Funding', 200, 721, '[email protected]', 'PATCH'),
(UNHEX('F7E1E08D7B1D4B4D89EEC5EB6C42CB89'), '2020-12-09 18:09:19', '/api/fundings/32242', NULL, NULL, '{\"dateToFollowUp\": \"2020-12-09\"}', 'Universal patch method - Funding', 200, 1511, '[email protected]', 'PATCH'),
(UNHEX('F7E217668D564C1EA6B97C7CC66B6AA5'), '2017-04-05 18:27:04', '/api/fundings/2849', NULL, NULL, '{\"checkDate\": {\"day\": 30, \"year\": 2017, \"month\": 3}, \"checkAmount\": 500, \"checkNumber\": \"2182\", \"feesCharged\": 0, \"checkCashedDate\": {\"day\": 4, \"year\": 2017, \"month\": 4}, \"fundsReceivmentOption\": \"4\"}', 'Universal patch method - Funding', 200, 899, '[email protected]', NULL),
(UNHEX('F7E24AE48ECF4C94BFB8E960E273B024'), '2019-07-02 20:15:50', '/api/applicants/10147', NULL, NULL, '{\"collectabilityStatus\": \"20\"}', 'Universal patch method', 200, 3888, '[email protected]', 'PATCH'),
(UNHEX('F7E28992C8334B288F524C4A24DCD36E'), '2019-07-09 18:14:43', '/api/fundings/16162', NULL, NULL, '{\"medicalWhiteboardStatus\": \"waiting_on_billing\"}', 'Universal patch method - Funding', 200, 4304, '[email protected]', 'PATCH'),
(UNHEX('F7E28B73D19849DFA27975A2D762D407'), '2021-05-14 17:23:48', '/api/fundings/35948', NULL, NULL, '{\"dateToFollowUp\": \"2021-05-14\"}', 'Universal patch method - Funding', 200, 7577, '[email protected]', 'PATCH'),
(UNHEX('F7E2968608F74BF88A8F6941F3608523'), '2019-09-11 23:27:55', '/api/fundings/20181', NULL, NULL, '{\"lienLetterSent\": true}', 'Universal patch method - Funding', 200, 4304, '[email protected]', 'PATCH'),
INSERT INTO `sms_messages` (`id`, `applicant_id`, `from_number`, `to_number`, `body`, `account_sid`, `messaging_service_sid`, `message_sid`, `status`, `segments`, `direction`, `error_code`, `error_message`, `accepted_at`, `queued_at`, `sending_at`, `sent_at`, `receiving_at`, `received_at`, `delivered_at`, `undelivered_at`, `failed_at`, `raw_data`, `action_taken_by`, `action_taken_at`, `send_by_id`) VALUES
(9087, 17488, 'rockpoint', '+19253517881', 'Hola Blanca, hemos intentado de comunicarnos para programar su cita para el MRI y Radiographia (XRay). Favor de regresarnos la llamada a Precise Imaging al 818-629-1169 para confirmar su cita, gracias.', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SM76317fc5758e47f5aab025a9c281ae79', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 17:27:03', '2020-10-05 17:27:04', NULL, '2020-10-05 17:27:04', NULL, NULL, '2020-10-05 17:27:04', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SM76317fc5758e47f5aab025a9c281ae79]\"]', NULL, NULL, 7398),
(9088, 18565, 'rockpoint', '+17276575585', 'Your Western Union MTCN from Rockpoint Legal Funding for $403 is 581-554-6779 (this is not a phone number).', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SMa00c8006db8e42d08582ad4c3a32cb1f', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 17:30:49', '2020-10-05 17:30:50', NULL, '2020-10-05 17:30:50', NULL, NULL, '2020-10-05 17:30:50', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SMa00c8006db8e42d08582ad4c3a32cb1f]\"]', NULL, NULL, 7493),
(9089, 18333, 'rockpoint', '+19516650349', 'Hello Mr. Smith, we have tried reaching out to you multiple times to reschedule your MRI appointment. Your attorney has also tried calling you with no success. Please give Precise imaging a call at 818-629-1169 to confirm your new appointment. Thank you', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SMcf15477a8cec47f2979b82bbd0e431f1', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 17:36:38', '2020-10-05 17:36:39', NULL, '2020-10-05 17:36:39', NULL, NULL, '2020-10-05 17:36:40', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SMcf15477a8cec47f2979b82bbd0e431f1]\"]', NULL, NULL, 7398),
(9090, 17769, 'rockpoint', '+16264066249', 'Hola Sr. Terrones, recuerde que su cita para la radiographia(XRay) es manana 10/6 2:30pm at Inview Imaging-Fremont, 39465 Paseo Padre Parkway Suite 1000 Fremont Ca, 94538. Tel: 818-629-1169', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SMe839e0093550450888a262fc42a9fc72', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 17:49:30', '2020-10-05 17:49:31', NULL, '2020-10-05 17:49:31', NULL, NULL, '2020-10-05 17:49:32', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SMe839e0093550450888a262fc42a9fc72]\"]', NULL, NULL, 7398),
(9091, 18298, 'rockpoint', '+16262726719', 'Hello Juan, don\'t forget your MRI appointment is tomorrow 10/6 1pm at SoCal Imaging-Ontario, 1290 E. Elm St. Ontario Ca, 91761. Tel: 888-814-0206', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SM315d86da62f84dc4b2c7b8519f465427', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 17:51:20', '2020-10-05 17:51:21', NULL, '2020-10-05 17:51:21', NULL, NULL, '2020-10-05 17:51:21', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SM315d86da62f84dc4b2c7b8519f465427]\"]', NULL, NULL, 7398),
(9092, 18468, 'rockpoint', '+19105819377', 'Hi Aram, don\'t forget your MRI appointment is tomorrow 10/6 8:30am at Silicon Valley MRI, 15405 Los Gatos Blvd. #104 Los Gatos Ca, 95032. Tel: 818-629-1169', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SM58890cb6369a4f4b8a8e0f7a5a44dc48', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 17:52:40', '2020-10-05 17:52:41', NULL, '2020-10-05 17:52:41', NULL, NULL, '2020-10-05 17:52:41', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SM58890cb6369a4f4b8a8e0f7a5a44dc48]\"]', NULL, NULL, 7398),
(9093, 10573, 'rockpoint', '+13108645517', 'Your Western Union MTCN from Rockpoint Legal Funding for $2403 is 995-749-7041 (this is not a phone number).', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SMa1712a2cea5e4b858d71c6d41408f2f6', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 18:39:56', '2020-10-05 18:39:57', NULL, '2020-10-05 18:39:57', NULL, NULL, '2020-10-05 18:39:58', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SMa1712a2cea5e4b858d71c6d41408f2f6]\"]', NULL, NULL, 7059),
(9094, 12546, 'rockpoint', '+15303940135', 'Your Western Union MTCN from Rockpoint Legal Funding for $903 is 901-279-2873 (this is not a phone number).', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SM21f85ff7f3be4819944ae5674b9ed72c', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 19:59:22', '2020-10-05 19:59:22', NULL, '2020-10-05 19:59:23', NULL, NULL, '2020-10-05 19:59:23', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SM21f85ff7f3be4819944ae5674b9ed72c]\"]', NULL, NULL, 721),
(9095, 18566, 'rockpoint', '+15206580875', 'Your Western Union MTCN from Rockpoint Legal Funding for $903 is 456-287-4008 (this is not a phone number).', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SMa0708c0300ce4be3982c8b7249e55190', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 21:52:13', '2020-10-05 21:52:14', NULL, '2020-10-05 21:52:14', NULL, NULL, '2020-10-05 21:52:15', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SMa0708c0300ce4be3982c8b7249e55190]\"]', NULL, NULL, 7493),
(9096, 12996, 'rockpoint', '+12138074653', 'Your Western Union MTCN from Rockpoint Legal Funding for $500 is 423-015-8557 (this is not a phone number).', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SM23739f3e22f244f79adba657585f23cd', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 22:19:33', '2020-10-05 22:19:34', NULL, '2020-10-05 22:19:34', NULL, NULL, '2020-10-05 22:19:34', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SM23739f3e22f244f79adba657585f23cd]\"]', NULL, NULL, 721),
(9097, 18543, 'rockpoint', '+19162367311', 'Your Western Union MTCN from Rockpoint Legal Funding for $500 is 706-033-7105 (this is not a phone number).', 'AC9aca337398a5178c51d1cd2117d93f32', 'MG176a8ac8e9b6189061e2113fac291d09', 'SM81efb23623c64d0583b430c32ffe0787', 'delivered', '0', 'outbound-api', NULL, NULL, '2020-10-05 23:03:51', '2020-10-05 23:03:52', NULL, '2020-10-05 23:03:52', NULL, NULL, '2020-10-05 23:03:53', NULL, NULL, '[\"[Twilio.Api.V2010.MessageInstance accountSid=AC9aca337398a5178c51d1cd2117d93f32 sid=SM81efb23623c64d0583b430c32ffe0787]\"]', NULL, NULL, 721),
INSERT INTO `data_history_log` (`id`, `logged_user_id`, `logged_user_name`, `context`, `action`, `entity`, `entity_id`, `diff`, `ip`, `location`, `created_at`) VALUES
(UNHEX('ED6EFDBB220E4FFE8AB0A23F906B8F57'), 7398, 'Luis Reyes', '[\"Misc\"]', 'update', 'Funding', 51146, '{\"dateToFollowUp\": {\"data\": [\"2022-08-12\", \"2022-08-22\"], \"title\": \"Date To Follow Up\"}}', '201.162.240.97', '{\"ip\": \"201.162.240.97\", \"loc\": \"19.4285,-99.1277\", \"org\": \"AS7438 Pegaso PCS, S.A. de C.V.\", \"city\": \"Mexico City\", \"postal\": \"03020\", \"region\": \"Mexico City\", \"country\": \"MX\", \"hostname\": \"pc20116224097.optele.net\", \"timezone\": \"America/Mexico_City\"}', '2022-08-12 20:34:21'),
(UNHEX('ED6F060F6ABF40B6B899AC34F087D09C'), 900, 'Mike Grijalva', '[\"Funding - Status\"]', 'update', 'Funding', 12756, '{\"readyForReview\": {\"data\": [null, true], \"title\": \"Ready for review\"}}', '172.113.248.84', '{\"ip\": \"172.113.248.84\", \"loc\": \"34.0256,-118.4720\", \"org\": \"AS20001 Time Warner Cable Internet LLC\", \"city\": \"Santa Monica\", \"phone\": \"310\", \"postal\": \"90404\", \"region\": \"California\", \"country\": \"US\", \"hostname\": \"cpe-172-113-248-84.socal.res.rr.com\"}', '2018-10-11 20:28:02'),
(UNHEX('ED6F087C1F2B46639B3DA60E9C10723C'), 2745, 'Travis Grant', '[\"Misc\"]', 'insert', 'ApplicantNote', 114688, '{\"content\": {\"data\": [null, \"10/08/18 TSG - Sent new contract waiving wiring fees.\"], \"title\": \"Content\"}, \"applicant\": {\"data\": [null, {\"id\": 5298, \"lastName\": \"Serna\", \"firstName\": \"Oscar\", \"internalId\": \"C105298-CA\", \"entityString\": \"Oscar Serna, C105298-CA\"}], \"title\": null}, \"createdBy\": {\"data\": [null, {\"id\": 2745, \"lastName\": \"Grant\", \"firstName\": \"Travis\", \"entityString\": \"Travis Grant\"}], \"title\": \"Created By\"}, \"createdOn\": {\"data\": [null, \"2018-10-08T17:38:28+0000\"], \"title\": \"Created On\"}, \"caseStatus\": {\"data\": [null, {\"id\": \"33\", \"title\": \"Arbitration/Mediation/Negotiation\", \"entityString\": \"Arbitration/Mediation/Negotiation\"}], \"title\": \"Case Status\"}, \"caseStatusFrom\": {\"data\": [null, {\"id\": \"33\", \"title\": \"Arbitration/Mediation/Negotiation\", \"entityString\": \"Arbitration/Mediation/Negotiation\"}], \"title\": \"Case Status\"}, \"totalFaceValue\": {\"data\": [null, 26295], \"title\": \"Total Face Value\"}, \"totalPrincipal\": {\"data\": [null, 17500], \"title\": \"Total Principal\"}, \"collectabilityStatus\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status\"}, \"collectabilityStatusFrom\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status From\"}}', '172.113.248.84', '{\"ip\": \"172.113.248.84\", \"loc\": \"34.0256,-118.4720\", \"org\": \"AS20001 Time Warner Cable Internet LLC\", \"city\": \"Santa Monica\", \"phone\": \"310\", \"postal\": \"90404\", \"region\": \"California\", \"country\": \"US\", \"hostname\": \"cpe-172-113-248-84.socal.res.rr.com\"}', '2018-10-08 17:38:28'),
(UNHEX('ED6F0D68C7B847B8A8DD79C055308F0E'), NULL, NULL, '[\"Misc\"]', 'update', 'ContractDocument', 6394, '{\"filename\": {\"data\": [null, \"PC109701-1-CA_Magdalena Scolari-Borunda_Standard_Contract_1000_100518.pdf\"], \"title\": \"File Name\"}}', '', '[]', '2018-10-05 22:30:20'),
(UNHEX('ED6F15B13F044EBA81731FAF6D2BCBC5'), 8656, 'Maria Flores', '[\"Misc\"]', 'update', 'Funding', 56215, '{\"whiteboardStatus\":{\"title\":\"Whiteboard Status\",\"data\":[{\"create_contract\":1},{\"contract_qc\":1}]}}', '187.213.22.69', '[]', '2022-12-02 21:06:26'),
(UNHEX('ED6F166A6E434661BB10D27ED15E1D65'), 7492, 'Ana Rojas', '[\"Misc\"]', 'insert', 'ApplicantNote', 359688, '{\"content\": {\"data\": [null, \"LVM- 4th FU on contract status inquiry\"], \"title\": \"Content\"}, \"callType\": {\"data\": [null, 2], \"title\": \"Call Type\"}, \"applicant\": {\"data\": [null, {\"id\": 18943, \"lastName\": \"Wang\", \"firstName\": \"John\", \"internalId\": \"C118943-CA\", \"entityString\": \"John Wang, C118943-CA\"}], \"title\": \"Applicant note\"}, \"createdBy\": {\"data\": [null, {\"id\": 7492, \"lastName\": \"Rojas\", \"firstName\": \"Ana\", \"entityString\": \"Ana Rojas\"}], \"title\": \"Created By\"}, \"createdOn\": {\"data\": [null, \"2020-11-30T17:13:45+00:00\"], \"title\": \"Created On\"}, \"callSubject\": {\"data\": [null, {\"id\": \"7\", \"title\": \"Contract Status Inquiry\", \"entityString\": \"Contract Status Inquiry\"}], \"title\": \"Call Subject\"}, \"caseStatusFrom\": {\"data\": [null, {\"id\": \"33\", \"title\": \"Arbitration/Mediation/Negotiation\", \"entityString\": \"Arbitration/Mediation/Negotiation\"}], \"title\": \"Case Status\"}, \"systemNoteType\": {\"data\": [null, \"default-note\"], \"title\": \"System Type Note\"}, \"callReceiverType\": {\"data\": [null, 1], \"title\": \"Call Receiver Type\"}, \"collectabilityStatusFrom\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status From\"}, \"healthcareTreatmentStageFrom\": {\"data\": [null, {\"id\": \"2612\", \"title\": \"In Treatment\", \"entityString\": \"In Treatment\"}], \"title\": \"Healthcare Treatment Stage From\"}}', '189.203.182.144', '{\"ip\": \"189.203.182.144\", \"loc\": \"22.1891,-100.9379\", \"org\": \"AS17072 TOTAL PLAY TELECOMUNICACIONES SA DE CV\", \"city\": \"Soledad de Graciano Sánchez\", \"postal\": \"78430\", \"region\": \"San Luis Potosí\", \"country\": \"MX\", \"hostname\": \"fixed-189-203-182-144.totalplay.net\", \"timezone\": \"America/Mexico_City\"}', '2020-11-30 17:13:45'),
(UNHEX('ED6F190851E9470AA0DD898C96F2059A'), 7493, 'Antonio Venegas', '[\"Funding - Timeline\"]', 'update', 'Funding', 38290, '{\"readyForPaymentOn\": {\"data\": [null, \"2021-07-15T22:15:06+00:00\"], \"title\": \"Ready for Payment On\"}, \"paymentsWhiteboardStatus\": {\"data\": [null, \"wire\"], \"title\": \"Payments Whiteboard Status\"}, \"plaintiffWhiteboardStatus\": {\"data\": [\"docs_in\", \"ready_for_payment\"], \"title\": \"Plaintiff Whiteboard Status\"}, \"whiteboardStatusChangedOn\": {\"data\": [\"2021-07-15T22:11:50+00:00\", \"2021-07-15T22:15:06+00:00\"], \"title\": \"Whiteboard Column Updated On\"}}', '187.190.224.228', '{\"ip\": \"187.190.224.228\", \"loc\": \"25.5439,-103.4190\", \"org\": \"AS17072 TOTAL PLAY TELECOMUNICACIONES SA DE CV\", \"city\": \"Torreón\", \"postal\": \"27010\", \"region\": \"Coahuila\", \"country\": \"MX\", \"hostname\": \"fixed-187-190-224-228.totalplay.net\", \"timezone\": \"America/Monterrey\"}', '2021-07-15 22:15:06'),
(UNHEX('ED6F1AD9A12C43DDA7FD1D9A1E4D02A0'), 7085, 'Carla Alvarez', '[\"Misc\"]', 'insert', 'ApplicantNote', 312069, '{\"content\": {\"data\": [null, \"emailed list for case status\"], \"title\": \"Content\"}, \"applicant\": {\"data\": [null, {\"id\": 10607, \"lastName\": \"Gardner\", \"firstName\": \"Lianna\", \"internalId\": \"C110607-CA\", \"entityString\": \"Lianna Gardner, C110607-CA\"}], \"title\": \"Applicant note\"}, \"createdBy\": {\"data\": [null, {\"id\": 7085, \"lastName\": \"Alvarez\", \"firstName\": \"Carla \", \"entityString\": \"Carla Alvarez\"}], \"title\": \"Created By\"}, \"createdOn\": {\"data\": [null, \"2020-07-09T23:29:50+0000\"], \"title\": \"Created On\"}, \"caseStatusFrom\": {\"data\": [null, {\"id\": \"29\", \"title\": \"Demand Letter Sent\", \"entityString\": \"Demand Letter Sent\"}], \"title\": \"Case Status\"}, \"systemNoteType\": {\"data\": [null, \"default-note\"], \"title\": \"System Type Note\"}, \"totalFaceValue\": {\"data\": [null, 67572.5], \"title\": \"Total Face Value\"}, \"totalPrincipal\": {\"data\": [null, 34000], \"title\": \"Total Principal\"}, \"collectabilityStatusFrom\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status From\"}, \"healthcareTreatmentStageFrom\": {\"data\": [null, {\"id\": \"2612\", \"title\": \"In Treatment\", \"entityString\": \"In Treatment\"}], \"title\": \"Healthcare Treatment Stage From\"}}', '177.240.153.58', '{\"ip\": \"177.240.153.58\", \"loc\": \"19.7008,-101.1844\", \"org\": \"AS27672 SERVICIO Y EQUIPO EN TELEFONÍA INTERNET Y TV S.A. DE C.V.\", \"city\": \"Morelia\", \"postal\": \"58000\", \"region\": \"Michoacán\", \"country\": \"MX\", \"hostname\": \"customer-mor-cgn-153-58.megared.net.mx\", \"timezone\": \"America/Mexico_City\"}', '2020-07-09 23:29:50'),
(UNHEX('ED6F1CCB66C648E08DE5B844FB0EEA75'), NULL, NULL, '[\"Misc\"]', 'insert', 'ApplicantNote', 560378, '{\"content\": {\"data\": [null, \"Funding **PC121960-1-CA** has been settled for $5272.25.\"], \"title\": \"Content\"}, \"noteType\": {\"data\": [null, \"settled\"], \"title\": \"Type\"}, \"applicant\": {\"data\": [null, {\"id\": 21960, \"lastName\": \"Bello\", \"firstName\": \"Amber\", \"internalId\": \"C121960-CA\", \"entityString\": \"Amber Bello, C121960-CA\"}], \"title\": \"Applicant note\"}, \"createdBy\": {\"data\": [null, {\"id\": 9799, \"lastName\": \"Ceja\", \"firstName\": \"Isaac\", \"entityString\": \"Isaac Ceja\"}], \"title\": \"Created By\"}, \"createdOn\": {\"data\": [null, \"2022-08-05T00:32:48+00:00\"], \"title\": \"Created On\"}, \"systemNoteType\": {\"data\": [null, \"default-note\"], \"title\": \"System Type Note\"}, \"totalFaceValue\": {\"data\": [null, \"27750\"], \"title\": \"Total Face Value\"}, \"totalPrincipal\": {\"data\": [null, \"15500\"], \"title\": \"Total Principal\"}}', '', '[]', '2022-08-05 00:32:48'),
(UNHEX('ED6F2B098DC3440A8762B37EB75313C6'), 900, 'Mike Grijalva', '[\"Funding - Status\"]', 'update', 'Funding', 11287, '{\"customerServiceRepresentative\": {\"data\": [null, {\"id\": 2384, \"lastName\": \"Wecker\", \"firstName\": \"Gennifer\", \"entityString\": \"Gennifer Wecker\"}], \"title\": \"CustomerServiceRepresentative\"}}', '172.113.248.84', '{\"ip\": \"172.113.248.84\", \"loc\": \"34.0256,-118.4720\", \"org\": \"AS20001 Time Warner Cable Internet LLC\", \"city\": \"Santa Monica\", \"phone\": \"310\", \"postal\": \"90404\", \"region\": \"California\", \"country\": \"US\", \"hostname\": \"cpe-172-113-248-84.socal.res.rr.com\"}', '2018-08-13 19:37:46'),
(UNHEX('ED6F2D89E12043D18C11CB5C89882379'), NULL, NULL, '[\"Misc\"]', 'update', 'ContractDocument', 26701, '{\"state\": {\"data\": [\"pending\", \"generated\"], \"title\": \"State\"}}', '', '[]', '2021-08-23 22:45:13'),
(UNHEX('ED6F32D2F5554AD1AC07546DB19FA760'), 8483, 'Esteban Olvera', '[\"Funding - Status\",\"Funding - Timeline\",\"Funding - Funds Delivery Options\"]', 'update', 'Funding', 54633, '{\"approvalStatus\":{\"title\":\"Approval Status\",\"data\":[1,2]},\"approvalStatusChangedOn\":{\"title\":\"Approval Status - Last Changed On\",\"data\":[\"2022-10-21T21:23:58+00:00\",\"2022-10-21T21:42:20+00:00\"]},\"fundedOn\":{\"title\":\"Funded On\",\"data\":[null,\"2022-10-21\"]},\"statusChangeFunded\":{\"title\":\"Status Change Funded\",\"data\":[null,\"2022-10-21T21:42:20+00:00\"]},\"checkAmount\":{\"title\":\"Check Amount\",\"data\":[\"0.00\",\"300\"]},\"dealState\":{\"title\":\"Deal State\",\"data\":[null,\"Funded\"]}}', '187.161.191.95', '{\"ip\":\"187.161.191.95\",\"hostname\":\"187.161.191.95-clientes-izzi.mx\",\"city\":\"Monterrey\",\"region\":\"Nuevo Le\\u00f3n\",\"country\":\"MX\",\"loc\":\"25.6592,-100.3242\",\"org\":\"AS11888 Television Internacional, S.A. de C.V.\",\"postal\":\"64723\",\"timezone\":\"America\\/Monterrey\"}', '2022-10-21 21:42:20'),
(UNHEX('ED6F3784AD59451D9121229E783CC641'), 4570, 'Daisy Carlos', '[\"Misc\", \"Attorney Information\"]', 'insert', 'Attorney', 5228, '{\"email\": {\"data\": [null, \"[email protected]\"], \"title\": \"Email\"}, \"phone\": {\"data\": [null, \"907 344 3434\"], \"title\": \"Phone\"}, \"active\": {\"data\": [null, true], \"title\": \"Active\"}, \"lawFirm\": {\"data\": [null, {\"entityString\": \"Schlehofer Law Offices P.C.\"}], \"title\": \"Law Firm\"}, \"lastName\": {\"data\": [null, \"Schlehofer \"], \"title\": \"Last Name\"}, \"firstName\": {\"data\": [null, \"Frank J.\"], \"title\": \"First Name\"}}', '75.82.144.194', '{\"ip\": \"75.82.144.194\", \"loc\": \"34.0268,-118.4733\", \"org\": \"AS20001 Charter Communications Inc\", \"city\": \"Santa Monica\", \"postal\": \"90404\", \"region\": \"California\", \"country\": \"US\", \"hostname\": \"cpe-75-82-144-194.socal.res.rr.com\"}', '2019-08-29 16:58:38'),
(UNHEX('ED6F3C6A0D7A4CF7930428F905CCE53A'), 4570, 'Daisy Carlos', '[\"Misc\", \"Applicant - Sources of Recovery\"]', 'update', 'Applicant', 13864, '{\"nonMedicalDealsCount\": {\"data\": [null, 1], \"title\": \"Pre Settlement Deals Count\"}, \"defendantsInsuranceProvider\": {\"data\": [null, []], \"title\": \"Defendant Insurance Provider\"}}', '75.82.144.194', '{\"ip\": \"75.82.144.194\", \"loc\": \"34.0268,-118.4733\", \"org\": \"AS20001 Charter Communications Inc\", \"city\": \"Santa Monica\", \"postal\": \"90404\", \"region\": \"California\", \"country\": \"US\", \"hostname\": \"cpe-75-82-144-194.socal.res.rr.com\", \"timezone\": \"America/Los_Angeles\"}', '2019-09-09 15:34:41'),
(UNHEX('ED6F3CE9B34F45B68557EC4CE20B4E65'), 8658, 'Luis Castro', '[\"Misc\", \"Applicant - Header\"]', 'update', 'Applicant', 25555, '{\"addressLat\": {\"data\": [null, 33.898603], \"title\": \"Latitude\"}, \"addressLng\": {\"data\": [null, -118.346973], \"title\": \"Longitude\"}, \"internalId\": {\"data\": [null, \"C125555-CA\"], \"title\": \"Applicant ID\"}, \"lawFirmManager\": {\"data\": [null, {\"id\": 8246, \"lastName\": \"Ruiz\", \"firstName\": \"Maria\", \"entityString\": \"Maria Ruiz\"}], \"title\": \"Law Firm Manager\"}, \"nextFundingNumber\": {\"data\": [1, 2], \"title\": \"Next Funding Number\"}, \"collectabilityStatus\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status\"}}', '189.203.100.192', '{\"ip\": \"189.203.100.192\", \"loc\": \"20.6558,-103.3428\", \"org\": \"AS17072 TOTAL PLAY TELECOMUNICACIONES SA DE CV\", \"city\": \"Guadalajara\", \"postal\": \"44658\", \"region\": \"Jalisco\", \"country\": \"MX\", \"hostname\": \"fixed-189-203-100-192.totalplay.net\", \"timezone\": \"America/Mexico_City\"}', '2022-05-20 21:22:17'),
(UNHEX('ED6F444EE6F04867B921913BF81C94C0'), 1909, 'Richard Brewer', '[\"Misc\"]', 'insert', 'ApplicantNote', 149357, '{\"content\": {\"data\": [null, \"sent payoff to fca\"], \"title\": \"Content\"}, \"applicant\": {\"data\": [null, {\"id\": 11000, \"lastName\": \"Usher\", \"firstName\": \"Arthur Godfrey\", \"internalId\": \"C111000-CA\", \"entityString\": \"Arthur Godfrey Usher, C111000-CA\"}], \"title\": null}, \"createdBy\": {\"data\": [null, {\"id\": 1909, \"lastName\": \"Brewer\", \"firstName\": \"Richard\", \"entityString\": \"Richard Brewer\"}], \"title\": \"Created By\"}, \"createdOn\": {\"data\": [null, \"2019-02-01T23:04:39+0000\"], \"title\": \"Created On\"}, \"caseStatus\": {\"data\": [null, {\"id\": \"36\", \"title\": \"Pre-Demand Letter\", \"entityString\": \"Pre-Demand Letter\"}], \"title\": \"Case Status\"}, \"caseStatusFrom\": {\"data\": [null, {\"id\": \"36\", \"title\": \"Pre-Demand Letter\", \"entityString\": \"Pre-Demand Letter\"}], \"title\": \"Case Status\"}, \"totalFaceValue\": {\"data\": [null, 3750], \"title\": \"Total Face Value\"}, \"totalPrincipal\": {\"data\": [null, 2500], \"title\": \"Total Principal\"}, \"collectabilityStatus\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status\"}, \"collectabilityStatusFrom\": {\"data\": [null, {\"id\": \"1\", \"title\": \"Normal\", \"entityString\": \"Normal\"}], \"title\": \"Collectability Status From\"}, \"healthcareTreatmentStage\": {\"data\": [null, {\"id\": \"2613\", \"title\": \"MMI Reached\", \"entityString\": \"MMI Reached\"}], \"title\": \"Healthcare Treatment Stage\"}, \"healthcareTreatmentStageFrom\": {\"data\": [null, {\"id\": \"2613\", \"title\": \"MMI Reached\", \"entityString\": \"MMI Reached\"}], \"title\": \"Healthcare Treatment Stage From\"}}', '75.82.144.194', '{\"ip\": \"75.82.144.194\", \"loc\": \"34.0256,-118.4720\", \"org\": \"AS20001 Charter Communications Inc\", \"city\": \"Santa Monica\", \"phone\": \"310\", \"postal\": \"90404\", \"region\": \"California\", \"country\": \"US\", \"hostname\": \"cpe-75-82-144-194.socal.res.rr.com\"}', '2019-02-01 23:04:39'),
(33702, NULL, 'PC127647-1-CA_Rigoberto Suarez Tapia_Dual_Sign_Contract_3000_110122.pdf', 'applicants/27647/_no-category/PC127647-1-CA/9e4fccd4354303a0203fb6fef150251390e2ba6a', '2022-11-01 20:00:53', 'signed', 'completed', 'd5d35088-dd30-4417-b411-e27f66b05f94', '2022-11-01 20:01:50', '2022-11-01 20:58:31', '{\"fb97cb9a-a252-4d75-9871-3355d3539b50\":\"1\",\"dcee8c83-d82b-4ca9-82ed-ac83b45f9ae7\":\"3\",\"85bbc87b-63fd-4346-bf1d-6c8577ed9c89\":\"2\"}', '{\"recipients\":{\"1\":{\"status\":\"completed\",\"name\":\"Ramin Ghaneeian\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T20:02:02.12Z\",\"signedOn\":\"2022-11-01T20:02:06.197Z\",\"sentOn\":\"2022-11-01T20:01:49.847Z\",\"declinedOn\":\"\"},\"3\":{\"status\":\"completed\",\"name\":\"Melody Parman\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T20:56:50.273Z\",\"signedOn\":\"2022-11-01T20:57:58.59Z\",\"sentOn\":\"2022-11-01T20:02:07.46Z\",\"declinedOn\":\"\"},\"2\":{\"status\":\"completed\",\"name\":\"Rigoberto Suarez Tapia\",\"email\":\"[email protected]\",\"tabs\":{\"How we helped\":\"Abc\",\"Bank\":null,\"Account Number\":null,\"Routing Number\":null,\"Address\":null,\"Delivery Type\":\"Western Union Money in Minutes\"},\"deliveredOn\":\"2022-11-01T20:36:59.377Z\",\"signedOn\":\"2022-11-01T20:44:28.373Z\",\"sentOn\":\"2022-11-01T20:02:07.773Z\",\"declinedOn\":\"\"}},\"status\":\"completed\"}', 'in', 'Dual Sign Contract', 40569),
(33703, NULL, 'PC127645-1-CA_Ana Neri_Dual_Sign_Contract_4000_110122.pdf', 'applicants/27645/_no-category/PC127645-1-CA/977f3a56450914f95cdb5a771aaa569ad469525b', '2022-11-01 20:09:20', 'signed', 'completed', 'a7b9d0cf-fc01-4a6f-8206-462fe1f7b0e1', '2022-11-01 20:17:47', '2022-11-02 15:10:22', '{\"45c6d303-547a-4b89-bff8-fb1166cb1a41\":\"1\",\"4c3f5270-6fdc-415c-a784-beb05574304c\":\"2\",\"1e8c9bee-3acf-4e0a-a37d-42a417e853f3\":\"3\"}', '{\"recipients\":{\"1\":{\"status\":\"completed\",\"name\":\"Ramin Ghaneeian\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T20:17:58.32Z\",\"signedOn\":\"2022-11-01T20:18:00.74Z\",\"sentOn\":\"2022-11-01T20:17:46.917Z\",\"declinedOn\":\"\"},\"2\":{\"status\":\"completed\",\"name\":\"Ana Neri\",\"email\":\"[email protected]\",\"tabs\":{\"Address\":\"1315 W Cara Dr. Anaheim Ca 92805\",\"How we helped\":\"This helped my family and I so much. We would be homeless if it wasn\'t for this loan. \",\"Bank\":null,\"Account Number\":null,\"Routing Number\":null,\"Delivery Type\":\"Check by First Class Mail\"},\"deliveredOn\":\"2022-11-01T20:24:51.907Z\",\"signedOn\":\"2022-11-01T20:26:24.057Z\",\"sentOn\":\"2022-11-01T20:18:02.163Z\",\"declinedOn\":\"\"}},\"status\":\"completed\"}', 'in', 'Dual Sign Contract', 40570),
(33704, NULL, 'PC127651-1-CA_Eugene Ford_Dual_Sign_Contract_3500_110122.pdf', 'applicants/27651/_no-category/PC127651-1-CA/6420ec7db14aa010d968a16d296abdd8144b452c', '2022-11-01 20:09:40', 'signed', 'completed', '11b2b0bb-bec0-41e9-8811-168f1519d4c3', '2022-11-01 20:18:39', '2022-11-01 21:07:25', '{\"62658d08-4ffe-482b-80fe-fc29fa32e77d\":\"1\",\"a7a0a59a-a29d-4767-bec9-833ffd735ca7\":\"2\",\"0b5fb952-d8dc-4f4f-9af5-d649597084f8\":\"3\"}', '{\"recipients\":{\"1\":{\"status\":\"completed\",\"name\":\"Ramin Ghaneeian\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T20:18:46.123Z\",\"signedOn\":\"2022-11-01T20:18:50.857Z\",\"sentOn\":\"2022-11-01T20:18:38.953Z\",\"declinedOn\":\"\"},\"2\":{\"status\":\"completed\",\"name\":\"Eugene Ford\",\"email\":\"[email protected]\",\"tabs\":{\"How we helped\":\"Df\",\"Bank\":null,\"Account Number\":null,\"Routing Number\":null,\"Address\":null,\"Delivery Type\":\"Western Union Money in Minutes\"},\"deliveredOn\":\"2022-11-01T20:57:42.08Z\",\"signedOn\":\"2022-11-01T21:06:55.24Z\",\"sentOn\":\"2022-11-01T20:18:52.387Z\",\"declinedOn\":\"\"},\"3\":{\"status\":\"completed\",\"name\":\"Jesse Burl Chrisp\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T20:38:40.127Z\",\"signedOn\":\"2022-11-01T20:38:45.58Z\",\"sentOn\":\"2022-11-01T20:18:52.077Z\",\"declinedOn\":\"\"}},\"status\":\"completed\"}', 'in', 'Dual Sign Contract', 40571),
(33705, NULL, 'PC123472-19-CA_Marlon Garcia_Dual_Sign_Contract_2500_110122.pdf', 'applicants/23472/_no-category/PC123472-19-CA/270710d299d9b6b707a80c68991cd411488f8edc', '2022-11-01 20:46:50', 'signed', 'completed', '5b8ba545-527e-4545-8f44-31def105891d', '2022-11-01 20:55:16', '2022-11-01 21:38:43', '{\"6f4d32be-29b7-4624-8e0b-1979e052359c\":\"1\",\"0209dec8-a900-48ea-b114-54607eef8d98\":\"2\",\"6ca2a77d-37cc-4fc2-a26d-605cc268694f\":\"3\"}', '{\"recipients\":{\"1\":{\"status\":\"completed\",\"name\":\"Ramin Ghaneeian\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T20:55:27.987Z\",\"signedOn\":\"2022-11-01T20:55:30.567Z\",\"sentOn\":\"2022-11-01T20:55:15.267Z\",\"declinedOn\":\"\"},\"2\":{\"status\":\"completed\",\"name\":\"Marlon Garcia\",\"email\":\"[email protected]\",\"tabs\":{\"How we helped\":\"To pay for bills and have 6 kids\",\"Bank\":null,\"Account Number\":null,\"Routing Number\":null,\"Address\":null,\"Delivery Type\":\"Western Union Money in Minutes\"},\"deliveredOn\":\"2022-11-01T21:34:09.903Z\",\"signedOn\":\"2022-11-01T21:38:15.843Z\",\"sentOn\":\"2022-11-01T20:55:32.143Z\",\"declinedOn\":\"\"}},\"status\":\"completed\"}', 'in', 'Dual Sign Contract', 40572),
(33706, NULL, 'PC126799-6-CA_Billy Stafford_Dual_Sign_Contract_350_110122.pdf', 'applicants/26799/_no-category/PC126799-6-CA/ce829b32a9926b155edbc9c6ef019f67b641ed12', '2022-11-01 21:26:28', 'signed', 'completed', '4abe046b-d08a-496d-b5b5-a53b9001856f', '2022-11-01 21:30:51', '2022-11-01 23:22:39', '{\"0b356a81-ba3d-4a75-b861-c7ca663ebd96\":\"1\",\"ecbee088-4c36-4cc6-9129-f78b4c2f0122\":\"2\",\"0770dfe1-5b22-4514-abee-91fe48222498\":\"3\"}', '{\"recipients\":{\"1\":{\"status\":\"completed\",\"name\":\"Ramin Ghaneeian\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T21:30:59.43Z\",\"signedOn\":\"2022-11-01T21:31:03.037Z\",\"sentOn\":\"2022-11-01T21:30:50.47Z\",\"declinedOn\":\"\"},\"2\":{\"status\":\"completed\",\"name\":\"Billy Stafford\",\"email\":\"[email protected]\",\"tabs\":{\"How we helped\":\"Billy Stafford \",\"Bank\":null,\"Account Number\":null,\"Routing Number\":null,\"Address\":null,\"Delivery Type\":\"Western Union Money in Minutes\"},\"deliveredOn\":\"2022-11-01T23:19:31.1Z\",\"signedOn\":\"2022-11-01T23:22:10.4Z\",\"sentOn\":\"2022-11-01T21:31:04.46Z\",\"declinedOn\":\"\"},\"3\":{\"status\":\"completed\",\"name\":\"Bobby Saadian\",\"email\":\"[email protected]\",\"tabs\":[],\"deliveredOn\":\"2022-11-01T21:35:36.433Z\",\"signedOn\":\"2022-11-01T21:35:43.027Z\",\"sentOn\":\"2022-11-01T21:31:04.227Z\",\"declinedOn\":\"\"}},\"status\":\"completed\"}', 'in', 'Dual Sign Contract', 40574),
(33712, NULL, 'PC127606-1-FL_Rhonda Williams_Dual_Sign_Contract_1200_110222.pdf', 'applicants/27606/_no-category/PC127606-1-FL/1e1b54c23052958bf2b0153451005b96b54f15f2', '2022-11-02 17:56:38', 'generated', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dual Sign Contract', 40582),
