names

87 rows where place_id = 603083

✎ 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
3653002 1911269 1911269 defendant Fort Ambrose yeoman 603083 603083 Fort, Ambrose, of Wragby, yeoman 2
3825871 1965940 1965940 defendant Chamber John weaver 603083 603083 Chamber, John, of Wragby, weaver 2
3831150 1967628 1967628 defendant Marshall John butcher 603083 603083 Marshall, John, of Wragby, butcher 0
3831151 1967628 1967628 defendant Tomson John butcher 603083 603083 Tomson, John, of Wragby, butcher 1
3936356 2002481 2002481 defendant Milner William yeoman 603083 603083 Milner, William, of Wragby, yeoman 2
4061240 2046427 2046427 defendant Smith John yeoman 603083 603083 Smith, John, of Wragby, yeoman 0
4068364 2048986 2048986 defendant Wynde William yeoman 603083 603083 Wynde, William, of Wragby, yeoman 0
4134123 2072528 2072528 defendant Sandon Ambrose esq 603083 603083 Sandon, Ambrose, of Wragby, esq 0
4171693 2085565 2085565 defendant Wathey Robert yeoman 603083 603083 Wathey, Robert, of Wragby, yeoman 1
4202068 2096266 2096266 defendant Wynde William yeoman 603083 603083 Wynde, William, of Wragby, yeoman 2
4234692 2107680 2107680 defendant Tooley Francis gent 603083 603083 Tooley, Francis, of Wragby, gent 0
4295244 2128385 2128385 defendant Bradwaye William husbandman 603083 603083 Bradwaye, William, of Wragby, husbandman 0
4349815 2147193 2147193 defendant Marshall Ambrose husbandman 603083 603083 Marshall, Ambrose, of Wragby, husbandman 0
4446259 2183743 2183743 plaintiff Dayvill Ralph   603083 603083 Dayvill, Ralph, of Wragby 0
4446261 2183744 2183744 plaintiff Dayvyll Ralph   603083 603083 Dayvyll, Ralph, of Wragby 0
4454405 2186388 2186388 defendant Draper Richard   603083 603083 Draper, Richard, of Wragby 0
4457385 2187322 2187322 defendant Daynell Rallph   603083 603083 Daynell, Rallph, of Wragby 0
4500919 2200907 2200907 defendant Refam Robert   603083 603083 Refam, Robert, of Wragby 3
4503035 2201517 2201517 defendant Baildon Simon de forester 603083 603083 Baildon, Simon de, of Wragby, forester 0
4516982 2205719 2205719 defendant Joneson Thomas   603083 603083 Joneson, Thomas, of Wragby 0
4518247 2206082 2206082 plaintiff del Skyres Robert   603083 603083 del Skyres, Robert, of Wragby 0
4541944 2213370 2213370 defendant Barbour Thomas   603083 603083 Barbour, Thomas, of Wragby 0
4559739 2219000 2219000 defendant Milner William   603083 603083 Milner, William, of Wragby 0
4566981 2221234 2221234 defendant Croft Richard   603083 603083 Croft, Richard, of Wragby 3
4567012 2221238 2221238 defendant Barbur Thomas   603083 603083 Barbur, Thomas, of Wragby 2
4571353 2222624 2222624 defendant Barbour Thomas   603083 603083 Barbour, Thomas, of Wragby 5
4576311 2224097 2224097 defendant Fool John thatcher or roofer 603083 603083 Fool, John, of Wragby, thatcher or roofer 0
4585581 2226913 2226913 defendant Taillour Richard   603083 603083 Taillour, Richard, of Wragby 0
4596539 2230155 2230155 defendant Forster Simon   603083 603083 Forster, Simon, of Wragby 0
4596540 2230155 2230155 defendant Rudyerd John   603083 603083 Rudyerd, John, of Wragby 1
4657151 2248123 2248123 defendant Roger John   603083 603083 Roger, John, of Wragby 4
4659151 2248734 2248734 defendant Taillour William tailor 603083 603083 Taillour, William, of Wragby, tailor 0
4665341 2250649 2250649 defendant Roger John husbandman 603083 603083 Roger, John, of Wragby, husbandman 4
4669442 2256149 2256149 plaintiff Borell John (legal representative) 603083 603083 Borell, John, of Wragby, executors of 0
4682533 2260160 2260160 defendant Rodyerd John   603083 603083 Rodyerd, John, of Wragby, bailiff 4
4688620 2262004 2262004 defendant Werkeman Richard husbandman 603083 603083 Werkeman, Richard, of Wragby, husbandman 0
4697196 2264604 2264604 plaintiff Clerk Robert   603083 603083 Clerk, Robert, of Wragby 0
4708528 2268035 2268035 defendant Skires Richard merchant 603083 603083 Skires, Richard, of Wragby, merchant 0
4714148 2269756 2269756 defendant Hyndlay Thomas chaplain 603083 603083 Hyndlay, Thomas, of Wragby, chaplain 0
4718556 2271142 2271142 defendant Rogger John yeoman 603083 603083 Rogger, John, of Wragby, yeoman 0
4718607 2271158 2271158 defendant Croft Hugh shoemaker 603083 603083 Croft, Hugh, of Wragby, shoemaker 1
4726444 2273553 2273553 defendant Kynge Thomas barber 603083 603083 Kynge, Thomas, of Wragby, barber 2
4726749 2273635 2273635 defendant Roger John   603083 603083 Roger, John, of Wragby, bailiff 1
4740171 2277641 2277641 defendant Boston John grocer 603083 603083 Boston, John, of Wragby, grocer 0
4740455 2277724 2277724 defendant Rogger John yeoman 603083 603083 Rogger, John, of Wragby, yeoman 0
4773424 2287661 2287661 defendant Rogerd John yeoman 603083 603083 Rogerd, John, of Wragby, yeoman 3
4798736 2295783 2295783 defendant Shirref Robert husbandman 603083 603083 Shirref, Robert, of Wragby, husbandman 0
4798737 2295783 2295783 defendant Wryght John husbandman 603083 603083 Wryght, John, of Wragby, husbandman 1
4799638 2296069 2296069 defendant Roger John husbandman 603083 603083 Roger, John, of Wragby, husbandman 2
4807206 2298455 2298455 defendant Boule Thomas chapman 603083 603083 Boule, Thomas, of Wragby, chapman 2
4822770 2303200 2303200 defendant Boston John yeoman 603083 603083 Boston, John, of Wragby, yeoman 0
4841600 2308908 2308908 defendant Boston John ostler 603083 603083 Boston, John, of Wragby, ostler 0
4848049 2310855 2310855 defendant Cibotson Robert yeoman 603083 603083 Cibotson, Robert, of Wragby, yeoman 2
4882795 2321540 2321540 defendant Boston John   603083 603083 Boston, John, of Wragby, bailiff 5
4890386 2323761 2323761 defendant Hancok John yeoman 603083 603083 (Hancok, John, of Wragby, yeoman 1
4895879 2325377 2325377 defendant Metheley John husbandman 603083 603083 Metheley, John, of Wragby, husbandman 1
4947763 2341287 2341287 defendant Whixley Nicholas gent 603083 603083 Whixley, Nicholas, of Wragby, gent 0
4995348 2355453 2355453 plaintiff Geffrayson David   603083 603083 Geffrayson, David, of Wragby 0
5059441 2374391 2374391 defendant Fewe William butcher 603083 603083 Fewe, William, of Wragby, butcher 1
5081344 2380925 2380925 defendant Jefferon David yeoman 603083 603083 Jefferon, David, of Wragby, yeoman 0
5163902 2405179 2405179 defendant Webster Thomas weaver 603083 603083 Webster, Thomas, of Wragby, weaver 0
5163903 2405179 2405179 defendant Boteler John husbandman 603083 603083 Boteler, John, of Wragby, husbandman 1
5163904 2405179 2405179 defendant Knyghtley John laborer 603083 603083 Knyghtley, John, of Wragby, laborer 2
5217070 2420733 2420733 defendant Gefferson David yeoman 603083 603083 Gefferson, David, of Wragby, yeoman 0
5217072 2420734 2420734 defendant Geffron David yeoman 603083 603083 Geffron, David, of Wragby, yeoman 0
5237652 2426593 2426593 defendant Byrde Robert husbandman 603083 603083 Byrde, Robert, of Wragby, husbandman 0
5240306 2427377 2427377 plaintiff Jeffron David   603083 603083 Jeffron, David, of Wragby 0
5240309 2427377 2427377 defendant Bryde alias Webster Richard husbandman 603083 603083 Bryde alias Webster, Richard, of Wragby, husbandman 2
5247009 2429287 2429287 defendant Chaundeler John yeoman 603083 603083 Chaundeler, John, of Wragby, yeoman 0
5318929 2450753 2450753 defendant Aberford John husbandman 603083 603083 Aberford, John, of Wragby, husbandman 1
5318932 2450754 2450754 defendant Aberford John husbandman 603083 603083 Aberford, John, of Wragby, husbandman 1
5336124 2455883 2455883 defendant Everyngham William chaplain 603083 603083 Everyngham, William, of Wragby, chaplain 1
5338698 2456673 2456673 defendant Miles Thomas shoemaker 603083 603083 Miles, Thomas, of Wragby, shoemaker 5
5338700 2456673 2456673 defendant Chaloner Nicholas yeoman 603083 603083 Chaloner, Nicholas, of Wragby, yeoman 7
5372298 2466930 2466930 defendant Sirguay William yeoman 603083 603083 Sirguay, William, of Wragby, yeoman 2
5478465 2498586 2498586 defendant Baker Robert laborer 603083 603083 Baker, Robert, of Wragby, laborer 0
5486597 2500890 2500890 plaintiff Shepard Richard yeoman 603083 603083 Shepard, Richard, of Wragby, yeoman 0
5486600 2500890 2500890 defendant Clerke John yeoman 603083 603083 Clerke, John, of Wragby, yeoman 2
5489703 2501804 2501804 defendant Sirqua Agnes widow 603083 603083 Sirqua, Agnes, of Wragby, widow 0
5489704 2501804 2501804 defendant Clyfton John clerk 603083 603083 Clyfton, John, of Wragby, clerk 1
5500512 2505092 2505092 defendant Fawset Robert yeoman 603083 603083 Fawset, Robert, of Wragby, yeoman 0
5501058 2505265 2505265 defendant Fauset Robert yeoman 603083 603083 Fauset, Robert, of Wragby, yeoman 0
5522764 2511945 2511945 defendant Bougham John yeoman 603083 603083 Bougham, John, of Wragby, yeoman 3
5528707 2513496 2513496 defendant Bougham John yeoman 603083 603083 Bougham, John, of Wragby, yeoman 0
5540619 2517191 2517191 defendant Boughay John   603083 603083 Boughay, John, of Wragby, Lincs yeoman 4
5616746 2549042 2549042 defendant Methelay Richard de   603083 603083 Methelay, Richard de, of Wragby 0
5619188 2549849 2549849 defendant Dayvill Ralph   603083 603083 Dayvill, Ralph, of Wragby 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);