names

22 rows where place_id = 635463

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3825486 1965820 1965820 defendant Were Nicholas butcher 635463 635463 Were, Nicholas, of Holcombe Rogus, butcher 0
3849496 1973443 1973443 defendant Rewe James laborer 635463 635463 Rewe, James, of Holcombe Rogus, laborer 0
4260050 2116328 2116328 defendant Still John, junior foster or forester 635463 635463 Still, John, junior, of Holcombe Rogus, foster or forester 1
5007790 2359173 2359173 defendant Lemyngton John husbandman 635463 635463 Lemyngton, John, of Holcombe Rogus, husbandman 2
5007791 2359173 2359173 defendant Tomas Robert husbandman 635463 635463 Tomas, Robert, of Holcombe Rogus, husbandman 3
5066526 2376516 2376516 defendant Tomas Robert husbandman 635463 635463 Tomas, Robert, of Holcombe Rogus, husbandman 0
5066527 2376516 2376516 defendant Rounsy John husbandman 635463 635463 Rounsy, John, of Holcombe Rogus, husbandman 1
5066528 2376516 2376516 defendant Leche Robert husbandman 635463 635463 Leche, Robert, of Holcombe Rogus, husbandman 2
5066529 2376516 2376516 defendant Lome William husbandman 635463 635463 Lome, William, of Holcombe Rogus, husbandman 3
5066530 2376516 2376516 defendant Thomas Nicholas husbandman 635463 635463 Thomas, Nicholas, of Holcombe Rogus, husbandman 4
5066531 2376516 2376516 defendant Smert Richard husbandman 635463 635463 Smert, Richard, of Holcombe Rogus, husbandman 5
5066532 2376516 2376516 defendant Merwode Geoffrey husbandman 635463 635463 Merwode, Geoffrey, of Holcombe Rogus, husbandman 6
5066533 2376516 2376516 defendant Wynterbourne John husbandman 635463 635463 Wynterbourne, John, of Holcombe Rogus, husbandman 7
5066534 2376516 2376516 defendant Cokke Thomas husbandman 635463 635463 Cokke, Thomas, of Holcombe Rogus, husbandman 8
5066535 2376516 2376516 defendant Smert Robert husbandman 635463 635463 Smert, Robert, of Holcombe Rogus, husbandman 9
5066536 2376516 2376516 defendant Bole Nicholas husbandman 635463 635463 Bole, Nicholas, of Holcombe Rogus, husbandman 10
5066537 2376516 2376516 defendant Fysshe John hooper 635463 635463 Fysshe, John, of Holcombe Rogus, hooper 11
5164182 2405264 2405264 defendant Bluet John esq 635463 635463 Bluet, John, of Holcombe Rogus, esq 0
5177519 2409121 2409121 defendant Bluet John esq 635463 635463 Bluet, John, of Holcombe Rogus, esq 0
5177544 2409126 2409126 defendant Bluet John esq 635463 635463 Bluet, John, of Holcombe Rogus, esq 0
5200653 2415949 2415949 defendant Bluet John esq 635463 635463 Bluet, John, of Holcombe Rogus, esq 0
5211567 2419121 2419121 defendant Bluet John esq 635463 635463 (Bluet, John, of Holcombe Rogus, esq 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);