names

25 rows where place_id = 761472

✎ 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
4479214 2194154 2194154 defendant Bostane John   761472 761472 Bostane, John, of Routh 0
4556731 2218040 2218040 plaintiff Ingram Robert   761472 761472 Ingram, Robert, of Routh 0
4659696 2248884 2248884 defendant Tannour Edmund yeoman 761472 761472 Tannour, Edmund, of Routh, yeoman 1
4702783 2266269 2266269 defendant Bilton John husbandman 761472 761472 Bilton, John, of Routh, husbandman 1
4717361 2270764 2270764 defendant Hede Petrus clerk 761472 761472 Hede, Petrus, of Routh, clerk 0
4875262 2319217 2319217 plaintiff Routh John (legal representative) 761472 761472 Routh, John, of Routh, knight, executors of 0
4885911 2322464 2322464 defendant atte Halle John tailor 761472 761472 atte Halle, John, of Routh, tailor 0
4927292 2334970 2334970 defendant Roos Ivell husbandman 761472 761472 Roos, Ivell, of Routh, husbandman 13
4927293 2334970 2334970 defendant Glover Thomas husbandman 761472 761472 Glover, Thomas, of Routh, husbandman 14
4927298 2334970 2334970 defendant Goodson John glover 761472 761472 Goodson, John, of Routh, glover 19
4927301 2334971 2334971 defendant Thomson William husbandman 761472 761472 Thomson, William, of Routh, husbandman 1
4927314 2334973 2334973 plaintiff Routh John esq 761472 761472 Routh, John, of Routh, esq 0
4935348 2337452 2337452 defendant Routh John esq 761472 761472 Routh, John, of Routh, esq 0
4943892 2340053 2340053 defendant Routh John esq 761472 761472 Routh, John, of Routh, esq 0
4952569 2342727 2342727 plaintiff Routh John esq 761472 761472 Routh, John, of Routh, esq 0
5032104 2366261 2366261 defendant Lerybowe Thomas clerk 761472 761472 Lerybowe, Thomas, of Routh, clerk 3
5048685 2371245 2371245 plaintiff Routh John (legal representative) 761472 761472 Routh, John, of Routh, esq, executors of 0
5060875 2374826 2374826 defendant Lerybowe Thomas clerk 761472 761472 Lerybowe, Thomas, of Routh, clerk 0
5118674 2391891 2391891 defendant Thomson Robert yeoman 761472 761472 Thomson, Robert, of Routh, yeoman 0
5135448 2396880 2396880 defendant (illegible) John husbandman 761472 761472 --, John, of Routh, husbandman 1
5135449 2396880 2396880 defendant Routh Martin yeoman 761472 761472 Routh, Martin, of Routh, yeoman 2
5155673 2402818 2402818 defendant Selby John husbandman 761472 761472 Selby, John, of Routh, husbandman 1
5155674 2402818 2402818 defendant Routh Martin yeoman 761472 761472 Routh, Martin, of Routh, yeoman 2
5195277 2414366 2414366 defendant Halle John husbandman 761472 761472 Halle, John, of Routh, husbandman 0
5626657 2552311 2552311 defendant Roos John gent 761472 761472 Roos, John, of Routh, 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);