names

20 rows where case_id = 2408824

✎ 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
5176525 2408824 2408824 plaintiff Vampage John     Vampage, John 0
5176526 2408824 2408824 defendant Wollashill Edmund husbandman   Wollashill, Edmund, husbandman 0
5176527 2408824 2408824 defendant Ledyn Richard husbandman   Ledyn, Richard, husbandman 1
5176528 2408824 2408824 defendant Dobbys John husbandman   Dobbys, John, husbandman 2
5176529 2408824 2408824 defendant Maynard Robert husbandman   Maynard, Robert, husbandman 3
5176530 2408824 2408824 defendant Jenkyns Robert husbandman   Jenkyns, Robert, husbandman 4
5176531 2408824 2408824 defendant Jenkyns William husbandman   Jenkyns, William, husbandman 5
5176532 2408824 2408824 defendant Mason Robert mason   Mason, Robert, mason 6
5176533 2408824 2408824 defendant Cornewayle William clerk   Cornewayle, William, clerk 7
5176534 2408824 2408824 defendant Haukyns Thomas clerk 604163 604163 Haukyns, Thomas, of Ekyngton, clerk 8
5176535 2408824 2408824 defendant Walker Robert husbandman 586204 586204 Walker, Robert, of Bengeworth, husbandman 9
5176536 2408824 2408824 defendant Stacy John husbandman 585945 585945 Stacy, John, of Pershore, husbandman 10
5176537 2408824 2408824 defendant Stacy Thomas butcher 585945 585945 Stacy, Thomas, of Pershore, butcher 11
5176538 2408824 2408824 defendant Pollard Simon husbandman 797197 797197 Pollard, Simon, of Great Comberton, husbandman 12
5176539 2408824 2408824 defendant George Thomas husbandman 852200 852200 George, Thomas, of Norton by Bredon, husbandman 13
5176540 2408824 2408824 defendant Tonne Ralph husbandman 604163 604163 Tonne, Ralph, of Ekyngton, husbandman 14
5176541 2408824 2408824 defendant Baker Ralph butcher 585945 585945 Baker, Ralph, of Pershore, butcher 15
5176542 2408824 2408824 defendant Wynslowe Richard husbandman 592644 592644 Wynslowe, Richard, of Erles Crombe, husbandman 16
5176543 2408824 2408824 defendant Fulwell John husbandman 758057 758057 Fulwell, John, of Wyke by Pershore, husbandman 17
5176544 2408824 2408824 defendant Smyth Thomas husbandman 797197 797197 Smyth, Thomas, of Great Comberton, husbandman 18

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