names

37 rows where place_id = 599036

✎ 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
3634929 1905725 1905725 defendant Thacker Thomas merchant of the staple 599036 599036 Thacker, Thomas, of Hull, Yorks, merchant of the staple 0
3779864 1951433 1951433 defendant Matheson George merchant 599036 599036 Matheson, George, of Hull, Yorks, merchant 4
3829838 1967223 1967223 plaintiff Dove John merchant 599036 599036 Dove, John, of Hull, Yorks, merchant 0
3854909 1975179 1975179 defendant Madyson George merchant 599036 599036 (Madyson, George, of Hull, Yorks, merchant 1
3875011 1981868 1981868 plaintiff Dove John merchant 599036 599036 Dove, John, of Hull, Yorks, merchant 0
3904431 1991728 1991728 defendant Wardall Robert merchant 599036 599036 Wardall, Robert, of Hull, Yorks, merchant 0
3932850 2001277 2001277 defendant Langton Richard merchant 599036 599036 Langton, Richard, of Hull, Yorks, merchant 0
3949550 2006916 2006916 plaintiff Englishe John merchant 599036 599036 Englishe, John, of Hull, Yorks, merchant 0
4008969 2027972 2027972 defendant Tompson William merchant 599036 599036 Tompson, William, of Hull, Yorks, merchant 1
4008974 2027973 2027973 defendant Tompson William merchant 599036 599036 Tompson, William, of Hull, Yorks, merchant 2
4008978 2027974 2027974 defendant Preston Giles haberdasher 599036 599036 Preston, Giles, of Hull, Yorks, haberdasher 1
4008981 2027975 2027975 defendant Preston Giles haberdasher 599036 599036 Preston, Giles, of Hull, Yorks, haberdasher 1
4010818 2028645 2028645 defendant Hayles John merchant 599036 599036 Hayles, John, of Hull, Yorks, merchant 0
4010819 2028645 2028645 defendant Rawlyng Thomas merchant 599036 599036 Rawlyng, Thomas, of Hull, Yorks, merchant 1
4014653 2029962 2029962 defendant Hayles John merchant 599036 599036 Hayles, John, of Hull, Yorks, merchant 0
4110919 2064157 2064157 defendant Osgarbye William chapman 599036 599036 Osgarbye, William, of Hull, Yorks, chapman 4
4665027 2250540 2250540 defendant Donesby or Dovesby Thomas skinner 599036 599036 Donesby or Dovesby, Thomas, of Hull, Yorks, skinner 2
4693391 2263435 2263435 defendant Merflete Peter chapman 599036 599036 Merflete, Peter, of Hull, Yorks, chapman 3
4693396 2263436 2263436 defendant Merflete Peter chapman 599036 599036 Merflete, Peter, of Hull, Yorks, chapman 3
4706527 2267421 2267421 defendant Hende Walter merchant 599036 599036 Hende, Walter, of Hull, Yorks, merchant 0
4745164 2279091 2279091 defendant Skot Richard gent 599036 599036 Skot, Richard, of Hull, Yorks, gent 1
4760222 2283548 2283548 defendant Nore Adam fuller 599036 599036 Nore, Adam, of Hull, Yorks, fuller 0
4765180 2285091 2285091 defendant del Bryg William merchant 599036 599036 del Bryg, William, of Hull, Yorks, merchant 0
4792004 2293605 2293605 defendant Pound Walter merchant 599036 599036 Pound, Walter, of Hull, Yorks, merchant 1
4797947 2295541 2295541 defendant Molde William shipman 599036 599036 Molde, William, of Hull, Yorks, shipman 0
4902189 2327295 2327295 defendant Thomson Robert mariner 599036 599036 Thomson, Robert, of Hull, Yorks, mariner 1
5103806 2387538 2387538 defendant Clyderowe Hugh, senior merchant 599036 599036 Clyderowe, Hugh, senior, of Hull, Yorks, merchant 2
5118518 2391850 2391850 defendant Custard John chapman 599036 599036 Custard, John, of Hull, Yorks, chapman 0
5253459 2431184 2431184 defendant Overton William gent 599036 599036 Overton, William, of Hull, Yorks, gent 0
5556456 2521862 2521862 defendant Darell Godfrey merchant 599036 599036 Darell, Godfrey, of Hull, Yorks, merchant 1
5566773 2524876 2524876 defendant Monkton William merchant 599036 599036 Monkton, William, of Hull, Yorks, merchant 3
5573471 2526800 2526800 defendant Monkton William merchant 599036 599036 Monkton, William, of Hull, Yorks, merchant 0
5573473 2526801 2526801 defendant Monkton William merchant 599036 599036 Monkton, William, of Hull, Yorks, merchant 0
5575151 2527315 2527315 defendant Gyll John (legal representative) 599036 599036 Gyll, John, of Hull, Yorks, merchant, executrix of 0
5583151 2529804 2529804 defendant Walde William merchant 599036 599036 Walde, William, of Hull, Yorks, merchant 0
5584648 2530269 2530269 defendant Welsby William merchant 599036 599036 Welsby, William, of Hull, Yorks, merchant 0
5616926 2549103 2549103 defendant Preston William de   599036 599036 Preston, William de, of Hull, Yorks 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);