names

71 rows where place_id = 592630

✎ 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
3608304 1870254 1870254 defendant Leverych Robert husbandman 592630 592630 Leverych, Robert, of Heigham, husbandman 3
3628421 1903756 1903756 defendant Clerke Robert husbandman 592630 592630 Clerke, Robert, of Heigham, husbandman 0
3689560 1922890 1922890 defendant Brygge Thomas gent 592630 592630 Brygge, Thomas, of Heigham, gent 0
3692633 1923883 1923883 defendant Godman John husbandman 592630 592630 Godman, John, of Heigham, husbandman 0
3694200 1924390 1924390 defendant Gedges John butcher 592630 592630 Gedges, John, of Heigham, butcher 2
3748448 1941449 1941449 plaintiff Grene Thomas (legal representative) 592630 592630 Grene, Thomas, of Heigham, executors of 0
3748449 1941449 1941449 plaintiff Thuxton John clerk 592630 592630 (Thuxton, John, of Heigham, clerk 1
3759689 1945020 1945020 defendant Lewson Augustine husbandman 592630 592630 Lewson, Augustine, of Heigham, husbandman 0
3782190 1952182 1952182 plaintiff Holle Thomas yeoman 592630 592630 Holle, Thomas, of Heigham, yeoman 0
3798313 1957370 1957370 defendant Russell Robert tanner 592630 592630 Russell, Robert, of Heigham, tanner 4
3809736 1960934 1960934 defendant Dobulday Thomas husbandman 592630 592630 Dobulday, Thomas, of Heigham, husbandman 0
3815715 1962833 1962833 defendant Russell Robert tanner 592630 592630 Russell, Robert, of Heigham, tanner 0
3841712 1970992 1970992 defendant Cosen Thomas husbandman 592630 592630 Cosen, Thomas, of Heigham Potter, husbandman 0
3841713 1970992 1970992 defendant Wedys John husbandman 592630 592630 Wedys, John, of Heigham Potter, husbandman 1
3847829 1972897 1972897 plaintiff Holle Thomas   592630 592630 Holle, Thomas, of Heigham 0
3849789 1973521 1973521 defendant Larwood William husbandman 592630 592630 Larwood, William, of Heigham Potter, husbandman 2
3852320 1974326 1974326 defendant Russell Robert tanner 592630 592630 Russell, Robert, of Heigham, tanner 0
3853031 1974567 1974567 defendant Pollard Nicholas smith 592630 592630 Pollard, Nicholas, of Heigham Potter, smith 0
3855778 1975438 1975438 plaintiff Ray John tanner 592630 592630 Ray, John, of Heigham, tanner 1
3861164 1977211 1977211 defendant Balle John husbandman 592630 592630 Balle, John, of Heigham Potter, husbandman 0
3861165 1977211 1977211 defendant Palmer Robert husbandman 592630 592630 Palmer, Robert, of Heigham Potter, husbandman 1
3861187 1977218 1977218 defendant Balle John husbandman 592630 592630 Balle, John, of Heigham Potter, husbandman 0
3861188 1977218 1977218 defendant Palmer Robert husbandman 592630 592630 Palmer, Robert, of Heigham Potter, husbandman 1
3864970 1978489 1978489 defendant Pollard Nicholas smith 592630 592630 Pollard, Nicholas, of Heigham Potter, smith 1
3881976 1984231 1984231 defendant Reve Henry tanner 592630 592630 Reve, Henry, of Heigham, tanner 0
4089867 2056664 2056664 defendant Welbecke William gent 592630 592630 Welbecke, William, of Heigham, gent 0
4126819 2069882 2069882 defendant Elwyn John gent 592630 592630 Elwyn, John, of Heigham, gent 0
4197593 2094715 2094715 defendant Banester Christopher gent 592630 592630 Banester, Christopher, of Heigham, gent 0
4197594 2094715 2094715 defendant Dowell Richard husbandman 592630 592630 Dowell, Richard, of Heigham, husbandman 1
4197595 2094715 2094715 defendant Richardson John husbandman 592630 592630 Richardson, John, of Heigham, husbandman 2
4197596 2094715 2094715 defendant Kynge Richard husbandman 592630 592630 Kynge, Richard, of Heigham, husbandman 3
4212448 2099902 2099902 defendant Warren John husbandman 592630 592630 Warren, John, of Heigham, husbandman 0
4377379 2156985 2156985 defendant Norton John husbandman 592630 592630 Norton, John, of Heigham, husbandman 1
4406895 2166871 2166871 defendant Norton John husbandman 592630 592630 Norton, John, of Heigham, husbandman 1
4407252 2166988 2166988 defendant Pawlinge Thomas husbandman 592630 592630 Pawlinge, Thomas, of Heigham Potter, husbandman 1
4442643 2182649 2182649 defendant Strout William   592630 592630 Strout, William, of Heigham 0
4449008 2184632 2184632 defendant Lyster Richard   592630 592630 Lyster, Richard, of Heigham 3
4535393 2211340 2211340 defendant Tubbyng Thomas   592630 592630 Tubbyng, Thomas, of Heigham 2
4667585 2255580 2255580 defendant Smyth John smith 592630 592630 Smyth, John, of Heigham, smith 0
4687371 2261652 2261652 defendant Cook John yeoman 592630 592630 Cook, John, of Heigham, yeoman 1
4687586 2261702 2261702 defendant Cook John yeoman 592630 592630 Cook, John, of Heigham, yeoman 0
4693937 2263610 2263610 defendant Tom John   592630 592630 Tom, John, of Heigham, vicar 0
4724303 2272898 2272898 defendant Bacon Geoffrey husbandman 592630 592630 Bacon, Geoffrey, of Heigham, husbandman 1
4765068 2285051 2285051 defendant Cook John yeoman 592630 592630 Cook, John, of Heigham Potter or Potter Heigham, yeoman 1
4768273 2286046 2286046 defendant atte Hethe John husbandman 592630 592630 atte Hethe, John, of Heigham, husbandman 0
4768282 2286047 2286047 defendant atte Hethe John husbandman 592630 592630 together with atte Hethe, John, of Heigham, husbandman 3
4827865 2304769 2304769 defendant Heigham Thomas gent 592630 592630 Heigham, Thomas, of Heigham, gent 0
4837538 2307676 2307676 defendant Heigham Thomas gent 592630 592630 Heigham, Thomas, of Heigham, gent 0
4845649 2310149 2310149 defendant Pecok Thomas tailor 592630 592630 Pecok, Thomas, of Heigham, tailor 0
4885102 2322233 2322233 defendant Jankynnys Nicholas yeoman 592630 592630 Jankynnys, Nicholas, of Heigham Potter, yeoman 1
4897735 2325958 2325958 defendant Nek William husbandman 592630 592630 Nek, William, of Heigham, husbandman 4
4925315 2334350 2334350 defendant Leche Thomas   592630 592630 Leche, Thomas, of Heigham, plough man 0
4935866 2337607 2337607 defendant Walsham William pedder 592630 592630 Walsham, William, of Heigham, pedder 0
5116440 2391242 2391242 defendant Colman Thomas husbandman 592630 592630 Colman, Thomas, of Heigham Potter, or of Ludham, husbandman 0
5154729 2402536 2402536 defendant Lymour Alexander fuller 592630 592630 Lymour, Alexander, of Heigham, fuller 3
5239977 2427268 2427268 defendant Courby Thomas yeoman 592630 592630 Courby, Thomas, of Heigham, yeoman 0
5308206 2447486 2447486 defendant Milys Thomas thatcher alias paten maker 592630 592630 Milys, Thomas, of Heigham, thatcher alias paten maker 0
5332123 2454685 2454685 defendant Davy Andrew yeoman 592630 592630 Davy, Andrew, of Heigham, yeoman 2
5334660 2455434 2455434 defendant Andrewe Robert smithyman 592630 592630 Andrewe, Robert, of Heigham, smithyman 0
5459554 2492769 2492769 defendant Norwold William carpenter 592630 592630 Norwold, William, of Heigham, carpenter 0
5480193 2499058 2499058 defendant Leveriche Robert fishmonger 592630 592630 Leveriche, Robert, of Heigham, fishmonger 0
5517755 2510394 2510394 defendant Courby Robert yeoman 592630 592630 Courby, Robert, of Heigham, yeoman 0
5555263 2521544 2521544 defendant Newby George waterman 592630 592630 Newby, George, of Heigham, waterman 0
5555522 2521616 2521616 defendant Grene John yeoman 592630 592630 Grene, John, of Heigham, yeoman 0
5599325 2534671 2534671 defendant Grene John yeoman 592630 592630 Grene, John, of Heigham, yeoman 0
5604383 2536234 2536234 defendant Barton George yeoman 592630 592630 Barton, George, of Heigham, yeoman 0
5607614 2537278 2537278 defendant London William yeoman 592630 592630 London, William, of Heigham, yeoman 0
5607615 2537278 2537278 defendant Peryot John husbandman 592630 592630 Peryot, John, of Heigham, husbandman 1
5616664 2549015 2549015 plaintiff Hunt John   592630 592630 Hunt, John, of Heigham, son of Hugh 0
5624621 2551640 2551640 defendant Reynald Stephen chaplain 592630 592630 Reynald, Stephen, of Heigham, chaplain 3
5628026 2552737 2552737 plaintiff Peeke John   592630 592630 Peeke, John, of Heigham 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);