names

37 rows where place_id = 757117

✎ 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
4443420 2182904 2182904 defendant Skinner John   757117 757117 Skinner, John, of Hertefeld 0
4555401 2217623 2217623 defendant Swan Roger   757117 757117 Swan, Roger, of Hertefeld 3
4567682 2221455 2221455 defendant Sergeant John   757117 757117 Sergeant, John, of Hertefeld 0
4665724 2250753 2250753 plaintiff Hore Walter   757117 757117 Hore, Walter, of Hertefeld 0
4701853 2265983 2265983 defendant Broun John laborer 757117 757117 Broun, John, of Hertefeld, laborer 0
4728006 2274005 2274005 defendant Sadeler Andrew sadler 757117 757117 Sadeler, Andrew, of Hertefeld, sadler 0
4757865 2282838 2282838 defendant Strode Thomas butcher 757117 757117 Strode, Thomas, of Hertefeld, butcher 0
4769108 2286316 2286316 defendant Skynnere John   757117 757117 Skynnere, John, of Hertefeld, servant of John Skynnere 14
4769113 2286316 2286316 defendant Fynsherst Walter tailor 757117 757117 Fynsherst, Walter, of Hertefeld, tailor 19
4769116 2286316 2286316 defendant Say Thomas parkman 757117 757117 Say, Thomas, of Hertefeld, parkman 22
4793644 2294123 2294123 defendant Skynner John Jonnysservant laborer 757117 757117 Skynner, John Jonnysservant, of Hertefeld, laborer 6
4793645 2294123 2294123 defendant Bocher John butcher 757117 757117 Bocher, John, of Hertefeld, butcher 7
4828894 2305078 2305078 defendant Humbeldon Thomas laborer 757117 757117 Humbeldon, Thomas, of Hertefeld, laborer 0
4841346 2308829 2308829 defendant Burgeys William husbandman 757117 757117 Burgeys, William, of Hertefeld, husbandman 0
4848483 2311001 2311001 defendant Burgeys William husbandman 757117 757117 Burgeys, William, of Hertefeld, husbandman 0
4856388 2313374 2313374 defendant Basset John ripyer or fishmonger 757117 757117 Basset, John, of Hertefeld, ripyer or fishmonger 0
4869837 2317537 2317537 defendant Perot Thomas yeoman 757117 757117 Perot, Thomas, of Hertefeld, yeoman 1
4908608 2329245 2329245 defendant Perot Thomas yeoman 757117 757117 Perot, Thomas, of Hertefeld, yeoman 0
5018991 2362447 2362447 defendant Chalener John butcher 757117 757117 Chalener, John, of Hertefeld, butcher 0
5018992 2362447 2362447 defendant at Stone John laborer 757117 757117 at Stone, John, of Hertefeld, laborer 1
5018993 2362447 2362447 defendant at Stone William laborer 757117 757117 at Stone, William, of Hertefeld, laborer 2
5018994 2362447 2362447 defendant Memory Thomas laborer 757117 757117 Memory, Thomas, of Hertefeld, laborer 3
5018995 2362447 2362447 defendant Skynner Richard laborer 757117 757117 Skynner, Richard, of Hertefeld, laborer 4
5018996 2362447 2362447 defendant Chalener Nicholas Johannysservant   757117 757117 Chalener, Nicholas Johannysservant, of Hertefeld, groom 5
5018997 2362447 2362447 defendant Vyne John husbandman 757117 757117 Vyne, John, of Hertefeld, husbandman 6
5129283 2395054 2395054 defendant Broun Robert laborer 757117 757117 Broun, Robert, of Hertefeld, laborer 0
5129284 2395054 2395054 defendant Skynner Adam tailor 757117 757117 Skynner, Adam, of Hertefeld, tailor 1
5144238 2399467 2399467 defendant Skynner Richard yeoman 757117 757117 Skynner, Richard, of Hertefeld, yeoman 0
5148553 2400703 2400703 defendant Broun Robert laborer 757117 757117 Broun, Robert, of Hertefeld, laborer 0
5148554 2400703 2400703 defendant Skynner Adam tailor 757117 757117 Skynner, Adam, of Hertefeld, tailor 1
5165142 2405551 2405551 defendant Skynner Richard yeoman 757117 757117 Skynner, Richard, of Hertefeld, yeoman 0
5178892 2409553 2409553 defendant Skynner Richard yeoman 757117 757117 Skynner, Richard, of Hertefeld, yeoman 0
5178918 2409562 2409562 defendant Skynner Richard yeoman 757117 757117 Skynner, Richard, of Hertefeld, yeoman 0
5184491 2411206 2411206 defendant Englyssh William clerk 757117 757117 Englyssh, William, of Hertefeld, clerk 0
5184493 2411207 2411207 defendant Englyssh William clerk 757117 757117 Englyssh, William, of Hertefeld, clerk 0
5217129 2420749 2420749 defendant Englyssh William clerk 757117 757117 Englyssh, William, of Hertefeld, clerk 0
5226089 2423297 2423297 defendant Barbour John yeoman 757117 757117 Barbour, John, of Hertefeld, yeoman 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);