names

26 rows where place_id = 661553

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3961199 2011011 2011011 defendant Drake Miles husbandman 661553 661553 Drake, Miles, of Belton, Suff, husbandman 1
4111964 2064528 2064528 defendant Ludman William gent 661553 661553 Ludman, William, of Belton, Suff, gent 0
4111966 2064529 2064529 defendant Ludman William gent 661553 661553 Ludman, William, of Belton, Suff, gent 0
4156912 2080495 2080495 defendant Ludman William gent 661553 661553 Ludman, William, of Belton, Suff, gent 1
4199451 2095357 2095357 defendant Ludman William gent 661553 661553 Ludman, William, of Belton, Suff, gent 2
4290778 2126760 2126760 defendant Beamond George clerk 661553 661553 Beamond, George, of Belton, Suff, clerk 0
4851231 2311833 2311833 defendant Neve Nicholas   661553 661553 Neve, Nicholas, of Belton, Suff, franklin 1
4879230 2320442 2320442 defendant Neve Nicholas   661553 661553 Neve, Nicholas, of Belton, Suff, franklin 0
5083434 2381542 2381542 defendant Lacebon Thomas husbandman 661553 661553 Lacebon, Thomas, of Belton, Suff, husbandman 1
5083451 2381547 2381547 defendant Toralde Thomas husbandman 661553 661553 Toralde, Thomas, of Belton, Suff, husbandman 2
5134878 2396704 2396704 defendant Freberne Robert husbandman 661553 661553 Freberne, Robert, of Belton, Suff, husbandman 1
5154921 2402597 2402597 defendant Feberne Robert husbandman 661553 661553 Feberne, Robert, of Belton, Suff, husbandman 1
5154924 2402598 2402598 defendant Freberne Robert husbandman 661553 661553 Freberne, Robert, of Belton, Suff, husbandman 1
5171764 2407463 2407463 defendant Freborne Robert husbandman 661553 661553 Freborne, Robert, of Belton, Suff, husbandman 1
5223205 2422490 2422490 defendant Fylbrygge John gent 661553 661553 Fylbrygge, John, of Belton, Suff, gent 2
5270159 2436375 2436375 defendant Stanton Nicholas clerk 661553 661553 Stanton, Nicholas, of Belton, Suff, clerk 4
5388383 2471726 2471726 defendant Ippeswell Robert clerk 661553 661553 (Ippeswell, Robert, of Belton, Suff, clerk 1
5429467 2483744 2483744 defendant Ippeswell Robert clerk 661553 661553 (Ippeswell, Robert, of Belton, Suff, clerk 1
5429472 2483745 2483745 defendant Ippeswell Robert clerk 661553 661553 (Ippeswell, Robert, of Belton, Suff, clerk 1
5442144 2487567 2487567 defendant Gunton John husbandman 661553 661553 Gunton, John, of Belton, Suff, husbandman 1
5446072 2488711 2488711 defendant Bryg William husbandman 661553 661553 Bryg, William, of Belton, Suff, husbandman 0
5446476 2488833 2488833 defendant Ippeswell Robert clerk 661553 661553 (Ippeswell, Robert, of Belton, Suff, clerk 1
5454869 2491376 2491376 defendant Gunton William husbandman 661553 661553 Gunton, William, of Belton, Suff, husbandman 0
5458765 2492514 2492514 defendant Bryg William husbandman 661553 661553 Bryg, William, of Belton, Suff, husbandman 0
5481774 2499482 2499482 defendant Brig William husbandman 661553 661553 Brig, William, of Belton, Suff, husbandman 1
5569919 2525777 2525777 defendant Gounton John husbandman 661553 661553 Gounton, John, of Belton, Suff, husbandman 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);