names

27 rows where place_id = 613353

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3697938 1925576 1925576 defendant Heydon John yeoman 613353 613353 Heydon, John, of Tetbury, Glos, yeoman 0
3740686 1938949 1938949 defendant Hyll John clothier 613353 613353 Hyll, John, of Tetbury, Glos, clothier 1
3740690 1938950 1938950 defendant Hyll John clothier 613353 613353 Hyll, John, of Tetbury, Glos, clothier 1
3754053 1943214 1943214 defendant Mayer Henry tailor 613353 613353 Mayer, Henry, of Tetbury, Glos, tailor 0
3756572 1944036 1944036 defendant Hykkys Thomas clothier 613353 613353 Hykkys, Thomas, of Tetbury, Glos, clothier 0
3768708 1947860 1947860 defendant Dene Thomas   613353 613353 Dene, Thomas, of Tetbury, Glos, mercer, administrators of 0
3783746 1952681 1952681 defendant Lessetur John chapman 613353 613353 Lessetur, John, of Tetbury, Glos, chapman 0
3792219 1955420 1955420 defendant Hykkys Thomas clothier 613353 613353 Hykkys, Thomas, of Tetbury, Glos, clothier 0
3808819 1960637 1960637 defendant Hyckys Thomas clothier 613353 613353 Hyckys, Thomas, of Tetbury, Glos, clothier 0
3820411 1964265 1964265 defendant Hyckys Thomas clothier 613353 613353 Hyckys, Thomas, of Tetbury, Glos, clothier 1
3857106 1975853 1975853 defendant Heydon John chapman 613353 613353 Heydon, John, of Tetbury, Glos, chapman 4
3979699 2017492 2017492 defendant Godwen Robert yeoman 613353 613353 Godwen, Robert, of Tetbury, Glos, yeoman 2
4141841 2075311 2075311 defendant Seede Eleanor widow 613353 613353 Seede, Eleanor, of Tetbury, Glos, widow 0
4664282 2250311 2250311 defendant Motfount John husbandman 613353 613353 Motfount, John, of Tetbury, Glos, husbandman 2
5056755 2373597 2373597 defendant Onewyn William chapman 613353 613353 Onewyn, William, of Tetbury, Glos, chapman 0
5070799 2377762 2377762 defendant Herte John yeoman 613353 613353 Herte, John, of Tetbury, Glos, yeoman 1
5254001 2431372 2431372 defendant Popyngay John carpenter 613353 613353 Popyngay, John, of Tetbury, Glos, carpenter 0
5319076 2450799 2450799 defendant Payn Robert husbandman 613353 613353 Payn, Robert, of Tetbury, Glos, husbandman 1
5348289 2459604 2459604 defendant Hern Walter gent 613353 613353 Hern, Walter, of tetbury, Glos, gent 0
5521159 2511432 2511432 defendant Flewelyn John yeoman 613353 613353 Flewelyn, John, of Tetbury, Glos, yeoman 5
5521162 2511433 2511433 defendant Flewelyng John yeoman 613353 613353 Flewelyng, John, of Tetbury, Glos, yeoman 1
5553168 2520967 2520967 defendant Sprotte William weaver 613353 613353 Sprotte, William, of Tetbury, Glos, weaver 0
5587039 2530974 2530974 defendant Adams Margery widow 613353 613353 Adams, Margery, of Tetbury, Glos, widow 2
5587044 2530975 2530975 defendant Adams Margery widow 613353 613353 Adams, Margery, of Tetbury, Glos, widow 2
5588212 2531317 2531317 defendant Savage John clothman 613353 613353 Savage, John, of Tetbury, Glos, clothman 1
5588216 2531318 2531318 defendant Savage John clothman 613353 613353 Savage, John, of Tetbury, Glos, clothman 1
5588714 2531482 2531482 defendant Sprotte William clothmaker 613353 613353 Sprotte, William, of Tetbury, Glos, clothmaker 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);