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.
Sample rows
preview · 8 of 85 rows · all 20 columns| permit_application_idstring | applicant_address_countrystring | application_fee_amountfloat | processing_officestring | applicant_idstring | permit_typestring | application_submitted_datetimedatetime | application_received_datetimedatetime | application_review_start_datetimedatetime | application_approved_datetimedatetime | application_denied_datetimedatetime | current_statusstring | processing_officer_idstring | applicant_namestring | applicant_emailstring | applicant_phonestring | applicant_address_streetstring | applicant_address_citystring | applicant_address_statestring | applicant_address_postal_codestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PA-20240001 | USA | 200 | Central Office | APP-1001 | Building | 2024-04-01T09:15:13 | 2024-04-01T10:01:35 | 2024-04-02T09:33:10 | 2024-04-10T12:25:47 | blank | approved | PO-007 | Olivia Johnson | olivia.johnson@ | +1-212-555-1023 | 784 Upper Ave | New York | NY | 10009 |
| PA-20240002 | USA | 150.5 | Downtown Branch | APP-1002 | Event | 2024-04-02T15:41:00 | 2024-04-02T16:00:14 | 2024-04-03T09:09:32 | blank | blank | under_review | PO-003 | Markus Lin | markus.lin@ | +1-617-555-9922 | 32 Beacon St | Boston | MA | 02108 |
| PA-20240003 | USA | 75 | Central Office | APP-1003 | Signage | 2024-04-03T12:22:13 | 2024-04-03T13:00:00 | blank | blank | blank | received | blank | Sarah Williams | sarahw@ | 415-555-3344 | 18 Market St | San Francisco | CA | 94103 |
| PA-20240004 | USA | 110 | West Office | APP-1004 | Zoning | 2024-04-02T08:07:55 | 2024-04-02T08:12:30 | 2024-04-03T10:25:15 | blank | 2024-04-07T15:44:33 | denied | PO-012 | Jeffrey Kim | jeff.kim@ | 503-555-1189 | 91 NW 21st Ave | Portland | OR | 97209 |
| PA-20240005 | USA | 300 | East Office | APP-1005 | Food Service | 2024-04-04T13:10:20 | 2024-04-04T13:18:20 | blank | blank | blank | received | blank | Priya Patel | priya.patel@ | 312-555-6677 | 2254 W Adams St | Chicago | IL | 60612 |
| PA-20240006 | USA | 250 | Central Office | APP-1006 | Building | 2024-04-05T10:19:54 | 2024-04-05T11:02:25 | 2024-04-06T09:33:10 | 2024-04-17T16:27:07 | blank | approved | PO-007 | Jason Freeman | jason.freeman@ | 510-555-2323 | 802 Lakeview Blvd | Oakland | CA | 94610 |
| PA-20240007 | USA | 125 | Downtown Branch | APP-1007 | Event | 2024-04-05T14:30:41 | 2024-04-05T15:09:01 | 2024-04-06T08:50:10 | blank | 2024-04-12T13:00:00 | denied | PO-005 | Isabel Garcia | isabel.garcia@ | 786-555-1280 | 14 W Flagler St | Miami | FL | 33130 |
| PA-20240008 | USA | 90 | Central Office | APP-1008 | Signage | 2024-04-06T09:25:00 | 2024-04-06T09:40:13 | blank | blank | blank | received | blank | Henry Nguyen | henry.n@ | 206-555-8777 | 2213 5th Ave | Seattle | WA | 98121 |
| PA-20240009 | USA | 235 | West Office | APP-1009 | Building | 2024-04-07T12:31:44 | 2024-04-07T13:05:10 | 2024-04-08T09:00:00 | 2024-04-20T16:30:00 | blank | approved | PO-011 | David Lee | david.lee@ | 702-555-9911 | 101 Desert Rd | Las Vegas | NV | 89109 |
| PA-20240010 | USA | 280 | East Office | APP-1010 | Food Service | 2024-04-08T10:40:12 | 2024-04-08T11:12:34 | 2024-04-09T10:00:00 | blank | 2024-04-15T14:12:00 | denied | PO-014 | Linda Park | linda.park@ | 469-555-1100 | 3200 Elm St | Dallas | TX | 75226 |
| PA-20240011 | USA | 180 | Downtown Branch | APP-1011 | Event | 2024-04-08T13:12:10 | 2024-04-08T13:32:49 | 2024-04-09T09:50:00 | blank | blank | under_review | PO-006 | Kevin Smith | kevin.smith@ | 718-555-8888 | 45 Main St | Brooklyn | NY | 11201 |
| PA-20240012 | USA | 320 | North Branch | APP-1002 | Food Service | 2024-04-09T08:50:00 | 2024-04-09T09:10:15 | blank | blank | blank | received | blank | Markus Lin | markus.lin@ | +1-617-555-9922 | 32 Beacon St | Boston | MA | 02108 |
| PA-20240013 | USA | 100 | West Office | APP-1012 | Zoning | 2024-04-10T11:15:00 | 2024-04-10T12:00:00 | 2024-04-11T09:00:00 | 2024-04-18T13:15:00 | blank | approved | PO-012 | Fatima Rahman | fatima.rahman@ | 503-555-2121 | 4527 SW Taylor St | Portland | OR | 97205 |
| PA-20240014 | USA | 85 | Central Office | APP-1013 | Signage | 2024-04-10T15:00:00 | 2024-04-10T15:30:12 | blank | blank | blank | received | blank | Megan O'Neil | megan.oneil@ | 415-555-5556 | 2283 Union St | San Francisco | CA | 94123 |
| PA-20240015 | USA | 170 | Downtown Branch | APP-1014 | Event | 2024-04-11T09:23:49 | 2024-04-11T09:44:00 | 2024-04-11T10:30:00 | blank | blank | under_review | PO-006 | Rafael Torres | rafael.torres@ | 718-555-7766 | 1792 2nd Ave | New York | NY | 10128 |
| PA-20240016 | USA | 315 | North Branch | APP-1015 | Food Service | 2024-04-11T14:13:00 | 2024-04-11T14:19:00 | blank | blank | blank | received | blank | Valerie Cunningham | valerie.cunn@ | 503-555-4022 | 1905 NW Kearney St | Portland | OR | 97209 |
| PA-20240017 | USA | 230 | Central Office | APP-1016 | Building | 2024-04-12T08:16:00 | 2024-04-12T08:50:00 | 2024-04-13T09:00:00 | 2024-04-22T17:00:00 | blank | approved | PO-009 | William Zhang | william.zhang@ | 310-555-8899 | 488 Sunset Blvd | Los Angeles | CA | 90028 |
| PA-20240018 | USA | 70 | Downtown Branch | APP-1014 | Signage | 2024-04-12T14:10:00 | 2024-04-12T14:32:00 | blank | blank | blank | received | blank | Rafael Torres | rafael.torres@ | 718-555-7766 | 1792 2nd Ave | New York | NY | 10128 |
| PA-20240019 | USA | 95 | West Office | APP-1017 | Zoning | 2024-04-13T10:12:10 | 2024-04-13T10:33:00 | 2024-04-14T11:00:00 | blank | 2024-04-19T15:00:00 | denied | PO-012 | John McCarthy | john.mccarthy@ | 651-555-4822 | 14 Grand Ave | Saint Paul | MN | 55105 |
| PA-20240020 | USA | 300 | East Office | APP-1018 | Food Service | 2024-04-13T15:18:00 | 2024-04-13T15:55:00 | blank | blank | blank | received | blank | Emily Chen | emily.chen@ | 503-555-1900 | 3210 NE Alberta St | Portland | OR | 97211 |
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
Median 150.0, from 49.0 to 420.0.
- string 14
- float 1
- datetime 5
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
permit_application_id | string | Unique identifier for each permit applicationunique | PA-20240001 |
applicant_id | string | Unique identifier for the applicant (individual or organization) | APP-1001 |
permit_type | string | Type or category of permit being applied for11 types | Building |
current_status | string | Current status of the application (e.g., submitted, under_review, approved, denied, withdrawn)6 values | approved |
processing_office | string | Name or code of the government office processing the applicationoptional | Central Office |
processing_officer_id | string | Identifier for the officer responsible for processing the applicationoptional | PO-007 |
applicant_name | string | Full name of the applicantoptional | Olivia Johnson |
applicant_email | string | Email address of the applicantoptional | markus.lin@ |
applicant_phone | string | Phone number of the applicantoptional | +1-212-555-1023 |
applicant_address_street | string | Street address of the applicantoptional | 784 Upper Ave |
applicant_address_city | string | City of the applicant's addressoptional | New York |
applicant_address_state | string | State or province of the applicant's addressoptional | NY |
applicant_address_postal_code | string | Postal code of the applicant's addressoptional | 10009 |
applicant_address_country | string | Country of the applicant's address3 countries · optional | USA |
| Numbers 1 column | |||
application_fee_amount | float | Fee amount paid for the permit application0 or more · optional | 200 |
| Dates and times 5 columns | |||
application_submitted_datetime | datetime | Timestamp when the permit application was officially submitted | 2024-04-01T09:15:13 |
application_received_datetime | datetime | Timestamp when the application was received by the processing authorityoptional | 2024-04-01T10:01:35 |
application_review_start_datetime | datetime | Timestamp when the review process for the application beganoptional | 2024-04-02T09:33:10 |
application_approved_datetime | datetime | Timestamp when the application was approvedoptional | 2024-04-10T12:25:47 |
application_denied_datetime | datetime | Timestamp when the application was denied (if applicable)optional | 2024-04-07T15:44:33 |
Use it for
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.
- Permit applications85PA-20240001200USAPA-20240002150.5USAPA-2024000375USA
A software demo
Believable permit applications with applicant_
id, permit_ type and application_ submitted_ datetime to fill a screen in front of a buyer.
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.
- Record submission and approval date
- Calculate total processing days
- Flag applications exceeding standard time
- Categorize by permit type
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