names

19 rows where place_id = 600621

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641822 1907891 1907891 defendant Hedge William chapman 600621 600621 Hedge, William, of Ilmystre, chapman 0
4473551 2192385 2192385 defendant Curteys William   600621 600621 Curteys, William, of Ilmystre 0
4639253 2242997 2242997 plaintiff Coke John   600621 600621 Coke, John, of Ilmystre 0
4654094 2247161 2247161 defendant Destrell Thomas   600621 600621 Destrell, Thomas, of Ilmystre, millward 5
4679429 2259182 2259182 defendant Orchard John mercer 600621 600621 Orchard, John, of Ilmystre, mercer 0
4787733 2292231 2292231 defendant Dylyngton Maud   600621 600621 Dylyngton, Maud, of Ilmystre, widow of Dylyngton, Richard 0
4820166 2302379 2302379 defendant Sely John seaver 600621 600621 Sely, John, of Ilmystre, seaver 1
4864618 2315907 2315907 defendant Bryan Richard shoemaker 600621 600621 Bryan, Richard, of Ilmystre, shoemaker 0
4875310 2319232 2319232 defendant Jule Edward   600621 600621 Jule, Edward, of Ilmystre, holy water clerk 0
4910884 2329914 2329914 defendant Wymond John chapman 600621 600621 Wymond, John, of Ilmystre, chapman 3
4953962 2343147 2343147 defendant Curteys John husbandman 600621 600621 Curteys, John, of Ilmystre, husbandman 0
5035614 2367274 2367274 defendant Strete Henry dyer 600621 600621 Strete, Henry, of Ilmystre, dyer 6
5084686 2381934 2381934 defendant Imberley John yeoman 600621 600621 Imberley, John, of Ilmystre, yeoman 0
5097060 2385573 2385573 defendant Cadewell John chapman 600621 600621 Cadewell, John, of Ilmystre, chapman 0
5110347 2389429 2389429 defendant Wattys William merchant 600621 600621 Wattys, William, of Ilmystre, merchant 1
5327049 2453167 2453167 plaintiff Thorne Thomas   600621 600621 Thorne, Thomas, of Ilmystre 0
5454693 2491326 2491326 plaintiff Baale John mercer 600621 600621 Baale, John, of Ilmystre, mercer 0
5562846 2523723 2523723 defendant Patwyn Thomas yeoman 600621 600621 Patwyn, Thomas, of Ilmystre, yeoman 0
5578755 2528419 2528419 plaintiff Bale John mercer 600621 600621 Bale, John, of Ilmystre, mercer 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);