names

32 rows where place_id = 603422

✎ 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
3654482 1911661 1911661 defendant Olsyng John laborer 603422 603422 Olsyng, John, of Whepsted, laborer 1
3674566 1918097 1918097 defendant Sturgeon Roger husbandman 603422 603422 Sturgeon, Roger, of Whepsted, husbandman 0
3717543 1931776 1931776 defendant Nunne Robert husbandman 603422 603422 Nunne, Robert, of Whepsted, husbandman 1
3732943 1936526 1936526 defendant Elsyng Richard laborer 603422 603422 Elsyng, Richard, of Whepsted, laborer 4
3742147 1939410 1939410 defendant Rose Thomas husbandman 603422 603422 Rose, Thomas, of Whepsted, husbandman 0
3773733 1949501 1949501 defendant Sturgeon Roger yeoman 603422 603422 Sturgeon, Roger, of Whepsted, yeoman 0
3777047 1950567 1950567 defendant Nunne William husbandman 603422 603422 Nunne, William, of Whepsted, husbandman 0
3785832 1953357 1953357 defendant Nonne Robert husbandman 603422 603422 Nonne, Robert, of Whepsted, husbandman 0
3790381 1954808 1954808 defendant Steward John husbandman 603422 603422 Steward, John, of Whepsted, husbandman 2
3791950 1955330 1955330 defendant Nunne John carpenter 603422 603422 Nunne, John, of Whepsted, carpenter 0
3833793 1968501 1968501 defendant Steward John (legal representative) 603422 603422 Steward, John, of Whepsted, husbandman, executors of 0
3833795 1968501 1968501 defendant Steward John husbandman 603422 603422 Steward, John, of WHepsted, husbandman 2
3922400 1997810 1997810 defendant Jervys William gent 603422 603422 Jervys, William, of Whepsted, gent 0
3922401 1997810 1997810 defendant Sturgyn Roger yeoman 603422 603422 Sturgyn, Roger, of Whepsted, yeoman 1
3922402 1997810 1997810 defendant Sturgyn John husbandman 603422 603422 Sturgyn, John, of Whepsted, husbandman 2
3922403 1997810 1997810 defendant Rose John husbandman 603422 603422 Rose, John, of Whepsted, husbandman 3
4000185 2024834 2024834 defendant Sturgeon Roger yeoman 603422 603422 Sturgeon, Roger, of Whepsted, yeoman 2
4281783 2123532 2123532 defendant Sturgen John (legal representative) 603422 603422 Sturgen, John, of Whepsted, yeoman, executrix of 0
4281784 2123532 2123532 defendant Stugen or Sturgen Joan widow 603422 603422 Stugen or Sturgen, Joan, of Whepsted, widow 1
4548801 2215562 2215562 defendant Toneld John   603422 603422 Toneld, John, of Whepsted 0
5028339 2365169 2365169 defendant Coke Lawrence laborer 603422 603422 Coke, Lawrence, of Whepsted, laborer 0
5167445 2406211 2406211 defendant Moor John husbandman 603422 603422 Moor, John, of Whepsted, husbandman 1
5182939 2410757 2410757 defendant More John husbandman 603422 603422 More, John, of Whepsted, husbandman 4
5182945 2410759 2410759 defendant Moor John husbandman 603422 603422 Moor, John, of Whepsted, husbandman 1
5296288 2443903 2443903 defendant Roos Thomas husbandman 603422 603422 Roos, Thomas, of Whepsted, husbandman 2
5362589 2463948 2463948 plaintiff Tusfeld John husbandman 603422 603422 Tusfeld, John, of Whepsted, husbandman 0
5362590 2463948 2463948 plaintiff Sturgyon William husbandman 603422 603422 Sturgyon, William, of Whepsted, husbandman 1
5362591 2463948 2463948 plaintiff Cage Robert husbandman 603422 603422 Cage, Robert, of Whepsted, husbandman 2
5362592 2463948 2463948 plaintiff Swale John husbandman 603422 603422 Swale, John, of Whepsted, husbandman 3
5522624 2511901 2511901 defendant Kylt William husbandman 603422 603422 Kylt, William, of Whepsted, husbandman 3
5567245 2524995 2524995 defendant Mayhowe John laborer 603422 603422 Mayhowe, John, of Whepsted, laborer 3
5593918 2533087 2533087 defendant Hyll William, senior laborer 603422 603422 Hyll, William, senior, of Whepsted, laborer 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);