names

83 rows where place_id = 588719

✎ 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
3595378 1866186 1866186 defendant Haukyns Robert yeoman 588719 588719 Haukyns, Robert, of Neuport Paynell, yeoman 0
3685869 1921739 1921739 defendant Tompson William mercer 588719 588719 Tompson, William, of Neuport Paynell, wool packer, mercer 0
4441215 2182182 2182182 defendant Veysy William   588719 588719 Veysy, William, of Neuport Paynell, formerly servant of Thomas 0
4500763 2200852 2200852 defendant Baxster John   588719 588719 Baxster, John, of Neuport Paynell 0
4532293 2210367 2210367 defendant Colson John   588719 588719 Colson, John, of Neuport Paynell 0
4544829 2214301 2214301 defendant Wirehale Hugh chapman 588719 588719 Wirehale, Hugh, of Neuport Paynell, chapman 0
4550567 2216120 2216120 defendant Chucolre Richard   588719 588719 Chucolre, Richard, of Neuport Paynell 0
4552511 2216741 2216741 defendant Fuller Robert   588719 588719 Fuller, Robert, of Neuport Paynell 0
4597442 2230444 2230444 defendant Stafford Richard   588719 588719 Stafford, Richard, of Neuport Paynell 0
4646412 2245013 2245013 defendant Taillour Adam   588719 588719 Taillour, Adam, of Neuport Paynell 2
4647517 2245333 2245333 defendant Stafford Richard   588719 588719 Stafford, Richard, of Neuport Paynell 2
4652578 2246763 2246763 plaintiff Bakere John   588719 588719 Bakere, John, of Neuport Paynell 0
4667704 2255610 2255610 defendant Parker Richard husbandman 588719 588719 Parker, Richard, of Neuport Paynell, husbandman 1
4667949 2255679 2255679 defendant Taillour Adam tailor 588719 588719 Taillour, Adam, of Neuport Paynell, tailor 0
4667950 2255679 2255679 defendant Isham John tailor 588719 588719 Isham, John, of Neuport Paynell, tailor 1
4668240 2255777 2255777 defendant Parysseh John husbandman 588719 588719 Parysseh, John, of Neuport Paynell, husbandman 1
4668242 2255778 2255778 defendant Chyche Richard butcher 588719 588719 Chyche, Richard, of Neuport Paynell, butcher 0
4668243 2255778 2255778 defendant Parysshe John husbandman 588719 588719 Parysshe, John, of Neuport Paynell, husbandman 1
4746169 2279372 2279372 defendant Prene Walter baker 588719 588719 Prene, Walter, of Neuport Paynell, baker 0
4746170 2279372 2279372 defendant Chicche Richard husbandman 588719 588719 Chicche, Richard, of Neuport Paynell, husbandman 1
4748249 2279996 2279996 defendant Parker Robert husbandman 588719 588719 Parker, Robert, of Neuport Paynell, husbandman 2
4749527 2280342 2280342 defendant Preme Robert chapman 588719 588719 Preme, Robert, of Neuport Paynell, chapman 0
4749529 2280342 2280342 defendant Belassose John chapman 588719 588719 Belassose, John, of Neuport Paynell, chapman 2
4786511 2291827 2291827 defendant Parys John butcher 588719 588719 Parys, John, of Neuport Paynell, butcher 0
4787860 2292268 2292268 defendant Chicche Richard butcher 588719 588719 Chicche, Richard, of Neuport Paynell, butcher 4
4789829 2292886 2292886 defendant Basset Elias husbandman 588719 588719 Basset, Elias, of Neuport Paynell, husbandman 0
4789830 2292886 2292886 defendant Genell Thomas husbandman 588719 588719 Genell, Thomas, of Neuport Paynell, husbandman 1
4796852 2295172 2295172 defendant Stafford Richard husbandman 588719 588719 Stafford, Richard, of Neuport Paynell, husbandman 0
4796856 2295172 2295172 defendant Parys John butcher 588719 588719 Parys, John, of Neuport Paynell, butcher 4
4805242 2297839 2297839 defendant Prudde John yeoman 588719 588719 Prudde, John, of Neuport Paynell, yeoman 2
4813586 2300357 2300357 plaintiff Hobbes Henry husbandman 588719 588719 Hobbes, Henry, of Neuport Paynell, husbandman 0
4813588 2300357 2300357 defendant Squyer John tailor 588719 588719 Squyer, John, of Neuport Paynell, tailor 0
4813594 2300358 2300358 defendant Hobbesson Henry husbandman 588719 588719 Hobbesson, Henry, of Neuport Paynell, husbandman 4
4854859 2312872 2312872 plaintiff Abbey Thomas   588719 588719 Abbey, Thomas, of Neuport Paynell 0
4854860 2312872 2312872 defendant Peyto John fuller 588719 588719 Peyto, John, of Neuport Paynell, fuller 0
4855395 2313045 2313045 defendant Abbey Thomas fuller 588719 588719 Abbey, Thomas, of Neuport Paynell, fuller 0
4855397 2313046 2313046 defendant Abbey Thomas fuller 588719 588719 Abbey, Thomas, of Neuport Paynell, fuller 0
4879342 2320468 2320468 defendant Dagyll William, junior   588719 588719 Dagyll, William, junior, of Neuport Paynell, mason 0
4885810 2322433 2322433 defendant Crodelyng John chapman 588719 588719 Crodelyng, John, of Neuport Paynell, chapman 1
4885811 2322433 2322433 defendant Wryght Walter tailor 588719 588719 Wryght, Walter, of Neuport Paynell, tailor 2
4907018 2328770 2328770 defendant Astewode John husbandman 588719 588719 Astewode, John, of Neuport Paynell, husbandman 2
4921071 2333103 2333103 defendant Hobbes Hugh husbandman 588719 588719 Hobbes, Hugh, of Neuport Paynell, husbandman 0
4924711 2334166 2334166 defendant Tymmes John husbandman 588719 588719 (Tymmes, John, of Neuport Paynell, husbandman 2
4924728 2334170 2334170 defendant Tymmes John husbandman 588719 588719 (Tymmes, John, of Neuport Paynell, husbandman 2
4947614 2341249 2341249 defendant Potter Nicholas husbandman 588719 588719 Potter, Nicholas, of Neuport Paynell, husbandman 0
4947615 2341249 2341249 defendant Smyth Ralph smith 588719 588719 Smyth, Ralph, of Neuport Paynell, smith 1
4959622 2344839 2344839 plaintiff atte Hoo Simon   588719 588719 atte Hoo, Simon, of Neuport Paynell 0
4966712 2346979 2346979 defendant Fenton Robert clerk 588719 588719 Fenton, Robert, of Neuport Paynell, clerk 0
4966715 2346980 2346980 defendant Fenton Robert clerk 588719 588719 Fenton, Robert, of Neuport Paynell, clerk 0
4966718 2346981 2346981 defendant Hobbes Thomas maltman 588719 588719 Hobbes, Thomas, of Neuport Paynell, husbandman, maltman 0
4977015 2350079 2350079 defendant Jonneservant Chamber Joan   588719 588719 Jonneservant Chamber, Joan, of Neuport Paynell, servant 0
4977024 2350082 2350082 defendant Tymmes John husbandman 588719 588719 (Tymmes, John, of Neuport Paynell, husbandman 1
5031861 2366191 2366191 defendant Hobbes Ralph husbandman 588719 588719 Hobbes, Ralph, of Neuport Paynell, husbandman 1
5037761 2367919 2367919 defendant Pounteys John cordwainer 588719 588719 Pounteys, John, of Neuport Paynell, cordwainer 1
5053187 2372552 2372552 defendant Fyssher John husbandman 588719 588719 Fyssher, John, of Neuport Paynell, husbandman 0
5076201 2379382 2379382 defendant Chaumber Robert chapman 588719 588719 Chaumber, Robert, of Neuport Paynell, chapman 0
5079068 2380227 2380227 defendant Peyto John fuller 588719 588719 Peyto, John, of Neuport Paynell, fuller 0
5084331 2381823 2381823 defendant Hobbes John yeoman 588719 588719 Hobbes, John, of Neuport Paynell, yeoman 0
5096620 2385445 2385445 defendant Chambre John chapman 588719 588719 Chambre, John, of Neuport Paynell, chapman 2
5103607 2387482 2387482 defendant Hobbys Ralph husbandman 588719 588719 Hobbys, Ralph, of Neuport Paynell, husbandman 0
5216802 2420655 2420655 defendant Gomery William stringer 588719 588719 Gomery, William, of Neuport Paynell, stringer 0
5216803 2420655 2420655 defendant Barker Robert yeoman 588719 588719 Barker, Robert, of Neuport Paynell, yeoman 1
5220500 2421690 2421690 defendant Chaumbre Robert husbandman 588719 588719 Chaumbre, Robert, of Neuport Paynell, husbandman 4
5221214 2421904 2421904 defendant Barker Robert yeoman 588719 588719 Barker, Robert, of Neuport Paynell, yeoman 0
5229928 2424371 2424371 defendant Lake Thomas   588719 588719 Lake, Thomas, of Neuport Paynell 0
5264675 2434710 2434710 defendant Chamber John yeoman 588719 588719 Chamber, John, of Neuport Paynell, yeoman 0
5264676 2434710 2434710 defendant Chamber Robert yeoman 588719 588719 Chamber, Robert, of Neuport Paynell, yeoman 1
5272164 2436940 2436940 defendant Broun John husbandman 588719 588719 Broun, John, of Neuport Paynell, husbandman 0
5284128 2440378 2440378 defendant Peyto John yeoman 588719 588719 Peyto, John, of Neuport Paynell, yeoman 1
5292228 2442724 2442724 defendant Chambre Robert yeoman 588719 588719 Chambre, Robert, of Neuport Paynell, yeoman 4
5362109 2463813 2463813 defendant Peyto Thomas miller 588719 588719 Peyto, Thomas, of Neuport Paynell, miller 0
5362110 2463813 2463813 defendant Dyer John dyer 588719 588719 Dyer, John, of Neuport Paynell, dyer 1
5362111 2463813 2463813 defendant Bryce John tailor 588719 588719 Bryce, John, of Neuport Paynell, tailor 2
5413995 2479121 2479121 defendant Sydeley Thomas barber 588719 588719 Sydeley, Thomas, of Neuport Paynell, barber 0
5512403 2508740 2508740 defendant Coxton Nicholas husbandman 588719 588719 Coxton, Nicholas, of Neuport Paynell, husbandman 0
5590257 2531923 2531923 defendant Pottar Nicholas husbandman 588719 588719 Pottar, Nicholas, of Neuport Paynell, husbandman 0
5628468 2552874 2552874 defendant Stafford Richard butcher 588719 588719 Stafford, Richard, of Neuport Paynell, butcher 0
5628469 2552874 2552874 defendant Stafford Thomas husbandman 588719 588719 Stafford, Thomas, of Neuport Paynell, husbandman 1
5631082 2553728 2553728 defendant Lecas John carpenter 588719 588719 Lecas, John, of Neuport Paynell, carpenter 1
5631083 2553728 2553728 defendant Clerk John currier 588719 588719 Clerk, John, of Neuport Paynell, currier 2
5631091 2553731 2553731 defendant Parys John butcher 588719 588719 Parys, John, of Neuport Paynell, butcher 1
5631094 2553731 2553731 defendant Prene or Preve Robert mercer 588719 588719 Prene or Preve, Robert, of Neuport Paynell, mercer 4
5633504 2554473 2554473 defendant Stafford Richard butcher 588719 588719 Stafford, Richard, of Neuport Paynell, butcher 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);