names

35 rows where place_id = 595454

✎ 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
3620537 1873998 1873998 defendant Campyon John laborer 595454 595454 Campyon, John, of Lyllyngton, laborer 2
3673127 1917606 1917606 defendant Alryche John husbandman 595454 595454 Alryche, John, of Lyllyngton, husbandman 0
3777031 1950562 1950562 defendant Bartelett William laborer 595454 595454 Bartelett, William, of Lyllyngton, laborer 0
3794414 1956129 1956129 defendant Bartlet William laborer 595454 595454 Bartlet, William, of Lyllyngton, laborer 0
3834545 1968741 1968741 defendant Peche Elizabeth widow 595454 595454 Peche, Elizabeth, of Lyllyngton, widow 2
3850116 1973626 1973626 defendant Pechy Elizabeth widow 595454 595454 Pechy, Elizabeth, of Lyllyngton, widow 2
3865003 1978495 1978495 defendant Pechy Elizabeth widow 595454 595454 Pechy, Elizabeth, of Lyllyngton, widow 2
3892208 1987643 1987643 defendant Peche Elizabeth widow 595454 595454 Peche, Elizabeth, of Lyllyngton, widow 2
4007783 2027567 2027567 defendant Russell Thomas yeoman 595454 595454 Russell, Thomas, of Lyllyngton, yeoman 1
4007788 2027568 2027568 defendant Russell Thomas yeoman 595454 595454 Russell, Thomas, of Lyllyngton, yeoman 1
4037408 2038039 2038039 plaintiff Kaylwaye Martin gent 595454 595454 Kaylwaye, Martin, of Lyllyngton, gent 0
4037409 2038039 2038039 defendant Napper Lewis yeoman 595454 595454 Napper, Lewis, of Lyllyngton, yeoman 0
4165842 2083549 2083549 defendant Hardyn John yeoman 595454 595454 Hardyn, John, of Lyllyngton, yeoman 1
4285302 2124793 2124793 defendant Collyer John husbandman 595454 595454 Collyer, John, of Lyllyngton, husbandman 0
4308316 2133059 2133059 defendant Collyer John husbandman 595454 595454 Collyer, John, of Lyllyngton, husbandman 0
4674862 2257747 2257747 plaintiff Est John   595454 595454 Est, John, of Lyllyngton, on his own account 0
4674864 2257748 2257748 plaintiff Est John   595454 595454 Est, John, of Lyllyngton, on his own account 0
4725798 2273354 2273354 defendant Dounton Bartholomew gent 595454 595454 Dounton, Bartholomew, of Lyllyngton, gent 0
4763145 2284456 2284456 defendant Dunton Bartholomew   595454 595454 Dunton, Bartholomew, of Lyllyngton, franklin 0
4786299 2291758 2291758 defendant Dounton Bartholomew   595454 595454 Dounton, Bartholomew, of Lyllyngton, franklin 0
4865544 2316186 2316186 defendant Dounton Bartholomew   595454 595454 Dounton, Bartholomew, of Lyllyngton, franklin 0
5004482 2358209 2358209 defendant Fynyan Walter weaver 595454 595454 Fynyan, Walter, of Lyllyngton, weaver 1
5102061 2387028 2387028 defendant Broun William yeoman 595454 595454 Broun, William, of Lyllyngton, yeoman 1
5117327 2391502 2391502 defendant Broun William yeoman 595454 595454 Broun, William, of Lyllyngton, yeoman 1
5135278 2396818 2396818 defendant Yope John, junior husbandman 595454 595454 Yope, John, junior, of Lyllyngton, husbandman 0
5196844 2414829 2414829 defendant Stevenes John weaver 595454 595454 Stevenes, John, of Lyllyngton, weaver 4
5545935 2518803 2518803 defendant Kayleway Thomas gent 595454 595454 Kayleway, Thomas, of Lyllyngton, gent 0
5551822 2520578 2520578 plaintiff Darell Thomas esq 595454 595454 Darell, Thomas, of Lyllyngton, esq 0
5552757 2520855 2520855 defendant Mynteryn Thomas husbandman 595454 595454 Mynteryn, Thomas, of Lyllyngton, husbandman 0
5554965 2521454 2521454 defendant Orlage John husbandman 595454 595454 Orlage, John, of Lyllyngton, husbandman 0
5583588 2529942 2529942 defendant Keylewey Thomas gent 595454 595454 Keylewey, Thomas, of Lyllyngton, gent 0
5591687 2532386 2532386 defendant Courtenay William clerk 595454 595454 Courtenay, William, of Lyllyngton, clerk 0
5599071 2534591 2534591 defendant Kayleway Thomas gent 595454 595454 Kayleway, Thomas, of Lyllyngton, gent 0
5601552 2535377 2535377 defendant Neweman John husbandman 595454 595454 Neweman, John, of Lyllyngton, husbandman 1
5601553 2535377 2535377 defendant Neweman William husbandman 595454 595454 Neweman, William, of Lyllyngton, husbandman 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);