names

32 rows where place_id = 615520

✎ 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
3709316 1929211 1929211 defendant Ros Martin chaplain 615520 615520 Ros, Martin, of Over Toynton, chaplain 2
3770340 1948396 1948396 defendant Hudson John fisher 615520 615520 Hudson, John, of Over Toynton, fisher 0
3780818 1951737 1951737 defendant Alman Thomas husbandman 615520 615520 Alman, Thomas, of Over Toynton, husbandman 1
3803254 1958922 1958922 defendant Roose Martin chaplain 615520 615520 Roose, Martin, of Over Toynton, chaplain 0
3882572 1984432 1984432 defendant Rose Martin clerk 615520 615520 Rose, Martin, of Over Toynton, clerk 0
3908915 1993274 1993274 defendant Plinne "Libeum" butcher 615520 615520 Plinne, "Libeum", of Over Toynton, butcher 0
3940025 2003683 2003683 defendant Vinter William husbandman 615520 615520 Vinter, William, of Over Toynton, husbandman 1
4691996 2263031 2263031 defendant Chaloner Richard husbandman 615520 615520 Chaloner, Richard, of Over Toynton, husbandman 1
4704894 2266907 2266907 defendant Boyland Beatrice widow 615520 615520 Boyland, Beatrice, of Over Toynton, widow 0
4717163 2270696 2270696 defendant Hykson Thomas   615520 615520 Hykson, Thomas, of Over Toynton 0
4794281 2294352 2294352 defendant Alenson Thomas husbandman 615520 615520 Alenson, Thomas, of Over Toynton, husbandman 0
4887778 2323009 2323009 defendant Foulstowe Richard gent 615520 615520 Foulstowe, Richard, of Over Toynton, gent 2
5095881 2385223 2385223 defendant Claye John, junior laborer 615520 615520 Claye, John, junior, of Over Toynton, laborer 0
5124600 2393666 2393666 defendant Parker William   615520 615520 Parker, William, of Over Toynton, wright 1
5124601 2393666 2393666 defendant Campsey Edmund laborer 615520 615520 Campsey, Edmund, of Over Toynton, laborer 2
5130877 2395513 2395513 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5131160 2395604 2395604 defendant Walker William laborer & son of John 615520 615520 Walker, William, of Over Toynton, laborer & son of John 0
5131161 2395604 2395604 defendant Parker William   615520 615520 Parker, William, of Over Toynton, wright 1
5131162 2395604 2395604 defendant Campsey Edmund laborer 615520 615520 Campsey, Edmund, of Over Toynton, laborer 2
5150340 2401230 2401230 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5161470 2404455 2404455 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5168907 2406635 2406635 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5184962 2411347 2411347 defendant Kytchyn Thomas husbandman 615520 615520 Kytchyn, Thomas, of Over Toynton, husbandman 0
5185165 2411407 2411407 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5197501 2415008 2415008 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5204615 2417095 2417095 defendant Kytchyn Thomas husbandman 615520 615520 Kytchyn, Thomas, of Over Toynton, husbandman 0
5229775 2424331 2424331 defendant Lounde Richard husbandman 615520 615520 Lounde, Richard, of Over Toynton, husbandman 0
5283440 2440211 2440211 defendant Bocher John husbandman 615520 615520 Bocher, John, of Over Toynton, husbandman 2
5352623 2460916 2460916 defendant Coke Robert husbandman 615520 615520 Coke, Robert, of Over Toynton, husbandman 0
5352624 2460916 2460916 defendant Pedder Richard husbandman 615520 615520 Pedder, Richard, of Over Toynton, husbandman 1
5352626 2460916 2460916 defendant Thorp Robert husbandman 615520 615520 Thorp, Robert, of Over Toynton, husbandman 3
5352627 2460916 2460916 defendant Bekys Thomas husbandman 615520 615520 Bekys, Thomas, of Over Toynton, husbandman 4

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