names

18 rows where place_id = 681116

✎ 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
4043514 2040140 2040140 defendant Bucklar Arthur yeoman 681116 681116 Bucklar, Arthur, of Great Stepyng, yeoman 1
4494081 2198837 2198837 defendant Lymme John de   681116 681116 Lymme, John de, of Great Stepyng 0
4497293 2199798 2199798 defendant Lynnne John de   681116 681116 Lynnne, John de, of Great Stepyng 0
4575566 2223867 2223867 defendant Hobson Gunby John   681116 681116 Hobson Gunby, John, of Great Stepyng 0
4606694 2233205 2233205 defendant Repynghale John   681116 681116 Repynghale, John, of Great Stepyng 2
4734036 2275829 2275829 plaintiff Ruston Thomas esq 681116 681116 Ruston, Thomas, of Great Stepyng, esq 0
4734037 2275829 2275829 defendant Gunby John de husbandman 681116 681116 Gunby, John de, of Great Stepyng, husbandman 0
4820283 2302411 2302411 defendant Kelsey Robert husbandman 681116 681116 Kelsey, Robert, of Great Stepyng, husbandman 0
4915913 2331472 2331472 defendant Bek Robert husbandman 681116 681116 Bek, Robert, of Great Stepyng, husbandman 0
5129410 2395089 2395089 defendant Thorp Robert yeoman 681116 681116 Thorp, Robert, of Great Stepyng, yeoman 4
5148704 2400745 2400745 defendant Thorp Robert yeoman 681116 681116 Thorp, Robert, of Great Stepyng, yeoman 4
5167912 2406327 2406327 defendant Thorp Robert yeoman 681116 681116 Thorp, Robert, of Great Stepyng, yeoman 4
5183611 2410942 2410942 defendant Thorp Robert yeoman 681116 681116 Thorp, Robert, of Great Stepyng, yeoman 3
5203928 2416900 2416900 defendant Thorp Robert yeoman 681116 681116 Thorp, Robert, of Great Stepyng, yeoman 3
5302315 2445659 2445659 defendant Bresse Thomas (legal representative) 681116 681116 Bresse, Thomas, of Great Stepyng, executors of 3
5302317 2445659 2445659 defendant Taillour Richard husbandman 681116 681116 Taillour, Richard, of Great Stepyng, husbandman 5
5402393 2475757 2475757 defendant Kelsey Thomas husbandman 681116 681116 Kelsey, Thomas, of Great Stepyng, husbandman 4
5431495 2484376 2484376 defendant Kelsey Thomas husbandman 681116 681116 Kelsey, Thomas, of Great Stepyng, husbandman 2

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