names

88 rows where place_id = 622670

✎ 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
3748311 1941401 1941401 defendant Goderham James husbandman 622670 622670 Goderham, James, of Kenynghale, husbandman 0
3759411 1944933 1944933 defendant Brandon John husbandman 622670 622670 Brandon, John, of Kenynghale, husbandman 0
3759643 1945004 1945004 defendant Goderam James husbandman 622670 622670 Goderam, James, of Kenynghale, husbandman 0
3769393 1948084 1948084 defendant Goderham James husbandman 622670 622670 Goderham, James, of Kenynghale, husbandman 2
3797648 1957160 1957160 defendant Grey John   622670 622670 Grey, John, of Kenynghale, rough mason 1
3811785 1961586 1961586 defendant Brandon John husbandman 622670 622670 Brandon, John, of Kenynghale, husbandman 0
3811787 1961587 1961587 defendant Gooderam James husbandman 622670 622670 Gooderam, James, of Kenynghale, husbandman 0
3846521 1972469 1972469 defendant Brandon John husbandman 622670 622670 Brandon, John, of Kenynghale, husbandman 2
3889133 1986601 1986601 defendant Husee Thomas esq 622670 622670 Husee, Thomas, of Kenynghale, esq 0
3889456 1986704 1986704 plaintiff Goodram James   622670 622670 Goodram, James, of Kenynghale 0
3890991 1987248 1987248 defendant Wyndam Thomas gent 622670 622670 Wyndam, Thomas, of Kenynghale, gent 2
3900403 1990367 1990367 defendant Browne Thomas yeoman 622670 622670 Browne, Thomas, of Kenynghale, yeoman 0
3903472 1991386 1991386 defendant Towneshend Richard esq 622670 622670 Towneshend, Richard, of Kenynghale, esq 0
3939530 2003525 2003525 defendant Gotherham William husbandman 622670 622670 Gotherham, William, of Kenynghale, husbandman 2
3948335 2006480 2006480 defendant Gotheram James yeoman 622670 622670 Gotheram, James, of Kenynghale, yeoman 0
3970796 2014376 2014376 defendant Typtotte John husbandman 622670 622670 Typtotte, John, of Kenynghale, husbandman 0
3970797 2014376 2014376 defendant Haylock Thomas husbandman 622670 622670 Haylock, Thomas, of Kenynghale, or of Dysse Haywood, husbandman 1
3970798 2014376 2014376 defendant Hill Simon carpenter 622670 622670 Hill, Simon, of Kenynghale, carpenter 2
3970799 2014376 2014376 defendant Dene John weaver 622670 622670 Dene, John, of Kenynghale, weaver 3
3972782 2015053 2015053 defendant Prentyse William yeoman 622670 622670 Prentyse, William, of Kenynghale, yeoman 0
3972872 2015084 2015084 defendant Browne Robert   622670 622670 Browne, Robert, of Kenynghale, pump maker 3
3980827 2017906 2017906 defendant Dowe John yeoman 622670 622670 Dowe, John, of Kenynghale, yeoman 1
3980828 2017906 2017906 defendant Randis alias Osborne William yeoman 622670 622670 Randis alias Osborne, William, of Kenynghale, yeoman 2
4182148 2089233 2089233 defendant Dalton John clerk 622670 622670 Dalton, John, of Kenynghale, clerk 2
4494312 2198912 2198912 defendant Noble Adam   622670 622670 Noble, Adam, of Kenynghale 1
4625453 2238922 2238922 defendant Sket John   622670 622670 Sket, John, of Kenynghale 0
4645993 2244900 2244900 defendant Skeet John   622670 622670 Skeet, John, of Kenynghale 3
4657381 2248200 2248200 defendant Poule John yeoman 622670 622670 Poule, John, of Kenynghale, yeoman 1
4671524 2256740 2256740 defendant Cook John husbandman 622670 622670 Cook, John, of Kenynghale, husbandman 0
4677491 2258573 2258573 defendant Kyng Walter husbandman 622670 622670 Kyng, Walter, of Kenynghale, husbandman 0
4688615 2262002 2262002 defendant Lystere Robert husbandman 622670 622670 Lystere, Robert, of Kenynghale, husbandman 1
4688616 2262002 2262002 defendant Bateman William husbandman 622670 622670 Bateman, William, of Kenynghale, husbandman 2
4720770 2271828 2271828 defendant Benet John husbandman 622670 622670 Benet, John, of Kenynghale, husbandman 0
4737668 2276889 2276889 defendant Cook John yeoman 622670 622670 Cook, John, of Kenynghale, yeoman 1
4755234 2282025 2282025 defendant Goodsweyn John yeoman 622670 622670 Goodsweyn, John, of Kenynghale, yeoman 0
4755235 2282025 2282025 defendant Goodsweyn Richard   622670 622670 Goodsweyn, Richard, of Kenynghale, groom 1
4807470 2298530 2298530 plaintiff Coke John   622670 622670 Coke, John, of Kenynghale 0
4809219 2299057 2299057 defendant Warner Robert tailor 622670 622670 Warner, Robert, of Kenynghale, tailor 4
4842964 2309342 2309342 defendant Broun Henry spicer 622670 622670 Broun, Henry, of Kenynghale, spicer 0
4879989 2320654 2320654 defendant Cook John yeoman 622670 622670 Cook, John, of Kenynghale, yeoman 3
4889750 2323588 2323588 defendant Underwode William husbandman 622670 622670 Underwode, William, of Kenynghale, husbandman 3
4900138 2326669 2326669 defendant Shirme John yeoman 622670 622670 Shirme, John, of Kenynghale, yeoman 3
4900863 2326901 2326901 defendant Dobbys Robert   622670 622670 Dobbys, Robert, of Kenynghale, mason 0
4929532 2335649 2335649 defendant Coke John husbandman 622670 622670 Coke, John, of Kenynghale, husbandman 0
4938808 2338529 2338529 defendant Cook John yeoman 622670 622670 Cook, John, of Kenynghale, yeoman 0
4993233 2354855 2354855 defendant Cook John yeoman 622670 622670 Cook, John, of Kenynghale, yeoman 5
4998217 2356335 2356335 defendant Nobbys John husbandman 622670 622670 Nobbys, John, of Kenynghale, husbandman 0
5003566 2357936 2357936 defendant Glede Wedewer_ John husbandman 622670 622670 Glede Wedewer_, John, of Kenynghale, husbandman 11
5082487 2381263 2381263 defendant Bawe Robert butcher 622670 622670 Bawe, Robert, of Kenynghale, butcher 0
5202487 2416489 2416489 defendant Woderove John weaver 622670 622670 Woderove, John, of Kenynghale, weaver 0
5226043 2423287 2423287 plaintiff Snethe John   622670 622670 Snethe, John, of Kenynghale 0
5240000 2427275 2427275 defendant Bredok John laborer 622670 622670 Bredok, John, of Kenynghale, laborer 0
5289224 2441853 2441853 defendant Davy John engraver 622670 622670 Davy, John, of Kenynghale, engraver 0
5296878 2444077 2444077 defendant Sare John laborer 622670 622670 Sare, John, of Kenynghale, laborer 1
5308501 2447578 2447578 defendant Sare John husbandman 622670 622670 Sare, John, of Kenynghale, husbandman 0
5308502 2447578 2447578 defendant Bawe Thomas laborer 622670 622670 Bawe, Thomas, of Kenynghale, laborer 1
5325217 2452632 2452632 defendant Osberne John, senior singleman 622670 622670 Osberne, John, senior, of Kenynghale, husbandman, singleman 0
5325221 2452633 2452633 defendant Osberne John, senior singleman 622670 622670 Osberne, John, senior, of Kenynghale, husbandman, singleman 0
5325225 2452634 2452634 defendant Osberne John, senior husbandman 622670 622670 Osberne, John, senior, of Kenynghale, husbandman 0
5332033 2454657 2454657 defendant Prynchet John husbandman 622670 622670 Prynchet, John, of Kenynghale, husbandman 2
5339411 2456897 2456897 defendant Austyn William yeoman 622670 622670 Austyn, William, of Kenynghale, yeoman 0
5339412 2456897 2456897 defendant Prenchitte John weaver 622670 622670 Prenchitte, John, of Kenynghale, weaver 1
5341652 2457585 2457585 defendant Smyth Richard husbandman 622670 622670 Smyth, Richard, of Kenynghale, husbandman 0
5341653 2457585 2457585 defendant Bolle Richard husbandman 622670 622670 Bolle, Richard, of Kenynghale, husbandman 1
5341654 2457585 2457585 defendant Thirlowe John husbandman 622670 622670 Thirlowe, John, of Kenynghale, husbandman 2
5341655 2457585 2457585 defendant Basse John husbandman 622670 622670 Basse, John, of Kenynghale, husbandman 3
5341656 2457585 2457585 defendant Lyche John husbandman 622670 622670 Lyche, John, of Kenynghale, husbandman 4
5341657 2457585 2457585 defendant Sare John husbandman 622670 622670 Sare, John, of Kenynghale, husbandman 5
5347607 2459407 2459407 defendant Prynchet John weaver 622670 622670 Prynchet, John, of Kenynghale, weaver 0
5347608 2459407 2459407 defendant Austyn William yeoman 622670 622670 Austyn, William, of Kenynghale, yeoman 1
5349647 2460024 2460024 defendant Austyn William husbandman 622670 622670 Austyn, William, of Kenynghale, husbandman 2
5349648 2460024 2460024 defendant Prynchet John yeoman 622670 622670 Prynchet, John, of Kenynghale, yeoman 3
5363611 2464274 2464274 defendant Prynchet John weaver 622670 622670 Prynchet, John, of Kenynghale, weaver 0
5365206 2464790 2464790 defendant Ede Thomas husbandman 622670 622670 Ede, Thomas, of Kenynghale, husbandman 1
5369541 2466060 2466060 defendant Boole Richard yeoman 622670 622670 Boole, Richard, of Kenynghale, yeoman 0
5369545 2466061 2466061 defendant Boole Richard yeoman 622670 622670 Boole, Richard, of Kenynghale, yeoman 0
5371156 2466565 2466565 defendant Bold John mercer 622670 622670 Bold, John, of Kenynghale, mercer 2
5434923 2485378 2485378 defendant Prynchell John clothmaker 622670 622670 Prynchell, John, of Kenynghale, clothmaker 0
5440079 2486937 2486937 defendant Prenget John husbandman 622670 622670 Prenget, John, of Kenynghale, husbandman 1
5440081 2486937 2486937 defendant Hoddys Alexander butcher 622670 622670 Hoddys, Alexander, of Kenynghale, butcher 3
5440082 2486937 2486937 defendant Bawe William butcher 622670 622670 Bawe, William, of Kenynghale, butcher 4
5450155 2489933 2489933 defendant Prynchat John   622670 622670 Prynchat, John, of Kenynghale, cloth maker 0
5462331 2493635 2493635 defendant Prynchat John clothmaker 622670 622670 Prynchat, John, of Kenynghale, clothmaker 0
5462334 2493636 2493636 defendant Prynchat John clothmaker 622670 622670 Prynchat, John, of Kenynghale, clothmaker 0
5481374 2499365 2499365 defendant Boole Richard mercer 622670 622670 Boole, Richard, of Kenynghale, mercer 1
5484319 2500231 2500231 defendant Aystyn William yeoman 622670 622670 Aystyn, William, of Kenynghale, yeoman 0
5485367 2500537 2500537 defendant Colford John fuller 622670 622670 Colford, John, of Kenynghale, fuller 3
5627123 2552450 2552450 defendant Aleyn Robert chaplain 622670 622670 Aleyn, Robert, of Kenynghale, chaplain 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);