names

34 rows where place_id = 606671

✎ 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
3666106 1915344 1915344 plaintiff Sharpoles Richard clerk 606671 606671 Sharpoles, Richard, of Peldon, clerk 2
3729482 1935468 1935468 defendant Gooke John chaplain 606671 606671 Gooke, John, of Peldon, chaplain 2
3782416 1952244 1952244 defendant Marchant Robert husbandman 606671 606671 Marchant, Robert, of Peldon, husbandman 2
3912091 1994367 1994367 defendant Hewer John husbandman 606671 606671 Hewer, John, of Peldon, husbandman 0
4222101 2103222 2103222 defendant Owtinge John yeoman 606671 606671 Owtinge, John, of Peldon, yeoman 0
4414598 2169472 2169472 plaintiff Edmund Roger   606671 606671 Edmund, Roger, of Peldon 0
4449442 2184769 2184769 plaintiff Goddard John   606671 606671 Goddard, John, of Peldon 0
4493991 2198812 2198812 defendant Grenelef William   606671 606671 Grenelef, William, of Peldon 0
4493992 2198812 2198812 defendant Knott William   606671 606671 Knott, William, of Peldon 1
4493993 2198812 2198812 defendant Shepherd John   606671 606671 Shepherd, John, of Peldon 2
4493994 2198812 2198812 defendant Hammond Thomas   606671 606671 Hammond, Thomas, of Peldon 3
4493996 2198812 2198812 defendant Hayward Thomas   606671 606671 Hayward, Thomas, of Peldon 5
4493997 2198812 2198812 defendant Tibneam John   606671 606671 Tibneam, John, of Peldon 6
4493998 2198812 2198812 defendant Tigneam Walter   606671 606671 Tigneam, Walter, of Peldon 7
4494187 2198874 2198874 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4494473 2198969 2198969 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4494488 2198970 2198970 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4496870 2199689 2199689 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4503679 2201724 2201724 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4504067 2201821 2201821 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4504635 2201994 2201994 defendant Tybenham Walter   606671 606671 Tybenham, Walter, of Peldon 7
4506617 2202551 2202551 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4507298 2202749 2202749 defendant Tynbenham Walter   606671 606671 Tynbenham, Walter, of Peldon 6
4618272 2236724 2236724 defendant Hayward Thomas   606671 606671 Hayward, Thomas, of Peldon 0
4728960 2274295 2274295 defendant Tebbs Edmund   606671 606671 Tebbs, Edmund, of Peldon, parson & clerk 1
4849392 2311287 2311287 defendant Tybenham John yeoman 606671 606671 Tybenham, John, of Peldon, yeoman 2
4874130 2318850 2318850 defendant Page John husbandman 606671 606671 Page, John, of Peldon, husbandman 0
4877556 2319937 2319937 defendant Kervyle John laborer 606671 606671 Kervyle, John, of Peldon, laborer 2
5145392 2399798 2399798 plaintiff Page Thomas   606671 606671 Page, Thomas, of Peldon 4
5165855 2405756 2405756 plaintiff Pate Thomas   606671 606671 Pate, Thomas, of Peldon 4
5336964 2456126 2456126 defendant Page John husbandman 606671 606671 Page, John, of Peldon, husbandman 4
5376885 2468365 2468365 defendant Marsshall Alice widow 606671 606671 Marsshall, Alice, of Peldon, widow 1
5473597 2497068 2497068 defendant Ferrour John husbandman 606671 606671 Ferrour, John, of Peldon, husbandman 0
5620980 2550436 2550436 plaintiff Smyth William   606671 606671 Smyth, William, of Peldon 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);