names

35 rows where place_id = 601580

✎ 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
3646009 1909146 1909146 defendant Kyrkby Robert gent 601580 601580 Kyrkby, Robert, of Overton, Hants, gent 0
3728758 1935236 1935236 defendant Fyssher John clothmaker 601580 601580 Fyssher, John, of Overton, Hants, clothmaker 0
3739201 1938478 1938478 defendant Fyssher John clothmaker 601580 601580 Fyssher, John, of Overton, Hants, clothmaker 0
3751775 1942475 1942475 defendant Fysher John clothmaker 601580 601580 Fysher, John, of Overton, Hants, clothmaker 0
3790208 1954757 1954757 defendant Est William clothman 601580 601580 Est, William, of Overton, Hants, clothman 0
3790223 1954760 1954760 defendant Est William chapman 601580 601580 Est, William, of Overton, Hants, chapman 0
3933994 2001669 2001669 defendant Wylde Nicholas chapman 601580 601580 Wylde, Nicholas, of Overton, Hants, chapman 2
3933999 2001670 2001670 defendant Wylde Nicholas chapman 601580 601580 Wylde, Nicholas, of Overton, Hants, chapman 2
3934004 2001672 2001672 defendant Bynbery Thomas chapman 601580 601580 Bynbery, Thomas, of Overton, Hants, chapman 0
4042242 2039706 2039706 plaintiff Palmes William gent 601580 601580 Palmes, William, of Overton, Hants, gent 0
4042577 2039812 2039812 defendant Smyth William clothier 601580 601580 Smyth, William, of Overton, Hants, clothier 0
4042579 2039813 2039813 defendant Smyth William clothier 601580 601580 Smyth, William, of Overton, Hants, clothier 0
4061069 2046367 2046367 defendant Page Robert girdler 601580 601580 Page, Robert, of Overton, Hants, girdler 0
4195202 2093875 2093875 defendant Lancaster William chapman 601580 601580 Lancaster, William, of Overton, Hants, chapman 2
4211778 2099674 2099674 defendant Page Robert chapman 601580 601580 Page, Robert, of Overton, Hants, chapman 0
4218120 2101835 2101835 defendant Dowce Richard yeoman 601580 601580 Dowce, Richard, of Overton, Hants, yeoman 0
5039331 2368409 2368409 defendant Mounter William clerk 601580 601580 (Mounter, William, of Overton, Hants, clerk 1
5093447 2384484 2384484 defendant atte More Ingelram gent 601580 601580 atte More, Ingelram, of Overton, Hants, gent 1
5234946 2425800 2425800 defendant Spylan John smith 601580 601580 Spylan, John, of Overton, Hants, smith 0
5262703 2434080 2434080 defendant Knyght John chaplain 601580 601580 Knyght, John, of Overton, Hants, chaplain 0
5276626 2438243 2438243 defendant Hore John husbandman 601580 601580 Hore, John, of Overton, Hants, husbandman 2
5296541 2443977 2443977 defendant Hore John husbandman 601580 601580 Hore, John, of Overton, Hants, husbandman 2
5296546 2443978 2443978 defendant Hore John husbandman 601580 601580 Hore, John, of Overton, Hants, husbandman 1
5436619 2485882 2485882 defendant More Ingelram gent 601580 601580 More, Ingelram, of Overton, Hants, gent 0
5437156 2486046 2486046 defendant More Ingram gent 601580 601580 More, Ingram, of Overton, Hants, gent 0
5439037 2486597 2486597 defendant Neweport William weaver 601580 601580 Neweport, William, of Overton, Hants, weaver 0
5451636 2490361 2490361 defendant More Ingram gent 601580 601580 More, Ingram, of Overton, Hants, gent 0
5464845 2494400 2494400 defendant Neweporte William weaver 601580 601580 Neweporte, William, of Overton, Hants, weaver 0
5464849 2494401 2494401 defendant Neweporte William weaver 601580 601580 Neweporte, William, of Overton, Hants, weaver 0
5487871 2501259 2501259 defendant Neweporte William weaver 601580 601580 Neweporte, William, of Overton, Hants, weaver 0
5525478 2512559 2512559 defendant Baldyswell William gent 601580 601580 Baldyswell, William, of Overton, Hants, gent 1
5528224 2513387 2513387 defendant Cordyner William chapman 601580 601580 Cordyner, William, of Overton, Hants, chapman 2
5558208 2522350 2522350 defendant Stynkley Robert smith 601580 601580 Stynkley, Robert, of Overton, Hants, smith 3
5602848 2535775 2535775 defendant Clamarton Richard husbandman 601580 601580 Clamarton, Richard, of Overton, Hants, husbandman 2
5607557 2537255 2537255 defendant Wattys Thomas innholder 601580 601580 Wattys, Thomas, of Overton, Hants, innholder 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);