Separate `ohioctapp` dockets holding clusters from different cases

[grossir]

Describe the issue.

Affects 316 dockets

The bug that generated these incorrect docket assignments was already patched in CL and juriscraper

Query and sample

SELECT
    docket_number, docket_id, count(*), array_agg(distinct(case_name))
FROM 
    search_opinioncluster
INNER JOIN (
    SELECT court_id, id as docket_id, docket_number
    FROM search_docket 
    WHERE court_id = 'ohioctapp'
) a USING (docket_id)
GROUP BY
    docket_number, docket_id
HAVING count(distinct(case_name)) > 1
ORDER BY 3 DESC
;

-[ RECORD 1 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 28
docket_id     | 2351656
count         | 4
array_agg     | {"People v. Brown","People v. Patrick Labate","The People v. Thomas P. Perdue"}
-[ RECORD 2 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 27
docket_id     | 2311070
count         | 4
array_agg     | {"Rosenblum v. Conflicts of Interest Board","Taxi Tours v. Go New York Tours , Go New York Tours v. Big Bus Tours Limited","The People v. Anthony Debellis","The People v. Anthony DeBellis"}
-[ RECORD 3 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 41
docket_id     | 2313430
count         | 4
array_agg     | {"Bissell v. Town of Amherst","The People v. Dwight Reid","The People v. Kenneth E. Fisher"}
-[ RECORD 4 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 12
docket_id     | 2633903
count         | 3
array_agg     | {"In the Matter of Veronica P. v. Radcliff A.","The People v. Danny Novas","The People v. Santino Guerra"}
-[ RECORD 5 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 21
docket_id     | 2309587
count         | 3
array_agg     | {"Eastside Exhibition Corp. v. 210 East 86th Street Corp.","Lujerio Cordero v. Transamerica Annuity Service Corporation","The People v. Jonaiki Martinez Estrella"}
-[ RECORD 6 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 50
docket_id     | 176080
count         | 3
array_agg     | {"People v. Carr","The People v. Christopher J. Weber","The People v. Samual Nektalov"}
-[ RECORD 7 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 22
docket_id     | 3038338
count         | 3
array_agg     | {"Daler Singh v. City of New York","The People v. Jason Bohn","The People v. Oscar Sanders"}
-[ RECORD 8 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 17
docket_id     | 3037451
count         | 3
array_agg     | {"Favourite Limited v. Benedetto Cico","The People v. Christopher A. Nicholson","The People v. Mark A. Hartle"}
-[ RECORD 9 ]-+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 13
docket_id     | 2633904
count         | 3
array_agg     | {"In the Matter of Tyrone D. v. State of New York","The Matter of TCR Sports Broadcasting Holding v. WN Partner","The People v. Fernando Ramirez"}
-[ RECORD 10 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 59
docket_id     | 2656105
count         | 3
array_agg     | {"Alison Regan v. W Associates","Andrew Nitkewicz v. Lincoln Life & Annuity Company of New York","Matter of Luther Dempsey v. New York City Department of Education"}
-[ RECORD 11 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 25
docket_id     | 2351791
count         | 3
array_agg     | {"People v. Kisina","The Matter of Anne Marie R. Colon v. Teachers' Retirement System of the City of New York","The People v. .Yermia Solomon, a/k/a Jeremy Solomon"}
-[ RECORD 12 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 26
docket_id     | 1963852
count         | 3
array_agg     | {"Glacial Aggregates LLC v. Town of Yorkshire","The Matter of Edwin Agramonte v. Local 461, District Council 37","The Matter of the Estate of Maika"}
-[ RECORD 13 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 38
docket_id     | 1137365
count         | 3
array_agg     | {"Ovitz v. Bloomberg L.P.","The People v. David Williams","The People v. Michael Saenger"}
-[ RECORD 14 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 39
docket_id     | 1082102
count         | 3
array_agg     | {"Teodorescu v. Resnick & Binder, P.C.","The Matter of Patrick J. Lynch v. City of New York","The People v. Cid C. Franklin"}
-[ RECORD 15 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 40
docket_id     | 1889099
count         | 3
array_agg     | {"People v. Zephrin","the Matter of Teamsters Local 445 v. Town of Monroe","The People v. Yasif Sims"}
-[ RECORD 16 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 42
docket_id     | 1451336
count         | 3
array_agg     | {"The People v. Corey Dunton","The People v. Diane Wells","The People v. Hanza Muhammad"}
-[ RECORD 17 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 43
docket_id     | 1889083
count         | 3
array_agg     | {"People v. Mothersell","the Matter of St. Lawrence County v. City of Ogdensburg","The People v. Fabian Greene"}
-[ RECORD 18 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 69
docket_id     | 2395115
count         | 3
array_agg     | {"In the Matter of Afton C.","The People v. Jean Dufresne","The People v. Sergio Cerda"}
-[ RECORD 19 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 14
docket_id     | 2310883
count         | 3
array_agg     | {"Matter of Cappellino v. Baumann & Sons Bus Company","The People v. Dakota W. Baldwin","The People v. Jayquaine Seignious"}
-[ RECORD 20 ]+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
docket_number | 70
docket_id     | 2351139
count         | 3
array_agg     | {"Amber R. v. Pediatric & Adolescent Urgent Care of Western New York","People v. McBride","The Matter of Terrence Stevens v. New York State Division of Criminal Justice Services"}

Related Issue

No response

Screenshots

No response

What type of issue is this?

Research

[flooie]

fun