names

33 rows where place_id = 592467

✎ 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
3607776 1870082 1870082 defendant Stephyns William weaver 592467 592467 Stephyns, William, of Kevyll, weaver 0
3626936 1903276 1903276 defendant Berkesdale Thomas clothman 592467 592467 Berkesdale, Thomas, of Kevyll, clothman 1
3685898 1921747 1921747 plaintiff Berkysdale Robert clothman 592467 592467 Berkysdale, Robert, of Kevyll, clothman 0
3690483 1923190 1923190 defendant Barkesdale Thomas clothman 592467 592467 Barkesdale, Thomas, of Kevyll, clothman 0
3690486 1923191 1923191 defendant Barkesdale Thomas clothman 592467 592467 Barkesdale, Thomas, of Kevyll, clothman 0
3694428 1924462 1924462 defendant Bowke Stephen weaver 592467 592467 Bowke, Stephen, of Kevyll, weaver 0
3744532 1940192 1940192 defendant Stokes John butcher 592467 592467 Stokes, John, of Kevyll, butcher 0
3744533 1940192 1940192 defendant Stokes Robert yeoman 592467 592467 Stokes, Robert, of Kevyll, yeoman 1
3798244 1957348 1957348 defendant Sheyreffe Thomas butcher 592467 592467 Sheyreffe, Thomas, of Kevyll, butcher 1
3803030 1958848 1958848 defendant Bache James husbandman 592467 592467 Bache, James, of Kevyll, husbandman 0
3806743 1960008 1960008 defendant Pedyll Robert clothier 592467 592467 Pedyll, Robert, of Kevyll, clothier 0
3809081 1960724 1960724 defendant Stuckull William weaver 592467 592467 Stuckull, William, of Kevyll, weaver 1
3885428 1985380 1985380 plaintiff Bayly Thomas clothman 592467 592467 Bayly, Thomas, of Kevyll, clothman 0
5352020 2460734 2460734 defendant Mayne William gent 592467 592467 Mayne, William, of Kevyll, gent 0
5521193 2511444 2511444 defendant Stephyns William yeoman 592467 592467 Stephyns, William, of Kevyll, yeoman 3
5521198 2511445 2511445 defendant Stephyns William yeoman 592467 592467 Stephyns, William, of Kevyll, yeoman 3
5549776 2519969 2519969 defendant Barkesdale Thomas clothier 592467 592467 Barkesdale, Thomas, of Kevyll, clothier 0
5549778 2519969 2519969 defendant Stephyns Lawrence weaver 592467 592467 Stephyns, Lawrence, of Kevyll, weaver 2
5549779 2519969 2519969 defendant Shreff John weaver 592467 592467 Shreff, John, of Kevyll, weaver 3
5549781 2519969 2519969 defendant Yalde William weaver 592467 592467 Yalde, William, of Kevyll, weaver 5
5549782 2519969 2519969 defendant Blays Humphrey weaver 592467 592467 Blays, Humphrey, of Kevyll, weaver 6
5549783 2519969 2519969 defendant Smyth Thomas weaver 592467 592467 Smyth, Thomas, of Kevyll, weaver 7
5549784 2519969 2519969 defendant Kevylles John husbandman 592467 592467 Kevylles, John, of Kevyll, husbandman 8
5549785 2519969 2519969 defendant Forest John weaver 592467 592467 Forest, John, of Kevyll, weaver 9
5549786 2519969 2519969 defendant Burton John weaver 592467 592467 Burton, John, of Kevyll, weaver 10
5549787 2519969 2519969 defendant Atwode Andrew weaver 592467 592467 Atwode, Andrew, of Kevyll, weaver 11
5549788 2519969 2519969 defendant Clerk Richard husbandman 592467 592467 Clerk, Richard, of Kevyll, husbandman 12
5556604 2521883 2521883 defendant Barkesdale Thomas clothmaker 592467 592467 Barkesdale, Thomas, of Kevyll, clothmaker 0
5578883 2528460 2528460 defendant Lucas Robert weaver 592467 592467 Lucas, Robert, of Kevyll, weaver 0
5578885 2528461 2528461 defendant Lucas Robert weaver 592467 592467 Lucas, Robert, of Kevyll, weaver 0
5578886 2528461 2528461 defendant Coppe John laborer 592467 592467 Coppe, John, of Kevyll, laborer 1
5600168 2534937 2534937 defendant Stanley Walter husbandman 592467 592467 Stanley, Walter, of Kevyll, husbandman 0
5600169 2534937 2534937 defendant Nethe Henry laborer 592467 592467 Nethe, Henry, of Kevyll, laborer 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);