-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `daily_health_report_archive`
--

CREATE TABLE `daily_health_report_archive` (
  `id` bigint UNSIGNED NOT NULL,
  `run_date` date NOT NULL,
  `subscriber_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `node_straid` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `network_node` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pon_ont` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `health` decimal(5,1) NOT NULL,
  `alarm_penalty` decimal(6,2) NOT NULL,
  `surge_penalty` decimal(6,2) NOT NULL,
  `bip_penalty` decimal(6,2) NOT NULL,
  `optics_penalty` decimal(6,2) NOT NULL,
  `alarms_24h_fault_total` int NOT NULL,
  `alarms_24h_ont_missing` int NOT NULL,
  `alarms_24h_low_optical_power_ne` int NOT NULL,
  `alarms_24h_ds_sdber_exceeded` int NOT NULL,
  `alarms_24h_us_sdber_exceeded` int NOT NULL,
  `alarms_24h_ont_battery_failed` int NOT NULL,
  `alarms_24h_ont_battery_missing` int NOT NULL,
  `fe_optical_level` decimal(6,2) DEFAULT NULL,
  `rx_optical_level` decimal(6,2) DEFAULT NULL,
  `bip_errors_24h` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `daily_health_report_archive`
--

INSERT INTO `daily_health_report_archive` (`id`, `run_date`, `subscriber_id`, `node_straid`, `network_node`, `description`, `pon_ont`, `health`, `alarm_penalty`, `surge_penalty`, `bip_penalty`, `optics_penalty`, `alarms_24h_fault_total`, `alarms_24h_ont_missing`, `alarms_24h_low_optical_power_ne`, `alarms_24h_ds_sdber_exceeded`, `alarms_24h_us_sdber_exceeded`, `alarms_24h_ont_battery_failed`, `alarms_24h_ont_battery_missing`, `fe_optical_level`, `rx_optical_level`, `bip_errors_24h`, `created_at`) VALUES
(1, '2025-10-10', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '9.3', '66.72', '0.00', '24.00', '0.00', 35, 29, 0, 6, 0, 0, 0, '-16.70', '-15.00', 73067117, '2025-10-10 16:54:00'),
(2, '2025-10-10', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '27.1', '40.89', '0.00', '0.00', '32.00', 18, 0, 18, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-10 16:54:00'),
(3, '2025-10-10', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '23.2', '20.76', '0.00', '24.00', '32.00', 7, 7, 0, 0, 0, 0, 0, '-28.90', '-33.00', 4501164, '2025-10-10 16:54:00'),
(4, '2025-10-10', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '31.6', '29.90', '0.00', '6.48', '32.00', 14, 0, 0, 0, 14, 0, 0, '-33.00', '-30.00', 40255, '2025-10-10 16:54:00'),
(5, '2025-10-10', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '34.1', '9.86', '0.00', '24.00', '32.00', 5, 0, 0, 0, 3, 0, 0, '-32.20', '-35.00', 2881748, '2025-10-10 16:54:00'),
(6, '2025-10-10', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '39.0', '4.97', '0.00', '24.00', '32.00', 2, 0, 0, 0, 2, 0, 0, '-33.00', '-27.00', 171881, '2025-10-10 16:54:00'),
(7, '2025-10-10', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'NTWK-WLMS2_E7', 'GERALD AMSTUTZ', '1-1-3-285', '42.0', '58.03', '0.00', '0.00', '0.00', 38, 0, 0, 0, 0, 38, 0, '-16.00', NULL, 0, '2025-10-10 16:54:00'),
(8, '2025-10-10', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-36.00', 139646624, '2025-10-10 16:54:00'),
(9, '2025-10-10', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.40', '-40.00', 148366948, '2025-10-10 16:54:00'),
(10, '2025-10-10', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 44683998, '2025-10-10 16:54:00'),
(27, '2025-10-10', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-30.00', 23858144, '2025-10-10 19:29:08'),
(31, '2025-10-13', 'RODNEY MILLER', 'NTWK-SWFT2_E7-1-2-6-74235', 'NTWK-SWFT2_E7', 'RODNEY MILLER', '1-2-6-74235', '0.0', '87.86', '0.00', '24.00', '32.00', 68, 64, 0, 3, 0, 0, 0, '-30.50', '-30.00', 4753084, '2025-10-13 12:42:14'),
(32, '2025-10-13', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '0.0', '45.49', '0.00', '24.00', '32.00', 20, 13, 0, 7, 0, 0, 0, '-29.20', '-31.00', 24453754, '2025-10-13 12:42:14'),
(33, '2025-10-13', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '23.2', '52.81', '0.00', '24.00', '0.00', 23, 22, 0, 1, 0, 0, 0, '-16.80', '-15.00', 22589504, '2025-10-13 12:42:14'),
(34, '2025-10-13', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '23.8', '44.22', '0.00', '0.00', '32.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-13 12:42:14'),
(35, '2025-10-13', 'DAVID EDWARDS', 'NTWK-PLVL2_E7-1-2-4-47923', 'NTWK-PLVL2_E7', 'DAVID EDWARDS', '1-2-4-47923', '24.5', '51.52', '0.00', '24.00', '0.00', 25, 12, 0, 13, 0, 0, 0, '-18.00', '-17.00', 24937976, '2025-10-13 12:42:14'),
(36, '2025-10-13', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '30.6', '37.36', '0.00', '0.00', '32.00', 16, 0, 16, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-13 12:42:14'),
(37, '2025-10-13', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 0, 1, 0, 0, '-33.00', '-27.00', 309239, '2025-10-13 12:42:14'),
(38, '2025-10-13', 'MARY AHLERT', 'NTWK-WEFD_E7-1-2-1-54081', 'NTWK-WEFD_E7', 'MARY AHLERT', '1-2-1-54081', '42.6', '1.36', '0.00', '24.00', '32.00', 1, 0, 0, 0, 0, 0, 0, '-27.20', '-33.00', 4535272, '2025-10-13 12:42:14'),
(39, '2025-10-13', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 41280968, '2025-10-13 12:42:14'),
(40, '2025-10-13', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 7100730, '2025-10-13 12:42:14'),
(51, '2025-10-14', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '0.0', '55.44', '0.00', '24.00', '32.00', 25, 23, 0, 2, 0, 0, 0, '-29.20', '-31.00', 12080829, '2025-10-14 12:00:45'),
(52, '2025-10-14', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '8.3', '62.45', '0.00', '19.20', '10.07', 39, 0, 0, 0, 39, 0, 0, '-26.20', '-24.95', 80015, '2025-10-14 12:00:45'),
(53, '2025-10-14', 'RODNEY MILLER', 'NTWK-SWFT2_E7-1-2-6-74235', 'NTWK-SWFT2_E7', 'RODNEY MILLER', '1-2-6-74235', '18.9', '25.11', '0.00', '24.00', '32.00', 10, 6, 0, 3, 0, 0, 0, '-30.50', '-30.00', 48619752, '2025-10-14 12:00:45'),
(54, '2025-10-14', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '20.7', '47.35', '0.00', '0.00', '32.00', 22, 0, 22, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-14 12:00:45'),
(55, '2025-10-14', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '28.8', '39.15', '0.00', '0.00', '32.00', 17, 0, 17, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-14 12:00:45'),
(56, '2025-10-14', 'MARY AHLERT', 'NTWK-WEFD_E7-1-2-1-54081', 'NTWK-WEFD_E7', 'MARY AHLERT', '1-2-1-54081', '38.3', '5.71', '0.00', '24.00', '32.00', 2, 1, 0, 1, 0, 0, 0, '-27.20', '-33.00', 26407648, '2025-10-14 12:00:45'),
(57, '2025-10-14', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'NTWK-WLMS2_E7', 'GERALD AMSTUTZ', '1-1-3-285', '40.3', '59.67', '0.00', '0.00', '0.00', 41, 0, 0, 0, 0, 38, 0, '-16.00', NULL, 0, '2025-10-14 12:00:45'),
(58, '2025-10-14', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-33.00', 30550046, '2025-10-14 12:00:45'),
(59, '2025-10-14', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 0, 1, 0, 0, '-33.00', '-27.00', 526237, '2025-10-14 12:00:45'),
(60, '2025-10-14', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 328352151, '2025-10-14 12:00:45'),
(61, '2025-10-15', 'JUDY ZIEGLER', 'NTWK-RTFD_E7-1-1-5-76', 'NTWK-RTFD_E7', 'JUDY ZIEGLER', '1-1-5-76', '4.5', '95.53', '0.00', '0.00', '0.00', 156, 0, 0, 0, 0, 156, 0, '-22.80', NULL, 0, '2025-10-15 12:00:51'),
(62, '2025-10-15', 'RODNEY MILLER', 'NTWK-SWFT2_E7-1-2-6-74235', 'NTWK-SWFT2_E7', 'RODNEY MILLER', '1-2-6-74235', '7.3', '36.75', '0.00', '24.00', '32.00', 15, 10, 0, 5, 0, 0, 0, '-30.50', '-30.00', 32968262, '2025-10-15 12:00:51'),
(63, '2025-10-15', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '7.4', '58.55', '0.00', '24.00', '10.07', 35, 0, 0, 0, 35, 0, 0, '-26.20', '-24.95', 169731, '2025-10-15 12:00:51'),
(64, '2025-10-15', 'Darrel Dye', 'NTWK-TRSP_E7-1-1-4-16', 'NTWK-TRSP_E7', 'Darrel Dye', '1-1-4-16', '22.0', '78.00', '0.00', '0.00', '0.00', 55, 28, 0, 0, 0, 27, 0, '-16.00', '-13.17', 30, '2025-10-15 12:00:51'),
(65, '2025-10-15', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '23.8', '44.22', '0.00', '0.00', '32.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-15 12:00:51'),
(66, '2025-10-15', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '27.1', '40.89', '0.00', '0.00', '32.00', 18, 0, 18, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-15 12:00:51'),
(67, '2025-10-15', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '36.3', '39.74', '0.00', '24.00', '0.00', 16, 13, 0, 3, 0, 0, 0, '-16.80', '-15.00', 55990776, '2025-10-15 12:00:51'),
(68, '2025-10-15', 'KATHY MIDER', 'NTWK-GLWD2_E7-1-1-4-61401', 'NTWK-GLWD2_E7', 'KATHY MIDER', '1-1-4-61401', '40.7', '3.28', '0.00', '24.00', '32.00', 1, 1, 0, 0, 0, 0, 0, '-28.20', '-35.00', 702881, '2025-10-15 12:00:51'),
(69, '2025-10-15', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-33.00', 135253963, '2025-10-15 12:00:51'),
(70, '2025-10-15', 'MARY AHLERT', 'NTWK-WEFD_E7-1-2-1-54081', 'NTWK-WEFD_E7', 'MARY AHLERT', '1-2-1-54081', '42.6', '1.36', '0.00', '24.00', '32.00', 1, 0, 0, 0, 0, 0, 0, '-27.20', '-33.00', 9190170, '2025-10-15 12:00:51'),
(71, '2025-10-02', 'NATHANIEL DONALDSON', 'NTWK-SWFT_E7-1-1-8-17762', 'NTWK-SWFT_E7', 'NATHANIEL DONALDSON', '1-1-8-17762', '24.2', '0.00', '0.00', '0.00', '0.00', 93, 0, 0, 0, 93, 0, 0, '-16.40', '-15.32', 3174818, '2025-10-15 13:49:48'),
(72, '2025-10-02', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '28.6', '0.00', '0.00', '0.00', '0.00', 60, 41, 0, 19, 0, 0, 0, '-16.80', '-15.00', 71472356, '2025-10-15 13:49:48'),
(73, '2025-10-02', 'TRAVIS INMAN', 'NTWK-LOGT_E7-1-2-5-2025', 'NTWK-LOGT_E7', 'TRAVIS INMAN', '1-2-5-2025', '38.5', '0.00', '0.00', '0.00', '0.00', 21, 0, 0, 0, 21, 0, 0, '-29.60', '-28.86', 57451, '2025-10-15 13:49:48'),
(74, '2025-10-02', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '49.6', '0.00', '0.00', '0.00', '0.00', 19, 0, 19, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(75, '2025-10-02', 'NICHOLAS EICHER', 'NTWK-ODON2_E7-1-1-1-96036', 'NTWK-ODON2_E7', 'NICHOLAS EICHER', '1-1-1-96036', '49.6', '0.00', '0.00', '0.00', '0.00', 19, 0, 19, 0, 0, 0, 0, '-30.00', '-28.00', 0, '2025-10-15 13:49:48'),
(76, '2025-10-02', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '50.8', '0.00', '0.00', '0.00', '0.00', 18, 0, 18, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-15 13:49:48'),
(77, '2025-10-02', 'GINGER PORTER', 'NTWK-ODON2_E7-1-1-3-51361', 'NTWK-ODON2_E7', 'GINGER PORTER', '1-1-3-51361', '50.8', '0.00', '0.00', '0.00', '0.00', 18, 0, 18, 0, 0, 0, 0, '-30.50', '-30.00', 0, '2025-10-15 13:49:48'),
(78, '2025-10-02', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '54.6', '0.00', '0.00', '0.00', '0.00', 15, 0, 15, 0, 0, 0, 0, '-34.00', '-32.00', 2, '2025-10-15 13:49:48'),
(79, '2025-10-02', 'BILL BURNS', 'NTWK-STMP_E7-1-1-1-87947', 'NTWK-STMP_E7', 'BILL BURNS', '1-1-1-87947', '58.0', '0.00', '0.00', '0.00', '0.00', 9, 5, 0, 4, 0, 0, 0, '-29.60', '-25.00', 25099773, '2025-10-15 13:49:48'),
(80, '2025-10-02', 'ARTHUR PHILLIPS', 'NTWK-WLMS2_E7-1-2-6-249', 'NTWK-WLMS2_E7', 'ARTHUR PHILLIPS', '1-2-6-249', '59.2', '0.00', '0.00', '0.00', '0.00', 5, 2, 0, 2, 0, 0, 0, '-26.80', '-36.00', 612751096, '2025-10-15 13:49:48'),
(81, '2025-10-03', 'NATHANIEL DONALDSON', 'NTWK-SWFT_E7-1-1-8-17762', 'NTWK-SWFT_E7', 'NATHANIEL DONALDSON', '1-1-8-17762', '26.5', '0.00', '0.00', '0.00', '0.00', 81, 0, 0, 0, 81, 0, 0, '-16.40', '-15.32', 4570503, '2025-10-15 13:49:48'),
(82, '2025-10-03', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '43.1', '0.00', '0.00', '0.00', '0.00', 25, 0, 25, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-15 13:49:48'),
(83, '2025-10-03', 'NICHOLAS EICHER', 'NTWK-ODON2_E7-1-1-1-96036', 'NTWK-ODON2_E7', 'NICHOLAS EICHER', '1-1-1-96036', '48.4', '0.00', '0.00', '0.00', '0.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-28.00', 0, '2025-10-15 13:49:48'),
(84, '2025-10-03', 'GINGER PORTER', 'NTWK-ODON2_E7-1-1-3-51361', 'NTWK-ODON2_E7', 'GINGER PORTER', '1-1-3-51361', '48.4', '0.00', '0.00', '0.00', '0.00', 20, 0, 20, 0, 0, 0, 0, '-30.50', '-30.00', 0, '2025-10-15 13:49:48'),
(85, '2025-10-03', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '52.0', '0.00', '0.00', '0.00', '0.00', 17, 0, 17, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(86, '2025-10-03', 'TRAVIS INMAN', 'NTWK-LOGT_E7-1-2-5-2025', 'NTWK-LOGT_E7', 'TRAVIS INMAN', '1-2-5-2025', '52.6', '0.00', '0.00', '0.00', '0.00', 17, 2, 0, 0, 15, 0, 0, '-29.60', '-28.86', 24130, '2025-10-15 13:49:48'),
(87, '2025-10-03', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '53.3', '0.00', '0.00', '0.00', '0.00', 22, 14, 0, 8, 0, 0, 0, '-16.80', '-15.00', 63040415, '2025-10-15 13:49:48'),
(88, '2025-10-03', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '54.6', '0.00', '0.00', '0.00', '0.00', 15, 0, 15, 0, 0, 0, 0, '-34.00', '-32.00', 0, '2025-10-15 13:49:48'),
(89, '2025-10-03', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '55.0', '0.00', '0.00', '0.00', '0.00', 7, 3, 0, 4, 0, 0, 0, '-28.50', '-33.00', 280731596, '2025-10-15 13:49:48'),
(90, '2025-10-03', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '55.5', '0.00', '0.00', '0.00', '0.00', 6, 5, 0, 1, 0, 0, 0, '-28.50', '-30.00', 49889311, '2025-10-15 13:49:48'),
(91, '2025-10-04', 'NATHANIEL DONALDSON', 'NTWK-SWFT_E7-1-1-8-17762', 'NTWK-SWFT_E7', 'NATHANIEL DONALDSON', '1-1-8-17762', '29.1', '0.00', '0.00', '0.00', '0.00', 71, 0, 0, 0, 71, 0, 0, '-16.40', '-15.32', 2624544, '2025-10-15 13:49:48'),
(92, '2025-10-04', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '37.9', '0.00', '0.00', '0.00', '0.00', 41, 24, 0, 17, 0, 0, 0, '-16.80', '-15.00', 105371227, '2025-10-15 13:49:48'),
(93, '2025-10-04', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '46.2', '0.00', '0.00', '0.00', '0.00', 22, 0, 22, 0, 0, 0, 0, '-30.00', '-26.00', 2, '2025-10-15 13:49:48'),
(94, '2025-10-04', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '47.3', '0.00', '0.00', '0.00', '0.00', 21, 0, 21, 0, 0, 0, 0, '-34.00', '-32.00', 0, '2025-10-15 13:49:48'),
(95, '2025-10-04', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '48.4', '0.00', '0.00', '0.00', '0.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(96, '2025-10-04', 'DEREK SMITH', 'NTWK-PTWM_E7-1-1-5-111292', 'NTWK-PTWM_E7', 'DEREK SMITH', '1-1-5-111292', '51.9', '0.00', '0.00', '0.00', '0.00', 19, 10, 3, 0, 0, 0, 0, '-33.00', '0.00', 6, '2025-10-15 13:49:48'),
(97, '2025-10-04', 'NICHOLAS EICHER', 'NTWK-ODON2_E7-1-1-1-96036', 'NTWK-ODON2_E7', 'NICHOLAS EICHER', '1-1-1-96036', '52.0', '0.00', '0.00', '0.00', '0.00', 17, 0, 17, 0, 0, 0, 0, '-30.00', '-28.00', 0, '2025-10-15 13:49:48'),
(98, '2025-10-04', 'GINGER PORTER', 'NTWK-ODON2_E7-1-1-3-51361', 'NTWK-ODON2_E7', 'GINGER PORTER', '1-1-3-51361', '54.6', '0.00', '0.00', '0.00', '0.00', 15, 0, 15, 0, 0, 0, 0, '-30.50', '-30.00', 0, '2025-10-15 13:49:48'),
(99, '2025-10-04', 'KEVIN MYERS', 'NTWK-GLWD3_E7-1-1-1-7', 'NTWK-GLWD3_E7', 'KEVIN MYERS', '1-1-1-7', '63.4', '0.00', '0.00', '0.00', '0.00', 14, 0, 14, 0, 0, 0, 0, '-29.20', '-25.09', 0, '2025-10-15 13:49:48'),
(100, '2025-10-04', 'Frank Richard', 'NTWK-GFWA2_E7-1-2-3-182', 'NTWK-GFWA2_E7', 'Frank Richard', '1-2-3-182', '64.9', '0.00', '0.00', '0.00', '0.00', 32, 0, 0, 0, 0, 31, 0, '-28.90', '-22.75', 0, '2025-10-15 13:49:48'),
(101, '2025-10-05', 'SKYLAR CISSELL', 'NTWK-WEFD2_E7-1-2-6-71913', 'NTWK-WEFD2_E7', 'SKYLAR CISSELL', '1-2-6-71913', '18.3', '0.00', '0.00', '0.00', '0.00', 37, 36, 0, 0, 0, 0, 0, '-22.40', '-33.00', 24550024, '2025-10-15 13:49:48'),
(102, '2025-10-05', '', 'NTWK-WLMS2_E7-1-1-8-130', 'NTWK-WLMS2_E7', '', '1-1-8-130', '43.7', '0.00', '0.00', '0.00', '0.00', 75, 29, 0, 0, 0, 23, 0, '-24.00', NULL, 164, '2025-10-15 13:49:48'),
(103, '2025-10-05', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '47.3', '0.00', '0.00', '0.00', '0.00', 21, 0, 21, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(104, '2025-10-05', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '48.4', '0.00', '0.00', '0.00', '0.00', 20, 0, 20, 0, 0, 0, 0, '-34.00', '-32.00', 0, '2025-10-15 13:49:48'),
(105, '2025-10-05', 'NICHOLAS EICHER', 'NTWK-ODON2_E7-1-1-1-96036', 'NTWK-ODON2_E7', 'NICHOLAS EICHER', '1-1-1-96036', '48.4', '0.00', '0.00', '0.00', '0.00', 20, 0, 20, 0, 0, 0, 0, '-30.50', '-27.00', 0, '2025-10-15 13:49:48'),
(106, '2025-10-05', 'NATHANIEL DONALDSON', 'NTWK-SWFT_E7-1-1-8-17762', 'NTWK-SWFT_E7', 'NATHANIEL DONALDSON', '1-1-8-17762', '50.5', '0.00', '0.00', '0.00', '0.00', 30, 0, 0, 0, 29, 0, 0, '0.00', '0.00', 604434, '2025-10-15 13:49:48'),
(107, '2025-10-05', 'GINGER PORTER', 'NTWK-ODON2_E7-1-1-3-51361', 'NTWK-ODON2_E7', 'GINGER PORTER', '1-1-3-51361', '53.3', '0.00', '0.00', '0.00', '0.00', 16, 0, 16, 0, 0, 0, 0, '-30.00', '-27.00', 0, '2025-10-15 13:49:48'),
(108, '2025-10-05', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '58.5', '0.00', '0.00', '0.00', '0.00', 17, 13, 0, 4, 0, 0, 0, '-16.70', '-15.00', 80720654, '2025-10-15 13:49:48'),
(109, '2025-10-05', 'STACEY BOWLING', 'NTWK-NLGT1_E7-1-2-4-52524', 'NTWK-NLGT1_E7', 'STACEY BOWLING', '1-2-4-52524', '65.4', '0.00', '0.00', '0.00', '0.00', 2, 2, 0, 0, 0, 0, 0, '-34.00', '-33.00', 44895, '2025-10-15 13:49:48'),
(110, '2025-10-05', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '66.2', '0.00', '0.00', '0.00', '0.00', 1, 0, 0, 1, 0, 0, 0, '-28.90', '-33.00', 237332012, '2025-10-15 13:49:48'),
(111, '2025-10-06', 'GINGER PORTER', 'NTWK-ODON2_E7-1-1-3-51361', 'NTWK-ODON2_E7', 'GINGER PORTER', '1-1-3-51361', '47.3', '0.00', '0.00', '0.00', '0.00', 21, 0, 21, 0, 0, 0, 0, '-30.00', '-27.00', 0, '2025-10-15 13:49:48'),
(112, '2025-10-06', 'NICHOLAS EICHER', 'NTWK-ODON2_E7-1-1-1-96036', 'NTWK-ODON2_E7', 'NICHOLAS EICHER', '1-1-1-96036', '48.4', '0.00', '0.00', '0.00', '0.00', 20, 0, 20, 0, 0, 0, 0, '-30.50', '-27.00', 0, '2025-10-15 13:49:48'),
(113, '2025-10-06', '', 'NTWK-WLMS2_E7-1-1-8-130', 'NTWK-WLMS2_E7', '', '1-1-8-130', '51.6', '0.00', '0.00', '0.00', '0.00', 56, 19, 0, 0, 1, 18, 0, '-24.00', NULL, 164, '2025-10-15 13:49:48'),
(114, '2025-10-06', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '51.7', '0.00', '0.00', '0.00', '0.00', 22, 20, 0, 2, 0, 0, 0, '-16.70', '-15.00', 52710594, '2025-10-15 13:49:48'),
(115, '2025-10-06', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '52.8', '0.00', '0.00', '0.00', '0.00', 31, 0, 0, 0, 31, 0, 0, '-26.40', '-24.95', 24361, '2025-10-15 13:49:48'),
(116, '2025-10-06', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '53.3', '0.00', '0.00', '0.00', '0.00', 16, 0, 16, 0, 0, 0, 0, '-34.00', '-32.00', 2, '2025-10-15 13:49:48'),
(117, '2025-10-06', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '53.3', '0.00', '0.00', '0.00', '0.00', 16, 0, 16, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(118, '2025-10-06', 'SHADYN REED', 'NTWK-PLVL2_E7-1-1-8-90108', 'NTWK-PLVL2_E7', 'SHADYN REED', '1-1-8-90108', '62.5', '0.00', '0.00', '0.00', '0.00', 13, 11, 0, 1, 0, 0, 0, '-24.90', '-24.00', 4336354, '2025-10-15 13:49:48'),
(120, '2025-10-06', 'Frank Richard', 'NTWK-GFWA2_E7-1-2-3-182', 'NTWK-GFWA2_E7', 'Frank Richard', '1-2-3-182', '66.1', '0.00', '0.00', '0.00', '0.00', 33, 0, 0, 0, 0, 32, 0, '-28.00', '-22.75', 0, '2025-10-15 13:49:48'),
(121, '2025-10-07', '', 'NTWK-WLMS2_E7-1-1-8-130', 'NTWK-WLMS2_E7', '', '1-1-8-130', '11.9', '88.05', '0.00', '0.00', '0.00', 95, 33, 0, 0, 0, 31, 0, '-24.00', NULL, 168, '2025-10-15 13:49:48'),
(122, '2025-10-07', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '16.3', '51.71', '0.00', '0.00', '32.00', 25, 0, 25, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(123, '2025-10-07', 'Brian Tolbert', 'NTWK-PTWM_E7-1-1-5-99', 'NTWK-PTWM_E7', 'Brian Tolbert', '1-1-5-99', '25.2', '74.77', '0.00', '0.00', '0.00', 61, 0, 0, 0, 0, 61, 0, '-15.40', '-13.00', 0, '2025-10-15 13:49:48'),
(125, '2025-10-07', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '34.4', '33.61', '0.00', '0.00', '32.00', 14, 0, 14, 0, 0, 0, 0, '-34.00', '-32.00', 0, '2025-10-15 13:49:48'),
(126, '2025-10-07', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '39.0', '4.97', '0.00', '24.00', '32.00', 2, 0, 0, 0, 2, 0, 0, '-32.20', '-35.00', 5043208, '2025-10-15 13:49:48'),
(128, '2025-10-07', 'Frank Richard', 'NTWK-GFWA2_E7-1-2-3-182', 'NTWK-GFWA2_E7', 'Frank Richard', '1-2-3-182', '39.1', '48.09', '0.00', '0.00', '12.80', 29, 0, 0, 0, 0, 28, 0, '-28.00', '-22.75', 0, '2025-10-15 13:49:48'),
(129, '2025-10-07', 'NICHOLAS EICHER', 'NTWK-ODON2_E7-1-1-1-96036', 'NTWK-ODON2_E7', 'NICHOLAS EICHER', '1-1-1-96036', '39.3', '28.66', '0.00', '0.00', '32.00', 11, 4, 7, 0, 0, 0, 0, '-30.50', '-27.00', 6, '2025-10-15 13:49:48'),
(130, '2025-10-07', 'GINGER PORTER', 'NTWK-ODON2_E7-1-1-3-51361', 'NTWK-ODON2_E7', 'GINGER PORTER', '1-1-3-51361', '43.6', '24.38', '0.00', '0.00', '32.00', 9, 4, 5, 0, 0, 0, 0, '-30.00', '-27.00', 4, '2025-10-15 13:49:48'),
(131, '2025-10-08', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '17.5', '50.49', '0.00', '0.00', '32.00', 24, 1, 23, 0, 0, 0, 0, '-30.00', '-24.00', 2, '2025-10-15 13:49:48'),
(132, '2025-10-08', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '26.0', '50.01', '0.00', '24.00', '0.00', 21, 21, 0, 0, 0, 0, 0, '-16.70', '-15.00', 53091623, '2025-10-15 13:49:48'),
(133, '2025-10-08', 'PATTY PARSONS', 'NTWK-NLGT1_E7-1-2-3-58160', 'NTWK-NLGT1_E7', 'PATTY PARSONS', '1-2-3-58160', '32.5', '35.51', '0.00', '0.00', '32.00', 15, 0, 15, 0, 0, 0, 0, '-34.00', '-32.00', 0, '2025-10-15 13:49:48'),
(134, '2025-10-08', 'KAREN BOYD', 'NTWK-NLGT1_E7-1-1-4-111164', 'NTWK-NLGT1_E7', 'KAREN BOYD', '1-1-4-111164', '34.1', '21.83', '0.00', '12.11', '32.00', 10, 4, 2, 0, 0, 0, 0, '-34.00', '0.00', 57849, '2025-10-15 13:49:48'),
(135, '2025-10-08', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'NTWK-WLMS2_E7', 'GERALD AMSTUTZ', '1-1-3-285', '40.9', '59.13', '0.00', '0.00', '0.00', 40, 0, 0, 0, 0, 38, 0, '-16.00', NULL, 0, '2025-10-15 13:49:48'),
(136, '2025-10-08', 'Frank Richard', 'NTWK-GFWA2_E7-1-2-3-182', 'NTWK-GFWA2_E7', 'Frank Richard', '1-2-3-182', '41.0', '46.18', '0.00', '0.00', '12.80', 27, 0, 0, 0, 0, 27, 0, '-28.00', '-22.75', 0, '2025-10-15 13:49:48'),
(137, '2025-10-08', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.90', '-33.00', 100040674, '2025-10-15 13:49:48'),
(138, '2025-10-08', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 0, 1, 0, 0, '-32.20', '-35.00', 4382829, '2025-10-15 13:49:48'),
(139, '2025-10-08', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.40', '-40.00', 241287317, '2025-10-15 13:49:48'),
(140, '2025-10-08', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-36.00', 205331898, '2025-10-15 13:49:48'),
(141, '2025-10-09', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '13.6', '54.40', '0.00', '0.00', '32.00', 27, 0, 27, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(142, '2025-10-09', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '22.8', '53.17', '0.00', '24.00', '0.00', 23, 23, 0, 0, 0, 0, 0, '-16.70', '-15.00', 51986691, '2025-10-15 13:49:48'),
(143, '2025-10-09', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '36.6', '7.35', '0.00', '24.00', '32.00', 3, 0, 0, 0, 3, 0, 0, '-32.20', '-35.00', 3848052, '2025-10-15 13:49:48'),
(144, '2025-10-09', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.90', '-33.00', 13147224, '2025-10-15 13:49:48'),
(145, '2025-10-09', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 0, 1, 0, 0, '-33.00', '-27.00', 156277, '2025-10-15 13:49:48'),
(146, '2025-10-09', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-30.00', 105886, '2025-10-15 13:49:48'),
(147, '2025-10-09', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-36.00', 168152566, '2025-10-15 13:49:48'),
(148, '2025-10-09', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.40', '-40.00', 151594513, '2025-10-15 13:49:48'),
(149, '2025-10-09', '', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 35066569, '2025-10-15 13:49:48'),
(150, '2025-10-09', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 22303636, '2025-10-15 13:49:48'),
(158, '2025-10-10', '', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 40287871, '2025-10-15 13:49:48'),
(159, '2025-10-10', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 20743017, '2025-10-15 13:49:48'),
(160, '2025-10-10', 'KATHY DURNIL', 'NTWK-GLWD2_E7-1-1-6-57296', 'NTWK-GLWD2_E7', 'KATHY DURNIL', '1-1-6-57296', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-28.50', '-40.00', 6790980, '2025-10-15 13:49:48'),
(161, '2025-10-11', '', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '8.8', '50.68', '0.00', '8.51', '32.00', 28, 0, 0, 0, 28, 0, 0, '-33.00', '-30.00', 46605, '2025-10-15 13:49:48'),
(162, '2025-10-11', 'JENNA GIBSON', 'NTWK-ODON_E7-1-1-3-111312', 'NTWK-ODON_E7', 'JENNA GIBSON', '1-1-3-111312', '15.0', '61.00', '0.00', '24.00', '0.00', 41, 20, 0, 0, 0, 0, 0, '-17.80', '0.00', 326607, '2025-10-15 13:49:48'),
(163, '2025-10-11', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '17.1', '58.95', '0.00', '24.00', '0.00', 28, 24, 0, 4, 0, 0, 0, '-16.70', '-15.00', 55764003, '2025-10-15 13:49:48'),
(164, '2025-10-11', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '19.2', '48.85', '0.00', '0.00', '32.00', 23, 0, 23, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-15 13:49:48'),
(165, '2025-10-11', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '36.5', '7.53', '0.00', '24.00', '32.00', 4, 0, 0, 0, 2, 0, 0, '-32.20', '-35.00', 3037840, '2025-10-15 13:49:48'),
(166, '2025-10-11', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '38.3', '5.71', '0.00', '24.00', '32.00', 2, 1, 0, 1, 0, 0, 0, '-28.50', '-30.00', 58838772, '2025-10-15 13:49:48'),
(167, '2025-10-11', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '39.0', '4.97', '0.00', '24.00', '32.00', 2, 0, 0, 0, 2, 0, 0, '-33.00', '-27.00', 190986, '2025-10-15 13:49:48'),
(168, '2025-10-11', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.40', '-40.00', 159661787, '2025-10-15 13:49:48'),
(170, '2025-10-11', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 15092501, '2025-10-15 13:49:48'),
(171, '2025-10-12', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '6.2', '37.84', '0.00', '24.00', '32.00', 16, 9, 0, 7, 0, 0, 0, '-29.20', '-31.00', 58168894, '2025-10-15 13:49:48'),
(172, '2025-10-12', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '8.7', '67.34', '0.00', '24.00', '0.00', 37, 25, 0, 12, 0, 0, 0, '-16.80', '-15.00', 71054503, '2025-10-15 13:49:48'),
(173, '2025-10-12', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '19.2', '48.85', '0.00', '0.00', '32.00', 23, 0, 23, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-15 13:49:48'),
(174, '2025-10-12', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '23.8', '44.22', '0.00', '0.00', '32.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-15 13:49:48'),
(175, '2025-10-12', 'Tim Showalter', 'NTWK-MTGM2_E7-1-1-5-35', 'NTWK-MTGM2_E7', 'Tim Showalter', '1-1-5-35', '35.9', '64.12', '0.00', '0.00', '0.00', 45, 0, 0, 0, 0, 45, 0, '-17.40', NULL, 0, '2025-10-15 13:49:48'),
(176, '2025-10-12', '', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '38.1', '29.90', '0.00', '0.00', '32.00', 14, 0, 0, 0, 14, 0, 0, '-34.00', '-30.00', 12982, '2025-10-15 13:49:48'),
(177, '2025-10-12', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-33.00', 69317211, '2025-10-15 13:49:48'),
(178, '2025-10-12', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 0, 1, 0, 0, '-33.00', '-27.00', 490615, '2025-10-15 13:49:48'),
(179, '2025-10-12', 'Loukas Gray', 'NTWK-WEFD2_E7-1-2-8-33566', 'NTWK-WEFD2_E7', 'Loukas Gray', '1-2-8-33566', '42.5', '33.48', '0.00', '24.00', '0.00', 13, 10, 0, 3, 0, 0, 0, '-15.40', '-15.00', 28176050, '2025-10-15 13:49:48'),
(180, '2025-10-12', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 298072791, '2025-10-15 13:49:48'),
(191, '2025-10-16', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '11.3', '64.25', '0.00', '14.34', '10.07', 41, 0, 0, 0, 41, 0, 0, '-26.20', '-24.95', 64803, '2025-10-16 12:00:57'),
(192, '2025-10-16', 'JEREMY R LASHLEY', 'NTWK-MTGM2_E7-1-1-4-20', 'NTWK-MTGM2_E7', 'JEREMY R LASHLEY', '1-1-4-20', '17.9', '82.08', '0.00', '0.00', '0.00', 77, 0, 0, 0, 0, 77, 0, '-17.30', '-14.14', 0, '2025-10-16 12:00:57'),
(193, '2025-10-16', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '25.4', '42.58', '0.00', '0.00', '32.00', 19, 0, 19, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-16 12:00:57'),
(194, '2025-10-16', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '27.1', '40.89', '0.00', '0.00', '32.00', 18, 0, 18, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-16 12:00:57'),
(195, '2025-10-16', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '37.2', '38.80', '0.00', '24.00', '0.00', 16, 11, 0, 5, 0, 0, 0, '-16.80', '-15.00', 56517516, '2025-10-16 12:00:57'),
(196, '2025-10-16', 'RODNEY MILLER', 'NTWK-SWFT2_E7-1-2-6-74235', 'NTWK-SWFT2_E7', 'RODNEY MILLER', '1-2-6-74235', '38.3', '5.71', '0.00', '24.00', '32.00', 2, 1, 0, 1, 0, 0, 0, '-30.50', '-30.00', 38363605, '2025-10-16 12:00:57'),
(197, '2025-10-16', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'NTWK-WLMS2_E7', 'GERALD AMSTUTZ', '1-1-3-285', '38.4', '61.60', '0.00', '0.00', '0.00', 44, 0, 0, 0, 0, 39, 0, '-16.00', NULL, 0, '2025-10-16 12:00:57'),
(198, '2025-10-16', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-33.00', 11962557, '2025-10-16 12:00:57'),
(199, '2025-10-16', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 411298145, '2025-10-16 12:00:57'),
(200, '2025-10-16', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 162844619, '2025-10-16 12:00:57'),
(201, '2025-10-17', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '0.0', '97.99', '20.00', '24.00', '0.00', 269, 267, 0, 2, 0, 0, 0, '-22.40', '-20.00', 10710649, '2025-10-17 12:01:04'),
(202, '2025-10-17', 'JOHN SUPEL', 'NTWK-GRAM-1-2-1-50662', 'NTWK-GRAM', 'JOHN SUPEL', '1-2-1-50662', '13.8', '62.24', '0.00', '24.00', '0.00', 32, 22, 0, 10, 0, 0, 0, '-16.80', '-15.00', 29701837, '2025-10-17 12:01:04'),
(203, '2025-10-17', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '19.2', '48.85', '0.00', '0.00', '32.00', 23, 0, 23, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-17 12:01:04'),
(204, '2025-10-17', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '29.8', '50.68', '0.00', '9.45', '10.07', 28, 0, 0, 0, 28, 0, 0, '-26.20', '-24.95', 49533, '2025-10-17 12:01:04'),
(205, '2025-10-17', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '30.6', '37.36', '0.00', '0.00', '32.00', 16, 0, 16, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-17 12:01:04'),
(206, '2025-10-17', 'DARREL DYE', 'NTWK-TRSP_E7-1-1-4-16', 'NTWK-TRSP_E7', 'DARREL DYE', '1-1-4-16', '31.5', '28.80', '0.00', '24.00', '15.68', 12, 6, 0, 1, 0, 5, 0, '-28.90', '0.00', 2986661, '2025-10-17 12:01:04'),
(207, '2025-10-17', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '36.6', '7.35', '0.00', '24.00', '32.00', 3, 0, 0, 0, 3, 0, 0, '-33.00', '-27.00', 98743, '2025-10-17 12:01:04'),
(208, '2025-10-17', 'RODNEY MILLER', 'NTWK-SWFT2_E7-1-2-6-74235', 'NTWK-SWFT2_E7', 'RODNEY MILLER', '1-2-6-74235', '37.6', '6.44', '0.00', '24.00', '32.00', 2, 2, 0, 0, 0, 0, 0, '-30.50', '-30.00', 5406325, '2025-10-17 12:01:04'),
(209, '2025-10-17', 'FRANSISCO FLORES', 'NTWK-WEFD2_E7-1-1-3-1070', 'NTWK-WEFD2_E7', 'FRANSISCO FLORES', '1-1-3-1070', '39.1', '28.94', '0.00', '0.00', '32.00', 25, 0, 0, 0, 0, 0, 0, '-22.10', '-30.00', 794, '2025-10-17 12:01:04'),
(210, '2025-10-17', 'JAMES ISAACS', 'NTWK-LOGT_E7-1-2-6-70797', 'NTWK-LOGT_E7', 'JAMES ISAACS', '1-2-6-70797', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-28.50', '-33.00', 17735698, '2025-10-17 12:01:04'),
(211, '2025-10-18', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '0.0', '91.76', '0.00', '24.00', '0.00', 81, 81, 0, 0, 0, 0, 0, '-22.40', '-20.00', 11441480, '2025-10-18 12:01:10'),
(212, '2025-10-18', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '14.9', '58.55', '0.00', '16.52', '10.07', 35, 0, 0, 0, 35, 0, 0, '-26.20', '-24.95', 71621, '2025-10-18 12:01:10'),
(213, '2025-10-18', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '22.2', '45.81', '0.00', '0.00', '32.00', 21, 0, 21, 0, 0, 0, 0, '-30.00', '-23.00', 0, '2025-10-18 12:01:10'),
(214, '2025-10-18', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '32.5', '35.51', '0.00', '0.00', '32.00', 15, 0, 15, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-18 12:01:10'),
(215, '2025-10-18', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '39.0', '4.97', '0.00', '24.00', '32.00', 2, 0, 0, 0, 2, 0, 0, '-33.00', '-27.00', 121335, '2025-10-18 12:01:10'),
(216, '2025-10-18', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 444779570, '2025-10-18 12:01:10'),
(217, '2025-10-18', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 166852460, '2025-10-18 12:01:10'),
(218, '2025-10-18', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 54729401, '2025-10-18 12:01:10'),
(219, '2025-10-18', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 22172170, '2025-10-18 12:01:10'),
(220, '2025-10-18', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-35.00', 13337662, '2025-10-18 12:01:10'),
(221, '2025-10-19', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '14.3', '60.55', '0.00', '14.86', '10.28', 37, 0, 0, 0, 37, 0, 0, '-26.40', '-24.81', 66433, '2025-10-19 12:01:15'),
(222, '2025-10-19', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '23.8', '44.22', '0.00', '0.00', '32.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-19 12:01:15'),
(223, '2025-10-19', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '23.8', '44.22', '0.00', '0.00', '32.00', 20, 0, 20, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-19 12:01:15'),
(224, '2025-10-19', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '38.4', '29.63', '0.00', '0.00', '32.00', 12, 0, 12, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-19 12:01:15'),
(225, '2025-10-19', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '39.0', '4.97', '0.00', '24.00', '32.00', 2, 0, 0, 0, 2, 0, 0, '-33.00', '-27.00', 190996, '2025-10-19 12:01:15'),
(226, '2025-10-19', 'JEAN SWINEHEART', 'NTWK-GLWD3_E7-1-1-1-1', 'NTWK-GLWD3_E7', '', '1-1-1-1', '42.6', '25.40', '0.00', '0.00', '32.00', 10, 0, 10, 0, 0, 0, 0, '-34.00', '-30.00', 0, '2025-10-19 12:01:15'),
(227, '2025-10-19', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 740059940, '2025-10-19 12:01:15'),
(228, '2025-10-19', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 142963983, '2025-10-19 12:01:15'),
(229, '2025-10-19', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 47927107, '2025-10-19 12:01:15'),
(230, '2025-10-19', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 23697311, '2025-10-19 12:01:16'),
(231, '2025-10-20', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '0.0', '86.54', '0.00', '16.21', '0.00', 83, 0, 0, 0, 82, 0, 0, '-17.00', '-18.93', 70655, '2025-10-20 12:01:23'),
(232, '2025-10-20', 'FRANSISCO FLORES', 'NTWK-WEFD2_E7-1-1-3-1070', 'NTWK-WEFD2_E7', 'FRANSISCO FLORES', '1-1-3-1070', '14.1', '53.88', '0.00', '0.00', '32.00', 57, 0, 0, 0, 0, 0, 0, '-21.40', '-30.00', 327, '2025-10-20 12:01:23'),
(233, '2025-10-20', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '19.2', '48.85', '0.00', '0.00', '32.00', 23, 0, 23, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-20 12:01:23'),
(234, '2025-10-20', 'JOSHUA NEIDEFFER', 'NTWK-TRSP_E7-1-1-1-107706', 'NTWK-TRSP_E7', 'JOSHUA NEIDEFFER', '1-1-1-107706', '29.1', '46.94', '0.00', '24.00', '0.00', 26, 0, 0, 0, 24, 0, 0, '-18.00', '-16.02', 133071, '2025-10-20 12:01:23'),
(235, '2025-10-20', 'TRAVIS INMAN', 'NTWK-LOGT_E7-1-2-5-2025', 'NTWK-LOGT_E7', 'TRAVIS INMAN', '1-2-5-2025', '31.8', '28.52', '0.00', '7.69', '32.00', 14, 2, 0, 0, 9, 0, 0, '-30.00', '-28.86', 44016, '2025-10-20 12:01:23'),
(236, '2025-10-20', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '35.4', '32.57', '0.00', '0.00', '32.00', 14, 0, 13, 0, 0, 0, 0, '-30.00', '-26.00', 2, '2025-10-20 12:01:23'),
(237, '2025-10-20', 'HUNTER ESCALERA', 'NTWK-WEFD2_E7-1-2-6-74818', 'NTWK-WEFD2_E7', 'HUNTER ESCALERA', '1-2-6-74818', '37.6', '6.44', '0.00', '24.00', '32.00', 2, 2, 0, 0, 0, 0, 0, '-18.20', '-30.00', 126187, '2025-10-20 12:01:23'),
(238, '2025-10-20', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '37.7', '6.26', '0.00', '24.00', '32.00', 3, 0, 0, 0, 2, 0, 0, '-33.00', '-27.00', 134685, '2025-10-20 12:01:23'),
(239, '2025-10-20', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '38.4', '29.63', '0.00', '0.00', '32.00', 12, 0, 12, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-20 12:01:23'),
(240, '2025-10-20', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '41.6', '26.41', '0.00', '0.00', '32.00', 11, 0, 10, 0, 0, 0, 0, '-30.50', '-26.00', 2, '2025-10-20 12:01:23'),
(241, '2025-10-21', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '0.0', '83.31', '0.00', '24.00', '0.00', 73, 0, 0, 0, 73, 0, 0, '-17.00', '-18.93', 104917, '2025-10-21 12:01:29'),
(242, '2025-10-21', 'KEVIN DOSCHER', 'NTWK-MTGM2_E7-1-1-2-9', 'NTWK-MTGM2_E7', 'KEVIN DOSCHER', '1-1-2-9', '11.0', '88.96', '0.00', '0.00', '0.00', 101, 0, 0, 0, 0, 101, 0, '-18.40', NULL, 0, '2025-10-21 12:01:29'),
(243, '2025-10-21', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '19.2', '48.85', '0.00', '0.00', '32.00', 23, 0, 23, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-21 12:01:29'),
(244, '2025-10-21', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '36.4', '31.65', '0.00', '0.00', '32.00', 13, 0, 13, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-10-21 12:01:29'),
(245, '2025-10-21', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '36.6', '7.35', '0.00', '24.00', '32.00', 3, 0, 0, 0, 3, 0, 0, '-33.00', '-27.00', 110605, '2025-10-21 12:01:29'),
(246, '2025-10-21', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '38.3', '5.71', '0.00', '24.00', '32.00', 2, 1, 0, 1, 0, 0, 0, '-27.20', '-40.00', 441269664, '2025-10-21 12:01:29'),
(247, '2025-10-21', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-21 12:01:29'),
(248, '2025-10-21', 'JOSHUA NEIDEFFER', 'NTWK-TRSP_E7-1-1-1-107706', 'NTWK-TRSP_E7', 'JOSHUA NEIDEFFER', '1-1-1-107706', '41.0', '35.01', '0.00', '24.00', '0.00', 17, 0, 0, 0, 17, 0, 0, '-18.00', '-16.02', 96656, '2025-10-21 12:01:29'),
(249, '2025-10-21', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 147922834, '2025-10-21 12:01:29'),
(250, '2025-10-21', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 63928380, '2025-10-21 12:01:29'),
(251, '2025-10-22', 'BETH KALB', 'NTWK-GLWD2_E7-1-1-2-811254', 'NTWK-GLWD2_E7', 'BETH KALB', '1-1-2-811254', '0.0', '91.15', '0.00', '24.00', '0.00', 102, 1, 0, 0, 101, 0, 0, '-16.70', '-16.57', 1844409, '2025-10-22 12:01:33'),
(252, '2025-10-22', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '0.0', '86.97', '0.00', '24.00', '0.00', 84, 0, 0, 0, 84, 0, 0, '-17.00', '-18.93', 105517, '2025-10-22 12:01:33'),
(253, '2025-10-22', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '22.0', '46.01', '0.00', '0.00', '32.00', 21, 1, 20, 0, 0, 0, 0, '-30.00', '-24.00', 2, '2025-10-22 12:01:33'),
(254, '2025-10-22', 'JOSHUA NEIDEFFER', 'NTWK-TRSP_E7-1-1-1-107706', 'NTWK-TRSP_E7', 'JOSHUA NEIDEFFER', '1-1-1-107706', '30.5', '45.49', '0.00', '24.00', '0.00', 24, 0, 0, 0, 24, 0, 0, '-18.00', '-16.02', 247496, '2025-10-22 12:01:33'),
(255, '2025-10-22', 'JAMIE GUY', 'NTWK-SWFT_E7-1-2-1-107022', 'NTWK-SWFT_E7', 'JAMIE GUY', '1-2-1-107022', '30.7', '54.23', '0.00', '4.82', '10.28', 31, 0, 0, 0, 31, 0, 0, '-26.40', '-24.81', 35077, '2025-10-22 12:01:33'),
(256, '2025-10-22', 'JOHN A. LEE', 'NTWK-STMP_E7-1-1-2-96044', 'NTWK-STMP_E7', 'JOHN A. LEE', '1-1-2-96044', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-21.00', 0, '2025-10-22 12:01:33'),
(257, '2025-10-22', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-22 12:01:33'),
(258, '2025-10-22', 'KALIN KNEPP', 'NTWK-MTGM2_E7-1-2-1-54389', 'NTWK-MTGM2_E7', 'KALIN KNEPP', '1-2-1-54389', '42.9', '50.68', '0.00', '0.00', '6.40', 22, 21, 0, 0, 0, 0, 0, '0.00', '-26.00', 7318, '2025-10-22 12:01:33'),
(259, '2025-10-22', 'ERIC M GRABER', 'NTWK-MTGM2_E7-1-2-1-68392', 'NTWK-MTGM2_E7', 'ERIC M GRABER', '1-2-1-68392', '43.6', '53.17', '0.00', '0.00', '3.20', 23, 23, 0, 0, 0, 0, 0, '0.00', '-25.00', 12, '2025-10-22 12:01:33'),
(260, '2025-10-22', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 429953307, '2025-10-22 12:01:33'),
(261, '2025-10-23', 'BETH KALB', 'NTWK-GLWD2_E7-1-1-2-811254', 'NTWK-GLWD2_E7', 'BETH KALB', '1-1-2-811254', '0.0', '88.31', '0.00', '24.00', '0.00', 89, 0, 0, 0, 89, 0, 0, '-16.70', '-16.57', 3111369, '2025-10-23 12:01:41'),
(262, '2025-10-23', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '0.0', '84.06', '0.00', '23.25', '0.00', 75, 0, 0, 0, 75, 0, 0, '-17.00', '-18.93', 92663, '2025-10-23 12:01:41'),
(263, '2025-10-23', 'COREY MARTIN', 'NTWK-STMP_E7-1-1-3-3', 'NTWK-STMP_E7', 'COREY MARTIN', '1-1-3-3', '19.7', '48.25', '0.00', '0.00', '32.00', 21, 12, 9, 0, 0, 0, 0, '-30.00', '-24.00', 6, '2025-10-23 12:01:41'),
(264, '2025-10-23', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '28.8', '39.15', '0.00', '0.00', '32.00', 17, 0, 17, 0, 0, 0, 0, '-30.50', '-26.00', 8, '2025-10-23 12:01:41'),
(265, '2025-10-23', 'JOHN A. LEE', 'NTWK-STMP_E7-1-1-2-96044', 'NTWK-STMP_E7', 'JOHN A. LEE', '1-1-2-96044', '30.6', '37.36', '0.00', '0.00', '32.00', 16, 0, 16, 0, 0, 0, 0, '-30.00', '-21.00', 0, '2025-10-23 12:01:41'),
(266, '2025-10-23', 'ROBERT HUGHES', 'NTWK-WEFD2_E7-1-1-6-50498', 'NTWK-WEFD2_E7', 'ROBERT HUGHES', '1-1-6-50498', '37.7', '38.32', '0.00', '24.00', '0.00', 16, 10, 0, 6, 0, 0, 0, '-21.40', '-20.00', 74684094, '2025-10-23 12:01:41'),
(267, '2025-10-23', 'HERSCHEL WAYNE RUSSELL', 'NTWK-RTFD_E7-1-1-5-68212', 'NTWK-RTFD_E7', 'HERSCHEL WAYNE RUSSELL', '1-1-5-68212', '39.0', '4.97', '0.00', '24.00', '32.00', 2, 0, 0, 0, 2, 0, 0, '-33.00', '-27.00', 236461, '2025-10-23 12:01:41'),
(268, '2025-10-23', 'TIFFANY LINGENFELTER', 'NTWK-LOGT2_E7-1-1-1-75127', 'NTWK-LOGT2_E7', 'TIFFANY LINGENFELTER', '1-1-1-75127', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-23 12:01:41'),
(269, '2025-10-23', 'JOSHUA NEIDEFFER', 'NTWK-TRSP_E7-1-1-1-107706', 'NTWK-TRSP_E7', 'JOSHUA NEIDEFFER', '1-1-1-107706', '41.0', '35.01', '0.00', '24.00', '0.00', 17, 0, 0, 0, 17, 0, 0, '-18.00', '-16.02', 166325, '2025-10-23 12:01:41'),
(270, '2025-10-23', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 336789160, '2025-10-23 12:01:41');
INSERT INTO `daily_health_report_archive` (`id`, `run_date`, `subscriber_id`, `node_straid`, `network_node`, `description`, `pon_ont`, `health`, `alarm_penalty`, `surge_penalty`, `bip_penalty`, `optics_penalty`, `alarms_24h_fault_total`, `alarms_24h_ont_missing`, `alarms_24h_low_optical_power_ne`, `alarms_24h_ds_sdber_exceeded`, `alarms_24h_us_sdber_exceeded`, `alarms_24h_ont_battery_failed`, `alarms_24h_ont_battery_missing`, `fe_optical_level`, `rx_optical_level`, `bip_errors_24h`, `created_at`) VALUES
(271, '2025-10-24', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '0.0', '97.94', '20.00', '24.00', '32.00', 239, 155, 0, 56, 28, 0, 0, '-32.20', '-35.00', 15759581, '2025-10-24 12:01:47'),
(272, '2025-10-24', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '0.0', '96.82', '20.00', '24.00', '0.00', 130, 130, 0, 0, 0, 0, 0, '-22.40', '-20.00', 458740, '2025-10-24 12:01:47'),
(273, '2025-10-24', 'BETH KALB', 'NTWK-GLWD2_E7-1-1-2-811254', 'NTWK-GLWD2_E7', 'BETH KALB', '1-1-2-811254', '0.0', '88.80', '0.00', '24.00', '0.00', 91, 0, 0, 0, 91, 0, 0, '-16.70', '-16.57', 3360666, '2025-10-24 12:01:47'),
(274, '2025-10-24', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '0.0', '84.76', '0.00', '15.81', '0.00', 77, 0, 0, 0, 77, 0, 0, '-17.00', '-18.93', 69421, '2025-10-24 12:01:47'),
(275, '2025-10-24', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '26.9', '17.12', '0.00', '24.00', '32.00', 6, 3, 3, 0, 0, 0, 0, '-32.20', '-40.00', 23748656, '2025-10-24 12:01:47'),
(276, '2025-10-24', 'JOHN A. LEE', 'NTWK-STMP_E7-1-1-2-96044', 'NTWK-STMP_E7', 'JOHN A. LEE', '1-1-2-96044', '30.6', '37.36', '0.00', '0.00', '32.00', 16, 0, 16, 0, 0, 0, 0, '-30.00', '-21.00', 0, '2025-10-24 12:01:47'),
(277, '2025-10-24', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '34.2', '22.44', '0.00', '11.38', '32.00', 10, 0, 0, 0, 10, 0, 0, '-33.00', '-30.00', 55548, '2025-10-24 12:01:47'),
(278, '2025-10-24', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 351458357, '2025-10-24 12:01:47'),
(279, '2025-10-24', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 174893065, '2025-10-24 12:01:47'),
(280, '2025-10-24', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 14419376, '2025-10-24 12:01:47'),
(281, '2025-10-25', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '0.0', '92.09', '0.00', '20.69', '0.00', 108, 0, 0, 0, 108, 0, 0, '-17.00', '-18.93', 84650, '2025-10-25 12:01:54'),
(282, '2025-10-25', 'BETH KALB', 'NTWK-GLWD2_E7-1-1-2-811254', 'NTWK-GLWD2_E7', 'BETH KALB', '1-1-2-811254', '8.2', '67.83', '0.00', '24.00', '0.00', 45, 1, 0, 0, 44, 0, 0, '-16.70', '-16.57', 349988, '2025-10-25 12:01:54'),
(283, '2025-10-25', 'JOHN A. LEE', 'NTWK-STMP_E7-1-1-2-96044', 'NTWK-STMP_E7', 'JOHN A. LEE', '1-1-2-96044', '20.7', '47.35', '0.00', '0.00', '32.00', 22, 0, 22, 0, 0, 0, 0, '-30.00', '-21.00', 0, '2025-10-25 12:01:54'),
(284, '2025-10-25', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '22.5', '41.23', '0.00', '4.27', '32.00', 21, 0, 0, 0, 21, 0, 0, '-33.00', '-30.00', 33332, '2025-10-25 12:01:54'),
(285, '2025-10-25', 'JOSHUA NEIDEFFER', 'NTWK-TRSP_E7-1-1-1-107706', 'NTWK-TRSP_E7', 'JOSHUA NEIDEFFER', '1-1-1-107706', '32.7', '54.23', '0.00', '13.02', '0.00', 31, 0, 0, 0, 31, 0, 0, '-18.00', '-16.02', 60691, '2025-10-25 12:01:54'),
(286, '2025-10-25', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '40.2', '3.84', '0.00', '24.00', '32.00', 2, 0, 0, 0, 1, 0, 0, '-32.20', '-35.00', 3759798, '2025-10-25 12:01:54'),
(287, '2025-10-25', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-29.60', '-33.00', 459662, '2025-10-25 12:01:54'),
(288, '2025-10-25', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-27.20', '-40.00', 561128547, '2025-10-25 12:01:54'),
(289, '2025-10-25', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 150016072, '2025-10-25 12:01:54'),
(290, '2025-10-25', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 42095836, '2025-10-25 12:01:54'),
(291, '2025-10-26', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '16.6', '64.25', '0.00', '19.15', '0.00', 41, 0, 0, 0, 41, 0, 0, '-18.50', '-22.44', 79849, '2025-10-26 12:02:00'),
(292, '2025-10-26', 'BREANNA KRAMER', 'NTWK-SWFT3_E7-1-1-2-77514', 'NTWK-SWFT3_E7', 'BREANNA KRAMER', '1-1-2-77514', '27.1', '40.89', '0.00', '0.00', '32.00', 18, 0, 18, 0, 0, 0, 0, '-30.50', '-27.00', 0, '2025-10-26 12:02:00'),
(293, '2025-10-26', 'NATHAN WALKER', 'NTWK-LOGT2_E7-1-1-1-87911', 'NTWK-LOGT2_E7', 'NATHAN WALKER', '1-1-1-87911', '37.3', '38.68', '0.00', '24.00', '0.00', 15, 14, 0, 1, 0, 0, 0, '-21.70', '-17.00', 34403533, '2025-10-26 12:02:00'),
(294, '2025-10-26', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-25.00', 7, '2025-10-26 12:02:00'),
(295, '2025-10-26', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '41.7', '26.27', '0.00', '0.00', '32.00', 12, 0, 0, 0, 12, 0, 0, '-33.00', '-30.00', 8682, '2025-10-26 12:02:00'),
(296, '2025-10-26', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-26.80', '-40.00', 518513910, '2025-10-26 12:02:00'),
(297, '2025-10-26', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 174415884, '2025-10-26 12:02:00'),
(298, '2025-10-26', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 137112973, '2025-10-26 12:02:00'),
(299, '2025-10-26', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 28251175, '2025-10-26 12:02:00'),
(300, '2025-10-26', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'NTWK-DHVL_E7', 'TYE GAZARIAN', '1-1-1-54393', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-35.00', 3091279, '2025-10-26 12:02:00'),
(301, '2025-10-27', 'NSL Farms Inc', 'NTWK-GFWA2_E7-1-2-1-214', 'NTWK-GFWA2_E7', 'NSL Farms Inc', '1-2-1-214', '10.4', '89.58', '0.00', '0.00', '0.00', 104, 0, 0, 0, 0, 104, 0, '-22.00', NULL, 0, '2025-10-27 12:21:32'),
(302, '2025-10-27', 'BREANNA KRAMER', 'NTWK-SWFT3_E7-1-1-2-77514', 'NTWK-SWFT3_E7', 'BREANNA KRAMER', '1-1-2-77514', '17.7', '50.30', '0.00', '0.00', '32.00', 24, 0, 24, 0, 0, 0, 0, '-30.50', '-27.00', 0, '2025-10-27 12:21:32'),
(303, '2025-10-27', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '24.6', '69.13', '0.00', '6.26', '0.00', 47, 0, 0, 0, 47, 0, 0, '-18.50', '-22.44', 39555, '2025-10-27 12:21:32'),
(304, '2025-10-27', 'ROBERT HUGHES', 'NTWK-WEFD2_E7-1-1-6-50498', 'NTWK-WEFD2_E7', 'ROBERT HUGHES', '1-1-6-50498', '34.2', '41.80', '0.00', '24.00', '0.00', 18, 11, 0, 7, 0, 0, 0, '-21.40', '-20.00', 16018123, '2025-10-27 12:21:32'),
(305, '2025-10-27', 'BILLY EDWARDS', 'NTWK-SWFT2_E7-1-1-1-61141', 'NTWK-SWFT2_E7', 'BILLY EDWARDS', '1-1-1-61141', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-29.60', '-33.00', 1165170, '2025-10-27 12:21:32'),
(306, '2025-10-27', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '41.5', '34.50', '0.00', '24.00', '0.00', 13, 12, 0, 1, 0, 0, 0, '-22.30', '-20.00', 22999567, '2025-10-27 12:21:32'),
(307, '2025-10-27', 'BRANDON POOLE', 'NTWK-LOGT_E7-1-2-8-33292', 'NTWK-LOGT_E7', 'BRANDON POOLE', '1-2-8-33292', '42.6', '1.36', '0.00', '24.00', '32.00', 1, 0, 0, 0, 0, 0, 0, '-27.70', '-40.00', 324594, '2025-10-27 12:21:32'),
(308, '2025-10-27', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '43.6', '24.38', '0.00', '0.00', '32.00', 11, 0, 0, 0, 11, 0, 0, '-33.00', '-30.00', 7816, '2025-10-27 12:21:32'),
(309, '2025-10-27', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-26.80', '-40.00', 204334917, '2025-10-27 12:21:32'),
(310, '2025-10-27', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-24.90', '-40.00', 147388057, '2025-10-27 12:21:32'),
(311, '2025-10-28', 'ALEXIS ROBBINS', 'NTWK-GRAM-1-1-2-107834', 'NTWK-GRAM', 'ALEXIS ROBBINS', '1-1-2-107834', '7.0', '70.59', '0.00', '22.38', '0.00', 49, 0, 0, 0, 49, 0, 0, '-18.50', '-22.44', 89925, '2025-10-28 12:00:45'),
(312, '2025-10-28', 'BREANNA KRAMER', 'NTWK-SWFT3_E7-1-1-2-77514', 'NTWK-SWFT3_E7', 'BREANNA KRAMER', '1-1-2-77514', '19.0', '49.04', '0.00', '0.00', '32.00', 23, 1, 22, 0, 0, 0, 0, '-30.50', '-27.00', 2, '2025-10-28 12:00:45'),
(313, '2025-10-28', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '34.4', '33.61', '0.00', '0.00', '32.00', 14, 0, 14, 0, 0, 0, 0, '-30.00', '-25.00', 0, '2025-10-28 12:00:45'),
(314, '2025-10-28', 'ROBERT HUGHES', 'NTWK-WEFD2_E7-1-1-6-50498', 'NTWK-WEFD2_E7', 'ROBERT HUGHES', '1-1-6-50498', '35.2', '40.78', '0.00', '24.00', '0.00', 17, 12, 0, 5, 0, 0, 0, '-21.40', '-20.00', 57366758, '2025-10-28 12:00:45'),
(315, '2025-10-28', 'GREG PURCELL', 'NTWK-WEFD2_E7-1-1-4-82853', 'NTWK-WEFD2_E7', 'GREG PURCELL', '1-1-4-82853', '37.8', '9.68', '0.00', '24.00', '28.48', 4, 0, 0, 4, 0, 0, 0, '-28.90', '-28.00', 13497783, '2025-10-28 12:00:45'),
(316, '2025-10-28', 'HEIDI MYERS', 'NTWK-PTWM_E7-1-1-4-64', 'NTWK-PTWM_E7', 'HEIDI MYERS', '1-1-4-64', '38.4', '61.63', '0.00', '0.00', '0.00', 42, 0, 0, 0, 0, 42, 0, '-17.00', NULL, 0, '2025-10-28 12:00:45'),
(317, '2025-10-28', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-28 12:00:45'),
(318, '2025-10-28', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '40.7', '3.28', '0.00', '24.00', '32.00', 1, 1, 0, 0, 0, 0, 0, '-24.90', '-40.00', 285800958, '2025-10-28 12:00:45'),
(319, '2025-10-28', 'WHA_617_6th_St', 'NTWK-SWFT2_E7-1-1-7-1', 'NTWK-SWFT2_E7', '', '1-1-7-1', '41.2', '26.84', '0.00', '0.00', '32.00', 10, 5, 5, 0, 0, 0, 0, '-32.20', '-30.00', 4, '2025-10-28 12:00:45'),
(320, '2025-10-28', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-26.80', '-40.00', 514870325, '2025-10-28 12:00:45'),
(321, '2025-10-29', 'RICHER FARMS', 'NTWK-NLGT1_E7-1-1-5-72049', 'NTWK-NLGT1_E7', 'RICHER FARMS', '1-1-5-72049', '0.0', '98.00', '20.00', '1.30', '0.00', 490, 490, 0, 0, 0, 0, 0, '-23.90', '-22.00', 24073, '2025-10-29 12:00:52'),
(322, '2025-10-29', 'BREANNA KRAMER', 'NTWK-SWFT3_E7-1-1-2-77514', 'NTWK-SWFT3_E7', 'BREANNA KRAMER', '1-1-2-77514', '16.3', '51.71', '0.00', '0.00', '32.00', 25, 0, 25, 0, 0, 0, 0, '-30.50', '-27.00', 0, '2025-10-29 12:00:52'),
(323, '2025-10-29', 'FRANSISCO FLORES', 'NTWK-WEFD2_E7-1-1-3-1070', 'NTWK-WEFD2_E7', 'FRANSISCO FLORES', '1-1-3-1070', '22.2', '45.81', '0.00', '0.00', '32.00', 45, 0, 0, 0, 0, 0, 0, '-22.50', '-30.46', 311, '2025-10-29 12:00:52'),
(324, '2025-10-29', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '28.8', '39.15', '0.00', '0.00', '32.00', 17, 0, 17, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-29 12:00:52'),
(325, '2025-10-29', 'Jordon Russell', 'NTWK-MTGM2_E7-1-1-6-23', 'NTWK-MTGM2_E7', '', '1-1-6-23', '37.6', '6.44', '0.00', '24.00', '32.00', 2, 2, 0, 0, 0, 0, 0, '-24.90', '-40.00', 51736955, '2025-10-29 12:00:52'),
(326, '2025-10-29', 'GREG PURCELL', 'NTWK-WEFD2_E7-1-1-4-82853', 'NTWK-WEFD2_E7', 'GREG PURCELL', '1-1-4-82853', '40.2', '7.35', '0.00', '24.00', '28.48', 3, 0, 0, 3, 0, 0, 0, '-28.90', '-28.00', 17099928, '2025-10-29 12:00:52'),
(327, '2025-10-29', 'BRANDON POOLE', 'NTWK-LOGT_E7-1-2-8-33292', 'NTWK-LOGT_E7', 'BRANDON POOLE', '1-2-8-33292', '40.7', '3.28', '0.00', '24.00', '32.00', 1, 1, 0, 0, 0, 0, 0, '-27.70', '-40.00', 693220, '2025-10-29 12:00:52'),
(328, '2025-10-29', 'CLEMENTE DeLEON', 'NTWK-SWFT2_E7-1-1-6-51892', 'NTWK-SWFT2_E7', 'CLEMENTE DeLEON', '1-1-6-51892', '41.5', '2.52', '0.00', '24.00', '32.00', 1, 0, 0, 1, 0, 0, 0, '-29.20', '-31.00', 4461598, '2025-10-29 12:00:52'),
(329, '2025-10-29', 'KATHY O\'HAVER', 'NTWK-ODON2_E7-1-1-3-345', 'NTWK-ODON2_E7', 'KATHY O\'HAVER', '1-1-3-345', '41.6', '26.41', '0.00', '0.00', '32.00', 13, 5, 2, 0, 0, 0, 0, '-32.20', '-25.38', 4, '2025-10-29 12:00:52'),
(330, '2025-10-29', 'ALEX MARTIN', 'NTWK-NLGT1_E7-1-2-4-75395', 'NTWK-NLGT1_E7', 'ALEX MARTIN', '1-2-4-75395', '41.7', '34.25', '0.00', '24.00', '0.00', 15, 8, 0, 5, 0, 0, 0, '-16.20', '-16.00', 37641653, '2025-10-29 12:00:52'),
(331, '2025-10-30', 'RICHER FARMS', 'NTWK-NLGT1_E7-1-1-5-72049', 'NTWK-NLGT1_E7', 'RICHER FARMS', '1-1-5-72049', '0.0', '98.00', '20.00', '0.00', '0.00', 547, 547, 0, 0, 0, 0, 0, '-23.90', '-22.00', 2, '2025-10-30 12:00:58'),
(332, '2025-10-30', 'CHARLES WOODHULL', 'NTWK-SWFT3_E7-1-1-2-45042', 'NTWK-SWFT3_E7', 'CHARLES WOODHULL', '1-1-2-45042', '19.2', '48.85', '0.00', '0.00', '32.00', 23, 0, 23, 0, 0, 0, 0, '-30.50', '-24.00', 0, '2025-10-30 12:00:58'),
(333, '2025-10-30', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '27.1', '40.89', '0.00', '0.00', '32.00', 18, 0, 18, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-30 12:00:58'),
(334, '2025-10-30', 'BREANNA KRAMER', 'NTWK-SWFT3_E7-1-1-2-77514', 'NTWK-SWFT3_E7', 'BREANNA KRAMER', '1-1-2-77514', '36.8', '31.25', '0.00', '0.00', '32.00', 12, 6, 6, 0, 0, 0, 0, '-30.50', '-27.00', 6, '2025-10-30 12:00:58'),
(335, '2025-10-30', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '38.4', '29.63', '0.00', '0.00', '32.00', 12, 0, 12, 0, 0, 0, 0, '-30.00', '-25.00', 0, '2025-10-30 12:00:58'),
(336, '2025-10-30', 'GREG PURCELL', 'NTWK-WEFD2_E7-1-1-4-82853', 'NTWK-WEFD2_E7', 'GREG PURCELL', '1-1-4-82853', '42.6', '4.97', '0.00', '24.00', '28.48', 2, 0, 0, 2, 0, 0, 0, '-28.90', '-28.00', 12728350, '2025-10-30 12:00:58'),
(337, '2025-10-30', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-26.80', '-40.00', 439866984, '2025-10-30 12:00:58'),
(338, '2025-10-30', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 133417713, '2025-10-30 12:00:58'),
(339, '2025-10-30', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'NTWK-WEFD3_E7', 'MITCHELL WAGLER', '1-1-4-44510', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-32.20', '-40.00', 20929161, '2025-10-30 12:00:58'),
(340, '2025-10-30', 'CLEMENTE DeLEON', 'NTWK-SWFT2_E7-1-1-6-51892', 'NTWK-SWFT2_E7', 'CLEMENTE DeLEON', '1-1-6-51892', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-29.20', '-31.00', 3708266, '2025-10-30 12:00:58'),
(341, '2025-10-31', 'BRO ALFRED HELMS', 'NTWK-RTFD_E7-1-1-4-44', 'NTWK-RTFD_E7', 'BRO ALFRED HELMS', '1-1-4-44', '8.1', '91.86', '0.00', '0.00', '0.00', 108, 48, 0, 0, 0, 31, 0, '-15.30', NULL, 28, '2025-10-31 12:01:04'),
(342, '2025-10-31', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '22.2', '45.81', '0.00', '0.00', '32.00', 21, 0, 21, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-10-31 12:01:04'),
(343, '2025-10-31', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '23.6', '52.44', '0.00', '24.00', '0.00', 23, 21, 0, 2, 0, 0, 0, '-22.30', '-20.00', 48569823, '2025-10-31 12:01:04'),
(344, '2025-10-31', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '25.1', '18.88', '0.00', '24.00', '32.00', 7, 4, 0, 3, 0, 0, 0, '-26.80', '-40.00', 1318031519, '2025-10-31 12:01:04'),
(345, '2025-10-31', 'ERICA PETTY', 'NTWK-WEFD_E7-1-2-7-107326', 'NTWK-WEFD_E7', 'ERICA PETTY', '1-2-7-107326', '26.2', '49.82', '0.00', '24.00', '0.00', 27, 1, 0, 0, 26, 0, 0, '-21.70', '-23.66', 192089, '2025-10-31 12:01:04'),
(346, '2025-10-31', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '26.9', '26.27', '0.00', '14.88', '32.00', 12, 0, 0, 0, 12, 0, 0, '-33.00', '-29.00', 66485, '2025-10-31 12:01:04'),
(347, '2025-10-31', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'NTWK-WLMS2_E7', 'GERALD AMSTUTZ', '1-1-3-285', '33.3', '66.68', '0.00', '0.00', '0.00', 52, 0, 0, 0, 0, 43, 0, '-16.00', NULL, 0, '2025-10-31 12:01:04'),
(348, '2025-10-31', 'CHARLES WOODHULL', 'NTWK-SWFT3_E7-1-1-2-45042', 'NTWK-SWFT3_E7', 'CHARLES WOODHULL', '1-1-2-45042', '34.4', '33.61', '0.00', '0.00', '32.00', 14, 0, 14, 0, 0, 0, 0, '-30.50', '-24.00', 0, '2025-10-31 12:01:04'),
(349, '2025-10-31', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-25.00', 0, '2025-10-31 12:01:04'),
(350, '2025-10-31', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.80', '-35.00', 176121059, '2025-10-31 12:01:04'),
(351, '2025-11-01', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '0.0', '53.08', '0.00', '24.00', '32.00', 30, 0, 0, 0, 30, 0, 0, '-33.00', '-29.00', 128297, '2025-11-01 12:01:17'),
(352, '2025-11-01', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '5.9', '70.15', '0.00', '24.00', '0.00', 37, 37, 0, 0, 0, 0, 0, '-22.30', '-20.00', 47088979, '2025-11-01 12:01:17'),
(353, '2025-11-01', 'ERICA PETTY', 'NTWK-WEFD_E7-1-2-7-107326', 'NTWK-WEFD_E7', 'ERICA PETTY', '1-2-7-107326', '12.6', '63.36', '0.00', '24.00', '0.00', 40, 0, 0, 0, 40, 0, 0, '-21.70', '-23.66', 181962, '2025-11-01 12:01:17'),
(354, '2025-11-01', 'EARL WAGLER', 'NTWK-MTGM2_E7-1-2-6-277', 'NTWK-MTGM2_E7', 'EARL WAGLER', '1-2-6-277', '16.5', '83.51', '0.00', '0.00', '0.00', 81, 0, 0, 0, 0, 81, 0, '-23.70', NULL, 0, '2025-11-01 12:01:17'),
(355, '2025-11-01', 'CHARLES WOODHULL', 'NTWK-SWFT3_E7-1-1-2-45042', 'NTWK-SWFT3_E7', 'CHARLES WOODHULL', '1-1-2-45042', '21.8', '46.22', '0.00', '0.00', '32.00', 21, 2, 19, 0, 0, 0, 0, '-30.50', '-24.00', 2, '2025-11-01 12:01:17'),
(356, '2025-11-01', 'ANDREA BROWN', 'NTWK-SWFT_E7-1-1-1-49730', 'NTWK-SWFT_E7', 'ANDREA BROWN', '1-1-1-49730', '23.2', '20.76', '0.00', '24.00', '32.00', 7, 7, 0, 0, 0, 0, 0, '-26.80', '-40.00', 398783585, '2025-11-01 12:01:17'),
(357, '2025-11-01', 'FRANSISCO FLORES', 'NTWK-WEFD2_E7-1-1-3-1070', 'NTWK-WEFD2_E7', 'FRANSISCO FLORES', '1-1-3-1070', '26.0', '42.02', '0.00', '0.00', '32.00', 40, 0, 0, 0, 0, 0, 0, '-22.50', '-30.46', 0, '2025-11-01 12:01:17'),
(358, '2025-11-01', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '27.1', '40.89', '0.00', '0.00', '32.00', 18, 0, 18, 0, 0, 0, 0, '-30.00', '-26.00', 0, '2025-11-01 12:01:17'),
(359, '2025-11-01', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '40.5', '27.55', '0.00', '0.00', '32.00', 11, 0, 11, 0, 0, 0, 0, '-30.00', '-25.00', 4, '2025-11-01 12:01:17'),
(360, '2025-11-01', 'KIMBERLY WOODALL', 'NTWK-WEFD3_E7-1-1-2-68812', 'NTWK-WEFD3_E7', 'KIMBERLY WOODALL', '1-1-2-68812', '40.7', '3.28', '0.00', '24.00', '32.00', 1, 1, 0, 0, 0, 0, 0, '-21.20', '-30.00', 623376, '2025-11-01 12:01:17'),
(361, '2025-11-02', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '0.0', '69.13', '0.00', '24.00', '32.00', 47, 0, 0, 0, 47, 0, 0, '-33.00', '-29.00', 97578, '2025-11-02 13:01:16'),
(362, '2025-11-02', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '7.8', '68.19', '0.00', '24.00', '0.00', 35, 35, 0, 0, 0, 0, 0, '-22.30', '-20.00', 48251452, '2025-11-02 13:01:16'),
(363, '2025-11-02', 'ERICA PETTY', 'NTWK-WEFD_E7-1-2-7-107326', 'NTWK-WEFD_E7', 'ERICA PETTY', '1-2-7-107326', '20.6', '55.35', '0.00', '24.00', '0.00', 32, 0, 0, 0, 32, 0, 0, '-21.70', '-23.66', 160302, '2025-11-02 13:01:16'),
(364, '2025-11-02', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '22.2', '45.81', '0.00', '0.00', '32.00', 21, 0, 21, 0, 0, 0, 0, '-30.50', '-26.00', 0, '2025-11-02 13:01:16'),
(365, '2025-11-02', 'CHARLES WOODHULL', 'NTWK-SWFT3_E7-1-1-2-45042', 'NTWK-SWFT3_E7', 'CHARLES WOODHULL', '1-1-2-45042', '22.2', '45.81', '0.00', '0.00', '32.00', 21, 0, 21, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-11-02 13:01:16'),
(366, '2025-11-02', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'NTWK-WLMS2_E7', 'GERALD AMSTUTZ', '1-1-3-285', '26.5', '73.50', '0.00', '0.00', '0.00', 62, 0, 0, 0, 0, 54, 0, '-16.00', NULL, 0, '2025-11-02 13:01:16'),
(367, '2025-11-02', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '38.4', '29.63', '0.00', '0.00', '32.00', 12, 0, 12, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-11-02 13:01:16'),
(368, '2025-11-02', 'JOHN A. LEE', 'NTWK-STMP_E7-1-1-2-96044', 'NTWK-STMP_E7', 'JOHN A. LEE', '1-1-2-96044', '38.4', '29.63', '0.00', '0.00', '32.00', 12, 0, 12, 0, 0, 0, 0, '-30.00', '-21.00', 0, '2025-11-02 13:01:16'),
(369, '2025-11-02', 'GREG PURCELL', 'NTWK-WEFD2_E7-1-1-4-82853', 'NTWK-WEFD2_E7', 'GREG PURCELL', '1-1-4-82853', '39.2', '7.35', '0.00', '24.00', '29.44', 3, 0, 0, 3, 0, 0, 0, '-29.20', '-28.00', 18999999, '2025-11-02 13:01:16'),
(370, '2025-11-02', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '44.0', '0.00', '0.00', '24.00', '32.00', 0, 0, 0, 0, 0, 0, 0, '-22.90', '-35.00', 87887718, '2025-11-02 13:01:17'),
(371, '2025-11-03', 'ANITA CORWIN', 'NTWK-ODON_E7-1-1-4-50086', 'NTWK-ODON_E7', 'ANITA CORWIN', '1-1-4-50086', '0.0', '80.10', '0.00', '24.00', '0.00', 50, 50, 0, 0, 0, 0, 0, '-22.30', '-20.00', 42524246, '2025-11-03 13:01:23'),
(372, '2025-11-03', 'GREG PURCELL', 'NTWK-WEFD2_E7-1-1-4-82853', 'NTWK-WEFD2_E7', 'GREG PURCELL', '1-1-4-82853', '12.6', '33.99', '0.00', '24.00', '29.44', 15, 6, 0, 8, 0, 0, 0, '-29.20', '-28.00', 54275300, '2025-11-03 13:01:23'),
(373, '2025-11-03', 'KEVIN BAXTER', 'NTWK-GRAM-1-2-8-20', 'NTWK-GRAM', '', '1-2-8-20', '14.1', '29.90', '0.00', '24.00', '32.00', 14, 0, 0, 0, 14, 0, 0, '-33.00', '-29.00', 205451, '2025-11-03 13:01:23'),
(374, '2025-11-03', 'HEATHER NICHOLSON', 'NTWK-LOGT2_E7-1-1-1-87883', 'NTWK-LOGT2_E7', 'HEATHER NICHOLSON', '1-1-1-87883', '23.8', '44.22', '0.00', '0.00', '32.00', 20, 0, 20, 0, 0, 0, 0, '-30.50', '-26.00', 0, '2025-11-03 13:01:23'),
(375, '2025-11-03', 'JOHN A. LEE', 'NTWK-STMP_E7-1-1-2-96044', 'NTWK-STMP_E7', 'JOHN A. LEE', '1-1-2-96044', '28.8', '39.15', '0.00', '0.00', '32.00', 17, 0, 17, 0, 0, 0, 0, '-30.00', '-21.00', 0, '2025-11-03 13:01:23'),
(376, '2025-11-03', 'CHARLES WOODHULL', 'NTWK-SWFT3_E7-1-1-2-45042', 'NTWK-SWFT3_E7', 'CHARLES WOODHULL', '1-1-2-45042', '28.8', '39.15', '0.00', '0.00', '32.00', 17, 0, 17, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-11-03 13:01:23'),
(377, '2025-11-03', 'ERICA PETTY', 'NTWK-WEFD_E7-1-2-7-107326', 'NTWK-WEFD_E7', 'ERICA PETTY', '1-2-7-107326', '34.6', '48.15', '0.00', '17.25', '0.00', 26, 0, 0, 0, 26, 0, 0, '-21.70', '-23.66', 73908, '2025-11-03 13:01:23'),
(378, '2025-11-03', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'NTWK-WEFD2_E7', 'JAMES E NICHOLS', '1-2-1-52216', '37.0', '6.99', '0.00', '24.00', '32.00', 3, 1, 0, 1, 0, 0, 0, '-22.90', '-35.00', 109612256, '2025-11-03 13:01:23'),
(379, '2025-11-03', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'NTWK-BCKN1_E7', 'TERRY DAVIS', '1-2-2-72233', '38.4', '29.63', '0.00', '0.00', '32.00', 12, 0, 12, 0, 0, 0, 0, '-30.00', '-24.00', 0, '2025-11-03 13:01:23'),
(380, '2025-11-03', 'KIMBERLY WOODALL', 'NTWK-WEFD3_E7-1-1-2-68812', 'NTWK-WEFD3_E7', 'KIMBERLY WOODALL', '1-1-2-68812', '40.2', '3.84', '0.00', '24.00', '32.00', 2, 0, 0, 1, 0, 0, 0, '-21.60', '-30.00', 50584800, '2025-11-03 13:01:23');

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

--
-- Table structure for table `standing_alarms`
--

CREATE TABLE `standing_alarms` (
  `id` bigint UNSIGNED NOT NULL,
  `network` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alarm_type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `occur_time` datetime NOT NULL,
  `subscr_id` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `node_straid` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pon_descr` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serno` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mfg_serno` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inserted_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `ivue_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `standing_alarms`
--

INSERT INTO `standing_alarms` (`id`, `network`, `alarm_type`, `occur_time`, `subscr_id`, `node_straid`, `pon_descr`, `model`, `serno`, `mfg_serno`, `inserted_at`, `updated_at`, `latitude`, `longitude`, `ivue_address`) VALUES
(1325387, 'NTWK-NLGT1_E7', 'ont-ds-sdber', '2025-11-01 11:18:13', 'MELODY PADGETT', 'NTWK-NLGT1_E7-1-2-5-53901', 'TRCK#1', '803G', 'b4e3d7', '422106170040', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6849, -86.9219, 'LOGT 283 BYRON ST'),
(1325388, 'NTWK-NLGT1_E7', 'ont-ds-sdber', '2025-10-15 07:44:54', 'DEBRA BULLOCK', 'NTWK-NLGT1_E7-1-2-2-68884', 'LINE#2', '803G', '10c5f20', '422208033235', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6798, -86.9125, 'LOGT 101 CLARK ST'),
(1325389, 'NTWK-NLGT1_E7', 'ont-ds-sdber', '2025-10-28 22:31:20', 'ALEX MARTIN', 'NTWK-NLGT1_E7-1-2-4-75395', 'QUEN#2', '803G', '12d7b8e', '422305016484', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6809, -86.9118, 'LOGT 202 1/2 N OAK ST'),
(1325390, 'NTWK-ODON_E7', 'ont-ds-sdber', '2025-11-03 20:53:24', 'PARKVIEW VLG (728 S WEST ST)', 'NTWK-ODON_E7-1-2-4-71109', 'ODON#3', '803G', 'bab515', '422108141594', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.834, -86.9992, 'ODON 728 S WEST ST'),
(1325391, 'NTWK-ODON_E7', 'ont-dying-gasp', '2025-11-03 15:44:59', 'RODNEY ADKINSON', 'NTWK-ODON_E7-1-2-6-74055', 'RACE #4', '803G', '12d4fc8', '422305005278', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8428, -86.9848, 'ODON 403 E MAIN ST'),
(1325392, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-11-03 07:30:48', 'LEAH LAYTON', 'NTWK-ODON2_E7-1-1-3-111', 'WEST BURNS #1 - x64', 'GP1100G', '1a3365b', '542410063533', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8248, -86.9219, 'ODON 11357 N US HIGHWAY 231'),
(1325393, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-10-20 10:19:37', 'TINA MCCULLOUGH', 'NTWK-ODON2_E7-1-1-3-150', 'WEST BURNS #1 - x64', '803G', 'b65ea9', '422107057713', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6598, -87.175, 'WASH 8 E HEFRON ST'),
(1325394, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-10-17 11:30:07', 'JOE STOLL', 'NTWK-ODON2_E7-1-1-1-555', 'RAGLVL #1 x64', '803G', '5a3290', '261812054135', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7957, -86.9674, 'ODON 9419 N 1025 E'),
(1325395, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-10-10 23:44:52', 'GEORGE ALLEN', 'NTWK-ODON2_E7-1-1-3-50810', 'WEST BURNS #1 - x64', '803G', 'b6648d', '422107059221', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8305, -86.9393, 'ODON 12121 E 1200 N'),
(1325396, 'NTWK-ODON2_E7', 'ont-sw-mismatch', '2025-10-10 23:47:53', 'MEGAN KETTINGER', 'NTWK-ODON2_E7-1-1-2-57088', 'FRLN #1 - x64', '803G', 'ca5edf', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8462, -86.9909, 'ODON 302 N SPRING ST'),
(1325397, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-10-10 23:48:42', 'WILLIAM ARNOLD', 'NTWK-ODON2_E7-1-1-3-102610', 'WEST BURNS #1 - x64', '803G', 'eed2e2', '262409047995', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.832, -86.9252, 'ODON 12864 E 1200 N'),
(1325398, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-10-25 19:17:32', 'JOY SPEER', 'NTWK-ODON2_E7-1-1-3-104438', 'WEST BURNS #1 - x64', '803G', '5a3293', '261812054138', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8304, -86.9407, 'ODON 11912 N 1200 E'),
(1325399, 'NTWK-ODON2_E7', 'low-rx-opt-pwr-ne', '2025-10-10 23:44:12', 'NICK RABER', 'NTWK-ODON2_E7-1-1-3-107058', 'WEST BURNS #1 - x64', 'GP1100G', '1b4c60e', '542501037364', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8318, -86.9529, 'ODON 11382 E 1200 N'),
(1325400, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-07-27 16:49:17', 'Alvin W Chestnut', 'NTWK-PLVL2_E7-1-1-3-22', 'PLVL#1', '711GE', '7c4451', '481912041565', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325401, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-10-01 15:19:51', 'Allison Kreiger', 'NTWK-PLVL2_E7-1-1-3-81', 'PLVL#1', '844G-1', '4bbb34', '261804043504', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.794, -87.1454, 'WASH 9338 N 100 E'),
(1325402, 'NTWK-PLVL2_E7', 'ont-missing', '2025-10-29 14:53:11', 'HILDA L ENGLEMAN', 'NTWK-PLVL2_E7-1-1-6-150', 'PLVL#3', NULL, '57c374', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325403, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-11-03 19:51:06', 'Bonnie Pierce', 'NTWK-PLVL2_E7-1-1-7-164', 'PLVL#4', '844G-1', '59cb04', '261811048967', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8072, -87.1481, 'PLVL 521 JOHN ST'),
(1325404, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-10-01 17:45:33', 'Scott Edwards', 'NTWK-PLVL2_E7-1-1-7-176', 'PLVL#4', '844G-1', '59c715', '261811047960', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8073, -87.1519, 'PLVL 257 JOHN ST'),
(1325405, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-10-01 17:45:33', 'Scott Edwards', 'NTWK-PLVL2_E7-1-1-7-176', 'PLVL#4', '844G-1', '59c715', '261811047960', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8073, -87.1519, 'PLVL 257 JOHN ST'),
(1325406, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-10-01 17:48:25', 'Baker Bike Works', 'NTWK-PLVL2_E7-1-1-7-181', 'PLVL#4', '844G-1', '59cb19', '261811048988', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8057, -87.1532, 'PLVL 156 E MAIN ST'),
(1325407, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-10-01 17:48:26', 'Baker Bike Works', 'NTWK-PLVL2_E7-1-1-7-181', 'PLVL#4', '844G-1', '59cb19', '261811048988', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8057, -87.1532, 'PLVL 156 E MAIN ST'),
(1325408, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-10-01 17:49:37', 'Chris A Ritter', 'NTWK-PLVL2_E7-1-2-6-217', 'CNVL-Cornettsvile', '844G-1', '73135b', '421908065926', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7767, -87.1386, 'WASH 8160 N 150 E'),
(1325409, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-10-01 17:49:37', 'Chris A Ritter', 'NTWK-PLVL2_E7-1-2-6-217', 'CNVL-Cornettsvile', '844G-1', '73135b', '421908065926', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7767, -87.1386, 'WASH 8160 N 150 E'),
(1325410, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-11-01 17:24:28', 'Bryan Engleman', 'NTWK-PLVL2_E7-1-2-6-218', 'CNVL-Cornettsvile', '844G-1', '732eda', '421908072965', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7691, -87.1314, 'PLVL 1898 E 750 N'),
(1325411, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-11-01 23:26:51', 'Bryan Engleman', 'NTWK-PLVL2_E7-1-2-6-218', 'CNVL-Cornettsvile', '844G-1', '732eda', '421908072965', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7691, -87.1314, 'PLVL 1898 E 750 N'),
(1325412, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-10-22 03:34:37', 'Cornettsville United', 'NTWK-PLVL2_E7-1-2-6-227', 'CNVL-Cornettsvile', '844G-1', '6fd53a', '421907093703', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7575, -87.1097, 'PLVL 3074 E 700 N'),
(1325413, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-10-22 09:30:02', 'Cornettsville United', 'NTWK-PLVL2_E7-1-2-6-227', 'CNVL-Cornettsvile', '844G-1', '6fd53a', '421907093703', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7575, -87.1097, 'PLVL 3074 E 700 N'),
(1325414, 'NTWK-PLVL2_E7', 'ont-battery-missing', '2025-10-01 16:19:27', 'CENTAUR PETROLEUM OIL', 'NTWK-PLVL2_E7-1-2-3-34229', 'PLVL#6', '844G-1', '49116e', '261711004432', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8089, -87.158, 'PLVL 10358 N 50 E'),
(1325415, 'NTWK-PLVL2_E7', 'ont-battery-failed', '2025-10-01 16:19:27', 'CENTAUR PETROLEUM OIL', 'NTWK-PLVL2_E7-1-2-3-34229', 'PLVL#6', '844G-1', '49116e', '261711004432', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8089, -87.158, 'PLVL 10358 N 50 E'),
(1325416, 'NTWK-PLVL2_E7', 'low-rx-opt-pwr-ne', '2025-09-25 11:46:18', 'BEVERLY KERSTIENS', 'NTWK-PLVL2_E7-1-2-6-107226', 'CNVL-Cornettsvile', 'GP1100G', '1b4d543', '542501041257', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.783, -87.1389, 'WASH 8610 N 150 E'),
(1325417, 'NTWK-PLVL2_E7', 'ont-us-sdber', '2025-10-31 17:29:46', 'STEPHEN SMITH', 'NTWK-PLVL2_E7-1-1-5-110574', 'PLVL#2', 'GP1100G', '1c6bcb4', '542505072409', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325418, 'NTWK-PLVL2_E7', 'sipua-reg-auth', '2025-10-29 15:06:35', NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325419, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-10-14 09:33:07', 'DARREN ROBERTS', 'NTWK-PTWM_E7-1-1-2-32', 'STMP #2', '710GX', '158e0b', '211405209987', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7986, -86.6032, 'WILL 773 SPREEN RD'),
(1325420, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-10-14 09:33:06', 'Rhoda Marie Medley', 'NTWK-PTWM_E7-1-1-2-33', 'STMP #2', '710GX', '15a825', '211406203762', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8033, -86.6041, 'WILL 1733 STUMPHOLE BRIDGE RD'),
(1325421, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-08-17 06:22:29', 'PAM MOODY', 'NTWK-PTWM_E7-1-1-3-42', 'BRVL #1', '710GX', '13afaf', '211403202234', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7698, -86.5966, 'WILL 2 DOGWOOD ACRES LN'),
(1325422, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-10-08 01:32:58', 'Terrence M Mahoney', 'NTWK-PTWM_E7-1-1-4-55', 'BRVL #2', '711GE', '3a6448', '211701042182', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325423, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-09-20 19:35:57', 'STACI RYSER-KIMMEL', 'NTWK-PTWM_E7-1-1-7-61', 'PTWM#1', '844G-1', '6fd503', '421907093648', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7809, -86.6438, 'WILL 1260 PORT WILLIAMS RD'),
(1325424, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-09-20 19:35:57', 'STACI RYSER-KIMMEL', 'NTWK-PTWM_E7-1-1-7-61', 'PTWM#1', '844G-1', '6fd503', '421907093648', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7809, -86.6438, 'WILL 1260 PORT WILLIAMS RD'),
(1325425, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-10-27 23:30:35', 'HEIDI MYERS', 'NTWK-PTWM_E7-1-1-4-64', 'BRVL #2', '710GX', '3459e', '080812762137', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7734, -86.5834, 'WILL 4696 PORT WILLIAMS RD'),
(1325426, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-11-02 11:54:01', 'Keith Henderson', 'NTWK-PTWM_E7-1-1-6-104', 'FRVW', '844G-1', '732fa7', '421908073170', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.762, -86.6434, 'WILL 459 GRAND VIEW RD'),
(1325427, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-11-02 17:43:18', 'Keith Henderson', 'NTWK-PTWM_E7-1-1-6-104', 'FRVW', '844G-1', '732fa7', '421908073170', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.762, -86.6434, 'WILL 459 GRAND VIEW RD'),
(1325428, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-11-02 11:53:56', 'Casey Lemons', 'NTWK-PTWM_E7-1-1-7-111', 'PTWM#1', '844G-1', '732fff', '421908073258', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.766, -86.6142, 'MITC 3544 KINGS RIDGE RD'),
(1325429, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-11-02 17:39:43', 'Casey Lemons', 'NTWK-PTWM_E7-1-1-7-111', 'PTWM#1', '844G-1', '732fff', '421908073258', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.766, -86.6142, 'MITC 3544 KINGS RIDGE RD'),
(1325430, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-09-21 19:00:34', 'Raymond L Lutchka', 'NTWK-PTWM_E7-1-1-7-118', 'PTWM#1', '844G-1', '772001', '421911051425', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325431, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-09-21 19:00:34', 'Raymond L Lutchka', 'NTWK-PTWM_E7-1-1-7-118', 'PTWM#1', '844G-1', '772001', '421911051425', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325432, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-08-17 06:22:30', 'JENNIFER COATS', 'NTWK-PTWM_E7-1-1-3-130', 'BRVL #1', '710GX', '10b129', '211307202811', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7708, -86.6048, 'WILL 18 DOGWOOD ACRES DR'),
(1325433, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-08-17 12:11:36', 'JENNIFER COATS', 'NTWK-PTWM_E7-1-1-3-130', 'BRVL #1', '710GX', '10b129', '211307202811', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7708, -86.6048, 'WILL 18 DOGWOOD ACRES DR'),
(1325434, 'NTWK-PTWM_E7', 'ont-battery-missing', '2025-11-02 11:54:06', 'BEN L ROBBINS', 'NTWK-PTWM_E7-1-1-6-158', 'FRVW', '844G-1', '6fd4c5', '421907093586', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7557, -86.645, 'MITC 1433 KINGS RIDGE RD'),
(1325435, 'NTWK-PTWM_E7', 'ont-battery-failed', '2025-11-02 17:36:22', 'BEN L ROBBINS', 'NTWK-PTWM_E7-1-1-6-158', 'FRVW', '844G-1', '6fd4c5', '421907093586', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7557, -86.645, 'MITC 1433 KINGS RIDGE RD'),
(1325436, 'NTWK-RTFD_E7', 'ont-battery-missing', '2025-11-03 15:05:38', 'CAROL RANEY', 'NTWK-RTFD_E7-1-1-4-73', 'ALVL#1', '710GX', '15943b', '211405203608', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5612, -86.9472, 'LOGT 6554 S DEWEY ST'),
(1325437, 'NTWK-RTFD_E7', 'ont-battery-failed', '2025-11-03 15:05:38', 'CAROL RANEY', 'NTWK-RTFD_E7-1-1-4-73', 'ALVL#1', '710GX', '15943b', '211405203608', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5612, -86.9472, 'LOGT 6554 S DEWEY ST'),
(1325438, 'NTWK-RTFD_E7', 'ont-battery-missing', '2025-10-07 08:19:22', 'Leland Gibson', 'NTWK-RTFD_E7-1-1-6-83', 'HRCK#2', '844G-1', '732fee', '421908073241', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5209, -86.9377, 'LOGT 9286 S 1225 E'),
(1325439, 'NTWK-RTFD_E7', 'ont-battery-failed', '2025-10-07 14:07:15', 'Leland Gibson', 'NTWK-RTFD_E7-1-1-6-83', 'HRCK#2', '844G-1', '732fee', '421908073241', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5209, -86.9377, 'LOGT 9286 S 1225 E'),
(1325440, 'NTWK-SWFT_E7', 'ont-dying-gasp', '2025-10-23 16:14:41', 'Jump-N-Jax', 'NTWK-SWFT_E7-1-1-4-158', 'WALM#1', NULL, '80324b', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325441, 'NTWK-SWFT_E7', 'ont-ds-sdber', '2025-11-03 16:44:21', 'TONY NONTE', 'NTWK-SWFT_E7-1-2-4-54209', '150S#2', '803G', 'b4e498', '422106170233', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325442, 'NTWK-SWFT_E7', 'ont-dying-gasp', '2025-10-18 10:39:22', 'LATOSHA SCALES', 'NTWK-SWFT_E7-1-1-6-58036', 'TOWR Water Tower', NULL, 'ca6196', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6503, -87.182, 'WASH 631 SW 6TH ST'),
(1325443, 'NTWK-SWFT_E7', 'ont-dying-gasp', '2025-10-31 21:38:22', 'SHAWNEE BYERS', 'NTWK-SWFT_E7-1-1-2-68324', '150W #1', NULL, '10c5d35', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6524, -87.1925, 'WASH 13 CINDY KAY DR'),
(1325444, 'NTWK-WEFD2_E7', 'ont-dying-gasp', '2025-11-03 14:25:46', 'JASON KENT', 'NTWK-WEFD2_E7-1-2-7-121', 'MAX#3', '803G', '6154ad', '261901009729', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325445, 'NTWK-WEFD2_E7', 'low-rx-opt-pwr-fe', '2025-11-03 04:49:24', 'FRANSISCO FLORES', 'NTWK-WEFD2_E7-1-1-3-1070', 'MAXW#2', 'GP1100G', '1b4c551', '542501037175', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6635, -87.1887, 'WASH 711 ST GEORGE DR'),
(1325446, 'NTWK-WEFD2_E7', 'ont-ds-sdber', '2025-11-03 14:06:09', 'ROBERT HUGHES', 'NTWK-WEFD2_E7-1-1-6-50498', '100N#3', '803G', 'b65e5a', '422107057634', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6753, -87.1958, 'WASH 1385 N 150 W'),
(1325447, 'NTWK-WEFD2_E7', 'ont-ds-sdber', '2025-11-03 02:50:09', 'JAMES E NICHOLS', 'NTWK-WEFD2_E7-1-2-1-52216', 'VANT#3', '803G', 'c13025', '422110048042', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6574, -87.1837, 'WASH 12 NW 7TH ST'),
(1325448, 'NTWK-WEFD2_E7', 'ont-ds-sdber', '2025-11-03 21:20:35', 'GREG PURCELL', 'NTWK-WEFD2_E7-1-1-4-82853', 'NW16', '803G', '12cfae7', '422304143780', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6596, -87.1911, 'WASH 1212 MCCORMICK AVE'),
(1325449, 'NTWK-SWFT2_E7', 'ont-dying-gasp', '2025-10-29 13:24:49', 'CLR INC', 'NTWK-SWFT2_E7-1-2-2-103994', 'KETZ #4', NULL, '5a3256', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6549, -87.172, 'WASH 200 SE 3RD ST'),
(1325450, 'NTWK-WEFD_E7', 'ont-dying-gasp', '2025-11-02 19:37:34', 'SKIN & BODY EMPIRE MED SPA', 'NTWK-WEFD_E7-1-2-1-35355', 'TRSC#2', '854G-1', '8360e4', '422007031594', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325451, 'NTWK-WEFD_E7', 'ont-dying-gasp', '2025-10-20 13:46:55', 'RICHARD BENNETT', 'NTWK-WEFD_E7-1-2-2-46004', 'Viola #3', NULL, 'a29f05', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6748, -87.1787, 'WASH 1343 N SAINT JOHNS RD'),
(1325452, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-11-03 21:34:22', 'CHARLES WOODHULL', 'NTWK-SWFT3_E7-1-1-2-45042', 'ROUNDBARN #1', '803G', 'a10419', '422101247486', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6405, -87.1558, 'WASH 541 E 100 S'),
(1325453, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-10-14 03:46:08', 'RYAN TOLBERT', 'NTWK-SWFT3_E7-1-1-3-74646', 'ROUND BARN #2', '803G', '12dcd40', '422305037397', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5837, -87.2027, 'WASH 4834 S STATE RD 57'),
(1325454, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-10-29 13:41:40', 'ANNA KLINGLE', 'NTWK-SWFT3_E7-1-1-3-75607', 'ROUND BARN #2', '803G', '12d8954', '422305020009', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5912, -87.1954, 'WASH 1545 W 450 S'),
(1325455, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-10-14 03:43:42', 'MARY ANN PADGETT', 'NTWK-SWFT3_E7-1-1-2-77562', 'ROUNDBARN #1', '803G', '12d4391', '422305002151', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5862, -87.206, 'WASH 4826 S STATE RD 57'),
(1325456, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-10-14 03:45:13', 'CHAD SHAFFER', 'NTWK-SWFT3_E7-1-1-3-77646', 'ROUND BARN #2', '803G', '12d5226', '422305005884', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5982, -87.1965, 'WASH 1604 W 400 S'),
(1325457, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-10-31 15:59:27', 'TERRY WISE', 'NTWK-SWFT3_E7-1-1-5-93303', 'ROUND BARN #3 1x32', '803G', '1348afa', '422308166764', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5977, -87.2233, 'WASH 4021 S 300 W'),
(1325458, 'NTWK-SWFT3_E7', 'low-rx-opt-pwr-ne', '2025-10-19 09:56:35', 'LINDA D WILSON', 'NTWK-SWFT3_E7-1-1-1-99309', 'STATE RD 57', '803G', '136cbd4', '422309111450', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6217, -87.1637, 'WASH 109 E 250 S'),
(1325459, 'NTWK-TRSP_E7', 'ont-battery-missing', '2025-10-19 09:31:53', 'William K Wilson', 'NTWK-TRSP_E7-1-1-4-27', 'LGAP#1', '710GX', '1dfc87', '211506203614', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.746, -86.735, 'SHOA 10114 CLARKS FERRY LN'),
(1325460, 'NTWK-TRSP_E7', 'low-rx-opt-pwr-ne', '2025-09-27 10:05:01', 'James E Norman', 'NTWK-TRSP_E7-1-1-5-73', 'TRSP#1', '844G-1', '6fd575', '421907093762', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325461, 'NTWK-TRSP_E7', 'ont-battery-missing', '2025-10-19 09:33:26', 'DALE DIVINE', 'NTWK-TRSP_E7-1-1-7-92', 'TRSP#2', '844G-1', '6b5820', '421905054687', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7279, -86.7382, 'SHOA 9999 EAGLES NEST LN'),
(1325462, 'NTWK-TRSP_E7', 'ont-battery-failed', '2025-10-19 15:28:09', 'DALE DIVINE', 'NTWK-TRSP_E7-1-1-7-92', 'TRSP#2', '844G-1', '6b5820', '421905054687', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7279, -86.7382, 'SHOA 9999 EAGLES NEST LN'),
(1325463, 'NTWK-TRSP_E7', 'ont-dying-gasp', '2025-11-03 21:32:23', 'KENNETH JONES', 'NTWK-TRSP_E7-1-1-1-58220', 'WRVR', '803G', 'ca6236', '422201148079', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7039, -86.7579, 'SHOA 8982 HOPKINS LN'),
(1325464, 'NTWK-WEFD3_E7', 'low-rx-opt-pwr-ne', '2025-10-23 11:03:22', 'MITCHELL WAGLER', 'NTWK-WEFD3_E7-1-1-4-44510', 'VANT #4', '803G', 'a0a1da', '422101216096', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6575, -87.177, 'WASH 105 W VAN TREES ST'),
(1325465, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-09-22 15:32:38', 'Eleanor Woodruff', 'NTWK-WLMS2_E7-1-2-8-18', 'Cale#2', '710GX', '136cc4', '211401201836', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7921, -86.7457, 'SHOA 9636 CALE RD'),
(1325466, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:56:08', 'Evon Emmick', 'NTWK-WLMS2_E7-1-2-1-30', 'EWMS#2', '844G-1', '59cc8d', '261811049360', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8015, -86.6586, 'WILL 54 LYNCH RD'),
(1325467, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 13:05:38', 'Evon Emmick', 'NTWK-WLMS2_E7-1-2-1-30', 'EWMS#2', '844G-1', '59cc8d', '261811049360', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8015, -86.6586, 'WILL 54 LYNCH RD'),
(1325468, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 06:54:26', 'Jerry George', 'NTWK-WLMS2_E7-1-1-4-46', 'EWMS#1', '710GX', '9f786', '081208700761', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8231, -86.6495, 'WILL 1371 RIDGE RD'),
(1325469, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:54:25', 'Bonnie Lynch', 'NTWK-WLMS2_E7-1-1-4-56', 'EWMS#1', '710GX', '995ca', '081202701092', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8321, -86.6414, 'WILL 2137 RIDGE RD'),
(1325470, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-08-22 03:59:42', 'ERICA HALL', 'NTWK-WLMS2_E7-1-1-8-124', 'SLVS 1X64 SR158', '710GX', 'bb151', '081302700988', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8443, -86.6663, 'WILL 50 JR PHILLIPS DR'),
(1325471, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-11-02 11:52:27', 'WINSTON JOHNSON', 'NTWK-WLMS2_E7-1-1-6-125', 'CHRF Chase Riffle', '710GX', 'b5f5d', '081211702819', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7666, -86.6568, 'WILL 701 SANDY LN'),
(1325472, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-09-26 07:07:13', 'KYRA WRIGHT', 'NTWK-WLMS2_E7-1-2-3-185', 'PDRM #1', '844G-1', '57c1ae', '261808076370', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8416, -86.7173, 'WILL 11209 WHITE HILLS RD'),
(1325473, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-23 23:24:02', 'Shameh Redman Tanksley', 'NTWK-WLMS2_E7-1-2-3-194', 'PDRM #1', '844G-1', '59cb20', '261811048995', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8278, -86.7183, 'WILL 11114 GOLDEN PARK RD'),
(1325474, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-23 23:24:02', 'Shameh Redman Tanksley', 'NTWK-WLMS2_E7-1-2-3-194', 'PDRM #1', '844G-1', '59cb20', '261811048995', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8278, -86.7183, 'WILL 11114 GOLDEN PARK RD'),
(1325475, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-19 03:09:32', 'WILLIAM A PING D', 'NTWK-WLMS2_E7-1-2-3-202', 'PDRM #1', '844G-1', '59d9cb', '261811052750', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8275, -86.7212, 'WILL 22753 VALLEY AVE'),
(1325476, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-19 08:52:50', 'WILLIAM A PING D', 'NTWK-WLMS2_E7-1-2-3-202', 'PDRM #1', '844G-1', '59d9cb', '261811052750', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8275, -86.7212, 'WILL 22753 VALLEY AVE'),
(1325477, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-09-24 19:44:16', 'JUSTIAM WRIGHT', 'NTWK-WLMS2_E7-1-2-3-204', 'PDRM #1', '844G-1', '59d5db', '261811051742', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8325, -86.7175, 'WILL 11216 SWAMP LAKE RD'),
(1325478, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-09-25 01:35:59', 'JUSTIAM WRIGHT', 'NTWK-WLMS2_E7-1-2-3-204', 'PDRM #1', '844G-1', '59d5db', '261811051742', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8325, -86.7175, 'WILL 11216 SWAMP LAKE RD'),
(1325479, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-30 15:16:30', 'GABRIELLE C WRIGHT', 'NTWK-WLMS2_E7-1-2-3-205', 'PDRM #1', '844G-1', '59c6e3', '261811047910', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8285, -86.7193, 'WILL 22785 VALLEY AVE'),
(1325480, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-30 20:46:52', 'GABRIELLE C WRIGHT', 'NTWK-WLMS2_E7-1-2-3-205', 'PDRM #1', '844G-1', '59c6e3', '261811047910', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8285, -86.7193, 'WILL 22785 VALLEY AVE'),
(1325481, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-09-24 19:44:19', 'Hebrew Wright', 'NTWK-WLMS2_E7-1-2-3-206', 'PDRM #1', '844G-1', '59d34f', '261811051090', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8435, -86.7169, 'WILL 11095 WHITE HILLS RD'),
(1325482, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-09-25 01:30:00', 'Hebrew Wright', 'NTWK-WLMS2_E7-1-2-3-206', 'PDRM #1', '844G-1', '59d34f', '261811051090', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8435, -86.7169, 'WILL 11095 WHITE HILLS RD'),
(1325483, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:55:59', 'Lawrence County Auditor', 'NTWK-WLMS2_E7-1-2-5-230', 'EWMS#3', '844G-1', '5d817e', '261901030664', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8048, -86.6493, 'WILL 33 HENDRICKSON LN'),
(1325484, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 12:43:58', 'Lawrence County Auditor', 'NTWK-WLMS2_E7-1-2-5-230', 'EWMS#3', '844G-1', '5d817e', '261901030664', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8048, -86.6493, 'WILL 33 HENDRICKSON LN'),
(1325485, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:55:59', 'Janice Riley', 'NTWK-WLMS2_E7-1-2-5-233', 'EWMS#3', '844G-1', '5d81e4', '261901030766', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8071, -86.6475, 'WILL 247 RIDGE RD'),
(1325486, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 12:56:04', 'Janice Riley', 'NTWK-WLMS2_E7-1-2-5-233', 'EWMS#3', '844G-1', '5d81e4', '261901030766', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8071, -86.6475, 'WILL 247 RIDGE RD'),
(1325487, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-10 13:08:51', 'Sharon Hanners', 'NTWK-WLMS2_E7-1-2-5-234', 'EWMS#3', '844G-1', '5d81ed', '261901030775', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8061, -86.647, 'WILL 166 RIDGE RD'),
(1325488, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-10 13:08:51', 'Sharon Hanners', 'NTWK-WLMS2_E7-1-2-5-234', 'EWMS#3', '844G-1', '5d81ed', '261901030775', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8061, -86.647, 'WILL 166 RIDGE RD'),
(1325489, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-11-02 05:23:00', 'Samuel Barnett', 'NTWK-WLMS2_E7-1-2-5-240', 'EWMS#3', '844G-1', '5d7fac', '261901030198', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8055, -86.6454, 'WILL 140 BOSSERT ST'),
(1325490, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-11-02 10:48:56', 'Samuel Barnett', 'NTWK-WLMS2_E7-1-2-5-240', 'EWMS#3', '844G-1', '5d7fac', '261901030198', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8055, -86.6454, 'WILL 140 BOSSERT ST'),
(1325491, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-09-24 19:44:19', 'Samuel S Fuson', 'NTWK-WLMS2_E7-1-2-4-253', 'PDRM #2', '844G-1', '5d8091', '261901030427', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8277, -86.7177, 'WILL 11128 GOLDEN PARK RD'),
(1325492, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-09-25 01:30:01', 'Samuel S Fuson', 'NTWK-WLMS2_E7-1-2-4-253', 'PDRM #2', '844G-1', '5d8091', '261901030427', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8277, -86.7177, 'WILL 11128 GOLDEN PARK RD'),
(1325493, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:56:04', 'Teresa L Swenson', 'NTWK-WLMS2_E7-1-1-4-257', 'EWMS#1', '844G-1', '5d81cd', '261901030743', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8044, -86.6465, 'WILL 162 HENDRICKSON LN'),
(1325494, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 12:36:14', 'Teresa L Swenson', 'NTWK-WLMS2_E7-1-1-4-257', 'EWMS#1', '844G-1', '5d81cd', '261901030743', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8044, -86.6465, 'WILL 162 HENDRICKSON LN'),
(1325495, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:56:12', 'White River Bait & Tackle', 'NTWK-WLMS2_E7-1-2-1-261', 'EWMS#2', '844G-1', '66d11c', '421901033661', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8048, -86.6449, 'WILL 249 HENDRICKSON LN'),
(1325496, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 12:36:29', 'White River Bait & Tackle', 'NTWK-WLMS2_E7-1-2-1-261', 'EWMS#2', '844G-1', '66d11c', '421901033661', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8048, -86.6449, 'WILL 249 HENDRICKSON LN'),
(1325497, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-29 21:22:19', 'KYLE T GEE', 'NTWK-WLMS2_E7-1-2-1-266', 'EWMS#2', '844G-1', '66d116', '421901033655', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8036, -86.6476, 'WILL 15 KERN ST'),
(1325498, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-30 03:02:40', 'KYLE T GEE', 'NTWK-WLMS2_E7-1-2-1-266', 'EWMS#2', '844G-1', '66d116', '421901033655', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8036, -86.6476, 'WILL 15 KERN ST'),
(1325499, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-06 06:56:08', 'Morris D Gee', 'NTWK-WLMS2_E7-1-2-6-274', 'EWMS#4', '844G-1', '69fd31', '421904024208', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325500, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-06 12:42:04', 'Morris D Gee', 'NTWK-WLMS2_E7-1-2-6-274', 'EWMS#4', '844G-1', '69fd31', '421904024208', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325501, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-11-02 01:28:44', 'GERALD AMSTUTZ', 'NTWK-WLMS2_E7-1-1-3-285', 'ISLN', '710GX', '13afb0', '211403202046', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8055, -86.6762, 'WILL 12221 WILLIAMS RD'),
(1325502, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-30 09:29:56', 'Brenden Wertz', 'NTWK-WLMS2_E7-1-1-6-296', 'CHRF Chase Riffle', '844G-1', '6fc48a', '421907089431', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7734, -86.6703, 'WILL 4030 HURON WILLIAMS RD'),
(1325503, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-30 15:29:05', 'Brenden Wertz', 'NTWK-WLMS2_E7-1-1-6-296', 'CHRF Chase Riffle', '844G-1', '6fc48a', '421907089431', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7734, -86.6703, 'WILL 4030 HURON WILLIAMS RD'),
(1325504, 'NTWK-WLMS2_E7', 'ont-battery-missing', '2025-10-19 03:09:40', 'TAMMY GORE', 'NTWK-WLMS2_E7-1-2-8-301', 'Cale#2', '854G-1', '83603f', '422007031429', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7945, -86.7518, 'SHOA 20472 SIPES RD'),
(1325505, 'NTWK-WLMS2_E7', 'ont-battery-failed', '2025-10-19 09:09:49', 'TAMMY GORE', 'NTWK-WLMS2_E7-1-2-8-301', 'Cale#2', '854G-1', '83603f', '422007031429', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7945, -86.7518, 'SHOA 20472 SIPES RD'),
(1325506, 'NTWK-WLMS2_E7', 'ont-ds-sdber', '2025-11-02 21:09:21', 'BRENNAN FULTS', 'NTWK-WLMS2_E7-1-1-6-50626', 'CHRF Chase Riffle', '803G', 'b65f26', '422107057838', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7761, -86.6654, 'WILL 4352 HURON WILLIAMS RD'),
(1325507, 'NTWK-WLMS2_E7', 'ont-ds-sdber', '2025-11-02 08:16:43', 'JAY HICKMAN', 'NTWK-WLMS2_E7-1-1-8-74686', 'SLVS 1X64 SR158', '803G', '12dcda8', '422305037501', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8577, -86.6611, 'WILL 1199 STATE RD 158'),
(1325508, 'NTWK-WLMS2_E7', 'ont-dying-gasp', '2025-10-29 09:00:40', 'NEIL J SIPES', 'NTWK-WLMS2_E7-1-1-1-102686', 'Cale#1', NULL, 'eed319', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7951, -86.7579, 'SHOA 9017 CALE RD'),
(1325509, 'NTWK-STMP_E7', 'ont-ds-sdber', '2025-10-21 15:33:48', 'BILL BURNS', 'NTWK-STMP_E7-1-1-1-87947', 'TWIN PONDS #1 - 1x64', '803G', '131a7be', '422307104746', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8407, -86.5648, 'WILL 1084 LOUIE SMITH RD'),
(1325510, 'NTWK-STMP_E7', 'ont-missing', '2025-10-22 16:03:27', 'TERRY WADE', 'NTWK-STMP_E7-1-1-1-90200', 'TWIN PONDS #1 - 1x64', NULL, '131a41e', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8236, -86.5632, 'BEDF 629 WEST COXTON RD'),
(1325511, 'NTWK-STMP_E7', 'ont-ds-sdber', '2025-11-02 18:06:06', 'RACHEL WELLS', 'NTWK-STMP_E7-1-1-1-90304', 'TWIN PONDS #1 - 1x64', '803G', '131d6fa', '422307116837', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8258, -86.5946, 'WILL 6739 WILLIAMS RD'),
(1325512, 'NTWK-STMP_E7', 'low-rx-opt-pwr-ne', '2025-07-26 10:22:44', 'MIKE SCHERSCHEL', 'NTWK-STMP_E7-1-1-1-92089', 'TWIN PONDS #1 - 1x64', '803G', '13afccc', '422310204136', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8157, -86.554, 'BEDF 33 COXTON RD'),
(1325513, 'NTWK-STMP_E7', 'low-rx-opt-pwr-ne', '2025-07-23 14:21:43', 'BETTY SMITH', 'NTWK-STMP_E7-1-1-2-92810', 'TWIN PONDS #2 -1x64', '803G', '1345454', '422308152774', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8385, -86.5638, 'BEDF 4713 WILLIAMS RD'),
(1325514, 'NTWK-STMP_E7', 'low-rx-opt-pwr-ne', '2025-10-14 13:48:27', 'ISSAC RAINEY', 'NTWK-STMP_E7-1-1-3-92894', 'BFLY LANE #1 - 1x32', '803G', '137e392', '422310029073', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8472, -86.5771, 'BEDF 90 BUTTERFLY LN'),
(1325515, 'NTWK-STMP_E7', 'low-rx-opt-pwr-ne', '2025-11-03 14:14:58', 'LYNDI DECKER-BAXTER', 'NTWK-STMP_E7-1-1-1-99205', 'TWIN PONDS #1 - 1x64', '803G', '136cb6d', '422309111347', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8054, -86.5926, 'BEDF 167 TWIN PONDS RD'),
(1325516, 'NTWK-STMP_E7', 'low-rx-opt-pwr-ne', '2025-10-22 11:56:38', 'AMY PATRICK', 'NTWK-STMP_E7-1-1-2-103078', 'TWIN PONDS #2 -1x64', 'GP1100G', '1a33661', '542410063539', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.8338, -86.5741, 'BEDF 5245 WILLIAMS RD'),
(1325517, 'NTWK-STMP_E7', 'low-rx-opt-pwr-ne', '2025-08-19 06:06:37', 'NATHAN SLAUGHTER', 'NTWK-STMP_E7-1-1-2-108090', 'TWIN PONDS #2 -1x64', 'GP1100G', '1b4dae7', '542501042701', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325518, 'NTWK-BCKN1_E7', 'low-rx-opt-pwr-ne', '2025-09-26 10:35:06', 'TERRY CARROLL', 'NTWK-BCKN1_E7-1-1-7-52844', 'BRUCEVILLE #2', '803G', 'b30330', '422106046993', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7693, -87.3147, 'BICK 727 W ALTON ST'),
(1325519, 'NTWK-BCKN1_E7', 'low-rx-opt-pwr-ne', '2025-10-13 19:45:22', 'TREVOR TROWBRIDGE', 'NTWK-BCKN1_E7-1-2-2-56248', 'BRUCEVILLE AVE FDH', '803G', 'ca45c8', '422201140801', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325520, 'NTWK-BCKN1_E7', 'low-rx-opt-pwr-ne', '2025-10-06 11:33:44', 'TERRY MILLER', 'NTWK-BCKN1_E7-1-1-6-68808', 'ALEX #1', '803G', '10c5ef0', '422208033187', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7825, -87.3146, 'BICK 7348 N ALEXANDER ST RD'),
(1325521, 'NTWK-BCKN1_E7', 'low-rx-opt-pwr-ne', '2025-11-03 21:36:27', 'TERRY DAVIS', 'NTWK-BCKN1_E7-1-2-2-72233', 'BRUCEVILLE AVE FDH', '803G', 'bab8eb', '422108142576', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7694, -87.3138, 'BICK 719 W ALTON ST'),
(1325522, 'NTWK-BCKN1_E7', 'ont-ds-sdber', '2025-11-03 11:01:08', 'KNOX COUNTY HOUSING AUTHORITY (APT 8A)', 'NTWK-BCKN1_E7-1-2-2-74878', 'BRUCEVILLE AVE FDH', '803G', '12dcec5', '422305037786', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325523, 'NTWK-BCKN1_E7', 'low-rx-opt-pwr-ne', '2025-10-28 17:27:20', 'GABRIELLE LINTON', 'NTWK-BCKN1_E7-1-2-4-92057', 'ALEX #2', '803G', '13afc9d', '422310204089', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325524, 'NTWK-BCKN1_E7', 'ont-missing', '2025-10-23 03:59:14', 'ALEXYS CARIE', 'NTWK-BCKN1_E7-1-2-5-93992', 'SouthPark #2', NULL, '136fb93', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7692, -87.3106, 'BICK 314 S DIVISION ST'),
(1325525, 'NTWK-BCKN1_E7', 'low-rx-opt-pwr-ne', '2025-10-14 13:04:24', 'KYLE DRAKE', 'NTWK-BCKN1_E7-1-2-2-107378', 'BRUCEVILLE AVE FDH', 'GP1100G', '1b4d649', '542501041519', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7682, -87.3185, 'BICK 1 HODGE ST'),
(1325526, 'NTWK-CMBK_E7', 'ont-battery-missing', '2025-09-14 08:25:23', 'Doug Clark', 'NTWK-CMBK_E7-1-1-1-10', 'CMBK', '710GX', '10d904', '211308209203', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.549, -87.0964, 'MTGM 3726 E 725 S'),
(1325527, 'NTWK-CMBK_E7', 'ont-battery-missing', '2025-09-14 08:25:24', 'Steve Veale', 'NTWK-CMBK_E7-1-1-1-11', 'CMBK', '710GX', '15dbbc', '211411206608', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5496, -87.0993, 'MTGM 3556 E 725 S'),
(1325528, 'NTWK-CMBK_E7', 'ont-battery-missing', '2025-09-14 08:25:25', 'VICKIE HUFFINES', 'NTWK-CMBK_E7-1-1-1-12', 'CMBK', '710GX', '15dbb6', '211411205193', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5489, -87.0941, 'MTGM 3796 E 725 S'),
(1325529, 'NTWK-CMBK_E7', 'ont-battery-failed', '2025-06-23 13:57:39', 'Coy Robinson', 'NTWK-CMBK_E7-1-1-2-42', 'WCMB #1', '710GX', 'baf27', '081302700775', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5416, -87.1474, 'WASH 7839 S 100 E'),
(1325530, 'NTWK-CMBK_E7', 'ont-battery-missing', '2025-10-24 10:44:25', 'Dudley May', 'NTWK-CMBK_E7-1-1-3-51', 'WCMB #2', '710GX', '1ded00', '211505200876', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5559, -87.131, 'WASH 1895 E 675 S'),
(1325531, 'NTWK-CMBK_E7', 'ont-battery-missing', '2025-10-24 10:44:24', 'MARK A STANLEY', 'NTWK-CMBK_E7-1-1-3-55', 'WCMB #2', '710GX', '502a3', '081005701383', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5584, -87.1368, 'WASH 1590 E 675 S'),
(1325532, 'NTWK-CMBK_E7', 'ont-battery-missing', '2025-10-16 13:48:21', 'CHARLES DALE ARMES', 'NTWK-CMBK_E7-1-1-4-79', 'HDVL', '710GX', '1d97fb', '211412205617', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5387, -87.0718, 'MTGM 5041 E 800 S'),
(1325533, 'NTWK-CMBK_E7', 'ont-battery-failed', '2025-10-16 19:34:01', 'CHARLES DALE ARMES', 'NTWK-CMBK_E7-1-1-4-79', 'HDVL', '710GX', '1d97fb', '211412205617', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5387, -87.0718, 'MTGM 5041 E 800 S'),
(1325534, 'NTWK-CMBK_E7', 'ont-dying-gasp', '2025-10-31 23:14:40', 'Myrtle Clements', 'NTWK-CMBK_E7-1-1-4-207', 'HDVL', NULL, '957cfc', NULL, '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5377, -87.0744, 'MTGM 4589 E 825 S'),
(1325535, 'NTWK-CMBK_E7', 'ont-us-sdber', '2025-11-03 20:36:56', 'LARRY STAFFORD', 'NTWK-CMBK_E7-1-1-6-107786', 'WCMB #3', 'GP1100G', '1b4d71c', '542501041730', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.5469, -87.1261, 'WASH 7294 S 200 E'),
(1325536, 'NTWK-GRAM2_E7', 'ont-dying-gasp', '2025-11-03 18:40:15', 'LARRY L PEYTON', 'NTWK-GRAM2_E7-1-1-5-237', 'SHPN#1 F 193', '844G-1', '493fad', '261711018131', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.6114, -87.1356, 'WASH 1615 E 300 S'),
(1325537, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-10-24 11:51:32', 'Jeffrey Lake', 'NTWK-DHVL_E7-1-1-4-19', 'BRETT  Brett Road', '844G-1', '896a06', '422008150413', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325538, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-10-24 11:51:32', 'Jeffrey Lake', 'NTWK-DHVL_E7-1-1-4-19', 'BRETT  Brett Road', '844G-1', '896a06', '422008150413', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325539, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-10-19 09:31:50', 'VALERIE WOLFE', 'NTWK-DHVL_E7-1-1-5-28', 'MCBL  McBrides Bluff', '710GX', '13afa8', '211403202280', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7377, -86.7785, 'SHOA 7865 TOMMY GEORGE RD'),
(1325540, 'NTWK-DHVL_E7', 'ont-battery-low', '2025-10-19 09:31:51', 'VALERIE WOLFE', 'NTWK-DHVL_E7-1-1-5-28', 'MCBL  McBrides Bluff', '710GX', '13afa8', '211403202280', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7377, -86.7785, 'SHOA 7865 TOMMY GEORGE RD'),
(1325541, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-09-13 02:32:32', 'Wanda Moody', 'NTWK-DHVL_E7-1-1-3-29', 'KLLN Killion Mill Rd', '710GX', '13bd72', '211404201432', '2025-11-04 02:38:41', '2025-11-04 02:38:41', NULL, NULL, NULL),
(1325542, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-10-19 09:32:27', 'JULIA JACKSON', 'NTWK-DHVL_E7-1-1-2-86', 'DVHL #2', '711GE', '3b3c4e', '211706006177', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7206, -86.8123, 'LOGT 15360 DOVER HILL RD'),
(1325543, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-11-01 12:50:25', 'ZACHARY CARWILE', 'NTWK-DHVL_E7-1-1-2-87', 'DVHL #2', '711GE', '458c17', '211709047787', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7209, -86.8088, 'LOGT 15378 DOVER HILL RD'),
(1325544, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-09-27 10:02:52', 'Steve Fahey', 'NTWK-DHVL_E7-1-1-6-98', 'DVHL#3', '844G-1', '69fd12', '421904024177', '2025-11-04 02:38:41', '2025-11-04 02:38:41', 38.7281, -86.8008, 'SHOA 15850 WITT RD'),
(1325545, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-09-27 15:55:47', 'Steve Fahey', 'NTWK-DHVL_E7-1-1-6-98', 'DVHL#3', '844G-1', '69fd12', '421904024177', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7281, -86.8008, 'SHOA 15850 WITT RD'),
(1325546, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-09-27 10:02:52', 'Harold Sipes', 'NTWK-DHVL_E7-1-1-6-105', 'DVHL#3', '844G-1', '6eff2a', '421907038903', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7257, -86.7985, 'SHOA 15689 N STATE RD 450'),
(1325547, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-09-27 16:07:29', 'Harold Sipes', 'NTWK-DHVL_E7-1-1-6-105', 'DVHL#3', '844G-1', '6eff2a', '421907038903', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7257, -86.7985, 'SHOA 15689 N STATE RD 450'),
(1325548, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-09-27 10:02:52', 'Larry Bratton', 'NTWK-DHVL_E7-1-1-6-108', 'DVHL#3', '844G-1', '6ec3ab', '421907023674', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7251, -86.802, 'SHOA 15621 N STATE ROAD 450'),
(1325549, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-09-27 15:53:30', 'Larry Bratton', 'NTWK-DHVL_E7-1-1-6-108', 'DVHL#3', '844G-1', '6ec3ab', '421907023674', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7251, -86.802, 'SHOA 15621 N STATE ROAD 450'),
(1325550, 'NTWK-DHVL_E7', 'ont-battery-missing', '2025-09-27 10:02:52', 'JOY R BOUGH', 'NTWK-DHVL_E7-1-1-6-114', 'DVHL#3', '844G-1', '6ec41b', '421907023786', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7257, -86.7996, 'SHOA 15663 N STATE RD 450'),
(1325551, 'NTWK-DHVL_E7', 'ont-battery-failed', '2025-09-27 15:58:28', 'JOY R BOUGH', 'NTWK-DHVL_E7-1-1-6-114', 'DVHL#3', '844G-1', '6ec41b', '421907023786', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7257, -86.7996, 'SHOA 15663 N STATE RD 450'),
(1325552, 'NTWK-DHVL_E7', 'ont-us-sdber', '2025-10-24 10:31:53', 'TYE GAZARIAN', 'NTWK-DHVL_E7-1-1-1-54393', 'DVHL#1 Dover Hill 1', '803G', 'b4e52f', '422106170384', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7159, -86.7979, 'SHOA 15868 IVY LN'),
(1325553, 'NTWK-BCKN2_E7', 'ont-dying-gasp', '2025-10-24 11:21:17', 'ZACKERY CHAMBERS', 'NTWK-BCKN2_E7-1-1-1-6', 'NKCE #4', NULL, '1a33cba', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7777, -87.3072, 'BICK 307 E 8TH ST'),
(1325554, 'NTWK-EPSM_E7', 'ont-battery-missing', '2025-10-01 14:24:32', 'Wagler Custom Homes House', 'NTWK-EPSM_E7-1-1-2-15', 'EPSM', '710GX', '930f5', '081110700054', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7654, -87.0514, 'ODON 6214 E 750 N'),
(1325555, 'NTWK-GFWA2_E7', 'ont-battery-missing', '2025-07-28 22:40:27', 'LONNIE D BARBER', 'NTWK-GFWA2_E7-1-1-1-44', 'GLDL #1', '710GX', '15dfac', '211412200671', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5621, -87.0915, 'MTGM 6426 S 400 E'),
(1325556, 'NTWK-GFWA2_E7', 'ont-battery-missing', '2025-10-23 11:42:34', 'RICHARD ALLEN', 'NTWK-GFWA2_E7-1-2-1-72', 'HRCK', '844G-1', '6fd536', '421907093699', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5449, -86.9462, 'LOGT 7620 S 1175 E'),
(1325557, 'NTWK-GFWA2_E7', 'ont-battery-failed', '2025-10-23 17:28:03', 'RICHARD ALLEN', 'NTWK-GFWA2_E7-1-2-1-72', 'HRCK', '844G-1', '6fd536', '421907093699', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5449, -86.9462, 'LOGT 7620 S 1175 E'),
(1325558, 'NTWK-GFWA2_E7', 'ont-battery-missing', '2025-07-28 22:40:23', 'Public Access Development', 'NTWK-GFWA2_E7-1-1-8-140', 'GFWA', '710GX', '9c71b', '081205700306', '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325559, 'NTWK-GFWA2_E7', 'ont-battery-failed', '2025-07-29 04:31:54', 'Public Access Development', 'NTWK-GFWA2_E7-1-1-8-140', 'GFWA', '710GX', '9c71b', '081205700306', '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325560, 'NTWK-GFWA2_E7', 'ont-battery-failed', '2025-07-28 22:40:19', 'Anthony W Auberry', 'NTWK-GFWA2_E7-1-2-3-158', 'RTWD #1', '710GX', '110530', '211309204468', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5837, -87.1096, 'WASH 4897 S STATE RD 257'),
(1325561, 'NTWK-GFWA2_E7', 'ont-battery-failed', '2025-10-19 02:31:16', 'MARK CLINE', 'NTWK-GFWA2_E7-1-2-3-164', 'RTWD #1', '710GX', '10f197', '211310205375', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5755, -87.1164, 'WASH 2654 E 550 S'),
(1325562, 'NTWK-GFWA2_E7', 'ont-battery-missing', '2025-08-12 16:15:47', 'Phyllis Hart', 'NTWK-GFWA2_E7-1-2-3-178', 'RTWD #1', '710GX', '1371d4', '211311212632', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5738, -87.1144, 'WASH 2739 E 550 S'),
(1325563, 'NTWK-GFWA2_E7', 'ont-missing', '2025-10-20 15:48:02', 'Timothy Stoner', 'NTWK-GFWA2_E7-1-2-3-211', 'RTWD #1', NULL, '265b3b', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325564, 'NTWK-GFWA2_E7', 'ont-missing', '2025-11-03 07:05:51', 'CINDY HOPPER', 'NTWK-GFWA2_E7-1-2-3-107894', 'RTWD #1', 'GP1100G', '1b4d771', '542501041815', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5901, -87.1102, 'WASH 2968 E 450 S'),
(1325565, 'NTWK-LOGT2_E7', 'ont-dying-gasp', '2025-10-25 11:45:26', 'ALICE JONES', 'NTWK-LOGT2_E7-1-1-3-44538', 'PLAR #3', NULL, 'a0a21f', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6548, -87.1636, 'WASH 209 SE 11TH ST'),
(1325566, 'NTWK-GLWD_E7', 'ont-missing', '2025-10-31 14:55:09', 'Patrick Fowler', 'NTWK-GLWD_E7-1-1-3-46', 'GLWD#2', NULL, '75ebb3', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325567, 'NTWK-GLWD_E7', 'ont-us-sdber', '2025-10-30 01:45:19', 'LACEY HIMSEL', 'NTWK-GLWD_E7-1-1-6-5881', 'GOLF Golf Course FDH', 'GP1100G', '1b4c75a', '542501037696', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6645, -87.1678, 'WASH 701 BRETT CABEL RD'),
(1325568, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-09-27 10:03:40', 'Hart Family Chiropractic', 'NTWK-MTGM2_E7-1-1-2-8', 'CNLB#1 fibers 1-72', '844G-1', '79e3d1', '421912031298', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6698, -86.9981, 'CNBG 201 N MAIN ST'),
(1325569, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-09-27 15:57:39', 'Hart Family Chiropractic', 'NTWK-MTGM2_E7-1-1-2-8', 'CNLB#1 fibers 1-72', '844G-1', '79e3d1', '421912031298', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6698, -86.9981, 'CNBG 201 N MAIN ST'),
(1325570, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-24 08:46:12', 'KEVIN DOSCHER', 'NTWK-MTGM2_E7-1-1-2-9', 'CNLB#1 fibers 1-72', '710GX', '1dcec6', '211503202590', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6606, -86.9982, 'CNBG 314 N 900 E'),
(1325571, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-09-27 10:02:02', 'Michael Wagler', 'NTWK-MTGM2_E7-1-1-2-10', 'CNLB#1 fibers 1-72', '710GX', 'b8973', '081301700704', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6594, -86.9977, 'CNBG 9045 E 25 N'),
(1325572, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-15 17:38:50', 'JEREMY R LASHLEY', 'NTWK-MTGM2_E7-1-1-4-20', 'SPMS#1', '711GE', '3ac7bb', '211703021557', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6212, -87.0741, 'MTGM 2327 S 500 E'),
(1325573, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-09-27 10:02:02', 'John Wuepper', 'NTWK-MTGM2_E7-1-1-4-24', 'SPMS#1', '710GX', '1daa3a', '211501201927', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6119, -87.0736, 'MTGM 2975 S 500 E'),
(1325574, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-11-03 03:33:13', 'Tim Showalter', 'NTWK-MTGM2_E7-1-1-5-35', 'TRCT#1 x32', '710GX', '930c7', '081110700407', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6583, -87.0513, 'MTGM 6221 E TERRACE COURT DR'),
(1325575, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-06 08:47:31', 'JOSH HUFF', 'NTWK-MTGM2_E7-1-1-6-40', 'OKVW#1', '710GX', 'b4173', '081211700434', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6599, -87.0648, 'MTGM 5509 E FAIRWAY DR'),
(1325576, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-07-16 13:02:31', 'Adam Cornelius', 'NTWK-MTGM2_E7-1-1-6-86', 'OKVW#1', '710GX', 'b5f4c', '081211702219', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6556, -87.0641, 'MTGM 5440 E US HIGHWAY 50'),
(1325577, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-08-16 14:59:51', 'Delmar L Graber', 'NTWK-MTGM2_E7-1-1-7-102', 'GDNA #1', '710GX', '96429', '081112701063', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6565, -87.0846, 'WASH 4357 GARDENIA LN'),
(1325578, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-07-09 09:59:49', 'Shawn L Stoll', 'NTWK-MTGM2_E7-1-1-7-113', 'GDNA #1', '710GX', 'a1b99', '081209700967', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6585, -87.0847, 'WASH 4374 HACIENDA DR'),
(1325579, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-19 08:41:30', 'Robert Grannan', 'NTWK-MTGM2_E7-1-2-7-123', 'MILL#1', '844G-1', '59cb0d', '261811048976', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6685, -87.0481, 'MTGM 610 N 3RD ST'),
(1325580, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-19 14:24:29', 'Robert Grannan', 'NTWK-MTGM2_E7-1-2-7-123', 'MILL#1', '844G-1', '59cb0d', '261811048976', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6685, -87.0481, 'MTGM 610 N 3RD ST'),
(1325581, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-09-14 16:50:42', 'Thomas Shofner', 'NTWK-MTGM2_E7-1-2-4-203', 'GSTF#2', '710GX', '978fa', '081201700632', '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325582, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-06 21:27:09', 'BG STORAGE', 'NTWK-MTGM2_E7-1-2-5-209', 'TRCT#2 x64', '714GX', '35e97', '080901760165', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6564, -87.0585, 'MTGM 5721 E US HIGHWAY 50'),
(1325583, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-11-01 15:26:15', 'Melanie Graber', 'NTWK-MTGM2_E7-1-2-5-230', 'TRCT#2 x64', '711GE', '383f0b', '211612062260', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6537, -87.0476, 'MTGM 6403 E OLD US HIGHWAY 50'),
(1325584, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-19 08:40:00', 'MARK STRANGE', 'NTWK-MTGM2_E7-1-2-3-241', 'GSTF#1', '710GX', '139dbf', '211402202917', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6706, -87.0468, 'MTGM 1077 N 650 E'),
(1325585, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-29 08:08:36', 'Rose Ann Stoll', 'NTWK-MTGM2_E7-1-2-3-248', 'GSTF#1', '710GX', '13bd71', '211404201253', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.674, -87.0469, 'MTGM 1259 N 650 E'),
(1325586, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-09-14 16:50:43', 'David L Miller', 'NTWK-MTGM2_E7-1-2-3-253', 'GSTF#1', '710GX', '13ad5f', '211403201741', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6774, -87.0461, 'MTGM 1523 N 650 E');
INSERT INTO `standing_alarms` (`id`, `network`, `alarm_type`, `occur_time`, `subscr_id`, `node_straid`, `pon_descr`, `model`, `serno`, `mfg_serno`, `inserted_at`, `updated_at`, `latitude`, `longitude`, `ivue_address`) VALUES
(1325587, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-11-03 20:06:19', 'EARL WAGLER', 'NTWK-MTGM2_E7-1-2-6-277', 'CNNW#1', '710GX', '260aa5', '211509208284', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6701, -87.0053, 'CNBG 8717 E 100 N'),
(1325588, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-09-14 16:51:16', 'Helena Agri 100N', 'NTWK-MTGM2_E7-1-2-4-306', 'GSTF#2', '711GE', '44a0a7', '211709047000', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6699, -87.0711, 'MTGM 5070 E 100 N'),
(1325589, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-19 08:41:44', 'NEW LIFE CHURCH', 'NTWK-MTGM2_E7-1-2-8-359', 'Mill#2', '844G-1', '66d144', '421901033701', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6658, -87.0459, 'MTGM 427 N 1ST ST'),
(1325590, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-19 14:32:56', 'NEW LIFE CHURCH', 'NTWK-MTGM2_E7-1-2-8-359', 'Mill#2', '844G-1', '66d144', '421901033701', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6658, -87.0459, 'MTGM 427 N 1ST ST'),
(1325591, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-19 08:41:42', 'CINDY L COLVIN', 'NTWK-MTGM2_E7-1-2-8-377', 'Mill#2', '844G-1', '66d117', '421901033656', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6648, -87.0458, 'MTGM 240 W CHURCH ST'),
(1325592, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-19 14:40:32', 'CINDY L COLVIN', 'NTWK-MTGM2_E7-1-2-8-377', 'Mill#2', '844G-1', '66d117', '421901033656', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6648, -87.0458, 'MTGM 240 W CHURCH ST'),
(1325593, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-19 08:41:33', 'The Game Plan', 'NTWK-MTGM2_E7-1-2-8-378', 'Mill#2', '844G-1', '66d11d', '421901033662', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6659, -87.044, 'MTGM 450 N MAIN ST'),
(1325594, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-19 14:28:42', 'The Game Plan', 'NTWK-MTGM2_E7-1-2-8-378', 'Mill#2', '844G-1', '66d11d', '421901033662', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6659, -87.044, 'MTGM 450 N MAIN ST'),
(1325595, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-19 08:41:36', 'St Peters Rectory Church', 'NTWK-MTGM2_E7-1-2-8-382', 'Mill#2', '844G-1', '66d12a', '421901033675', '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325596, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-19 14:15:39', 'St Peters Rectory Church', 'NTWK-MTGM2_E7-1-2-8-382', 'Mill#2', '844G-1', '66d12a', '421901033675', '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325597, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-06 21:23:28', 'Michael E James', 'NTWK-MTGM2_E7-1-1-5-392', 'TRCT#1 x32', '711G', '354ae', '080812755716', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6588, -87.0508, 'MTGM 6235 E TERRACE COURT DR'),
(1325598, 'NTWK-MTGM2_E7', 'ont-battery-missing', '2025-10-10 08:36:30', 'Francis E Graber', 'NTWK-MTGM2_E7-1-1-3-436', 'EMTG', '844G-1', '6fd47d', '421907093514', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6428, -87.0364, 'MTGM 787 S 700 E'),
(1325599, 'NTWK-MTGM2_E7', 'ont-battery-failed', '2025-10-10 14:22:35', 'Francis E Graber', 'NTWK-MTGM2_E7-1-1-3-436', 'EMTG', '844G-1', '6fd47d', '421907093514', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6428, -87.0364, 'MTGM 787 S 700 E'),
(1325600, 'NTWK-MTGM2_E7', 'ont-ds-sdber', '2025-11-02 17:35:11', 'SARAH AUSBROOK', 'NTWK-MTGM2_E7-1-1-7-74450', 'GDNA #1', '803G', 'c16189', '422110060686', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6573, -87.0828, 'WASH 4489 GARDENIA LN'),
(1325601, 'NTWK-MTGM2_E7', 'low-rx-opt-pwr-ne', '2025-09-04 19:21:47', 'JOSEPH STUTZMAN', 'NTWK-MTGM2_E7-1-2-2-107298', 'CNRD', 'GP1100G', '1b4d598', '542501041342', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.5994, -86.995, 'CNBG 9246 E 400 S'),
(1325602, 'NTWK-MTGM2_E7', 'ont-dying-gasp', '2025-11-03 09:57:01', 'THERESA O\'BRIAN', 'NTWK-MTGM2_E7-1-2-7-111554', 'MILL#1', 'GP1100G', '1c7e813', '542506047692', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6649, -87.045, 'MTGM 160 W CHURCH ST'),
(1325603, 'NTWK-GLWD2_E7', 'ont-ds-sdber', '2025-11-03 16:44:28', 'KATHY DURNIL', 'NTWK-GLWD2_E7-1-1-6-57296', 'HOSP#3', '803G', 'ca5f13', '422201147276', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6581, -87.1675, 'WASH 108 NE 7TH ST'),
(1325604, 'NTWK-GLWD2_E7', 'ont-dying-gasp', '2025-10-17 08:00:14', 'AUDRA NELSON', 'NTWK-GLWD2_E7-1-1-2-58376', 'HOSP#2', NULL, 'ca73bf', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6589, -87.167, 'WASH 706 E WALNUT ST'),
(1325605, 'NTWK-GLWD2_E7', 'ont-dying-gasp', '2025-10-27 20:18:19', 'KAREN RISK GRABER', 'NTWK-GLWD2_E7-1-2-4-68776', 'HOSP#4', NULL, '10c5ed9', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6576, -87.1638, 'WASH 1007 E VAN TREES ST'),
(1325606, 'NTWK-GLWD2_E7', 'ont-ds-sdber', '2025-11-03 18:03:14', 'SHIRLEY PERKINS', 'NTWK-GLWD2_E7-1-2-7-69152', 'JOHN #5', '803G', '10c602b', '422208033502', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6685, -87.1711, 'WASH 1302 NE 4TH ST'),
(1325607, 'NTWK-GLWD2_E7', 'ont-ds-sdber', '2025-11-03 15:30:26', 'LANA CATT', 'NTWK-GLWD2_E7-1-1-6-90104', 'HOSP#3', '803G', '131a203', '422307103279', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6584, -87.1654, 'WASH 120 NE 9TH ST'),
(1325608, 'NTWK-GRAM3_E7', 'ont-ds-sdber', '2025-10-27 16:15:04', 'DANIELLE GOODWIN', 'NTWK-GRAM3_E7-1-1-1-74726', 'LONGBRANCH#1', '803G', '12dcdd6', '422305037547', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6487, -87.1477, 'WASH 2 LONGBRANCH DR'),
(1325609, 'NTWK-GRAM', 'ont-dying-gasp', '2025-11-03 20:34:07', 'PAUL HYATT', 'NTWK-GRAM-1-1-4-49526', '21st Street FDH#2', NULL, 'b0319f', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6573, -87.1447, 'WASH 1 AMOS DR'),
(1325610, 'NTWK-LOGT_E7', 'ont-ds-sdber', '2025-10-25 20:41:35', 'Cheryl Strange', 'NTWK-LOGT_E7-1-1-8-23', 'Kentucky #2', '803G', 'ad14e8', '422105024881', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6711, -86.9056, 'LOGT 1050 STATE RD 550'),
(1325611, 'NTWK-LOGT_E7', 'ont-sw-mismatch', '2025-10-07 11:16:47', 'MARK BAUER', 'NTWK-LOGT_E7-1-2-3-50630', 'SCENIC #2', '803G', 'b65f27', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6765, -86.9045, 'LOGT 108 CRESTVIEW DR'),
(1325612, 'NTWK-LOGT_E7', 'ont-dying-gasp', '2025-11-03 13:32:41', 'BENJAMIN HACKER', 'NTWK-LOGT_E7-1-2-1-108795', 'KENTUCKY #3', 'GP1100G', '1b9ca7a', '542504010775', '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325613, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-10-26 16:17:38', 'Tara S Delaney', 'NTWK-MTGM3_E7-1-1-4-15', 'MTGM#2', '844G-1', '5d8151', '261901030619', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6622, -87.0467, 'MTGM 125 W OAK ST'),
(1325614, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-10-26 22:14:07', 'Tara S Delaney', 'NTWK-MTGM3_E7-1-1-4-15', 'MTGM#2', '844G-1', '5d8151', '261901030619', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6622, -87.0467, 'MTGM 125 W OAK ST'),
(1325615, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-10-19 08:41:55', 'Kelly Grannan', 'NTWK-MTGM3_E7-1-1-4-22', 'MTGM#2', '844G-1', '59c6f1', '261811047924', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6619, -87.0473, 'MTGM 176 W OAK ST'),
(1325616, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-10-19 14:21:42', 'Kelly Grannan', 'NTWK-MTGM3_E7-1-1-4-22', 'MTGM#2', '844G-1', '59c6f1', '261811047924', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6619, -87.0473, 'MTGM 176 W OAK ST'),
(1325617, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-10-19 08:41:56', 'Brookelyn Graber', 'NTWK-MTGM3_E7-1-1-4-26', 'MTGM#2', '844G-1', '59cbf2', '261811049205', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6605, -87.0461, 'MTGM 279 S 1ST ST'),
(1325618, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-10-19 14:41:34', 'Brookelyn Graber', 'NTWK-MTGM3_E7-1-1-4-26', 'MTGM#2', '844G-1', '59cbf2', '261811049205', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6605, -87.0461, 'MTGM 279 S 1ST ST'),
(1325619, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-09-27 10:03:35', 'JERRELL CLARK', 'NTWK-MTGM3_E7-1-1-3-77', 'MTGM#1', '844G-1', '69fd45', '421904024228', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6632, -87.0306, 'MTGM 7390 E US HIGHWAY 50'),
(1325620, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-09-27 15:45:41', 'JERRELL CLARK', 'NTWK-MTGM3_E7-1-1-3-77', 'MTGM#1', '844G-1', '69fd45', '421904024228', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6632, -87.0306, 'MTGM 7390 E US HIGHWAY 50'),
(1325621, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-10-29 19:24:16', 'S & G Auto Truck Service', 'NTWK-MTGM3_E7-1-1-3-102', 'MTGM#1', '844G-1', '6b583e', '421905054717', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6639, -87.046, 'MTGM 262 W RUDOLPH ST'),
(1325622, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-10-30 01:29:07', 'S & G Auto Truck Service', 'NTWK-MTGM3_E7-1-1-3-102', 'MTGM#1', '844G-1', '6b583e', '421905054717', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6639, -87.046, 'MTGM 262 W RUDOLPH ST'),
(1325623, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-10-23 18:56:01', 'AUSTIN GRANT BRADLEY', 'NTWK-MTGM3_E7-1-2-4-182', 'EMTG #2', '844G-1', '6fd561', '421907093742', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6486, -87.0202, 'MTGM 7902 E OLD US HIGHWAY 50'),
(1325624, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-10-23 18:56:01', 'AUSTIN GRANT BRADLEY', 'NTWK-MTGM3_E7-1-2-4-182', 'EMTG #2', '844G-1', '6fd561', '421907093742', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6486, -87.0202, 'MTGM 7902 E OLD US HIGHWAY 50'),
(1325625, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-09-27 10:03:47', 'Jim Stoll', 'NTWK-MTGM3_E7-1-2-4-183', 'EMTG #2', '844G-1', '6fd554', '421907093729', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6493, -87.0224, 'MTGM 7814 E OLD US HIGHWAY 50'),
(1325626, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-09-27 16:02:20', 'Jim Stoll', 'NTWK-MTGM3_E7-1-2-4-183', 'EMTG #2', '844G-1', '6fd554', '421907093729', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6493, -87.0224, 'MTGM 7814 E OLD US HIGHWAY 50'),
(1325627, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-09-27 10:03:35', 'William Petty', 'NTWK-MTGM3_E7-1-1-1-204', 'SPMS #2', '844G-1', '79e3c7', '421912031288', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6054, -87.0446, 'MTGM 3450 S 650 E'),
(1325628, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-09-27 15:31:54', 'William Petty', 'NTWK-MTGM3_E7-1-1-1-204', 'SPMS #2', '844G-1', '79e3c7', '421912031288', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.6054, -87.0446, 'MTGM 3450 S 650 E'),
(1325629, 'NTWK-MTGM3_E7', 'ont-battery-missing', '2025-09-27 10:03:42', 'Toy\'s Garage LLC', 'NTWK-MTGM3_E7-1-1-1-208', 'SPMS #2', '844G-1', '7a3ff7', '422001019400', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.604, -87.0449, 'MTGM 3528 S 650 E'),
(1325630, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-09-27 15:45:14', 'Toy\'s Garage LLC', 'NTWK-MTGM3_E7-1-1-1-208', 'SPMS #2', '844G-1', '7a3ff7', '422001019400', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.604, -87.0449, 'MTGM 3528 S 650 E'),
(1325631, 'NTWK-MTGM3_E7', 'ont-dying-gasp', '2025-10-16 09:38:32', 'Bryant Niehoff', 'NTWK-MTGM3_E7-1-1-7-217', 'Mill#3', NULL, '7dd549', NULL, '2025-11-04 02:38:42', '2025-11-04 02:38:42', NULL, NULL, NULL),
(1325632, 'NTWK-MTGM3_E7', 'ont-battery-failed', '2025-08-23 20:03:42', 'K & K Industries', 'NTWK-MTGM3_E7-1-1-6-50323', 'MTGM#4', '766GX', 'bb7aa', '081303940389', '2025-11-04 02:38:42', '2025-11-04 02:38:42', 38.7359, -87.0071, 'MTGM 8518 E 550 N'),
(1325633, 'Lab-E7-2', 'ont-missing', '2025-09-30 15:13:01', 'XGS Test', 'Lab-E7-2-1-1-xp1-5', NULL, 'XGIA', '18DC3EF', '18DC3EF', '2025-11-04 02:38:43', '2025-11-04 02:38:43', NULL, NULL, NULL),
(1325634, 'Lab-E7-2_2', 'ont-missing', '2025-10-19 08:45:08', 'SMX LAB ONT', 'Lab-E7-2_2-1-1-gp1-43', NULL, 'GP1100G', '1A59B46', '1A59B46', '2025-11-04 02:38:43', '2025-11-04 02:38:43', 38.6664, -87.1662, 'WASH 19 CORONADO DR'),
(1325635, 'AX-CRAN1', 'ont-dying-gasp', '2025-08-20 12:52:45', 'CRANE ONT#8 (Brian Layden)', 'AX-CRAN1', NULL, NULL, 'EED1DD', 'EED1DD', '2025-11-04 02:38:43', '2025-11-04 02:38:43', 38.8956, -86.9006, 'CRAN 131 MCVAY CT'),
(1325636, 'AX-CRAN1', 'ont-missing', '2025-09-10 17:44:09', 'CRANE ONT#6 (CJ Parcels)', 'AX-CRAN1', NULL, NULL, 'EED1D3', 'EED1D3', '2025-11-04 02:38:43', '2025-11-04 02:38:43', NULL, NULL, NULL),
(1325637, 'AX-CRAN1', 'low-rx-opt-pwr-ne', '2025-10-28 21:47:00', 'CRANE ONT#42 (Cameron Brown)', 'AX-CRAN1-1-1-gp2-84', NULL, '803G', 'EED2E3', 'EED2E3', '2025-11-04 02:38:43', '2025-11-04 02:38:43', 38.8965, -86.8998, 'CRAN 116 LARRIMER ST'),
(1325638, 'AX-CRAN1', 'ont-dying-gasp', '2025-08-26 12:05:22', 'CRANE ONT#24 (Carolyn Lewis-Shake)', 'AX-CRAN1', NULL, NULL, '1C71C28', '1C71C28', '2025-11-04 02:38:43', '2025-11-04 02:38:43', NULL, NULL, NULL),
(1325639, 'AX-NLGT3', 'ont-missing', '2025-09-26 20:41:14', 'John Vaupel', 'AX-NLGT3-1-1-xp5-246', NULL, 'GP1101X', '16747C3', '16747C3', '2025-11-04 02:38:43', '2025-11-04 02:38:43', 38.7737, -86.9088, 'LOGT 18916 SAINT JOSEPH RD'),
(1325640, 'AX-NLGT3', 'ont-dying-gasp', '2025-09-03 09:32:08', 'West Boggs Eagle Point LLC', 'AX-NLGT3', NULL, NULL, '1A13CBC', '1A13CBC', '2025-11-04 02:38:43', '2025-11-04 02:38:43', 38.7197, -86.9288, 'LOGT 15043 US HWY 231'),
(1325641, 'AX-NLGT3', 'ont-ds-sdber', '2025-10-30 00:02:54', 'Daniel O\'Connor', 'AX-NLGT3-1-2-xp1-331', NULL, 'GP1101X', '1A1C1E2', '1A1C1E2', '2025-11-04 02:38:43', '2025-11-04 02:38:43', 38.737, -86.9353, 'LOGT 12348 SKI CIR');

--
-- Indexes for table `daily_health_report_archive`
--
ALTER TABLE `daily_health_report_archive`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_run_sub` (`run_date`,`subscriber_id`),
  ADD KEY `idx_subscriber` (`subscriber_id`),
  ADD KEY `idx_run_date` (`run_date`),
  ADD KEY `idx_network_node` (`network_node`),
  ADD KEY `idx_node_straid` (`node_straid`);

--
-- Indexes for table `standing_alarms`
--
ALTER TABLE `standing_alarms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_network` (`network`),
  ADD KEY `idx_alarm_type` (`alarm_type`),
  ADD KEY `idx_occur_time` (`occur_time`),
  ADD KEY `idx_node_straid` (`node_straid`),
  ADD KEY `idx_subscr_id` (`subscr_id`);

--
-- AUTO_INCREMENT for table `daily_health_report_archive`
--
ALTER TABLE `daily_health_report_archive`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=381;

--
-- AUTO_INCREMENT for table `standing_alarms`
--
ALTER TABLE `standing_alarms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1325642;
COMMIT;

