names

39 rows where place_id = 591567

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604850 1869183 1869183 defendant Skuriour John chapman 591567 591567 Skuriour, John, of Wynchelsey, Sussex, chapman 1
3604854 1869184 1869184 defendant Skuryour John chapman 591567 591567 Skuryour, John, of Wynchelsey, Sussex, chapman 1
3665915 1915276 1915276 defendant Fysshe Simon gent 591567 591567 Fysshe, Simon, of Wynchelsey, Sussex, gent 1
3719688 1932424 1932424 defendant Henman John yeoman 591567 591567 Henman, John, of Wynchelsey, Sussex, yeoman 1
3837369 1969599 1969599 defendant Stokes Henry merchant of the staple 591567 591567 Stokes, Henry, of Wynchelsey, Sussex, gent, merchant of the staple 0
3849864 1973543 1973543 plaintiff Maister Peter (legal representative) 591567 591567 Maister, Peter, of Wynchelsey, Sussex, merchant, executors of 0
3849867 1973544 1973544 plaintiff Maister Peter (legal representative) 591567 591567 Maister, Peter, of Wynchelsey, Sussex, merchant, executors of 0
3850185 1973648 1973648 plaintiff Mayster Peter (legal representative) 591567 591567 Mayster, Peter, of Wynchelsey, Sussex, merchant, executors of 0
3864230 1978229 1978229 defendant Gryffyn George merchant 591567 591567 Gryffyn, George, of Wynchelsey, Sussex, merchant 1
3905146 1991984 1991984 defendant Lewes George yeoman 591567 591567 Lewes, George, of Wynchelsey, Sussex, yeoman 4
3914692 1995258 1995258 defendant Lewys George merchant 591567 591567 Lewys, George, of Wynchelsey, Sussex, merchant 0
3924570 1998532 1998532 defendant Lowys George gent 591567 591567 Lowys, George, of Wynchelsey, Sussex, gent 1
3928795 1999966 1999966 defendant Danyell Peter clerk 591567 591567 Danyell, Peter, of Wynchelsey, Sussex, clerk 0
3938886 2003342 2003342 defendant Garratt John draper 591567 591567 Garratt, John, of Wynchelsey, Sussex, draper 2
4031820 2036043 2036043 defendant Peyrse Robert brewer 591567 591567 Peyrse, Robert, of Wynchelsey, Sussex, brewer 0
4031838 2036050 2036050 defendant Peyrse Robert brewer 591567 591567 Peyrse, Robert, of Wynchelsey, Sussex, brewer 0
4054893 2044141 2044141 defendant Whytfylde Thomas yeoman 591567 591567 Whytfylde, Thomas, of Wynchelsey, Sussex, yeoman 0
4074840 2051301 2051301 defendant Bolton Francis yeoman 591567 591567 Bolton, Francis, of Wynchelsey, Sussex, yeoman 0
4081300 2053622 2053622 defendant Smearsall Nicholas grasier 591567 591567 Smearsall, Nicholas, of Wynchelsey, Sussex, grasier 0
4102586 2061223 2061223 defendant Fane Thomas gent 591567 591567 Fane, Thomas, of Wynchelsey, Sussex, gent 2
4103363 2061484 2061484 defendant Bolton Francis yeoman 591567 591567 Bolton, Francis, of Wynchelsey, Sussex, yeoman 0
4103366 2061485 2061485 defendant Bolton Francis yeoman 591567 591567 Bolton, Francis, of Wynchelsey, Sussex, yeoman 0
4125406 2069370 2069370 defendant Bolton Francis yeoman 591567 591567 Bolton, Francis, of Wynchelsey, Sussex, yeoman 3
4126616 2069805 2069805 defendant Harwood Thomas gent 591567 591567 Harwood, Thomas, of Wynchelsey, Sussex, gent 1
4133873 2072451 2072451 defendant Tockey Robert yeoman 591567 591567 Tockey, Robert, of Wynchelsey, Sussex, yeoman 0
4236788 2108443 2108443 defendant Nethersole John gent 591567 591567 Nethersole, John, of Wynchelsey, Sussex, gent 0
4334146 2141699 2141699 defendant Adams Lawrence lighterman 591567 591567 (Adams, Lawrence, of Wynchelsey, Sussex, lighterman 1
4964329 2346244 2346244 defendant Yonge William shipman 591567 591567 Yonge, William, of Wynchelsey, Sussex, shipman 1
4980205 2351026 2351026 defendant Yong alias Hiwnge William master of ship le Mary of Wynchelsey 591567 591567 Yong alias Hiwnge, William, of Wynchelsey, Sussex, mariner, master of ship le Mary of Wynchelsey 0
5320470 2451204 2451204 defendant Syncler Thomas skinner 591567 591567 Syncler, Thomas, of Wynchelsey, Sussex, skinner 1
5320473 2451205 2451205 defendant Syncler Thomas skinner 591567 591567 Syncler, Thomas, of Wynchelsey, Sussex, skinner 1
5440584 2487089 2487089 defendant Potter Francis   591567 591567 Potter, Francis, of Wynchelsey, Sussex, goldsmith, administrators of 2
5453890 2491054 2491054 defendant Potter Francis   591567 591567 Potter, Francis, of Wynchelsey, Sussex, goldsmith, administrators of 2
5465776 2494679 2494679 defendant Porter Francis   591567 591567 Porter, Francis, of Wynchelsey, Sussex, goldsmith, administrators of 2
5503911 2506137 2506137 defendant Potter Francis   591567 591567 Potter, Francis, of Wynchelsey, Sussex, goldsmith, administrators of 2
5526547 2512870 2512870 defendant Sherman Guy waterman 591567 591567 Sherman, Guy, of Wynchelsey, Sussex, waterman 1
5536442 2515885 2515885 defendant Bardeles John merchant 591567 591567 Bardeles, John, of Wynchelsey, Sussex, merchant 2
5539393 2516808 2516808 defendant Godard Thomas yeoman 591567 591567 Godard, Thomas, of Wynchelsey, Sussex, or of Feyrfeld, Kent, yeoman 0
5559940 2522862 2522862 defendant Berkley Richard gent 591567 591567 Berkley, Richard, of Wynchelsey, Sussex, gent 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);