names

15 rows where case_id = 1936236

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3731981 1936236 1936236 plaintiff Cokesey John     Cokesey, John 0
3731982 1936236 1936236 defendant Gybbyns Thomas husbandman 597103 597103 Gybbyns, Thomas, of Pepulton, husbandman 0
3731983 1936236 1936236 defendant Tailour William husbandman 619794 619794 Tailour, William, of Wolverton Parva, husbandman 1
3731984 1936236 1936236 defendant Prene Hugh brewer 586318 586318 Prene, Hugh, of Worcester, brewer 2
3731985 1936236 1936236 defendant Edwardys Thomas fuller 586318 586318 Edwardys, Thomas, of Worcester, fuller 3
3731986 1936236 1936236 defendant Treve John weaver 586318 586318 Treve, John, of Worcester, weaver 4
3731987 1936236 1936236 defendant Draper John weaver 615835 615835 Draper, John, of Norton juxta Evesham, weaver 5
3731988 1936236 1936236 defendant Broke John husbandman 615835 615835 Broke, John, of Norton juxta Evesham, husbandman 6
3731989 1936236 1936236 defendant Savage William husbandman 615835 615835 Savage, William, of Norton juxta Evesham, husbandman 7
3731990 1936236 1936236 defendant Genyns Thomas husbandman 619795 619795 Genyns, Thomas, of Parva Wolverton, husbandman 8
3731991 1936236 1936236 defendant Bacheler Thomas husbandman 597261 597261 Bacheler, Thomas, of Byrlyngham, husbandman 9
3731992 1936236 1936236 defendant Haswall John husbandman 597575 597575 Haswall, John, of Ludley, husbandman 10
3731993 1936236 1936236 defendant Pachet Richard husbandman 619796 619796 Pachet, Richard, of Bromusgrove, husbandman 11
3731994 1936236 1936236 defendant Fysher Thomas husbandman 619797 619797 Fysher, Thomas, of Pedyll, husbandman 12
3731995 1936236 1936236 defendant Rudyng Thomas gent 597261 597261 Rudyng, Thomas, of Byrlyngham, gent 13

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);