names

52 rows where place_id = 604957

✎ 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
3658598 1912941 1912941 defendant Scotte John   604957 604957 Scotte, John, of Iden, knight 0
3659858 1913337 1913337 defendant Walter Emma widow 604957 604957 Walter, Emma, of Iden, widow 0
3673562 1917758 1917758 defendant Scotte John   604957 604957 Scotte, John, of Iden, knight 0
3698002 1925600 1925600 defendant Van Agnes widow 604957 604957 Van, Agnes, of Iden, widow 0
3698047 1925616 1925616 defendant Matthy John laborer 604957 604957 Matthy, John, of Iden, laborer 2
3774153 1949629 1949629 defendant Munne Robert laborer 604957 604957 Munne, Robert, of Iden, laborer 0
3774154 1949629 1949629 defendant Dyngulden Thomas laborer 604957 604957 Dyngulden, Thomas, of Iden, laborer 1
3775464 1950069 1950069 defendant Van John (legal representative) 604957 604957 Van, John, of Iden, executors of 0
3779730 1951393 1951393 defendant Ameatt Richard yeoman 604957 604957 Ameatt, Richard, of Iden, yeoman 0
3790898 1954984 1954984 defendant Sampson Lawrence husbandman 604957 604957 Sampson, Lawrence, of Iden, husbandman 0
3795957 1956598 1956598 defendant Cranache Thomas husbandman 604957 604957 Cranache, Thomas, of Iden, husbandman 0
3859675 1976734 1976734 defendant Patryche Thomas husbandman 604957 604957 Patryche, Thomas, of Iden, husbandman 0
3924048 1998353 1998353 defendant Hope Robert husbandman 604957 604957 Hope, Robert, of Iden, husbandman 0
3924052 1998355 1998355 defendant Partryche Thomas yeoman 604957 604957 Partryche, Thomas, of Iden, yeoman 0
3924053 1998355 1998355 defendant Partryche Richard husbandman 604957 604957 Partryche, Richard, of Iden, husbandman 1
4224306 2103985 2103985 defendant Gosseppe Richard yeoman 604957 604957 Gosseppe, Richard, of Iden, yeoman 1
4224308 2103986 2103986 defendant Gosseppe Richard yeoman 604957 604957 Gosseppe, Richard, of Iden, yeoman 0
4224614 2104085 2104085 defendant Danyell William butcher 604957 604957 Danyell, William, of Iden, butcher 0
4225730 2104463 2104463 defendant Colbrande Lawrence yeoman 604957 604957 Colbrande, Lawrence, of Iden, yeoman 2
4232432 2106850 2106850 defendant Strodes John husbandman 604957 604957 Strodes, John, of Iden, husbandman 1
4232433 2106850 2106850 defendant Mason Robert husbandman 604957 604957 Mason, Robert, of Iden, husbandman 2
4232435 2106851 2106851 defendant Fowtrell Richard yeoman 604957 604957 Fowtrell, Richard, of Iden, yeoman 0
4232436 2106851 2106851 defendant Symons John husbandman 604957 604957 Symons, John, of Iden, husbandman 1
4232812 2106983 2106983 defendant Mawdesley Thomas clerk 604957 604957 Mawdesley, Thomas, of Iden, clerk 0
4250148 2113028 2113028 defendant Gossoppe Richard yeoman 604957 604957 Gossoppe, Richard, of Iden, yeoman 1
4250159 2113033 2113033 defendant Gosseppe Richard yeoman 604957 604957 Gosseppe, Richard, of Iden, yeoman 0
4266153 2118317 2118317 defendant Colbrande Lawrence yeoman 604957 604957 Colbrande, Lawrence, of Iden, yeoman 2
4274802 2121131 2121131 defendant Harte Samuel husbandman 604957 604957 Harte, Samuel, of Iden, husbandman 0
4284680 2124569 2124569 defendant Blacke Richard yeoman 604957 604957 Blacke, Richard, of Iden, yeoman 0
4322586 2137968 2137968 defendant Seely or Selye Robert yeoman 604957 604957 Seely or Selye, Robert, of Iden or of Rye, yeoman 0
4371697 2154935 2154935 defendant Waghorne Henry tailor 604957 604957 Waghorne, Henry, of Iden, tailor 0
4381915 2158637 2158637 defendant Gossopp Richard yeoman 604957 604957 Gossopp, Richard, of Iden, yeoman 0
4382214 2158747 2158747 defendant Waghorne George tailor 604957 604957 Waghorne, George, of Iden, tailor 0
4551641 2216458 2216458 defendant Salerne John   604957 604957 Salerne, John, of Iden 0
4614613 2235579 2235579 defendant Salerne John   604957 604957 Salerne, John, of Iden 0
4685601 2261090 2261090 plaintiff Salern John (legal representative) 604957 604957 Salern, John, of Iden, executors of 0
4750949 2280762 2280762 plaintiff Salerne John (legal representative) 604957 604957 Salerne, John, of Iden, executors of 0
4793501 2294076 2294076 defendant Fleccher William laborer 604957 604957 Fleccher, William, of Iden, laborer 0
4793822 2294188 2294188 defendant Kychenore Richard husbandman 604957 604957 Kychenore, Richard, of Iden, husbandman 0
4816683 2301313 2301313 defendant Kechenore Richard husbandman 604957 604957 Kechenore, Richard, of Iden, husbandman 0
4873004 2318516 2318516 defendant atte Crouche John laborer 604957 604957 atte Crouche, John, of Iden, laborer 0
4873006 2318517 2318517 defendant Petter William laborer 604957 604957 Petter, William, of Iden, laborer 0
4925927 2334540 2334540 defendant Petter William laborer 604957 604957 Petter, William, of Iden, laborer 1
4925929 2334541 2334541 defendant Kechenore John husbandman 604957 604957 Kechenore, John, of Iden, husbandman 0
4925930 2334541 2334541 defendant Petter William laborer 604957 604957 Petter, William, of Iden, laborer 1
4935691 2337551 2337551 defendant atte Wode Richard yeoman 604957 604957 atte Wode, Richard, of Iden, yeoman 0
5140416 2398298 2398298 defendant Oxenr--- John husbandman 604957 604957 Oxenr---, John, of Iden, husbandman 0
5140417 2398298 2398298 defendant Asshemeston John carpenter 604957 604957 Asshemeston, John, of Iden, carpenter 1
5161561 2404479 2404479 defendant Asshemeston John carpenter 604957 604957 Asshemeston, John, of Iden, carpenter 1
5404131 2476259 2476259 defendant Amyot William husbandman 604957 604957 Amyot, William, of Iden, husbandman 0
5627592 2552601 2552601 defendant Marchaunt William gent 604957 604957 Marchaunt, William, of Iden, gent 3
5627597 2552602 2552602 defendant Marchaunt William gent 604957 604957 Marchaunt, William, of Iden, gent 3

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);