names

39 rows where place_id = 766173

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4450017 2184964 2184964 plaintiff Gynewell William   766173 766173 Gynewell, William, of Leighton Buzzard, prebendary & parson 0
4525252 2208237 2208237 defendant Smyth John   766173 766173 Smyth, John, of Leighton Buzzard 0
4548564 2215492 2215492 plaintiff Clement John (legal representative) 766173 766173 Clement, John, of Leighton Buzzard, executors of 0
4614194 2235452 2235452 defendant Glover Richard   766173 766173 Glover, Richard, of Leighton Buzzard 0
4622448 2238003 2238003 defendant Fissher John   766173 766173 Fissher, John, of Leighton Buzzard 1
4641381 2243573 2243573 defendant Waryn Walter   766173 766173 Waryn, Walter, of Leighton Buzzard 0
4712212 2269133 2269133 defendant Margery John butcher 766173 766173 Margery, John, of Leighton Buzzard, butcher 0
4734627 2275991 2275991 defendant Coltyngton William smith 766173 766173 Coltyngton, William, of Leighton Buzzard, smith 0
4736202 2276458 2276458 defendant Holynden Thomas husbandman 766173 766173 Holynden, Thomas, of Leighton Buzzard, husbandman 0
4737740 2276907 2276907 defendant Holynden Thomas yeoman 766173 766173 Holynden, Thomas, of Leighton Buzzard, yeoman 0
4847350 2310675 2310675 defendant North John butcher 766173 766173 North, John, of Leighton Buzzard, butcher 0
5000222 2356942 2356942 defendant Levet Joan   766173 766173 Levet, Joan, of Leighton Buzzard, widow, formerly wife of Thomas 4
5165990 2405796 2405796 defendant Savage Richard husbandman 766173 766173 Savage, Richard, of Leighton Buzzard, husbandman 3
5165991 2405796 2405796 defendant Gaddesden Henry yeoman 766173 766173 Gaddesden, Henry, of Leighton Buzzard, yeoman 4
5179159 2409639 2409639 defendant Bernard John mercer 766173 766173 Bernard, John, of Leighton Buzzard, mercer 0
5179160 2409639 2409639 defendant Leveryche Edmund husbandman 766173 766173 Leveryche, Edmund, of Leighton Buzzard, husbandman 1
5180715 2410100 2410100 defendant Savage Richard husbandman 766173 766173 Savage, Richard, of Leighton Buzzard, husbandman 2
5180716 2410100 2410100 defendant Gaddesden Henry yeoman 766173 766173 Gaddesden, Henry, of Leighton Buzzard, yeoman 3
5274733 2437688 2437688 defendant Margery Thomas butcher 766173 766173 Margery, Thomas, of Leighton Buzzard, butcher 1
5383216 2470272 2470272 defendant Alegh William yeoman 766173 766173 Alegh, William, of Leighton Buzzard, yeoman 0
5419959 2480885 2480885 defendant Fo_ Thomas butcher 766173 766173 Fo_, Thomas, of Leighton Buzzard, butcher 2
5424079 2482158 2482158 defendant Braine Robert husbandman 766173 766173 Braine, Robert, of Leighton Buzzard, husbandman 1
5433564 2485000 2485000 defendant Braynton Thomas tailor 766173 766173 Braynton, Thomas, of Leighton Buzzard, tailor 2
5434579 2485281 2485281 defendant Godriche John gent 766173 766173 Godriche, John, of Leighton Buzzard, gent 6
5434580 2485281 2485281 defendant Harryk Thomas tanner 766173 766173 Harryk, Thomas, of Leighton Buzzard, tanner 7
5434588 2485282 2485282 defendant Godryche John gent 766173 766173 Godryche, John, of Leighton Buzzard, gent 6
5434589 2485282 2485282 defendant Harryk Thomas tanner 766173 766173 Harryk, Thomas, of Leighton Buzzard, tanner 7
5434597 2485283 2485283 defendant Godrich John gent 766173 766173 Godrich, John, of Leighton Buzzard, gent 6
5434598 2485283 2485283 defendant Harryk Thomas tanner 766173 766173 Harryk, Thomas, of Leighton Buzzard, tanner 7
5438496 2486449 2486449 defendant Fookys Thomas butcher 766173 766173 Fookys, Thomas, of Leighton Buzzard, butcher 2
5452719 2490695 2490695 defendant Reynar William chandler 766173 766173 Reynar, William, of Leighton Buzzard, chandler 1
5452720 2490695 2490695 defendant Fookys William butcher 766173 766173 Fookys, William, of Leighton Buzzard, butcher 2
5458895 2492555 2492555 plaintiff Godench Richard   766173 766173 Godench, Richard, of Leighton Buzzard 0
5458896 2492555 2492555 defendant Person Thomas yeoman 766173 766173 Person, Thomas, of Leighton Buzzard, yeoman 0
5470473 2496089 2496089 plaintiff Godench Richard   766173 766173 Godench, Richard, of Leighton Buzzard 0
5470474 2496089 2496089 defendant Person Thomas yeoman 766173 766173 Person, Thomas, of Leighton Buzzard, yeoman 0
5470476 2496090 2496090 plaintiff Godenek or Godench Richard   766173 766173 Godenek or Godench, Richard, of Leighton Buzzard 0
5470477 2496090 2496090 defendant Person Thomas yeoman 766173 766173 Person, Thomas, of Leighton Buzzard, yeoman 0
5621644 2550671 2550671 defendant Stokes Thomas   766173 766173 Stokes, Thomas, of Leighton Buzzard 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);