names

94 rows where place_id = 601716

✎ 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
3646674 1909363 1909363 defendant Wynne John smith 601716 601716 Wynne, John, of Antyngham, smith 2
3702191 1926941 1926941 defendant Parke Geoffrey husbandman 601716 601716 Parke, Geoffrey, of Antyngham, husbandman 1
3745329 1940444 1940444 defendant Walsshe John gent 601716 601716 Walsshe, John, of Antyngham, gent 0
3750417 1942050 1942050 plaintiff Drake Thomas   601716 601716 Drake, Thomas, of Antyngham 2
3751718 1942452 1942452 defendant Walsshe John gent 601716 601716 Walsshe, John, of Antyngham, gent 1
3753618 1943075 1943075 defendant Walsshe John gent 601716 601716 Walsshe, John, of Antyngham, gent 0
3753619 1943075 1943075 defendant Benys Richard   601716 601716 Benys, Richard, of Antyngham, worsted weaver 1
3755069 1943535 1943535 defendant Broune George husbandman 601716 601716 Broune, George, of Antyngham, husbandman 0
3755070 1943535 1943535 defendant Devys Richard   601716 601716 Devys, Richard, of Antyngham, worsted weaver 1
3755071 1943535 1943535 defendant Drake Thomas husbandman 601716 601716 Drake, Thomas, of Antyngham, husbandman 2
3755269 1943602 1943602 defendant Browne George husbandman 601716 601716 Browne, George, of Antyngham, husbandman 0
3755270 1943602 1943602 defendant Bevys Richard   601716 601716 Bevys, Richard, of Antyngham, worsted weaver 1
3757939 1944465 1944465 defendant Marchall John   601716 601716 Marchall, John, of Antyngham, worsted weaver 3
3764339 1946509 1946509 defendant Bourger Geoffrey husbandman 601716 601716 Bourger, Geoffrey, of Antyngham, husbandman 1
3770755 1948540 1948540 defendant Walsshe John gent 601716 601716 Walsshe, John, of Antyngham, gent 0
3770756 1948540 1948540 defendant Benys or Bevys Robert   601716 601716 Benys or Bevys, Robert, of Antyngham, worsted weaver 1
3788253 1954122 1954122 defendant Haltman Edmund clerk 601716 601716 Haltman, Edmund, of Antyngham, clerk 2
3795771 1956545 1956545 defendant Walsshe John gent 601716 601716 Walsshe, John, of Antyngham, gent 1
3804471 1959339 1959339 defendant Haltman Edmund clerk 601716 601716 Haltman, Edmund, of Antyngham, clerk 0
3810037 1961028 1961028 defendant Haltman Edmund clerk 601716 601716 Haltman, Edmund, of Antyngham, clerk 0
3826809 1966236 1966236 defendant Haltman Edward clerk 601716 601716 Haltman, Edward, of Antyngham, clerk 2
3826816 1966237 1966237 defendant Haltman Edward clerk 601716 601716 Haltman, Edward, of Antyngham, clerk 2
3857759 1976064 1976064 defendant Gardener Robert blacksmith 601716 601716 Gardener, Robert, of Antyngham, blacksmith 3
3871840 1980819 1980819 defendant Walsshe John yeoman 601716 601716 Walsshe, John, of Antyngham, yeoman 0
3876420 1982358 1982358 defendant Gardyner Robert smith 601716 601716 Gardyner, Robert, of Antyngham, smith 2
3910730 1993906 1993906 defendant Walysshe John gent 601716 601716 Walysshe, John, of Antyngham, gent 1
3914422 1995168 1995168 plaintiff Calthroppe Richard gent 601716 601716 Calthroppe, Richard, of Antyngham, gent 0
3919235 1996763 1996763 defendant Osborne Thomas mariner 601716 601716 Osborne, Thomas, of Antyngham, mariner 0
3963564 2011864 2011864 plaintiff Yonger Thomas yeoman 601716 601716 Yonger, Thomas, of Antyngham, yeoman 0
3963566 2011865 2011865 plaintiff Yonger Thomas yeoman 601716 601716 Yonger, Thomas, of Antyngham, yeoman 0
3968439 2013594 2013594 defendant Nockold James   601716 601716 Nockold, James, of Antyngham, worsted weaver 1
3972862 2015081 2015081 defendant Becham Richard thatcher 601716 601716 Becham, Richard, of Antyngham, thatcher 0
3987484 2020270 2020270 defendant Harmer Richard butcher 601716 601716 Harmer, Richard, of Antyngham, butcher 2
3991387 2021673 2021673 defendant Gryme Thomas gent 601716 601716 Gryme, Thomas, of Antyngham, gent 3
3994424 2022760 2022760 defendant Yonger John husbandman 601716 601716 Yonger, John, of Antyngham, husbandman 1
4007056 2027299 2027299 defendant Yonger Robert gent 601716 601716 Yonger, Robert, of Antyngham, or of Thavys Inn, Holborne, gent 0
4012278 2029111 2029111 defendant Yonger Thomas butcher 601716 601716 Yonger, Thomas, of Antyngham, butcher 0
4012279 2029111 2029111 defendant Yonger Thomas yeoman 601716 601716 Yonger, Thomas, of Antyngham, yeoman 1
4015014 2030073 2030073 defendant Bollande Robert husbandman 601716 601716 Bollande, Robert, of Antyngham, husbandman 6
4026489 2034121 2034121 defendant Yongar Thomas yeoman 601716 601716 Yongar, Thomas, of Antyngham, yeoman 0
4026491 2034122 2034122 defendant Yongar Thomas yeoman 601716 601716 Yongar, Thomas, of Antyngham, yeoman 0
4033692 2036700 2036700 plaintiff Gryme Thomas gent 601716 601716 Gryme, Thomas, of Antyngham, gent 0
4033695 2036700 2036700 defendant Harrold William husbandman 601716 601716 Harrold, William, of Antyngham, husbandman 2
4033696 2036701 2036701 plaintiff Gryme Thomas gent 601716 601716 Gryme, Thomas, of Antyngham, gent 0
4033699 2036701 2036701 defendant Harrold William husbandman 601716 601716 Harrold, William, of Antyngham, husbandman 2
4047232 2041459 2041459 defendant Gryme Thomas gent 601716 601716 Gryme, Thomas, of Antyngham, gent 0
4049245 2042175 2042175 defendant Harwood William husbandman 601716 601716 Harwood, William, of Antyngham, husbandman 0
4127874 2070259 2070259 defendant Younger Thomas yeoman 601716 601716 Younger, Thomas, of Antyngham, yeoman 1
4172466 2085832 2085832 defendant Wood Robert husbandman 601716 601716 Wood, Robert, of Antyngham, husbandman 0
4172748 2085926 2085926 defendant Wood Robert husbandman 601716 601716 Wood, Robert, of Antyngham, husbandman 3
4186811 2090873 2090873 defendant Jermy William gent 601716 601716 Jermy, William, of Antyngham, gent 2
4251737 2113571 2113571 defendant Gryme Martin gent 601716 601716 Gryme, Martin, of Antyngham, gent 1
4259826 2116260 2116260 defendant Tompson Richard yeoman 601716 601716 Tompson, Richard, of Antyngham, yeoman 0
4338934 2143372 2143372 defendant Yonger Adam yeoman 601716 601716 Yonger, Adam, of Antyngham, yeoman 0
4602905 2232123 2232123 defendant Wodeowe Ralph   601716 601716 Wodeowe, Ralph, of Antyngham 1
4767290 2285755 2285755 defendant Brounyng Walter   601716 601716 Brounyng, Walter, of Antyngham 3
4848781 2311079 2311079 defendant Foster William husbandman 601716 601716 Foster, William, of Antyngham, husbandman 0
4853684 2312568 2312568 defendant Ham John   601716 601716 Ham, John, of Antyngham, parson of St Mary's church 0
4895723 2325339 2325339 defendant atte Medewe Thomas husbandman 601716 601716 atte Medewe, Thomas, of Antyngham, husbandman 0
4897895 2326000 2326000 defendant Shipwynd Nicholas   601716 601716 Shipwynd, Nicholas, of Antyngham, freemason 0
4905033 2328183 2328183 defendant Ham John clerk 601716 601716 Ham, John, of Antyngham, clerk 0
4939861 2338856 2338856 defendant Madewyn John fuller 601716 601716 Madewyn, John, of Antyngham, fuller 1
5010236 2359859 2359859 plaintiff Walyssh Thomas   601716 601716 Walyssh, Thomas, of Antyngham 1
5012299 2360451 2360451 plaintiff Walysch Thomas   601716 601716 Walysch, Thomas, of Antyngham 1
5044404 2369957 2369957 plaintiff Hawe William   601716 601716 Hawe, William, of Antyngham 0
5056163 2373416 2373416 defendant Love John husbandman 601716 601716 Love, John, of Antyngham, husbandman 8
5104225 2387658 2387658 defendant Love John husbandman 601716 601716 Love, John, of Antyngham, husbandman 1
5106376 2388305 2388305 defendant Walyssh John yeoman 601716 601716 Walyssh, John, of Antyngham, yeoman 0
5132660 2396050 2396050 defendant Salman William couper 601716 601716 Salman, William, of Antyngham, couper 2
5255094 2431705 2431705 defendant Beston John, junior tailor 601716 601716 Beston, John, junior, of Antyngham, tailor 0
5269138 2436076 2436076 defendant Walssh John (legal representative) 601716 601716 Walssh, John, of Antyngham, executors of 4
5283266 2440164 2440164 defendant Cok John husbandman 601716 601716 (Cok, John, of Antyngham, husbandman 2
5283276 2440166 2440166 defendant Cok John yeoman 601716 601716 (Cok, John, of Antyngham, yeoman 1
5296832 2444063 2444063 defendant Walyssh John   601716 601716 Walyssh, John, of Antyngham 1
5311255 2448393 2448393 defendant Worme John husbandman 601716 601716 Worme, John, of Antyngham, husbandman 0
5328476 2453591 2453591 defendant Roler or Reler John laborer 601716 601716 Roler or Reler, John, of Antyngham, laborer 0
5333391 2455057 2455057 defendant Worme John husbandman 601716 601716 Worme, John, of Antyngham, husbandman 13
5337391 2456255 2456255 defendant Worme John husbandman 601716 601716 Worme, John, of Antyngham, husbandman 0
5346405 2459020 2459020 defendant Salman William cooper 601716 601716 Salman, William, of Antyngham, cooper 1
5377698 2468606 2468606 defendant Hogekyns Nicholas yeoman 601716 601716 Hogekyns, Nicholas, of Antyngham, yeoman 0
5377701 2468607 2468607 defendant Hogekyns Nicholas yeoman 601716 601716 Hogekyns, Nicholas, of Antyngham, yeoman 0
5379407 2469150 2469150 defendant Hogekyns Nicholas yeoman 601716 601716 Hogekyns, Nicholas, of Antyngham, yeoman 0
5393437 2473182 2473182 defendant Hogekyns Nicholas yeoman 601716 601716 Hogekyns, Nicholas, of Antyngham, yeoman 1
5442520 2487676 2487676 plaintiff Beston John, sen (legal representative) 601716 601716 Beston, John, sen, of Antyngham, executor of 0
5442522 2487676 2487676 defendant Ryngold Nicholas husbandman 601716 601716 Ryngold, Nicholas, of Antyngham, husbandman 0
5448433 2489427 2489427 defendant Hoggekyn Simon husbandman 601716 601716 Hoggekyn, Simon, of Antyngham, husbandman 3
5457067 2492017 2492017 defendant Hogekyns Nicholas yeoman 601716 601716 Hogekyns, Nicholas, of Antyngham, yeoman 4
5457077 2492018 2492018 defendant Hogekyns Nicholas yeoman 601716 601716 Hogekyns, Nicholas, of Antyngham, yeoman 4
5460741 2493158 2493158 defendant Hoggekyn Simon husbandman 601716 601716 Hoggekyn, Simon, of Antyngham, husbandman 3
5460764 2493165 2493165 defendant Hoggekyn Simon husbandman 601716 601716 Hoggekyn, Simon, of Antyngham, husbandman 3
5472338 2496693 2496693 defendant Hoggekyn Simon husbandman 601716 601716 Hoggekyn, Simon, of Antyngham, husbandman 2
5479107 2498775 2498775 defendant Walssh John (legal representative) 601716 601716 Walssh, John, of Antyngham, husbandman, administrator of 2
5483788 2500096 2500096 defendant Hoggekyn Simon husbandman 601716 601716 Hoggekyn, Simon, of Antyngham, husbandman 3
5570386 2525908 2525908 defendant Denys John husbandman 601716 601716 Denys, John, of Antyngham, husbandman 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);