names

15 rows where case_id = 2470271

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5383199 2470271 2470271 defendant Wryght William   586121 586121 Wryght, William, of Carleton 0
5383200 2470271 2470271 defendant Nowele Thomas husbandman 586121 586121 Nowele, Thomas, of Carleton, husbandman 1
5383201 2470271 2470271 defendant Mausan William husbandman 586121 586121 Mausan, William, of Carleton, husbandman 2
5383202 2470271 2470271 defendant Mauson Richard husbandman 586121 586121 Mauson, Richard, of Carleton, husbandman 3
5383203 2470271 2470271 defendant Grene Robert husbandman 586121 586121 Grene, Robert, of Carleton, husbandman 4
5383204 2470271 2470271 defendant Middelton William husbandman 586121 586121 Middelton, William, of Carleton, husbandman 5
5383205 2470271 2470271 defendant Evynt John laborer 586121 586121 Evynt, John, of Carleton, laborer 6
5383206 2470271 2470271 defendant Matloke John husbandman 586121 586121 Matloke, John, of Carleton, husbandman 7
5383207 2470271 2470271 defendant Byot Thomas husbandman 595865 595865 Byot, Thomas, of Gedlyng, husbandman 8
5383208 2470271 2470271 defendant Balye William husbandman 603099 603099 Balye, William, of Gedlynge, husbandman 9
5383209 2470271 2470271 defendant Nobull Robert husbandman 595865 595865 Nobull, Robert, of Gedlyng, husbandman 10
5383210 2470271 2470271 defendant Stere Robert husbandman 595865 595865 Stere, Robert, of Gedlyng, husbandman 11
5383211 2470271 2470271 defendant Bayley Richard husbandman 595865 595865 Bayley, Richard, of Gedlyng, husbandman 12
5383212 2470271 2470271 defendant Nowell John husbandman 595865 595865 Nowell, John, of Gedlyng, husbandman 13
5383213 2470271 2470271 defendant Norwell William husbandman 595865 595865 Norwell, William, of Gedlyng, husbandman 14

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