Skip to content

Instantly share code, notes, and snippets.

@filipac
Last active January 12, 2025 17:31
Show Gist options
  • Select an option

  • Save filipac/947d28cdc08d433bbd2686f7f5f27ccd to your computer and use it in GitHub Desktop.

Select an option

Save filipac/947d28cdc08d433bbd2686f7f5f27ccd to your computer and use it in GitHub Desktop.
Ceac Updates week #2
Statistics since 2025-01-03 [latest https://dvcharts.xarthisius.xyz data publish]
(Generated 2025-01-12 16:31:33.513209 UTC)
Status transitions
+-------------------------+-------+----+----+-----+----+----+
| Transition | Count | AF | AS | EU | OC | SA |
+-------------------------+-------+----+----+-----+----+----+
| Ready -> Issued | 300 | 51 | 90 | 118 | 9 | 32 |
| Ready -> AP | 262 | 84 | 83 | 70 | 7 | 18 |
| Ready -> Refused221g | 200 | 52 | 62 | 71 | 9 | 6 |
| AP -> Issued | 91 | 78 | 1 | 11 | 0 | 1 |
| Ready -> Refused | 50 | 21 | 16 | 7 | 4 | 2 |
| Refused221g -> Issued | 32 | 10 | 2 | 16 | 3 | 1 |
| Refused221g -> AP | 22 | 9 | 1 | 10 | 1 | 1 |
| Refused221g -> Ready | 8 | 4 | 0 | 4 | 0 | 0 |
| Refused221g -> Refused | 4 | 3 | 1 | 0 | 0 | 0 |
| Ready -> Transfer | 4 | 1 | 0 | 3 | 0 | 0 |
| Issued -> Ready | 3 | 3 | 0 | 0 | 0 | 0 |
| InTransit -> Ready | 3 | 0 | 0 | 3 | 0 | 0 |
| AP -> Ready | 2 | 1 | 0 | 0 | 0 | 1 |
| Transfer -> Ready | 2 | 0 | 0 | 2 | 0 | 0 |
| Issued -> Refused | 1 | 1 | 0 | 0 | 0 | 0 |
| Transfer -> Refused221g | 1 | 1 | 0 | 0 | 0 | 0 |
| NVC -> Ready | 1 | 0 | 0 | 1 | 0 | 0 |
| Issued -> AP | 1 | 0 | 0 | 0 | 0 | 1 |
+-------------------------+-------+----+----+-----+----+----+
Consulate transitions
+------------+-------+----+----+----+----+----+
| Transition | Count | AF | AS | EU | OC | SA |
+------------+-------+----+----+----+----+----+
| NVC -> HNK | 2 | 0 | 0 | 2 | 0 | 0 |
| WRW -> BKK | 2 | 0 | 0 | 2 | 0 | 0 |
| YDE -> ABD | 1 | 1 | 0 | 0 | 0 | 0 |
| CSB -> TNS | 1 | 1 | 0 | 0 | 0 | 0 |
| NVC -> VNN | 1 | 0 | 0 | 1 | 0 | 0 |
| NPL -> KEV | 1 | 0 | 0 | 1 | 0 | 0 |
| WRW -> ATA | 1 | 0 | 0 | 1 | 0 | 0 |
| NVC -> SOF | 1 | 0 | 0 | 1 | 0 | 0 |
| SNT -> MDD | 1 | 0 | 0 | 0 | 0 | 1 |
+------------+-------+----+----+----+----+----+
Region with most status transitions: AF (319)
Region with most consulate transitions: EU (8)
Status change activity
+-------------+-----------+-----------+----------+-----------+---------+---------+----------+
| Status | Count | AF | AS | EU | OC | SA | Winner:) |
+-------------+-----------+-----------+----------+-----------+---------+---------+----------+
| Issued | 423 (835) | 139 (242) | 93 (167) | 145 (330) | 12 (26) | 34 (70) | EU |
| Refused | 55 (71) | 25 (31) | 17 (20) | 7 (7) | 4 (6) | 2 (7) | AF |
| Ready | 19 (46) | 8 (18) | 0 (0) | 10 (25) | 0 (0) | 1 (3) | EU |
| InTransit | 0 (0) | 0 | 0 | 0 | 0 | 0 | None |
| AP | 285 (583) | 93 | 84 | 80 | 8 | 20 | AF |
| Refused221g | 201 (303) | 53 | 62 | 71 | 9 | 6 | EU |
| Returned | 0 (0) | 0 | 0 | 0 | 0 | 0 | None |
+-------------+-----------+-----------+----------+-----------+---------+---------+----------+
Case numbers outside (parenthesis), number of persons in (parenthesis).
Consulate accepted cases
+------------------------+-------+
| Consulate | Count |
+------------------------+-------+
| HNK (Hong Kong, China) | 2 |
| VNN (Vienna, Austria) | 1 |
| SOF (Sofia, Bulgaria) | 1 |
+------------------------+-------+
2NLs since 2025-01-04 [latest https://dvcharts.xarthisius.xyz data publish] (Generated 2025-01-12 16:30:43.964318 UTC)
+---------+----+----+----+----+----+----+
| Con | AF | AS | EU | OC | SA | == |
+---------+----+----+----+----+----+----+
| HNK | 0 | 0 | 1 | 0 | 0 | 1 |
| - | - | - | - | - | - | - |
| Transit | 0 | 0 | 0 | 0 | 0 | 0 |
| - | - | - | - | - | - | - |
| Total | 0 | 0 | 1 | 0 | 0 | 1 |
+---------+----+----+----+----+----+----+
Grand Total 1
These statistics are based on freshly updated non-hole cases from 1 to the following max case number, depending on the region:
EU - up to 12000
AF - up to 22500
AS - up to 5500
NA - up to 20
SA - up to 1750
OC - up to 1100
As soon as the new Visa Bulletin is published each month, the max case numbers are updated accordingly.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment