names

28 rows where place_id = 758981

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4458247 2187621 2187621 defendant Grym John   758981 758981 Grym, John, of Croylond 0
4873498 2318669 2318669 defendant William son of Launder William husbandman 758981 758981 together with William son of Launder, William, of Croylond, husbandman 2
4873499 2318669 2318669 defendant Seman Richard husbandman 758981 758981 Seman, Richard, of Croylond, husbandman 3
4873517 2318671 2318671 defendant Body John husbandman 758981 758981 Body, John, of Croylond, husbandman 1
4873518 2318671 2318671 defendant Wyseberd Nigel husbandman 758981 758981 Wyseberd, Nigel, of Croylond, husbandman 2
4873519 2318671 2318671 defendant Tebbe Richard husbandman 758981 758981 Tebbe, Richard, of Croylond, husbandman 3
4873520 2318671 2318671 defendant Wryght John husbandman 758981 758981 Wryght, John, of Croylond, husbandman 4
4873521 2318671 2318671 defendant Body William husbandman 758981 758981 together with Body, William, of Croylond, husbandman 5
4873522 2318671 2318671 defendant Coker William husbandman 758981 758981 Coker, William, of Croylond, husbandman 6
4873523 2318671 2318671 defendant Wryght John, junior husbandman 758981 758981 Wryght, John, junior, of Croylond, husbandman 7
4873524 2318671 2318671 defendant Fouler William husbandman 758981 758981 Fouler, William, of Croylond, husbandman 8
5102167 2387058 2387058 defendant Strot John yeoman 758981 758981 Strot, John, of Croylond, yeoman 1
5129257 2395045 2395045 defendant Oke Richard husbandman 758981 758981 Oke, Richard, of Croylond, husbandman 1
5129258 2395045 2395045 defendant Markham Richard   758981 758981 Markham, Richard, of Croylond 2
5136591 2397220 2397220 defendant Multon Nicholas laborer 758981 758981 Multon, Nicholas, of Croylond, laborer 0
5136592 2397220 2397220 defendant Millar William laborer 758981 758981 Millar, William, of Croylond, laborer 1
5148505 2400689 2400689 defendant Oke Richard husbandman 758981 758981 Oke, Richard, of Croylond, husbandman 1
5148506 2400689 2400689 defendant Markham Richard laborer 758981 758981 Markham, Richard, of Croylond, laborer 2
5150787 2401375 2401375 plaintiff Garner Stephen   758981 758981 Garner, Stephen, of Croylond 0
5157107 2403219 2403219 defendant Multon Nicholas laborer 758981 758981 Multon, Nicholas, of Croylond, laborer 0
5157108 2403219 2403219 defendant Millar William laborer 758981 758981 Millar, William, of Croylond, laborer 1
5173180 2407865 2407865 defendant Miller William laborer 758981 758981 Miller, William, of Croylond, laborer 1
5266397 2435239 2435239 defendant Hornby William marbler 758981 758981 Hornby, William, of Croylond, marbler 0
5431587 2484401 2484401 defendant Fypers Thomas yeoman 758981 758981 Fypers, Thomas, of Croylond, yeoman 0
5439723 2486820 2486820 defendant Seman William fisher 758981 758981 Seman, William, of Croylond, fisher 1
5447971 2489276 2489276 defendant (illegible) Thomas yeoman 758981 758981 _, Thomas, of Croylond, yeoman 0
5460304 2493019 2493019 defendant Fypers Thomas yeoman 758981 758981 Fypers, Thomas, of Croylond, yeoman 0
5487638 2501193 2501193 defendant Date Robert baker 758981 758981 Date, Robert, of Croylond, baker 3

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