names

49 rows where place_id = 654046

✎ 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
3811527 1961499 1961499 defendant Dalston Thomas gent 654046 654046 Dalston, Thomas, of Dalston, Cumber, gent 0
3930793 2000645 2000645 defendant Relf Robert husbandman 654046 654046 Relf, Robert, of Dalston, husbandman 0
3930794 2000645 2000645 defendant Bryg William husbandman 654046 654046 Bryg, William, of Dalston, husbandman 1
4253305 2114096 2114096 defendant Fawdon William (legal representative) 654046 654046 Fawdon, William, of Dalston, Cumber, yeoman, executrix of 2
4253306 2114096 2114096 defendant Fawdon Jenetta widow 654046 654046 Fawdon, Jenetta, of Dalston, widow 3
4266581 2118468 2118468 defendant Fawdon William (legal representative) 654046 654046 Fawdon, William, of Dalston, yeoman, executrix of 2
4266582 2118468 2118468 defendant Fawdon Jenetta widow 654046 654046 Fawdon, Jenetta, of Dalston, Cumber, widow 3
4365617 2152766 2152766 defendant Fadden William (legal representative) 654046 654046 Fadden, William, of Dalston, yeoman, administratrix of 0
4365618 2152766 2152766 defendant Fadden Jenetta widow 654046 654046 Fadden, Jenetta, of Dalston, widow 1
4462440 2188946 2188946 plaintiff Taillour John   654046 654046 Taillour, John, of Dalston 0
4498801 2200259 2200259 defendant Thomson William   654046 654046 Thomson, William, of Dalston 0
4613343 2235206 2235206 defendant Raynoldeson Robert   654046 654046 Raynoldeson, Robert, of Dalston 0
4722315 2272303 2272303 defendant Stubbe John yeoman 654046 654046 Stubbe, John, of Dalston, yeoman 0
4729079 2274328 2274328 defendant Stubbe William yeoman 654046 654046 Stubbe, William, of Dalston, yeoman 3
4778201 2289166 2289166 defendant Keswyk John yeoman 654046 654046 Keswyk, John, of Dalston, yeoman 1
4778202 2289166 2289166 defendant Bampton John husbandman 654046 654046 Bampton, John, of Dalston, husbandman 2
4783977 2290998 2290998 defendant Colman John yeoman 654046 654046 Colman, John, of Dalston, yeoman 1
4792630 2293783 2293783 defendant Mortymer John yeoman 654046 654046 Mortymer, John, of Dalston, yeoman 3
4821001 2302654 2302654 defendant Dalston de Henry gent 654046 654046 Dalston de, Henry, of Dalston, gent 0
4833702 2306550 2306550 defendant Leswyk John yeoman 654046 654046 Leswyk, John, of Dalston, yeoman 1
4842781 2309280 2309280 defendant Stobe William yeoman 654046 654046 together with Stobe, William, of Dalston, yeoman 3
4844237 2309705 2309705 defendant Reynaldson Robert yeoman 654046 654046 Reynaldson, Robert, of Dalston, yeoman 1
4848687 2311059 2311059 defendant Raynaldson Robert yeoman 654046 654046 Raynaldson, Robert, of Dalston, yeoman 0
4848688 2311059 2311059 defendant Husley Alan yeoman 654046 654046 Husley, Alan, of Dalston, yeoman 1
4869403 2317398 2317398 defendant Stub John yeoman 654046 654046 Stub, John, of Dalston, yeoman 1
4871590 2318085 2318085 defendant Raynaldson Robert yeoman 654046 654046 Raynaldson, Robert, of Dalston, yeoman 1
4961286 2345343 2345343 defendant Stork John yeoman 654046 654046 Stork, John, of Dalston, yeoman 0
4975064 2349514 2349514 defendant Storke John yeoman 654046 654046 Storke, John, of Dalston, yeoman 7
4980903 2351225 2351225 defendant Storke John yeoman 654046 654046 Storke, John, of Dalston, yeoman 0
4980904 2351225 2351225 defendant Uslay Alan yeoman 654046 654046 Uslay, Alan, of Dalston, yeoman 1
4981147 2351293 2351293 defendant Richardson John yeoman 654046 654046 Richardson, John, of Dalston, yeoman 1
4981148 2351293 2351293 defendant Rynaway William yeoman 654046 654046 Rynaway, William, of Dalston, yeoman 2
4981149 2351293 2351293 defendant Patonson William yeoman 654046 654046 Patonson, William, of Dalston, yeoman 3
4992317 2354594 2354594 defendant Holme Alan husbandman 654046 654046 Holme, Alan, of Dalston, husbandman 2
4992332 2354597 2354597 defendant Falder Henry yeoman 654046 654046 Falder, Henry, of Dalston, yeoman 3
4992383 2354608 2354608 defendant Uslay Alan yeoman 654046 654046 Uslay, Alan, of Dalston, yeoman 2
4992384 2354608 2354608 defendant Grisedale John yeoman 654046 654046 Grisedale, John, of Dalston, yeoman 3
5001699 2357394 2357394 defendant Trumpet Thomas yeoman 654046 654046 Trumpet, Thomas, of Dalston, yeoman 0
5455457 2491543 2491543 defendant Louther John gent 654046 654046 Louther, John, of Dalston, gent 0
5632554 2554214 2554214 defendant Benette Henry yeoman 654046 654046 Benette, Henry, of Dalston, yeoman 3
5632555 2554214 2554214 defendant Withre Thomas   654046 654046 Withre, Thomas, of Dalston yeoman 4
5632557 2554214 2554214 defendant Keswyk John yeoman 654046 654046 Keswyk, John, of Dalston, yeoman 6
5632558 2554214 2554214 defendant del Barre Geoffrey yeoman 654046 654046 together with del Barre, Geoffrey, of Dalston, yeoman 7
5632567 2554214 2554214 defendant Tyngate John yeoman 654046 654046 Tyngate, John, of Dalston, yeoman 16
5632571 2554216 2554216 defendant del Barre Geoffrey yeoman 654046 654046 del Barre, Geoffrey, of Dalston, yeoman 0
5632580 2554216 2554216 defendant Tyngate John yeoman 654046 654046 Tyngate, John, of Dalston, yeoman 9
5632584 2554216 2554216 defendant Benette Henry yeoman 654046 654046 Benette, Henry, of Dalston, yeoman 13
5632585 2554216 2554216 defendant Withre Thomas   654046 654046 Withre, Thomas, of Dalston yeoman 14
5632587 2554216 2554216 defendant Keswyk John yeoman 654046 654046 Keswyk, John, of Dalston, yeoman 16

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