names

40 rows where place_id = 588796

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595619 1866257 1866257 defendant Boddyn Thomas chapman 588796 588796 Boddyn, Thomas, of Stenyng, Sussex, chapman 0
3625504 1875516 1875516 defendant Pryklove Richard yeoman 588796 588796 Pryklove, Richard, of Stenyng, Sussex, yeoman 3
3784138 1952822 1952822 defendant Donstone Leticia widow 588796 588796 Donstone, Leticia, of Stenyng, Sussex, widow 3
3829308 1967050 1967050 defendant Dunstall Robert chapman 588796 588796 Dunstall, Robert, of Stenyng, Sussex, chapman 0
3900877 1990522 1990522 defendant Dunstall Robert mercer 588796 588796 Dunstall, Robert, of Stenyng, Sussex, mercer 2
4690840 2262666 2262666 defendant Vynere John baker 588796 588796 Vynere, John, of Stenyng, Sussex, baker 1
4794799 2294516 2294516 plaintiff Pryklove John   588796 588796 Pryklove, John, of Stenyng, Sussex 0
4794801 2294517 2294517 plaintiff Pryklove John   588796 588796 Pryklove, John, of Stenyng, Sussex 0
4852031 2312067 2312067 defendant Papy Richard clerk & vicar 588796 588796 Papy, Richard, of Stenyng, Sussex, clerk & vicar 0
4889478 2323504 2323504 defendant Moughter Robert clerk 588796 588796 Moughter, Robert, of Stenyng, Sussex, clerk 4
4920310 2332866 2332866 defendant Pelat John husbandman 588796 588796 Pelat, John, of Stenyng, Sussex, husbandman 0
4942495 2339635 2339635 defendant Norton John husbandman 588796 588796 Norton, John, of Stenyng, Sussex, husbandman 0
4942501 2339636 2339636 defendant Norton John husbandman 588796 588796 Norton, John, of Stenyng, Sussex, husbandman 1
5031022 2365951 2365951 defendant Toley John chandler 588796 588796 Toley, John, of Stenyng, Sussex, chandler 2
5031028 2365952 2365952 defendant Toley John chandler 588796 588796 Toley, John, of Stenyng, Sussex, chandler 2
5032679 2366441 2366441 defendant Norton alias Toune John gent 588796 588796 Norton alias Toune, John, of Stenyng, Sussex, gent 3
5099655 2386334 2386334 defendant Wolvyn John merchant 588796 588796 Wolvyn, John, of Stenyng, Sussex, merchant 0
5099664 2386338 2386338 defendant Lambefall Thomas merchant 588796 588796 Lambefall, Thomas, of Stenyng, Sussex, merchant 0
5109203 2389115 2389115 defendant Lamvale Thomas mercer 588796 588796 Lamvale, Thomas, of Stenyng, Sussex, mercer 1
5109355 2389164 2389164 defendant Lamvale or Lamvile Thomas merchant 588796 588796 Lamvale or Lamvile, Thomas, of Stenyng, Sussex, merchant 0
5109357 2389165 2389165 defendant Lamvale or Lamvile Thomas merchant 588796 588796 Lamvale or Lamvile, Thomas, of Stenyng, Sussex, merchant 0
5150872 2401396 2401396 defendant Farnfeld Peter gent 588796 588796 Farnfeld, Peter, of Stenyng, Sussex, gent 0
5169212 2406734 2406734 defendant Farnfeld Peter gent 588796 588796 Farnfeld, Peter, of Stenyng, Sussex, gent 0
5174051 2408109 2408109 defendant Hurtur Peter skinner 588796 588796 Hurtur, Peter, of Stenyng, Sussex, skinner 4
5185816 2411598 2411598 defendant Farnfold Peter gent 588796 588796 Farnfold, Peter, of Stenyng, Sussex, gent 0
5185819 2411599 2411599 defendant Farnfeld Peter gent 588796 588796 Farnfeld, Peter, of Stenyng, Sussex, gent 0
5185823 2411600 2411600 defendant Smyth John   588796 588796 Smyth, John, of Stenyng, Sussex, balck smith 1
5194381 2414086 2414086 defendant Hurtur Peter skinner 588796 588796 Hurtur, Peter, of Stenyng, Sussex, skinner 4
5204951 2417194 2417194 defendant Farnfold Peter gent 588796 588796 Farnfold, Peter, of Stenyng, Sussex, gent 0
5215490 2420253 2420253 defendant mainpernors for Campyon Thomas yeoman 588796 588796 mainpernors for Campyon, Thomas, of Stenyng, Sussex, yeoman 4
5237393 2426520 2426520 defendant Smyth Margaret widow 588796 588796 Smyth, Margaret, of Stenyng, Sussex, widow 2
5276229 2438116 2438116 defendant Campyon Thomas yeoman 588796 588796 Campyon, Thomas, of Stenyng,, Sussex, yeoman 0
5279515 2439086 2439086 defendant Hawker or Hakkere John chapman 588796 588796 Hawker or Hakkere, John, of Stenyng, Sussex, chapman 2
5279862 2439190 2439190 defendant Hawker or Hakkere John chapman 588796 588796 Hawker or Hakkere, John, of Stenyng, Sussex, chapman 2
5361548 2463635 2463635 defendant Boteler Nicholas chapman 588796 588796 Boteler, Nicholas, of Stenyng, Sussex, chapman 1
5361553 2463636 2463636 defendant Boteler Nicholas chapman 588796 588796 Boteler, Nicholas, of Stenyng, Sussex, chapman 1
5453153 2490826 2490826 defendant Vagger John   588796 588796 Vagger, John, of Stenyng, Sussex 0
5465127 2494475 2494475 defendant Vagger John gent 588796 588796 Vagger, John, of Stenyng, Sussex, gent 0
5528230 2513388 2513388 defendant Bodyne Thomas butcher 588796 588796 Bodyne, Thomas, of Stenyng, Sussex, butcher 2
5591034 2532176 2532176 defendant Best Richard chapman 588796 588796 Best, Richard, of Stenyng, Sussex, chapman 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);