names

78 rows where place_id = 608374

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3673437 1917713 1917713 defendant Nele John husbandman 608374 608374 Nele, John, of Turvey, husbandman 1
3711660 1929959 1929959 defendant Nele William yeoman 608374 608374 Nele, William, of Turvey, yeoman 1
3722605 1933330 1933330 plaintiff Mordaunt John   608374 608374 Mordaunt, John, of Turvey, knight 0
3722610 1933331 1933331 plaintiff Mordaunt John (legal representative) 608374 608374 Mordaunt, John, of turvey, knight, executor of 0
3734359 1936984 1936984 defendant Stevynson John yeoman 608374 608374 Stevynson, John, of Turvey, yeoman 0
3734360 1936984 1936984 defendant Byrt William husbandman 608374 608374 Byrt, William, of Turvey, husbandman 1
3734361 1936984 1936984 defendant Skevyngton William butcher 608374 608374 Skevyngton, William, of Turvey, butcher 2
3769731 1948187 1948187 defendant Stevynson John yeoman 608374 608374 Stevynson, John, of Turvey, yeoman 2
3770660 1948508 1948508 defendant Stevenson John yeoman 608374 608374 Stevenson, John, of Turvey, yeoman 0
3786840 1953682 1953682 defendant Stevynson John yeoman 608374 608374 Stevynson, John, of Turvey, yeoman 0
3786841 1953682 1953682 defendant Skevyngton William baker 608374 608374 Skevyngton, William, of Turvey, baker 1
3786842 1953682 1953682 defendant Hodell John husbandman 608374 608374 Hodell, John, of Turvey, husbandman 2
3859774 1976770 1976770 plaintiff Coldewell George   608374 608374 Coldewell, George, of Turvey 0
3875787 1982153 1982153 defendant Lambert John husbandman 608374 608374 Lambert, John, of Turvey, husbandman 2
3955060 2008836 2008836 plaintiff Lyon William gent 608374 608374 Lyon, William, of Turvey, gent 0
3955062 2008837 2008837 plaintiff Lyon William gent 608374 608374 Lyon, William, of Turvey, gent 0
4052774 2043426 2043426 plaintiff Adams William   608374 608374 Adams, William, of Turvey 0
4496442 2199564 2199564 defendant Hatton John   608374 608374 Hatton, John, of Turvey 5
4548281 2215403 2215403 defendant Rychedrynke Andrew   608374 608374 Rychedrynke, Andrew, of Turvey 0
4577233 2224397 2224397 defendant Quynton Roger   608374 608374 Quynton, Roger, of Turvey 0
4629730 2240220 2240220 defendant Eyr Thomas   608374 608374 Eyr, Thomas, of Turvey 3
4654928 2247424 2247424 defendant Feun or Fevu Simon yeoman 608374 608374 Feun or Fevu, Simon, of Turvey, yeoman 0
4655426 2247592 2247592 plaintiff Broun John   608374 608374 Broun, John, of Turvey 0
4662760 2249810 2249810 defendant Herberd William chaplain 608374 608374 Herberd, William, of Turvey, chaplain 0
4700821 2265657 2265657 plaintiff Fodryngeye Thomas (legal representative) 608374 608374 Fodryngeye, Thomas, of Turvey, executors of 0
4701865 2265987 2265987 defendant Chopper Thomas husbandman 608374 608374 Chopper, Thomas, of Turvey, husbandman 3
4705432 2267065 2267065 defendant Fuller Thomas fuller 608374 608374 Fuller, Thomas, of Turvey, fuller 0
4710864 2268754 2268754 plaintiff Robyn Richard   608374 608374 Robyn, Richard, of Turvey 0
4714862 2269983 2269983 plaintiff Turvey John   608374 608374 Turvey, John, of Turvey 0
4715565 2270196 2270196 defendant Fuller Thomas husbandman 608374 608374 Fuller, Thomas, of Turvey, husbandman 0
4721286 2271988 2271988 defendant Quynten Roger tailor 608374 608374 Quynten, Roger, of Turvey, tailor 2
4722799 2272445 2272445 plaintiff Coton John   608374 608374 Coton, John, of Turvey 0
4722800 2272445 2272445 defendant Geffrey Edmund husbandman 608374 608374 Geffrey, Edmund, of Turvey, husbandman 0
4725359 2273223 2273223 defendant Quynten Roger tailor 608374 608374 Quynten, Roger, of Turvey, tailor 0
4737262 2276773 2276773 defendant Quynten Roger tailor 608374 608374 Quynten, Roger, of Turvey, tailor 0
4737266 2276774 2276774 defendant Quynten Roger tailor 608374 608374 Quynten, Roger, of Turvey, tailor 0
4741119 2277908 2277908 defendant Honyden or Hovyden John   608374 608374 Honyden or Hovyden, John, of Turvey, shepherd 0
4760766 2283708 2283708 plaintiff Dardys Thomas (legal representative) 608374 608374 Dardys, Thomas, of Turvey, executrix of 0
4788673 2292512 2292512 defendant Mordaunt Robert gent 608374 608374 Mordaunt, Robert, of Turvey, gent 1
4825341 2303968 2303968 defendant Lytelmore John husbandman 608374 608374 Lytelmore, John, of Turvey, husbandman 2
4879279 2320454 2320454 defendant Eynesbury John barker 608374 608374 Eynesbury, John, of Turvey, barker 4
4895214 2325162 2325162 plaintiff Brigge John, senior (legal representative) 608374 608374 Brigge, John, senior, of Turvey, executors of 0
4895216 2325162 2325162 plaintiff Campion John   608374 608374 Campion, John, of Turvey 2
4911239 2330021 2330021 plaintiff Brigge John (legal representative) 608374 608374 Brigge, John, of Turvey, senior, executors of 0
4911240 2330021 2330021 plaintiff Brigge John   608374 608374 (Brigge, John, of Turvey, son of Testator 1
4911241 2330021 2330021 plaintiff Campion John   608374 608374 Campion, John, of Turvey 2
4911242 2330021 2330021 defendant Brigge John (legal representative) 608374 608374 Brigge, John, of Turvey, senior, executors of 0
4911243 2330021 2330021 defendant Brigge John   608374 608374 (Brigge, John, of Turvey, son of Testator 1
4911244 2330021 2330021 defendant Campion John   608374 608374 Campion, John, of Turvey 2
4918788 2332389 2332389 defendant Halby John   608374 608374 Halby, John, of Turvey, parson 0
4956281 2343839 2343839 defendant Capon Richard butcher 608374 608374 Capon, Richard, of Turvey, butcher 2
4962709 2345753 2345753 plaintiff Brygges John   608374 608374 Brygges, John, of Turvey 0
4962712 2345753 2345753 defendant Curteys Elias weaver 608374 608374 Curteys, Elias, of Turvey, weaver 2
4976645 2349972 2349972 defendant Shadwell John husbandman 608374 608374 Shadwell, John, of Turvey, husbandman 4
4979975 2350966 2350966 plaintiff Smyth Nicholas   608374 608374 Smyth, Nicholas, of Turvey 0
5180039 2409897 2409897 defendant Lawe John yeoman 608374 608374 Lawe, John, of Turvey, yeoman 1
5180040 2409897 2409897 defendant Walcote Thomas smith 608374 608374 Walcote, Thomas, of Turvey, smith 2
5196531 2414739 2414739 defendant Everard John husbandman 608374 608374 Everard, John, of Turvey, husbandman 0
5202205 2416408 2416408 defendant Lawe John yeoman 608374 608374 Lawe, John, of Turvey, yeoman 0
5202207 2416408 2416408 defendant Walcote Thomas smith 608374 608374 Walcote, Thomas, of Turvey, smith 2
5202210 2416409 2416409 defendant Lawe John yeoman 608374 608374 Lawe, John, of Turvey, yeoman 0
5202212 2416409 2416409 defendant Walcote Thomas smith 608374 608374 Walcote, Thomas, of Turvey, smith 2
5212857 2419505 2419505 defendant Robyns John yeoman 608374 608374 Robyns, John, of Turvey, yeoman 0
5212858 2419505 2419505 defendant Lowe John yeoman 608374 608374 Lowe, John, of Turvey, yeoman 1
5213527 2419689 2419689 defendant Lawe John yeoman 608374 608374 Lawe, John, of Turvey, yeoman 0
5213528 2419689 2419689 defendant Wakeote Thomas smith 608374 608374 Wakeote, Thomas, of Turvey, smith 1
5214075 2419846 2419846 defendant Walcote Thomas yeoman 608374 608374 Walcote, Thomas, of Turvey, yeoman 0
5214077 2419846 2419846 defendant Robyns John yeoman 608374 608374 Robyns, John, of Turvey, yeoman 2
5235989 2426108 2426108 defendant Walcote Thomas smith 608374 608374 Walcote, Thomas, of Turvey, smith 1
5235991 2426108 2426108 defendant Denys alias Warner Thomas husbandman 608374 608374 Denys alias Warner, Thomas, of Turvey, husbandman 3
5357247 2462329 2462329 defendant Walcot Thomas smith 608374 608374 Walcot, Thomas, of Turvey, smith 0
5357249 2462330 2462330 defendant Walcotte Thomas smith 608374 608374 Walcotte, Thomas, of Turvey, smith 0
5527659 2513230 2513230 defendant Mordaunt John gent 608374 608374 Mordaunt, John, of Turvey, gent 0
5535807 2515708 2515708 defendant Mordaunt John   608374 608374 Mordaunt, John, of Turvey 0
5542632 2517816 2517816 plaintiff Mordaunt John   608374 608374 Mordaunt, John, of Turvey 0
5542634 2517817 2517817 plaintiff Mordaunt John gent 608374 608374 Mordaunt, John, of Turvey, gent 0
5634978 2554927 2554927 defendant Lokwod John husbandman 608374 608374 Lokwod, John, of Turvey, husbandman 1
5634982 2554928 2554928 defendant Lokwode John husbandman 608374 608374 Lokwode, John, of Turvey, husbandman 1

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