names

39 rows where place_id = 587235

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590865 1864774 1864774 defendant Ketyll Michael husbandman 587235 587235 Ketyll, Michael, of Sprouton, husbandman 0
4418175 2170564 2170564 plaintiff Vynter John   587235 587235 Vynter, John, of Sprouton 0
4442413 2182570 2182570 defendant Hore John le   587235 587235 Hore, John le, of Sprouton 0
4624943 2238770 2238770 plaintiff Oode John, sen   587235 587235 Oode, John, sen, of Sprouton 0
4724615 2272998 2272998 defendant Ode John husbandman 587235 587235 Ode, John, of Sprouton, husbandman 0
4726408 2273541 2273541 defendant Ode John husbandman 587235 587235 Ode, John, of Sprouton, husbandman 0
4796264 2294977 2294977 defendant Cooke John yeoman 587235 587235 Cooke, John, of Sprouton, yeoman 0
4796266 2294978 2294978 defendant Cooke John yeoman 587235 587235 Cooke, John, of Sprouton, yeoman 0
4798895 2295829 2295829 defendant Stokton Ralph husbandman 587235 587235 Stokton, Ralph, of Sprouton, husbandman 0
4798897 2295830 2295830 defendant Stokton Ralph husbandman 587235 587235 Stokton, Ralph, of Sprouton, husbandman 0
4817724 2301630 2301630 defendant Ode John plowman 587235 587235 Ode, John, of Sprouton, plowman 0
4817725 2301630 2301630 defendant Mastall Thomas plowman 587235 587235 Mastall, Thomas, of Sprouton, plowman 1
4852959 2312347 2312347 defendant Cook William husbandman 587235 587235 Cook, William, of Sprouton, husbandman 0
4852960 2312347 2312347 defendant Godard Margaret   587235 587235 Godard, Margaret, of Sprouton, servant 1
4917132 2331866 2331866 defendant Ode John yeoman 587235 587235 Ode, John, of Sprouton, yeoman 1
4965043 2346465 2346465 defendant Rande John husbandman 587235 587235 Rande, John, of Sprouton, husbandman 0
4965046 2346466 2346466 defendant Rande John husbandman 587235 587235 Rande, John, of Sprouton, husbandman 0
4966100 2346790 2346790 defendant Lesse John laborer 587235 587235 Lesse, John, of Sprouton, laborer 3
5019854 2362685 2362685 defendant Rande John yeoman 587235 587235 Rande, John, of Sprouton, yeoman 3
5144655 2399594 2399594 defendant Wode Thomas husbandman 587235 587235 Wode, Thomas, of Sprouton, husbandman 0
5144657 2399594 2399594 defendant Wode John   587235 587235 Wode, John, of Sprouton, laborer, son of the previously named Thomas Wode 2
5144662 2399595 2399595 defendant Wode Thomas husbandman 587235 587235 Wode, Thomas, of Sprouton, husbandman 0
5144664 2399595 2399595 defendant Wode John   587235 587235 Wode, John, of Sprouton, laborer, son of previously mentioned Thomas 2
5164947 2405484 2405484 defendant Terry John husbandman 587235 587235 Terry, John, of Sprouton, husbandman 0
5165407 2405629 2405629 defendant Wode Thomas husbandman 587235 587235 Wode, Thomas, of Sprouton, husbandman 0
5165409 2405629 2405629 defendant Wode John   587235 587235 Wode, John, of Sprouton, laborer, son of Thomas Wode 2
5178900 2409556 2409556 defendant Terry John husbandman 587235 587235 Terry, John, of Sprouton, husbandman 0
5179454 2409725 2409725 defendant Wode John   587235 587235 Wode, John, of Sprouton, laborer, son of Thomas 2
5201656 2416251 2416251 defendant Terry John husbandman 587235 587235 (Terry, John, of Sprouton, husbandman 1
5211736 2419174 2419174 defendant Ody Thomas husbandman 587235 587235 Ody, Thomas, of Sprouton, husbandman 2
5314429 2449342 2449342 defendant Waryn John   587235 587235 Waryn, John, of Sprouton, collar maker 1
5325999 2452868 2452868 defendant Dan John laborer 587235 587235 Dan, John, of Sprouton, laborer 0
5326000 2452868 2452868 defendant Feldegate William yeoman 587235 587235 Feldegate, William, of Sprouton, yeoman 1
5326907 2453121 2453121 defendant Danne John thatcher 587235 587235 Danne, John, of Sprouton, thatcher 1
5326908 2453121 2453121 defendant Waryn John husbandman 587235 587235 Waryn, John, of Sprouton, husbandman 2
5326909 2453121 2453121 defendant Mascall Thomas laborer 587235 587235 Mascall, Thomas, of Sprouton, laborer 3
5374505 2467629 2467629 defendant Felgate William husbandman 587235 587235 Felgate, William, of Sprouton, husbandman 0
5444425 2488238 2488238 defendant Wilkynson Thomas clerk 587235 587235 Wilkynson, Thomas, of Sprouton, clerk 0
5457164 2492038 2492038 defendant Wilkynson Thomas clerk 587235 587235 Wilkynson, Thomas, of Sprouton, clerk 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);