Skip to content

Instantly share code, notes, and snippets.

@filipac

filipac/Ceac Updates week #25

Last active June 20, 2025 18:25
Show Gist options
  • Save filipac/6882d5f6595524bc373c62db68ad781a to your computer and use it in GitHub Desktop.
Save filipac/6882d5f6595524bc373c62db68ad781a to your computer and use it in GitHub Desktop.
Download ZIP
Ceac Updates week #25
Raw
Ceac Updates week #25
2NLs since 2025-06-15 (Generated 2025-06-20 18:25:32.447441 UTC)
+---------+-----+-----+-----+----+----+-----+
| Con | AF | AS | EU | OC | SA | == |
+---------+-----+-----+-----+----+----+-----+
| ACC | 1 | 0 | 0 | 0 | 0 | 1 |
| ATA | 0 | 0 | 28 | 0 | 0 | 28 |
| BGN | 0 | 0 | 0 | 0 | 1 | 1 |
| BLG | 0 | 0 | 13 | 0 | 0 | 13 |
| BNK | 0 | 0 | 1 | 0 | 0 | 1 |
| CDJ | 0 | 0 | 1 | 0 | 0 | 1 |
| DRS | 8 | 0 | 0 | 0 | 0 | 8 |
| JAK | 0 | 4 | 1 | 0 | 0 | 5 |
| KEV | 0 | 0 | 15 | 0 | 0 | 15 |
| MDD | 2 | 1 | 6 | 0 | 0 | 9 |
| PRG | 0 | 0 | 1 | 0 | 0 | 1 |
| RID | 0 | 15 | 0 | 0 | 0 | 15 |
| RNG | 0 | 58 | 0 | 0 | 0 | 58 |
| SEO | 0 | 2 | 4 | 0 | 0 | 6 |
| SGP | 0 | 3 | 0 | 0 | 0 | 3 |
| SNJ | 0 | 0 | 0 | 0 | 1 | 1 |
| SOF | 0 | 0 | 7 | 0 | 0 | 7 |
| SUV | 0 | 0 | 0 | 9 | 0 | 9 |
| SYD | 0 | 3 | 0 | 8 | 0 | 11 |
| TAI | 0 | 4 | 0 | 0 | 0 | 4 |
| TBL | 0 | 2 | 87 | 0 | 0 | 89 |
| THT | 0 | 0 | 70 | 0 | 0 | 70 |
| TIA | 0 | 0 | 44 | 0 | 0 | 44 |
| TKY | 0 | 3 | 2 | 0 | 0 | 5 |
| TNS | 31 | 0 | 0 | 0 | 0 | 31 |
| ULN | 0 | 3 | 1 | 0 | 0 | 4 |
| VNN | 0 | 2 | 31 | 0 | 0 | 33 |
| WRW | 0 | 1 | 107 | 0 | 0 | 108 |
| YDE | 138 | 0 | 1 | 0 | 0 | 139 |
| YRV | 0 | 29 | 0 | 0 | 0 | 29 |
| - | - | - | - | - | - | - |
| Transit | 81 | 12 | 14 | 1 | 1 | 109 |
| - | - | - | - | - | - | - |
| Total | 261 | 142 | 434 | 18 | 3 | 858 |
+---------+-----+-----+-----+----+----+-----+
Grand Total: 858
To see last week's data, visit https://gist.github.com/filipac
Statistics since 2025-06-14
(Generated 06/20/2025, 18:25:33 UTC)
Status transitions
+------------------------+-------+-----+-----+-----+----+----+
| Transition | Count | AF | AS | EU | OC | SA |
+------------------------+-------+-----+-----+-----+----+----+
| NVC -> Ready | 749 | 180 | 130 | 420 | 17 | 2 |
| InTransit -> Ready | 706 | 143 | 436 | 106 | 0 | 21 |
| Ready -> Issued | 149 | 59 | 24 | 64 | 0 | 2 |
| AP -> Issued | 113 | 76 | 24 | 12 | 1 | 0 |
| NVC -> InTransit | 109 | 81 | 12 | 14 | 1 | 1 |
| Ready -> AP | 108 | 84 | 9 | 14 | 1 | 0 |
| Ready -> Refused | 55 | 34 | 18 | 3 | 0 | 0 |
| Ready -> Refused221g | 46 | 21 | 6 | 19 | 0 | 0 |
| Refused221g -> Issued | 38 | 30 | 1 | 6 | 1 | 0 |
| Refused221g -> AP | 24 | 22 | 1 | 1 | 0 | 0 |
| Refused221g -> Refused | 14 | 6 | 6 | 1 | 1 | 0 |
| Refused221g -> Ready | 7 | 4 | 1 | 0 | 1 | 1 |
| Ready -> Transfer | 4 | 2 | 2 | 0 | 0 | 0 |
| Transfer -> Ready | 3 | 3 | 0 | 0 | 0 | 0 |
| Refused -> Refused221g | 2 | 2 | 0 | 0 | 0 | 0 |
| Issued -> Ready | 2 | 0 | 0 | 2 | 0 | 0 |
| Issued -> Transfer | 1 | 1 | 0 | 0 | 0 | 0 |
| AP -> Ready | 1 | 1 | 0 | 0 | 0 | 0 |
| Refused -> Ready | 1 | 1 | 0 | 0 | 0 | 0 |
| Refused -> AP | 1 | 1 | 0 | 0 | 0 | 0 |
| AP -> Refused | 1 | 1 | 0 | 0 | 0 | 0 |
| Issued -> Refused | 1 | 1 | 0 | 0 | 0 | 0 |
| Issued -> AP | 1 | 0 | 0 | 1 | 0 | 0 |
+------------------------+-------+-----+-----+-----+----+----+
Consulate transitions
+------------+-------+-----+-----+-----+----+----+
| Transition | Count | AF | AS | EU | OC | SA |
+------------+-------+-----+-----+-----+----+----+
| NVC -> KDU | 300 | 0 | 300 | 0 | 0 | 0 |
| NVC -> YDE | 139 | 138 | 0 | 1 | 0 | 0 |
| NVC -> WRW | 108 | 0 | 1 | 107 | 0 | 0 |
| NVC -> TBL | 89 | 0 | 2 | 87 | 0 | 0 |
| NVC -> THT | 70 | 0 | 0 | 70 | 0 | 0 |
| NVC -> ABD | 66 | 6 | 60 | 0 | 0 | 0 |
| NVC -> DHB | 60 | 0 | 0 | 60 | 0 | 0 |
| NVC -> RNG | 58 | 0 | 58 | 0 | 0 | 0 |
| NVC -> RID | 51 | 27 | 24 | 0 | 0 | 0 |
| NVC -> DKR | 50 | 50 | 0 | 0 | 0 | 0 |
| NVC -> TIA | 44 | 0 | 0 | 44 | 0 | 0 |
| NVC -> ISL | 38 | 0 | 38 | 0 | 0 | 0 |
| NVC -> VNN | 33 | 0 | 2 | 31 | 0 | 0 |
| NVC -> LUA | 32 | 32 | 0 | 0 | 0 | 0 |
| NVC -> TNS | 31 | 31 | 0 | 0 | 0 | 0 |
| NVC -> YRV | 29 | 0 | 29 | 0 | 0 | 0 |
| NVC -> ATA | 28 | 0 | 0 | 28 | 0 | 0 |
| NVC -> BMB | 27 | 9 | 10 | 8 | 0 | 0 |
| NVC -> HNK | 20 | 0 | 0 | 20 | 0 | 0 |
| NVC -> MST | 16 | 0 | 16 | 0 | 0 | 0 |
| NVC -> KEV | 15 | 0 | 0 | 15 | 0 | 0 |
| NVC -> BLG | 13 | 0 | 0 | 13 | 0 | 0 |
| NVC -> SYD | 11 | 0 | 3 | 0 | 8 | 0 |
| NVC -> LMA | 11 | 0 | 0 | 0 | 0 | 11 |
| NVC -> NPL | 10 | 2 | 1 | 7 | 0 | 0 |
| NVC -> MDD | 9 | 2 | 1 | 6 | 0 | 0 |
| NVC -> SUV | 9 | 0 | 0 | 0 | 9 | 0 |
| NVC -> DRS | 8 | 8 | 0 | 0 | 0 | 0 |
| NVC -> OUG | 8 | 8 | 0 | 0 | 0 | 0 |
| NVC -> SOF | 7 | 0 | 0 | 7 | 0 | 0 |
| NVC -> GYQ | 7 | 0 | 0 | 0 | 0 | 7 |
| NVC -> SEO | 6 | 0 | 2 | 4 | 0 | 0 |
| NVC -> GUZ | 5 | 3 | 1 | 1 | 0 | 0 |
| NVC -> JAK | 5 | 0 | 4 | 1 | 0 | 0 |
| NVC -> TKY | 5 | 0 | 3 | 2 | 0 | 0 |
| NVC -> HRE | 4 | 4 | 0 | 0 | 0 | 0 |
| NVC -> KLL | 4 | 0 | 1 | 3 | 0 | 0 |
| NVC -> ULN | 4 | 0 | 3 | 1 | 0 | 0 |
| NVC -> TAI | 4 | 0 | 4 | 0 | 0 | 0 |
| NVC -> PRI | 4 | 0 | 0 | 4 | 0 | 0 |
| NVC -> SGP | 3 | 0 | 3 | 0 | 0 | 0 |
| NVC -> BNS | 3 | 0 | 0 | 1 | 0 | 2 |
| KIN -> YDE | 2 | 2 | 0 | 0 | 0 | 0 |
| NVC -> MNL | 2 | 1 | 0 | 1 | 0 | 0 |
| CRO -> BGH | 1 | 1 | 0 | 0 | 0 | 0 |
| MNL -> ISL | 1 | 1 | 0 | 0 | 0 | 0 |
| MST -> DOH | 1 | 1 | 0 | 0 | 0 | 0 |
| NVC -> ACC | 1 | 1 | 0 | 0 | 0 | 0 |
| NVC -> LIB | 1 | 1 | 0 | 0 | 0 | 0 |
| BNK -> BKK | 1 | 0 | 1 | 0 | 0 | 0 |
| NVC -> BNK | 1 | 0 | 0 | 1 | 0 | 0 |
| WRW -> BKK | 1 | 0 | 0 | 1 | 0 | 0 |
| NVC -> CDJ | 1 | 0 | 0 | 1 | 0 | 0 |
| NVC -> PRG | 1 | 0 | 0 | 1 | 0 | 0 |
| NVC -> RDJ | 1 | 0 | 0 | 1 | 0 | 0 |
| NVC -> SNJ | 1 | 0 | 0 | 0 | 0 | 1 |
| NVC -> PTS | 1 | 0 | 0 | 0 | 0 | 1 |
| NVC -> BGN | 1 | 0 | 0 | 0 | 0 | 1 |
+------------+-------+-----+-----+-----+----+----+
Status change activity
+-------------+-------------+-----------+------------+------------+---------+---------+----------+
| Status | Count | AF | AS | EU | OC | SA | Winner:) |
+-------------+-------------+-----------+------------+------------+---------+---------+----------+
| Issued | 607 (300) | 305 (165) | 90 (49) | 207 (82) | 3 (2) | 2 (2) | AF |
| Refused | 116 (71) | 59 (42) | 42 (24) | 8 (4) | 7 (1) | 0 (0) | AF |
| Ready | 3059 (1469) | 639 (332) | 1122 (567) | 1209 (528) | 46 (18) | 43 (24) | EU |
| Intransit | 109 (109) | 81 (81) | 12 (12) | 14 (14) | 1 (1) | 1 (1) | AF |
| Ap | 236 (134) | 178 (107) | 21 (10) | 36 (16) | 1 (1) | 0 (0) | AF |
| Refused221g | 83 (48) | 33 (23) | 12 (6) | 38 (19) | 0 (0) | 0 (0) | EU |
| Returned | 0 (0) | 0 (0) | 0 (0) | 0 (0) | 0 (0) | 0 (0) | None |
+-------------+-------------+-----------+------------+------------+---------+---------+----------+
Consulate accepted cases
+-----------+-------+---------+
| Consulate | Count | Persons |
+-----------+-------+---------+
| KDU | 300 | 576 |
| YDE | 139 | 242 |
| WRW | 108 | 257 |
| TBL | 89 | 195 |
| THT | 70 | 186 |
| ABD | 66 | 124 |
| DHB | 60 | 175 |
| RNG | 58 | 118 |
| RID | 51 | 123 |
| DKR | 50 | 98 |
| TIA | 44 | 86 |
| ISL | 38 | 75 |
| VNN | 33 | 63 |
| LUA | 32 | 99 |
| TNS | 31 | 39 |
| YRV | 29 | 55 |
| ATA | 28 | 63 |
| BMB | 27 | 49 |
| HNK | 20 | 34 |
| MST | 16 | 41 |
| KEV | 15 | 39 |
| BLG | 13 | 21 |
| SYD | 11 | 20 |
| LMA | 11 | 18 |
| NPL | 10 | 16 |
| MDD | 9 | 15 |
| SUV | 9 | 30 |
| DRS | 8 | 17 |
| OUG | 8 | 8 |
| SOF | 7 | 12 |
| GYQ | 7 | 13 |
| SEO | 6 | 12 |
| GUZ | 5 | 6 |
| JAK | 5 | 9 |
| TKY | 5 | 10 |
| HRE | 4 | 11 |
| KLL | 4 | 11 |
| ULN | 4 | 8 |
| TAI | 4 | 8 |
| PRI | 4 | 13 |
| SGP | 3 | 7 |
| BNS | 3 | 8 |
| MNL | 2 | 2 |
| ACC | 1 | 4 |
| LIB | 1 | 2 |
| BNK | 1 | 1 |
| CDJ | 1 | 2 |
| PRG | 1 | 2 |
| RDJ | 1 | 1 |
| SNJ | 1 | 2 |
| PTS | 1 | 2 |
| BGN | 1 | 1 |
+-----------+-------+---------+
Overall global summary (where Case is no longer at NVC) - as seen on https://dvcharts.xarthisius.xyz/ceacFY25.html
* to keep things consistent with dvcharts.xarthisius.xyz, numbers in the table correspond to the number of actual people/visas. Number of cases are given in () which is actually the opposite of the above.
+--------+---------------+-----------+-------------+-------------+--------------+-----------+---------------+
| Region | Issued | AP | 221g | Refused | Ready | Transit | Totals |
+--------+---------------+-----------+-------------+-------------+--------------+-----------+---------------+
| AF | 13678 (7530) | 213 (122) | 1494 (771) | 2045 (923) | 7560 (3558) | N/A (208) | 24990 (13112) |
| AS | 4546 (2436) | 21 (10) | 1142 (455) | 554 (257) | 3268 (1619) | N/A (64) | 9531 (4841) |
| EU | 11882 (4956) | 36 (16) | 629 (211) | 612 (207) | 5247 (2119) | N/A (91) | 18406 (7600) |
| OC | 635 (311) | 1 (1) | 53 (25) | 147 (66) | 262 (116) | N/A (2) | 1098 (521) |
| SA | 1225 (594) | 0 (0) | 50 (22) | 228 (90) | 393 (170) | N/A (3) | 1896 (879) |
| Totals | 31969 (15830) | 271 (149) | 3368 (1484) | 3586 (1543) | 16730 (7582) | N/A (368) | 55924 (26956) |
+--------+---------------+-----------+-------------+-------------+--------------+-----------+---------------+
Quota usage
+--------+-------+--------+------------+
| Region | Quota | Issued | Percentage |
+--------+-------+--------+------------+
| AF | 23610 | 13678 | 57.9% |
| AS | 8245 | 4546 | 55.1% |
| EU | 17872 | 11882 | 66.5% |
| OC | 849 | 635 | 74.8% |
| SA | 1416 | 1225 | 86.5% |
| NA | 8 | 3 | 37.5% |
| Global | 52000 | 31969 | 61.5% |
+--------+-------+--------+------------+
Quota usage (including AP cases)
Considering that 99.9% of all AP cases will transition to Issued, we can calculate the quota usage as if all AP cases were issued.
+--------+-------+--------+-----+-----------------+------------+
| Region | Quota | Issued | AP | Assuming issued | Percentage |
+--------+-------+--------+-----+-----------------+------------+
| AF | 23610 | 13678 | 213 | 13891 | 58.8% |
| AS | 8245 | 4546 | 21 | 4567 | 55.4% |
| EU | 17872 | 11882 | 36 | 11918 | 66.7% |
| OC | 849 | 635 | 1 | 636 | 74.9% |
| SA | 1416 | 1225 | 0 | 1225 | 86.5% |
| NA | 8 | 3 | 0 | 3 | 37.5% |
| Global | 52000 | 31969 | 271 | 32240 | 62.0% |
+--------+-------+--------+-----+-----------------+------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment