names

69 rows where place_id = 602305

✎ 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
3649437 1910215 1910215 plaintiff Power John gent 602305 602305 Power, John, of Peterburgh, gent 0
3668748 1916161 1916161 plaintiff Baker Robert innholder 602305 602305 Baker, Robert, of Peterburgh, innholder 0
3668749 1916161 1916161 plaintiff Morton Walter baker 602305 602305 Morton, Walter, of Peterburgh, baker 1
3668751 1916161 1916161 defendant Wylkynson Anthony mercer 602305 602305 Wylkynson, Anthony, of Peterburgh, mercer 1
3700414 1926366 1926366 plaintiff Baker Robert innholder 602305 602305 Baker, Robert, of Peterburgh, innholder 0
3700415 1926366 1926366 plaintiff Morton Walter   602305 602305 Morton, Walter, of Peterburgh 1
3736839 1937776 1937776 defendant Edwardys Robert weaver 602305 602305 Edwardys, Robert, of Peterburgh, weaver 0
3797703 1957179 1957179 plaintiff Grenhall Thomas gent 602305 602305 Grenhall, Thomas, of Peterburgh, gent 0
3831230 1967655 1967655 plaintiff Grenehall Thomas gent 602305 602305 Grenehall, Thomas, of Peterburgh, gent 0
3870304 1980319 1980319 defendant Robynson Richard baker 602305 602305 Robynson, Richard, of Peterburgh, baker 0
3870880 1980513 1980513 defendant Barrett Joan widow 602305 602305 Barrett, Joan, of Peterburgh, widow 2
3870884 1980514 1980514 defendant Barrett Joan widow 602305 602305 Barrett, Joan, of Peterburgh, widow 2
4479858 2194365 2194365 defendant Lynne John de merchant 602305 602305 Lynne, John de, of Peterburgh, merchant 0
4479862 2194366 2194366 defendant Fyion William thatcher 602305 602305 Fyion, William, of Peterburgh, thatcher 0
4585381 2226850 2226850 defendant Walker Robert   602305 602305 Walker, Robert, of Peterburgh 0
4683770 2260530 2260530 defendant Whitby John laborer 602305 602305 Whitby, John, of Peterburgh, laborer 0
4823962 2303569 2303569 defendant Payn William milner 602305 602305 Payn, William, of Peterburgh, milner 0
4823969 2303571 2303571 defendant Payn John milner 602305 602305 Payn, John, of Peterburgh, milner 0
4824001 2303582 2303582 plaintiff Swan John esq 602305 602305 Swan, John, of Peterburgh, esq, on his own account 0
4853700 2312574 2312574 plaintiff Wydmerpole John   602305 602305 Wydmerpole, John, of Peterburgh 0
4863100 2315439 2315439 plaintiff Draper Stephen   602305 602305 Draper, Stephen, of Peterburgh 0
4868590 2317151 2317151 defendant Turney John barker 602305 602305 Turney, John, of Peterburgh, barker 0
4915747 2331425 2331425 defendant Gyldale Margaret widow 602305 602305 Gyldale, Margaret, of Peterburgh, widow 0
4950915 2342252 2342252 defendant Hervy Richard carpenter 602305 602305 Hervy, Richard, of Peterburgh, carpenter 3
4952947 2342843 2342843 defendant Aylef William butcher 602305 602305 Aylef, William, of Peterburgh, butcher 0
4952948 2342843 2342843 defendant Belde John butcher 602305 602305 Belde, John, of Peterburgh, butcher 1
4952949 2342843 2342843 defendant Ryot Richard husbandman 602305 602305 Ryot, Richard, of Peterburgh, husbandman 2
4954640 2343345 2343345 plaintiff Staunton John barber 602305 602305 Staunton, John, of Peterburgh, barber 0
4954641 2343345 2343345 defendant Porter William skinner 602305 602305 Porter, William, of Peterburgh, skinner 0
4954642 2343345 2343345 defendant Sowele Richard dyer 602305 602305 Sowele, Richard, of Peterburgh, dyer 1
4986133 2352776 2352776 plaintiff Assheton Richard   602305 602305 Assheton, Richard, of Peterburgh, abbot of the monastery 0
5007055 2358958 2358958 defendant Bentley William yeoman 602305 602305 Bentley, William, of Peterburgh, yeoman 5
5092828 2384281 2384281 defendant Lessy John husbandman 602305 602305 Lessy, John, of Peterburgh, husbandman 0
5092829 2384281 2384281 defendant Rede William butcher 602305 602305 Rede, William,of Peterburgh, butcher 1
5092830 2384281 2384281 defendant Bowyer William husbandman 602305 602305 Bowyer, William, of Peterburgh, husbandman 2
5098496 2385991 2385991 defendant Castell William gent 602305 602305 Castell, William, of Peterburgh, gent 1
5099006 2386140 2386140 defendant Pepyr Thomas butcher 602305 602305 Pepyr, Thomas, of Peterburgh, butcher 1
5099130 2386171 2386171 defendant Orwyn Robert merchant 602305 602305 Orwyn, Robert, of Peterburgh, merchant 0
5109696 2389262 2389262 defendant Miles William butcher 602305 602305 Miles, William, of Peterburgh, butcher 2
5141679 2398675 2398675 defendant Moleyn William sheermman 602305 602305 Moleyn, William, of Peterburgh, sheermman 0
5177981 2409267 2409267 defendant Martyn John yeoman 602305 602305 Martyn, John, of Peterburgh, yeoman 0
5177982 2409267 2409267 defendant Palmer Henry shoemaker 602305 602305 Palmer, Henry, of Peterburgh, shoemaker 1
5177983 2409267 2409267 defendant Richardson John yeoman 602305 602305 Richardson, John, of Peterburgh, yeoman 2
5177984 2409267 2409267 defendant Moleyns William sheerman 602305 602305 Moleyns, William, of Peterburgh, sheerman 3
5177985 2409267 2409267 defendant Taillour Edward tailor 602305 602305 Taillour, Edward, of Peterburgh, tailor 4
5183022 2410780 2410780 defendant Baker John husbandman 602305 602305 Baker, John, of Peterburgh, husbandman 0
5183023 2410780 2410780 defendant Miller Robert yeoman 602305 602305 Miller, Robert, of Peterburgh, yeoman 1
5183024 2410780 2410780 defendant Marram John yeoman 602305 602305 Marram, John, of Peterburgh, yeoman 2
5183025 2410780 2410780 defendant Asshedale William yeoman 602305 602305 Asshedale, William, of Peterburgh, yeoman 3
5201204 2416111 2416111 defendant Martyn John yeoman 602305 602305 Martyn, John, of Peterburgh, yeoman 0
5203676 2416828 2416828 defendant Caker John husbandman 602305 602305 Caker, John, of Peterburgh, husbandman 0
5203677 2416828 2416828 defendant Miller Robert yeoman 602305 602305 Miller, Robert, of Peterburgh, yeoman 1
5203678 2416828 2416828 defendant Marram John yeoman 602305 602305 Marram, John, of Peterburgh, yeoman 2
5203679 2416828 2416828 defendant Asshedale William yeoman 602305 602305 Asshedale, William, of Peterburgh, yeoman 3
5280205 2439285 2439285 defendant Castell John gent 602305 602305 Castell, John, of Peterburgh, gent 1
5283408 2440202 2440202 defendant Horton Milicent widow 602305 602305 Horton, Milicent, of Peterburgh, widow 0
5297270 2444193 2444193 defendant Manne William yeoman 602305 602305 Manne, William, of Peterburgh, yeoman 0
5349538 2459984 2459984 defendant Holdenby Thomas gent 602305 602305 Holdenby, Thomas, of Peterburgh, gent 2
5415384 2479535 2479535 plaintiff Kylham John gent & master 602305 602305 Kylham, John, of Peterburgh, gent & master 0
5415386 2479535 2479535 defendant Marsshlond John yeoman 602305 602305 Marsshlond, John, of Peterburgh, yeoman 1
5415387 2479535 2479535 defendant Murcote Richard butcher 602305 602305 Murcote, Richard, of Peterburgh, butcher 2
5415388 2479535 2479535 defendant Barford John dyer 602305 602305 Barford, John, of Peterburgh, dyer 3
5505442 2506618 2506618 defendant Botomley Bartholomew yeoman 602305 602305 Botomley, Bartholomew, of Peterburgh, yeoman 0
5505443 2506618 2506618 defendant Phelype Ralph yeoman 602305 602305 Phelype, Ralph, of Peterburgh, yeoman 1
5509949 2507951 2507951 defendant Kyrkeham Robert mercer 602305 602305 Kyrkeham, Robert, of Peterburgh, mercer 1
5533867 2515137 2515137 defendant Apultoft alias Taylour Richard tailor 602305 602305 Apultoft alias Taylour, Richard, of Peterburgh, tailor 1
5553390 2521032 2521032 defendant Toche Robert, senior yeoman 602305 602305 Toche, Robert, senior, of Peterburgh, yeoman 0
5553391 2521032 2521032 defendant Baron John husbandman 602305 602305 Baron, John, of Peterburgh, husbandman 1
5574059 2526976 2526976 defendant Pavy John husbandman 602305 602305 Pavy, John, of Peterburgh, husbandman 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);