names

30 rows where place_id = 597005

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626895 1903263 1903263 defendant Hayle John, senior yeoman or parker 597005 597005 Hayle, John, senior, of Whynbergh, yeoman or parker 0
3654865 1911781 1911781 defendant Wyxkys Robert carpenter 597005 597005 Wyxkys, Robert, of Whynbergh, carpenter 0
3660956 1913698 1913698 defendant Sheffeld John husbandman 597005 597005 Sheffeld, John, of Whynbergh, husbandman 2
3682367 1920587 1920587 defendant Wynbergh George   597005 597005 Wynbergh, George, of Whynbergh, gent, administrators of 0
3682368 1920587 1920587 defendant Jamesson John   597005 597005 (Jamesson, John, of Whynbergh, court holder 1
3709763 1929367 1929367 defendant Whynbergh Henry gent 597005 597005 Whynbergh, Henry, of Whynbergh, gent 0
3822784 1965031 1965031 defendant Mere Richard husbandman 597005 597005 Mere, Richard, of Whynbergh, husbandman 0
3824266 1965464 1965464 defendant Webster Francis husbandman 597005 597005 Webster, Francis, of Whynbergh, husbandman 0
3835512 1969047 1969047 defendant Webster John clerk 597005 597005 Webster, John, of Whynbergh, clerk 0
3859765 1976766 1976766 defendant Lawes Thomas husbandman 597005 597005 Lawes, Thomas, of Whynbergh, husbandman 1
3910540 1993841 1993841 defendant Webster John clerk 597005 597005 Webster, John, of Whynbergh, clerk 1
4265002 2117929 2117929 defendant Davye Hugh drover 597005 597005 Davye, Hugh, of Whynbergh, drover 1
4453186 2186004 2186004 plaintiff Langetoft John   597005 597005 Langetoft, John, of Whynbergh 0
4744156 2278817 2278817 defendant Cullyng John husbandman 597005 597005 Cullyng, John, of Whynbergh, husbandman 0
4744157 2278817 2278817 defendant Cullyng Phillip husbandman 597005 597005 Cullyng, Phillip, of Whynbergh, husbandman 1
4831485 2305877 2305877 defendant Cullyng John yeoman 597005 597005 Cullyng, John, of Whynbergh, yeoman 4
4838075 2307829 2307829 defendant Eliot William yeoman 597005 597005 Eliot, William, of Whynbergh, yeoman 2
4929508 2335643 2335643 defendant Okenden Stephen (legal representative) 597005 597005 Okenden, Stephen, of Whynbergh, administratrix of 7
4968579 2347567 2347567 defendant Norton Richard butcher 597005 597005 Norton, Richard, of Whynbergh, butcher 3
4986842 2353004 2353004 defendant Amerynghale William gent 597005 597005 Amerynghale, William, of Whynbergh, gent 0
4995272 2355432 2355432 defendant Norton Richard butcher 597005 597005 Norton, Richard, of Whynbergh, butcher 3
5023196 2363685 2363685 defendant Fypers Lawrnce gent 597005 597005 Fypers, Lawrnce, of Whynbergh, gent 1
5057298 2373750 2373750 defendant Crulle John husbandman 597005 597005 Crulle, John, of Whynbergh, husbandman 1
5065653 2376256 2376256 defendant Shene Robert husbandman 597005 597005 Shene, Robert, of Whynbergh, husbandman 1
5075125 2379058 2379058 defendant Brook Walter husbandman 597005 597005 Brook, Walter, of Whynbergh, husbandman 5
5090255 2383521 2383521 defendant Skernyng Thomas clerk 597005 597005 Skernyng, Thomas, of Whynbergh, clerk 2
5114620 2390689 2390689 defendant Whynbergh Richard gent 597005 597005 Whynbergh, Richard, of Whynbergh, gent 0
5250601 2430297 2430297 defendant Gurle Philip yeoman 597005 597005 Gurle, Philip, of Whynbergh, yeoman 2
5275491 2437901 2437901 defendant Skernyng Thomas clerk 597005 597005 Skernyng, Thomas, of Whynbergh, clerk 3
5376994 2468398 2468398 defendant Whynbergh Richard gent 597005 597005 Whynbergh, Richard, of Whynbergh, gent 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);