names

33 rows where place_id = 602968

✎ 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
3652541 1911127 1911127 defendant Hotton William laborer 602968 602968 Hotton, William, of Thirsk, laborer 0
3942252 2004422 2004422 defendant Lolle Richard clerk 602968 602968 Lolle, Richard, of Thirsk, clerk 0
4323439 2138257 2138257 defendant Barker Thomas tanner 602968 602968 Barker, Thomas, of Thirsk, tanner 1
4538091 2212198 2212198 defendant Scot William   602968 602968 Scot, William, of Thirsk 0
4541939 2213368 2213368 defendant Mallom William   602968 602968 Mallom, William, of Thirsk 0
4560298 2219162 2219162 defendant Bell John   602968 602968 Bell, John, of Thirsk 24
4570338 2222296 2222296 plaintiff Worcester John de sadler 602968 602968 Worcester, John de, of Thirsk, sadler 0
4620952 2237535 2237535 defendant Calton Thomas de   602968 602968 Calton, Thomas de, of Thirsk 3
4626265 2239173 2239173 defendant Bell John   602968 602968 Bell, John, of Thirsk 0
4633476 2241323 2241323 plaintiff Watson Richard   602968 602968 Watson, Richard, of Thirsk 0
4694194 2263686 2263686 defendant Lister John dyer 602968 602968 Lister, John, of Thirsk, dyer 2
4705042 2266949 2266949 plaintiff Kepwyk William tanner 602968 602968 Kepwyk, William, of Thirsk, tanner 0
4715260 2270104 2270104 defendant Littester John dyer 602968 602968 Littester, John, of Thirsk, dyer 0
4728723 2274223 2274223 plaintiff Kepwyk William   602968 602968 Kepwyk, William, of Thirsk 0
4769204 2286346 2286346 plaintiff Palyser or Pavyser John   602968 602968 Palyser or Pavyser, John, of Thirsk 0
4773944 2287832 2287832 defendant Knayton John gent 602968 602968 Knayton, John, of Thirsk, gent 0
4844357 2309746 2309746 defendant Grenefeld John gent 602968 602968 Grenefeld, John, of Thirsk, gent 0
4850494 2311614 2311614 defendant Smyth William smith 602968 602968 Smyth, William, of Thirsk, smith 0
4854081 2312685 2312685 defendant Kilburn William dyer 602968 602968 Kilburn, William, of Thirsk, dyer 1
4858261 2313956 2313956 defendant Grenwod William skinner 602968 602968 Grenwod, William, of Thirsk, skinner 1
4993869 2355037 2355037 defendant Byggynges John tailor 602968 602968 Byggynges, John, of Thirsk, tailor 0
4993870 2355037 2355037 defendant Eland William tanner 602968 602968 Eland, William, of thirsk, tanner 1
4996013 2355658 2355658 defendant Palycer William husbandman 602968 602968 Palycer, William, of Thirsk, husbandman 0
5002393 2357610 2357610 defendant Barbour Thomas yeoman 602968 602968 Barbour, Thomas, of Thirsk, yeoman 0
5002395 2357610 2357610 defendant Guberthorn Thomas husbandman 602968 602968 Guberthorn, Thomas, of Thirsk, husbandman 2
5002396 2357610 2357610 defendant Hall John of the laborer 602968 602968 Hall, John of the, of Thirsk, laborer 3
5012501 2360502 2360502 defendant Aclyff John (legal representative) 602968 602968 Aclyff, John, of Thirsk, executrix of 3
5156484 2403052 2403052 defendant Harland Henry shoemaker 602968 602968 Harland, Henry, of Thirsk, shoemaker 1
5166514 2405925 2405925 defendant Plokes John yeoman 602968 602968 Plokes, John, of Thirsk, yeoman 1
5172690 2407741 2407741 defendant Harland Henry shoemaker 602968 602968 Harland, Henry, of Thirsk, shoemaker 1
5192378 2413506 2413506 defendant Harland Henry shoemaker 602968 602968 Harland, Henry, of Thirsk, shoemaker 1
5275674 2437951 2437951 defendant southake Robert tailor 602968 602968 southake, Robert, of Thirsk, tailor 1
5622476 2550954 2550954 defendant del Balk Emma   602968 602968 del Balk, Emma, of Thirsk 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);