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)

All official checks filtering question.

Post Reply
User avatar
Mochard
Posts: 2324
Joined: May 13th, 2011, 6:00 am
Location: California
Contact:

All official checks filtering question.

#1

Post by Mochard »

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
User avatar
maxwelldeux
Donator
Posts: 8791
Joined: June 7th, 2016, 6:00 am
Location: Seattle-ish, WA, USA
Contact:

#2

Post by maxwelldeux »

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. :P
User avatar
Tim2460
Posts: 3221
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#3

Post by Tim2460 »

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
User avatar
Mochard
Posts: 2324
Joined: May 13th, 2011, 6:00 am
Location: California
Contact:

#4

Post by Mochard »

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.
User avatar
Mochard
Posts: 2324
Joined: May 13th, 2011, 6:00 am
Location: California
Contact:

#5

Post by Mochard »

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
Just downloaded it - it's perfect - just what I was looking for

Thanks
User avatar
maxwelldeux
Donator
Posts: 8791
Joined: June 7th, 2016, 6:00 am
Location: Seattle-ish, WA, USA
Contact:

#6

Post by maxwelldeux »

Mochard wrote: November 21st, 2019, 8:06 pm
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
Just downloaded it - it's perfect - just what I was looking for

Thanks
Hot diggity damn... that's even better than I expected. Thanks for sharing!
User avatar
blueboybob
Donator
Posts: 2518
Joined: March 11th, 2013, 6:00 am
Location: DC
Contact:

#7

Post by blueboybob »

There is also a less up to date 80 minutes list https://www.icheckmovies.com/lists/offi ... adatriste/
User avatar
Ebbywebby
Posts: 3720
Joined: September 10th, 2012, 6:00 am
Location: Orange County, CA
Contact:

#8

Post by Ebbywebby »

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
Mochard wrote: November 21st, 2019, 5:14 pm
I didn't see mjf's short features though - thats cool.
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. ;)
User avatar
maxwelldeux
Donator
Posts: 8791
Joined: June 7th, 2016, 6:00 am
Location: Seattle-ish, WA, USA
Contact:

#9

Post by maxwelldeux »

Ebbywebby wrote: November 22nd, 2019, 12:07 am
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
Mochard wrote: November 21st, 2019, 5:14 pm
I didn't see mjf's short features though - thats cool.
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. ;)
Best friends all around! :P

But yeah - thanks for putting that together!
User avatar
joachimt
Donator
Posts: 33119
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#10

Post by joachimt »

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. :hug:
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 3221
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#11

Post by Tim2460 »

Glad the excel is usefull !
User avatar
Ebbywebby
Posts: 3720
Joined: September 10th, 2012, 6:00 am
Location: Orange County, CA
Contact:

#12

Post by Ebbywebby »

joachimt wrote: November 22nd, 2019, 5:55 am 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.
So now I need to find some underappreciated newbie to mentor and host a list for. :)
User avatar
Coryn
Posts: 1343
Joined: December 5th, 2018, 2:53 pm
Contact:

#13

Post by Coryn »

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
(l) (l) (l)
I saved Latin, what did you ever do ?
User avatar
Onderhond
Posts: 5821
Joined: December 23rd, 2012, 7:00 am
Contact:

#14

Post by Onderhond »

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 :)
User avatar
blueboybob
Donator
Posts: 2518
Joined: March 11th, 2013, 6:00 am
Location: DC
Contact:

#15

Post by blueboybob »

User avatar
Onderhond
Posts: 5821
Joined: December 23rd, 2012, 7:00 am
Contact:

#16

Post by Onderhond »

Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!
User avatar
Fergenaprido
Donator
Posts: 4916
Joined: June 3rd, 2014, 6:00 am
Location: Canada
Contact:

#17

Post by Fergenaprido »

Onderhond wrote: July 3rd, 2020, 9:08 pm Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!
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
User avatar
Onderhond
Posts: 5821
Joined: December 23rd, 2012, 7:00 am
Contact:

#18

Post by Onderhond »

Fergenaprido wrote: July 6th, 2020, 7:27 pm
Onderhond wrote: July 3rd, 2020, 9:08 pm Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!
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. :shifty:
User avatar
Fergenaprido
Donator
Posts: 4916
Joined: June 3rd, 2014, 6:00 am
Location: Canada
Contact:

#19

Post by Fergenaprido »

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
User avatar
Onderhond
Posts: 5821
Joined: December 23rd, 2012, 7:00 am
Contact:

#20

Post by Onderhond »

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
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.

Thanks for the tip though, handy list :)
User avatar
Torgo
Posts: 1958
Joined: June 30th, 2011, 6:00 am
Location: Germany
Contact:

#21

Post by Torgo »

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...
Spoiler
... literally no idea. Could be anything. :shrug:

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
User avatar
PeacefulAnarchy
Moderator
Posts: 25920
Joined: May 8th, 2011, 6:00 am
Contact:

#22

Post by PeacefulAnarchy »

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.
User avatar
joachimt
Donator
Posts: 33119
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#23

Post by joachimt »

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"
User avatar
Tim2460
Posts: 3221
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#24

Post by Tim2460 »

I'll take à look when I'm back home. I do have the runtime on my excel chart.
User avatar
pitchorneirda
Posts: 313
Joined: February 11th, 2019, 12:07 pm
Location: France
Contact:

#25

Post by pitchorneirda »

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
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
User avatar
Torgo
Posts: 1958
Joined: June 30th, 2011, 6:00 am
Location: Germany
Contact:

#26

Post by Torgo »

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 :)
User avatar
joachimt
Donator
Posts: 33119
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#27

Post by joachimt »

Torgo wrote: October 31st, 2020, 3:20 pm 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,
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"
User avatar
pitchorneirda
Posts: 313
Joined: February 11th, 2019, 12:07 pm
Location: France
Contact:

#28

Post by pitchorneirda »

Torgo wrote: October 31st, 2020, 3:20 pm Also one of you says there are over 16k official checks, the other estimates 20k - guess we will have a clearer number later :)
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
User avatar
PeacefulAnarchy
Moderator
Posts: 25920
Joined: May 8th, 2011, 6:00 am
Contact:

#29

Post by PeacefulAnarchy »

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)
User avatar
Tim2460
Posts: 3221
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#30

Post by Tim2460 »

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
User avatar
pitchorneirda
Posts: 313
Joined: February 11th, 2019, 12:07 pm
Location: France
Contact:

#31

Post by pitchorneirda »

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)
I did the calculation of the median runtime excluding those with unknown runtimes so the calculation is correct.
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
User avatar
pitchorneirda
Posts: 313
Joined: February 11th, 2019, 12:07 pm
Location: France
Contact:

#32

Post by pitchorneirda »

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
Well, that wasn't a good proxy then.
Thank you Tim
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
User avatar
xianjiro
Donator
Posts: 8763
Joined: June 17th, 2015, 6:00 am
Location: Kakistani Left Coast
Contact:

#33

Post by xianjiro »

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
1517418 minutes is an iCM official lifetime :lol:
User avatar
Onderhond
Posts: 5821
Joined: December 23rd, 2012, 7:00 am
Contact:

#34

Post by Onderhond »

Still not going to be 100%, some films miss lengths and some of the miniseries show episode length instead of full length.
Post Reply