names

35 rows where place_id = 666457

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3981088 2017994 2017994 defendant Meryfyld Robert yeoman 666457 666457 Meryfyld, Robert, of Crukern, Soms, yeoman 3
3981099 2017997 2017997 defendant Vanner Roger yeoman 666457 666457 Vanner, Roger, of Crukern, Soms, yeoman 0
4584607 2226604 2226604 defendant Crukern Robert   666457 666457 Crukern, Robert, of Crukern, Soms 0
4584609 2226605 2226605 defendant Crukern Robert   666457 666457 Crukern, Robert, of Crukern, Soms 0
4697206 2264605 2264605 defendant Tort Hugh butcher 666457 666457 Tort, Hugh, of Crukern, Soms, butcher 6
4714198 2269767 2269767 defendant Crukern Robert gent 666457 666457 Crukern, Robert, of Crukern, Soms, gent 1
4714540 2269878 2269878 defendant Fysshere Roger   666457 666457 Fysshere, Roger, of Crukern, Soms, fish monger 0
4724984 2273108 2273108 defendant Coby John husbandman 666457 666457 Coby, John, of Crukern, Soms, husbandman 0
4739787 2277520 2277520 defendant Tort Hugh gent 666457 666457 Tort, Hugh, of Crukern, Soms, gent 3
4770026 2286597 2286597 defendant Reynold John   666457 666457 Reynold, John, of Crukern, Soms, hoop maker 0
4785545 2291503 2291503 defendant Smert John husbandman 666457 666457 Smert, John, of Crukern, Soms, husbandman 0
4824174 2303635 2303635 defendant Noreys John laborer 666457 666457 Noreys, John, of Crukern, Soms, laborer 0
4830370 2305531 2305531 defendant Colyn John chapman 666457 666457 Colyn, John, of Crukern, Soms, chapman 0
4859281 2314278 2314278 defendant Odelond John clerk 666457 666457 Odelond, John, of Crukern, Soms, clerk 0
4859283 2314279 2314279 defendant Odelond John clerk 666457 666457 Odelond, John, of Crukern, Soms, clerk 0
4859285 2314280 2314280 defendant Odelond John clerk 666457 666457 Odelond, John, of Crukern, Soms, clerk 0
4874220 2318881 2318881 defendant Ganet William husbandman 666457 666457 Ganet, William, of Crukern, Soms, husbandman 0
4874222 2318882 2318882 defendant Ganet William husbandman 666457 666457 Ganet, William, of Crukern, Soms, husbandman 0
4880556 2320830 2320830 defendant Blaneford Robert gent 666457 666457 Blaneford, Robert, of Crukern, Soms, gent 0
4881786 2321201 2321201 defendant Blaneford Robert gent 666457 666457 Blaneford, Robert, of Crukern, Soms, gent 0
4882461 2321425 2321425 defendant Dyar Richard dyer 666457 666457 Dyar, Richard, of Crukern, Soms, dyer 0
4901963 2327217 2327217 defendant Crukern John gent 666457 666457 Crukern, John, of Crukern, Soms, gent 0
4902005 2327231 2327231 defendant Ganet William   666457 666457 Ganet, William, of Crukern, Soms, "chopchirch" 0
4914364 2331007 2331007 defendant Deyher John dyer 666457 666457 Deyher, John, of Crukern, Soms, dyer 0
4920561 2332943 2332943 defendant Crukern John gent 666457 666457 Crukern, John, of Crukern, soms, gent 0
4929779 2335726 2335726 defendant Benet Richard yeoman 666457 666457 Benet, Richard, of Crukern, Soms, yeoman 3
4977378 2350195 2350195 defendant Smart John dyer 666457 666457 Smart, John, of Crukern, Soms, dyer 0
4997987 2356258 2356258 defendant Peverell Thomas butcher 666457 666457 Peverell, Thomas, of Crukern, Soms, butcher 2
4998433 2356410 2356410 defendant Creke John husbandman 666457 666457 Creke, John, of Crukern, Soms, husbandman 0
5188476 2412348 2412348 defendant Symson Thomas gent 666457 666457 Symson, Thomas, of Crukern, Soms, gent 0
5295503 2443674 2443674 defendant Ferneham Thomas husbandman 666457 666457 Ferneham, Thomas, of Crukern, Soms, husbandman 1
5304545 2446355 2446355 defendant More John clerk 666457 666457 More, John, of Crukern, Soms, clerk 0
5351616 2460605 2460605 defendant Enggelby William ostler 666457 666457 Enggelby, William, of Crukern, Soms, ostler 2
5365196 2464787 2464787 defendant Touker John baker 666457 666457 Touker, John, of Crukern, Soms, baker 0
5631356 2553807 2553807 defendant Typpe John gent 666457 666457 Typpe, John, of Crukern, Soms, 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);