names

42 rows where place_id = 612558

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3691316 1923444 1923444 defendant Cobham Edward   612558 612558 Cobham, Edward, of Grenewyche, knight 0
3693905 1924297 1924297 defendant Stephenson Hugh yeoman 612558 612558 Stephenson, Hugh, of Grenewyche, yeoman 3
3705839 1928108 1928108 defendant Coke William gent 612558 612558 Coke, William, of Grenewyche, gent 0
3736639 1937711 1937711 plaintiff Johnson John   612558 612558 Johnson, John, of Grenewyche 0
3741026 1939055 1939055 plaintiff Skelton Elizabeth widow 612558 612558 Skelton, Elizabeth, of Grenewyche, widow 1
3854588 1975078 1975078 defendant Edmondys John yeoman 612558 612558 Edmondys, John, of Grenewyche, yeoman 0
3857413 1975953 1975953 defendant Holmes William (legal representative) 612558 612558 Holmes, William, of Grenewyche, executors of 0
3871917 1980842 1980842 defendant Owen Jasper esq 612558 612558 Owen, Jasper, of Grenewyche, esq 1
3918019 1996393 1996393 defendant Floyd Edward yeoman 612558 612558 Floyd, Edward, of Grenewyche, yeoman 1
3918020 1996393 1996393 defendant Langdon Robert yeoman 612558 612558 Langdon, Robert, of Grenewyche, yeoman 2
3918027 1996394 1996394 defendant Gold Baptist yeoman 612558 612558 Gold, Baptist, of Grenewyche, yeoman 1
3918028 1996394 1996394 defendant Walker Thomas yeoman 612558 612558 Walker, Thomas, of Grenewyche, yeoman 2
3918029 1996394 1996394 defendant Nasshe John yeoman 612558 612558 Nasshe, John, of Grenewyche, yeoman 3
3918030 1996394 1996394 defendant Harve Anthony yeoman 612558 612558 Harve, Anthony, of Grenewyche, yeoman 4
3918037 1996395 1996395 defendant Awntell John   612558 612558 Awntell, John, of Grenewyche, groom of the chamber 2
3918038 1996395 1996395 defendant Kellam John yeoman of the guard 612558 612558 Kellam, John, of Grenewyche, yeoman of the guard 3
3918046 1996396 1996396 defendant Awntell John   612558 612558 Awntell, John, of Grenewyche, groom of the chamber 2
3918047 1996396 1996396 defendant Kellam John yeoman of the guard 612558 612558 Kellam, John, of Grenewyche, yeoman of the guard 3
3918054 1996397 1996397 defendant Bockhyll Arnold yeoman 612558 612558 Bockhyll, Arnold, of Grenewyche, yeoman 1
3918055 1996397 1996397 defendant Tanner Edward yeoman 612558 612558 Tanner, Edward, of Grenewyche, yeoman 2
3918056 1996397 1996397 defendant Edward George yeoman 612558 612558 Edward, George, of Grenewyche, yeoman 3
3918057 1996397 1996397 defendant Traford Edward yeoman 612558 612558 Traford, Edward, of Grenewyche, yeoman 4
3918063 1996398 1996398 defendant Jonys John   612558 612558 Jonys, John, of Grenewyche, sergeant at arms 1
3918094 1996403 1996403 defendant Newman Thomas, junior yeoman 612558 612558 Newman, Thomas, junior, of Grenewyche, yeoman 1
3918095 1996403 1996403 defendant Stok John yeoman 612558 612558 Stok, John, of Grenewyche, yeoman 2
3918096 1996403 1996403 defendant York Christopher yeoman 612558 612558 York, Christopher, of Grenewyche, yeoman 3
3918097 1996403 1996403 defendant Foster Robert yeoman 612558 612558 Foster, Robert, of Grenewyche, yeoman 4
3918112 1996405 1996405 defendant Clotworth Robert yeoman 612558 612558 Clotworth, Robert, of Grenewyche, yeoman 2
3918113 1996405 1996405 defendant Smyth John, senior yeoman 612558 612558 Smyth, John, senior, of Grenewyche, yeoman 3
3918171 1996413 1996413 defendant Plume Robert   612558 612558 Plume, Robert, of Grenewyche, cook 1
3918172 1996413 1996413 defendant Tymewell John yeoman 612558 612558 Tymewell, John, of Grenewyche, yeoman 2
3918173 1996413 1996413 defendant Varney John gent 612558 612558 Varney, John, of Grenewyche, gent 3
3918174 1996413 1996413 defendant Gyttens Thomas yeoman 612558 612558 Gyttens, Thomas, of Grenewyche, yeoman 4
3919667 1996914 1996914 defendant Kyrby John gent 612558 612558 Kyrby, John, of Grenewyche, gent 1
4050016 2042437 2042437 defendant Browne Hugh smith 612558 612558 Browne, Hugh, of Grenewyche, smith 1
4560836 2219347 2219347 plaintiff Offle Thomas   612558 612558 Offle, Thomas, of Grenewyche 0
4643337 2244154 2244154 defendant Selby William   612558 612558 Selby, William, of Grenewyche 0
4741336 2277962 2277962 plaintiff Bocher John   612558 612558 Bocher, John, of Grenewyche 0
5213031 2419549 2419549 defendant Bukke Thomas butcher 612558 612558 Bukke, Thomas, of Grenewyche, butcher 2
5213032 2419549 2419549 defendant Style Richard yeoman 612558 612558 Style, Richard, of Grenewyche, yeoman 3
5317472 2450311 2450311 defendant Colyngburn William   612558 612558 Colyngburn, William, of Grenewyche 0
5435426 2485536 2485536 defendant Cordable Jenyn brewer 612558 612558 Cordable, Jenyn, of Grenewyche, brewer 1

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