names

412 rows where place_id = 605288

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3661050 1913730 1913730 defendant Gentilman Lawrence tailor 605288 605288 Gentilman, Lawrence, of Maidstone, tailor 0
3661051 1913730 1913730 defendant Jacobbe John smith 605288 605288 Jacobbe, John, of Maidstone, smith 1
3661052 1913730 1913730 defendant Dawson William sadler 605288 605288 Dawson, William, of Maidstone, sadler 2
3661053 1913730 1913730 defendant Wykham William tailor 605288 605288 Wykham, William, of Maidstone, tailor 3
3661054 1913730 1913730 defendant Haynys John carpenter 605288 605288 Haynys, John, of Maidstone, carpenter 4
3674379 1918032 1918032 defendant Kyng William yeoman 605288 605288 Kyng, William, of Maidstone, yeoman 0
3891742 1987492 1987492 defendant Mascall Henry laborer 605288 605288 Mascall, Henry, of Maidstone, laborer 0
3940205 2003741 2003741 defendant Robynson Robert yeoman 605288 605288 Robynson, Robert, of Maidstone, yeoman 2
4297716 2129288 2129288 defendant Hayward John grocer 605288 605288 Hayward, John, of Maidstone, grocer 0
4311187 2134060 2134060 defendant Broade William shoemaker 605288 605288 Broade, William, of Maidstone, shoemaker 0
4412215 2168678 2168678 defendant Dubble Richard laborer 605288 605288 Dubble, Richard, of Maidstone, laborer 1
4415113 2169629 2169629 plaintiff Gillyngham James de (legal representative) 605288 605288 Gillyngham, James de, of Maidstone, executors of 0
4415114 2169629 2169629 plaintiff Gillyngham John de   605288 605288 (Gillyngham, John de, of Maidstone, son of James 1
4415116 2169629 2169629 defendant Ryvet John   605288 605288 Ryvet, John, of Maidstone 0
4435143 2175757 2175757 defendant Linen draper Nicholas   605288 605288 Linen draper, Nicholas, of Maidstone 0
4451691 2185501 2185501 defendant Hestangre John   605288 605288 Hestangre, John, of Maidstone 1
4458048 2187545 2187545 defendant Sharp John   605288 605288 Sharp, John, of Maidstone 4
4481630 2194949 2194949 defendant Bakere John   605288 605288 Bakere, John, of Maidstone 3
4485910 2196298 2196298 defendant Lattere Robert legger 605288 605288 Lattere, Robert, of Maidstone, legger 3
4493355 2198624 2198624 defendant Clement John   605288 605288 Clement, John, of Maidstone 2
4493358 2198625 2198625 defendant Prynce John   605288 605288 Prynce, John, of Maidstone 0
4493795 2198753 2198753 defendant Gaurder John   605288 605288 Gaurder, John, of Maidstone 0
4498337 2200138 2200138 defendant Gosse Andrew   605288 605288 Gosse, Andrew, of Maidstone 0
4505256 2202174 2202174 defendant Bounde Thomas   605288 605288 Bounde, Thomas, of Maidstone 0
4508017 2202977 2202977 defendant Westcote John   605288 605288 Westcote, John, of Maidstone 1
4511189 2203946 2203946 defendant Marchall John   605288 605288 Marchall, John, of Maidstone 0
4514723 2205021 2205021 defendant Gourder John   605288 605288 Gourder, John, of Maidstone 1
4516067 2205440 2205440 defendant Fuller William carpenter 605288 605288 Fuller, William, of Maidstone, carpenter 0
4522313 2207325 2207325 defendant Courder John   605288 605288 Courder, John, of Maidstone 0
4522329 2207331 2207331 plaintiff Gravele William   605288 605288 Gravele, William, of Maidstone 0
4524265 2207925 2207925 defendant Godyn John   605288 605288 Godyn, John, of Maidstone 0
4524335 2207948 2207948 defendant Godyn John   605288 605288 Godyn, John, of Maidstone 0
4527637 2208924 2208924 defendant Bounde Thomas   605288 605288 Bounde, Thomas, of Maidstone 0
4529215 2209416 2209416 defendant Sadeler Michael   605288 605288 Sadeler, Michael, of Maidstone 0
4529810 2209608 2209608 defendant Wescote John   605288 605288 Wescote, John, of Maidstone, mason 0
4532338 2210380 2210380 defendant Barry John   605288 605288 Barry, John, of Maidstone 3
4534972 2211218 2211218 defendant Worthe William   605288 605288 Worthe, William, of Maidstone 0
4537861 2212125 2212125 defendant Wotton John master of All Saints college 605288 605288 Wotton, John, of Maidstone, master of All Saints college 0
4543494 2213854 2213854 defendant Helman William   605288 605288 Helman, William, of Maidstone 0
4545777 2214607 2214607 defendant Westcote Thomas   605288 605288 Westcote, Thomas, of Maidstone, mason 0
4549567 2215808 2215808 defendant Taillour John   605288 605288 Taillour, John, of Maidstone 0
4550583 2216127 2216127 plaintiff Dedyr Thomas   605288 605288 Dedyr, Thomas, of Maidstone 0
4551579 2216435 2216435 plaintiff Dyne John   605288 605288 Dyne, John, of Maidstone 0
4551580 2216435 2216435 plaintiff Grygge William   605288 605288 Grygge, William, of Maidstone 1
4551581 2216435 2216435 defendant Helman William   605288 605288 Helman, William, of Maidstone 0
4551582 2216435 2216435 defendant Glover Thomas   605288 605288 Glover, Thomas, of Maidstone 1
4559040 2218787 2218787 defendant Fyssher William   605288 605288 Fyssher, William, of Maidstone 0
4560328 2219169 2219169 defendant Brayles Henry   605288 605288 Brayles, Henry, of Maidstone 0
4560329 2219169 2219169 defendant Lundeneys William   605288 605288 Lundeneys, William, of Maidstone 1
4563322 2220100 2220100 defendant Elys Richard   605288 605288 Elys, Richard, of Maidstone 0
4563577 2220173 2220173 defendant atte Wode Lawrence   605288 605288 atte Wode, Lawrence, of Maidstone, mason 0
4572666 2222990 2222990 defendant Whilok Richard   605288 605288 Whilok, Richard, of Maidstone 0
4574155 2223441 2223441 defendant Glovere Roger mower 605288 605288 Glovere, Roger, of Maidstone, mower 0
4576251 2224075 2224075 defendant Wyke Thomas   605288 605288 Wyke, Thomas, of Maidstone 0
4578887 2224877 2224877 defendant Bounde Thomas   605288 605288 Bounde, Thomas, of Maidstone 4
4578893 2224878 2224878 defendant Bounde Thomas   605288 605288 Bounde, Thomas, of Maidstone 4
4579852 2225184 2225184 plaintiff Crophell John   605288 605288 Crophell, John, of Maidstone 0
4579853 2225184 2225184 defendant Reve Peter   605288 605288 Reve, Peter, of Maidstone 0
4581671 2225714 2225714 plaintiff Dyn John skinner 605288 605288 Dyn, John, of Maidstone, skinner 0
4581679 2225716 2225716 plaintiff Fyssher William   605288 605288 Fyssher, William, of Maidstone 1
4583510 2226266 2226266 defendant Longe Peter   605288 605288 Longe, Peter, of Maidstone 0
4583708 2226318 2226318 plaintiff Fullere John   605288 605288 Fullere, John, of Maidstone 0
4585871 2227002 2227002 defendant Ferrour John shoemaker 605288 605288 Ferrour, John, of Maidstone, shoemaker 0
4585936 2227026 2227026 defendant Taverner John   605288 605288 Taverner, John, of Maidstone 0
4590326 2228337 2228337 plaintiff Mallyng William jeweler 605288 605288 Mallyng, William, of Maidstone, jeweler 0
4593700 2229303 2229303 defendant Helman John   605288 605288 Helman, John, of Maidstone 1
4593701 2229303 2229303 defendant Gravene Thomas   605288 605288 Gravene, Thomas, of Maidstone 2
4593702 2229303 2229303 defendant Helman Richard   605288 605288 Helman, Richard, of Maidstone 3
4593703 2229303 2229303 defendant Curteys Richard   605288 605288 Curteys, Richard, of Maidstone 4
4595119 2229729 2229729 defendant Spicer John   605288 605288 Spicer, John, of Maidstone 1
4595851 2229958 2229958 defendant atte Wode Lawrence   605288 605288 atte Wode, Lawrence, of Maidstone, mason 0
4595852 2229958 2229958 defendant Lowyn Simon   605288 605288 Lowyn, Simon, of Maidstone, mason 1
4597798 2230564 2230564 defendant Reve John   605288 605288 Reve, John, of Maidstone 0
4597799 2230564 2230564 defendant Stile William   605288 605288 Stile, William, of Maidstone 1
4598121 2230660 2230660 defendant Kyng John   605288 605288 Kyng, John, of Maidstone 5
4601909 2231823 2231823 plaintiff Warbylton William   605288 605288 Warbylton, William, of Maidstone 0
4603868 2232394 2232394 plaintiff Wyke Thomas   605288 605288 Wyke, Thomas, of Maidstone 0
4607472 2233445 2233445 defendant Cokeman Bartholomew   605288 605288 Cokeman, Bartholomew, of Maidstone 0
4608429 2233745 2233745 defendant Corder John draper 605288 605288 Corder, John, of Maidstone, draper 0
4608844 2233867 2233867 defendant Reve John (legal representative) 605288 605288 Reve, John, of Maidstone, executors of 0
4610502 2234356 2234356 defendant Cokman Bartholomew tanner 605288 605288 Cokman, Bartholomew, of Maidstone, tanner 0
4615141 2235744 2235744 defendant Gorder John   605288 605288 Gorder, John, of Maidstone 0
4615142 2235744 2235744 defendant Myles John   605288 605288 Myles, John, of Maidstone 1
4615147 2235745 2235745 defendant Gorder John   605288 605288 Gorder, John, of Maidstone 0
4616845 2236271 2236271 defendant Chyld John   605288 605288 Chyld, John, of Maidstone 1
4618349 2236748 2236748 defendant Erdegrove Thomas   605288 605288 Erdegrove, Thomas, of Maidstone 1
4619089 2236965 2236965 defendant Melle John   605288 605288 Melle, John, of Maidstone 0
4619477 2237083 2237083 defendant Gourdere John   605288 605288 Gourdere, John, of Maidstone 2
4625376 2238902 2238902 defendant Gourdare John   605288 605288 Gourdare, John, of Maidstone 0
4625378 2238903 2238903 defendant Gourdare John   605288 605288 Gourdare, John, of Maidstone 0
4626493 2239235 2239235 defendant Sporier William   605288 605288 Sporier, William, of Maidstone 0
4628367 2239797 2239797 defendant Milis John   605288 605288 Milis, John, of Maidstone 0
4628369 2239798 2239798 defendant Verne John   605288 605288 Verne, John, of Maidstone 0
4629404 2240126 2240126 defendant Milys John   605288 605288 Milys, John, of Maidstone 2
4631083 2240617 2240617 defendant Courdere John draper 605288 605288 Courdere, John, of Maidstone, draper 0
4638356 2242764 2242764 defendant Propchaunt Bartholomew   605288 605288 Propchaunt, Bartholomew, of Maidstone, son of Richard 0
4638627 2242833 2242833 defendant Gebell John   605288 605288 Gebell, John, of Maidstone 0
4638629 2242834 2242834 defendant Gebell John   605288 605288 Gebell, John, of Maidstone 0
4644091 2244370 2244370 defendant Gerowede Thomas   605288 605288 Gerowede, Thomas, of Maidstone 1
4649162 2245805 2245805 defendant Cogman Bartholomew   605288 605288 Cogman, Bartholomew, of Maidstone 0

Next page

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