names

21 rows where case_id = 2398601

✎ 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
5141377 2398601 2398601 plaintiff Vampage John     Vampage, John 0
5141378 2398601 2398601 defendant Wollashull Edmund husbandman   Wollashull, Edmund, husbandman 0
5141379 2398601 2398601 defendant Ledyn Richard husbandman   Ledyn, Richard, husbandman 1
5141380 2398601 2398601 defendant Dolbys John husbandman   Dolbys, John, husbandman 2
5141381 2398601 2398601 defendant Maynard Robert husbandman   Maynard, Robert, husbandman 3
5141382 2398601 2398601 defendant Jenkyns Robert husbandman   Jenkyns, Robert, husbandman 4
5141383 2398601 2398601 defendant Jenkyns William husbandman   Jenkyns, William, husbandman 5
5141384 2398601 2398601 defendant Mason Robert mason   Mason, Robert, mason 6
5141385 2398601 2398601 defendant Cornewayle William clerk   Cornewayle, William, clerk 7
5141386 2398601 2398601 defendant Haukyns Thomas clerk 604163 604163 Haukyns, Thomas, of Ekyngton, clerk 8
5141387 2398601 2398601 defendant Walker Robert husbandman 586204 586204 Walker, Robert, of Bengeworth, husbandman 9
5141388 2398601 2398601 defendant Stacy John husbandman 852199 852199 Stacy, John, of Psyore or Pershore, husbandman, Stacy, husbandman 10
5141389 2398601 2398601 defendant of Psuore   butcher   of Psuore, butcher 11
5141390 2398601 2398601 defendant Pollard Simon husbandman 797197 797197 Pollard, Simon, of Great Comberton, husbandman 12
5141391 2398601 2398601 defendant George Thomas husbandman 852200 852200 George, Thomas,of Norton by Bredon, husbandman 13
5141392 2398601 2398601 defendant Tonne Ralph husbandman 604163 604163 Tonne, Ralph, of ekyngton, husbandman 14
5141393 2398601 2398601 defendant Baker Ralph butcher 852201 852201 Baker, Ralph, of Persiore or Pershore, butcher 15
5141394 2398601 2398601 defendant Wynslowe Richard husbandman 852202 852202 Wynslowe, Richard, of Erleis Crombe, husbandman 16
5141395 2398601 2398601 defendant Fulwell John husbandman 852203 852203 Fulwell, John, of Wyke by Psiore, husbandman 17
5141396 2398601 2398601 defendant Smyth Thomas husbandman   Smyth, Thomas, husbandman 18
5141397 2398601 2398601 defendant all of Great Comberton except where given otherwise     all of Great Comberton, except where given otherwise 19

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