names

29 rows where place_id = 603893

✎ 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
3656121 1912168 1912168 defendant Fawkener Thomas, junior husbandman 603893 603893 Fawkener, Thomas, junior, of Morcote, husbandman 2
3678245 1919251 1919251 plaintiff Messynger John husbandman 603893 603893 Messynger, John, of Morcote, husbandman 0
3834122 1968614 1968614 plaintiff Messynger John (legal representative) 603893 603893 Messynger, John, of Morcote, husbandman, executor of 0
4182084 2089213 2089213 defendant Edmond Edward husbandman 603893 603893 Edmond, Edward, of Morcote, husbandman 0
4414828 2169541 2169541 defendant Broun John   603893 603893 Broun, John, of Morcote, son of Robert 1
4447281 2184055 2184055 defendant Grene John de la   603893 603893 Grene, John de la, of Morcote 1
4467540 2190528 2190528 defendant Bailly John   603893 603893 Bailly, John, of Morcote 1
4467541 2190528 2190528 defendant Chamberleyn John   603893 603893 Chamberleyn, John, of Morcote 2
4689104 2262152 2262152 plaintiff Tryte Thomas   603893 603893 Tryte, Thomas, of Morcote 0
4696245 2264311 2264311 defendant Messenger John husbandman 603893 603893 Messenger, John, of Morcote, husbandman 0
4789065 2292635 2292635 defendant Messenger John yeoman 603893 603893 Messenger, John, of Morcote, yeoman 0
4826162 2304215 2304215 defendant Thornton Thomas husbandman 603893 603893 Thornton, Thomas, of Morcote, husbandman 0
4828748 2305032 2305032 defendant Brynkton Thomas chapman 603893 603893 Brynkton, Thomas, of Morcote, chapman 0
4839273 2308209 2308209 defendant Laughton Thomas   603893 603893 Laughton, Thomas, of Morcote, wright 0
4958576 2344530 2344530 defendant Chopyn Richard harper 603893 603893 Chopyn, Richard, of Morcote, harper 1
4967854 2347330 2347330 defendant Faukener William husbandman 603893 603893 Faukener, William, of Morcote, husbandman 0
4977720 2350297 2350297 defendant Fenell Thomas husbandman 603893 603893 Fenell, Thomas, of Morcote, husbandman 0
5070330 2377619 2377619 defendant West Thomas husbandman 603893 603893 West, Thomas, of Morcote, husbandman 1
5075524 2379176 2379176 defendant Weston Richard yeoman 603893 603893 Weston, Richard, of Morcote, yeoman 3
5143404 2399208 2399208 defendant Weston Richard yeoman 603893 603893 Weston, Richard, of Morcote, yeoman 3
5273341 2437274 2437274 defendant Grove Richard husbandman 603893 603893 Grove, Richard, of Morcote, husbandman 4
5285214 2440698 2440698 defendant Beller John husbandman 603893 603893 Beller, John, of Morcote, husbandman 0
5285216 2440699 2440699 defendant Beller John husbandman 603893 603893 Beller, John, of Morcote, husbandman 0
5317282 2450247 2450247 defendant Rolnes or Rolves William husbandman 603893 603893 Rolnes or Rolves, William, of Morcote, husbandman 2
5317287 2450247 2450247 defendant Spilbery William husbandman 603893 603893 Spilbery, William, of Morcote, husbandman 7
5397173 2474276 2474276 defendant Tampon Richard husbandman 603893 603893 Tampon, Richard, of Morcote, husbandman 0
5410364 2478052 2478052 defendant Tampon Richard husbandman 603893 603893 Tampon, Richard, of Morcote, husbandman 0
5499282 2504727 2504727 defendant Tampen Richard husbandman 603893 603893 Tampen, Richard, of Morcote, husbandman 2
5513800 2509172 2509172 defendant Tampen Richard husbandman 603893 603893 Tampen, Richard, of Morcote, husbandman 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);