Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
NOTE: Board emails should be working again. Information on forum upgrade and style issues.
Podcast: Talking Images (Episode 22 released November 17th * EXCLUSIVE * We Are Mentioned in a Book!!! Interview with Mary Guillermin on Rapture, JG & More)
Polls: TV-series (Results), Directors (Jan 2nd), 1980 (Jan 24th), <50 checks (Jan 31st)
Challenges: 1000<400, Sci-Fi/Fantasy, Central American/Andean
Film of the Week: Les croix de bois, February nominations (Jan 29th)
NOTE: Board emails should be working again. Information on forum upgrade and style issues.
Podcast: Talking Images (Episode 22 released November 17th * EXCLUSIVE * We Are Mentioned in a Book!!! Interview with Mary Guillermin on Rapture, JG & More)
Polls: TV-series (Results), Directors (Jan 2nd), 1980 (Jan 24th), <50 checks (Jan 31st)
Challenges: 1000<400, Sci-Fi/Fantasy, Central American/Andean
Film of the Week: Les croix de bois, February nominations (Jan 29th)
All official checks filtering question.
All official checks filtering question.
I am trying to list all official checks and then filter / sort them by runtimes but I can't seem to find a way! Is it even possible to filter by runtime? I can't seem to find a way that works.
The only thing I can think of doing is to export every list then remove duplicates and then I can sort by runtime.
If this is the only way then I'm asking if anyone happens to have already created a spreadsheet with all official checks on it that they are willing to share?
Or if anyone knows of something I am missing? It would be nice if rather than seeing all movies - you see all official movies as an option then you can sort by runtimes etc.
Exporting the lists doesn't show runtimes so that's out! Maybe an imdb list exists as that would have runtimes on if exported.
Thanks
The only thing I can think of doing is to export every list then remove duplicates and then I can sort by runtime.
If this is the only way then I'm asking if anyone happens to have already created a spreadsheet with all official checks on it that they are willing to share?
Or if anyone knows of something I am missing? It would be nice if rather than seeing all movies - you see all official movies as an option then you can sort by runtimes etc.
Exporting the lists doesn't show runtimes so that's out! Maybe an imdb list exists as that would have runtimes on if exported.
Thanks
- maxwelldeux
- Donator
- Posts: 8791
- Joined: June 7th, 2016, 6:00 am
- Location: Seattle-ish, WA, USA
- Contact:
What are you looking for?
If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes
If you're looking for longs, I don't have that at my fingertips.
But more generally (and I'm speaking from memory, so forgive me if I'm wrong on details), there's no way to filter only official checks, and it's not possible to export ICM search results. Also, ICM has a list limit of 5000 titles, and there are ~17000+ official checks.
But in this respect, Tim2460 is your best friend:
Films on 3+ Official lists
Films on 2 Official lists
Films on 1 Official list p1
Films on 1 Official list p2
That distills all official checks down to four lists (data are updated monthly). If you want to do more from there, that's on you.
If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes
If you're looking for longs, I don't have that at my fingertips.
But more generally (and I'm speaking from memory, so forgive me if I'm wrong on details), there's no way to filter only official checks, and it's not possible to export ICM search results. Also, ICM has a list limit of 5000 titles, and there are ~17000+ official checks.
But in this respect, Tim2460 is your best friend:
Films on 3+ Official lists
Films on 2 Official lists
Films on 1 Official list p1
Films on 1 Official list p2
That distills all official checks down to four lists (data are updated monthly). If you want to do more from there, that's on you.

Using both icm and imdb export is indeed the way to go.
It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
Thank you guys so much.
Yeah i was fine for shorts - oh I didn't see mjf's short features though - thats cool.
Tim - I can't download your link atm as I'm at work (I shouldn't really be on this forum either but whatever!) but thank-you again. I really appreciate it. I'll grab it on my lunch.
Yeah i was fine for shorts - oh I didn't see mjf's short features though - thats cool.
Tim - I can't download your link atm as I'm at work (I shouldn't really be on this forum either but whatever!) but thank-you again. I really appreciate it. I'll grab it on my lunch.
Just downloaded it - it's perfect - just what I was looking forTim2460 wrote: ↑November 21st, 2019, 8:40 am Using both icm and imdb export is indeed the way to go.
It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
Thanks
- maxwelldeux
- Donator
- Posts: 8791
- Joined: June 7th, 2016, 6:00 am
- Location: Seattle-ish, WA, USA
- Contact:
Hot diggity damn... that's even better than I expected. Thanks for sharing!Mochard wrote: ↑November 21st, 2019, 8:06 pmJust downloaded it - it's perfect - just what I was looking forTim2460 wrote: ↑November 21st, 2019, 8:40 am Using both icm and imdb export is indeed the way to go.
It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
Thanks
- blueboybob
- Donator
- Posts: 2518
- Joined: March 11th, 2013, 6:00 am
- Location: DC
- Contact:
There is also a less up to date 80 minutes list https://www.icheckmovies.com/lists/offi ... adatriste/
maxwelldeux wrote: ↑November 21st, 2019, 5:16 am What are you looking for?
If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes
It's not really JoachimT's or mjf314's short features list...it's mine. JoachimT started hosting it as a favor when non-paying users couldn't share multiple lists and, well, it has stayed that way.
I'm your best friend too.

- maxwelldeux
- Donator
- Posts: 8791
- Joined: June 7th, 2016, 6:00 am
- Location: Seattle-ish, WA, USA
- Contact:
Best friends all around!Ebbywebby wrote: ↑November 22nd, 2019, 12:07 ammaxwelldeux wrote: ↑November 21st, 2019, 5:16 am What are you looking for?
If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes
It's not really JoachimT's or mjf314's short features list...it's mine. JoachimT started hosting it as a favor when non-paying users couldn't share multiple lists and, well, it has stayed that way.
I'm your best friend too.![]()

But yeah - thanks for putting that together!
Indeed. EbbyWebby keeps track of 46 to 69 minutes, but I update the list.
I keep track of 45 minutes and less, but mjf314 updates the list.
It's confusing, I know, but we're all best friends indeed.
I keep track of 45 minutes and less, but mjf314 updates the list.
It's confusing, I know, but we're all best friends indeed.

ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
Fergenaprido: "I find your OCD to be adorable, J"
Glad the excel is usefull !
Tim2460 wrote: ↑November 21st, 2019, 8:40 am Using both icm and imdb export is indeed the way to go.
It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ



I saved Latin, what did you ever do ?
Wondering about a different filter myself:
Is there an easy way to see which animes are official? I've already finished the Paste list, but I'm sure there are some official checks on other lists. All bright ideas are welcome
Is there an easy way to see which animes are official? I've already finished the Paste list, but I'm sure there are some official checks on other lists. All bright ideas are welcome

My Top 675 (2021 Edition) on: Onderhond | ICM | Letterboxd
- blueboybob
- Donator
- Posts: 2518
- Joined: March 11th, 2013, 6:00 am
- Location: DC
- Contact:
Closest you'll get is "animation" https://www.icheckmovies.com/movies/?ta ... Aanimation
Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!
My Top 675 (2021 Edition) on: Onderhond | ICM | Letterboxd
- Fergenaprido
- Donator
- Posts: 4916
- Joined: June 3rd, 2014, 6:00 am
- Location: Canada
- Contact:
Actually, it's probably better to use the Beta version for this task, since genre tags stopped being added to films in the current version a few years ago, so any film recently imported to icm would not show up in that list. Try this: https://beta.icheckmovies.com/movies/un ... Aanimation
Sounds promising, but the beta.icheckmovies pages never load for me.Fergenaprido wrote: ↑July 6th, 2020, 7:27 pmActually, it's probably better to use the Beta version for this task, since genre tags stopped being added to films in the current version a few years ago, so any film recently imported to icm would not show up in that list. Try this: https://beta.icheckmovies.com/movies/un ... Aanimation

My Top 675 (2021 Edition) on: Onderhond | ICM | Letterboxd
- Fergenaprido
- Donator
- Posts: 4916
- Joined: June 3rd, 2014, 6:00 am
- Location: Canada
- Contact:
Strange. Well, I can't help you much there, then. I just checked manually, and it seems there are only 3 official animes from 2016 onwards that aren't on the Paste list, and I suspect you've already seen them or are aware of them:
https://www.icheckmovies.com/movies/kon ... i+ni-2016/
https://www.icheckmovies.com/movies/yor ... +yo+otome/
https://www.icheckmovies.com/movies/tenki+no+ko/
There's also this list I found which may help guide you: https://www.icheckmovies.com/lists/500+ ... altoplists
https://www.icheckmovies.com/movies/kon ... i+ni-2016/
https://www.icheckmovies.com/movies/yor ... +yo+otome/
https://www.icheckmovies.com/movies/tenki+no+ko/
There's also this list I found which may help guide you: https://www.icheckmovies.com/lists/500+ ... altoplists
Based on that one, I'm missing 3 official films. One of the wrong Harmageddon though (it lists a Finnish film), the other one is a Pokémon film and the final one Urotsukidoji ... I've seen that one before I started rating films, not sure if I should revisit.Fergenaprido wrote: ↑July 6th, 2020, 8:59 pm There's also this list I found which may help guide you: https://www.icheckmovies.com/lists/500+ ... altoplists
Thanks for the tip though, handy list

My Top 675 (2021 Edition) on: Onderhond | ICM | Letterboxd
I see some of you guys are maniacs experts. That's great! I'd like to ask for one crazy, yet obvious fact - the ultimate goal of every ICM user, the final task:
What is the actual added runtime of every official check on ICM?
Maybe that's a quick stat you just have lying around with all your Excels. Maybe not - I wouldn't want to trouble anyone.
If it's easily accessible, perhaps you can also give an overall value with and without extreme outliers. Because I assume there are more cases like The Wire or that Baseball series in our recent <400 poll; the former is quite extreme in its length of approximately 60 hours compared to our standard films or even exotic filmmakers with enormously long features. Or Empire and all that.
Come to think of it, It's actually a fun game: Give your best estimate what all movies on ICM add up to!
I'd say...
Finally, if we have calculated a value, we could assign a great task, a vision like none other. We'd have to take a hypothetical human to have watched not a single minute of film in his life before and make him watch every (official) ICM movie ever. Give him/her some time, let's be realistic, 6 hours a day, maybe 7, it's a job (the greatest there is!). I have no idea how many years it would take this person then, quite a few. When he's finished, wise and old, we ask him if Shawshank Redemption really is the greatest film of time, to which his answ
What is the actual added runtime of every official check on ICM?
Maybe that's a quick stat you just have lying around with all your Excels. Maybe not - I wouldn't want to trouble anyone.
If it's easily accessible, perhaps you can also give an overall value with and without extreme outliers. Because I assume there are more cases like The Wire or that Baseball series in our recent <400 poll; the former is quite extreme in its length of approximately 60 hours compared to our standard films or even exotic filmmakers with enormously long features. Or Empire and all that.
Come to think of it, It's actually a fun game: Give your best estimate what all movies on ICM add up to!
I'd say...
Spoiler
... literally no idea. Could be anything.

Finally, if we have calculated a value, we could assign a great task, a vision like none other. We'd have to take a hypothetical human to have watched not a single minute of film in his life before and make him watch every (official) ICM movie ever. Give him/her some time, let's be realistic, 6 hours a day, maybe 7, it's a job (the greatest there is!). I have no idea how many years it would take this person then, quite a few. When he's finished, wise and old, we ask him if Shawshank Redemption really is the greatest film of time, to which his answ
- PeacefulAnarchy
- Moderator
- Posts: 25920
- Joined: May 8th, 2011, 6:00 am
- Contact:
Without looking anything up there are some 20K checks, average runtime is probably around 90 minutes, so 30 thousand hours. That's about 3.5 years non stop or a decade of 8 hours a day.
I've asked Marijn in the past to include runtime in the exportfile, but somehow he never added it. Would be easy otherwise to calculate this. Or you could create an IMDb-list of all official checks and export from there. Takes a bit more time, but not hard to do.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
Fergenaprido: "I find your OCD to be adorable, J"
I'll take à look when I'm back home. I do have the runtime on my excel chart.
- pitchorneirda
- Posts: 313
- Joined: February 11th, 2019, 12:07 pm
- Location: France
- Contact:
There are 16230 official checks.
I don't have an estimate for the mean runtime of an official movie
But I have the median runtime of a movie (official or not): 55 min
Official checks are a bit more skewed towards feature films than average but 90 min (PA's estimate) seems too high.
16230 * 55 = 892650 minutes or 14877 hours or 620 days
16230 * 90 = 1460700 minutes or 24345 hours or 1014 days
The right answer should be between those two boundaries
I don't have an estimate for the mean runtime of an official movie
But I have the median runtime of a movie (official or not): 55 min
Official checks are a bit more skewed towards feature films than average but 90 min (PA's estimate) seems too high.
16230 * 55 = 892650 minutes or 14877 hours or 620 days
16230 * 90 = 1460700 minutes or 24345 hours or 1014 days
The right answer should be between those two boundaries
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
Mh yeah, if I had to ballpark the number, I'd have the impression there are hundreds of shorts and so many of them are only a few minutes long, and maybe not as many hundreds of films with runtimes of 180 minutes or even outlier range (500+), so I'd also say 80 minutes each, .. or something? ..
Also one of you says there are over 16k official checks, the other estimates 20k - guess we will have a clearer number later
Also one of you says there are over 16k official checks, the other estimates 20k - guess we will have a clearer number later

There are currently 1935 official shorts (excluding shorts only on IMDb Shorts list). 29 of those have an unknown runtime. The other 1906 have an average runtime of 14.9 minutes.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
Fergenaprido: "I find your OCD to be adorable, J"
- pitchorneirda
- Posts: 313
- Joined: February 11th, 2019, 12:07 pm
- Location: France
- Contact:
16320 is not an estimate, that's the actual number.
If you go to iCM -> All movies -> Order by: in # official toplists
The last movie to be official is the 16320th (page 650)
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
- PeacefulAnarchy
- Moderator
- Posts: 25920
- Joined: May 8th, 2011, 6:00 am
- Contact:
I made my post half asleep without checking anything, so yeah if someone checked something then they're probably right.
The median runtime of official checks is much higher than those 55 minutes since that includes a) a lot of things without runtimes and b) a ton of TV episodes, even before getting into other runtime biases with official checks.
Edit: 1935 shorts
618 non shorts under70 min
Looking at Tim's lists Median runtime is probably between 90 and 100 minutes (Estimate since I'm not counting 2000 entries to see where exactly the middle is, and the lists don't have the same distributions anyway)
The median runtime of official checks is much higher than those 55 minutes since that includes a) a lot of things without runtimes and b) a ton of TV episodes, even before getting into other runtime biases with official checks.
Edit: 1935 shorts
618 non shorts under70 min
Looking at Tim's lists Median runtime is probably between 90 and 100 minutes (Estimate since I'm not counting 2000 entries to see where exactly the middle is, and the lists don't have the same distributions anyway)
Excel List is still on the official lists from 01/10/2020
So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)
1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month
So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)
1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month
- pitchorneirda
- Posts: 313
- Joined: February 11th, 2019, 12:07 pm
- Location: France
- Contact:
I did the calculation of the median runtime excluding those with unknown runtimes so the calculation is correct.PeacefulAnarchy wrote: ↑October 31st, 2020, 5:10 pm I made my post half asleep without checking anything, so yeah if someone checked something then they're probably right.
The median runtime of official checks is much higher than those 55 minutes since that includes a) a lot of things without runtimes and b) a ton of TV episodes, even before getting into other runtime biases with official checks.
Edit: 1935 shorts
618 non shorts under70 min
Looking at Tim's lists Median runtime is probably between 90 and 100 minutes (Estimate since I'm not counting 2000 entries to see where exactly the middle is, and the lists don't have the same distributions anyway)
If that's a good proxy for the actual average runtime is another question of course.
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
- pitchorneirda
- Posts: 313
- Joined: February 11th, 2019, 12:07 pm
- Location: France
- Contact:
Well, that wasn't a good proxy then.Tim2460 wrote: ↑October 31st, 2020, 9:18 pm Excel List is still on the official lists from 01/10/2020
So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)
1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month
Thank you Tim
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
- xianjiro
- Donator
- Posts: 8763
- Joined: June 17th, 2015, 6:00 am
- Location: Kakistani Left Coast
- Contact:
1517418 minutes is an iCM official lifetimeTim2460 wrote: ↑October 31st, 2020, 9:18 pm Excel List is still on the official lists from 01/10/2020
So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)
1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month

Still not going to be 100%, some films miss lengths and some of the miniseries show episode length instead of full length.
My Top 675 (2021 Edition) on: Onderhond | ICM | Letterboxd