names

26 rows where place_id = 668080

✎ 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
3987689 2020345 2020345 plaintiff Nyell alias Parsons William gent 668080 668080 Nyell alias Parsons, William, of Motcombe, gent 0
4009399 2028127 2028127 plaintiff Nele or Nyell alias Parsons William gent 668080 668080 Nele or Nyell alias Parsons, William, of Motcombe, gent 0
4009964 2028329 2028329 plaintiff Nyell alias Parsons William gent 668080 668080 Nyell alias Parsons, William, of Motcombe, gent 0
4131477 2071577 2071577 defendant Hussey Giles (legal representative) 668080 668080 Hussey, Giles, of Motcombe, esq, executor of 2
4175002 2086723 2086723 defendant Bounde Anthony husbandman 668080 668080 Bounde, Anthony, of Motcombe, husbandman 0
4187811 2091239 2091239 defendant Whyte John husbandman 668080 668080 Whyte, John, of Motcombe, husbandman 0
4211429 2099551 2099551 defendant Vanner Roger yeoman 668080 668080 Vanner, Roger, of Motcombe, yeoman 0
4236521 2108347 2108347 defendant Bounde Thomas husbandman 668080 668080 Bounde, Thomas, of Motcombe, or of Dynton, Wilts, husbandman 1
4242067 2110341 2110341 defendant Coward John yeoman 668080 668080 Coward, John, of Motcombe, yeoman 0
4256927 2115290 2115290 defendant Bounde Thomas husbandman 668080 668080 Bounde, Thomas, of Motcombe, or of Boyton, Wilts, husbandman 1
4286710 2125298 2125298 defendant Senyor Christopher   668080 668080 Senyor, Christopher, of Motcombe, surgeon 0
4286712 2125299 2125299 defendant Burrelton Robert husbandman 668080 668080 Burrelton, Robert, of Motcombe, husbandman 0
4290551 2126679 2126679 defendant White Robert yeoman 668080 668080 White, Robert, of Motcombe, yeoman 2
4314155 2135058 2135058 defendant Burrelton Robert husbandman 668080 668080 Burrelton, Robert, of Motcombe, husbandman 0
4331592 2140864 2140864 defendant Seignor or Senior Christopher yeoman 668080 668080 Seignor or Senior, Christopher, of Motcombe, yeoman 0
4363824 2152122 2152122 defendant White John husbandman 668080 668080 White, John, of Motcombe, husbandman 0
4946168 2340786 2340786 defendant Croweche Peter husbandman 668080 668080 Croweche, Peter, of Motcombe, husbandman 0
5140516 2398332 2398332 defendant Burbage John husbandman 668080 668080 Burbage, John, of Motcombe, husbandman 0
5161642 2404506 2404506 defendant Burbage John husbandman 668080 668080 Burbage, John, of Motcombe, husbandman 0
5161644 2404507 2404507 defendant Burbage John husbandman 668080 668080 Burbage, John, of Motcombe, husbandman 0
5163467 2405047 2405047 defendant Sturmy John   668080 668080 Sturmy, John, of Motcombe, mason 2
5175154 2408426 2408426 defendant Burbage John husbandman 668080 668080 Burbage, John, of Motcombe, husbandman 0
5209557 2418534 2418534 defendant Cotell John laborer 668080 668080 Cotell, John, of Motcombe, laborer 1
5275199 2437823 2437823 defendant Crouche Stephen husbandman 668080 668080 Crouche, Stephen, of Motcombe, husbandman 0
5275200 2437823 2437823 defendant Neweman Thomas cooper 668080 668080 Neweman, Thomas, of Motcombe, cooper 1
5275201 2437823 2437823 defendant Brokes alias Cotell John husbandman 668080 668080 Brokes alias Cotell, John, of Motcombe, husbandman 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);