# Profiles

In the stage database:

select left(i.identifier,3) as scheme, 
p.label as label, i.profile_id, 
count(*) as cnt  from ezidapp_identifier as i,
ezidapp_profile as p where p.id=i.profile_id 
group by scheme, i.profile_id;
+--------+------------+------------+----------+
| scheme | label      | profile_id | cnt      |
+--------+------------+------------+----------+
| ark    | erc        |          1 |  9197644 |
| ark    | dc         |          2 | 17837370 |
| ark    | datacite   |          3 |   223990 |
| ark    | ezid       |          4 |      310 |
| ark    | NIHdc      |          8 |       25 |
| ark    | ark        |          9 |    45010 |
| ark    | schema_org |         11 |        4 |
| doi    | erc        |          1 |        6 |
| doi    | dc         |          2 |    10059 |
| doi    | datacite   |          3 |   279883 |
| doi    | crossref   |          5 |    27608 |
+--------+------------+------------+----------+
11 rows in set (14 min 53.34 sec)

|Profile | id | pid |
| --- | --- | --- |
| erc | 1 | ark:/12345/fk1234 |
| erc | 1 | ark:/12345/fk1235 |
| erc | 1 | ark:/12345/fk3 |
| erc | 1 | ark:/12345/x98765 |
| erc | 1 | ark:/13030/c7000001q |
| erc | 1 | ark:/13030/kt7p301970 |
| erc | 1 | ark:/13030/kt7p30198h |
| erc | 1 | ark:/13030/kt7p301991 |
| erc | 1 | ark:/13030/kt7p3019bj |
| erc | 1 | ark:/13030/kt7p3019c2 |
| dc | 2 | ark:/13030/c74q7qp5f |
| dc | 2 | ark:/13030/c78g8fg9k |
| dc | 2 | ark:/13030/c7d79593b |
| dc | 2 | ark:/13030/c7j09w373 |
| dc | 2 | ark:/13030/c800007n |
| datacite | 3 | ark:/13030/c74t6f285 |
| datacite | 3 | ark:/13030/m5gh9jm0 |
| datacite | 3 | ark:/13030/m5m9099t |
| datacite | 3 | ark:/13030/m5qz2bmh |
| datacite | 3 | ark:/21547/AgS2 |
| ezid | 4 | ark:/99166/p9028pd50 |
| ezid | 4 | ark:/99166/p90c4sk0n |
| ezid | 4 | ark:/99166/p90r9m72r |
| ezid | 4 | ark:/99166/p90v89j36 |
| ezid | 4 | ark:/99166/p9183428t |
| NIHdc | 8 | ark:/13030/d3TestDC |
| NIHdc | 8 | ark:/13030/d38g6z |
| NIHdc | 8 | ark:/13030/d31012 |
| NIHdc | 8 | ark:/13030/d3rg69 |
| NIHdc | 8 | ark:/13030/d3h01d |
| ark | 9 | ark:/57799/b9WQUPBtEIfETY |
| ark | 9 | ark:/57799/b99q2oRptzqyJz |
| ark | 9 | ark:/57799/b9hVMaxpmqx733 |
| ark | 9 | ark:/57799/b916O35c6UL2jdX |
| ark | 9 | ark:/57799/b91DmyafMOveE9N |
| schema_org | 11 | ark:/13030/d3730k |
| schema_org | 11 | ark:/13030/d3zk5t |
| schema_org | 11 | ark:/13030/d3q30x |
| schema_org | 11 | ark:/13030/d3xk5h |

|Profile | id | pid |
| --- | --- | --- |
| erc | 1 | doi:10.5060/D2D798B9 |
| erc | 1 | doi:10.5060/D2J1012K |
| erc | 1 | doi:10.5060/D2NP22C8 |
| erc | 1 | doi:10.5060/D2SF2T3M |
| erc | 1 | doi:10.5060/D2X63JTX |
| dc | 2 | doi:10.15779/J2001R |
| dc | 2 | doi:10.15779/J2059H |
| dc | 2 | doi:10.15779/J20C7T |
| dc | 2 | doi:10.15779/J20K54 |
| dc | 2 | doi:10.15779/J20P4S |
| datacite | 3 | doi:10.11572/P24W2F |
| datacite | 3 | doi:10.13022/M3001R |
| datacite | 3 | doi:10.13022/M3059H |
| datacite | 3 | doi:10.13022/M30K54 |
| datacite | 3 | doi:10.13022/M30K9N |
| crossref | 5 | doi:10.5070/P2001D |
| crossref | 5 | doi:10.5070/P2002S |
| crossref | 5 | doi:10.5070/P20302 |
| crossref | 5 | doi:10.5070/P20595 |
| crossref | 5 | doi:10.5070/P2088T |