names

18 rows where case_id = 2428012

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5242489 2428012 2428012 plaintiff (not given)   Prior of Michelham Priory   Michelham Priory, Prior of 0
5242490 2428012 2428012 defendant Strode William, senior butcher 588259 588259 Strode, William, senior, of Flecchyng, butcher 0
5242491 2428012 2428012 defendant Mall Richard husbandman 588259 588259 Mall, Richard, of Flecchyng, husbandman 1
5242492 2428012 2428012 defendant Lye John husbandman 588259 588259 Lye, John, of Flecchyng, husbandman 2
5242493 2428012 2428012 defendant atte Downe Richard husbandman 588259 588259 atte Downe, Richard, of Flecchyng, husbandman 3
5242494 2428012 2428012 defendant Studolf John husbandman 588259 588259 Studolf, John, of Flecchyng, husbandman 4
5242495 2428012 2428012 defendant Studolf Richard husbandman 588259 588259 Studolf, Richard, of Flecchyng, husbandman 5
5242496 2428012 2428012 defendant Holford Richard husbandman 588259 588259 Holford, Richard, of Flecchyng, husbandman 6
5242497 2428012 2428012 defendant Avecok Thomas husbandman 588259 588259 Avecok, Thomas, of Flecchyng, husbandman 7
5242498 2428012 2428012 defendant Cowestok Alexander     Cowestok, Alexander 8
5242499 2428012 2428012 defendant Strode William     Strode, William 9
5242500 2428012 2428012 defendant Atherwold William     Atherwold, William 10
5242501 2428012 2428012 defendant Alshorne Richard     Alshorne, Richard 11
5242502 2428012 2428012 defendant Avecok John     Avecok, John 12
5242503 2428012 2428012 defendant Parys Thomas     Parys, Thomas 13
5242504 2428012 2428012 defendant Avecok Robert     Avecok, Robert 14
5242505 2428012 2428012 defendant Durkyn Richard     Durkyn, Richard 15
5242506 2428012 2428012 defendant Skynner Richard     Skynner, Richard 16

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