Toggle Menu

DV2023 CEAC Data

Data was obtained from the Consular Electronic Application Center of the U.S. Department of State. You can also download the current state of data in a form of csv file: FY2023-ceac-current.csv.
RegionIssuedAP221gRefusedReadyTransitSum
AF0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
AS0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
EU0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
OC0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
SA0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
Sum0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
Numbers in the table correspond to the number of actual people/visas. Number of cases are given in (). For an explanation on status classification see below.
Charts presented here serve merely as an interactive illustration of the CEAC data. For comprehensive analysis please refer to Simon's blog.
Please note that you can disable individual datasets by clicking on the legend.

DV2023 CEAC Data for Embassies

Please note that the range of case numbers on the following plot doesn't correspond to the range of the region where an embassy is located. There's a simple explanation: an assignment to embassies for DV winners is done per the place of residence, not the place of birth. In other words, it's possible for an embassy in EU to process people from e.g. AF or AS.
RegionIssuedAP221gRefusedReadyTotals
AF0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
AS0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
EU0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
OC0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
SA0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
Totals0 (0)0 (0)0 (0)0 (0)0 (0)0 (0)
Numbers in the table correspond to the number of actual people/visas. Number of cases are given in (). For an explanation on status classification see below.

The following table shows how many 2NLs a given embassy sent on a specific date.

How many cases there are before and after me?

If you're a DV selectee you can check how many cases are in front of you by filling out the form below.

DV2023 Raw CEAC Data

A complete dump of the database made on a given date.
    You can use the following file: embassies.txt to map a 3-letter embassy code to a physical location of the embassy (City, Country). Table below shows the current status of all cases in the database.
    caseNumberFullconsulatestatussubmitDatestatusDateIssuedAPReadyRefusedRefused221g2nlDate
    caseNumberFullconsulatestatussubmitDatestatusDateIssuedAPReadyRefusedRefused221g2nlDate

    Notes on cases classification

    Sometime around March 2020 CEAC database started showing cases that were undergoing Administrative Processing as Refused. That is "technically" a more accurate choice since it is a refusal under section 221(g) of the Immigration and Nationality Act. However, since most of those cases resolve to Issued after some time, for purpose of determining how many people are getting DV visa it's more convenient to keep the old classification. Fortunately, it's still possible to distinguish between a 221(g) refusal and other types of refusal if you consider the case status message in CEAC. There are two types of wording for refused cases:
    • A U.S. consular officer has adjudicated and refused your visa application. Please see the letter you received at the interview.
    • A U.S. consular officer has adjudicated and refused your visa application. Please follow any instructions provided by the consular officer. If you were informed by the consular officer that your case was refused for administrative processing, your case will remain refused while undergoing such processing...
    This allows us to assume that the latter phrasing indicates 221(g) refusal. All charts and tables on this page follow this hypothesis during case classification. Additionally, in raw csv dumps there's now a new column potentialAP that indicates wording in the CEAC status message. (0 - refusal, 1 - potential AP).