names

27 rows where place_id = 623040

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3750363 1942033 1942033 defendant Flokman Nicholas carpenter 623040 623040 Flokman, Nicholas, of Edenham, carpenter 0
3932391 2001125 2001125 defendant Bole William husbandman 623040 623040 Bole, William, of Edenham, husbandman 5
4199726 2095451 2095451 defendant Turnbull William miller 623040 623040 Turnbull, William, of Edenham, miller 0
4616395 2236122 2236122 defendant Styvour John   623040 623040 Styvour, John, of Edenham 0
4696271 2264317 2264317 defendant Bromet Robert husbandman 623040 623040 Bromet, Robert, of Edenham, husbandman 0
4730314 2274680 2274680 defendant Mauby John chaplain 623040 623040 Mauby, John, of Edenham, chaplain 2
4733640 2275700 2275700 defendant Styver John husbandman 623040 623040 Styver, John, of Edenham, husbandman 0
4774394 2287974 2287974 defendant Ladde John husbandman 623040 623040 Ladde, John, of Edenham, husbandman 0
4796019 2294903 2294903 defendant Stynor John yeoman 623040 623040 Stynor, John, of Edenham, yeoman 2
4820509 2302485 2302485 defendant Whittop Richard yeoman 623040 623040 Whittop, Richard, of Edenham, yeoman 3
4842038 2309047 2309047 defendant Pavy John yeoman 623040 623040 Pavy, John, of Edenham, yeoman 0
4944749 2340344 2340344 defendant Foderby Thomas yeoman 623040 623040 Foderby, Thomas, of Edenham, yeoman 0
5035962 2367372 2367372 defendant Wellowe Thomas chaplain 623040 623040 Wellowe, Thomas, of Edenham, chaplain 0
5073298 2378503 2378503 defendant Smyth John husbandman 623040 623040 Smyth, John, of Edenham, husbandman 0
5110395 2389442 2389442 defendant Gromet Roger clerk 623040 623040 Gromet, Roger, of Edenham, clerk 3
5110396 2389442 2389442 defendant Depyng William husbandman 623040 623040 Depyng, William, of Edenham, husbandman 4
5131268 2395634 2395634 defendant Loryng Robert husbandman 623040 623040 Loryng, Robert, of Edenham, husbandman 0
5205322 2417310 2417310 defendant Ground Roger clerk 623040 623040 Ground, Roger, of Edenham, clerk 2
5205323 2417310 2417310 defendant Depyng William husbandman 623040 623040 Depyng, William, of Edenham, husbandman 3
5247464 2429415 2429415 defendant Richard Hugh husbandman 623040 623040 Richard, Hugh, of Edenham, husbandman 0
5247465 2429415 2429415 defendant Byngham Thomas husbandman 623040 623040 Byngham, Thomas, of Edenham, husbandman 1
5247470 2429416 2429416 defendant Richard Hugh husbandman 623040 623040 Richard, Hugh, of Edenham, husbandman 0
5247471 2429416 2429416 defendant Byngham Thomas husbandman 623040 623040 Byngham, Thomas, of Edenham, husbandman 1
5266398 2435239 2435239 defendant Chapman John husbandman 623040 623040 Chapman, John, of Edenham, husbandman 1
5316838 2450122 2450122 defendant Lathes William thatcher 623040 623040 Lathes, William, of Edenham, thatcher 2
5339942 2457062 2457062 defendant Parysshe William smith 623040 623040 Parysshe, William, of Edenham, smith 0
5370234 2466277 2466277 defendant Chapman John yeoman 623040 623040 Chapman, John, of Edenham, yeoman 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);