names

16 rows where place_id = 659452

✎ 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
3952503 2007944 2007944 defendant Levett John yeoman 659452 659452 Levett, John, of Framefeld, yeoman 0
4000202 2024840 2024840 defendant Norman Nicholas husbandman 659452 659452 Norman, Nicholas, of Framefeld, husbandman 0
4012396 2029156 2029156 plaintiff Pynyon alias Everett Richard   659452 659452 Pynyon alias Everett, Richard, of Framefeld, "hamarman" 0
4013497 2029561 2029561 defendant Byllyam Michael collier 659452 659452 Byllyam, Michael, of Framefeld, collier 0
4019782 2031806 2031806 defendant Carpenter Richard husbandman 659452 659452 Carpenter, Richard, of Framefeld, husbandman 0
4019783 2031806 2031806 defendant Freman John yeoman 659452 659452 Freman, John, of Framefeld, yeoman 1
4057311 2044999 2044999 defendant Carpenter Richard husbandman 659452 659452 Carpenter, Richard, of Framefeld, husbandman 0
4078675 2052669 2052669 plaintiff Tester Thomas cooper 659452 659452 Tester, Thomas, of Framefeld, cooper 0
4107044 2062815 2062815 defendant Barney Ralph yeooman 659452 659452 Barney, Ralph, of Framefeld, yeooman 3
4107062 2062820 2062820 defendant Snellyng John husbandman 659452 659452 Snellyng, John, of Framefeld, husbandman 0
4130909 2071368 2071368 defendant Brynckehurst Richard tanner 659452 659452 Brynckehurst, Richard, of Framefeld, tanner 2
4174820 2086661 2086661 defendant Brynckeherst Richard tanner 659452 659452 Brynckeherst, Richard, of Framefeld, tanner 0
4190038 2092017 2092017 defendant Carpenter John husbandman 659452 659452 Carpenter, John, of Framefeld, husbandman 0
4253547 2114177 2114177 defendant A Brooke Robert yeoman 659452 659452 A Brooke, Robert, of Framefeld, yeoman 0
4321124 2137481 2137481 defendant Payne Robert blacksmith 659452 659452 Payne, Robert, of Framefeld, blacksmith 0
5597799 2534208 2534208 plaintiff Delve or Delne Thomas   659452 659452 Delve or Delne, Thomas, of Framefeld 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);