There are 100 certified public accountants in this database. Each accountant record is comprised of firm, city, state, country, category, registration status location, headquarters address, other name used in issuing audit report, registration date, disciplinary proceeding and insection report. In the certified public accountants database, there are other 3 important tables related with these accountants, they are 483 annual and special reporting records with title, filed date and special report relates to in each, 89 auditor reporting records with form, filed date, issuer name, audit report date & engagement partner in each and registration table with 21 records.
There are 7 tables in this whole certified public accountants database.
| Name | n3_chennan_accountant_pcaobus_org |
|---|---|
| Data | 704K (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 41 (+ 0) |
| Table Rows | 1,683 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| annual_and_special_reporting | 483 | title |
100%
|
| filed_date |
100%
|
||
| special_report_relates_to |
20.7%
|
||
| auditor_reporting | 89 | form |
100%
|
| filed_date |
100%
|
||
| issuer_name |
100%
|
||
| audit_report_date |
100%
|
||
| engagement_partner |
100%
|
||
| certified_public_accountant | 100 | firm |
100%
|
| city |
100%
|
||
| state |
93%
|
||
| country |
100%
|
||
| category |
100%
|
||
| registration_status |
100%
|
||
| headquarters_address |
100%
|
||
| other_name_used_in_issuing_audit_report |
100%
|
||
| registration_date |
100%
|
||
| disciplinary_proceeding |
100%
|
||
| insection_report |
100%
|
||
| certified_public_accountant_x_annual_and_special_reporting | 781 | certified_public_accountant_id |
100%
|
| annual_and_special_reporting_id |
100%
|
||
| certified_public_accountant_x_auditor_reporting | 89 | certified_public_accountant_id |
100%
|
| auditor_reporting_id |
100%
|
||
| certified_public_accountant_x_registration | 120 | certified_public_accountant_id |
100%
|
| registration_id |
100%
|
||
| registration | 21 | value |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
