PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE users ( id INTEGER NOT NULL, email VARCHAR, phone VARCHAR, full_name VARCHAR NOT NULL, hashed_password VARCHAR, oauth_provider VARCHAR, oauth_id VARCHAR, push_token VARCHAR, is_active BOOLEAN, created_at DATETIME, role VARCHAR DEFAULT 'CIUDADANO', PRIMARY KEY (id) ); INSERT INTO users VALUES(1,'demo@celaya.gob.mx','461-123-4567','María González Demo','$2b$12$WNs4MrlgnztneTIdIyrroee7vYwQH2CUeqazwOyEzuDbV1IfhG9uO',NULL,NULL,NULL,1,'2026-05-23 13:42:58.402887','CIUDADANO'); INSERT INTO users VALUES(2,'empleado@celaya.gob.mx','461-200-1000','Carlos Hernández (Empleado)','$2b$12$ltUN3dUr0NcDWf0DGUbSYec8Kz7wCmz0np.nCaEDMLd3YtBHWByXO',NULL,NULL,NULL,1,'2026-05-23 13:42:58.607717','EMPLEADO'); INSERT INTO users VALUES(3,'admin@celaya.gob.mx','461-100-0001','Lic. Patricia Ramírez (Admin)','$2b$12$luwtXmSTe6t1v.SZ8un6nut5QgAoIX.XuFlC0C84kkHfvU2jWNXwC',NULL,NULL,NULL,1,'2026-05-23 13:42:58.813269','ADMIN'); INSERT INTO users VALUES(4,'guadalupe.jimenez100@celaya.gob.mx','461-328-3286','Guadalupe Díaz Jiménez','$2b$12$iHbFu04i8kXCeIFLfHObLeHtLR2WO8qQIRDZhZmI0E6wAvcfNAHxe',NULL,NULL,NULL,1,'2026-05-23 13:42:59.021971','EMPLEADO'); INSERT INTO users VALUES(5,'magdalena.dominguez101@celaya.gob.mx','461-532-1520','Magdalena Rodríguez Domínguez','$2b$12$n89JVIPAUmPyeRYn987WF.mqWN58pVTyCrng5FtSNunnJ899aPI32',NULL,NULL,NULL,1,'2026-05-23 13:42:59.230758','EMPLEADO'); INSERT INTO users VALUES(6,'mario.solis102@celaya.gob.mx','461-127-4257','Mario Mendez Solís','$2b$12$AeycFZfKBmZOFN57nAIU7OQ2Zm9ZSEgrDM18M1O/luhVq3y6TM9uS',NULL,NULL,NULL,1,'2026-05-23 13:42:59.558149','EMPLEADO'); INSERT INTO users VALUES(7,'ruben.diaz103@celaya.gob.mx','461-928-1106','Rubén Domínguez Díaz','$2b$12$HG1e0QM9A5aoWzQQ9j951O7rPSX2zP3eIyKwLVkuSRaRqujdi/ucq',NULL,NULL,NULL,1,'2026-05-23 13:42:59.809439','EMPLEADO'); INSERT INTO users VALUES(8,'karla.cruz104@celaya.gob.mx','461-320-6514','Karla Díaz Cruz','$2b$12$UzqgimLqkzBQouK.xEkGx.zwzeC1XUXLXixA93sOWZ/gRYYumRO6W',NULL,NULL,NULL,1,'2026-05-23 13:43:00.019084','EMPLEADO'); INSERT INTO users VALUES(9,'jorge.romero105@celaya.gob.mx','461-718-5333','Jorge Romero Romero','$2b$12$CZrKMn948/d3Q5JxBKmz5emJuweUJFAIVJMw4nFNJYnLubkJGrhw2',NULL,NULL,NULL,1,'2026-05-23 13:43:00.228695','EMPLEADO'); INSERT INTO users VALUES(10,'magdalena.herrera106@celaya.gob.mx','461-180-5803','Magdalena Sánchez Herrera','$2b$12$ZQ9CZEBoxA3UJGm7MpAngegLmAxX/jyOl6yEnvIf0mu100pifCLaq',NULL,NULL,NULL,1,'2026-05-23 13:43:00.438473','EMPLEADO'); INSERT INTO users VALUES(11,'carmen.reyes107@celaya.gob.mx','461-891-5741','Carmen González Reyes','$2b$12$W6Bb/I6ttEwbDNLlA.kxo.LwjZIVo8XnH4dsVsyhK4tzrKLbe0G9W',NULL,NULL,NULL,1,'2026-05-23 13:43:00.645687','EMPLEADO'); INSERT INTO users VALUES(12,'laura.diaz108@celaya.gob.mx','461-564-6977','Laura Herrera Díaz','$2b$12$j1Xstv1L2iIYj.ydrB7diuucHx8An/x2Oo0v.OKN4OUO8sxh1.UEm',NULL,NULL,NULL,1,'2026-05-23 13:43:00.853603','EMPLEADO'); INSERT INTO users VALUES(13,'fernando.lopez109@celaya.gob.mx','461-723-3803','Fernando Díaz López','$2b$12$5NtWQ2YDVKOR9q.pWAF5iOtZ6q20aXtZhbJTJtaZ/hzKVdAq/CRqa',NULL,NULL,NULL,1,'2026-05-23 13:43:01.059922','EMPLEADO'); INSERT INTO users VALUES(14,'claudia.herrera110@celaya.gob.mx','461-376-4598','Claudia Chávez Herrera','$2b$12$aUlouCii6d0aeX97NsdYG.pX9U6JeYAMI3jARzFqA5g9OxCeejjJ6',NULL,NULL,NULL,1,'2026-05-23 13:43:01.266362','EMPLEADO'); INSERT INTO users VALUES(15,'patricia.gonzalez111@celaya.gob.mx','461-924-6168','Patricia Reyes González','$2b$12$EM0ahjqxMMuAdXQBcxZkkeXvyW0byn0G3he4gfXHNEFBDLuF9Lrwu',NULL,NULL,NULL,1,'2026-05-23 13:43:01.478591','EMPLEADO'); INSERT INTO users VALUES(16,'fernando.aguilar112@celaya.gob.mx','461-317-9179','Fernando Cervantes Aguilar','$2b$12$QpUueCBpl355O/aR4.M4FOdBCGJjoQ7t8cwoJj1CwPAv8DH1vqfVW',NULL,NULL,NULL,1,'2026-05-23 13:43:01.685649','EMPLEADO'); INSERT INTO users VALUES(17,'valeria.torres200@celaya.gob.mx','461-242-5040','Lic. Valeria Cruz Torres','$2b$12$RpLlPHgZjJj/3WCYhPoVJ.mHmVBgb/DrHZvH2LsgBt58kxIS21gMW',NULL,NULL,NULL,1,'2026-05-23 13:43:01.887234','ADMIN'); INSERT INTO users VALUES(18,'octavio.castillo201@celaya.gob.mx','461-470-4593','Lic. Octavio Domínguez Castillo','$2b$12$4HxjE00iCUwJrtmyrYl.ce9Vfx9Yi7cMXcujlMs8XW5cgnLG07E4i',NULL,NULL,NULL,1,'2026-05-23 13:43:02.089663','ADMIN'); INSERT INTO users VALUES(19,'rosa.sanchez300@celaya.gob.mx','461-256-3621','Rosa Martínez Sánchez','$2b$12$NsMZGLIwMNEZC6qkVmUovOnAXBwoHD8SR0oKndNwur4tQnuVVfjY.',NULL,NULL,NULL,1,'2026-05-23 13:43:02.293834','CIUDADANO'); INSERT INTO users VALUES(20,'lucia.solis301@celaya.gob.mx','461-579-9669','Lucía Herrera Solís','$2b$12$kpT1zAEduK8zytK92vJhQ.uOJZ24xmPHteHf2CoCS3oWD1aLPD1ky',NULL,NULL,NULL,1,'2026-05-23 13:43:02.495722','CIUDADANO'); INSERT INTO users VALUES(21,'maria.salazar302@celaya.gob.mx','461-868-5371','María Sánchez Salazar','$2b$12$dNTP5knIGnuWAoQHeuNZW.ZxkxwJKgbeBrkIwdQveT3y27TslNiJ2',NULL,NULL,NULL,1,'2026-05-23 13:43:02.701307','CIUDADANO'); INSERT INTO users VALUES(22,'octavio.chavez303@celaya.gob.mx','461-103-5315','Octavio Flores Chávez','$2b$12$PjFy7G2st2HGLDNtSvZrN.sRU2EhN6jHIIjIL1053PBTWcBKttoam',NULL,NULL,NULL,1,'2026-05-23 13:43:02.918810','CIUDADANO'); INSERT INTO users VALUES(23,'karina.mendoza304@celaya.gob.mx','461-961-9317','Karina Pérez Mendoza','$2b$12$Zy/dOb8OaSdAeEQ0Qd6gYeJXq1emU08xFRgNBXVzgpk6HW7rpnRDy',NULL,NULL,NULL,1,'2026-05-23 13:43:03.127255','CIUDADANO'); INSERT INTO users VALUES(24,'ricardo.estrada305@celaya.gob.mx','461-100-6310','Ricardo Salazar Estrada','$2b$12$LQ9Rh2fgmfocD5A1Gez48u8qV28A99tB2g7OlxEQs4yBNnisW/HcO',NULL,NULL,NULL,1,'2026-05-23 13:43:03.331186','CIUDADANO'); INSERT INTO users VALUES(25,'hector.jimenez306@celaya.gob.mx','461-159-4946','Héctor Mendoza Jiménez','$2b$12$ULr5TNphfc5lYbjOiQnEBePhdRYldfhKcykNh08vbqwvbYPbyBTwm',NULL,NULL,NULL,1,'2026-05-23 13:43:03.535420','CIUDADANO'); INSERT INTO users VALUES(26,'diego.salazar307@celaya.gob.mx','461-884-3060','Diego López Salazar','$2b$12$GG5l28y74H78eOY1FXAGveQ5aaZDaryDUUErqKF1XrpbUA45Y6yCq',NULL,NULL,NULL,1,'2026-05-23 13:43:03.737620','CIUDADANO'); INSERT INTO users VALUES(27,'claudia.estrada308@celaya.gob.mx','461-993-7932','Claudia Torres Estrada','$2b$12$fAtX4ECdJ9yUnvXitm/TCexOto6jBr6E.aWQGYNfyDRBq6ZnkhAcq',NULL,NULL,NULL,1,'2026-05-23 13:43:03.939422','CIUDADANO'); INSERT INTO users VALUES(28,'cecilia.castillo309@celaya.gob.mx','461-787-7118','Cecilia Mendoza Castillo','$2b$12$3a8EzL5Pz1fPWo./5WHYde7cb4lcqV8qXs.BJqGBNw9oP9pPvbbmC',NULL,NULL,NULL,1,'2026-05-23 13:43:04.141679','CIUDADANO'); INSERT INTO users VALUES(29,'sofia.jimenez310@celaya.gob.mx','461-330-2049','Sofía Sánchez Jiménez','$2b$12$0BOUkroMZVh7D3tggY.d4.dw2HGAZxvcEflTUADjBBxuL0WQwOUN6',NULL,NULL,NULL,1,'2026-05-23 13:43:04.344843','CIUDADANO'); INSERT INTO users VALUES(30,'mario.reyes311@celaya.gob.mx','461-107-2163','Mario Domínguez Reyes','$2b$12$SuE.YWVSiqNE7wlE6OD6r.xcRsmgypP6.U/A3cVrrn1roclY3Q51C',NULL,NULL,NULL,1,'2026-05-23 13:43:04.555964','CIUDADANO'); INSERT INTO users VALUES(31,'pedro.lopez312@celaya.gob.mx','461-626-4899','Pedro Castro López','$2b$12$h0Qor81F1KALukUFRFA8l.qsCEZ6EtTZZD06GSluzS.sL1k5NGupG',NULL,NULL,NULL,1,'2026-05-23 13:43:04.834821','CIUDADANO'); INSERT INTO users VALUES(32,'gabriela.ramirez313@celaya.gob.mx','461-840-8744','Gabriela Salazar Ramírez','$2b$12$H.nfXK/qDHl.Vw28g1sZ/.tbizW0OKgT5FmfkAresJ32vCTo42aXy',NULL,NULL,NULL,1,'2026-05-23 13:43:05.060604','CIUDADANO'); INSERT INTO users VALUES(33,'beatriz.perez314@celaya.gob.mx','461-199-8062','Beatriz Morales Pérez','$2b$12$g0Tb5FOZCVneXfjWkKF2He1X5/ktuUdMjlPqdhg4JCIw4Sd3SR07C',NULL,NULL,NULL,1,'2026-05-23 13:43:05.269543','CIUDADANO'); INSERT INTO users VALUES(34,'pablo.perez315@celaya.gob.mx','461-162-7596','Pablo Martínez Pérez','$2b$12$fCiimvw869XqMQ4fZDODRubWKHXURsPsqfigLiOLXogQVHk5x/QSm',NULL,NULL,NULL,1,'2026-05-23 13:43:05.483336','CIUDADANO'); INSERT INTO users VALUES(35,'laura.morales316@celaya.gob.mx','461-294-9786','Laura Jiménez Morales','$2b$12$6Cww/RyMvxBHfxfkoq4PbOQmzNC1HOuVJB.gl510awlDysxGFB.96',NULL,NULL,NULL,1,'2026-05-23 13:43:05.699550','CIUDADANO'); INSERT INTO users VALUES(36,'roberto.chavez317@celaya.gob.mx','461-355-2235','Roberto Díaz Chávez','$2b$12$NDwvXEqtM5B/N0v8J9aAVesHKISaG7aUZCD2ZxPiuj01X1d2ADlD6',NULL,NULL,NULL,1,'2026-05-23 13:43:05.905861','CIUDADANO'); INSERT INTO users VALUES(37,'laura.salazar318@celaya.gob.mx','461-956-1241','Laura Martínez Salazar','$2b$12$tNIDzOTmIbYlbMSKh1pnquyl7jRLCPYkBiOXIs4Kbp6CoFuVIRA4m',NULL,NULL,NULL,1,'2026-05-23 13:43:06.110201','CIUDADANO'); INSERT INTO users VALUES(38,'isabel.ortiz319@celaya.gob.mx','461-597-8886','Isabel Flores Ortiz','$2b$12$zC7QVb72W1lVdB.3VG9CdezLpeWy7e3DefwWOwme4bFEbVcBU9RgW',NULL,NULL,NULL,1,'2026-05-23 13:43:06.312638','CIUDADANO'); INSERT INTO users VALUES(39,'patricia.herrera320@celaya.gob.mx','461-102-7396','Patricia Flores Herrera','$2b$12$H4BOBizZNq0nqFAbXotwJe.fvyeiU9FFzxj8q3U8jUx4hy3FVCLPu',NULL,NULL,NULL,1,'2026-05-23 13:43:06.515974','CIUDADANO'); INSERT INTO users VALUES(40,'valeria.moreno321@celaya.gob.mx','461-813-8973','Valeria Ruiz Moreno','$2b$12$pStAGpBUPFEY7fbiXIKDduryL7DuAwj/3XlBBRczRtSsFAcgEW3Ii',NULL,NULL,NULL,1,'2026-05-23 13:43:06.720175','CIUDADANO'); INSERT INTO users VALUES(41,'fernando.dominguez322@celaya.gob.mx','461-853-9883','Fernando Martínez Domínguez','$2b$12$NwHTknuMj4OBWcHjsPsAsei7iflge4e1CnfWNodC9qYuLjn1kEYCa',NULL,NULL,NULL,1,'2026-05-23 13:43:06.923355','CIUDADANO'); INSERT INTO users VALUES(42,'patricia.dominguez323@celaya.gob.mx','461-588-9238','Patricia Martínez Domínguez','$2b$12$ijjIb8xSyFKp9LxXjtfjt.8/wGNQlQxBTreXmpt7lPIgdvLfJRXoW',NULL,NULL,NULL,1,'2026-05-23 13:43:07.125597','CIUDADANO'); INSERT INTO users VALUES(43,'ivan.gomez324@celaya.gob.mx','461-170-2113','Iván Rodríguez Gómez','$2b$12$CQfYw/ZSYCKQI0nrIvU32Ob3vhZr1w7pSzv1.ZKyV.ilp5HiQ3NaG',NULL,NULL,NULL,1,'2026-05-23 13:43:07.330844','CIUDADANO'); INSERT INTO users VALUES(44,'eduardo.solis325@celaya.gob.mx','461-140-2343','Eduardo Domínguez Solís','$2b$12$yvPLl4ob2GrZbAAHlw9syeCKxa665X8C89SbEqbbANQ1RIvuqyPh.',NULL,NULL,NULL,1,'2026-05-23 13:43:07.534071','CIUDADANO'); INSERT INTO users VALUES(45,'marisol.torres326@celaya.gob.mx','461-309-6147','Marisol Aguilar Torres','$2b$12$2PePJr9opdv6Z/Sfckby/ew1uy7/t2OK5EItg90x7wfsB.7zvayNK',NULL,NULL,NULL,1,'2026-05-23 13:43:07.744836','CIUDADANO'); INSERT INTO users VALUES(46,'alejandro.chavez327@celaya.gob.mx','461-423-2188','Alejandro Mendoza Chávez','$2b$12$ap7XMiNIs/c/iUlTKfiiD.jZukmUhCfgkAnPdbZWHMO3esVIwuaM6',NULL,NULL,NULL,1,'2026-05-23 13:43:07.964589','CIUDADANO'); INSERT INTO users VALUES(47,'jorge.salazar328@celaya.gob.mx','461-318-9288','Jorge López Salazar','$2b$12$ZC2PmPRFSU4zasCB3jLjnOZ6LrQijGA9zD3AnST4QI3eaVw4ycYcO',NULL,NULL,NULL,1,'2026-05-23 13:43:08.180791','CIUDADANO'); INSERT INTO users VALUES(48,'gerardo.jimenez329@celaya.gob.mx','461-478-5669','Gerardo López Jiménez','$2b$12$T5RLY1iP4.kh163L9botn.xJ5NDRmOs02Eb9ffsvnKtF5YM/0tN46',NULL,NULL,NULL,1,'2026-05-23 13:43:08.394482','CIUDADANO'); INSERT INTO users VALUES(49,'enrique.avila330@celaya.gob.mx','461-926-9666','Enrique Mendoza Avila','$2b$12$OGM4iBD.KBzGHX3vfOVh8OYV6L9KCqhexsvGN.6/Gr5Vti4C3yePu',NULL,NULL,NULL,1,'2026-05-23 13:43:08.608680','CIUDADANO'); INSERT INTO users VALUES(50,'norma.ramirez331@celaya.gob.mx','461-370-2891','Norma Pérez Ramírez','$2b$12$uK40OagBGxvKz9U8TebH9urSu5aMGQau1cOXGzr.0T48Z51aKYUwO',NULL,NULL,NULL,1,'2026-05-23 13:43:08.815431','CIUDADANO'); INSERT INTO users VALUES(51,'adriana.ruiz332@celaya.gob.mx','461-719-4450','Adriana Díaz Ruiz','$2b$12$0A5YvtIQEGpgg00tlD.gYeoibasAAdrR.LqtxPGlFSwCtHL95ZKyG',NULL,NULL,NULL,1,'2026-05-23 13:43:09.020346','CIUDADANO'); INSERT INTO users VALUES(52,'javier.guzman333@celaya.gob.mx','461-357-1832','Javier Mendez Guzmán','$2b$12$JBNuKnTN2CoUJkD2ez3G.ur0TqNfCsymMZMoGsrzyot09X2L7ch8e',NULL,NULL,NULL,1,'2026-05-23 13:43:09.227389','CIUDADANO'); INSERT INTO users VALUES(53,'alejandra.garcia334@celaya.gob.mx','461-441-3143','Alejandra González García','$2b$12$BygLqSuVV.ZXkrej9r7eSe0svA7sTXPfYLZB3ehJKDc9yctoMXeSe',NULL,NULL,NULL,1,'2026-05-23 13:43:09.433103','CIUDADANO'); INSERT INTO users VALUES(54,'ruben.moreno335@celaya.gob.mx','461-674-1158','Rubén Núñez Moreno','$2b$12$D1cgto6W3bu9FtexsMUylusjhv8.x2e0vY37nmdfnZ/qdUkjNE8ZS',NULL,NULL,NULL,1,'2026-05-23 13:43:09.640825','CIUDADANO'); INSERT INTO users VALUES(55,'antonio.gonzalez336@celaya.gob.mx','461-954-7049','Antonio Salazar González','$2b$12$wxiVClbkJRHDoOkLwJ4dU.3j3HW4PnFS8kZdDLI0w1yfJYP0wxxka',NULL,NULL,NULL,1,'2026-05-23 13:43:09.851446','CIUDADANO'); INSERT INTO users VALUES(56,'pedro.vargas337@celaya.gob.mx','461-915-1653','Pedro Mendoza Vargas','$2b$12$TQv/7gCbJM1CKlpa3BGjMeizZWLmtAOCyKRA9f74g82KvjReEBxo2',NULL,NULL,NULL,1,'2026-05-23 13:43:10.055405','CIUDADANO'); INSERT INTO users VALUES(57,'eduardo.romero338@celaya.gob.mx','461-898-7658','Eduardo Pérez Romero','$2b$12$4CdUazoLw235KKZMfs5Ok.OCuoAm/b4IxD171HGCNW4pw2CVgJvF6',NULL,NULL,NULL,1,'2026-05-23 13:43:10.258187','CIUDADANO'); INSERT INTO users VALUES(58,'isabel.gomez339@celaya.gob.mx','461-522-1406','Isabel Flores Gómez','$2b$12$V6hksVv68FBStH/ehtFYyeeaRWYHfTogbzmHlPXFgKnouPonFs0mm',NULL,NULL,NULL,1,'2026-05-23 13:43:10.461071','CIUDADANO'); INSERT INTO users VALUES(59,'karla.jimenez340@celaya.gob.mx','461-373-3608','Karla Ortiz Jiménez','$2b$12$3iXu7MuSNvzWRn1yvd9mwOmCrFBlofPvBHvrXO./gqVOaHCv6qk8.',NULL,NULL,NULL,1,'2026-05-23 13:43:10.665668','CIUDADANO'); INSERT INTO users VALUES(60,'pedro.reyes341@celaya.gob.mx','461-304-8541','Pedro Ramos Reyes','$2b$12$vPURNBA1E3UF2dwluGzhtepMdWQAa15t4t9he1eKNqk0pwqLxVjB.',NULL,NULL,NULL,1,'2026-05-23 13:43:10.870871','CIUDADANO'); INSERT INTO users VALUES(61,'mario.hernandez342@celaya.gob.mx','461-775-4164','Mario Reyes Hernández','$2b$12$d1HOhOp/nfTcjRzGvs2nXO0YrviEKai4FVdqnD4ADwBreW7KUOF.2',NULL,NULL,NULL,1,'2026-05-23 13:43:11.078355','CIUDADANO'); INSERT INTO users VALUES(62,'luis.romero343@celaya.gob.mx','461-756-9346','Luis Díaz Romero','$2b$12$Gk81dTiqGloB385R0R6YZ.IvatwCzQDm75Us1duki9ZGjoRlyY.52',NULL,NULL,NULL,1,'2026-05-23 13:43:11.283659','CIUDADANO'); INSERT INTO users VALUES(63,'magdalena.hernandez344@celaya.gob.mx','461-218-5279','Magdalena Castro Hernández','$2b$12$ZkSbhwMlOishfIBs5dAhtOGiNx05Zd69OXUb4n/2gK4iChhE/kM6y',NULL,NULL,NULL,1,'2026-05-23 13:43:11.489506','CIUDADANO'); INSERT INTO users VALUES(64,'yolanda.perez345@celaya.gob.mx','461-710-8119','Yolanda González Pérez','$2b$12$LesWczw3WSgzCoKMIgD3ru28zYxsckir.BFs7YcjR86HOFlm6QN4G',NULL,NULL,NULL,1,'2026-05-23 13:43:11.696925','CIUDADANO'); INSERT INTO users VALUES(65,'diana.solis346@celaya.gob.mx','461-623-2894','Diana Moreno Solís','$2b$12$AzM4xOyPx8nDYJQOYeeMFuz/DoiGeQJ4a6FvXBZMBaAQQiMnenbCa',NULL,NULL,NULL,1,'2026-05-23 13:43:11.899920','CIUDADANO'); INSERT INTO users VALUES(66,'cecilia.gonzalez347@celaya.gob.mx','461-825-8144','Cecilia Torres González','$2b$12$QpplkVdQtIpmppZQWyYXj.ynt8HRERWcBax9k3DeTpV/ZNFlSvn6e',NULL,NULL,NULL,1,'2026-05-23 13:43:12.105051','CIUDADANO'); INSERT INTO users VALUES(67,'magdalena.vargas348@celaya.gob.mx','461-541-2146','Magdalena Morales Vargas','$2b$12$y4GoWkHM97yiADrf4I3XauWOuz4ejPswKr821xm6tMBZmCNdkD2va',NULL,NULL,NULL,1,'2026-05-23 13:43:12.307666','CIUDADANO'); INSERT INTO users VALUES(68,'sandra.mendez349@celaya.gob.mx','461-416-7691','Sandra Mendoza Mendez','$2b$12$1tcLFvzKcc9ny5F3D8TEMOmWPUHFhew4yM3jqIOSHcJvbF.oZAGBC',NULL,NULL,NULL,1,'2026-05-23 13:43:12.511678','CIUDADANO'); INSERT INTO users VALUES(69,'raul.ramirez350@celaya.gob.mx','461-296-7888','Raúl Núñez Ramírez','$2b$12$B6pY8ugVSnRebGzAPush.OF3ey/23XgCBYwHZXeEVznEDXv9SzjkG',NULL,NULL,NULL,1,'2026-05-23 13:43:12.719370','CIUDADANO'); INSERT INTO users VALUES(70,'monica.cervantes351@celaya.gob.mx','461-408-7653','Mónica Avila Cervantes','$2b$12$Z46vKc1AznD6yVEASttGTOKiRKg8.ZTAblOl.xWpj8MAjtK4j.4t2',NULL,NULL,NULL,1,'2026-05-23 13:43:12.924857','CIUDADANO'); INSERT INTO users VALUES(71,'norma.vazquez352@celaya.gob.mx','461-540-6279','Norma Ruiz Vázquez','$2b$12$KlX6C3WoU.wzXZ.S8whCW.wF.bcj.kC/TS65JlR1BNZ7D1M9NFOHq',NULL,NULL,NULL,1,'2026-05-23 13:43:13.141356','CIUDADANO'); INSERT INTO users VALUES(72,'fernando.ramos353@celaya.gob.mx','461-912-3780','Fernando Mendez Ramos','$2b$12$3WuFl.fkPTPge1CvMG5q.Ockj2VEGH4C0fZ8rWcdOLsKDzO.XcLmq',NULL,NULL,NULL,1,'2026-05-23 13:43:13.349445','CIUDADANO'); INSERT INTO users VALUES(73,'arturo.jimenez354@celaya.gob.mx','461-788-6085','Arturo Rodríguez Jiménez','$2b$12$wnlhX0BdfmVaEWoCa0pkTeAzituG5zs0E8P/g5ewajEaH7Y0P2eA6',NULL,NULL,NULL,1,'2026-05-23 13:43:13.555159','CIUDADANO'); INSERT INTO users VALUES(74,'adriana.gonzalez355@celaya.gob.mx','461-350-8784','Adriana Hernández González','$2b$12$eKD1eC5/ZZhK82KCn7ySC.PF8btKXCf8JGutjm6G3gWLcYKEQz8vK',NULL,NULL,NULL,1,'2026-05-23 13:43:13.758920','CIUDADANO'); INSERT INTO users VALUES(75,'daniel.guzman356@celaya.gob.mx','461-509-4997','Daniel Herrera Guzmán','$2b$12$w1JFSvvjugOrplr78oMdb.Ex8ah9Ysrd1YOhNPY9oOjNaZGI8pm42',NULL,NULL,NULL,1,'2026-05-23 13:43:13.961831','CIUDADANO'); INSERT INTO users VALUES(76,'maria.moreno357@celaya.gob.mx','461-324-3881','María Pérez Moreno','$2b$12$bNQswoIDG7CyC/ddgGiu6utOecsMfGEqy/7Tr53krJGXX9JJ2frQm',NULL,NULL,NULL,1,'2026-05-23 13:43:14.164250','CIUDADANO'); INSERT INTO users VALUES(77,'eduardo.chavez358@celaya.gob.mx','461-236-8612','Eduardo Sánchez Chávez','$2b$12$r1OUdjD9gntkV9IK.h9TSupSyvK4ycH3D.ZmU0b3qZeEAMLMJiJfq',NULL,NULL,NULL,1,'2026-05-23 13:43:14.366679','CIUDADANO'); INSERT INTO users VALUES(78,'diana.avila359@celaya.gob.mx','461-934-9270','Diana Rivera Avila','$2b$12$XUjT0hu4gWkl3gMw9WgHJ.9r2VhN.Xt/NtS90iA/RRYYLtJV.3Ug.',NULL,NULL,NULL,1,'2026-05-23 13:43:14.570768','CIUDADANO'); INSERT INTO users VALUES(79,'sofia.ramos360@celaya.gob.mx','461-560-5246','Sofía Flores Ramos','$2b$12$28UQzDghX/5yPaWte2OoguHwAxz7vvbSeO/y/GFl6z./ztzffg866',NULL,NULL,NULL,1,'2026-05-23 13:43:14.775576','CIUDADANO'); INSERT INTO users VALUES(80,'alejandra.guzman361@celaya.gob.mx','461-741-4919','Alejandra Estrada Guzmán','$2b$12$ifVcKld4yDlyxiJQE4mYmOqPg1j2bsd7t10KoJ/m7z6a.tbGsOeUO',NULL,NULL,NULL,1,'2026-05-23 13:43:14.978872','CIUDADANO'); INSERT INTO users VALUES(81,'raul.diaz362@celaya.gob.mx','461-443-6238','Raúl Jiménez Díaz','$2b$12$tULwFJuvsGao5k8FZugh2uj3pzMCbhLBaWaS3IMFtoF1jFbS1gEiC',NULL,NULL,NULL,1,'2026-05-23 13:43:15.181268','CIUDADANO'); INSERT INTO users VALUES(82,'antonio.herrera363@celaya.gob.mx','461-810-3503','Antonio Reyes Herrera','$2b$12$/K6qsGL.Gl1hLb8An7qVM.Rfhh7vNkklPl9nNA6s8GY6anb0asM12',NULL,NULL,NULL,1,'2026-05-23 13:43:15.383981','CIUDADANO'); INSERT INTO users VALUES(83,'salvador.salazar364@celaya.gob.mx','461-577-7812','Salvador Castro Salazar','$2b$12$bzXILtObbO.0ejUpQ5fsuuL9P78XD3WF0psXhDS7IeLQPjsuhESTi',NULL,NULL,NULL,1,'2026-05-23 13:43:15.587155','CIUDADANO'); INSERT INTO users VALUES(84,'salvador.dominguez365@celaya.gob.mx','461-812-1320','Salvador Herrera Domínguez','$2b$12$ZZoPbcTrxY6kP9K9iqKOyO.hq4oGW/WuRyXD0jMY1CXx433WlQjIa',NULL,NULL,NULL,1,'2026-05-23 13:43:15.789941','CIUDADANO'); INSERT INTO users VALUES(85,'gerardo.herrera366@celaya.gob.mx','461-973-7865','Gerardo Mendoza Herrera','$2b$12$DAfBBX8Dkt1Bvq2xZ7z1de62WA22pR0iw6YQgXOocWW2hsfI2MRzG',NULL,NULL,NULL,1,'2026-05-23 13:43:15.992811','CIUDADANO'); INSERT INTO users VALUES(86,'magdalena.reyes367@celaya.gob.mx','461-599-4595','Magdalena Solís Reyes','$2b$12$/OgUQDqAdOOzUkVfOeEk8OJFkYDkR5dDO2K96M/gMmwMSByAjN.tm',NULL,NULL,NULL,1,'2026-05-23 13:43:16.196899','CIUDADANO'); INSERT INTO users VALUES(87,'juan.castro368@celaya.gob.mx','461-784-7624','Juan Herrera Castro','$2b$12$d7TG9ROlYLOGzoqUGE0erO0z2Kf/tMVHWyFTrZBXAJRATpYInX996',NULL,NULL,NULL,1,'2026-05-23 13:43:16.401620','CIUDADANO'); INSERT INTO users VALUES(88,'veronica.salazar369@celaya.gob.mx','461-127-7455','Verónica Avila Salazar','$2b$12$C53S/B7ym00evdAO9/RGku2q7AYtXh6b8/covhDm8X/7/2zewdUqC',NULL,NULL,NULL,1,'2026-05-23 13:43:16.604748','CIUDADANO'); INSERT INTO users VALUES(89,'octavio.chavez370@celaya.gob.mx','461-286-1823','Octavio Ramírez Chávez','$2b$12$BXMd9UcGpn3Ogfzy3ujGIO7/A2tghv3RtVg/GmqXF7W2reNM3GjFG',NULL,NULL,NULL,1,'2026-05-23 13:43:16.809578','CIUDADANO'); INSERT INTO users VALUES(90,'fernando.aguilar371@celaya.gob.mx','461-445-7211','Fernando Chávez Aguilar','$2b$12$tb0sd9NleYl9AddGRqaeuu/cVvRoROy4jzxQBpnB1KteoG7L4MWnS',NULL,NULL,NULL,1,'2026-05-23 13:43:17.012466','CIUDADANO'); INSERT INTO users VALUES(91,'beatriz.rodriguez372@celaya.gob.mx','461-581-1317','Beatriz Torres Rodríguez','$2b$12$EozF69B2mihNnR0qmd0wL.x6jFeBWygxJnBofE5T4oRk7cXn0CKme',NULL,NULL,NULL,1,'2026-05-23 13:43:17.215560','CIUDADANO'); INSERT INTO users VALUES(92,'gerardo.lopez373@celaya.gob.mx','461-899-1659','Gerardo Reyes López','$2b$12$OyHGKTKx5kUCHXbhj4X7o.YjP4EE/CrM9MV4F2AjJ9MKHQcFDb.DW',NULL,NULL,NULL,1,'2026-05-23 13:43:17.418269','CIUDADANO'); INSERT INTO users VALUES(93,'cecilia.avila374@celaya.gob.mx','461-256-4908','Cecilia Hernández Avila','$2b$12$H2P97k3c.4UOt0oenK30pubq/YVM61cHBHEOTHUVpu0zjIYBqoaie',NULL,NULL,NULL,1,'2026-05-23 13:43:17.622390','CIUDADANO'); INSERT INTO users VALUES(94,'francisco.vazquez375@celaya.gob.mx','461-576-5198','Francisco Cervantes Vázquez','$2b$12$oz10FVxlkQmYx9SnQz.HHOs68MHAGMfeSeAxUIUZUmafyhzmTCPgq',NULL,NULL,NULL,1,'2026-05-23 13:43:17.826029','CIUDADANO'); INSERT INTO users VALUES(95,'francisco.mendoza376@celaya.gob.mx','461-210-1420','Francisco Flores Mendoza','$2b$12$Jpe0Ap3vR4CM3vvVVS3ww.wprXIPSK3j32yFaG2R8rrbK2XTR//tm',NULL,NULL,NULL,1,'2026-05-23 13:43:18.039274','CIUDADANO'); INSERT INTO users VALUES(96,'lucia.morales377@celaya.gob.mx','461-177-4978','Lucía Castillo Morales','$2b$12$X0i8ejfrqZngR0HpqWKSQO1wpoi8QALaIi.Hx6ABBzkzbcXM8nExm',NULL,NULL,NULL,1,'2026-05-23 13:43:18.258491','CIUDADANO'); INSERT INTO users VALUES(97,'norma.sanchez378@celaya.gob.mx','461-915-1672','Norma Solís Sánchez','$2b$12$dXkx97F2IpPTjRESc6pr5e621D9t9ye9bQi6hEuIl6Z3VMvGQk8a2',NULL,NULL,NULL,1,'2026-05-23 13:43:18.478458','CIUDADANO'); INSERT INTO users VALUES(98,'brenda.mendez379@celaya.gob.mx','461-763-6590','Brenda López Mendez','$2b$12$3IMJs1Wi2M9vGpWgYrTRnu20oLwV1yQkcgohqsb/UU43RUxzkjYXC',NULL,NULL,NULL,1,'2026-05-23 13:43:18.694034','CIUDADANO'); INSERT INTO users VALUES(99,'paola.moreno380@celaya.gob.mx','461-470-8532','Paola Pérez Moreno','$2b$12$jvWCWX7ne6Jh2nI/.N72n.CBFBNY9w8O3UgvFEZzI3pBjs8R/CXti',NULL,NULL,NULL,1,'2026-05-23 13:43:18.901647','CIUDADANO'); INSERT INTO users VALUES(100,'alberto.avila381@celaya.gob.mx','461-927-9817','Alberto Díaz Avila','$2b$12$rbXwbpEgEnD6Zvm69sv4jOzxyFyXCvOyIOMUKAlTzplJW6pJ5Ueje',NULL,NULL,NULL,1,'2026-05-23 13:43:19.109997','CIUDADANO'); INSERT INTO users VALUES(101,'sergio.jimenez382@celaya.gob.mx','461-950-2419','Sergio Aguilar Jiménez','$2b$12$hxGZrJDRpqvw0rmw8HqqqeYWp79qOmG0fHq6t77VSz2.3r0XlfAnG',NULL,NULL,NULL,1,'2026-05-23 13:43:19.318308','CIUDADANO'); INSERT INTO users VALUES(102,'isabel.cervantes383@celaya.gob.mx','461-724-7209','Isabel Chávez Cervantes','$2b$12$fi2UZFh31IE//CSCavMtXecPYNBKiXpd3..uyzYgwVspf9e2P7HNm',NULL,NULL,NULL,1,'2026-05-23 13:43:19.524518','CIUDADANO'); INSERT INTO users VALUES(103,'rafael.guzman384@celaya.gob.mx','461-317-6813','Rafael Gómez Guzmán','$2b$12$ORCU08HRdhxnu.8Z/703tOXpesBwuarEspN/SoDjeO8Vp4Hbrrmyu',NULL,NULL,NULL,1,'2026-05-23 13:43:19.730405','CIUDADANO'); INSERT INTO users VALUES(104,'sergio.garcia385@celaya.gob.mx','461-629-4130','Sergio Núñez García','$2b$12$i3L40EH4Ezw1Ff6f7yt6leT4Bm/eWVG4bSB7IFW8OvT9n9HWR2wuu',NULL,NULL,NULL,1,'2026-05-23 13:43:19.934812','CIUDADANO'); INSERT INTO users VALUES(105,'salvador.nunez386@celaya.gob.mx','461-876-4937','Salvador Guzmán Núñez','$2b$12$hyAA33m5ju3e3JFbdAxzPuernSh2tK.D5UcFhcBjBlSzlFVRnRG.m',NULL,NULL,NULL,1,'2026-05-23 13:43:20.138687','CIUDADANO'); INSERT INTO users VALUES(106,'paola.hernandez387@celaya.gob.mx','461-195-5820','Paola Rivera Hernández','$2b$12$gIiiHuUpFTSn2DAi4pqXKOX8RDFlPhRtzc1EBy/N8ODAOwZRjwM9C',NULL,NULL,NULL,1,'2026-05-23 13:43:20.343388','CIUDADANO'); INSERT INTO users VALUES(107,'eduardo.dominguez388@celaya.gob.mx','461-477-8753','Eduardo Mendoza Domínguez','$2b$12$CQow8namXzoXNeppr17/AOKTwIoayogvGfg1PBHlO2wpS/Zseutqe',NULL,NULL,NULL,1,'2026-05-23 13:43:20.547585','CIUDADANO'); INSERT INTO users VALUES(108,'arturo.chavez389@celaya.gob.mx','461-377-6023','Arturo Romero Chávez','$2b$12$ik3o5.ovWjMWVvlUqSFQcu/bTPA.Zd10MJ8yKpxGRqt7VIX9uuF6a',NULL,NULL,NULL,1,'2026-05-23 13:43:20.754973','CIUDADANO'); INSERT INTO users VALUES(109,'daniel.sanchez390@celaya.gob.mx','461-860-9779','Daniel Aguilar Sánchez','$2b$12$j5gQYqu6.vUp1/v0RweTdukV5/Fpgb8d/CMQzft89a0SuDQNfc6.i',NULL,NULL,NULL,1,'2026-05-23 13:43:20.964346','CIUDADANO'); INSERT INTO users VALUES(110,'andres.dominguez391@celaya.gob.mx','461-878-9595','Andrés Díaz Domínguez','$2b$12$cqbnJwxWcwEwbdQmxM5bpeHTQWPZzjrUAFm.FmH3wtTpGwbKwjBmW',NULL,NULL,NULL,1,'2026-05-23 13:43:21.173681','CIUDADANO'); INSERT INTO users VALUES(111,'cecilia.reyes392@celaya.gob.mx','461-469-3939','Cecilia Ruiz Reyes','$2b$12$.x/qQz20bXcbmO7elbYS3OkraE3uFI7scS11upkm8deA5XEp2JQvW',NULL,NULL,NULL,1,'2026-05-23 13:43:21.380132','CIUDADANO'); INSERT INTO users VALUES(112,'enrique.diaz393@celaya.gob.mx','461-146-1893','Enrique Ramírez Díaz','$2b$12$m7VatWhcjfB8mCpiK2xqpukIUx2h82JCKSfYO4C1TRmi.LSmd.Ra6',NULL,NULL,NULL,1,'2026-05-23 13:43:21.589304','CIUDADANO'); INSERT INTO users VALUES(113,'veronica.perez394@celaya.gob.mx','461-993-1200','Verónica Guzmán Pérez','$2b$12$nik4jtX/6t.YEfZOazMX4.TFiIGWrNHm95aA8Loh/k2UzelUvxtP.',NULL,NULL,NULL,1,'2026-05-23 13:43:21.794793','CIUDADANO'); INSERT INTO users VALUES(114,'ruben.gomez395@celaya.gob.mx','461-152-5136','Rubén Castro Gómez','$2b$12$RJIeegME.uQNwDi1ymzP8.C9jID2ycOyPS8W4UO.Q2F/C8AmewmW.',NULL,NULL,NULL,1,'2026-05-23 13:43:21.999953','CIUDADANO'); INSERT INTO users VALUES(115,'luis.guzman396@celaya.gob.mx','461-175-1878','Luis Castillo Guzmán','$2b$12$hK8Wl5uVw5OPtEXothUL1.E9Bn5TCzKuWjjBNskh9Wgb1oJRRVIL6',NULL,NULL,NULL,1,'2026-05-23 13:43:22.204816','CIUDADANO'); INSERT INTO users VALUES(116,'manuel.jimenez397@celaya.gob.mx','461-221-7818','Manuel Rodríguez Jiménez','$2b$12$YJO0SQbD0g.CgxQXlftnLe823y6hba6Jn.mq8BVcTi87e3TW0ytjy',NULL,NULL,NULL,1,'2026-05-23 13:43:22.409126','CIUDADANO'); INSERT INTO users VALUES(117,'lucia.rivera398@celaya.gob.mx','461-404-8025','Lucía Rivera Rivera','$2b$12$ENr7bQEN/0/eX5NfAZ4yCe2KLstW.k6oqxgRc0W7DPgat492POc9u',NULL,NULL,NULL,1,'2026-05-23 13:43:22.615490','CIUDADANO'); INSERT INTO users VALUES(118,'patricia.perez399@celaya.gob.mx','461-881-4404','Patricia Avila Pérez','$2b$12$M2Id7utkhAP1r9ODdxrSQOx9trcdRnxD1vNRuA0lq27OEhjR11VLi',NULL,NULL,NULL,1,'2026-05-23 13:43:22.824958','CIUDADANO'); INSERT INTO users VALUES(119,'miguel.jimenez400@celaya.gob.mx','461-277-2229','Miguel Flores Jiménez','$2b$12$AFv8EE06dD.ZiZv.Qn69nu7d69VlREu3kR7HfcmbCWY2cihk4LR/2',NULL,NULL,NULL,1,'2026-05-23 13:43:23.034332','CIUDADANO'); INSERT INTO users VALUES(120,'ruben.ramos401@celaya.gob.mx','461-398-1534','Rubén Solís Ramos','$2b$12$jbKxc8ifnRJp3fatdpGArewmp.I6AZN/yTS7BIEQpm6NXkEn8hVzq',NULL,NULL,NULL,1,'2026-05-23 13:43:23.246264','CIUDADANO'); INSERT INTO users VALUES(121,'raul.lopez402@celaya.gob.mx','461-803-4824','Raúl Chávez López','$2b$12$0bjOC/58UnbtfgBPe2DACelruqz7cFlm/VOZulWcR2CDFsAVs.r4i',NULL,NULL,NULL,1,'2026-05-23 13:43:23.463312','CIUDADANO'); INSERT INTO users VALUES(122,'cecilia.sanchez403@celaya.gob.mx','461-657-4683','Cecilia Moreno Sánchez','$2b$12$Vtv4ZTeHeNpSKuiQoPGGPuHc7EFmgLgu5Ifge3iwgICytWFLlwCJK',NULL,NULL,NULL,1,'2026-05-23 13:43:23.672590','CIUDADANO'); INSERT INTO users VALUES(123,'adriana.martinez404@celaya.gob.mx','461-269-6039','Adriana López Martínez','$2b$12$DMV2GD.IYBOJnrYVkfemduLZE8zLBtHmUR2MiU.d9Q10CoubsXYgi',NULL,NULL,NULL,1,'2026-05-23 13:43:23.877879','CIUDADANO'); INSERT INTO users VALUES(124,'pablo.castillo405@celaya.gob.mx','461-378-9199','Pablo Mendoza Castillo','$2b$12$67YJ0neWcCIN8Comf4rfdekiUmM4M/maAfF1yiyma1DttyTfnmIcC',NULL,NULL,NULL,1,'2026-05-23 13:43:24.083108','CIUDADANO'); INSERT INTO users VALUES(125,'miguel.gonzalez406@celaya.gob.mx','461-542-6280','Miguel Solís González','$2b$12$2hSQEPF71vX48qiFiCJQEe3abIYoFJ/3tcOReulnuPvLcmxLZ/ORe',NULL,NULL,NULL,1,'2026-05-23 13:43:24.289136','CIUDADANO'); INSERT INTO users VALUES(126,'mario.dominguez407@celaya.gob.mx','461-121-5415','Mario Cervantes Domínguez','$2b$12$aJdE4JN1DtBh5yuIHr2qUux8VaEoeAvSa7/krD.nO/Y87JttpAn66',NULL,NULL,NULL,1,'2026-05-23 13:43:24.494974','CIUDADANO'); INSERT INTO users VALUES(127,'monica.estrada408@celaya.gob.mx','461-767-8245','Mónica Ramos Estrada','$2b$12$Mi7XrA7BeVU.OhdXNfwjUuOCce/qsSyLFrWBvpd4XGx/cW.Dqz37O',NULL,NULL,NULL,1,'2026-05-23 13:43:24.702782','CIUDADANO'); INSERT INTO users VALUES(128,'octavio.rodriguez409@celaya.gob.mx','461-581-6700','Octavio Guzmán Rodríguez','$2b$12$/wpdQwObUZJN82gBEVsQ8.DCp17tWfajmAtzUoJOnLY7v92l1oGpm',NULL,NULL,NULL,1,'2026-05-23 13:43:24.909940','CIUDADANO'); INSERT INTO users VALUES(129,'jorge.castro410@celaya.gob.mx','461-521-9117','Jorge Flores Castro','$2b$12$d5ViwZLuhHZ5j2uU5JYCLOMMwng/lDqNc5uNRaDvKVhQYORlRwzqK',NULL,NULL,NULL,1,'2026-05-23 13:43:25.117948','CIUDADANO'); INSERT INTO users VALUES(130,'elena.gonzalez411@celaya.gob.mx','461-565-2442','Elena Núñez González','$2b$12$ihuRCliPwE9tajULuFhxjelDGfJTqqjEL.bhlmMglifT1BQYG.Oti',NULL,NULL,NULL,1,'2026-05-23 13:43:25.324325','CIUDADANO'); INSERT INTO users VALUES(131,'francisco.mendez412@celaya.gob.mx','461-944-1018','Francisco Castillo Mendez','$2b$12$WHtv.DlPtFH6gINSTMJJVObgFwMJkUYLvtatgJHLi5Q2kGXMOvkEG',NULL,NULL,NULL,1,'2026-05-23 13:43:25.529318','CIUDADANO'); INSERT INTO users VALUES(132,'carlos.estrada413@celaya.gob.mx','461-470-9167','Carlos Morales Estrada','$2b$12$pZ5dmKtKZqnM7Y5T0/Mj0.VXJSj2ylhkE04eIiWXiNSkKPP/W4Zay',NULL,NULL,NULL,1,'2026-05-23 13:43:25.735749','CIUDADANO'); INSERT INTO users VALUES(133,'gabriela.nunez414@celaya.gob.mx','461-234-5719','Gabriela Díaz Núñez','$2b$12$uYqgD6JuTkudkngyeSwBaexqH4dFzmw7P6wwGZjQdQBr3.11kN6Wu',NULL,NULL,NULL,1,'2026-05-23 13:43:25.941487','CIUDADANO'); INSERT INTO users VALUES(134,'paola.hernandez415@celaya.gob.mx','461-745-4920','Paola Sánchez Hernández','$2b$12$H2nH4UENxbJBVjZ7GXYv3OrpWMU.pvxW.RvK7ZaGb8y/ABiU9nF7G',NULL,NULL,NULL,1,'2026-05-23 13:43:26.146748','CIUDADANO'); INSERT INTO users VALUES(135,'jose.ortiz416@celaya.gob.mx','461-195-4681','José Núñez Ortiz','$2b$12$opAG2s/eoIyKuEecfpM6BONb4wEEdJvGRg8PLy2NOmRjwkW52vjW2',NULL,NULL,NULL,1,'2026-05-23 13:43:26.352592','CIUDADANO'); INSERT INTO users VALUES(136,'francisco.guzman417@celaya.gob.mx','461-833-5781','Francisco Cruz Guzmán','$2b$12$5c8rq7XlhW3Owcqmvd4iyOaPuo8DQlYcol9wva5/eDP1zHlJO4XG.',NULL,NULL,NULL,1,'2026-05-23 13:43:26.561168','CIUDADANO'); INSERT INTO users VALUES(137,'beatriz.ramos418@celaya.gob.mx','461-349-8483','Beatriz Ramos Ramos','$2b$12$u74upnQQ8ikmADmxmOxjMeTHnsne2wUGTugGCT.igTrGEA95RXf8a',NULL,NULL,NULL,1,'2026-05-23 13:43:26.767877','CIUDADANO'); INSERT INTO users VALUES(138,'ivan.lopez419@celaya.gob.mx','461-382-7798','Iván Ramírez López','$2b$12$HRgMkKWbqhdgYMt5KcktrOdd8MXrVLHsDEapPYD/8.At7d6S2VW8i',NULL,NULL,NULL,1,'2026-05-23 13:43:26.973889','CIUDADANO'); INSERT INTO users VALUES(139,'karina.garcia420@celaya.gob.mx','461-389-5891','Karina Díaz García','$2b$12$UwpZhYPQOE1dbuIjj/Q8MubBBJx4ugBVORoS98UK8aZXkcSfcCsEG',NULL,NULL,NULL,1,'2026-05-23 13:43:27.181296','CIUDADANO'); INSERT INTO users VALUES(140,'sofia.ramos421@celaya.gob.mx','461-453-6446','Sofía Salazar Ramos','$2b$12$.WhK5CdrK4bINuB.r3yP2.Af.I9ObeREdCMS/RRlWzznN8bf8065W',NULL,NULL,NULL,1,'2026-05-23 13:43:27.387596','CIUDADANO'); INSERT INTO users VALUES(141,'rafael.jimenez422@celaya.gob.mx','461-685-7274','Rafael Morales Jiménez','$2b$12$l1ZU0tFdvVwQYIJWvLQmHeNhT2fiPk9vYExzqeJUmJYToA8ZTmsTq',NULL,NULL,NULL,1,'2026-05-23 13:43:27.594309','CIUDADANO'); INSERT INTO users VALUES(142,'beatriz.aguilar423@celaya.gob.mx','461-862-8749','Beatriz González Aguilar','$2b$12$SpKIzC0Avl0rUxhlgWi77uK0FLiYpKXvF1fyMFEiB/Z1k6Ifi4kku',NULL,NULL,NULL,1,'2026-05-23 13:43:27.801517','CIUDADANO'); INSERT INTO users VALUES(143,'antonio.gonzalez424@celaya.gob.mx','461-229-9229','Antonio Guzmán González','$2b$12$W6oQlM.mXGi.rlOYyjI3auXOVTen15QsRQVDXF/jpFZ6XgUdwakfu',NULL,NULL,NULL,1,'2026-05-23 13:43:28.008383','CIUDADANO'); INSERT INTO users VALUES(144,'sofia.estrada425@celaya.gob.mx','461-567-1251','Sofía Pérez Estrada','$2b$12$LKA8Gbp0HKQpBPso/0DqKelIt8IZHBiFEaanWz2fz4kIJfytK9di6',NULL,NULL,NULL,1,'2026-05-23 13:43:28.220226','CIUDADANO'); INSERT INTO users VALUES(145,'antonio.ramos426@celaya.gob.mx','461-900-5342','Antonio López Ramos','$2b$12$bMZK2eABFMOhReTK5FW2L.QLYtoG8ECYyAjOffMHimVk0KXYf02ta',NULL,NULL,NULL,1,'2026-05-23 13:43:28.433022','CIUDADANO'); INSERT INTO users VALUES(146,'elena.castro427@celaya.gob.mx','461-972-9742','Elena Rodríguez Castro','$2b$12$Pg5HZU5MGwsRmfxuJideeuLWmw/qN5CuCU36wVcWXu7AvSsG3Pz0y',NULL,NULL,NULL,1,'2026-05-23 13:43:28.640301','CIUDADANO'); INSERT INTO users VALUES(147,'paola.gonzalez428@celaya.gob.mx','461-732-2121','Paola Salazar González','$2b$12$f.m0GRVwX2CbHQPnfoZrcun2wZToI7Sual6FRv9SEUM0dNI/3w5Qy',NULL,NULL,NULL,1,'2026-05-23 13:43:28.846672','CIUDADANO'); INSERT INTO users VALUES(148,'leticia.rodriguez429@celaya.gob.mx','461-544-2612','Leticia Reyes Rodríguez','$2b$12$N/0zI7yPM.xvaQXzOjxyEueHuB3gxavwA5cryR2WbK5vC.d1V8xAC',NULL,NULL,NULL,1,'2026-05-23 13:43:29.064036','CIUDADANO'); INSERT INTO users VALUES(149,'manuel.gonzalez430@celaya.gob.mx','461-432-1919','Manuel Hernández González','$2b$12$IgXyfVC2ij4tlh1yC00mzuKMVWQRE2GV23jpPFBTSwbz/LkLywr8O',NULL,NULL,NULL,1,'2026-05-23 13:43:29.281603','CIUDADANO'); INSERT INTO users VALUES(150,'octavio.jimenez431@celaya.gob.mx','461-643-7751','Octavio Cruz Jiménez','$2b$12$Wjo5VBHN0UYJ9QFN5kJUb.418irRySEI0B1xbol39OxOOGlNv3iLq',NULL,NULL,NULL,1,'2026-05-23 13:43:29.501499','CIUDADANO'); INSERT INTO users VALUES(151,'miguel.herrera432@celaya.gob.mx','461-734-4945','Miguel Avila Herrera','$2b$12$pp2e/wAQ9N92KK/YTWasde5iFc92x/EOKUWd87qGWvjSuKZChosCS',NULL,NULL,NULL,1,'2026-05-23 13:43:29.711746','CIUDADANO'); INSERT INTO users VALUES(152,'adriana.chavez433@celaya.gob.mx','461-753-5161','Adriana Reyes Chávez','$2b$12$MwnLMvjZKYSAzdYS6ffvHeUDy1l0rL34tVD9MgjWL1ylRoFLoze9K',NULL,NULL,NULL,1,'2026-05-23 13:43:29.920605','CIUDADANO'); INSERT INTO users VALUES(153,'jose.ruiz434@celaya.gob.mx','461-793-9955','José Chávez Ruiz','$2b$12$oDnQLwkgw12damTqSjJyjuPXvaJxNh/65J0tgDz4NdNjJ6hhFb4bq',NULL,NULL,NULL,1,'2026-05-23 13:43:30.128992','CIUDADANO'); INSERT INTO users VALUES(154,'gerardo.mendoza435@celaya.gob.mx','461-754-7951','Gerardo Domínguez Mendoza','$2b$12$MIizP47NRM3jMn42fZRyC.0CW5yur/zoBUxofpPil.37YmLCys8K2',NULL,NULL,NULL,1,'2026-05-23 13:43:30.339169','CIUDADANO'); INSERT INTO users VALUES(155,'manuel.herrera436@celaya.gob.mx','461-973-8916','Manuel Morales Herrera','$2b$12$ygaW600SYEWuNLWXZ3IXl.uKTHNb69Qy0FV2j.io49ZZUo8hfP.Wm',NULL,NULL,NULL,1,'2026-05-23 13:43:30.547398','CIUDADANO'); INSERT INTO users VALUES(156,'gerardo.ruiz437@celaya.gob.mx','461-816-5837','Gerardo Cervantes Ruiz','$2b$12$R/vgkKwrwDSAgP5GhASS/uR8gsF4f/s3Ogep7WBipTXPoiBvHrLjO',NULL,NULL,NULL,1,'2026-05-23 13:43:30.758779','CIUDADANO'); INSERT INTO users VALUES(157,'elena.garcia438@celaya.gob.mx','461-679-1803','Elena Díaz García','$2b$12$IKuDTDk987pjFyJTam8gKurGDBH1svJrrNr8go8u.3MhnbzT7t9Ty',NULL,NULL,NULL,1,'2026-05-23 13:43:30.970404','CIUDADANO'); INSERT INTO users VALUES(158,'leticia.solis439@celaya.gob.mx','461-921-6772','Leticia Reyes Solís','$2b$12$8ufW/b7oucEsqVcm9Hvmz.y6NdGdnB9TUgrCV/rvCKWLBOHnIOLB.',NULL,NULL,NULL,1,'2026-05-23 13:43:31.195194','CIUDADANO'); INSERT INTO users VALUES(159,'yolanda.perez440@celaya.gob.mx','461-742-1645','Yolanda Ramírez Pérez','$2b$12$eLUdvyEfptWlZTZm5M/LKeURYFxgFuaa.4dSTnPU1X6o8zZIV8U1S',NULL,NULL,NULL,1,'2026-05-23 13:43:31.408224','CIUDADANO'); INSERT INTO users VALUES(160,'ana.vargas441@celaya.gob.mx','461-849-3153','Ana Domínguez Vargas','$2b$12$nJUA1zu1cJ8qwEBZ8I96LO9bYFYlwLQa.qgAKyuE71GMk4wy83FJq',NULL,NULL,NULL,1,'2026-05-23 13:43:31.623560','CIUDADANO'); INSERT INTO users VALUES(161,'diana.gomez442@celaya.gob.mx','461-305-3165','Diana Ortiz Gómez','$2b$12$oNjXWKLupf4jLAWfjk4LV.D.X5qCFatrQPFocn041EUAuYwEuTpkm',NULL,NULL,NULL,1,'2026-05-23 13:43:31.833962','CIUDADANO'); INSERT INTO users VALUES(162,'brenda.mendez443@celaya.gob.mx','461-379-3695','Brenda Estrada Mendez','$2b$12$jSxhhdTmf9C30mHKqUYqCurXR0qnY4u3tDj1dKLGF2utUUhjhz66K',NULL,NULL,NULL,1,'2026-05-23 13:43:32.041816','CIUDADANO'); INSERT INTO users VALUES(163,'daniela.castro444@celaya.gob.mx','461-923-2886','Daniela Ruiz Castro','$2b$12$5VCHD9LjroL21E6lSMGt2.1F8chvnix7wifGHNMlhG5lr/MsKl5r6',NULL,NULL,NULL,1,'2026-05-23 13:43:32.250793','CIUDADANO'); INSERT INTO users VALUES(164,'adriana.castillo445@celaya.gob.mx','461-966-6992','Adriana Reyes Castillo','$2b$12$Tp9XHY55PK6uWAVDHdTcL.cpSYStGMKa8tBxAqOr5rErG/ykkO/g2',NULL,NULL,NULL,1,'2026-05-23 13:43:32.459569','CIUDADANO'); INSERT INTO users VALUES(165,'maria.salazar446@celaya.gob.mx','461-226-8451','María Torres Salazar','$2b$12$SEYEqTSynUGrX50tXQx86ONT6n70afG9kGN1Hs.Hj7sbM4VmkVyMu',NULL,NULL,NULL,1,'2026-05-23 13:43:32.668541','CIUDADANO'); INSERT INTO users VALUES(166,'yolanda.herrera447@celaya.gob.mx','461-942-7086','Yolanda Domínguez Herrera','$2b$12$tJufU9L5DQjpgZP9/L1jwe/0xsIhyAj1lJDZW0HqzjDVb.e.z7eXK',NULL,NULL,NULL,1,'2026-05-23 13:43:32.881468','CIUDADANO'); INSERT INTO users VALUES(167,'daniela.avila448@celaya.gob.mx','461-674-6374','Daniela Hernández Avila','$2b$12$ZGtmLxOFjPV/cci2Nz5GHekDA7Mm0styCqb0uU1w2sJtwyjJx852O',NULL,NULL,NULL,1,'2026-05-23 13:43:33.094529','CIUDADANO'); INSERT INTO users VALUES(168,'valeria.ortiz449@celaya.gob.mx','461-219-3290','Valeria Mendoza Ortiz','$2b$12$2jVDS.aSOi/CBYodSkV4pOLjxXAPFykRFGOCAqP4Ih4SopLNaMrzq',NULL,NULL,NULL,1,'2026-05-23 13:43:33.312845','CIUDADANO'); INSERT INTO users VALUES(169,'norma.sanchez450@celaya.gob.mx','461-199-4846','Norma Guzmán Sánchez','$2b$12$Ott04ZbW1N.jfdCJfN8lcOdy3LGI8yKOMwE0Vt5LApveGvWiUClYu',NULL,NULL,NULL,1,'2026-05-23 13:43:33.547819','CIUDADANO'); INSERT INTO users VALUES(170,'pablo.salazar451@celaya.gob.mx','461-529-3531','Pablo Vargas Salazar','$2b$12$IwQBlKdHQzsCvJkB5U.j1OaqRhsWCKyK1oWMJiLp9SmROKZdPUwfu',NULL,NULL,NULL,1,'2026-05-23 13:43:33.771146','CIUDADANO'); INSERT INTO users VALUES(171,'paola.ortiz452@celaya.gob.mx','461-386-1536','Paola Avila Ortiz','$2b$12$2SwGadGV27DJQsvs2eB5k.K2.i8ivxCdVMe2BzR4KL/p3xSUvpVGi',NULL,NULL,NULL,1,'2026-05-23 13:43:33.992652','CIUDADANO'); INSERT INTO users VALUES(172,'ruben.vargas453@celaya.gob.mx','461-201-7018','Rubén Jiménez Vargas','$2b$12$hnrSJ4VE3GdwGg4hpB4siugDEzHTW/es86CROfpyQQjBSQuuHcVra',NULL,NULL,NULL,1,'2026-05-23 13:43:34.205659','CIUDADANO'); INSERT INTO users VALUES(173,'fabiola.castillo454@celaya.gob.mx','461-382-4109','Fabiola Martínez Castillo','$2b$12$cHaDT./a2qKjG2gz6N2rpOjP0Il1AaIh5yOWzzbjDE8igYgmUOPxG',NULL,NULL,NULL,1,'2026-05-23 13:43:34.414958','CIUDADANO'); INSERT INTO users VALUES(174,'valeria.vazquez455@celaya.gob.mx','461-757-1349','Valeria Rodríguez Vázquez','$2b$12$atPf4f8Kqv4xKp2iCy6oNOQlS/3rsVXJtlkzHVL6TCIjkTykGUtNq',NULL,NULL,NULL,1,'2026-05-23 13:43:34.625532','CIUDADANO'); INSERT INTO users VALUES(175,'isabel.cervantes456@celaya.gob.mx','461-310-2124','Isabel Ramírez Cervantes','$2b$12$iKmWaw9KpNxNBhFq4Uf5SeGm03DnevoI0YJr0NoV4ScnNvHxmWr7i',NULL,NULL,NULL,1,'2026-05-23 13:43:34.835530','CIUDADANO'); INSERT INTO users VALUES(176,'lourdes.cruz457@celaya.gob.mx','461-907-1046','Lourdes Castro Cruz','$2b$12$y2tKAQI/fP1mRnXIp9aIje6nry9DQT3Rp6XWpRrKlcv.JWxPwe1Oq',NULL,NULL,NULL,1,'2026-05-23 13:43:35.046534','CIUDADANO'); INSERT INTO users VALUES(177,'adriana.salazar458@celaya.gob.mx','461-356-3858','Adriana Ramírez Salazar','$2b$12$vu0hhMOxsEFuNdI3oLH3dOZhcultS7/zlfSpvQFAMfLKQCfvg6ZD2',NULL,NULL,NULL,1,'2026-05-23 13:43:35.256970','CIUDADANO'); INSERT INTO users VALUES(178,'guadalupe.garcia459@celaya.gob.mx','461-466-4898','Guadalupe Ramírez García','$2b$12$U35o8a2v5QX5PF6ht3prV.yZONP/ZUkh1rNhRm4hHiu3dL7Qlg6e.',NULL,NULL,NULL,1,'2026-05-23 13:43:35.469872','CIUDADANO'); INSERT INTO users VALUES(179,'javier.ramirez460@celaya.gob.mx','461-859-7897','Javier Martínez Ramírez','$2b$12$3Vwpl2ZIwT6fKglYZ4vL4.0A06uHv621JRDt/s5SkUvE17ybBU5Ca',NULL,NULL,NULL,1,'2026-05-23 13:43:35.681445','CIUDADANO'); INSERT INTO users VALUES(180,'luis.rivera461@celaya.gob.mx','461-896-6931','Luis Ramos Rivera','$2b$12$I.AuMk2neSBlJS15q2VRiuIPZDC9cb7HjqxuAU4T7IwBb52jdqbVS',NULL,NULL,NULL,1,'2026-05-23 13:43:35.891900','CIUDADANO'); INSERT INTO users VALUES(181,'sofia.reyes462@celaya.gob.mx','461-729-1710','Sofía Mendez Reyes','$2b$12$.mvMYWR0DYTvF8jIGj2Go.hU5OuXLzdG6PNHKNagHXBVT9HhZVQQG',NULL,NULL,NULL,1,'2026-05-23 13:43:36.103754','CIUDADANO'); INSERT INTO users VALUES(182,'juan.ramos463@celaya.gob.mx','461-967-7580','Juan Martínez Ramos','$2b$12$Q2OUdKCmXYtvJXKsuK3YgOfh6dAXWBmjb/sBpF.qP6cj5uJJX.QUe',NULL,NULL,NULL,1,'2026-05-23 13:43:36.319718','CIUDADANO'); INSERT INTO users VALUES(183,'paola.lopez464@celaya.gob.mx','461-182-6277','Paola Rivera López','$2b$12$pImuIqXCRZZDGMPdKegeouDD9P1DUHV.pqnFHF1fGbosfDDmcX8Ma',NULL,NULL,NULL,1,'2026-05-23 13:43:36.530342','CIUDADANO'); INSERT INTO users VALUES(184,'sergio.dominguez465@celaya.gob.mx','461-661-6327','Sergio Avila Domínguez','$2b$12$oF9HFOZjdaQVozMr6bTUmu4OVtLxmgL1eUUqXXcwc2/EqNyy.VV5e',NULL,NULL,NULL,1,'2026-05-23 13:43:36.741727','CIUDADANO'); INSERT INTO users VALUES(185,'marisol.chavez466@celaya.gob.mx','461-617-8048','Marisol Ruiz Chávez','$2b$12$MiBpYYqy5BpsOlN6G.M8te2H4eHXmwiNykZsa/FV3S4Av5GjSr7g6',NULL,NULL,NULL,1,'2026-05-23 13:43:36.952519','CIUDADANO'); INSERT INTO users VALUES(186,'sandra.vazquez467@celaya.gob.mx','461-540-8398','Sandra Núñez Vázquez','$2b$12$dfrBSd9KI/z7ls8DmG7h8.3vFqWUkwwAwyI.kh1Zl1p3kD6B3WQiO',NULL,NULL,NULL,1,'2026-05-23 13:43:37.163793','CIUDADANO'); INSERT INTO users VALUES(187,'pablo.ortiz468@celaya.gob.mx','461-847-2557','Pablo Castillo Ortiz','$2b$12$Y3eNATOYA.clSYMs4NsBtOKAZuPG2LlyycyF3Y49/xT.D/mkr7Aty',NULL,NULL,NULL,1,'2026-05-23 13:43:37.374943','CIUDADANO'); INSERT INTO users VALUES(188,'javier.cruz469@celaya.gob.mx','461-803-8770','Javier Vargas Cruz','$2b$12$JoBjn3h/i2.y.Ed41YIV5.ACbito1TF3ZGGPisSSexa2TGDmOOlZS',NULL,NULL,NULL,1,'2026-05-23 13:43:37.584825','CIUDADANO'); INSERT INTO users VALUES(189,'miguel.moreno470@celaya.gob.mx','461-198-7105','Miguel Rodríguez Moreno','$2b$12$3clOn4Kci/rNtrDdOpvVtuWsuDej/vxO.IaOGORl0dSr7HS8ItTpS',NULL,NULL,NULL,1,'2026-05-23 13:43:37.796697','CIUDADANO'); INSERT INTO users VALUES(190,'karla.ortiz471@celaya.gob.mx','461-462-7929','Karla Sánchez Ortiz','$2b$12$pjRHBiS4.3dEm2VN1d41F.cEjYAhGKKmyAYLVjD/K8z5R5VVez6Tq',NULL,NULL,NULL,1,'2026-05-23 13:43:38.007468','CIUDADANO'); INSERT INTO users VALUES(191,'norma.perez472@celaya.gob.mx','461-691-9313','Norma Romero Pérez','$2b$12$Kz0id/rcs3elclBCinxQE.43t.Itmfd8OBxvXWl03BsJS6fdHiSd6',NULL,NULL,NULL,1,'2026-05-23 13:43:38.217954','CIUDADANO'); INSERT INTO users VALUES(192,'andres.perez473@celaya.gob.mx','461-458-7022','Andrés Reyes Pérez','$2b$12$482vzm69PJVGjIgvaZ/Zx.Mzd5cwL9N0i1yXgJJmSHXMCTTGNq2hG',NULL,NULL,NULL,1,'2026-05-23 13:43:38.432890','CIUDADANO'); INSERT INTO users VALUES(193,'lourdes.nunez474@celaya.gob.mx','461-885-1430','Lourdes Moreno Núñez','$2b$12$45t3Y0TLVpQe0lNdmD6fGeJ0d/tcCAKmAo2DbVQEU9utqdF4kFtCi',NULL,NULL,NULL,1,'2026-05-23 13:43:38.649008','CIUDADANO'); INSERT INTO users VALUES(194,'sergio.castro475@celaya.gob.mx','461-459-1100','Sergio Mendoza Castro','$2b$12$BNyT19USWrMFveCzoUsSmuj/izLHpbLZsux3J0whz/0ECeqac9XAK',NULL,NULL,NULL,1,'2026-05-23 13:43:38.861551','CIUDADANO'); INSERT INTO users VALUES(195,'elena.cruz476@celaya.gob.mx','461-858-1502','Elena López Cruz','$2b$12$y1OFtz8RHs8uPaB2K.RTHulm1tY7jmmpSUjkGaBaIaTbn0zT/CM5.',NULL,NULL,NULL,1,'2026-05-23 13:43:39.072897','CIUDADANO'); INSERT INTO users VALUES(196,'gabriela.ortiz477@celaya.gob.mx','461-564-6585','Gabriela Herrera Ortiz','$2b$12$JacbdCzfw2Jef.2JG6UIG.PcxYLN3v0xyhyzVHk6.XFsNosrkOaPS',NULL,NULL,NULL,1,'2026-05-23 13:43:39.285093','CIUDADANO'); INSERT INTO users VALUES(197,'rafael.solis478@celaya.gob.mx','461-186-1861','Rafael Cervantes Solís','$2b$12$TXrZ.JKdGZ0xBagZhykgC.lIEtj/4U8lp6018W6F.POft1oFRiqPG',NULL,NULL,NULL,1,'2026-05-23 13:43:39.495758','CIUDADANO'); INSERT INTO users VALUES(198,'carlos.diaz479@celaya.gob.mx','461-553-7947','Carlos Rodríguez Díaz','$2b$12$M.OXnZ6Smt6THFV5PP.4u.4FM7Y8GIcTu7ngBdldJLnfsPicYDGqC',NULL,NULL,NULL,1,'2026-05-23 13:43:39.707716','CIUDADANO'); INSERT INTO users VALUES(199,'beatriz.vazquez480@celaya.gob.mx','461-873-9394','Beatriz Díaz Vázquez','$2b$12$RbgoeiTygJSB3nnjGyy4T.ckKCWzbxHJyLA74audRFuLo50bE.D5m',NULL,NULL,NULL,1,'2026-05-23 13:43:39.922758','CIUDADANO'); INSERT INTO users VALUES(200,'francisco.dominguez481@celaya.gob.mx','461-598-9633','Francisco Ruiz Domínguez','$2b$12$qSr9EsPaz5n/kLWk5uo96.mUyJvzZylfsIQeIs1YuuD32C8pMtbbK',NULL,NULL,NULL,1,'2026-05-23 13:43:40.140045','CIUDADANO'); INSERT INTO users VALUES(201,'ignacio.martinez482@celaya.gob.mx','461-107-4349','Ignacio Solís Martínez','$2b$12$uQKUTe.Q.LaVJuX0trWsE.vHgQxrcZQ0TNJvfJqvh3KThK2d6W/NW',NULL,NULL,NULL,1,'2026-05-23 13:43:40.359650','CIUDADANO'); INSERT INTO users VALUES(202,'veronica.ruiz483@celaya.gob.mx','461-435-2965','Verónica Torres Ruiz','$2b$12$AqrJwzpnRj2lsuGj2MzztO.1ZfMrwgGk36/1ah6vxo.69OUUwU.Qe',NULL,NULL,NULL,1,'2026-05-23 13:43:40.577319','CIUDADANO'); CREATE TABLE addresses ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, label VARCHAR NOT NULL, street VARCHAR NOT NULL, colony VARCHAR, city VARCHAR NOT NULL, lat FLOAT, lng FLOAT, route_id VARCHAR, is_default BOOLEAN, created_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES users (id) ); INSERT INTO addresses VALUES(1,1,'Casa','Hidalgo 612','Ciudad Industrial','Celaya',20.53662131380083266,-100.793739603021038,'RUTA-12',1,'2026-05-23 13:43:40.657961'); INSERT INTO addresses VALUES(2,19,'Local','Av. Las Torres 1012','Sede UG Sur','Celaya',20.55884561652349874,-100.8321090052991166,'RUTA-06',1,'2026-05-23 13:43:40.657965'); INSERT INTO addresses VALUES(3,19,'Trabajo','Constituyentes 333','Los Sauces','Celaya',20.51404212673515204,-100.8412716291850159,'RUTA-14',0,'2026-05-23 13:43:40.657966'); INSERT INTO addresses VALUES(4,19,'Departamento','Aldama 605','Irrigación','Celaya',20.52557264880229226,-100.8281380093087165,'RUTA-11',0,'2026-05-23 13:43:40.657966'); INSERT INTO addresses VALUES(5,20,'Casa de la abuela','Av. Las Torres 672','Rumbos de Roque','Celaya',20.51538725794084784,-100.8399450962523361,'RUTA-14',1,'2026-05-23 13:43:40.657967'); INSERT INTO addresses VALUES(6,21,'Departamento','Lázaro Cárdenas 509','Centro','Celaya',20.53784781201047239,-100.8165938812436621,'RUTA-13',1,'2026-05-23 13:43:40.657967'); INSERT INTO addresses VALUES(7,22,'Departamento','Reforma 1193','Centro','Celaya',20.52896735521806448,-100.7913300567303593,'RUTA-12',1,'2026-05-23 13:43:40.657968'); INSERT INTO addresses VALUES(8,23,'Trabajo','Av. Torres Landa 629','Las Insurgentes','Celaya',20.56292768590422782,-100.8413787566820048,'RUTA-06',1,'2026-05-23 13:43:40.657968'); INSERT INTO addresses VALUES(9,24,'Casa de campo','Benito Juárez 241','Real del Cid','Celaya',20.53023106013947086,-100.8481219858599047,'RUTA-09',1,'2026-05-23 13:43:40.657969'); INSERT INTO addresses VALUES(10,25,'Casa de mis papás','Av. Torres Landa 1241','Insurgentes Norte','Celaya',20.52669128600935266,-100.7926643121780331,'RUTA-12',1,'2026-05-23 13:43:40.657969'); INSERT INTO addresses VALUES(11,26,'Negocio','Galeana 507','Rumbos de Roque','Celaya',20.53012796888283021,-100.8494264947669592,'RUTA-09',1,'2026-05-23 13:43:40.657970'); INSERT INTO addresses VALUES(12,27,'Familia','Madero 127','Vista Hermosa','Celaya',20.52803766125155959,-100.8562189727785352,'RUTA-09',1,'2026-05-23 13:43:40.657970'); INSERT INTO addresses VALUES(13,27,'Departamento','Niños Héroes 1066','Camino Real','Celaya',20.53022701674227691,-100.7925014761861747,'RUTA-12',0,'2026-05-23 13:43:40.657971'); INSERT INTO addresses VALUES(14,28,'Local','Av. Torres Landa 114','Los Sauces','Celaya',20.53166917966180449,-100.7891117203316895,'RUTA-04',1,'2026-05-23 13:43:40.657971'); INSERT INTO addresses VALUES(15,29,'Oficina','Vicente Guerrero 632','Las Arboledas','Celaya',20.54456798475711921,-100.7994226321906694,'RUTA-13',1,'2026-05-23 13:43:40.657971'); INSERT INTO addresses VALUES(16,30,'Trabajo','Juárez 868','La Aurora','Celaya',20.50903015471590863,-100.8418209869132625,'RUTA-14',1,'2026-05-23 13:43:40.657972'); INSERT INTO addresses VALUES(17,31,'Trabajo','Lázaro Cárdenas 967','San Juanico','Celaya',20.53094123660476811,-100.8476541720111613,'RUTA-09',1,'2026-05-23 13:43:40.657972'); INSERT INTO addresses VALUES(18,31,'Casa de la abuela','Insurgentes 784','Camino Real','Celaya',20.50108866935819307,-100.8323102793741555,'RUTA-05',0,'2026-05-23 13:43:40.657973'); INSERT INTO addresses VALUES(19,32,'Local','Allende 1339','La Aurora','Celaya',20.53777496349630383,-100.8521975000737001,'RUTA-15',1,'2026-05-23 13:43:40.657973'); INSERT INTO addresses VALUES(20,32,'Local','Allende 1491','San José de Celaya','Celaya',20.53778473629004254,-100.8126274151360207,'RUTA-13',0,'2026-05-23 13:43:40.657974'); INSERT INTO addresses VALUES(21,32,'Casa de campo','Av. Torres Landa 1380','Villas de la Hacienda','Celaya',20.50903473294944845,-100.8437726467267765,'RUTA-14',0,'2026-05-23 13:43:40.657974'); INSERT INTO addresses VALUES(22,33,'Casa de mis papás','16 de Septiembre 387','Hospital General','Celaya',20.51129664066787938,-100.8393937472145154,'RUTA-14',1,'2026-05-23 13:43:40.657975'); INSERT INTO addresses VALUES(23,33,'Casa','5 de Mayo 423','Rancho Seco','Celaya',20.52459478183539333,-100.8150075940150857,'RUTA-01',0,'2026-05-23 13:43:40.657975'); INSERT INTO addresses VALUES(24,34,'Casa','5 de Mayo 91','San Isidro','Celaya',20.52096441066248645,-100.8124797636312734,'RUTA-01',1,'2026-05-23 13:43:40.657976'); INSERT INTO addresses VALUES(25,35,'Casa','Allende 1032','Real del Cid','Celaya',20.52317269210177386,-100.8483626975733075,'RUTA-09',1,'2026-05-23 13:43:40.657976'); INSERT INTO addresses VALUES(26,36,'Familia','Galeana 1378','Villas del Mineral','Celaya',20.54131517483116199,-100.8498109630363046,'RUTA-15',1,'2026-05-23 13:43:40.657977'); INSERT INTO addresses VALUES(27,37,'Negocio','Av. Tecnológico 616','Las Hadas','Celaya',20.53543260434163643,-100.8463978757618946,'RUTA-03',1,'2026-05-23 13:43:40.657977'); INSERT INTO addresses VALUES(28,38,'Casa de la abuela','Av. Juan Pablo II 1016','Los Olivos','Celaya',20.50279713890963862,-100.8348842233437921,'RUTA-05',1,'2026-05-23 13:43:40.657977'); INSERT INTO addresses VALUES(29,39,'Departamento','Benito Juárez 853','La Esperanza','Celaya',20.52971342524745424,-100.8221419540401911,'RUTA-11',1,'2026-05-23 13:43:40.657978'); INSERT INTO addresses VALUES(30,39,'Local','Av. Irrigación 494','San José de Celaya','Celaya',20.52699888494435499,-100.8351612102125187,'RUTA-11',0,'2026-05-23 13:43:40.657978'); INSERT INTO addresses VALUES(31,39,'Oficina','Lázaro Cárdenas 119','La Esperanza','Celaya',20.50557541238572768,-100.8385564825083379,'RUTA-05',0,'2026-05-23 13:43:40.657979'); INSERT INTO addresses VALUES(32,40,'Casa de campo','Independencia 677','Rumbos de Roque','Celaya',20.52629991814002963,-100.8531158095119338,'RUTA-09',1,'2026-05-23 13:43:40.657979'); INSERT INTO addresses VALUES(33,40,'Local','Cuauhtémoc 391','Los Olivos','Celaya',20.53849786825829327,-100.8492892250647799,'RUTA-15',0,'2026-05-23 13:43:40.657980'); INSERT INTO addresses VALUES(34,40,'Casa','Niños Héroes 150','Irrigación','Celaya',20.50077167974961156,-100.8339503055361633,'RUTA-05',0,'2026-05-23 13:43:40.657980'); INSERT INTO addresses VALUES(35,41,'Oficina','Independencia 682','Pueblitos','Celaya',20.50124305239852163,-100.8384114952372669,'RUTA-10',1,'2026-05-23 13:43:40.657981'); INSERT INTO addresses VALUES(36,41,'Trabajo','Cuauhtémoc 981','Tecnológico','Celaya',20.53415333706228551,-100.8436284023679832,'RUTA-03',0,'2026-05-23 13:43:40.657981'); INSERT INTO addresses VALUES(37,42,'Local','Constituyentes 580','Las Plazas','Celaya',20.52904513142977904,-100.7938487354040689,'RUTA-12',1,'2026-05-23 13:43:40.657981'); INSERT INTO addresses VALUES(38,42,'Casa de campo','Insurgentes 1051','Praderas','Celaya',20.52483650127416226,-100.7994074044444801,'RUTA-08',0,'2026-05-23 13:43:40.657982'); INSERT INTO addresses VALUES(39,43,'Departamento','Lázaro Cárdenas 417','Insurgentes Norte','Celaya',20.5468131845684674,-100.8083050957797866,'RUTA-13',1,'2026-05-23 13:43:40.657982'); INSERT INTO addresses VALUES(40,44,'Casa de mis papás','Hidalgo 535','La Esperanza','Celaya',20.52212524727464427,-100.816987259016841,'RUTA-01',1,'2026-05-23 13:43:40.657983'); INSERT INTO addresses VALUES(41,45,'Negocio','Av. Irrigación 1128','Casa Blanca','Celaya',20.52779865285977579,-100.7902016022525942,'RUTA-04',1,'2026-05-23 13:43:40.657983'); INSERT INTO addresses VALUES(42,46,'Oficina','Av. Torres Landa 345','La Aurora','Celaya',20.51388621100533882,-100.8367644205360278,'RUTA-14',1,'2026-05-23 13:43:40.657984'); INSERT INTO addresses VALUES(43,47,'Local','Mariano Escobedo 121','San Juanico','Celaya',20.53246546328725942,-100.8011595222713907,'RUTA-12',1,'2026-05-23 13:43:40.657984'); INSERT INTO addresses VALUES(44,48,'Casa','Av. Tecnológico 282','San José de Celaya','Celaya',20.54545188111200815,-100.8113178445660765,'RUTA-02',1,'2026-05-23 13:43:40.657985'); INSERT INTO addresses VALUES(45,48,'Local','Av. Torres Landa 765','Los Olivos','Celaya',20.54307169563703539,-100.817908585383094,'RUTA-02',0,'2026-05-23 13:43:40.657985'); INSERT INTO addresses VALUES(46,48,'Oficina','Vicente Guerrero 1000','Las Arboledas','Celaya',20.50037728591760455,-100.8346609627890161,'RUTA-05',0,'2026-05-23 13:43:40.657985'); INSERT INTO addresses VALUES(47,49,'Casa de campo','Av. Juan Pablo II 588','Las Arboledas','Celaya',20.5251133850821752,-100.856832738523977,'RUTA-09',1,'2026-05-23 13:43:40.657986'); INSERT INTO addresses VALUES(48,50,'Casa de mis papás','Madero 198','Torres Landa','Celaya',20.53374032952119065,-100.7949383230105269,'RUTA-12',1,'2026-05-23 13:43:40.657986'); INSERT INTO addresses VALUES(49,50,'Departamento','16 de Septiembre 813','Rumbos de Roque','Celaya',20.52641932056991437,-100.7887354401459987,'RUTA-04',0,'2026-05-23 13:43:40.657987'); INSERT INTO addresses VALUES(50,51,'Negocio','Reforma 1401','Rumbos de Roque','Celaya',20.54458997745551229,-100.797567921058075,'RUTA-07',1,'2026-05-23 13:43:40.657987'); INSERT INTO addresses VALUES(51,52,'Casa de la abuela','Av. del Trabajo 773','Jardines','Celaya',20.51549894451794031,-100.8436831549634433,'RUTA-14',1,'2026-05-23 13:43:40.657988'); INSERT INTO addresses VALUES(52,52,'Trabajo','Av. Irrigación 889','Casa Blanca','Celaya',20.52286748075555778,-100.8121715484998048,'RUTA-01',0,'2026-05-23 13:43:40.657988'); INSERT INTO addresses VALUES(53,53,'Casa','5 de Mayo 433','Jardines','Celaya',20.51873839745636019,-100.8350520878785659,'RUTA-08',1,'2026-05-23 13:43:40.657989'); INSERT INTO addresses VALUES(54,53,'Casa de campo','Emiliano Zapata 1113','San Juanico','Celaya',20.49746561970741609,-100.8392565194007346,'RUTA-10',0,'2026-05-23 13:43:40.657989'); INSERT INTO addresses VALUES(55,54,'Familia','Allende 1460','San Isidro','Celaya',20.5121448469322658,-100.8343853081012327,'RUTA-14',1,'2026-05-23 13:43:40.657989'); INSERT INTO addresses VALUES(56,55,'Casa de la abuela','Vicente Guerrero 1108','Casa Blanca','Celaya',20.49862450250714474,-100.8375952780569519,'RUTA-10',1,'2026-05-23 13:43:40.657990'); INSERT INTO addresses VALUES(57,55,'Trabajo','Av. Las Torres 709','Los Olivos','Celaya',20.547556092645209,-100.798600494057652,'RUTA-13',0,'2026-05-23 13:43:40.657990'); INSERT INTO addresses VALUES(58,55,'Departamento','Calzada de los Olivos 1258','San Isidro','Celaya',20.54037088252843545,-100.8096132534238762,'RUTA-13',0,'2026-05-23 13:43:40.657991'); INSERT INTO addresses VALUES(59,56,'Oficina','Av. Irrigación 468','La Aurora','Celaya',20.55629625658945159,-100.8392667297137138,'RUTA-06',1,'2026-05-23 13:43:40.657991'); INSERT INTO addresses VALUES(60,56,'Familia','Vicente Guerrero 779','Rumbos de Roque','Celaya',20.53041142844970679,-100.8526815205376152,'RUTA-09',0,'2026-05-23 13:43:40.657992'); INSERT INTO addresses VALUES(61,56,'Trabajo','Morelos 549','Torres Landa','Celaya',20.54318615890259991,-100.8050194482619731,'RUTA-13',0,'2026-05-23 13:43:40.657992'); INSERT INTO addresses VALUES(62,57,'Departamento','Insurgentes 219','Rumbos de Roque','Celaya',20.5433390088196326,-100.8056034471102436,'RUTA-13',1,'2026-05-23 13:43:40.657993'); INSERT INTO addresses VALUES(63,58,'Trabajo','Allende 179','Trojes','Celaya',20.50144735864996192,-100.8323865350879771,'RUTA-05',1,'2026-05-23 13:43:40.657993'); INSERT INTO addresses VALUES(64,59,'Casa','Morelos 725','Rumbos de Roque','Celaya',20.52654740000608768,-100.8529195582491695,'RUTA-09',1,'2026-05-23 13:43:40.657994'); INSERT INTO addresses VALUES(65,60,'Casa de campo','Av. Tecnológico 795','Rumbos de Roque','Celaya',20.5402443033057267,-100.809147620826053,'RUTA-13',1,'2026-05-23 13:43:40.657994'); INSERT INTO addresses VALUES(66,60,'Negocio','Av. Universidad 1068','Las Insurgentes','Celaya',20.53601136044856546,-100.7939479242568695,'RUTA-12',0,'2026-05-23 13:43:40.657994'); INSERT INTO addresses VALUES(67,61,'Oficina','Allende 130','Las Insurgentes','Celaya',20.52538840058959479,-100.833988687346249,'RUTA-11',1,'2026-05-23 13:43:40.657995'); INSERT INTO addresses VALUES(68,61,'Trabajo','Insurgentes 516','Tecnológico','Celaya',20.54275961871602619,-100.7970024774607793,'RUTA-07',0,'2026-05-23 13:43:40.657995'); INSERT INTO addresses VALUES(69,62,'Trabajo','Allende 624','Centro','Celaya',20.52543806398039195,-100.801044517751194,'RUTA-04',1,'2026-05-23 13:43:40.657996'); INSERT INTO addresses VALUES(70,62,'Departamento','Av. Torres Landa 686','Villas de la Hacienda','Celaya',20.54332217215311829,-100.7937980781212559,'RUTA-07',0,'2026-05-23 13:43:40.657996'); INSERT INTO addresses VALUES(71,63,'Casa de campo','Constituyentes 1236','Irrigación','Celaya',20.51551036858366572,-100.8380560708093582,'RUTA-14',1,'2026-05-23 13:43:40.657997'); INSERT INTO addresses VALUES(72,63,'Departamento','Reforma 1424','Praderas','Celaya',20.52264183281195286,-100.7933542537690527,'RUTA-08',0,'2026-05-23 13:43:40.657997'); INSERT INTO addresses VALUES(73,64,'Casa de la abuela','Insurgentes 234','Irrigación','Celaya',20.539424242967808,-100.8092394469767612,'RUTA-13',1,'2026-05-23 13:43:40.657998'); INSERT INTO addresses VALUES(74,64,'Local','Hidalgo 1490','Los Sauces','Celaya',20.50397264925730311,-100.8422007278739159,'RUTA-10',0,'2026-05-23 13:43:40.657998'); INSERT INTO addresses VALUES(75,64,'Trabajo','Pino Suárez 838','Praderas','Celaya',20.52909648396361319,-100.7950231447896812,'RUTA-12',0,'2026-05-23 13:43:40.657999'); INSERT INTO addresses VALUES(76,65,'Casa de la abuela','Aldama 773','Rancho Seco','Celaya',20.49942021167670703,-100.8334133703146734,'RUTA-05',1,'2026-05-23 13:43:40.657999'); INSERT INTO addresses VALUES(77,66,'Local','Lázaro Cárdenas 1417','La Esperanza','Celaya',20.49879234699772467,-100.839991949026711,'RUTA-10',1,'2026-05-23 13:43:40.657999'); INSERT INTO addresses VALUES(78,67,'Local','Calzada de los Olivos 1307','Rumbos de Roque','Celaya',20.54668428040739414,-100.8059836571294455,'RUTA-13',1,'2026-05-23 13:43:40.658000'); INSERT INTO addresses VALUES(79,67,'Departamento','Zaragoza 1326','San Juanico','Celaya',20.5436895404791997,-100.8114239835541923,'RUTA-02',0,'2026-05-23 13:43:40.658000'); INSERT INTO addresses VALUES(80,68,'Departamento','Aldama 882','Ciudad Industrial','Celaya',20.52977471895864169,-100.826003822537757,'RUTA-11',1,'2026-05-23 13:43:40.658008'); INSERT INTO addresses VALUES(81,68,'Local','Av. Juan Pablo II 1189','San José de Celaya','Celaya',20.51748606558581756,-100.8169799892045119,'RUTA-01',0,'2026-05-23 13:43:40.658008'); INSERT INTO addresses VALUES(82,69,'Local','Allende 707','Las Arboledas','Celaya',20.54463063208552854,-100.7932044451245304,'RUTA-07',1,'2026-05-23 13:43:40.658009'); INSERT INTO addresses VALUES(83,70,'Trabajo','Pino Suárez 1496','Torres Landa','Celaya',20.50115975428525772,-100.8303827213431986,'RUTA-10',1,'2026-05-23 13:43:40.658009'); INSERT INTO addresses VALUES(84,71,'Oficina','Insurgentes 976','Ciudad Industrial','Celaya',20.56055332635225951,-100.8399313267379255,'RUTA-06',1,'2026-05-23 13:43:40.658009'); INSERT INTO addresses VALUES(85,72,'Casa','Aldama 1456','Hospital General','Celaya',20.53152447193256692,-100.8023282565995941,'RUTA-12',1,'2026-05-23 13:43:40.658010'); INSERT INTO addresses VALUES(86,73,'Casa de mis papás','Lázaro Cárdenas 500','Trojes','Celaya',20.5624796991727763,-100.8352286066710945,'RUTA-06',1,'2026-05-23 13:43:40.658010'); INSERT INTO addresses VALUES(87,74,'Negocio','Aldama 830','Trojes','Celaya',20.56159848952489711,-100.8324153737826663,'RUTA-06',1,'2026-05-23 13:43:40.658011'); INSERT INTO addresses VALUES(88,74,'Casa','Cuauhtémoc 1258','Irrigación','Celaya',20.53040478876659947,-100.8326786554757035,'RUTA-03',0,'2026-05-23 13:43:40.658011'); INSERT INTO addresses VALUES(89,75,'Negocio','16 de Septiembre 1442','Rancho Seco','Celaya',20.54388835780356005,-100.7929526438404083,'RUTA-07',1,'2026-05-23 13:43:40.658012'); INSERT INTO addresses VALUES(90,76,'Departamento','Independencia 938','Hospital General','Celaya',20.54571979330010123,-100.8111304016436805,'RUTA-02',1,'2026-05-23 13:43:40.658012'); INSERT INTO addresses VALUES(91,76,'Departamento','Calzada de los Olivos 796','San Isidro','Celaya',20.50370701428224152,-100.8351051602119384,'RUTA-05',0,'2026-05-23 13:43:40.658013'); INSERT INTO addresses VALUES(92,77,'Casa de mis papás','Pino Suárez 1380','Pueblitos','Celaya',20.55951984924417176,-100.8374213941382322,'RUTA-06',1,'2026-05-23 13:43:40.658013'); INSERT INTO addresses VALUES(93,77,'Casa de mis papás','Constituyentes 242','Tecnológico','Celaya',20.5401448451571298,-100.8521524803137624,'RUTA-15',0,'2026-05-23 13:43:40.658013'); INSERT INTO addresses VALUES(94,78,'Casa de la abuela','Av. Tecnológico 1222','Sede UG Sur','Celaya',20.52773306070964309,-100.8355864145673167,'RUTA-03',1,'2026-05-23 13:43:40.658014'); INSERT INTO addresses VALUES(95,79,'Casa de mis papás','Av. Juan Pablo II 342','Praderas','Celaya',20.54185753699292861,-100.7936449835794122,'RUTA-07',1,'2026-05-23 13:43:40.658014'); INSERT INTO addresses VALUES(96,79,'Oficina','Calzada de los Olivos 110','La Aurora','Celaya',20.4984029653509765,-100.8368541998533913,'RUTA-10',0,'2026-05-23 13:43:40.658015'); INSERT INTO addresses VALUES(97,80,'Local','Av. Las Torres 1338','Praderas','Celaya',20.52086534714662491,-100.7948478405934622,'RUTA-08',1,'2026-05-23 13:43:40.658015'); INSERT INTO addresses VALUES(98,80,'Oficina','Av. Irrigación 343','Rumbos de Roque','Celaya',20.54684696670560129,-100.7958436956472638,'RUTA-07',0,'2026-05-23 13:43:40.658016'); INSERT INTO addresses VALUES(99,80,'Casa de campo','Juárez 563','San José de Celaya','Celaya',20.49430860705642842,-100.8363894338145456,'RUTA-10',0,'2026-05-23 13:43:40.658016'); INSERT INTO addresses VALUES(100,81,'Oficina','Av. Juan Pablo II 1047','Hospital General','Celaya',20.53180740197429798,-100.8313434953881397,'RUTA-03',1,'2026-05-23 13:43:40.658017'); INSERT INTO addresses VALUES(101,81,'Departamento','Av. Juan Pablo II 86','Camino Real','Celaya',20.49514206651358706,-100.8362488697213592,'RUTA-10',0,'2026-05-23 13:43:40.658017'); INSERT INTO addresses VALUES(102,82,'Negocio','Reforma 67','Camino Real','Celaya',20.54102416438877655,-100.7916992928345791,'RUTA-07',1,'2026-05-23 13:43:40.658017'); INSERT INTO addresses VALUES(103,82,'Oficina','Niños Héroes 241','Tecnológico','Celaya',20.5004857697682219,-100.831832714148831,'RUTA-10',0,'2026-05-23 13:43:40.658018'); INSERT INTO addresses VALUES(104,83,'Familia','Mariano Escobedo 877','Las Insurgentes','Celaya',20.53287923896976963,-100.7994936915888644,'RUTA-12',1,'2026-05-23 13:43:40.658018'); INSERT INTO addresses VALUES(105,84,'Casa','Av. Universidad 719','Las Hadas','Celaya',20.53906619656186904,-100.8109305727924863,'RUTA-13',1,'2026-05-23 13:43:40.658019'); INSERT INTO addresses VALUES(106,84,'Casa de campo','Reforma 1173','Las Hadas','Celaya',20.49938768546047641,-100.840763463841455,'RUTA-10',0,'2026-05-23 13:43:40.658019'); INSERT INTO addresses VALUES(107,85,'Trabajo','Allende 843','Los Olivos','Celaya',20.53085488302261652,-100.8502070068407762,'RUTA-09',1,'2026-05-23 13:43:40.658020'); INSERT INTO addresses VALUES(108,85,'Casa de mis papás','5 de Mayo 300','Villas del Mineral','Celaya',20.50567047590433844,-100.8387311183138592,'RUTA-05',0,'2026-05-23 13:43:40.658020'); INSERT INTO addresses VALUES(109,85,'Casa de la abuela','Av. Irrigación 292','Las Hadas','Celaya',20.51147554740022728,-100.8355644434335688,'RUTA-14',0,'2026-05-23 13:43:40.658020'); INSERT INTO addresses VALUES(110,86,'Trabajo','Av. del Trabajo 1056','Las Hadas','Celaya',20.54451991722550374,-100.793663722366503,'RUTA-07',1,'2026-05-23 13:43:40.658021'); INSERT INTO addresses VALUES(111,86,'Oficina','Constituyentes 1192','Centro','Celaya',20.53636336114088579,-100.799309288259252,'RUTA-12',0,'2026-05-23 13:43:40.658021'); INSERT INTO addresses VALUES(112,87,'Oficina','Mariano Escobedo 1361','La Aurora','Celaya',20.51632724026539378,-100.8366906806251251,'RUTA-14',1,'2026-05-23 13:43:40.658022'); INSERT INTO addresses VALUES(113,87,'Negocio','Av. Tecnológico 434','Praderas','Celaya',20.50963330686060005,-100.838655755356129,'RUTA-14',0,'2026-05-23 13:43:40.658022'); INSERT INTO addresses VALUES(114,87,'Local','Av. Universidad 268','Praderas','Celaya',20.50022865149589891,-100.8371640692399609,'RUTA-10',0,'2026-05-23 13:43:40.658023'); INSERT INTO addresses VALUES(115,88,'Trabajo','Mariano Escobedo 942','Las Arboledas','Celaya',20.54082551926093459,-100.8525159073884794,'RUTA-15',1,'2026-05-23 13:43:40.658023'); INSERT INTO addresses VALUES(116,88,'Oficina','Hidalgo 877','Irrigación','Celaya',20.54529432875347439,-100.8164201648502569,'RUTA-02',0,'2026-05-23 13:43:40.658024'); INSERT INTO addresses VALUES(117,89,'Casa de mis papás','Niños Héroes 562','Rumbos de Roque','Celaya',20.53531913087384097,-100.846500028006588,'RUTA-03',1,'2026-05-23 13:43:40.658024'); INSERT INTO addresses VALUES(118,89,'Casa de mis papás','Juárez 812','Pueblitos','Celaya',20.52660435383397087,-100.8291757946929436,'RUTA-03',0,'2026-05-23 13:43:40.658024'); INSERT INTO addresses VALUES(119,89,'Trabajo','Benito Juárez 195','Centro','Celaya',20.53399441371524504,-100.800658561585152,'RUTA-12',0,'2026-05-23 13:43:40.658025'); INSERT INTO addresses VALUES(120,90,'Oficina','Hidalgo 17','Casa Blanca','Celaya',20.53732699792039896,-100.8157380913854126,'RUTA-13',1,'2026-05-23 13:43:40.658025'); INSERT INTO addresses VALUES(121,91,'Trabajo','5 de Mayo 785','Rumbos de Roque','Celaya',20.51322313933775022,-100.8426782484890793,'RUTA-14',1,'2026-05-23 13:43:40.658026'); INSERT INTO addresses VALUES(122,91,'Departamento','Emiliano Zapata 613','Sede UG Sur','Celaya',20.53505956833827639,-100.8019679846679111,'RUTA-07',0,'2026-05-23 13:43:40.658026'); INSERT INTO addresses VALUES(123,92,'Casa de mis papás','Morelos 1087','Centro','Celaya',20.51653157800991067,-100.8426685376881408,'RUTA-14',1,'2026-05-23 13:43:40.658027'); INSERT INTO addresses VALUES(124,93,'Casa de mis papás','Lázaro Cárdenas 844','Camino Real','Celaya',20.52840099420780007,-100.8297756797363434,'RUTA-03',1,'2026-05-23 13:43:40.658027'); INSERT INTO addresses VALUES(125,93,'Casa de mis papás','Galeana 253','Las Plazas','Celaya',20.51117244677891449,-100.8350340705439123,'RUTA-14',0,'2026-05-23 13:43:40.658027'); INSERT INTO addresses VALUES(126,94,'Casa de campo','Mariano Escobedo 173','Tecnológico','Celaya',20.54314503668182468,-100.7986016981119093,'RUTA-13',1,'2026-05-23 13:43:40.658028'); INSERT INTO addresses VALUES(127,95,'Casa','Niños Héroes 1349','Pueblitos','Celaya',20.50121179638859558,-100.8411507918999348,'RUTA-10',1,'2026-05-23 13:43:40.658028'); INSERT INTO addresses VALUES(128,95,'Casa de la abuela','Reforma 1324','Los Olivos','Celaya',20.52967749127797248,-100.7889047743388601,'RUTA-04',0,'2026-05-23 13:43:40.658029'); INSERT INTO addresses VALUES(129,96,'Trabajo','5 de Mayo 1024','Rancho Seco','Celaya',20.54654671511347175,-100.8080511228005775,'RUTA-13',1,'2026-05-23 13:43:40.658029'); INSERT INTO addresses VALUES(130,96,'Departamento','Lázaro Cárdenas 649','Sede UG Sur','Celaya',20.52988724528086805,-100.8568793298760938,'RUTA-15',0,'2026-05-23 13:43:40.658030'); INSERT INTO addresses VALUES(131,97,'Casa de mis papás','Galeana 965','Rancho Seco','Celaya',20.51468380388772772,-100.8403458753715113,'RUTA-14',1,'2026-05-23 13:43:40.658030'); INSERT INTO addresses VALUES(132,98,'Casa','Aldama 816','Vista Hermosa','Celaya',20.53613793425725475,-100.8158425706148336,'RUTA-13',1,'2026-05-23 13:43:40.658031'); INSERT INTO addresses VALUES(133,99,'Casa de la abuela','Morelos 1312','Torres Landa','Celaya',20.53201048965507169,-100.798845680056246,'RUTA-12',1,'2026-05-23 13:43:40.658031'); INSERT INTO addresses VALUES(134,100,'Casa de mis papás','Av. Juan Pablo II 670','San Isidro','Celaya',20.49779021561974801,-100.8307907514122661,'RUTA-10',1,'2026-05-23 13:43:40.658031'); INSERT INTO addresses VALUES(135,101,'Trabajo','Reforma 1431','Villas de la Hacienda','Celaya',20.54534526469184997,-100.8061894431529169,'RUTA-13',1,'2026-05-23 13:43:40.658032'); INSERT INTO addresses VALUES(136,101,'Negocio','Morelos 890','Hospital General','Celaya',20.53653427976716018,-100.8006136261181638,'RUTA-07',0,'2026-05-23 13:43:40.658033'); INSERT INTO addresses VALUES(137,102,'Casa de mis papás','Madero 26','Sede UG Sur','Celaya',20.49455028619686203,-100.8373392042114034,'RUTA-10',1,'2026-05-23 13:43:40.658033'); INSERT INTO addresses VALUES(138,103,'Local','Aldama 1477','Las Américas','Celaya',20.52896412932522807,-100.833532948723203,'RUTA-03',1,'2026-05-23 13:43:40.658034'); INSERT INTO addresses VALUES(139,103,'Casa de campo','Cuauhtémoc 242','Las Arboledas','Celaya',20.52771869430891626,-100.8295022361590582,'RUTA-03',0,'2026-05-23 13:43:40.658034'); INSERT INTO addresses VALUES(140,104,'Familia','Mariano Escobedo 158','Praderas','Celaya',20.54271980595021673,-100.7993612801087693,'RUTA-13',1,'2026-05-23 13:43:40.658035'); INSERT INTO addresses VALUES(141,105,'Casa de mis papás','Insurgentes 323','Las Américas','Celaya',20.55655439110842408,-100.8334064021731251,'RUTA-06',1,'2026-05-23 13:43:40.658035'); INSERT INTO addresses VALUES(142,106,'Negocio','Cuauhtémoc 1043','Centro','Celaya',20.53973912305192329,-100.8457722162667381,'RUTA-15',1,'2026-05-23 13:43:40.658036'); INSERT INTO addresses VALUES(143,106,'Casa','Av. Irrigación 746','Las Plazas','Celaya',20.52508689009122023,-100.8190771192696217,'RUTA-01',0,'2026-05-23 13:43:40.658036'); INSERT INTO addresses VALUES(144,107,'Local','Aldama 1463','La Esperanza','Celaya',20.53331160077157235,-100.8284251480225179,'RUTA-03',1,'2026-05-23 13:43:40.658037'); INSERT INTO addresses VALUES(145,107,'Departamento','16 de Septiembre 160','Insurgentes Norte','Celaya',20.52771802014471802,-100.7898374340149843,'RUTA-04',0,'2026-05-23 13:43:40.658037'); INSERT INTO addresses VALUES(146,107,'Casa de mis papás','5 de Mayo 1057','San Juanico','Celaya',20.54102040942559526,-100.8089805899074207,'RUTA-13',0,'2026-05-23 13:43:40.658038'); INSERT INTO addresses VALUES(147,108,'Casa de campo','Constituyentes 177','Los Sauces','Celaya',20.5447699123818488,-100.8093396777002368,'RUTA-13',1,'2026-05-23 13:43:40.658038'); INSERT INTO addresses VALUES(148,108,'Casa de campo','Cuauhtémoc 1276','Tecnológico','Celaya',20.5201891935915235,-100.81628404909344,'RUTA-01',0,'2026-05-23 13:43:40.658039'); INSERT INTO addresses VALUES(149,108,'Negocio','Cuauhtémoc 1120','Tecnológico','Celaya',20.52318273627696143,-100.793281422548489,'RUTA-08',0,'2026-05-23 13:43:40.658039'); INSERT INTO addresses VALUES(150,109,'Departamento','Mariano Escobedo 1421','Centro','Celaya',20.53810036109566184,-100.8506700225813973,'RUTA-15',1,'2026-05-23 13:43:40.658040'); INSERT INTO addresses VALUES(151,110,'Casa de campo','Madero 421','Tecnológico','Celaya',20.52408929153213534,-100.8154372516953145,'RUTA-01',1,'2026-05-23 13:43:40.658040'); INSERT INTO addresses VALUES(152,110,'Casa de mis papás','Benito Juárez 574','Rumbos de Roque','Celaya',20.54492028876850184,-100.7994010492434711,'RUTA-13',0,'2026-05-23 13:43:40.658041'); INSERT INTO addresses VALUES(153,110,'Local','Av. Tecnológico 1436','Insurgentes Norte','Celaya',20.52571274402972179,-100.8102271252806901,'RUTA-12',0,'2026-05-23 13:43:40.658042'); INSERT INTO addresses VALUES(154,111,'Casa de mis papás','Mariano Escobedo 808','Rancho Seco','Celaya',20.52784902417516478,-100.8020442299466311,'RUTA-12',1,'2026-05-23 13:43:40.658042'); INSERT INTO addresses VALUES(155,112,'Negocio','Reforma 535','Villas del Mineral','Celaya',20.52084982878434972,-100.8095578172526672,'RUTA-01',1,'2026-05-23 13:43:40.658043'); INSERT INTO addresses VALUES(156,112,'Departamento','Constituyentes 928','Las Hadas','Celaya',20.54200816821999708,-100.8459927439367903,'RUTA-15',0,'2026-05-23 13:43:40.658043'); INSERT INTO addresses VALUES(157,113,'Trabajo','Allende 217','Las Insurgentes','Celaya',20.52586111846416727,-100.7862985337984014,'RUTA-04',1,'2026-05-23 13:43:40.658044'); INSERT INTO addresses VALUES(158,114,'Negocio','Av. Torres Landa 632','Los Sauces','Celaya',20.56006512551909182,-100.8366407545091051,'RUTA-06',1,'2026-05-23 13:43:40.658044'); INSERT INTO addresses VALUES(159,115,'Casa de campo','Pino Suárez 1444','San Juanico','Celaya',20.53690420888048607,-100.8099240309531979,'RUTA-13',1,'2026-05-23 13:43:40.658045'); INSERT INTO addresses VALUES(160,116,'Negocio','Insurgentes 812','Vista Hermosa','Celaya',20.51227793658884835,-100.8430878709620799,'RUTA-14',1,'2026-05-23 13:43:40.658045'); INSERT INTO addresses VALUES(161,117,'Casa','Av. del Trabajo 927','Tecnológico','Celaya',20.49960166792721238,-100.830093233795921,'RUTA-10',1,'2026-05-23 13:43:40.658046'); INSERT INTO addresses VALUES(162,118,'Casa','Juárez 456','Sede UG Sur','Celaya',20.54403896753444059,-100.8166020696072706,'RUTA-02',1,'2026-05-23 13:43:40.658046'); INSERT INTO addresses VALUES(163,119,'Trabajo','Av. Universidad 1201','Las Américas','Celaya',20.54372239743816308,-100.7936970245139605,'RUTA-07',1,'2026-05-23 13:43:40.658047'); INSERT INTO addresses VALUES(164,120,'Oficina','Aldama 264','Rumbos de Roque','Celaya',20.53621800182738611,-100.8173552796395284,'RUTA-13',1,'2026-05-23 13:43:40.658047'); INSERT INTO addresses VALUES(165,120,'Trabajo','Juárez 945','Los Olivos','Celaya',20.54247275434653375,-100.8449111279151111,'RUTA-15',0,'2026-05-23 13:43:40.658048'); INSERT INTO addresses VALUES(166,120,'Casa de la abuela','Av. Irrigación 61','Las Plazas','Celaya',20.53324131725533875,-100.8326684362276069,'RUTA-03',0,'2026-05-23 13:43:40.658048'); INSERT INTO addresses VALUES(167,121,'Casa de campo','16 de Septiembre 914','Torres Landa','Celaya',20.52753943252672997,-100.8279169578412677,'RUTA-11',1,'2026-05-23 13:43:40.658049'); INSERT INTO addresses VALUES(168,121,'Casa de campo','Av. Irrigación 844','Jardines','Celaya',20.52264106577777625,-100.8130302283550889,'RUTA-01',0,'2026-05-23 13:43:40.658049'); INSERT INTO addresses VALUES(169,122,'Local','5 de Mayo 1292','Las Arboledas','Celaya',20.50083015276024057,-100.8358076517880307,'RUTA-05',1,'2026-05-23 13:43:40.658050'); INSERT INTO addresses VALUES(170,123,'Oficina','Insurgentes 1159','Vista Hermosa','Celaya',20.54413370668583738,-100.8082031556111246,'RUTA-13',1,'2026-05-23 13:43:40.658050'); INSERT INTO addresses VALUES(171,123,'Departamento','Calzada de los Olivos 449','Las Arboledas','Celaya',20.55988381274569221,-100.8402018412630242,'RUTA-06',0,'2026-05-23 13:43:40.658051'); INSERT INTO addresses VALUES(172,123,'Oficina','Av. Las Torres 733','San José de Celaya','Celaya',20.54210689365704212,-100.8501906733469156,'RUTA-15',0,'2026-05-23 13:43:40.658051'); INSERT INTO addresses VALUES(173,124,'Local','Pino Suárez 115','San José de Celaya','Celaya',20.5384785705400148,-100.8155884720484608,'RUTA-02',1,'2026-05-23 13:43:40.658052'); INSERT INTO addresses VALUES(174,124,'Departamento','Lázaro Cárdenas 356','Trojes','Celaya',20.50246505090465022,-100.8360260931262076,'RUTA-05',0,'2026-05-23 13:43:40.658052'); INSERT INTO addresses VALUES(175,124,'Departamento','Lázaro Cárdenas 1212','Las Arboledas','Celaya',20.53042519509181218,-100.7859378977464075,'RUTA-04',0,'2026-05-23 13:43:40.658053'); INSERT INTO addresses VALUES(176,125,'Familia','Independencia 1009','Pueblitos','Celaya',20.56547558735070069,-100.8363639351321695,'RUTA-06',1,'2026-05-23 13:43:40.658054'); INSERT INTO addresses VALUES(177,125,'Negocio','Calzada de los Olivos 449','Las Arboledas','Celaya',20.5289043642012743,-100.8360974262314897,'RUTA-03',0,'2026-05-23 13:43:40.658054'); INSERT INTO addresses VALUES(178,126,'Casa de mis papás','Constituyentes 1469','Trojes','Celaya',20.51981733993574152,-100.8130586523233774,'RUTA-01',1,'2026-05-23 13:43:40.658055'); INSERT INTO addresses VALUES(179,126,'Casa','Hidalgo 303','Torres Landa','Celaya',20.54202424444588359,-100.8443178290185642,'RUTA-15',0,'2026-05-23 13:43:40.658055'); INSERT INTO addresses VALUES(180,127,'Trabajo','Insurgentes 1443','San Isidro','Celaya',20.5142629487857704,-100.8403511014759175,'RUTA-14',1,'2026-05-23 13:43:40.658056'); INSERT INTO addresses VALUES(181,127,'Casa de mis papás','Zaragoza 1500','Villas de la Hacienda','Celaya',20.49501032170180537,-100.8409823484627453,'RUTA-10',0,'2026-05-23 13:43:40.658056'); INSERT INTO addresses VALUES(182,128,'Local','Benito Juárez 1257','La Aurora','Celaya',20.52599180265644918,-100.801257973290447,'RUTA-04',1,'2026-05-23 13:43:40.658057'); INSERT INTO addresses VALUES(183,128,'Casa de la abuela','Reforma 1411','Real del Cid','Celaya',20.53115531669474692,-100.7858554576355771,'RUTA-04',0,'2026-05-23 13:43:40.658057'); INSERT INTO addresses VALUES(184,129,'Familia','Av. del Trabajo 1163','San Juanico','Celaya',20.52701797906672709,-100.7959799155184157,'RUTA-08',1,'2026-05-23 13:43:40.658058'); INSERT INTO addresses VALUES(185,130,'Negocio','Mariano Escobedo 1159','Ciudad Industrial','Celaya',20.56521038216418162,-100.8323246831438382,'RUTA-06',1,'2026-05-23 13:43:40.658058'); INSERT INTO addresses VALUES(186,131,'Departamento','Constituyentes 344','Rumbos de Roque','Celaya',20.52731168426166164,-100.8362219336153486,'RUTA-11',1,'2026-05-23 13:43:40.658059'); INSERT INTO addresses VALUES(187,131,'Departamento','Av. Torres Landa 24','Las Américas','Celaya',20.51608965813145247,-100.8376089731209503,'RUTA-14',0,'2026-05-23 13:43:40.658059'); INSERT INTO addresses VALUES(188,131,'Casa de campo','Aldama 222','Centro','Celaya',20.52699540863135041,-100.7933220521993576,'RUTA-12',0,'2026-05-23 13:43:40.658060'); INSERT INTO addresses VALUES(189,132,'Casa de la abuela','Av. Irrigación 776','La Aurora','Celaya',20.52682584494498741,-100.7933089817489503,'RUTA-12',1,'2026-05-23 13:43:40.658060'); INSERT INTO addresses VALUES(190,133,'Familia','Mariano Escobedo 1408','San José de Celaya','Celaya',20.54428806977566425,-100.8101127000552424,'RUTA-02',1,'2026-05-23 13:43:40.658060'); INSERT INTO addresses VALUES(191,133,'Casa','Reforma 42','Villas del Mineral','Celaya',20.52851287419153082,-100.8290080543424239,'RUTA-03',0,'2026-05-23 13:43:40.658061'); INSERT INTO addresses VALUES(192,134,'Casa de la abuela','Zaragoza 1500','Rancho Seco','Celaya',20.53674200401766826,-100.816298947968491,'RUTA-13',1,'2026-05-23 13:43:40.658061'); INSERT INTO addresses VALUES(193,135,'Familia','Emiliano Zapata 989','Las Arboledas','Celaya',20.54378041522898712,-100.84962049415752,'RUTA-15',1,'2026-05-23 13:43:40.658062'); INSERT INTO addresses VALUES(194,135,'Casa de la abuela','Zaragoza 110','Ciudad Industrial','Celaya',20.54942442258102275,-100.7983500280523827,'RUTA-13',0,'2026-05-23 13:43:40.658062'); INSERT INTO addresses VALUES(195,136,'Local','16 de Septiembre 1353','Real del Cid','Celaya',20.52859279865750607,-100.7884588756768381,'RUTA-04',1,'2026-05-23 13:43:40.658063'); INSERT INTO addresses VALUES(196,137,'Oficina','Allende 112','Insurgentes Norte','Celaya',20.53649635443038691,-100.8122823019214281,'RUTA-13',1,'2026-05-23 13:43:40.658063'); INSERT INTO addresses VALUES(197,138,'Familia','Av. Irrigación 409','Ciudad Industrial','Celaya',20.53894549448966345,-100.8113797977399031,'RUTA-13',1,'2026-05-23 13:43:40.658064'); INSERT INTO addresses VALUES(198,139,'Oficina','Niños Héroes 237','Pueblitos','Celaya',20.53038190659074402,-100.8272294230399951,'RUTA-11',1,'2026-05-23 13:43:40.658064'); INSERT INTO addresses VALUES(199,140,'Trabajo','Mariano Escobedo 1115','Las Plazas','Celaya',20.52439096812120666,-100.7963895994525388,'RUTA-08',1,'2026-05-23 13:43:40.658064'); INSERT INTO addresses VALUES(200,140,'Casa de mis papás','Av. Torres Landa 92','Las Américas','Celaya',20.5277102052484075,-100.8331855481289666,'RUTA-03',0,'2026-05-23 13:43:40.658065'); INSERT INTO addresses VALUES(201,141,'Casa','Allende 1427','Ciudad Industrial','Celaya',20.49926242280282552,-100.8373143800672693,'RUTA-10',1,'2026-05-23 13:43:40.658065'); INSERT INTO addresses VALUES(202,142,'Familia','5 de Mayo 1134','Los Olivos','Celaya',20.56408180157404076,-100.8378601334712954,'RUTA-06',1,'2026-05-23 13:43:40.658066'); INSERT INTO addresses VALUES(203,143,'Oficina','Av. Universidad 483','Jardines','Celaya',20.51422582273324124,-100.83434372295919,'RUTA-14',1,'2026-05-23 13:43:40.658066'); INSERT INTO addresses VALUES(204,143,'Casa','Av. Las Torres 1170','Torres Landa','Celaya',20.49778955049773898,-100.8309722279866066,'RUTA-10',0,'2026-05-23 13:43:40.658067'); INSERT INTO addresses VALUES(205,143,'Casa de mis papás','Independencia 395','Sede UG Sur','Celaya',20.54549254816451765,-100.8135096026381205,'RUTA-02',0,'2026-05-23 13:43:40.658067'); INSERT INTO addresses VALUES(206,144,'Casa de mis papás','Pino Suárez 1219','Las Américas','Celaya',20.54588279936336903,-100.8136460675446812,'RUTA-02',1,'2026-05-23 13:43:40.658068'); INSERT INTO addresses VALUES(207,145,'Casa de la abuela','Av. Juan Pablo II 814','Villas del Mineral','Celaya',20.53614173936898623,-100.8023298804695145,'RUTA-07',1,'2026-05-23 13:43:40.658068'); INSERT INTO addresses VALUES(208,146,'Familia','Av. Universidad 1071','La Esperanza','Celaya',20.52558157181122666,-100.8482653374662732,'RUTA-09',1,'2026-05-23 13:43:40.658068'); INSERT INTO addresses VALUES(209,146,'Familia','Av. Universidad 206','Ciudad Industrial','Celaya',20.54014442398769092,-100.8165180025870739,'RUTA-02',0,'2026-05-23 13:43:40.658069'); INSERT INTO addresses VALUES(210,146,'Local','Emiliano Zapata 705','La Esperanza','Celaya',20.50179544696964129,-100.8361425436969086,'RUTA-05',0,'2026-05-23 13:43:40.658069'); INSERT INTO addresses VALUES(211,147,'Casa','Zaragoza 565','San Isidro','Celaya',20.52785584792286145,-100.8239103784804768,'RUTA-11',1,'2026-05-23 13:43:40.658070'); INSERT INTO addresses VALUES(212,148,'Casa de la abuela','Emiliano Zapata 679','Tecnológico','Celaya',20.50080812863212998,-100.8399828010172569,'RUTA-10',1,'2026-05-23 13:43:40.658070'); INSERT INTO addresses VALUES(213,149,'Casa','Constituyentes 621','Pueblitos','Celaya',20.5287083498290599,-100.794029686378508,'RUTA-12',1,'2026-05-23 13:43:40.658071'); INSERT INTO addresses VALUES(214,150,'Negocio','Allende 616','Camino Real','Celaya',20.52808234783233488,-100.7961514797286498,'RUTA-08',1,'2026-05-23 13:43:40.658071'); INSERT INTO addresses VALUES(215,151,'Trabajo','Independencia 905','La Toscana','Celaya',20.55869419981008761,-100.8378322727229488,'RUTA-06',1,'2026-05-23 13:43:40.658072'); INSERT INTO addresses VALUES(216,151,'Local','Niños Héroes 766','Los Olivos','Celaya',20.54223969434255181,-100.8455905520108046,'RUTA-15',0,'2026-05-23 13:43:40.658072'); INSERT INTO addresses VALUES(217,152,'Casa de la abuela','Allende 1074','Las Arboledas','Celaya',20.5246561696761205,-100.8299043060163456,'RUTA-03',1,'2026-05-23 13:43:40.658073'); INSERT INTO addresses VALUES(218,152,'Casa','5 de Mayo 68','Los Sauces','Celaya',20.52592763446831725,-100.8286707006692212,'RUTA-11',0,'2026-05-23 13:43:40.658073'); INSERT INTO addresses VALUES(219,153,'Oficina','Av. Las Torres 813','Hospital General','Celaya',20.56304633945219961,-100.8392602250152664,'RUTA-06',1,'2026-05-23 13:43:40.658074'); INSERT INTO addresses VALUES(220,154,'Casa de mis papás','Niños Héroes 972','La Aurora','Celaya',20.52822466761535126,-100.7880595640654775,'RUTA-04',1,'2026-05-23 13:43:40.658074'); INSERT INTO addresses VALUES(221,154,'Trabajo','Reforma 57','Las Plazas','Celaya',20.5576351361451799,-100.8330550807968819,'RUTA-06',0,'2026-05-23 13:43:40.658075'); INSERT INTO addresses VALUES(222,155,'Negocio','Mariano Escobedo 462','La Toscana','Celaya',20.51472258061020071,-100.8343508239079824,'RUTA-14',1,'2026-05-23 13:43:40.658075'); INSERT INTO addresses VALUES(223,156,'Casa','Av. Irrigación 271','Trojes','Celaya',20.54513281233758449,-100.7913537006988918,'RUTA-07',1,'2026-05-23 13:43:40.658075'); INSERT INTO addresses VALUES(224,157,'Casa de campo','Benito Juárez 1453','Las Hadas','Celaya',20.51873770031723155,-100.8131165611710288,'RUTA-01',1,'2026-05-23 13:43:40.658076'); INSERT INTO addresses VALUES(225,157,'Oficina','16 de Septiembre 447','Los Sauces','Celaya',20.54895482975069498,-100.7914841382690696,'RUTA-07',0,'2026-05-23 13:43:40.658076'); INSERT INTO addresses VALUES(226,158,'Trabajo','Hidalgo 1048','Insurgentes Norte','Celaya',20.52924310821470754,-100.8530284746002792,'RUTA-09',1,'2026-05-23 13:43:40.658077'); INSERT INTO addresses VALUES(227,159,'Trabajo','Av. Irrigación 131','Casa Blanca','Celaya',20.50009050104637964,-100.8410152407374624,'RUTA-10',1,'2026-05-23 13:43:40.658077'); INSERT INTO addresses VALUES(228,159,'Casa de campo','Mariano Escobedo 1457','Pueblitos','Celaya',20.50340594745614453,-100.8313850839974748,'RUTA-05',0,'2026-05-23 13:43:40.658078'); INSERT INTO addresses VALUES(229,160,'Familia','Av. del Trabajo 1353','Villas del Mineral','Celaya',20.52865474388303468,-100.848003129552552,'RUTA-09',1,'2026-05-23 13:43:40.658078'); INSERT INTO addresses VALUES(230,161,'Casa de campo','16 de Septiembre 858','San Isidro','Celaya',20.52725455271120225,-100.7980262717159548,'RUTA-08',1,'2026-05-23 13:43:40.658079'); INSERT INTO addresses VALUES(231,161,'Familia','Pino Suárez 389','Casa Blanca','Celaya',20.54736732095743435,-100.7941697629758693,'RUTA-07',0,'2026-05-23 13:43:40.658079'); INSERT INTO addresses VALUES(232,162,'Oficina','Lázaro Cárdenas 1376','La Aurora','Celaya',20.53136318110932379,-100.7876168641012242,'RUTA-04',1,'2026-05-23 13:43:40.658080'); INSERT INTO addresses VALUES(233,162,'Local','Zaragoza 602','Ciudad Industrial','Celaya',20.5240019482855054,-100.8553001333593926,'RUTA-09',0,'2026-05-23 13:43:40.658080'); INSERT INTO addresses VALUES(234,163,'Casa de mis papás','Vicente Guerrero 688','Rumbos de Roque','Celaya',20.529586518505603,-100.7949165613085824,'RUTA-12',1,'2026-05-23 13:43:40.658080'); INSERT INTO addresses VALUES(235,164,'Departamento','Insurgentes 534','Real del Cid','Celaya',20.53194209929342761,-100.7909291472866756,'RUTA-12',1,'2026-05-23 13:43:40.658081'); INSERT INTO addresses VALUES(236,165,'Familia','Av. Universidad 1272','Rancho Seco','Celaya',20.54070536567670758,-100.8093360663030751,'RUTA-13',1,'2026-05-23 13:43:40.658081'); INSERT INTO addresses VALUES(237,166,'Casa de la abuela','Av. Las Torres 612','La Esperanza','Celaya',20.52950477374492521,-100.7853250224530228,'RUTA-04',1,'2026-05-23 13:43:40.658082'); INSERT INTO addresses VALUES(238,167,'Departamento','Av. Tecnológico 1167','Los Sauces','Celaya',20.51050778451095269,-100.8340765214711183,'RUTA-14',1,'2026-05-23 13:43:40.658082'); INSERT INTO addresses VALUES(239,168,'Oficina','Constituyentes 1293','Trojes','Celaya',20.51615668456109987,-100.8362105882256543,'RUTA-14',1,'2026-05-23 13:43:40.658083'); INSERT INTO addresses VALUES(240,169,'Casa de mis papás','Av. Universidad 325','Praderas','Celaya',20.51654713501423898,-100.816464721377983,'RUTA-01',1,'2026-05-23 13:43:40.658083'); INSERT INTO addresses VALUES(241,170,'Casa de la abuela','Av. del Trabajo 879','Jardines','Celaya',20.53788041343759118,-100.806855202612752,'RUTA-07',1,'2026-05-23 13:43:40.658084'); INSERT INTO addresses VALUES(242,170,'Departamento','Hidalgo 660','Irrigación','Celaya',20.54004669137580307,-100.7946621739715737,'RUTA-07',0,'2026-05-23 13:43:40.658084'); INSERT INTO addresses VALUES(243,171,'Departamento','Reforma 265','Ciudad Industrial','Celaya',20.52276686928671623,-100.8167117687712419,'RUTA-01',1,'2026-05-23 13:43:40.658085'); INSERT INTO addresses VALUES(244,172,'Casa','Reforma 596','Los Sauces','Celaya',20.49706115092091352,-100.843347129775296,'RUTA-10',1,'2026-05-23 13:43:40.658085'); INSERT INTO addresses VALUES(245,173,'Casa de mis papás','Constituyentes 1004','La Aurora','Celaya',20.49924117643667997,-100.8396633476996413,'RUTA-10',1,'2026-05-23 13:43:40.658085'); INSERT INTO addresses VALUES(246,173,'Casa de la abuela','Hidalgo 468','San José de Celaya','Celaya',20.53888426033891079,-100.80351915646294,'RUTA-13',0,'2026-05-23 13:43:40.658086'); INSERT INTO addresses VALUES(247,174,'Local','Zaragoza 253','Insurgentes Norte','Celaya',20.52611190229163185,-100.8367808672793445,'RUTA-11',1,'2026-05-23 13:43:40.658086'); INSERT INTO addresses VALUES(248,174,'Casa de campo','Galeana 1096','Los Olivos','Celaya',20.53350540380121103,-100.8026263657230715,'RUTA-07',0,'2026-05-23 13:43:40.658087'); INSERT INTO addresses VALUES(249,175,'Casa','Juárez 1413','Hospital General','Celaya',20.52311969915837864,-100.8126643238159943,'RUTA-01',1,'2026-05-23 13:43:40.658087'); INSERT INTO addresses VALUES(250,175,'Casa de campo','Av. Irrigación 1438','Torres Landa','Celaya',20.5444431428894596,-100.7987640493700496,'RUTA-13',0,'2026-05-23 13:43:40.658088'); INSERT INTO addresses VALUES(251,176,'Trabajo','Vicente Guerrero 1066','Las Hadas','Celaya',20.52930311340162816,-100.8269888354524398,'RUTA-11',1,'2026-05-23 13:43:40.658088'); INSERT INTO addresses VALUES(252,177,'Trabajo','Av. Las Torres 1473','Hospital General','Celaya',20.52837163522979935,-100.794693472795288,'RUTA-12',1,'2026-05-23 13:43:40.658089'); INSERT INTO addresses VALUES(253,177,'Negocio','Calzada de los Olivos 410','Las Américas','Celaya',20.49814012552684162,-100.8389373629169228,'RUTA-10',0,'2026-05-23 13:43:40.658089'); INSERT INTO addresses VALUES(254,178,'Casa de mis papás','Juárez 1123','Praderas','Celaya',20.52807921836550519,-100.789902437694721,'RUTA-04',1,'2026-05-23 13:43:40.658090'); INSERT INTO addresses VALUES(255,178,'Departamento','5 de Mayo 6','Centro','Celaya',20.53607693984271875,-100.843668756553484,'RUTA-03',0,'2026-05-23 13:43:40.658090'); INSERT INTO addresses VALUES(256,179,'Oficina','Allende 185','Vista Hermosa','Celaya',20.53510430917406638,-100.8472584723480736,'RUTA-15',1,'2026-05-23 13:43:40.658090'); INSERT INTO addresses VALUES(257,179,'Casa de campo','Mariano Escobedo 474','Los Sauces','Celaya',20.5432356361689834,-100.8169870952140741,'RUTA-02',0,'2026-05-23 13:43:40.658091'); INSERT INTO addresses VALUES(258,180,'Casa de mis papás','Niños Héroes 81','Real del Cid','Celaya',20.499641250227711,-100.8394991980418638,'RUTA-10',1,'2026-05-23 13:43:40.658091'); INSERT INTO addresses VALUES(259,180,'Trabajo','Madero 94','Centro','Celaya',20.56401596102690376,-100.8388729289303711,'RUTA-06',0,'2026-05-23 13:43:40.658092'); INSERT INTO addresses VALUES(260,180,'Departamento','Insurgentes 897','Las Hadas','Celaya',20.51038394442672797,-100.8375280137382077,'RUTA-14',0,'2026-05-23 13:43:40.658092'); INSERT INTO addresses VALUES(261,181,'Trabajo','Av. del Trabajo 820','Los Sauces','Celaya',20.53972622153274586,-100.8145727727723937,'RUTA-02',1,'2026-05-23 13:43:40.658093'); INSERT INTO addresses VALUES(262,181,'Oficina','Aldama 864','Las Insurgentes','Celaya',20.50535708345366359,-100.8331009756884953,'RUTA-05',0,'2026-05-23 13:43:40.658093'); INSERT INTO addresses VALUES(263,181,'Casa de mis papás','Madero 853','Jardines','Celaya',20.53732511576236775,-100.8107358888791083,'RUTA-13',0,'2026-05-23 13:43:40.658094'); INSERT INTO addresses VALUES(264,182,'Departamento','Calzada de los Olivos 60','Sede UG Sur','Celaya',20.52738162805000144,-100.8238867684170828,'RUTA-11',1,'2026-05-23 13:43:40.658094'); INSERT INTO addresses VALUES(265,182,'Casa de la abuela','Av. Torres Landa 95','Rancho Seco','Celaya',20.52870397985638107,-100.8018706252062628,'RUTA-12',0,'2026-05-23 13:43:40.658095'); INSERT INTO addresses VALUES(266,183,'Local','Galeana 1181','San José de Celaya','Celaya',20.55612360212985835,-100.8333166772814167,'RUTA-06',1,'2026-05-23 13:43:40.658095'); INSERT INTO addresses VALUES(267,184,'Familia','Madero 887','Tecnológico','Celaya',20.53173143563704883,-100.824809003209836,'RUTA-11',1,'2026-05-23 13:43:40.658095'); INSERT INTO addresses VALUES(268,184,'Casa de la abuela','Allende 1144','Los Olivos','Celaya',20.522957494874575,-100.7962370443164276,'RUTA-08',0,'2026-05-23 13:43:40.658096'); INSERT INTO addresses VALUES(269,184,'Oficina','Niños Héroes 1016','Las Insurgentes','Celaya',20.52293398716556893,-100.8176307262669837,'RUTA-01',0,'2026-05-23 13:43:40.658096'); INSERT INTO addresses VALUES(270,185,'Casa de campo','Juárez 1039','San José de Celaya','Celaya',20.52270633815533429,-100.7996910515747829,'RUTA-08',1,'2026-05-23 13:43:40.658097'); INSERT INTO addresses VALUES(271,186,'Oficina','Av. Torres Landa 1174','Camino Real','Celaya',20.54403276993462057,-100.7976500000000896,'RUTA-07',1,'2026-05-23 13:43:40.658097'); INSERT INTO addresses VALUES(272,186,'Trabajo','Av. Irrigación 1339','Las Arboledas','Celaya',20.54456589224178132,-100.8135293188008603,'RUTA-02',0,'2026-05-23 13:43:40.658098'); INSERT INTO addresses VALUES(273,187,'Trabajo','Aldama 1238','Pueblitos','Celaya',20.54035831932404222,-100.7945090121030632,'RUTA-07',1,'2026-05-23 13:43:40.658098'); INSERT INTO addresses VALUES(274,188,'Departamento','Insurgentes 112','San José de Celaya','Celaya',20.52306851248849994,-100.8502852562922101,'RUTA-03',1,'2026-05-23 13:43:40.658099'); INSERT INTO addresses VALUES(275,188,'Familia','Calzada de los Olivos 969','Insurgentes Norte','Celaya',20.51354459982603373,-100.8383984915489435,'RUTA-14',0,'2026-05-23 13:43:40.658099'); INSERT INTO addresses VALUES(276,188,'Negocio','Hidalgo 700','La Aurora','Celaya',20.5315253245617484,-100.8020256297767646,'RUTA-12',0,'2026-05-23 13:43:40.658099'); INSERT INTO addresses VALUES(277,189,'Trabajo','Juárez 337','Praderas','Celaya',20.53991983563808433,-100.8077801491339614,'RUTA-13',1,'2026-05-23 13:43:40.658100'); INSERT INTO addresses VALUES(278,189,'Casa de la abuela','Madero 521','Irrigación','Celaya',20.53221838659918674,-100.8295748910962289,'RUTA-03',0,'2026-05-23 13:43:40.658100'); INSERT INTO addresses VALUES(279,190,'Negocio','Benito Juárez 693','Ciudad Industrial','Celaya',20.54252194371766648,-100.850844104956309,'RUTA-15',1,'2026-05-23 13:43:40.658101'); INSERT INTO addresses VALUES(280,191,'Familia','Madero 923','Los Sauces','Celaya',20.52576626530537141,-100.8108253376251326,'RUTA-02',1,'2026-05-23 13:43:40.658101'); INSERT INTO addresses VALUES(281,191,'Oficina','Hidalgo 1087','Los Olivos','Celaya',20.52889316166610811,-100.8249580242384553,'RUTA-11',0,'2026-05-23 13:43:40.658102'); INSERT INTO addresses VALUES(282,192,'Local','Galeana 363','Trojes','Celaya',20.54838816110678935,-100.7951706803646487,'RUTA-07',1,'2026-05-23 13:43:40.658102'); INSERT INTO addresses VALUES(283,192,'Familia','Calzada de los Olivos 660','Vista Hermosa','Celaya',20.53515244154098341,-100.80196446038876,'RUTA-07',0,'2026-05-23 13:43:40.658104'); INSERT INTO addresses VALUES(284,193,'Negocio','16 de Septiembre 815','Casa Blanca','Celaya',20.54979500760205368,-100.7908408975830242,'RUTA-07',1,'2026-05-23 13:43:40.658105'); INSERT INTO addresses VALUES(285,193,'Casa de la abuela','Calzada de los Olivos 1434','Vista Hermosa','Celaya',20.50152845706081095,-100.8386662816898394,'RUTA-10',0,'2026-05-23 13:43:40.658105'); INSERT INTO addresses VALUES(286,193,'Departamento','Benito Juárez 1134','La Toscana','Celaya',20.50543074431281453,-100.8345219402863932,'RUTA-05',0,'2026-05-23 13:43:40.658106'); INSERT INTO addresses VALUES(287,194,'Casa de mis papás','Benito Juárez 1332','Trojes','Celaya',20.50114384535629596,-100.837133887026809,'RUTA-05',1,'2026-05-23 13:43:40.658106'); INSERT INTO addresses VALUES(288,195,'Departamento','Av. Juan Pablo II 984','La Esperanza','Celaya',20.53336877434867347,-100.7958964727286003,'RUTA-12',1,'2026-05-23 13:43:40.658106'); INSERT INTO addresses VALUES(289,195,'Casa de campo','Emiliano Zapata 866','Centro','Celaya',20.53047868723376368,-100.8215861069758291,'RUTA-11',0,'2026-05-23 13:43:40.658107'); INSERT INTO addresses VALUES(290,196,'Casa','Independencia 547','Las Insurgentes','Celaya',20.52030870313534905,-100.8186693500049245,'RUTA-01',1,'2026-05-23 13:43:40.658107'); INSERT INTO addresses VALUES(291,196,'Casa','Benito Juárez 605','La Toscana','Celaya',20.50383390328664746,-100.8385357160985904,'RUTA-05',0,'2026-05-23 13:43:40.658108'); INSERT INTO addresses VALUES(292,197,'Familia','Niños Héroes 1384','San José de Celaya','Celaya',20.52008682437345399,-100.8146740549547645,'RUTA-01',1,'2026-05-23 13:43:40.658108'); INSERT INTO addresses VALUES(293,197,'Local','Aldama 1426','Real del Cid','Celaya',20.53347119444320157,-100.7991111333789292,'RUTA-12',0,'2026-05-23 13:43:40.658109'); INSERT INTO addresses VALUES(294,198,'Departamento','Av. Juan Pablo II 111','Centro','Celaya',20.52576484811168811,-100.8153244535135827,'RUTA-02',1,'2026-05-23 13:43:40.658109'); INSERT INTO addresses VALUES(295,198,'Oficina','Pino Suárez 462','Insurgentes Norte','Celaya',20.5295134112837232,-100.7967943830438884,'RUTA-12',0,'2026-05-23 13:43:40.658110'); INSERT INTO addresses VALUES(296,199,'Negocio','Reforma 920','Trojes','Celaya',20.52838450032497875,-100.8550353091823979,'RUTA-09',1,'2026-05-23 13:43:40.658110'); INSERT INTO addresses VALUES(297,199,'Local','Madero 773','San Juanico','Celaya',20.52374468994043611,-100.820375247510242,'RUTA-01',0,'2026-05-23 13:43:40.658110'); INSERT INTO addresses VALUES(298,200,'Casa de campo','Hidalgo 677','Los Sauces','Celaya',20.52364239595309314,-100.8553907115024373,'RUTA-09',1,'2026-05-23 13:43:40.658111'); INSERT INTO addresses VALUES(299,201,'Familia','Juárez 1281','Pueblitos','Celaya',20.52439940589321309,-100.8277137176153957,'RUTA-11',1,'2026-05-23 13:43:40.658111'); INSERT INTO addresses VALUES(300,201,'Trabajo','Aldama 1450','Villas del Mineral','Celaya',20.52739908182417494,-100.7974983982028049,'RUTA-08',0,'2026-05-23 13:43:40.658112'); INSERT INTO addresses VALUES(301,202,'Casa de mis papás','Av. Tecnológico 1113','San Isidro','Celaya',20.52920606287331751,-100.8291374176066171,'RUTA-03',1,'2026-05-23 13:43:40.658112'); INSERT INTO addresses VALUES(302,202,'Departamento','Constituyentes 739','Real del Cid','Celaya',20.5394940295086208,-100.8091660326113299,'RUTA-13',0,'2026-05-23 13:43:40.658113'); CREATE TABLE reports ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, address_id INTEGER NOT NULL, folio VARCHAR NOT NULL, report_type VARCHAR NOT NULL, description TEXT, status VARCHAR, created_at DATETIME, updated_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES users (id), FOREIGN KEY(address_id) REFERENCES addresses (id) ); INSERT INTO reports VALUES(1,87,112,'MRL-20260523-6D30FF','OTRO','¿Cuándo van a pasar por electrónicos?','RESUELTO','2026-04-17 17:43:40.690680','2026-05-23 13:43:40.691289'); INSERT INTO reports VALUES(2,56,59,'MRL-20260523-0B84A7','ACUMULACION','Bote desbordado en parada de camión.','EN_PROCESO','2026-03-25 18:28:40.691415','2026-05-23 13:43:40.691533'); INSERT INTO reports VALUES(3,32,21,'MRL-20260523-1BFC34','ACUMULACION','Hay basura acumulada en la esquina.','EN_PROCESO','2026-04-29 05:09:40.691615','2026-05-23 13:43:40.691711'); INSERT INTO reports VALUES(4,107,145,'MRL-20260523-630A9E','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-20 21:15:40.691781','2026-05-23 13:43:40.691880'); INSERT INTO reports VALUES(5,175,250,'MRL-20260523-D8486C','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-05-02 21:38:40.691990','2026-05-23 13:43:40.692097'); INSERT INTO reports VALUES(6,51,50,'MRL-20260523-7B4879','NO_PASO','Llevamos 2 días sin recolección.','CERRADO','2026-04-19 13:03:40.692230','2026-05-23 13:43:40.692387'); INSERT INTO reports VALUES(7,40,34,'MRL-20260523-59124C','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-03-28 16:16:40.692499','2026-05-23 13:43:40.692627'); INSERT INTO reports VALUES(8,53,54,'MRL-20260523-C1AD5C','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-04-12 10:56:40.692708','2026-05-23 13:43:40.692810'); INSERT INTO reports VALUES(9,67,79,'MRL-20260523-C22D5C','NO_PASO','El camión no pasó por mi calle.','RESUELTO','2026-05-18 11:40:40.692912','2026-05-23 13:43:40.693005'); INSERT INTO reports VALUES(10,77,92,'MRL-20260523-4A49C7','ACUMULACION','Bote desbordado en parada de camión.','RESUELTO','2026-04-01 05:45:40.693076','2026-05-23 13:43:40.693153'); INSERT INTO reports VALUES(11,99,133,'MRL-20260523-30F9E4','RETRASO','Llegó casi a mediodía.','EN_PROCESO','2026-04-26 03:42:40.693213','2026-05-23 13:43:40.693288'); INSERT INTO reports VALUES(12,140,200,'MRL-20260523-6FB023','ACUMULACION','Bote desbordado en parada de camión.','RESUELTO','2026-05-18 14:06:40.693349','2026-05-23 13:43:40.693424'); INSERT INTO reports VALUES(13,34,24,'MRL-20260523-2AAD50','ACUMULACION','Bote desbordado en parada de camión.','PENDIENTE','2026-05-17 03:53:40.693491','2026-05-23 13:43:40.693566'); INSERT INTO reports VALUES(14,112,155,'MRL-20260523-BB4895','RETRASO','Llegó casi a mediodía.','PENDIENTE','2026-04-29 00:51:40.693626','2026-05-23 13:43:40.693699'); INSERT INTO reports VALUES(15,30,16,'MRL-20260523-A523D4','RETRASO','Llegó cuando ya nos íbamos a trabajar.','RESUELTO','2026-04-06 00:53:40.693760','2026-05-23 13:43:40.693835'); INSERT INTO reports VALUES(16,191,280,'MRL-20260523-6DC486','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-09 14:02:40.693893','2026-05-23 13:43:40.693966'); INSERT INTO reports VALUES(17,134,192,'MRL-20260523-7095A9','OTRO','Felicitación al equipo del camión.','PENDIENTE','2026-05-14 10:41:40.694025','2026-05-23 13:43:40.694098'); INSERT INTO reports VALUES(18,19,3,'MRL-20260523-24AF9E','RETRASO','Estuvo retrasado más de 90 minutos.','EN_PROCESO','2026-03-24 11:24:40.694157','2026-05-23 13:43:40.694231'); INSERT INTO reports VALUES(19,85,108,'MRL-20260523-0003E2','ACUMULACION','Acumulación que atrae perros.','CERRADO','2026-05-09 23:46:40.694289','2026-05-23 13:43:40.694362'); INSERT INTO reports VALUES(20,181,263,'MRL-20260523-E691F4','NO_PASO','Llevamos 2 días sin recolección.','PENDIENTE','2026-03-31 05:31:40.694425','2026-05-23 13:43:40.694499'); INSERT INTO reports VALUES(21,56,59,'MRL-20260523-4C4E10','NO_PASO','El camión no pasó por mi calle.','RESUELTO','2026-03-29 20:14:40.694557','2026-05-23 13:43:40.694630'); INSERT INTO reports VALUES(22,192,282,'MRL-20260523-36A419','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-05-17 06:57:40.694688','2026-05-23 13:43:40.694762'); INSERT INTO reports VALUES(23,200,298,'MRL-20260523-7446D0','RETRASO','Llegó cuando ya nos íbamos a trabajar.','EN_PROCESO','2026-04-10 17:28:40.694819','2026-05-23 13:43:40.694894'); INSERT INTO reports VALUES(24,52,52,'MRL-20260523-C785C7','NO_PASO','Hoy no escuché el camión.','PENDIENTE','2026-05-02 22:15:40.694956','2026-05-23 13:43:40.695036'); INSERT INTO reports VALUES(25,122,169,'MRL-20260523-45B854','RETRASO','Estuvo retrasado más de 90 minutos.','EN_PROCESO','2026-05-13 19:07:40.695095','2026-05-23 13:43:40.695170'); INSERT INTO reports VALUES(26,131,187,'MRL-20260523-DB0BE9','ACUMULACION','Bolsas regadas en la calle desde hace días.','CERRADO','2026-05-23 03:28:40.695230','2026-05-23 13:43:40.695306'); INSERT INTO reports VALUES(27,87,114,'MRL-20260523-20DE20','ACUMULACION','Acumulación que atrae perros.','RESUELTO','2026-03-31 02:35:40.695372','2026-05-23 13:43:40.695459'); INSERT INTO reports VALUES(28,123,170,'MRL-20260523-D913FE','ACUMULACION','Acumulación que atrae perros.','EN_PROCESO','2026-04-04 04:12:40.695523','2026-05-23 13:43:40.695602'); INSERT INTO reports VALUES(29,192,283,'MRL-20260523-DA15EF','NO_PASO','El camión no pasó por mi calle.','RESUELTO','2026-03-31 04:49:40.695659','2026-05-23 13:43:40.695732'); INSERT INTO reports VALUES(30,63,72,'MRL-20260523-0A3CBE','ACUMULACION','Hay basura acumulada en la esquina.','PENDIENTE','2026-04-07 10:46:40.695825','2026-05-23 13:43:40.695902'); INSERT INTO reports VALUES(31,25,10,'MRL-20260523-B0BAB7','ACUMULACION','Bote desbordado en parada de camión.','RESUELTO','2026-04-16 00:54:40.695962','2026-05-23 13:43:40.696034'); INSERT INTO reports VALUES(32,85,109,'MRL-20260523-E57B7D','OTRO','Felicitación al equipo del camión.','RESUELTO','2026-03-26 20:13:40.696102','2026-05-23 13:43:40.696175'); INSERT INTO reports VALUES(33,66,77,'MRL-20260523-6E0CCC','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-04-07 04:35:40.696235','2026-05-23 13:43:40.696308'); INSERT INTO reports VALUES(34,167,238,'MRL-20260523-AEFE6B','RETRASO','El retraso es de cada vez peor en la semana.','PENDIENTE','2026-04-21 13:01:40.696366','2026-05-23 13:43:40.696440'); INSERT INTO reports VALUES(35,92,123,'MRL-20260523-97617D','ACUMULACION','Bote desbordado en parada de camión.','RESUELTO','2026-04-10 07:55:40.696498','2026-05-23 13:43:40.696572'); INSERT INTO reports VALUES(36,182,264,'MRL-20260523-9B47C1','NO_PASO','Llevamos 2 días sin recolección.','PENDIENTE','2026-03-23 19:01:40.696635','2026-05-23 13:43:40.696708'); INSERT INTO reports VALUES(37,64,75,'MRL-20260523-3E414A','ACUMULACION','Acumulación que atrae perros.','EN_PROCESO','2026-05-21 05:55:40.696768','2026-05-23 13:43:40.696845'); INSERT INTO reports VALUES(38,175,250,'MRL-20260523-0A9EA6','NO_PASO','Hoy no escuché el camión.','PENDIENTE','2026-05-20 16:30:40.696904','2026-05-23 13:43:40.696977'); INSERT INTO reports VALUES(39,183,266,'MRL-20260523-2E8875','OTRO','¿Cuándo van a pasar por electrónicos?','EN_PROCESO','2026-03-25 22:47:40.697036','2026-05-23 13:43:40.697113'); INSERT INTO reports VALUES(40,34,24,'MRL-20260523-A9EEA7','NO_PASO','El camión no pasó por mi calle.','RESUELTO','2026-04-07 21:03:40.697171','2026-05-23 13:43:40.697244'); INSERT INTO reports VALUES(41,105,141,'MRL-20260523-35A6F6','ACUMULACION','Bote desbordado en parada de camión.','PENDIENTE','2026-04-17 08:19:40.697302','2026-05-23 13:43:40.697374'); INSERT INTO reports VALUES(42,135,194,'MRL-20260523-C82A73','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-04-20 05:19:40.697433','2026-05-23 13:43:40.697510'); INSERT INTO reports VALUES(43,88,115,'MRL-20260523-95623B','RETRASO','El retraso es de cada vez peor en la semana.','EN_PROCESO','2026-04-21 21:47:40.697569','2026-05-23 13:43:40.697643'); INSERT INTO reports VALUES(44,19,4,'MRL-20260523-A56EBC','RETRASO','Llegó cuando ya nos íbamos a trabajar.','PENDIENTE','2026-05-09 11:11:40.697704','2026-05-23 13:43:40.697776'); INSERT INTO reports VALUES(45,107,144,'MRL-20260523-F78823','NO_PASO','No vi pasar el camión en su horario.','PENDIENTE','2026-04-14 14:51:40.697835','2026-05-23 13:43:40.697909'); INSERT INTO reports VALUES(46,56,61,'MRL-20260523-582B12','ACUMULACION','Acumulación que atrae perros.','EN_PROCESO','2026-04-07 10:13:40.697970','2026-05-23 13:43:40.698047'); INSERT INTO reports VALUES(47,173,246,'MRL-20260523-BBA2B1','RETRASO','Llegó casi a mediodía.','RESUELTO','2026-05-22 06:41:40.698105','2026-05-23 13:43:40.698177'); INSERT INTO reports VALUES(48,60,66,'MRL-20260523-FD1869','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-05-20 19:34:40.698236','2026-05-23 13:43:40.698308'); INSERT INTO reports VALUES(49,39,29,'MRL-20260523-894F92','NO_PASO','Llevamos 2 días sin recolección.','CERRADO','2026-04-27 18:07:40.698370','2026-05-23 13:43:40.698467'); INSERT INTO reports VALUES(50,25,10,'MRL-20260523-FE7398','ACUMULACION','Acumulación que atrae perros.','RESUELTO','2026-03-24 11:30:40.698536','2026-05-23 13:43:40.698609'); INSERT INTO reports VALUES(51,161,230,'MRL-20260523-F1256D','RETRASO','Llegó casi a mediodía.','EN_PROCESO','2026-05-13 05:50:40.698674','2026-05-23 13:43:40.698746'); INSERT INTO reports VALUES(52,147,211,'MRL-20260523-B35ECD','RETRASO','Llegó cuando ya nos íbamos a trabajar.','RESUELTO','2026-04-13 16:11:40.698810','2026-05-23 13:43:40.698884'); INSERT INTO reports VALUES(53,101,136,'MRL-20260523-05BFD8','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-04-14 19:39:40.698941','2026-05-23 13:43:40.699014'); INSERT INTO reports VALUES(54,89,118,'MRL-20260523-6C79D1','RETRASO','Pasó más de una hora tarde.','PENDIENTE','2026-05-10 20:48:40.699072','2026-05-23 13:43:40.699145'); INSERT INTO reports VALUES(55,180,259,'MRL-20260523-6C3545','ACUMULACION','Bote desbordado en parada de camión.','RESUELTO','2026-05-17 08:13:40.699203','2026-05-23 13:43:40.699274'); INSERT INTO reports VALUES(56,32,20,'MRL-20260523-59803F','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-05-17 22:01:40.699333','2026-05-23 13:43:40.699403'); INSERT INTO reports VALUES(57,61,67,'MRL-20260523-FB7B60','OTRO','Solicito información sobre días festivos.','RESUELTO','2026-03-26 16:02:40.699469','2026-05-23 13:43:40.699544'); INSERT INTO reports VALUES(58,154,221,'MRL-20260523-D5C68F','RETRASO','Pasó más de una hora tarde.','EN_PROCESO','2026-04-08 21:16:40.699615','2026-05-23 13:43:40.699690'); INSERT INTO reports VALUES(59,89,118,'MRL-20260523-20EA0D','OTRO','¿Cuándo van a pasar por electrónicos?','EN_PROCESO','2026-04-30 18:52:40.699753','2026-05-23 13:43:40.699827'); INSERT INTO reports VALUES(60,198,295,'MRL-20260523-E40FCD','NO_PASO','El camión saltó nuestra cuadra.','PENDIENTE','2026-04-04 05:45:40.699885','2026-05-23 13:43:40.699962'); INSERT INTO reports VALUES(61,47,43,'MRL-20260523-6A756C','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-05-07 07:43:40.700023','2026-05-23 13:43:40.700097'); INSERT INTO reports VALUES(62,19,4,'MRL-20260523-EF7E54','RETRASO','Pasó más de una hora tarde.','PENDIENTE','2026-04-28 17:30:40.700156','2026-05-23 13:43:40.700227'); INSERT INTO reports VALUES(63,118,162,'MRL-20260523-07B8BA','RETRASO','Llegó casi a mediodía.','PENDIENTE','2026-04-11 19:27:40.700287','2026-05-23 13:43:40.700357'); INSERT INTO reports VALUES(64,100,134,'MRL-20260523-A840B9','ACUMULACION','Acumulación que atrae perros.','EN_PROCESO','2026-04-14 05:00:40.700416','2026-05-23 13:43:40.700491'); INSERT INTO reports VALUES(65,143,204,'MRL-20260523-3DA48C','ACUMULACION','Bote desbordado en parada de camión.','EN_PROCESO','2026-04-23 08:20:40.700559','2026-05-23 13:43:40.700635'); INSERT INTO reports VALUES(66,194,287,'MRL-20260523-A989CF','RETRASO','El retraso es de cada vez peor en la semana.','PENDIENTE','2026-04-17 01:54:40.700747','2026-05-23 13:43:40.700953'); INSERT INTO reports VALUES(67,143,204,'MRL-20260523-27448A','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-04-06 06:15:40.701040','2026-05-23 13:43:40.701176'); INSERT INTO reports VALUES(68,70,83,'MRL-20260523-AB3A3B','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-01 20:04:40.701275','2026-05-23 13:43:40.701369'); INSERT INTO reports VALUES(69,37,27,'MRL-20260523-BC0CA5','NO_PASO','El camión no pasó por mi calle.','CERRADO','2026-04-02 10:51:40.701451','2026-05-23 13:43:40.701533'); INSERT INTO reports VALUES(70,64,75,'MRL-20260523-23A4EA','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-05-19 05:29:40.701604','2026-05-23 13:43:40.701686'); INSERT INTO reports VALUES(71,133,190,'MRL-20260523-2F99E6','NO_PASO','El camión saltó nuestra cuadra.','PENDIENTE','2026-03-25 01:04:40.701753','2026-05-23 13:43:40.701832'); INSERT INTO reports VALUES(72,184,267,'MRL-20260523-13AD49','NO_PASO','El camión no pasó por mi calle.','CERRADO','2026-03-24 08:03:40.701901','2026-05-23 13:43:40.701982'); INSERT INTO reports VALUES(73,178,254,'MRL-20260523-8F2F06','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-05-05 07:41:40.702044','2026-05-23 13:43:40.702119'); INSERT INTO reports VALUES(74,181,262,'MRL-20260523-2F0948','RETRASO','Llegó cuando ya nos íbamos a trabajar.','PENDIENTE','2026-04-10 12:20:40.702182','2026-05-23 13:43:40.702256'); INSERT INTO reports VALUES(75,92,123,'MRL-20260523-558DA2','ACUMULACION','Hay basura acumulada en la esquina.','CERRADO','2026-05-06 01:21:40.702317','2026-05-23 13:43:40.702401'); INSERT INTO reports VALUES(76,143,203,'MRL-20260523-A2EA67','RETRASO','Pasó más de una hora tarde.','PENDIENTE','2026-04-05 15:39:40.702463','2026-05-23 13:43:40.702538'); INSERT INTO reports VALUES(77,49,47,'MRL-20260523-74A4C3','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-03-25 19:21:40.702597','2026-05-23 13:43:40.702672'); INSERT INTO reports VALUES(78,126,178,'MRL-20260523-DDC607','OTRO','Felicitación al equipo del camión.','PENDIENTE','2026-05-10 22:44:40.702732','2026-05-23 13:43:40.702811'); INSERT INTO reports VALUES(79,145,207,'MRL-20260523-C0189A','RETRASO','Llegó casi a mediodía.','PENDIENTE','2026-04-21 10:08:40.702875','2026-05-23 13:43:40.702950'); INSERT INTO reports VALUES(80,42,38,'MRL-20260523-2DA782','RETRASO','Pasó más de una hora tarde.','EN_PROCESO','2026-04-01 21:27:40.703011','2026-05-23 13:43:40.703085'); INSERT INTO reports VALUES(81,188,276,'MRL-20260523-38EF7B','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-04-28 19:13:40.703147','2026-05-23 13:43:40.703222'); INSERT INTO reports VALUES(82,93,125,'MRL-20260523-126189','ACUMULACION','Mal olor por basura acumulada.','CERRADO','2026-04-09 22:46:40.703284','2026-05-23 13:43:40.703361'); INSERT INTO reports VALUES(83,202,301,'MRL-20260523-BABD83','ACUMULACION','Acumulación que atrae perros.','EN_PROCESO','2026-05-19 01:03:40.703424','2026-05-23 13:43:40.703497'); INSERT INTO reports VALUES(84,87,113,'MRL-20260523-C1D549','ACUMULACION','Acumulación que atrae perros.','PENDIENTE','2026-04-27 02:10:40.703560','2026-05-23 13:43:40.703635'); INSERT INTO reports VALUES(85,188,275,'MRL-20260523-30C84E','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-05-05 11:18:40.703700','2026-05-23 13:43:40.703779'); INSERT INTO reports VALUES(86,125,176,'MRL-20260523-FBC964','NO_PASO','El camión saltó nuestra cuadra.','CERRADO','2026-05-03 02:30:40.703841','2026-05-23 13:43:40.703914'); INSERT INTO reports VALUES(87,198,294,'MRL-20260523-134235','NO_PASO','Hoy no escuché el camión.','CERRADO','2026-04-21 14:31:40.703975','2026-05-23 13:43:40.704049'); INSERT INTO reports VALUES(88,91,121,'MRL-20260523-0CEA39','ACUMULACION','Bolsas regadas en la calle desde hace días.','RESUELTO','2026-05-09 06:50:40.704111','2026-05-23 13:43:40.704189'); INSERT INTO reports VALUES(89,95,128,'MRL-20260523-388266','ACUMULACION','Hay basura acumulada en la esquina.','EN_PROCESO','2026-05-16 11:00:40.704249','2026-05-23 13:43:40.704322'); INSERT INTO reports VALUES(90,177,253,'MRL-20260523-5198EC','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-05-20 22:20:40.704381','2026-05-23 13:43:40.704455'); INSERT INTO reports VALUES(91,118,162,'MRL-20260523-B8287C','RETRASO','Estuvo retrasado más de 90 minutos.','CERRADO','2026-03-29 05:12:40.704515','2026-05-23 13:43:40.704587'); INSERT INTO reports VALUES(92,78,94,'MRL-20260523-2AC49E','OTRO','Comentario general sobre el servicio.','CERRADO','2026-04-28 05:55:40.704648','2026-05-23 13:43:40.704721'); INSERT INTO reports VALUES(93,199,296,'MRL-20260523-8270D3','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-04-22 20:41:40.704782','2026-05-23 13:43:40.704856'); INSERT INTO reports VALUES(94,180,258,'MRL-20260523-24A418','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-04-24 09:59:40.704917','2026-05-23 13:43:40.704991'); INSERT INTO reports VALUES(95,183,266,'MRL-20260523-96C9B7','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-04-10 07:19:40.705050','2026-05-23 13:43:40.705124'); INSERT INTO reports VALUES(96,200,298,'MRL-20260523-9CA02F','NO_PASO','No vi pasar el camión en su horario.','EN_PROCESO','2026-05-11 20:27:40.705184','2026-05-23 13:43:40.705258'); INSERT INTO reports VALUES(97,91,122,'MRL-20260523-C24547','NO_PASO','No vi pasar el camión en su horario.','CERRADO','2026-04-30 08:12:40.705322','2026-05-23 13:43:40.705404'); INSERT INTO reports VALUES(98,152,218,'MRL-20260523-D573AE','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-30 01:26:40.705464','2026-05-23 13:43:40.705536'); INSERT INTO reports VALUES(99,161,231,'MRL-20260523-E0295A','NO_PASO','Llevamos 2 días sin recolección.','PENDIENTE','2026-04-10 05:51:40.705597','2026-05-23 13:43:40.705669'); INSERT INTO reports VALUES(100,52,52,'MRL-20260523-40D736','ACUMULACION','Bote desbordado en parada de camión.','RESUELTO','2026-04-26 01:31:40.705730','2026-05-23 13:43:40.705803'); INSERT INTO reports VALUES(101,64,75,'MRL-20260523-209E81','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-04-02 13:32:40.705863','2026-05-23 13:43:40.705936'); INSERT INTO reports VALUES(102,151,216,'MRL-20260523-7F4C18','RETRASO','Estuvo retrasado más de 90 minutos.','CERRADO','2026-04-18 14:23:40.705995','2026-05-23 13:43:40.706068'); INSERT INTO reports VALUES(103,175,250,'MRL-20260523-970C86','NO_PASO','Llevamos 2 días sin recolección.','RESUELTO','2026-05-20 01:37:40.706127','2026-05-23 13:43:40.706199'); INSERT INTO reports VALUES(104,71,84,'MRL-20260523-3C8ECE','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-03-30 17:37:40.706260','2026-05-23 13:43:40.706333'); INSERT INTO reports VALUES(105,161,231,'MRL-20260523-B0DB65','ACUMULACION','Acumulación que atrae perros.','PENDIENTE','2026-04-17 19:44:40.706393','2026-05-23 13:43:40.706465'); INSERT INTO reports VALUES(106,98,132,'MRL-20260523-F68442','NO_PASO','No vi pasar el camión en su horario.','EN_PROCESO','2026-03-28 16:05:40.706526','2026-05-23 13:43:40.706600'); INSERT INTO reports VALUES(107,82,102,'MRL-20260523-F40247','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-05-12 04:21:40.706660','2026-05-23 13:43:40.706733'); INSERT INTO reports VALUES(108,121,167,'MRL-20260523-EC3656','ACUMULACION','Mal olor por basura acumulada.','EN_PROCESO','2026-03-28 11:19:40.706792','2026-05-23 13:43:40.706867'); INSERT INTO reports VALUES(109,108,147,'MRL-20260523-A729F3','RETRASO','Llegó cuando ya nos íbamos a trabajar.','CERRADO','2026-04-13 03:17:40.706926','2026-05-23 13:43:40.707001'); INSERT INTO reports VALUES(110,197,293,'MRL-20260523-285C94','RETRASO','Pasó más de una hora tarde.','CERRADO','2026-05-13 03:29:40.707065','2026-05-23 13:43:40.707142'); INSERT INTO reports VALUES(111,117,161,'MRL-20260523-F12D79','NO_PASO','No vi pasar el camión en su horario.','PENDIENTE','2026-04-14 17:18:40.707206','2026-05-23 13:43:40.707280'); INSERT INTO reports VALUES(112,103,139,'MRL-20260523-07D504','ACUMULACION','Acumulación que atrae perros.','RESUELTO','2026-04-05 19:10:40.707343','2026-05-23 13:43:40.707420'); INSERT INTO reports VALUES(113,161,231,'MRL-20260523-25D1D2','RETRASO','Pasó más de una hora tarde.','PENDIENTE','2026-05-14 14:28:40.707482','2026-05-23 13:43:40.707557'); INSERT INTO reports VALUES(114,96,129,'MRL-20260523-07F9CB','OTRO','Solicito información sobre días festivos.','RESUELTO','2026-05-10 08:18:40.707617','2026-05-23 13:43:40.707692'); INSERT INTO reports VALUES(115,53,53,'MRL-20260523-1B34F6','NO_PASO','El camión saltó nuestra cuadra.','CERRADO','2026-04-18 12:42:40.707752','2026-05-23 13:43:40.707828'); INSERT INTO reports VALUES(116,143,204,'MRL-20260523-6F8C2A','RETRASO','Pasó más de una hora tarde.','CERRADO','2026-05-06 18:34:40.707890','2026-05-23 13:43:40.707970'); INSERT INTO reports VALUES(117,48,44,'MRL-20260523-126873','ACUMULACION','Acumulación que atrae perros.','RESUELTO','2026-05-09 05:56:40.708038','2026-05-23 13:43:40.708112'); INSERT INTO reports VALUES(118,107,146,'MRL-20260523-AE028E','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-03-31 08:42:40.708174','2026-05-23 13:43:40.708248'); INSERT INTO reports VALUES(119,31,18,'MRL-20260523-EA3090','ACUMULACION','Acumulación que atrae perros.','RESUELTO','2026-03-28 22:14:40.708355','2026-05-23 13:43:40.708449'); INSERT INTO reports VALUES(120,189,277,'MRL-20260523-58009E','OTRO','Pregunta sobre separación de residuos.','RESUELTO','2026-03-23 15:09:40.708522','2026-05-23 13:43:40.708605'); INSERT INTO reports VALUES(121,76,91,'MRL-20260523-EF1CDD','RETRASO','Estuvo retrasado más de 90 minutos.','EN_PROCESO','2026-04-25 21:03:40.708667','2026-05-23 13:43:40.708746'); INSERT INTO reports VALUES(122,188,274,'MRL-20260523-622CEE','NO_PASO','Llevamos 2 días sin recolección.','EN_PROCESO','2026-05-09 11:15:40.708815','2026-05-23 13:43:40.708895'); INSERT INTO reports VALUES(123,114,158,'MRL-20260523-C08AE9','RETRASO','El retraso es de cada vez peor en la semana.','PENDIENTE','2026-05-23 13:10:40.708958','2026-05-23 13:43:40.709125'); INSERT INTO reports VALUES(124,62,70,'MRL-20260523-927862','NO_PASO','El camión no pasó por mi calle.','EN_PROCESO','2026-04-08 21:55:40.709262','2026-05-23 13:43:40.709365'); INSERT INTO reports VALUES(125,173,245,'MRL-20260523-74262B','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-15 05:53:40.709431','2026-05-23 13:43:40.709515'); INSERT INTO reports VALUES(126,19,4,'MRL-20260523-5C986C','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-04-26 01:28:40.709580','2026-05-23 13:43:40.709660'); INSERT INTO reports VALUES(127,71,84,'MRL-20260523-0C37C9','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-05-09 05:38:40.709720','2026-05-23 13:43:40.709802'); INSERT INTO reports VALUES(128,152,217,'MRL-20260523-94F282','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-04-01 15:00:40.709864','2026-05-23 13:43:40.709945'); INSERT INTO reports VALUES(129,104,140,'MRL-20260523-B51E1E','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-27 06:49:40.710004','2026-05-23 13:43:40.710078'); INSERT INTO reports VALUES(130,41,36,'MRL-20260523-4890F5','NO_PASO','El camión saltó nuestra cuadra.','PENDIENTE','2026-04-13 23:26:40.710137','2026-05-23 13:43:40.710210'); INSERT INTO reports VALUES(131,177,252,'MRL-20260523-FF1D66','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-04-19 13:32:40.710268','2026-05-23 13:43:40.710340'); INSERT INTO reports VALUES(132,53,53,'MRL-20260523-EB7150','NO_PASO','El camión saltó nuestra cuadra.','PENDIENTE','2026-04-07 13:29:40.710399','2026-05-23 13:43:40.710470'); INSERT INTO reports VALUES(133,49,47,'MRL-20260523-E9EFE4','NO_PASO','No vi pasar el camión en su horario.','EN_PROCESO','2026-04-27 03:53:40.710529','2026-05-23 13:43:40.710600'); INSERT INTO reports VALUES(134,179,256,'MRL-20260523-456647','OTRO','Solicito información sobre días festivos.','EN_PROCESO','2026-05-02 10:50:40.710659','2026-05-23 13:43:40.710731'); INSERT INTO reports VALUES(135,64,75,'MRL-20260523-E7A6C9','NO_PASO','El camión no pasó por mi calle.','RESUELTO','2026-04-18 22:32:40.710789','2026-05-23 13:43:40.710869'); INSERT INTO reports VALUES(136,80,99,'MRL-20260523-5A33DD','ACUMULACION','Mal olor por basura acumulada.','PENDIENTE','2026-03-31 13:36:40.710927','2026-05-23 13:43:40.711002'); INSERT INTO reports VALUES(137,95,128,'MRL-20260523-580D0A','RETRASO','Llegó cuando ya nos íbamos a trabajar.','CERRADO','2026-04-06 12:31:40.711069','2026-05-23 13:43:40.711155'); INSERT INTO reports VALUES(138,165,236,'MRL-20260523-D80DEE','ACUMULACION','Bolsas regadas en la calle desde hace días.','PENDIENTE','2026-04-23 01:00:40.711223','2026-05-23 13:43:40.711302'); INSERT INTO reports VALUES(139,116,160,'MRL-20260523-6CDA22','OTRO','Solicito información sobre días festivos.','PENDIENTE','2026-04-05 20:10:40.711361','2026-05-23 13:43:40.711433'); INSERT INTO reports VALUES(140,58,63,'MRL-20260523-D27029','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-04-30 11:48:40.711492','2026-05-23 13:43:40.711565'); INSERT INTO reports VALUES(141,87,112,'MRL-20260523-F1E8F4','OTRO','¿Cuándo van a pasar por electrónicos?','PENDIENTE','2026-05-03 13:33:40.711624','2026-05-23 13:43:40.711695'); INSERT INTO reports VALUES(142,106,142,'MRL-20260523-DD1C5E','RETRASO','Llegó cuando ya nos íbamos a trabajar.','EN_PROCESO','2026-05-23 12:06:40.711753','2026-05-23 13:43:40.711825'); INSERT INTO reports VALUES(143,172,244,'MRL-20260523-2F5C92','ACUMULACION','Hay basura acumulada en la esquina.','PENDIENTE','2026-05-08 08:12:40.711882','2026-05-23 13:43:40.711961'); INSERT INTO reports VALUES(144,49,47,'MRL-20260523-26EDB8','ACUMULACION','Hay basura acumulada en la esquina.','EN_PROCESO','2026-05-20 02:02:40.712023','2026-05-23 13:43:40.712108'); INSERT INTO reports VALUES(145,67,79,'MRL-20260523-B8F2E6','ACUMULACION','Bolsas regadas en la calle desde hace días.','RESUELTO','2026-04-22 06:23:40.712183','2026-05-23 13:43:40.712258'); INSERT INTO reports VALUES(146,193,286,'MRL-20260523-C6D967','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-04-07 07:42:40.712323','2026-05-23 13:43:40.712396'); INSERT INTO reports VALUES(147,135,194,'MRL-20260523-7A11B9','RETRASO','Pasó más de una hora tarde.','PENDIENTE','2026-04-21 15:15:40.712454','2026-05-23 13:43:40.712532'); INSERT INTO reports VALUES(148,194,287,'MRL-20260523-BD4D9D','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-04-17 08:09:40.712592','2026-05-23 13:43:40.712671'); INSERT INTO reports VALUES(149,126,179,'MRL-20260523-62DCB5','NO_PASO','Llevamos 2 días sin recolección.','EN_PROCESO','2026-03-25 20:33:40.712733','2026-05-23 13:43:40.712807'); INSERT INTO reports VALUES(150,41,36,'MRL-20260523-ACD3F1','RETRASO','El retraso es de cada vez peor en la semana.','EN_PROCESO','2026-04-19 02:14:40.712868','2026-05-23 13:43:40.712941'); INSERT INTO reports VALUES(151,1,1,'MRL-20260523-983ACE','ACUMULACION','Bolsas regadas en la calle desde hace días.','RESUELTO','2026-03-28 13:04:40.713001','2026-05-23 13:43:40.713072'); INSERT INTO reports VALUES(152,131,187,'MRL-20260523-067E7D','ACUMULACION','Hay basura acumulada en la esquina.','PENDIENTE','2026-04-10 19:51:40.713132','2026-05-23 13:43:40.713204'); INSERT INTO reports VALUES(153,140,199,'MRL-20260523-97734A','NO_PASO','Llevamos 2 días sin recolección.','RESUELTO','2026-05-13 18:25:40.713263','2026-05-23 13:43:40.713336'); INSERT INTO reports VALUES(154,120,166,'MRL-20260523-0608EA','RETRASO','Pasó más de una hora tarde.','EN_PROCESO','2026-04-19 16:39:40.713394','2026-05-23 13:43:40.713466'); INSERT INTO reports VALUES(155,33,23,'MRL-20260523-F9A909','ACUMULACION','Hay basura acumulada en la esquina.','PENDIENTE','2026-05-11 10:12:40.713525','2026-05-23 13:43:40.713596'); INSERT INTO reports VALUES(156,80,99,'MRL-20260523-A18483','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-04-10 22:10:40.713654','2026-05-23 13:43:40.713727'); INSERT INTO reports VALUES(157,98,132,'MRL-20260523-7EE6A4','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-05-23 07:02:40.713794','2026-05-23 13:43:40.713865'); INSERT INTO reports VALUES(158,177,252,'MRL-20260523-3F5CC9','OTRO','¿Cuándo van a pasar por electrónicos?','RESUELTO','2026-04-01 17:40:40.713925','2026-05-23 13:43:40.713996'); INSERT INTO reports VALUES(159,130,185,'MRL-20260523-494828','RETRASO','Llegó casi a mediodía.','CERRADO','2026-04-01 01:53:40.714054','2026-05-23 13:43:40.714127'); INSERT INTO reports VALUES(160,39,30,'MRL-20260523-AEB9CF','ACUMULACION','Hay basura acumulada en la esquina.','PENDIENTE','2026-04-07 10:50:40.714185','2026-05-23 13:43:40.714256'); INSERT INTO reports VALUES(161,112,156,'MRL-20260523-65C07A','NO_PASO','Llevamos 2 días sin recolección.','PENDIENTE','2026-05-17 09:57:40.714314','2026-05-23 13:43:40.714386'); INSERT INTO reports VALUES(162,89,119,'MRL-20260523-66CCD5','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-04-11 06:07:40.714445','2026-05-23 13:43:40.714516'); INSERT INTO reports VALUES(163,77,92,'MRL-20260523-78970F','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-04-03 17:07:40.714575','2026-05-23 13:43:40.714647'); INSERT INTO reports VALUES(164,129,184,'MRL-20260523-6044F5','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-03-28 10:33:40.714706','2026-05-23 13:43:40.714778'); INSERT INTO reports VALUES(165,77,93,'MRL-20260523-CB4297','RETRASO','Llegó cuando ya nos íbamos a trabajar.','RESUELTO','2026-04-18 18:15:40.714837','2026-05-23 13:43:40.714911'); INSERT INTO reports VALUES(166,127,181,'MRL-20260523-CB7626','OTRO','Comentario general sobre el servicio.','RESUELTO','2026-03-30 02:17:40.714971','2026-05-23 13:43:40.715044'); INSERT INTO reports VALUES(167,154,221,'MRL-20260523-6DA34D','ACUMULACION','Bolsas regadas en la calle desde hace días.','EN_PROCESO','2026-04-16 20:30:40.715103','2026-05-23 13:43:40.715180'); INSERT INTO reports VALUES(168,135,193,'MRL-20260523-D184CB','ACUMULACION','Acumulación que atrae perros.','CERRADO','2026-04-29 23:15:40.715240','2026-05-23 13:43:40.715312'); INSERT INTO reports VALUES(169,143,204,'MRL-20260523-51E17B','NO_PASO','No vi pasar el camión en su horario.','PENDIENTE','2026-04-15 13:10:40.715372','2026-05-23 13:43:40.715444'); INSERT INTO reports VALUES(170,62,70,'MRL-20260523-213070','OTRO','Comentario general sobre el servicio.','EN_PROCESO','2026-05-09 06:49:40.715504','2026-05-23 13:43:40.715578'); INSERT INTO reports VALUES(171,118,162,'MRL-20260523-34EDC9','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-03-25 20:11:40.715637','2026-05-23 13:43:40.715715'); INSERT INTO reports VALUES(172,193,285,'MRL-20260523-EBBE8A','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-05-20 23:21:40.715774','2026-05-23 13:43:40.715847'); INSERT INTO reports VALUES(173,68,80,'MRL-20260523-C0F258','NO_PASO','Llevamos 2 días sin recolección.','EN_PROCESO','2026-05-08 06:27:40.715909','2026-05-23 13:43:40.715982'); INSERT INTO reports VALUES(174,111,154,'MRL-20260523-C37943','NO_PASO','Hoy no escuché el camión.','EN_PROCESO','2026-04-07 10:57:40.716065','2026-05-23 13:43:40.716166'); INSERT INTO reports VALUES(175,121,167,'MRL-20260523-F9EF68','ACUMULACION','Bote desbordado en parada de camión.','PENDIENTE','2026-04-01 10:05:40.716244','2026-05-23 13:43:40.716337'); INSERT INTO reports VALUES(176,111,154,'MRL-20260523-6D315C','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-05-18 11:45:40.716404','2026-05-23 13:43:40.716489'); INSERT INTO reports VALUES(177,123,172,'MRL-20260523-D07B83','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-03-25 09:48:40.716555','2026-05-23 13:43:40.716632'); INSERT INTO reports VALUES(178,89,117,'MRL-20260523-07F049','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-04-12 17:19:40.716696','2026-05-23 13:43:40.716773'); INSERT INTO reports VALUES(179,38,28,'MRL-20260523-63FE36','NO_PASO','Llevamos 2 días sin recolección.','PENDIENTE','2026-04-17 09:23:40.716835','2026-05-23 13:43:40.716913'); INSERT INTO reports VALUES(180,180,258,'MRL-20260523-976336','ACUMULACION','Mal olor por basura acumulada.','PENDIENTE','2026-04-24 18:07:40.716975','2026-05-23 13:43:40.717051'); INSERT INTO reports VALUES(181,180,259,'MRL-20260523-212627','NO_PASO','El camión saltó nuestra cuadra.','EN_PROCESO','2026-05-14 09:22:40.717117','2026-05-23 13:43:40.717205'); INSERT INTO reports VALUES(182,47,43,'MRL-20260523-90CC7F','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-04-28 05:38:40.717277','2026-05-23 13:43:40.717405'); INSERT INTO reports VALUES(183,143,205,'MRL-20260523-EA197C','RETRASO','Llegó cuando ya nos íbamos a trabajar.','RESUELTO','2026-04-05 09:13:40.717538','2026-05-23 13:43:40.717628'); INSERT INTO reports VALUES(184,194,287,'MRL-20260523-D095CB','NO_PASO','Llevamos 2 días sin recolección.','EN_PROCESO','2026-05-10 20:04:40.717714','2026-05-23 13:43:40.717800'); INSERT INTO reports VALUES(185,184,269,'MRL-20260523-4F9240','NO_PASO','El camión saltó nuestra cuadra.','PENDIENTE','2026-05-02 15:44:40.717865','2026-05-23 13:43:40.717946'); INSERT INTO reports VALUES(186,198,295,'MRL-20260523-43C98A','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-04-30 02:31:40.718059','2026-05-23 13:43:40.718177'); INSERT INTO reports VALUES(187,120,165,'MRL-20260523-60648F','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-05-13 02:04:40.718259','2026-05-23 13:43:40.718351'); INSERT INTO reports VALUES(188,159,227,'MRL-20260523-213B37','RETRASO','Llegó cuando ya nos íbamos a trabajar.','EN_PROCESO','2026-05-10 16:20:40.718430','2026-05-23 13:43:40.718510'); INSERT INTO reports VALUES(189,68,80,'MRL-20260523-3AB03F','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-04-06 12:28:40.718574','2026-05-23 13:43:40.718650'); INSERT INTO reports VALUES(190,65,76,'MRL-20260523-B77552','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-05-01 14:52:40.718713','2026-05-23 13:43:40.718788'); INSERT INTO reports VALUES(191,55,57,'MRL-20260523-C511F6','NO_PASO','No vi pasar el camión en su horario.','EN_PROCESO','2026-05-09 14:09:40.718849','2026-05-23 13:43:40.718924'); INSERT INTO reports VALUES(192,85,109,'MRL-20260523-56DD02','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-17 22:04:40.718984','2026-05-23 13:43:40.719058'); INSERT INTO reports VALUES(193,64,73,'MRL-20260523-E412DB','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-04-15 16:10:40.719118','2026-05-23 13:43:40.719191'); INSERT INTO reports VALUES(194,33,23,'MRL-20260523-BC7D11','NO_PASO','Hoy no escuché el camión.','PENDIENTE','2026-04-02 15:04:40.719252','2026-05-23 13:43:40.719325'); INSERT INTO reports VALUES(195,103,139,'MRL-20260523-183943','NO_PASO','El camión no pasó por mi calle.','RESUELTO','2026-05-19 01:01:40.719386','2026-05-23 13:43:40.719465'); INSERT INTO reports VALUES(196,103,139,'MRL-20260523-4243F9','ACUMULACION','Acumulación que atrae perros.','CERRADO','2026-03-29 10:42:40.719526','2026-05-23 13:43:40.719600'); INSERT INTO reports VALUES(197,109,150,'MRL-20260523-D1ED15','ACUMULACION','Bolsas regadas en la calle desde hace días.','RESUELTO','2026-04-28 20:58:40.719671','2026-05-23 13:43:40.719747'); INSERT INTO reports VALUES(198,52,51,'MRL-20260523-1FB0D7','OTRO','Felicitación al equipo del camión.','EN_PROCESO','2026-04-19 11:32:40.719814','2026-05-23 13:43:40.719892'); INSERT INTO reports VALUES(199,82,102,'MRL-20260523-9D2EE3','RETRASO','Pasó más de una hora tarde.','EN_PROCESO','2026-05-21 05:44:40.719950','2026-05-23 13:43:40.720024'); INSERT INTO reports VALUES(200,186,272,'MRL-20260523-2490FD','NO_PASO','Hoy no escuché el camión.','EN_PROCESO','2026-05-22 02:00:40.720087','2026-05-23 13:43:40.720161'); INSERT INTO reports VALUES(201,127,181,'MRL-20260523-6A1FA9','RETRASO','Estuvo retrasado más de 90 minutos.','EN_PROCESO','2026-05-06 12:03:40.720224','2026-05-23 13:43:40.720296'); INSERT INTO reports VALUES(202,98,132,'MRL-20260523-CB1B9D','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-03-23 20:26:40.720358','2026-05-23 13:43:40.720438'); INSERT INTO reports VALUES(203,88,116,'MRL-20260523-491485','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-05-17 14:19:40.720507','2026-05-23 13:43:40.720586'); INSERT INTO reports VALUES(204,184,267,'MRL-20260523-F1F069','OTRO','Pregunta sobre separación de residuos.','RESUELTO','2026-04-27 06:07:40.720645','2026-05-23 13:43:40.720718'); INSERT INTO reports VALUES(205,67,79,'MRL-20260523-CA1A3C','RETRASO','Estuvo retrasado más de 90 minutos.','EN_PROCESO','2026-05-01 23:09:40.720776','2026-05-23 13:43:40.720850'); INSERT INTO reports VALUES(206,61,68,'MRL-20260523-6399B7','NO_PASO','Llevamos 2 días sin recolección.','PENDIENTE','2026-04-10 06:48:40.720915','2026-05-23 13:43:40.720989'); INSERT INTO reports VALUES(207,63,71,'MRL-20260523-0ECC63','NO_PASO','Llevamos 2 días sin recolección.','RESUELTO','2026-03-26 09:16:40.721049','2026-05-23 13:43:40.721122'); INSERT INTO reports VALUES(208,64,75,'MRL-20260523-19F375','ACUMULACION','Bolsas regadas en la calle desde hace días.','RESUELTO','2026-05-03 11:08:40.721184','2026-05-23 13:43:40.721257'); INSERT INTO reports VALUES(209,187,273,'MRL-20260523-511111','OTRO','Comentario general sobre el servicio.','PENDIENTE','2026-03-31 08:57:40.721318','2026-05-23 13:43:40.721392'); INSERT INTO reports VALUES(210,30,16,'MRL-20260523-880C36','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-04-27 04:15:40.721452','2026-05-23 13:43:40.721527'); INSERT INTO reports VALUES(211,105,141,'MRL-20260523-E1238C','NO_PASO','Hoy no escuché el camión.','PENDIENTE','2026-05-12 12:55:40.721596','2026-05-23 13:43:40.721671'); INSERT INTO reports VALUES(212,102,137,'MRL-20260523-E61378','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-05-09 06:00:40.721732','2026-05-23 13:43:40.721811'); INSERT INTO reports VALUES(213,28,14,'MRL-20260523-0BBC41','RETRASO','Llegó casi a mediodía.','RESUELTO','2026-05-14 20:49:40.721872','2026-05-23 13:43:40.721945'); INSERT INTO reports VALUES(214,170,241,'MRL-20260523-ED84DB','ACUMULACION','Mal olor por basura acumulada.','EN_PROCESO','2026-04-21 22:35:40.722006','2026-05-23 13:43:40.722085'); INSERT INTO reports VALUES(215,71,84,'MRL-20260523-758D8E','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-03-25 05:17:40.722145','2026-05-23 13:43:40.722219'); INSERT INTO reports VALUES(216,87,114,'MRL-20260523-8A7FC5','ACUMULACION','Bolsas regadas en la calle desde hace días.','CERRADO','2026-05-19 07:44:40.722279','2026-05-23 13:43:40.722353'); INSERT INTO reports VALUES(217,157,225,'MRL-20260523-4BD82D','ACUMULACION','Acumulación que atrae perros.','EN_PROCESO','2026-03-28 22:47:40.722417','2026-05-23 13:43:40.722491'); INSERT INTO reports VALUES(218,95,127,'MRL-20260523-84D08A','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-04-06 00:57:40.722550','2026-05-23 13:43:40.722623'); INSERT INTO reports VALUES(219,117,161,'MRL-20260523-9B9012','RETRASO','Estuvo retrasado más de 90 minutos.','CERRADO','2026-04-14 20:10:40.722683','2026-05-23 13:43:40.722756'); INSERT INTO reports VALUES(220,32,20,'MRL-20260523-E22E24','RETRASO','Pasó más de una hora tarde.','EN_PROCESO','2026-03-28 06:10:40.722816','2026-05-23 13:43:40.722889'); INSERT INTO reports VALUES(221,188,276,'MRL-20260523-E025AA','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-04-28 20:55:40.722954','2026-05-23 13:43:40.723028'); INSERT INTO reports VALUES(222,36,26,'MRL-20260523-A0F32E','NO_PASO','No vi pasar el camión en su horario.','EN_PROCESO','2026-04-04 04:14:40.723087','2026-05-23 13:43:40.723161'); INSERT INTO reports VALUES(223,73,86,'MRL-20260523-DF9EE4','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-04-08 20:46:40.723220','2026-05-23 13:43:40.723294'); INSERT INTO reports VALUES(224,64,73,'MRL-20260523-3DBE13','RETRASO','Pasó más de una hora tarde.','RESUELTO','2026-04-06 21:36:40.723415','2026-05-23 13:43:40.723500'); INSERT INTO reports VALUES(225,77,93,'MRL-20260523-CD6F74','ACUMULACION','Bote desbordado en parada de camión.','CERRADO','2026-05-15 01:17:40.723566','2026-05-23 13:43:40.723643'); INSERT INTO reports VALUES(226,120,166,'MRL-20260523-6BF802','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-03-26 14:46:40.723709','2026-05-23 13:43:40.723784'); INSERT INTO reports VALUES(227,83,104,'MRL-20260523-C475CB','ACUMULACION','Acumulación que atrae perros.','PENDIENTE','2026-04-08 16:45:40.723844','2026-05-23 13:43:40.723916'); INSERT INTO reports VALUES(228,71,84,'MRL-20260523-7BA0A1','ACUMULACION','Hay basura acumulada en la esquina.','PENDIENTE','2026-04-07 23:03:40.723975','2026-05-23 13:43:40.724048'); INSERT INTO reports VALUES(229,131,186,'MRL-20260523-ECF60E','NO_PASO','Llevamos 2 días sin recolección.','RESUELTO','2026-04-14 08:19:40.724107','2026-05-23 13:43:40.724180'); INSERT INTO reports VALUES(230,192,282,'MRL-20260523-7B936A','RETRASO','El retraso es de cada vez peor en la semana.','RESUELTO','2026-04-16 15:48:40.724237','2026-05-23 13:43:40.724310'); INSERT INTO reports VALUES(231,66,77,'MRL-20260523-342093','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-04-27 04:24:40.724369','2026-05-23 13:43:40.724446'); INSERT INTO reports VALUES(232,160,229,'MRL-20260523-1BDCB3','NO_PASO','Hoy no escuché el camión.','PENDIENTE','2026-05-11 13:04:40.724514','2026-05-23 13:43:40.724592'); INSERT INTO reports VALUES(233,96,130,'MRL-20260523-7CA914','NO_PASO','El camión saltó nuestra cuadra.','EN_PROCESO','2026-04-19 13:05:40.724651','2026-05-23 13:43:40.724722'); INSERT INTO reports VALUES(234,177,253,'MRL-20260523-D329E6','NO_PASO','El camión saltó nuestra cuadra.','RESUELTO','2026-04-24 00:15:40.724781','2026-05-23 13:43:40.724860'); INSERT INTO reports VALUES(235,45,41,'MRL-20260523-78BDA3','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-05-05 18:03:40.724925','2026-05-23 13:43:40.725003'); INSERT INTO reports VALUES(236,193,286,'MRL-20260523-B57FED','ACUMULACION','Bolsas regadas en la calle desde hace días.','PENDIENTE','2026-05-14 12:02:40.725061','2026-05-23 13:43:40.725134'); INSERT INTO reports VALUES(237,126,179,'MRL-20260523-854D37','NO_PASO','Llevamos 2 días sin recolección.','RESUELTO','2026-03-30 18:24:40.725191','2026-05-23 13:43:40.725263'); INSERT INTO reports VALUES(238,123,170,'MRL-20260523-41BC9C','OTRO','¿Cuándo van a pasar por electrónicos?','PENDIENTE','2026-05-12 08:00:40.725321','2026-05-23 13:43:40.725392'); INSERT INTO reports VALUES(239,107,146,'MRL-20260523-B89A70','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-04-16 20:32:40.725460','2026-05-23 13:43:40.725541'); INSERT INTO reports VALUES(240,163,234,'MRL-20260523-CEDDAE','ACUMULACION','Hay basura acumulada en la esquina.','EN_PROCESO','2026-05-18 04:23:40.725610','2026-05-23 13:43:40.725789'); INSERT INTO reports VALUES(241,132,189,'MRL-20260523-D0B27D','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-03-30 20:39:40.725913','2026-05-23 13:43:40.726055'); INSERT INTO reports VALUES(242,109,150,'MRL-20260523-6349FA','RETRASO','El retraso es de cada vez peor en la semana.','PENDIENTE','2026-05-01 21:17:40.726120','2026-05-23 13:43:40.726200'); INSERT INTO reports VALUES(243,184,269,'MRL-20260523-FCD65F','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-05-16 18:57:40.726267','2026-05-23 13:43:40.726359'); INSERT INTO reports VALUES(244,186,271,'MRL-20260523-0F3F9B','OTRO','Felicitación al equipo del camión.','EN_PROCESO','2026-03-24 15:25:40.726419','2026-05-23 13:43:40.726501'); INSERT INTO reports VALUES(245,153,219,'MRL-20260523-DA0C5D','RETRASO','Estuvo retrasado más de 90 minutos.','EN_PROCESO','2026-04-16 18:21:40.726563','2026-05-23 13:43:40.726641'); INSERT INTO reports VALUES(246,61,67,'MRL-20260523-72F7F4','RETRASO','Llegó casi a mediodía.','EN_PROCESO','2026-04-22 07:47:40.726701','2026-05-23 13:43:40.726781'); INSERT INTO reports VALUES(247,90,120,'MRL-20260523-81DC74','ACUMULACION','Hay basura acumulada en la esquina.','CERRADO','2026-05-16 13:14:40.726840','2026-05-23 13:43:40.726917'); INSERT INTO reports VALUES(248,56,61,'MRL-20260523-A26CE5','ACUMULACION','Bote desbordado en parada de camión.','PENDIENTE','2026-04-27 00:41:40.726975','2026-05-23 13:43:40.727048'); INSERT INTO reports VALUES(249,123,171,'MRL-20260523-15C91C','NO_PASO','Hoy no escuché el camión.','RESUELTO','2026-05-22 17:31:40.727113','2026-05-23 13:43:40.727193'); INSERT INTO reports VALUES(250,107,145,'MRL-20260523-48A0EB','NO_PASO','No vi pasar el camión en su horario.','PENDIENTE','2026-04-20 20:23:40.727264','2026-05-23 13:43:40.727337'); INSERT INTO reports VALUES(251,19,4,'MRL-20260523-377030','NO_PASO','El camión saltó nuestra cuadra.','EN_PROCESO','2026-04-06 19:04:40.727402','2026-05-23 13:43:40.727473'); INSERT INTO reports VALUES(252,29,15,'MRL-20260523-0384B1','ACUMULACION','Acumulación que atrae perros.','PENDIENTE','2026-03-24 16:13:40.727532','2026-05-23 13:43:40.727604'); INSERT INTO reports VALUES(253,171,243,'MRL-20260523-F00F5B','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-05-13 17:14:40.727666','2026-05-23 13:43:40.727742'); INSERT INTO reports VALUES(254,188,275,'MRL-20260523-CA1CDC','ACUMULACION','Mal olor por basura acumulada.','EN_PROCESO','2026-03-24 14:40:40.727804','2026-05-23 13:43:40.727876'); INSERT INTO reports VALUES(255,184,267,'MRL-20260523-BE6689','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-04-17 20:42:40.727933','2026-05-23 13:43:40.728006'); INSERT INTO reports VALUES(256,85,107,'MRL-20260523-B33962','RETRASO','El retraso es de cada vez peor en la semana.','EN_PROCESO','2026-05-19 09:26:40.728064','2026-05-23 13:43:40.728135'); INSERT INTO reports VALUES(257,30,16,'MRL-20260523-816A63','NO_PASO','Llevamos 2 días sin recolección.','EN_PROCESO','2026-03-31 08:07:40.728195','2026-05-23 13:43:40.728267'); INSERT INTO reports VALUES(258,140,200,'MRL-20260523-1C88A0','NO_PASO','No vi pasar el camión en su horario.','PENDIENTE','2026-04-08 02:58:40.728327','2026-05-23 13:43:40.728399'); INSERT INTO reports VALUES(259,31,17,'MRL-20260523-59C98D','NO_PASO','Hoy no escuché el camión.','PENDIENTE','2026-04-29 22:50:40.728467','2026-05-23 13:43:40.728539'); INSERT INTO reports VALUES(260,112,155,'MRL-20260523-A3EFE8','NO_PASO','El camión no pasó por mi calle.','EN_PROCESO','2026-04-30 11:54:40.728596','2026-05-23 13:43:40.728672'); INSERT INTO reports VALUES(261,83,104,'MRL-20260523-4CA0D9','OTRO','Solicito información sobre días festivos.','EN_PROCESO','2026-04-01 21:46:40.728736','2026-05-23 13:43:40.728810'); INSERT INTO reports VALUES(262,179,257,'MRL-20260523-B0770E','NO_PASO','El camión saltó nuestra cuadra.','EN_PROCESO','2026-04-06 21:24:40.728881','2026-05-23 13:43:40.728963'); INSERT INTO reports VALUES(263,121,168,'MRL-20260523-96F016','NO_PASO','Llevamos 2 días sin recolección.','RESUELTO','2026-04-10 09:30:40.729022','2026-05-23 13:43:40.729093'); INSERT INTO reports VALUES(264,32,19,'MRL-20260523-9E2DA0','RETRASO','Estuvo retrasado más de 90 minutos.','RESUELTO','2026-05-16 13:24:40.729153','2026-05-23 13:43:40.729229'); INSERT INTO reports VALUES(265,33,23,'MRL-20260523-0974DF','ACUMULACION','Hay basura acumulada en la esquina.','RESUELTO','2026-05-01 22:47:40.729289','2026-05-23 13:43:40.729363'); INSERT INTO reports VALUES(266,34,24,'MRL-20260523-3FFE0F','NO_PASO','No vi pasar el camión en su horario.','RESUELTO','2026-05-21 18:55:40.729426','2026-05-23 13:43:40.729500'); INSERT INTO reports VALUES(267,116,160,'MRL-20260523-D2280E','RETRASO','Llegó cuando ya nos íbamos a trabajar.','PENDIENTE','2026-05-11 04:26:40.729560','2026-05-23 13:43:40.729634'); INSERT INTO reports VALUES(268,187,273,'MRL-20260523-E322F8','NO_PASO','El camión no pasó por mi calle.','EN_PROCESO','2026-05-06 09:33:40.729694','2026-05-23 13:43:40.729768'); INSERT INTO reports VALUES(269,105,141,'MRL-20260523-A768C4','NO_PASO','Llevamos 2 días sin recolección.','CERRADO','2026-04-21 10:30:40.729828','2026-05-23 13:43:40.729907'); INSERT INTO reports VALUES(270,189,278,'MRL-20260523-6ED5DD','RETRASO','Llegó cuando ya nos íbamos a trabajar.','EN_PROCESO','2026-03-23 14:52:40.729967','2026-05-23 13:43:40.730041'); INSERT INTO reports VALUES(271,107,146,'MRL-20260523-5EE230','RETRASO','El retraso es de cada vez peor en la semana.','PENDIENTE','2026-04-14 03:09:40.730105','2026-05-23 13:43:40.730177'); INSERT INTO reports VALUES(272,159,228,'MRL-20260523-E7C016','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-05-17 01:40:40.730236','2026-05-23 13:43:40.730311'); INSERT INTO reports VALUES(273,48,45,'MRL-20260523-2EAB4D','RETRASO','Estuvo retrasado más de 90 minutos.','PENDIENTE','2026-03-26 19:03:40.730373','2026-05-23 13:43:40.730446'); INSERT INTO reports VALUES(274,160,229,'MRL-20260523-9146F8','RETRASO','Llegó cuando ya nos íbamos a trabajar.','EN_PROCESO','2026-04-07 15:52:40.730505','2026-05-23 13:43:40.730578'); INSERT INTO reports VALUES(275,188,274,'MRL-20260523-A57CB3','NO_PASO','El camión saltó nuestra cuadra.','CERRADO','2026-04-17 09:38:40.730639','2026-05-23 13:43:40.730717'); INSERT INTO reports VALUES(276,169,240,'MRL-20260523-74D032','NO_PASO','El camión saltó nuestra cuadra.','EN_PROCESO','2026-04-23 06:29:40.730776','2026-05-23 13:43:40.730849'); INSERT INTO reports VALUES(277,64,74,'MRL-20260523-A8AB70','ACUMULACION','Acumulación que atrae perros.','RESUELTO','2026-04-28 07:59:40.730908','2026-05-23 13:43:40.730981'); INSERT INTO reports VALUES(278,123,170,'MRL-20260523-792C4C','ACUMULACION','Mal olor por basura acumulada.','RESUELTO','2026-04-22 13:39:40.731040','2026-05-23 13:43:40.731113'); INSERT INTO reports VALUES(279,172,244,'MRL-20260523-DFDB0B','NO_PASO','Hoy no escuché el camión.','EN_PROCESO','2026-05-05 02:05:40.731173','2026-05-23 13:43:40.731251'); INSERT INTO reports VALUES(280,198,295,'MRL-20260523-BF9F0D','NO_PASO','El camión no pasó por mi calle.','PENDIENTE','2026-05-02 20:02:40.731311','2026-05-23 13:43:40.731361'); CREATE TABLE service_ratings ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, address_id INTEGER NOT NULL, rating INTEGER NOT NULL, comment TEXT, created_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES users (id), FOREIGN KEY(address_id) REFERENCES addresses (id) ); INSERT INTO service_ratings VALUES(1,104,140,5,NULL,'2026-04-19 22:16:40.779311'); INSERT INTO service_ratings VALUES(2,85,108,5,'Servicio puntual, gracias.','2026-04-12 04:11:40.779711'); INSERT INTO service_ratings VALUES(3,111,154,5,NULL,'2026-05-03 07:17:40.779949'); INSERT INTO service_ratings VALUES(4,144,206,5,NULL,'2026-04-23 15:55:40.780168'); INSERT INTO service_ratings VALUES(5,191,281,5,'Servicio puntual, gracias.','2026-04-12 15:10:40.780387'); INSERT INTO service_ratings VALUES(6,79,96,4,'Buen trabajo del equipo.','2026-04-10 14:14:40.780601'); INSERT INTO service_ratings VALUES(7,103,138,2,NULL,'2026-04-13 23:44:40.780808'); INSERT INTO service_ratings VALUES(8,196,290,4,'Servicio puntual, gracias.','2026-04-20 07:20:40.781019'); INSERT INTO service_ratings VALUES(9,166,237,5,'Buen trabajo del equipo.','2026-04-10 03:49:40.781226'); INSERT INTO service_ratings VALUES(10,156,223,5,NULL,'2026-05-18 17:30:40.781426'); INSERT INTO service_ratings VALUES(11,148,212,5,'Mejoró mucho este mes.','2026-04-12 08:27:40.781633'); INSERT INTO service_ratings VALUES(12,91,121,5,'Servicio puntual, gracias.','2026-05-14 07:42:40.781840'); INSERT INTO service_ratings VALUES(13,94,126,3,NULL,'2026-05-03 23:12:40.782112'); INSERT INTO service_ratings VALUES(14,194,287,1,NULL,'2026-04-12 12:31:40.782349'); INSERT INTO service_ratings VALUES(15,69,82,5,'Servicio puntual, gracias.','2026-05-07 05:01:40.782568'); INSERT INTO service_ratings VALUES(16,192,282,5,NULL,'2026-05-20 14:12:40.782778'); INSERT INTO service_ratings VALUES(17,26,11,5,'Servicio puntual, gracias.','2026-05-02 18:24:40.782993'); INSERT INTO service_ratings VALUES(18,40,33,2,NULL,'2026-04-29 16:01:40.783205'); INSERT INTO service_ratings VALUES(19,49,47,5,NULL,'2026-05-15 06:36:40.783408'); INSERT INTO service_ratings VALUES(20,197,293,4,'Servicio puntual, gracias.','2026-04-19 15:50:40.783616'); INSERT INTO service_ratings VALUES(21,200,298,2,NULL,'2026-05-06 21:47:40.783883'); INSERT INTO service_ratings VALUES(22,49,47,5,'Servicio puntual, gracias.','2026-05-03 02:50:40.784090'); INSERT INTO service_ratings VALUES(23,201,300,4,NULL,'2026-05-08 00:30:40.784351'); INSERT INTO service_ratings VALUES(24,64,74,5,'Buen trabajo del equipo.','2026-05-05 23:17:40.784568'); INSERT INTO service_ratings VALUES(25,97,131,3,NULL,'2026-05-19 22:09:40.784777'); INSERT INTO service_ratings VALUES(26,134,192,4,'Servicio puntual, gracias.','2026-05-02 20:16:40.784983'); INSERT INTO service_ratings VALUES(27,172,244,4,'Mejoró mucho este mes.','2026-05-14 02:13:40.785207'); INSERT INTO service_ratings VALUES(28,132,189,3,NULL,'2026-05-21 16:46:40.785420'); INSERT INTO service_ratings VALUES(29,31,18,3,NULL,'2026-04-11 11:59:40.785628'); INSERT INTO service_ratings VALUES(30,92,123,5,'Excelente atención.','2026-05-03 16:59:40.785836'); INSERT INTO service_ratings VALUES(31,131,186,2,'Llegaron tarde varias veces.','2026-04-19 05:49:40.786048'); INSERT INTO service_ratings VALUES(32,159,227,5,'Excelente atención.','2026-05-07 04:38:40.786252'); INSERT INTO service_ratings VALUES(33,91,121,5,NULL,'2026-05-12 23:03:40.786367'); INSERT INTO service_ratings VALUES(34,119,163,3,NULL,'2026-04-11 23:53:40.786572'); INSERT INTO service_ratings VALUES(35,31,18,5,'Servicio puntual, gracias.','2026-04-21 21:56:40.786687'); INSERT INTO service_ratings VALUES(36,148,212,2,'Hicieron mucho ruido.','2026-04-07 23:47:40.786801'); INSERT INTO service_ratings VALUES(37,52,52,3,NULL,'2026-04-09 05:11:40.787005'); INSERT INTO service_ratings VALUES(38,40,34,5,NULL,'2026-04-17 14:23:40.787223'); INSERT INTO service_ratings VALUES(39,162,233,4,NULL,'2026-05-19 17:02:40.787430'); INSERT INTO service_ratings VALUES(40,79,95,4,NULL,'2026-04-12 09:43:40.787637'); INSERT INTO service_ratings VALUES(41,144,206,5,'Mejoró mucho este mes.','2026-05-02 19:38:40.787756'); INSERT INTO service_ratings VALUES(42,55,57,5,NULL,'2026-04-07 16:55:40.787959'); INSERT INTO service_ratings VALUES(43,61,67,3,NULL,'2026-04-09 23:53:40.788162'); INSERT INTO service_ratings VALUES(44,120,164,4,NULL,'2026-05-15 05:32:40.788369'); INSERT INTO service_ratings VALUES(45,121,168,3,NULL,'2026-05-11 11:17:40.788577'); INSERT INTO service_ratings VALUES(46,132,189,5,'Excelente atención.','2026-04-17 06:42:40.788697'); INSERT INTO service_ratings VALUES(47,27,12,2,NULL,'2026-04-13 05:45:40.788899'); INSERT INTO service_ratings VALUES(48,48,46,1,'Falta limpieza después del paso.','2026-05-06 14:49:40.789104'); INSERT INTO service_ratings VALUES(49,74,87,5,NULL,'2026-04-25 18:27:40.789305'); INSERT INTO service_ratings VALUES(50,66,77,5,'Mejoró mucho este mes.','2026-05-12 19:36:40.789507'); INSERT INTO service_ratings VALUES(51,23,8,4,'Excelente atención.','2026-04-23 16:12:40.789712'); INSERT INTO service_ratings VALUES(52,56,61,5,'Buen trabajo del equipo.','2026-05-11 05:25:40.789913'); INSERT INTO service_ratings VALUES(53,178,254,5,'Excelente atención.','2026-05-09 18:30:40.790137'); INSERT INTO service_ratings VALUES(54,107,145,4,'Buen trabajo del equipo.','2026-04-27 08:17:40.790342'); INSERT INTO service_ratings VALUES(55,64,75,5,'Mejoró mucho este mes.','2026-05-07 18:15:40.790548'); INSERT INTO service_ratings VALUES(56,95,128,5,NULL,'2026-04-11 23:38:40.790745'); INSERT INTO service_ratings VALUES(57,21,6,4,NULL,'2026-05-02 15:18:40.790945'); INSERT INTO service_ratings VALUES(58,85,109,4,NULL,'2026-04-25 14:05:40.791165'); INSERT INTO service_ratings VALUES(59,98,132,5,NULL,'2026-05-20 12:22:40.791366'); INSERT INTO service_ratings VALUES(60,91,121,4,'Mejoró mucho este mes.','2026-04-14 15:52:40.791480'); INSERT INTO service_ratings VALUES(61,34,24,5,NULL,'2026-04-14 01:24:40.791691'); INSERT INTO service_ratings VALUES(62,143,203,4,'Buen trabajo del equipo.','2026-04-18 12:06:40.792051'); INSERT INTO service_ratings VALUES(63,77,92,5,NULL,'2026-04-22 02:47:40.792281'); INSERT INTO service_ratings VALUES(64,169,240,5,'Mejoró mucho este mes.','2026-04-07 21:16:40.792488'); INSERT INTO service_ratings VALUES(65,64,73,5,'Mejoró mucho este mes.','2026-05-21 09:12:40.792699'); INSERT INTO service_ratings VALUES(66,107,144,4,'Excelente atención.','2026-05-05 05:04:40.792901'); INSERT INTO service_ratings VALUES(67,101,136,4,'Excelente atención.','2026-05-13 02:56:40.793098'); INSERT INTO service_ratings VALUES(68,177,252,3,NULL,'2026-05-13 19:49:40.793296'); INSERT INTO service_ratings VALUES(69,158,226,5,'Buen trabajo del equipo.','2026-05-20 06:32:40.793498'); INSERT INTO service_ratings VALUES(70,32,19,4,'Buen trabajo del equipo.','2026-04-07 23:16:40.793713'); INSERT INTO service_ratings VALUES(71,56,60,1,NULL,'2026-05-20 23:21:40.793909'); INSERT INTO service_ratings VALUES(72,195,288,4,'Excelente atención.','2026-05-15 13:48:40.794113'); INSERT INTO service_ratings VALUES(73,65,76,5,'Servicio puntual, gracias.','2026-05-10 04:32:40.794313'); INSERT INTO service_ratings VALUES(74,74,87,4,NULL,'2026-05-05 18:46:40.794428'); INSERT INTO service_ratings VALUES(75,201,300,5,'Servicio puntual, gracias.','2026-04-19 19:32:40.794545'); INSERT INTO service_ratings VALUES(76,150,214,2,'Falta limpieza después del paso.','2026-04-21 16:37:40.794756'); INSERT INTO service_ratings VALUES(77,122,169,5,NULL,'2026-04-10 10:18:40.794996'); INSERT INTO service_ratings VALUES(78,134,192,4,'Servicio puntual, gracias.','2026-05-03 09:42:40.795109'); INSERT INTO service_ratings VALUES(79,46,42,4,NULL,'2026-04-10 22:14:40.795304'); INSERT INTO service_ratings VALUES(80,103,138,4,'Servicio puntual, gracias.','2026-05-02 12:02:40.795425'); INSERT INTO service_ratings VALUES(81,162,232,5,NULL,'2026-04-17 09:30:40.795639'); INSERT INTO service_ratings VALUES(82,35,25,3,NULL,'2026-05-05 02:52:40.795838'); INSERT INTO service_ratings VALUES(83,39,29,4,NULL,'2026-04-15 01:38:40.796052'); INSERT INTO service_ratings VALUES(84,143,205,5,'Buen trabajo del equipo.','2026-04-28 11:42:40.796254'); INSERT INTO service_ratings VALUES(85,85,107,5,NULL,'2026-04-28 04:02:40.796456'); INSERT INTO service_ratings VALUES(86,67,79,5,'Excelente atención.','2026-04-25 13:52:40.796662'); INSERT INTO service_ratings VALUES(87,115,159,2,NULL,'2026-05-15 02:01:40.796867'); INSERT INTO service_ratings VALUES(88,51,50,3,NULL,'2026-04-21 07:12:40.797073'); INSERT INTO service_ratings VALUES(89,160,229,3,NULL,'2026-04-23 05:07:40.797275'); INSERT INTO service_ratings VALUES(90,152,217,5,'Excelente atención.','2026-04-29 18:32:40.797482'); INSERT INTO service_ratings VALUES(91,156,223,4,'Servicio puntual, gracias.','2026-05-20 21:22:40.797599'); INSERT INTO service_ratings VALUES(92,167,238,4,NULL,'2026-04-09 15:34:40.797802'); INSERT INTO service_ratings VALUES(93,178,254,4,NULL,'2026-04-20 11:25:40.797923'); INSERT INTO service_ratings VALUES(94,169,240,5,NULL,'2026-04-23 04:34:40.798038'); INSERT INTO service_ratings VALUES(95,60,66,4,'Mejoró mucho este mes.','2026-05-07 21:16:40.798241'); INSERT INTO service_ratings VALUES(96,110,152,4,NULL,'2026-05-19 12:11:40.798569'); INSERT INTO service_ratings VALUES(97,55,56,4,'Excelente atención.','2026-05-16 23:01:40.798862'); INSERT INTO service_ratings VALUES(98,197,292,3,NULL,'2026-05-01 05:06:40.799110'); INSERT INTO service_ratings VALUES(99,46,42,3,NULL,'2026-05-22 09:56:40.799238'); INSERT INTO service_ratings VALUES(100,166,237,5,'Buen trabajo del equipo.','2026-04-28 12:38:40.799361'); INSERT INTO service_ratings VALUES(101,150,214,3,NULL,'2026-05-04 03:06:40.799488'); INSERT INTO service_ratings VALUES(102,162,233,3,NULL,'2026-04-24 17:52:40.799618'); INSERT INTO service_ratings VALUES(103,101,136,5,NULL,'2026-05-12 07:32:40.799736'); INSERT INTO service_ratings VALUES(104,45,41,4,NULL,'2026-05-06 16:37:40.799968'); INSERT INTO service_ratings VALUES(105,156,223,4,'Servicio puntual, gracias.','2026-04-28 10:43:40.800088'); INSERT INTO service_ratings VALUES(106,74,88,4,'Excelente atención.','2026-04-09 00:48:40.800305'); INSERT INTO service_ratings VALUES(107,175,250,5,NULL,'2026-04-14 01:59:40.800530'); INSERT INTO service_ratings VALUES(108,143,203,3,NULL,'2026-05-18 09:35:40.800662'); INSERT INTO service_ratings VALUES(109,23,8,5,NULL,'2026-05-21 15:31:40.800963'); INSERT INTO service_ratings VALUES(110,28,14,5,NULL,'2026-05-13 17:28:40.801299'); INSERT INTO service_ratings VALUES(111,157,224,3,NULL,'2026-04-19 07:38:40.801542'); INSERT INTO service_ratings VALUES(112,112,155,3,NULL,'2026-05-13 22:16:40.801773'); INSERT INTO service_ratings VALUES(113,27,12,5,'Buen trabajo del equipo.','2026-04-08 23:12:40.801894'); INSERT INTO service_ratings VALUES(114,170,242,5,'Excelente atención.','2026-04-16 06:31:40.802105'); INSERT INTO service_ratings VALUES(115,110,151,4,NULL,'2026-04-28 12:22:40.802315'); INSERT INTO service_ratings VALUES(116,20,5,5,NULL,'2026-04-08 00:17:40.802525'); INSERT INTO service_ratings VALUES(117,178,254,4,NULL,'2026-04-18 04:41:40.802640'); INSERT INTO service_ratings VALUES(118,175,250,5,NULL,'2026-04-15 14:04:40.802754'); INSERT INTO service_ratings VALUES(119,175,250,5,'Servicio puntual, gracias.','2026-04-20 13:16:40.802872'); INSERT INTO service_ratings VALUES(120,199,296,5,'Servicio puntual, gracias.','2026-05-05 17:17:40.803080'); INSERT INTO service_ratings VALUES(121,171,243,5,NULL,'2026-04-12 02:15:40.803299'); INSERT INTO service_ratings VALUES(122,157,224,5,'Mejoró mucho este mes.','2026-05-10 22:21:40.803422'); INSERT INTO service_ratings VALUES(123,157,225,5,'Buen trabajo del equipo.','2026-04-15 16:22:40.803625'); INSERT INTO service_ratings VALUES(124,169,240,5,'Mejoró mucho este mes.','2026-04-08 01:17:40.803745'); INSERT INTO service_ratings VALUES(125,130,185,3,NULL,'2026-05-12 18:30:40.803954'); INSERT INTO service_ratings VALUES(126,107,145,4,'Servicio puntual, gracias.','2026-04-10 22:35:40.804070'); INSERT INTO service_ratings VALUES(127,75,89,5,NULL,'2026-04-22 09:53:40.804273'); INSERT INTO service_ratings VALUES(128,149,213,2,NULL,'2026-05-04 06:30:40.804473'); INSERT INTO service_ratings VALUES(129,193,286,5,'Servicio puntual, gracias.','2026-05-01 05:21:40.804674'); INSERT INTO service_ratings VALUES(130,69,82,5,NULL,'2026-04-21 11:52:40.804789'); INSERT INTO service_ratings VALUES(131,40,33,5,'Servicio puntual, gracias.','2026-04-14 06:36:40.804903'); INSERT INTO service_ratings VALUES(132,195,288,5,'Mejoró mucho este mes.','2026-05-02 01:54:40.805016'); INSERT INTO service_ratings VALUES(133,34,24,3,NULL,'2026-04-18 04:46:40.805128'); INSERT INTO service_ratings VALUES(134,67,78,3,NULL,'2026-04-20 18:01:40.805328'); INSERT INTO service_ratings VALUES(135,53,54,4,'Excelente atención.','2026-04-24 10:37:40.805528'); INSERT INTO service_ratings VALUES(136,53,53,3,NULL,'2026-05-20 21:37:40.805726'); INSERT INTO service_ratings VALUES(137,73,86,4,NULL,'2026-05-10 02:33:40.805924'); INSERT INTO service_ratings VALUES(138,109,150,4,NULL,'2026-04-20 21:57:40.806122'); INSERT INTO service_ratings VALUES(139,52,51,5,'Mejoró mucho este mes.','2026-05-02 09:36:40.806320'); INSERT INTO service_ratings VALUES(140,83,104,5,'Excelente atención.','2026-05-23 05:50:40.806519'); INSERT INTO service_ratings VALUES(141,171,243,5,NULL,'2026-05-13 11:26:40.806633'); INSERT INTO service_ratings VALUES(142,133,191,4,'Excelente atención.','2026-04-29 17:01:40.806832'); INSERT INTO service_ratings VALUES(143,94,126,5,NULL,'2026-04-19 23:53:40.806946'); INSERT INTO service_ratings VALUES(144,89,117,5,'Excelente atención.','2026-04-26 23:46:40.807147'); INSERT INTO service_ratings VALUES(145,164,235,2,NULL,'2026-04-10 02:42:40.807356'); INSERT INTO service_ratings VALUES(146,159,227,5,'Servicio puntual, gracias.','2026-04-07 21:39:40.807471'); INSERT INTO service_ratings VALUES(147,48,44,5,'Excelente atención.','2026-05-13 00:40:40.807682'); INSERT INTO service_ratings VALUES(148,142,202,3,NULL,'2026-04-10 17:34:40.807887'); INSERT INTO service_ratings VALUES(149,198,295,5,NULL,'2026-04-07 15:47:40.808091'); INSERT INTO service_ratings VALUES(150,184,267,1,NULL,'2026-04-27 15:59:40.808300'); INSERT INTO service_ratings VALUES(151,193,284,3,NULL,'2026-05-03 02:43:40.808500'); INSERT INTO service_ratings VALUES(152,107,144,2,NULL,'2026-05-13 15:18:40.808638'); INSERT INTO service_ratings VALUES(153,160,229,4,NULL,'2026-04-13 18:02:40.808785'); INSERT INTO service_ratings VALUES(154,159,227,4,NULL,'2026-04-12 00:54:40.809123'); INSERT INTO service_ratings VALUES(155,82,102,3,NULL,'2026-05-18 12:09:40.809504'); INSERT INTO service_ratings VALUES(156,123,172,5,NULL,'2026-05-14 21:09:40.809723'); INSERT INTO service_ratings VALUES(157,107,146,5,NULL,'2026-04-18 04:10:40.809955'); INSERT INTO service_ratings VALUES(158,124,175,3,NULL,'2026-05-13 13:42:40.810164'); INSERT INTO service_ratings VALUES(159,189,277,4,'Buen trabajo del equipo.','2026-05-03 14:16:40.810371'); INSERT INTO service_ratings VALUES(160,180,259,5,'Servicio puntual, gracias.','2026-04-30 05:03:40.810571'); INSERT INTO service_ratings VALUES(161,180,260,5,'Servicio puntual, gracias.','2026-04-12 10:15:40.810769'); INSERT INTO service_ratings VALUES(162,110,153,4,'Servicio puntual, gracias.','2026-04-24 03:28:40.810966'); INSERT INTO service_ratings VALUES(163,200,298,4,NULL,'2026-04-10 19:49:40.811086'); INSERT INTO service_ratings VALUES(164,90,120,5,'Mejoró mucho este mes.','2026-04-10 15:07:40.811284'); INSERT INTO service_ratings VALUES(165,63,72,4,NULL,'2026-05-08 10:23:40.811481'); INSERT INTO service_ratings VALUES(166,182,265,4,NULL,'2026-04-29 23:37:40.811685'); INSERT INTO service_ratings VALUES(167,65,76,4,NULL,'2026-04-27 11:38:40.811799'); INSERT INTO service_ratings VALUES(168,40,32,5,'Buen trabajo del equipo.','2026-04-23 07:15:40.812001'); INSERT INTO service_ratings VALUES(169,44,40,5,NULL,'2026-04-27 19:08:40.812220'); INSERT INTO service_ratings VALUES(170,183,266,3,NULL,'2026-05-06 19:12:40.812435'); INSERT INTO service_ratings VALUES(171,152,217,1,NULL,'2026-04-27 08:34:40.812554'); INSERT INTO service_ratings VALUES(172,180,259,5,NULL,'2026-04-24 08:58:40.812666'); INSERT INTO service_ratings VALUES(173,181,263,3,NULL,'2026-05-15 15:30:40.812865'); INSERT INTO service_ratings VALUES(174,163,234,4,NULL,'2026-05-12 20:20:40.813062'); INSERT INTO service_ratings VALUES(175,56,61,4,'Excelente atención.','2026-05-16 10:20:40.813175'); INSERT INTO service_ratings VALUES(176,197,293,5,NULL,'2026-05-14 10:20:40.813289'); INSERT INTO service_ratings VALUES(177,113,157,1,'Hicieron mucho ruido.','2026-05-04 22:42:40.813488'); INSERT INTO service_ratings VALUES(178,64,74,5,NULL,'2026-04-27 11:44:40.813602'); INSERT INTO service_ratings VALUES(179,113,157,3,NULL,'2026-05-10 07:51:40.813714'); INSERT INTO service_ratings VALUES(180,176,251,5,NULL,'2026-05-01 10:48:40.813911'); INSERT INTO service_ratings VALUES(181,33,23,5,NULL,'2026-05-03 19:15:40.814107'); INSERT INTO service_ratings VALUES(182,124,173,3,NULL,'2026-04-22 13:50:40.814306'); INSERT INTO service_ratings VALUES(183,61,68,3,NULL,'2026-04-20 17:14:40.814505'); INSERT INTO service_ratings VALUES(184,161,231,4,'Buen trabajo del equipo.','2026-05-03 10:52:40.814702'); INSERT INTO service_ratings VALUES(185,146,210,5,'Excelente atención.','2026-05-01 20:41:40.814903'); INSERT INTO service_ratings VALUES(186,159,227,4,NULL,'2026-05-18 07:58:40.815024'); INSERT INTO service_ratings VALUES(187,27,13,4,NULL,'2026-04-08 04:08:40.815233'); INSERT INTO service_ratings VALUES(188,59,64,4,'Servicio puntual, gracias.','2026-05-10 18:09:40.815437'); INSERT INTO service_ratings VALUES(189,199,296,3,NULL,'2026-04-16 21:31:40.815556'); INSERT INTO service_ratings VALUES(190,172,244,4,'Servicio puntual, gracias.','2026-05-15 15:44:40.815672'); INSERT INTO service_ratings VALUES(191,187,273,5,'Servicio puntual, gracias.','2026-05-06 07:28:40.815875'); INSERT INTO service_ratings VALUES(192,199,297,5,NULL,'2026-04-18 18:23:40.816082'); INSERT INTO service_ratings VALUES(193,144,206,4,'Excelente atención.','2026-05-22 03:16:40.816200'); INSERT INTO service_ratings VALUES(194,77,93,5,NULL,'2026-04-20 03:19:40.816402'); INSERT INTO service_ratings VALUES(195,98,132,5,'Servicio puntual, gracias.','2026-04-19 08:25:40.816521'); INSERT INTO service_ratings VALUES(196,64,74,5,NULL,'2026-05-18 09:24:40.816635'); INSERT INTO service_ratings VALUES(197,146,209,4,'Servicio puntual, gracias.','2026-04-14 03:32:40.816859'); INSERT INTO service_ratings VALUES(198,28,14,4,'Mejoró mucho este mes.','2026-04-29 10:23:40.816982'); INSERT INTO service_ratings VALUES(199,64,73,5,'Mejoró mucho este mes.','2026-05-07 00:51:40.817099'); INSERT INTO service_ratings VALUES(200,57,62,5,'Buen trabajo del equipo.','2026-04-14 19:28:40.817634'); INSERT INTO service_ratings VALUES(201,177,253,4,NULL,'2026-04-29 10:26:40.817913'); INSERT INTO service_ratings VALUES(202,40,32,5,NULL,'2026-04-27 11:13:40.818044'); INSERT INTO service_ratings VALUES(203,29,15,5,'Buen trabajo del equipo.','2026-05-22 05:08:40.818292'); INSERT INTO service_ratings VALUES(204,202,301,4,'Buen trabajo del equipo.','2026-04-17 16:53:40.818526'); INSERT INTO service_ratings VALUES(205,60,65,5,'Excelente atención.','2026-04-25 10:49:40.818737'); INSERT INTO service_ratings VALUES(206,179,257,5,'Buen trabajo del equipo.','2026-04-29 20:33:40.818948'); INSERT INTO service_ratings VALUES(207,94,126,4,'Excelente atención.','2026-04-17 23:41:40.819069'); INSERT INTO service_ratings VALUES(208,1,1,3,NULL,'2026-04-14 04:02:40.819277'); INSERT INTO service_ratings VALUES(209,73,86,5,'Excelente atención.','2026-05-05 18:27:40.819403'); INSERT INTO service_ratings VALUES(210,136,195,1,'Falta limpieza después del paso.','2026-04-15 21:25:40.819610'); INSERT INTO service_ratings VALUES(211,34,24,5,NULL,'2026-04-17 11:24:40.819729'); INSERT INTO service_ratings VALUES(212,48,46,5,'Servicio puntual, gracias.','2026-05-14 14:08:40.819845'); INSERT INTO service_ratings VALUES(213,107,144,3,NULL,'2026-05-09 18:11:40.819962'); INSERT INTO service_ratings VALUES(214,119,163,3,NULL,'2026-05-01 17:27:40.820077'); INSERT INTO service_ratings VALUES(215,162,232,5,NULL,'2026-05-03 03:30:40.820193'); INSERT INTO service_ratings VALUES(216,165,236,2,'Hicieron mucho ruido.','2026-05-21 15:35:40.820423'); INSERT INTO service_ratings VALUES(217,19,2,4,'Servicio puntual, gracias.','2026-05-22 16:32:40.820650'); INSERT INTO service_ratings VALUES(218,148,212,4,NULL,'2026-04-07 21:55:40.820766'); INSERT INTO service_ratings VALUES(219,142,202,4,NULL,'2026-04-11 17:39:40.820889'); INSERT INTO service_ratings VALUES(220,188,276,5,NULL,'2026-04-10 23:00:40.821101'); CREATE TABLE operational_reports ( id INTEGER NOT NULL, employee_id INTEGER NOT NULL, folio VARCHAR NOT NULL, category VARCHAR NOT NULL, description TEXT, severity VARCHAR, route_id VARCHAR, truck_id INTEGER, status VARCHAR, created_at DATETIME, resolved_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(employee_id) REFERENCES users (id) ); INSERT INTO operational_reports VALUES(1,4,'OP-20260523-647D7C','COMBUSTIBLE','Tanque bajo, requiere recarga.','MEDIA','RUTA-04',27,'EN_ATENCION','2026-04-14 06:08:40.752067',NULL); INSERT INTO operational_reports VALUES(2,5,'OP-20260523-8D70F1','OTRO','Solicitud de mantenimiento preventivo.','BAJA','RUTA-13',53,'EN_ATENCION','2026-04-25 18:53:40.752516',NULL); INSERT INTO operational_reports VALUES(3,8,'OP-20260523-363838','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-15',5,'RESUELTO','2026-04-07 18:50:40.752784','2026-04-10 10:50:40.752784'); INSERT INTO operational_reports VALUES(4,4,'OP-20260523-01D60E','TRAFICO','Manifestación cerrando avenida principal.','MEDIA','RUTA-13',53,'RESUELTO','2026-05-12 04:18:40.753019','2026-05-12 14:18:40.753019'); INSERT INTO operational_reports VALUES(5,12,'OP-20260523-C930A2','FALLA_MECANICA','Falla en la transmisión.','MEDIA','RUTA-04',25,'RESUELTO','2026-04-21 17:01:40.753247','2026-04-22 02:01:40.753247'); INSERT INTO operational_reports VALUES(6,4,'OP-20260523-7BA328','FALLA_MECANICA','Frenos haciendo ruido.','BAJA','RUTA-13',49,'RESUELTO','2026-05-13 16:34:40.753469','2026-05-16 03:34:40.753469'); INSERT INTO operational_reports VALUES(7,11,'OP-20260523-FEB7E0','FALLA_MECANICA','Falla en la transmisión.','MEDIA','RUTA-04',14,'EN_ATENCION','2026-05-03 18:53:40.753681',NULL); INSERT INTO operational_reports VALUES(8,13,'OP-20260523-5FA073','ACCIDENTE','Raspón con poste, sin lesiones.','ALTA','RUTA-02',59,'EN_ATENCION','2026-04-16 13:04:40.753916',NULL); INSERT INTO operational_reports VALUES(9,11,'OP-20260523-3A872E','OBSTACULO','Vehículo bloqueando paso en colonia.','BAJA','RUTA-09',24,'EN_ATENCION','2026-05-22 15:08:40.754124',NULL); INSERT INTO operational_reports VALUES(10,16,'OP-20260523-45FE5C','OTRO','Comentario al supervisor.','BAJA','RUTA-06',2,'EN_ATENCION','2026-04-25 15:06:40.754343',NULL); INSERT INTO operational_reports VALUES(11,9,'OP-20260523-954D67','TRAFICO','Embotellamiento por accidente ajeno.','MEDIA','RUTA-04',28,'EN_ATENCION','2026-04-11 08:13:40.754556',NULL); INSERT INTO operational_reports VALUES(12,5,'OP-20260523-3F58C6','FALLA_MECANICA','Sobrecalentamiento del motor.','BAJA','RUTA-03',54,'RESUELTO','2026-05-04 16:35:40.754768','2026-05-05 11:35:40.754768'); INSERT INTO operational_reports VALUES(13,2,'OP-20260523-5BCE8E','NO_ARRANQUE','Marcha fallada, intentos múltiples.','BAJA','RUTA-07',32,'RESUELTO','2026-05-15 11:35:40.754987','2026-05-17 18:35:40.754987'); INSERT INTO operational_reports VALUES(14,16,'OP-20260523-2D9F3C','OBSTACULO','Calle inundada, no se puede acceder.','MEDIA','RUTA-08',28,'RESUELTO','2026-04-21 00:08:40.755120','2026-04-23 11:08:40.755120'); INSERT INTO operational_reports VALUES(15,9,'OP-20260523-8FFF8A','OBSTACULO','Obra municipal cerrando la ruta.','BAJA','RUTA-14',37,'RESUELTO','2026-05-07 15:11:40.755332','2026-05-09 03:11:40.755332'); INSERT INTO operational_reports VALUES(16,9,'OP-20260523-F07620','CLIMA','Viento fuerte que dificulta operación.','MEDIA','RUTA-08',3,'REPORTADO','2026-04-08 02:36:40.755549',NULL); INSERT INTO operational_reports VALUES(17,12,'OP-20260523-9D98D8','OBSTACULO','Árbol caído atravesando la calle.','MEDIA','RUTA-10',47,'REPORTADO','2026-04-23 21:38:40.755764',NULL); INSERT INTO operational_reports VALUES(18,11,'OP-20260523-C6829F','CLIMA','Viento fuerte que dificulta operación.','BAJA','RUTA-11',48,'RESUELTO','2026-05-18 16:03:40.755974','2026-05-21 15:03:40.755974'); INSERT INTO operational_reports VALUES(19,15,'OP-20260523-3C36B9','TRAFICO','Tráfico inusual por evento religioso.','MEDIA','RUTA-08',35,'RESUELTO','2026-04-23 20:46:40.756191','2026-04-26 10:46:40.756191'); INSERT INTO operational_reports VALUES(20,12,'OP-20260523-FDA950','COMBUSTIBLE','Bomba de combustible reportando fallas.','BAJA','RUTA-14',52,'RESUELTO','2026-05-05 08:41:40.756400','2026-05-07 00:41:40.756400'); INSERT INTO operational_reports VALUES(21,14,'OP-20260523-38E4DA','COMBUSTIBLE','Tanque bajo, requiere recarga.','BAJA','RUTA-12',38,'RESUELTO','2026-04-17 12:01:40.756644','2026-04-19 03:01:40.756644'); INSERT INTO operational_reports VALUES(22,15,'OP-20260523-613100','COMBUSTIBLE','Tanque bajo, requiere recarga.','BAJA','RUTA-14',9,'RESUELTO','2026-05-06 05:35:40.756929','2026-05-07 18:35:40.756929'); INSERT INTO operational_reports VALUES(23,7,'OP-20260523-E8D63F','CLIMA','Viento fuerte que dificulta operación.','BAJA','RUTA-12',12,'REPORTADO','2026-05-13 16:15:40.757165',NULL); INSERT INTO operational_reports VALUES(24,8,'OP-20260523-B4178C','CLIMA','Lluvia intensa, suspendido temporalmente.','BAJA','RUTA-13',32,'RESUELTO','2026-04-20 12:22:40.757284','2026-04-21 00:22:40.757284'); INSERT INTO operational_reports VALUES(25,5,'OP-20260523-B7963B','TRAFICO','Manifestación cerrando avenida principal.','MEDIA','RUTA-13',49,'RESUELTO','2026-04-29 06:01:40.757409','2026-05-01 16:01:40.757409'); INSERT INTO operational_reports VALUES(26,14,'OP-20260523-1E015D','TRAFICO','Tráfico inusual por evento religioso.','BAJA','RUTA-12',23,'RESUELTO','2026-04-12 04:55:40.757617','2026-04-12 20:55:40.757617'); INSERT INTO operational_reports VALUES(27,2,'OP-20260523-AC4EA0','FALLA_MECANICA','Ruido extraño en la dirección.','BAJA','RUTA-04',48,'EN_ATENCION','2026-04-28 15:58:40.757755',NULL); INSERT INTO operational_reports VALUES(28,9,'OP-20260523-C1B53B','OBSTACULO','Árbol caído atravesando la calle.','BAJA','RUTA-07',1,'RESUELTO','2026-04-25 01:00:40.757963','2026-04-26 19:00:40.757963'); INSERT INTO operational_reports VALUES(29,11,'OP-20260523-E0994D','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-09',41,'RESUELTO','2026-04-25 17:45:40.758211','2026-04-27 05:45:40.758211'); INSERT INTO operational_reports VALUES(30,8,'OP-20260523-4C72C9','FALLA_MECANICA','Sobrecalentamiento del motor.','MEDIA','RUTA-12',38,'EN_ATENCION','2026-04-23 15:56:40.758332',NULL); INSERT INTO operational_reports VALUES(31,6,'OP-20260523-73E0E9','COMBUSTIBLE','Tanque bajo, requiere recarga.','MEDIA','RUTA-05',22,'REPORTADO','2026-05-02 20:43:40.758531',NULL); INSERT INTO operational_reports VALUES(32,13,'OP-20260523-B31F3D','NO_ARRANQUE','Batería descargada esta mañana.','BAJA','RUTA-04',34,'EN_ATENCION','2026-04-09 23:21:40.758736',NULL); INSERT INTO operational_reports VALUES(33,6,'OP-20260523-4D3254','COMBUSTIBLE','Tanque bajo, requiere recarga.','BAJA','RUTA-03',40,'REPORTADO','2026-05-19 18:01:40.758958',NULL); INSERT INTO operational_reports VALUES(34,16,'OP-20260523-EB1F0D','FALLA_MECANICA','Frenos haciendo ruido.','MEDIA','RUTA-12',62,'REPORTADO','2026-05-17 18:35:40.759425',NULL); INSERT INTO operational_reports VALUES(35,9,'OP-20260523-AB41E5','TRAFICO','Tráfico inusual por evento religioso.','ALTA','RUTA-12',62,'RESUELTO','2026-05-15 15:32:40.759584','2026-05-17 01:32:40.759584'); INSERT INTO operational_reports VALUES(36,7,'OP-20260523-A71350','OBSTACULO','Árbol caído atravesando la calle.','ALTA','RUTA-09',60,'RESUELTO','2026-04-25 14:46:40.759824','2026-04-27 09:46:40.759824'); INSERT INTO operational_reports VALUES(37,7,'OP-20260523-06E55C','FALLA_MECANICA','Sobrecalentamiento del motor.','BAJA','RUTA-04',25,'RESUELTO','2026-05-02 12:27:40.759965','2026-05-03 23:27:40.759965'); INSERT INTO operational_reports VALUES(38,5,'OP-20260523-6C1452','OBSTACULO','Obra municipal cerrando la ruta.','MEDIA','RUTA-03',40,'RESUELTO','2026-05-11 17:12:40.760090','2026-05-12 08:12:40.760090'); INSERT INTO operational_reports VALUES(39,5,'OP-20260523-89C3BC','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-05',7,'RESUELTO','2026-04-08 05:37:40.760306','2026-04-08 11:37:40.760306'); INSERT INTO operational_reports VALUES(40,4,'OP-20260523-95F71E','NO_ARRANQUE','No prendió, parece arranque.','MEDIA','RUTA-06',2,'RESUELTO','2026-05-13 17:03:40.760428','2026-05-13 19:03:40.760428'); INSERT INTO operational_reports VALUES(41,2,'OP-20260523-95AE11','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-09',58,'RESUELTO','2026-04-17 13:11:40.760630','2026-04-20 05:11:40.760630'); INSERT INTO operational_reports VALUES(42,10,'OP-20260523-942AA9','OBSTACULO','Vehículo bloqueando paso en colonia.','MEDIA','RUTA-09',51,'RESUELTO','2026-05-09 13:19:40.760838','2026-05-12 04:19:40.760838'); INSERT INTO operational_reports VALUES(43,4,'OP-20260523-5ACD82','TRAFICO','Manifestación cerrando avenida principal.','ALTA','RUTA-08',44,'EN_ATENCION','2026-04-28 12:03:40.761059',NULL); INSERT INTO operational_reports VALUES(44,13,'OP-20260523-0E9847','NO_ARRANQUE','No prendió, parece arranque.','MEDIA','RUTA-13',6,'RESUELTO','2026-05-04 17:31:40.761260','2026-05-05 17:31:40.761260'); INSERT INTO operational_reports VALUES(45,11,'OP-20260523-875995','NO_ARRANQUE','No prendió, parece arranque.','BAJA','RUTA-05',45,'REPORTADO','2026-05-16 16:59:40.761475',NULL); INSERT INTO operational_reports VALUES(46,8,'OP-20260523-633D23','OBSTACULO','Calle inundada, no se puede acceder.','ALTA','RUTA-01',13,'EN_ATENCION','2026-05-11 12:57:40.761674',NULL); INSERT INTO operational_reports VALUES(47,12,'OP-20260523-34A06F','FALLA_MECANICA','Falla en la transmisión.','BAJA','RUTA-08',42,'RESUELTO','2026-04-18 23:42:40.761871','2026-04-19 05:42:40.761871'); INSERT INTO operational_reports VALUES(48,8,'OP-20260523-A7A568','NO_ARRANQUE','Batería descargada esta mañana.','MEDIA','RUTA-11',8,'REPORTADO','2026-04-11 16:10:40.762078',NULL); INSERT INTO operational_reports VALUES(49,10,'OP-20260523-107B49','CLIMA','Viento fuerte que dificulta operación.','ALTA','RUTA-04',48,'RESUELTO','2026-05-19 11:56:40.762206','2026-05-20 07:56:40.762206'); INSERT INTO operational_reports VALUES(50,10,'OP-20260523-60C9ED','TRAFICO','Tráfico inusual por evento religioso.','MEDIA','RUTA-12',3,'RESUELTO','2026-04-12 09:43:40.762321','2026-04-13 09:43:40.762321'); INSERT INTO operational_reports VALUES(51,13,'OP-20260523-535A0F','NO_ARRANQUE','Marcha fallada, intentos múltiples.','BAJA','RUTA-02',30,'RESUELTO','2026-05-12 19:39:40.762526','2026-05-13 10:39:40.762526'); INSERT INTO operational_reports VALUES(52,4,'OP-20260523-C33EFE','OBSTACULO','Calle inundada, no se puede acceder.','MEDIA','RUTA-14',52,'REPORTADO','2026-04-26 02:52:40.762646',NULL); INSERT INTO operational_reports VALUES(53,16,'OP-20260523-7E5005','OTRO','Comentario al supervisor.','MEDIA','RUTA-08',44,'EN_ATENCION','2026-05-03 06:55:40.762769',NULL); INSERT INTO operational_reports VALUES(54,2,'OP-20260523-568229','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-04',10,'REPORTADO','2026-05-12 15:20:40.762972',NULL); INSERT INTO operational_reports VALUES(55,11,'OP-20260523-8A54E3','FALLA_MECANICA','Frenos haciendo ruido.','BAJA','RUTA-13',9,'RESUELTO','2026-04-12 18:19:40.763086','2026-04-13 16:19:40.763086'); INSERT INTO operational_reports VALUES(56,2,'OP-20260523-2529A4','CLIMA','Lluvia intensa, suspendido temporalmente.','BAJA','RUTA-09',60,'REPORTADO','2026-04-07 17:06:40.763210',NULL); INSERT INTO operational_reports VALUES(57,7,'OP-20260523-E906DB','OBSTACULO','Calle inundada, no se puede acceder.','MEDIA','RUTA-05',45,'RESUELTO','2026-05-10 09:03:40.763321','2026-05-11 21:03:40.763321'); INSERT INTO operational_reports VALUES(58,11,'OP-20260523-0EB949','OBSTACULO','Vehículo bloqueando paso en colonia.','BAJA','RUTA-05',45,'REPORTADO','2026-04-15 07:58:40.763451',NULL); INSERT INTO operational_reports VALUES(59,10,'OP-20260523-BB2C06','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-07',20,'RESUELTO','2026-05-22 20:28:40.763659','2026-05-23 22:28:40.763659'); INSERT INTO operational_reports VALUES(60,4,'OP-20260523-B7F4CF','OTRO','Comentario al supervisor.','ALTA','RUTA-08',56,'RESUELTO','2026-04-12 16:30:40.763866','2026-04-14 05:30:40.763866'); INSERT INTO operational_reports VALUES(61,2,'OP-20260523-5D5043','FALLA_MECANICA','Sobrecalentamiento del motor.','MEDIA','RUTA-12',62,'RESUELTO','2026-04-22 08:33:40.763993','2026-04-22 15:33:40.763993'); INSERT INTO operational_reports VALUES(62,2,'OP-20260523-638800','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-05',22,'EN_ATENCION','2026-04-24 12:37:40.764107',NULL); INSERT INTO operational_reports VALUES(63,14,'OP-20260523-8CA808','NO_ARRANQUE','No prendió, parece arranque.','MEDIA','RUTA-06',2,'REPORTADO','2026-04-21 10:39:40.764225',NULL); INSERT INTO operational_reports VALUES(64,6,'OP-20260523-1BAC4B','COMBUSTIBLE','Bomba de combustible reportando fallas.','MEDIA','RUTA-04',13,'EN_ATENCION','2026-05-16 03:29:40.764340',NULL); INSERT INTO operational_reports VALUES(65,4,'OP-20260523-7CD9E4','FALLA_MECANICA','Pérdida de aceite visible.','BAJA','RUTA-09',58,'REPORTADO','2026-05-18 22:06:40.764454',NULL); INSERT INTO operational_reports VALUES(66,10,'OP-20260523-C56197','NO_ARRANQUE','No prendió, parece arranque.','BAJA','RUTA-03',40,'REPORTADO','2026-05-12 01:20:40.764573',NULL); INSERT INTO operational_reports VALUES(67,5,'OP-20260523-44A47F','OBSTACULO','Calle inundada, no se puede acceder.','BAJA','RUTA-14',18,'EN_ATENCION','2026-05-02 09:41:40.764775',NULL); INSERT INTO operational_reports VALUES(68,14,'OP-20260523-095FD6','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-02',30,'REPORTADO','2026-04-27 07:55:40.764891',NULL); INSERT INTO operational_reports VALUES(69,8,'OP-20260523-4523A0','FALLA_MECANICA','Ruido extraño en la dirección.','BAJA','RUTA-15',51,'REPORTADO','2026-05-12 19:08:40.765068',NULL); INSERT INTO operational_reports VALUES(70,16,'OP-20260523-5212E9','FALLA_MECANICA','Pérdida de aceite visible.','BAJA','RUTA-10',56,'RESUELTO','2026-04-22 23:26:40.765203','2026-04-23 02:26:40.765203'); INSERT INTO operational_reports VALUES(71,14,'OP-20260523-EDE569','OBSTACULO','Calle inundada, no se puede acceder.','ALTA','RUTA-15',28,'REPORTADO','2026-04-16 08:45:40.765336',NULL); INSERT INTO operational_reports VALUES(72,12,'OP-20260523-29B7A4','CLIMA','Viento fuerte que dificulta operación.','BAJA','RUTA-13',31,'REPORTADO','2026-04-21 12:16:40.765600',NULL); INSERT INTO operational_reports VALUES(73,11,'OP-20260523-E1011D','OBSTACULO','Obra municipal cerrando la ruta.','MEDIA','RUTA-05',7,'RESUELTO','2026-04-22 06:38:40.765732','2026-04-22 09:38:40.765732'); INSERT INTO operational_reports VALUES(74,14,'OP-20260523-06FAC6','COMBUSTIBLE','Tanque bajo, requiere recarga.','ALTA','RUTA-11',19,'REPORTADO','2026-05-18 13:13:40.765960',NULL); INSERT INTO operational_reports VALUES(75,13,'OP-20260523-0548CA','ACCIDENTE','Choque sin víctimas, esperando ajustador.','MEDIA','RUTA-01',48,'RESUELTO','2026-04-23 22:54:40.766082','2026-04-24 17:54:40.766082'); INSERT INTO operational_reports VALUES(76,16,'OP-20260523-E99D50','COMBUSTIBLE','Bomba de combustible reportando fallas.','BAJA','RUTA-09',41,'RESUELTO','2026-04-07 17:43:40.766202','2026-04-08 04:43:40.766202'); INSERT INTO operational_reports VALUES(77,9,'OP-20260523-4DB896','CLIMA','Granizada en la zona alta.','BAJA','RUTA-12',28,'REPORTADO','2026-04-13 20:07:40.766327',NULL); INSERT INTO operational_reports VALUES(78,15,'OP-20260523-CA82DC','FALLA_MECANICA','Frenos haciendo ruido.','MEDIA','RUTA-05',22,'RESUELTO','2026-04-20 16:20:40.766444','2026-04-21 00:20:40.766444'); INSERT INTO operational_reports VALUES(79,4,'OP-20260523-B7939A','OBSTACULO','Calle inundada, no se puede acceder.','MEDIA','RUTA-09',24,'REPORTADO','2026-04-11 19:58:40.766570',NULL); INSERT INTO operational_reports VALUES(80,4,'OP-20260523-77F74B','TRAFICO','Tráfico inusual por evento religioso.','MEDIA','RUTA-05',22,'REPORTADO','2026-04-19 10:02:40.766684',NULL); INSERT INTO operational_reports VALUES(81,10,'OP-20260523-259A05','COMBUSTIBLE','Tanque bajo, requiere recarga.','MEDIA','RUTA-05',45,'RESUELTO','2026-05-09 03:21:40.766798','2026-05-10 15:21:40.766798'); INSERT INTO operational_reports VALUES(82,11,'OP-20260523-B2010C','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-12',23,'REPORTADO','2026-04-21 21:10:40.766918',NULL); INSERT INTO operational_reports VALUES(83,16,'OP-20260523-0AA151','FALLA_MECANICA','Falla en la transmisión.','MEDIA','RUTA-08',35,'RESUELTO','2026-04-14 01:52:40.767032','2026-04-14 11:52:40.767032'); INSERT INTO operational_reports VALUES(84,6,'OP-20260523-558E1E','CLIMA','Lluvia intensa, suspendido temporalmente.','MEDIA','RUTA-09',58,'REPORTADO','2026-05-05 11:37:40.767174',NULL); INSERT INTO operational_reports VALUES(85,5,'OP-20260523-B74FCF','FALLA_MECANICA','Pérdida de aceite visible.','MEDIA','RUTA-09',56,'RESUELTO','2026-04-13 13:25:40.767293','2026-04-15 20:25:40.767293'); INSERT INTO operational_reports VALUES(86,13,'OP-20260523-7C6AB8','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-11',29,'EN_ATENCION','2026-05-22 04:31:40.767726',NULL); INSERT INTO operational_reports VALUES(87,4,'OP-20260523-FC3535','NO_ARRANQUE','Marcha fallada, intentos múltiples.','MEDIA','RUTA-04',34,'RESUELTO','2026-05-02 00:06:40.767908','2026-05-03 21:06:40.767908'); INSERT INTO operational_reports VALUES(88,13,'OP-20260523-EA5C02','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-05',45,'RESUELTO','2026-04-17 23:14:40.768052','2026-04-19 15:14:40.768052'); INSERT INTO operational_reports VALUES(89,12,'OP-20260523-3E9DBE','FALLA_MECANICA','Pérdida de aceite visible.','MEDIA','RUTA-07',17,'REPORTADO','2026-04-23 02:25:40.768321',NULL); INSERT INTO operational_reports VALUES(90,15,'OP-20260523-04A80A','CLIMA','Lluvia intensa, suspendido temporalmente.','BAJA','RUTA-12',62,'EN_ATENCION','2026-04-14 07:58:40.768453',NULL); INSERT INTO operational_reports VALUES(91,11,'OP-20260523-856B8A','FALLA_MECANICA','Pérdida de aceite visible.','ALTA','RUTA-05',45,'RESUELTO','2026-05-13 06:36:40.768567','2026-05-13 13:36:40.768567'); INSERT INTO operational_reports VALUES(92,8,'OP-20260523-03D457','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-04',14,'EN_ATENCION','2026-04-08 12:01:40.768687',NULL); INSERT INTO operational_reports VALUES(93,8,'OP-20260523-2F13AF','OTRO','Solicitud de mantenimiento preventivo.','BAJA','RUTA-02',11,'EN_ATENCION','2026-05-22 00:44:40.768933',NULL); INSERT INTO operational_reports VALUES(94,10,'OP-20260523-D78E85','COMBUSTIBLE','Tanque bajo, requiere recarga.','ALTA','RUTA-04',10,'RESUELTO','2026-04-18 21:22:40.769052','2026-04-20 12:22:40.769052'); INSERT INTO operational_reports VALUES(95,10,'OP-20260523-A3C0A5','CLIMA','Viento fuerte que dificulta operación.','ALTA','RUTA-03',37,'RESUELTO','2026-04-16 13:45:40.769171','2026-04-18 23:45:40.769171'); INSERT INTO operational_reports VALUES(96,8,'OP-20260523-607D26','TRAFICO','Embotellamiento por accidente ajeno.','MEDIA','RUTA-09',9,'RESUELTO','2026-05-16 04:42:40.769299','2026-05-18 09:42:40.769299'); INSERT INTO operational_reports VALUES(97,12,'OP-20260523-415C99','CLIMA','Viento fuerte que dificulta operación.','BAJA','RUTA-05',4,'REPORTADO','2026-04-12 07:06:40.769513',NULL); INSERT INTO operational_reports VALUES(98,11,'OP-20260523-EBCC14','FALLA_MECANICA','Frenos haciendo ruido.','ALTA','RUTA-06',2,'EN_ATENCION','2026-04-18 23:00:40.769643',NULL); INSERT INTO operational_reports VALUES(99,13,'OP-20260523-CAB9D1','OTRO','Solicitud de mantenimiento preventivo.','ALTA','RUTA-10',32,'EN_ATENCION','2026-04-14 21:40:40.769768',NULL); INSERT INTO operational_reports VALUES(100,13,'OP-20260523-BDBCFC','OBSTACULO','Obra municipal cerrando la ruta.','BAJA','RUTA-09',24,'RESUELTO','2026-04-30 13:25:40.769883','2026-05-02 11:25:40.769883'); INSERT INTO operational_reports VALUES(101,8,'OP-20260523-E00BB4','ACCIDENTE','Choque sin víctimas, esperando ajustador.','BAJA','RUTA-04',14,'RESUELTO','2026-04-24 14:17:40.770000','2026-04-27 00:17:40.770000'); INSERT INTO operational_reports VALUES(102,7,'OP-20260523-A601E7','FALLA_MECANICA','Sobrecalentamiento del motor.','MEDIA','RUTA-10',47,'RESUELTO','2026-05-14 19:05:40.770116','2026-05-15 08:05:40.770116'); INSERT INTO operational_reports VALUES(103,5,'OP-20260523-7C71A7','FALLA_MECANICA','Frenos haciendo ruido.','MEDIA','RUTA-05',22,'RESUELTO','2026-04-16 01:38:40.770230','2026-04-16 03:38:40.770230'); INSERT INTO operational_reports VALUES(104,9,'OP-20260523-435A7C','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-02',30,'REPORTADO','2026-04-17 09:31:40.770342',NULL); INSERT INTO operational_reports VALUES(105,5,'OP-20260523-0BF000','CLIMA','Granizada en la zona alta.','BAJA','RUTA-13',53,'RESUELTO','2026-04-16 04:12:40.770472','2026-04-18 17:12:40.770472'); INSERT INTO operational_reports VALUES(106,6,'OP-20260523-2DD43A','NO_ARRANQUE','Marcha fallada, intentos múltiples.','BAJA','RUTA-12',62,'EN_ATENCION','2026-04-12 22:36:40.770589',NULL); INSERT INTO operational_reports VALUES(107,13,'OP-20260523-9620B7','TRAFICO','Embotellamiento por accidente ajeno.','BAJA','RUTA-11',59,'REPORTADO','2026-05-08 13:36:40.770708',NULL); INSERT INTO operational_reports VALUES(108,15,'OP-20260523-BE4DE9','FALLA_MECANICA','Falla en la transmisión.','ALTA','RUTA-10',48,'REPORTADO','2026-04-22 19:16:40.770818',NULL); INSERT INTO operational_reports VALUES(109,16,'OP-20260523-D994F7','FALLA_MECANICA','Frenos haciendo ruido.','MEDIA','RUTA-13',53,'RESUELTO','2026-04-29 20:57:40.770935','2026-04-30 00:57:40.770935'); INSERT INTO operational_reports VALUES(110,16,'OP-20260523-F51D7F','FALLA_MECANICA','Pérdida de aceite visible.','MEDIA','RUTA-02',30,'REPORTADO','2026-05-01 08:40:40.771048',NULL); INSERT INTO operational_reports VALUES(111,7,'OP-20260523-55A533','OBSTACULO','Árbol caído atravesando la calle.','MEDIA','RUTA-05',4,'RESUELTO','2026-05-04 21:03:40.771161','2026-05-05 08:03:40.771161'); INSERT INTO operational_reports VALUES(112,11,'OP-20260523-5FA702','FALLA_MECANICA','Pérdida de aceite visible.','MEDIA','RUTA-03',39,'RESUELTO','2026-04-19 02:48:40.771374','2026-04-20 20:48:40.771374'); INSERT INTO operational_reports VALUES(113,16,'OP-20260523-3F22CD','CLIMA','Viento fuerte que dificulta operación.','MEDIA','RUTA-05',45,'EN_ATENCION','2026-04-30 10:09:40.771496',NULL); INSERT INTO operational_reports VALUES(114,12,'OP-20260523-63D3C9','OBSTACULO','Árbol caído atravesando la calle.','BAJA','RUTA-13',19,'REPORTADO','2026-04-22 00:22:40.771613',NULL); INSERT INTO operational_reports VALUES(115,5,'OP-20260523-19F70A','FALLA_MECANICA','Ruido extraño en la dirección.','BAJA','RUTA-10',13,'REPORTADO','2026-04-08 20:49:40.771730',NULL); INSERT INTO operational_reports VALUES(116,11,'OP-20260523-CB7CC2','COMBUSTIBLE','Bomba de combustible reportando fallas.','MEDIA','RUTA-04',27,'RESUELTO','2026-05-19 09:51:40.771847','2026-05-20 03:51:40.771847'); INSERT INTO operational_reports VALUES(117,2,'OP-20260523-74287E','OBSTACULO','Obra municipal cerrando la ruta.','BAJA','RUTA-13',53,'EN_ATENCION','2026-04-14 20:55:40.771964',NULL); INSERT INTO operational_reports VALUES(118,8,'OP-20260523-2B8857','FALLA_MECANICA','Pérdida de aceite visible.','BAJA','RUTA-11',8,'RESUELTO','2026-05-14 15:34:40.772072','2026-05-15 22:34:40.772072'); INSERT INTO operational_reports VALUES(119,7,'OP-20260523-7D873F','FALLA_MECANICA','Frenos haciendo ruido.','BAJA','RUTA-05',45,'REPORTADO','2026-05-19 12:54:40.772187',NULL); INSERT INTO operational_reports VALUES(120,10,'OP-20260523-E4D429','COMBUSTIBLE','Tanque bajo, requiere recarga.','BAJA','RUTA-08',51,'REPORTADO','2026-05-16 05:41:40.772298',NULL); INSERT INTO operational_reports VALUES(121,4,'OP-20260523-FD4456','ACCIDENTE','Choque sin víctimas, esperando ajustador.','BAJA','RUTA-11',8,'REPORTADO','2026-05-09 18:46:40.772409',NULL); INSERT INTO operational_reports VALUES(122,6,'OP-20260523-6C5A0A','FALLA_MECANICA','Falla en la transmisión.','BAJA','RUTA-09',55,'REPORTADO','2026-04-16 02:21:40.772612',NULL); INSERT INTO operational_reports VALUES(123,5,'OP-20260523-626F6A','CLIMA','Viento fuerte que dificulta operación.','MEDIA','RUTA-10',33,'RESUELTO','2026-05-19 09:51:40.772815','2026-05-19 12:51:40.772815'); INSERT INTO operational_reports VALUES(124,11,'OP-20260523-126618','FALLA_MECANICA','Ruido extraño en la dirección.','BAJA','RUTA-09',58,'EN_ATENCION','2026-05-22 14:37:40.772934',NULL); INSERT INTO operational_reports VALUES(125,6,'OP-20260523-C21A1C','CLIMA','Viento fuerte que dificulta operación.','ALTA','RUTA-05',45,'RESUELTO','2026-05-11 23:00:40.773044','2026-05-12 14:00:40.773044'); INSERT INTO operational_reports VALUES(126,5,'OP-20260523-E7654D','CLIMA','Lluvia intensa, suspendido temporalmente.','ALTA','RUTA-10',33,'EN_ATENCION','2026-04-27 09:55:40.773160',NULL); INSERT INTO operational_reports VALUES(127,8,'OP-20260523-F5C888','FALLA_MECANICA','Falla en la transmisión.','BAJA','RUTA-12',49,'REPORTADO','2026-05-04 19:57:40.773269',NULL); INSERT INTO operational_reports VALUES(128,2,'OP-20260523-FF9539','NO_ARRANQUE','Marcha fallada, intentos múltiples.','MEDIA','RUTA-02',30,'EN_ATENCION','2026-05-03 15:50:40.773383',NULL); INSERT INTO operational_reports VALUES(129,10,'OP-20260523-CD8B3E','FALLA_MECANICA','Pérdida de aceite visible.','BAJA','RUTA-14',28,'RESUELTO','2026-05-18 22:00:40.773492','2026-05-20 23:00:40.773492'); INSERT INTO operational_reports VALUES(130,5,'OP-20260523-2B71E1','NO_ARRANQUE','No prendió, parece arranque.','MEDIA','RUTA-09',26,'RESUELTO','2026-04-10 16:38:40.773696','2026-04-11 09:38:40.773696'); INSERT INTO operational_reports VALUES(131,5,'OP-20260523-33D44F','OBSTACULO','Calle inundada, no se puede acceder.','MEDIA','RUTA-02',48,'RESUELTO','2026-04-30 07:22:40.773815','2026-05-01 10:22:40.773815'); INSERT INTO operational_reports VALUES(132,12,'OP-20260523-1365F3','CLIMA','Viento fuerte que dificulta operación.','BAJA','RUTA-08',28,'REPORTADO','2026-05-05 14:54:40.773927',NULL); INSERT INTO operational_reports VALUES(133,12,'OP-20260523-9E01A4','TRAFICO','Manifestación cerrando avenida principal.','MEDIA','RUTA-06',61,'RESUELTO','2026-04-22 16:05:40.774132','2026-04-24 21:05:40.774132'); INSERT INTO operational_reports VALUES(134,10,'OP-20260523-615093','TRAFICO','Manifestación cerrando avenida principal.','BAJA','RUTA-11',8,'RESUELTO','2026-04-21 22:29:40.774256','2026-04-22 17:29:40.774256'); INSERT INTO operational_reports VALUES(135,2,'OP-20260523-956B03','NO_ARRANQUE','Batería descargada esta mañana.','BAJA','RUTA-08',44,'REPORTADO','2026-05-12 01:05:40.774369',NULL); INSERT INTO operational_reports VALUES(136,13,'OP-20260523-C7F7E8','ACCIDENTE','Golpe leve con vehículo particular en Av. Tecnológico.','BAJA','RUTA-11',49,'RESUELTO','2026-04-19 21:53:40.774484','2026-04-22 10:53:40.774484'); INSERT INTO operational_reports VALUES(137,6,'OP-20260523-C30945','FALLA_MECANICA','Falla en la transmisión.','MEDIA','RUTA-13',35,'RESUELTO','2026-04-18 20:42:40.774651','2026-04-19 02:42:40.774651'); INSERT INTO operational_reports VALUES(138,9,'OP-20260523-D71740','CLIMA','Granizada en la zona alta.','BAJA','RUTA-09',55,'RESUELTO','2026-04-24 23:41:40.774781','2026-04-25 05:41:40.774781'); INSERT INTO operational_reports VALUES(139,5,'OP-20260523-2429D8','TRAFICO','Tráfico inusual por evento religioso.','ALTA','RUTA-09',46,'EN_ATENCION','2026-04-22 00:35:40.775022',NULL); INSERT INTO operational_reports VALUES(140,7,'OP-20260523-E5C61D','COMBUSTIBLE','Bomba de combustible reportando fallas.','MEDIA','RUTA-08',44,'REPORTADO','2026-04-10 20:00:40.775142',NULL); INSERT INTO operational_reports VALUES(141,11,'OP-20260523-96C829','TRAFICO','Tráfico inusual por evento religioso.','MEDIA','RUTA-10',33,'RESUELTO','2026-04-28 05:12:40.775258','2026-04-30 07:12:40.775258'); INSERT INTO operational_reports VALUES(142,12,'OP-20260523-959B3A','TRAFICO','Tráfico inusual por evento religioso.','MEDIA','RUTA-05',4,'EN_ATENCION','2026-04-16 12:35:40.775381',NULL); INSERT INTO operational_reports VALUES(143,16,'OP-20260523-013E6E','OBSTACULO','Árbol caído atravesando la calle.','MEDIA','RUTA-07',49,'RESUELTO','2026-05-17 00:21:40.775510','2026-05-18 23:21:40.775510'); INSERT INTO operational_reports VALUES(144,9,'OP-20260523-02DA10','OBSTACULO','Árbol caído atravesando la calle.','MEDIA','RUTA-10',42,'REPORTADO','2026-05-17 15:39:40.775737',NULL); INSERT INTO operational_reports VALUES(145,16,'OP-20260523-AFD919','ACCIDENTE','Golpe leve con vehículo particular en Av. Tecnológico.','BAJA','RUTA-12',21,'REPORTADO','2026-04-23 15:48:40.776063',NULL); INSERT INTO operational_reports VALUES(146,9,'OP-20260523-9008B9','TRAFICO','Manifestación cerrando avenida principal.','ALTA','RUTA-05',45,'EN_ATENCION','2026-04-16 13:23:40.776226',NULL); INSERT INTO operational_reports VALUES(147,9,'OP-20260523-7C229F','TRAFICO','Tráfico inusual por evento religioso.','BAJA','RUTA-12',32,'REPORTADO','2026-04-10 07:22:40.776354',NULL); INSERT INTO operational_reports VALUES(148,10,'OP-20260523-75F5F9','TRAFICO','Manifestación cerrando avenida principal.','MEDIA','RUTA-03',40,'EN_ATENCION','2026-04-30 00:31:40.776483',NULL); INSERT INTO operational_reports VALUES(149,10,'OP-20260523-99EAE6','TRAFICO','Embotellamiento por accidente ajeno.','ALTA','RUTA-09',55,'REPORTADO','2026-05-10 04:27:40.776603',NULL); INSERT INTO operational_reports VALUES(150,2,'OP-20260523-823463','FALLA_MECANICA','Frenos haciendo ruido.','MEDIA','RUTA-03',40,'RESUELTO','2026-04-07 19:37:40.776730','2026-04-09 16:37:40.776730'); CREATE TABLE trucks ( id INTEGER NOT NULL, unit_number VARCHAR NOT NULL, plate VARCHAR, model VARCHAR, year INTEGER, capacity_kg INTEGER, fuel_type VARCHAR, status VARCHAR, route_id VARCHAR, base VARCHAR, odometer_km INTEGER, fuel_level_pct INTEGER, last_maintenance DATETIME, next_maintenance_km INTEGER, created_at DATETIME, PRIMARY KEY (id), UNIQUE (plate) ); INSERT INTO trucks VALUES(1,'CEL-001','GTO-645-M','Kenworth T270',2020,9512,'DIESEL','EN_RUTA','RUTA-07','Patio Centro',52788,70,'2026-05-08 13:43:40.600343',12147,'2026-05-23 13:43:40.608663'); INSERT INTO trucks VALUES(2,'CEL-002','GTO-689-G','International 4300',2024,8226,'DIESEL','EN_RUTA','RUTA-06','Patio Centro',75384,71,'2026-05-13 13:43:40.600439',10321,'2026-05-23 13:43:40.608665'); INSERT INTO trucks VALUES(3,'CEL-003','GTO-732-H','Mercedes-Benz Axor 1725',2025,12441,'DIESEL','TALLER',NULL,'Patio Industrial',70502,51,'2026-01-27 13:43:40.600469',14648,'2026-05-23 13:43:40.608665'); INSERT INTO trucks VALUES(4,'CEL-004','GTO-863-F','Isuzu FTR',2021,6841,'DIESEL','EN_RUTA','RUTA-05','Patio Norte',74782,87,'2026-01-08 13:43:40.600490',8176,'2026-05-23 13:43:40.608666'); INSERT INTO trucks VALUES(5,'CEL-005','GTO-760-P','Hino 268',2020,8241,'DIESEL','OPERATIVO',NULL,'Patio Centro',118427,42,'2025-12-15 13:43:40.600510',7504,'2026-05-23 13:43:40.608667'); INSERT INTO trucks VALUES(6,'CEL-006','GTO-605-H','International 4400',2025,10077,'DIESEL','OPERATIVO',NULL,'Patio Industrial',184454,100,'2026-02-27 13:43:40.600530',7473,'2026-05-23 13:43:40.608667'); INSERT INTO trucks VALUES(7,'CEL-007','GTO-915-E','Kenworth T270',2023,9057,'DIESEL','OPERATIVO','RUTA-05','Patio Norte',177743,79,'2026-01-23 13:43:40.600548',5616,'2026-05-23 13:43:40.608668'); INSERT INTO trucks VALUES(8,'CEL-008','GTO-984-P','International 4300',2019,8129,'DIESEL','OPERATIVO','RUTA-11','Patio Industrial',257594,94,'2025-12-28 13:43:40.600567',5672,'2026-05-23 13:43:40.608668'); INSERT INTO trucks VALUES(9,'CEL-009','GTO-685-L','Kenworth T270',2020,9329,'DIESEL','RESERVA',NULL,'Patio Sur',47439,77,'2026-04-22 13:43:40.600584',10626,'2026-05-23 13:43:40.608669'); INSERT INTO trucks VALUES(10,'CEL-010','GTO-824-H','International 4400',2022,10036,'DIESEL','EN_RUTA','RUTA-04','Patio Sur',205787,67,'2026-03-07 13:43:40.600602',11347,'2026-05-23 13:43:40.608670'); INSERT INTO trucks VALUES(11,'CEL-011','GTO-795-K','Isuzu FTR',2020,7308,'DIESEL','TALLER',NULL,'Patio Centro',49556,62,'2026-04-24 13:43:40.600637',14141,'2026-05-23 13:43:40.608670'); INSERT INTO trucks VALUES(12,'CEL-012','GTO-772-K','Isuzu FTR',2021,6841,'DIESEL','OPERATIVO',NULL,'Patio Sur',198406,59,'2025-12-02 13:43:40.600718',11421,'2026-05-23 13:43:40.608671'); INSERT INTO trucks VALUES(13,'CEL-013','GTO-417-J','Mercedes-Benz Axor 1725',2023,12158,'DIESEL','EN_RUTA',NULL,'Patio Sur',63996,74,'2026-01-08 13:43:40.600740',10928,'2026-05-23 13:43:40.608671'); INSERT INTO trucks VALUES(14,'CEL-014','GTO-449-N','International 4300',2025,7696,'DIESEL','OPERATIVO','RUTA-04','Patio Sur',96235,29,'2026-03-04 13:43:40.600757',6657,'2026-05-23 13:43:40.608672'); INSERT INTO trucks VALUES(15,'CEL-015','GTO-732-C','International 4300',2024,7657,'DIESEL','EN_RUTA',NULL,'Patio Sur',244466,25,'2026-02-02 13:43:40.600774',10968,'2026-05-23 13:43:40.608672'); INSERT INTO trucks VALUES(16,'CEL-016','GTO-725-E','Freightliner M2 106',2024,8739,'DIESEL','RESERVA',NULL,'Patio Centro',260899,44,'2026-02-13 13:43:40.600877',14345,'2026-05-23 13:43:40.608673'); INSERT INTO trucks VALUES(17,'CEL-017','GTO-614-J','Kenworth T270',2022,9989,'DIESEL','EN_RUTA','RUTA-07','Patio Sur',87560,52,'2026-05-05 13:43:40.600923',12873,'2026-05-23 13:43:40.608673'); INSERT INTO trucks VALUES(18,'CEL-018','GTO-628-P','Hino 268',2019,8291,'DIESEL','EN_RUTA','RUTA-14','Patio Sur',158021,77,'2026-01-07 13:43:40.600951',7414,'2026-05-23 13:43:40.608674'); INSERT INTO trucks VALUES(19,'CEL-019','GTO-936-H','Isuzu FTR',2022,7452,'DIESEL','OPERATIVO',NULL,'Patio Norte',222856,84,'2026-02-12 13:43:40.600970',8862,'2026-05-23 13:43:40.608674'); INSERT INTO trucks VALUES(20,'CEL-020','GTO-483-D','Isuzu FTR',2020,6826,'GAS_LP','RESERVA',NULL,'Patio Centro',91571,37,'2026-05-09 13:43:40.600987',9700,'2026-05-23 13:43:40.608675'); INSERT INTO trucks VALUES(21,'CEL-021','GTO-580-H','Kenworth T270',2023,9005,'GAS_LP','EN_RUTA','RUTA-12','Patio Norte',149177,47,'2026-04-10 13:43:40.601029',13991,'2026-05-23 13:43:40.608675'); INSERT INTO trucks VALUES(22,'CEL-022','GTO-224-A','Isuzu FTR',2021,6929,'DIESEL','OPERATIVO','RUTA-05','Patio Industrial',47929,34,'2026-01-11 13:43:40.601054',14776,'2026-05-23 13:43:40.608676'); INSERT INTO trucks VALUES(23,'CEL-023','GTO-247-E','International 4300',2024,7501,'DIESEL','EN_RUTA','RUTA-12','Patio Sur',233401,43,'2025-11-29 13:43:40.601074',6402,'2026-05-23 13:43:40.608676'); INSERT INTO trucks VALUES(24,'CEL-024','GTO-905-J','Hino 268',2023,8020,'DIESEL','OPERATIVO','RUTA-09','Patio Industrial',37824,69,'2026-02-12 13:43:40.601093',9155,'2026-05-23 13:43:40.608677'); INSERT INTO trucks VALUES(25,'CEL-025','GTO-850-L','International 4300',2019,8290,'DIESEL','OPERATIVO','RUTA-04','Patio Centro',84945,25,'2026-02-17 13:43:40.601114',13945,'2026-05-23 13:43:40.608677'); INSERT INTO trucks VALUES(26,'CEL-026','GTO-279-P','Hino 268',2025,8701,'DIESEL','TALLER',NULL,'Patio Industrial',110566,37,'2026-05-02 13:43:40.601131',12498,'2026-05-23 13:43:40.608678'); INSERT INTO trucks VALUES(27,'CEL-027','GTO-142-F','International 4300',2022,8027,'DIESEL','OPERATIVO','RUTA-04','Patio Industrial',147809,24,'2025-12-04 13:43:40.601151',8131,'2026-05-23 13:43:40.608678'); INSERT INTO trucks VALUES(28,'CEL-028','GTO-986-L','Ford F-750',2023,7279,'DIESEL','OPERATIVO',NULL,'Patio Centro',244088,71,'2026-01-26 13:43:40.601169',11334,'2026-05-23 13:43:40.608679'); INSERT INTO trucks VALUES(29,'CEL-029','GTO-608-M','Hino 268',2022,8376,'GAS_LP','RESERVA',NULL,'Patio Centro',58312,74,'2026-04-28 13:43:40.601188',12055,'2026-05-23 13:43:40.608679'); INSERT INTO trucks VALUES(30,'CEL-030','GTO-435-L','Mercedes-Benz Axor 1725',2022,11813,'DIESEL','EN_RUTA','RUTA-02','Patio Industrial',102369,76,'2026-02-18 13:43:40.601207',12325,'2026-05-23 13:43:40.608680'); INSERT INTO trucks VALUES(31,'CEL-031','GTO-729-G','International 4300',2022,8154,'GAS_LP','EN_RUTA',NULL,'Patio Norte',54343,71,'2026-02-14 13:43:40.601224',13406,'2026-05-23 13:43:40.608680'); INSERT INTO trucks VALUES(32,'CEL-032','GTO-246-P','Mercedes-Benz Axor 1725',2024,12194,'DIESEL','RESERVA',NULL,'Patio Norte',81180,28,'2026-03-19 13:43:40.601241',11001,'2026-05-23 13:43:40.608681'); INSERT INTO trucks VALUES(33,'CEL-033','GTO-257-L','Hino 268',2022,8971,'DIESEL','OPERATIVO','RUTA-10','Patio Industrial',55310,93,'2026-04-13 13:43:40.601258',13674,'2026-05-23 13:43:40.608681'); INSERT INTO trucks VALUES(34,'CEL-034','GTO-216-A','Hino 268',2024,8190,'DIESEL','OPERATIVO','RUTA-04','Patio Industrial',76740,53,'2026-03-13 13:43:40.601275',12311,'2026-05-23 13:43:40.608682'); INSERT INTO trucks VALUES(35,'CEL-035','GTO-392-M','Freightliner M2 106',2024,8704,'DIESEL','RESERVA',NULL,'Patio Norte',252000,42,'2026-01-25 13:43:40.601298',6438,'2026-05-23 13:43:40.608682'); INSERT INTO trucks VALUES(36,'CEL-036','GTO-663-J','Hino 268',2021,8912,'DIESEL','EN_RUTA',NULL,'Patio Sur',106273,66,'2026-01-08 13:43:40.601343',8673,'2026-05-23 13:43:40.608683'); INSERT INTO trucks VALUES(37,'CEL-037','GTO-911-C','International 4400',2020,10309,'DIESEL','RESERVA',NULL,'Patio Centro',208415,79,'2025-12-28 13:43:40.601369',7126,'2026-05-23 13:43:40.608683'); INSERT INTO trucks VALUES(38,'CEL-038','GTO-836-H','International 4400',2023,9920,'DIESEL','OPERATIVO','RUTA-12','Patio Norte',80707,60,'2025-12-05 13:43:40.601391',6215,'2026-05-23 13:43:40.608684'); INSERT INTO trucks VALUES(39,'CEL-039','GTO-999-P','Kenworth T270',2025,9564,'DIESEL','EN_RUTA','RUTA-03','Patio Sur',82650,75,'2026-01-10 13:43:40.601410',5907,'2026-05-23 13:43:40.608684'); INSERT INTO trucks VALUES(40,'CEL-040','GTO-430-M','International 4400',2020,9854,'GAS_LP','EN_RUTA','RUTA-03','Patio Centro',56345,52,'2026-03-29 13:43:40.601428',14024,'2026-05-23 13:43:40.608685'); INSERT INTO trucks VALUES(41,'CEL-041','GTO-195-J','Ford F-750',2020,7606,'GAS_LP','OPERATIVO','RUTA-09','Patio Sur',104758,99,'2025-12-15 13:43:40.601445',10531,'2026-05-23 13:43:40.608685'); INSERT INTO trucks VALUES(42,'CEL-042','GTO-129-B','International 4300',2018,8471,'DIESEL','TALLER',NULL,'Patio Centro',125524,93,'2026-02-01 13:43:40.601462',5496,'2026-05-23 13:43:40.608686'); INSERT INTO trucks VALUES(43,'CEL-043','GTO-658-E','Kenworth T270',2024,9979,'DIESEL','MANTENIMIENTO',NULL,'Patio Sur',227909,58,'2026-01-22 13:43:40.601479',6195,'2026-05-23 13:43:40.608686'); INSERT INTO trucks VALUES(44,'CEL-044','GTO-308-F','International 4300',2020,7820,'DIESEL','OPERATIVO','RUTA-08','Patio Centro',196073,71,'2026-04-15 13:43:40.601501',11070,'2026-05-23 13:43:40.608687'); INSERT INTO trucks VALUES(45,'CEL-045','GTO-560-D','International 4400',2020,9599,'DIESEL','OPERATIVO','RUTA-05','Patio Industrial',234223,51,'2026-04-08 13:43:40.601518',10364,'2026-05-23 13:43:40.608687'); INSERT INTO trucks VALUES(46,'CEL-046','GTO-578-H','Hino 268',2021,8509,'DIESEL','OPERATIVO','RUTA-09','Patio Industrial',279998,78,'2026-03-18 13:43:40.601535',8524,'2026-05-23 13:43:40.608688'); INSERT INTO trucks VALUES(47,'CEL-047','GTO-963-L','Hino 268',2024,8481,'DIESEL','OPERATIVO','RUTA-10','Patio Norte',71359,75,'2026-04-14 13:43:40.601554',9333,'2026-05-23 13:43:40.608688'); INSERT INTO trucks VALUES(48,'CEL-048','GTO-474-A','Hino 268',2022,8052,'DIESEL','TALLER',NULL,'Patio Sur',205066,90,'2026-03-06 13:43:40.601570',6204,'2026-05-23 13:43:40.608689'); INSERT INTO trucks VALUES(49,'CEL-049','GTO-386-P','Isuzu FTR',2024,7196,'DIESEL','EN_RUTA',NULL,'Patio Sur',65688,70,'2026-02-12 13:43:40.601586',10555,'2026-05-23 13:43:40.608689'); INSERT INTO trucks VALUES(50,'CEL-050','GTO-303-K','Hino 268',2023,8411,'DIESEL','TALLER',NULL,'Patio Norte',35402,37,'2026-02-22 13:43:40.601602',12761,'2026-05-23 13:43:40.608690'); INSERT INTO trucks VALUES(51,'CEL-051','GTO-243-F','Kenworth T270',2023,9326,'DIESEL','OPERATIVO',NULL,'Patio Centro',191356,84,'2026-01-08 13:43:40.601618',13721,'2026-05-23 13:43:40.608690'); INSERT INTO trucks VALUES(52,'CEL-052','GTO-117-F','Kenworth T270',2021,9689,'DIESEL','EN_RUTA','RUTA-14','Patio Industrial',176311,100,'2026-05-12 13:43:40.601635',14779,'2026-05-23 13:43:40.608691'); INSERT INTO trucks VALUES(53,'CEL-053','GTO-692-K','Kenworth T270',2020,9738,'DIESEL','OPERATIVO','RUTA-13','Patio Industrial',104397,87,'2025-12-08 13:43:40.601652',11229,'2026-05-23 13:43:40.608691'); INSERT INTO trucks VALUES(54,'CEL-054','GTO-348-A','Mercedes-Benz Axor 1725',2024,12470,'DIESEL','TALLER',NULL,'Patio Sur',24928,76,'2026-02-27 13:43:40.601668',11861,'2026-05-23 13:43:40.608692'); INSERT INTO trucks VALUES(55,'CEL-055','GTO-893-K','Mercedes-Benz Axor 1725',2023,12393,'DIESEL','OPERATIVO','RUTA-09','Patio Norte',87394,86,'2026-03-26 13:43:40.601685',14189,'2026-05-23 13:43:40.608692'); INSERT INTO trucks VALUES(56,'CEL-056','GTO-589-J','Hino 268',2022,8321,'GAS_LP','RESERVA',NULL,'Patio Industrial',194477,89,'2026-02-17 13:43:40.601701',9331,'2026-05-23 13:43:40.608693'); INSERT INTO trucks VALUES(57,'CEL-057','GTO-405-D','Kenworth T270',2021,9789,'DIESEL','OPERATIVO','RUTA-09','Patio Sur',271378,60,'2026-01-16 13:43:40.601718',10714,'2026-05-23 13:43:40.608693'); INSERT INTO trucks VALUES(58,'CEL-058','GTO-488-G','Ford F-750',2023,7977,'DIESEL','OPERATIVO','RUTA-09','Patio Sur',167280,25,'2026-03-06 13:43:40.601735',6294,'2026-05-23 13:43:40.608694'); INSERT INTO trucks VALUES(59,'CEL-059','GTO-771-E','Hino 268',2024,8490,'DIESEL','RESERVA',NULL,'Patio Centro',157407,37,'2026-04-21 13:43:40.601751',14614,'2026-05-23 13:43:40.608694'); INSERT INTO trucks VALUES(60,'CEL-060','GTO-331-L','Freightliner M2 106',2020,8553,'DIESEL','OPERATIVO','RUTA-09','Patio Centro',262675,32,'2025-11-25 13:43:40.601767',7252,'2026-05-23 13:43:40.608694'); INSERT INTO trucks VALUES(61,'CEL-061','GTO-261-G','International 4300',2025,7988,'DIESEL','RESERVA',NULL,'Patio Centro',183384,56,'2025-12-04 13:43:40.601783',5969,'2026-05-23 13:43:40.608695'); INSERT INTO trucks VALUES(62,'CEL-062','GTO-840-P','International 4400',2019,10435,'GAS_LP','EN_RUTA','RUTA-12','Patio Industrial',107163,24,'2026-02-06 13:43:40.601800',13116,'2026-05-23 13:43:40.608695'); CREATE INDEX ix_users_id ON users (id); CREATE UNIQUE INDEX ix_users_email ON users (email); CREATE UNIQUE INDEX ix_users_phone ON users (phone); CREATE INDEX ix_addresses_id ON addresses (id); CREATE UNIQUE INDEX ix_reports_folio ON reports (folio); CREATE INDEX ix_reports_id ON reports (id); CREATE INDEX ix_service_ratings_id ON service_ratings (id); CREATE INDEX ix_operational_reports_id ON operational_reports (id); CREATE UNIQUE INDEX ix_operational_reports_folio ON operational_reports (folio); CREATE INDEX ix_trucks_route_id ON trucks (route_id); CREATE INDEX ix_trucks_id ON trucks (id); CREATE UNIQUE INDEX ix_trucks_unit_number ON trucks (unit_number); COMMIT;