names

71 rows where place_id = 588864

✎ 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
3595823 1866330 1866330 defendant Thornton John gent 588864 588864 Thornton, John, of Bedale, gent 0
3610281 1870872 1870872 defendant Bartram Edward yeoman 588864 588864 Bartram, Edward, of Bedale, yeoman 1
3617267 1873024 1873024 defendant Thornton Robert husbandman 588864 588864 Thornton, Robert, of Bedale, husbandman 1
4564844 2220570 2220570 defendant Nesame William   588864 588864 Nesame, William, of Bedale 4
4587862 2227604 2227604 defendant Alemand John   588864 588864 Alemand, John, of Bedale 2
4645459 2244740 2244740 defendant Walker Robert   588864 588864 Walker, Robert, of Bedale 1
4679314 2259142 2259142 defendant Walker Robert yeoman 588864 588864 Walker, Robert, of Bedale, yeoman 0
4748505 2280067 2280067 defendant Hyll John butcher 588864 588864 Hyll, John, of Bedale, butcher 0
4748506 2280067 2280067 defendant Thyrn John, senior husbandman 588864 588864 Thyrn, John, senior, of Bedale, husbandman 1
4748507 2280067 2280067 defendant Threpland Henry tailor 588864 588864 Threpland, Henry, of Bedale, tailor 2
4748508 2280067 2280067 defendant Burrell William tailor 588864 588864 Burrell, William, of Bedale, tailor 3
4748509 2280067 2280067 defendant Beste William tailor 588864 588864 Beste, William, of Bedale, tailor 4
4748510 2280067 2280067 defendant Burrell Richard weaver 588864 588864 Burrell, Richard, of Bedale, weaver 5
4748511 2280067 2280067 defendant Langton William milner 588864 588864 Langton, William, of Bedale, milner 6
4748513 2280067 2280067 defendant Wade Simon   588864 588864 Wade, Simon, of Bedale, wright 8
4748514 2280067 2280067 defendant Raper William raper 588864 588864 Raper, William, of Bedale, raper 9
4748515 2280067 2280067 defendant Vale Thomas draper 588864 588864 Vale, Thomas, of Bedale, draper 10
4748516 2280067 2280067 defendant Rande Simon clerk 588864 588864 Rande, Simon, of Bedale, clerk 11
4754943 2281927 2281927 defendant Chandiller Thomas chandler 588864 588864 Chandiller, Thomas, of Bedale, chandler 0
4754944 2281927 2281927 defendant Ferry Robert de yeoman 588864 588864 Ferry, Robert de, of Bedale, yeoman 1
4763539 2284579 2284579 defendant Milner William miller 588864 588864 Milner, William, of Bedale, miller 0
4776538 2288655 2288655 defendant Chandiller Thomas chandler 588864 588864 Chandiller, Thomas, of Bedale, chandler 0
4776539 2288655 2288655 defendant de Ferry Robert yeoman 588864 588864 de Ferry, Robert, of Bedale, yeoman 1
4776682 2288697 2288697 defendant Halton John chaplain 588864 588864 Halton, John, of Bedale, chaplain 0
4783875 2290973 2290973 defendant Robynson John husbandman 588864 588864 Robynson, John, of Bedale, husbandman 3
4783876 2290973 2290973 defendant Wade Simon   588864 588864 Wade, Simon, of Bedale, wright 4
4783877 2290973 2290973 defendant Cateryk John   588864 588864 Cateryk, John, of Bedale, wright 5
4783878 2290973 2290973 defendant Jonkynson John weaver 588864 588864 Jonkynson, John, of Bedale, weaver 6
4784398 2291123 2291123 defendant Milner William miller 588864 588864 Milner, William, of Bedale, miller 0
4784399 2291123 2291123 defendant Bowes John yeoman 588864 588864 Bowes, John, of Bedale, yeoman 1
4787216 2292069 2292069 defendant Milner William miller 588864 588864 Milner, William, of Bedale, miller 0
4794913 2294556 2294556 defendant Dalton William yeoman 588864 588864 Dalton, William, of Bedale, yeoman 0
4794914 2294556 2294556 defendant Robynson John huysbandman 588864 588864 Robynson, John, of Bedale, huysbandman 1
4794915 2294556 2294556 defendant de Dale Robert glover 588864 588864 de Dale, Robert, of Bedale, glover 2
4794916 2294556 2294556 defendant Hoggekynson John weaver 588864 588864 Hoggekynson, John, of Bedale, weaver 3
4794917 2294556 2294556 defendant Hoggekynson Thomas tailor 588864 588864 Hoggekynson, Thomas, of Bedale, tailor 4
4794918 2294556 2294556 defendant Wylson Robert   588864 588864 Wylson, Robert, of Bedale, wright 5
4794919 2294556 2294556 defendant Wade Simon   588864 588864 Wade, Simon, of Bedale, wright 6
4794920 2294556 2294556 defendant Kateryk John   588864 588864 Kateryk, John, of Bedale, wright 7
4797699 2295460 2295460 defendant Langton William miller 588864 588864 Langton, William, of Bedale, miller 2
4797700 2295460 2295460 defendant Besette William   588864 588864 Besette, William, of Bedale, medicus or of Cratk, leach 3
4797701 2295460 2295460 defendant Hunton William cordwainer 588864 588864 Hunton, William, of Bedale, cordwainer 4
4802404 2296943 2296943 defendant Bewes John yeoman 588864 588864 Bewes, John, of Bedale, yeoman 1
4817664 2301613 2301613 plaintiff Morton Robert   588864 588864 Morton, Robert, of Bedale, parson 0
4909874 2329612 2329612 defendant Bokull Robert shoemaker 588864 588864 Bokull, Robert, of Bedale, shoemaker 1
4938897 2338557 2338557 defendant Hill Alice (legal representative) 588864 588864 Hill, Alice, of Bedale, executor of 0
4938898 2338557 2338557 defendant Galtras Robert chaplain 588864 588864 Galtras, Robert, of Bedale, chaplain 1
4939243 2338659 2338659 defendant Couper John cooper 588864 588864 Couper, John, of Bedale, cooper 3
4939617 2338779 2338779 defendant de Stabull Thomas husbandman 588864 588864 de Stabull, Thomas, of Bedale, husbandman 0
4948183 2341404 2341404 defendant Bowes John yeoman 588864 588864 Bowes, John, of Bedale, yeoman 0
4951718 2342492 2342492 plaintiff Raper William (legal representative) 588864 588864 Raper, William, of Bedale, executors of 0
4954581 2343328 2343328 defendant Tesdale Henry yeoman 588864 588864 Tesdale, Henry, of Bedale, yeoman 0
5010161 2359836 2359836 defendant Hyndson John butcher 588864 588864 Hyndson, John, of Bedale, butcher 0
5018363 2362257 2362257 defendant Midilton Robert cordwainer 588864 588864 Midilton, Robert, of Bedale, cordwainer 2
5096134 2385309 2385309 defendant Lofthouse John yeoman 588864 588864 Lofthouse, John, of Bedale, yeoman 4
5096168 2385317 2385317 defendant Thornton John husbandman 588864 588864 Thornton, John, of Bedale, husbandman 0
5277369 2438459 2438459 defendant Lofthous John yeoman 588864 588864 Lofthous, John, of Bedale, yeoman 0
5290069 2442101 2442101 defendant Harryson Richard tailor 588864 588864 Harryson, Richard, of Bedale, tailor 0
5315512 2449706 2449706 defendant Chapman alias Hoton William chapman 588864 588864 Chapman alias Hoton, William, of Bedale, chapman 0
5315514 2449707 2449707 defendant Chapman alias Hoton William chapman 588864 588864 Chapman alias Hoton, William, of Bedale, chapman 0
5328922 2453726 2453726 defendant Lofthous John yeoman 588864 588864 Lofthous, John, of Bedale, yeoman 0
5331529 2454505 2454505 defendant Gayle William yeoman 588864 588864 Gayle, William, of Bedale, yeoman 0
5347779 2459458 2459458 defendant Barbour Thomas barber 588864 588864 Barbour, Thomas, of Bedale, barber 1
5355893 2461919 2461919 defendant Wilson Nicholas yeoman 588864 588864 Wilson, Nicholas, of Bedale, yeoman 3
5429987 2483908 2483908 defendant Thorneton John yeoman 588864 588864 Thorneton, John, of Bedale, yeoman 0
5431443 2484357 2484357 defendant Loftehous John yeoman 588864 588864 Loftehous, John, of Bedale, yeoman 0
5624230 2551525 2551525 plaintiff Langthorn Katherine   588864 588864 Langthorn, Katherine, of Bedale 0
5624686 2551655 2551655 defendant Walker John yeoman 588864 588864 Walker, John, of Bedale, yeoman 1
5634240 2554693 2554693 defendant Crofton John dyer 588864 588864 Crofton, John, of Bedale, dyer 0
5634796 2554881 2554881 plaintiff Walker Robert   588864 588864 Walker, Robert, of Bedale 0
5634799 2554882 2554882 plaintiff Walker Robert   588864 588864 Walker, Robert, of Bedale 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);