names

32 rows where place_id = 620688

✎ 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
3737086 1937840 1937840 defendant Darker or Barker William husbandman 620688 620688 Darker or Barker, William, of Raydon, husbandman 0
3749666 1941807 1941807 defendant Drover William husbandman 620688 620688 Drover, William, of Raydon, husbandman 0
3749667 1941807 1941807 defendant Drover Robert husbandman 620688 620688 Drover, Robert, of Raydon, husbandman 1
3855447 1975346 1975346 defendant Wace John husbandman 620688 620688 Wace, John, of Raydon, husbandman 0
3943253 2004764 2004764 defendant Lyncoln Robert husbandman 620688 620688 Lyncoln, Robert, of Raydon, husbandman 0
3943254 2004764 2004764 defendant Barne Richard husbandman 620688 620688 Barne, Richard, of Raydon, husbandman 1
3943255 2004764 2004764 defendant Warne William husbandman 620688 620688 Warne, William, of Raydon, husbandman 2
3958922 2010205 2010205 plaintiff Salter John (legal representative) 620688 620688 Salter, John, of Raydon, husbandman, executors of 0
3980941 2017943 2017943 defendant Harman Christopher ditcher 620688 620688 Harman, Christopher, of Raydon, ditcher 0
4102199 2061080 2061080 defendant Todd Geoffrey weaver 620688 620688 Todd, Geoffrey, of Raydon, weaver 0
4123384 2068666 2068666 defendant Cullender John clerk 620688 620688 Cullender, John, of Raydon, clerk 0
4124514 2069066 2069066 defendant Walbye Thomas gent 620688 620688 Walbye, Thomas, of Raydon, gent 0
4126316 2069703 2069703 defendant Halsworthe alias Hyngame Anthony weaver 620688 620688 Halsworthe alias Hyngame, Anthony, of Raydon, weaver 0
4126317 2069703 2069703 defendant Cullmer John clerk 620688 620688 Cullmer, John, of Raydon, clerk 1
4202106 2096282 2096282 defendant Fletewood Henry yeoman 620688 620688 (Fletewood, Henry, of Raydon, yeoman 1
4210051 2099077 2099077 defendant Walby Thomas gent 620688 620688 Walby, Thomas, of Raydon, or of Wynterton, Norf, gent 1
4243201 2110718 2110718 defendant Humfrye Thomas yeoman 620688 620688 Humfrye, Thomas, of Raydon, yeoman 0
4327361 2139474 2139474 defendant Lytton John husbandman 620688 620688 Lytton, John, of Raydon, husbandman 3
4333287 2141416 2141416 defendant Hawckenett Thomas pointmaker 620688 620688 Hawckenett, Thomas, of Raydon, pointmaker 0
4349681 2147155 2147155 defendant Middlediche Anthony weaver 620688 620688 Middlediche, Anthony, of Raydon, weaver 0
4353559 2148469 2148469 defendant Fulcher George sawyer 620688 620688 Fulcher, George, of Raydon, sawyer 1
4353560 2148469 2148469 defendant Artys Nicholas carpenter 620688 620688 Artys, Nicholas, of Raydon, carpenter 2
4353561 2148469 2148469 defendant Middledytch Anthony weaver 620688 620688 Middledytch, Anthony, of Raydon, weaver 3
4372883 2155377 2155377 defendant Fulcher George   620688 620688 Fulcher, George, of Raydon, millwright 2
4382780 2158947 2158947 defendant Blocke Roger butcher 620688 620688 Blocke, Roger, of Raydon, butcher 0
4396499 2163404 2163404 defendant Mydledytch Anthony   620688 620688 Mydledytch, Anthony, of Raydon, linen weaver 0
4401009 2164928 2164928 defendant Fulcher George   620688 620688 Fulcher, George, of Raydon, millwright 2
4401911 2165236 2165236 defendant Middlediche Anthony weaver 620688 620688 Middlediche, Anthony, of Raydon, weaver 0
4408039 2167258 2167258 defendant Midledytche Anthony weaver 620688 620688 Midledytche, Anthony, of Raydon, weaver 0
4408041 2167258 2167258 defendant Fulcher Mathew sawyer 620688 620688 Fulcher, Mathew, of Raydon, sawyer 2
4520923 2206883 2206883 defendant Hayward William   620688 620688 Hayward, William, of Raydon 0
5608898 2537683 2537683 defendant Chaloner William chaplain 620688 620688 Chaloner, William, of Raydon, chaplain 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);