names

17 rows where place_id = 759462

✎ 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
4461692 2188717 2188717 plaintiff Stodleye John clerk 759462 759462 Stodleye, John, of Bishop's Lavyngton, clerk 0
4522880 2207491 2207491 defendant Kene William   759462 759462 Kene, William, of Bishop's Lavyngton 1
4530930 2209965 2209965 defendant Fynk John   759462 759462 Fynk, John, of Bishop's Lavyngton 2
4576272 2224084 2224084 defendant Palmer Thomas   759462 759462 Palmer, Thomas, of Bishop's Lavyngton 0
4576273 2224084 2224084 defendant Dornell John   759462 759462 Dornell, John, of Bishop's Lavyngton 1
4671412 2256708 2256708 defendant Romsey Robert husbandman 759462 759462 Romsey, Robert, of Bishop's Lavyngton, husbandman 0
4677050 2258437 2258437 defendant Romesay Robert husbandman 759462 759462 Romesay, Robert, of Bishop's Lavyngton, husbandman 1
4685346 2261012 2261012 defendant Romesey Robert husbandman 759462 759462 Romesey, Robert, of Bishop's Lavyngton, husbandman 0
4695772 2264160 2264160 defendant Loder William   759462 759462 Loder, William, of Bishop's Lavyngton, franklin 0
4720740 2271818 2271818 defendant Leder William   759462 759462 Leder, William, of Bishop's Lavyngton, franklin 0
4723788 2272743 2272743 defendant Skayll Peter husbandman 759462 759462 Skayll, Peter, of Bishop's Lavyngton, husbandman 0
4931047 2336105 2336105 defendant Hardyng Thomas husbandman 759462 759462 Hardyng, Thomas, of Bishop's Lavyngton, husbandman 0
4931049 2336105 2336105 defendant Hardyng John husbandman 759462 759462 Hardyng, John, of Bishop's Lavyngton, husbandman 2
5129427 2395093 2395093 defendant Floure William husbandman 759462 759462 Floure, William, of Bishop's Lavyngton, husbandman 0
5148715 2400747 2400747 defendant Floure William husbandman 759462 759462 Floure, William, of Bishop's Lavyngton, husbandman 0
5183626 2410945 2410945 defendant Floure William husbandman 759462 759462 Floure, William, of Bishop's Lavyngton, husbandman 0
5434319 2485202 2485202 defendant Walrond Thomas   759462 759462 Walrond, Thomas, of Bishop's Lavyngton, gent, administrators of 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);