names

58 rows where place_id = 640089

✎ 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
3853006 1974560 1974560 defendant Shreve Jerman husbandman 640089 640089 Shreve, Jerman, of Tilney, husbandman 3
4171326 2085433 2085433 defendant Fetherycke alias Thedrycke William husbandman 640089 640089 Fetherycke alias Thedrycke, William, of Tilney, husbandman 0
4260491 2116476 2116476 defendant Chappell William yeoman 640089 640089 Chappell, William, of Tilney, yeoman 0
4364675 2152424 2152424 defendant Beresforde John gent 640089 640089 Beresforde, John, of Tilney, gent 0
4398997 2164247 2164247 defendant Shrymplyn John husbandman 640089 640089 Shrymplyn, John, of Tilney, husbandman 0
4647604 2245353 2245353 defendant Goygold Adam   640089 640089 Goygold, Adam, of Tilney 5
4667976 2255691 2255691 plaintiff Baldyng John   640089 640089 Baldyng, John, of Tilney, on his own account 0
4677022 2258431 2258431 defendant Colte Peter husbandman 640089 640089 Colte, Peter, of Tilney, husbandman 2
4677023 2258431 2258431 defendant Dykon John husbandman 640089 640089 Dykon, John, of Tilney, husbandman 3
4705055 2266952 2266952 defendant Taillour Thomas husbandman 640089 640089 Taillour, Thomas, of Tilney, husbandman 1
4708395 2267992 2267992 defendant Jakes John husbandman 640089 640089 Jakes, John, of Tilney, husbandman 1
4730032 2274594 2274594 defendant Bulwer Thomas yeoman 640089 640089 Bulwer, Thomas, of Tilney, yeoman 3
4740904 2277851 2277851 defendant Sammes Richard husbandman 640089 640089 Sammes, Richard, of Tilney, husbandman 10
4763979 2284726 2284726 defendant Taylour Geoffrey yeoman 640089 640089 Taylour, Geoffrey, of Tilney, yeoman 3
4780067 2289771 2289771 defendant Lane John yeoman 640089 640089 Lane, John, of Tilney, yeoman 0
4946469 2340891 2340891 defendant Gedney Thomas   640089 640089 Gedney, Thomas, of Tilney, servant 0
4952382 2342667 2342667 defendant Huberd Robert laborer 640089 640089 Huberd, Robert, of Tilney, laborer 0
4972342 2348666 2348666 plaintiff Rogere Richard   640089 640089 (Rogere, Richard, of Tilney 1
4972349 2348667 2348667 plaintiff Rogere Richard   640089 640089 (Rogere, Richard, of Tilney 1
4972356 2348667 2348667 defendant Colt Robert husbandman 640089 640089 Colt, Robert, of Tilney, husbandman 4
4982348 2351635 2351635 defendant Blower John gent 640089 640089 Blower, John, of Tilney, gent 2
5018722 2362368 2362368 defendant Flory Robert husbandman 640089 640089 Flory, Robert, of Tilney, husbandman 0
5018723 2362368 2362368 defendant Leveryche Thomas husbandman 640089 640089 Leveryche, Thomas, of Tilney, husbandman 1
5031809 2366174 2366174 defendant Flory Robert yeoman 640089 640089 Flory, Robert, of Tilney, yeoman 0
5033247 2366604 2366604 defendant Bernewell John husbandman 640089 640089 Bernewell, John, of Tilney, husbandman 0
5033248 2366604 2366604 defendant Lenton John husbandman 640089 640089 Lenton, John, of Tilney, husbandman 1
5033251 2366605 2366605 defendant Scarnyng John husbandman 640089 640089 Scarnyng, John, of Tilney, husbandman 0
5037871 2367955 2367955 defendant Leverych Thomas yeoman 640089 640089 Leverych, Thomas, of Tilney, yeoman 1
5049108 2371366 2371366 defendant Noreys John husbandman 640089 640089 Noreys, John, of Tilney, husbandman 0
5049109 2371366 2371366 defendant Baxster Thomas husbandman 640089 640089 Baxster, Thomas, of Tilney, husbandman 1
5053389 2372616 2372616 defendant Spyrard John husbandman 640089 640089 Spyrard, John, of Tilney, husbandman 3
5100329 2386544 2386544 defendant Noreys Geoffrey yeoman 640089 640089 Noreys, Geoffrey, of Tilney, yeoman 1
5123797 2393418 2393418 defendant Norys John yeoman 640089 640089 Norys, John, of Tilney, yeoman, son of Norys, William, of Tilney, yeoman 0
5133788 2396373 2396373 defendant Bulwere Robert, senior husbandman 640089 640089 Bulwere, Robert, senior, of Tilney, husbandman 0
5148751 2400756 2400756 defendant Mowere John husbandman 640089 640089 Mowere, John, of Tilney, husbandman 0
5149694 2401040 2401040 defendant Craunton Richard chaplain 640089 640089 Craunton, Richard, of Tilney, chaplain 0
5153731 2402251 2402251 defendant Bulwere Robert, sen husbandman 640089 640089 Bulwere, Robert, sen, of Tilney, husbandman 0
5153732 2402251 2402251 defendant Gauge Edmund (legal representative) 640089 640089 Gauge, Edmund, of Tilney, husbandman, executrix of 1
5153733 2402251 2402251 defendant Gauge Katherine widow 640089 640089 Gauge, Katherine, of Tilney, widow 2
5163314 2405005 2405005 defendant Mower Robert husbandman 640089 640089 Mower, Robert, of Tilney, husbandman 0
5166638 2405965 2405965 defendant Nowne John husbandman 640089 640089 Nowne, John, of Tilney, husbandman 1
5167862 2406313 2406313 defendant Curson Thomas gent 640089 640089 Curson, Thomas, of Tilney, gent 0
5171041 2407254 2407254 defendant Bulwere Robert, sen husbandman 640089 640089 Bulwere, Robert, sen, of Tilney, husbandman 0
5171042 2407254 2407254 defendant Gauge Edmund (legal representative) 640089 640089 Gauge, Edmund, of Tilney, husbandman, executrix of 1
5171043 2407254 2407254 defendant Gauge Katherine widow 640089 640089 Gauge, Katherine, of Tilney, widow 2
5172820 2407785 2407785 defendant Curson Thomas gent 640089 640089 Curson, Thomas, of Tilney, gent 0
5181849 2410437 2410437 defendant Colman Nicholas (legal representative) 640089 640089 Colman, Nicholas, of Tilney, executors of 0
5183504 2410912 2410912 defendant Tilney Thomas gent 640089 640089 Tilney, Thomas, of Tilney, gent 0
5212491 2419399 2419399 defendant Rose Simon tailor 640089 640089 Rose, Simon, of Tilney, tailor 0
5219982 2421555 2421555 defendant Curson Thomas gent 640089 640089 Curson, Thomas, of Tilney, gent 0
5343204 2458068 2458068 defendant Mower Thomas husbandman 640089 640089 Mower, Thomas, of Tilney, husbandman 0
5351007 2460426 2460426 defendant Noreys William tailor 640089 640089 Noreys, William, of Tilney, tailor 1
5422690 2481737 2481737 defendant Burton Robert husbandman 640089 640089 Burton, Robert, of Tilney, husbandman 3
5474914 2497479 2497479 defendant Norrys John   640089 640089 Norrys, John, of Tilney, wheelwright 0
5504886 2506444 2506444 defendant Baldyng John, senior (legal representative) 640089 640089 Baldyng, John, senior, of Tilney, executor of 3
5504887 2506444 2506444 defendant Baldyng William chaplain 640089 640089 Baldyng, William, of Tilney, chaplain 4
5506763 2507035 2507035 defendant Flory John yeoman 640089 640089 Flory, John, of Tilney, yeoman 0
5617534 2549304 2549304 defendant Danbere Adam   640089 640089 Danbere, Adam, of Tilney 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);