names

27 rows where place_id = 625413

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3764052 1946403 1946403 defendant Bell John butcher 625413 625413 Bell, John, of Martham, Norf, butcher 0
3830758 1967503 1967503 defendant Stannowe Roger yeoman 625413 625413 Stannowe, Roger, of Martham, Norf, yeoman 1
3965107 2012403 2012403 defendant Staunton Robert yeoman 625413 625413 Staunton, Robert, of Martham, Norf, yeoman 0
4038791 2038496 2038496 defendant Eden Thomas yeoman 625413 625413 Eden, Thomas, of Martham, Norf, yeoman 0
4170404 2085140 2085140 defendant Russell Simon gent 625413 625413 (Russell, Simon, of Martham, Norf, gent 1
4234878 2107751 2107751 defendant Watt Zachary yeoman 625413 625413 (Watt, Zachary, of Martham, Norf, yeoman 1
4243484 2110813 2110813 defendant Watt Zachary yeoman 625413 625413 (Watt, Zachary, of Martham, Norf, yeoman 1
4277702 2122125 2122125 defendant Russe Peter yeoman 625413 625413 Russe, Peter, of Martham, Norf, yeoman 0
4280584 2123115 2123115 plaintiff Phillipps William (legal representative) 625413 625413 Phillipps, William, of Martham, Norf, gent, executrix of 0
4311220 2134071 2134071 defendant Constable John gent 625413 625413 Constable, John, of Martham, Norf, gent 0
5009040 2359528 2359528 defendant Caudeler John yeoman 625413 625413 Caudeler, John, of Martham, Norf, yeoman 1
5023443 2363765 2363765 defendant Lucas John husbandman 625413 625413 Lucas, John, of Martham, Norf, husbandman 0
5133088 2396163 2396163 defendant Clerk Geoffrey husbandman 625413 625413 Clerk, Geoffrey, of Martham, Norf, husbandman 0
5133092 2396164 2396164 defendant Clerk Geoffrey husbandman 625413 625413 Clerk, Geoffrey, of Martham, Norf, husbandman 0
5133096 2396165 2396165 defendant Clerk Geoffrey husbandman 625413 625413 Clerk, Geoffrey, of Martham, Norf, husbandman 0
5134888 2396707 2396707 defendant Maynard Robert yeoman 625413 625413 Maynard, Robert, of Martham, Norf, yeoman 0
5156713 2403123 2403123 defendant Rychers John yeoman 625413 625413 Rychers, John, of Martham, Norf, yeoman 1
5157822 2403413 2403413 defendant Skoo John husbandman 625413 625413 Skoo, John, of Martham, Norf, husbandman 1
5172817 2407784 2407784 defendant Rychers John yeoman 625413 625413 (Rychers, John, of Martham, Norf, yeoman 1
5184836 2411313 2411313 defendant Richerys John   625413 625413 Richerys, John, of Martham, Norf, franklin 1
5184839 2411314 2411314 defendant Rycherys John   625413 625413 Rycherys, John, of Martham, Norf, franklin 1
5204563 2417083 2417083 defendant Rycherys John   625413 625413 Rycherys, John, of Martham, Norf, franklin 1
5259136 2432973 2432973 defendant Rycheres John yeoman 625413 625413 Rycheres, John, of Martham, Norf, yeoman 1
5417397 2480123 2480123 defendant Bene or Beve John shoemaker 625413 625413 Bene or Beve, John, of Martham, Norf, shoemaker 0
5450042 2489901 2489901 defendant Bene John shoemaker 625413 625413 Bene, John, of Martham, Norf, shoemaker 0
5462222 2493602 2493602 defendant Dene John shoemaker 625413 625413 Dene, John, of Martham, Norf, shoemaker 0
5500403 2505064 2505064 defendant Fraunceys John yeoman 625413 625413 Fraunceys, John, of Martham, Norf, yeoman 2

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