names

32 rows where place_id = 601990

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647955 1909759 1909759 defendant Laurans alias Hayward Thomas pulter 601990 601990 Laurans alias Hayward, Thomas, of Offord Cluny, pulter 0
3695908 1924957 1924957 defendant Armouth Richard smith 601990 601990 Armouth, Richard, of Offord Cluny, smith 0
3713607 1930566 1930566 defendant Laurence Thomas pulter 601990 601990 Laurence, Thomas, of Offord Cluny, pulter 3
3729083 1935346 1935346 defendant Laurence Thomas pulter 601990 601990 Laurence, Thomas, of Offord Cluny, pulter 1
3737707 1938015 1938015 defendant Creswold Thomas yeoman 601990 601990 Creswold, Thomas, of Offord Cluny, yeoman 1
3737708 1938015 1938015 defendant Nicollys Robert yeoman 601990 601990 Nicollys, Robert, of Offord Cluny, yeoman 2
3766786 1947274 1947274 defendant Laurence William husbandman 601990 601990 Laurence, William, of Offord Cluny, husbandman 0
3818564 1963709 1963709 defendant Grossold Thomas yeoman 601990 601990 Grossold, Thomas, of Offord Cluny, yeoman 1
3825863 1965938 1965938 defendant Rycroft Richard yeoman 601990 601990 Rycroft, Richard, of Offord Cluny, yeoman 0
3859915 1976821 1976821 defendant Warner John husbandman 601990 601990 Warner, John, of Offord Cluny, husbandman 1
4494659 2199021 2199021 defendant Bolle Thomas chaplain 601990 601990 Bolle, Thomas, of Offord Cluny, chaplain 0
4555130 2217536 2217536 plaintiff Haward Henry   601990 601990 Haward, Henry, of Offord Cluny 0
4664113 2250264 2250264 defendant Graswell Peter husbandman 601990 601990 Graswell, Peter, of Offord Cluny, husbandman 0
4690328 2262530 2262530 defendant Hardegrave John husbandman 601990 601990 Hardegrave, John, of Offord Cluny, husbandman 0
4690330 2262531 2262531 defendant Herdegrave John husbandman 601990 601990 Herdegrave, John, of Offord Cluny, husbandman 0
4746731 2279538 2279538 defendant Raude or Rande Thomas husbandman 601990 601990 Raude or Rande, Thomas, of Offord Cluny, husbandman 2
4781274 2290156 2290156 defendant Laven or Lanen Thomas husbandman 601990 601990 Laven or Lanen, Thomas, of Offord Cluny, husbandman 2
4785297 2291418 2291418 defendant Hardegrave Thomas husbandman 601990 601990 Hardegrave, Thomas, of Offord Cluny, husbandman 4
4793673 2294134 2294134 defendant Mannyng Thomas husbandman 601990 601990 Mannyng, Thomas, of Offord Cluny, husbandman 0
4805838 2298034 2298034 defendant Marham John husbandman 601990 601990 Marham, John, of Offord Cluny, husbandman 0
4809777 2299221 2299221 defendant Lavell Thomas husbandman 601990 601990 Lavell, Thomas, of Offord Cluny, husbandman 0
4810286 2299362 2299362 defendant Lavell Thomas husbandman 601990 601990 Lavell, Thomas, of Offord Cluny, husbandman 0
4834932 2306928 2306928 defendant Norton Thomas husbandman 601990 601990 Norton, Thomas, of Offord Cluny, husbandman 0
4846593 2310446 2310446 defendant Lavell Thomas husbandman 601990 601990 Lavell, Thomas, of Offord Cluny, husbandman 0
4868976 2317270 2317270 defendant Norton Thomas maltman 601990 601990 Norton, Thomas, of Offord Cluny, maltman 0
4894929 2325077 2325077 defendant Burbriogge Richard husbandman 601990 601990 Burbriogge, Richard, of Offord Cluny, husbandman 2
4904712 2328081 2328081 defendant Vyell Henry husbandman 601990 601990 Vyell, Henry, of Offord Cluny, husbandman 2
4906096 2328501 2328501 defendant Bekelyswad Thomas husbandman 601990 601990 Bekelyswad, Thomas, of Offord Cluny, husbandman 3
4922412 2333419 2333419 defendant Vyell Henry husbandman 601990 601990 Vyell, Henry, of Offord Cluny, husbandman 2
5033405 2366651 2366651 defendant Edons Thomas husbandman 601990 601990 Edons, Thomas, of Offord Cluny, husbandman 1
5245062 2428724 2428724 defendant Bocher Henry husbandman 601990 601990 Bocher, Henry, of Offord Cluny, husbandman 1
5245076 2428727 2428727 defendant Ulffe Edmund husbandman 601990 601990 Ulffe, Edmund, of Offord Cluny, husbandman 4

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