Moonlighting Season 5 Episode 12

I see that Episode 12 of Season 5 of Moonlighting (tt0651053) is no longer missing from most of the dataset files (thank-you), but now Episode 4 of Season 5 of Law & Order (tt0629263) has the exact same problem. It is present in the akas file, but not in the basics, crew, episode, principals, or ratings files. Also, Episode 11 of Season 2 of The Good Wife (tt1632289) has the exact same problem.

Hello hduston

Thank you for reporting this issue. Our team is working to investigate and resolve this issue as quickly as possible (Ref Ticket #V2278579784). We'll update this combined thread once we receive further information. Thanks to you all for your patience.

@Fran​

 have conducted further analysis. It appears that there are a total of 434 titles that are present in the akas file and not present in the basics file (and possibly the other files as well). Here is the complete list of missing tconst ids:

t0016085,tt0017078,tt0027898,tt0053444,tt0063120,tt0088404,tt0093353,tt0129666,tt0134854,tt0144585,tt0226225,tt0283678,tt0303016,tt0315857,tt0343363,tt0347286,tt0372355,tt0431418,tt0472959,tt0491159,tt0511662,tt0520285,tt0543994,tt0616298,tt0628366,tt0628797,tt0628798,tt0628806,tt0628809,tt0629263,tt0650834,tt0654342,tt0749497,tt0751463,tt0758484,tt0758485,tt0760905,tt0760908,tt0771844,tt0771847,tt0785450,tt0791281,tt0792305,tt0797450,tt0797455,tt0798160,tt0801623,tt0801624,tt0813584,tt0813587,tt0820246,tt0820247,tt0824030,tt0824031,tt0827351,tt0828231,tt0828233,tt0832688,tt0846509,tt0849098,tt0853817,tt0858080,tt0858083,tt0859382,tt0871690,tt0873082,tt0885968,tt0885971,tt0899926,tt0899927,tt0903472,tt0909666,tt0941727,tt0941728,tt0941730,tt0941731,tt0955625,tt0955626,tt0978073,tt0987179,tt0993344,tt0998646,tt10017102,tt1004670,tt1004675,tt1004676,tt1008115,tt10087832,tt10151238,tt1016893,tt1016897,tt1016903,tt1016904,tt10229006,tt1025806,tt1025816,tt1033900,tt1033901,tt1033903,tt1033904,tt1048638,tt1048643,tt10508082,tt1052796,tt1052797,tt10617512,tt1065996,tt1066000,tt10695580,tt1076503,tt1076512,tt10793944,tt1093065,tt1093066,tt1093067,tt10957332,tt1095927,tt1095930,tt1101821,tt11065340,tt11135906,tt1120325,tt1120326,tt1120329,tt1120330,tt1120331,tt1133080,tt11666128,tt11706492,tt1170957,tt11710720,tt11710736,tt1184173,tt1188801,tt1195200,tt12009310,tt12099898,tt1217807,tt12188252,tt1228389,tt1228393,tt1228823,tt1229565,tt12301380,tt1230957,tt1239800,tt1243079,tt1246243,tt1268684,tt1274020,tt1277352,tt12874028,tt12874062,tt1289048,tt1291972,tt1291975,tt1291980,tt1292577,tt12982266,tt12993266,tt1306525,tt1317215,tt13198676,tt1324563,tt1326559,tt13283818,tt1331746,tt1335333,tt1335337,tt1335341,tt1338837,tt13486244,tt13515150,tt13519496,tt1372137,tt13745330,tt13835380,tt13932126,tt14086370,tt14124546,tt14149160,tt14299926,tt14338258,tt14675076,tt14938306,tt15539802,tt1568449,tt15745306,tt1744968,tt1750014,tt1825256,tt1859056,tt1861907,tt18814654,tt1916362,tt19820472,tt2008420,tt2096093,tt21096982,tt21851354,tt2187001,tt2187823,tt2189433,tt2189435,tt22052814,tt2213255,tt2213582,tt22168892,tt22168914,tt2216969,tt2222575,tt22298434,tt2239028,tt2239959,tt22468826,tt2275844,tt22816638,tt2384296,tt23846686,tt2445626,tt2715232,tt2764762,tt27728249,tt27920334,tt28100945,tt28254836,tt28266469,tt28266474,tt28266480,tt28611813,tt28651346,tt29081115,tt29081117,tt29268006,tt29270056,tt2945790,tt29582957,tt2989060,tt29924285,tt29930158,tt29940002,tt31116181,tt31149895,tt31598311,tt31720187,tt31939371,tt3224050,tt32262847,tt32490670,tt33254657,tt33394352,tt33394360,tt3355142,tt3409008,tt3410072,tt34748834,tt34807675,tt34883782,tt35180462,tt35342970,tt3548762,tt36013520,tt36013576,tt36103328,tt36103330,tt36299802,tt36758426,tt37434402,tt37693580,tt37967537,tt38236627,tt3839400,tt38608067,tt38631338,tt38631613,tt38754878,tt38780494,tt38781596,tt38781612,tt38793851,tt38793895,tt38835865,tt38956195,tt38960924,tt38960929,tt38973460,tt39049276,tt39049287,tt39049297,tt39066294,tt39066442,tt39066517,tt39066530,tt39066539,tt39069879,tt39069887,tt39070179,tt39070182,tt39070276,tt39070537,tt39070571,tt39071407,tt39071415,tt39071591,tt39072129,tt39072150,tt39074303,tt39086403,tt39087882,tt39087929,tt39087937,tt39088969,tt39088979,tt39088985,tt39088999,tt39089024,tt39089046,tt39089059,tt39089076,tt39089103,tt39089109,tt39089141,tt39089153,tt39089164,tt39089181,tt39101465,tt39105728,tt39105732,tt39105886,tt39105972,tt39107181,tt39107327,tt39107427,tt39107752,tt39107878,tt39107916,tt39107998,tt39141116,tt39141138,tt39305495,tt39305516,tt39305580,tt39305653,tt39305699,tt39305707,tt39305748,tt39305779,tt39305807,tt39305840,tt39305912,tt39306627,tt39306654,tt39306655,tt39306659,tt39306661,tt39306668,tt39306671,tt39306676,tt39306679,tt39306684,tt39307720,tt39307774,tt3985550,tt39947360,tt40070649,tt40070940,tt40071831,tt4080040,tt41201925,tt41201927,tt41207550,tt41223673,tt4126724,tt42720799,tt42721535,tt4324894,tt43439249,tt43594461,tt43609975,tt43689690,tt43689696,tt43689698,tt43689701,tt43689703,tt43689727,tt43689730,tt4464990,tt4742896,tt4772498,tt4800226,tt4911362,tt4927404,tt5019996,tt5070490,tt5234698,tt5276204,tt5337074,tt5476252,tt5499688,tt5762280,tt5818844,tt5856760,tt6005478,tt6121762,tt6150162,tt6189726,tt6269434,tt6409744,tt6445520,tt6485816,tt6745062,tt7247410,tt7336724,tt7405612,tt7439698,tt7439842,tt7448916,tt7477820,tt7525360,tt7535666,tt7717276,tt7887800,tt7912496,tt7996746,tt8041998,tt8459220,tt8733536,tt8970104,tt9047790,tt9577996,tt9577998,tt9590126,tt9604524,tt9826696 

@Maya​ Updating my reply to Fran, there are now 413 titles missing from the basics file that are present in the akas file.

This is the list of 413 titles.

tt0016085,tt0017078,tt0027898,tt0053444,tt0063120,tt0088404,tt0093353,tt0129666,tt0134854,tt0144585,tt0226225,tt0283678,tt0303016,tt0315857,tt0343363,tt0347286,tt0372355,tt0472959,tt0491159,tt0511662,tt0520285,tt0543994,tt0628366,tt0628797,tt0628798,tt0628806,tt0628809,tt0650834,tt0654342,tt0749497,tt0758484,tt0758485,tt0760905,tt0760908,tt0771844,tt0771847,tt0791281,tt0792305,tt0797450,tt0797455,tt0798160,tt0801623,tt0801624,tt0813584,tt0813587,tt0820246,tt0820247,tt0824030,tt0824031,tt0827351,tt0828231,tt0828233,tt0832688,tt0846509,tt0849098,tt0853817,tt0858080,tt0858083,tt0859382,tt0871690,tt0873082,tt0885968,tt0885971,tt0899926,tt0899927,tt0903472,tt0909666,tt0941727,tt0941728,tt0941730,tt0941731,tt0955625,tt0955626,tt0978073,tt0987179,tt0993344,tt0998646,tt10017102,tt1004670,tt1004675,tt1004676,tt1008115,tt10151238,tt1016893,tt1016897,tt1016903,tt1016904,tt10229006,tt1025806,tt1025816,tt1033900,tt1033901,tt1033903,tt1033904,tt1048638,tt1048643,tt10508082,tt1052796,tt1052797,tt1065996,tt1066000,tt10695580,tt1076503,tt1076512,tt10793944,tt1093065,tt1093066,tt1093067,tt10957332,tt1095927,tt1095930,tt1101821,tt11065340,tt11135906,tt1120325,tt1120326,tt1120329,tt1120330,tt1120331,tt1133080,tt11666128,tt1170957,tt1184173,tt1188801,tt1195200,tt12009310,tt12099898,tt1217807,tt12188252,tt1228389,tt1228393,tt1228823,tt1229565,tt12301380,tt1230957,tt1239800,tt1243079,tt1246243,tt1268684,tt1274020,tt1277352,tt12874028,tt12874062,tt1289048,tt1291972,tt1291975,tt1291980,tt1292577,tt12982266,tt12993266,tt1306525,tt1317215,tt13198676,tt1324563,tt1326559,tt13283818,tt1331746,tt1335333,tt1335337,tt1335341,tt1338837,tt13486244,tt13515150,tt13519496,tt1372137,tt13745330,tt13835380,tt13932126,tt14086370,tt14124546,tt14149160,tt14299926,tt14338258,tt14675076,tt14938306,tt15539802,tt1568449,tt15745306,tt1744968,tt1750014,tt1825256,tt1859056,tt1861907,tt18814654,tt1916362,tt19820472,tt2008420,tt2096093,tt21096982,tt21851354,tt2187001,tt2187823,tt2189433,tt2189435,tt22052814,tt2213255,tt2213582,tt22168892,tt22168914,tt2216969,tt2222575,tt22298434,tt2239028,tt2239959,tt22468826,tt2275844,tt22816638,tt2384296,tt23846686,tt2764762,tt27728249,tt27920334,tt28100945,tt28254836,tt28266469,tt28266474,tt28266480,tt28611813,tt28651346,tt29081115,tt29081117,tt29268006,tt29270056,tt2945790,tt29582957,tt2989060,tt29924285,tt29930158,tt29940002,tt31116181,tt31149895,tt31598311,tt31720187,tt31939371,tt3224050,tt32262847,tt32490670,tt33254657,tt33394352,tt33394360,tt3355142,tt3409008,tt3410072,tt34748834,tt34807675,tt34883782,tt35180462,tt35342970,tt3548762,tt36013520,tt36013576,tt36103328,tt36103330,tt36299802,tt36758426,tt37434402,tt37693580,tt37967537,tt38236627,tt3839400,tt38608067,tt38631338,tt38631613,tt38754878,tt38780494,tt38781596,tt38781612,tt38793851,tt38793895,tt38835865,tt38956195,tt38960924,tt38960929,tt38973460,tt39049276,tt39049287,tt39049297,tt39066294,tt39066442,tt39066517,tt39066530,tt39066539,tt39069879,tt39069887,tt39070179,tt39070182,tt39070276,tt39070537,tt39070571,tt39071407,tt39071415,tt39071591,tt39072129,tt39072150,tt39074303,tt39086403,tt39087882,tt39087929,tt39087937,tt39088969,tt39088979,tt39088985,tt39088999,tt39089024,tt39089046,tt39089059,tt39089076,tt39089103,tt39089109,tt39089141,tt39089153,tt39089164,tt39089181,tt39101465,tt39105728,tt39105732,tt39105886,tt39105972,tt39107181,tt39107327,tt39107427,tt39107752,tt39107878,tt39107916,tt39107998,tt39141116,tt39141138,tt39305495,tt39305516,tt39305580,tt39305653,tt39305699,tt39305707,tt39305748,tt39305779,tt39305807,tt39305840,tt39305912,tt39306627,tt39306654,tt39306655,tt39306659,tt39306661,tt39306668,tt39306671,tt39306676,tt39306679,tt39306684,tt39307720,tt39307774,tt3985550,tt39947360,tt40070649,tt40070940,tt40071831,tt4080040,tt41201925,tt41201927,tt41207550,tt4126724,tt42720799,tt42721535,tt4324894,tt43439249,tt43594461,tt43609975,tt4742896,tt4772498,tt4800226,tt4911362,tt4927404,tt5019996,tt5070490,tt5234698,tt5276204,tt5337074,tt5476252,tt5499688,tt5762280,tt5818844,tt5856760,tt6005478,tt6121762,tt6150162,tt6189726,tt6269434,tt6409744,tt6445520,tt6485816,tt6745062,tt7247410,tt7336724,tt7405612,tt7439698,tt7439842,tt7448916,tt7477820,tt7535666,tt7717276,tt7887800,tt7912496,tt7996746,tt8041998,tt8459220,tt8733536,tt8970104,tt9047790,tt9577996,tt9577998,tt9590126,tt9604524,tt9826696

Fantastic!!

I see we're down to only two titles missing from basics.tsv but present in akas.tsv. The titles are: (drumroll please!)

tt43729228 and tt43729262