names

125 rows where place_id = 637081

✎ 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
3834289 1968669 1968669 defendant Redbourne alias Heyward Robert yeoman 637081 637081 Redbourne alias Heyward, Robert, of Stanlake, yeoman 0
3834290 1968669 1968669 defendant Yate John yeoman 637081 637081 Yate, John, of Stanlake, yeoman 1
3834291 1968669 1968669 defendant Mery Bartholomew yeoman 637081 637081 Mery, Bartholomew, of Stanlake, yeoman 2
3834292 1968669 1968669 defendant Thurwarde Thomas husbandman 637081 637081 Thurwarde, Thomas, of Stanlake, husbandman 3
3861527 1977318 1977318 defendant Mery Bartholomew yeoman 637081 637081 Mery, Bartholomew, of Stanlake, yeoman 1
3873222 1981260 1981260 defendant Calcott George glover 637081 637081 Calcott, George, of Stanlake, glover 0
3921492 1997530 1997530 defendant Calcote George yeoman 637081 637081 Calcote, George, of Stanlake, yeoman 0
3997536 2023869 2023869 plaintiff Dyxon Ralph   637081 637081 Dyxon, Ralph, of Stanlake 0
3997537 2023869 2023869 defendant Grenewood Thomas weaver 637081 637081 Grenewood, Thomas, of Stanlake, weaver 0
3997538 2023870 2023870 plaintiff Dyxon Ralph   637081 637081 Dyxon, Ralph, of Stanlake 0
3997539 2023870 2023870 defendant Snapp John gent 637081 637081 Snapp, John, of Stanlake, gent 0
4214227 2100494 2100494 defendant Allyn Thomas yeoman 637081 637081 Allyn, Thomas, of Stanlake, yeoman 3
4233472 2107223 2107223 defendant Yate Bartholomew yeoman 637081 637081 Yate, Bartholomew, of Stanlake, yeoman 0
4233473 2107223 2107223 defendant Yate Edward yeoman 637081 637081 Yate, Edward, of Stanlake, yeoman 1
4442477 2182595 2182595 plaintiff Bukle Thomas   637081 637081 Bukle, Thomas, of Stanlake 0
4442896 2182738 2182738 plaintiff Bynne Thomas chaplain 637081 637081 Bynne, Thomas, of Stanlake, chaplain 0
4442897 2182738 2182738 defendant Bynne John   637081 637081 Bynne, John, of Stanlake, parson of the church of St Leonard in Walyngford 0
4523425 2207647 2207647 defendant Tryp Thomas   637081 637081 Tryp, Thomas, of Stanlake 0
4535749 2211459 2211459 defendant atte Mulne Thomas   637081 637081 atte Mulne, Thomas, of Stanlake 0
4545653 2214565 2214565 defendant Bernard William   637081 637081 Bernard, William, of Stanlake 0
4579319 2225015 2225015 defendant Mille Thomas   637081 637081 Mille, Thomas, of Stanlake, parson 0
4579586 2225101 2225101 defendant Bisshop Walter   637081 637081 Bisshop, Walter, of Stanlake 0
4604313 2232520 2232520 defendant Bernard William   637081 637081 Bernard, William, of Stanlake 0
4658842 2248637 2248637 defendant Walker John chapman 637081 637081 Walker, John, of Stanlake, chapman 0
4659801 2248915 2248915 defendant Walker Simon merchant 637081 637081 Walker, Simon, of Stanlake, merchant 0
4662293 2249679 2249679 defendant Fullere Robert fuller 637081 637081 Fullere, Robert, of Stanlake, fuller 0
4662751 2249808 2249808 plaintiff Fuller Robert   637081 637081 Fuller, Robert, of Stanlake 0
4662752 2249808 2249808 defendant Tirlyng William, junior husbandman 637081 637081 Tirlyng, William, junior, of Stanlake, husbandman 0
4662753 2249808 2249808 defendant Tirlyng John fuller 637081 637081 Tirlyng, John, of Stanlake, fuller 1
4662754 2249808 2249808 defendant Tirlyng John miller 637081 637081 Tirlyng, John, of Stanlake, miller 2
4662755 2249808 2249808 defendant Tirlyng Robert miller 637081 637081 Tirlyng, Robert, of Stanlake, miller 3
4692496 2263169 2263169 defendant Walkere Simon husbandman 637081 637081 Walkere, Simon, of Stanlake, husbandman 0
4692497 2263169 2263169 defendant Walkere John chapman 637081 637081 Walkere, John, of Stanlake, chapman 1
4695075 2263952 2263952 defendant Bernard William   637081 637081 Bernard, William, of Stanlake, wool winder 2
4709204 2268246 2268246 plaintiff Payn John   637081 637081 Payn, John, of Stanlake 0
4716890 2270611 2270611 defendant Payn John chapman 637081 637081 Payn, John, of Stanlake, chapman 0
4717377 2270772 2270772 defendant Walker John chapman 637081 637081 Walker, John, of Stanlake, chapman 0
4718014 2270974 2270974 defendant Walkere John chapman 637081 637081 Walkere, John, of Stanlake, chapman 0
4718317 2271069 2271069 defendant Robyns William husbandman 637081 637081 Robyns, William, of Stanlake, husbandman 0
4724512 2272964 2272964 defendant Robyns William butcher 637081 637081 Robyns, William, of Stanlake, butcher 0
4726779 2273646 2273646 defendant Mathewe John   637081 637081 Mathewe, John, of Stanlake, mill ward 0
4736474 2276541 2276541 defendant Halygrave John shoemaker 637081 637081 Halygrave, John, of Stanlake, shoemaker 0
4737626 2276878 2276878 defendant Walker Simon (legal representative) 637081 637081 Walker, Simon, of Stanlake, executors of 0
4737627 2276878 2276878 defendant Tryllyng William husbandman 637081 637081 (Tryllyng, William, of Stanlake, husbandman 1
4737628 2276878 2276878 defendant Walker Joan   637081 637081 Walker, Joan, of Stanlake, widow, formerly wife of Simon 2
4739173 2277345 2277345 defendant Holygrene John shoemaker 637081 637081 Holygrene, John, of Stanlake, shoemaker 0
4745576 2279217 2279217 defendant Halyngrene John husbandman 637081 637081 Halyngrene, John, of Stanlake, husbandman 0
4749268 2280267 2280267 defendant Halgrave John shoemaker 637081 637081 Halgrave, John, of Stanlake, shoemaker 0
4749610 2280370 2280370 plaintiff Payn John   637081 637081 Payn, John, of Stanlake, on his own account 0
4758288 2282968 2282968 defendant Mason John smith 637081 637081 Mason, John, of Stanlake, smith 0
4771504 2287069 2287069 defendant Strecche Robert fuller 637081 637081 Strecche, Robert, of Stanlake, fuller 0
4774518 2288016 2288016 defendant Halygrene John shoemaker 637081 637081 Halygrene, John, of Stanlake, shoemaker 0
4774523 2288019 2288019 plaintiff Walker John   637081 637081 Walker, John, of Stanlake 0
4774525 2288019 2288019 defendant Tryllyng William husbandman 637081 637081 Tryllyng, William, of Stanlake, husbandman 1
4774526 2288019 2288019 defendant Birche William laborer 637081 637081 Birche, William, of Stanlake, laborer 2
4774527 2288019 2288019 defendant Houchon Thomas husbandman 637081 637081 Houchon, Thomas, of Stanlake, husbandman 3
4795682 2294803 2294803 defendant Herbeye alias Barnerd William merchant 637081 637081 Herbeye alias Barnerd, William, of Stanlake, merchant 1
4802771 2297052 2297052 defendant Walkere John chapman 637081 637081 Walkere, John, of Stanlake, chapman 0
4813377 2300300 2300300 defendant Magot (illegible) husbandman 637081 637081 Magot, ----, of Stanlake, husbandman 1
4813378 2300300 2300300 defendant Stephenes John husbandman 637081 637081 Stephenes, John, of Stanlake, husbandman 2
4817172 2301461 2301461 defendant Mathewe John husbandman 637081 637081 Mathewe, John, of Stanlake, husbandman 4
4829862 2305385 2305385 plaintiff Bedele John   637081 637081 Bedele, John, of Stanlake 0
4829863 2305385 2305385 plaintiff Trillyng John   637081 637081 Trillyng, John, of Stanlake 1
4829864 2305385 2305385 defendant Walkere John husbandman 637081 637081 Walkere, John, of Stanlake, husbandman 0
4829865 2305386 2305386 plaintiff Bedele John   637081 637081 Bedele, John, of Stanlake 0
4829866 2305386 2305386 plaintiff Trillyng John   637081 637081 Trillyng, John, of Stanlake 1
4829867 2305386 2305386 defendant Walkere John husbandman 637081 637081 Walkere, John, of Stanlake, husbandman 0
4833180 2306389 2306389 defendant Marchall Thomas chapman 637081 637081 Marchall, Thomas, of Stanlake, chapman 0
4835013 2306953 2306953 defendant Marchell Thomas   637081 637081 Marchell, Thomas, of Stanlake, wool man 0
4840498 2308568 2308568 defendant Chaundeler John husbandman 637081 637081 Chaundeler, John, of Stanlake, husbandman 0
4844928 2309932 2309932 defendant Bryse Thomas husbandman 637081 637081 Bryse, Thomas, of Stanlake, husbandman 0
4856747 2313484 2313484 plaintiff Bedele John   637081 637081 Bedele, John, of Stanlake 0
4856748 2313484 2313484 plaintiff Tryllyng John   637081 637081 Tryllyng, John, of Stanlake 1
4856749 2313484 2313484 defendant Walkere John husbandman 637081 637081 Walkere, John, of Stanlake, husbandman 0
4861391 2314932 2314932 defendant Vyncent Thomas butcher 637081 637081 Vyncent, Thomas, of Stanlake, butcher 1
4898694 2326242 2326242 defendant Marchall Thomas yeoman 637081 637081 Marchall, Thomas, of Stanlake, yeoman 0
4898695 2326242 2326242 defendant Walker William, junior yeoman 637081 637081 Walker, William, junior, of Stanlake, yeoman 1
4914016 2330894 2330894 defendant Odam Henry husbandman 637081 637081 Odam, Henry, of Stanlake, husbandman 0
4914017 2330894 2330894 defendant Odam Walter husbandman 637081 637081 Odam, Walter, of Stanlake, husbandman 1
4914018 2330894 2330894 defendant Chaundelere John husbandman 637081 637081 Chaundelere, John, of Stanlake, husbandman 2
4922921 2333588 2333588 defendant Salysman alias Tempull John   637081 637081 Salysman alias Tempull, John, of Stanlake, milward 0
4935590 2337522 2337522 defendant Bagnore Robert fuller 637081 637081 Bagnore, Robert, of Stanlake, fuller 0
4935591 2337522 2337522 defendant Pery Henry fuller 637081 637081 Pery, Henry, of Stanlake, fuller 1
4951727 2342493 2342493 defendant Salysman John   637081 637081 Salysman, John, of Stanlake, millward 0
4953061 2342883 2342883 defendant Hayne John chaplain 637081 637081 Hayne, John, of Stanlake, chaplain 0
4955324 2343546 2343546 defendant Nicoll Walter husbandman 637081 637081 Nicoll, Walter, of Stanlake, husbandman 2
4955329 2343547 2343547 defendant Nicoll Walter husbandman 637081 637081 Nicoll, Walter, of Stanlake, husbandman 2
4960938 2345235 2345235 defendant Pery Henry fuller 637081 637081 Pery, Henry, of Stanlake, fuller 0
4960939 2345235 2345235 defendant Bagnore Robert fuller 637081 637081 together with Bagnore, Robert, of Stanlake, fuller 1
4976196 2349832 2349832 defendant Nobys Thomas carpenter 637081 637081 Nobys, Thomas, of Stanlake, carpenter 0
4983417 2351948 2351948 defendant Hersy Thomas husbandman 637081 637081 Hersy, Thomas, of Stanlake, husbandman 0
5013736 2360862 2360862 defendant Pynnok Stephen husbandman 637081 637081 Pynnok, Stephen, of Stanlake, husbandman 1
5013739 2360862 2360862 defendant Pynnok John husbandman 637081 637081 Pynnok, John, of Stanlake, husbandman 4
5024474 2364071 2364071 defendant Brise Henry husbandman 637081 637081 Brise, Henry, of Stanlake, husbandman 0
5024475 2364071 2364071 defendant Walwen William husbandman 637081 637081 Walwen, William, of Stanlake, husbandman 1
5024476 2364071 2364071 defendant Bocher Thomas husbandman 637081 637081 Bocher, Thomas, of Stanlake, husbandman 2
5029205 2365418 2365418 defendant Walker William gent 637081 637081 Walker, William, of Stanlake, gent 0
5058821 2374203 2374203 defendant Swayne Richard husbandman 637081 637081 Swayne, Richard, of Stanlake, husbandman 0
5067538 2376789 2376789 defendant Grene William smith 637081 637081 Grene, William, of Stanlake, smith 0
5080945 2380797 2380797 defendant Sydenham Thomas clerk 637081 637081 Sydenham, Thomas, of Stanlake, clerk 0

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