names

211 rows where place_id = 587540

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591698 1865022 1865022 plaintiff Wymond Robert   587540 587540 Wymond, Robert, of Rye 2
3644364 1908655 1908655 defendant Bawldwyn Walter (legal representative) 587540 587540 Bawldwyn, Walter, of Rye, fisher, executors of 2
3684466 1921274 1921274 defendant Basden Walter yeoman 587540 587540 Basden, Walter, of Rye, yeoman 2
3684469 1921275 1921275 defendant Sutton Nicholas gent 587540 587540 Sutton, Nicholas, of Rye, gent 1
3684470 1921275 1921275 defendant Edolf John yeoman 587540 587540 Edolf, John, of Rye, yeoman 2
3684471 1921275 1921275 defendant Swannem John yeoman 587540 587540 Swannem John, of Rye, yeoman 3
3684472 1921275 1921275 defendant Basden Walter yeoman 587540 587540 Basden, Walter, of Rye, yeoman 4
3694086 1924355 1924355 defendant Sewell Thomas clerk 587540 587540 Sewell, Thomas, of Rye, clerk 0
3694087 1924355 1924355 defendant Hunt Thomas chaplain 587540 587540 Hunt, Thomas, of Rye, chaplain 1
3711789 1930003 1930003 defendant Edolf John yeoman 587540 587540 Edolf, John, of Rye, yeoman 1
3711790 1930003 1930003 defendant Cheseman Thomas yeoman 587540 587540 Cheseman, Thomas, of Rye, yeoman 2
3711791 1930003 1930003 defendant Pedyll Richard merchant 587540 587540 Pedyll, Richard, of Rye, merchant 3
3711792 1930003 1930003 defendant Barbour John yeoman 587540 587540 Barbour, John, of Rye, yeoman 4
3711793 1930003 1930003 defendant Basden Thomas yeoman 587540 587540 Basden, Thomas, of Rye, yeoman 5
3711794 1930003 1930003 defendant Basden Walter yeoman 587540 587540 Basden, Walter, of Rye, yeoman 6
3751588 1942410 1942410 defendant Whygh Richard husbandman 587540 587540 Whygh, Richard, of Rye, husbandman 0
3754729 1943440 1943440 defendant Basden Thomas yeoman 587540 587540 Basden, Thomas, of Rye, yeoman 2
3754730 1943440 1943440 defendant Pedyll Richard yeoman 587540 587540 Pedyll, Richard, of Rye, yeoman 3
3754731 1943440 1943440 defendant Basden Walter yeoman 587540 587540 Basden, Walter, of Rye, yeoman 4
3754737 1943441 1943441 defendant Whyte Nicholas gent 587540 587540 Whyte, Nicholas, of Rye, gent 2
3754739 1943441 1943441 defendant Tomson John clerk 587540 587540 Tomson, John, of Rye, clerk 4
3757028 1944179 1944179 plaintiff Basedon Henry yeoman 587540 587540 Basedon, Henry, of Rye, yeoman 0
3762506 1945916 1945916 defendant Dyrykson alias Dunkercoyfe Nicholas beer brewer 587540 587540 Dyrykson alias Dunkercoyfe, Nicholas, of Rye, beer brewer 0
3764029 1946394 1946394 defendant Towyn or Tolkyn Nicholas barber 587540 587540 Towyn or Tolkyn, Nicholas, of Rye, barber 1
3764476 1946552 1946552 defendant Benett John baker 587540 587540 Benett, John, of Rye, baker 0
3764890 1946683 1946683 defendant Hunte Thomas clerk 587540 587540 Hunte, Thomas, of Rye, clerk 0
3766186 1947078 1947078 defendant Lambe Thomas chaplain 587540 587540 Lambe, Thomas, of Rye, chaplain 0
3766187 1947078 1947078 defendant Nycoll Richard fisherman 587540 587540 Nycoll, Richard, of Rye, fisherman 1
3766188 1947078 1947078 defendant Bysshopp Thomas   587540 587540 Bysshopp, Thomas, of Rye, shipwright 2
3766189 1947078 1947078 defendant Cooke Robert innholder 587540 587540 Cooke, Robert, of Rye, innholder 3
3772149 1948981 1948981 defendant Whyte Nicholas gent 587540 587540 Whyte, Nicholas, of Rye, gent 1
3772151 1948981 1948981 defendant Tompson John clerk 587540 587540 Tompson, John, of Rye, clerk 3
3773137 1949303 1949303 plaintiff Whyte Nicholas   587540 587540 Whyte, Nicholas, of Rye 0
3773259 1949345 1949345 plaintiff Wodd Robert   587540 587540 Wodd, Robert, of Rye 0
3773260 1949345 1949345 defendant Hunte Thomas clerk 587540 587540 Hunte, Thomas, of Rye, clerk 0
3782531 1952279 1952279 defendant Bem- John baker 587540 587540 Bem-, John, of Rye, baker 0
3782712 1952336 1952336 defendant Amere Thomas yeoman 587540 587540 Amere, Thomas, of Rye, yeoman 0
3790893 1954982 1954982 plaintiff Whyte Nicholas   587540 587540 Whyte, Nicholas, of Rye 0
3790895 1954983 1954983 plaintiff Whyte Nicholas   587540 587540 Whyte, Nicholas, of Rye 0
3790897 1954984 1954984 plaintiff Whyte Nicholas   587540 587540 Whyte, Nicholas, of Rye 0
3807901 1960359 1960359 plaintiff Wymond John (legal representative) 587540 587540 Wymond, John, of Rye, former mayor, executors of 0
3831251 1967659 1967659 defendant Grenelond Robert carver 587540 587540 Grenelond, Robert, of Rye, carver 3
3860914 1977138 1977138 defendant Byspyn William (legal representative) 587540 587540 Byspyn, William, of Rye, executrix of 1
3860917 1977139 1977139 defendant Byspyn Thomas yeoman 587540 587540 Byspyn, Thomas, of Rye, yeoman 0
3860918 1977139 1977139 defendant Byspyn William (legal representative) 587540 587540 Byspyn, William, of Rye, executrix of 1
3860949 1977150 1977150 defendant Byspyn William (legal representative) 587540 587540 Byspyn, William, of Rye, executrix of 0
3860952 1977151 1977151 defendant Byspyn William (legal representative) 587540 587540 Byspyn, William, of Rye, executrix of 0
3881863 1984188 1984188 defendant Inolde William clerk 587540 587540 Inolde, William, of Rye, clerk 0
3894470 1988357 1988357 defendant Inglett John merchant 587540 587540 Inglett, John, of Rye, merchant 0
3894472 1988358 1988358 defendant Inglett John merchant 587540 587540 Inglett, John, of Rye, merchant 0
3900476 1990390 1990390 plaintiff Byrchett Thomas   587540 587540 Byrchett, Thomas, of Rye 0
3900478 1990391 1990391 plaintiff Byrchett Thomas   587540 587540 Byrchett, Thomas, of Rye 0
3903895 1991541 1991541 plaintiff Gylbye Robert   587540 587540 Gylbye, Robert, of Rye 0
3907793 1992892 1992892 plaintiff Pertrege William   587540 587540 Pertrege, William, of Rye 0
3924213 1998407 1998407 defendant Oxenbrigge William gent 587540 587540 Oxenbrigge, William, of Rye, gent 0
3929439 2000190 2000190 plaintiff Byrchett Thomas beer brewer 587540 587540 Byrchett, Thomas, of Rye, beer brewer 0
3932253 2001094 2001094 plaintiff Fletcher Richard merchant 587540 587540 Fletcher, Richard, of Rye, merchant 0
3936540 2002545 2002545 plaintiff Martyn William   587540 587540 Martyn, William, of Rye 0
3942594 2004531 2004531 plaintiff Wood Robert   587540 587540 Wood, Robert, of Rye 0
3942887 2004623 2004623 plaintiff Wymonde William (legal representative) 587540 587540 Wymonde, William, of Rye, executor of 0
3943705 2004910 2004910 defendant Peck Henry yeoman 587540 587540 Peck, Henry, of Rye, yeoman 0
3943706 2004910 2004910 defendant Marche Robert yeoman 587540 587540 Marche, Robert, of Rye, yeoman 1
3943707 2004910 2004910 defendant Collyns Thomas yeoman 587540 587540 Collyns, Thomas, of Rye, yeoman 2
3943708 2004910 2004910 defendant Bennett Robert yeoman 587540 587540 Bennett, Robert, of Rye, yeoman 3
3961979 2011287 2011287 plaintiff Walter Thomas tailor 587540 587540 Walter, Thomas, of Rye, tailor 0
4032820 2036392 2036392 defendant Mynge Henry yeoman 587540 587540 Mynge, Henry, of Rye, yeoman 1
4059536 2045804 2045804 plaintiff Cooke Richard beer brewer 587540 587540 Cooke, Richard, of Rye, beer brewer 0
4064051 2047424 2047424 defendant Holstock Henry tailor 587540 587540 Holstock, Henry, of Rye, tailor 0
4068787 2049126 2049126 defendant Tyndall Edmund merchant 587540 587540 Tyndall, Edmund, of Rye, merchant 0
4068789 2049127 2049127 defendant Bennett John merchant 587540 587540 Bennett, John, of Rye, merchant 0
4070312 2049675 2049675 defendant Myddleton Stephen gent 587540 587540 Myddleton, Stephen, of Rye, gent 2
4126657 2069820 2069820 defendant Farlye Robert merchant 587540 587540 Farlye, Robert, of Rye, merchant 0
4130150 2071090 2071090 defendant Hebylthawytt Thomas yeoman 587540 587540 Hebylthawytt, Thomas, of Rye, yeoman 0
4137250 2073671 2073671 defendant Jacson Robert beer brewer 587540 587540 Jacson, Robert, of Rye, gent, beer brewer 0
4138084 2073986 2073986 defendant Chamberlyn Thomas blacksmith 587540 587540 Chamberlyn, Thomas, of Rye, blacksmith 0
4159597 2081426 2081426 defendant Holstock Henry tailor 587540 587540 Holstock, Henry, of Rye, tailor 1
4196318 2094254 2094254 defendant Marche Jane widow 587540 587540 Marche, Jane, of Rye, widow 1
4208895 2098659 2098659 defendant Jackson Robert beer brewer 587540 587540 Jackson, Robert, of Rye, gent, beer brewer 0
4231025 2106351 2106351 defendant Watt Thomas yeoman 587540 587540 Watt, Thomas, of Rye, yeoman 0
4234791 2107719 2107719 defendant Savye Thomas husbandman 587540 587540 (Savye, Thomas, of Rye, husbandman 1
4235833 2108105 2108105 defendant Bolton Francis gent 587540 587540 Bolton, Francis, of Rye, gent 0
4255806 2114916 2114916 defendant Bolton Francis gent 587540 587540 Bolton, Francis, of Rye, gent 0
4311099 2134031 2134031 defendant Robynson John tanner 587540 587540 Robynson, John, of Rye, tanner 3
4312309 2134442 2134442 defendant Hastynge or Hastinges Andrew miller 587540 587540 Hastynge or Hastinges, Andrew, of Rye, miller 0
4318123 2136448 2136448 defendant Harryes Edward butcher 587540 587540 Harryes, Edward, of Rye, butcher 0
4318125 2136449 2136449 defendant Harrys Thomas butcher 587540 587540 Harrys, Thomas, of Rye, butcher 0
4319003 2136761 2136761 defendant Rolff Thomas innkeeper or alehouse keeper 587540 587540 Rolff, Thomas, of Rye, "typler", or of Playden, innkeeper or alehouse keeper 0
4319965 2137089 2137089 defendant Welles John smith 587540 587540 Welles, John, of Rye, smith 0
4319966 2137089 2137089 defendant Squyre Thomas glasier 587540 587540 Squyre, Thomas, of Rye, glasier 1
4329761 2140249 2140249 defendant Harrys Thomas butcher 587540 587540 Harrys, Thomas, of Rye, butcher 0
4332259 2141081 2141081 defendant Wells John smith 587540 587540 Wells, John, of Rye, smith 0
4332260 2141081 2141081 defendant Squire Thomas glasier 587540 587540 Squire, Thomas, of Rye, glasier 1
4334142 2141698 2141698 defendant Netter Richard mercer 587540 587540 Netter, Richard, of Rye, mercer 1
4358928 2150361 2150361 defendant Hamon Thomas gent 587540 587540 Hamon, Thomas, of Rye, gent 0
4358929 2150361 2150361 defendant Bridges Thomas carpenter 587540 587540 Bridges, Thomas, of Rye, carpenter 1
4358930 2150361 2150361 defendant Pye John carpenter 587540 587540 Pye, John, of Rye, carpenter 2
4358931 2150361 2150361 defendant Goddesmarke Henry   587540 587540 Goddesmarke, Henry, of Rye, "fetterer" 3
4358932 2150361 2150361 defendant Derricke Nicholas carpenter 587540 587540 Derricke, Nicholas, of Rye, carpenter 4
4358933 2150361 2150361 defendant Stace Walter carpenter 587540 587540 Stace, Walter, of Rye, carpenter 5
4362227 2151537 2151537 defendant Fryer Nicholas butcher 587540 587540 Fryer, Nicholas, of Rye, butcher 0

Next page

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