names

42 rows where place_id = 602140

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648610 1909953 1909953 defendant Larwode John husbandman 602140 602140 Larwode, John, of Wolterton, husbandman 1
3676832 1918793 1918793 defendant Langdon Thomas gent 602140 602140 Langdon, Thomas, of Wolterton, gent 2
3793947 1955978 1955978 defendant Langdon Thomas gent 602140 602140 Langdon, Thomas, of Wolterton, gent 0
3795770 1956545 1956545 defendant Landon or Langdon Thomas gent 602140 602140 Landon or Langdon, Thomas, of Wolterton, gent 0
3850484 1973739 1973739 plaintiff More John gent 602140 602140 More, John, of Wolterton, gent 0
3898942 1989850 1989850 defendant Langdon John gent 602140 602140 Langdon, John, of Wolterton, gent 0
3904247 1991665 1991665 defendant Langedon Thomas gent 602140 602140 Langedon, Thomas, of Wolterton, gent 1
3917827 1996323 1996323 defendant Langdon Thomas gent 602140 602140 Langdon, Thomas, of Wolterton, gent 0
3970134 2014154 2014154 defendant Langdon John gent 602140 602140 Langdon, John, of Wolterton, gent 2
3970135 2014154 2014154 defendant Langdon Christopher gent 602140 602140 Langdon, Christopher, of Wolterton, gent 3
3975601 2016030 2016030 defendant Pynchyn Robert husbandman or blacksmith 602140 602140 Pynchyn, Robert, of Wolterton, husbandman or blacksmith 3
3980245 2017700 2017700 defendant Pynchyn Robert   602140 602140 Pynchyn, Robert, of Wolterton. Husbandman 1
4015003 2030072 2030072 defendant Crede James husbandman 602140 602140 Crede, James, of Wolterton, husbandman 11
4034951 2037179 2037179 defendant Hast Thomas gent 602140 602140 Hast, Thomas, of Wolterton, gent 0
4110662 2064070 2064070 defendant Pynchyn Geoffery husbandman 602140 602140 Pynchyn, Geoffery, of Wolterton, husbandman 1
4110665 2064071 2064071 defendant Pynchyn Geoffery husbandman 602140 602140 Pynchyn, Geoffery, of Wolterton, husbandman 1
4141408 2075151 2075151 defendant Francys John carpenter 602140 602140 Francys, John, of Wolterton, carpenter 1
4154074 2079518 2079518 defendant Moore William gent 602140 602140 Moore, William, of Wolterton, gent 3
4154079 2079519 2079519 defendant Moore William gent 602140 602140 Moore, William, of Wolterton, gent 3
4186809 2090873 2090873 defendant More William gent 602140 602140 More, William, of Wolterton, gent 0
4265587 2118128 2118128 defendant Fraunces Cecily widow 602140 602140 Fraunces, Cecily, of Wolterton, widow 2
4265588 2118128 2118128 defendant Fraunces John husbandman 602140 602140 Fraunces, John, of Wolterton, husbandman 3
4281040 2123269 2123269 defendant Grymboll Thomas thatcher 602140 602140 Grymboll, Thomas, of Wolterton, thatcher 0
4386419 2160136 2160136 defendant Canne John husbandman 602140 602140 Canne, John, of Wolterton, husbandman 1
4427473 2173429 2173429 defendant Calwod Robert de   602140 602140 Calwod, Robert de, of Wolterton 0
4567281 2221324 2221324 plaintiff Talyour Roger   602140 602140 Talyour, Roger, of Wolterton 0
4650811 2246256 2246256 defendant Dycones Nicholas   602140 602140 Dycones, Nicholas, of Wolterton 1
4677550 2258591 2258591 defendant Grenewey Robert husbandman 602140 602140 Grenewey, Robert, of Wolterton, husbandman 0
4767945 2285946 2285946 defendant Larwode John yeoman 602140 602140 Larwode, John, of Wolterton, yeoman 2
4787318 2292104 2292104 defendant Bertilmewe Henry yeoman 602140 602140 Bertilmewe, Henry, of Wolterton, yeoman 0
4838801 2308064 2308064 defendant Wymond Robert clerk 602140 602140 Wymond, Robert, of Wolterton, clerk 2
4884296 2321995 2321995 defendant Julles John husbandman 602140 602140 Julles, John, of Wolterton, husbandman 0
4975210 2349541 2349541 defendant Larwode John, senior (legal representative) 602140 602140 Larwode, John, senior, of Wolterton, husbandman, executors of 0
4975211 2349541 2349541 defendant Sarys John husbandman 602140 602140 (Sarys, John, of Wolterton, husbandman 1
4975212 2349541 2349541 defendant Jerveys Robert husbandman 602140 602140 Jerveys, Robert, of Wolterton, husbandman 2
4992928 2354767 2354767 defendant Jullys John, sen husbandman 602140 602140 Jullys, John, sen, of Wolterton, husbandman 0
5000261 2356953 2356953 defendant Gergeys Robert husbandman 602140 602140 Gergeys, Robert, of Wolterton, husbandman 0
5110204 2389391 2389391 defendant Herman Godfrey husbandman 602140 602140 Herman, Godfrey, of Wolterton, husbandman 0
5452261 2490553 2490553 defendant Larwode Thomas husbandman 602140 602140 Larwode, Thomas, of Wolterton, husbandman 1
5464214 2494203 2494203 defendant Larwode Thomas husbandman 602140 602140 Larwode, Thomas, of Wolterton, husbandman 1
5475758 2497747 2497747 defendant Larwode Thomas husbandman 602140 602140 Larwode, Thomas, of Wolterton, husbandman 0
5487245 2501082 2501082 defendant Larwode Thomas husbandman 602140 602140 Larwode, Thomas, of Wolterton, husbandman 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);