names

30 rows where case_id = 1903357

✎ 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
3627186 1903357 1903357 plaintiff Bigod Ralph knight   Bigod, Ralph, knight 0
3627187 1903357 1903357 defendant Saull Richard laborer 588845 588845 Saull, Richard, of Grymston, laborer 0
3627188 1903357 1903357 defendant Gurwald Thomas husbandman 588845 588845 Gurwald, Thomas, of Grymston, husbandman 1
3627189 1903357 1903357 defendant Hall Thomas, senior husbandman 588845 588845 Hall, Thomas, senior, of Grymston, husbandman 2
3627190 1903357 1903357 defendant Awnger Edmund laborer 588845 588845 Awnger, Edmund, of Grymston, laborer 3
3627191 1903357 1903357 defendant Hall Thomas junior of Grymston, laborer   Hall, Thomas, junior of Grymston, laborer 4
3627192 1903357 1903357 defendant Jakeson John husbandman 588845 588845 Jakeson, John, of Grymston, husbandman 5
3627193 1903357 1903357 defendant Bowser Christopher husbandman 588845 588845 Bowser, Christopher, of Grymston, husbandman 6
3627194 1903357 1903357 defendant Jeffereyson John laborer 588845 588845 Jeffereyson, John, of Grymston, laborer 7
3627195 1903357 1903357 defendant Pattanson William laborer 588845 588845 Pattanson, William, of Grymston, laborer 8
3627196 1903357 1903357 defendant Awnger Christopher laborer 588845 588845 Awnger, Christopher, of Grymston, laborer 9
3627197 1903357 1903357 defendant Jakeson Edmund laborer 588845 588845 Jakeson, Edmund, of Grymston, laborer 10
3627198 1903357 1903357 defendant Gurwald William laborer 588845 588845 Gurwald, William, of Grymston, laborer 11
3627199 1903357 1903357 defendant Thomas John laborer 588845 588845 Thomas, John, of Grymston, laborer 12
3627200 1903357 1903357 defendant Dobson Brian laborer 588845 588845 Dobson, Brian, of Grymston, laborer 13
3627201 1903357 1903357 defendant Marshall John husbandman 589132 589132 Marshall, John, of Wharrom in le Strete, husbandman 14
3627202 1903357 1903357 defendant Marshall Richard husbandman 597077 597077 Marshall, Richard, of Wharrom, husbandman 15
3627203 1903357 1903357 defendant Bowser Thomas husbandman 597077 597077 Bowser, Thomas, of Wharrom, husbandman 16
3627204 1903357 1903357 defendant Bowser John laborer 597077 597077 Bowser, John, of Wharrom, laborer 17
3627205 1903357 1903357 defendant Grey Robert husbandman 597077 597077 Grey, Robert, of Wharrom, husbandman 18
3627206 1903357 1903357 defendant Segewith Thomas laborer 597077 597077 Segewith, Thomas, of Wharrom, laborer 19
3627207 1903357 1903357 defendant grisacre Robert husbandman 597077 597077 grisacre, Robert, of Wharrom, husbandman 20
3627208 1903357 1903357 defendant Sharp William husbandman 597077 597077 Sharp, William, of Wharrom, husbandman 21
3627209 1903357 1903357 defendant Peirson Richard laborer 597077 597077 Peirson, Richard, of Wharrom, laborer 22
3627210 1903357 1903357 defendant Holtby Robert laborer 597077 597077 Holtby, Robert, of Wharrom, laborer 23
3627211 1903357 1903357 defendant Wattarman Robert laborer 597077 597077 Wattarman, Robert, of Wharrom, laborer 24
3627212 1903357 1903357 defendant Adamson William laborer 597077 597077 Adamson, William, of Wharrom, laborer 25
3627213 1903357 1903357 defendant Watson Robert laborer 597077 597077 Watson, Robert, of Wharrom, laborer 26
3627214 1903357 1903357 defendant Cowlum Thomas laborer 597077 597077 Cowlum, Thomas, of Wharrom, laborer 27
3627215 1903357 1903357 defendant Brotton Thomas laborer 597077 597077 Brotton, Thomas, of Wharrom, laborer 28

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