names

18 rows where place_id = 642455

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3868066 1979553 1979553 defendant Sawgate Robert husbandman 642455 642455 Sawgate, Robert, of Combes, Suff, husbandman 1
3868071 1979554 1979554 defendant Sawgate Robert husbandman 642455 642455 Sawgate, Robert, of Combes, Suff, husbandman 1
3868076 1979555 1979555 defendant Sewgate Robert husbandman 642455 642455 Sewgate, Robert, of Combes, Suff, husbandman 1
3868081 1979556 1979556 defendant Sawyate Robert husbandman 642455 642455 Sawyate, Robert, of Combes, Suff, husbandman 1
4339767 2143680 2143680 defendant Pyssy John husbandman 642455 642455 Pyssy, John, of Combes, Suff, husbandman 0
5005113 2358393 2358393 defendant Baldewyn Thomas laborer 642455 642455 Baldewyn, Thomas, of Combes, Suff, laborer 9
5018414 2362269 2362269 defendant Resshebrook John gent 642455 642455 Resshebrook, John, of Combes, Suff, gent 0
5020155 2362783 2362783 defendant Russhebrook John gent 642455 642455 Russhebrook, John, of Combes, Suff, gent 0
5141117 2398526 2398526 defendant Smyth Thomas yeoman 642455 642455 Smyth, Thomas, of Combes, Suff, yeoman 0
5142792 2399020 2399020 defendant Resshebrook John gent 642455 642455 Resshebrook, John, of Combes, Suff, gent 0
5162303 2404702 2404702 defendant Smyth Thomas yeoman 642455 642455 Smyth, Thomas, of Combes, Suff, yeoman 0
5166436 2405909 2405909 defendant Resshebrook John gent 642455 642455 Resshebrook, John, of Combes, Suff, gent 0
5166440 2405910 2405910 defendant Resshebrook John gent 642455 642455 Resshebrook, John, of Combes, Suff, gent 0
5213554 2419697 2419697 defendant Bakke John yeoman 642455 642455 Bakke, John, of Combes, Suff, yeoman 2
5213555 2419697 2419697 defendant Trytare Thomas yeoman 642455 642455 Trytare, Thomas, of Combes, Suff, yeoman 3
5275070 2437789 2437789 defendant Stalpy John husbandman 642455 642455 Stalpy, John, of Combes, Suff, husbandman 0
5293006 2442942 2442942 defendant Scalpy John husbandman 642455 642455 Scalpy, John, of Combes, Suff, husbandman 3
5483120 2499890 2499890 defendant Smyth William yeoman 642455 642455 Smyth, William, of Combes, Suff, yeoman 3

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