names

31 rows where place_id = 601940

✎ 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
3647762 1909692 1909692 defendant Masseham John yeoman 601940 601940 Masseham, John, of Wymyngton, yeoman 3
3753976 1943194 1943194 defendant Grey John husbandman 601940 601940 Grey, John, of Wymyngton, husbandman 0
4413634 2169157 2169157 plaintiff Boweles John   601940 601940 Boweles, John, of Wymyngton, parson 0
4445786 2183624 2183624 plaintiff Curteys John   601940 601940 Curteys, John, of Wymyngton 0
4445788 2183625 2183625 plaintiff Curteys John   601940 601940 Curteys, John, of Wymyngton 0
4445790 2183626 2183626 plaintiff Curteys John   601940 601940 Curteys, John, of Wymyngton 0
4445793 2183627 2183627 plaintiff Curteys John   601940 601940 Curteys, John, of Wymyngton 0
4473516 2192378 2192378 plaintiff Curteys Alfred   601940 601940 Curteys, Alfred, of Wymyngton 0
4473518 2192379 2192379 plaintiff Curteys John (legal representative) 601940 601940 Curteys, John, of Wymyngton, executors of 0
4508087 2203002 2203002 plaintiff Wytheryn John   601940 601940 Wytheryn, John, of Wymyngton, parson, on his own account 0
4519082 2206323 2206323 defendant Wytheryn John   601940 601940 Wytheryn, John, of Wymyngton, parson 0
4534420 2211039 2211039 plaintiff Saucy William   601940 601940 Saucy, William, of Wymyngton 0
4542138 2213431 2213431 plaintiff Wytheryn John   601940 601940 Wytheryn, John, of Wymyngton, parson 0
4542140 2213432 2213432 plaintiff Wytheryn John   601940 601940 Wytheryn, John, of Wymyngton, parson 0
4715550 2270193 2270193 defendant Whytgschurch John   601940 601940 Whytgschurch, John, of Wymyngton, chaplain, formerly of Herefordshire 2
4782249 2290448 2290448 plaintiff Cole John   601940 601940 Cole, John, of Wymyngton 0
4785651 2291540 2291540 defendant Wychurche John chaplain 601940 601940 Wychurche, John, of Wymyngton, chaplain 1
4804487 2297590 2297590 plaintiff Bokeland William   601940 601940 Bokeland, William, of Wymyngton, parson & brother of John Bokelond, of All Saints College, Aylyngton & Master of Fotheringay College 0
4804490 2297591 2297591 plaintiff Bokeland William   601940 601940 (Bokeland, William, of Wymyngton, parson, & brother of Testator 1
4804494 2297592 2297592 plaintiff Bokeland William   601940 601940 (Bokeland, William, of Wymyngton, parson, & brother of Testator 1
4830625 2305601 2305601 plaintiff Bokeland William   601940 601940 (Bokeland, William, of Wymyngton, parson 1
4830645 2305607 2305607 plaintiff Bokland William   601940 601940 (Bokland, William, of Wymyngton, parson 1
4885391 2322316 2322316 plaintiff Gryndell Edmund   601940 601940 Gryndell, Edmund, of Wymyngton 0
4931864 2336353 2336353 defendant Motte John chaplain 601940 601940 Motte, John, of Wymyngton, chaplain 1
5068136 2376974 2376974 plaintiff Penell or Pevell Roger (legal representative) 601940 601940 Penell or Pevell, Roger, of Wymyngton, executors of 0
5138348 2397725 2397725 defendant Frayre John miller 601940 601940 Frayre, John, of Wymyngton, miller 1
5159131 2403787 2403787 defendant Frayre John miller 601940 601940 Frayre, John, of Wymyngton, miller 1
5279708 2439146 2439146 defendant Kendale William miller 601940 601940 Kendale, William, of Wymyngton, or of Sharnebrook, Beds, miller 0
5279712 2439147 2439147 defendant Kendale William miller 601940 601940 Kendale, William, of Wymyngton, or of Sharnebrook, Beds, miller 0
5613497 2548012 2548012 plaintiff Curtays John   601940 601940 Curtays, John, of Wymyngton 0
5628086 2552755 2552755 plaintiff Penel or Pevel Roger   601940 601940 Penel or Pevel, Roger, of Wymyngton 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);