names

30 rows where place_id = 777566

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4646895 2245154 2245154 defendant Carleton Thomas   777566 777566 Carleton, Thomas, of Bury St Edmunds, Suffolk 0
4692619 2263208 2263208 defendant Daubeney John husbandman 777566 777566 Daubeney, John, of Bury St Edmunds, Suffolk, husbandman 3
4707401 2267692 2267692 defendant Damat John taverner 777566 777566 Damat, John, of Bury St Edmunds, Suffolk, taverner 0
4711111 2268830 2268830 defendant Damat John taverner 777566 777566 Damat, John, of Bury St Edmunds, Suffolk, taverner 0
4714186 2269764 2269764 defendant Haule Robert merchant 777566 777566 Haule, Robert, of Bury St Edmunds, Suffolk, merchant 0
4719269 2271374 2271374 defendant Grabbe John summoner 777566 777566 Grabbe, John, of Bury St Edmunds, Suffolk, summoner 0
4720121 2271637 2271637 defendant Abreed John taverner 777566 777566 Abreed, John, of Bury St Edmunds, Suffolk, taverner 0
4721760 2272142 2272142 defendant Talmage Thomas yeoman 777566 777566 Talmage, Thomas, of Bury St Edmunds, Suffolk, yeoman 0
4730952 2274879 2274879 defendant Damat John taverner 777566 777566 Damat, John, of Bury St Edmunds, Suffolk, taverner 0
4754589 2281817 2281817 defendant Clerk Geoffrey chapman 777566 777566 Clerk, Geoffrey, of Bury St Edmunds, Suffolk, chapman 1
4773771 2287771 2287771 defendant Bon William butcher 777566 777566 Bon, William, of Bury St Edmunds, Suffolk, butcher 0
4832191 2306099 2306099 defendant Wake John   777566 777566 Wake, John, of Bury St Edmunds, Suffolk 0
4842500 2309189 2309189 defendant Martyn John clerk 777566 777566 Martyn, John, of Bury St Edmunds, Suffolk, clerk 0
4848729 2311069 2311069 defendant Guy John stainer 777566 777566 Guy, John, of Bury St Edmunds, Suffolk, stainer 1
4849905 2311442 2311442 defendant Watton John merchant 777566 777566 Watton, John, of Bury St Edmunds, Suffolk, merchant 0
4999124 2356615 2356615 defendant Barowe James   777566 777566 Barowe, James, of Bury St Edmunds, Suffolk, text writer 0
5003838 2358014 2358014 defendant Cut John butcher 777566 777566 Cut, John, of Bury St Edmunds, Suffolk, butcher 2
5008191 2359280 2359280 defendant Cullyng John gent 777566 777566 Cullyng, John, of Bury St Edmunds, Suffolk, gent 0
5178604 2409456 2409456 defendant Harry John chapman 777566 777566 Harry, John, of Bury St Edmunds, Suffolk, chapman 3
5185394 2411474 2411474 defendant Wormegaye Thomas chapman 777566 777566 Wormegaye, Thomas, of Bury St Edmunds, Suffolk, chapman 4
5188362 2412308 2412308 defendant Antyvale William   777566 777566 Antyvale, William, of Bury St Edmunds, Suffolk, coverlet weaver 0
5192877 2413640 2413640 defendant Gardyner Robert chapman 777566 777566 Gardyner, Robert, of Bury St Edmunds, Suffolk, chapman 0
5192892 2413644 2413644 defendant Butteler Thomas chapman 777566 777566 Butteler, Thomas, of Bury St Edmunds, Suffolk, chapman 2
5194706 2414188 2414188 defendant Fyst Richard husbandman 777566 777566 Fyst, Richard, of Bury St Edmunds, Suffolk, husbandman 0
5201523 2416203 2416203 defendant Harry John chapman 777566 777566 Harry, John, of Bury St Edmunds, Suffolk, chapman 3
5204608 2417093 2417093 defendant Wormyng Thomas chapman 777566 777566 Wormyng, Thomas, of Bury St Edmunds, Suffolk, chapman 4
5204712 2417122 2417122 defendant Wormyng Thomas   777566 777566 Wormyng, Thomas, of Bury St Edmunds, Suffolk, girdle maker 4
5302867 2445845 2445845 defendant Aylmere Henry grocer 777566 777566 Aylmere, Henry, of Bury St Edmunds, Suffolk, grocer 1
5304298 2446290 2446290 defendant Brekealdowne William skinner 777566 777566 Brekealdowne, William, of Bury St Edmunds, Suffolk, skinner 0
5305317 2446595 2446595 defendant Chapell Thomas husbandman 777566 777566 Chapell, Thomas, of Bury St Edmunds, Suffolk, husbandman 2

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