names

32 rows where place_id = 763491

✎ 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
4497705 2199926 2199926 plaintiff Eath Philip   763491 763491 Eath, Philip, of Mountagu 0
4502905 2201484 2201484 defendant Royere Roger   763491 763491 Royere, Roger, of Mountagu 4
4516362 2205526 2205526 defendant Dogettes Joan   763491 763491 Dogettes, Joan, of Mountagu 0
4575353 2223805 2223805 defendant Cole Henry   763491 763491 Cole, Henry, of Mountagu 1
4576504 2224162 2224162 defendant Helyer Richard   763491 763491 Helyer, Richard, of Mountagu 0
4652527 2246742 2246742 defendant Shether Thomas yeoman 763491 763491 Shether, Thomas, of Mountagu, yeoman 0
4666387 2250963 2250963 defendant Monke John husbandman 763491 763491 Monke, John, of Mountagu, husbandman 1
4668957 2255993 2255993 defendant Cole John   763491 763491 Cole, John, of Mountagu, laborer, son & heir of Henry Cole 0
4670914 2256578 2256578 defendant Hugyn John yeoman 763491 763491 Hugyn, John, of Mountagu, yeoman 0
4720575 2271770 2271770 defendant Tylere Richard tiler 763491 763491 Tylere, Richard, of Mountagu, tiler 0
4727624 2273879 2273879 defendant Cole Henry (legal representative) 763491 763491 Cole, Henry, of Mountagu, executor of 0
4727625 2273879 2273879 defendant Cole John husbandman 763491 763491 Cole, John, of Mountagu, son of Henry, husbandman 1
4794662 2294470 2294470 defendant Salesbury William baker 763491 763491 Salesbury, William, of Mountagu, baker 1
4794665 2294470 2294470 defendant Monk John husbandman 763491 763491 Monk, John, of Mountagu, husbandman 4
4840530 2308578 2308578 defendant Bursy Maud widow 763491 763491 Bursy, Maud, of Mountagu, widow 0
4867809 2316902 2316902 defendant Bursy Maud widow 763491 763491 Bursy, Maud, of Mountagu, widow 0
4875547 2319306 2319306 defendant Colyer Edward husbandman 763491 763491 Colyer, Edward, of Mountagu, husbandman 0
4880698 2320872 2320872 defendant Monke John husbandman 763491 763491 Monke, John, of Mountagu, husbandman 0
4885280 2322286 2322286 defendant Monke John husbandman 763491 763491 Monke, John, of Mountagu, husbandman 0
4885282 2322286 2322286 defendant Barbour William barber 763491 763491 Barbour, William, of Mountagu, barber 2
4885285 2322286 2322286 defendant Orgeley Robert husbandman 763491 763491 Orgeley, Robert, of Mountagu, husbandman 5
4897677 2325938 2325938 defendant Salysbury William, senior baker 763491 763491 Salysbury, William, senior, of Mountagu, baker 0
4897678 2325938 2325938 defendant Salysbury Alice   763491 763491 Salysbury, Alice, of Mountagu, servant 1
4897966 2326029 2326029 defendant Burgeys John husbandman 763491 763491 Burgeys, John, of Mountagu, husbandman 0
4900827 2326889 2326889 defendant Bursy Maud widow 763491 763491 Bursy, Maud, of Mountagu, widow 0
4967484 2347218 2347218 defendant Brympton John husbandman 763491 763491 Brympton, John, of Mountagu, husbandman 0
4986694 2352954 2352954 defendant Brympton John gent 763491 763491 Brympton, John, of Mountagu, gent 0
4994021 2355084 2355084 defendant Brynton John husbandman 763491 763491 Brynton, John, of Mountagu, husbandman 0
5058988 2374251 2374251 defendant Drake John clerk 763491 763491 Drake, John, of Mountagu, clerk 3
5377178 2468453 2468453 defendant Benyn John gent 763491 763491 Benyn, John, of Mountagu, gent 0
5559383 2522711 2522711 defendant Pessyn Angel merchant 763491 763491 Pessyn, Angel, of Mountagu, merchant 3
5618493 2549610 2549610 defendant Pestour Robert   763491 763491 Pestour, Robert, of Mountagu 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);