names

15 rows where case_id = 2440580

✎ 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
5284823 2440580 2440580 plaintiff Gleson or Eleson William     Gleson or Eleson, William 0
5284824 2440580 2440580 defendant Wylde John   585936 585936 Wylde, John, of Norwich, worsted weaver 0
5284825 2440580 2440580 defendant Rysseley John gent 868609 868609 Rysseley, John, of Magna Cressynghm, gent 1
5284826 2440580 2440580 defendant Gunore Robert   868610 868610 Gunore, Robert, of Holkham, gnt 2
5284827 2440580 2440580 defendant Spynke John husbandman 593527 593527 Spynke, John, of Saxlyngham, husbandman 3
5284828 2440580 2440580 defendant Myles John husbandman 593527 593527 Myles, John, of Saxlyngham, husbandman 4
5284829 2440580 2440580 defendant Sharryngton John gent 868611 868611 Sharryngton, John, of Colethorp, gent 5
5284830 2440580 2440580 defendant Harkyn John husbandman 596885 596885 Harkyn, John, of Wykmere, husbandman 6
5284831 2440580 2440580 defendant Sarle Thomas husbandman 860785 860785 Sarle, Thomas, of Colkyrk, husbandman 7
5284832 2440580 2440580 defendant Barsham John husbandman 868612 868612 Barsham, John, of Hendyngham, husbandman 8
5284833 2440580 2440580 defendant Mortoft Robert gent 868612 868612 Mortoft, Robert, of Hendyngham, gent 9
5284834 2440580 2440580 defendant Spynke William clerk 592153 592153 Spynke, William, of Wroxham, clerk 10
5284835 2440580 2440580 defendant Erle Robert husbandman 588355 588355 Erle, Robert, of South Elmham, Suff, husbandman 11
5284836 2440580 2440580 defendant Gerveys Geoffrey husbandman 868613 868613 Gerveys, Geoffrey, of Wylby juxta Fressyngfeld, Suff, husbandman 12
5284837 2440580 2440580 defendant Crane Isabel widow 586143 586143 Crane, Isabel, of Norton, widow 13

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