names

18 rows where place_id = 594872

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617917 1873228 1873228 defendant Bocher Roger butcher 594872 594872 Bocher, Roger, of Lyngfeld, Surrey, butcher 1
3668442 1916082 1916082 defendant at Wode Richard husbandman 594872 594872 at Wode, Richard, of Lyngfeld, Surrey, husbandman 0
3987006 2020093 2020093 plaintiff Wooddye John tanner 594872 594872 Wooddye, John, of Lyngfeld, Surrey, tanner 0
3987008 2020094 2020094 plaintiff Wooddye John tanner 594872 594872 Wooddye, John, of Lyngfeld, Surrey, tanner 0
4020773 2032156 2032156 plaintiff Wooddy John tanner 594872 594872 Wooddy, John, of Lyngfeld, Surrey, tanner 0
4785535 2291498 2291498 defendant Dryver John yeoman 594872 594872 Dryver, John, of Lyngfeld, Surrey, yeoman 0
4785543 2291502 2291502 defendant Dryver John yeoman 594872 594872 Dryver, John, of Lyngfeld, Surrey, yeoman 0
4968337 2347493 2347493 defendant Innyngfeld William husbandman 594872 594872 Innyngfeld, William, of Lyngfeld, Surrey, husbandman 3
4977502 2350235 2350235 defendant Sende William gent 594872 594872 Sende, William, of Lyngfeld, Surrey, gent 0
5028064 2365086 2365086 defendant atte Staple William husbandman 594872 594872 atte Staple, William, of Lyngfeld, Surrey, husbandman 0
5097352 2385654 2385654 defendant Sondes William gent 594872 594872 Sondes, William, of Lyngfeld, Surrey, gent 5
5154431 2402449 2402449 defendant Luggesford William husbandman 594872 594872 Luggesford, William, of Lyngfeld, Surrey, husbandman 3
5306747 2447011 2447011 defendant Dane Thomas husbandman 594872 594872 Dane, Thomas, of Lyngfeld, Surrey, husbandman 0
5360486 2463308 2463308 defendant Karver Henry yeoman 594872 594872 Karver, Henry, of Lyngfeld, Surrey, yeoman 0
5364089 2464426 2464426 defendant Gaynesford Richard esq 594872 594872 Gaynesford, Richard, of Lyngfeld, Surrey, esq 1
5526341 2512817 2512817 defendant Merssh William yeoman 594872 594872 Merssh, William, of Lyngfeld, Surrey, yeoman 0
5526344 2512817 2512817 defendant Huntley John yeoman 594872 594872 Huntley, John, of Lyngfeld, Surrey, yeoman 3
5561562 2523366 2523366 defendant Danby John   594872 594872 Danby, John, of Lyngfeld, Surrey, clerk, parson of Shelford 3

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