+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445

What Are My Rights When My Citizenship Application is Delayed?

bas12

Hero Member
Apr 20, 2018
369
122
I was actually mistaken, the "Location" field is where the applicant is living. So we don't even have the processing centre as information. We don't have online vs. paper in the spreadsheet.

As is, in the data that I'm keeping right now, the _most_ nominative information is date of application sent.

The process is simple if you know the R programming language: save each sheet of the Excel file as a .csv file, import to R (skipping the first two lines), combine and process. The .csv files take some cleaning up, because things like "#VALUE!" or the errant "Excel thinks this is a date" cell will make R think a column is text for one file whereas it correctly thinks it's numbers for the rest, and it won't be able to join the files.

Luckily for us, this forum is hosted on a law team's website, so... maybe we could start there if we had a real interest in making the anonymized data more publicly available.
Might be a good idea to find out if we can use the generated pictures outside of the forum (or at all), there might be some weird issues around that...
Maybe I am overthinking it..
 

bas12

Hero Member
Apr 20, 2018
369
122
I do actually have 2019 (and could go back as far as the spreadsheets exists) and 2023. Here's a graph of milestone by year with the two included, for some of the milestones I judged as more important. Caution for 2023, especially for submission to oath, cause only 6 applicants have taken the oath (1% of applications so far).

Would anybody be interested in having a copy of the cleaned-up and aggregated data? I could maybe share it on GitHub. Right now, I'm abstracting away from most information (like processing centre) in favour of the numerical data, so let me know what other factors you want to know about.

Probably not very scientific, but looks like 2019 were treated very unfairly. Of course we already knew that. 2020 also not great, but I guess there is covid excuse. About 2021, it is hard to tell. There is no evidence of backlog being processed at a low rate over long time like for 2019. But that could mean that either they completely abandoned working on it, or it is very small for that year.

Interestingly, I don't see any increase at 36 months, so I guess it might have been a coincidence, or maybe it is because the posts I saw were from before covid, and the policy has changed since then.
 

johnjkjk

Champion Member
Mar 29, 2016
1,059
426
The old backlog still exists. That's why the processing time isn't back to 12 months yet. We can assume most 19-20 applicants are done, and 2022 files are being processed to the service standard, so the current backlog would stem from 2021 online applicants, particularly Sep-Dec, as a small quota was introduced for these months. From the spreadsheet data, it would appear that in the first 3 quarters of 2021, 65% of cases were approved within 12 months in any given month, falling to 50% for the last quarter, and picking up to 70-80% for 2022 (the service standard). So it is likely that a select % of applicants per month were backlogged. What criteria was applied to backlog people? An ATIP question for IRCC.
 

inkomati

Full Member
Dec 2, 2022
41
10
The old backlog still exists. That's why the processing time isn't back to 12 months yet. We can assume most 19-20 applicants are done, and 2022 files are being processed to the service standard, so the current backlog would stem from 2021 online applicants, particularly Sep-Dec, as a small quota was introduced for these months. From the spreadsheet data, it would appear that in the first 3 quarters of 2021, 65% of cases were approved within 12 months in any given month, falling to 50% for the last quarter, and picking up to 70-80% for 2022 (the service standard). So it is likely that a select % of applicants per month were backlogged. What criteria was applied to backlog people? An ATIP question for IRCC.
If I remember correctly, 40% of 2020 applications in the spreadsheets still aren't completed. Same for 2022. I will look by quarter of submission, though. Anecdotally speaking as a May 2021 applicant myself who can see no reasonable sign for delay in my case notes... you're possibly being a bit generous here.
 

bas12

Hero Member
Apr 20, 2018
369
122
If I remember correctly, 40% of 2020 applications in the spreadsheets still aren't completed. Same for 2022. I will look by quarter of submission, though. Anecdotally speaking as a May 2021 applicant myself who can see no reasonable sign for delay in my case notes... you're possibly being a bit generous here.
I could be that the person in charge is not updating it, or people are forgetting to report on it.
I think most of 2021 was already at 60% in the end of last summer, and it hasn't changed much since then. I hope they still process the ones that are left, even if very slowly.

Actually I am not in 2021 spreadsheet, and I am not sure how to get in touch with the person updating it.
 

johnjkjk

Champion Member
Mar 29, 2016
1,059
426
I could be that the person in charge is not updating it, or people are forgetting to report on it.
I think most of 2021 was already at 60% in the end of last summer, and it hasn't changed much since then. I hope they still process the ones that are left, even if very slowly.

Actually I am not in 2021 spreadsheet, and I am not sure how to get in touch with the person updating it.
I was thinking if a spreadsheet admin could make a sticky thread inviting people whose details are incomplete/missing to PM them, we would have more complete data.

Somehow I appear twice- once in the wrong month. Not sure how to request the wrong entry be deleted.
 

bas12

Hero Member
Apr 20, 2018
369
122
I was thinking if a spreadsheet admin could make a sticky thread inviting people whose details are incomplete/missing to PM them, we would have more complete data.

Somehow I appear twice- once in the wrong month. Not sure how to request the wrong entry be deleted.
I think there is an email you can see if you click on A1 cell.
Do we know by any chance which users are admins of these spreadsheets?

Getting more up to date data would be interesting, but I am not sure this crowdsourced data can be used to prove anything. Of course getting some idea of what is really going on is still helpful.
 

inkomati

Full Member
Dec 2, 2022
41
10
There must be a way to see when a given spreadsheet was updated last. Or we could manually look at a couple of threads and verify if people who have recently taken the oath have had their entries updated. And go from there
 
  • Like
Reactions: bas12