names

47 rows where place_id = 589024

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596304 1866473 1866473 defendant Kyng Richard draper 589024 589024 Kyng, Richard, of Agmondesham, Bucks, draper 1
3617220 1873010 1873010 defendant Tillesworth Richard chapman 589024 589024 Tillesworth, Richard, of Agmondesham, Bucks, chapman 2
3668110 1915970 1915970 defendant Salcok John tailor 589024 589024 Salcok, John, of Agmondesham, Bucks, tailor 0
3668112 1915971 1915971 defendant Salcok John tailor 589024 589024 Salcok, John, of Agmondesham, Bucks, tailor 0
3681461 1920290 1920290 defendant Halfacre Thomas capper 589024 589024 Halfacre, Thomas, of Agmondesham, Bucks, capper 0
3701156 1926609 1926609 defendant Stevyns Richard mercer 589024 589024 Stevyns, Richard, of Agmondesham, Bucks, mercer 4
3713745 1930597 1930597 defendant Mytun Halfacar Thomas capper 589024 589024 Mytun Halfacar, Thomas, of Agmondesham, Bucks, capper 0
4110161 2063897 2063897 defendant Bennett Walter yeoman 589024 589024 Bennett, Walter, of Agmondesham, Bucks, yeoman 0
4246831 2111916 2111916 defendant Jerman John yeoman 589024 589024 Jerman, John, of Agmondesham, Bucks, yeoman 0
4271468 2120036 2120036 defendant Jermen John yeoman 589024 589024 Jermen, John, of Agmondesham, Bucks, yeoman 0
4278698 2122483 2122483 defendant Ellice or Ellis George tailor 589024 589024 Ellice or Ellis, George, of Agmondesham, Bucks, tailor 0
4356377 2149456 2149456 defendant Lernede Robert yeoman 589024 589024 Lernede, Robert, of Agmondesham , Bucks, yeoman 1
4370588 2154531 2154531 defendant German Henry yeoman 589024 589024 German, Henry, of Agmondesham, Bucks, yeoman 0
4372481 2155225 2155225 defendant Challenor Robert   589024 589024 Challenor, Robert, of Agmondesham, Bucks, Professor of Theology 1
4380227 2158032 2158032 defendant Saunders Richard gent 589024 589024 Saunders, Richard, of Agmondesham, Bucks ,gent 3
4826653 2304371 2304371 defendant Grover Richard dyer 589024 589024 Grover, Richard, of Agmondesham, Bucks, dyer 0
4828672 2305010 2305010 defendant Bryand John chapman 589024 589024 Bryand, John, of Agmondesham, Bucks, chapman 4
4828678 2305011 2305011 defendant Bryan John chapman 589024 589024 Bryan, John, of Agmondesham, Bucks, chapman 4
4897156 2325768 2325768 defendant Grover Robert dyer 589024 589024 Grover, Robert, of Agmondesham, Bucks, dyer 2
4903283 2327635 2327635 defendant Grover Robert dyer 589024 589024 Grover, Robert, of Agmondesham, Bucks, dyer 2
4989505 2353796 2353796 defendant Shelyer William hosier 589024 589024 Shelyer, William, of Agmondesham, Bucks, hosier 0
5026700 2364679 2364679 defendant Alwey William laborer 589024 589024 Alwey, William, of Agmondesham, Bucks, laborer 0
5075881 2379279 2379279 defendant Clerk alias Dyer John yeoman 589024 589024 Clerk alias Dyer, John, of Agmondesham, Bucks, yeoman 0
5134121 2396476 2396476 defendant Gullifra Simon   589024 589024 Gullifra, Simon, of Agmondesham, Bucks, d-- 0
5149577 2401007 2401007 plaintiff Edmunde alias Edmond Robert   589024 589024 Edmunde alias Edmond, Robert, of Agmondesham, Bucks 0
5168451 2406490 2406490 plaintiff Edmunde Robert   589024 589024 Edmunde, Robert, of Agmondesham, Bucks 0
5184445 2411188 2411188 plaintiff Edmunde Robert   589024 589024 Edmunde, Robert, of Agmondesham, Bucks 0
5234115 2425570 2425570 defendant Barett William dyer 589024 589024 Barett, William, of Agmondesham, Bucks, dyer 1
5241017 2427573 2427573 defendant Baret William dyer 589024 589024 Baret, William, of Agmondesham, Bucks, dyer 4
5245448 2428823 2428823 defendant Blake Richard   589024 589024 Blake, Richard, of Agmondesham, Bucks, holy water clerk 0
5298806 2444628 2444628 defendant Dyer John yeoman 589024 589024 Dyer, John, of Agmondesham, Bucks, yeoman 0
5298813 2444630 2444630 defendant Dyer John yeoman 589024 589024 Dyer, John, of Agmondesham, Bucks, yeoman 0
5318532 2450640 2450640 defendant Cheyny Thomas gent 589024 589024 Cheyny, Thomas, of Agmondesham, Bucks, gent 1
5321112 2451412 2451412 defendant Golofre Simon dyer 589024 589024 Golofre, Simon, of Agmondesham, Bucks, dyer 0
5321115 2451413 2451413 defendant Golofer Simon dyer 589024 589024 Golofer, Simon, of Agmondesham, Bucks, dyer 0
5328070 2453464 2453464 defendant Golover Simon dyer 589024 589024 Golover, Simon, of Agmondesham, Bucks, dyer 3
5333119 2454975 2454975 defendant Holme Thomas dyer 589024 589024 Holme, Thomas, of Agmondesham, Bucks, dyer 0
5341733 2457607 2457607 defendant Aprice Edmund capper 589024 589024 Aprice, Edmund, of Agmondesham, Bucks, capper 0
5363048 2464092 2464092 defendant Brutnell Drew esq 589024 589024 Brutnell, Drew, of Agmondesham, Bucks, esq 0
5391216 2472566 2472566 defendant Saunders William dyer 589024 589024 Saunders, William, of Agmondesham, Bucks, dyer 3
5417323 2480100 2480100 plaintiff Palmer William chaplain 589024 589024 Palmer, William, of Agmondesham, Bucks, chaplain 0
5422958 2481820 2481820 defendant Clerk Thomas yeoman 589024 589024 Clerk, Thomas, of Agmondesham, Bucks, yeoman 1
5422981 2481824 2481824 defendant Clerk Thomas yeoman 589024 589024 Clerk, Thomas, of Agmondesham, Bucks, yeoman 2
5441394 2487345 2487345 defendant Saundres William yeoman 589024 589024 Saundres, William, of Agmondesham, Bucks, yeoman 2
5456895 2491967 2491967 defendant Saundres William yeoman 589024 589024 Saundres, William, of Agmondesham, Bucks, yeoman 2
5489156 2501640 2501640 defendant Scryvener Robert smith 589024 589024 Scryvener, Robert, of Agmondesham, Bucks, smith 1
5505978 2506791 2506791 defendant Darsy William chaplain 589024 589024 Darsy, William, of Agmondesham, Bucks, chaplain 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);