names

21 rows where place_id = 590096

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599910 1867626 1867626 defendant Wynder Richard weaver 590096 590096 Wynder, Richard, of Lofthous, weaver 1
3702845 1927163 1927163 defendant Franke Thomas clerk 590096 590096 Franke, Thomas, of Lofthous, clerk 0
4564129 2220351 2220351 defendant Thwaytes Thomas   590096 590096 Thwaytes, Thomas, of Lofthous 1
4594948 2229673 2229673 defendant Robynson William   590096 590096 Robynson, William, of Lofthous 0
4617105 2236358 2236358 defendant Symson William   590096 590096 together with Symson, William, of Lofthous 1
4617110 2236359 2236359 defendant Symson William   590096 590096 Symson, William, of Lofthous 0
4750527 2280638 2280638 defendant Hiperom John gent 590096 590096 Hiperom, John, of Lofthous, gent 0
4815989 2301093 2301093 plaintiff Lokwod John   590096 590096 Lokwod, John, of Lofthous 1
4854232 2312736 2312736 defendant Hepron Thomas gent [ out of focus ] 590096 590096 Hepron, Thomas, of Lofthous, gent [ out of focus ] 0
4877061 2319796 2319796 defendant Hepron Thomas gent 590096 590096 Hepron, Thomas, of Lofthous, gent 0
4933454 2336848 2336848 defendant Bamyll Thomas husbandman 590096 590096 Bamyll, Thomas, of Lofthous, husbandman 1
4933455 2336848 2336848 defendant Turnour William husbandman 590096 590096 Turnour, William, of Lofthous, husbandman 2
4984645 2352338 2352338 plaintiff Wolhous Thomas   590096 590096 Wolhous, Thomas, of Lofthous 3
5033209 2366594 2366594 defendant Spyne or Spyve Thomas husbandman 590096 590096 Spyne or Spyve, Thomas, of Lofthous, husbandman 0
5106432 2388315 2388315 defendant Hipprom John gent 590096 590096 Hipprom, John, of Lofthous, gent 0
5106433 2388315 2388315 defendant Hipprom Robert gent 590096 590096 Hipprom, Robert, of Lofthous, gent 1
5129732 2395182 2395182 defendant Hipperon John gent 590096 590096 Hipperon, John, of Lofthous, gent 9
5304420 2446320 2446320 defendant Hyppron John (legal representative) 590096 590096 Hyppron, John, of Lofthous, gent, sen, executors of 4
5304421 2446320 2446320 defendant Hyppron John gent 590096 590096 (Hyppron, John, of Lofthous, gent 5
5497018 2504043 2504043 defendant Cowell John tailor 590096 590096 Cowell, John, of Lofthous, tailor 2
5627341 2552517 2552517 defendant Marchall William yeoman 590096 590096 Marchall, William, of Lofthous, yeoman 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);