names

36 rows where place_id = 587389

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591270 1864895 1864895 defendant Cade Thomas gent 587389 587389 Cade, Thomas, of Effyngham, gent 0
3613164 1871771 1871771 defendant Crocher Richard husbandman 587389 587389 Crocher, Richard, of Effyngham, husbandman 0
3613167 1871772 1871772 defendant Croucher Richard husbandman 587389 587389 Croucher, Richard, of Effyngham, husbandman 0
3766191 1947079 1947079 defendant Coke William husbandman 587389 587389 Coke, William, of Effyngham, husbandman 0
3766193 1947080 1947080 defendant Deacon Thomas husbandman 587389 587389 Deacon, Thomas, of Effyngham, husbandman 0
3797290 1957039 1957039 defendant Lee William husbandman 587389 587389 Lee, William, of Effyngham, husbandman 0
3857469 1975972 1975972 defendant Atlee Thomas laborer 587389 587389 Atlee, Thomas, of Effyngham, laborer 0
4004127 2026248 2026248 defendant Weston Richard gent 587389 587389 Weston, Richard, of Effyngham, gent 0
4282346 2123724 2123724 defendant Kytchebell Robert yeoman 587389 587389 Kytchebell, Robert, of Effyngham, yeoman 0
4284751 2124593 2124593 defendant Lee Richard yeoman 587389 587389 Lee, Richard, of Effyngham, yeoman 0
4460439 2188328 2188328 defendant Northwod William   587389 587389 Northwod, William, of Effyngham 0
4465134 2189754 2189754 defendant Northwode William   587389 587389 Northwode, William, of Effyngham 0
4831412 2305857 2305857 defendant Cheyne John husbandman 587389 587389 Cheyne, John, of Effyngham, husbandman 0
4831413 2305857 2305857 defendant Croucher John husbandman 587389 587389 Croucher, John, of Effyngham, husbandman 1
4858299 2313969 2313969 defendant Croucher John husbandman 587389 587389 Croucher, John, of Effyngham, husbandman 0
4858300 2313969 2313969 defendant Cheyne John husbandman 587389 587389 Cheyne, John, of Effyngham, husbandman 1
4858303 2313970 2313970 defendant Ottewey Thomas husbandman 587389 587389 Ottewey, Thomas, of Effyngham, husbandman 1
4872814 2318447 2318447 defendant Cheyne John husbandman 587389 587389 Cheyne, John, of Effyngham, husbandman 0
4876458 2319600 2319600 plaintiff Ottewey Thomas butcher 587389 587389 Ottewey, Thomas, of Effyngham, butcher 1
4922226 2333367 2333367 defendant Filgrave Thomas laborer 587389 587389 Filgrave, Thomas, of Effyngham, laborer 0
4922227 2333367 2333367 defendant Filbrave John laborer 587389 587389 Filbrave, John, of Effyngham, laborer 1
4922234 2333369 2333369 plaintiff Leukyn William   587389 587389 Leukyn, William, of Effyngham, vicar 0
4922235 2333369 2333369 defendant Leukyn William   587389 587389 Leukyn, William, of Effyngham, vicar 0
4983424 2351951 2351951 defendant Coke John husbandman 587389 587389 Coke, John, of Effyngham, husbandman 0
4991350 2354295 2354295 defendant Waleys John husbandman 587389 587389 Waleys, John, of Effyngham, husbandman 0
5040268 2368686 2368686 defendant Roger Richard laborer 587389 587389 Roger, Richard, of Effyngham, laborer 4
5059275 2374339 2374339 defendant atte Lye john   587389 587389 atte Lye, john, of Effyngham, yeoman, as mainpernors 2
5157146 2403228 2403228 defendant atte Lee John   587389 587389 atte Lee, John, of Effyngham 4
5180111 2409925 2409925 defendant North Richard husbandman 587389 587389 North, Richard, of Effyngham, husbandman 0
5180112 2409925 2409925 defendant Roger Henry husbandman 587389 587389 Roger, Henry, of Effyngham, husbandman 1
5202244 2416420 2416420 defendant Northe Richard husbandman 587389 587389 Northe, Richard, of Effyngham, husbandman 0
5202245 2416420 2416420 defendant Roger Henry husbandman 587389 587389 Roger, Henry, of Effyngham, husbandman 1
5252384 2430859 2430859 defendant Doun Lawrence   587389 587389 Doun, Lawrence, of Effyngham 0
5279522 2439088 2439088 defendant Dowene Lawrence gent 587389 587389 Dowene, Lawrence, of Effyngham, gent 0
5492613 2502704 2502704 defendant Stephyn Thomas husbandman 587389 587389 Stephyn, Thomas, of Effyngham, husbandman 0
5492616 2502704 2502704 defendant Crowecher Richard husbandman 587389 587389 Crowecher, Richard, of Effyngham, husbandman 3

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);