names

86 rows where place_id = 681132

✎ 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
3593989 1865758 1865758 defendant Robynson William yeoman 681132 681132 Robynson, William, of Kirkeby Over Blawys, yeoman 0
4043543 2040150 2040150 defendant Rede Leonard husbandman 681132 681132 Rede, Leonard, of Kirkeby, husbandman 2
4164963 2083253 2083253 defendant Trigett Thomas gent 681132 681132 Trigett, Thomas, of Kirkeby, gent 0
4236896 2108482 2108482 defendant Midleton Thomas gent 681132 681132 Midleton, Thomas, of Kirkeby, gent 0
4313884 2134961 2134961 defendant Houlegate William husbandman 681132 681132 Houlegate, William, of Kirkeby, husbandman 2
4415744 2169810 2169810 plaintiff Ibelot Emma   681132 681132 Ibelot, Emma, of Kirkeby, formerly wife of John 0
4423200 2172114 2172114 defendant del Spense Adam   681132 681132 del Spense, Adam, of Kirkeby 0
4423528 2172204 2172204 defendant del Spense Adam   681132 681132 del Spense, Adam, of Kirkeby 0
4425492 2172798 2172798 defendant Pyk Alan   681132 681132 Pyk, Alan, of Kirkeby 1
4433367 2175191 2175191 defendant Foucher William   681132 681132 Foucher, William, of Kirkeby 0
4453369 2186059 2186059 defendant Dennemey Thomas   681132 681132 Dennemey, Thomas, of Kirkeby 0
4455063 2186587 2186587 defendant atte Hyde Thomas tailor 681132 681132 atte Hyde, Thomas, of Kirkeby, tailor 0
4455064 2186587 2186587 defendant Horshey John mercer 681132 681132 Horshey, John, of Kirkeby, mercer 1
4458852 2187817 2187817 defendant Jullesson John   681132 681132 Jullesson, John, of Kirkeby 3
4459282 2187950 2187950 plaintiff Rowesson Robert   681132 681132 Rowesson, Robert, of Kirkeby 0
4459283 2187950 2187950 defendant Barnard William   681132 681132 Barnard, William, of Kirkeby 0
4459284 2187951 2187951 plaintiff Rowesson Robert   681132 681132 Rowesson, Robert, of Kirkeby 0
4459285 2187951 2187951 defendant Bernard William   681132 681132 Bernard, William, of Kirkeby 0
4516839 2205671 2205671 defendant Pipe Robert   681132 681132 Pipe, Robert, of Kirkeby 0
4560391 2219188 2219188 plaintiff Neuton Robert de   681132 681132 Neuton, Robert de, of Kirkeby, parson 0
4560393 2219189 2219189 plaintiff Neuton Robert de   681132 681132 Neuton, Robert de, of Kirkeby, parson 0
4567074 2221258 2221258 defendant Pycot John   681132 681132 Pycot, John, of Kirkeby 0
4568187 2221620 2221620 defendant Proktour Thomas   681132 681132 Proktour, Thomas, of Kirkeby 0
4593933 2229379 2229379 defendant Grene Richard   681132 681132 Grene, Richard, of Kirkeby 0
4601364 2231663 2231663 defendant Baxster Hugh   681132 681132 Baxster, Hugh, of Kirkeby 2
4609766 2234149 2234149 defendant Parys Thomas   681132 681132 Parys, Thomas, of Kirkeby 0
4614191 2235451 2235451 plaintiff Dracotes Alice   681132 681132 Dracotes, Alice, of Kirkeby 0
4616527 2236165 2236165 defendant Poklay John   681132 681132 Poklay, John, of Kirkeby, parish clerk 1
4617243 2236404 2236404 defendant Borewell Robert   681132 681132 Borewell, Robert, of Kirkeby 0
4620569 2237420 2237420 defendant Raulynson Richard   681132 681132 Raulynson, Richard, of Kirkeby 0
4621054 2237569 2237569 defendant Flesshewer William   681132 681132 Flesshewer, William, of Kirkeby on Moor 4
4639449 2243054 2243054 plaintiff Cooke Robert clerk 681132 681132 Cooke, Robert, of Kirkeby, clerk 0
4648716 2245682 2245682 defendant Saunderson Richard   681132 681132 Saunderson, Richard, of Kirkeby 0
4660368 2249070 2249070 defendant Trygot John yeoman 681132 681132 Trygot, John, of Kirkeby, yeoman 4
4666276 2250923 2250923 defendant Balle Robert   681132 681132 Balle, Robert, of Kirkeby 0
4667959 2255683 2255683 plaintiff Bakere Alan   681132 681132 Bakere, Alan, of Kirkeby 0
4668072 2255720 2255720 defendant Gamyll William yeoman 681132 681132 Gamyll, William, of Kirkeby, yeoman 0
4674065 2257498 2257498 defendant Grene Richard husbandman 681132 681132 Grene, Richard, of Kirkeby, husbandman 0
4700482 2265565 2265565 plaintiff Farman William   681132 681132 Farman, William, of Kirkeby Over Blawers, parson 0
4713351 2269497 2269497 defendant Walker Robert chaplain 681132 681132 Walker, Robert, of Kirkeby, chaplain 0
4719069 2271313 2271313 defendant Maynesford William laborer 681132 681132 Maynesford, William, of Kirkeby Under Knoll, laborer 0
4735866 2276369 2276369 defendant Birde Richard husbandman 681132 681132 Birde, Richard, of Kirkeby, husbandman 0
4736322 2276490 2276490 defendant Walley Richard   681132 681132 Walley, Richard, of Kirkeby, bailiff 0
4736664 2276595 2276595 defendant Robynson John husbandman 681132 681132 Robynson, John, of Kirkeby, husbandman 0
4737325 2276793 2276793 defendant Osbarne Thomas gent 681132 681132 Osbarne, Thomas, of Kirkeby, gent 1
4737950 2276976 2276976 defendant Threklyn William husbandman 681132 681132 Threklyn, William, of Kirkeby, husbandman 1
4772507 2287365 2287365 defendant Fouler Richard husbandman 681132 681132 Fouler, Richard, of Kirkeby, husbandman 4
4772960 2287514 2287514 defendant Chapman John laborer 681132 681132 Chapman, John, of Kirkeby, laborer 1
4778280 2289191 2289191 defendant Salforth William laborer 681132 681132 Salforth, William, of Kirkeby, laborer 0
4779984 2289741 2289741 defendant Milner John miller 681132 681132 Milner, John, of Kirkeby, miller 0
4779985 2289741 2289741 defendant Borowe John husbandman 681132 681132 Borowe, John, of Kirkeby, husbandman 1
4779986 2289741 2289741 defendant Smyth John smith 681132 681132 Smyth, John, of Kirkeby, smith 2
4782346 2290482 2290482 defendant Matheweson Robert yeoman 681132 681132 Matheweson, Robert, of Kirkeby, yeoman 0
4793837 2294193 2294193 defendant Milner John miller 681132 681132 Milner, John, of Kirkeby, miller 2
4796561 2295077 2295077 plaintiff Browene John   681132 681132 Browene, John, of Kirkeby 1
4828909 2305084 2305084 defendant Machon Richard husbandman 681132 681132 Machon, Richard, of Kirkeby, husbandman 0
4867657 2316855 2316855 defendant Trygot John husbandman 681132 681132 Trygot, John, of Kirkeby juxta Doncaster, husbandman 0
4867660 2316855 2316855 defendant Whytell John husbandman 681132 681132 Whytell, John, of Kirkeby juxta Doncaster, husbandman 3
4892134 2324280 2324280 defendant Broune John yeoman 681132 681132 Broune, John, of Kirkeby, yeoman 0
4908520 2329221 2329221 plaintiff att Bek Robert   681132 681132 att Bek, Robert, of Kirkeby 0
4918503 2332308 2332308 plaintiff Halley Henry   681132 681132 Halley, Henry, of Kirkeby 0
4918504 2332308 2332308 defendant Halley Henry   681132 681132 Halley, Henry, of Kirkeby 0
4921017 2333085 2333085 defendant Rogger John husbandman 681132 681132 Rogger, John, of Kirkeby, husbandman 0
4932839 2336657 2336657 defendant Langeselawe William yeoman 681132 681132 Langeselawe, William, of Kirkeby, yeoman 0
4971268 2348343 2348343 defendant Wattes John cordwainer 681132 681132 Wattes, John, of Kirkeby, cordwainer 3
5071903 2378091 2378091 defendant Watson Richard butcher 681132 681132 Watson, Richard, of Kirkeby, butcher 0
5087619 2382763 2382763 plaintiff Langton Richard, junior   681132 681132 Langton, Richard, junior, of Kirkeby 1
5091524 2383910 2383910 defendant Grymesby John yeoman 681132 681132 Grymesby, John, of Kirkeby, yeoman 5
5099905 2386409 2386409 defendant Seynttyngley Robert butcher 681132 681132 Seynttyngley, Robert, of Kirkeby, butcher 0
5108758 2388998 2388998 defendant Hall John smith 681132 681132 Hall, John, of Kirkeby, smith 0
5114586 2390675 2390675 defendant Turnour William yeoman 681132 681132 Turnour, William, of Kirkeby, yeoman 1
5129007 2394967 2394967 defendant Bradeley Robert clerk 681132 681132 Bradeley, Robert, of Kirkeby, clerk 0
5129008 2394967 2394967 defendant Smyth Robert smith 681132 681132 Smyth, Robert, of Kirkeby, smith 1
5198077 2415181 2415181 defendant Goos Thomas, sen butcher 681132 681132 Goos, Thomas, sen, of Kirkeby, butcher 3
5233076 2425258 2425258 defendant Neuman John husbandman 681132 681132 Neuman, John, of Kirkeby, husbandman 1
5233077 2425258 2425258 defendant Neuman Robert husbandman 681132 681132 Neuman, Robert, of Kirkeby, husbandman 2
5233567 2425409 2425409 defendant Sturgeon Rose widow 681132 681132 Sturgeon, Rose, of Kirkeby, widow 3
5233568 2425409 2425409 defendant Sturgeon Robert carpenter 681132 681132 Sturgeon, Robert, of Kirkeby, carpenter 4
5272638 2437072 2437072 defendant Farletun Robert yeoman 681132 681132 Farletun, Robert, of Kirkeby, yeoman 0
5291101 2442400 2442400 defendant Walker Richard husbandman 681132 681132 Walker, Richard, of Kirkeby, husbandman 2
5463187 2493905 2493905 defendant Gyrne Richard gent 681132 681132 Gyrne, Richard, of Kirkeby, gent 0
5463188 2493905 2493905 defendant Smart Richard yeoman 681132 681132 Smart, Richard, of Kirkeby, yeoman 1
5609800 2546765 2546765 defendant Hammeson Richard   681132 681132 Hammeson, Richard, of Kirkeby 8
5626522 2552268 2552268 defendant Fayte Thomas yeoman 681132 681132 Fayte, Thomas, of Kirkeby, yeoman 0
5626524 2552269 2552269 defendant Fayte Thomas yeoman 681132 681132 Fayte, Thomas, of Kirkeby, yeoman 0
5633310 2554413 2554413 defendant Gamyll Thomas husbandman 681132 681132 Gamyll, Thomas, of Kirkeby, 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);