names

53 rows where place_id = 594819

✎ 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
3617750 1873176 1873176 defendant Leyerdon or Legerdon Gilbert husbandman 594819 594819 Leyerdon or Legerdon, Gilbert, of Quaplod, husbandman 3
3619682 1873725 1873725 defendant Pynchebek William gent 594819 594819 Pynchebek, William, of Quaplod, gent 0
3619685 1873726 1873726 defendant Skarlet Robert yeoman 594819 594819 Skarlet, Robert, of Quaplod, yeoman 0
3619686 1873726 1873726 defendant Shepard Robert husbandman 594819 594819 Shepard, Robert, of Quaplod, husbandman 1
4610911 2234485 2234485 defendant Litster William   594819 594819 Litster, William, of Quaplod 0
4617649 2236526 2236526 defendant Goodhusband Richard   594819 594819 Goodhusband, Richard, of Quaplod 1
4626210 2239154 2239154 plaintiff Porter John, sen   594819 594819 Porter, John, sen, of Quaplod 0
4626211 2239154 2239154 defendant Doggeshed William   594819 594819 Doggeshed, William, of Quaplod 0
4626213 2239154 2239154 defendant Hubard William   594819 594819 Hubard, William, of Quaplod 2
4626214 2239154 2239154 defendant Storme John   594819 594819 Storme, John, of Quaplod, son of Alexander 3
4682543 2260162 2260162 defendant Stkynner Roger   594819 594819 Stkynner, Roger, of Quaplod, bailiff 1
4809762 2299216 2299216 defendant Prowet John husbandman 594819 594819 Prowet, John, of Quaplod, husbandman 0
4815379 2300917 2300917 defendant Tygo John husbandman 594819 594819 Tygo, John, of Quaplod, husbandman 3
4834567 2306819 2306819 defendant Idon John yeoman 594819 594819 Idon, John, of Quaplod, yeoman 0
4870959 2317892 2317892 defendant Glover William husbandman 594819 594819 Glover, William, of Quaplod, husbandman 0
4882358 2321394 2321394 defendant Horne William husbandman 594819 594819 Horne, William, of Quaplod, husbandman 0
4892107 2324274 2324274 defendant Randolf John husbandman 594819 594819 Randolf, John, of Quaplod, husbandman 0
4892109 2324274 2324274 defendant Pynder Henry husbandman 594819 594819 Pynder, Henry, of Quaplod, husbandman 2
4892110 2324274 2324274 defendant Thirlowe William husbandman 594819 594819 Thirlowe, William, of Quaplod, husbandman 3
4892113 2324274 2324274 defendant Gamull Simon husbandman 594819 594819 Gamull, Simon, of Quaplod, husbandman 6
4892114 2324274 2324274 defendant Everard John husbandman 594819 594819 Everard, John, of Quaplod, husbandman 7
4892115 2324274 2324274 defendant Burnwell William husbandman 594819 594819 Burnwell, William, of Quaplod,husbandman 8
4892116 2324274 2324274 defendant Mosse Katherine widow 594819 594819 Mosse, Katherine, of Quaplod, widow 9
4892117 2324274 2324274 defendant Willyamson Richard laborer 594819 594819 Willyamson, Richard, of Quaplod, laborer 10
4905551 2328334 2328334 defendant Horne William husbandman 594819 594819 Horne, William, of Quaplod, husbandman 0
4920820 2333025 2333025 defendant Blakwell Thomas husbandman 594819 594819 Blakwell, Thomas, of Quaplod, husbandman 3
4920821 2333025 2333025 defendant Winulsey John yeoman 594819 594819 Winulsey, John, of Quaplod, yeoman 4
4920822 2333025 2333025 defendant Acke Alexander husbandman 594819 594819 Acke, Alexander, of Quaplod, husbandman 5
4926379 2334672 2334672 defendant Skynner Robert husbandman 594819 594819 Skynner, Robert, of Quaplod, husbandman 0
4937726 2338177 2338177 defendant Mannere John husbandman 594819 594819 Mannere, John, of Quaplod, husbandman 2
4945925 2340711 2340711 defendant Redman Robert yeoman 594819 594819 Redman, Robert, of Quaplod, yeoman 0
4945927 2340712 2340712 defendant Scarlet Robert, senior   594819 594819 Scarlet, Robert, senior, of Quaplod, shepherd 0
4956326 2343855 2343855 defendant Strotte William husbandman 594819 594819 Strotte, William, of Quaplod, husbandman 0
4956327 2343855 2343855 defendant Strotte John husbandman 594819 594819 Strotte, John, of Quaplod, husbandman 1
4971708 2348466 2348466 defendant Cawode William husbandman 594819 594819 Cawode, William, of Quaplod, husbandman 0
4980277 2351045 2351045 defendant Spenloffe Thomas husbandman 594819 594819 Spenloffe, Thomas, of Quaplod, husbandman 0
4992188 2354557 2354557 defendant Bateman John smith 594819 594819 Bateman, John, of Quaplod, smith 0
5021979 2363320 2363320 defendant Scoby John husbandman 594819 594819 Scoby, John, of Quaplod, husbandman 2
5023506 2363784 2363784 defendant Clerk William husbandman 594819 594819 Clerk William, of Quaplod, husbandman 2
5060461 2374706 2374706 defendant Strotte John, junior husbandman 594819 594819 Strotte, John, junior, of Quaplod, husbandman 0
5073116 2378445 2378445 defendant Akke Simon yeoman 594819 594819 Akke, Simon, of Quaplod, yeoman 0
5083189 2381470 2381470 defendant Idon John, junior husbandman 594819 594819 Idon, John, junior, of Quaplod, husbandman 6
5087601 2382756 2382756 defendant Randes John laborer 594819 594819 Randes, John, of Quaplod, laborer 1
5117767 2391631 2391631 plaintiff Pulvertoft Thomas   594819 594819 Pulvertoft, Thomas, of Quaplod 1
5351051 2460436 2460436 defendant Tygo Richard husbandman 594819 594819 Tygo, Richard, of Quaplod, husbandman 0
5351052 2460436 2460436 defendant Lewyn Richard husbandman 594819 594819 Lewyn, Richard, of Quaplod, husbandman 1
5359441 2462990 2462990 defendant Markham Gilbert husbandman 594819 594819 Markham, Gilbert, of Quaplod, husbandman 0
5359480 2463000 2463000 defendant Pynder John husbandman 594819 594819 Pynder, John, of Quaplod, husbandman 1
5512251 2508695 2508695 defendant Biller John husbandman 594819 594819 Biller, John, of Quaplod, husbandman 0
5526660 2512905 2512905 defendant Scarlet Robert yeoman 594819 594819 Scarlet, Robert, of Quaplod, yeoman 0
5526661 2512905 2512905 defendant Shepard Robert husbandman 594819 594819 Shepard, Robert, of Quaplod, husbandman 1
5526664 2512906 2512906 defendant Skarlet Robert yeoman 594819 594819 Skarlet, Robert, of Quaplod, yeoman 0
5526665 2512906 2512906 defendant Shepard Robert husbandman 594819 594819 Shepard, Robert, of Quaplod, husbandman 1

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