names

62 rows where place_id = 594021

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614182 1872101 1872101 defendant Tracy John innholder 594021 594021 Tracy, John, of Yevell, Soms, innholder 0
3637561 1906558 1906558 defendant Toker William mercer 594021 594021 Toker, William, of Yevell, Soms, mercer 0
3807377 1960214 1960214 defendant Everett Robert merchant 594021 594021 Everett, Robert, of Yevell, Soms, merchant 2
4190731 2092321 2092321 defendant Well Andrew chapman 594021 594021 Well, Andrew, of Yevell, Soms, chapman 0
4197632 2094727 2094727 defendant Lewcock Richard chapman 594021 594021 Lewcock, Richard, of Yevell, Soms, chapman 1
4200065 2095573 2095573 defendant Jacobbe Valentine yeoman 594021 594021 Jacobbe, Valentine, of Yevell, Soms, yeoman 0
4207240 2098081 2098081 defendant Lucocke Richard tailor 594021 594021 Lucocke, Richard, of Yevell, Soms, tailor 0
4240100 2109662 2109662 defendant Styckland Roger husbandman 594021 594021 Styckland, Roger, of Yevell, Soms, husbandman 1
4286573 2125242 2125242 defendant Chaplyn Henry tailor 594021 594021 Chaplyn, Henry, of Yevell, Soms, tailor 0
4336169 2142382 2142382 defendant Phelps John chapman 594021 594021 Phelps, John, of Yevell, Soms, chapman 0
4385129 2159714 2159714 defendant Phelpes John   594021 594021 Phelpes, John, of Yevell, Soms, linen draper 0
4516869 2205679 2205679 defendant Bedeman John   594021 594021 Bedeman, John, of Yevell, Soms 2
4678540 2258895 2258895 defendant Gobet John tanner 594021 594021 Gobet, John, of Yevell, Soms, tanner 0
4688306 2261911 2261911 defendant Brydde Richard shoemaker 594021 594021 Brydde, Richard, of Yevell, Soms, shoemaker 0
4730408 2274707 2274707 defendant Geffrey John chapman 594021 594021 Geffrey, John, of Yevell, Soms, chapman 2
4732225 2275258 2275258 defendant Wyseman Geoffrey husbandman 594021 594021 Wyseman, Geoffrey, of Yevell, Soms, husbandman 0
4732878 2275459 2275459 defendant Bavent Robert gent 594021 594021 Bavent, Robert, of Yevell, Soms, gent 0
4732880 2275460 2275460 defendant Bavent Robert gent 594021 594021 Bavent, Robert, of Yevell, Soms, gent 0
4739425 2277415 2277415 defendant Chapman John ostler 594021 594021 Chapman, John, of Yevell, Soms, ostler 2
4793497 2294074 2294074 defendant Lane John smith 594021 594021 Lane, John, of Yevell, Soms, smith 2
4874884 2319087 2319087 defendant Manston Ralph yeoman 594021 594021 (Manston, Ralph, of Yevell, Soms, yeoman 1
4882859 2321557 2321557 defendant Wyseman Geoffrey hosteler 594021 594021 Wyseman, Geoffrey, of Yevell, Soms, hosteler 0
4890284 2323731 2323731 defendant Wyseman Geoffrey hosteler 594021 594021 Wyseman, Geoffrey, of Yevell, Soms, hosteler 0
4919020 2332460 2332460 defendant Harnyst John skinner 594021 594021 Harnyst, John, of Yevell, Soms, skinner 4
4923755 2333871 2333871 defendant Bathe John tanner 594021 594021 Bathe, John, of Yevell, Soms, tanner 2
4937684 2338162 2338162 defendant Penvoll John merchant 594021 594021 Penvoll, John, of Yevell, Soms, merchant 2
4957637 2344257 2344257 defendant Hillyng Thomas mercer 594021 594021 Hillyng, Thomas, of Yevell, Soms, mercer 1
4969237 2347759 2347759 defendant Bestone Thomas draper 594021 594021 Bestone, Thomas, of Yevell, Soms, draper 1
4969242 2347760 2347760 defendant Beston Thomas draper 594021 594021 Beston, Thomas, of Yevell, Soms, draper 1
4979983 2350968 2350968 defendant Fraunceys Thomas smith 594021 594021 Fraunceys, Thomas, of Yevell, Soms, smith 0
4995528 2355502 2355502 defendant Chafy John ostler 594021 594021 Chafy, John, of Yevell, Soms, ostler 3
5055064 2373084 2373084 defendant Dyer alias Wode Robert dyer 594021 594021 Dyer alias Wode, Robert, of Yevell, Soms, dyer 0
5114899 2390771 2390771 defendant Carpenter John esq 594021 594021 Carpenter, John, of Yevell, Soms, esq 0
5128074 2394684 2394684 defendant Aysshecombe Robert weaver 594021 594021 Aysshecombe, Robert, of Yevell, Soms, weaver 1
5144010 2399395 2399395 defendant James Henry   594021 594021 James, Henry, of Yevell, Soms, glove maker 0
5147156 2400305 2400305 defendant Aysshecombe Robert weaver 594021 594021 Aysshecombe, Robert, of Yevell, Soms, weaver 0
5157498 2403325 2403325 defendant Spencer John gent 594021 594021 Spencer, John, of Yevell, Soms, gent 0
5165025 2405511 2405511 defendant James Henry   594021 594021 James, Henry, of Yevell, Soms, glove maker 0
5173386 2407923 2407923 defendant Spencer john gent 594021 594021 Spencer, john, of Yevell, Soms, gent 0
5189138 2412555 2412555 defendant Bescombe Thomas merchant 594021 594021 Bescombe, Thomas, of Yevell, Soms, merchant 0
5206389 2417603 2417603 defendant Bescombe Thomas merchant 594021 594021 Bescombe, Thomas, of Yevell, Soms, merchant 0
5213358 2419638 2419638 defendant Bathe Thomas husbandman 594021 594021 Bathe, Thomas, of Yevell, Soms, husbandman 0
5215599 2420285 2420285 defendant Clayson Arnold hardwareman 594021 594021 Clayson, Arnold, of Yevell, Soms, hardwareman 4
5229803 2424338 2424338 defendant Bene John mercer 594021 594021 Bene, John, of Yevell, Soms, mercer 0
5240573 2427456 2427456 defendant Bestcome John chapman 594021 594021 Bestcome, John, of Yevell, Soms, chapman 0
5249648 2430016 2430016 defendant Bathe Walter chaplain 594021 594021 Bathe, Walter, of Yevell, Soms, chaplain 0
5257535 2432476 2432476 defendant Harold John merchant 594021 594021 Harold, John, of Yevell, Soms, merchant 3
5281260 2439595 2439595 defendant Clayson Arnold hardwareman 594021 594021 Clayson, Arnold, of Yevell, Soms, hardwareman 2
5344936 2458576 2458576 defendant Bescombe John merchant 594021 594021 Bescombe, John, of Yevell, Soms, merchant 0
5350094 2460154 2460154 defendant Hewet Giles glasier 594021 594021 Hewet, Giles, of Yevell, Soms, glasier 0
5350096 2460155 2460155 defendant Hewet Giles glasier 594021 594021 Hewet, Giles, of Yevell, Soms, glasier 0
5356304 2462046 2462046 defendant Huet Giles glasier 594021 594021 Huet, Giles, of Yevell, Soms, glasier 2
5383875 2470474 2470474 defendant Moreyn Thomas, senior weaver 594021 594021 (Moreyn, Thomas, senior, of Yevell, Soms, weaver 3
5405667 2476696 2476696 defendant Fort Thomas clerk 594021 594021 Fort, Thomas, of Yevell, Soms, clerk 0
5423289 2481927 2481927 defendant Tracye John gent 594021 594021 Tracye, John, of Yevell, Soms, gent 0
5437039 2486017 2486017 defendant Bacheler John yeoman 594021 594021 Bacheler, John, of Yevell, Soms, yeoman 0
5444996 2488389 2488389 defendant Chan Joan widow 594021 594021 Chan, Joan, of Yevell, Soms, widow 3
5463558 2494017 2494017 defendant Bacheler John yeoman 594021 594021 Bacheler, John, of Yevell, Soms, yeoman 0
5490452 2502039 2502039 defendant Tracy John yeoman 594021 594021 Tracy, John, of Yevell, Soms, yeoman 1
5497135 2504081 2504081 defendant Chapman Thomas yeoman 594021 594021 Chapman, Thomas, of Yevell, Soms, yeoman 0
5498225 2504425 2504425 defendant Garnard John clothmaker 594021 594021 Garnard, John, of Yevell, Soms, clothmaker 0
5545938 2518804 2518804 defendant Bremore John merchant 594021 594021 Bremore, John, of Yevell, Soms, merchant 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);