names

33 rows where place_id = 589396

✎ 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
3597491 1866836 1866836 plaintiff Ryall John   589396 589396 Ryall, John, of Bryghtelmeston 0
3806093 1959833 1959833 defendant Stonam John carpenter 589396 589396 Stonam, John, of Bryghtelmeston, carpenter 0
3946881 2005977 2005977 defendant Alleyn John fisherman 589396 589396 Alleyn, John, of Bryghtelmeston, fisherman 0
3947720 2006264 2006264 defendant Nycoll John fisherman 589396 589396 Nycoll, John, of Bryghtelmeston, fisherman 3
3975663 2016047 2016047 defendant Evernden John yeoman 589396 589396 Evernden, John, of Bryghtelmeston, yeoman 0
3979511 2017428 2017428 defendant Umfrey Richard, senior fisherman 589396 589396 Umfrey, Richard, senior, of Bryghtelmeston, fisherman 1
3989237 2020891 2020891 defendant Baker Agnes widow 589396 589396 Baker, Agnes, of Bryghtelmeston, widow 0
3994769 2022880 2022880 plaintiff Comber Leonard fisherman 589396 589396 Comber, Leonard, of Bryghtelmeston, fisherman 0
3994771 2022880 2022880 defendant Baker Thomas merchant 589396 589396 Baker, Thomas, of Bryghtelmeston, merchant 0
3998071 2024068 2024068 defendant Hoke John fisherman 589396 589396 Hoke, John, of Bryghtelmeston, fisherman 3
3998072 2024068 2024068 defendant Awood John yeoman 589396 589396 Awood, John, of Bryghtelmeston, yeoman 4
3998077 2024069 2024069 defendant Hoke John fisherman 589396 589396 Hoke, John, of Bryghtelmeston, fisherman 3
3998078 2024069 2024069 defendant Awood John yeoman 589396 589396 Awood, John, of Bryghtelmeston, yeoman 4
4058587 2045463 2045463 defendant Wyllard John mercer 589396 589396 Wyllard, John, of Bryghtelmeston, mercer 0
4095689 2058789 2058789 defendant Slutter John yeoman 589396 589396 Slutter, John, of Bryghtelmeston, yeoman 0
4097310 2059356 2059356 defendant Pye Amos tailor 589396 589396 Pye, Amos, of Bryghtelmeston, tailor 1
4098763 2059888 2059888 defendant Pye Amos yeoman 589396 589396 Pye, Amos, of Bryghtelmeston, yeoman 2
4111646 2064415 2064415 defendant Warde Richard fisherman 589396 589396 Warde, Richard, of Bryghtelmeston, fisherman 1
4122303 2068285 2068285 defendant Hyckley John fisherman 589396 589396 Hyckley, John, of Bryghtelmeston, fisherman 0
4792327 2293688 2293688 defendant Erlegh John gent 589396 589396 Erlegh, John, of Bryghtelmeston, gent 0
4792328 2293688 2293688 defendant Ovyot or Onyot John husbandman 589396 589396 Ovyot or Onyot, John, of Bryghtelmeston, husbandman 1
4792329 2293688 2293688 defendant Happer Henry husbandman 589396 589396 Happer, Henry, of Bryghtelmeston, husbandman 2
4792330 2293688 2293688 defendant Cony William husbandman 589396 589396 Cony, William, of Bryghtelmeston, husbandman 3
4792331 2293688 2293688 defendant Russell John, junior   589396 589396 Russell, John, junior, of Bryghtelmeston, shepherd 4
4792332 2293688 2293688 defendant Thwytemot Richard   589396 589396 Thwytemot, Richard, of Bryghtelmeston, groom 5
4904572 2328041 2328041 defendant Onyot or Ovyot John husbandman 589396 589396 Onyot or Ovyot, John, of Bryghtelmeston, husbandman 0
5112345 2389998 2389998 defendant Farley William yeoman 589396 589396 Farley, William, of Bryghtelmeston, yeoman 0
5112347 2389998 2389998 defendant Tryce Adam laborer 589396 589396 Tryce, Adam, of Bryghtelmeston, laborer 2
5534439 2515314 2515314 defendant Maynard Thomas yeoman 589396 589396 Maynard, Thomas, of Bryghtelmeston, yeoman 0
5548312 2519537 2519537 defendant Nicoll James yeoman 589396 589396 Nicoll, James, of Bryghtelmeston, yeoman 1
5552233 2520696 2520696 defendant Smyth Richard yeoman 589396 589396 Smyth, Richard, of Bryghtelmeston, yeoman 0
5556784 2521942 2521942 defendant Smyth Richard yeoman 589396 589396 Smyth, Richard, of Bryghtelmeston, yeoman 0
5597135 2534010 2534010 defendant Benet John, junior chapman 589396 589396 Benet, John, junior, of Bryghtelmeston, chapman 1

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