names

25 rows where place_id = 668857

✎ 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
3929419 2000183 2000183 defendant Sare Robert   668857 668857 Sare, Robert, of Petersfeld, Hants, shoe maker 3
3990817 2021475 2021475 defendant Westbroke Robert tailor 668857 668857 Westbroke, Robert, of Petersfeld, Hants, tailor 0
3990819 2021476 2021476 plaintiff Bolde Elizabeth tailor 668857 668857 Bolde, Elizabeth, of Petersfeld, Hants, tailor 0
4000950 2025110 2025110 defendant Feelder Philip dyer 668857 668857 Feelder, Philip, of Petersfeld, Hants, dyer 0
4010323 2028456 2028456 defendant Pagelsonn John clothier 668857 668857 Pagelsonn, John, of Petersfeld, Hants, clothier 0
4026565 2034151 2034151 defendant Bensted Roger yeoman 668857 668857 Bensted, Roger, of Petersfeld, Hants, yeoman 0
4042166 2039683 2039683 plaintiff Pagelsham John clothier 668857 668857 Pagelsham, John, of Petersfeld, Hants, clothier 0
4051457 2042942 2042942 defendant Felder or Fyldar Philip dyer 668857 668857 Felder or Fyldar, Philip, of Petersfeld, Hants, dyer 0
4051461 2042943 2042943 defendant Felder Philip dyer 668857 668857 Felder, Philip, of Petersfeld, Hants, dyer 0
4051467 2042944 2042944 defendant Pagellsam John clothier 668857 668857 Pagellsam, John, of Petersfeld, Hants, clothier 1
4051472 2042945 2042945 defendant Pagelsham John clothier 668857 668857 Pagelsham, John, of Petersfeld, Hants, clothier 1
4081829 2053805 2053805 plaintiff Wolgar Joan widow 668857 668857 Wolgar, Joan, of Petersfeld, Hants, widow 0
4093659 2058054 2058054 defendant Colbroke John yeoman 668857 668857 Colbroke, John, of Petersfeld, Hants, yeoman 1
4139160 2074371 2074371 defendant Powell alias Cooke Simon yeoman 668857 668857 Powell alias Cooke, Simon, of Petersfeld, Hants, yeoman 2
4181300 2088940 2088940 defendant Colbrooke John mercer 668857 668857 Colbrooke, John, of Petersfeld, Hants, mercer 0
4181303 2088941 2088941 defendant Colbrooke John mercer 668857 668857 Colbrooke, John, of Petersfeld, Hants, mercer 0
4331956 2140982 2140982 defendant Rede Thomas gent 668857 668857 Rede, Thomas, of Petersfeld, Hants, gent 0
4670845 2256559 2256559 defendant Sidnale William yeoman 668857 668857 Sidnale, William, of Petersfeld, Hants, yeoman 1
4763790 2284664 2284664 defendant Wenman Walter chapman 668857 668857 Wenman, Walter, of Petersfeld, Hants, chapman 1
5016291 2361655 2361655 defendant Hewe John chapman 668857 668857 Hewe, John, of of Petersfeld, Hants, chapman 2
5316775 2450103 2450103 defendant Knyght Richard chapman 668857 668857 Knyght, Richard, of Petersfeld, Hants, chapman 1
5379437 2469159 2469159 defendant Morerde Thomas miller 668857 668857 Morerde, Thomas, of Petersfeld, Hants, miller 0
5412808 2478781 2478781 defendant Martyn John   668857 668857 Martyn, John, of Petersfeld, Hants, cap maker 4
5432252 2484614 2484614 defendant Wolley John yeoman 668857 668857 Wolley, John, of Petersfeld, Hants, yeoman 1
5537830 2516320 2516320 defendant Broun John yeoman 668857 668857 Broun, John, of Petersfeld, Hants, yeoman 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);