names

45 rows where place_id = 602396

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649931 1910344 1910344 defendant Tayler alias Bocher John butcher 602396 602396 Tayler alias Bocher, John, of Orwell, butcher 0
3955923 2009140 2009140 defendant Sterne William yeoman 602396 602396 Sterne, William, of Orwell, yeoman 0
4343747 2145089 2145089 defendant Skynner Elizabeth widow 602396 602396 Skynner, Elizabeth, of Orwell, widow 0
4582843 2226066 2226066 defendant Jepe William   602396 602396 Jepe, William, of Orwell 1
4589040 2227949 2227949 defendant Jepe William   602396 602396 Jepe, William, of Orwell 1
4620591 2237428 2237428 defendant Laverok John   602396 602396 Laverok, John, of Orwell 0
4758508 2283040 2283040 defendant Lyngwode William husbandman 602396 602396 Lyngwode, William, of Orwell, husbandman 3
4842256 2309112 2309112 plaintiff Leef John   602396 602396 Leef, John, of Orwell 0
4869740 2317506 2317506 plaintiff Leef John   602396 602396 Leef, John, of Orwell 0
4888862 2323304 2323304 defendant Smyth John husbandman 602396 602396 Smyth, John, of Orwell, husbandman 0
4888863 2323304 2323304 defendant Kyllet Henry husbandman 602396 602396 Kyllet, Henry, of Orwell, husbandman 1
4901925 2327209 2327209 defendant Falden John husbandman 602396 602396 Falden, John, of Orwell, husbandman 0
4901926 2327209 2327209 defendant Gerard Thomas husbandman 602396 602396 Gerard, Thomas, of Orwell, husbandman 1
4907090 2328786 2328786 defendant Hedman John mariner 602396 602396 Hedman, John, of Orwell, mariner 8
4907091 2328786 2328786 defendant Richard Simon mariner 602396 602396 Richard, Simon, of Orwell, mariner 9
4922357 2333402 2333402 defendant Baker John   602396 602396 Baker, John, of Orwell, vicar 0
4927996 2335188 2335188 defendant Godfrey Henry husbandman 602396 602396 Godfrey, Henry, of Orwell, husbandman 2
4927998 2335188 2335188 defendant Gerard Thomas husbandman 602396 602396 (Gerard, Thomas, of Orwell, husbandman 4
4927999 2335188 2335188 defendant Baker John clerk 602396 602396 Baker, John, of Orwell, clerk 5
4929656 2335691 2335691 defendant Valantyn John husbandman 602396 602396 Valantyn, John, of Orwell, husbandman 2
4938611 2338461 2338461 defendant Kelotte Henry husbandman 602396 602396 Kelotte, Henry, of Orwell, husbandman 0
4945116 2340453 2340453 defendant Gerard Thomas husbandman 602396 602396 Gerard, Thomas, of Orwell, husbandman 2
4945117 2340453 2340453 defendant Waryn John husbandman 602396 602396 Waryn, John, of Orwell, husbandman 3
4945118 2340453 2340453 defendant Jepe John husbandman 602396 602396 Jepe, John, of Orwell, husbandman 4
4953314 2342954 2342954 defendant Skampeyn Nicholas carpenter 602396 602396 Skampeyn, Nicholas, of Orwell, carpenter 2
4954722 2343366 2343366 defendant Skampen Nicholas carpenter 602396 602396 Skampen, Nicholas, of Orwell, carpenter 1
5009444 2359645 2359645 defendant Baron William husbandman 602396 602396 Baron, William, of Orwell, husbandman 4
5009445 2359645 2359645 defendant Kelot Henry husbandman 602396 602396 Kelot, Henry, of Orwell, husbandman 5
5009446 2359645 2359645 defendant Adam Richard husbandman 602396 602396 Adam, Richard, of Orwell, husbandman 6
5015531 2361430 2361430 defendant Kyng Robert husbandman 602396 602396 Kyng, Robert, of Orwell, husbandman 0
5015532 2361430 2361430 defendant Jepson Thomas husbandman 602396 602396 Jepson, Thomas, of Orwell, husbandman 1
5021581 2363211 2363211 defendant Jepe John husbandman 602396 602396 Jepe, John, of Orwell, husbandman 0
5111277 2389688 2389688 defendant Holme Robert laborer 602396 602396 Holme, Robert, of Orwell, laborer 2
5229568 2424264 2424264 defendant Lyngwod Henry pulter 602396 602396 Lyngwod, Henry, of Orwell, pulter 0
5337754 2456367 2456367 defendant Smyth John (legal representative) 602396 602396 Smyth, John, of Orwell, executors of 1
5337756 2456367 2456367 defendant Garard Henry husbandman 602396 602396 Garard, Henry, of Orwell, husbandman 3
5349310 2459914 2459914 defendant Jeppesson Hugh husbandman 602396 602396 Jeppesson, Hugh, of Orwell, husbandman 0
5401069 2475371 2475371 defendant Polard Lawrence husbandman 602396 602396 Polard, Lawrence, of Orwell, husbandman 0
5407368 2477173 2477173 defendant Pollard Lawrence husbandman 602396 602396 Pollard, Lawrence, of Orwell, husbandman 1
5407369 2477173 2477173 defendant Jepe Edmund husbandman 602396 602396 Jepe, Edmund, of Orwell, husbandman 2
5407370 2477173 2477173 defendant Herte John husbandman 602396 602396 Herte, John, of Orwell, husbandman 3
5407375 2477175 2477175 defendant Waren Edmund husbandman 602396 602396 Waren, Edmund, of Orwell, husbandman 0
5407377 2477175 2477175 defendant Clerk Richard husbandman 602396 602396 Clerk, Richard, of Orwell, husbandman 2
5407378 2477175 2477175 defendant Jepe John husbandman 602396 602396 Jepe, John, of Orwell, husbandman 3
5414096 2479152 2479152 defendant Polard Lawrence husbandman 602396 602396 Polard, Lawrence, of Orwell, husbandman 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);