names

27 rows where place_id = 590495

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601393 1868097 1868097 defendant Stafford John husbandman 590495 590495 Stafford, John, of Rypley, husbandman 6
3797114 1956979 1956979 defendant Parkynson William   590495 590495 Parkynson, William, of Rypley, scythe smith 0
3894708 1988436 1988436 defendant Everegan John husbandman 590495 590495 Everegan, John, of Rypley, husbandman 1
3905745 1992199 1992199 defendant Longe Thomas yeoman 590495 590495 Longe, Thomas, of Rypley, yeoman 1
3905746 1992199 1992199 defendant Lancaster Richard yeoman 590495 590495 Lancaster, Richard, of Rypley, yeoman 2
3913695 1994921 1994921 defendant Syddon Henry husbandman 590495 590495 Syddon, Henry, of Rypley, husbandman 1
4482558 2195247 2195247 defendant Haxby John   590495 590495 Haxby, John, of Rypley 1
4759238 2283230 2283230 defendant Tyndale William tailor 590495 590495 Tyndale, William, of Rypley, tailor 0
4777703 2289022 2289022 defendant Shane or Shaue Richard smith 590495 590495 Shane or Shaue, Richard, of Rypley, smith 0
4777704 2289022 2289022 defendant Shane or Shaue John husbandman 590495 590495 Shane or Shaue, John, of Rypley, husbandman 1
4925024 2334258 2334258 defendant Marys John husbandman 590495 590495 Marys, John, of Rypley, husbandman 2
5135220 2396799 2396799 defendant Wyndesore Richard tailor 590495 590495 Wyndesore, Richard, of Rypley, tailor 1
5155354 2402716 2402716 defendant Wyndesore Richard tailor 590495 590495 Wyndesore, Richard, of Rypley, tailor 1
5326233 2452936 2452936 defendant Hall Robert husbandman 590495 590495 Hall, Robert, of Rypley, husbandman 0
5332204 2454705 2454705 defendant Wheteley William husbandman 590495 590495 Wheteley, William, of Rypley, husbandman 4
5332282 2454719 2454719 defendant Wryght Thomas husbandman 590495 590495 Wryght, Thomas, of Rypley, husbandman 1
5332283 2454719 2454719 defendant Wheteley Eilliam husbandman 590495 590495 Wheteley, Eilliam, of Rypley, husbandman 2
5363182 2464138 2464138 defendant Whitehed Robert   590495 590495 Whitehed, Robert, of Rypley, scythe smith 1
5394906 2473615 2473615 defendant Cletur John collier 590495 590495 Cletur, John, of Rypley, collier 0
5408158 2477414 2477414 defendant Cletur John collier 590495 590495 Cletur, John, of Rypley, collier 0
5478407 2498568 2498568 defendant Stafford John laborer 590495 590495 Stafford, John, of Rypley, laborer 4
5502141 2505592 2505592 defendant Petyte Richard husbandman 590495 590495 Petyte, Richard, of Rypley, husbandman 1
5532777 2514805 2514805 defendant Lame or Laine Robert husbandman 590495 590495 Lame or Laine, Robert, of Rypley, husbandman 2
5532779 2514805 2514805 defendant Fulwode James husbandman 590495 590495 Fulwode, James, of Rypley, husbandman 4
5532785 2514806 2514806 defendant Lane Robert husbandman 590495 590495 Lane, Robert, of Rypley, husbandman 2
5532793 2514807 2514807 defendant Lane Robert husbandman 590495 590495 Lane, Robert, of Rypley, husbandman 2
5532795 2514807 2514807 defendant Fulwode James husbandman 590495 590495 Fulwode, James, of Rypley, 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);