names

100 rows where place_id = 605208

✎ 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
3660778 1913635 1913635 defendant Eme Thomas smith 605208 605208 Eme, Thomas, of Lymyngton, smith 1
3670754 1916813 1916813 defendant Dey John husbandman 605208 605208 Dey, John, of Lymyngton, husbandman 1
3753962 1943189 1943189 defendant Sybyll John tailor 605208 605208 Sybyll, John, of Lymyngton, tailor 0
3782478 1952263 1952263 defendant Palmer John gent 605208 605208 Palmer, John, of Lymyngton, gent 0
3813480 1962130 1962130 defendant Dykar John (legal representative) 605208 605208 Dykar, John, of Lymyngton, executrix of 0
3813481 1962130 1962130 defendant Dykar Julia widow 605208 605208 Dykar, Julia, of Lymyngton, widow 1
3872406 1980994 1980994 defendant Overton alias Myller Thomas innholder 605208 605208 Overton alias Myller, Thomas, of Lymyngton, innholder 0
3967185 2013149 2013149 defendant Ryppyngton Christopher gent 605208 605208 Ryppyngton, Christopher, of Lymyngton, gent 0
3971513 2014596 2014596 defendant Hunt William merchant 605208 605208 Hunt, William, of Lymyngton, or of Poole, Dorset, merchant 0
3971523 2014601 2014601 defendant Hunt William merchant 605208 605208 Hunt, William, of Lymyngton, or of Poole, Dorset, merchant 0
4023216 2033012 2033012 defendant Tanner Robert carpenter 605208 605208 Tanner, Robert, of Lymyngton, carpenter 0
4023218 2033013 2033013 defendant Tanner Robert carpenter 605208 605208 Tanner, Robert, of Lymyngton, carpenter 0
4087608 2055864 2055864 plaintiff Burrard John butcher 605208 605208 Burrard, John, of Lymyngton, butcher 0
4099985 2060321 2060321 defendant Burrerde Thomas mercer 605208 605208 Burrerde, Thomas, of Lymyngton, mercer 1
4109851 2063782 2063782 defendant Rowe John yeoman 605208 605208 Rowe, John, of Lymyngton, yeoman 1
4109854 2063783 2063783 defendant Rowe John yeoman 605208 605208 Rowe, John, of Lymyngton, yeoman 1
4113275 2065016 2065016 defendant Rowe John yeoman 605208 605208 Rowe, John, of Lymyngton, yeoman 0
4122195 2068242 2068242 defendant Ellyott William mercer 605208 605208 Ellyott, William, of Lymyngton, or of Cranbourn, Dorset, mercer 0
4130169 2071098 2071098 defendant Hopkyns Walter yeoman 605208 605208 Hopkyns, Walter, of Lymyngton, yeoman 0
4143952 2076048 2076048 defendant Wilshere Edmund merchant 605208 605208 Wilshere, Edmund, of Lymyngton, merchant 1
4143953 2076048 2076048 defendant Beake William merchant 605208 605208 Beake, William, of Lymyngton, merchant 2
4143954 2076048 2076048 defendant Woodroffe Henry merchant 605208 605208 Woodroffe, Henry, of Lymyngton, merchant 3
4168452 2084452 2084452 defendant Busshell Thomas innholder 605208 605208 Busshell, Thomas, of Lymyngton, innholder 1
4168453 2084452 2084452 defendant Hunte William merchant 605208 605208 Hunte, William, of Lymyngton, merchant 2
4168461 2084454 2084454 defendant Lasky John merchant 605208 605208 Lasky, John, of Lymyngton, merchant 1
4177865 2087731 2087731 defendant Easton John, junior husbandman 605208 605208 Easton, John, junior, of Lymyngton, husbandman 0
4179575 2088332 2088332 defendant Hunt Elizabeth widow 605208 605208 Hunt, Elizabeth, of Lymyngton, or of Chiltron Dommer, widow 0
4179576 2088332 2088332 defendant Hunt James husbandman 605208 605208 Hunt, James, of Lymyngton, husbandman 1
4182719 2089435 2089435 defendant Keylewaye Henry gent 605208 605208 Keylewaye, Henry, of Lymyngton, gent 1
4189339 2091768 2091768 defendant Brownynge John husbandman 605208 605208 Brownynge, John, of Lymyngton, husbandman 0
4197369 2094634 2094634 defendant Jenkyns Henry vintner 605208 605208 Jenkyns, Henry, of Lymyngton, vintner 0
4197370 2094634 2094634 defendant Laske John mariner 605208 605208 Laske, John, of Lymyngton, mariner 1
4197371 2094634 2094634 defendant Hunte William merchant 605208 605208 Hunte, William, of Lymyngton, merchant 2
4198700 2095104 2095104 defendant Clare John glover 605208 605208 Clare, John, of Lymyngton, glover 1
4206328 2097759 2097759 defendant Kellwaye Henry gent 605208 605208 Kellwaye, Henry, of Lymyngton, gent 1
4223092 2103566 2103566 defendant Staple Richard husbandman 605208 605208 Staple, Richard, of Lymyngton, husbandman 0
4234932 2107768 2107768 defendant Clare John yeoman 605208 605208 Clare, John, of Lymyngton, yeoman 2
4275597 2121409 2121409 defendant Levett Richard butcher 605208 605208 Levett, Richard, of Lymyngton, butcher 0
4279495 2122749 2122749 defendant Sybbell John butcher 605208 605208 Sybbell, John, of Lymyngton, butcher 0
4279496 2122749 2122749 defendant Dore Thomas husbandman 605208 605208 Dore, Thomas, of Lymyngton, husbandman 1
4279497 2122749 2122749 defendant Osgood Henry husbandman 605208 605208 Osgood, Henry, of Lymyngton, husbandman 2
4281908 2123575 2123575 defendant Bedham Thomas gent 605208 605208 Bedham, Thomas, of Lymyngton, gent 0
4285790 2124971 2124971 defendant Chappell Bartholomew husbandman 605208 605208 Chappell, Bartholomew, of Lymyngton, husbandman 0
4285792 2124972 2124972 defendant Hall Christopher husbandman 605208 605208 Hall, Christopher, of Lymyngton, husbandman 0
4294933 2128273 2128273 defendant Castell John yeoman 605208 605208 Castell, John, of Lymyngton, yeoman 0
4307325 2132701 2132701 defendant Agarde Roger husbandman 605208 605208 Agarde, Roger, of Lymyngton, husbandman 0
4311503 2134165 2134165 defendant Hunt William merchant 605208 605208 Hunt, William, of Lymyngton, merchant 0
4313967 2134991 2134991 defendant Garde Robert husbandman 605208 605208 Garde, Robert, of Lymyngton, husbandman 0
4313968 2134991 2134991 defendant Pope John husbandman 605208 605208 Pope, John, of Lymyngton, husbandman 1
4318458 2136567 2136567 defendant Tubervile Thomas gent 605208 605208 Tubervile, Thomas, of Lymyngton, gent 0
4318459 2136567 2136567 defendant Dowe Edmund yeoman 605208 605208 Dowe, Edmund, of Lymyngton, yeoman 1
4321876 2137736 2137736 defendant Dove Edmund yeoman 605208 605208 Dove, Edmund, of Lymyngton, yeoman 1
4336211 2142396 2142396 defendant Laskey John merchant 605208 605208 Laskey, John, of Lymyngton, merchant 0
4343568 2145029 2145029 defendant Looder George husbandman 605208 605208 Looder, George, of Lymyngton, husbandman 0
4343570 2145030 2145030 defendant Gast John blacksmith 605208 605208 Gast, John, of Lymyngton, blacksmith 0
4350970 2147594 2147594 defendant East John blacksmith 605208 605208 East, John, of Lymyngton, blacksmith 0
4358909 2150352 2150352 defendant Levett Richard butcher 605208 605208 Levett, Richard, of Lymyngton, butcher 0
4358910 2150352 2150352 defendant Bunch John yeoman 605208 605208 Bunch, John, of Lymyngton, yeoman 1
4362141 2151505 2151505 defendant Levett Richard butcher 605208 605208 Levett, Richard, of Lymyngton, butcher 0
4365187 2152605 2152605 defendant Levett Richard butcher 605208 605208 Levett, Richard, of Lymyngton, butcher 1
4372059 2155070 2155070 defendant Blake David smith 605208 605208 Blake, David, of Lymyngton, smith 0
4372060 2155070 2155070 defendant Levett Richard butcher 605208 605208 Levett, Richard, of Lymyngton, butcher 1
4372061 2155070 2155070 defendant Bunch John tanner 605208 605208 Bunch, John, of Lymyngton, tanner 2
4374215 2155850 2155850 defendant Sybell John butcher 605208 605208 Sybell, John, of Lymyngton, butcher 0
4380823 2158257 2158257 defendant Castell John innholder 605208 605208 Castell, John, of Lymyngton, innholder 0
4380849 2158267 2158267 defendant Burrard John yeoman 605208 605208 Burrard, John, of Lymyngton, yeoman 0
4382983 2159022 2159022 defendant Bunche John tanner 605208 605208 Bunche, John, of Lymyngton, tanner 0
4382984 2159022 2159022 defendant Levett Richard butcher 605208 605208 Levett, Richard, of Lymyngton, butcher 1
4434894 2175672 2175672 plaintiff Molyns Richard   605208 605208 Molyns, Richard, of Lymyngton, parson 2
4438535 2181341 2181341 defendant Norman John   605208 605208 Norman, John, of Lymyngton 0
4502734 2201433 2201433 defendant Baker Stephen   605208 605208 Baker, Stephen, of Lymyngton 0
4519351 2206412 2206412 defendant Coute John   605208 605208 Coute, John, of Lymyngton 0
4529082 2209370 2209370 plaintiff Mey John   605208 605208 Mey, John, of Lymyngton 0
4529084 2209371 2209371 plaintiff Mey John   605208 605208 Mey, John, of Lymyngton 0
4545724 2214590 2214590 defendant Cokkys John   605208 605208 Cokkys, John, of Lymyngton 0
4591185 2228601 2228601 plaintiff Meyr John   605208 605208 Meyr, John, of Lymyngton 0
4594706 2229598 2229598 defendant Coppe Philip   605208 605208 Coppe, Philip, of Lymyngton 1
4616288 2236085 2236085 defendant Coppe John   605208 605208 Coppe, John, of Lymyngton 0
4658196 2248442 2248442 defendant Morehay John clerk 605208 605208 Morehay, John, of Lymyngton, clerk 0
4665751 2250762 2250762 defendant Porter Isabel widow 605208 605208 Porter, Isabel, of Lymyngton, widow 3
4686276 2261310 2261310 defendant Fever John merchant 605208 605208 Fever, John, of Lymyngton, merchant 1
4772098 2287250 2287250 defendant Knolle Alexander husbandman 605208 605208 Knolle, Alexander, of Lymyngton, husbandman 0
4772099 2287250 2287250 defendant Marcheys Isabel widow 605208 605208 Marcheys, Isabel, of Lymyngton, widow 1
4772101 2287250 2287250 defendant Mulward Adam   605208 605208 Mulward, Adam, of Lymyngton, husb 3
4772107 2287250 2287250 defendant White William   605208 605208 White, William, of Lymyngton, husb 9
4784554 2291175 2291175 defendant Baker John mariner 605208 605208 Baker, John, of Lymyngton, mariner 0
4829438 2305249 2305249 defendant Baker John husbandman 605208 605208 Baker, John, of Lymyngton, husbandman 0
4829446 2305252 2305252 defendant Pay Thomas   605208 605208 Pay, Thomas, of Lymyngton 0
4865247 2316103 2316103 defendant Lane John draper 605208 605208 Lane, John, of Lymyngton, draper 0
4882821 2321547 2321547 defendant Fowy John clerk 605208 605208 Fowy, John, of Lymyngton, clerk 3
4900157 2326674 2326674 defendant Grynder Nicholas salter 605208 605208 Grynder, Nicholas, of Lymyngton, salter 0
4919664 2332656 2332656 defendant Graunger John weaver 605208 605208 Graunger, John, of Lymyngton, weaver 0
5087855 2382828 2382828 defendant Dirdo John butcher 605208 605208 Dirdo, John, of Lymyngton, butcher 2
5228777 2424028 2424028 defendant Wiltesshire Nicholas mercer 605208 605208 Wiltesshire, Nicholas, of Lymyngton, mercer 0
5308108 2447450 2447450 defendant Oglond Robert (legal representative) 605208 605208 Oglond, Robert, of Lymyngton, gent, executrix of 0
5330431 2454180 2454180 defendant Oglander Joan widow 605208 605208 Oglander, Joan, of Lymyngton, widow 2
5340608 2457264 2457264 defendant Mewys Ralph yeoman 605208 605208 Mewys, Ralph, of Lymyngton, yeoman 0
5501076 2505272 2505272 defendant Holcombe Stephen (legal representative) 605208 605208 Holcombe, Stephen, of Lymyngton, or of Marchewode, gent, executor of 0
5530281 2513980 2513980 defendant Boreot William butcher 605208 605208 Boreot, William, of Lymyngton, butcher 0
5624203 2551516 2551516 defendant Bakere John hosteler 605208 605208 Bakere, John, of Lymyngton, hosteler 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);