names

19 rows where place_id = 689933

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4082665 2054110 2054110 defendant Tashe Lancelot yeoman 689933 689933 Tashe, Lancelot, of Hornecastle, yeoman 1
4161190 2081991 2081991 defendant Corye John clerk 689933 689933 Corye, John, of Hornecastle, or of Maram, clerk 0
4225201 2104283 2104283 defendant Sugden Henry tailor 689933 689933 Sugden, Henry, of Hornecastle, tailor 0
4235851 2108112 2108112 defendant Kente John gent 689933 689933 Kente, John, of Hornecastle, gent 0
4238699 2109153 2109153 defendant Gibson Richard butcher 689933 689933 Gibson, Richard, of Hornecastle, butcher 2
4320183 2137160 2137160 defendant Eldred Robert gent 689933 689933 Eldred, Robert, of Hornecastle, gent 0
4364883 2152492 2152492 defendant Gibson Robert butcher 689933 689933 Gibson, Robert, of Hornecastle, butcher 0
4377914 2157170 2157170 defendant Suttabie Robert yeoman 689933 689933 Suttabie, Robert, of Hornecastle, yeoman 0
4443789 2183029 2183029 defendant Braban William weaver 689933 689933 Braban, William, of Hornecastle, weaver 0
4506231 2202451 2202451 defendant Smyth John   689933 689933 Smyth, John, of Hornecastle 0
4746837 2279576 2279576 defendant Marom William hostiler 689933 689933 Marom, William, of Hornecastle, hostiler 0
4821317 2302747 2302747 defendant Billyng John laborer 689933 689933 Billyng, John, of Hornecastle, laborer 2
4822642 2303159 2303159 defendant Grene John dyer 689933 689933 Grene, John, of Hornecastle, dyer 2
4840308 2308515 2308515 defendant Milner John miller 689933 689933 Milner, John, of Hornecastle, miller 0
5132051 2395865 2395865 defendant Pernell John   689933 689933 Pernell, John, of Hornecastle, parish clerk 0
5136121 2397075 2397075 defendant Ellarton William yeoman 689933 689933 Ellarton, William, of Hornecastle, yeoman 1
5224868 2422944 2422944 defendant Ellerton William yeoman 689933 689933 Ellerton, William, of Hornecastle, yeoman 2
5459216 2492660 2492660 plaintiff Gunby Thomas gent 689933 689933 Gunby, Thomas, of Hornecastle, gent 0
5510137 2508007 2508007 plaintiff Gunby Thomas gent 689933 689933 Gunby, Thomas, of Hornecastle, gent 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);