names

50 rows where place_id = 593140

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610653 1871000 1871000 defendant Laton John gent 593140 593140 Laton, John, of South Duffeld, gent 0
3718700 1932128 1932128 defendant Knyght Edward gent 593140 593140 Knyght, Edward, of South Duffeld, gent 0
3729160 1935368 1935368 defendant Knyght Lawrence gent 593140 593140 Knyght, Lawrence, of South Duffeld, gent 2
3729161 1935368 1935368 defendant Knyght Edward gent 593140 593140 Knyght, Edward, of South Duffeld, gent 3
3770896 1948585 1948585 defendant Smyth Thomas tailor 593140 593140 Smyth, Thomas, of South Duffeld, tailor 1
3821896 1964740 1964740 defendant Haddesley Thomas piper 593140 593140 Haddesley, Thomas, of South Duffeld, piper 0
3821897 1964740 1964740 defendant Smuth John laborer 593140 593140 Smuth, John, of South Duffeld, laborer 1
3821898 1964740 1964740 defendant Godayll William laborer 593140 593140 Godayll, William, of South Duffeld, laborer 2
3821899 1964740 1964740 defendant Hadysley Nicholas laborer 593140 593140 Hadysley, Nicholas, of South Duffeld, laborer 3
3821900 1964740 1964740 defendant Nordeby John husbandman 593140 593140 Nordeby, John, of South Duffeld, husbandman 4
3821901 1964740 1964740 defendant Foster William yeoman 593140 593140 Foster, William, of South Duffeld, yeoman 5
3821902 1964740 1964740 defendant Mylner William laborer 593140 593140 Mylner, William, of South Duffeld, laborer 6
3826235 1966053 1966053 defendant Haddysley William yeoman 593140 593140 Haddysley, William, of South Duffeld, yeoman 0
3826239 1966055 1966055 defendant Gascoigne John gent 593140 593140 Gascoigne, John, of South Duffeld, gent 0
3826240 1966055 1966055 defendant Haddysley William husbandman 593140 593140 Haddysley, William, of South Duffeld, husbandman 1
3826241 1966055 1966055 defendant Rykall Thomas husbandman 593140 593140 Rykall, Thomas, of South Duffeld, husbandman 2
3826242 1966055 1966055 defendant Jakson Richard husbandman 593140 593140 Jakson, Richard, of South Duffeld, husbandman 3
3826243 1966055 1966055 defendant Jakson John husbandman 593140 593140 Jakson, John, of South Duffeld, husbandman 4
4155212 2079916 2079916 defendant Sympson James gent 593140 593140 (Sympson, James, of South Duffeld, gent 1
4176222 2087160 2087160 defendant Rycall Thomas husbandman 593140 593140 Rycall, Thomas, of South Duffeld, husbandman 0
4176223 2087160 2087160 defendant Northbye Robert husbandman 593140 593140 together with Northbye, Robert, of South Duffeld, husbandman 1
4179429 2088282 2088282 defendant Laton Richard gent 593140 593140 (Laton, Richard, of South Duffeld, gent 1
4179430 2088282 2088282 defendant Layton Thomas gent 593140 593140 Layton, Thomas, of South Duffeld, gent 2
4179431 2088282 2088282 defendant Layton Margaret spinster 593140 593140 Layton, Margaret, of South Duffeld, spinster 3
4179432 2088282 2088282 defendant Layton Katherine spinster 593140 593140 Layton, Katherine, of South Duffeld, spinster 4
4179433 2088282 2088282 defendant Layton Barbara spinster 593140 593140 Layton, Barbara, of South Duffeld, spinster 5
4179434 2088282 2088282 defendant Layton Mary spinster 593140 593140 Layton, Mary, of South Duffeld, spinster 6
4179435 2088282 2088282 defendant Layton Anne spinster 593140 593140 Layton, Anne, of South Duffeld, spinster 7
4179436 2088282 2088282 defendant Sympson James gent 593140 593140 Sympson, James, of South Duffeld, gent 8
4458883 2187826 2187826 defendant Basset William   593140 593140 Basset, William, of South Duffeld, son of John 0
4478080 2193817 2193817 plaintiff Hathelsay William de   593140 593140 Hathelsay, William de, of South Duffeld 0
4534378 2211022 2211022 defendant Jakson William   593140 593140 Jakson, William, of South Duffeld 0
4596804 2230236 2230236 defendant Jakson William   593140 593140 Jakson, William, of South Duffeld 3
4596807 2230236 2230236 defendant Webster John   593140 593140 Webster, John, of South Duffeld 6
4668314 2255804 2255804 defendant Knyght William husbandman 593140 593140 Knyght, William, of South Duffeld, husbandman 0
4668315 2255804 2255804 defendant Knyght Robert laborer 593140 593140 Knyght, Robert, of South Duffeld, laborer 1
4896724 2325637 2325637 defendant Curtays John yeoman 593140 593140 Curtays, John, of South Duffeld, yeoman 1
5025801 2364445 2364445 defendant Lusseby Thomas husbandman 593140 593140 Lusseby, Thomas, of South Duffeld, husbandman 0
5064054 2375783 2375783 defendant Lusseby Thomas husbandman 593140 593140 Lusseby, Thomas, of South Duffeld, husbandman 0
5064055 2375783 2375783 defendant Lusseby John laborer 593140 593140 Lusseby, John, of South Duffeld, laborer 1
5064056 2375783 2375783 defendant Lusseby Richard laborer 593140 593140 Lusseby, Richard, of South Duffeld, laborer 2
5064057 2375783 2375783 defendant Lusseby Thomas laborer 593140 593140 Lusseby, Thomas, of South Duffeld, laborer 3
5106071 2388214 2388214 defendant Laton William gent 593140 593140 Laton, William, of South Duffeld, gent 3
5142135 2398820 2398820 defendant Lanton William gent 593140 593140 Lanton, William, of South Duffeld, gent 0
5143055 2399094 2399094 defendant Laton William gent 593140 593140 Laton, William, of South Duffeld, gent 3
5199697 2415657 2415657 defendant Lanton William gent 593140 593140 Lanton, William, of South Duffeld, gent 0
5199699 2415658 2415658 defendant Lanton William gent 593140 593140 Lanton, William, of South Duffeld, gent 0
5218906 2421255 2421255 plaintiff Gyles John   593140 593140 Gyles, John, of South Duffeld 0
5218908 2421255 2421255 defendant Luceby Thomas husbandman 593140 593140 Luceby, Thomas, of South Duffeld, husbandman 1
5563561 2523947 2523947 defendant Layton John gent 593140 593140 Layton, John, of South Duffeld, gent 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);