names

38 rows where place_id = 630515

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3794820 1956250 1956250 defendant Forstall John yeoman 630515 630515 Forstall, John, of Eastry, yeoman 4
3863361 1977942 1977942 plaintiff Huggen John yeoman 630515 630515 Huggen, John, of Eastry, yeoman 0
4496731 2199644 2199644 defendant Gyles John   630515 630515 Gyles, John, of Eastry 4
4498115 2200064 2200064 defendant Molonde John   630515 630515 Molonde, John, of Eastry 0
4691816 2262974 2262974 defendant Garwynton Thomas gent 630515 630515 Garwynton, Thomas, of Eastry, gent 0
4724095 2272831 2272831 defendant Swayn Robert husbandman 630515 630515 Swayn, Robert, of Eastry, husbandman 2
4759354 2283268 2283268 defendant Colyn Robert yeoman 630515 630515 Colyn, Robert, of Eastry, yeoman 1
4761692 2284001 2284001 defendant Man William smith 630515 630515 Man, William, of Eastry, smith 1
4774895 2288142 2288142 defendant Swayn John laborer 630515 630515 Swayn, John, of Eastry, laborer 0
4774896 2288142 2288142 defendant Buklond John husbandman 630515 630515 Buklond, John, of Eastry, husbandman 1
4774897 2288142 2288142 defendant Whitepese John husbandman 630515 630515 Whitepese, John, of Eastry, husbandman 2
4774987 2288172 2288172 defendant Swa_ Robert husbandman 630515 630515 Swa_, Robert, of Eastry, husbandman 0
4819008 2302024 2302024 defendant Ovham William husbandman 630515 630515 Ovham, William, of Eastry, husbandman 0
4832528 2306200 2306200 defendant Frenne John husbandman 630515 630515 Frenne, John, of Eastry, husbandman 0
4843732 2309563 2309563 defendant Durant William   630515 630515 Durant, William, of Eastry, mason 0
4843734 2309563 2309563 defendant Bryke Robert laborer 630515 630515 Bryke, Robert, of Eastry, laborer 2
4874055 2318825 2318825 defendant Thomelyn Richard laborer 630515 630515 Thomelyn, Richard, of Eastry, laborer 2
4916558 2331686 2331686 defendant Stefed William gent 630515 630515 Stefed, William, of Eastry, gent 0
4931960 2336383 2336383 plaintiff Watyer John (legal representative) 630515 630515 Watyer, John, of Eastry, vicar, executors of 0
4997389 2356069 2356069 defendant Tomlyn Thomas butcher 630515 630515 Tomlyn, Thomas, of Eastry, butcher 1
5005250 2358433 2358433 defendant Stesday William gent 630515 630515 Stesday, William, of Eastry, gent 0
5025965 2364489 2364489 defendant Frenne Richard husbandman 630515 630515 Frenne, Richard, of Eastry, husbandman 1
5032260 2366313 2366313 defendant Stefday William gent 630515 630515 Stefday, William, of Eastry, gent 0
5070423 2377647 2377647 defendant Steveday William gent 630515 630515 Steveday, William, of Eastry, gent 0
5179367 2409703 2409703 defendant Ore Richard husbandman 630515 630515 Ore, Richard, of Eastry, husbandman 0
5192050 2413403 2413403 defendant Idley John gent 630515 630515 together with Idley, John, of Eastry, gent 3
5192052 2413404 2413404 defendant Idley John gent 630515 630515 Idley, John, of Eastry, gent 0
5192057 2413405 2413405 defendant Idley John gent 630515 630515 Idley, John, of Eastry, gent 0
5192067 2413407 2413407 defendant Ikley John gent 630515 630515 Ikley, John, of Eastry, gent 0
5201862 2416311 2416311 defendant Ore Richard husbandman 630515 630515 Ore, Richard, of Eastry, husbandman 0
5207469 2417925 2417925 defendant Idley John gent 630515 630515 Idley, John, of Eastry, gent 0
5367788 2465554 2465554 defendant Bynder John husbandman 630515 630515 Bynder, John, of Eastry, husbandman 0
5368015 2465621 2465621 defendant Bynder John   630515 630515 Bynder, John, of Eastry 0
5374847 2467728 2467728 defendant Prentyce Richard husbandman 630515 630515 Prentyce, Richard, of Eastry, husbandman 1
5374848 2467728 2467728 defendant Ocle John husbandman 630515 630515 Ocle, John, of Eastry, husbandman 2
5599083 2534595 2534595 defendant Nethersall Thomas yeoman 630515 630515 Nethersall, Thomas, of Eastry, yeoman 0
5599190 2534626 2534626 defendant Nethersall Thomas yeoman 630515 630515 Nethersall, Thomas, of Eastry, yeoman 0
5636986 2555514 2555514 defendant Molandes Joan widow 630515 630515 Molandes, Joan, of Eastry, widow 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);