names

38 rows where place_id = 637102

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3834451 1968722 1968722 defendant Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
3840644 1970639 1970639 plaintiff Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
3854708 1975119 1975119 defendant Trerys Alexander Arundell gent 637102 637102 Trerys, Alexander Arundell, of Trerys, gent 0
3854710 1975120 1975120 defendant Arundell Alexander gent 637102 637102 Arundell, Alexander, of Trerys, gent 0
3912709 1994585 1994585 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4605612 2232874 2232874 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys 0
4635854 2242055 2242055 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys 0
4639426 2243044 2243044 defendant Arundell John   637102 637102 Arundell, John, of Trerys 0
4651579 2246494 2246494 plaintiff Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
4692219 2263083 2263083 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4692226 2263084 2263084 plaintiff Arundell Ralph   637102 637102 Arundell, Ralph, of Trerys 0
4717827 2270918 2270918 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4717833 2270919 2270919 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4717845 2270920 2270920 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4764172 2284787 2284787 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4828638 2304996 2304996 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4855412 2313052 2313052 plaintiff Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
4855416 2313053 2313053 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4866517 2316488 2316488 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4879153 2320418 2320418 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4880428 2320788 2320788 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4890176 2323697 2323697 defendant Arundell John   637102 637102 Arundell, John, of Trerys, or of Efford, Cornw, knight 0
4894610 2324987 2324987 defendant Arundell John   637102 637102 Arundell, John, of Trerys, or of Efford, Cornw, knight, son of Arundell, Nicholas, of Trerys juxta Trenartham, Cornw, knight 0
4901338 2327025 2327025 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4926854 2334830 2334830 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4959399 2344778 2344778 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4960388 2345074 2345074 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4986063 2352754 2352754 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
4986962 2353042 2353042 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
5014062 2360967 2360967 defendant Arundell John   637102 637102 Arundell, John, of Trerys, knight 0
5074808 2378969 2378969 defendant Arundell Joan widow 637102 637102 Arundell, Joan, of Trerys, widow 1
5243947 2428419 2428419 defendant Bassyng Richard esq 637102 637102 Bassyng, Richard, of Trerys, esq 0
5248852 2429784 2429784 defendant Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
5251917 2430704 2430704 plaintiff Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
5268003 2435755 2435755 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys 0
5277546 2438508 2438508 defendant Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 0
5518850 2510731 2510731 plaintiff Arundell John   637102 637102 Arundell, John, of Trerys 0
5518852 2510732 2510732 plaintiff Arundell John esq 637102 637102 Arundell, John, of Trerys, esq 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);