names

15 rows where place_id = 763865

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4501153 2200963 2200963 defendant Pecke William   763865 763865 Pecke, William, of Coupull 0
4636507 2242249 2242249 defendant Ely Thomas   763865 763865 Ely, Thomas, of Coupull 1
4685247 2260982 2260982 defendant Pekk John   763865 763865 Pekk, John, of Coupull, franklin 0
4739630 2277468 2277468 defendant Vause Richard husbandman 763865 763865 Vause, Richard, of Coupull, husbandman 0
5214101 2419850 2419850 defendant Morbarn John yeoman 763865 763865 Morbarn, John, of Coupull, yeoman 3
5232242 2425007 2425007 defendant Morbarn John yeoman 763865 763865 Morbarn, John, of Coupull, yeoman 1
5305307 2446592 2446592 defendant Fage John husbandman 763865 763865 Fage, John, of Coupull, husbandman 0
5305309 2446593 2446593 defendant Rochour Thomas husbandman 763865 763865 Rochour, Thomas, of Coupull, husbandman 0
5397054 2474240 2474240 defendant Spencer Robert gent 763865 763865 Spencer, Robert, of Coupull, gent 0
5410284 2478028 2478028 defendant Spencer Robert gent 763865 763865 Spencer, Robert, of Coupull, gent 0
5424088 2482161 2482161 defendant Spencer Robert gent 763865 763865 Spencer, Robert, of Coupull, gent 0
5424090 2482162 2482162 defendant Spencer Robert gent 763865 763865 Spencer, Robert, of Coupull, gent 0
5552099 2520657 2520657 defendant Spencer John   763865 763865 Spencer, John, of Coupull 0
5629093 2553071 2553071 defendant Vaus or Vans Richard husbandman 763865 763865 Vaus or Vans, Richard, of Coupull, husbandman 1
5629097 2553072 2553072 defendant Vaus Richard husbandman 763865 763865 Vaus, Richard, of Coupull, husbandman 1

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);