Skip to content

Instantly share code, notes, and snippets.

@1rara

1rara/bgmPersonConnection.ipynb

Last active March 27, 2023 05:36
Show Gist options
  • Save 1rara/483e21cfd0ab97922d65b774b6a115f3 to your computer and use it in GitHub Desktop.
Save 1rara/483e21cfd0ab97922d65b774b6a115f3 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
bgmPersonConnection.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import requests\n",
"import os\n",
"import zipfile\n",
"import sqlite3\n",
"import jsonlines"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"# 下载 wiki dump\n",
"r = requests.get('https://github.com/bangumi/Archive/releases/download/archive/dump.zip', stream=True)\n",
"with open('dump.zip', 'wb') as f:\n",
" for chunk in r.iter_content(chunk_size=8*1024*1024):\n",
" f.write(chunk)\n",
"with zipfile.ZipFile('dump.zip', 'r') as zipObj:\n",
" zipObj.extract('person.jsonlines')\n",
" zipObj.extract('subject-persons.jsonlines')\n",
"os.remove('dump.zip')"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"# jsonlines 转换 sqlite\n",
"cur = sqlite3.connect(\"subject-persons.db\").cursor()\n",
"cur.execute(\"CREATE TABLE data(person_id, subject_id)\")\n",
"with jsonlines.open('subject-persons.jsonlines') as jl:\n",
" for item in jl:\n",
" cur.execute('INSERT INTO data(person_id, subject_id) VALUES (?,?)',\n",
" (item['person_id'], item['subject_id']))\n",
"os.remove('subject-persons.jsonlines')\n",
"\n",
"cur.execute(\"CREATE TABLE data2(id, name)\")\n",
"with jsonlines.open('person.jsonlines') as jl:\n",
" for item in jl:\n",
" cur.execute('INSERT INTO data2(id, name) VALUES (?,?)',\n",
" (item['id'], item['name']))\n",
"os.remove('person.jsonlines')"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[('キングレコード', 264, 131),\n",
" ('上松範康', 3064, 118),\n",
" ('藤間仁', 2749, 60),\n",
" ('藤田淳平', 3618, 57),\n",
" ('菊田大介', 7794, 35),\n",
" ('加藤裕介', 10705, 33),\n",
" ('高垣彩陽', 4757, 33),\n",
" ('悠木碧', 5076, 28),\n",
" ('都築真紀', 1414, 27),\n",
" ('堀江由衣', 3970, 26),\n",
" ('吉木絵里子', 11143, 23),\n",
" ('日笠陽子', 5119, 23),\n",
" ('田村ゆかり', 3965, 23),\n",
" ('茅野愛衣', 5847, 22),\n",
" ('南條愛乃', 4792, 22),\n",
" ('藤永龍太郎', 20113, 19),\n",
" ('金子彰史', 7139, 18),\n",
" ('Aniplex', 645, 18),\n",
" ('藤林聖子', 9924, 17),\n",
" ('志倉千代丸', 417, 17),\n",
" ('ヨシダタクミ', 38403, 16),\n",
" ('岩橋星実', 10102, 16),\n",
" ('Seven Arcs', 7117, 15),\n",
" ('しほり', 6999, 15),\n",
" ('Elements Garden', 3619, 15),\n",
" ('小野勝巳', 3206, 15),\n",
" ('吉成鋼', 10006, 14),\n",
" ('中山真斗', 7330, 14),\n",
" ('母里治樹', 13442, 13),\n",
" ('藤本さとる', 8166, 13),\n",
" ('坂田理', 8025, 13),\n",
" ('井口裕香', 4851, 13),\n",
" ('末益涼太', 29719, 12),\n",
" ('Hibiki', 12713, 12),\n",
" ('宮野真守', 4697, 12),\n",
" ('望月俊平', 42616, 11),\n",
" ('青木康哲', 26833, 11),\n",
" ('水瀬いのり', 10868, 11),\n",
" ('EFFY', 10089, 11),\n",
" ('佐藤利奈', 4670, 11),\n",
" ('福田直征', 52482, 10),\n",
" ('普津澤時ヱ門', 26673, 10),\n",
" ('光田史亮', 12286, 10),\n",
" ('飯飼一幸', 11706, 10),\n",
" ('吉田泰三', 10005, 10),\n",
" ('茅原実里', 4421, 10),\n",
" ('福山潤', 3818, 10),\n",
" ('都丸椋太', 34896, 9),\n",
" ('大久保義之', 26238, 9),\n",
" ('今西亨', 22590, 9),\n",
" ('光増ハジメ', 17967, 9),\n",
" ('木曽勇太', 15688, 9),\n",
" ('南田健吾', 15080, 9),\n",
" ('Evan Call', 10895, 9),\n",
" ('上坂すみれ', 7307, 9),\n",
" ('釘宮理恵', 3936, 9),\n",
" ('高山みなみ', 3933, 9),\n",
" ('椛島洋介', 3665, 9),\n",
" ('大河広行', 3095, 9),\n",
" ('草川啓造', 2913, 9),\n",
" ('矢吹俊郎', 2617, 9),\n",
" ('奥田泰弘', 2588, 9),\n",
" ('外崎春雄', 1430, 9),\n",
" ('田中公平', 32, 9),\n",
" ('坂本俊太', 21592, 8),\n",
" ('江幡育子', 10402, 8),\n",
" ('松井五郎', 10088, 8),\n",
" ('齋藤真也', 8925, 8),\n",
" ('志方あきこ', 6510, 8),\n",
" ('早見沙織', 4895, 8),\n",
" ('杉田智和', 4513, 8),\n",
" ('鈴木竜也', 3592, 8),\n",
" ('バンダイナムコエンターテインメント', 3502, 8),\n",
" ('菊谷知樹', 3267, 8),\n",
" ('小室哲哉', 1576, 8),\n",
" ('堀内博之', 858, 8),\n",
" ('西村純二', 853, 8),\n",
" ('亀山俊樹', 77, 8),\n",
" ('ポニーキャニオン', 64, 8),\n",
" ('中島順', 43231, 7),\n",
" ('ハニュー', 40757, 7),\n",
" ('笠井雄太', 35117, 7),\n",
" ('竹田祐介', 35116, 7),\n",
" ('畑智司', 30105, 7),\n",
" ('林隆祥', 27982, 7),\n",
" ('ats-', 23826, 7),\n",
" ('ブシロードミュージック', 16183, 7),\n",
" ('片平真司', 14875, 7),\n",
" ('陶山隼', 14462, 7),\n",
" ('田中宏紀', 12589, 7),\n",
" ('式地幸喜', 12512, 7),\n",
" ('内田孝', 12190, 7),\n",
" ('斉藤良成', 11564, 7),\n",
" ('華原大輔', 10990, 7),\n",
" ('ブシロード', 10556, 7),\n",
" ('40mP', 8890, 7),\n",
" ('内田真礼', 6724, 7),\n",
" ('藤真拓哉', 6040, 7),\n",
" ('寿美菜子', 5118, 7),\n",
" ('井上麻里奈', 4382, 7),\n",
" ('平野綾', 4158, 7),\n",
" ('松尾衡', 2567, 7),\n",
" ('佐藤博暉', 506, 7),\n",
" ('サンライズ', 189, 7),\n",
" ('野村優真', 51075, 6),\n",
" ('T.M.Revolution', 49686, 6),\n",
" ('筒井香織', 31860, 6),\n",
" ('益田賢治', 31250, 6),\n",
" ('橋立佳奈', 29863, 6),\n",
" ('グロービジョン', 25182, 6),\n",
" ('本田敬一', 23376, 6),\n",
" ('飯野まこと', 18772, 6),\n",
" ('大石昌良', 15364, 6),\n",
" ('三宮昌太', 11346, 6),\n",
" ('h-wonder', 11280, 6),\n",
" ('イズミカワソラ', 10953, 6),\n",
" ('川田瑠夏', 9908, 6),\n",
" ('岩里祐穂', 9558, 6),\n",
" ('蒼井翔太', 8545, 6),\n",
" ('マーベラス', 8094, 6),\n",
" ('和田高明', 7519, 6),\n",
" ('前山田健一', 7205, 6),\n",
" ('佐倉綾音', 5745, 6),\n",
" ('菊池志穂', 5280, 6),\n",
" ('豊崎愛生', 5001, 6),\n",
" ('日高里菜', 4962, 6),\n",
" ('阿澄佳奈', 4868, 6),\n",
" ('中原麻衣', 4145, 6),\n",
" ('千葉紗子', 4129, 6),\n",
" ('名塚佳織', 3922, 6),\n",
" ('田中ちゆき', 3713, 6),\n",
" ('神戸洋行', 3678, 6),\n",
" ('篠原愛子', 3561, 6),\n",
" ('塩谷直義', 3498, 6),\n",
" ('浅倉大介', 3250, 6),\n",
" ('伊藤達文', 2992, 6),\n",
" ('稲垣隆行', 1983, 6),\n",
" ('サイトロン・デジタルコンテンツ', 1612, 6),\n",
" ('Production I.G', 1286, 6),\n",
" ('高梨康治', 1120, 6),\n",
" ('今川泰宏', 673, 6),\n",
" ('本山哲', 501, 6),\n",
" ('KID', 415, 6),\n",
" ('松島晃', 274, 6),\n",
" ('浜名孝行', 240, 6),\n",
" ('出渕裕', 43, 6),\n",
" ('金羊社', 43259, 5),\n",
" ('森井佑介', 42740, 5),\n",
" ('太田豊紀', 42735, 5),\n",
" ('金子文雄', 41931, 5),\n",
" ('中西豪', 41556, 5),\n",
" ('三嶋章夫', 39768, 5),\n",
" ('茶之原拓也', 37464, 5),\n",
" ('澤田博範', 37307, 5),\n",
" ('高梨絵美', 28082, 5),\n",
" ('中小路佳毅', 27097, 5),\n",
" ('谷口明弘', 22381, 5),\n",
" ('喜多智弘', 19555, 5),\n",
" ('亀井治', 15926, 5),\n",
" ('渡辺徹', 15035, 5),\n",
" ('徳田夢之介', 14927, 5),\n",
" ('福原綾香', 14780, 5),\n",
" ('杉江敏治', 12195, 5),\n",
" ('阿部望', 11560, 5),\n",
" ('山原一浩', 10999, 5),\n",
" ('六ツ見純代', 10509, 5),\n",
" ('榎本明広', 10258, 5),\n",
" ('古屋真', 9910, 5),\n",
" ('田中隼人', 8911, 5),\n",
" ('筑紫大介', 7521, 5),\n",
" ('赤﨑千夏', 7297, 5),\n",
" ('Funta', 7159, 5),\n",
" ('吉井ダン', 7142, 5),\n",
" ('岡崎律子', 6144, 5),\n",
" ('東山奈央', 6010, 5),\n",
" ('丸山博雄', 5783, 5),\n",
" ('柿原徹也', 4782, 5),\n",
" ('後藤邑子', 4514, 5),\n",
" ('生天目仁美', 4394, 5),\n",
" ('南里侑香', 4356, 5),\n",
" ('栗林みな実', 4330, 5),\n",
" ('喜多村英梨', 4251, 5),\n",
" ('大谷育江', 3906, 5),\n",
" ('桑島法子', 3867, 5),\n",
" ('水橋かおり', 3851, 5),\n",
" ('磯江俊道', 2748, 5),\n",
" ('高木洋', 1990, 5),\n",
" ('服部憲知', 1739, 5),\n",
" ('メモリーテック', 1434, 5),\n",
" ('木谷高明', 1062, 5),\n",
" ('広井王子', 847, 5),\n",
" ('サテライト', 811, 5),\n",
" ('西澤晋', 316, 5),\n",
" ('STAR CHILD', 196, 5),\n",
" ('池田あづさ', 52281, 4),\n",
" ('塩田学', 43401, 4),\n",
" ('木下あすな', 42996, 4),\n",
" ('篠笥和也', 42743, 4),\n",
" ('田中克憲', 42737, 4),\n",
" ('山田竜平', 41683, 4),\n",
" ('宗圓祐輔', 38862, 4),\n",
" ('ハン･ミンギ', 38455, 4),\n",
" ('河村涼子', 37659, 4),\n",
" ('山谷尚人', 37439, 4),\n",
" ('宮崎里美', 37419, 4),\n",
" ('上野励', 36364, 4),\n",
" ('Raychell', 34141, 4),\n",
" ('日比野裕史', 33905, 4),\n",
" ('中西和也', 32387, 4),\n",
" ('飯塚正則', 31867, 4),\n",
" ('黒銀', 28181, 4),\n",
" ('渡部穏寛', 23345, 4),\n",
" ('定松剛', 22688, 4),\n",
" ('三宅雄一郎', 21645, 4),\n",
" ('酒井智史', 21200, 4),\n",
" ('成田歳法', 20264, 4),\n",
" ('溝口雅大', 18486, 4),\n",
" ('山野雅明', 15783, 4),\n",
" ('飯田高広', 14636, 4),\n",
" ('中山敦史', 14065, 4),\n",
" ('大平勉', 12895, 4),\n",
" ('関一彦', 12672, 4),\n",
" ('森悦史', 12605, 4),\n",
" ('山村響', 12569, 4),\n",
" ('谷口繁則', 11792, 4),\n",
" ('宮澤努', 11661, 4),\n",
" ('園田凌士', 11652, 4),\n",
" ('金子秀一', 11599, 4),\n",
" ('鈴木卓也', 11414, 4),\n",
" ('鴨川浩', 11393, 4),\n",
" ('山崎燿', 10550, 4),\n",
" ('HoneyWorks', 9036, 4),\n",
" ('Sony Music Associated Records', 8943, 4),\n",
" ('米倉千尋', 8382, 4),\n",
" ('MAGES.', 7946, 4),\n",
" ('小松未可子', 7498, 4),\n",
" ('angela', 7372, 4),\n",
" ('サンジゲン', 7061, 4),\n",
" ('伊藤賢治', 6827, 4),\n",
" ('fripSide', 6733, 4),\n",
" (\"May'n\", 6086, 4),\n",
" ('Suara', 5913, 4),\n",
" ('彩音', 5860, 4),\n",
" ('沼倉愛美', 5824, 4),\n",
" ('伊藤かな恵', 4949, 4),\n",
" ('那須めぐみ', 4660, 4),\n",
" ('ささきいさお', 4654, 4),\n",
" ('仲西環', 4383, 4),\n",
" ('福圓美里', 4372, 4),\n",
" ('新谷良子', 4305, 4),\n",
" ('斎藤千和', 4249, 4),\n",
" ('鳥海浩輔', 4147, 4),\n",
" ('高木礼子', 3969, 4),\n",
" ('浅野るり', 3946, 4),\n",
" ('田中理恵', 3862, 4),\n",
" ('浅野真澄', 3841, 4),\n",
" ('及川啓', 3673, 4),\n",
" ('安田賢司', 3462, 4),\n",
" ('大久保薫', 3455, 4),\n",
" ('中村慎太郎', 3344, 4),\n",
" ('松竹徳幸', 2878, 4),\n",
" ('松山愛子', 2614, 4),\n",
" ('杉光登', 2544, 4),\n",
" ('JAM Project', 2537, 4),\n",
" ('マジックカプセル', 2370, 4),\n",
" ('吉川浩司', 2304, 4),\n",
" ('塩川貴史', 2209, 4),\n",
" ('金月龍之介', 1803, 4),\n",
" ('北岡正', 1706, 4),\n",
" ('田崎智子', 1416, 4),\n",
" ('佐野広明', 1415, 4),\n",
" ('渡邊哲哉', 1373, 4),\n",
" ('五島翔', 1369, 4),\n",
" ('梅津泰臣', 1354, 4),\n",
" ('黄瀬和哉', 1192, 4),\n",
" ('植田秀仁', 806, 4),\n",
" ('まついひとゆき', 621, 4),\n",
" ('XEBEC', 551, 4),\n",
" ('スクウェア・エニックス', 497, 4),\n",
" ('結城信輝', 479, 4),\n",
" ('大河内一楼', 389, 4),\n",
" ('大橋誉志光', 382, 4),\n",
" ('山口宏', 335, 4),\n",
" ('坂田純一', 306, 4),\n",
" ('下田正美', 278, 4),\n",
" ('岩崎良明', 150, 4),\n",
" ('菅野よう子', 101, 4),\n",
" ('三間雅文', 42, 4),\n",
" ('CLAMP', 39, 4),\n",
" ('葛西さおり', 51950, 3),\n",
" ('清水美友紀', 50971, 3),\n",
" ('小野あゆ美', 50213, 3),\n",
" ('藤田卓也', 44471, 3),\n",
" ('サカノウエヨースケ', 43152, 3),\n",
" ('海野節子', 43146, 3),\n",
" ('兼高里圭', 42879, 3),\n",
" ('Kijibato', 42190, 3),\n",
" ('清水武仁', 40994, 3),\n",
" ('鶴﨑輝一', 40525, 3),\n",
" ('Happy Around!', 38420, 3),\n",
" ('割田圭介', 38189, 3),\n",
" ('宇良隆太', 37811, 3),\n",
" ('今義和', 37466, 3),\n",
" ('福島勇', 37450, 3),\n",
" ('髙部光章', 37438, 3),\n",
" ('今岡大', 37198, 3),\n",
" ('宮嶋仁志', 36849, 3),\n",
" ('小坂倫洋', 36619, 3),\n",
" ('平馬浩司', 35535, 3),\n",
" ('中野領太', 34796, 3),\n",
" ('柴田ユウジ', 33865, 3),\n",
" ('橋本貴吉', 33655, 3),\n",
" ('小林優子', 32500, 3),\n",
" ('陣内美帆', 32446, 3),\n",
" ('青木美穂', 31344, 3),\n",
" ('大河内忍', 30417, 3),\n",
" ('スタジオパストラル', 30369, 3),\n",
" ('澤田美香', 30113, 3),\n",
" ('田中理恵', 29995, 3),\n",
" ('渋谷秀', 29884, 3),\n",
" ('大西健太', 28913, 3),\n",
" ('岩岡夢子', 28906, 3),\n",
" ('高橋優也', 28888, 3),\n",
" ('Roselia', 28358, 3),\n",
" ('小畑賢', 28154, 3),\n",
" ('下條祐未', 28043, 3),\n",
" ('小平麻紀', 27909, 3),\n",
" ('新垣一成', 27842, 3),\n",
" ('黒崎隼人', 27321, 3),\n",
" ('鈴木大介', 27236, 3),\n",
" ('宮浦栗生', 26987, 3),\n",
" ('種村綾隆', 26681, 3),\n",
" ('福永純一', 26334, 3),\n",
" ('吉田巧介', 26248, 3),\n",
" ('花輪美幸', 26208, 3),\n",
" ('田村里美', 25972, 3),\n",
" ('後藤麻梨子', 25577, 3),\n",
" ('海津利子', 25235, 3),\n",
" ('久世岳', 24528, 3),\n",
" ('野亦則行', 24427, 3),\n",
" ('菊池カツヤ', 24391, 3),\n",
" ('吟', 24249, 3),\n",
" ('大久保修一', 24245, 3),\n",
" ('池下博紀', 23476, 3),\n",
" ('宮本崇', 21648, 3),\n",
" ('石川俊介', 21634, 3),\n",
" ('荒井和人', 21507, 3),\n",
" ('小澤和則', 21362, 3),\n",
" ('近藤一英', 21315, 3),\n",
" ('田中唯', 21302, 3),\n",
" ('中島渚', 21289, 3),\n",
" ('戸井田珠里', 21288, 3),\n",
" ('西田美弥子', 21212, 3),\n",
" ('岡村正弘', 19197, 3),\n",
" ('中條美沙', 18093, 3),\n",
" ('武本大介', 16023, 3),\n",
" ('鯉川慎平', 16016, 3),\n",
" ('奥野耕太', 15492, 3),\n",
" ('小澤亜李', 15287, 3),\n",
" ('大山曜', 15058, 3),\n",
" ('乘田拓茂', 14587, 3),\n",
" (\"Bee'\", 14247, 3),\n",
" ('工藤真由', 14085, 3),\n",
" ('園田雅裕', 14064, 3),\n",
" ('志村豪', 14060, 3),\n",
" ('TECHNOBOYS PULCRAFT GREEN-FUND', 13583, 3),\n",
" ('博史池畠', 13170, 3),\n",
" ('横田拓己', 13045, 3),\n",
" ('橋本裕之', 13018, 3),\n",
" ('荒木涼', 12444, 3),\n",
" ('小田裕康', 12433, 3),\n",
" ('畠山茂樹', 12400, 3),\n",
" ('室谷靖', 12280, 3),\n",
" ('牧孝雄', 12263, 3),\n",
" ('三木達也', 12237, 3),\n",
" ('古川知宏', 12229, 3),\n",
" ('野中正幸', 12215, 3),\n",
" ('吉川美貴', 12164, 3),\n",
" ('北村友幸', 11958, 3),\n",
" ('いとうまりこ', 11885, 3),\n",
" ('尾尻進矢', 11664, 3),\n",
" ('加藤友美', 11453, 3),\n",
" ('津熊健徳', 11452, 3),\n",
" ('飯村真一', 11450, 3),\n",
" ('西井正典', 11232, 3),\n",
" ('渡邉美佳', 10997, 3),\n",
" ('櫻井真一', 10947, 3),\n",
" ('川原智弘', 10894, 3),\n",
" ('松本ヨシロウ', 10809, 3),\n",
" ('佐藤晃', 10807, 3),\n",
" ('古川貴浩', 10573, 3),\n",
" ('木本慶子', 9981, 3),\n",
" ('太田雅友', 9570, 3),\n",
" ('宮崎誠', 9557, 3),\n",
" ('奈良悠樹', 9556, 3),\n",
" ('藤末樹', 9060, 3),\n",
" ('林ゆうき', 9055, 3),\n",
" ('Good Smile Company', 9020, 3),\n",
" ('烏宏明', 8546, 3),\n",
" ('種田梨沙', 8138, 3),\n",
" ('橋本昌和', 7822, 3),\n",
" ('阿保剛', 7337, 3),\n",
" ('麻生夏子', 6389, 3),\n",
" ('ELISA', 6353, 3),\n",
" ('中川翔子', 6320, 3),\n",
" ('西浦智仁', 6129, 3),\n",
" ('寺岡賢司', 6113, 3),\n",
" ('草薙', 5992, 3),\n",
" ('前田俊博', 5774, 3),\n",
" ('秋田まどか', 5569, 3),\n",
" ('岩村剛士', 5058, 3),\n",
" ('佐藤聡美', 5003, 3),\n",
" ('間宮くるみ', 4948, 3),\n",
" ('戸松遥', 4856, 3),\n",
" ('谷山紀章', 4678, 3),\n",
" ('斎藤桃子', 4676, 3),\n",
" ('永野善一', 4608, 3),\n",
" ('水沢史絵', 4455, 3),\n",
" ('平川大輔', 4452, 3),\n",
" ('伊藤静', 4272, 3),\n",
" ('間島淳司', 4264, 3),\n",
" ('沢城みゆき', 4244, 3),\n",
" ('加藤奈々絵', 4239, 3),\n",
" ('神谷浩史', 4232, 3),\n",
" ('福井裕佳梨', 4185, 3),\n",
" ('桑谷夏子', 4168, 3),\n",
" ('森久保祥太郎', 4166, 3),\n",
" ('望月久代', 4161, 3),\n",
" ('神崎ちろ', 4160, 3),\n",
" ('石川英郎', 4151, 3),\n",
" ('かかずゆみ', 4097, 3),\n",
" ('櫻井孝宏', 4015, 3),\n",
" ('柚木涼香', 4007, 3),\n",
" ('井上喜久子', 3945, 3),\n",
" ('石田彰', 3927, 3),\n",
" ('林原めぐみ', 3919, 3),\n",
" ('久川綾', 3875, 3),\n",
" ('前嶋康明', 3814, 3),\n",
" ('小森篤', 3737, 3),\n",
" ('石田啓一', 3725, 3),\n",
" ('萌木原ふみたけ', 3708, 3),\n",
" ('井内舞子', 3610, 3),\n",
" ('実原登', 3583, 3),\n",
" ('下川直哉', 3536, 3),\n",
" ('杉本功', 3334, 3),\n",
" ('5pb.', 3229, 3),\n",
" ('ドワンゴ', 3023, 3),\n",
" ('友岡新平', 3015, 3),\n",
" ('松浦有希', 2990, 3),\n",
" ('大塚舞', 2901, 3),\n",
" ('水谷広実', 2839, 3),\n",
" ('松岡純也', 2797, 3),\n",
" ('衣笠道雄', 2796, 3),\n",
" ('小野学', 2718, 3),\n",
" ('秋元康', 2706, 3),\n",
" ('福田道生', 2610, 3),\n",
" ('藤咲淳一', 2474, 3),\n",
" ('小林一三', 2326, 3),\n",
" ('成田巧', 2325, 3),\n",
" ('ロマン・トマ', 1789, 3),\n",
" ('渡辺浩二', 1737, 3),\n",
" ('芦野芳晴', 1732, 3),\n",
" ('佐藤真人', 1570, 3),\n",
" ('SEGA', 1541, 3),\n",
" ('二村秀樹', 1309, 3),\n",
" ('中野典克', 1298, 3),\n",
" ('久米一成', 1201, 3),\n",
" ('宮川泰', 1193, 3),\n",
" ('追崎史敏', 1165, 3),\n",
" ('小坂春女', 1092, 3),\n",
" ('山岡信一', 1090, 3),\n",
" ('多田彰文', 778, 3),\n",
" ('川澄綾子', 740, 3),\n",
" ('武内宣之', 734, 3),\n",
" ('福田己津央', 707, 3),\n",
" ('水島努', 623, 3),\n",
" ('うえだしげる', 502, 3),\n",
" ('明田川仁', 477, 3),\n",
" ('大川七瀬', 380, 3),\n",
" ('根岸貴幸', 379, 3),\n",
" ('斉藤恒芳', 368, 3),\n",
" ('柳沢まさひで', 273, 3),\n",
" ('後藤隆幸', 248, 3),\n",
" ('前田明寿', 195, 3),\n",
" ('南伸一郎', 194, 3),\n",
" ('ランティス', 57, 3),\n",
" ('横瀬潤', 52582, 2),\n",
" ('小市由佳', 51308, 2),\n",
" ('高橋紀子', 51259, 2),\n",
" ('荒川理恵', 50822, 2),\n",
" ('長嶋凌', 50425, 2),\n",
" ('大田明日香', 50365, 2),\n",
" ('瓜生恭子', 50231, 2),\n",
" ('嵩本樹', 49753, 2),\n",
" ('藤原千帆', 48681, 2),\n",
" ('白鳥弘公', 48526, 2),\n",
" ('西正悟', 48300, 2),\n",
" ('北村翔太郎', 46538, 2),\n",
" ('BOUNCEBACK', 46536, 2),\n",
" ('米澤怜美', 46500, 2),\n",
" ('ウィッチクラフト', 45388, 2),\n",
" ('たかはしゆう', 45304, 2),\n",
" ('平朋崇', 44622, 2),\n",
" ('山本玲史', 44456, 2),\n",
" ('浦田幸博', 44163, 2),\n",
" ('高市彩加', 43950, 2),\n",
" ('紫灯珈', 43949, 2),\n",
" ('松本淑恵', 43924, 2),\n",
" ('梅村妃奈子', 43906, 2),\n",
" ('桑原麻衣', 43765, 2),\n",
" ('森いづみ', 43665, 2),\n",
" ('服部未夢', 43468, 2),\n",
" ('西部師経', 43454, 2),\n",
" ('上赤由香里', 43435, 2),\n",
" ('増田俊介', 43427, 2),\n",
" ('矢田起也', 43425, 2),\n",
" ('鈴木莉乃', 43411, 2),\n",
" ('清水椋大', 43405, 2),\n",
" ('福田佳太', 43281, 2),\n",
" ('犬塚政彦', 43189, 2),\n",
" ('OVERHEAD CHAMPION', 43157, 2),\n",
" ('國松聖士', 43142, 2),\n",
" ('今牧千世', 43092, 2),\n",
" ('熊谷勇也', 43080, 2),\n",
" ('松本智', 43027, 2),\n",
" ('山田香央里', 43014, 2),\n",
" ('野村優貴', 42981, 2),\n",
" ('金丸綾子', 42971, 2),\n",
" ('谷口りつ子', 42969, 2),\n",
" ('垣内彩子', 42968, 2),\n",
" ('大西麻衣子', 42903, 2),\n",
" ('若菜宣典', 42891, 2),\n",
" ('大原和男', 42873, 2),\n",
" ('大森亘', 42862, 2),\n",
" ('川本和隆', 42789, 2),\n",
" ('中川実', 42696, 2),\n",
" ('幡野雄亮', 42667, 2),\n",
" ('桐谷真咲', 42591, 2),\n",
" ('長田信博', 41812, 2),\n",
" ('須川康太', 41229, 2),\n",
" ('水谷有吾', 40834, 2),\n",
" ('tofu', 40311, 2),\n",
" ('志賀健太郎', 38323, 2),\n",
" ('森田侑希', 38087, 2),\n",
" ('児玉亮', 37976, 2),\n",
" ('柏木信弘', 37915, 2),\n",
" ('鍵山亜子', 37796, 2),\n",
" ('吉木正行', 37794, 2),\n",
" ('依田祐輔', 37710, 2),\n",
" ('鈴木佳代子', 37706, 2),\n",
" ('山田龍太郎', 37530, 2),\n",
" ('金城優', 37465, 2),\n",
" ('浅川翔', 37416, 2),\n",
" ('中山みゆき', 37329, 2),\n",
" ('山田雄一郎', 37269, 2),\n",
" ('陳亮', 37266, 2),\n",
" ('澤井真紀', 37025, 2),\n",
" ('石川達也', 37006, 2),\n",
" ('日比政広', 36945, 2),\n",
" ('多田周平', 36500, 2),\n",
" ('清水奏太郎', 36373, 2),\n",
" ('松尾真彦', 36337, 2),\n",
" ('榎田美咲', 35690, 2),\n",
" ('鈴木麻希子', 35531, 2),\n",
" ('梅本賢一', 35472, 2),\n",
" ('石黒達也', 35459, 2),\n",
" ('工藤公聖', 34532, 2),\n",
" ('安達祐輔', 34452, 2),\n",
" ('耳浦朋彰', 34451, 2),\n",
" ('平沢晃弘', 34442, 2),\n",
" ('長田伸二', 34317, 2),\n",
" ('山岸正和', 34272, 2),\n",
" (\"One's work\", 33699, 2),\n",
" ('高嶋宏之', 33697, 2),\n",
" ('魏斯曼', 33680, 2),\n",
" ('瀬口泉', 33643, 2),\n",
" ('中島大智', 33635, 2),\n",
" ('黄霑', 33298, 2),\n",
" ('光譜資訊', 32699, 2),\n",
" ('シナリオ工房 月光', 32598, 2),\n",
" ('挽本敦子', 32499, 2),\n",
" ('高橋靖子', 32473, 2),\n",
" ('柴田太郎', 32414, 2),\n",
" ('河野絵美', 32402, 2),\n",
" ('桜井英朗', 32389, 2),\n",
" ('針場裕子', 32017, 2),\n",
" ('境成美', 31916, 2),\n",
" ('安本学', 31815, 2),\n",
" ('小原和大', 31792, 2),\n",
" ('沖田英一', 31733, 2),\n",
" ('澤崎誠', 31729, 2),\n",
" ('Kon-K', 31653, 2),\n",
" ('倉谷亮多', 31635, 2),\n",
" ('和田俊也', 31264, 2),\n",
" ('村上直紀', 30921, 2),\n",
" ('古池敏也', 30744, 2),\n",
" ('橋口隼人', 30556, 2),\n",
" ('加藤弘将', 30401, 2),\n",
" ('中村航', 30317, 2),\n",
" ('平野宏樹', 29724, 2),\n",
" ('中熊太一', 29418, 2),\n",
" ('阿久悠', 29236, 2),\n",
" ('金平和茂', 28890, 2),\n",
" ('清水博幸', 28840, 2),\n",
" ('伊東広道', 28713, 2),\n",
" ('ハロー、ハッピーワールド！', 28359, 2),\n",
" ('Pastel＊Palettes', 28357, 2),\n",
" ('Afterglow', 28353, 2),\n",
" ('高鉾誠', 28229, 2),\n",
" ('幸田直子', 28227, 2),\n",
" ('球野貴裕', 28205, 2),\n",
" ('森中正春', 28139, 2),\n",
" ('横田知加子', 28048, 2),\n",
" ('塚本倫基', 27926, 2),\n",
" ('池原百合子', 27922, 2),\n",
" ('小橋陽介', 27827, 2),\n",
" ('齋藤温子', 27798, 2),\n",
" ('木村豪', 27647, 2),\n",
" ('雨宮英雄', 27423, 2),\n",
" ('髙橋瑞紀', 27320, 2),\n",
" ('江野沢柚美', 27299, 2),\n",
" (\"Poppin'Party\", 27251, 2),\n",
" ('藤井亮太', 26844, 2),\n",
" ('渡辺一平太', 26801, 2),\n",
" ('石井ゆみこ', 26638, 2),\n",
" ('田辺茂範', 26628, 2),\n",
" ('矢花馨', 26570, 2),\n",
" ('清水一伸', 26568, 2),\n",
" ('鈴木廉太', 26553, 2),\n",
" ('清水智子', 26433, 2),\n",
" ('安藤尚也', 26386, 2),\n",
" ('柴田健児', 26221, 2),\n",
" ('小林浩輔', 25997, 2),\n",
" ('工藤友靖', 25838, 2),\n",
" ('佐土原武之', 25550, 2),\n",
" ('永吉隆志', 25539, 2),\n",
" ('萬直樹', 25480, 2),\n",
" ('Scott MacDonald', 25414, 2),\n",
" ('永井真吾', 25327, 2),\n",
" ('saji', 24920, 2),\n",
" ('大塚美登理', 24836, 2),\n",
" ('山内東生雄', 24823, 2),\n",
" ('藤崎賢二', 24247, 2),\n",
" ('杉村友和', 23708, 2),\n",
" ('KING AMUSEMENT CREATIVE', 23237, 2),\n",
" ('空賀萌香', 22965, 2),\n",
" ('小川優樹', 22605, 2),\n",
" ('岸川寛良', 22419, 2),\n",
" ('朴性厚', 22074, 2),\n",
" ('久保山英一', 21657, 2),\n",
" ('野道佳代', 21588, 2),\n",
" ('市村徹夫', 21324, 2),\n",
" ('玉川真吾', 21296, 2),\n",
" ('島袋智和', 21182, 2),\n",
" ('山村俊了', 21176, 2),\n",
" ('青柳宏宜', 21171, 2),\n",
" ('町谷俊輔', 21169, 2),\n",
" ('北條直明', 21155, 2),\n",
" ('細越裕治', 21015, 2),\n",
" ('下司泰弘', 20998, 2),\n",
" ('小宮有紗', 20952, 2),\n",
" ('安藤貴史', 20846, 2),\n",
" ('村上正博', 20778, 2),\n",
" ('蛭川幸太郎', 20637, 2),\n",
" ('武宮むつみ', 20395, 2),\n",
" ('原修一', 20255, 2),\n",
" ('イシイジロウ', 20156, 2),\n",
" ('猪原健太', 20151, 2),\n",
" ('丸山由紀子', 20131, 2),\n",
" ('黎小田', 19730, 2),\n",
" ('田所修', 19637, 2),\n",
" ('アベユーイチ', 19300, 2),\n",
" ('鳥羽聡', 19297, 2),\n",
" ('長町英樹', 19140, 2),\n",
" ('西野文那', 19090, 2),\n",
" ('高橋知也', 18896, 2),\n",
" ('芳賀政哉', 18654, 2),\n",
" ('平峯義大', 18570, 2),\n",
" ('山﨑佳祐', 18544, 2),\n",
" ('鈴木大輔', 18491, 2),\n",
" ('三輪清宗', 18488, 2),\n",
" ('吉岡毅', 18484, 2),\n",
" ('星野円哉', 18416, 2),\n",
" ('mitsuyuki miyake', 18177, 2),\n",
" ('Orangestar', 17543, 2),\n",
" ('岩崎光洋', 16095, 2),\n",
" ('山本善哉', 16018, 2),\n",
" ('CooRie', 15867, 2),\n",
" ('岩井俊二', 15860, 2),\n",
" ('Eve', 15720, 2),\n",
" ('小野早香', 15455, 2),\n",
" ('火狗創意有限公司', 15370, 2),\n",
" ('枡田邦彰', 15269, 2),\n",
" ('伊橋成哉', 15155, 2),\n",
" ('鳥居貴史', 15115, 2),\n",
" ('avex pictures', 14945, 2),\n",
" ('陰陽座', 14838, 2),\n",
" ('寺尾洋之', 14744, 2),\n",
" ('ivory', 14710, 2),\n",
" ('伊東大和', 14638, 2),\n",
" ('雅智弥', 14637, 2),\n",
" ('滝山真哲', 14541, 2),\n",
" ('木村篤史', 14517, 2),\n",
" ('本田晃弘', 14489, 2),\n",
" ('筒美京平', 14410, 2),\n",
" ('小倉宏文', 14401, 2),\n",
" ('ORANGE RANGE', 14381, 2),\n",
" ('古田丈司', 14223, 2),\n",
" ('平栁悟', 14176, 2),\n",
" ('Goose house', 14083, 2),\n",
" ('川島勝', 14073, 2),\n",
" ('甲斐政俊', 13987, 2),\n",
" ('三宅和男', 13979, 2),\n",
" ('坂本久美子', 13974, 2),\n",
" ('池田晃久', 13936, 2),\n",
" ('八瀬祐樹', 13817, 2),\n",
" ('園田健太郎', 13811, 2),\n",
" ('オオヤギヒロオ', 13778, 2),\n",
" ('岸村正実', 13604, 2),\n",
" ('かなでももこ', 13511, 2),\n",
" ('ヤマトナオミチ', 13485, 2),\n",
" ('江上夏樹', 13460, 2),\n",
" ('F.I.X. Records', 13358, 2),\n",
" ('畑博之', 13338, 2),\n",
" ('阿部智之', 13076, 2),\n",
" ('有江勇樹', 13019, 2),\n",
" ('三浦貴博', 12920, 2),\n",
" ('山本浩憲', 12789, 2),\n",
" ('村上竜之介', 12762, 2),\n",
" ('奥田陽介', 12757, 2),\n",
" ('山口智', 12590, 2),\n",
" ('若林信', 12586, 2),\n",
" ('エピックレコードジャパン', 12541, 2),\n",
" ('小島崇史', 12524, 2),\n",
" ('砂川正和', 12520, 2),\n",
" ('しんぼたくろう', 12502, 2),\n",
" ('池田ひとみ', 12417, 2),\n",
" ('出雲範子', 12381, 2),\n",
" ('重松晋一', 12305, 2),\n",
" ('相坂ナオキ', 12304, 2),\n",
" ('夕澄慶英', 12296, 2),\n",
" ('斉藤雅和', 12254, 2),\n",
" ('吉田亘良', 12230, 2),\n",
" ('加藤剣', 12228, 2),\n",
" ('高瀬健一', 12226, 2),\n",
" ('石井和彦', 12004, 2),\n",
" ('友田政晴', 11984, 2),\n",
" ('斎藤大輔', 11960, 2),\n",
" ('桜井木の実', 11936, 2),\n",
" ('片岡康治', 11912, 2),\n",
" ('甲田雅人', 11904, 2),\n",
" ('崎山知明', 11850, 2),\n",
" ('安藤義信', 11820, 2),\n",
" ('須江信人', 11793, 2),\n",
" ('柳瀬譲二', 11776, 2),\n",
" ('小倉一男', 11729, 2),\n",
" ('清水空翔', 11712, 2),\n",
" ('定井秀樹', 11707, 2),\n",
" ('島津裕行', 11704, 2),\n",
" ('糸島雅彦', 11594, 2),\n",
" ('宮沢康紀', 11578, 2),\n",
" ('久野美咲', 11523, 2),\n",
" ('小林冬至生', 11384, 2),\n",
" ('舘崎大', 11370, 2),\n",
" ('板垣祐介', 11332, 2),\n",
" ('辻純更', 11238, 2),\n",
" ('川面恒介', 11075, 2),\n",
" ('長田直之', 10988, 2),\n",
" ('添田啓二', 10979, 2),\n",
" ('堺香子', 10978, 2),\n",
" ('石川真也', 10975, 2),\n",
" ('有森聡美', 10942, 2),\n",
" ('末廣健一郎', 10850, 2),\n",
" ('UVERworld', 10842, 2),\n",
" ('サクセス', 10817, 2),\n",
" ('松尾ゆきひろ', 10793, 2),\n",
" ('丸田新', 10788, 2),\n",
" ('原一博', 10765, 2),\n",
" ('山下洋介', 10704, 2),\n",
" ('河合英嗣', 10608, 2),\n",
" ('高橋ひろ', 10551, 2),\n",
" ('只野菜摘', 10397, 2),\n",
" ('渡辺未来', 10396, 2),\n",
" ('一色由比', 10328, 2),\n",
" ('Fukase', 10294, 2),\n",
" ('松本麻友子', 10189, 2),\n",
" ('今泉洋', 9983, 2),\n",
" ('大森祥子', 9933, 2),\n",
" ('上杉洋史', 9926, 2),\n",
" ('EasyPop', 9892, 2),\n",
" ('伊藤祐毅', 9871, 2),\n",
" ('輿水隆之', 9803, 2),\n",
" ('ゆよゆっぺ', 9693, 2),\n",
" ('Neru', 9313, 2),\n",
" ('熊谷純', 9215, 2),\n",
" ('村川梨衣', 9096, 2),\n",
" ('津田尚克', 9095, 2),\n",
" ('俊龍', 9070, 2),\n",
" ('黒うさP', 8882, 2),\n",
" ('鈴木寿枝', 8864, 2),\n",
" ('石渡マコト', 8766, 2),\n",
" ('みきとP', 8463, 2),\n",
" ('ZAQ', 8336, 2),\n",
" ('GRANRODEO', 8249, 2),\n",
" ('黒崎真音', 8188, 2),\n",
" ('こだまさおり', 7970, 2),\n",
" ('武井宏之', 7845, 2),\n",
" ('小岩井ことり', 7837, 2),\n",
" ('水上悟志', 7768, 2),\n",
" ('鷲尾直広', 7661, 2),\n",
" ('BANPRESTO', 7587, 2),\n",
" ('秋田谷典昭', 7549, 2),\n",
" ('緋賀ゆかり', 7513, 2),\n",
" ('日野晃博', 7475, 2),\n",
" ('小高光太郎', 7456, 2),\n",
" ('高橋洋子', 7373, 2),\n",
" ('上原れな', 7368, 2),\n",
" ('河井英里', 7367, 2),\n",
" ('Zwei', 7340, 2),\n",
" ('畑亜貴', 7329, 2),\n",
" ('あいだ夏波', 7289, 2),\n",
" ('徳井青空', 7278, 2),\n",
" ('松田彬人', 7143, 2),\n",
" ('エンカレッジフィルムズ', 7141, 2),\n",
" ('小池智史', 7140, 2),\n",
" ('藍井エイル', 7124, 2),\n",
" ('ChouCho', 6998, 2),\n",
" ('石川智晶', 6596, 2),\n",
" ('美郷あき', 6507, 2),\n",
" ('小倉唯', 6447, 2),\n",
" ('高瀬一矢', 6402, 2),\n",
" ('DECO*27', 6231, 2),\n",
" ('A・C・G・T', 6093, 2),\n",
" ('柳瀬敬之', 6087, 2),\n",
" ('大河原邦男', 6061, 2),\n",
" ('佐藤ひろ美', 6029, 2),\n",
" ('Kalafina', 6014, 2),\n",
" ('いとうかなこ', 5882, 2),\n",
" ('結城アイラ', 5873, 2),\n",
" ('岩上敦宏', 5782, 2),\n",
" (\"I've\", 5775, 2),\n",
" ('瀬戸麻沙美', 5766, 2),\n",
" ('川田まみ', 5747, 2),\n",
" ('KOTOKO', 5733, 2),\n",
" ('石川由依', 5727, 2),\n",
" ('佐藤広太', 5700, 2),\n",
" ('高橋伸也', 5137, 2),\n",
" ('藤田咲', 5014, 2),\n",
" ('沖佳苗', 4960, 2),\n",
" ('中島愛', 4953, 2),\n",
" ('榊原ゆい', 4916, 2),\n",
" ('樹元オリエ', 4867, 2),\n",
" ('高梁碧', 4781, 2),\n",
" ('大原桃子', 4780, 2),\n",
" ('浅沼晋太郎', 4779, 2),\n",
" ('宮崎羽衣', 4773, 2),\n",
" ('後藤沙緒里', 4772, 2),\n",
" ('井ノ上奈々', 4745, 2),\n",
" ('小野涼子', 4727, 2),\n",
" ('森永理科', 4695, 2),\n",
" ('三瓶由布子', 4667, 2),\n",
" ('本名陽子', 4539, 2),\n",
" ('小清水亜美', 4474, 2),\n",
" ('小野大輔', 4456, 2),\n",
" ('野川さくら', 4433, 2),\n",
" ('高橋美佳子', 4412, 2),\n",
" ('rino', 4387, 2),\n",
" ('山本麻里安', 4385, 2),\n",
" ('稲田徹', 4373, 2),\n",
" ('野中藍', 4371, 2),\n",
" ('松来未祐', 4353, 2),\n",
" ('こやまきみこ', 4326, 2),\n",
" ('鈴村健一', 4311, 2),\n",
" ('植田佳奈', 4263, 2),\n",
" ('池澤春菜', 4230, 2),\n",
" ('陶山章央', 4221, 2),\n",
" ('広橋涼', 4165, 2),\n",
" ('三木眞一郎', 4101, 2),\n",
" ('桃井はるこ', 3993, 2),\n",
" ('高橋広樹', 3979, 2),\n",
" ('置鮎龍太郎', 3976, 2),\n",
" ('緑川光', 3967, 2),\n",
" ('浅川悠', 3958, 2),\n",
" ('吉野裕行', 3955, 2),\n",
" ('山寺宏一', 3914, 2),\n",
" ('野田順子', 3905, 2),\n",
" ('諏訪部順一', 3864, 2),\n",
" ('氷上恭子', 3859, 2),\n",
" ('真田アサミ', 3847, 2),\n",
" ('能登麻美子', 3827, 2),\n",
" ('木下由美子', 3754, 2),\n",
" ('山本靖貴', 3681, 2),\n",
" ('カワタヒサシ', 3620, 2),\n",
" ('鎌池和馬', 3608, 2),\n",
" ('植松伸夫', 3584, 2),\n",
" ('藤澤健至', 3581, 2),\n",
" ('加々美高浩', 3553, 2),\n",
" ('大澤信博', 3548, 2),\n",
" ('大槻敦史', 3520, 2),\n",
" ('樋口達人', 3495, 2),\n",
" ('なかじまちゅうじ', 3474, 2),\n",
" ('沼田誠也', 3447, 2),\n",
" ('小杉保夫', 3398, 2),\n",
" ('夏目公一朗', 3350, 2),\n",
" ('原田大基', 3314, 2),\n",
" ('星野桂', 3207, 2),\n",
" ('雑破業', 3148, 2),\n",
" ('石川光久', 3133, 2),\n",
" ('三澤康広', 3060, 2),\n",
" ('ufotable', 3059, 2),\n",
" ('竹内哲也', 3047, 2),\n",
" ('石原恵治', 2884, 2),\n",
" ('千葉崇洋', 2848, 2),\n",
" ('毎日放送', 2847, 2),\n",
" ('もといぎひろあき', 2770, 2),\n",
" ('佐藤直子', 2763, 2),\n",
" ('佐久間正英', 2705, 2),\n",
" ('細田直人', 2696, 2),\n",
" ('青山弘', 2681, 2),\n",
" ('荒井栄児', 2629, 2),\n",
" ('はしもとなおと', 2622, 2),\n",
" ('前澤弘美', 2587, 2),\n",
" ('赤間三佐子', 2576, 2),\n",
" ('高寺たけし', 2511, 2),\n",
" ('志村錠児', 2479, 2),\n",
" ('中山岳洋', 2361, 2),\n",
" ('宇佐美皓一', 2212, 2),\n",
" ('青野厚司', 1963, 2),\n",
" ('大倉雅彦', 1930, 2),\n",
" ('大河原晴男', 1814, 2),\n",
" ('影山ヒロノブ', 1782, 2),\n",
" ('千住明', 1762, 2),\n",
" ('今石洋之', 1755, 2),\n",
" ('小原正和', 1722, 2),\n",
" ('板垣伸', 1663, 2),\n",
" ('池端隆史', 1614, 2),\n",
" ('高見明男', 1563, 2),\n",
" ('塩屋翼', 1452, 2),\n",
" ('早坂律子', 1449, 2),\n",
" ('羽原信義', 1418, 2),\n",
" ('小寺勝之', 1328, 2),\n",
" ('高木弘樹', 1305, 2),\n",
" ('太田雅彦', 1294, 2),\n",
" ('feel.', 1275, 2),\n",
" ('ZIZZ STUDIO', 1273, 2),\n",
" ('今西隆志', 1252, 2),\n",
" ('増永計介', 1218, 2),\n",
" ('斉藤恵', 1180, 2),\n",
" ('増井壮一', 1170, 2),\n",
" ('大森英敏', 1144, 2),\n",
" ('小林誠', 1106, 2),\n",
" ('江上潔', 1097, 2),\n",
" ('子安武人', 1096, 2),\n",
" ('岸本誠司', 1038, 2),\n",
" ('佐藤直紀', 919, 2),\n",
" ('阿部雅司', 867, 2),\n",
" ('中田亮大', 856, 2),\n",
" ('海谷敏久', 843, 2),\n",
" ('白根秀樹', 821, 2),\n",
" ('木村暢', 709, 2),\n",
" ('新房昭之', 692, 2),\n",
" ('大畑清隆', 687, 2),\n",
" ('MADHOUSE', 603, 2),\n",
" ('水島精二', 575, 2),\n",
" ('米村正二', 571, 2),\n",
" ('下地志直', 552, 2),\n",
" ('GONZO', 541, 2),\n",
" ('本郷みつる', 522, 2),\n",
" ('石原満', 474, 2),\n",
" ('木村貴宏', 419, 2),\n",
" ('アクアプラス', 406, 2),\n",
" ('松浦裕暁', 399, 2),\n",
" ('藤田まり子', 385, 2),\n",
" ('中村隆太郎', 359, 2),\n",
" ('朝倉紀行', 334, 2),\n",
" ('後藤圭二', 305, 2),\n",
" ('中嶋敦子', 276, 2),\n",
" ('小林利充', 275, 2),\n",
" ('馬飼野康二', 258, 2),\n",
" ('浦畑達彦', 233, 2),\n",
" ('岩浪美和', 231, 2),\n",
" ('日本コロムビア', 228, 2),\n",
" ('ジェンコ', 220, 2),\n",
" ('国崎久徳', 190, 2),\n",
" ('渡部高志', 172, 2),\n",
" ('OLM', 166, 2),\n",
" ('高橋ナオヒト', 161, 2),\n",
" ('甲斐けいこ', 134, 2),\n",
" ('村田俊治', 132, 2),\n",
" ('藤島康介', 124, 2),\n",
" ('川元利浩', 102, 2),\n",
" ('荒川稔久', 74, 2),\n",
" ('バンダイビジュアル', 56, 2),\n",
" ('花田未央', 52632, 1),\n",
" ('藤田麗子', 52618, 1),\n",
" ('趙杰', 52585, 1),\n",
" ('張金浩', 52579, 1),\n",
" ('包国成', 52485, 1),\n",
" ('唐遠界', 52484, 1),\n",
" ('木村仁哉', 52474, 1),\n",
" ...]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"person_id = 1 # query by ID - 水樹奈々\n",
"query = \"\"\"\n",
" SELECT name, id, Count(*) \n",
" FROM data, data2 \n",
" WHERE person_id = id \n",
" AND person_id != ?1 \n",
" AND subject_id IN (SELECT subject_id \n",
" FROM data \n",
" WHERE person_id = ?1) \n",
" GROUP BY id \n",
" ORDER BY Count(*) DESC\n",
" \"\"\"\n",
"res = cur.execute(query, (person_id,)).fetchall()\n",
"res # 人名，ID，合作次数"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.10.6"
},
"orig_nbformat": 4
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment