names

19 rows where place_id = 804487

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4803718 2297346 2297346 plaintiff Beauchamp Mary   804487 804487 Beauchamp, Mary, of Canonlegh, abbess 0
4963753 2346070 2346070 defendant Welyngton John yeoman 804487 804487 Welyngton, John, of Canonlegh, yeoman 3
5124997 2393787 2393787 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, Abbess 0
5124999 2393788 2393788 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, Abbess 0
5143641 2399275 2399275 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5143644 2399276 2399276 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5164790 2405434 2405434 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5164792 2405435 2405435 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5178261 2409345 2409345 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5201369 2416157 2416157 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5201371 2416158 2416158 plaintiff Arundell Joan   804487 804487 Arundell, Joan, of Canonlegh, abbess 0
5313758 2449142 2449142 defendant Pyttyn John husbandman 804487 804487 Pyttyn, John, of Canonlegh, husbandman 1
5374571 2467654 2467654 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, abbess 0
5374574 2467655 2467655 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, abbess of 0
5391229 2472569 2472569 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, abbess 0
5404212 2476282 2476282 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, Abbess 0
5417353 2480107 2480107 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, abbess 0
5417356 2480108 2480108 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, abbess 0
5417359 2480109 2480109 plaintiff Parker Alice   804487 804487 Parker, Alice, of Canonlegh, abbess 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);