Permit Application Processing Time

This dataset provides comprehensive tracking of government permit applications, capturing critical timestamps from submission to approval or denial, along with applicant and processing details. It enables analysis of processing durations, identification of workflow bottlenecks, and insights into applicant demographics and office performance. The dataset is ideal for process optimization, transparency initiatives, and public service improvement.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing permit processing times to identify and address workflow bottlenecks

Sample rows

preview · 8 of 85 rows · all 20 columns
permit_application_idstringapplicant_address_countrystringapplication_fee_amountfloatprocessing_officestringapplicant_idstringpermit_typestringapplication_submitted_datetimedatetimeapplication_received_datetimedatetimeapplication_review_start_datetimedatetimeapplication_approved_datetimedatetimeapplication_denied_datetimedatetimecurrent_statusstringprocessing_officer_idstringapplicant_namestringapplicant_emailstringapplicant_phonestringapplicant_address_streetstringapplicant_address_citystringapplicant_address_statestringapplicant_address_postal_codestring
PA-20240001USA200Central OfficeAPP-1001Building2024-04-01T09:15:132024-04-01T10:01:352024-04-02T09:33:102024-04-10T12:25:47blankapprovedPO-007Olivia Johnsonolivia.johnson@domain.com+1-212-555-1023784 Upper AveNew YorkNY10009
PA-20240002USA150.5Downtown BranchAPP-1002Event2024-04-02T15:41:002024-04-02T16:00:142024-04-03T09:09:32blankblankunder_reviewPO-003Markus Linmarkus.lin@email.net+1-617-555-992232 Beacon StBostonMA02108
PA-20240003USA75Central OfficeAPP-1003Signage2024-04-03T12:22:132024-04-03T13:00:00blankblankblankreceivedblankSarah Williamssarahw@company.org415-555-334418 Market StSan FranciscoCA94103
PA-20240004USA110West OfficeAPP-1004Zoning2024-04-02T08:07:552024-04-02T08:12:302024-04-03T10:25:15blank2024-04-07T15:44:33deniedPO-012Jeffrey Kimjeff.kim@kjrealty.com503-555-118991 NW 21st AvePortlandOR97209
PA-20240005USA300East OfficeAPP-1005Food Service2024-04-04T13:10:202024-04-04T13:18:20blankblankblankreceivedblankPriya Patelpriya.patel@eatwell.biz312-555-66772254 W Adams StChicagoIL60612
PA-20240006USA250Central OfficeAPP-1006Building2024-04-05T10:19:542024-04-05T11:02:252024-04-06T09:33:102024-04-17T16:27:07blankapprovedPO-007Jason Freemanjason.freeman@domain.com510-555-2323802 Lakeview BlvdOaklandCA94610
PA-20240007USA125Downtown BranchAPP-1007Event2024-04-05T14:30:412024-04-05T15:09:012024-04-06T08:50:10blank2024-04-12T13:00:00deniedPO-005Isabel Garciaisabel.garcia@culturalevents.org786-555-128014 W Flagler StMiamiFL33130
PA-20240008USA90Central OfficeAPP-1008Signage2024-04-06T09:25:002024-04-06T09:40:13blankblankblankreceivedblankHenry Nguyenhenry.n@signexperts.com206-555-87772213 5th AveSeattleWA98121

What the 85 rows show

from the 85-row sample
  • 150.0median application_fee_amount
  • 5current statuses
  • 11permit types
  • 16applicant address states
  • 21applicant address cities
applicant_address_country85 rows by value
0459082USA96%2United Kingd…2%1China1%
application_fee_amount85 rows, in bands of 50
015301251691268440250450application_fee_amount →

Median 150.0, from 49.0 to 420.0.

processing_office77 rows with a value · 8 left blank
  1. Central Office16
  2. Downtown Branch10
  3. West Office8
  4. PHL-018
  5. East Office7
  6. CHI-057
  7. DAL-036
  8. NYC-045
  9. SFO-025
  10. North Branch2
20 columns by typefrom the column list below
  • string 14
  • float 1
  • datetime 5

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 14 columns
permit_application_idstringUnique identifier for each permit applicationuniquePA-20240001
applicant_idstringUnique identifier for the applicant (individual or organization)APP-1001
permit_typestringType or category of permit being applied for11 typesBuilding
current_statusstringCurrent status of the application (e.g., submitted, under_review, approved, denied, withdrawn)6 valuesapproved
processing_officestringName or code of the government office processing the applicationoptionalCentral Office
processing_officer_idstringIdentifier for the officer responsible for processing the applicationoptionalPO-007
applicant_namestringFull name of the applicantoptionalOlivia Johnson
applicant_emailstringEmail address of the applicantoptionalmarkus.lin@email.net
applicant_phonestringPhone number of the applicantoptional+1-212-555-1023
applicant_address_streetstringStreet address of the applicantoptional784 Upper Ave
applicant_address_citystringCity of the applicant's addressoptionalNew York
applicant_address_statestringState or province of the applicant's addressoptionalNY
applicant_address_postal_codestringPostal code of the applicant's addressoptional10009
applicant_address_countrystringCountry of the applicant's address3 countries · optionalUSA
Numbers 1 column
application_fee_amountfloatFee amount paid for the permit application0 or more · optional200
Dates and times 5 columns
application_submitted_datetimedatetimeTimestamp when the permit application was officially submitted2024-04-01T09:15:13
application_received_datetimedatetimeTimestamp when the application was received by the processing authorityoptional2024-04-01T10:01:35
application_review_start_datetimedatetimeTimestamp when the review process for the application beganoptional2024-04-02T09:33:10
application_approved_datetimedatetimeTimestamp when the application was approvedoptional2024-04-10T12:25:47
application_denied_datetimedatetimeTimestamp when the application was denied (if applicable)optional2024-04-07T15:44:33

Use it for

  • median applica…150.085 rowsmean application fee …177.0USA262.8United…300.0China

    A government dashboard

    Application_fee_amount by applicant_address_country and a breakdown of processing_office. Excel, Power BI or Tableau.

  • What pattern can you find in 85 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 85 rows.

  • A software demo

    Believable permit applications with applicant_id, permit_type and application_submitted_datetime 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 dataset85 rows20 columns
Yours1,000 rows20 columnsapplicant_address_street: UK only

blueprint · permit-application-processing-time

Behind this dataset

Same schema. As many rows as you need.

These 85 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
  • Record submission and approval date
  • Calculate total processing days
  • Flag applications exceeding standard time
  • Categorize by permit type
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
permit-application-processing-time

What should your data show?

Preview 20 rows free
No signup. No card.