names

39 rows where place_id = 586350

✎ 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
3588505 1864050 1864050 defendant Bermyngeham Fulk clerk 586350 586350 Bermyngeham, Fulk, of Bermyngeham, clerk 0
4455302 2186666 2186666 plaintiff Michel Richard   586350 586350 Michel, Richard, of Bermyngeham 0
4457663 2187406 2187406 plaintiff Phelippes Jhn   586350 586350 Phelippes, Jhn, of Bermyngeham 0
4460691 2188403 2188403 plaintiff Slouwe William atte   586350 586350 Slouwe, William atte, of Bermyngeham 0
4479738 2194324 2194324 defendant Slough William   586350 586350 (Slough, William, of Bermyngeham 1
4490631 2197767 2197767 plaintiff Warde William chaplain 586350 586350 Warde, William, of Bermyngeham, chaplain 0
4499898 2200604 2200604 plaintiff Hikokessone William butcher 586350 586350 Hikokessone, William, of Bermyngeham, butcher 0
4553749 2217094 2217094 plaintiff Glasyere Thomas   586350 586350 Glasyere, Thomas, of Bermyngeham 0
4605992 2232990 2232990 plaintiff atte Slough William (legal representative) 586350 586350 atte Slough, William, of Bermyngeham, executors of 0
4605994 2232990 2232990 plaintiff atte Slough Isabel   586350 586350 atte Slough, Isabel, of Bermyngeham 2
4612934 2235106 2235106 plaintiff Crowe John   586350 586350 Crowe, John, of Bermyngeham 0
4626296 2239182 2239182 plaintiff Poynton Thomas   586350 586350 Poynton, Thomas, of Bermyngeham 0
4626297 2239182 2239182 defendant Ferybrygge John   586350 586350 Ferybrygge, John, of Bermyngeham 0
4750074 2280493 2280493 defendant Webbe Richard weaver 586350 586350 Webbe, Richard, of Bermyngeham, weaver 0
4788087 2292343 2292343 defendant Bowode Thomas baker 586350 586350 Bowode, Thomas, of Bermyngeham, baker 0
4794184 2294320 2294320 plaintiff Peyton Thomas yeoman 586350 586350 Peyton, Thomas, of Bermyngeham, yeoman 0
4794185 2294320 2294320 defendant Acton John fuller 586350 586350 Acton, John, of Bermyngeham, fuller 0
4794186 2294320 2294320 defendant Whitchirch Richard drover 586350 586350 Whitchirch, Richard, of Bermyngeham, drover 1
4794578 2294444 2294444 defendant Porter William mercer 586350 586350 Porter, William, of Bermyngeham, mercer 1
4817289 2301499 2301499 defendant Porter William mercer 586350 586350 Porter, William, of Bermyngeham, mercer 0
4817545 2301578 2301578 defendant Hyll John clerk & parson 586350 586350 Hyll, John, of Bermyngeham, clerk & parson 2
4830243 2305496 2305496 defendant Ferrers Edmund   586350 586350 Ferrers, Edmund, of Bermyngeham, knight 0
4841076 2308745 2308745 defendant Waren John clerk 586350 586350 Waren, John, of Bermyngeham, clerk 0
4857035 2313581 2313581 defendant Ferrers Edmund   586350 586350 Ferrers, Edmund, of Bermyngeham, knight 0
4868185 2317028 2317028 plaintiff Hychyns Richard   586350 586350 Hychyns, Richard, of Bermyngeham 0
4935665 2337542 2337542 defendant Couper William cooper 586350 586350 Couper, William, of Bermyngeham, cooper 0
4935666 2337542 2337542 defendant Tyler John smith 586350 586350 Tyler, John, of Bermyngeham, smith 1
4935667 2337542 2337542 defendant Drover William ostler 586350 586350 Drover, William, of Bermyngeham, ostler 2
4935668 2337542 2337542 defendant Halle William yeoman 586350 586350 Halle, William, of Bermyngeham, yeoman 3
4935669 2337542 2337542 defendant Watersall Robert butcher 586350 586350 Watersall, Robert, of Bermyngeham, butcher 4
4935670 2337542 2337542 defendant Billyng John drover 586350 586350 Billyng, John, of Bermyngeham, drover 5
4935672 2337543 2337543 defendant Chetwynd Philip   586350 586350 Chetwynd, Philip, of Bermyngeham, knight 0
4945507 2340573 2340573 defendant Whitchurch William butcher 586350 586350 Whitchurch, William, of Bermyngeham, butcher 4
5102930 2387278 2387278 defendant Philips William husbandman 586350 586350 Philips, William, of Bermyngeham, husbandman 1
5234893 2425789 2425789 defendant Pulesdon Nicholas sgerman 586350 586350 Pulesdon, Nicholas, of Bermyngeham, sgerman 1
5234926 2425796 2425796 defendant Lenche Henry laborer 586350 586350 Lenche, Henry, of Bermyngeham, laborer 2
5234930 2425796 2425796 defendant Pulesdon Nicholas sherman 586350 586350 Pulesdon, Nicholas, of Bermyngeham, sherman 6
5234932 2425797 2425797 defendant Gubbe Thomas yeoman 586350 586350 Gubbe, Thomas, of Bermyngeham, yeoman 0
5250091 2430135 2430135 defendant Bowyer Thomas lorimer 586350 586350 Bowyer, Thomas, of Bermyngeham, lorimer 0

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