Civic Engagement Crowdsourcing Signals

This dataset provides detailed, user-reported civic issues with rich metadata on location, urgency, resolution, and feedback, enabling AI-driven event detection and resource prioritization for urban improvement. It supports startups, researchers, and civic tech developers in building responsive policy and community analytics solutions.

  • last updated 22 Oct 2025
  • by GoMask
The brief that made it

AI-powered civic event detection and trend analysis

Sample rows

preview · 8 of 200 rows · all 20 columns
signal_idstringstatusstringresource_priority_scorefloatlocation_statestringuser_idstringissue_typestringreported_datetimedatetimelocation_street_addressstringlocation_citystringlocation_postal_codestringlocation_countrystringlatitudefloatlongitudefloaturgency_levelintegerresolved_datetimedatetimefeedback_ratingintegerfeedback_commentstringassigned_departmentstringissue_descriptionstringresolution_descriptionstring
SIG-001-A23resolved0.81NYUSR-0001pothole2024-04-02T08:22:00145 Maple AveBrooklyn11201USA40.6936-73.98942024-04-03T15:10:005Quick and effective response.Public WorksLarge pothole near the intersection causing traffic delays.Pothole filled and road repaved.
SIG-002-X9Freported0.45MAUSR-0023noise2024-03-29T22:47:0023 Pine StreetBoston02111USA42.3522-71.06052blankblankblankNoise ControlContinuous loud construction noise reported at night.blank
SIG-003-B18in_progress0.59CAUSR-0017streetlight2024-04-01T20:18:00101 Main BlvdSan Francisco94109USA37.7945-122.42153blankblankblankLighting ServicesStreetlight is out on the corner near the park entrance.blank
SIG-004-X88resolved0.93ILUSR-0027waste2024-03-30T10:10:0055 Orchard LaneChicago60607USA41.8764-87.651752024-03-30T16:20:004Rodents still present. Needs more attention.SanitationOverflowing trash bin attracting rodents.Bin emptied and area cleaned.
SIG-005-Y77closed0.38WAUSR-0006graffiti2024-04-01T13:42:00200 Elm StreetSeattle98101USA47.6097-122.333122024-04-02T10:01:004Wall looks clean now.Civic MaintenanceGraffiti on public library wall.Graffiti painted over by city staff.
SIG-006-P56in_progress0.97TXUSR-0019roadblock2024-04-03T08:55:00789 Willow DriveAustin78704USA30.2498-97.7545blankblankblankEmergency ResponseTree fallen and blocking two lanes of traffic.blank
SIG-007-W44reported0.54TXUSR-0025streetlight2024-04-02T22:33:0066 Oak StreetHouston77002USA29.7584-95.36793blankblankblankLighting ServicesStreetlight flickering and causing visibility issues.blank
SIG-008-H32resolved0.72COUSR-0024other2024-03-31T16:08:0012 Spruce LaneDenver80202USA39.7517-104.996332024-04-01T09:55:005Resolved quickly, thanks!Water ServicesWater leak near the community garden entrance.Water utility fixed the leak.

What the 200 rows show

from the 200-row sample

Reported status stands out: mean resource_priority_score is 0.33, against 0.67 for the rest.

  • 0.58median resource_priority_score
  • 2location countries
  • 7issue types
  • 25assigned departments
  • 58location cities
  • 3median urgency_level
Mean resource_priority_score by status200 rows
00.510.33reported59 rows0.65in_progr…56 rows0.74resolved72 rows0.33closed13 rows
resource_priority_score200 rows, in bands of 0.1
01530318281515242422213000.51resource_priority_score →

Median 0.58, from 0.07 to 0.99.

location_state200 rows · top 10 of 34 values
  1. CA42
  2. TX30
  3. CO12
  4. NY11
  5. OH9
  6. AZ9
  7. FL7
  8. MO7
  9. WA6
  10. OR5
20 columns by typefrom the column list below
  • string 13
  • integer 2
  • float 3
  • datetime 2

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 13 columns
signal_idstringUnique identifier for each civic engagement signal/event reported.uniqueSIG-001-A23
user_idstringUnique identifier for the user reporting the civic issue.USR-0001
issue_typestringType of civic issue reported (e.g., pothole, noise complaint, streetlight outage).7 valuespothole
issue_descriptionstringDetailed description of the reported civic issue.10 or moreGraffiti on city bus.
location_street_addressstringStreet address where the issue occurred.optional145 Maple Ave
location_citystringCity where the issue occurred.Brooklyn
location_statestringState or province where the issue occurred.NY
location_postal_codestringPostal code of the location.optional11201
location_countrystringCountry where the issue occurred.2 countriesUSA
statusstringCurrent status of the issue (e.g., reported, in_progress, resolved, closed).reported · in_progress · resolved · closedresolved
resolution_descriptionstringDescription of how the issue was resolved, if applicable.optionalBus cleaned at depot.
feedback_commentstringAdditional user comments or feedback on the resolution.optionalWall looks clean now.
assigned_departmentstringMunicipal department or agency assigned to handle the issue.optionalPublic Works
Numbers 5 columns
latitudefloatLatitude coordinate of the issue location.-90 to 90 · optional40.6936
longitudefloatLongitude coordinate of the issue location.-180 to 180 · optional-73.989
urgency_levelintegerUrgency level assigned to the issue (1=low, 5=high).1 to 5 · optional4
feedback_ratingintegerUser feedback rating on the resolution (1=poor, 5=excellent).1 to 5 · optional5
resource_priority_scorefloatAI-generated score indicating priority for resource allocation (0-1).0 to 1 · optional0.81
Dates and times 2 columns
reported_datetimedatetimeDate and time when the issue was reported.2024-04-02T08:22:00
resolved_datetimedatetimeDate and time when the issue was resolved.optional2024-04-03T15:10:00

Use it for

  • median resourc…0.58200 rowsmean resource priorit…0.33repo…0.65in_p…0.74reso…0.33clos…

    A government dashboard

    Resource_priority_score by status and a breakdown of location_state. Excel, Power BI or Tableau.

  • Why do the 59 reported rows have a mean resource_priority_score of 0.33?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable signals with user_id, issue_type and issue_description to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows20 columns
Yours1,000 rows20 columnslocation_street_address: UK only

blueprint · civic-engagement-crowdsourcing-signals

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each record includes timestamp, location, and issue category.
  • Issue status transitions from reported to resolved or escalated.
  • Resolution times vary by issue severity and category.
  • User feedback may be missing for certain resolved cases.
  • Duplicate reports within 24h are flagged for aggregation.
  • Location granularity includes zip code and GPS coordinates.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
civic-engagement-crowdsourcing-signals

More in Government

Browse all
Also in GovernmentMunicipal Service Request ProgressLocal Government Budget BreakdownPublic Service Complaint ResolutionAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.