names

26 rows where place_id = 755643

✎ 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
4430046 2174183 2174183 defendant Jeckes Robert   755643 755643 Jeckes, Robert, of Stodeye 1
4434154 2175443 2175443 defendant Edes John   755643 755643 Edes, John, of Stodeye 0
4518776 2206246 2206246 defendant Barkere John   755643 755643 Barkere, John, of Stodeye 2
4700599 2265596 2265596 defendant Coldyk William butcher 755643 755643 Coldyk, William, of Stodeye, butcher 0
4700600 2265596 2265596 defendant Coldyk Robert laborer 755643 755643 Coldyk, Robert, of Stodeye, laborer 1
4804972 2297761 2297761 plaintiff Braunche John esq 755643 755643 Braunche, John, of Stodeye, esq 0
4859868 2314457 2314457 defendant Lampet Ralph esq 755643 755643 (Lampet, Ralph, of Stodeye, esq 1
4953844 2343112 2343112 defendant Lamson Robert husbandman 755643 755643 Lamson, Robert, of Stodeye, husbandman 0
5056022 2373373 2373373 plaintiff Butte John   755643 755643 Butte, John, of Stodeye 0
5097293 2385640 2385640 defendant But John yeoman 755643 755643 But, John, of Stodeye, yeoman 1
5097297 2385641 2385641 defendant But John yeoman 755643 755643 But, John, of Stodeye, yeoman 1
5097298 2385641 2385641 defendant Pelles John mercer 755643 755643 Pelles, John, of Stodeye, mercer 2
5129224 2395036 2395036 plaintiff Butte John   755643 755643 Butte, John, of Stodeye 1
5129225 2395036 2395036 plaintiff Seman John   755643 755643 Seman, John, of Stodeye 2
5129226 2395036 2395036 plaintiff Pell John   755643 755643 Pell, John, of Stodeye 3
5129227 2395036 2395036 plaintiff Mony John   755643 755643 Mony, John, of Stodeye 4
5148470 2400681 2400681 plaintiff Butte John   755643 755643 Butte, John, of Stodeye 1
5148471 2400681 2400681 plaintiff Seman John   755643 755643 Seman, John, of Stodeye 2
5148472 2400681 2400681 plaintiff Pell John   755643 755643 Pell, John, of Stodeye 3
5148473 2400681 2400681 plaintiff Mony John   755643 755643 Mony, John, of Stodeye 4
5227275 2423607 2423607 defendant But John yeoman 755643 755643 But, John, of Stodeye, yeoman 1
5227276 2423607 2423607 defendant Pelle John mercer 755643 755643 Pelle, John, of Stodeye, mercer 2
5255878 2431959 2431959 plaintiff Butte John   755643 755643 Butte, John, of Stodeye 1
5255881 2431959 2431959 plaintiff Mony John   755643 755643 Mony, John, of Stodeye 4
5255882 2431959 2431959 defendant Lampet Ralph esq 755643 755643 Lampet, Ralph, of Stodeye, esq 0
5328667 2453653 2453653 defendant Mony Robert butcher 755643 755643 Mony, Robert, of Stodeye, butcher 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);