names

16 rows where case_id = 2036248

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4032393 2036248 2036248 plaintiff Garnons William attorney of the bench   Garnons, William, attorney of the bench 0
4032394 2036248 2036248 defendant Symond Richard husbandman 656787 656787 Symond, Richard, of Mawfyld, husbandman 0
4032395 2036248 2036248 defendant Stybon Thomas husbandman 678645 678645 Stybon, Thomas, of Moungton Stradell, husbandman 1
4032396 2036248 2036248 defendant Jones William yeoman 651541 651541 Jones, William, of Hylhowse, yeoman 2
4032397 2036248 2036248 defendant Wynnett John yeoman 586386 586386 Wynnett, John, of Weston, yeoman 3
4032398 2036248 2036248 defendant Gosyngton Robert gent 625512 625512 Gosyngton, Robert, of Bache, gent 4
4032399 2036248 2036248 defendant Edwyns Walter yeoman 587000 587000 Edwyns, Walter, of Marden, yeoman 5
4032400 2036248 2036248 defendant Pyper Stephen yeoman 678644 678644 Pyper, Stephen, of Staunton on Arrowe, yeoman 6
4032401 2036248 2036248 defendant Phylpott Richard yeoman 663045 663045 Phylpott, Richard, of Castleton, yeoman 7
4032402 2036248 2036248 defendant Thomas David sawyer 630114 630114 Thomas, David, of Doore, sawyer 8
4032403 2036248 2036248 defendant Deykyns William yeoman 587503 587503 Deykyns, William, of Orleton, yeoman 9
4032404 2036248 2036248 defendant Phelpott Jevan weaver 586208 586208 Phelpott, Jevan, of Hereford, weaver 10
4032405 2036248 2036248 defendant Davye Thomas husbandman 678646 678646 Davye, Thomas, of Mounsell Gamage, husbandman 11
4032406 2036248 2036248 defendant Heynes Richard yeoman 678647 678647 Heynes, Richard, of Cleyhonger, yeoman 12
4032407 2036248 2036248 defendant Pye John yeoman 644833 644833 Pye, John, of Dydley, yeoman 13
4032408 2036248 2036248 defendant Rogers Geoffrey yeoman 615847 615847 Rogers, Geoffrey, of Byrley, yeoman 14

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