names

20 rows where place_id = 618548

✎ 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
3725240 1934183 1934183 plaintiff Smyth John   618548 618548 Smyth, John, of Chevenyng, Kent 0
3831639 1967792 1967792 defendant Bathe Thomas husbandman 618548 618548 Bathe, Thomas, of Chevenyng, Kent, husbandman 0
3936032 2002370 2002370 defendant Lennard John esq 618548 618548 Lennard, John, of Chevenyng, Kent, esq 0
3936083 2002389 2002389 defendant Webbe John husbandman 618548 618548 Webbe, John, of Chevenyng, Kent, husbandman 6
3940202 2003741 2003741 plaintiff Smythe Henry   618548 618548 Smythe, Henry, of Chevenyng, Kent 0
4726625 2273599 2273599 defendant Harneys John gent 618548 618548 Harneys, John, of Chevenyng, Kent, gent 1
4929934 2335773 2335773 defendant atte Tye Thomas husbandman 618548 618548 atte Tye, Thomas, of Chevenyng, Kent, husbandman 0
5048468 2371180 2371180 defendant Narneys John gent 618548 618548 Narneys, John, of Chevenyng, Kent, gent 2
5052739 2372415 2372415 defendant Wodeward Simon yeoman 618548 618548 Wodeward, Simon, of Chevenyng, Kent, yeoman 0
5052762 2372421 2372421 defendant Wodeward Simon yeoman 618548 618548 Wodeward, Simon, of Chevenyng, Kent, yeoman 0
5121104 2392603 2392603 defendant Chelscombe Thomas gent 618548 618548 Chelscombe, Thomas, of Chevenyng, Kent, gent 0
5121106 2392604 2392604 defendant Chelscombe Thomas gent 618548 618548 Chelscombe, Thomas, of Chevenyng, Kent, gent 0
5143631 2399272 2399272 defendant Skele John butcher 618548 618548 Skele, John, of Chevenyng, Kent, butcher 1
5159161 2403796 2403796 defendant Harneys John gent 618548 618548 Harneys, John, of Chevenyng, Kent, gent 1
5164774 2405430 2405430 defendant Skele John butcher 618548 618548 Skele, John, of Chevenyng, Kent, butcher 1
5164780 2405431 2405431 defendant Skele John butcher 618548 618548 Skele, John, of Chevenyng, Kent, butcher 1
5174400 2408214 2408214 defendant Harneys John gent 618548 618548 Harneys, John, of Chevenyng, Kent, gent 1
5195016 2414292 2414292 defendant Harneys John gent 618548 618548 Harneys, John, of Chevenyng, Kent, gent 1
5195023 2414294 2414294 defendant Hervys John gent 618548 618548 Hervys, John, of Chevenyng, Kent, gent 0
5308147 2447463 2447463 defendant Wodeward John yeoman 618548 618548 Wodeward, John, of Chevenyng, Kent, yeoman 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);