names

1,058 rows where place_id = 585932

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587527 1863747 1863747 defendant Byrdsall John vintner 585932 585932 Byrdsall, John, of Kingston on Hull, vintner 0
3593063 1865457 1865457 defendant Lynsey John merchant 585932 585932 Lynsey, John, of Kingston on Hull, merchant 0
3594312 1865853 1865853 defendant Brompton Robert merchant 585932 585932 Brompton, Robert, of Kingston on Hull, merchant 4
3597326 1866782 1866782 defendant Myndram Henry merchant 585932 585932 Myndram, Henry, of Kingston on Hull, merchant 0
3597327 1866782 1866782 defendant Gosman Thomas merchant 585932 585932 Gosman, Thomas, of Kingston on Hull, merchant 1
3597334 1866784 1866784 defendant Myndram Henry merchant 585932 585932 Myndram, Henry, of Kingston on Hull, merchant 0
3597335 1866784 1866784 defendant Gosinam Thomas merchant 585932 585932 Gosinam, Thomas, of Kingston on Hull, merchant 1
3623549 1874894 1874894 defendant Birdsall John merchant 585932 585932 Birdsall, John, of Kingston on Hull, merchant 0
3695821 1924926 1924926 defendant Eland John alderman 585932 585932 Eland, John, of Kingston on Hull, alderman 0
3711327 1929849 1929849 defendant Billop John yeoman 585932 585932 Billop, John, of Kingston on Hull, yeoman 1
3711328 1929849 1929849 defendant Goddard Thomas saddler 585932 585932 Goddard, Thomas, of Kingston on Hull, saddler 2
3711329 1929849 1929849 defendant Walker Thomas miller 585932 585932 Walker, Thomas, of Kingston on Hull, miller 3
3726137 1934439 1934439 defendant Billop John yeoman 585932 585932 Billop, John, of Kingston on Hull, yeoman 1
3726138 1934439 1934439 defendant Goddard Thomas saddler 585932 585932 Goddard, Thomas, of Kingston on Hull, saddler 2
3726139 1934439 1934439 defendant Walker Thomas miller 585932 585932 Walker, Thomas, of Kingston on Hull, miller 3
3795811 1956556 1956556 defendant Haryes William merchant 585932 585932 Haryes, William, of Kingston on Hull, merchant 0
3800978 1958216 1958216 defendant Haven John merchant 585932 585932 Haven, John, of Kingston on Hull, merchant 0
3801838 1958470 1958470 defendant Walcer Henry (legal representative) 585932 585932 Walcer, Henry, of Kingston on Hull, merchant, executor of 0
3801839 1958470 1958470 defendant Walcar Robert merchant 585932 585932 Walcar, Robert, of Kingston on Hull, merchant 1
3879868 1983526 1983526 plaintiff Oversall Hugh   585932 585932 Oversall, Hugh, of Kingston on Hull 0
3944765 2005268 2005268 plaintiff Bee John   585932 585932 Bee, John, of Kingston on Hull 0
3944766 2005268 2005268 defendant Smyth William mariner 585932 585932 Smyth, William, of Kingston on Hull, mariner 0
3944767 2005268 2005268 defendant Bulmer Brian mariner 585932 585932 Bulmer, Brian, of Kingston on Hull, mariner 1
3947537 2006209 2006209 defendant Davye John merchant 585932 585932 Davye, John, of Kingston on Hull, merchant 0
3949087 2006746 2006746 defendant Calwood John merchant 585932 585932 Calwood, John, of Kingston on Hull, merchant 0
3949093 2006747 2006747 defendant Calwood John merchant 585932 585932 Calwood, John, of Kingston on Hull, merchant 0
3949099 2006748 2006748 defendant Thompson William merchant 585932 585932 Thompson, William, of Kingston on Hull, merchant 0
3949104 2006749 2006749 defendant Thompson William merchant 585932 585932 Thompson, William, of Kingston on Hull, merchant 0
3950705 2007320 2007320 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
3953671 2008361 2008361 plaintiff Jobson Walter merchant 585932 585932 Jobson, Walter, of Kingston on Hull, merchant 0
3953936 2008447 2008447 defendant Thomson or Thompson William merchant 585932 585932 Thomson or Thompson, William, of Kingston on Hull, merchant 0
3953938 2008448 2008448 defendant Thomson William merchant 585932 585932 Thomson, William, of Kingston on Hull, merchant 0
3958579 2010072 2010072 defendant Dalton John merchant 585932 585932 Dalton, John, of Kingston on Hull, merchant 0
3958880 2010190 2010190 defendant Rotheram Alice widow 585932 585932 (Rotheram, Alice, of Kingston on Hull, widow 1
3959213 2010310 2010310 defendant Stephenson James draper 585932 585932 Stephenson, James, of Kingston on Hull, draper 0
3960224 2010676 2010676 plaintiff Stockdale Alexander merchant 585932 585932 Stockdale, Alexander, of Kingston on Hull, merchant 0
3960225 2010676 2010676 defendant Dacton John merchant 585932 585932 Dacton, John, of Kingston on Hull, merchant 0
3961022 2010949 2010949 defendant Smythe William mariner 585932 585932 Smythe, William, of Kingston on Hull, mariner 0
3962595 2011509 2011509 defendant Robynson James saddler 585932 585932 Robynson, James, of Kingston on Hull, saddler 0
3965496 2012544 2012544 plaintiff Baxter Robert   585932 585932 Baxter, Robert, of Kingston on Hull, "medicus" or doctor of medicine 0
3965549 2012563 2012563 plaintiff Beamound John merchant 585932 585932 Beamound, John, of Kingston on Hull, merchant 0
3965787 2012647 2012647 defendant Jobson Walter merchant 585932 585932 Jobson, Walter, of Kingston on Hull, merchant 0
3966849 2013039 2013039 defendant Jobson Walter alderman 585932 585932 Jobson, Walter, of Kingston on Hull, merchant, alderman 0
3967365 2013213 2013213 defendant Petytte Thomas mariner 585932 585932 Petytte, Thomas, of Kingston on Hull, mariner 0
3968573 2013644 2013644 plaintiff Clarkeson James merchant 585932 585932 Clarkeson, James, of Kingston on Hull, merchant 0
3970180 2014169 2014169 plaintiff Dalton Robert merchant 585932 585932 Dalton, Robert, of Kingston on Hull, merchant 0
3970691 2014339 2014339 defendant Cawood John gent 585932 585932 Cawood, John, of Kingston on Hull, gent 0
3971393 2014552 2014552 defendant Jobson Walter alderman 585932 585932 Jobson, Walter, of Kingston on Hull, alderman 0
3971394 2014552 2014552 defendant Tomson William merchant 585932 585932 Tomson, William, of Kingston on Hull, merchant 1
3975088 2015848 2015848 defendant Pormort Gregory draper 585932 585932 Pormort, Gregory, of Kingston on Hull, draper 0
3976670 2016417 2016417 defendant Cawood John gent 585932 585932 Cawood, John, of Kingston on Hull, gent 0
3977958 2016864 2016864 plaintiff Mallinson John merchant 585932 585932 Mallinson, John, of Kingston on Hull, merchant 0
3978464 2017048 2017048 defendant Modye Henry merchant 585932 585932 Modye, Henry, of Kingston on Hull, merchant 0
3978625 2017102 2017102 plaintiff Modye Henry   585932 585932 Modye, Henry, of Kingston on Hull 0
3983170 2018753 2018753 plaintiff Smyth John merchant 585932 585932 Smyth, John, of Kingston on Hull, merchant 0
3983937 2019023 2019023 defendant Parker William merchant 585932 585932 Parker, William, of Kingston on Hull, merchant 0
3990657 2021410 2021410 defendant Jacklyng Richard gent 585932 585932 Jacklyng, Richard, of Kingston on Hull, gent 0
3990660 2021411 2021411 defendant Jacklynge Richard gent 585932 585932 Jacklynge, Richard, of Kingston on Hull, gent 0
3993351 2022363 2022363 plaintiff Cave Lawrence (legal representative) 585932 585932 Cave, Lawrence, of Kingston on Hull, merchant, executrix of 0
3993354 2022364 2022364 plaintiff Cave Lawrence (legal representative) 585932 585932 Cave, Lawrence, of Kingston on Hull, merchant, executrix of 0
3994049 2022621 2022621 plaintiff Clarkeson James merchant 585932 585932 Clarkeson, James, of Kingston on Hull, merchant 0
3994051 2022622 2022622 plaintiff Clarkson James merchant 585932 585932 Clarkson, James, of Kingston on Hull, merchant 0
3994361 2022736 2022736 defendant Tomson William merchant 585932 585932 Tomson, William, of Kingston on Hull, merchant 0
3995025 2022967 2022967 defendant Wakefyld Anthony merchant 585932 585932 Wakefyld, Anthony, of Kingston on Hull, merchant 0
3996113 2023363 2023363 plaintiff Dalton Robert merchant 585932 585932 Dalton, Robert, of Kingston on Hull, merchant 0
3999362 2024529 2024529 plaintiff Fullwood Henry merchant 585932 585932 Fullwood, Henry, of Kingston on Hull, merchant 0
3999907 2024736 2024736 plaintiff Gayton Robert merchant 585932 585932 Gayton, Robert, of Kingston on Hull, merchant 0
3999909 2024737 2024737 plaintiff Gayton Robert merchant 585932 585932 Gayton, Robert, of Kingston on Hull, merchant 0
4006036 2026931 2026931 defendant Jobson Walter merchant 585932 585932 Jobson, Walter, of Kingston on Hull, merchant 8
4006046 2026932 2026932 defendant Jobson Walter merchant 585932 585932 Jobson, Walter, of Kingston on Hull, merchant 8
4010291 2028446 2028446 defendant Jobsone George merchant 585932 585932 Jobsone, George, of Kingston on Hull, merchant 0
4010503 2028531 2028531 plaintiff Parker William (legal representative) 585932 585932 Parker, William, of Kingston on Hull, executors of 0
4015427 2030214 2030214 plaintiff Smyth William mercer 585932 585932 Smyth, William, of Kingston on Hull, mercer 0
4015428 2030214 2030214 defendant Latham Thomas gent 585932 585932 Latham, Thomas, of Kingston on Hull, gent 0
4015596 2030276 2030276 plaintiff Smythe William mercer 585932 585932 Smythe, William, of Kingston on Hull, mercer 0
4015597 2030276 2030276 defendant Latham Thomas gent 585932 585932 Latham, Thomas, of Kingston on Hull, gent 0
4016348 2030544 2030544 defendant Thomson William merchant 585932 585932 Thomson, William, of Kingston on Hull, merchant 0
4016640 2030657 2030657 defendant Cooke John yeoman 585932 585932 Cooke, John, of Kingston on Hull, yeoman 0
4017461 2030950 2030950 defendant Thomson William merchant 585932 585932 Thomson, William, of Kingston on Hull, merchant 0
4017884 2031108 2031108 defendant Preston Giles chapman 585932 585932 Preston, Giles, of Kingston on Hull, chapman 0
4024787 2033547 2033547 defendant Roberdes Edmund merchant 585932 585932 Roberdes, Edmund, of Kingston on Hull, merchant 0
4029289 2035118 2035118 defendant Robert Edmund merchant 585932 585932 Robert, Edmund, of Kingston on Hull, merchant 0
4029392 2035152 2035152 plaintiff Dalton Robert merchant 585932 585932 Dalton, Robert, of Kingston on Hull, merchant 0
4029449 2035171 2035171 defendant Almond William gent 585932 585932 Almond, William, of Kingston on Hull, gent 0
4030323 2035498 2035498 defendant Tompson William chapman 585932 585932 Tompson, William, of Kingston on Hull, chapman 0
4030651 2035624 2035624 defendant Almonde William gent 585932 585932 Almonde, William, of Kingston on Hull, gent 1
4030695 2035639 2035639 defendant Almonde William gent 585932 585932 Almonde, William, of Kingston on Hull, gent 1
4030795 2035679 2035679 plaintiff Empson Thomas   585932 585932 Empson, Thomas, of Kingston on Hull, ship owner 0
4031222 2035838 2035838 plaintiff Fawether John merchant 585932 585932 Fawether, John, of Kingston on Hull, merchant 0
4031224 2035839 2035839 plaintiff Fawether John merchant 585932 585932 Fawether, John, of Kingston on Hull, merchant 0
4031226 2035840 2035840 plaintiff Fawether John merchant 585932 585932 Fawether, John, of Kingston on Hull, merchant 0
4031229 2035841 2035841 plaintiff Fawether John merchant 585932 585932 Fawether, John, of Kingston on Hull, merchant 0
4031231 2035842 2035842 plaintiff Fawether John merchant 585932 585932 Fawether, John, of Kingston on Hull, merchant 0
4032614 2036315 2036315 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
4032616 2036316 2036316 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
4032618 2036317 2036317 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
4032620 2036318 2036318 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
4032623 2036319 2036319 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
4032626 2036320 2036320 plaintiff Gee William merchant 585932 585932 Gee, William, of Kingston on Hull, merchant 0
4033044 2036469 2036469 defendant Thompson William merchant 585932 585932 Thompson, William, of Kingston on Hull, merchant 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);