names

169 rows where place_id = 754764

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4417276 2170287 2170287 defendant Wyke Thomas de   754764 754764 Wyke, Thomas de, of Swynesheved, parson of the chapel 0
4422871 2172014 2172014 plaintiff Flesshewer Robert   754764 754764 Flesshewer, Robert, of Swynesheved 0
4423721 2172262 2172262 defendant Bolle Thomas   754764 754764 Bolle, Thomas, of Swynesheved 0
4426189 2172995 2172995 defendant Toly William   754764 754764 Toly, William, of Swynesheved 0
4440083 2181825 2181825 plaintiff Bay John   754764 754764 Bay, John, of Swynesheved 0
4440356 2181896 2181896 plaintiff Belle Randolf   754764 754764 Belle, Randolf, of Swynesheved 0
4440357 2181896 2181896 defendant Betson John   754764 754764 Betson, John, of Swynesheved 0
4440730 2182016 2182016 defendant Bolle William   754764 754764 Bolle, William, of Swynesheved 0
4441057 2182128 2182128 plaintiff Blithe John de   754764 754764 Blithe, John de, of Swynesheved 0
4441058 2182128 2182128 defendant Baker Stephen   754764 754764 Baker, Stephen, of Swynesheved 0
4443458 2182916 2182916 defendant Bolle William   754764 754764 Bolle, William, of Swynesheved 0
4445361 2183498 2183498 defendant Mynton Richard   754764 754764 Mynton, Richard, of Swynesheved 1
4446253 2183740 2183740 defendant Day John   754764 754764 Day, John, of Swynesheved 0
4446696 2183884 2183884 defendant Freston John   754764 754764 Freston, John, of Swynesheved 0
4450914 2185255 2185255 defendant Landesdale John de   754764 754764 Landesdale, John de, of Swynesheved 0
4450915 2185255 2185255 defendant Bond William   754764 754764 Bond, William, of Swynesheved 1
4451480 2185436 2185436 plaintiff Holand Thomas   754764 754764 Holand, Thomas, of Swynesheved 0
4451929 2185587 2185587 plaintiff Hummyng Alexander   754764 754764 Hummyng, Alexander, of Swynesheved 0
4451930 2185587 2185587 defendant Curteys Richard   754764 754764 Curteys, Richard, of Swynesheved 0
4452316 2185713 2185713 plaintiff Jay William   754764 754764 Jay, William, of Swynesheved 0
4452317 2185713 2185713 defendant Puttoke Thomas   754764 754764 Puttoke, Thomas, of Swynesheved 0
4458263 2187627 2187627 defendant Grayne William   754764 754764 Grayne, William, of Swynesheved 0
4459083 2187884 2187884 defendant Martynson Richard   754764 754764 Martynson, Richard, of Swynesheved 2
4459269 2187945 2187945 plaintiff Rousyng Thomas   754764 754764 Rousyng, Thomas, of Swynesheved 0
4459270 2187945 2187945 defendant Baxster William   754764 754764 Baxster, William, of Swynesheved 0
4462625 2189005 2189005 plaintiff Terry John   754764 754764 Terry, John, of Swynesheved 0
4462627 2189005 2189005 defendant Bosy John   754764 754764 Bosy, John, of Swynesheved 1
4462911 2189095 2189095 defendant Ny John   754764 754764 Ny, John, of Swynesheved 2
4465353 2189840 2189840 plaintiff Wolmer John   754764 754764 Wolmer, John, of Swynesheved 0
4465355 2189840 2189840 defendant Strakour Robert   754764 754764 Strakour, Robert, of Swynesheved 1
4465580 2189907 2189907 plaintiff Wryght Lawrence   754764 754764 Wryght, Lawrence, of Swynesheved 0
4468353 2190767 2190767 defendant Collyng Ranulph   754764 754764 Collyng, Ranulph, of Swynesheved 2
4475723 2193084 2193084 defendant Jay John   754764 754764 Jay, John, of Swynesheved 0
4477096 2193493 2193493 defendant Babull John   754764 754764 Babull, John, of Swynesheved 0
4477097 2193493 2193493 defendant Molle Alan   754764 754764 Molle, Alan, of Swynesheved 1
4478744 2194019 2194019 defendant Baxter William   754764 754764 Baxter, William, of Swynesheved 1
4491831 2198124 2198124 defendant Smyth Henry   754764 754764 Smyth, Henry, of Swynesheved 2
4499101 2200362 2200362 defendant Fengreyne Robert   754764 754764 Fengreyne, Robert, of Swynesheved, son of Thomas 0
4499696 2200540 2200540 defendant Jay William   754764 754764 Jay, William, of Swynesheved 0
4509724 2203523 2203523 defendant Curtays John   754764 754764 Curtays, John, of Swynesheved 0
4512325 2204295 2204295 defendant Bardenay Richard   754764 754764 Bardenay, Richard, of Swynesheved 0
4512326 2204295 2204295 defendant Trewelove William   754764 754764 Trewelove, William, of Swynesheved, son of Andrew 1
4512689 2204401 2204401 defendant Holand Lawrence   754764 754764 Holand, Lawrence, of Swynesheved 0
4514475 2204945 2204945 defendant Jay John, sen   754764 754764 Jay, John, sen, of Swynesheved 0
4515736 2205348 2205348 defendant Roper William thatcher 754764 754764 Roper, William, of Swynesheved, thatcher 0
4516242 2205488 2205488 defendant Adeldewe John   754764 754764 Adeldewe, John, of Swynesheved 1
4525505 2208306 2208306 plaintiff Jay William   754764 754764 Jay, William, of Swynesheved 0
4525512 2208306 2208306 defendant Tepilere William   754764 754764 Tepilere, William, of Swynesheved 6
4533680 2210803 2210803 defendant Lady William   754764 754764 Lady, William, of Swynesheved 0
4537024 2211848 2211848 plaintiff Strugge John   754764 754764 Strugge, John, of Swynesheved 0
4537513 2212004 2212004 defendant Banur William   754764 754764 Banur, William, of Swynesheved 0
4543136 2213732 2213732 defendant Borry John   754764 754764 Borry, John, of Swynesheved 1
4543672 2213916 2213916 defendant Dyconson John thatcher 754764 754764 Dyconson, John, of Swynesheved, thatcher 0
4545823 2214625 2214625 defendant Gradener William   754764 754764 Gradener, William, of Swynesheved 0
4545825 2214625 2214625 defendant (illegible) John   754764 754764 _, John, of Swynesheved 2
4549357 2215741 2215741 defendant Fengreyne Robert   754764 754764 Fengreyne, Robert, of Swynesheved 0
4551305 2216346 2216346 plaintiff Drombell William   754764 754764 Drombell, William, of Swynesheved 0
4552146 2216620 2216620 defendant Jay Thomas   754764 754764 Jay, Thomas, of Swynesheved 2
4565388 2220742 2220742 plaintiff Smyth Henry   754764 754764 Smyth, Henry, of Swynesheved 0
4565389 2220742 2220742 defendant Knyght Robert   754764 754764 Knyght, Robert, of Swynesheved 0
4565746 2220844 2220844 defendant Atheldewe Thomas   754764 754764 Atheldewe, Thomas, of Swynesheved 2
4567092 2221263 2221263 defendant Roper John   754764 754764 Roper, John, of Swynesheved 1
4567093 2221263 2221263 defendant Staker Robert   754764 754764 Staker, Robert, of Swynesheved 2
4569045 2221906 2221906 defendant Fengreyne John, sen   754764 754764 Fengreyne, John, sen, of Swynesheved 0
4569069 2221912 2221912 defendant Attildieu John   754764 754764 Attildieu, John, of Swynesheved 0
4569071 2221913 2221913 defendant Jonesson Robert   754764 754764 Jonesson, Robert, of Swynesheved 0
4569316 2221990 2221990 defendant Gardyner William   754764 754764 Gardyner, William, of Swynesheved 0
4586822 2227277 2227277 plaintiff Holand William   754764 754764 Holand, William, of Swynesheved 0
4587815 2227592 2227592 defendant Roper John   754764 754764 Roper, John, of Swynesheved 0
4599756 2231145 2231145 defendant Roper John   754764 754764 Roper, John, of Swynesheved 0
4603955 2232409 2232409 defendant Barbour Simon   754764 754764 Barbour, Simon, of Swynesheved 1
4606768 2233230 2233230 defendant Wryght William   754764 754764 Wryght, William, of Swynesheved 1
4625421 2238915 2238915 defendant Jurdan Nicholas   754764 754764 Jurdan, Nicholas, of Swynesheved 0
4636431 2242228 2242228 defendant Wright William   754764 754764 Wright, William, of Swynesheved 1
4636434 2242228 2242228 defendant Pynder John   754764 754764 Pynder, John, of Swynesheved 4
4636435 2242228 2242228 defendant Terry Thomas   754764 754764 Terry, Thomas, of Swynesheved 5
4636436 2242228 2242228 defendant Bulle William   754764 754764 Bulle, William, of Swynesheved 6
4636437 2242228 2242228 defendant Knyght Ralph   754764 754764 Knyght, Ralph, of Swynesheved 7
4650846 2246266 2246266 defendant Smyth Henry   754764 754764 Smyth, Henry, of Swynesheved 4
4668389 2255824 2255824 plaintiff Bawend John   754764 754764 Bawend, John, of Swynesheved 0
4668406 2255831 2255831 plaintiff Bay Stephen chaplain 754764 754764 Bay, Stephen, of Swynesheved, chaplain 0
4668409 2255832 2255832 plaintiff Grantham Thomas   754764 754764 Grantham, Thomas, of Swynesheved 1
4669537 2256178 2256178 defendant Smyth William husbandman 754764 754764 Smyth, William, of Swynesheved, husbandman 0
4671420 2256711 2256711 defendant Babull John weaver 754764 754764 Babull, John, of Swynesheved, weaver 0
4679178 2259097 2259097 defendant Deye Walter husbandman 754764 754764 Deye, Walter, of Swynesheved, husbandman 0
4679180 2259097 2259097 defendant Hilton Amicia widow 754764 754764 Hilton, Amicia, of Swynesheved, widow 2
4679181 2259097 2259097 defendant Hilton John yeoman 754764 754764 Hilton, John, of Swynesheved, yeoman 3
4682380 2260108 2260108 defendant Barker Thomas shoemaker 754764 754764 Barker, Thomas, of Swynesheved, shoemaker 3
4685350 2261014 2261014 plaintiff Rousyng Robert   754764 754764 Rousyng, Robert, of Swynesheved 0
4685955 2261195 2261195 defendant Barlyman William husbandman 754764 754764 Barlyman, William, of Swynesheved, husbandman 0
4685956 2261195 2261195 defendant Molle William husbandman 754764 754764 Molle, William, of Swynesheved, husbandman 1
4688429 2261948 2261948 defendant Aleynson William husbandman 754764 754764 Aleynson, William, of Swynesheved, husbandman 0
4696127 2264272 2264272 plaintiff Calche John   754764 754764 Calche, John, of Swynesheved 0
4696487 2264378 2264378 plaintiff Carvyll William   754764 754764 Carvyll, William, of Swynesheved 0
4697724 2264780 2264780 plaintiff Constable Richard tailor 754764 754764 Constable, Richard, of Swynesheved, tailor 0
4697725 2264780 2264780 defendant Barlyman William brother of John 754764 754764 Barlyman, William, of Swynesheved, husbandman, brother of John 0
4708628 2268073 2268073 defendant Halyday Edmund   754764 754764 Halyday, Edmund, of Swynesheved, cook 0
4716723 2270550 2270550 plaintiff Wolmere Richard   754764 754764 Wolmere, Richard, of Swynesheved 0
4716724 2270550 2270550 defendant Neuton William gent 754764 754764 Neuton, William, of Swynesheved, gent 0
4734846 2276055 2276055 defendant Pyndeer John   754764 754764 Pyndeer, John, of Swynesheved, fen man 2

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);