names

128 rows where place_id = 595755

✎ 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
3621525 1874275 1874275 defendant Manser Christopher innholder 595755 595755 Manser, Christopher, of Barnet, or of Totenham, Middx, innholder 0
3621748 1874342 1874342 plaintiff Owen John baker 595755 595755 Owen, John, of Barnet, baker 0
3621751 1874343 1874343 plaintiff Owen John baker 595755 595755 Owen, John, of Barnet, baker 0
3621754 1874344 1874344 plaintiff Owen John baker 595755 595755 Owen, John, of Barnet, baker 0
3692550 1923857 1923857 defendant Gardener Robert baker 595755 595755 Gardener, Robert, of Barnet, baker 1
3695999 1924988 1924988 defendant Salford William gent 595755 595755 Salford, William, of Barnet, gent 1
3696000 1924988 1924988 defendant Bowman William gent 595755 595755 Bowman, William, of Barnet, gent 2
3696002 1924989 1924989 defendant Edwardys John butcher 595755 595755 Edwardys, John, of Barnet, butcher 0
3696003 1924989 1924989 defendant Wylkynson Thomas laborer 595755 595755 Wylkynson, Thomas, of Barnet, laborer 1
3696004 1924989 1924989 defendant Bowman William gent 595755 595755 Bowman, William, of Barnet, gent 2
3696092 1925002 1925002 defendant Bowman Thomas gent 595755 595755 Bowman, Thomas, of Barnet, gent 0
3708587 1928985 1928985 defendant Warde Joan widow 595755 595755 Warde, Joan, of Barnet, widow 2
3709911 1929414 1929414 defendant Wylkynson Thomas yeoman 595755 595755 Wylkynson, Thomas, of Barnet, yeoman 2
3709914 1929415 1929415 defendant Wylkynson Thomas yeoman 595755 595755 Wylkynson, Thomas, of Barnet, yeoman 1
4007284 2027386 2027386 defendant Gryffen John innholder 595755 595755 Gryffen, John, of Barnet, innholder 0
4342387 2144610 2144610 defendant Tyngcom William yeoman 595755 595755 Tyngcom, William, of Barnet, yeoman 0
4430804 2174390 2174390 defendant Nichol John   595755 595755 Nichol, John, of Barnet 0
4437385 2176439 2176439 defendant Nichol John   595755 595755 Nichol, John, of Barnet 0
4459831 2188128 2188128 defendant Raulyn John   595755 595755 Raulyn, John, of Barnet 0
4462544 2188981 2188981 defendant Spicer John merchant 595755 595755 Spicer, John, of Barnet, merchant 6
4467152 2190396 2190396 defendant Marchall Robert   595755 595755 Marchall, Robert, of Barnet 0
4492284 2198263 2198263 defendant Smyth John   595755 595755 Smyth, John, of Barnet 4
4492290 2198264 2198264 defendant Smyth John   595755 595755 Smyth, John, of Barnet 3
4506652 2202560 2202560 defendant Fekenham Robert   595755 595755 Fekenham, Robert, of Barnet 1
4520177 2206645 2206645 defendant Pope William   595755 595755 Pope, William, of Barnet 2
4538374 2212287 2212287 defendant Fekynham Robert   595755 595755 Fekynham, Robert, of Barnet, mason 3
4571473 2222659 2222659 plaintiff Alderiche John   595755 595755 Alderiche, John, of Barnet 0
4611085 2234530 2234530 defendant Bedelowe John   595755 595755 Bedelowe, John, of Barnet 8
4615108 2235735 2235735 defendant Haksalt John   595755 595755 Haksalt, John, of Barnet 3
4615113 2235736 2235736 defendant Haksalt John   595755 595755 Haksalt, John, of Barnet 3
4632482 2241048 2241048 defendant Trendill John, sen   595755 595755 Trendill, John, sen, of Barnet 1
4632484 2241048 2241048 defendant Hede John   595755 595755 Hede, John, of Barnet 3
4667320 2255507 2255507 defendant Taillour William maltman 595755 595755 Taillour, William, of Barnet, maltman 0
4689236 2262193 2262193 defendant Mopes John butcher 595755 595755 Mopes, John, of Barnet, butcher 0
4690306 2262524 2262524 plaintiff West John, senior   595755 595755 West, John, senior, of Barnet 0
4691268 2262790 2262790 defendant Sabbe William matlman 595755 595755 Sabbe, William, of Barnet, matlman 0
4713146 2269436 2269436 plaintiff Stery Thomas   595755 595755 Stery, Thomas, of Barnet 0
4716949 2270634 2270634 defendant Sabbe William maltman 595755 595755 Sabbe, William, of Barnet, maltman 0
4717918 2270944 2270944 defendant Trendele John, sen maltman 595755 595755 Trendele, John, sen, of Barnet, maltman 2
4717919 2270944 2270944 defendant Taillour William husbandman 595755 595755 Taillour, William, of Barnet, husbandman 3
4747123 2279666 2279666 defendant Taylour William husbandman 595755 595755 Taylour, William, of Barnet, husbandman 0
4748539 2280075 2280075 defendant Trendele John, senior husbandman 595755 595755 Trendele, John, senior, of Barnet, husbandman 1
4762710 2284317 2284317 plaintiff Elys Edmund   595755 595755 Elys, Edmund, of Barnet 1
4764139 2284775 2284775 plaintiff Harr John   595755 595755 Harr, John, of Barnet 0
4764141 2284776 2284776 plaintiff Harre John   595755 595755 Harre, John, of Barnet 0
4764142 2284776 2284776 defendant Bartelot John husbandman 595755 595755 Bartelot, John, of Barnet, husbandman 0
4764996 2285027 2285027 plaintiff Holmes Thomas   595755 595755 Holmes, Thomas, of Barnet 0
4788000 2292315 2292315 plaintiff Harre John   595755 595755 Harre, John, of Barnet 0
4788001 2292315 2292315 defendant Bartelot John husbandman 595755 595755 Bartelot, John, of Barnet, husbandman 0
4789121 2292650 2292650 plaintiff Holmes Thomas   595755 595755 Holmes, Thomas, of Barnet 0
4789123 2292651 2292651 plaintiff Holmes Thomas   595755 595755 Holmes, Thomas, of Barnet 0
4798099 2295595 2295595 defendant Bulshrave Henry drover 595755 595755 Bulshrave, Henry, of Barnet, drover 1
4847865 2310817 2310817 defendant Beauchamp William husbandman 595755 595755 Beauchamp, William, of Barnet, husbandman 3
4861477 2314959 2314959 defendant Pays John tanner 595755 595755 Pays, John, of Barnet, tanner 1
4861802 2315066 2315066 defendant Sabbe Robert chapman 595755 595755 Sabbe, Robert, of Barnet, chapman 0
4861804 2315067 2315067 defendant Sabbe Robert chapman 595755 595755 Sabbe, Robert, of Barnet, chapman 0
4874117 2318847 2318847 defendant Manwode Richard collier 595755 595755 Manwode, Richard, of Barnet, collier 0
4874118 2318847 2318847 defendant Dyngle Richard barber 595755 595755 Dyngle, Richard, of Barnet, barber 1
4874119 2318847 2318847 defendant Brydshot John carpenter 595755 595755 Brydshot, John, of Barnet, carpenter 2
4874155 2318857 2318857 defendant Langeford Richard drover 595755 595755 Langeford, Richard, of Barnet, drover 0
4875541 2319303 2319303 defendant Beauchamp William husbandman 595755 595755 Beauchamp, William, of Barnet, husbandman 0
4928450 2335321 2335321 defendant Rolf John, senior collier 595755 595755 Rolf, John, senior, of Barnet, collier 0
4928451 2335321 2335321 defendant Rolf William, senior laborer 595755 595755 Rolf, William, senior, of Barnet, laborer 1
4928452 2335321 2335321 defendant Fetherston Hugh husbandman 595755 595755 Fetherston, Hugh, of Barnet, husbandman 2
4928454 2335322 2335322 defendant Rolf John, senior collier 595755 595755 Rolf, John, senior, of Barnet, collier 0
4928455 2335322 2335322 defendant Rolff William, senior laborer 595755 595755 Rolff, William, senior, of Barnet, laborer 1
4928456 2335322 2335322 defendant Fethereston Hugh husbandman 595755 595755 Fethereston, Hugh, of Barnet, husbandman 2
4930176 2335842 2335842 defendant Langford Hugh husbandman 595755 595755 Langford, Hugh, of Barnet, husbandman 0
4930177 2335842 2335842 defendant Lyons Johns   595755 595755 Lyons, Johns, of Barnet 1
4975625 2349669 2349669 defendant Abell John husbandman 595755 595755 Abell, John, of Barnet, husbandman 0
4975626 2349669 2349669 defendant Atgore John husbandman 595755 595755 Atgore, John, of Barnet, husbandman 1
5007436 2359069 2359069 defendant Redeher William baker 595755 595755 Redeher, William, of Barnet, baker 0
5017350 2361964 2361964 defendant Coupewode Henry (legal representative) 595755 595755 Coupewode, Henry, of Barnet, executors of 0
5017351 2361964 2361964 defendant Osberne Henry husbandman 595755 595755 (Osberne, Henry, of Barnet, husbandman 1
5023145 2363671 2363671 defendant Roughede William maltman 595755 595755 Roughede, William, of Barnet, maltman 1
5025645 2364409 2364409 defendant Trandell John husbandman 595755 595755 Trandell, John, of Barnet, husbandman 0
5025647 2364409 2364409 defendant Osberne Henry husbandman 595755 595755 (Osberne, Henry, of Barnet, husbandman 2
5026143 2364542 2364542 defendant Langford John barker 595755 595755 Langford, John, of Barnet, barker 3
5030980 2365936 2365936 plaintiff Pryor John   595755 595755 Pryor, John, of Barnet 0
5041740 2369132 2369132 defendant Waleston Walter drover 595755 595755 Waleston, Walter, of Barnet, drover 0
5041742 2369132 2369132 defendant Heyton William tiler 595755 595755 Heyton, William, of Barnet, tiler 2
5053258 2372578 2372578 defendant Hyde John husbandman 595755 595755 Hyde, John, of Barnet, husbandman 1
5053259 2372578 2372578 defendant Lytylman John maltman 595755 595755 Lytylman, John, of Barnet, maltman 2
5053260 2372578 2372578 defendant de Watton John maltman 595755 595755 de Watton, John, of Barnet, maltman 3
5057573 2373833 2373833 defendant Crenlone or Crenlove John butcher 595755 595755 Crenlone or Crenlove, John, of Barnet, butcher 2
5064014 2375770 2375770 defendant Porter William husbandman 595755 595755 Porter, William, of Barnet, husbandman 0
5067071 2376675 2376675 defendant Porter William yeoman 595755 595755 Porter, William, of Barnet, yeoman 0
5068893 2377195 2377195 defendant Tanner Thomas butcher 595755 595755 Tanner, Thomas, of Barnet, butcher 0
5084229 2381791 2381791 defendant Goderych John tiler 595755 595755 Goderych, John, of Barnet, tiler 1
5085710 2382217 2382217 defendant Saverey Richard butcher 595755 595755 Saverey, Richard, of Barnet, butcher 0
5085711 2382217 2382217 defendant Felyp John butcher 595755 595755 Felyp, John, of Barnet, butcher 1
5085713 2382217 2382217 defendant Pryour John, junior butcher 595755 595755 Pryour, John, junior, of Barnet, butcher 3
5085714 2382217 2382217 defendant White Thomas cooper 595755 595755 White, Thomas, of Barnet, cooper 4
5086409 2382422 2382422 defendant Godrych John tiler 595755 595755 Godrych, John, of Barnet, tiler 0
5086410 2382422 2382422 defendant Freman John tailor 595755 595755 Freman, John, of Barnet, tailor 1
5093406 2384469 2384469 defendant Tanner Thomas butcher 595755 595755 Tanner, Thomas, of Barnet, butcher 0
5109735 2389275 2389275 plaintiff Godfray John husbandman 595755 595755 Godfray, John, of Barnet, husbandman 0
5109736 2389275 2389275 plaintiff Jenyn Thomas   595755 595755 Jenyn, Thomas, of Barnet 1
5112773 2390127 2390127 defendant Nicholl Thomas (legal representative) 595755 595755 Nicholl, Thomas, of Barnet, executors of 0
5112774 2390127 2390127 defendant Malter Thomas yeoman 595755 595755 (Malter, Thomas, of Barnet, yeoman 1

Next page

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