Public Service Access Log
This dataset logs detailed records of citizen access to government online services, including access time, channel, location, device details, and outcome. It enables analysis of service usage patterns, identification of usability issues, and supports digital transformation initiatives by providing actionable insights into citizen interactions with public digital services.
Sample rows
preview · 8 of 150 rows · all 16 columns| access_log_idstring | access_channelstring | response_time_msinteger | successboolean | location_citystring | citizen_idstring | service_idstring | service_namestring | access_timestampdatetime | session_idstring | ip_addressstring | location_statestring | location_countrystring | error_codestring | referrer_urlstring | user_agentstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ALOG0001 | web | 348 | true | New York | CITIZEN_4A3B1C | SVC001 | Tax Filing | 2024-01-29T23:59:59Z | WEBSESS1A2B | 104.56.23.184 | NY | US | blank | https://portal.gov/home | Mozilla/5.0 (Windows NT 10.0; Win64; x64) |
| ALOG0002 | web | 601 | true | San Francisco | CITIZEN_9F2E1B | SVC003 | Voter Registration | 2024-01-30T00:01:43Z | WEBSESS7E5C | 172.31.56.201 | CA | US | blank | https://portal.gov/services | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) |
| ALOG0003 | web | 98 | false | Chicago | CITIZEN_B5D1FF | SVC002 | Passport Renewal | 2024-01-30T09:12:21Z | WEBSESS4D8F | 65.12.121.90 | IL | US | 401_AUTH | https://portal.gov/services | Mozilla/5.0 (Windows NT 10.0; Win64; x64) |
| ALOG0004 | web | 533 | true | Houston | CITIZEN_23E5A1 | SVC004 | Driver License Renewal | 2024-01-31T13:00:54Z | WEBSESS4D8F | 198.51.100.47 | TX | US | blank | https://portal.gov/dashboard | Mozilla/5.0 (Windows NT 10.0; rv:112.0) |
| ALOG0005 | web | 388 | true | Los Angeles | CITIZEN_D4E2C8 | SVC002 | Passport Renewal | 2024-01-31T14:59:00Z | WEBSESS7E5C | 203.0.113.11 | CA | US | blank | https://portal.gov/profile | Mozilla/5.0 (X11; Linux x86_64) |
| ALOG0006 | mobile | 1240 | true | Dallas | CITIZEN_7A1F8C | SVC005 | Healthcare Enrollment | 2024-02-01T17:22:19Z | MOBSESSA1B2 | 10.23.54.67 | TX | US | blank | https://appstore.com/govapp | Mozilla/5.0 (iPhone; CPU iPhone OS 16_1 like Mac OS X) |
| ALOG0007 | mobile | 3250 | false | Austin | CITIZEN_1B3D2A | SVC003 | Voter Registration | 2024-02-01T18:44:09Z | MOBSESS4A9C | 192.168.0.44 | TX | US | 408_TIMEOUT | https://mobile.portal.gov | Mozilla/5.0 (Linux; Android 12; SM-G991U) |
| ALOG0008 | mobile | 489 | true | Miami | CITIZEN_2A5F3D | SVC004 | Driver License Renewal | 2024-02-02T11:05:45Z | MOBSESSA1B2 | 172.16.254.3 | FL | US | blank | https://mobile.portal.gov | Mozilla/5.0 (iPhone; CPU iPhone OS 15_3 like Mac OS X) |
| ALOG0009 | mobile | 698 | true | Atlanta | CITIZEN_22B4E9 | SVC005 | Healthcare Enrollment | 2024-02-02T12:12:14Z | MOBSESS4A9C | 10.0.0.189 | GA | US | blank | https://appstore.com/govapp | Mozilla/5.0 (Android 13; Mobile; rv:112.0) |
| ALOG0010 | mobile | 2324 | false | Dallas | CITIZEN_7A1F8C | SVC005 | Healthcare Enrollment | 2024-02-02T22:59:58Z | MOBSESSA1B2 | 10.10.20.30 | TX | US | 503_UNAVAIL | https://mobile.portal.gov | Mozilla/5.0 (iPhone; CPU iPhone OS 16_1 like Mac OS X) |
| ALOG0011 | kiosk | 991 | true | Toronto | CITIZEN_5E0C1B | SVC008 | Business Registration | 2024-02-03T08:12:56Z | blank | 2001:0db8:85a3:0000:0000:8a2e:0370:7334 | ON | CA | blank | blank | Government Kiosk/1.3 |
| ALOG0012 | kiosk | 1108 | true | Toronto | CITIZEN_5E0C1B | SVC004 | Driver License Renewal | 2024-02-03T08:18:03Z | KIOSKSESS1A0B | 198.162.1.100 | ON | CA | blank | blank | Government Kiosk/1.2 |
| ALOG0013 | kiosk | 0 | false | Montreal | CITIZEN_6C1E2A | SVC008 | Business Registration | 2024-02-03T09:17:13Z | blank | unknown | QC | CA | 500_SYSERR | blank | Government Kiosk/1.3 |
| ALOG0014 | kiosk | 1201 | true | Vancouver | CITIZEN_5B3A4E | SVC004 | Driver License Renewal | 2024-02-03T10:55:22Z | KIOSKSESS4B8E | 192.168.56.1 | BC | CA | blank | blank | Government Kiosk/1.1 |
| ALOG0015 | kiosk | 509 | true | Montreal | CITIZEN_2A5F3D | SVC008 | Business Registration | 2024-02-03T11:33:39Z | blank | blank | QC | CA | blank | blank | Government Kiosk/1.1 |
| ALOG0016 | kiosk | 8000 | false | Vancouver | CITIZEN_5B3A4E | SVC004 | Driver License Renewal | 2024-02-03T13:50:49Z | blank | unknown | BC | CA | 403_FORBID | blank | Government Kiosk/1.0 |
| ALOG0017 | api | 98 | true | blank | CITIZEN_8D1F2C | SVC007 | Child Benefits | 2024-02-04T06:13:00Z | APISESS0031 | 2001:4860:4860::8888 | blank | blank | blank | blank | API-Client/3.2 |
| ALOG0018 | api | 388 | true | blank | CITIZEN_0D2A3B | SVC005 | Healthcare Enrollment | 2024-02-04T06:15:23Z | APISESS0098 | 192.0.2.33 | blank | blank | blank | blank | python-requests/2.31.0 |
| ALOG0019 | api | 8000 | false | blank | CITIZEN_8D1F2C | SVC009 | Pension Inquiry | 2024-02-04T07:27:41Z | APISESS0031 | blank | blank | blank | 504_GATEWAY | blank | bot/1.0 |
| ALOG0020 | api | 0 | false | blank | CITIZEN_1B3D2A | SVC007 | Child Benefits | 2024-02-04T08:13:50Z | blank | unknown | blank | blank | 401_AUTH | blank | API-Client/3.1 |
What the 150 rows show
from the 150-row sampleApi (access channel) stands out: mean response_
- 67%success = true
- 533median response_
time_ ms - 5location countries
- 8services
- 13referrer urls
- 15location states
Median 533, from 0 to 8,000.
- string 13
- integer 1
- datetime 1
- boolean 1
Columns
16 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
access_log_id | string | Unique identifier for each access log entryunique | ALOG0001 |
citizen_id | string | Anonymized unique identifier for the citizen accessing the service | CITIZEN_4A3B1C |
service_id | string | Unique identifier for the government online service accessed8 services | SVC001 |
service_name | string | Human-readable name of the government online service | Tax Filing |
access_channel | string | Channel used to access the service (e.g., web, mobile, kiosk)web · mobile · kiosk · api · other | web |
session_id | string | Unique identifier for the user's session during which the access occurredoptional | WEBSESS1A2B |
ip_address | string | IP address from which the service was accessedoptional | 104.56.23.184 |
user_agent | string | User agent string of the device/browser used for accessoptional | Government Kiosk/1.3 |
location_city | string | City from which the service was accessed (if available)optional | New York |
location_state | string | State or region from which the service was accessed (if available)optional | NY |
location_country | string | Country from which the service was accessed5 countries · optional | US |
error_code | string | Error code if the access attempt failed (blank if successful)optional | 401_AUTH |
referrer_url | string | URL of the page that referred the user to the service (if applicable)optional | https://portal.gov/home |
| Numbers 1 column | |||
response_time_ms | integer | Time taken (in milliseconds) to respond to the access request0 or more · optional | 348 |
| Dates and times 1 column | |||
access_timestamp | datetime | Date and time when the citizen accessed the service | 2024-01-29T23:59:59Z |
| True or false 1 column | |||
success | boolean | Indicates whether the access attempt was successful | true |
Use it for
A government dashboard
The success rate, response_
time_ ms by access_ channel and a breakdown of location_ city. Excel, Power BI or Tableau. Why do the 27 api rows have a mean response_
time_ ms of 2,465? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Access logs150ALOG0001348webALOG0002601webALOG000398web
A software demo
Believable access logs with citizen_
id, service_ id and service_ name to fill a screen in front of a buyer.
blueprint · public-service-access-log
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 16 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.
- Log session timestamp and service accessed
- Record user type (resident, business, visitor)
- Capture error or timeout events
- Flag high-frequency users
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
- public-service-access-log