names

46 rows where place_id = 609958

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681238 1920217 1920217 defendant Wilson Peter shoemaker 609958 609958 Wilson, Peter, of Pomfrett, shoemaker 1
3691328 1923447 1923447 defendant Haytkayle Henry yeoman 609958 609958 Haytkayle, Henry, of Pomfrett, yeoman 2
3701205 1926622 1926622 defendant Ince John   609958 609958 Ince, John, of Pomfrett, notary 2
3701212 1926623 1926623 defendant Ince John   609958 609958 Ince, John, of Pomfrett, notary 2
3751633 1942428 1942428 defendant Thayght John chapman 609958 609958 Thayght, John, of Pomfrett, chapman 0
3795892 1956578 1956578 defendant Marshall Robert yeoman 609958 609958 Marshall, Robert, of Pomfrett, yeoman 0
3981566 2018164 2018164 defendant Wayrd Robert badger 609958 609958 Wayrd, Robert, of Pomfrett, badger 1
4066293 2048235 2048235 defendant Staynfurth John yeoman 609958 609958 Staynfurth, John, of Pomfrett, yeoman 1
4066294 2048235 2048235 defendant Saunder James yeoman 609958 609958 Saunder, James, of Pomfrett, yeoman 2
4066295 2048235 2048235 defendant Smythson Richard yeoman 609958 609958 Smythson, Richard, of Pomfrett, yeoman 3
4066296 2048235 2048235 defendant Hanson Richard yeoman 609958 609958 Hanson, Richard, of Pomfrett, yeoman 4
4066297 2048235 2048235 defendant Beverley John yeoman 609958 609958 Beverley, John, of Pomfrett, yeoman 5
4093810 2058110 2058110 defendant Waide Roger laborer 609958 609958 Waide, Roger, of Pomfrett, laborer 0
4093811 2058110 2058110 defendant Rowden William laborer 609958 609958 Rowden, William, of Pomfrett, laborer 1
4093812 2058110 2058110 defendant Dawson John laborer 609958 609958 Dawson, John, of Pomfrett, laborer 2
4110597 2064048 2064048 defendant Newbye William yeoman 609958 609958 Newbye, William, of Pomfrett, yeoman 4
4111477 2064351 2064351 defendant Newbie William yeoman 609958 609958 Newbie, William, of Pomfrett, yeoman 4
4121193 2067874 2067874 defendant Habergam George   609958 609958 Habergam, George, of Pomfrett, or of Catlidye, Cams, freemason 0
4149617 2077991 2077991 defendant Crosby Thomas gent 609958 609958 Crosby, Thomas, of Pomfrett, gent 0
4152409 2078952 2078952 defendant Basfurthe John yeoman 609958 609958 Basfurthe, John, of Pomfrett, yeoman 1
4152839 2079101 2079101 defendant Savage William mercer 609958 609958 Savage, William, of Pomfrett, mercer 0
4154671 2079727 2079727 defendant Hill Thomas glover 609958 609958 Hill, Thomas, of Pomfrett, glover 1
4154672 2079727 2079727 defendant Ayrie Alan yeoman 609958 609958 Ayrie, Alan, of Pomfrett, yeoman 2
4186783 2090866 2090866 defendant Ledell Marmaduke skinner 609958 609958 Ledell, Marmaduke, of Pomfrett, skinner 0
4200487 2095728 2095728 defendant Savage William mercer 609958 609958 Savage, William, of Pomfrett, mercer 0
4202390 2096377 2096377 defendant Hyll Thomas glover 609958 609958 Hyll, Thomas, of Pomfrett, glover 0
4202391 2096377 2096377 defendant Ayre Alan yeoman 609958 609958 Ayre, Alan, of Pomfrett, yeoman 1
4211917 2099718 2099718 defendant Ayrye Alan haberdasher 609958 609958 Ayrye, Alan, of Pomfrett, haberdasher 0
4211918 2099718 2099718 defendant Tathum William vintner 609958 609958 Tathum, William, of Pomfrett, vintner 1
4223334 2103654 2103654 defendant Parmbe Thomas yeoman 609958 609958 Parmbe, Thomas, of Pomfrett, yeoman 0
4231387 2106478 2106478 defendant Hamond Thomas clerk 609958 609958 Hamond, Thomas, of Pomfrett, clerk 0
4231388 2106478 2106478 defendant Barmbe Thomas yeoman 609958 609958 Barmbe, Thomas, of Pomfrett, yeoman 1
4256047 2115003 2115003 defendant Warde Roger husbandman 609958 609958 Warde, Roger, of Pomfrett, husbandman 0
4256048 2115003 2115003 defendant Hodgson Robert husbandman 609958 609958 Hodgson, Robert, of Pomfrett, husbandman 1
4266645 2118489 2118489 defendant Hirst Alexander collier 609958 609958 Hirst, Alexander, of Pomfrett, collier 3
4273837 2120795 2120795 defendant Hamonde Thomas clerk 609958 609958 Hamonde, Thomas, of Pomfrett, clerk 0
4313113 2134704 2134704 defendant Baiteson Alan yeoman 609958 609958 Baiteson, Alan, of Pomfrett, yeoman 0
4313905 2134966 2134966 defendant Grene John waller 609958 609958 Grene, John, of Pomfrett, waller 3
4315297 2135462 2135462 defendant Nelson George gent 609958 609958 Nelson, George, of Pomfrett, gent 2
4315456 2135517 2135517 defendant Story Thomas butcher 609958 609958 Story, Thomas, of Pomfrett, butcher 0
4315457 2135517 2135517 defendant Hodgeson Thomas gent 609958 609958 Hodgeson, Thomas, of Pomfrett, gent 1
4315458 2135517 2135517 defendant Rowden George husbandman 609958 609958 Rowden, George, of Pomfrett, yeoman Norton, Alan, of Pomfrett, husbandman 2
4315460 2135518 2135518 defendant Story Thomas butcher 609958 609958 Story, Thomas, of Pomfrett, butcher 0
4315461 2135518 2135518 defendant Hodgeson Thomas gent 609958 609958 Hodgeson, Thomas, of Pomfrett, gent 1
4315462 2135518 2135518 defendant Rowden George husbandman 609958 609958 Rowden, George, of Pomfrett, yeoman Norton, Alan, of Pomfrett, husbandman 2
4405445 2166401 2166401 defendant Burnam alias Burnett Edward cordwainer 609958 609958 Burnam alias Burnett, Edward, of Pomfrett, cordwainer 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);