names

796 rows where place_id = 603528

✎ 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
3654839 1911772 1911772 defendant Pyllet Robert merchant & burgess 603528 603528 Pyllet, Robert, of Kyngeston upon Hull, merchant & burgess 0
3658763 1912996 1912996 defendant Madyson Edward merchant 603528 603528 Madyson, Edward, of Kyngeston upon Hull, merchant 0
3658765 1912997 1912997 defendant Madyson Edward   603528 603528 Madyson, Edward, of Kyngeston upon Hull, staple merchant 0
3928082 1999730 1999730 defendant Dalton Robert merchant 603528 603528 Dalton, Robert, of Kyngeston upon Hull, merchant 0
3928252 1999784 1999784 defendant Dove John merchant 603528 603528 Dove, John, of Kyngeston upon Hull, merchant 1
3931638 2000877 2000877 defendant Johnson William merchant & Alderman 603528 603528 Johnson, William, of Kyngeston upon Hull, merchant & Alderman 1
3931641 2000878 2000878 defendant Johnson William merchant & Alderman 603528 603528 Johnson, William, of Kyngeston upon Hull, merchant & Alderman 1
4413369 2169057 2169057 defendant Beverlay John de   603528 603528 Beverlay, John de, of Kyngeston upon Hull 0
4413742 2169194 2169194 plaintiff Brouno John   603528 603528 Brouno, John, of Kyngeston upon Hull 0
4415418 2169720 2169720 plaintiff Helleward Thomas   603528 603528 Helleward, Thomas, of Kyngeston upon Hull 0
4415943 2169871 2169871 defendant Godknape John   603528 603528 Godknape, John, of Kyngeston upon Hull 0
4415958 2169878 2169878 plaintiff Lamberd John   603528 603528 Lamberd, John, of Kyngeston upon Hull, burgess 0
4415959 2169878 2169878 plaintiff Yafford John de   603528 603528 Yafford, John de, of Kyngeston upon Hull, burgess 1
4417200 2170257 2170257 defendant Baron John de   603528 603528 Baron, John de, of Kyngeston upon Hull 1
4417201 2170257 2170257 defendant Taverner William le   603528 603528 Taverner, William le, of Kyngeston upon Hull 2
4419524 2170992 2170992 plaintiff Beghum Stephen de (legal representative) 603528 603528 Beghum, Stephen de, of Kyngeston upon Hull, executors of 0
4419526 2170992 2170992 plaintiff Uppesale Robert de   603528 603528 Uppesale, Robert de, of Kyngeston upon Hull 2
4420253 2171236 2171236 plaintiff Briselay Roger de   603528 603528 Briselay, Roger de, of Kyngeston upon Hull 0
4421779 2171692 2171692 plaintiff Dacron Robert de   603528 603528 Dacron, Robert de, of Kyngeston upon Hull 0
4422140 2171797 2171797 defendant Broun Thomas   603528 603528 Broun, Thomas, of Kyngeston upon Hull 0
4424054 2172376 2172376 defendant Upesale wiliam   603528 603528 Upesale, wiliam, of Kyngeston upon Hull 0
4424795 2172593 2172593 defendant Helward John   603528 603528 Helward, John, of Kyngeston upon Hull 1
4428777 2173801 2173801 plaintiff Taverner Hugh le (legal representative) 603528 603528 Taverner, Hugh le, of Kyngeston upon Hull, executors of 0
4428781 2173802 2173802 plaintiff Taverner Hugh (legal representative) 603528 603528 Taverner, Hugh, of Kyngeston upon Hull, executors of 0
4428943 2173852 2173852 defendant Bakester Hugh   603528 603528 Bakester, Hugh, of Kyngeston upon Hull 0
4429671 2174071 2174071 defendant Spens Geoffrey   603528 603528 Spens, Geoffrey, of Kyngeston upon Hull, burgess 0
4429672 2174071 2174071 defendant Barton John de master & burgess 603528 603528 Barton, John de, of Kyngeston upon Hull, master & burgess 1
4429673 2174071 2174071 defendant Porter Robert   603528 603528 Porter, Robert, of Kyngeston upon Hull, burgess 2
4429675 2174072 2174072 defendant Spens Geoffrey   603528 603528 Spens, Geoffrey, of Kyngeston upon Hull, burgess 0
4429676 2174072 2174072 defendant Barton John de master & burgess 603528 603528 Barton, John de, of Kyngeston upon Hull, master & burgess 1
4429677 2174072 2174072 defendant Porter Robert   603528 603528 Porter, Robert, of Kyngeston upon Hull, burgess 2
4430354 2174283 2174283 plaintiff Yafford Geoffrey   603528 603528 Yafford, Geoffrey, of Kyngeston upon Hull 0
4434330 2175496 2175496 plaintiff Ker Richard de   603528 603528 Ker, Richard de, of Kyngeston upon Hull 0
4434331 2175496 2175496 defendant Fisshelake Thomas de   603528 603528 Fisshelake, Thomas de, of Kyngeston upon Hull 0
4444923 2183384 2183384 defendant Waltham Thomas   603528 603528 Waltham, Thomas, of Kyngeston upon Hull 0
4448646 2184509 2184509 plaintiff Frost Walter   603528 603528 Frost, Walter, of Kyngeston upon Hull 0
4448649 2184510 2184510 plaintiff Frost Walter   603528 603528 Frost, Walter, of Kyngeston upon Hull 0
4448701 2184528 2184528 defendant Bates William   603528 603528 Bates, William, of Kyngeston upon Hull 0
4448733 2184541 2184541 defendant Bate William   603528 603528 Bate, William, of Kyngeston upon Hull 0
4450273 2185044 2185044 plaintiff Hanby Hugh de (legal representative) 603528 603528 Hanby, Hugh de, of Kyngeston upon Hull, executors of 0
4450575 2185141 2185141 defendant Bate Richard   603528 603528 Bate, Richard, of Kyngeston upon Hull 0
4451942 2185590 2185590 defendant Selby Henry de   603528 603528 Selby, Henry de, of Kyngeston upon Hull 6
4457922 2187498 2187498 plaintiff Potterflet Robert de   603528 603528 Potterflet, Robert de, of Kyngeston upon Hull 0
4459827 2188126 2188126 defendant Grymesby Simon de   603528 603528 Grymesby, Simon de, of Kyngeston upon Hull 1
4459998 2188183 2188183 plaintiff Selby Robert de   603528 603528 Selby, Robert de, of Kyngeston upon Hull 0
4460901 2188476 2188476 plaintiff Snaynton William   603528 603528 Snaynton, William, of Kyngeston upon Hull 0
4462255 2188893 2188893 defendant Delle John   603528 603528 Delle, John, of Kyngeston upon Hull, son of John Dell, of Hesell 2
4464229 2189480 2189480 plaintiff Waltham Thomas   603528 603528 Waltham, Thomas, of Kyngeston upon Hull, on his own account 0
4464246 2189481 2189481 plaintiff Waltham Thomas   603528 603528 Waltham, Thomas, of Kyngeston upon Hull, on his own account 0
4467859 2190629 2190629 plaintiff Banastre William   603528 603528 Banastre, William, of Kyngeston upon Hull 0
4471778 2191839 2191839 defendant Blakeneye William   603528 603528 Blakeneye, William, of Kyngeston upon Hull 1
4474896 2192815 2192815 plaintiff Dynulton John   603528 603528 Dynulton, John, of Kyngeston upon Hull, burgess 0
4474999 2192852 2192852 plaintiff Ellay Thomas de   603528 603528 Ellay, Thomas de, of Kyngeston upon Hull 0
4475000 2192852 2192852 defendant Mawer Wiliam   603528 603528 Mawer, Wiliam, of Kyngeston upon Hull 0
4476241 2193230 2193230 defendant Hedon William   603528 603528 Hedon, William, of Kyngeston upon Hull, son of John de Hedon 0
4476596 2193341 2193341 defendant Trymesby Simon de   603528 603528 Trymesby, Simon de, of Kyngeston upon Hull 0
4479073 2194111 2194111 plaintiff Pundy William   603528 603528 Pundy, William, of Kyngeston upon Hull, formerly collector of Customs for the King, at the port 1
4479868 2194369 2194369 plaintiff Walkar Simon   603528 603528 Walkar, Simon, of Kyngeston upon Hull 1
4480260 2194488 2194488 plaintiff Kylyngholme Robert de   603528 603528 Kylyngholme, Robert de, of Kyngeston upon Hull 0
4480976 2194727 2194727 plaintiff Leversege John   603528 603528 Leversege, John, of Kyngeston upon Hull 0
4487567 2196831 2196831 plaintiff Snaynton Joan   603528 603528 Snaynton, Joan, of Kyngeston upon Hull, formerly wife of William de Snaynton 0
4487569 2196832 2196832 plaintiff Snaynton William de (legal representative) 603528 603528 Snaynton, William de, of Kyngeston upon Hull, executors of 0
4487570 2196832 2196832 plaintiff Snaynton Joan de   603528 603528 (Snaynton, Joan de, of Kyngeston upon Hull, formerly wife of Testator 1
4487571 2196832 2196832 plaintiff Snaynton Robert de   603528 603528 Snaynton, Robert de, of Kyngeston upon Hull, son of William 2
4488662 2197178 2197178 plaintiff Sutton Robert de weaver 603528 603528 Sutton, Robert de, of Kyngeston upon Hull, weaver 0
4495308 2199210 2199210 plaintiff Bynglay John de   603528 603528 Bynglay, John de, of Kyngeston upon Hull 0
4495315 2199212 2199212 plaintiff Byngley John   603528 603528 Byngley, John, of Kyngeston upon Hull 0
4495318 2199213 2199213 plaintiff Byngley John   603528 603528 Byngley, John, of Kyngeston upon Hull 0
4496310 2199521 2199521 plaintiff Colthorp John de (legal representative) 603528 603528 Colthorp, John de, of Kyngeston upon Hull, executors of 0
4496314 2199521 2199521 defendant Swan Thomas   603528 603528 Swan, Thomas, of Kyngeston upon Hull 0
4498343 2200141 2200141 plaintiff Founteney Thomas   603528 603528 Founteney, Thomas, of Kyngeston upon Hull 0
4498755 2200244 2200244 plaintiff Garton Robert de   603528 603528 Garton, Robert de, of Kyngeston upon Hull, formerly customer or customs officer for the King, at the port 0
4499640 2200525 2200525 plaintiff Hedon William   603528 603528 Hedon, William, of Kyngeston upon Hull 0
4499642 2200526 2200526 plaintiff Hedon William   603528 603528 Hedon, William, of Kyngeston upon Hull 0
4501286 2201007 2201007 plaintiff Leversegg John   603528 603528 Leversegg, John, of Kyngeston upon Hull, on his own account 0
4501618 2201109 2201109 defendant Tutbury John   603528 603528 Tutbury, John, of Kyngeston upon Hull 0
4501628 2201111 2201111 defendant Tutbury John merchant 603528 603528 Tutbury, John, of Kyngeston upon Hull, merchant 0
4501770 2201148 2201148 plaintiff Lyversegg John   603528 603528 Lyversegg, John, of Kyngeston upon Hull, on his own account 0
4504714 2202017 2202017 defendant Bynglay John   603528 603528 Bynglay, John, of Kyngeston upon Hull 2
4504787 2202036 2202036 defendant Humbleton John de   603528 603528 Humbleton, John de, of Kyngeston upon Hull 0
4504914 2202077 2202077 plaintiff Shefeld William   603528 603528 Shefeld, William, of Kyngeston upon Hull 0
4507723 2202875 2202875 plaintiff Wilcok Alan   603528 603528 Wilcok, Alan, of Kyngeston upon Hull, burgess 0
4507726 2202876 2202876 plaintiff Wilcok Alan   603528 603528 Wilcok, Alan, of Kyngeston upon Hull, burgess 0
4510001 2203614 2203614 defendant Brige William   603528 603528 Brige, William, of Kyngeston upon Hull 0
4510107 2203648 2203648 plaintiff Banastre William   603528 603528 Banastre, William, of Kyngeston upon Hull 0
4510994 2203889 2203889 plaintiff Breneston John   603528 603528 Breneston, John, of Kyngeston upon Hull 1
4511321 2203985 2203985 defendant Appylton John   603528 603528 Appylton, John, of Kyngeston upon Hull 0
4514193 2204856 2204856 plaintiff Burton John   603528 603528 Burton, John, of Kyngeston upon Hull 0
4515845 2205377 2205377 plaintiff Cliffe Robert de sheerman 603528 603528 Cliffe, Robert de, of Kyngeston upon Hull, sheerman 0
4520158 2206640 2206640 defendant Grymesby Simon   603528 603528 Grymesby, Simon, of Kyngeston upon Hull 0
4520796 2206845 2206845 plaintiff Fountenay Thomas   603528 603528 Fountenay, Thomas, of Kyngeston upon Hull 0
4520800 2206846 2206846 plaintiff Fountenay Thomas   603528 603528 Fountenay, Thomas, of Kyngeston upon Hull 0
4521527 2207072 2207072 defendant Hayton Robert de   603528 603528 Hayton, Robert de, of Kyngeston upon Hull, administrators of 0
4521528 2207072 2207072 defendant Percy George   603528 603528 (Percy, George, of Kyngeston upon Hull 1
4521542 2207074 2207074 defendant Bekyngham Robert merchant 603528 603528 Bekyngham, Robert, of Kyngeston upon Hull, merchant 0
4521549 2207075 2207075 defendant Arnald John   603528 603528 Arnald, John, of Kyngeston upon Hull 0
4524370 2207959 2207959 defendant Appilton John de merchant & burgess 603528 603528 Appilton, John de, of Kyngeston upon Hull, merchant & burgess 1
4525891 2208397 2208397 defendant Sergeaunt Robert   603528 603528 Sergeaunt, Robert, of Kyngeston upon Hull 0
4526592 2208594 2208594 defendant Appylton John   603528 603528 Appylton, John, of Kyngeston upon Hull 0
4527149 2208776 2208776 plaintiff Levesege John   603528 603528 Levesege, John, of Kyngeston upon Hull 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);