names

15 rows where case_id = 2289549

✎ 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
4779432 2289549 2289549 plaintiff Bourne Stephen     Bourne, Stephen 0
4779433 2289549 2289549 plaintiff Lettere Robert     Lettere, Robert 1
4779434 2289549 2289549 plaintiff Amherst Thomas     Amherst, Thomas 2
4779435 2289549 2289549 plaintiff Grofherst Roger     Grofherst, Roger 3
4779436 2289549 2289549 plaintiff Doumere or Donmere John     Doumere or Donmere, John 4
4779437 2289549 2289549 plaintiff Burre Agnes     Burre, Agnes 5
4779438 2289549 2289549 plaintiff Burre George     Burre, George 6
4779439 2289549 2289549 defendant Blakepette John shoemaker 595466 595466 Blakepette, John, of Pepynbery, shoemaker 0
4779440 2289549 2289549 defendant atte Broke Nicholas laborer 595466 595466 atte Broke, Nicholas, of Pepynbery, laborer 1
4779441 2289549 2289549 defendant Robyn John laborer 595466 595466 Robyn, John, of Pepynbery, laborer 2
4779442 2289549 2289549 defendant Poyll John shoemaker 595466 595466 Poyll, John, of Pepynbery, shoemaker 3
4779443 2289549 2289549 defendant Begeteppe Richard laborer 587765 587765 Begeteppe, Richard, of Horsmonden, laborer 4
4779444 2289549 2289549 defendant Croweherst John wheeler 595466 595466 Croweherst, John, of Pepynbery, wheeler 5
4779445 2289549 2289549 defendant Chytecroft John laborer 595466 595466 Chytecroft, John, of Pepynbery, laborer 6
4779446 2289549 2289549 defendant Akedon Henry laborer 592771 592771 Akedon, Henry, of Tonbregge, laborer 7

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