Skip to content

JoinOrder canonical IMDb 2013 dataset (v1)

Choose a tag to compare

@joeharris76 joeharris76 released this 09 Jul 19:27
· 3328 commits to develop since this release

JoinOrder canonical IMDb 2013 dataset (v1)

  • Source: Harvard Dataverse DOI 10.7910/DVN/2QYZBT, file imdb_pg11.
  • Snapshot: May 2013 IMDb list-file data parsed into the JOB 21-table schema.
  • Attribution: Information courtesy of IMDb (https://www.imdb.com). Used with permission.
  • Scope: research and database optimizer benchmarking.
  • BenchBox redistribution disclaimer and takedown commitment are included in DATA-LICENSE.md.
  • Archive: joinorder-imdb-2013-v1.tar.zst sha256 106ae78c5a1ab09f8e5ccc9ce0751ff8b5eae1f7b9e03a262773c26c528e9526.

Tables

  • aka_name: 901,343 rows, sha256 2abc121754c0ee62aac325dcc5373fcf054ba0eb9740d65001f31daceb07169e
  • aka_title: 361,472 rows, sha256 d0f6a559ceeaac996191656d97a6ce9477d515a382aec96948e8e207210adde7
  • cast_info: 36,244,344 rows, sha256 c6bebb9d00b50a7f5d6a046763c8d5e725dc55237b9ad94f92288aa2e9e3cbae
  • char_name: 3,140,339 rows, sha256 8427d9f1c7376df4a3f4175fed83b016277d25b835985fe9178a088c66379b25
  • comp_cast_type: 4 rows, sha256 f78755ff054ef0d5e3e00d245c7f3d9335c2d031eccbef0428c414c91058e6af
  • company_name: 234,997 rows, sha256 7210730eb45239af2f6c45b3bc229f0e21f890b11e8101a32fe7ad8bec478ffa
  • company_type: 4 rows, sha256 bba80a9acac32fe57344fbea5904a0d6a23a977c00b1916a83a5be94594c1fe8
  • complete_cast: 135,086 rows, sha256 6c660c5665348174d9226ad6dfd118728c2352ba68a1c4d45c93de945f7bccc5
  • info_type: 113 rows, sha256 e83fa2db221564ffb3487c16614200899a042a9e66792326a74179523cefc907
  • keyword: 134,170 rows, sha256 fd61a10ba98c9ded14778649bf64e1c98defbe9b78d481b6d1fe51dc444ce1bf
  • kind_type: 7 rows, sha256 dd9d886414b4ee83b0b015e06a440f868a05bb0d590d64cc7bfaadec1021bde9
  • link_type: 18 rows, sha256 205d37c045011d4fc20cf566d787e7b9655ecdad7bb0d0e19befb9d32f0036b8
  • movie_companies: 2,609,129 rows, sha256 6d7939c6ebbb88bd6963b155485a48060df4b073099f3e86835a68f282b2c94d
  • movie_info: 14,835,720 rows, sha256 c63b13e8f90965cdfb45263d2fb8c6b09dd7926a6c2e9d957508c927133be54f
  • movie_info_idx: 1,380,035 rows, sha256 52458eba771af35067459e79988ad91d639b5dcb535e116854de214aa06ee159
  • movie_keyword: 4,523,930 rows, sha256 17e628c6a2214d265ed0ea67c2462034a198a0b91c42356ce94a04e44f7b7a64
  • movie_link: 29,997 rows, sha256 71208862a69db18e79bf414a9f2787dbf640a4a3558db165ca536c57eb746991
  • name: 4,167,491 rows, sha256 9c755fb800bbac00e6fa4c09d7bd344a759ff0d65ce8396c117fd012221f49dc
  • person_info: 2,963,664 rows, sha256 a516f55bade10bf660eb40f159aa93b6c579349646d1c927110f72cfe78beac3
  • role_type: 12 rows, sha256 7f6a2148a3e34787dfe1c6f71f68e9d1cd0e3fb165e497bdf9a7c64e21d771ce
  • title: 2,528,312 rows, sha256 6c5749b8c1569342c1a96ffaefe1146051a10f77db3b693df84a0d2d44f1462b