names

33 rows where place_id = 606373

✎ 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
3664974 1914988 1914988 defendant Baillie Robert yeoman 606373 606373 Baillie, Robert, of Lede, yeoman 0
3664976 1914989 1914989 defendant Baillye William yeoman 606373 606373 Baillye, William, of Lede, yeoman 0
3781337 1951905 1951905 defendant Calverley Thomas gent 606373 606373 Calverley, Thomas, of Lede, gent 1
3798092 1957300 1957300 defendant Calverley Thomas gent 606373 606373 Calverley, Thomas, of Lede, gent 1
3815507 1962765 1962765 defendant Calverley Thomas gent 606373 606373 Calverley, Thomas, of Lede, gent 0
3834759 1968807 1968807 defendant Reme John clothier 606373 606373 Reme, John, of Lede, clothier 0
4544135 2214078 2214078 defendant Baldyngton John   606373 606373 Baldyngton, John, of Lede 3
4887423 2322905 2322905 defendant Hoghlet Clement husbandman 606373 606373 Hoghlet, Clement, of Lede, husbandman 0
5055101 2373098 2373098 defendant Fermour Johnm butcher 606373 606373 Fermour, Johnm, of Lede, butcher 0
5055102 2373098 2373098 defendant Lovecok John husbandman 606373 606373 Lovecok, John, of Lede, husbandman 1
5055103 2373098 2373098 defendant Trendherst Nicholas laborer 606373 606373 Trendherst, Nicholas, of Lede, laborer 2
5131553 2395710 2395710 defendant atte Water William tailor 606373 606373 atte Water, William, of Lede, tailor 0
5131554 2395710 2395710 defendant Fermour John butcher 606373 606373 Fermour, John, of Lede, butcher 1
5135980 2397034 2397034 defendant Boldyng John smith 606373 606373 Boldyng, John, of Lede, smith 2
5135981 2397034 2397034 defendant Charlys John husbandman 606373 606373 Charlys, John, of Lede, husbandman 3
5135982 2397034 2397034 defendant atte Water William tailor 606373 606373 atte Water, William, of Lede, tailor 4
5156289 2402993 2402993 defendant Frede James husbandman 606373 606373 Frede, James, of Lede, husbandman 0
5156290 2402993 2402993 defendant Hall Thomas husbandman 606373 606373 Hall, Thomas, of Lede, husbandman 1
5156291 2402993 2402993 defendant Boldyng John smith 606373 606373 Boldyng, John, of Lede, smith 2
5156292 2402993 2402993 defendant Charlys John husbandman 606373 606373 Charlys, John, of Lede, husbandman 3
5172349 2407639 2407639 defendant Hall Thomas husbandman 606373 606373 Hall, Thomas, of Lede, husbandman 0
5172350 2407639 2407639 defendant Boldyng John smith 606373 606373 Boldyng, John, of Lede, smith 1
5172351 2407639 2407639 defendant Charlys John husbandman 606373 606373 Charlys, John, of Lede, husbandman 2
5172353 2407639 2407639 defendant Frode James husbandman 606373 606373 together with Frode, James, of Lede, husbandman 4
5172355 2407640 2407640 defendant Hall Thomas husbandman 606373 606373 Hall, Thomas, of Lede, husbandman 0
5172356 2407640 2407640 defendant Goldyng John smith 606373 606373 Goldyng, John, of Lede, smith 1
5172357 2407640 2407640 defendant Charlys John husbandman 606373 606373 Charlys, John, of Lede, husbandman 2
5172359 2407640 2407640 defendant Frede James husbandman 606373 606373 together with Frede, James, of Lede, husbandman 4
5172523 2407690 2407690 defendant Frode James husbandman 606373 606373 Frode, James, of Lede, husbandman 0
5223634 2422598 2422598 defendant Water William tailor 606373 606373 Water, William, of Lede, tailor 3
5294143 2443259 2443259 defendant Scargill William, junior esq 606373 606373 Scargill, William, junior, of Lede, esq 3
5294149 2443260 2443260 defendant Scargill William, junior esq 606373 606373 Scargill, William, junior, of Lede, esq 3
5512545 2508782 2508782 defendant Caweston Thomas chapman 606373 606373 Caweston, Thomas, of Lede, chapman 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);