names

43 rows where place_id = 587979

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593019 1865444 1865444 defendant Felde John wheeler 587979 587979 Felde, John, of Shordyche, Middx, wheeler 0
3638291 1906793 1906793 defendant Grenyng John   587979 587979 Grenyng, John, of Shordyche, Middx, minstrel 4
3646998 1909462 1909462 defendant Stapull William butcher 587979 587979 Stapull, William, of Shordyche, Middx, butcher 0
3651696 1910887 1910887 defendant Grenyng Thomas   587979 587979 Grenyng, Thomas, of Shordyche, Middx, minstrel 4
3705790 1928092 1928092 defendant Goddard William   587979 587979 Goddard, William, of Shordyche, Middx, mechant of the staple 0
3710002 1929436 1929436 defendant Robynson John yeoman 587979 587979 Robynson, John, of Shordyche, Middx, yeoman 2
3737505 1937971 1937971 defendant Foxley Lawrence gent 587979 587979 Foxley, Lawrence, of Shordyche, Middx, gent 0
3737509 1937972 1937972 defendant Foxley Lawrence gent 587979 587979 Foxley, Lawrence, of Shordyche, Middx, gent 0
3738169 1938152 1938152 defendant Godard William merchant of the staple 587979 587979 Godard, William, of Shordyche, Middx, merchant of the staple 1
3783981 1952771 1952771 defendant Foxley Lawrence gent 587979 587979 Foxley, Lawrence, of Shordyche, Middx, gent 0
3818984 1963831 1963831 defendant Goddarde William gent 587979 587979 Goddarde, William, of Shordyche, Middx, gent 0
3876268 1982302 1982302 defendant Chesman William yeoman 587979 587979 Chesman, William, of Shordyche, Middx, yeoman 5
3897799 1989466 1989466 defendant Wynde Dorothy widow 587979 587979 Wynde, Dorothy, of Shordyche, Middx, widow 0
3915680 1995617 1995617 defendant Goddard William gent 587979 587979 Goddard, William, of Shordyche, Middx, gent 0
3917129 1996090 1996090 defendant Goddard William merchant of the staple 587979 587979 Goddard, William, of Shordyche, Middx, merchant of the staple 0
3917231 1996122 1996122 defendant Goddard William merchant of the staple 587979 587979 Goddard, William, of Shordyche, Middx, merchant of the staple 0
3978486 2017055 2017055 defendant Robynson William butcher 587979 587979 (Robynson, William, of Shordyche, Middx, butcher 1
4000089 2024798 2024798 plaintiff Goddard Alice widow 587979 587979 Goddard, Alice, of Shordyche, Middx, widow 0
4018977 2031525 2031525 plaintiff Walsted Henry tailor 587979 587979 Walsted, Henry, of Shordyche, Middx, tailor 0
4045156 2040719 2040719 defendant Setton William innholder 587979 587979 Setton, William, of Shordyche, Middx, innholder 1
4049572 2042287 2042287 defendant Goddard George gent 587979 587979 Goddard, George, of Shordyche, Middx, gent 1
4211327 2099515 2099515 defendant Frere Hugh   587979 587979 Frere, Hugh, of Shordyche, Middx, silk weaver 0
4795894 2294865 2294865 defendant Gefford John pulter 587979 587979 Gefford, John, of Shordyche, Middx, pulter 4
4800321 2296280 2296280 defendant Hille John husbandman 587979 587979 Hille, John, of Shordyche, Middx, or of Harleton, husbandman 1
4889169 2323399 2323399 defendant Purdon Richard coiner 587979 587979 Purdon, Richard, of Shordyche, Middx, coiner 1
4919735 2332674 2332674 defendant Sqwyer Nicholas brewer 587979 587979 Sqwyer, Nicholas, of Shordyche, Middx, brewer 1
4919745 2332678 2332678 defendant Sqwyer Nicholas brewer 587979 587979 Sqwyer, Nicholas, of Shordyche, Middx, brewer 1
4984450 2352283 2352283 defendant Langton John gent 587979 587979 Langton, John, of Shordyche, Middx, gent 0
4985028 2352454 2352454 defendant Langton John gent 587979 587979 Langton, John, of Shordyche, Middx, gent 0
5225483 2423127 2423127 defendant Chircheman Richard yeoman 587979 587979 Chircheman, Richard, of Shordyche, Middx, yeoman 2
5231989 2424925 2424925 defendant Lincoln John yeoman 587979 587979 Lincoln, John, of Shordyche, Middx, yeoman 1
5287512 2441371 2441371 defendant Brook Robert baker 587979 587979 Brook, Robert, of Shordyche, Middx, baker 0
5344405 2458429 2458429 defendant Brokke John cooper 587979 587979 Brokke, John, of Shordyche, Middx, cooper 2
5360189 2463228 2463228 defendant Part Richard yeoman 587979 587979 Part, Richard, of Shordyche, Middx, yeoman 3
5399905 2475067 2475067 defendant Stokdale James yeoman 587979 587979 Stokdale, James, of Shordyche, Middx, yeoman 0
5407841 2477321 2477321 defendant Joye John gent 587979 587979 Joye, John, of Shordyche, Middx, gent 0
5407844 2477322 2477322 defendant Joye John gent 587979 587979 Joye, John, of Shordyche, Middx, gent 0
5499739 2504864 2504864 defendant Colford Thomas butcher 587979 587979 Colford, Thomas, of Shordyche, Middx, butcher 2
5544409 2518361 2518361 defendant Horne Robert husbandman 587979 587979 Horne, Robert, of Shordyche, Middx, husbandman 4
5550577 2520192 2520192 defendant Trases John yeoman 587979 587979 Trases, John, of Shordyche, Middx, yeoman 1
5564935 2524331 2524331 defendant Page John smith 587979 587979 Page, John, of Shordyche, Middx, smith 0
5604305 2536209 2536209 defendant Chery John   587979 587979 Chery, John, of Shordyche, Middx, tile maker 0
5604312 2536211 2536211 defendant Chery John   587979 587979 Chery, John, of Shordyche, Middx, tile maker 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);