names

30 rows where place_id = 599024

✎ 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
3634902 1905716 1905716 defendant Alshoppe Richard yeoman 599024 599024 Alshoppe, Richard, of Knyghtley, yeoman 3
3635791 1905995 1905995 defendant Barne John husbandman 599024 599024 Barne, John, of Knyghtley, husbandman 0
3635792 1905995 1905995 defendant Barnefeld William husbandman 599024 599024 Barnefeld, William, of Knyghtley, husbandman 1
3635793 1905995 1905995 defendant Bayle Christopher husbandman 599024 599024 Bayle, Christopher, of Knyghtley, husbandman 2
3642620 1908134 1908134 defendant Nevele Thomas esq 599024 599024 Nevele, Thomas, of Knyghtley, esq 0
3722832 1933408 1933408 defendant Blount John esq 599024 599024 Blount, John, of Knyghtley, esq 0
3722834 1933408 1933408 defendant Carr John yeoman 599024 599024 Carr, John, of Knyghtley, yeoman 2
3722835 1933408 1933408 defendant Bursley John yeoman 599024 599024 Bursley, John, of Knyghtley, yeoman 3
3722836 1933408 1933408 defendant Parker Roger yeoman 599024 599024 Parker, Roger, of Knyghtley, yeoman 4
3722837 1933408 1933408 defendant Alcok Roger yeoman 599024 599024 Alcok, Roger, of Knyghtley, yeoman 5
3760263 1945213 1945213 defendant Treves John   599024 599024 Treves, John, of Knyghtley, minstrel 0
3776956 1950537 1950537 defendant Blounte John esq 599024 599024 Blounte, John, of Knyghtley, esq 0
3776957 1950537 1950537 defendant Madeley Thomas yeoman 599024 599024 Madeley, Thomas, of Knyghtley, yeoman 1
3776958 1950537 1950537 defendant Heepe John yeoman 599024 599024 Heepe, John, of Knyghtley, yeoman 2
4504801 2202042 2202042 defendant Poyter John   599024 599024 Poyter, John, of Knyghtley 0
4589130 2227979 2227979 plaintiff Lee William de   599024 599024 Lee, William de, of Knyghtley 0
4747740 2279848 2279848 plaintiff Lee William   599024 599024 Lee, William, of Knyghtley, on his own account 0
4747744 2279849 2279849 plaintiff Lee William   599024 599024 Lee, William, of Knyghtley, on his own account 0
4747747 2279850 2279850 plaintiff Lee William   599024 599024 Lee, William, of Knyghtley, on his own account 0
4747750 2279851 2279851 plaintiff Lee William   599024 599024 Lee, William, of Knyghtley 0
4747755 2279852 2279852 plaintiff Lee William   599024 599024 Lee, William, of Knyghtley 0
4790847 2293227 2293227 plaintiff Lee William   599024 599024 Lee, William, of Knyghtley 0
4978555 2350537 2350537 defendant Leche John husbandman 599024 599024 Leche, John, of Knyghtley, husbandman 2
5106916 2388450 2388450 defendant Peesale Richard (legal representative) 599024 599024 Peesale, Richard, of Knyghtley, esq, executors of 0
5134368 2396549 2396549 defendant Peesale Richard (legal representative) 599024 599024 Peesale, Richard, of Knyghtley, esq, executors of 0
5153883 2402291 2402291 defendant Peesale Richard (legal representative) 599024 599024 Peesale, Richard, of Knyghtley, esq, executors of 0
5171136 2407281 2407281 defendant Peesale Richard (legal representative) 599024 599024 Peesale, Richard, of Knyghtley, esq, executors of 0
5221383 2421954 2421954 defendant Peesale Richard (legal representative) 599024 599024 Peesale, Richard, of Knyghtley, esq, executors of 0
5352065 2460752 2460752 defendant Arcall Thomas yeoman 599024 599024 Arcall, Thomas, of Knyghtley, yeoman 2
5572715 2526564 2526564 defendant Alsop Richard yeoman 599024 599024 Alsop, Richard, of Knyghtley, 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);