names

32 rows where place_id = 756995

✎ 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
4442191 2182486 2182486 defendant Smyth Richard   756995 756995 Smyth, Richard, of Haukeston 0
4442192 2182486 2182486 defendant Cok Robert   756995 756995 Cok, Robert, of Haukeston 1
4442193 2182486 2182486 defendant Clerk Henry   756995 756995 Clerk, Henry, of Haukeston 2
4442194 2182486 2182486 defendant Onewyn John smith 756995 756995 Onewyn, John, of Haukeston, smith 3
4442289 2182522 2182522 defendant Cok John   756995 756995 Cok, John, of Haukeston, vicar 0
4442292 2182523 2182523 defendant Kekeman Richard   756995 756995 Kekeman, Richard, of Haukeston 1
4442293 2182523 2182523 defendant Andrew John   756995 756995 Andrew, John, of Haukeston 2
4442294 2182523 2182523 defendant Bole William   756995 756995 Bole, William, of Haukeston 3
4465128 2189751 2189751 defendant Pouch John   756995 756995 Pouch, John, of Haukeston 0
4469471 2191114 2191114 defendant Smyth John chaplain 756995 756995 Smyth, John, of Haukeston, chaplain 0
4472905 2192202 2192202 defendant Sturmyn John   756995 756995 Sturmyn, John, of Haukeston 0
4472906 2192202 2192202 defendant Colleson John   756995 756995 Colleson, John, of Haukeston 1
4485375 2196129 2196129 defendant Aleyn John maltman 756995 756995 Aleyn, John, of Haukeston, maltman 2
4530272 2209757 2209757 defendant Sweyn Geoffrey   756995 756995 Sweyn, Geoffrey, of Haukeston 1
4652244 2246648 2246648 defendant Clerk John husbandman 756995 756995 Clerk, John, of Haukeston, husbandman 1
4652247 2246648 2246648 defendant Willesson Thomas husbandman 756995 756995 Willesson, Thomas, of Haukeston, husbandman 4
4685737 2261128 2261128 defendant Pole Richard gent 756995 756995 Pole, Richard, of Haukeston, gent 0
4690063 2262443 2262443 defendant Therlowe John husbandman 756995 756995 Therlowe, John, of Haukeston, husbandman 0
4690064 2262443 2262443 defendant Aleyn John   756995 756995 Aleyn, John, of Haukeston 1
4813392 2300303 2300303 defendant Cokkeshede Geoffrey husbandman 756995 756995 Cokkeshede, Geoffrey, of Haukeston, husbandman 0
4813394 2300303 2300303 defendant Cofyn John husbandman 756995 756995 Cofyn, John, of Haukeston, husbandman 2
4826640 2304367 2304367 defendant Podemore Thomas yeoman 756995 756995 Podemore, Thomas, of Haukeston, yeoman 0
4850385 2311576 2311576 defendant Cokkeshed Geoffrey husbandman 756995 756995 Cokkeshed, Geoffrey, of Haukeston, husbandman 0
4932267 2336493 2336493 defendant Pole Roger husbandman 756995 756995 Pole, Roger, of Haukeston, husbandman 1
4990580 2354091 2354091 defendant Trumpe John maltman 756995 756995 Trumpe, John, of Haukeston, maltman 3
5025224 2364271 2364271 defendant Preston John maltman 756995 756995 Preston, John, of Haukeston, maltman 1
5311825 2448562 2448562 defendant Muncy Thomas husbandman 756995 756995 (Muncy, Thomas, of Haukeston, husbandman 5
5311826 2448562 2448562 defendant Cokkeshed John husbandman 756995 756995 Cokkeshed, John, of Haukeston, husbandman 6
5628495 2552882 2552882 defendant Aleyn John ploughman 756995 756995 Aleyn, John, of Haukeston, ploughman 2
5628496 2552882 2552882 defendant Clerk John ploughman 756995 756995 Clerk, John, of Haukeston, ploughman 3
5628525 2552891 2552891 defendant Aleyn John ploughman 756995 756995 Aleyn, John, of Haukeston, ploughman 2
5628526 2552891 2552891 defendant Clerk John ploughman 756995 756995 Clerk, John, of Haukeston, ploughman 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);