names

28 rows where place_id = 597362

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628275 1903705 1903705 defendant Nicholas William yeoman 597362 597362 Nicholas, William, of Assheby de la Zouche, yeoman 0
3755957 1943816 1943816 defendant Yorke John butcher 597362 597362 Yorke, John, of Assheby de la Zouche, butcher 0
3857900 1976110 1976110 defendant Yorke John butcher 597362 597362 Yorke, John, of Assheby de la Zouche, butcher 0
3857903 1976111 1976111 defendant Yorke John butcher 597362 597362 Yorke, John, of Assheby de la Zouche, butcher 0
3864200 1978215 1978215 defendant Spenser Robert yeoman 597362 597362 Spenser, Robert, of Assheby de la Zouche, yeoman 0
3878296 1982989 1982989 defendant Spenser Robert yeoman 597362 597362 Spenser, Robert, of Assheby de la Zouche, yeoman 0
4470813 2191526 2191526 defendant Coke John skinner 597362 597362 Coke, John, of Assheby de la Zouche, skinner 0
4604849 2232689 2232689 plaintiff Admet Robert   597362 597362 Admet, Robert, of Assheby de la Zouche 0
4622173 2237913 2237913 defendant Herteswell William   597362 597362 Herteswell, William, of Assheby de la Zouche 0
4622175 2237914 2237914 defendant Hertuswell William   597362 597362 Hertuswell, William, of Assheby de la Zouche 0
4702581 2266218 2266218 defendant Blakfordby Simon gent 597362 597362 Blakfordby, Simon, of Assheby de la Zouche, gent 0
4899469 2326475 2326475 plaintiff Hervy alias Cartwryght Roger   597362 597362 Hervy alias Cartwryght, Roger, of Assheby de la Zouche 0
4911511 2330101 2330101 defendant Stokes Thomas, junior gent 597362 597362 Stokes, Thomas, junior, of Assheby de la Zouche, gent 1
4937112 2337979 2337979 defendant Stoke Thomas, junior gent 597362 597362 Stoke, Thomas, junior, of Assheby de la Zouche, gent 1
4986101 2352767 2352767 defendant Kyrkeby John chapman 597362 597362 Kyrkeby, John, of Assheby de la Zouche, chapman 1
5028077 2365090 2365090 defendant Goodknap alias Blythe William chapman 597362 597362 Goodknap alias Blythe, William, of Assheby de la Zouche, chapman 0
5099209 2386196 2386196 defendant Stone John yeoman 597362 597362 Stone, John, of Assheby de la Zouche, yeoman 0
5219168 2421331 2421331 defendant Leveson or Leneson Thomas yeoman 597362 597362 Leveson or Leneson, Thomas, of Assheby de la Zouche, yeoman 1
5219169 2421331 2421331 defendant Stone John yeoman 597362 597362 Stone, John, of Assheby de la Zouche, yeoman 2
5219179 2421334 2421334 defendant Leneson or Leveson Thomas yeoman 597362 597362 Leneson or Leveson, Thomas, of Assheby de la Zouche, yeoman 1
5219180 2421334 2421334 defendant Stone John yeoman 597362 597362 Stone, John, of Assheby de la Zouche, yeoman 2
5302546 2445736 2445736 defendant Chapleyn Bartholomew yeoman 597362 597362 Chapleyn, Bartholomew, of Assheby de la Zouche, yeoman 0
5387083 2471374 2471374 defendant (illegible) Thomas yeoman 597362 597362 _, Thomas, of Assheby de la Zouche, yeoman 0
5387084 2471374 2471374 defendant Blakfordby John   597362 597362 Blakfordby, John, of Assheby de la Zouche, pedlar 1
5412339 2478636 2478636 defendant Blakfordby John   597362 597362 Blakfordby, John, of Assheby de la Zouche, pedlar 0
5427080 2483040 2483040 defendant Forster Thomas yeoman 597362 597362 Forster, Thomas, of Assheby de la Zouche, yeoman 0
5488099 2501333 2501333 defendant Grey Humphrey esq 597362 597362 Grey, Humphrey, of Assheby de la Zouche, or of Nayleston, Leics, esq 3
5583344 2529861 2529861 defendant Yorke John butcher 597362 597362 Yorke, John, of Assheby de la Zouche, butcher 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);