SQLite Web: db.sqlite3

id

Primary key. INTEGER NOT NULL

raingull_id

char(32) NOT NULL

status

varchar(20) NOT NULL

formatted_payload

{"to": "", "content": "Message from Raingull Server\nOriginally sent 2025-12-04 18:47:02 by Mary Crozier (maryjcrozier@gmail.com)\nSource: IMAP\n---\nDang!  So sorry!  I'll make sure everyone knows about this.  Thanks...Mar\r\n\r\n\r\nOn Thu, Dec 4, 2025 at 10:44\u202fAM Alissa Gubelman <\r\noffice@jeffcofairgrounds.org> wrote:\r\n\r\n> Hi Mary,\r\n>\r\n> We\u2019re so happy to see you all getting set up for the Mystery Dinner, it\u2019s\r\n> been fun watching everything take shape!\r\n>\r\n> Just a quick note to ask that everyone double-check the doors before\r\n> leaving for the night. This morning when we came in, the back door to\r\n> Erickson was left open. This is the time of year when our rodent friends\r\n> like to sneak in anywhere they can, so keeping doors fully closed and\r\n> locked really helps.\r\n>\r\n> Thank you so much, and please let us know if you need anything!\r\n>\r\n> Kind regards,\r\n>\r\n> Alissa Gubelman\r\n>\r\n> Operations Coordinator\r\n>\r\n> Jefferson County Fair Association\r\n>\r\n> \ud83d\udcde 360-385-1013\r\n>\r\n\r\n-- \r\nYou received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\nTo unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\nTo view this discussion visit https://groups.google.com/d/msgid/ptmurder/CA%2BgCv2fZE9Q9XrexxvATS%3DVXpnBSQcPpTNJ0c7cqXkg4Wktn%3DQ%40mail.gmail.com.\r\n", "from": "+13603822448", "metadata": {"subject": "Re: Quick Note About Erickson Doors", "date": "Thu, 4 Dec 2025 10:47:02 -0800", "headers": {"Return-Path": "<ptmurder+bncBCNODQHT7QJRBS5OY7EQMGQEIGXN2PA@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "by mail-yw1-x1134.google.com with SMTP id 00721157ae682-787e35ab178so12707207b3.2\r\n        for <ptmurder@googlegroups.com>; Thu, 04 Dec 2025 10:47:39 -0800 (PST)", "Return-path": "<ptmurder+bncBCNODQHT7QJRBS5OY7EQMGQEIGXN2PA@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Thu, 04 Dec 2025 18:47:41 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764874059; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=AC9hbiual+1nQQvdGgZQkq2bijQiD/Cd0QbaMZZxuF4Erss8ZrTeS2HgUQWFRUuZ9z\r\n         x6CsAbA/hebpppnrDSkCHvzDgYy9Mi3c6QV6Oi2Y9Ubvx0EdKbiVI0b+EmyhkfwPB5wM\r\n         E07IL+ZKVxIO1Hgvgfgo7c14qsYc60LMU6uOH4QzJSIc3bmFi2S+SspIDhlLQaBR9ojP\r\n         tVTedrYaWlfz70OYEVUFSPcZg9ZBXgId7liQQlDIe17kKaO5upthr4MRWOqKHdc/rYEH\r\n         zXr94NEZKgnQjjquS5vuHVHGQG8TyJcqu93RXFxCZrWkTD98bYjsH1umJTF+b7eKf6hH\r\n         8czQ==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=cc:to:subject:message-id:date:from:in-reply-to:references\r\n         :mime-version:dkim-signature;\r\n        bh=C7/dolHlz5/lG3EqBQcNImIWjoSnIPw+daX8DrNV8x8=;\r\n        fh=Yr4nii1z1ZkQK9vi/ebv9Qp7dpW1VZQXMS25SV8QNcg=;\r\n        b=dfg0jogdC0kd0HLiLxSrjkH6wD6lJGXx5Q+7i831hdXATUMPqbLI+2X5SrhMBIKSHM\r\n         CfZWCnJm/CY12kdjKZTqfJAmJv4jwgRGCBsUbmv3XBVdCdTpZSJmn0hR0Ve7EOLK2FcE\r\n         xLHiHGgoUdorNQdS9H/wDqhFAlV8hujNa01ZlPz9krNvAWZKp4tJIf6Us8AgQqNRSLe0\r\n         btRuCPV8CkdnwYkrs4L11rPAXvd/n9MSJV6nmpZgWiB99sE6PxQ3ft174Cn3uKDdoIBt\r\n         sSnd85yWC/BvmpYm3HemW9KjSB5lA5wZL8ppw0FMA2kBzGztd2CcPF/RLsiY5uw9itC9\r\n         qoTA==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@gmail.com header.s=20230601 header.b=ihw5bSA7;\r\n       spf=pass (google.com: domain of maryjcrozier@gmail.com designates 2607:f8b0:4864:20::1134 as permitted sender) smtp.mailfrom=maryjcrozier@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       dara=pass header.i=@googlegroups.com", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=gmail.com; s=20230601; t=1764874060; x=1765478860; darn=raingull.org;\r\n        h=list-unsubscribe:list-archive:list-help:list-post:list-id\r\n         :mailing-list:precedence:reply-to:x-original-authentication-results\r\n         :x-original-sender:cc:to:subject:message-id:date:from:in-reply-to\r\n         :references:mime-version:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=ePn4K49rjJuj/7ushS1C7eGFvANBQZETWYd78zgf4ug=;\r\n        b=iSwgyUTLbBPf0X++gkyBJNz6M+r0Hb2VvLwbXY63qzatWYDzgKL5vdyBOG2rRZqpm6\r\n         FP7irfq8zRHUZsJ+ONxpbkKXXlXjwv48jBGPMUhWZc7bHh4ZkXS+UCVPgXeuNagquZYe\r\n         1zZFsvsp2kB2FMfjhwWJhxrVSNF4L2/3QsMR8Ncz1MuUsvfvkwZ86NJvTH3YcPdOCWEL\r\n         G5gg8hD/7SUS4ZD3IGIhHIZ1TwlXxFhZvBEvGqnBr+kXFcj5/2z8McKnpsnA9JXXwnIk\r\n         ueNKVMaEP5D+heWUdafrfTQQRytKgaLi449W02X8/yrIA/CX3FPoP+Q4SgmVtH/2JTL6\r\n         1Pjw==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764874060; x=1765478860;\r\n        h=list-unsubscribe:list-archive:list-help:list-post\r\n         :x-spam-checked-in-group:list-id:mailing-list:precedence:reply-to\r\n         :x-original-authentication-results:x-original-sender:cc:to:subject\r\n         :message-id:date:from:in-reply-to:references:mime-version:x-gm-gg\r\n         :x-beenthere:x-gm-message-state:sender:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=ePn4K49rjJuj/7ushS1C7eGFvANBQZETWYd78zgf4ug=;\r\n        b=MKifv1LQgPza2VOMhT7tzKFrrOh4vkOLjJn3Lrm4S+4mSqcPYkqrpijvGz+/wHaOTS\r\n         eZSe087hPhU9fxszQQkPwscSmjSBoxmBYEmvB9aznOq3rM/t/4RD1JuvqNnSOpELEi89\r\n         0odS/rfrqbgYl5NjGPgR14GtEvV+9EqcAbRtFhLyTul+XUgdhhM7KX62ONZDThcqnpKs\r\n         GvpFpoxNUfmC5koL0XOHuhyN7o6KQ7/ypw/fcz8vMys3zxLDRKfzNJlcXFnsmkPMg4zl\r\n         XHzAR497XxTgAH4GKYIzmFW61MtXiY3paaAqykFpiLLKVS46nNQYDCNzeD8Br4nVw5Sr\r\n         hYNQ==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=1; AJvYcCUZbzLDaNhJ7u/SiIEX3IhQjcoupXzQMWGXsfpA67ooZby+s5+lFUkY8lrRsrD9fCav9FpYJtzOJA==@googlegroups.com", "X-Gm-Message-State": "AOJu0YzAJHCxPwZWfScuNqZf352D7XeaLnHP5MT/rqdlAfPl4d/rYGHt\r\n\tn8nphuuCmjUyYa/aqxredvNi26esiVLv/Qe6+SKbIKDFFTa4AQu4ZB8=", "X-Google-Smtp-Source": "AGHT+IGAWtvMZYK5z+XBsjyl9dyLsa15ff8Ek2Rjyrx7mmw2SFjWq+jOPEOMFfH+PkHoXlhUrAarAg==", "X-Received": "by 2002:a05:690c:688d:b0:786:6383:6572 with SMTP id\r\n 00721157ae682-78c0c1d1720mr48901587b3.61.1764874058745; Thu, 04 Dec 2025\r\n 10:47:38 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+bCO//4EB7CgbDhE5uuTAmmIjkH5JoHHLRkC3curPTAXg==\"", "Received-SPF": "pass (google.com: domain of maryjcrozier@gmail.com designates 2607:f8b0:4864:20::1134 as permitted sender) client-ip=2607:f8b0:4864:20::1134;", "X-Gm-Gg": "ASbGncsXxp3l2LaEIe+p2ePcL/jWFiNsqOqu6BZsiBZANAo1k+D7bv+kB91S31toDju\r\n\tcE+rq9qm8l/fcGdvz9T4ior3tyAQHH4rOj0YmWCFyJUkF88Uu3M5kgPYfVvo4Z3eg19yC+FMYio\r\n\tuAIoF9Jz+VdQ+215ERMvy4VvrJyO+wFR+r+Na37xmcX7R2ffwuDxomdbUPHK120LHxU99Upe5Qs\r\n\tDp+Cr9DlWi/EmnM+DLu/ia9jXNJfSWA273uWH1IoecbfC2DnC7wc/QHqslkMoz4ImupAQdM", "MIME-Version": "1.0", "References": "<CAPnUi9tZT-Kd2=sLJhGVKh9H4VucyNMirmi1G9W3hd9WZ450iw@mail.gmail.com>", "In-Reply-To": "<CAPnUi9tZT-Kd2=sLJhGVKh9H4VucyNMirmi1G9W3hd9WZ450iw@mail.gmail.com>", "From": "Mary Crozier <maryjcrozier@gmail.com>", "Date": "Thu, 4 Dec 2025 10:47:02 -0800", "X-Gm-Features": "AQt7F2rqRejJO93PY2cBLN5KsesRMeYxqvk2mq4bPEcnpVUcbP4pLoFtjcX4q5k", "Message-ID": "<CA+gCv2fZE9Q9XrexxvATS=VXpnBSQcPpTNJ0c7cqXkg4Wktn=Q@mail.gmail.com>", "Subject": "Re: Quick Note About Erickson Doors", "To": "Alissa Gubelman <office@jeffcofairgrounds.org>", "Cc": "Karly Mishko <director@jeffcofairgrounds.org>, ptmurder@googlegroups.com", "Content-Type": "multipart/alternative; boundary=\"000000000000584bb7064524c35f\"", "X-Original-Sender": "maryjcrozier@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=ihw5bSA7;       spf=pass\r\n (google.com: domain of maryjcrozier@gmail.com designates 2607:f8b0:4864:20::1134\r\n as permitted sender) smtp.mailfrom=maryjcrozier@gmail.com;       dmarc=pass\r\n (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;       dara=pass header.i=@googlegroups.com", "Reply-To": "ptmurder@googlegroups.com", "Precedence": "list", "Mailing-list": "list ptmurder@googlegroups.com; contact ptmurder+owners@googlegroups.com", "List-ID": "<ptmurder.googlegroups.com>", "X-Spam-Checked-In-Group": "ptmurder@googlegroups.com", "X-Google-Group-Id": "27968096625", "List-Post": "<https://groups.google.com/group/ptmurder/post>, <mailto:ptmurder@googlegroups.com>", "List-Help": "<https://groups.google.com/support/>, <mailto:ptmurder+help@googlegroups.com>", "List-Archive": "<https://groups.google.com/group/ptmurder", "List-Unsubscribe": "<mailto:googlegroups-manage+27968096625+unsubscribe@googlegroups.com>,\r\n <https://groups.google.com/group/ptmurder/subscribe>", "X-DKIM": "signer='gmail.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "1.8 (+)", "X-Spam-Report": "Spam detection software, running on the system \"heracles.mxrouting.net\", has\r\n performed the tests listed below against this email.\r\n Information: https://mxroutedocs.com/directadmin/spamfilters/\r\n ---\r\n Content analysis details:   (1.8 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.\r\n                             See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block\r\n                              for more information.\r\n                             [URI: googlegroups.com]\r\n  0.0 RCVD_IN_DNSWL_BLOCKED  RBL: ADMINISTRATOR NOTICE: The query to DNSWL\r\n                             was blocked.  See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#DnsBlocklists-dnsbl-block\r\n                              for more information.\r\n                             [209.85.160.189 listed in list.dnswl.org]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n -0.1 DKIM_VALID_EF          Message has a valid DKIM or DK signature from\r\n                             envelope-from domain\r\n  0.0 ARC_VALID              Message has a valid ARC signature\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [maryjcrozier(at)gmail.com]\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.160.189 listed in wl.mailspike.net]\r\n  0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders", "SpamTally": "Final spam score: 18"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-12-04 18:47:02 by Mary Crozier (maryjcrozier@gmail.com)\nSource: IMAP\n---\nDang!  So sorry!  I'll make sure everyone knows about this.  Thanks...Mar\r\n\r\n\r\nOn Thu, Dec 4, 2025 at 10:44\u202fAM Alissa Gubelman <\r\noffice@jeffcofairgrounds.org> wrote:\r\n\r\n> Hi Mary,\r\n>\r\n> We\u2019re so happy to see you all getting set up for the Mystery Dinner, it\u2019s\r\n> been fun watching everything take shape!\r\n>\r\n> Just a quick note to ask that everyone double-check the doors before\r\n> leaving for the night. This morning when we came in, the back door to\r\n> Erickson was left open. This is the time of year when our rodent friends\r\n> like to sneak in anywhere they can, so keeping doors fully closed and\r\n> locked really helps.\r\n>\r\n> Thank you so much, and please let us know if you need anything!\r\n>\r\n> Kind regards,\r\n>\r\n> Alissa Gubelman\r\n>\r\n> Operations Coordinator\r\n>\r\n> Jefferson County Fair Association\r\n>\r\n> \ud83d\udcde 360-385-1013\r\n>\r\n\r\n-- \r\nYou received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\nTo unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\nTo view this discussion visit https://groups.google.com/d/msgid/ptmurder/CA%2BgCv2fZE9Q9XrexxvATS%3DVXpnBSQcPpTNJ0c7cqXkg4Wktn%3DQ%40mail.gmail.com.\r\n"}}

TEXT NOT NULL

subject

varchar(255)

sender

varchar(255)

recipient

varchar(255)

error_message

TEXT

created_at

datetime NOT NULL

updated_at

datetime NOT NULL

sent_at

datetime

message_id

bigint NOT NULL

service_id

bigint NOT NULL

db.sqlite3 — core_formatted_messages

Update row 203 in core_formatted_messages