Civic Issue Reporting Dataset

This dataset contains simulated civic issue reports submitted by residents, including detailed information on issue types, locations, submission and resolution timelines, and resident engagement. It enables analysis of urban problem hotspots, municipal response patterns, and trends in civic participation, supporting smarter city management and community engagement initiatives.

  • opened 10 times
  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Identifying urban problem hotspots for targeted municipal intervention

Sample rows

preview · 8 of 200 rows · all 21 columns
report_idstringissue_statusstringis_anonymousbooleanmunicipal_departmentstringresident_idstringresident_namestringresident_emailstringresident_phonestringissue_typestringreport_datetimedatetimelocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringlocation_countrystringlatitudefloatlongitudefloatresolution_datetimedatetimeissue_descriptionstringphoto_urlstringresolution_notesstring
RPT-1A8ZQ394in-progressfalseRoads & HighwaysRES-1023Charlotte Brookscharlotte.brooks94@gmail.com+1-212-555-0896pothole2024-06-04T09:13:00215 Park AveNew YorkNY10016USA40.745-73.982blankLarge pothole causing traffic disruption near the intersection; vehicles are swerving to avoid it.https://civicphotos.nyc/parkave-pothole.jpgblank
RPT-6X8KJQ97submittedtrueblankRES-1175blankblankblanknoise2024-06-05T21:02:0047 Grand StBrooklynNY11249USA40.717-73.963blankConstruction noise persists late into the night, disturbing nearby residents.blankblank
RPT-9H7FQZ13resolvedfalseSanitationRES-1304Miguel Sanchezmsanchez77@outlook.com+1 718 555 2390garbage2024-05-29T08:44:00809 Bedford AveBrooklynNY11205USA40.695-73.9562024-05-30T10:10:00Overflowing garbage bins on the corner are attracting pests and causing unpleasant odors.https://civicphotos.nyc/garbage-bedford.jpgGarbage bins emptied and cleaned by sanitation crew.
RPT-2L6VRP82submittedfalseElectrical ServicesRES-1042Jasmine Leejlee98@gmail.com+1-917-555-0147streetlight2024-06-02T19:23:00132 W 34th StNew YorkNY10001USA40.751-73.99blankStreetlight not functioning, resulting in a dark street section and safety concerns at night.blankblank
RPT-7Y3VBN65in-progresstruePublic WorksRES-1210blankblankblankgraffiti2024-05-31T11:45:0098 Malcolm X BlvdHarlemNY10026USA40.802-73.953blankGraffiti observed on the wall of a public building, creating an unsightly environment.https://civicphotos.nyc/harlem-graffiti.jpgblank
RPT-4N1KTC53resolvedfalseWater ManagementRES-1255Derek Whitedwhite@whitecorp.com+1-646-555-3127water-leak2024-05-27T15:05:00401 5th AveNew YorkNY10016USA40.749-73.9822024-05-28T09:27:00Water leaking from a hydrant causing flooding on the sidewalk.blankHydrant valve repaired, area cleared of excess water.
RPT-5Q8MJD71in-progressfalseSanitationRES-1099Priyanka Kumarpkumar@nyc.net+1 347 555 2084illegal-dumping2024-06-03T13:36:00222 Flatbush AveBrooklynNY11217USA40.683-73.976blankIllegal dumping of construction debris observed behind the supermarket.https://civicphotos.nyc/flatbush-dumping.jpgblank
RPT-8S2LPD24submittedtrueParks & RecreationRES-1152blankblankblankother2024-06-05T15:12:0012 Prospect Park WBrooklynNY11215USA40.66-73.973blankBroken bench in the park near the playground, potential safety hazard for children.blankblank

What the 200 rows show

from the 200-row sample

Submitted (issue status) stands out: 44 of its 66 rows have is_anonymous = true, against 11 of 134 for the rest.

  • 28%is_anonymous = true
  • 6location states
  • 8issue types
Is anonymous rate by issue_statusis_anonymous = true
0%50%100%67%submit…44 of 6619%in-pro…11 of 580%resolv…0 of 510%closed0 of 220%reject…0 of 3
municipal_department193 rows with a value · 7 left blank
  1. Sanitation46
  2. Electrical Services20
  3. Public Works20
  4. Community Services18
  5. Noise Control11
  6. Road Maintenance9
  7. Water Department8
  8. Parks & Recreation7
  9. Roads & Highways6
  10. Roads6
21 columns by typefrom the column list below
  • string 16
  • float 2
  • datetime 2
  • boolean 1

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 16 columns
report_idstringUnique identifier for each civic issue report.uniqueRPT-1A8ZQ394
resident_idstringUnique identifier for the resident submitting the report.RES-1023
resident_namestringName of the resident submitting the report.Charlotte Brooks
resident_emailstringEmail address of the resident submitting the report.msanchez77@outlook.com
resident_phonestringPhone number of the resident submitting the report.optional+1-212-555-0896
issue_typestringCategory of the civic issue reported (e.g., pothole, streetlight, garbage, noise).8 valuespothole
issue_descriptionstringDetailed description of the civic issue.10 to 1,000Large pothole causing tra…
issue_statusstringCurrent status of the issue report.submitted · in-progress · resolved · closed · rejectedin-progress
location_street_addressstringStreet address where the issue is located.215 Park Ave
location_citystringCity where the issue is located.New York
location_statestringState where the issue is located.6 statesNY
location_postal_codestringPostal code of the issue location.10016
location_countrystringCountry where the issue is located.USA
photo_urlstringURL to a photo attached to the report, if available.optionalhttps://civicphotos.nyc/p…
municipal_departmentstringMunicipal department responsible for addressing the issue.optionalRoads & Highways
resolution_notesstringNotes or comments on how the issue was resolved.up to 1,000 · optionalSidewalk repaired.
Numbers 2 columns
latitudefloatLatitude coordinate of the issue location.-90 to 90 · optional40.745
longitudefloatLongitude coordinate of the issue location.-180 to 180 · optional-73.982
Dates and times 2 columns
report_datetimedatetimeDate and time when the report was submitted.2024-06-04T09:13:00
resolution_datetimedatetimeDate and time when the issue was resolved or closed.optional2024-05-30T10:10:00
True or false 1 column
is_anonymousbooleanIndicates if the report was submitted anonymously.false

15 SQL practice questions for the Civic Issue Reporting Dataset

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeGROUP BY · COUNT

    Reports by issue type

    Count the reports for each issue_type. Return the columns issue_type and report_count, ordered by report_count from highest to lowest, then by issue_type alphabetically.

    Tables: civic_issue_reporting_dataset · your result: 2 columns, 8 rows
  2. 02BeginnerFreeWHERE · ORDER BY

    Open potholes list

    List report_id, location_street_address and report_datetime for every pothole report whose issue_status is 'submitted'. Order the results by report_datetime ascending, then by report_id.

    Tables: civic_issue_reporting_dataset · your result: 3 columns, 7 rows
  3. 03BeginnerFreeDISTINCT · IS NOT NULL

    Distinct departments

    Return the distinct, non-null municipal_department values sorted alphabetically. The result should have a single column named municipal_department.

    Tables: civic_issue_reporting_dataset · your result: 1 columns, 22 rows
  1. 04Anonymous share by statusBeginner
  2. 05Reports per state bar chartPower BI
  3. 06Cities with many reportsIntermediate
  4. 07Resolution time bucketsIntermediate
  5. 08Monthly report volumeIntermediate
  6. 09Slow issue types vs overallIntermediate
  7. 10Resolution rate by issue typePower BI
  8. 11Rank cities within stateAdvanced
  9. 12Days between consecutive reportsAdvanced
  10. 13Running total of reportsAdvanced
  11. 14Percent of total by issue typeAdvanced
  12. 15Month-over-month change tablePower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • is anonymous28%55 of 200 rowsis anonymous by issue…67%subm…19%in-p…0%reso…0%clos…

    A government dashboard

    The is_anonymous rate, is_anonymous by issue_status and a breakdown of municipal_department. Excel, Power BI or Tableau.

  • Why do 55 of 200 rows have is_anonymous = true?

    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 reports with resident_id, resident_name and resident_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 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 rows21 columns
Yours1,000 rows21 columnslocation_street_address: UK only

blueprint · civic-issue-reporting-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 21 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
  • Issue type randomly assigned from 12 classes
  • Location anonymized to district level
  • Resolution status: open, closed, pending
  • Submission channel: web, app, phone
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-issue-reporting-dataset

More in Government

Browse all
Also in GovernmentLocal Government Feedback SurveyProcurement Spend AnalyticsPublic Procurement Transparency LogsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.