names

19 rows where case_id = 2382118

✎ 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
5085369 2382118 2382118 plaintiff Gresley John knight   Gresley, John, knight 0
5085370 2382118 2382118 plaintiff Bukkenale William     Bukkenale, William 1
5085371 2382118 2382118 defendant Maddeley John yeoman 598666 598666 Maddeley, John, of Newcastle under Lyme, yeoman 0
5085372 2382118 2382118 defendant Bratte John yeoman 844642 844642 Bratte, John, of Dymmesdale, yeoman 1
5085373 2382118 2382118 defendant Swetnam Richard husbandman 844643 844643 Swetnam, Richard, of Wolstaunton, husbandman 2
5085374 2382118 2382118 defendant Turnemore Thomas husbandman 590227 590227 Turnemore, Thomas, of Shelton, husbandman 3
5085375 2382118 2382118 defendant Kydde John husbandman 590227 590227 Kydde, John, of Shelton, husbandman 4
5085376 2382118 2382118 defendant Lovot William husbandman 588253 588253 Lovot, William, of Clayton, husbandman 5
5085377 2382118 2382118 defendant Poynton Robert husbandman 844644 844644 Poynton, Robert, of Sheprygge, husbandman 6
5085378 2382118 2382118 defendant Lovot Richard husbandman 588253 588253 Lovot, Richard, of Clayton, husbandman 7
5085379 2382118 2382118 defendant Kendall Thomas husbandman 844645 844645 Kendall, Thomas, of Sheprigge, husbandman 8
5085380 2382118 2382118 defendant Smyth John yeoman 598666 598666 Smyth, John, of Newcastle under Lyme, yeoman 9
5085381 2382118 2382118 defendant Bratte Richard yeoman 598666 598666 Bratte, Richard, of Newcastle under Lyme, yeoman 10
5085382 2382118 2382118 defendant Machyn Richard husbandman 844646 844646 Machyn, Richard, of Fenton Fibion, husbandman 11
5085383 2382118 2382118 defendant Berdmore Robert husbandman 714894 714894 Berdmore, Robert, of Hanford, husbandman 12
5085384 2382118 2382118 defendant Payntour John husbandman 606609 606609 Payntour, John, of Trentam, husbandman 13
5085385 2382118 2382118 defendant Galwey Gilbert husbandman 606609 606609 Galwey, Gilbert, of Trentam, husbandman 14
5085386 2382118 2382118 defendant Orchard Hugh yeoman 714894 714894 Orchard, Hugh, of Hanford, yeoman 15
5085387 2382118 2382118 defendant Cowdale John laborer 606609 606609 Cowdale, John, of Trentam, laborer 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);