names

76 rows where place_id = 591466

✎ 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
3604489 1869070 1869070 plaintiff Grevy or Greny William yeoman 591466 591466 Grevy or Greny, William, of Hakford, yeoman 0
3678161 1919219 1919219 defendant Baldwyn William tailor 591466 591466 Baldwyn, William, of Hakford, tailor 1
3678163 1919219 1919219 defendant Goddyng William raffman 591466 591466 Goddyng, William, of Hakford, raffman 3
3691665 1923554 1923554 defendant Bronton or Brouton Thomas thatcher 591466 591466 Bronton or Brouton, Thomas, of Hakford, thatcher 0
3738363 1938212 1938212 defendant Fyssher John butcher 591466 591466 Fyssher, John, of Hakford, butcher 0
3738515 1938255 1938255 defendant Brynton William thatcher 591466 591466 Brynton, William, of Hakford, thatcher 0
3766269 1947100 1947100 defendant Male Richard butcher 591466 591466 Male, Richard, of Hakford, butcher 0
3878162 1982942 1982942 defendant Mason John painter 591466 591466 Mason, John, of Hakford, painter 5
4464962 2189710 2189710 defendant Grene Thomas   591466 591466 Grene, Thomas, of Hakford 7
4466649 2190244 2190244 defendant Almouthe Robert   591466 591466 Almouthe, Robert, of Hakford 1
4493070 2198532 2198532 plaintiff atte Grene William (legal representative) 591466 591466 atte Grene, William, of Hakford, executors of 0
4503406 2201636 2201636 defendant Davus Ralph   591466 591466 Davus, Ralph, of Hakford 1
4598031 2230639 2230639 defendant Greyene Thomas   591466 591466 Greyene, Thomas, of Hakford 0
4635959 2242082 2242082 defendant Ham Richard   591466 591466 Ham, Richard, of Hakford 0
4641229 2243526 2243526 defendant Kepyll John   591466 591466 Kepyll, John, of Hakford 0
4671139 2256638 2256638 defendant Greyne Thomas husubandman 591466 591466 Greyne, Thomas, of Hakford, husubandman 1
4671143 2256638 2256638 defendant atte Grene Henry husbandman 591466 591466 atte Grene, Henry, of Hakford, husbandman 5
4683682 2260498 2260498 plaintiff Perot Peter   591466 591466 Perot, Peter, of Hakford, on his own account 0
4686033 2261220 2261220 defendant Mason Thomas   591466 591466 Mason, Thomas, of Hakford, mason 2
4692384 2263134 2263134 defendant Nene or Neve Thomas yeoman 591466 591466 Nene or Neve, Thomas, of Hakford, yeoman 1
4692387 2263135 2263135 defendant Neme Thomas yeoman 591466 591466 Neme, Thomas, of Hakford, yeoman 0
4695264 2263999 2263999 plaintiff Mason John   591466 591466 Mason, John, of Hakford 1
4696121 2264269 2264269 defendant Nene Thomas   591466 591466 Nene, Thomas, of Hakford, holy water clerk 3
4697438 2264685 2264685 defendant Cuttys Stephen   591466 591466 Cuttys, Stephen, of Hakford, corsour or horse dealer 1
4708931 2268162 2268162 plaintiff Palgrave Gregory   591466 591466 Palgrave, Gregory, of Hakford 0
4718006 2270972 2270972 plaintiff atte Hagh Thomas   591466 591466 atte Hagh, Thomas, of Hakford 1
4729237 2274363 2274363 defendant Palgrave Gregory yeoman 591466 591466 Palgrave, Gregory, of Hakford, yeoman 4
4729238 2274363 2274363 defendant Qwykke Rowland   591466 591466 Qwykke, Rowland, of Hakford, parson 5
4733313 2275595 2275595 defendant Robbys Henry   591466 591466 Robbys, Henry, of Hakford, wright 2
4736018 2276404 2276404 defendant Perot Peter yeoman 591466 591466 Perot, Peter, of Hakford, yeoman 7
4758166 2282928 2282928 defendant Turnour John husbandman 591466 591466 Turnour, John, of Hakford, husbandman 0
4762516 2284259 2284259 defendant Lyne Robert yeoman 591466 591466 Lyne, Robert, of Hakford, yeoman 0
4762537 2284264 2284264 defendant Skot Walter laborer 591466 591466 Skot, Walter, of Hakford, laborer 0
4773041 2287539 2287539 defendant Langham Nicholas yeoman 591466 591466 Langham, Nicholas, of Hakford, yeoman 3
4789298 2292714 2292714 defendant Cossey Katherine widow 591466 591466 Cossey, Katherine, of Hakford, widow 0
4789299 2292714 2292714 defendant Cossey John yeoman 591466 591466 Cossey, John, of Hakford, yeoman 1
4808630 2298863 2298863 plaintiff Cuttes Stephen husbandman 591466 591466 Cuttes, Stephen, of Hakford, husbandman 0
4838073 2307829 2307829 defendant Robbes Henry yeoman 591466 591466 Robbes, Henry, of Hakford, yeoman 0
4865251 2316105 2316105 defendant Robbes Henry yeoman 591466 591466 Robbes, Henry, of Hakford, yeoman 0
4865253 2316106 2316106 defendant Robbes Henry yeoman 591466 591466 Robbes, Henry, of Hakford, yeoman 0
4892601 2324413 2324413 defendant Wylson Robert husbandman 591466 591466 Wylson, Robert, of Hakford, husbandman 0
4901176 2326980 2326980 defendant Sprygy John clerk 591466 591466 Sprygy, John, of Hakford, clerk 5
4932914 2336683 2336683 defendant Grene Robert husbandman 591466 591466 Grene, Robert, of Hakford, husbandman 4
4934589 2337210 2337210 defendant Vynne Robert laborer 591466 591466 Vynne, Robert, of Hakford, laborer 0
4949076 2341702 2341702 plaintiff Montford Thomas esq 591466 591466 Montford, Thomas, of Hakford, esq 0
4951698 2342486 2342486 defendant Wynnys Robert husbandman 591466 591466 Wynnys, Robert, of Hakford, husbandman 3
4988901 2353630 2353630 defendant Wedir Rogert sawer 591466 591466 Wedir, Rogert, of Hakford, sawer 10
4998637 2356477 2356477 defendant Ayleward John husbandman 591466 591466 Ayleward, John, of Hakford, husbandman 1
5018856 2362402 2362402 defendant Fytlyng Thomas husbandman 591466 591466 Fytlyng, Thomas, of Hakford, husbandman 0
5018858 2362403 2362403 defendant Wether Adam husbandman 591466 591466 Wether, Adam, of Hakford, husbandman 0
5018859 2362403 2362403 defendant Bataill John husbandman 591466 591466 Bataill, John, of Hakford, husbandman 1
5018860 2362403 2362403 defendant Westgate Andrew husbandman 591466 591466 Westgate, Andrew, of Hakford, husbandman 2
5018861 2362403 2362403 defendant Colman Lambert husbandman 591466 591466 Colman, Lambert, of Hakford, husbandman 3
5064063 2375786 2375786 plaintiff Knyght William   591466 591466 Knyght, William, of Hakford 0
5074772 2378959 2378959 defendant Dodde Robert yeoman 591466 591466 Dodde, Robert, of Hakford, yeoman 4
5158371 2403570 2403570 defendant Gyles William   591466 591466 Gyles, William, of Hakford, mason 3
5158376 2403571 2403571 defendant Gyles William   591466 591466 Gyles, William, of Hakford, mason 3
5158381 2403572 2403572 defendant Giles Williamm   591466 591466 Giles, Williamm, of Hakford, mason 3
5169447 2406798 2406798 defendant Snoryng Arnald gent 591466 591466 Snoryng, Arnald, of Hakford, gent 0
5169449 2406799 2406799 defendant Snoryng Arnald gent 591466 591466 Snoryng, Arnald, of Hakford, gent 0
5172121 2407565 2407565 defendant Snoryng Arnald gent 591466 591466 Snoryng, Arnald, of Hakford, gent 0
5172123 2407566 2407566 defendant Snoryng Arnald gent 591466 591466 Snoryng, Arnald, of Hakford, gent 0
5173975 2408087 2408087 defendant Goolde John husbandman 591466 591466 Goolde, John, of Hakford, husbandman 0
5177435 2409096 2409096 defendant Snoryng Arnold gent 591466 591466 Snoryng, Arnold, of Hakford, gent 0
5194245 2414049 2414049 defendant Goolde John husbandman 591466 591466 Goolde, John, of Hakford, husbandman 0
5235271 2425892 2425892 defendant Fettlyng Thomas husbandman 591466 591466 Fettlyng, Thomas, of Hakford, husbandman 2
5281813 2439753 2439753 defendant Mannyng John laborer 591466 591466 Mannyng, John, of Hakford, laborer 1
5307994 2447409 2447409 plaintiff Redman Thomas   591466 591466 Redman, Thomas, of Hakford 0
5380205 2469386 2469386 defendant Goodwyns John   591466 591466 Goodwyns, John, of Hakford 1
5386649 2471245 2471245 defendant Beveryche Robert clerk 591466 591466 Beveryche, Robert, of Hakford, clerk 2
5498574 2504517 2504517 defendant Vynnys or Wynnys Richard husbandman 591466 591466 Vynnys or Wynnys, Richard, of Hakford, husbandman 1
5508023 2507403 2507403 defendant Blaksale Robert husbandman 591466 591466 (Blaksale, Robert, of Hakford, husbandman 1
5554499 2521352 2521352 defendant Alpe Walter husbandman 591466 591466 Alpe, Walter, of Hakford, husbandman 2
5554501 2521352 2521352 defendant Fyssher John husbandman 591466 591466 Fyssher, John, of Hakford, husbandman 4
5554502 2521352 2521352 defendant Myllyngton Thomas husbandman 591466 591466 Myllyngton, Thomas, of Hakford, husbandman 5
5632664 2554234 2554234 defendant Whyk Roland clerk 591466 591466 Whyk, Roland, of Hakford, clerk 1

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