names

38 rows where place_id = 592509

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607913 1870125 1870125 defendant Candeler Nicholas husbandman 592509 592509 Candeler, Nicholas, of Pykenham Wade, husbandman 0
3712038 1930085 1930085 defendant Mayes William innholder 592509 592509 Mayes, William, of Pykenham Wade, yeoman, innholder 0
3713057 1930408 1930408 defendant Fermour John yeoman 592509 592509 Fermour, John, of Pykenham Wade, yeoman 0
3735203 1937244 1937244 defendant Reynberd John butcher 592509 592509 Reynberd, John, of Pykenham Wade, butcher 0
3744298 1940115 1940115 defendant Fermour John   592509 592509 Fermour, John, of Pykenham Wade, yeoman, son of William rede 0
3744325 1940124 1940124 defendant Fermour John yeoman 592509 592509 Fermour, John, of Pykenham Wade, yeoman 0
3746980 1940974 1940974 defendant Fermour John gent 592509 592509 Fermour, John, of Pykenham Wade, gent 0
3750427 1942053 1942053 defendant Fermour John yeoman 592509 592509 Fermour, John, of Pykenham Wade, yeoman 0
3760480 1945281 1945281 defendant Fermour John gent 592509 592509 Fermour, John, of Pykenham Wade, gent 0
3761109 1945477 1945477 plaintiff Echard Thomas   592509 592509 Echard, Thomas, of Pykenham Wade 0
3765962 1947024 1947024 defendant Fermour John yeoman 592509 592509 Fermour, John, of Pykenham Wade, yeoman 0
3811094 1961366 1961366 defendant Taversham John innholder 592509 592509 Taversham, John, of Pykenham Wade, innholder 0
3839773 1970368 1970368 defendant Taversham John innkeeper 592509 592509 Taversham, John, of Pykenham Wade, innkeeper 1
3857081 1975847 1975847 defendant Bexendell Christopher innkeeper 592509 592509 Bexendell, Christopher, of Pykenham Wade, innkeeper 2
3857086 1975848 1975848 defendant Bexendell Christopher innkeeper 592509 592509 Bexendell, Christopher, of Pykenham Wade, innkeeper 3
3873767 1981447 1981447 defendant Hylton Robert chaplain 592509 592509 Hylton, Robert, of Pykenham Wade, chaplain 1
4724690 2273019 2273019 defendant Heylot John clerk 592509 592509 Heylot, John, of Pykenham Wade, clerk 2
4724694 2273020 2273020 defendant Heylot John clerk 592509 592509 Heylot, John, of Pykenham Wade, clerk 2
4902478 2327390 2327390 defendant Roberdisson or Robard Rodeland husbandman 592509 592509 Roberdisson or Robard, Rodeland, of Pykenham Wade, husbandman Smyth, Simon, of Methewold, husbandman 0
4961873 2345503 2345503 defendant Pyttes Richard   592509 592509 Pyttes, Richard, of Pykenham Wade, wright 0
5162084 2404643 2404643 defendant Newby William yeoman 592509 592509 Newby, William, of Pykenham Wade, yeoman 0
5162086 2404643 2404643 defendant Yevan Thomas husbandman 592509 592509 Yevan, Thomas, of Pykenham Wade, husbandman 2
5162087 2404643 2404643 defendant Roberdes John husbandman 592509 592509 Roberdes, John, of Pykenham Wade, husbandman 3
5176303 2408758 2408758 defendant Newby William yeoman 592509 592509 Newby, William, of Pykenham Wade, yeoman 0
5176304 2408758 2408758 defendant Flappe Walter yeoman 592509 592509 Flappe, Walter, of Pykenham Wade, yeoman 1
5176306 2408758 2408758 defendant Roberdes John husbandman 592509 592509 Roberdes, John, of Pykenham Wade, husbandman 3
5210478 2418798 2418798 defendant Newby William yeoman 592509 592509 Newby, William, of Pykenham Wade, yeoman 0
5210479 2418798 2418798 defendant Flappe Thomas yeoman 592509 592509 Flappe, Thomas, of Pykenham Wade, yeoman 1
5210480 2418798 2418798 defendant Yevan Thomas husbandman 592509 592509 Yevan, Thomas, of Pykenham Wade, husbandman 2
5210481 2418798 2418798 defendant Roberdes John husbandman 592509 592509 Roberdes, John, of Pykenham Wade, husbandman 3
5262550 2434029 2434029 defendant Flappe Walter yeoman 592509 592509 Flappe, Walter, of Pykenham Wade, yeoman 1
5301011 2445257 2445257 defendant Hervy John husbandman 592509 592509 Hervy, John, of Pykenham Wade, husbandman 0
5301012 2445257 2445257 defendant Cook Thomas husbandman 592509 592509 Cook, Thomas, of Pykenham Wade, husbandman 1
5403618 2476106 2476106 defendant Skryvener Henry   592509 592509 Skryvener, Henry, of Pykenham Wade, inn holder 1
5416734 2479924 2479924 defendant Screvyner Henry   592509 592509 Screvyner, Henry, of Pykenham Wade, inn holder 1
5433638 2485027 2485027 defendant Strevyner Henry innholder 592509 592509 Strevyner, Henry, of Pykenham Wade, innholder 1
5557723 2522210 2522210 defendant Helmesley John clerk 592509 592509 Helmesley, John, of Pykenham Wade, clerk 1
5557724 2522210 2522210 defendant Fayerman Richard yeoman 592509 592509 Fayerman, Richard, of Pykenham Wade, yeoman 2

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