names

22 rows where case_id = 2441648

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5288463 2441648 2441648 plaintiff Lomnore Alan     Lomnore, Alan 0
5288464 2441648 2441648 defendant Crane Thomas yeoman 590799 590799 Crane, Thomas, of Woddallyng, yeoman 0
5288465 2441648 2441648 defendant Wattys John tailor 590799 590799 Wattys, John, of Woddallyng, tailor 1
5288466 2441648 2441648 defendant Herber Roger laborer 590799 590799 Herber, Roger, of Woddallyng, laborer 2
5288467 2441648 2441648 defendant Lokke Richar laborer 590799 590799 Lokke, Richar, of Woddallyng, laborer 3
5288468 2441648 2441648 defendant Cley Thomas smith 590799 590799 Cley, Thomas, of Woddallyng, smith 4
5288469 2441648 2441648 defendant Cokman Thomas laborer 590799 590799 Cokman, Thomas, of Woddallyng, laborer 5
5288470 2441648 2441648 defendant Overdon John laborer 590799 590799 Overdon, John, of Woddallyng, laborer 6
5288471 2441648 2441648 defendant Loksmyth John husbandman 590799 590799 Loksmyth, John, of Woddallyng, husbandman 7
5288472 2441648 2441648 defendant Loksmyth William butcher 590799 590799 Loksmyth, William, of Woddallyng, butcher 8
5288473 2441648 2441648 defendant Lytylwode Richard butcher 590799 590799 Lytylwode, Richard, of Woddallyng, butcher 9
5288474 2441648 2441648 defendant Wodecroft Peter butcher 590799 590799 Wodecroft, Peter, of Woddallyng, butcher 10
5288475 2441648 2441648 defendant Wodecroft Thomas butcher 590799 590799 Wodecroft, Thomas, of Woddallyng, butcher 11
5288476 2441648 2441648 defendant Jerveys Thomas butcher 590799 590799 Jerveys, Thomas, of Woddallyng, butcher 12
5288477 2441648 2441648 defendant Laverok John laborer 591070 591070 Laverok, John, of Refham, laborer 13
5288478 2441648 2441648 defendant Broun Robert laborer 587166 587166 Broun, Robert, of Salle, laborer 14
5288479 2441648 2441648 defendant Metton Robert laborer 587166 587166 Metton, Robert, of Salle, laborer 15
5288480 2441648 2441648 defendant Bulwer John, junior yeoman 590799 590799 Bulwer, John, junior, of Woddallyng, yeoman 16
5288481 2441648 2441648 defendant Bulwer John sennior, of Woddallyng, yeoman   Bulwer, John, sennior, of Woddallyng, yeoman 17
5288482 2441648 2441648 defendant Bulwer William laborer 590799 590799 Bulwer, William, of Woddallyng, laborer 18
5288483 2441648 2441648 defendant Wygot William laborer 590799 590799 Wygot, William, of Woddallyng, laborer 19
5288484 2441648 2441648 defendant Wygot Thomas laborer 590799 590799 Wygot, Thomas, of Woddallyng, laborer 20

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