names

31 rows where place_id = 655323

✎ 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
3935807 2002283 2002283 plaintiff Layton Edward gent 655323 655323 Layton, Edward, of Howeden, gent 0
4515748 2205353 2205353 defendant Wreshill Thomas   655323 655323 Wreshill, Thomas, of Howeden 0
4612392 2234946 2234946 defendant Melton William   655323 655323 Melton, William, of Howeden 2
4612395 2234946 2234946 defendant Hygdon John   655323 655323 Hygdon, John, of Howeden, glove maker 5
4710027 2268493 2268493 defendant Frankelan William butcher 655323 655323 Frankelan, William, of Howeden, butcher 3
4715383 2270147 2270147 plaintiff Brunne Thomas   655323 655323 Brunne, Thomas, of Howeden 1
4725299 2273203 2273203 defendant Mitton Margaret single woman 655323 655323 Mitton, Margaret, of Howeden, single woman 0
4752293 2281131 2281131 defendant Clerk William yeoman 655323 655323 Clerk, William, of Howeden, yeoman 3
4827724 2304719 2304719 defendant Flesshewer Robert butcher 655323 655323 Flesshewer, Robert, of Howeden, butcher 0
4832566 2306211 2306211 defendant Creswell William tailor 655323 655323 Creswell, William, of Howeden, tailor 2
4875516 2319296 2319296 defendant Laverok Richard tailor 655323 655323 Laverok, Richard, of Howeden, tailor 0
4875517 2319296 2319296 defendant Laverok William chaplain 655323 655323 together with Laverok, William, of Howeden, chaplain 1
4931393 2336198 2336198 defendant Bubwyth Thomas butcher 655323 655323 Bubwyth, Thomas, of Howeden, butcher 0
4931395 2336198 2336198 defendant Blaunchard John yeoman 655323 655323 Blaunchard, John, of Howeden, yeoman 2
4974727 2349408 2349408 defendant Sutton Simon yeoman 655323 655323 Sutton, Simon, of Howeden, yeoman 0
4978389 2350484 2350484 defendant Barker William barker 655323 655323 Barker, William, of Howeden, barker 0
4994685 2355265 2355265 defendant Rykall William chaplain 655323 655323 Rykall, William, of Howeden, chaplain 0
5008890 2359495 2359495 defendant Frankeleyn Richard butcher 655323 655323 Frankeleyn, Richard, of Howeden, butcher 0
5012798 2360574 2360574 defendant Clayton John saddler 655323 655323 Clayton, John, of Howeden, saddler 0
5081092 2380850 2380850 defendant Kent William chapman or fisher 655323 655323 Kent, William, of Howeden, chapman or fisher 0
5098016 2385849 2385849 defendant Bekyngham Thomas tailor 655323 655323 Bekyngham, Thomas, of Howeden, chapman, or of London, tailor 3
5145746 2399899 2399899 defendant Laweton William gent 655323 655323 Laweton, William, of Howeden, gent 4
5145747 2399899 2399899 defendant Thorp Thomas yeoman 655323 655323 Thorp, Thomas, of Howeden, yeoman 5
5145751 2399899 2399899 defendant Lee Hugh esq 655323 655323 Lee, Hugh, of Howeden, esq 9
5166085 2405822 2405822 defendant Laweton William gent 655323 655323 Laweton, William, of Howeden, gent 3
5166090 2405822 2405822 defendant Thorp Thomas yeoman 655323 655323 Thorp, Thomas, of Howeden, yeoman 8
5323794 2452201 2452201 defendant Barker John gent 655323 655323 Barker, John, of Howeden, gent 0
5438891 2486555 2486555 defendant Brymesley Thomas yeoman 655323 655323 Brymesley, Thomas, of Howeden, yeoman 2
5452774 2490709 2490709 defendant Grymesley Thomas   655323 655323 Grymesley, Thomas, of Howeden 2
5512070 2508635 2508635 defendant Hemmesley Robert chaplain 655323 655323 Hemmesley, Robert, of Howeden, chaplain 0
5626948 2552403 2552403 defendant Blyburgh William butcher 655323 655323 Blyburgh, William, of Howeden, butcher 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);