names

34 rows where place_id = 592862

✎ 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
3609192 1870536 1870536 defendant Smyth William yeoman 592862 592862 Smyth, William, of Holbeche, Lincs, yeoman 0
3864629 1978366 1978366 defendant Callowe John yeoman 592862 592862 Callowe, John, of Holbeche, Lincs, yeoman 0
3905970 1992283 1992283 defendant Trayforde George gent 592862 592862 Trayforde, George, of Holbeche, Lincs, gent 0
4228972 2105615 2105615 defendant Keyes John yeoman 592862 592862 Keyes, John, of Holbeche, Lincs, yeoman 0
4287864 2125707 2125707 defendant Barker Thomas yeoman 592862 592862 Barker, Thomas, of Holbeche, Lincs, or of St Mary Magdalene, Lincoln, yeoman 0
4357615 2149894 2149894 defendant Keyes John gent 592862 592862 Keyes, John, of Holbeche, Lincs, gent 0
4675459 2257933 2257933 defendant Sybbesseye Thomas yeoman 592862 592862 Sybbesseye, Thomas, of Holbeche, Lincs, yeoman 0
4722198 2272267 2272267 defendant Tounesson Richard salter 592862 592862 Tounesson, Richard, of Holbeche, Lincs, salter 0
4768507 2286124 2286124 defendant Sibsay Thomas yeoman 592862 592862 Sibsay, Thomas, of Holbeche, Lincs, yeoman 0
4789742 2292861 2292861 defendant Yool John tailor 592862 592862 Yool, John, of Holbeche, Lincs, tailor 0
4806534 2298257 2298257 defendant Wade John fishmonger 592862 592862 Wade, John, of Holbeche, Lincs, fishmonger 0
4822586 2303141 2303141 plaintiff Smyth John   592862 592862 Smyth, John, of Holbeche, Lincs 0
4859245 2314267 2314267 defendant Calowe Henry husbandman 592862 592862 Calowe, Henry, of Holbeche, Lincs, husbandman 0
4923789 2333881 2333881 defendant Yool John yeoman 592862 592862 Yool, John, of Holbeche, Lincs, yeoman 0
4930913 2336067 2336067 defendant Spelk Thomas husbandman 592862 592862 Spelk, Thomas, of Holbeche, Lincs, husbandman 0
4965721 2346674 2346674 defendant Thakker Roger weaver 592862 592862 Thakker, Roger, of Holbeche, Lincs, weaver 0
4985576 2352601 2352601 defendant Gamull Simon yeoman 592862 592862 Gamull, Simon, of Holbeche, Lincs, yeoman 0
4985622 2352615 2352615 defendant Dyghill John husbandman 592862 592862 Dyghill, John, of Holbeche, Lincs, husbandman 4
4994424 2355208 2355208 defendant Braytofte Richard husbandman 592862 592862 Braytofte, Richard, of Holbeche, Lincs, husbandman 0
4994956 2355350 2355350 defendant Spell or Spelk Thomas yeoman 592862 592862 Spell or Spelk, Thomas, of Holbeche, Lincs, yeoman 2
5008778 2359458 2359458 defendant Onty John husbandman 592862 592862 Onty, John, of Holbeche, Lincs, husbandman 0
5059279 2374341 2374341 defendant Calowe John husbandman 592862 592862 Calowe, John, of Holbeche, Lincs, husbandman 0
5059284 2374342 2374342 defendant Calowe John husbandman 592862 592862 Calowe, John, of Holbeche, Lincs, husbandman 0
5060182 2374618 2374618 defendant Rowehold Thomas yeoman 592862 592862 Rowehold, Thomas, of Holbeche, Lincs, yeoman 2
5244127 2428473 2428473 defendant Palfreyman John husbandman 592862 592862 Palfreyman, John, of Holbeche, Lincs, husbandman 2
5245157 2428745 2428745 defendant Be- William husbandman 592862 592862 Be-, William, of Holbeche, Lincs, husbandman 0
5249557 2429986 2429986 defendant Baldewar John husbandman 592862 592862 Baldewar, John, of Holbeche, Lincs, husbandman, Walter, William, of Wymondham, husbandman 3
5333759 2455170 2455170 defendant Potte John husbandman 592862 592862 Potte, John, of Holbeche, Lincs, husbandman 1
5341413 2457509 2457509 defendant Ben William husbandman 592862 592862 Ben, William, of Holbeche, Lincs, husbandman 0
5359065 2462880 2462880 defendant Ben William husbandman 592862 592862 Ben, William, of Holbeche, Lincs, husbandman 0
5504287 2506256 2506256 defendant Smyth William merchant 592862 592862 Smyth, William, of Holbeche, Lincs, merchant 2
5505883 2506764 2506764 defendant Bradowe William yeoman or salter 592862 592862 Bradowe, William, of Holbeche, Lincs, yeoman or salter 0
5521316 2511484 2511484 defendant Garner John yeoman 592862 592862 Garner, John, of Holbeche, Lincs, yeoman 0
5575219 2527340 2527340 defendant Flete John yeoman 592862 592862 Flete, John, of Holbeche, Lincs, 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);