| _id | user | isOriginal | originalRef | category | priority | description | status | media | isVoicePost | location | hashtags | mentions | commentsCount | repostsCount | upvotesCount | downvotesCount | shareCount | viewCount | relatedPosts | relatedGrievances | statusHistory | isEdited | isDeleted | isHidden | visibility | engagement | analysis | publicId | editHistory | createdAt | updatedAt | __v | title | updatesCount | isActive |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68681fcd0750e8837c2f497b
|
67e64b3805e03a1d26207e60
|
true
|
TECHNICAL
|
MEDIUM
|
there are lot of potholes in our area
|
VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.65103552694005,
12.901120017837153
],
"placeName": "Bengaluru",
"placeId": "12.901120017837153,77.65103552694005",
"address": "34/3, Hustlehub Tech Park, HSR Layout, Bengaluru, 560102, India"
}
|
{}
|
20
|
0
|
2
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e64b3805e03a1d26207e60",
"updatedAt": "2025-07-04T18:39:09.488Z",
"_id": "68681fcd0750e8837c2f497c"
},
{
"status": "VERIFYING",
"updatedBy": "67e64b3805e03a1d26207e60",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-04T18:39:23.593Z",
"_id": "68681fdb0750e8837c2f4a51"
},
{
"status": "VERIFYING",
"updatedBy": "67f16603e6afb6bf38dd81f0",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-04T18:41:04.028Z",
"_id": "686820400750e8837c2f4c9b"
},
{
"status": "VERIFYING",
"updatedBy": "686820760750e8837c2f4d96",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-04T18:42:59.500Z",
"_id": "686820b30750e8837c2f4ea1"
},
{
"status": "VERIFYING",
"updatedBy": "686820760750e8837c2f4d96",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-04T18:42:59.919Z",
"_id": "686820b30750e8837c2f4eb4"
},
{
"status": "VERIFYING",
"updatedBy": "6868218b0750e8837c2f51bc",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-04T18:47:50.182Z",
"_id": "686821d60750e8837c2f524a"
},
{
"status": "VERIFYING",
"updatedBy": "67ebc82a05e03a1d2620810b",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-05T21:19:09.682Z",
"_id": "686996cd12910a094c60782b"
},
{
"status": "VERIFIED",
"updatedBy": "67ebc82a05e03a1d2620810b",
"reason": "Verified by volunteers: 67e64b3805e03a1d26207e60, 67f16603e6afb6bf38dd81f0, 686820760750e8837c2f4d96, 6868218b0750e8837c2f51bc, 67ebc82a05e03a1d2620810b",
"updatedAt": "2025-07-05T21:19:22.968Z",
"_id": "686996da12910a094c607861"
}
]
|
false
|
false
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "news",
"intent": "complaint",
"english_translation": "there are lot of potholes in our area",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
Uq0Z8dueefb7
|
[
{
"_id": "68681fdb0750e8837c2f4a52"
},
{
"_id": "686820400750e8837c2f4c9c"
},
{
"_id": "686820b30750e8837c2f4ea2"
},
{
"_id": "686820b30750e8837c2f4eb5"
},
{
"_id": "686821d60750e8837c2f524b"
},
{
"_id": "686996cd12910a094c60782c"
},
{
"_id": "686996da12910a094c607862"
}
]
|
Fri Jul 04 2025 18:39:09 GMT+0000 (Coordinated Universal Time)
|
Thu Oct 09 2025 06:03:25 GMT+0000 (Coordinated Universal Time)
|
7
|
there are lot of potholes in our area
|
3
|
||||||
686a66ea12910a094c6085e9
|
67ebc82a05e03a1d2620810b
|
true
|
TECHNICAL
|
MEDIUM
|
The road is completely damaged here, this is a ju…
|
ESCALATED
|
686a66db12910a094c6085d4,686a66df12910a094c6085db,686a66e412910a094c6085e2
|
false
|
{
"type": "Point",
"coordinates": [
77.6531851,
12.8946036
],
"placeName": "Bengaluru",
"placeId": "12.8946036,77.6531851",
"address": "VMV3+Q7V, , Bengaluru, 560068, India"
}
|
{}
|
5
|
0
|
2
|
1
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67ebc82a05e03a1d2620810b",
"updatedAt": "2025-07-06T12:07:06.558Z",
"_id": "686a66ea12910a094c6085ea"
},
{
"status": "VERIFYING",
"updatedBy": "67e64b3805e03a1d26207e60",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-06T12:09:30.847Z",
"_id": "686a677a12910a094c6086a2"
},
{
"status": "VERIFYING",
"updatedBy": "67e64b3805e03a1d26207e60",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-06T12:09:34.197Z",
"_id": "686a677e12910a094c6086b7"
},
{
"status": "VERIFYING",
"updatedBy": "68149f8b0be4b252c936e657",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-08T05:57:00.455Z",
"_id": "686cb32c12910a094c609a7e"
},
{
"status": "VERIFYING",
"updatedBy": "67e5bff505e03a1d26207d51",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-08T09:19:01.076Z",
"_id": "686ce28519da436028a2d95f"
},
{
"status": "VERIFYING",
"updatedBy": "687c9a6b57037dc009b702d9",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-20T07:41:59.639Z",
"_id": "687c9dc757037dc009b70544"
},
{
"status": "VERIFYING",
"updatedBy": "687c9a6b57037dc009b702d9",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-20T07:42:01.140Z",
"_id": "687c9dc957037dc009b70557"
},
{
"status": "VERIFYING",
"updatedBy": "68a2f4f2ceea89b5e110f499",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-10-06T07:03:43.988Z",
"_id": "68e369cf39cf052166e68cdd"
},
{
"status": "ESCALATED",
"updatedBy": "68a2f4f2ceea89b5e110f499",
"reason": "Escalated",
"updatedAt": "2025-10-06T07:04:08.411Z",
"_id": "68e369e839cf052166e68d11"
}
]
|
false
|
false
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "news",
"intent": "complaint",
"english_translation": "The road is completely damaged here, this is a junction of 3 roads, and the damage here is causing a lot of problems to the people travelling on this road regularly. It's damaged since the last 2 years and no proper action has been taken to resolve this. It's on Haralur Main road.",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
UqAfUQce73a5
|
[
{
"_id": "686a677a12910a094c6086a3"
},
{
"_id": "686a677e12910a094c6086b8"
},
{
"_id": "686cb32c12910a094c609a7f"
},
{
"_id": "686ce28519da436028a2d960"
},
{
"_id": "687c9dc757037dc009b70545"
},
{
"_id": "687c9dc957037dc009b70558"
},
{
"_id": "68e369cf39cf052166e68cde"
},
{
"_id": "68e369e839cf052166e68d12"
}
]
|
Sun Jul 06 2025 12:07:06 GMT+0000 (Coordinated Universal Time)
|
Thu Oct 16 2025 11:00:57 GMT+0000 (Coordinated Universal Time)
|
8
|
Haralur Main road lo 2 years nunchi road damage c…
|
true
|
|||||
68721c3812497aca4795bf2f
|
6872003912497aca4795bcde
|
true
|
TECHNICAL
|
HIGH
|
the vehicles here are not parked properly causing…
|
ESCALATED
|
68721c2c12497aca4795bf29
|
false
|
{
"type": "Point",
"coordinates": [
77.65428569759868,
12.893316647459084
],
"placeName": "58/22, 1st Cross Road, Springvillae",
"placeId": "12.893316647459084,77.65428569759868",
"address": "58/22, 1st Cross Road, Springvillae, Kudlu, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
1
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "6872003912497aca4795bcde",
"updatedAt": "2025-07-12T08:26:32.908Z",
"_id": "68721c3812497aca4795bf30"
},
{
"status": "VERIFYING",
"updatedBy": "67e64b3805e03a1d26207e60",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-12T08:28:01.478Z",
"_id": "68721c9112497aca4795bf92"
},
{
"status": "VERIFYING",
"updatedBy": "687c9a6b57037dc009b702d9",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-20T07:42:11.905Z",
"_id": "687c9dd357037dc009b70581"
},
{
"status": "VERIFYING",
"updatedBy": "68a2f4f2ceea89b5e110f499",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-10-06T10:30:54.991Z",
"_id": "68e39a5e39cf052166e69036"
},
{
"status": "ESCALATED",
"updatedBy": "68a2f4f2ceea89b5e110f499",
"reason": "Escalated !!!!",
"updatedAt": "2025-10-09T09:43:08.125Z",
"_id": "68e783ac39cf052166e69e52"
}
]
|
false
|
false
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "lifestyle",
"intent": "complaint",
"english_translation": "the vehicles here are not parked properly causing disturbance..",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
Uqir7Gy5565a
|
[
{
"_id": "68721c9112497aca4795bf93"
},
{
"_id": "687c9dd357037dc009b70582"
},
{
"_id": "68e39a5e39cf052166e69037"
},
{
"_id": "68e783ac39cf052166e69e53"
}
]
|
Sat Jul 12 2025 08:26:32 GMT+0000 (Coordinated Universal Time)
|
Thu Oct 09 2025 09:43:08 GMT+0000 (Coordinated Universal Time)
|
4
|
vehicles not parked properly causing disturbance
|
true
|
|||||
68721c6612497aca4795bf3c
|
6872003912497aca4795bcde
|
true
|
TECHNICAL
|
LOW
|
the wall is very small and insecure
|
ESCALATED
|
68721c5d12497aca4795bf36
|
false
|
{
"type": "Point",
"coordinates": [
77.65428569759868,
12.893316647459084
],
"placeName": "58/22, 1st Cross Road, Springvillae",
"placeId": "12.893316647459084,77.65428569759868",
"address": "58/22, 1st Cross Road, Springvillae, Kudlu, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
2
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "6872003912497aca4795bcde",
"updatedAt": "2025-07-12T08:27:18.074Z",
"_id": "68721c6612497aca4795bf3d"
},
{
"status": "VERIFYING",
"updatedBy": "67e64b3805e03a1d26207e60",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-12T08:28:04.232Z",
"_id": "68721c9412497aca4795bfa8"
},
{
"status": "VERIFYING",
"updatedBy": "687c9a6b57037dc009b702d9",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-07-20T07:41:52.968Z",
"_id": "687c9dc057037dc009b70512"
},
{
"status": "VERIFYING",
"updatedBy": "68a2f4f2ceea89b5e110f499",
"reason": "Task accepted and grievance set to VERIFYING",
"updatedAt": "2025-10-06T11:20:07.828Z",
"_id": "68e3a5e739cf052166e69188"
},
{
"status": "ESCALATED",
"updatedBy": "68a2f4f2ceea89b5e110f499",
"reason": "Escalated !!!!",
"updatedAt": "2025-10-09T09:43:14.308Z",
"_id": "68e783b239cf052166e69e70"
}
]
|
false
|
false
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 1
}
|
{
"category": "politics",
"intent": "persuasive",
"english_translation": "the wall is very small and insecure",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
UqirJ1Q365ee
|
[
{
"_id": "68721c9412497aca4795bfa9"
},
{
"_id": "687c9dc057037dc009b70513"
},
{
"_id": "68e3a5e739cf052166e69189"
},
{
"_id": "68e783b239cf052166e69e71"
}
]
|
Sat Jul 12 2025 08:27:18 GMT+0000 (Coordinated Universal Time)
|
Thu Oct 09 2025 09:43:14 GMT+0000 (Coordinated Universal Time)
|
4
|
the wall is very small and insecure
|
false
|
|||||
68904a6bece3663952264a28
|
67e5bff505e03a1d26207d51
|
true
|
TECHNICAL
|
MEDIUM
|
test grievance
|
NOT VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.654285,
12.8932017
],
"placeName": "VILLA-47",
"placeId": "12.8932017,77.654285",
"address": "VILLA-47, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
0
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e5bff505e03a1d26207d51",
"updatedAt": "2025-08-04T05:51:39.153Z",
"_id": "68904a6bece3663952264a29"
}
]
|
false
|
true
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "personal",
"intent": "complaint",
"english_translation": "test grievance",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
7TTvVqsd1b9c
|
Mon Aug 04 2025 05:51:39 GMT+0000 (Coordinated Universal Time)
|
Thu Sep 18 2025 13:01:21 GMT+0000 (Coordinated Universal Time)
|
0
|
I apologize, but the complaint description simply…
|
true
|
|||||||
68904b0b8559b26f0b8425f4
|
67e5bff505e03a1d26207d51
|
true
|
TECHNICAL
|
MEDIUM
|
test grievance 2
|
NOT VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.654285,
12.8932017
],
"placeName": "VILLA-47",
"placeId": "12.8932017,77.654285",
"address": "VILLA-47, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
0
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e5bff505e03a1d26207d51",
"updatedAt": "2025-08-04T05:54:19.570Z",
"_id": "68904b0b8559b26f0b8425f5"
}
]
|
false
|
true
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "business",
"intent": "complaint",
"english_translation": "test grievance 2",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
7TTvTb30607f
|
Mon Aug 04 2025 05:54:19 GMT+0000 (Coordinated Universal Time)
|
Thu Sep 18 2025 13:01:23 GMT+0000 (Coordinated Universal Time)
|
0
|
test grievance 2
|
true
|
|||||||
6890609ab9efb718378afbe5
|
67e5bff505e03a1d26207d51
|
true
|
TECHNICAL
|
MEDIUM
|
test grievance
|
NOT VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.654285,
12.8932017
],
"placeName": "VILLA-47",
"placeId": "12.8932017,77.654285",
"address": "VILLA-47, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
0
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e5bff505e03a1d26207d51",
"updatedAt": "2025-08-04T07:26:18.286Z",
"_id": "6890609ab9efb718378afbe6"
}
]
|
false
|
true
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "lifestyle",
"intent": "complaint",
"english_translation": "test grievance",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
7TLSqA4123cd
|
Mon Aug 04 2025 07:26:18 GMT+0000 (Coordinated Universal Time)
|
Thu Sep 18 2025 13:01:27 GMT+0000 (Coordinated Universal Time)
|
0
|
I apologize, but the complaint description you've…
|
true
|
|||||||
68906138b9efb718378afcae
|
67e5bff505e03a1d26207d51
|
true
|
TECHNICAL
|
MEDIUM
|
test grievance 2
|
NOT VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.654285,
12.8932017
],
"placeName": "VILLA-47",
"placeId": "12.8932017,77.654285",
"address": "VILLA-47, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
0
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e5bff505e03a1d26207d51",
"updatedAt": "2025-08-04T07:28:56.954Z",
"_id": "68906138b9efb718378afcaf"
}
]
|
false
|
true
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "business",
"intent": "complaint",
"english_translation": "test grievance 2",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
7TLS9vQ930ec
|
Mon Aug 04 2025 07:28:56 GMT+0000 (Coordinated Universal Time)
|
Thu Sep 18 2025 13:01:30 GMT+0000 (Coordinated Universal Time)
|
0
|
test grievance 2
|
true
|
|||||||
68906146b9efb718378afcbc
|
67e5bff505e03a1d26207d51
|
true
|
TECHNICAL
|
MEDIUM
|
test grievance 3
|
NOT VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.654285,
12.8932017
],
"placeName": "VILLA-47",
"placeId": "12.8932017,77.654285",
"address": "VILLA-47, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
0
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e5bff505e03a1d26207d51",
"updatedAt": "2025-08-04T07:29:10.855Z",
"_id": "68906146b9efb718378afcbd"
}
]
|
false
|
true
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "business",
"intent": "complaint",
"english_translation": "test grievance 3",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
7TLSMrx8dd5a
|
Mon Aug 04 2025 07:29:10 GMT+0000 (Coordinated Universal Time)
|
Thu Sep 18 2025 13:01:33 GMT+0000 (Coordinated Universal Time)
|
0
|
test grievance 3
|
true
|
|||||||
689062d2b9efb718378aff2b
|
67e5bff505e03a1d26207d51
|
true
|
TECHNICAL
|
MEDIUM
|
test grievance
|
NOT VERIFIED
|
false
|
{
"type": "Point",
"coordinates": [
77.654285,
12.8932017
],
"placeName": "VILLA-47",
"placeId": "12.8932017,77.654285",
"address": "VILLA-47, Bengaluru, Karnataka, 560068, India"
}
|
{}
|
0
|
0
|
0
|
0
|
0
|
0
|
[
{
"status": "NOT VERIFIED",
"updatedBy": "67e5bff505e03a1d26207d51",
"updatedAt": "2025-08-04T07:35:46.515Z",
"_id": "689062d2b9efb718378aff2c"
}
]
|
false
|
true
|
false
|
PUBLIC
|
{
"clickCount": 0,
"saveCount": 0,
"reportCount": 0
}
|
{
"category": "personal",
"intent": "complaint",
"english_translation": "test grievance",
"is_nsfw": false,
"follow_up_questions": [],
"language": "unknown"
}
|
7TLUf6F68000
|
Mon Aug 04 2025 07:35:46 GMT+0000 (Coordinated Universal Time)
|
Thu Sep 18 2025 13:01:37 GMT+0000 (Coordinated Universal Time)
|
0
|
I apologize, but the complaint description you pr…
|
true
|
| Documents | 47 |
| Total doc size | 68.27 KB |
| Average doc size | 1.45 KB |
| Pre-allocated size | 60 KB |
| Indexes | 18 |
| Total index size | 648 KB |
| Padding factor | |
| Extents |
| Name | Columns | Size | Attributes | Actions |
|---|---|---|---|---|
| _id_ |
_id ASC
|
36 KB | DEL | |
| publicId_1 |
publicId ASC
|
36 KB |
background: true
unique: true
|
DEL |
| user_1 |
user ASC
|
36 KB |
background: true
|
DEL |
| membershipId_1 |
membershipId ASC
|
36 KB |
background: true
|
DEL |
| category_1 |
category ASC
|
36 KB |
background: true
|
DEL |
| priority_1 |
priority ASC
|
36 KB |
background: true
|
DEL |
| status_1 |
status ASC
|
36 KB |
background: true
|
DEL |
| hashtags_1 |
hashtags ASC
|
36 KB |
background: true
|
DEL |
| createdAt_1 |
createdAt ASC
|
36 KB |
background: true
|
DEL |
| isActive_1 |
isActive ASC
|
36 KB |
background: true
|
DEL |
| visibility_1 |
visibility ASC
|
36 KB |
background: true
|
DEL |
| location_2dsphere |
location DSC
|
36 KB |
background: true
2dsphereIndexVersion: 3
|
DEL |
| user_1_createdAt_-1 |
user ASC
createdAt DSC
|
36 KB |
background: true
|
DEL |
| category_1_status_1_createdAt_-1 |
category ASC
status ASC
createdAt DSC
|
36 KB |
background: true
|
DEL |
| publicId_1_isDeleted_1 |
publicId ASC
isDeleted ASC
|
36 KB |
background: true
|
DEL |
| publicId_1_visibility_1 |
publicId ASC
visibility ASC
|
36 KB |
background: true
|
DEL |
| publicId_1_status_1 |
publicId ASC
status ASC
|
36 KB |
background: true
|
DEL |
| authorContext.type_1_createdAt_-1 |
authorContext.type ASC
createdAt DSC
|
36 KB |
background: true
|
DEL |