names

55 rows where place_id = 591651

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605096 1869259 1869259 defendant Grene Robert husbandman 591651 591651 Grene, Robert, of Bures St Mary, husbandman 0
3608370 1870276 1870276 defendant Argentem Robert butcher 591651 591651 Argentem, Robert, of Bures St Mary, butcher 0
3608373 1870277 1870277 defendant Argenten Robert butcher 591651 591651 Argenten, Robert, of Bures St Mary, butcher 0
3712385 1930191 1930191 defendant Frent Thomas husbandman 591651 591651 Frent, Thomas, of Bures St Mary, husbandman 0
3732086 1936269 1936269 defendant Kelyngworth Richard fuller 591651 591651 Kelyngworth, Richard, of Bures St Mary, fuller 3
3780330 1951580 1951580 plaintiff Fyssher William   591651 591651 Fyssher, William, of Bures St Mary 0
3796294 1956708 1956708 defendant Frend Edward pedder 591651 591651 Frend, Edward, of Bures St Mary, pedder 1
3803323 1958937 1958937 plaintiff Ravens Michael   591651 591651 Ravens, Michael, of Bures St Mary 0
3822024 1964782 1964782 plaintiff Smyth Robert yeoman 591651 591651 Smyth, Robert, of Bures St Mary, yeoman 0
3822809 1965040 1965040 plaintiff Syday William yeoman 591651 591651 Syday, William, of Bures St Mary, yeoman 0
3822811 1965041 1965041 plaintiff Syday William yeoman 591651 591651 Syday, William, of Bures St Mary, yeoman 0
3848492 1973109 1973109 defendant Fyssher William mercer 591651 591651 Fyssher, William, of Bures St Mary, mercer 2
3848494 1973109 1973109 defendant Rede John husbandman 591651 591651 Rede, John, of Bures St Mary, husbandman 4
3981300 2018079 2018079 plaintiff Quedwell John yeoman 591651 591651 Quedwell, John, of Bures St Mary, yeoman 0
4100112 2060373 2060373 defendant Lorkine James husbandman 591651 591651 Lorkine, James, of Bures St Mary, husbandman 0
4111940 2064520 2064520 defendant Turner William yeoman 591651 591651 Turner, William, of Bures St Mary, yeoman 0
4113682 2065176 2065176 defendant Turnor William yeoman 591651 591651 Turnor, William, of Bures St Mary, yeoman 0
4113684 2065177 2065177 defendant Turnor William yeoman 591651 591651 Turnor, William, of Bures St Mary, yeoman 0
4114429 2065444 2065444 defendant Turnor William yeoman 591651 591651 Turnor, William, of Bures St Mary, yeoman 0
4407553 2167091 2167091 defendant Rice William yeoman 591651 591651 Rice, William, of Bures St Mary, yeoman 1
4517248 2205795 2205795 defendant Moddy Richard   591651 591651 Moddy, Richard, of Bures St Mary 0
4520408 2206727 2206727 defendant Tristram Thomas   591651 591651 Tristram, Thomas, of Bures St Mary 0
4526606 2208598 2208598 defendant Mellere Ralph   591651 591651 Mellere, Ralph, of Bures St Mary 2
4594862 2229647 2229647 defendant Nowers John   591651 591651 Nowers, John, of Bures St Mary 2
4632749 2241127 2241127 defendant Bakere John   591651 591651 Bakere, John, of Bures St Mary 2
4681663 2259874 2259874 defendant Nowers Thomas yeoman 591651 591651 Nowers, Thomas, of Bures St Mary, yeoman 7
4683197 2260359 2260359 defendant Polstede John chapman 591651 591651 Polstede, John, of Bures St Mary, chapman 3
4693594 2263497 2263497 defendant Normandye Robert gent 591651 591651 Normandye, Robert, of Bures St Mary, gent 0
4696693 2264443 2264443 defendant Chapman john butcher 591651 591651 Chapman, john, of Bures St Mary, butcher 0
4724873 2273075 2273075 defendant Normandye Robert   591651 591651 Normandye, Robert, of Bures St Mary, franklin 1
4729573 2274463 2274463 plaintiff Swanton William   591651 591651 Swanton, William, of Bures St Mary 1
4736184 2276451 2276451 defendant Burre William yeoman 591651 591651 Burre, William, of Bures St Mary, yeoman 0
4738339 2277086 2277086 defendant Luntley Richard husbandman 591651 591651 Luntley, Richard, of Bures St Mary, husbandman 4
4913787 2330813 2330813 plaintiff Colyere John baker 591651 591651 Colyere, John, of Bures St Mary, baker 0
4913788 2330813 2330813 defendant Colyere John baker 591651 591651 Colyere, John, of Bures St Mary, baker 0
4983934 2352126 2352126 plaintiff Wendene John (legal representative) 591651 591651 Wendene, John, of Bures St Mary, executors of 0
4983941 2352127 2352127 plaintiff Wendene John (legal representative) 591651 591651 Wendene, John, of Bures St Mary, executors of 0
4997212 2356020 2356020 defendant Heryet Thomas yeoman 591651 591651 Heryet, Thomas, of Bures St Mary, yeoman 1
5018515 2362295 2362295 defendant Lay John husbandman 591651 591651 Lay, John, of Bures St Mary, husbandman 0
5018519 2362296 2362296 defendant Peter Simon husbandman 591651 591651 Peter, Simon, of Bures St Mary, husbandman 0
5036080 2367406 2367406 defendant Chapman John laborer 591651 591651 Chapman, John, of Bures St Mary, laborer 1
5080639 2380698 2380698 defendant Materas Richard husbandman 591651 591651 Materas, Richard, of Bures St Mary, husbandman 0
5081496 2380965 2380965 defendant Clerk Ralph husbandman 591651 591651 Clerk, Ralph, of Bures St Mary, husbandman 0
5094214 2384713 2384713 defendant Balle John butcher 591651 591651 Balle, John, of Bures St Mary, butcher 1
5108719 2388987 2388987 defendant Potyer John husbandman 591651 591651 Potyer, John, of Bures St Mary, husbandman 0
5108723 2388988 2388988 defendant Potter John husbandman 591651 591651 Potter, John, of Bures St Mary, husbandman 0
5151577 2401613 2401613 defendant Clerk Ralph husbandman 591651 591651 Clerk, Ralph, of Bures St Mary, husbandman 0
5169692 2406874 2406874 defendant Clerk Ralph husbandman 591651 591651 Clerk, Ralph, of Bures St Mary, husbandman 0
5367540 2465495 2465495 defendant Clerk Robert laborer 591651 591651 Clerk, Robert, of Bures St Mary, laborer 0
5485990 2500697 2500697 defendant Terry Robert tailor 591651 591651 Terry, Robert, of Bures St Mary, or of Stoke Naylond, tailor 0
5518589 2510647 2510647 plaintiff Akyrman John   591651 591651 Akyrman, John, of Bures St Mary 0
5519173 2510841 2510841 defendant Symson Richard yeoman 591651 591651 Symson, Richard, of Bures St Mary, yeoman 0
5519174 2510841 2510841 defendant Page Thomas husbandman 591651 591651 Page, Thomas, of Bures St Mary, husbandman 1
5607111 2537111 2537111 plaintiff Hulke John yeoman 591651 591651 Hulke, John, of Bures St Mary, yeoman 1
5627240 2552486 2552486 defendant Hyde Thomas laborer 591651 591651 Hyde, Thomas, of Bures St Mary, laborer 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);