names

39 rows where place_id = 611035

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686464 1921919 1921919 defendant Pott William husbandman 611035 611035 Pott, William, of Upmynster, husbandman 2
3807124 1960121 1960121 plaintiff White John tanner 611035 611035 White, John, of Upmynster, tanner 0
3920857 1997319 1997319 defendant Frende Thomas husbandman 611035 611035 Frende, Thomas, of Upmynster, husbandman 1
3955099 2008846 2008846 defendant Pendreth Miles gent 611035 611035 Pendreth, Miles, of Upmynster, gent 0
4217062 2101461 2101461 defendant Wright Thomas yeoman 611035 611035 Wright, Thomas, of Upmynster, yeoman 0
4243241 2110731 2110731 defendant Wright Thomas yeoman 611035 611035 Wright, Thomas, of Upmynster, yeoman 0
4288829 2126058 2126058 defendant Palmer John chapman 611035 611035 Palmer, John, of Upmynster, chapman 2
4297376 2129165 2129165 defendant Palmer John chapman 611035 611035 Palmer, John, of Upmynster, chapman 3
4412688 2168836 2168836 defendant Palmer John tailor 611035 611035 Palmer, John, of Upmynster, tailor 0
4883285 2321699 2321699 defendant Lexston Thomas husbandman 611035 611035 Lexston, Thomas, of Upmynster, husbandman 1
4966623 2346952 2346952 defendant Germayn Stephen clerk 611035 611035 Germayn, Stephen, of Upmynster, clerk 0
4968721 2347614 2347614 defendant Deyncourt Thomas gent 611035 611035 Deyncourt, Thomas, of Upmynster, gent 0
5022261 2363405 2363405 defendant Dayncourt Roger gent 611035 611035 Dayncourt, Roger, of Upmynster, gent 0
5099753 2386363 2386363 defendant Cary Robert yeoman 611035 611035 Cary, Robert, of Upmynster, yeoman 0
5104524 2387753 2387753 defendant Wylde Richard carpenter 611035 611035 Wylde, Richard, of Upmynster, carpenter 0
5119845 2392239 2392239 defendant Wylde Richard carpenter 611035 611035 Wylde, Richard, of Upmynster, carpenter 0
5132725 2396067 2396067 defendant Wyld John husbandman 611035 611035 Wyld, John, of Upmynster, husbandman 0
5132726 2396067 2396067 defendant Gylmyn or Eylmyn John husbandman 611035 611035 Gylmyn or Eylmyn, John, of Upmynster, husbandman 1
5164188 2405265 2405265 defendant Hunt William husbandman 611035 611035 Hunt, William, of Upmynster, husbandman 2
5214275 2419907 2419907 defendant Wylde John husbandman 611035 611035 Wylde, John, of Upmynster, husbandman 1
5216562 2420574 2420574 plaintiff Dencourte Thomas gent 611035 611035 Dencourte, Thomas, of Upmynster, gent 0
5216563 2420574 2420574 defendant Laxton Thomas husbandman 611035 611035 Laxton, Thomas, of Upmynster, husbandman 0
5216564 2420575 2420575 plaintiff Dencourte Thomas gent 611035 611035 Dencourte, Thomas, of Upmynster, gent 0
5216565 2420575 2420575 defendant Laxton Thomas husbandman 611035 611035 Laxton, Thomas, of Upmynster, husbandman 0
5289147 2441831 2441831 defendant Hegler Thomas smith 611035 611035 Hegler, Thomas, of Upmynster, smith 2
5355030 2461642 2461642 defendant Baldewyn Thomas, senior husbandman 611035 611035 Baldewyn, Thomas, senior, of Upmynster, husbandman 1
5355032 2461642 2461642 defendant Baldewyn Robert laborer 611035 611035 Baldewyn, Robert, of Upmynster, laborer 3
5355033 2461642 2461642 defendant Baldewyn Andrew laborer 611035 611035 Baldewyn, Andrew, of Upmynster, laborer 4
5363676 2464293 2464293 defendant Kyng William husbandman 611035 611035 Kyng, William, of Upmynster, husbandman 0
5437689 2486207 2486207 defendant Wellys William chaplain 611035 611035 Wellys, William, of Upmynster, chaplain 3
5440264 2486989 2486989 defendant Kynt John husbandman 611035 611035 Kynt, John, of Upmynster, husbandman 0
5440265 2486989 2486989 defendant Witby William husbandman 611035 611035 Witby, William, of Upmynster, husbandman 1
5485376 2500540 2500540 defendant Wyllot Richard husbandman 611035 611035 Wyllot, Richard, of Upmynster, husbandman 0
5485377 2500540 2500540 defendant Wyllot John husbandman 611035 611035 Wyllot, John, of Upmynster, husbandman 1
5496749 2503949 2503949 defendant Athethe William husbandman 611035 611035 Athethe, William, of Upmynster, husbandman 1
5497949 2504334 2504334 defendant Stephyn Henry husbandman 611035 611035 Stephyn, Henry, of Upmynster, husbandman 0
5497950 2504334 2504334 defendant neulond John husbandman 611035 611035 neulond, John, of Upmynster, husbandman 1
5497951 2504334 2504334 defendant Stephyn Alice widow 611035 611035 Stephyn, Alice, of Upmynster, widow 2
5511647 2508490 2508490 defendant Attehethe William husbandman 611035 611035 Attehethe, William, of Upmynster, 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);