names

70 rows where place_id = 594407

✎ 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
3615984 1872635 1872635 defendant Cole Alice widow 594407 594407 Cole, Alice, of Alvyngton, widow 1
3646854 1909416 1909416 defendant Cryspyn John husbandman 594407 594407 Cryspyn, John, of Alvyngton, husbandman 0
3646855 1909416 1909416 defendant Cole Thomas husbandman 594407 594407 Cole, Thomas, of Alvyngton, husbandman 1
3646856 1909416 1909416 defendant Cole Nicholas husbandman 594407 594407 Cole, Nicholas, of Alvyngton, husbandman 2
3646857 1909416 1909416 defendant Falabus Roger husbandman 594407 594407 Falabus, Roger, of Alvyngton, husbandman 3
3646858 1909416 1909416 defendant Yarnecombe Thomas husbandman 594407 594407 Yarnecombe, Thomas, of Alvyngton, husbandman 4
3751045 1942260 1942260 defendant Hore Richard smith 594407 594407 Hore, Richard, of Alvyngton, smith 0
3766619 1947220 1947220 defendant Byrdwode Nicholas weaver 594407 594407 Byrdwode, Nicholas, of Alvyngton, weaver 0
3846659 1972510 1972510 defendant Burdewode Nicholas weaver 594407 594407 Burdewode, Nicholas, of Alvyngton, weaver 0
4384805 2159605 2159605 defendant Ball John tanner 594407 594407 Ball, John, of Alvyngton, tanner 2
4530331 2209773 2209773 defendant Rowe Richard   594407 594407 Rowe, Richard, of Alvyngton 0
4570387 2222312 2222312 defendant Peret Walter   594407 594407 Peret, Walter, of Alvyngton 5
4582602 2225998 2225998 defendant Wyot Richard   594407 594407 Wyot, Richard, of Alvyngton 0
4582603 2225998 2225998 defendant Rowe Richard   594407 594407 Rowe, Richard, of Alvyngton 1
4585891 2227009 2227009 defendant Staure John   594407 594407 Staure, John, of Alvyngton 0
4592734 2229067 2229067 defendant Bisshop Roger   594407 594407 Bisshop, Roger, of Alvyngton 5
4606447 2233127 2233127 defendant Rou Thomas   594407 594407 Rou, Thomas, of Alvyngton 0
4655962 2247743 2247743 defendant Roger William husbandman 594407 594407 Roger, William, of Alvyngton, husbandman 0
4655963 2247743 2247743 defendant Hople John husbandman 594407 594407 Hople, John, of Alvyngton, husbandman 1
4655967 2247744 2247744 defendant Toryton Peter yeoman 594407 594407 Toryton, Peter, of Alvyngton, yeoman 0
4655969 2247744 2247744 defendant Herberd John gent 594407 594407 Herberd, John, of Alvyngton, gent 2
4720833 2271846 2271846 defendant Harry John husbandman 594407 594407 together with Harry, John, of Alvyngton, husbandman 3
4742111 2278184 2278184 defendant Whityng Robert husbandman 594407 594407 Whityng, Robert, of Alvyngton, husbandman 3
4748220 2279985 2279985 defendant Note John laborer 594407 594407 Note, John, of Alvyngton, laborer 1
4749596 2280364 2280364 defendant Harry John husbandman 594407 594407 Harry, John, of Alvyngton, husbandman 5
4769362 2286390 2286390 plaintiff Paule Simon   594407 594407 Paule, Simon, of Alvyngton, vicar 0
4780461 2289886 2289886 defendant Boys John husbandman 594407 594407 Boys, John, of Alvyngton, husbandman 2
4780462 2289886 2289886 defendant Prior John husbandman 594407 594407 Prior, John, of Alvyngton, husbandman 3
4780463 2289886 2289886 defendant Wareyn John, junior husbandman 594407 594407 Wareyn, John, junior, of Alvyngton, husbandman 4
4785055 2291341 2291341 defendant Howet Thomas husbandman 594407 594407 Howet, Thomas, of Alvyngton, husbandman 0
4827032 2304496 2304496 defendant Roger-servant-Wody John laborer 594407 594407 Roger-servant-Wody, John, of Alvyngton, laborer 2
4832026 2306049 2306049 defendant Boweryng John husbandman 594407 594407 Boweryng, John, of Alvyngton, husbandman 0
4832034 2306050 2306050 defendant Boys John husbandman 594407 594407 Boys, John, of Alvyngton, husbandman 5
4836154 2307288 2307288 defendant Loveney Thomas husbandman 594407 594407 Loveney, Thomas, of Alvyngton, husbandman 0
4842837 2309300 2309300 defendant Bouryng John husbandman 594407 594407 Bouryng, John, of Alvyngton, husbandman 0
4845771 2310187 2310187 defendant Douryng John husbandman 594407 594407 Douryng, John, of Alvyngton, husbandman 0
4846507 2310416 2310416 defendant Loveney Thomas husbandman 594407 594407 Loveney, Thomas, of Alvyngton, husbandman 0
4858866 2314150 2314150 defendant Perche Margery widow 594407 594407 Perche, Margery, of Alvyngton, widow 2
4858867 2314150 2314150 defendant Cause John husbandman 594407 594407 Cause, John, of Alvyngton, husbandman 3
4863589 2315582 2315582 defendant Loveney Thomas husbandman 594407 594407 Loveney, Thomas, of Alvyngton, husbandman 0
4879878 2320622 2320622 defendant Trigge Thomas laborer 594407 594407 Trigge, Thomas, of Alvyngton, laborer 0
4879879 2320622 2320622 defendant Grey William laborer 594407 594407 Grey William, of Alvyngton, laborer 1
4879880 2320622 2320622 defendant Trygge William laborer 594407 594407 Trygge, William, of Alvyngton, laborer 2
4942282 2339579 2339579 defendant Hyddeswyll Simon laborer 594407 594407 Hyddeswyll, Simon, of Alvyngton, laborer 3
4947425 2341190 2341190 defendant Harry John husbandman 594407 594407 Harry, John, of Alvyngton, husbandman 0
4953727 2343073 2343073 defendant Rowe John husbandman 594407 594407 Rowe, John, of Alvyngton, husbandman 3
4962910 2345822 2345822 defendant Ganter or Gauter Thomas yeoman 594407 594407 Ganter or Gauter, Thomas, of Alvyngton, yeoman 1
4962911 2345822 2345822 defendant Stracche John husbandman 594407 594407 Stracche, John, of Alvyngton, husbandman 2
5030957 2365927 2365927 defendant Loveney Thomas gent 594407 594407 Loveney, Thomas, of Alvyngton, gent 0
5040518 2368774 2368774 defendant Streche John husbandman 594407 594407 Streche, John, of Alvyngton, husbandman 2
5054934 2373039 2373039 defendant Perche Thomas husbandman 594407 594407 Perche, Thomas, of Alvyngton, husbandman 0
5068193 2376991 2376991 defendant Toker John yeoman 594407 594407 Toker, John, of Alvyngton, yeoman 1
5070341 2377622 2377622 defendant Puntyndon John laborer 594407 594407 Puntyndon, John, of Alvyngton, laborer 2
5088872 2383123 2383123 defendant Faukener Robert husbandman 594407 594407 Faukener, Robert, of Alvyngton, husbandman 0
5088873 2383123 2383123 defendant Hyemstede Richard smith 594407 594407 Hyemstede, Richard, of Alvyngton, smith 1
5088874 2383123 2383123 defendant Maddok Lawrence husbandman 594407 594407 Maddok, Lawrence, of Alvyngton, husbandman 2
5100243 2386514 2386514 defendant Toly Robert husbandman 594407 594407 Toly, Robert, of Alvyngton, husbandman 0
5118068 2391715 2391715 defendant Gille Thomas, junior gent 594407 594407 Gille,Thomas, junior, of Alvyngton, gent 0
5138018 2397626 2397626 defendant Gille Thomas, junior gent 594407 594407 Gille, Thomas, junior, of Alvyngton, gent 0
5138368 2397730 2397730 defendant Deker Richard husbandman 594407 594407 Deker, Richard, of Alvyngton, husbandman 0
5145891 2399925 2399925 defendant Turnour Stephen husbandman 594407 594407 Turnour, Stephen, of Alvyngton, husbandman 8
5164115 2405240 2405240 defendant Hawekyns John husbandman 594407 594407 Hawekyns, John, of Alvyngton, husbandman 0
5296939 2444098 2444098 defendant Milward John husbandman 594407 594407 Milward, John, of Alvyngton, husbandman 2
5296943 2444099 2444099 defendant Milward John husbandman 594407 594407 Milward, John, of Alvyngton, husbandman 2
5327297 2453235 2453235 defendant Coleyn John (legal representative) 594407 594407 Coleyn, John, of Alvyngton, yeoman, executors of 2
5563009 2523778 2523778 defendant Cryspyn William husbandman 594407 594407 Cryspyn, William, of Alvyngton, husbandman 0
5563010 2523778 2523778 defendant Rowe Robert husbandman 594407 594407 Rowe, Robert, of Alvyngton, husbandman 1
5563011 2523778 2523778 defendant Carowe John husbandman 594407 594407 Carowe, John, of Alvyngton, husbandman 2
5563012 2523778 2523778 defendant Adam John husbandman 594407 594407 Adam, John, of Alvyngton, husbandman 3
5563013 2523778 2523778 defendant Chubbe John husbandman 594407 594407 Chubbe, John, of Alvyngton, husbandman 4

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