names

74 rows where place_id = 619652

✎ 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
3731158 1935971 1935971 defendant Prene Richard tanner 619652 619652 Prene, Richard, of Bruggenorth, tanner 0
3731160 1935971 1935971 defendant Barker Richard yeoman 619652 619652 Barker, Richard, of Bruggenorth, yeoman 2
3731161 1935971 1935971 defendant Howell Thomas weaver 619652 619652 Howell, Thomas, of Bruggenorth, weaver 3
3751145 1942282 1942282 defendant Oldbury alias Westwode john (legal representative) 619652 619652 Oldbury alias Westwode, john, of Bruggenorth, yeoman, executors of 2
3801318 1958340 1958340 defendant Tydur Richard carpenter 619652 619652 Tydur, Richard, of Bruggenorth, carpenter 0
3801319 1958340 1958340 defendant Beche William miller 619652 619652 Beche, William, of Bruggenorth, miller 1
3806767 1960017 1960017 defendant Pyrry John draper 619652 619652 Pyrry, John, of Bruggenorth, draper 0
3806768 1960017 1960017 defendant Pyrry Thomas draper 619652 619652 Pyrry, Thomas, of Bruggenorth, draper 1
4413999 2169281 2169281 defendant Crouke John   619652 619652 Crouke, John, of Bruggenorth 0
4414175 2169340 2169340 defendant Rondulf John   619652 619652 Rondulf, John, of Bruggenorth 0
4415173 2169645 2169645 plaintiff Goldsmyth Joan la   619652 619652 Goldsmyth, Joan la, of Bruggenorth 0
4415174 2169645 2169645 defendant Canne John   619652 619652 Canne, John, of Bruggenorth 0
4421926 2171733 2171733 defendant Mese Roger   619652 619652 Mese, Roger, of Bruggenorth 0
4423353 2172153 2172153 plaintiff Goldsmyth Emma le   619652 619652 Goldsmyth, Emma le, of Bruggenorth, formerly wife of Walter 0
4423355 2172154 2172154 plaintiff Goldsmyth William le   619652 619652 Goldsmyth, William le, of Bruggenorth, son of Thomas 0
4424723 2172569 2172569 plaintiff Kyrkeby William de   619652 619652 Kyrkeby, William de, of Bruggenorth, prebendary of the lesser, prebend of Erdyngton, in the King's free chapel 0
4424724 2172569 2172569 defendant Crouke John   619652 619652 Crouke, John, of Bruggenorth, son of John 0
4427440 2173419 2173419 defendant Pycheford William de   619652 619652 Pycheford, William de, of Bruggenorth 0
4427442 2173420 2173420 defendant Pychford William de   619652 619652 Pychford, William de, of Bruggenorth 0
4459483 2188018 2188018 defendant Sadeler Ralph   619652 619652 Sadeler, Ralph, of Bruggenorth 0
4466509 2190196 2190196 defendant atte Yate John   619652 619652 atte Yate, John, of Bruggenorth 0
4471980 2191903 2191903 defendant Streton William   619652 619652 Streton, William, of Bruggenorth 0
4474362 2192633 2192633 defendant Bussheley William de   619652 619652 Bussheley, William de, of Bruggenorth 0
4494033 2198819 2198819 plaintiff Bernard Ralph   619652 619652 Bernard, Ralph, of Bruggenorth 0
4504999 2202100 2202100 defendant Hourde William esq 619652 619652 Hourde, William, of Bruggenorth, esq 2
4517138 2205763 2205763 plaintiff Coweley John   619652 619652 Coweley, John, of Bruggenorth 0
4517310 2205814 2205814 defendant Blokkeley John hewster 619652 619652 Blokkeley, John, of Bruggenorth, hewster 0
4545166 2214409 2214409 plaintiff Bernard Ralph   619652 619652 Bernard, Ralph, of Bruggenorth 0
4545167 2214409 2214409 defendant Selman Richard   619652 619652 Selman, Richard, of Bruggenorth 0
4554340 2217285 2217285 defendant Esnam Walter chaplain 619652 619652 Esnam, Walter, of Bruggenorth, chaplain 0
4623441 2238305 2238305 defendant Alburbury John chaplain 619652 619652 Alburbury, John, of Bruggenorth, chaplain 2
4651436 2246455 2246455 defendant Baker Richard husbandman 619652 619652 Baker, Richard, of Bruggenorth, husbandman 4
4655547 2247628 2247628 defendant Adames John chapman 619652 619652 Adames, John, of Bruggenorth, chapman 1
4655554 2247629 2247629 defendant Adames John chapman 619652 619652 Adames, John, of Bruggenorth, chapman 1
4655561 2247630 2247630 defendant Adames John chapman 619652 619652 Adames, John, of Bruggenorth, chapman 1
4691204 2262770 2262770 defendant Bryne John esq 619652 619652 Bryne, John, of Bruggenorth, esq 0
4692188 2263077 2263077 defendant Ferrour William   619652 619652 Ferrour, William, of Bruggenorth, iron worker 0
4696393 2264351 2264351 plaintiff Cardemaker Henry   619652 619652 Cardemaker, Henry, of Bruggenorth 0
4733676 2275711 2275711 plaintiff Robyns John   619652 619652 Robyns, John, of Bruggenorth 0
4733677 2275711 2275711 defendant Benet Lewis chapman 619652 619652 Benet, Lewis, of Bruggenorth, chapman 0
4733678 2275711 2275711 defendant Chapman Geoffrey chapman 619652 619652 Chapman, Geoffrey, of Bruggenorth, chapman 1
4813367 2300298 2300298 defendant Benet Lewis husbandman 619652 619652 Benet, Lewis, of Bruggenorth, husbandman 0
4818914 2301999 2301999 defendant Rondull Nicholas mercer 619652 619652 Rondull, Nicholas, of Bruggenorth, mercer 2
4822114 2302995 2302995 defendant Chapman Geoffrey chapman 619652 619652 Chapman, Geoffrey, of Bruggenorth, chapman 2
4823200 2303345 2303345 defendant Lode William husbandman 619652 619652 Lode, William, of Bruggenorth, husbandman 0
4834621 2306831 2306831 plaintiff Crook Nicholas   619652 619652 Crook, Nicholas, of Bruggenorth 0
4933029 2336720 2336720 plaintiff Wylde Richard   619652 619652 Wylde, Richard, of Bruggenorth 0
4933030 2336720 2336720 defendant Wylde Richard   619652 619652 Wylde, Richard, of Bruggenorth 0
4934909 2337320 2337320 defendant Clerk William gent 619652 619652 Clerk, William, of Bruggenorth, gent 0
4964437 2346274 2346274 defendant Brook Nicholas husbandman 619652 619652 Brook, Nicholas, of Bruggenorth, husbandman 8
4968908 2347665 2347665 defendant Croke Nicholas husbandman 619652 619652 Croke, Nicholas, of Bruggenorth, husbandman 0
4992068 2354519 2354519 defendant Steventon Thomas   619652 619652 Steventon, Thomas, of Bruggenorth, lock maker 0
5040414 2368736 2368736 defendant Crouk Nicholas yeoman 619652 619652 Crouk, Nicholas, of Bruggenorth, yeoman 0
5055539 2373237 2373237 plaintiff Bruyn John (legal representative) 619652 619652 Bruyn, John, of Bruggenorth, senior, administrator of 0
5055541 2373237 2373237 defendant Crouk Nicholas yeoman 619652 619652 Crouk, Nicholas, of Bruggenorth, yeoman 0
5055542 2373238 2373238 plaintiff Bruyn John, senior (legal representative) 619652 619652 Bruyn, John, senior, of Bruggenorth, administrator of 0
5055544 2373238 2373238 defendant Crouk Nicholas yeoman 619652 619652 Crouk, Nicholas, of Bruggenorth, yeoman 0
5088695 2383071 2383071 defendant Dee Thomas tailor 619652 619652 Dee, Thomas, of Bruggenorth, tailor 0
5154899 2402593 2402593 defendant Somnour William fishmonger 619652 619652 Somnour, William, of Bruggenorth, fishmonger 0
5190489 2412962 2412962 defendant Smyth Thurstan chapman 619652 619652 Smyth, Thurstan, of Bruggenorth, chapman 0
5190491 2412962 2412962 defendant Blaker Richard baker 619652 619652 Blaker, Richard, of Bruggenorth, baker 2
5206959 2417771 2417771 defendant Smyth Thurstan chapman 619652 619652 Smyth, Thurstan, of Bruggenorth, chapman 0
5206961 2417771 2417771 defendant Baker Richard baker 619652 619652 Baker, Richard, of Bruggenorth, baker 2
5229292 2424178 2424178 defendant Overton Thomas   619652 619652 Overton, Thomas, of Bruggenorth, board hewer 2
5251249 2430494 2430494 plaintiff Wynnesbury Elizabeth   619652 619652 Wynnesbury, Elizabeth, of Bruggenorth 0
5392330 2472893 2472893 defendant Wryght John innkeeper 619652 619652 Wryght, John, of Bruggenorth, innkeeper 2
5418436 2480442 2480442 defendant Wryght John hosteller 619652 619652 Wryght, John, of Bruggenorth, hosteller 1
5419142 2480652 2480652 defendant Shipman Philip husbandman 619652 619652 Shipman, Philip, of Bruggenorth, husbandman 0
5471499 2496425 2496425 plaintiff Horde John   619652 619652 Horde, John, of Bruggenorth 0
5487445 2501140 2501140 defendant Philippes John weaver 619652 619652 Philippes, John, of Bruggenorth, weaver 0
5525130 2512450 2512450 plaintiff Bromley William   619652 619652 Bromley, William, of Bruggenorth 1
5613028 2547852 2547852 plaintiff Collyng Richard de (legal representative) 619652 619652 Collyng, Richard de, of Bruggenorth, executrix of 0
5613768 2548081 2548081 plaintiff del Grene Thomas   619652 619652 del Grene, Thomas, of Bruggenorth 0
5613769 2548081 2548081 defendant Colle John   619652 619652 Colle, John, of Bruggenorth 0

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