names

26 rows where place_id = 599650

✎ 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
3637599 1906570 1906570 defendant Mower William husbandman 599650 599650 Mower, William, of Kneton, husbandman 0
4074290 2051103 2051103 defendant Mawer Edmunds yeoman 599650 599650 Mawer, Edmunds, of Kneton, yeoman 0
4142782 2075648 2075648 defendant Franke Henry esq 599650 599650 Franke, Henry, of Kneton, esq 0
4142783 2075648 2075648 defendant Shawe William   599650 599650 Shawe, William, of Kneton, yeoman, servant of Henry 1
4188593 2091489 2091489 defendant Mawer or More Edmund yeoman 599650 599650 Mawer or More, Edmund, of Kneton, yeoman 0
4262876 2117252 2117252 defendant Francke George gent 599650 599650 Francke, George, of Kneton, gent 0
4387452 2160448 2160448 defendant Spence Richard chapman 599650 599650 Spence, Richard, of Kneton, chapman 0
4387453 2160448 2160448 defendant Hall George chapman 599650 599650 Hall, George, of Kneton, chapman 1
4458189 2187599 2187599 defendant atte Halle John (legal representative) 599650 599650 atte Halle, John, of Kneton, executrix of 0
4563503 2220159 2220159 defendant Stevenson William   599650 599650 Stevenson, William, of Kneton 0
4781832 2290333 2290333 defendant Herde John husbandman 599650 599650 Herde, John, of Kneton, husbandman 1
4782915 2290676 2290676 defendant Hyrede John husbandman 599650 599650 Hyrede, John, of Kneton, husbandman 0
4827508 2304651 2304651 defendant Plouman William husbandman 599650 599650 Plouman, William, of Kneton, husbandman 1
4881741 2321186 2321186 defendant Shepherd John husbandman 599650 599650 Shepherd, John, of Kneton, husbandman 1
4983773 2352075 2352075 defendant Herd John yeoman 599650 599650 Herd, John, of Kneton, yeoman 0
5021255 2363117 2363117 plaintiff Feryman Robert chaplain 599650 599650 Feryman, Robert, of Kneton, chaplain 0
5085303 2382096 2382096 defendant Herde John husbandman 599650 599650 Herde, John, of Kneton, husbandman 3
5092661 2384233 2384233 defendant Lyndby William husbandman 599650 599650 Lyndby, William, of Kneton, husbandman 2
5131257 2395630 2395630 defendant Herde Robert husbandman 599650 599650 Herde, Robert, of Kneton, husbandman 0
5150770 2401369 2401369 defendant Herde Robert husbandman 599650 599650 Herde, Robert, of Kneton, husbandman 0
5376270 2468173 2468173 defendant Person William husbandman 599650 599650 Person, William, of Kneton, husbandman 0
5392457 2472920 2472920 defendant Persons William husbandman 599650 599650 Persons, William, of Kneton, husbandman 4
5442859 2487776 2487776 defendant Orme Thomas husbandman 599650 599650 Orme, Thomas, of Kneton, husbandman 3
5442860 2487776 2487776 defendant Yate Thomas husbandman 599650 599650 Yate, Thomas, of Kneton, husbandman 4
5474820 2497453 2497453 defendant Person William husbandman 599650 599650 Person, William, of Kneton, husbandman 4
5605464 2536589 2536589 defendant Madder William husbandman 599650 599650 Madder, William, of Kneton, husbandman 3

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);