names

45 rows where place_id = 587710

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592196 1865177 1865177 defendant Cary Thomas gent 587710 587710 Cary, Thomas, of Fulford, gent 0
3687623 1922300 1922300 defendant Pexsall Ralph esq 587710 587710 Pexsall, Ralph, of Fulford, esq 0
3688997 1922717 1922717 defendant Pexsall Ralph esq 587710 587710 Pexsall, Ralph, of Fulford, esq 0
3712920 1930362 1930362 defendant Wryght John yeoman 587710 587710 Wryght, John, of Fulford, yeoman 0
3712921 1930362 1930362 defendant Wryght Robert husbandman 587710 587710 Wryght, Robert, of Fulford, husbandman 1
3712922 1930362 1930362 defendant Wryght Christopher husbandman 587710 587710 Wryght, Christopher, of Fulford, husbandman 2
3759465 1944954 1944954 defendant Calverd John gent 587710 587710 Calverd, John, of Fulford, gent 0
3777911 1950798 1950798 defendant Calverd John (legal representative) 587710 587710 Calverd, John, of Fulford, gent, executor of 0
3793325 1955772 1955772 defendant Fulford Baldwin gent 587710 587710 Fulford, Baldwin, of Fulford, gent 3
3810146 1961063 1961063 defendant Fulford Baldwin gent 587710 587710 Fulford, Baldwin, of Fulford, gent 2
3822248 1964862 1964862 defendant Wright John yeoman 587710 587710 Wright, John, of Fulford, yeoman 2
3911332 1994106 1994106 defendant Pakeman Hugh laborer 587710 587710 Pakeman, Hugh, of Fulford, laborer 2
3932589 2001191 2001191 plaintiff Fulford John esq 587710 587710 Fulford, John, of Fulford, esq 0
3934898 2001975 2001975 defendant Fulford John esq 587710 587710 Fulford, John, of Fulford, esq 0
3960180 2010661 2010661 defendant Horden Jane widow 587710 587710 Horden, Jane, of Fulford, widow 0
3960181 2010661 2010661 defendant Horden Robert husbandman 587710 587710 Horden, Robert, of Fulford, husbandman 1
3994470 2022771 2022771 defendant Foden Hugh yeoman 587710 587710 Foden, Hugh, of Fulford, yeoman 10
4202756 2096509 2096509 defendant Fulford Gabriel gent 587710 587710 Fulford, Gabriel, of Fulford, gent 1
4317475 2136228 2136228 defendant Fulford Thomas esq 587710 587710 Fulford, Thomas, of Fulford, esq 1
4317477 2136228 2136228 defendant Fulford Francis gent 587710 587710 Fulford, Francis, of Fulford, or of Exeter, gent 3
4340085 2143798 2143798 defendant Wright John yeoman 587710 587710 Wright, John, of Fulford, yeoman 2
4340086 2143798 2143798 defendant Baylie Hugh yeoman 587710 587710 Baylie, Hugh, of Fulford, yeoman 3
4365613 2152765 2152765 defendant Tripputt William yeoman 587710 587710 Tripputt, William, of Fulford, yeoman 0
4587337 2227446 2227446 defendant Simman Robert   587710 587710 Simman, Robert, of Fulford 1
4587338 2227446 2227446 defendant Bownes Thomas   587710 587710 Bownes, Thomas, of Fulford 2
4648425 2245587 2245587 plaintiff Summan John (legal representative) 587710 587710 Summan, John, of Fulford, executor of 0
4648429 2245587 2245587 defendant Clarell Robert   587710 587710 Clarell, Robert, of Fulford 2
4698722 2265082 2265082 defendant Brig Henry yeoman 587710 587710 Brig, Henry, of Fulford, yeoman 0
4808826 2298926 2298926 defendant Nevyll William husbandman 587710 587710 Nevyll, William, of Fulford, husbandman 6
4897315 2325819 2325819 plaintiff Dalton Thomas   587710 587710 Dalton, Thomas, of Fulford 1
4900185 2326683 2326683 defendant Wryght John yeoman 587710 587710 Wryght, John, of Fulford, yeoman 0
4952426 2342684 2342684 defendant Wryght John husbandman 587710 587710 Wryght, John, of Fulford, husbandman 1
5278305 2438757 2438757 defendant Aller Richard yeoman 587710 587710 Aller, Richard, of Fulford, yeoman 0
5369946 2466192 2466192 defendant Cole John, junior laborer 587710 587710 Cole, John, junior, of Fulford, laborer 1
5521948 2511681 2511681 defendant Drayton John yeoman 587710 587710 Drayton, John, of Fulford, yeoman 1
5521951 2511681 2511681 defendant Fey William laborer 587710 587710 Fey, William, of Fulford, laborer 4
5521953 2511681 2511681 defendant Kyse William yeoman 587710 587710 Kyse, William, of Fulford, yeoman 6
5521954 2511681 2511681 defendant Botre Roger yeoman 587710 587710 Botre, Roger, of Fulford, yeoman 7
5521956 2511681 2511681 defendant Shirland William yeoman 587710 587710 Shirland, William, of Fulford, yeoman 9
5552132 2520666 2520666 defendant Wright John yeoman 587710 587710 Wright, John, of Fulford, yeoman 3
5563520 2523933 2523933 defendant Hordern Richard yeoman 587710 587710 Hordern, Richard, of Fulford, yeoman 0
5565759 2524579 2524579 defendant Battyshyll John gent 587710 587710 Battyshyll, John, of Fulford, gent 1
5597316 2534069 2534069 defendant Densham John yeoman 587710 587710 Densham, John, of Fulford, yeoman 8
5623462 2551274 2551274 defendant Roson John de   587710 587710 Roson, John de, of Fulford 0
5623471 2551274 2551274 defendant Bathyne William   587710 587710 Bathyne, William, of Fulford 9

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