names

17 rows where place_id = 626496

✎ 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
3770452 1948439 1948439 defendant Wellys John husbandman 626496 626496 Wellys, John, of Fyllyngham, husbandman 1
3770453 1948439 1948439 defendant Bryght Henry husbandman 626496 626496 Bryght, Henry, of Fyllyngham, husbandman 2
3807121 1960119 1960119 defendant Gybons Richard   626496 626496 Gybons, Richard, of Fyllyngham, mason 2
3824791 1965629 1965629 defendant Gybons Richard   626496 626496 Gybons, Richard, of Fyllyngham, mason 2
4012734 2029277 2029277 defendant Westfeld Robert yeoman 626496 626496 Westfeld, Robert, of Fyllyngham, yeoman 0
4022072 2032624 2032624 defendant Danport Thomas clerk 626496 626496 Danport, Thomas, of Fyllyngham, or of Lincoln, clerk 0
4540618 2212964 2212964 defendant Peke William   626496 626496 Peke, William, of Fyllyngham 0
4752508 2281193 2281193 defendant Sawyll John husbandman 626496 626496 Sawyll, John, of Fyllyngham, husbandman 1
4852385 2312167 2312167 defendant Curteys John husbandman 626496 626496 Curteys, John, of Fyllyngham, husbandman 0
4852386 2312167 2312167 defendant Glower William husbandman 626496 626496 Glower, William, of Fyllyngham, husbandman 1
5242228 2427927 2427927 defendant Westfeld John yeoman 626496 626496 Westfeld, John, of Fyllyngham, yeoman 0
5268343 2435865 2435865 defendant Jakson Edmund shoemaker 626496 626496 Jakson, Edmund, of Fyllyngham, shoemaker 2
5454389 2491221 2491221 defendant Kyng William husbandman 626496 626496 Kyng, William, of Fyllyngham, husbandman 2
5466278 2494852 2494852 defendant Kyng William husbandman 626496 626496 Kyng, William, of Fyllyngham, husbandman 2
5466285 2494853 2494853 defendant Kyng William husbandman 626496 626496 Kyng, William, of Fyllyngham, husbandman 2
5502517 2505706 2505706 defendant Kyng William husbandman 626496 626496 Kyng, William, of Fyllyngham, husbandman 1
5558452 2522417 2522417 defendant Frayman John husbandman 626496 626496 Frayman, John, of Fyllyngham, husbandman 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);