names

30 rows where place_id = 588632

✎ 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
3595108 1866100 1866100 defendant Cantlowe Thomas gent 588632 588632 Cantlowe, Thomas, of Alveley, Essex, gent 0
3618977 1873547 1873547 defendant Fuller John husbandman 588632 588632 Fuller, John, of Alveley, Essex, husbandman 1
3622734 1874638 1874638 plaintiff Reed Henry yeoman 588632 588632 Reed, Henry, of Alveley, Essex, yeoman 0
3659341 1913182 1913182 defendant Rawson Beatrice   588632 588632 Rawson, Beatrice, of Alveley, Essex, wdiow 4
3716001 1931289 1931289 defendant Wether Edmund yeoman 588632 588632 Wether, Edmund, of Alveley, Essex, yeoman 0
3731231 1935994 1935994 defendant Wether Edmund yeoman 588632 588632 Wether, Edmund, of Alveley, Essex, yeoman 0
3750648 1942124 1942124 defendant Cooke Richard gent 588632 588632 Cooke, Richard, of Alveley, Essex, gent 0
3781034 1951802 1951802 defendant Body John yeoman 588632 588632 Body, John, of Alveley, Essex, yeoman 1
3782102 1952154 1952154 defendant Jonys Edward gent 588632 588632 Jonys, Edward, of Alveley, Essex, gent 1
3959856 2010539 2010539 defendant Padyam Andrew yeoman 588632 588632 Padyam, Andrew, of Alveley, Essex, yeoman 0
4215267 2100836 2100836 defendant Hatchett John yeoman 588632 588632 Hatchett, John, of Alveley, Essex, yeoman 0
4304347 2131658 2131658 defendant Serle Edward gent 588632 588632 Serle, Edward, of Alveley, Essex, gent 0
4723008 2272506 2272506 defendant Sawere John gent 588632 588632 Sawere, John, of Alveley, Essex, gent 3
5016284 2361654 2361654 defendant Lenthorp William chapman 588632 588632 Lenthorp, William, of Alveley, Essex, chapman 1
5016290 2361655 2361655 defendant Lenthorp William chapman 588632 588632 Lenthorp, William, of Alveley, Essex, chapman 1
5052654 2372387 2372387 defendant Pert William gent 588632 588632 Pert, William, of Alveley, Essex, gent 0
5075757 2379250 2379250 defendant Pert William gent 588632 588632 Pert, William, of Alveley, Essex, gent 2
5095363 2385064 2385064 defendant Smyth Thomas smith 588632 588632 Smyth, Thomas, of Alveley, Essex, smith 3
5095367 2385065 2385065 defendant Smyth Thomas smith 588632 588632 Smyth, Thomas, of Alveley, Essex, smith 2
5145085 2399700 2399700 defendant Wade Robert gent 588632 588632 Wade, Robert, of Alveley, Essex, gent 0
5145148 2399724 2399724 defendant Wade Robert gent 588632 588632 Wade, Robert, of Alveley, Essex, gent 0
5165685 2405705 2405705 defendant Wade Robert gent 588632 588632 Wade, Robert, of Alveley, Essex, gent 0
5179978 2409877 2409877 defendant Wade Robert gent 588632 588632 Wade, Robert, of Alveley, Essex, gent 0
5224482 2422831 2422831 defendant Pert William   588632 588632 Pert, William, of Alveley, Essex, gent, executorof 2
5279182 2439011 2439011 defendant Knot William yeoman 588632 588632 Knot, William, of Alveley, Essex, yeoman 1
5282696 2440003 2440003 defendant Pert William gent 588632 588632 Pert, William, of Alveley, Essex, gent 0
5282700 2440004 2440004 defendant Pert William gent 588632 588632 Pert, William, of Alveley, Essex, gent 0
5367430 2465463 2465463 defendant Pert William gent 588632 588632 Pert, William, of Alveley, Essex, gent 3
5567491 2525061 2525061 defendant Rede Henry yeoman 588632 588632 Rede, Henry, of Alveley, Essex, yeoman 0
5567503 2525066 2525066 defendant Rede Henry yeoman 588632 588632 Rede, Henry, of Alveley, Essex, 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);