names

41 rows where place_id = 622910

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3749608 1941788 1941788 defendant Harold John chapman 622910 622910 Harold, John, of Chepyng Sodbury, chapman 1
3777368 1950667 1950667 plaintiff Clerke Christopher   622910 622910 Clerke, Christopher, of Chepyng Sodbury 0
3825050 1965709 1965709 defendant Munmer Edmund clothman 622910 622910 Munmer, Edmund, of Chepyng Sodbury, clothman 0
3827945 1966606 1966606 defendant Adams Richard yeoman 622910 622910 Adams, Richard, of Chepyng Sodbury, yeoman 0
3827946 1966606 1966606 defendant Burley Edward baker 622910 622910 Burley, Edward, of Chepyng Sodbury, baker 1
3839304 1970220 1970220 defendant Weryatt Stephen yeoman 622910 622910 Weryatt, Stephen, of Chepyng Sodbury, yeoman 0
3839309 1970222 1970222 defendant Weryat Stephen yeoman 622910 622910 Weryat, Stephen, of Chepyng Sodbury, yeoman 0
3856568 1975679 1975679 defendant Aparsnage Nicholas yeoman 622910 622910 Aparsnage, Nicholas, of Chepyng Sodbury, yeoman 1
3883575 1984776 1984776 defendant Harres Robert weaver 622910 622910 Harres, Robert, of Chepyng Sodbury, weaver 3
3883576 1984776 1984776 defendant Dodymede John weaver 622910 622910 Dodymede, John, of Chepyng Sodbury, weaver 4
3883601 1984785 1984785 defendant Wyryat John shoemaker 622910 622910 Wyryat, John, of Chepyng Sodbury, shoemaker 1
3883602 1984785 1984785 defendant West John weaver 622910 622910 West, John, of Chepyng Sodbury, weaver 2
3897769 1989460 1989460 defendant Colymore John clothier 622910 622910 Colymore, John, of Chepyng Sodbury, clothier 0
3924182 1998398 1998398 defendant Wattys John tucker 622910 622910 Wattys, John, of Chepyng Sodbury, tucker 2
4052549 2043333 2043333 defendant Cooke Edmund chapman 622910 622910 Cooke, Edmund, of Chepyng Sodbury, or of Pynsodburne, Glos, chapman 0
4684803 2260846 2260846 defendant atte Nasshe William husbandman 622910 622910 atte Nasshe, William, of Chepyng Sodbury, husbandman 0
4862823 2315358 2315358 defendant Lye Walter chapman 622910 622910 Lye, Walter, of Chepyng Sodbury, chapman 1
5055223 2373142 2373142 defendant Clerk Richard mercer 622910 622910 Clerk, Richard, of Chepyng Sodbury, mercer 1
5062043 2375205 2375205 defendant Doughton Isabel chapman 622910 622910 Doughton, Isabel, of Chepyng Sodbury, widow of Doughton, John, of Chepyng Sodbury, chapman 1
5071114 2377854 2377854 defendant Tanner alias Chapman John carrier 622910 622910 Tanner alias Chapman, John, of Chepyng Sodbury, carrier 0
5079907 2380469 2380469 defendant Baker Henry baker 622910 622910 Baker, Henry, of Chepyng Sodbury, baker 1
5369924 2466185 2466185 defendant Forthey Richard butcher 622910 622910 Forthey, Richard, of Chepyng Sodbury, butcher 0
5377157 2468446 2468446 defendant Bateman John clerk 622910 622910 Bateman, John, of Chepyng Sodbury, clerk 0
5384645 2470694 2470694 defendant Brayne John tanner 622910 622910 Brayne, John, of Chepyng Sodbury, tanner 1
5500823 2505189 2505189 defendant Boys Robert butcher 622910 622910 Boys, Robert, of Chepyng Sodbury, butcher 0
5500824 2505189 2505189 defendant Cradley John tailor 622910 622910 Cradley, John, of Chepyng Sodbury, tailor 1
5541482 2517451 2517451 defendant Harreys John shoemaker 622910 622910 Harreys, John, of Chepyng Sodbury, shoemaker 0
5541483 2517451 2517451 defendant Weriot William shoemaker 622910 622910 Weriot, William, of Chepyng Sodbury, shoemaker 1
5541484 2517451 2517451 defendant Wayte William baker 622910 622910 Wayte, William, of Chepyng Sodbury, baker 2
5541485 2517451 2517451 defendant Hochynnes William weaver 622910 622910 Hochynnes, William, of Chepyng Sodbury, weaver 3
5541486 2517451 2517451 defendant Clerke Edward baker 622910 622910 Clerke, Edward, of Chepyng Sodbury, baker 4
5541487 2517451 2517451 defendant Hykkysswan Philip weaver 622910 622910 Hykkysswan, Philip, of Chepyng Sodbury, weaver 5
5541504 2517455 2517455 defendant Harreys John shoemaker 622910 622910 Harreys, John, of Chepyng Sodbury, shoemaker 0
5541505 2517455 2517455 defendant Weriot William shoemaker 622910 622910 Weriot, William, of Chepyng Sodbury, shoemaker 1
5541506 2517455 2517455 defendant Wayte William baker 622910 622910 Wayte, William, of Chepyng Sodbury, baker 2
5541507 2517455 2517455 defendant Hochynnes William weaver 622910 622910 Hochynnes, William, of Chepyng Sodbury, weaver 3
5541508 2517455 2517455 defendant Clerke Edward baker 622910 622910 Clerke, Edward, of Chepyng Sodbury, baker 4
5541509 2517455 2517455 defendant Hykkysswan Philip weaver 622910 622910 Hykkysswan, Philip, of Chepyng Sodbury, weaver 5
5574067 2526979 2526979 defendant Adams Thomas clothier 622910 622910 Adams, Thomas, of Chepyng Sodbury, clothier 1
5574068 2526979 2526979 defendant Boys Robert butcher 622910 622910 Boys, Robert, of Chepyng Sodbury, butcher 2
5576207 2527620 2527620 defendant Corke Robert dyer 622910 622910 Corke, Robert, of Chepyng Sodbury, dyer 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);