names

32 rows where place_id = 679715

✎ 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
3965454 2012532 2012532 plaintiff Bawdewyn Thomas (legal representative) 679715 679715 Bawdewyn, Thomas, of Lymyngton, Hants, gent, administrator of 0
4037383 2038032 2038032 defendant Burrarde Thomas mercer 679715 679715 Burrarde, Thomas, of Lymyngton, Hants, mercer 0
4087609 2055864 2055864 defendant Wilsher Edmund tanner 679715 679715 Wilsher, Edmund, of Lymyngton, Hants, tanner 0
4143951 2076048 2076048 defendant Hunt William merchant 679715 679715 Hunt, William, of Lymyngton, Hants, merchant 0
4157229 2080596 2080596 defendant Mychell Walter mariner 679715 679715 Mychell, Walter, of Lymyngton, Hants, mariner 2
4157283 2080614 2080614 defendant Wylshe Edmund yeoman 679715 679715 Wylshe, Edmund, of Lymyngton, Hants, yeoman 1
4168451 2084452 2084452 defendant Blake John yeoman 679715 679715 Blake, John, of Lymyngton, Hants, yeoman 0
4168460 2084454 2084454 defendant Clare John glover 679715 679715 Clare, John, of Lymyngton, Hants, glover 0
4168465 2084455 2084455 defendant Hunt William merchant 679715 679715 Hunt, William, of Lymyngton, Hants, merchant 2
4170419 2085147 2085147 defendant Busshell Thomas tanner 679715 679715 Busshell, Thomas, of Lymyngton, Hants, tanner 0
4176907 2087394 2087394 defendant Dove Edmund gent 679715 679715 Dove, Edmund, of Lymyngton, Hants, gent 1
4198699 2095104 2095104 defendant Laskey John merchant 679715 679715 Laskey, John, of Lymyngton, Hants, merchant 0
4309679 2133543 2133543 defendant Cole Charles merchant 679715 679715 Cole, Charles, of Lymyngton, Hants, merchant 2
4321870 2137734 2137734 defendant Blake David blacksmith 679715 679715 Blake, David, of Lymyngton, Hants, blacksmith 0
4321875 2137736 2137736 defendant Turbervile Thomas gent 679715 679715 Turbervile, Thomas, of Lymyngton, Hants, gent 0
4329780 2140256 2140256 defendant Clare John yeoman 679715 679715 Clare, John, of Lymyngton, Hants, yeoman 1
4673889 2257449 2257449 defendant Pycher John gent 679715 679715 Pycher, John, of Lymyngton, Hants, gent 0
4676221 2258172 2258172 defendant Mewes William esq 679715 679715 Mewes, William, of Lymyngton, Hants, esq 2
4727423 2273822 2273822 defendant Taffell Walter husbandman 679715 679715 Taffell, Walter, of Lymyngton, Hants, husbandman 1
4755107 2281984 2281984 defendant Hogges John skinner 679715 679715 Hogges, John, of Lymyngton, Hants, skinner 0
4764369 2284850 2284850 defendant Pychard John gent 679715 679715 Pychard, John, of Lymyngton, Hants, gent 0
4787077 2292020 2292020 defendant Burlegh Agnes widow 679715 679715 Burlegh, Agnes, of Lymyngton, Hants, widow 2
4838069 2307827 2307827 defendant Lane John draper 679715 679715 Lane, John, of Lymyngton, Hants, draper 1
4845582 2310129 2310129 defendant Tenent John merchant 679715 679715 Tenent, John, of Lymyngton, Hants, merchant 0
4855067 2312935 2312935 defendant Meryet Margaret widow 679715 679715 Meryet, Margaret, of Lymyngton, Hants, widow 0
4873163 2318557 2318557 defendant Tenent John merchant 679715 679715 Tenent, John, of Lymyngton, Hants, merchant 0
4873167 2318558 2318558 defendant Tenent John merchant 679715 679715 Tenent, John, of Lymyngton, Hants, merchant 0
4979540 2350839 2350839 defendant Clerk Philip   679715 679715 Clerk, Philip, of Lymyngton, Hants, holy water clerk 0
5296661 2444009 2444009 defendant Holcombe Stephen husbandman 679715 679715 Holcombe, Stephen, of Lymyngton, Hants, husbandman 4
5308109 2447450 2447450 defendant Oglond Alice widow 679715 679715 Oglond, Alice, of Lymyngton, Hants, widow 1
5321871 2451611 2451611 defendant Hone or Hove Robert husbandman 679715 679715 Hone or Hove, Robert, of Lymyngton, Hants, husbandman 1
5392887 2473038 2473038 defendant Holcombe Stephen (legal representative) 679715 679715 Holcombe, Stephen, of Lymyngton, Hants, executor of 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);