names

32 rows where place_id = 591611

✎ 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
3604968 1869216 1869216 defendant Alman John, senior husbandman 591611 591611 Alman, John, senior, of Metfeld, husbandman 2
3604969 1869216 1869216 defendant Alman Robert husbandman 591611 591611 Alman, Robert, of Metfeld, husbandman 3
3604970 1869216 1869216 defendant Alman John, junior husbandman 591611 591611 Alman, John, junior, of Metfeld, husbandman 4
3607079 1869878 1869878 defendant Wryghte Robert husbandman 591611 591611 Wryghte, Robert, of Metfeld, husbandman 2
3608664 1870370 1870370 defendant Kyng William pedder 591611 591611 Kyng, William, of Metfeld, pedder 0
3611491 1871267 1871267 defendant Grene Thomas husbandman 591611 591611 Grene, Thomas, of Metfeld, husbandman 0
3625554 1875529 1875529 defendant Cove or Cone John carpenter 591611 591611 Cove or Cone, John, of Metfeld, carpenter 0
3644432 1908676 1908676 defendant Welton John husbandman 591611 591611 Welton, John, of Metfeld, husbandman 4
3890037 1986903 1986903 defendant Crowe Robert husbandman 591611 591611 Crowe, Robert, of Metfeld, husbandman 1
3923735 1998246 1998246 defendant Cakker Thomas husbandman 591611 591611 Cakker, Thomas, of Metfeld, husbandman 1
4030202 2035452 2035452 plaintiff Duke or Duky Anthony yeoman 591611 591611 Duke or Duky, Anthony, of Metfeld, yeoman 0
4115100 2065689 2065689 defendant Peake Henry husbandman 591611 591611 Peake, Henry, of Metfeld, or of South Elmeham St James, Suff, husbandman 0
4132846 2072077 2072077 defendant Chambre Philip clothworker 591611 591611 Chambre, Philip, of Metfeld, clothworker 0
4278159 2122296 2122296 defendant Huntman James yeoman 591611 591611 Huntman, James, of Metfeld, or of Weybread, Suff, yeoman 1
4341158 2144180 2144180 defendant Greene William weaver 591611 591611 Greene, William, of Metfeld, weaver 3
4354929 2148939 2148939 defendant Gouche Nicholas yeoman 591611 591611 Gouche, Nicholas, of Metfeld, yeoman 0
4818923 2302003 2302003 defendant Yonge John yeoman 591611 591611 Yonge, John, of Metfeld, yeoman 1
4895101 2325131 2325131 defendant Sibson William husbandman 591611 591611 Sibson, William, of Metfeld, husbandman 0
4898454 2326171 2326171 defendant Gibson William husbandman 591611 591611 Gibson, William, of Metfeld, husbandman 0
5018314 2362241 2362241 defendant Bettys Robert carpenter 591611 591611 Bettys, Robert, of Metfeld, carpenter 0
5018315 2362241 2362241 defendant Bettys Thomas carpenter 591611 591611 Bettys, Thomas, of Metfeld, carpenter 1
5237835 2426650 2426650 defendant Boteler Robert husbandman 591611 591611 Boteler, Robert, of Metfeld, husbandman 0
5478847 2498693 2498693 defendant Oldryng Alexander husbandman 591611 591611 Oldryng, Alexander, of Metfeld, husbandman 0
5517995 2510471 2510471 defendant Orelowe John yeoman 591611 591611 Orelowe, John, of Metfeld, yeoman 0
5522735 2511939 2511939 defendant Orlowe John husbandman 591611 591611 Orlowe, John, of Metfeld, husbandman 3
5523661 2512226 2512226 defendant Orlowe John husbandman 591611 591611 Orlowe, John, of Metfeld, husbandman 0
5523663 2512227 2512227 defendant Orlowe John husbandman 591611 591611 Orlowe, John, of Metfeld, husbandman 0
5533693 2515087 2515087 defendant Sparke William husbandman 591611 591611 Sparke, William, of Metfeld, husbandman 3
5564803 2524291 2524291 defendant Cone or Cove John husbandman 591611 591611 Cone or Cove, John, of Metfeld, husbandman 1
5564817 2524293 2524293 defendant Charlett Thomas husbandman 591611 591611 Charlett, Thomas, of Metfeld, husbandman 1
5570834 2526028 2526028 plaintiff Jermy John, junior gent 591611 591611 Jermy, John, junior, of Metfeld, gent 0
5604729 2536343 2536343 defendant Dryver William clerk 591611 591611 Dryver, William, of Metfeld, clerk 3

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