names

19 rows where place_id = 759650

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4463137 2189171 2189171 defendant Peyntour William   759650 759650 Peyntour, William, of Calyngton 0
4503905 2201782 2201782 defendant Pynnour John   759650 759650 Pynnour, John, of Calyngton 4
4694706 2263841 2263841 plaintiff Bote William   759650 759650 Bote, William, of Calyngton 0
4757243 2282638 2282638 plaintiff Bote William   759650 759650 Bote, William, of Calyngton 0
4757569 2282747 2282747 defendant Bota John husbandman 759650 759650 Bota, John, of Calyngton, husbandman 0
4758776 2283098 2283098 defendant Chyket Richard gent 759650 759650 Chyket, Richard, of Calyngton, gent 0
4779257 2289491 2289491 plaintiff Bote William   759650 759650 Bote, William, of Calyngton 0
4790054 2292963 2292963 defendant Chyket Richard gent 759650 759650 Chyket, Richard, of Calyngton, gent 0
4860325 2314590 2314590 defendant Bote John husbandman 759650 759650 Bote, John, of Calyngton, husbandman 3
4891002 2323925 2323925 defendant Joce Robert   759650 759650 Joce, Robert, of Calyngton 0
4920420 2332903 2332903 defendant Dowete John drover 759650 759650 Dowete, John, of Calyngton, drover 0
4946177 2340788 2340788 plaintiff Joce Robert   759650 759650 Joce, Robert, of Calyngton 0
4964252 2346216 2346216 plaintiff Chyket Richard   759650 759650 Chyket, Richard, of Calyngton 0
4964474 2346282 2346282 defendant Chyket Richard gent 759650 759650 Chyket, Richard, of Calyngton, gent 16
4992802 2354729 2354729 defendant Shyre William, sen husbandman 759650 759650 Shyre, William, sen, of Calyngton, husbandman 0
5052877 2372452 2372452 defendant Loke William husbandman 759650 759650 Loke, William, of Calyngton, husbandman 0
5230565 2424553 2424553 defendant Uston John husbandman 759650 759650 Uston, John, of Calyngton, husbandman 3
5230895 2424644 2424644 defendant Tomma Reginald husbandman 759650 759650 Tomma, Reginald, of Calyngton, husbandman 0
5352025 2460736 2460736 defendant Chyket Edward gent 759650 759650 Chyket, Edward, of Calyngton, gent 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);