Business License Application Trends
This dataset provides detailed records of new business license applications, including applicant and business details, application status, processing times, and regulatory agency information. It enables analysis of entrepreneurial activity, regulatory efficiency, and geographic trends in business formation, making it valuable for policymakers, researchers, and economic development professionals.
Sample rows
preview · 8 of 70 rows · all 20 columns| application_idstring | statusstring | application_feefloat | industry_sectorstring | business_namestring | business_typestring | application_datedate | approval_datedate | processing_time_daysinteger | business_owner_namestring | owner_contact_emailstring | business_phonestring | business_address_streetstring | business_address_citystring | business_address_statestring | business_address_postal_codestring | business_address_countrystring | number_of_employeesinteger | regulatory_agencystring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APP-20240101-0001 | approved | 110 | Food Services | Sunrise Bakery | bakery | 2024-01-05 | 2024-01-12 | 7 | Maria Alvarez | maria.alvarez@ | 415-555-1023 | 123 Market St | San Francisco | CA | 94103 | USA | 8 | San Francisco Business Licensing Dept | New location in SoMa |
| APP-20240101-0002 | pending | 185.5 | Recreation | Peak Fitness Center | gym | 2024-01-07 | blank | blank | James Carter | jcarter@ | 206-555-7812 | 400 Pine St | Seattle | WA | 98101 | USA | 15 | Seattle Business Permits | blank |
| APP-20240101-0003 | approved | 160 | Professional Services | Windsor Consulting | consulting | 2024-01-09 | 2024-01-15 | 6 | Helen Windsor | helen@ | 212-555-3939 | 88 Lexington Ave | New York | NY | 10010 | USA | 3 | NYC Dept of Consumer Affairs | Consulting in tech startups |
| APP-20240101-0004 | pending | 85 | Retail | GreenLeaf Florists | florist | 2024-01-10 | blank | blank | Ava Patel | ava.patel@ | 415-555-4521 | 2024 18th Ave | San Francisco | CA | 94116 | USA | 5 | San Francisco Business Licensing Dept | blank |
| APP-20240101-0005 | approved | 200 | Education | Bright Minds Daycare | childcare | 2024-01-12 | 2024-01-25 | 13 | Linda Nguyen | linda.nguyen@ | 312-555-6721 | 157 E Randolph St | Chicago | IL | 60601 | USA | 10 | Chicago Dept of Family Services | Background checks required |
| APP-20240101-0006 | pending | 180 | Food Services | Urban Eats | restaurant | 2024-01-13 | blank | blank | Carlos Ramirez | c.ramirez@ | 702-555-1133 | 501 Fremont St | Las Vegas | NV | 89101 | USA | 22 | Las Vegas Business Licensing | blank |
| APP-20240101-0007 | approved | 210.75 | IT & Software | TechNest Startups | technology | 2024-01-14 | 2024-01-21 | 7 | Brian Lee | b.lee@ | 650-555-2020 | 777 Hamilton Ave | Palo Alto | CA | 94301 | USA | 16 | Santa Clara County Business Office | Seed-stage company |
| APP-20240101-0008 | approved | 120 | Retail | Healthy Habits Market | grocery | 2024-01-15 | 2024-01-20 | 5 | Dennis Kim | denniskim@ | 415-555-9090 | 3500 California St | San Francisco | CA | 94118 | USA | 14 | San Francisco Business Licensing Dept | blank |
| APP-20240101-0009 | pending | 70 | Home & Garden | Go Green Landscaping | landscaping | 2024-01-17 | blank | blank | Eric Johnson | eric.johnson@ | 503-555-4455 | 1295 NE Broadway | Portland | OR | 97232 | USA | 6 | Portland Bureau of Development Services | blank |
| APP-20240101-0010 | approved | 250 | Financial Services | Silver Lining Insurance | insurance | 2024-01-18 | 2024-01-27 | 9 | Patricia Lopez | patricia.lopez@ | 212-555-3278 | 145 5th Ave | New York | NY | 10010 | USA | 20 | NYC Insurance Licensing | Commercial policies focus |
| APP-20240101-0011 | pending | 95 | Food Services | Quick Byte Café | cafe | 2024-01-19 | blank | blank | Jorge Martinez | jorge@ | 415-555-1231 | 500 Howard St | San Francisco | CA | 94105 | USA | 7 | San Francisco Business Licensing Dept | blank |
| APP-20240101-0012 | approved | 88.5 | Services | Eco Fresh Cleaners | dry cleaning | 2024-01-20 | 2024-01-26 | 6 | Amelia Chen | amelia.chen@ | 213-555-6028 | 930 S Hill St | Los Angeles | CA | 90015 | USA | 4 | LA City Business Licensing | blank |
| APP-20240101-0013 | pending | 170 | IT & Software | DigiSolutions IT | technology | 2024-01-21 | blank | blank | Rajesh Iyer | r.iyer@ | 408-555-2233 | 4000 Stevens Creek Blvd | San Jose | CA | 95129 | USA | 11 | Santa Clara County Business Office | blank |
| APP-20240101-0014 | approved | 210 | Food Services | Harbor Brew Pub | brewery | 2024-01-22 | 2024-02-04 | 13 | Megan O'Reilly | megan@ | 617-555-9988 | 17 Atlantic Ave | Boston | MA | 02110 | USA | 18 | Boston Licensing Board | Microbrewery license |
| APP-20240101-0015 | approved | 105.25 | Services | Parkside Pet Care | pet care | 2024-01-24 | 2024-01-28 | 4 | Samantha Brown | samantha@ | 303-555-4107 | 4900 York St | Denver | CO | 80216 | USA | 6 | Denver Animal Services | blank |
| APP-20240101-0016 | pending | 175 | Transportation | Citywide Car Rentals | car rental | 2024-01-25 | blank | blank | Leonard King | leonard.king@ | 702-555-8844 | 2200 Tropicana Ave | Las Vegas | NV | 89119 | USA | 14 | Las Vegas Business Licensing | blank |
| APP-20240101-0017 | pending | 60 | Retail | Maple Bookstore | bookstore | 2024-01-27 | blank | blank | Olivia Turner | olivia.turner@ | 215-555-3411 | 142 Walnut St | Philadelphia | PA | 19106 | USA | 4 | Philadelphia Business Licensing | blank |
| APP-20240101-0018 | approved | 195 | Education | Sunny Days Childcare | childcare | 2024-01-28 | 2024-02-10 | 13 | Rebecca Lee | rebecca.lee@ | 206-555-2345 | 8100 35th Ave NE | Seattle | WA | 98115 | USA | 12 | Seattle Dept of Education | Nutritional programs included |
| APP-20240101-0019 | approved | 72 | Services | Northside Print Shop | printing | 2024-01-29 | 2024-02-04 | 6 | Anthony Scott | a.scott@ | 312-555-4592 | 6500 N Clark St | Chicago | IL | 60626 | USA | 8 | Chicago Business Affairs & Consumer Protection | blank |
| APP-20240101-0020 | pending | 90 | Personal Care | Modern Hair Studio | salon | 2024-01-30 | blank | blank | Sophie Kim | sophie.kim@ | 617-555-2023 | 28 Charles St | Boston | MA | 02114 | USA | 9 | Boston Licensing Board | blank |
What the 70 rows show
from the 70-row sample- 122.8median application_
fee - 14business address states
- 19business address cities
- 8median processing_
time_ days - 8.5median number_
of_ employees
Median 122.8, from 60.0 to 300.0.
- string 15
- integer 2
- float 1
- date 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
application_id | string | Unique identifier for each business license applicationunique | APP-20240101-0001 |
business_name | string | Registered name of the business applying for the license | Sunrise Bakery |
business_type | string | Type or category of business (e.g., restaurant, retail, consulting) | bakery |
industry_sector | string | Industry sector classification for the business (e.g., Food Services, Retail, Professional Services)optional | Food Services |
status | string | Current status of the application (e.g., pending, approved, rejected, withdrawn)pending · approved · rejected · withdrawn | approved |
business_owner_name | string | Full name of the primary business owner or applicant | Maria Alvarez |
owner_contact_email | string | Contact email address of the business owner or applicantoptional | jcarter@ |
business_phone | string | Primary phone number for the businessoptional | 415-555-1023 |
business_address_street | string | Street address of the business location | 123 Market St |
business_address_city | string | City where the business is located | San Francisco |
business_address_state | string | State or province where the business is located | CA |
business_address_postal_code | string | Postal or ZIP code of the business location | 94103 |
business_address_country | string | Country where the business is located | USA |
regulatory_agency | string | Name of the agency or department processing the applicationoptional | Seattle Business Permits |
notes | string | Additional notes or comments related to the applicationoptional | New location in SoMa |
| Numbers 3 columns | |||
processing_time_days | integer | Number of days taken to process the application (approval_date - application_date)0 or more · optional | 7 |
number_of_employees | integer | Number of employees at the time of application0 or more · optional | 8 |
application_fee | float | Fee paid for the business license application0 or more · optional | 110 |
| Dates and times 2 columns | |||
application_date | date | Date the business license application was submitted | 2024-01-05 |
approval_date | date | Date the business license application was approved (if applicable)optional | 2024-01-12 |
Use it for
A government dashboard
Application_
fee by status and a breakdown of industry_ sector. Excel, Power BI or Tableau. What pattern can you find in 70 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 70 rows.
- Applications70APP-20240101-0001110approvedAPP-20240101-0002185.5pendingAPP-20240101-0003160approved
A software demo
Believable applications with business_
name, business_ type and industry_ sector to fill a screen in front of a buyer.
blueprint · business-license-application-trends
Behind this dataset
Same schema. As many rows as you need.
These 70 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.
- Include application date and business type
- Track status (approved, pending, rejected)
- Calculate average approval time
- Aggregate by business category
- Highlight applications pending >60 days
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
- business-license-application-trends