names

107 rows where place_id = 596148

✎ 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
3623363 1874837 1874837 defendant Ward Richard yeoman 596148 596148 Ward, Richard, of Lokyngton, yeoman 0
3630185 1904290 1904290 defendant Coke Richard yeoman 596148 596148 Coke, Richard, of Lokyngton, yeoman 0
3637550 1906555 1906555 defendant Hewson Robert laborer 596148 596148 Hewson, Robert, of Lokyngton, laborer 1
3637551 1906555 1906555 defendant Vaux John tailor 596148 596148 Vaux, John, of Lokyngton, tailor 2
3708406 1928926 1928926 defendant Andreson Robert yeoman 596148 596148 Andreson, Robert, of Lokyngton, yeoman 0
3708407 1928926 1928926 defendant Scorburgh William yeoman 596148 596148 Scorburgh, William, of Lokyngton, yeoman 1
3719967 1932514 1932514 defendant Vyntener William yeoman 596148 596148 Vyntener, William, of Lokyngton, yeoman 0
3753272 1942963 1942963 defendant Hurste William husbandman 596148 596148 Hurste, William, of Lokyngton, husbandman 1
3753337 1942982 1942982 defendant Hurte William husbandman 596148 596148 Hurte, William, of Lokyngton, husbandman 1
3753339 1942982 1942982 defendant Devenshyre Thomas husbandman 596148 596148 Devenshyre, Thomas, of Lokyngton, husbandman 3
3765732 1946947 1946947 defendant Grevys John husbandman 596148 596148 Grevys, John, of Lokyngton, husbandman 0
3765733 1946947 1946947 defendant Pollard John husbandman 596148 596148 Pollard, John, of Lokyngton, husbandman 1
3800717 1958136 1958136 defendant Clerk Thomas husbandman 596148 596148 Clerk, Thomas, of Lokyngton, husbandman 0
3811408 1961463 1961463 defendant Hancok John grasier 596148 596148 Hancok, John, of Lokyngton, grasier 0
3811410 1961464 1961464 defendant Hancok John grasier 596148 596148 Hancok, John, of Lokyngton, grasier 0
3811412 1961465 1961465 defendant Hancok John grasier 596148 596148 Hancok, John, of Lokyngton, grasier 0
3837778 1969731 1969731 defendant Hancoke John husbandman 596148 596148 Hancoke, John, of Lokyngton, husbandman 0
3881973 1984230 1984230 defendant Hancokkys John husbandman 596148 596148 Hancokkys, John, of Lokyngton, husbandman 0
3886534 1985746 1985746 defendant Golett Francis butcher 596148 596148 Golett, Francis, of Lokyngton, butcher 2
3886535 1985746 1985746 defendant Hort Edward yeoman 596148 596148 Hort, Edward, of Lokyngton, yeoman 3
3886536 1985746 1985746 defendant Long John husbandman 596148 596148 Long, John, of Lokyngton, husbandman 4
3918472 1996507 1996507 defendant Hancoke John yeoman 596148 596148 Hancoke, John, of Lokyngton, yeoman 0
3931674 2000893 2000893 defendant Storeburgh John husbandman 596148 596148 Storeburgh, John, of Lokyngton, husbandman 0
4464168 2189463 2189463 defendant Kayner Thomas   596148 596148 Kayner, Thomas, of Lokyngton 0
4464807 2189656 2189656 plaintiff Wermyngton John   596148 596148 Wermyngton, John, of Lokyngton, parson 0
4464809 2189657 2189657 plaintiff Wermyngton John   596148 596148 Wermyngton, John, of Lokyngton, parson of the church 0
4522454 2207363 2207363 plaintiff Grene William   596148 596148 Grene, William, of Lokyngton 0
4522458 2207363 2207363 defendant Ragell John   596148 596148 Ragell, John, of Lokyngton 3
4524714 2208067 2208067 defendant Grene William   596148 596148 Grene, William, of Lokyngton 0
4540489 2212924 2212924 plaintiff Wermyngton John   596148 596148 Wermyngton, John, of Lokyngton, parson 0
4569478 2222040 2222040 plaintiff Wermyngton John   596148 596148 Wermyngton, John, of Lokyngton, parson 0
4569482 2222041 2222041 plaintiff Wermyngton John   596148 596148 Wermyngton, John, of Lokyngton, parson 0
4665792 2250777 2250777 defendant Bilton William laborer 596148 596148 Bilton, William, of Lokyngton, laborer 0
4695723 2264143 2264143 defendant Huntyng Thomas husbandman 596148 596148 Huntyng, Thomas, of Lokyngton, husbandman 0
4729492 2274437 2274437 defendant Lambard John yeoman 596148 596148 Lambard, John, of Lokyngton, yeoman 0
4729496 2274438 2274438 defendant Lambard John yeoman 596148 596148 Lambard, John, of Lokyngton, yeoman 0
4743579 2278647 2278647 defendant Pellican John yeoman 596148 596148 Pellican, John, of Lokyngton, yeoman 4
4746727 2279537 2279537 defendant Feriby Nicholas   596148 596148 Feriby, Nicholas, of Lokyngton, parson 0
4747806 2279864 2279864 defendant Polle Robert   596148 596148 Polle, Robert, of Lokyngton, vicar 0
4748608 2280090 2280090 defendant Best Richard husbandman 596148 596148 Best, Richard, of Lokyngton, husbandman 0
4752923 2281308 2281308 defendant Huntyng Thomas husbandman 596148 596148 Huntyng, Thomas, of Lokyngton, husbandman 2
4775694 2288394 2288394 defendant Haywode Thomas   596148 596148 Haywode, Thomas, of Lokyngton, parish clerk 0
4797074 2295252 2295252 defendant Elyson William husbandman 596148 596148 Elyson, William, of Lokyngton, husbandman 0
4797324 2295335 2295335 plaintiff Clyffe William   596148 596148 Clyffe, William, of Lokyngton 1
4799116 2295901 2295901 defendant Warner William yeoman 596148 596148 Warner, William, of Lokyngton, yeoman 0
4804765 2297690 2297690 defendant Smyth John   596148 596148 Smyth, John, of Lokyngton 0
4817045 2301429 2301429 defendant Alane John husbandman 596148 596148 Alane, John, of Lokyngton, husbandman 1
4844709 2309863 2309863 plaintiff Neweton Nicholas   596148 596148 Neweton, Nicholas, of Lokyngton, parson 0
4847582 2310740 2310740 defendant Burgeys Robert husbandman 596148 596148 Burgeys, Robert, of Lokyngton, husbandman 2
4860583 2314668 2314668 plaintiff Clyff William   596148 596148 Clyff, William, of Lokyngton 0
4866159 2316385 2316385 defendant Garthum Robert yeoman 596148 596148 Garthum, Robert, of Lokyngton, yeoman 4
4869743 2317507 2317507 defendant Tessh John husbandman 596148 596148 Tessh, John, of Lokyngton, husbandman 0
4869744 2317507 2317507 defendant Pellican Robert husbandman 596148 596148 Pellican, Robert, of Lokyngton, husbandman 1
4883981 2321898 2321898 defendant Garthum Robert yeoman 596148 596148 Garthum, Robert, of Lokyngton, yeoman 2
4895984 2325411 2325411 defendant Jakson Robert husbandman 596148 596148 Jakson, Robert, of Lokyngton, husbandman 0
4900463 2326789 2326789 defendant Taillour William husbandman 596148 596148 Taillour, William, of Lokyngton, husbandman 4
4927279 2334970 2334970 defendant Burgys Robert husbandman 596148 596148 Burgys, Robert, of Lokyngton, husbandman 0
4935409 2337470 2337470 defendant Bulkyn Richard husbandman 596148 596148 Bulkyn, Richard, of Lokyngton, husbandman 0
4936274 2337745 2337745 defendant Scorburgh Robert husbandman 596148 596148 Scorburgh, Robert, of Lokyngton, husbandman 0
4939791 2338833 2338833 defendant Federstone "Idonem" weaver 596148 596148 Federstone, "Idonem", of Lokyngton, weaver 0
4960821 2345198 2345198 defendant Smyth William smith 596148 596148 Smyth, William, of Lokyngton, smith 0
5035373 2367204 2367204 defendant Strynger William husbandman 596148 596148 Strynger, William, of Lokyngton, husbandman 1
5040620 2368803 2368803 defendant Strenger William laborer 596148 596148 Strenger, William, of lokyngton, laborer 1
5085960 2382286 2382286 defendant Strenger Robert yeoman 596148 596148 Strenger, Robert, of Lokyngton, yeoman 3
5090575 2383625 2383625 defendant Gower Richard miller 596148 596148 Gower, Richard, of Lokyngton, miller 0
5090579 2383626 2383626 defendant Gower Richard miller 596148 596148 Gower, Richard, of Lokyngton, miller 0
5090583 2383627 2383627 defendant Gower Richard miller 596148 596148 Gower, Richard, of Lokyngton, miller 0
5094774 2384884 2384884 defendant Strynger Robert husbandman 596148 596148 Strynger, Robert, of Lokyngton, husbandman 2
5094795 2384890 2384890 defendant Strynger Robert yeoman 596148 596148 Strynger, Robert, of Lokyngton, yeoman 2
5107412 2388599 2388599 defendant Clyffe Henry yeoman 596148 596148 Clyffe, Henry, of Lokyngton, yeoman 0
5148271 2400632 2400632 defendant Kyrkeby Richard chaplain 596148 596148 Kyrkeby, Richard, of Lokyngton, chaplain 0
5167615 2406253 2406253 defendant Kirkeby Richard chaplain 596148 596148 Kirkeby, Richard, of Lokyngton, chaplain 1
5183189 2410824 2410824 defendant Kirkeby Richard chaplain 596148 596148 Kirkeby, Richard, of Lokyngton, chaplain 1
5229381 2424203 2424203 defendant Strenger Robert yeoman 596148 596148 together with Strenger, Robert, of Lokyngton, yeoman 7
5247613 2429459 2429459 defendant Rychdale Thomas clerk 596148 596148 Rychdale, Thomas, of Lokyngton, clerk 0
5263072 2434192 2434192 defendant Richedale Thomas clerk 596148 596148 Richedale, Thomas, of Lokyngton, clerk 0
5295007 2443529 2443529 defendant Clyffe Henry yeoman 596148 596148 Clyffe, Henry, of Lokyngton, yeoman 4
5327143 2453193 2453193 defendant Taillour William husbandman 596148 596148 Taillour, William, of Lokyngton, husbandman 4
5327144 2453193 2453193 defendant Broune alias Paryssheclerke John weaver 596148 596148 Broune alias Paryssheclerke, John, of Lokyngton, weaver 5
5344303 2458399 2458399 defendant Colston William husbandman 596148 596148 Colston, William, of Lokyngton, husbandman 0
5348420 2459649 2459649 defendant Borough William laborer 596148 596148 Borough, William, of Lokyngton, laborer 1
5348421 2459649 2459649 defendant Clerk Richard   596148 596148 Clerk, Richard, of Lokyngton, clock maker 2
5490594 2502080 2502080 defendant Bowens John husbandman 596148 596148 Bowens, John, of Lokyngton, husbandman 1
5490595 2502080 2502080 defendant Clerk Richard   596148 596148 Clerk, Richard, of Lokyngton, clock maker 2
5490596 2502080 2502080 defendant Ponlord or Poulord John husbandman 596148 596148 Ponlord or Poulord, John, of Lokyngton, husbandman 3
5490597 2502080 2502080 defendant Shepard John husbandman 596148 596148 Shepard, John, of Lokyngton, husbandman 4
5490598 2502080 2502080 defendant Shepard William husbandman 596148 596148 Shepard, William, of Lokyngton, husbandman 5
5490599 2502080 2502080 defendant Savage William husbandman 596148 596148 Savage, William, of Lokyngton, husbandman 6
5510232 2508037 2508037 defendant Bowns John husbandman 596148 596148 Bowns, John, of Lokyngton, husbandman 1
5510233 2508037 2508037 defendant Clerk Richard   596148 596148 Clerk, Richard, of Lokyngton, clock maker 2
5510234 2508037 2508037 defendant Poulerd or Ponlerd John husbandman 596148 596148 Poulerd or Ponlerd, John, of Lokyngton, husbandman 3
5510235 2508037 2508037 defendant Sheppard John husbandman 596148 596148 Sheppard, John, of Lokyngton, husbandman 4
5510236 2508037 2508037 defendant Sheppard William husbandman 596148 596148 Sheppard, William, of Lokyngton, husbandman 5
5510237 2508037 2508037 defendant Savage William husbandman 596148 596148 Savage, William, of Lokyngton, husbandman 6
5510240 2508038 2508038 defendant Bowns John husbandman 596148 596148 Bowns, John, of Lokyngton, husbandman 1
5510241 2508038 2508038 defendant Clerk Richard   596148 596148 Clerk, Richard, of Lokyngton, clock maker 2
5510242 2508038 2508038 defendant Poulerd or Ponlerd John husbandman 596148 596148 Poulerd or Ponlerd, John, of Lokyngton, husbandman 3
5510243 2508038 2508038 defendant Sheppard John husbandman 596148 596148 Sheppard, John, of Lokyngton, husbandman 4
5510244 2508038 2508038 defendant Sheppard William husbandman 596148 596148 Sheppard, William, of Lokyngton, husbandman 5
5510245 2508038 2508038 defendant Savage William husbandman 596148 596148 Savage, William, of Lokyngton, husbandman 6

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