names

136 rows where place_id = 781252

✎ 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
4630943 2240568 2240568 defendant Kynveton Thomas   781252 781252 Kynveton, Thomas, of Derbs 2
4671901 2256858 2256858 defendant Stokkes Ellis merchant 781252 781252 Stokkes, Ellis, of Derby, Derbs, merchant 2
4697865 2264828 2264828 defendant Gerard John chapman 781252 781252 Gerard, John, of Derby, Derbs, chapman 3
4697871 2264829 2264829 defendant Gerard John chapman 781252 781252 Gerard, John, of Derby, Derbs, chapman 3
4702084 2266060 2266060 defendant West William draper 781252 781252 West, William, of Derby, Derbs, draper 0
4702086 2266061 2266061 defendant West William draper 781252 781252 West, William, of Derby, Derbs, draper 0
4703922 2266603 2266603 defendant Shene John tanner 781252 781252 Shene, John, of Derby, Derbs, tanner 0
4703924 2266604 2266604 defendant Shene John tanner 781252 781252 Shene, John, of Derby, Derbs, tanner 0
4705864 2267208 2267208 defendant Sparham John husbandman 781252 781252 Sparham, John, of Derby, Derbs, husbandman 0
4705868 2267210 2267210 defendant Sparham John husbandman 781252 781252 Sparham, John, of Derby, Derbs, husbandman 0
4706295 2267350 2267350 defendant Taverner John taverner 781252 781252 Taverner, John, of Derby, Derbs, taverner 1
4707278 2267653 2267653 defendant Rameshede William chaplain 781252 781252 Rameshede, William, of Derby, Derbs, chaplain 4
4708782 2268117 2268117 defendant Melburn William gent 781252 781252 Melburn, William, of Derby, Derbs, gent 0
4710938 2268776 2268776 defendant Middelton John skinner 781252 781252 Middelton, John, of Derby, Derbs, skinner 0
4711242 2268867 2268867 defendant Prentys John miller 781252 781252 Prentys, John, of Derby, Derbs, miller 0
4721506 2272056 2272056 defendant Toweke Thomas gent 781252 781252 Toweke, Thomas, of Derby, Derbs, gent 0
4721508 2272057 2272057 defendant Towele John gent 781252 781252 Towele, John, of Derby, Derbs, gent 0
4730283 2274676 2274676 defendant Wolley Roger draper 781252 781252 Wolley, Roger, of Derby, Derbs, draper 0
4756547 2282410 2282410 defendant Gerard Adam cutler 781252 781252 Gerard, Adam, of Derby, Derbs, cutler 4
4765704 2285268 2285268 defendant Irlande Robert esq 781252 781252 Irlande, Robert, of Derby, Derbs, esq 0
4769000 2286281 2286281 defendant Tamworth Richard fishmonger 781252 781252 Tamworth, Richard, of Derby, Derbs, fishmonger 1
4772241 2287290 2287290 defendant Latoner Robert latoner 781252 781252 Latoner, Robert, of Derby, Derbs, latoner 3
4783644 2290901 2290901 plaintiff de la Pole Peter   781252 781252 de la Pole, Peter, of Derbs 0
4803054 2297141 2297141 defendant Tymburley Richard merchant 781252 781252 Tymburley, Richard, of Derby, Derbs, merchant 0
4806958 2298379 2298379 defendant Walton Thomas merchant 781252 781252 Walton, Thomas, of Derby, Derbs, merchant 0
4810382 2299395 2299395 defendant Spycer William chapman 781252 781252 Spycer, William, of Derby, Derbs, chapman 0
4813630 2300369 2300369 defendant Roberd Thomas   781252 781252 Roberd, Thomas, of Derby, Derbs, brass worker 0
4813634 2300370 2300370 defendant Ryche John dyer 781252 781252 Ryche, John, of Derby, Derbs, dyer 0
4814221 2300552 2300552 defendant Brynne John   781252 781252 Brynne, John, of Derby, Derbs, brass worker 2
4814226 2300553 2300553 defendant Brynne John   781252 781252 Brynne, John, of Derby, Derbs, brass worker 2
4814307 2300580 2300580 defendant Robert Thomas   781252 781252 Robert, Thomas, of Derby, Derbs, brass worker 0
4814862 2300759 2300759 defendant Irland Robert gent 781252 781252 Irland, Robert, of Derby, Derbs, gent 0
4820224 2302396 2302396 defendant Nounde Robert chapman 781252 781252 Nounde, Robert, of Derby, Derbs, chapman 0
4821422 2302783 2302783 defendant Topclyf John merchant 781252 781252 Topclyf, John, of Derby, Derbs, merchant 0
4826875 2304443 2304443 defendant Tykhull John spicer 781252 781252 Tykhull, John, of Derby, Derbs, spicer 3
4827273 2304579 2304579 defendant Tykhull John spicer 781252 781252 Tykhull, John, of Derby, Derbs, spicer 3
4827461 2304638 2304638 defendant Robert Thomas   781252 781252 Robert, Thomas, of Derby, Derbs, brass worker 1
4827469 2304640 2304640 defendant Brasyer Thomas   781252 781252 Brasyer, Thomas, of Derby, Derbs, brass worker 0
4828438 2304939 2304939 defendant Robert Thomas   781252 781252 Robert, Thomas, of Derby, Derbs, brass worker 0
4829275 2305196 2305196 defendant (not given) Henry prior of Assheburn 781252 781252 Assheburn, Henry, of Derby, Derbs, prior of the house of St James 0
4833027 2306348 2306348 defendant Roberd Thomas   781252 781252 Roberd, Thomas, of Derby, Derbs, brass worker 0
4833203 2306396 2306396 defendant Allesworth John carpenter 781252 781252 Allesworth, John, of Derby, Derbs, carpenter 3
4836873 2307491 2307491 defendant Gerard John (legal representative) 781252 781252 Gerard, John, of Derby, Derbs, chapman, executrix of 3
4840853 2308675 2308675 defendant Nundy Robert chapman 781252 781252 Nundy, Robert, of Derby, Derbs, chapman 0
4853872 2312620 2312620 defendant Robart Thomas   781252 781252 Robart, Thomas, of Derby, Derbs, brass worker 0
4860154 2314539 2314539 defendant Macworth Thomas esq 781252 781252 Macworth, Thomas, of Derbs, esq 1
4865006 2316032 2316032 plaintiff Fynderne William esq 781252 781252 Fynderne, William, of Derbs, esq 0
4909415 2329483 2329483 defendant Bothe John gent 781252 781252 Bothe, John, of Derby, Derbs, gent 0
4910145 2329697 2329697 defendant Bothe John gent 781252 781252 Bothe, John, of Derby, Derbs, gent 0
4912956 2330550 2330550 defendant Bothe John gent 781252 781252 Bothe, John, of Derby, Derbs, gent 0
4918954 2332443 2332443 defendant Bothe John gent 781252 781252 Bothe, John, of Derby, Derbs, gent 0
4922390 2333413 2333413 defendant Bonthe John gent 781252 781252 Bonthe, John, of Derby, Derbs, gent 4
4931787 2336329 2336329 defendant Spenne John yeoman 781252 781252 Spenne, John, of Derby, Derbs, yeoman 1
4967256 2347143 2347143 plaintiff Enturpathe John   781252 781252 Enturpathe, John, of Derbs, mason 0
4989172 2353697 2353697 defendant Porter John   781252 781252 Porter, John, of Derby, Derbs, scythe smith 2
4989531 2353801 2353801 defendant Frere John yeoman 781252 781252 Frere, John, of Derby, Derbs, yeoman 1
5004708 2358282 2358282 defendant Stokkes Thomas gent 781252 781252 Stokkes, Thomas, of Derby, Derbs, gent 0
5004716 2358283 2358283 defendant Stokkys Thomas gent 781252 781252 Stokkys, Thomas, of Derby, Derbs, gent 0
5044531 2369996 2369996 defendant Shepherd John husbandman 781252 781252 Shepherd, John, of Derby, Derbs, husbandman 0
5046665 2370625 2370625 defendant Strelley John yeoman 781252 781252 Strelley, John, of Derby, Derbs, yeoman 0
5046911 2370698 2370698 defendant Heuster Walter heuster 781252 781252 Heuster, Walter, of Derby, Derbs, heuster 0
5047156 2370771 2370771 defendant Cotom John walker 781252 781252 Cotom, John, of Derby, Derbs, walker 0
5049899 2371596 2371596 plaintiff Strelley John yeoman 781252 781252 Strelley, John, of Derby, Derbs, yeoman 0
5134174 2396489 2396489 defendant Wodehouse Thomas husbandman 781252 781252 Wodehouse, Thomas, of Derby, Derbs, husbandman 1
5138693 2397813 2397813 defendant Forest William chapman 781252 781252 Forest, William, of Derby, Derbs, chapman 1
5142271 2398857 2398857 defendant Neweton John chapman 781252 781252 (Neweton, John, of Derby, Derbs, chapman 4
5144158 2399444 2399444 defendant Mody Richard   781252 781252 Mody, Richard, of Derby, Derbs, "armyte" 1
5151159 2401480 2401480 defendant Orme William chapman 781252 781252 Orme, William, of Derby, Derbs, chapman 0
5151313 2401533 2401533 defendant Blande Thomas chapman 781252 781252 Blande, Thomas, of Derby, Derbs, chapman 3
5159142 2403789 2403789 defendant Wharmby Thomas merchant 781252 781252 Wharmby, Thomas, of Derby, Derbs, merchant 0
5159457 2403882 2403882 defendant Forest William chapman 781252 781252 Forest, William, of Derby, Derbs, chapman 1
5159465 2403883 2403883 defendant Forest William chapman 781252 781252 Forest, William, of Derby, Derbs, chapman 1
5163490 2405053 2405053 defendant Bland Thomas chapman 781252 781252 Bland, Thomas, of Derby, Derbs, chapman 0
5163501 2405055 2405055 defendant Neweton John chapman 781252 781252 (Neweton, John, of Derby, Derbs, chapman 4
5163508 2405056 2405056 defendant Neweton John chapman 781252 781252 (Neweton, John, of Derby, Derbs, chapman 4
5164016 2405212 2405212 defendant Loselond Richard chapman 781252 781252 Loselond, Richard, of Derby, Derbs, chapman 4
5165096 2405535 2405535 defendant Mody Richard   781252 781252 Mody, Richard, of Derby, Derbs, armyte 1
5166728 2405992 2405992 defendant Burgh John yeoman 781252 781252 Burgh, John, of Derby, Derbs, yeoman 2
5169494 2406816 2406816 defendant Blande Thomas chapman 781252 781252 Blande, Thomas, of Derby, Derbs, chapman 3
5174380 2408208 2408208 defendant Wharmby Thomas merchant 781252 781252 Wharmby, Thomas, of Derby, Derbs, merchant 0
5174585 2408267 2408267 defendant Forest William chapman 781252 781252 Forest, William, of Derby, Derbs, chapman 1
5178803 2409522 2409522 defendant Mody Richard   781252 781252 Mody, Richard, of Derby, Derbs, armyte 1
5178806 2409523 2409523 defendant Mody Richard   781252 781252 Mody, Richard, of Derby, Derbs, armyte 1
5178809 2409524 2409524 defendant Mody Richard   781252 781252 Mody, Richard, of Derby, Derbs, armyte 1
5186368 2411770 2411770 defendant Bland Thomas chapman 781252 781252 Bland, Thomas, of Derby, Derbs, chapman 3
5186373 2411771 2411771 defendant Blande Thomas chapman 781252 781252 Blande, Thomas, of Derby, Derbs, chapman 3
5188878 2412481 2412481 defendant Quernby Thomas merchant 781252 781252 Quernby, Thomas, of Derby, Derbs, merchant 0
5189313 2412606 2412606 defendant Spycer or Sopycer John chapman 781252 781252 Spycer or Sopycer, John, of Derby, Derbs, chapman 0
5195176 2414332 2414332 defendant Blande Thomas chapman 781252 781252 Blande, Thomas, of Derby, Derbs, chapman 3
5200483 2415900 2415900 defendant Loseland Richard chapman 781252 781252 Loseland, Richard, of Derby, Derbs, chapman 4
5206468 2417624 2417624 defendant Spycer John chapman 781252 781252 Spycer, John, of Derby, Derbs, chapman 0
5206470 2417625 2417625 defendant Spyder John chapman 781252 781252 Spyder, John, of Derby, Derbs, chapman 0
5209141 2418401 2418401 defendant Blande Thomas chapman 781252 781252 Blande, Thomas, of Derby, Derbs, chapman 3
5209225 2418430 2418430 defendant Forest William chapman 781252 781252 Forest, William, of Derby, Derbs, chapman 1
5216694 2420618 2420618 defendant Mille John chaplain 781252 781252 Mille, John, of Derbs, chaplain 2
5257907 2432596 2432596 plaintiff Hunte Thomas   781252 781252 Hunte, Thomas, of Derbs 2
5297360 2444228 2444228 defendant Raulynson Edmund chapman 781252 781252 Raulynson, Edmund, of Derby, Derbs, chapman 0
5306210 2446843 2446843 defendant Hide Sanchia widow 781252 781252 Hide, Sanchia, of Derby, Derbs, widow 2
5309431 2447861 2447861 defendant fitz Herbert Robert gent 781252 781252 (fitz Herbert, Robert, of Derby, Derbs, gent 1
5310691 2448234 2448234 defendant Ralynson Edmund mercer 781252 781252 Ralynson, Edmund, of Derby, Derbs, mercer 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);