names

19 rows where case_id = 2036245

✎ 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
4032370 2036245 2036245 plaintiff Garnons William attorney of the bench   Garnons, William, attorney of the bench 0
4032371 2036245 2036245 defendant Barnard George yeoman 586208 586208 Barnard, George, of hereford, yeoman 0
4032372 2036245 2036245 defendant Symond Richard husbandman 656787 656787 Symond, Richard, of Mawfyld, husbandman 1
4032373 2036245 2036245 defendant Seylon Thomas husbandman 678643 678643 Seylon, Thomas, of Monington Stradell, husbandman 2
4032374 2036245 2036245 defendant Jenkes Henry gent 604145 604145 Jenkes, Henry, of Pembridge, gent 3
4032375 2036245 2036245 defendant Jones William yeoman 651541 651541 Jones, William, of Hylhowse, yeoman 4
4032376 2036245 2036245 defendant Wynnyett John yeoman 586386 586386 Wynnyett, John, of Weston, yeoman 5
4032377 2036245 2036245 defendant Gosyngton Robert gent 625512 625512 Gosyngton, Robert, of Bache, gent 6
4032378 2036245 2036245 defendant Hunt Jenkin yeoman 586143 586143 Hunt, Jenkin, of Norton, yeoman 7
4032379 2036245 2036245 defendant Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 8
4032380 2036245 2036245 defendant Edwyns Walter yeoman 587000 587000 Edwyns, Walter, of Marden, yeoman 9
4032381 2036245 2036245 defendant Pyper Stephen yeoman 678644 678644 Pyper, Stephen, of Staunton on Arrowe, yeoman 10
4032382 2036245 2036245 defendant Phylpott Richard yeoman 663045 663045 Phylpott, Richard, of Castleton, yeoman 11
4032383 2036245 2036245 defendant Thomas David sawyer 630114 630114 Thomas, David, of Doore, sawyer 12
4032384 2036245 2036245 defendant Deykyns William yeoman 587503 587503 Deykyns, William, of Orleton, yeoman 13
4032385 2036245 2036245 defendant Phylpott Jevan weaver 586208 586208 Phylpott, Jevan, of Hereford, weaver 14
4032386 2036245 2036245 defendant Davye Thomas husbandman 669077 669077 Davye, Thomas, of Maunsell Gamage, husbandman 15
4032387 2036245 2036245 defendant Scaunbrett Oliver yeoman 593772 593772 Scaunbrett, Oliver, of Kyngton, yeoman 16
4032388 2036245 2036245 defendant Heynes Geoffrey yeoman 615847 615847 Heynes, Geoffrey, of Byrley, yeoman 17

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