names

90 rows where place_id = 618854

✎ 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
3726749 1934632 1934632 defendant Glover Thomas husbandman 618854 618854 Glover, Thomas, of Salthous, husbandman 0
3746171 1940709 1940709 defendant Garrard Avellin widow 618854 618854 Garrard, Avellin, of Salthous, widow 1
3845377 1972115 1972115 defendant Bakby Alice widow 618854 618854 Bakby, Alice, of Salthous, widow 2
3943283 2004773 2004773 defendant Bartylmewe John mariner 618854 618854 Bartylmewe, John, of Salthous, mariner 1
4063927 2047381 2047381 defendant Howsego John shipman 618854 618854 Howsego, John, of Salthous, shipman 0
4353644 2148495 2148495 defendant Tompson Peter mariner 618854 618854 Tompson, Peter, of Salthous, mariner 0
4415965 2169880 2169880 defendant Fayrman John   618854 618854 Fayrman, John, of Salthous 0
4441068 2182132 2182132 defendant atte Hill Nicholas   618854 618854 atte Hill, Nicholas, of Salthous 0
4442893 2182736 2182736 defendant Gybbes John   618854 618854 Gybbes, John, of Salthous 0
4486103 2196351 2196351 defendant Crode John   618854 618854 Crode, John, of Salthous 27
4505125 2202135 2202135 defendant Coupere Thomas   618854 618854 Coupere, Thomas, of Salthous 0
4505126 2202135 2202135 defendant Bynoll Robert   618854 618854 Bynoll, Robert, of Salthous 1
4505127 2202135 2202135 defendant Hickes John   618854 618854 Hickes, John, of Salthous 2
4505128 2202136 2202136 plaintiff Skryvener William (legal representative) 618854 618854 Skryvener, William, of Salthous, executors of 0
4547291 2215087 2215087 plaintiff Busk John   618854 618854 Busk, John, of Salthous 0
4547292 2215087 2215087 defendant Robyns Robert shipman 618854 618854 Robyns, Robert, of Salthous, shipman 0
4547293 2215087 2215087 defendant Robynes William fishman 618854 618854 Robynes, William, of Salthous, fishman 1
4553460 2217010 2217010 defendant Pynnyng John   618854 618854 Pynnyng, John, of Salthous 2
4565996 2220917 2220917 defendant atte Boure Lawrence   618854 618854 atte Boure, Lawrence, of Salthous 0
4605846 2232941 2232941 defendant Coteler Lawrence   618854 618854 Coteler, Lawrence, of Salthous 3
4609825 2234166 2234166 plaintiff Bussh John   618854 618854 Bussh, John, of Salthous 0
4620248 2237316 2237316 defendant Crosse John   618854 618854 Crosse, John, of Salthous 0
4620249 2237316 2237316 defendant Leche William   618854 618854 Leche, William , of Salthous 1
4620250 2237316 2237316 defendant Soutere John   618854 618854 Soutere, John, of Salthous 2
4622245 2237939 2237939 defendant Phelippes Thomas   618854 618854 Phelippes, Thomas, of Salthous 0
4624728 2238714 2238714 defendant Busshe John   618854 618854 Busshe, John, of Salthous 6
4698355 2264965 2264965 defendant Paston Robert (legal representative) 618854 618854 Paston, Robert, of Salthous, shipman, executors of 0
4698357 2264965 2264965 defendant Haukyn Thomas shipman 618854 618854 Haukyn, Thomas, of Salthous, shipman 2
4730520 2274744 2274744 defendant Coteler Lawrence husbandman 618854 618854 Coteler, Lawrence, of Salthous, husbandman 3
4747813 2279868 2279868 plaintiff Lent Philip   618854 618854 Lent, Philip, of Salthous, on his own account 0
4761359 2283896 2283896 defendant Lekere Edmund   618854 618854 Lekere, Edmund, of Salthous, parson 1
4765740 2285280 2285280 defendant Leker Edmund   618854 618854 Leker, Edmund, of Salthous, parson 0
4766503 2285515 2285515 defendant Boure Laurence husbandman 618854 618854 Boure, Laurence, of Salthous, husbandman 0
4790909 2293248 2293248 defendant Boure Lawrence husbandman 618854 618854 Boure, Lawrence, of Salthous, husbandman 0
4892223 2324312 2324312 defendant Pynchebek Richard husbandman 618854 618854 Pynchebek, Richard, of Salthous, husbandman 0
4893569 2324691 2324691 defendant Pynchebek Richard   618854 618854 Pynchebek, Richard, of Salthous, bailiff 0
4893570 2324691 2324691 defendant Wryght Roger husbandman 618854 618854 Wryght, Roger, of Salthous, husbandman 1
4893571 2324691 2324691 defendant Charles Roger husbandman 618854 618854 Charles, Roger, of Salthous, husbandman 2
4893572 2324691 2324691 defendant Walsham William husbandman 618854 618854 Walsham, William, of Salthous, husbandman 3
4893573 2324691 2324691 defendant Couper William husbandman 618854 618854 Couper, William, of Salthous, husbandman 4
4897851 2325990 2325990 defendant Hagon Thomas yeoman 618854 618854 Hagon, Thomas, of Salthous, yeoman 0
4897853 2325991 2325991 defendant Londe Philip yeoman 618854 618854 Londe, Philip, of Salthous, yeoman 0
4901158 2326979 2326979 defendant Groom John husbandman 618854 618854 Groom, John, of Salthous, husbandman 2
4931536 2336246 2336246 defendant Gilham Henry husbandman 618854 618854 Gilham, Henry, of Salthous, husbandman 0
4933994 2337013 2337013 defendant Yerdesley William weaver 618854 618854 Yerdesley, William, of Salthous, weaver 0
4933995 2337013 2337013 defendant Sporell William shoemaker 618854 618854 Sporell, William, of Salthous, shoemaker 1
4933996 2337013 2337013 defendant atte Style John husbandman 618854 618854 atte Style, John, of Salthous, husbandman 2
4943011 2339788 2339788 defendant Forster William yeoman 618854 618854 (Forster, William, of Salthous, yeoman 5
4949899 2341945 2341945 defendant Albon Robert smith 618854 618854 Albon, Robert, of Salthous, smith 3
4953845 2343112 2343112 defendant Byrlyngham Godwin husbandman 618854 618854 Byrlyngham, Godwin, of Salthous, husbandman 1
4963401 2345962 2345962 defendant Albon Robert smith 618854 618854 Albon, Robert, of Salthous, smith 1
4979425 2350800 2350800 defendant Pynchebek Richard husbandman 618854 618854 Pynchebek, Richard, of Salthous, husbandman 0
4998542 2356447 2356447 plaintiff Kellowe John spicer 618854 618854 Kellowe, John, of Salthous, spicer 0
4998543 2356447 2356447 defendant Stacy Robert tailor 618854 618854 Stacy, Robert, of Salthous, tailor 0
5008661 2359426 2359426 defendant Pynchebek Richard yeoman 618854 618854 Pynchebek, Richard, of Salthous, yeoman 3
5018014 2362151 2362151 defendant Charlys Robert yeoman 618854 618854 Charlys, Robert, of Salthous, yeoman 0
5025497 2364358 2364358 defendant Clyppysby Richard shipman 618854 618854 Clyppysby, Richard, of Salthous, shipman 0
5025498 2364359 2364359 plaintiff Kellowe John   618854 618854 Kellowe, John, of Salthous 0
5133051 2396152 2396152 defendant Brome John husbandman 618854 618854 Brome, John, of Salthous, husbandman 2
5139899 2398151 2398151 defendant Wright Roger husbandman 618854 618854 Wright, Roger, of Salthous, husbandman 0
5139900 2398151 2398151 defendant Gilham Henry husbandman 618854 618854 Gilham, Henry, of Salthous, husbandman 1
5139901 2398151 2398151 defendant Baker Thomas husbandman 618854 618854 Baker, Thomas, of Salthous, husbandman 2
5142984 2399073 2399073 plaintiff Yerdle William   618854 618854 Yerdle, William, of Salthous 0
5160917 2404297 2404297 defendant Wright Roger husbandman 618854 618854 Wright, Roger, of Salthous, husbandman 0
5160918 2404297 2404297 defendant Gilham Henry husbandman 618854 618854 Gilham, Henry, of Salthous, husbandman 1
5160919 2404297 2404297 defendant Baker Thomas husbandman 618854 618854 Baker, Thomas, of Salthous, husbandman 2
5175533 2408527 2408527 defendant Wright Roger husbandman 618854 618854 Wright, Roger, of Salthous, husbandman 0
5175534 2408527 2408527 defendant Gille Henry husbandman 618854 618854 Gille, Henry, of Salthous, husbandman 1
5175535 2408527 2408527 defendant Baker Thomas husbandman 618854 618854 Baker, Thomas, of Salthous, husbandman 2
5198919 2415437 2415437 defendant Gylham Henry shipman 618854 618854 Gylham, Henry, of Salthous, shipman 1
5246662 2429182 2429182 defendant Wryght Roger yeoman 618854 618854 Wryght, Roger, of Salthous, yeoman 4
5250187 2430171 2430171 defendant Gylham alias Herrys Henry husbandman 618854 618854 Gylham alias Herrys, Henry, of Salthous, husbandman 0
5259880 2433213 2433213 defendant Redell Thomas gent 618854 618854 Redell, Thomas, of Salthous, gent 0
5276184 2438109 2438109 defendant Erle Richard (legal representative) 618854 618854 Erle, Richard, of Salthous, yeoman, executors of 0
5276185 2438109 2438109 defendant Erle Cecilia widow 618854 618854 (Erle, Cecilia, of Salthous, widow 1
5276186 2438109 2438109 defendant Par John yeoman 618854 618854 Par, John, of Salthous, yeoman 2
5319604 2450957 2450957 defendant Vans or Vaus Thomas yeoman 618854 618854 Vans or Vaus, Thomas, of Salthous, yeoman 0
5333333 2455041 2455041 defendant Redell Thomas gent 618854 618854 Redell, Thomas, of Salthous, gent 0
5343411 2458129 2458129 defendant Symondys Robert shoemaker 618854 618854 Symondys, Robert, of Salthous, shoemaker 1
5344765 2458531 2458531 plaintiff Vaus Thomas   618854 618854 Vaus, Thomas, of Salthous 0
5355626 2461835 2461835 defendant Vaus or Vans Thomas yeoman 618854 618854 Vaus or Vans, Thomas, of Salthous, yeoman 0
5371671 2466728 2466728 defendant Parre Thomas shoemaker 618854 618854 Parre, Thomas, of Salthous, shoemaker 1
5394697 2473542 2473542 defendant Rodell Katherine widow 618854 618854 Rodell, Katherine, of Salthous, widow 6
5407934 2477346 2477346 defendant Redell Katherine widow 618854 618854 Redell, Katherine, of Salthous, widow 6
5446593 2488869 2488869 defendant Symondys Robert shoemaker 618854 618854 Symondys, Robert, of Salthous, shoemaker 1
5458034 2492304 2492304 defendant Symondys Robert shoemaker 618854 618854 Symondys, Robert, of Salthous, shoemaker 1
5550626 2520207 2520207 defendant Baret Robert husbandman 618854 618854 Baret, Robert, of Salthous, husbandman 0
5550634 2520209 2520209 defendant Barett Robert husbadman 618854 618854 Barett, Robert, of Salthous, husbadman 1
5621122 2550490 2550490 plaintiff Spoo William   618854 618854 Spoo, William, of Salthous 0
5632736 2554253 2554253 defendant Wychyngham Roger clerk 618854 618854 Wychyngham, Roger, of Salthous, clerk 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);