names

54 rows where place_id = 626555

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3770836 1948568 1948568 defendant Durbag Hugh husbandman 626555 626555 Durbag, Hugh, of Surflet, husbandman 0
3770837 1948568 1948568 defendant Slater John husbandman 626555 626555 Slater, John, of Surflet, husbandman 1
3772270 1949015 1949015 defendant Pett John husbandman 626555 626555 Pett, John, of Surflet, husbandman 0
3792919 1955639 1955639 defendant Wallys Thomas laborer 626555 626555 Wallys, Thomas, of Surflet, laborer 0
3816193 1962970 1962970 defendant Obrey Robert, junior husbandman 626555 626555 Obrey, Robert, junior, of Surflet, husbandman 0
3822185 1964837 1964837 defendant Nicolson William husbandman 626555 626555 Nicolson, William, of Surflet, husbandman 0
3852175 1974279 1974279 plaintiff Quykrell John husbandman 626555 626555 Quykrell, John, of Surflet, husbandman 0
3861498 1977308 1977308 defendant Gote Walter husbandman 626555 626555 Gote, Walter, of Surflet, husbandman 0
3862821 1977759 1977759 defendant Pyne John husbandman 626555 626555 Pyne, John, of Surflet, husbandman 0
3875573 1982069 1982069 defendant Gote Walter husbandman 626555 626555 Gote, Walter, of Surflet, husbandman 0
3878955 1983212 1983212 defendant Ingram William husbandman 626555 626555 Ingram, William, of Surflet, husbandman 0
3942436 2004482 2004482 defendant Terryngton Robert husbandman 626555 626555 Terryngton, Robert, of Surflet, husbandman 0
3953411 2008264 2008264 defendant Cokson John husbandman 626555 626555 Cokson, John, of Surflet, husbandman 0
3953412 2008264 2008264 defendant Obrey Thomas laborer 626555 626555 Obrey, Thomas, of Surflet, laborer 1
4050716 2042689 2042689 defendant Burton John gent 626555 626555 Burton, John, of Surflet, gent 0
4437994 2181201 2181201 plaintiff Allaman Joan   626555 626555 Allaman, Joan, of Surflet, formerly wife of Robert 0
4437997 2181201 2181201 defendant Seward Geoffrey   626555 626555 Seward, Geoffrey, of Surflet 2
4437999 2181201 2181201 defendant Ade Robert   626555 626555 Ade, Robert, of Surflet 4
4438000 2181201 2181201 defendant Colynson William   626555 626555 Colynson, William, of Surflet 5
4438001 2181201 2181201 defendant Thacker John   626555 626555 Thacker, John, of Surflet 6
4438002 2181201 2181201 defendant Chaumberleyn John   626555 626555 Chaumberleyn, John, of Surflet 7
4438003 2181201 2181201 defendant Her-- Robert   626555 626555 Her--, Robert, of Surflet 8
4445423 2183520 2183520 plaintiff Cressy John   626555 626555 Cressy, John, of Surflet 0
4445424 2183520 2183520 defendant Takker John, junior   626555 626555 Takker, John, junior, of Surflet 0
4499989 2200637 2200637 defendant Capon Robert   626555 626555 Capon, Robert, of Surflet 1
4551306 2216346 2216346 defendant Herlwyn Gilbert   626555 626555 Herlwyn, Gilbert, of Surflet 0
4555832 2217764 2217764 defendant Thackar John   626555 626555 Thackar, John, of Surflet, son of John 0
4563701 2220213 2220213 defendant Temar William   626555 626555 Temar, William, of Surflet 0
4564787 2220551 2220551 plaintiff Seynt Mary William   626555 626555 Seynt Mary, William, of Surflet 0
4567478 2221389 2221389 plaintiff Thakker John   626555 626555 Thakker, John, of Surflet 0
4601763 2231772 2231772 defendant Launde Thomas de la   626555 626555 Launde, Thomas de la, of Surflet 0
4656336 2247875 2247875 plaintiff Capon Robert   626555 626555 Capon, Robert, of Surflet 0
4668122 2255737 2255737 defendant Rogewyn Robert husbandman 626555 626555 Rogewyn, Robert, of Surflet, husbandman 0
4687977 2261808 2261808 plaintiff Sutton William   626555 626555 Sutton, William, of Surflet 0
4692995 2263319 2263319 defendant Thaker William husbandman 626555 626555 Thaker, William, of Surflet, husbandman 0
4698255 2264936 2264936 plaintiff Cressy Walter   626555 626555 Cressy, Walter, of Surflet 0
4698256 2264936 2264936 defendant Dode Robert, sen husbandman 626555 626555 Dode, Robert, sen, of Surflet, husbandman 0
4703356 2266428 2266428 defendant Austyn Gilbert husbandman 626555 626555 Austyn, Gilbert, of Surflet, husbandman 0
4721229 2271969 2271969 plaintiff Capon Robert   626555 626555 Capon, Robert, of Surflet 0
4721231 2271969 2271969 defendant Carter Robert laborer 626555 626555 Carter, Robert, of Surflet, laborer 1
4789919 2292916 2292916 defendant Cressy John husbandman 626555 626555 Cressy, John, of Surflet, husbandman 0
4802093 2296845 2296845 defendant Sutton Richard gent 626555 626555 Sutton, Richard, of Surflet, gent 1
4809734 2299207 2299207 defendant Sutton John gent 626555 626555 Sutton, John, of Surflet, gent 1
4826342 2304276 2304276 plaintiff Sutton John gent 626555 626555 Sutton, John, of Surflet, gent 1
4977735 2350301 2350301 defendant Elys John husbandman 626555 626555 Elys, John, of Surflet, husbandman 0
5037998 2367999 2367999 defendant Austyn William husbandman 626555 626555 Austyn, William, of Surflet, husbandman 2
5184070 2411076 2411076 defendant Sayward John husbandman 626555 626555 Sayward, John, of Surflet, husbandman 0
5204140 2416964 2416964 defendant Seyward John husbandman 626555 626555 Seyward, John, of Surflet, husbandman 0
5374458 2467616 2467616 defendant Bankes Thomas gent 626555 626555 (Bankes, Thomas, of Surflet, gent 3
5594525 2533269 2533269 defendant Dawson William yeoman 626555 626555 Dawson, William, of Surflet, yeoman 0
5594526 2533269 2533269 defendant Leke Thomas yeoman 626555 626555 Leke, Thomas, of Surflet, yeoman 1
5595802 2533602 2533602 defendant Dawson William yeoman 626555 626555 Dawson, William, of Surflet, yeoman 0
5595803 2533602 2533602 defendant Leke Thomas yeoman 626555 626555 Leke, Thomas, of Surflet, yeoman 1
5619002 2549790 2549790 defendant Sutton Robert de   626555 626555 Sutton, Robert de, of Surflet 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);