names

32 rows where place_id = 593285

✎ 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
3611197 1871178 1871178 defendant Assheley William husbandman 593285 593285 Assheley, William, of Rygge, husbandman 1
3611198 1871178 1871178 defendant Brytte Thomas laborer 593285 593285 Brytte, Thomas, of Rygge, laborer 2
3611199 1871178 1871178 defendant Redpyth Vincent laborer 593285 593285 Redpyth, Vincent, of Rygge, laborer 3
3725673 1934315 1934315 defendant Payne William husbandman 593285 593285 Payne, William, of Rygge, husbandman 0
3789821 1954647 1954647 defendant Basse Robert husbandman 593285 593285 Basse, Robert, of Rygge, husbandman 0
3852276 1974312 1974312 defendant Basse William husbandman 593285 593285 Basse, William, of Rygge, husbandman 0
4463172 2189179 2189179 defendant Sherrene William   593285 593285 Sherrene, William, of Rygge 0
4729297 2274379 2274379 defendant Okeford John thatcher 593285 593285 Okeford, John, of Rygge, thatcher 0
4825718 2304086 2304086 defendant Roteland John drover 593285 593285 Roteland, John, of Rygge, drover 0
4825723 2304087 2304087 defendant Rogelan John drover 593285 593285 Rogelan, John, of Rygge, drover 3
4893430 2324646 2324646 defendant Chapell John husbandman 593285 593285 Chapell, John, of Rygge, husbandman 2
4896068 2325428 2325428 defendant Neweman Thomas   593285 593285 Neweman, Thomas, of Rygge, tile maker 1
4913392 2330689 2330689 defendant Theyne John husbandman 593285 593285 Theyne, John, of Rygge, husbandman 0
4929066 2335513 2335513 plaintiff Stanet William husbandman 593285 593285 Stanet, William, of Rygge, husbandman 0
4971675 2348456 2348456 defendant Bocher John laborer 593285 593285 Bocher, John, of Rygge, laborer 1
4971676 2348456 2348456 defendant Whatenden William husbandman 593285 593285 Whatenden, William, of Rygge, husbandman 2
4979037 2350688 2350688 defendant Rygge John husbandman 593285 593285 Rygge, John, of Rygge, husbandman 1
5098640 2386034 2386034 defendant Sterte John husbandman 593285 593285 Sterte, John, of Rygge, husbandman 1
5202776 2416578 2416578 defendant Neweman Thomas   593285 593285 Neweman, Thomas, of Rygge 0
5375857 2468040 2468040 defendant Neweman Robert laborer 593285 593285 Neweman, Robert, of Rygge, laborer 0
5378993 2469021 2469021 defendant Parkyn John colyer 593285 593285 Parkyn, John, of Rygge, colyer 2
5382437 2470036 2470036 defendant Perkyn John colyer 593285 593285 Perkyn, John, of Rygge, colyer 1
5405777 2476724 2476724 defendant Neweman William laborer 593285 593285 Neweman, William, of Rygge, laborer 1
5405778 2476724 2476724 defendant Perkyn John colier 593285 593285 Perkyn, John, of Rygge, colier 2
5419935 2480880 2480880 defendant Perkyn Thomas husbandman 593285 593285 Perkyn, Thomas, of Rygge, husbandman 1
5438393 2486415 2486415 defendant Perkyn John, sen collier 593285 593285 Perkyn, John, sen, of Rygge, collier 0
5471139 2496305 2496305 defendant Parker John collier 593285 593285 Parker, John, of Rygge, collier 3
5498608 2504527 2504527 plaintiff Okeford Thomas   593285 593285 Okeford, Thomas, of Rygge 0
5498610 2504527 2504527 plaintiff Gucche William   593285 593285 Gucche, William, of Rygge 2
5511883 2508571 2508571 defendant Parkyn John collier 593285 593285 Parkyn, John, of Rygge, collier 3
5609314 2537815 2537815 defendant Perkyn John collier 593285 593285 Perkyn, John, of Rygge, collier 1
5631096 2553732 2553732 defendant Watenden John ploughman 593285 593285 Watenden, John, of Rygge, ploughman 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);