names

27 rows where place_id = 585982

✎ 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
3587625 1863774 1863774 defendant Molys Robert husbandman 585982 585982 Molys, Robert, of Gyrston, husbandman 1
3669355 1916354 1916354 plaintiff Belonde William   585982 585982 Belonde, William, of Gyrston 0
3893459 1988040 1988040 defendant Walter John yeoman 585982 585982 Walter, John, of Gyrston, yeoman 0
3900028 1990229 1990229 defendant Walter John yeoman 585982 585982 Walter, John, of Gyrston, yeoman 0
3911318 1994102 1994102 defendant Bronde George gent 585982 585982 Bronde, George, of Gyrston, gent 0
3916988 1996049 1996049 defendant Sponer John smith 585982 585982 Sponer, John, of Gyrston, smith 1
3927172 1999421 1999421 defendant Feete George fuller 585982 585982 Feete, George, of Gyrston, fuller 0
3941777 2004263 2004263 plaintiff Walter John yeoman 585982 585982 Walter, John, of Gyrston, yeoman 0
3955804 2009104 2009104 defendant Dunthorne William yeoman 585982 585982 Dunthorne, William, of Gyrston, yeoman 0
4028953 2035000 2035000 plaintiff Cretroft or Crytoft Robert gent 585982 585982 Cretroft or Crytoft, Robert, of Gyrston, gent 0
4091678 2057315 2057315 defendant Dunthorne William yeoman 585982 585982 Dunthorne, William, of Gyrston, yeoman 0
4091679 2057315 2057315 defendant Mynnes Thomas yeoman 585982 585982 Mynnes, Thomas, of Gyrston, yeoman 1
4091680 2057315 2057315 defendant Mynnes Peter yeoman 585982 585982 Mynnes, Peter, of Gyrston, yeoman 2
4135836 2073146 2073146 defendant Gyldyngsleve John clerk 585982 585982 Gyldyngsleve, John, of Gyrston, clerk 0
4321840 2137723 2137723 defendant Tebold Robert yeoman 585982 585982 Tebold, Robert, of Gyrston, yeoman 0
4342362 2144602 2144602 defendant Maye Henry yeoman 585982 585982 Maye, Henry, of Gyrston, yeoman 0
4342364 2144602 2144602 defendant Sharpe Thomas laborer 585982 585982 Sharpe, Thomas, of Gyrston, laborer 2
4387751 2160540 2160540 defendant Burrowe Geoffrey gent 585982 585982 Burrowe, Geoffrey, of Gyrston, gent 0
4400406 2164732 2164732 defendant Cawdell Richard husbandman 585982 585982 Cawdell, Richard, of Gyrston, husbandman 0
4716635 2270522 2270522 defendant Cullyng John husbandman 585982 585982 Cullyng, John, of Gyrston, husbandman 1
5137115 2397369 2397369 defendant Harre John   585982 585982 Harre, John, of Gyrston 0
5157725 2403388 2403388 defendant Harre John   585982 585982 Harre, John, of Gyrston, franklin 0
5166319 2405871 2405871 defendant Chawmbir John, sen husbandman 585982 585982 Chawmbir, John, sen, of Gyrston, husbandman 3
5177120 2409000 2409000 defendant Gape Thomas husbandman 585982 585982 Gape, Thomas, of Gyrston, husbandman 1
5177121 2409000 2409000 defendant Busshop Thomas husbandman 585982 585982 Busshop, Thomas, of Gyrston, husbandman 2
5267100 2435467 2435467 defendant Dynne William piper 585982 585982 Dynne, William,of Gyrston, piper 3
5286902 2441171 2441171 defendant Bettys John husbandman 585982 585982 Bettys, John, of Gyrston, husbandman 0

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