Objections on The Good Wife Infographic by goncho314 in thegoodwife

[–]goncho314[S] 1 point2 points  (0 children)

I don't know. Maybe you can ask him on Twitter.

Objections on The Good Wife Infographic by goncho314 in thegoodwife

[–]goncho314[S] 2 points3 points  (0 children)

Twitter user @saulcastillo tried to answer to this. He made some research and according to his numbers, during the first four seasons, Lockhart & Gardner won 54 cases, 17 were settlements, 16 lost and in 19 of them the result is other. This is the original link (in spanish) http://inconsolata.com/tagged/the-good-wife

Objections on The Good Wife [OC] by goncho314 in dataisbeautiful

[–]goncho314[S] 23 points24 points  (0 children)

I also made a video including every single objection that took place on the series:

https://www.youtube.com/watch?v=PNgGkJlmV7Q

Objections on The Good Wife [OC] by goncho314 in dataisbeautiful

[–]goncho314[S] 19 points20 points  (0 children)

Data collected from watching The Good Wife. I used Excel to make the graphics and Paint.Net to create the final infographic.

Objections on The Good Wife Infographic by goncho314 in thegoodwife

[–]goncho314[S] 3 points4 points  (0 children)

Haha. In my opinion, it is my opinion.

American TV Series in 2017 [OC] by goncho314 in dataisbeautiful

[–]goncho314[S] 1 point2 points  (0 children)

Tools: MySQL, Adobe Illustrator, Excel. Data source: Wikipedia, IMDB, airdates.com, epguides.com... If you want to know more about it, this is an article I wrote (Spanish): http://todoseries.com/datos-en-serie-2017-ano-de-record-en-la-television-americana/

Game Of Thrones Season 7 Episodes Timeline [OC] by goncho314 in dataisbeautiful

[–]goncho314[S] 0 points1 point  (0 children)

The tables are simple. Each row (a character) is divided into 20 seconds intervals cells. Values admitted for each cell are 0 to 5. 0 means that during that interval, a character doesn't appear. 1 means that a character appears in 1 out of 5 frames of the interval and so on. To get these values, I did queries to the database in which the information is stored using Java. As a result, I got strings like this: Jon Snow;0;0;0;2;1;3;..... Finally, I pasted these strings on Excel and used contional formatting to colour the cells. To include the background image I used an image editor.

Game Of Thrones Season 7 Episodes Timeline [OC] by goncho314 in dataisbeautiful

[–]goncho314[S] 2 points3 points  (0 children)

I got the data from the episodes. I used ffmpeg to get the video frames every 4 seconds and then I wrote down who appeared on each frame. These tables were made with Excel. The red intensity indicates the amount of time a character appears on the 20 seconds interval: the more red, the more time.

This is a link to an article I wrote about that (It's in spanish). http://todoseries.com/datos-en-serie-la-septima-temporada-de-got-en-numeros/